Data Dictionary
US Addresses IndexView Source Documentation
CYBERSYN.US_ADDRESSES: Comprehensive US address data, including geographic information, latitude/longitude coordinates, and address specifics, mapped to a unique ADDRESS_ID for each address.
NAME
DESCRIPTION
TYPE
EXAMPLE
ADDRESS_IDA unique identifier of an address based on street address that is joinable to the point_of_interest_addresses_relationships table.
VARCHAR
addressId/79e0f74203d4b705d2e9eb088c59d62d
ID_ZIPA unique identifier for a zip code joinable to the geography_index/relationships tables
VARCHAR
zip/80227
ID_CITYA unique identifier for a city joinable to the geography_index/relationships tables
VARCHAR
geoId/0466820
ID_STATEA unique identifier for a state, Washington, D.C. or Puerto Rico joinable to the geography_index/relationships tables
VARCHAR
geoId/08
ID_COUNTRYA unique identifier for a country joinable to the geography_index/relationships tables
VARCHAR
country/USA
LONGITUDElongitude coordinate in degrees
FLOAT
-105.0709528
LATITUDElatitude coordinate in degrees
FLOAT
39.6690634
NUMBERnumber of the address identifying location on a street
VARCHAR
43
STREET_DIRECTIONAL_PREFIXa directional modifier preceding the street name, such as N or SW
VARCHAR
N
STREETname of the street
VARCHAR
Yale
STREET_TYPEstring type of the street, such as ROAD
VARCHAR
Lane
to
of
Page
of