The new Foursquare Places dataset combines the best of Factual's data collection methods with Foursquare's user generated content. Below is a schema mapping to assist migrating from a Legacy Factual Places dataset. Please note that all Legacy Factual Extended attributes are being deprecated, but many individual attributes are carried over in new Extended Attribute Packages. These are available to be licensed in addition to the Core attributes and include: Ratings, Hours & Social Media (RHSM); Tips & Tastes; Best Photos; Calculated Scores; and Tags.
To use this guide, please refer to the Legacy Factual Attribute column to look up the replacement attribute in the New Foursquare Places Attribute column. If an attribute has a blank row ( "-" ) then it has been deprecated. For more information about a specific Foursquare Places Attribute, please refer to our Schema Documentation. Several replacement attributes consist of either a Data Type Change, and/or a Format Change. Please use the table below to check for these circumstances and refer to the Legacy Factual Data Migration Guide where details of the changes will be organized by Attribute Package for easy reference.
Legacy Factual Attribute | New Foursquare Places Attribute | New Attribute Package | Data Type Changed | Format Changed |
---|
factual_id * | - | - | - | - |
name | name | Core | No | No |
address | address | Core | No | No |
address_extended | address_extended | Core | No | No |
po_box | po_box | Core | No | No |
locality | locality | Core | No | No |
region | region | Core | No | No |
post_town | post_town | Core | No | No |
admin_region | admin_region | Core | No | No |
postcode | postcode | Core | No | No |
country | country | Core | No | No |
tel | tel | RHSM | No | No |
fax | fax | RHSM | No | No |
latitude | latitude | Core | No | No |
longitude | longitude | Core | No | No |
neighborhood | neighborhood | Core | No | No |
website | website | RHSM | No | No |
email | email | RHSM | No | No |
category_ids * | fsq_category_ids | Core | No | Yes |
category_labels * | fsq_category_labels | Core | No | Yes |
chain_name * | fsq_chain_name | Core | Yes | Yes |
chain_id * | fsq_chain_id | Core | Yes | Yes |
hours | hours | RHSM | No | No |
hours_display | hours_display | RHSM | No | No |
existence * | closed_bucket and/or venue_reality_bucket | Caclulated Scores | Yes | Yes |
* These legacy attributes will be included in the first several flat file deliveries appended to the end of the column order to assist in migration.
Legacy Factual Attribute | Integrated Places Attribute | Attribute Package | DataType Changed | Format Changed |
---|
cuisine | - | - | - | - |
price | price | RHSM | Yes | Yes |
rating | rating | RHSM | Yes | Yes |
payment_cashonly | takescreditcards | Tags | No | Yes |
reservations | reservations | Tags | No | No |
open_24hrs | - | - | - | - |
founded | - | - | - | - |
attire | - | - | - | - |
attire_required | - | - | - | - |
attire_prohibited | - | - | - | - |
parking | hasparking | Tags | No | No |
parking_valet | valetparking | Tags | No | No |
parking_garage | - | - | - | - |
parking_street | streetparking | Tags | No | No |
parking_lot | publiclot | Tags | No | No |
parking_validated | - | - | - | - |
parking_free | - | - | - | - |
smoking | smoking | Tags | No | No |
meal_breakfast | servesbreakfast | Tags | No | No |
meal_lunch | serveslunch | Tags | No | No |
meal_dinner | servesdinner | Tags | No | No |
meal_delivery | delivery | Tags | No | No |
meal_takeout | takeout | Tags | No | No |
meal_cater | - | - | - | - |
alcohol | - | - | - | - |
alcohol_bar | barservice and/or fullbar | Tags | No | No |
alcohol_beer_wine | beer and/or wine | Tags | No | No |
alcohol_byob | beer | Tags | No | No |
kids_goodfor | - | - | - | - |
kids_menu | - | - | - | - |
groups_goodfor | groupspopular | Tags | Yes | No |
accessible_wheelchair | wheelchairaccessible | Tags | No | No |
seating_outdoor | outdoorseating | Tags | No | No |
wifi | wifi | Tags | Yes | No |
owner | - | - | - | - |
room_private | - | - | - | - |
options_vegetarian | vegetariandiet | Tags | Yes | No |
options_vegan | vegandiet | Tags | Yes | No |
options_glutenfree | glutenfreediet | Tags | No | No |
options_lowfat | - | - | - | - |
options_organic | - | - | - | - |
options_healthy | healthydiet | Tags | Yes | No |
Legacy Factual Attribute | Integrated Places Attribute | Attribute Package | DataType Changed | Format Changed |
---|
air_conditioning | - | - | - | - |
complimentary_breakfast | - | - | - | - |
lowest_price | price | RHSM | Yes | Yes |
highest_price | price | RHSM | Yes | Yes |
deposit | - | - | - | - |
room_count | - | - | - | - |
stars | - | - | - | - |
pets | goodfordogs | Tags | Yes | Yes |
non_smoking_rooms | - | - | - | - |
smoking | smoking | Tags | No | No |
internet | wifi | Tags | Yes | Yes |
pool | - | - | - | - |
fitness_facilities | - | - | - | - |
check_in | - | - | - | - |
check_out | - | - | - | - |
business_center | - | - | - | - |
express_check_in | - | - | - | - |
express_check_out | - | - | - | - |
laundry_service | - | - | - | - |
cable_tv | - | - | - | - |
room_service | - | - | - | - |
accessibility | - | - | - | - |
spa_services | - | - | - | - |
cribs | - | - | - | - |
restaurant | - | - | - | - |
concierge | - | - | - | - |
bar | barservice and/or fullbar | Tags | No | No |
twentyfour_hour_front_desk | - | - | - | - |
meeting_rooms | - | - | - | - |
banquet_facilities | - | - | - | - |
event_catering | - | - | - | - |
complimentary_newspapers | - | - | - | - |
review_count | - | - | - | - |
rating | rating | RHSM | Yes | Yes |
type | - | - | - | - |
roll_out_beds | - | - | - | - |
parking_details | - | - | - | - |
Legacy Factual Attribute | Integrated Places Attribute | Attribute Package | DataType Changed | Format Changed |
---|
degrees | - | - | - | - |
education | - | - | - | - |
gender | - | - | - | - |
affiliations | - | - | - | - |
years_experience | - | - | - | - |
insurances | - | - | - | - |
npi_id | - | - | - | - |
languages | - | - | - | - |
Legacy Factual Attribute | Integrated Places Attribute | Attribute Package | DataType Changed | Format Changed |
---|
placerank | popularity | Calculated Scores | Yes | Yes |
Legacy Factual Attribute | Integrated Places Attribute | Attribute Package | DataType Changed | Format Changed |
---|
crosswalk_id_facebook | facebook_id | RHSM | Yes | No |
crosswalk_url_facebook | - | - | - | - |
crosswalk_id_foursquare | fsq_id | Core | No | No |
crosswalk_url_foursquare | - | - | - | - |
crosswalk_url_grubhub | - | - | - | - |
crosswalk_id_instagram | - | - | - | - |
crosswalk_url_instagram | instagram | RHSM | No | Yes |
crosswalk_url_lonelyplanet | - | - | - | - |
crosswalk_url_opentable | - | - | - | - |
crosswalk_id_opentable | - | - | - | - |
crosswalk_url_singleplatform | - | - | - | - |
crosswalk_url_stubhub | - | - | - | - |
crosswalk_id_tripadvisor | - | - | - | - |
crosswalk_url_tripadvisor | - | - | - | - |
crosswalk_id_twitter | twitter | RHSM | No | No |
crosswalk_url_twitter | - | - | - | - |
crosswalk_url_wikipedia | - | - | - | - |
crosswalk_id_yelp | - | - | - | - |
crosswalk_url_yelp | - | - | - | - |
crosswalk_url_zagat | - | - | - | - |