Point of Interest Addresses Relationships

Snowflake table name : CYBERSYN.POINT_OF_INTEREST_ADDRESSES_RELATIONSHIPS

View data source documentation 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	08f29a0b5b455a690361d571157b3fe2
ADDRESS_ID	A unique identifier for an address based on street address that is joinable to the us_addresses table.	VARCHAR	addressId/906a8cf096bffd476bb4064fe715a8a5
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