Places Data Schema

SafeGraph’s Places data provides detailed information about physical places. Our data is fresh, cleaned and provided in a format that empowers the user. With POI data for countries around the world, you can gain insights about any location that a person can visit aside from private residences.

SafeGraph updates the Places dataset every month with the past month's openings and closings and maintains a persistent placekey across releases.

All SafeGraph datasets are formatted as delimited CSVs, combining the desired rows and columns.

:eyes: Are we missing a brand or country? :eyes: Please let us know here! We are adding hundreds of new brands across all countries every month, and we prioritize our brand queue based on your feedback. If you have more general product feedback or questions, please contact us here.

Contents

Helpful Links

Places Schema

Base Attributes

Base attributes capture the fundamental details of a place. You can find more detail here.

Column NameDescriptionTypeExample
placekeyUnique and persistent ID tied to this POI. See Placekey for details on placekey design.String[email protected]
parent_placekeyIf place is encompassed by a larger place (e.g. mall, airport), this lists the placekey of the parent place; otherwise null. See more on parent-child relationships in Spatial Hierarchy.String[email protected]
location_nameThe name of the place of interest.StringSalinas Valley Ford Lincoln
safegraph_brand_idsUnique and consistent ID that represents this specific brand.ListSG_BRAND_59dcabd7cd2395a2, SG_BRAND_8310c2e3461b8b5a
brandsIf this POI is an instance of a larger brand that we have explicitly identified, this column will contain that brand name. See more details in brands.ListFord, Lincoln
top_categoryThe label associated with the first 4 digits of the POI’s NAICS category.StringAutomobile Dealers
sub_categoryThe label associated with all 6 digits of the POI’s NAICS category. For POIs with a 4-digit NAICS category, this column is nullStringNew Car Dealers
naics_code4-digit or 6-digit NAICS code describing the business.Integer441110
latitudeLatitude coordinate of the place of interest.Float36.714767
longitudeLongitude coordinate of the place of interest.Float-121.662912
street_addressStreet address of the place of interest.String1100 Auto Center Circle
cityThe city of the point of interest.StringIrvine
regionThe state, province or county of the place of interest. See region for more details.StringCA
postal_codeThe postal code of the place of interest.String92602
iso_country_codeThe 2 letter ISO 3166-1 alpha-2 country code. Expected values are US, CA, and GB.StringUS

Rich Attributes

Rich attributes are premium columns that include additional valuable information. You can find more detail here.

Column NameDescriptionTypeExample
category_tagsAn array of descriptive tags indicating higher-resolution category information. See category_tags for more details.List[Mexican Food,Casual Dining,Lunch,Dinner]
websitesThe website(s) associated with the POI as provided and maintained by the POI itself. See websites for more details.List["ford.com","lincoln.com"]
phone_numberThe phone number of this POIString+14151234567
open_hoursA JSON string with days as keys and opening & closing times (in the POI's local time) as values. See open_hours for more details.String{ "Mon": [["8:00", "22:00"]], "Tue": [["8:00", "13:00"], ["18:00", "24:00"]], "Wed": [["0:00", "2:00"]], "Thu": [["0:00", "24:00"]], "Fri": [["23:00", "24:00"]], "Sat": [["0:00", "3:00"], ["15:00", "22:30"]], "Sun": [] }
opened_onThe outside year and month this POI opened in yyyy-mm format. If null, then we do not have enough metadata to determine an open date. See the open_on logic for more details.String2019-10
closed_onThe outside year and month this POI closed in yyyy-mm format. If null, then this POI is open. See the closed_on logic for more details.String2020-03
tracking_closed_sinceIndicates the year and month we started tracking "closed_on" for this POI. See the closed_on logic for more details.String2019-07
store_idThe unique ID associated with the store as provided and maintained by the store/brand itself. See store_id for more details.String36558

Geometry Attributes

Geometry attributes help describe the physical aspects of a POI. You can find more detail here.

Column NameDescriptionTypeExample
geometry_typeThe geometric shape associated with this POI. Possible values are: 1) POLYGON: POI has a polygon and geometry metadata or is intended to have a polygon and geometry metadata once Geometry is available in the given country . 2) POINT: POI intentionally does not have a polygon nor Geometry metadata. See geometry_type for more details.StringPOINT
polygon_wktThe shape of the place of interest, formatted as Well-Known Text (WKT). See polygon_wkt for more details.StringPolygon ((-121.663310 36.715207, …, -121.663310 36.715207))
polygon_classThe classification of the polygon: 1) OWNED_POLYGON: only one POI maps to this distinct polygon. 2) SHARED_POLYGON: at least two POIs share the same polygon. See Shared Polygons for more details.StringOWNED_POLYGON
is_syntheticIf true then this is not a precise POI footprint polygon, but instead is an inferred polygon from an accurate centroid and category-based radius. See is_synthetic for more details.Booleanfalse
enclosedIf true, then this POI is completely enclosed indoors by its parent and is only accessible by entering the parent structure. See Influence on Patterns for more information on visit attribution to enclosed POI.Booleanfalse
includes_parking_lotWhether or not the polygon includes the parking lot. See includes_parking_lot for more details.Booleanfalse
wkt_area_sq_metersThe calculated area of the polygon_wkt in square meters. Enterprise customers: Please contact your customer success manager to have this column added to your deliveries.Float184.363874629
related_parkingThe placekey(s) of the parking lot(s) we believe to be servicing this place. Note that a single parking lot often services more than one POI, and sometimes, more than one parking lot services a single POI. This is the inverse of the related_poi column in SafeGraph Parking Lots.List[[email protected], [email protected]]

Brand Info

[brand_info.csv]

The brand_info file is a separate csv that is complimentary with any purchase of SafeGraph Places data.

A SafeGraph brand is defined as store which has multiple locations all under the same logo or store banner. See brands for more details.

Column NameDescriptionTypeExample
safegraph_brand_idUnique and persistent ID that represents this specific brand.StringSG_BRAND_59dcabd7cd2395a2
brand_nameThis is the brand_name corresponding to the safegraph_brand_id.StringFord Motor Company
parent_safegraph_brand_idThere are 2 possible values: 1) If this brand has a parent, this will list the ID of the parent brand. 2) If this brand has no parent, this will be null.StringSG_BRAND_8310c2e3461b8b5a
naics_code4-digit or 6-digit NAICS code describing the business.Integer441110
top_categoryThe label associated with the first 4 digits of the POI’s NAICS category.StringAutomobile Dealers
subcategoryThe label associated with all 6 digits of the POI’s NAICS category. For POIs with a 4-digit NAICS category, this column is nullStringNew Car Dealers
stock_symbolThe stock ticker (if the corporation is traded publicly)StringF
stock_exchangeThe stock exchange on which this corporation is listed (if the corporation is traded publicly).StringNYSE
iso_country_codes_openA list of all 2 letter ISO 3166-1 alpha-2 country codes for each country this brand has at least 1 open POI (closed_on is null).String["US", "GB"]
iso_country_codes_closedA list of all 2 letter ISO 3166-1 alpha-2 country codes for each country this brand has at least 1 closed POI (closed_on is not null).String["US", "CA"]

What’s Next