This issue is to document the need to provide clear examples of how to import different types of geodata, whether that's in shapefiles, geojson, or topojson formats. Options in the location specific Ansible tasks file, such as seattle_tasks.yml, should be present in the code, and we should also add to documentation a description of the types and format expected by these examples.
For the purposes of writing this documentation, the shapefile example for Seattle in the master branch works, but the shapefile in the stevenscounty branch does not.
When Ansible gets to the step of ingesting census block groups on the line above, the error below occurs (trimmed for brevity ...):
fatal: [default]: FAILED! => {"changed": true, "cmd": ["ogr2ogr", "-f", "PostgreSQL", "-t_srs", "EPSG:4326", "-nln", "wa_censusblocks", "-nlt", "MultiPolygon", "PG:user=postgres dbname=piecewise", "/opt/piecewise_web/stevens_blkgrps/BlkGrpPop.shp"], "delta": "0:00:00.184024", "end": "2016-10-13 17:19:33.059715", "failed": true, "rc": 1, "start": "2016-10-13 17:19:32.875691", "stderr": "ERROR 1: INSERT command for new feature failed.\nERROR: numeric field overflow\nDETAIL: A field with precision 19, scale 11 must round to an absolute value less than 10^8.\n\n ...
critzo
commented
8 years ago
This issue is to document the need to provide clear examples of how to import different types of geodata, whether that's in shapefiles, geojson, or topojson formats. Options in the location specific Ansible tasks file, such as seattle_tasks.yml, should be present in the code, and we should also add to documentation a description of the types and format expected by these examples.
For the purposes of writing this documentation, the shapefile example for Seattle in the master branch works, but the shapefile in the stevenscounty branch does not.
When Ansible gets to the step of ingesting census block groups on the line above, the error below occurs (trimmed for brevity ...):
fatal: [default]: FAILED! => {"changed": true, "cmd": ["ogr2ogr", "-f", "PostgreSQL", "-t_srs", "EPSG:4326", "-nln", "wa_censusblocks", "-nlt", "MultiPolygon", "PG:user=postgres dbname=piecewise", "/opt/piecewise_web/stevens_blkgrps/BlkGrpPop.shp"], "delta": "0:00:00.184024", "end": "2016-10-13 17:19:33.059715", "failed": true, "rc": 1, "start": "2016-10-13 17:19:32.875691", "stderr": "ERROR 1: INSERT command for new feature failed.\nERROR: numeric field overflow\nDETAIL: A field with precision 19, scale 11 must round to an absolute value less than 10^8.\n\n ...