| 19 | PaulPorthouse: |
| 20 | |
| 21 | Our idea is to use a basic web form with a file upload (similar to the Import from OpenStreetMap) where you can select which ShapeFile to use. You should also be able to set basic information including database connection details. This will then upload the shape and use OGR2OGR to convert the ShapeFile to geometry and import it into the specified database. |
| 22 | |
| 23 | A basic OGR2OGR which should accomplish the import is: |
| 24 | OGR2OGR -overwrite -f "PostgreSQL" PG:dbname=databaseconnection shapefile.shp |
| 25 | |
| 26 | This could be called directly from Python by running it as a sub process. |
| 27 | |
| 28 | Alternatively, to use Python bindings, you could perform the import using GDAL which would allow more control over the import directly within Python, but should still handle the import into Postgres. |
| 29 | |