Export Postgis Layer Subset to Spatialite with ogr2ogr, using some options for significant speedup

export_pg_to_spatialite.sh

ogr2ogr \
  -progress \                             # show progress
  -dsco SPATIALITE=YES \                  # create SQLite DB with spatialite format
  -f "SQLITE" \                           # use SQLite as output format
  -dsco OGR_SQLITE_CACHE=2048MB \         # use increased cache for speedup
  -gt 65536 \                             # use increased number of rows for each transaction for speedup
  landuse.db \                            # output filename
  PG:"host=localhost user=osm dbname=osm" \ # Postgresql connection string
  -sql "SELECT * FROM osm_landusages"     # SQL statement for feature selection