My postgis database contains osm data from my country. For transportation reasons i want to export a spatial view i created from those data to an spatialite database.
Is there any way to directly extract my postgis view to a spatialite db without resorting to a man-in-the-middle (shapefile then sqlite) solution?
Im using ubuntu linux, with postgis 2.1 gdal 191
here's a single cmd to expot to shapefile:
ogr2ogr -f "ESRI Shapefile" <name-of-folder-to-be-created> \ PG:"dbname=dbname user=username password=pass" \ -sql "<sql query eg> select * from database where <whatever>"
If you get a getsrid(geom) error, load in your database the
psql -f /path/to/legacy.sql