TouringApp タグアーキテクチャ設計書

// spot_extraction_schema.json
{
  "type": "object",
  "properties": {
    "spots": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "name": {
            "type": "string",
            "description": "Google Mapsで検索可能な正式名称"
          },
          "category": {
            "type": "string",
            "enum": ["scenery", "food", "onsen", "shrine",
                    "castle", "museum", "park", "road",
                    "rest_area", "camp", "beach",
                    "activity", "shopping"]
          },
          "prefecture": {
            "type": "string",
            "description": "都道府県名（例: 東京都、神奈川県）"
          },
          "description": {
            "type": "string",
            "description": "スポットの魅力（動画の感想ベース、1〜2文）"
          },
          "tags": {
            "type": "array",
            "items": { "type": "string" },
            "description": "体験タグ（絶景,映え,秘境,穴場,定番,ご当地グルメ,海鮮,ワインディング等）"
          },
          "season": {
            "type": "string",
            "enum": ["spring", "summer", "autumn", "winter", "all"]
          },
          "ridingDifficulty": {
            "type": "string",
            "enum": ["beginner", "intermediate", "advanced"]
          },
          "youtuberRating": {
            "type": "string",
            "enum": ["highly_recommended", "recommended", "mentioned"]
          },
          "mentionedAtSec": {
            "type": "integer"
          },
          "suitableFor": {
            "type": "array",
            "items": {
              "type": "string",
              "enum": ["solo", "couple", "group", "family"]
            },
            "description": "このスポットに適した訪問スタイル"
          }
        },
        "required": ["name", "category", "prefecture",
                    "description", "tags", "season",
                    "ridingDifficulty", "youtuberRating",
                    "mentionedAtSec", "suitableFor"],
        "additionalProperties": false
      }
    }
  },
  "required": ["spots"],
  "additionalProperties": false
}

# spot_service.py に追加
def calculate_completeness(spot_data: dict) -> float:
    score = 0.0
    weights = {
        "name": 0.10,
        "category": 0.05,
        "prefecture": 0.05,
        "description": 0.10,
        "tags": 0.10,         # len >= 1 で加算
        "latitude": 0.15,     # 位置情報は重要
        "longitude": 0.15,
        "rating": 0.10,
        "facilities": 0.05,
        "parking": 0.05,
        "visitCount": 0.05,   # > 0 で加算
        "favoriteCount": 0.05,
    }
    for field, weight in weights.items():
        value = spot_data.get(field)
        if value is not None:
            if isinstance(value, list) and len(value) > 0:
                score += weight
            elif isinstance(value, (int, float)) and value > 0:
                score += weight
            elif isinstance(value, str) and value:
                score += weight
            elif isinstance(value, dict):
                score += weight
    return round(score, 2)

# 既存データの category 変換（1回実行のバッチ）
def migrate_categories():
    spots = db.collection("touring_spots").stream()
    for doc in spots:
        data = doc.to_dict()
        old_cat = data.get("category")
        new_cat = old_cat  # デフォルトはそのまま

        if old_cat == "rest":
            name = data.get("name", "")
            if "温泉" in name or "湯" in name:
                new_cat = "onsen"
            else:
                new_cat = "rest_area"

        elif old_cat == "shrine":
            name = data.get("name", "")
            if "城" in name or "史跡" in name or "遺跡" in name:
                new_cat = "castle"

        if new_cat != old_cat:
            doc.reference.update({"category": new_cat})