yelp api data

[masayuki14]

Yelpの新旧データを比較

[masayuki14]

新データ

        yelp_id         | yelp_name_en_us |  yelp_latitude   |  yelp_longitude
------------------------+-----------------+------------------+------------------
 r6IN1APYvYBYN0oT6dDldQ | Miyoshi         | 34.9727751248    | 135.690635606
 2TvSYTEPFyJPYircJiv8pQ | Miyoshi         | 35.0077610071    | 135.743947211
 FpznHJ0FWIjJoi-4M2PoKA | Miyoshi         | 35.0029209169    | 135.775639321
 0Gn8ZlvB8IqDloUNmGqzfw | Miyoshi         | 35.0086401581569 | 135.770567667523

旧データ

    yelp_id    | yelp_name_en_us | yelp_latitude | yelp_longitude
---------------+-----------------+---------------+----------------
 みよし-京都市 | Miyoshi         |    35.0086402 |    135.7705677
 三芳-京都市   | Miyoshi         |    35.0029209 |    135.7756393

[masayuki14]

旧 yelp_id でAPIを叩いてみる。

$ curl -H 'Authorization: Bearer <API_KEY>' 'https://api.yelp.com/v3/businesses/みよし-京都市'

{
  "id": "0Gn8ZlvB8IqDloUNmGqzfw",
  "alias": "みよし-京都市",
  "name": "Miyoshi",
  "image_url": "https://s3-media4.fl.yelpcdn.com/bphoto/4tTrfn57vuvV7omfyct_zw/o.jpg",
  "is_claimed": false,
  "is_closed": false,
  "url": "https://www.yelp.com/biz/%E3%81%BF%E3%82%88%E3%81%97-%E4%BA%AC%E9%83%BD%E5%B8%82?adjust_creative=xclYgHw-wivVRQss_OChNA&utm_campaign=yelp_api_v3&utm_m
edium=api_v3_business_lookup&utm_source=xclYgHw-wivVRQss_OChNA",
  "phone": "+81752118814",
  "display_phone": "+81 75-211-8814",
  "review_count": 23,
  "categories": [
    {
      "alias": "ramen",
      "title": "Ramen"
    }
  ],
  "rating": 4,
  "location": {
    "address1": "中京区木屋町通三条下る石屋町116",
    "address2": null,
    "address3": null,
    "city": "Kyoto",
    "zip_code": "604-8002",
    "country": "JP",
    "state": "26",
    "display_address": [
      "中京区木屋町通三条下る石屋町116",
      "Kyoto, 京都府 〒604-8002",
      "Japan"
    ],
    "cross_streets": ""
  },
  "coordinates": {
    "latitude": 35.0086401581569,
    "longitude": 135.770567667523
  },

[masayuki14]

$ curl -H 'Authorization: Bearer <API_KEY>' 'https://api.yelp.com/v3/businesses/三芳-京都市'

{
  "id": "FpznHJ0FWIjJoi-4M2PoKA",
  "alias": "三芳-京都市",
  "name": "Miyoshi",
  "image_url": "https://s3-media2.fl.yelpcdn.com/bphoto/PhUDfgHEVvUZHbhpdEB6UA/o.jpg",
  "is_claimed": false,
  "is_closed": false,
  "url": "https://www.yelp.com/biz/%E4%B8%89%E8%8A%B3-%E4%BA%AC%E9%83%BD%E5%B8%82?adjust_creative=xclYgHw-wivVRQss_OChNA&utm_campaign=yelp_api_v3&utm_medium=api
_v3_business_lookup&utm_source=xclYgHw-wivVRQss_OChNA",
  "phone": "+81755612508",
  "display_phone": "+81 75-561-2508",
  "review_count": 3,
  "categories": [
    {
      "alias": "kaiseki",
      "title": "Kaiseki"
    }
  ],
  "rating": 4.5,
  "location": {
    "address1": "東山区祇園町南側570-15",
    "address2": null,
    "address3": null,
    "city": "Kyoto",
    "zip_code": "605-0074",
    "country": "JP",
    "state": "26",
    "display_address": [
      "東山区祇園町南側570-15",
      "Kyoto, 京都府 〒605-0074",
      "Japan"
    ],
    "cross_streets": ""
  },
  "coordinates": {
    "latitude": 35.0029209169,
    "longitude": 135.775639321
  },

[masayuki14]

旧IDは、新IDでは alias として機能している。

[masayuki14]

ちなみにほかの Miyoshi は

{
  "id": "2TvSYTEPFyJPYircJiv8pQ",
  "alias": "みよ志-中京区",
  "name": "Miyoshi",

{
  "id": "r6IN1APYvYBYN0oT6dDldQ",
  "alias": "三好-京都市",
  "name": "Miyoshi",