Placekey/FOURSQUARE_OPEN_SOURCE_PLACES_x_OVERTURE_INNER_JOIN

该数据集是Overture和Foursquare Open Source Places两个地理空间数据集的内连接结果，连接时间为2024年11月。Foursquare Open Source Places数据集贡献了geometry、confidence、version等字段的新增值，而Overture Places数据集则贡献了name、fsq_place_id、date_created等字段的新增值。连接结果显示，共有7,868,660个Placekeys匹配成功，Foursquare Open Source Places数据集总共有103,413,964个Placekeys，Overture数据集总共有42,084,985个Placekeys。

This dataset is the result of an inner join between the Foursquare Open Source Places and Overture Places datasets. After the join, Foursquare Open Source Places added 7,868,660 new values to multiple fields such as geometry, confidence, version, sources, bbox, id, names, addresses, categories, phones, socials, websites, brand, etc. Overture Places also added corresponding new values to fields such as name, fsq_place_id, date_created, date_refreshed, longitude, latitude, fsq_category_ids, fsq_category_labels, tel, website, email, admin_region, facebook_id, date_closed, twitter, post_town, instagram, po_box, etc. The total number of matched Placekeys after the join is 7,868,660, with a total of 103,413,964 Placekeys from Foursquare Open Source Places and 42,084,985 Placekeys from Overture.