User Tools

Site Tools


documentation:next_cdm:lat_long

This is an old revision of the document!


Add Latitude and Longitude to Location Table

FieldRequiredTypeDescription
location_idYesintegerA unique identifier for each geographic location.
address_1Novarchar(50)The address field 1, typically used for the street address, as it appears in the source data.
address_2Novarchar(50)The address field 2, typically used for additional detail such as buildings, suites, floors, as it appears in the source data.
city Novarchar(50)The city field as it appears in the source data.
stateNovarchar(2)The state field as it appears in the source data.
zipNovarchar(9)The zip or postal code as it appears in the source data
countyNovarchar(20)The county as it appears in the source data
location_source_valueNovarchar(50)The verbatim information that is used to uniquely identify the location as it appears in the source data.
latitudeNofloatGeocoded latitude
longitudeNofloatGeocoded longitude
documentation/next_cdm/lat_long.1489760300.txt.gz · Last modified: 2017/03/17 14:18 by gowtham_rao