Changes between Version 108 and Version 109 of UserGuidelines/GIS/Data


Ignore:
Timestamp:
01/04/11 07:40:09 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/GIS/Data

    v108 v109  
    7676NB AS_WKT requires OGR v1.6+
    7777
    78 Inspect the CSV & adjust columns as-necessary. The PROPER() spreadsheet function is useful to get the names in the correct format (then Paste as Text).
    79 
    80 There is a function available in {{{modules/s3gis.py}}} to import from CSV.
     78Inspect the CSV & adjust columns as-necessary:
     79 * We need a sheet for L1 with columns: ADM0_NAME, ADM1_NAME (& WKT)
     80 * We want a sheet for L2 with columns: ADM1_NAME, ADM2_NAME (& WKT) [ADM0_NAME can also be used to help separate duplicates]
     81 * We want a sheet for L3 with columns: ADM2_NAME, ADM3_NAME (& WKT) [ADM1_NAME can also be used to help separate duplicates]
     82 * The PROPER() spreadsheet function is useful to get the names in the correct format (then Paste as Text).
     83 * The VLOOKUP() spreadsheet function is useful if the different levels of the hierarchy are in different sheets & linked via a code instead of the name (as we need)
     84
     85There is a function available in {{{modules/s3/s3gis.py}}} to import from CSV.
    8186
    8287Example for Pakistan: