science 이 제품 또는 기능은 미리보기 (GA 이전) 버전입니다. GA 이전 제품과 기능은 지원이 제한될 수 있으며, GA 이전 제품과 기능이 변경된 경우 다른 GA 이전 버전과 호환되지 않을 수 있습니다. GA 이전 버전 제품 및 서비스에는 Google Maps Platform 서비스별 약관이 적용됩니다. 자세한 내용은 출시 단계 설명을 참조하세요. 가입하여 장소 통계를 테스트해 보세요.
SELECTWITHAGGREGATION_THRESHOLDbrands.name,COUNT(*)ASstore_countFROMplaces_insights___us___sample.places_sampleplaces,UNNEST(brand_ids)ASbrand_idLEFTJOINplaces_insights___us___sample.brandsONbrand_id=brands.idWHEREbrands.category="Food and Drink"AND"cafe"INUNNEST(places.types)ANDbusiness_status="OPERATIONAL"GROUPBYbrands.nameORDERBYstore_countDESC;
[null,null,["최종 업데이트: 2025-07-17(UTC)"],[],[],null,["| **Note:** For the Preview release, the brands dataset is only available for New York City in the United States.\n\nPlaces Insights provides brand information for many categories of places. For\nexample:\n\n- For the category of \"ATMs, Banks, and Credit Unions\", the brands data contains an entry for each of the brands PNC, UBS, and Chase banks.\n- For the category \"Automotive Rentals\", the data contains an entry for each of the brands Budget, Hertz, and Thrifty.\n\nA typical use case for querying the brands dataset is to join it with a query on\nthe place data to answer questions such as:\n\n- What is the count of all stores by brand in an area?\n- What is the count of my top three competitor brands in the area?\n- What is the count of brands of a specific category, such as \"Fitness\" or \"Gas Station\", in the area?\n\nAbout the brands dataset\n\nThe brands dataset for the US is named `places_insights___us___sample.brands`.\n\nBrands dataset schema\n\nThe schema for the brands dataset defines three fields:\n\n- `id`: The brand ID.\n- `name`: The brand name, such as \"Hertz\" or \"Chase\".\n- `category`: The brand type, such as \"Gas Station\", \"Food and Drink\", or \"Lodging\". For a list of possible values, see [Category\n values](#category-values)\n\nUse brands dataset in a query\n\nThe **places dataset** schema defines the `brand_ids` field. If a place in the\nplaces dataset is associated with a brand, then the `brand_ids` field for the\nplace contains the corresponding brand ID.\n\nA typical query that references the **brands dataset** performs a `JOIN` with\nthe **places dataset** based on the `brand_ids` field.\n\nFor example, to find the count of the number of McDonald's restaurants within\n2000 meters of the Empire State Building in New York City: \n\n```googlesql\nSELECT WITH AGGREGATION_THRESHOLD\n COUNT(*)\nFROM places_insights___us___sample.places_sample places, UNNEST(brand_ids) AS brand_id\nLEFT JOIN places_insights___us___sample.brands ON brand_id = brands.id\nWHERE\nST_DWITHIN(ST_GEOGPOINT(-73.9857, 40.7484), point, 2000)\nAND brands.name = \"McDonald's\"\nAND business_status = \"OPERATIONAL\"\n```\n\nThe next query returns the count of the number of cafes in New York City that\nbelong to a brand, grouped by brand name: \n\n```googlesql\nSELECT WITH AGGREGATION_THRESHOLD\n brands.name,\n COUNT(*) AS store_count\nFROM places_insights___us___sample.places_sample places, UNNEST(brand_ids) AS brand_id\nLEFT JOIN places_insights___us___sample.brands ON brand_id = brands.id\nWHERE brands.category = \"Food and Drink\"\nAND \"cafe\" IN UNNEST(places.types)\nAND business_status = \"OPERATIONAL\"\nGROUP BY brands.name\nORDER BY store_count DESC;\n```\n\nThe following image shows the counts by brand:\n\nCategory values\n\nThe `category` field for a brand can contain the following values:\n\n| Category type value |\n|--------------------------------------|\n| `ATMs, Banks and Credit Unions` |\n| `Automotive and Parts Dealers` |\n| `Automotive Rentals` |\n| `Automotive Services` |\n| `Dental` |\n| `Electric Vehicle Charging Stations` |\n| `Electronics Retailers` |\n| `Fitness` |\n| `Food and Drink` |\n| `Gas Station` |\n| `Grocery and Liquor` |\n| `Health and Personal Care Retailers` |\n| `Hospital` |\n| `Lodging` |\n| `Merchandise Retail` |\n| `Movie Theater` |\n| `Parking` |\n| `Telecommunications` |"]]
