This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
documentation:next_cdm:lat_long [2017/03/14 01:05] gowtham_rao created |
documentation:next_cdm:lat_long [2017/08/02 13:46] clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Location History ===== | + | ===== Add Latitude and Longitude to Location Table ===== |
+ | ===Proposals are now housed on github=== | ||
+ | [[https://github.com/OHDSI/CommonDataModel/issues/91|link to github issue]] | ||
* Proposal Owner: Gowtham Rao | * Proposal Owner: Gowtham Rao | ||
Line 8: | Line 11: | ||
* 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| | ||