Point of Interest Index
Snowflake table name : CYBERSYN.POINT_OF_INTEREST_INDEX
Last updated
Snowflake table name : CYBERSYN.POINT_OF_INTEREST_INDEX
Last updated
Copyright © 2024 Cybersyn
Name | Description | Type | Example |
---|---|---|---|
POI_ID
A unique identifier for a point of interest (such as a park, fast food chain, hotel, etc.) based on its description and location. This is joinable to the POINT_OF_INTEREST_ADDRESSES_RELATIONSHIPS table which can be used to link POIs to addresses.
VARCHAR
08f2660d24591228037461fc91d2f1d3
POI_NAME
Name of the place, merchant, or landmark for the particular the POI.
VARCHAR
Mcdonald's
CATEGORY_MAIN
Primary category or class of place for the POI.
VARCHAR
Dog Park
CATEGORY_ALTERNATE
Alternate categories of the POI. A POI could fit multiple categories (e.g., Restaurant, Burger Restaurant, Fast Food Restaurant), in which case one category would be recorded as CATEGORY_MAIN and the remaining categories would be recorded in a list under CATEGORY_ALTERNATE.
ARRAY
[ "Retail" ]