Differences

This shows you the differences between two versions of the page.

--- documentation:next_cdm:lat_long [2017/03/14 01:05] – created gowtham_rao
+++ documentation:next_cdm:lat_long [2017/08/02 13:46] (current) – 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
@@ Line 8: / Line 11: @@
   * Backward compatible: Yes
   * 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|