Point of Interest Addresses Relationships

Snowflake table name : CYBERSYN.POINT_OF_INTEREST_ADDRESSES_RELATIONSHIPS

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
POI_ID	A unique identifier for a point of interest (such as a park, a branch of a fast food chain, a hotel, etc.) based on its description and location. It is joinable to the point_of_interest_index table.	VARCHAR	08f26c97862d07510305b67ba9a9e29f
ADDRESS_ID	A unique identifier for an address based on street address that is joinable to the us_addresses table.	VARCHAR	addressId/c32c61c6da52b9f5b5d1504d2427b3b6
RELATIONSHIP_TYPE	Relationship between the two places. We use 'Overlaps' to indicate that the POI_ID is a subpart of the ADDRESS_ID (e.g., relationship of an apartment to an apartment building, as there could be several points of interest at the same address, especially if the data is lacking accurate unit information).	VARCHAR	Overlaps
RELATIONSHIP_START_DATE	The date from which a given relationship is valid. For example, if the NAME of a place at a given POI_ID changed on 2023-04-01, then relationship_start_date of 2023-04-01 is assigned. However, currently, all the values in this column are NULL since it only contains most recent characteristics with no historical changes.	DATE	N/A
RELATIONSHIP_END_DATE	The date from which a given relationship is valid. For example, if the NAME of a place at a given POI_ID changed on 2023-04-01, then relationship_end_date of 2023-03-31 is assigned to the NAME for that POI_ID. However, currently, all the values in this column are NULL since it only contains most recent characteristics with no historical changes.	DATE	N/A