POI Index
Snowflake table name : CYBERSYN.POI_INDEX
Name | Description | Type | Example |
---|---|---|---|
| POI's street address. | VARCHAR |
|
| Name of the POI's city. | VARCHAR |
|
| Cybersyn's estimation for the month when the POI closed. Recorded as '9999-01-01' if still open. | DATE |
|
| Cybersyn's estimation for the month when the POI opened. | DATE |
|
| Latitude of the POI, rounded to 4 digits. | FLOAT |
|
| Longitude of the POI, rounded to 4 digits. | FLOAT |
|
| Unique identifier assigned by Cybersyn to each merchant. | VARCHAR |
|
| The name of the merchant. | VARCHAR |
|
| Unique identifier assigned by Cybersyn to each point of interest (POI). Joinable to the POI TIMESERIES tables. | VARCHAR |
|
| POI's abbreviated state. | VARCHAR |
|
| POI's 5-digit zip code. | VARCHAR |
|
Last updated