💻Data Schema
echo_poi_id
A POI's unique and consistent Identification code created by Echo Analytics
string
echo_poi_id_v2
An improved version of our echo_poi_id. End of Q3/early Q4 this attribute will be rename as echo_poi_id and will replace the current version 1.
string
poi_name
Specific name of the physical place of interest
string
brand
A label indicating which chain/franchise the entity is operated by, if any. At Echo, an entity is only considered a brand if it has more than 3 physical locations and has a proprietary website
string
tier1_category
Echo Analytics has its own taxonomy, which indicates which industry the POI falls under. Tier 1 indicates the least granular category, E.g Retail
string
tier2_category
Echo Analytics has its own taxonomy, which indicates which business the POI operates in. Tier 2 indicates the most granular category level, E.g. Clothing Stores
string
tier1_naics_code
The code that belongs to the highest level tier of the North American Industry Classification System
integer
tier1_naics_category
The category that belongs to the highest level tier of the North American Industry Classification System
string
tier2_naics_code
The code that belongs to the second highest level tier of the North American Industry Classification System
integer
tier2_naics_category
The category that belongs to the second highest level tier of the North American Industry Classification System
string
tier3_naics_code
The code that belongs to the third highest level tier of the North American Industry Classification System
integer
tier3_naics_category
The category that belongs to the third highest level tier of the North American Industry Classification System
string
tier4_naics_code
The code belongs to the second to last level tier of the North American Industry Classification System
integer
tier4_naics_category
The category that belongs to the second to last level tier of the North American Industry Classification System
string
tier5_naics_code
The code that belongs to the lowest level tier of the North American Industry Classification System
integer
tier5_naics_category
The category that belongs to the lowest level tier of the North American Industry Classification System
string
business_status
This indicates whether the POI is operational, temporarily closed, or permanently closed
string
full_address
Full address of the POI, it contains all available information about the address. (street name, street number, admin boundaries, zip code, etc.)
string
street_number
Street number, street name
string
zip_code
Zip code
string
admin_boundary_3
City, village, town
string
admin_boundary_2
Municipality, Suburb, County
string
admin_boundary_1
State, region
string
country_code
The country where the POI is located in a 2-letter ISO code format
string
latitude
The standard latitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
longitude
The standard longitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
geo_h3_id_level_10
A unique identifier for each H3 area (H3 = Uber's Hexagonal Hierarchical Spatial Index, a grid system with different granularity levels). At Echo, we use Level 10, which has an area of approximately 15 meters
string
parent_organization
A legal entity that runs the stated brand/franchise. This is the indicator of the business group that the company is listed under, Eg: Esso is owned by the Parent Organization Exxon Mobil Corporation
string
stock_ticker
The stock ticker symbol is a unique series of letters associated with publicly listed parent organisations E.g. McDonald's = MCD
string
opening_hours
Indicates the operating hours of the POI business (if applicable). Operating hours formatting can vary for each POI. E.g. (Mo-Fr 09:00-19:30; Sa 10:00-17:00)
string
phone_number
The phone number of the POI business (if applicable). E.g. +33673647563
string
website
URL of the official website tied to the POI business. Can sometimes be just the domain name of the company itself, can be a Facebook page associated to the business, or can be a detailed URL of the specific store of that chain
string
echo_building_id
A building's unique and consistent identification code created by Echo Analytics. A building is a physical place that often contains multiple POIs, E.g. a mall, airport, or stadium
string
shape_type
The shape of the POI boundaries: Radius or Polygon. When a Shape package is purchased, we can deliver either all POIs with both shape types, or only Polygons
string
shape_polygons
The geographical perimeters that define the radius or polygon. For radius, it will indicate the radius of the centroid, for polygon, it will indicate the lat/longs.
geography
area_sq_meters
The area of the polygon or circle in square meters.
string
Last updated