Changes between Version 206 and Version 207 of UserGuidelines/GIS/Data


Ignore:
Timestamp:
05/16/13 11:27:37 (8 years ago)
Author:
Fran Boon
Comment:

Update to current

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/GIS/Data

    v206 v207  
    1616The CSV needs to have specific columns:
    1717 * WKT column if we have polygon info (or Lat and Lon for Points, if not)
    18  * For L1, we need these columns: Country, ADM1_NAME (& WKT)
    19  * For L2, we need these columns: ADM1_NAME, ADM2_NAME (& WKT) [Country can also be used to help separate duplicates]
    20  * For L3, we need these columns: ADM2_NAME, ADM3_NAME (& WKT) [ADM1_NAME and Country can also be used to help separate duplicates]
    21  * For L4, we need these columns: ADM3_NAME, ADM4_NAME (& WKT) [ADM2_NAME, ADM1_NAME and Country can also be used to help separate duplicates]
    22  * For specific lcoations, we need these columns: ADMx_NAME (for appropiate parent level of hierarchy) Name (& Lat/Lon) [ADM2_NAME, ADM1_NAME and Country can also be used to help separate duplicates]
    23  * Code columns are used, if-present
    24   * ADM1_CODE, ADM1_CODE2, ADM2_CODE, ADM2_CODE2, ADM3_CODE, ADM3_CODE2, ADM4_CODE, ADM4_CODE2, Code, Code2
     18 * For L1, we need these columns: Country, L1 (& WKT)
     19 * For L2, we need these columns: L1, L2 (& WKT) [Country can also be used to help separate duplicates]
     20 * For L3, we need these columns: L2, L3 (& WKT) [L1 and Country can also be used to help separate duplicates]
     21 * For L4, we need these columns: L3, L4 (& WKT) [L2, L1 and Country can also be used to help separate duplicates]
     22 * For specific locations, we need these columns: Lx_NAME (for appropriate parent level of hierarchy) Name (& Lat/Lon) [L2, L1 and Country can also be used to help separate duplicates]
     23 * Key/Value columns are used, if-present
     24  * e.g.: "L1 KV:GADM" adds a record in gis_location_tag for every L1 record with a key of "GADM" & a value of whatever is specified in the cell.
    2525 * Population & Elevation columns are read, if-present
    2626 * Ensure that names are consistent between Levels