Point of Interest Index
Snowflake table name : CYBERSYN.POINT_OF_INTEREST_INDEX
| Name | Description | Type | Example |
|---|---|---|---|
| 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 |
|
| Name of the place, merchant, or landmark for the particular the POI. | VARCHAR |
|
| Primary category or class of place for the POI. | VARCHAR |
|
| 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 |
|
Last updated