💻Data Schema

Name	Definition	Format
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. [phone]	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