documentation:next_cdm:lat_long
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision Last revision Both sides next revision | ||
|
documentation:next_cdm:lat_long [2017/03/14 01:05] gowtham_rao created |
documentation:next_cdm:lat_long [2017/03/17 14:18] gowtham_rao |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Location History ===== | + | ===== Add Latitude and Longitude to Location Table ===== |
| * Proposal Owner: Gowtham Rao | * Proposal Owner: Gowtham Rao | ||
| Line 8: | Line 8: | ||
| * Backward compatible: Yes | * Backward compatible: Yes | ||
| * Impact: GIS workgroup | * Impact: GIS workgroup | ||
| + | |||
| + | |||
| + | |||
| + | ^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| | ||
documentation/next_cdm/lat_long.txt ยท Last modified: 2017/08/02 13:46 by clairblacketer
Page Tools
