Venues Schema Mapping
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 Foursquare Venues dataset. Please note that the Seasonal Hours data delivery is being deprecated. The new Foursquare Places has its own robust Extended Attribute Packages that are available for licensing, these include: Ratings, Hours & Social Media (RHSM); Tips & Tastes; Best Photos; Calculated Scores; and Tags.
To use this guide, refer to the Legacy Foursquare Attribute column to lookup the replacement attribute in the New Places Attribute column. 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 Foursquare Data Migration Guide for more details.
Core Data
Legacy Foursquare Attribute | New Places Attribute | New Attribute Package | Data Type Changed | Format Changed |
---|---|---|---|---|
venueid | fsq_id | Core | No | No |
venuename | name | Core | No | No |
translatedvenuenames | name_translated | Core | Yes | Yes |
latitude | latitude | Core | Yes | No |
longitude | longitude | Core | Yes | No |
address | address | Core | No | No |
city | locality | Core | No | No |
dma | dma | Core | No | No |
state | region | Core | No | Yes |
postalcode | postcode | Core | No | No |
countrycode | country | Core | No | Yes |
date_created | date_created | Core | No | No |
date_approximateclosed | date_closed | Calculated Scores | No | No |
score_openclose | closed_bucket | Calculated Scores | No | Yes |
category_primary_id * | fsq_category_ids | Core | Yes | Yes |
category_primary * | fsq_category_labels | Core | Yes | Yes |
category_secondary_id * | fsq_category_ids | Core | Yes | Yes |
cateogry_secondary * | fsq_category_labels | Core | Yes | Yes |
phonenumber | tel | RHSM | No | No |
chainid * | fsq_chain_id | Core | Yes | Yes |
chainname * | fsq_chain_name | Core | Yes | Yes |
totalsubvenues | subvenue_count | Core | No | No |
* 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.
Rich Data
Legacy Foursquare Attribute | New Places Attribute | Attribute Package | Data Type Changed | Format Changed |
---|---|---|---|---|
rating | rating | RHSM | No | No |
price | price | RHSM | No | No |
url | website | RHSM | No | No |
hours | hours | RHSM | Yes | Yes |
hours_popular | hours_popular | RHSM | No | No |
facebookid | facebook_id | RHSM | No | No |
instagramhandle | RHSM | No | No | |
twittername | RHSM | No | No | |
description | description | RHSM | No | No |
photo1, photo2, ... | photos | Best Photos | Yes | Yes |
taste1, taste2, ... | tastes | Tips & Tastes | Yes | Yes |
tip1, tip2, ... | tips | Tips & Tastes | Yes | Yes |
parentid | parentid | Core | No | No |
totaltips | total_tips | Tips & Tastes | No | No |
totalphotos | total_photos | Best Photos | No | No |
popularity_score | popularity | Calculated Scores | No | No |
score_venuereality | venue_reality_bucket | Calculated Scores | No | No |
atm | atm | Tags | Yes | No |
beer | beer | Tags | Yes | No |
barservice | barservice | Tags | Yes | No |
businessmeeting | businessmeeting | Tags | No | No |
byo | byo | Tags | Yes | No |
clean | clean | Tags | No | No |
coatcheck | coatcheck | Tags | Yes | No |
cocktails | cocktails | Tags | Yes | No |
crowded | crowded | Tags | No | No |
datespopular | datespopular | Tags | No | No |
delivery | delivery | Tags | Yes | No |
dressy | dressy | Tags | No | No |
drivethrough | drivethrough | Tags | Yes | No |
essentialreservations | essentialreservations | Tags | Yes | No |
familiespopular | familiespopular | Tags | No | No |
fullbar | fullbar | Tags | Yes | No |
glutenfreediet | glutenfreediet | Tags | No | No |
goodfordogs | goodfordogs | Tags | No | No |
groupsonlyreservations | groupsonlyreservations | Tags | Yes | No |
groupspopular | groupspopular | Tags | No | No |
hasmusic | hasmusic | Tags | No | No |
hasparking | hasparking | Tags | Yes | No |
healthydiet | healthydiet | Tags | No | No |
jukeboxmusic | jukeboxmusic | Tags | Yes | No |
latenight | latenight | Tags | No | No |
livemusic | livemusic | Tags | Yes | No |
noisy | noisy | Tags | No | No |
onlinereservations | onlinereservations | Tags | Yes | No |
outdoorseating | outdoorseating | Tags | Yes | No |
privatelot | privatelot | Tags | Yes | No |
privateroom | privateroom | Tags | Yes | No |
publiclot | publiclot | Tags | Yes | No |
quickbite | quickbite | Tags | No | No |
reservations | reservations | Tags | Yes | No |
restroom | restroom | Tags | Yes | No |
romantic | romantic | Tags | No | No |
servesbarsnacks | servesbarsnacks | Tags | Yes | No |
servesbreakfast | servesbreakfast | Tags | Yes | No |
servesbrunch | servesbrunch | Tags | Yes | No |
servesdessert | servesdessert | Tags | Yes | No |
servesdinner | servesdinner | Tags | Yes | No |
serveshappyhour | serveshappyhour | Tags | Yes | No |
serveslunch | serveslunch | Tags | Yes | No |
servestastingmenu | servestastingmenu | Tags | Yes | No |
servicequality | servicequality | Tags | No | No |
singlespopular | singlespopular | Tags | No | No |
sitdowndining | sitdowndining | Tags | Yes | No |
smoking | smoking | Tags | Yes | No |
specialoccasion | specialoccasion | Tags | No | No |
streetparking | streetparking | Tags | Yes | No |
takeout | takeout | Tags | Yes | No |
takesamex | takesamex | Tags | Yes | No |
takescreditcards | takescreditcards | Tags | Yes | No |
takesdinersclub | takesdinersclub | Tags | Yes | No |
takesdiscover | takesdiscover | Tags | Yes | No |
takesmastercard | takesmastercard | Tags | Yes | No |
takesnfc | takesnfc | Tags | Yes | No |
takesunionpay | takesunionpay | Tags | Yes | No |
takesvisa | takesvisa | Tags | Yes | No |
trendy | trendy | Tags | No | No |
tvs | tvs | Tags | Yes | No |
valetparking | valetparking | Tags | No | No |
valueformoney | valueformoney | Tags | No | No |
vegandiet | vegandiet | Tags | No | No |
vegetariandiet | vegetariandiet | Tags | No | No |
wheelchairaccessible | wheelchairaccessible | Tags | Yes | No |
wifi | wifi | Tags | No | No |
wine | wine | Tags | Yes | No |
Seasonal Hours
Legacy Foursquare Attribute | New Places Attribute |
---|---|
seasonal_hours | Deprecated |
Updated 10 months ago