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 |