| 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. |
| | 78 | Inspect 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 | |
| | 85 | There is a function available in {{{modules/s3/s3gis.py}}} to import from CSV. |
