Point of Interest Index

Snowflake table name : CYBERSYN.POINT_OF_INTEREST_INDEX

View data source documentation here.

NameDescriptionTypeExample

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" ]

Last updated

Copyright © 2024 Cybersyn