Documentation
Common Data Model (CDM)
Convert Database to CDM (ETL)
Tool Specific Documentation
Common Data Model (CDM)
Convert Database to CDM (ETL)
Tool Specific Documentation
This is an old revision of the document!
Field | Required | Type | Description |
---|---|---|---|
location_id | Yes | integer | A unique identifier for each geographic location. |
address_1 | No | varchar(50) | The address field 1, typically used for the street address, as it appears in the source data. |
address_2 | No | varchar(50) | The address field 2, typically used for additional detail such as buildings, suites, floors, as it appears in the source data. |
city | No | varchar(50) | The city field as it appears in the source data. |
state | No | varchar(2) | The state field as it appears in the source data. |
zip | No | varchar(9) | The zip or postal code as it appears in the source data |
county | No | varchar(20) | The county as it appears in the source data |
location_source_value | No | varchar(50) | The verbatim information that is used to uniquely identify the location as it appears in the source data. |
latitude | No | float | Geocoded latitude |
longitude | No | float | Geocoded longitude |