Contents
How to import geopackges into Postgres with ogr2ogr?
This tutorial shows how to import geopackges into postgres with ogr2ogr like: Note importing into PostgreSQL like this will convert the case of the field names in your GeoPackage data to lowercase in the PostgreSQL table. To maintain case you would need to use the lco option like:
How to import A GeoPackage into QGIS database?
QGIS can consume a lot of file types in a GeoPackage, beyond those of just SHP, TAB, or KML. Irrespective of the supported file type that you want to import, the process is the same: Click on Database | DBManager and expand the GeoPackage section so that you can see the new_sites GeoPackage.
Can A GeoPackage be used for desktop work?
We’ve already started using Geopackages for desktop work (QGIS / ArcGIS) but often have a requirement to upload data to our PostgreSQL databases.
How to import a shapefile to PostGIS with ogr2ogr?
As you discovered by trial and error, there were few nagging issues you needed to fix, the last of which was resolved using ogr2ogr’s -nlt GEOMETRY * argument.
How to import spatial data into PostGIS database?
The most common data format for spatial data has traditionally been the ESRI shapefile. shp2pgsql is a command line tool to import ESRI shapefiles to the database. Under Unix, you can use the following command for importing a new PostGIS table:
How to upload GeoPackage contents to PostGIS database?
To maintain case you would need to use the lco option like: There is work ongoing in QGIS master (e.g. here and here to ‘fix’ the tool in QGIS (Import vector into Postgis database – …) which generates command line parameters for OGR2OGR for you to use, specifically for Postgis, which seems to have broken with QGIS 3.
Which is the most flexible way to use ogr2ogr?
The most flexible way to do this is to use the -sql command which will take any sql statement. One way in which ogr2ogr excels above using the pgsql2shp tool is that ogr2ogr can export multiple tables at once. This is pretty handy for sharing your postgis data with others who do not have a postgis database.
Which is the command line tool for ogr2ogr?
ogrinfo – inspects a GIS datasource and spits out summary data or detailed information about the layers, kinds of geometries found in the file. ogr2ogr – this is a command line tool that converts one Ogr defined data source to another Ogr data source.
How is OGR used to import non-spatial data?
Using OGR to Import Non-spatial Data While OGR was designed primarily to transform data between different spatial datasources, it is a little known fact that it can be used as well for importing non-spatial datasources such as Dbase files and CSV files. Importing Dbase file into PostgreSQL using Ogr2Ogr
When to run ogr2ogr to export specific polygons?
When I run ogr2ogr command to export some specific polygons from .osm.pbf file, downloaded from OSM, I get an error Warning 1: layer names ignored in combination with -sql. I use -sql tag to get get I downloaded the germany.osm.pbf from geofabrik and would like to extract all the harbours.
How to test PostGIS import with shp2pgsql?
I would have been stumped by your second error for awhile, but by testing your SQL user with a different import utility (shp2pgsql), which was smart, you got a more precise error message and gave your SQL user necessary privileges on the spatial_ref_sys table.