Re: [gdal-dev] ogr2ogr postgis to sqlite composite primary key issueissue

2023-08-15 Thread Brent Wood via gdal-dev
ooter=off' -F',' -qAc "select * from table where false" |sed 's/columnToOmit,//g') from table" target.gpkg PG:dbname=mydb On 8/15/23 17:12, Brent Wood via gdal-dev wrote: > Hi, > > I'm looking to use ogr2ogr to replicate a Postgis schema into a > Spatialite

[gdal-dev] ogr2ogr postgis to sqlite composite primary key issueissue

2023-08-15 Thread Brent Wood via gdal-dev
Hi, I'm looking to use ogr2ogr to replicate a Postgis schema into a Spatialite database. (Make a snapshot copy of institutional tables on a field laptop with possible no internet access) I have a script to identify the relevant tables and invoke ogr2ogr to copy each table. Some of the source

Re: [gdal-dev] Convert grid to polygon shapefile

2023-04-10 Thread Brent Wood via gdal-dev
I have done this with QGIS, if you have a grid with categorised values, QGIS can generate a polygon shapefile with the cell boundaries merged by cell value. QGIS uses gdal_polygonize.py under the hood to do this (via a simple GUI interface), so if you work out the command line parameters you