Re: [gdal-dev] Problems loading swedish climate data to PostGIS

Thiemo Kellner Tue, 23 Jun 2020 13:41:32 -0700

Hi Jeff

Thank you for sharing your steps. I tried to follow them and had an insight though I am still stuck. I noticed that I was passing the gdb file within the unzipped folder to ogr2ogr whereas you passed the folder path. Switching to your pattern it looks as follows.


thiemo @ thiemos-toshi /mnt/schweden % ogrinfo --formats | grep -i postg
  PostgreSQL -vector- (rw+): PostgreSQL/PostGIS
  PGDUMP -vector- (w+v): PostgreSQL SQL dump
# PostGIS capabilities of ogrinfo proven

thiemo @ thiemos-toshi /mnt/schweden % ogrinfo PG:"host='/var/run/postgresql' port='6543' dbname='sverige' user='sverige'" INFO: Open of `PG:host='/var/run/postgresql' port='6543' dbname='sverige' user='sverige''

      using driver `PostgreSQL' successful.
1: tiger.county (Multi Polygon)
2: tiger.state (Multi Polygon)
...
# Connection to PostGIS works

thiemo @ thiemos-toshi /mnt/schweden % ogrinfo SCID_v4.0.gdb
INFO: Open of `SCID_v4.0.gdb'
      using driver `OpenFileGDB' successful.
1: HBVSv_intrans_HQloc100_rcp45_ensembleMean_diffPerc (Multi Polygon)
2: HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc (Multi Polygon)
...
# Proven to be able to read the gdb file(s)

thiemo @ thiemos-toshi /mnt/schweden % ogrinfo SCID_v4.0.gdb HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc -summary

INFO: Open of `SCID_v4.0.gdb'
      using driver `OpenFileGDB' successful.

Layer name: HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc
Geometry: Multi Polygon
Feature Count: 1103
...
# Proven to be able to access a specific layer in the gdb

thiemo @ thiemos-toshi /mnt/schweden % ogr2ogr –f "PostgreSQL" -overwrite –progress --config PG_USE_COPY YES PG:"host='/var/run/postgresql' port='5432' dbname='sverige' user='sverige'" SCID_v4.0.gdb HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc

FAILURE:
Unable to open datasource `PostgreSQL' with the following drivers.
  -> `PCIDSK'
...
# UNABLE TO USE ogr2ogr TO WRITE DATA TO MY PostGIS

thiemo @ thiemos-toshi /mnt/schweden :-( % ogr2ogr –f "ESRI Shapefile" test.shp SCID_v4.0.gdb/gdb.shp SCID_v4.0.gdb HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc

FAILURE:
Unable to open datasource `ESRI Shapefile' with the following drivers.
  -> `PCIDSK'
...

# To me it seems that I am not able to use ogr2ogr eventhough I can ogrinfo shape files

thiemo @ thiemos-toshi /mnt/schweden % ogrinfo --formats | grep -i esri
  ESRI Shapefile -vector- (rw+v): ESRI Shapefile
  ESRIJSON -vector- (rov): ESRIJSON
  PGeo -vector- (ro): ESRI Personal GeoDatabase
  OpenFileGDB -vector- (rov): ESRI FileGDB

I am pritty lost.

Kind regards

Thiemo

Quoting Jeff McKenna <[email protected]>:

Hi Thiemo!

I have downloaded your data, to hopefully show you how I would tackle this.
First thing is to take this in very small steps, to confirm along the way, otherwise you jump to ogr2ogr without confirming that it is even possible on your system - in other words, live by *ogrinfo*, ogrinfo is your friend, and only move to ogr2ogr once you have ogrinfo happy, and then later use ogrinfo again for confirmation.
Here are my notes, I've made comments with the # symbol, and I should also mention that I am testing on Windows, with MS4W, so sometimes the exact command may slightly change (such as a single quote instead of a double quote in a command, on Linux systems) :
create database
---------------
#must first create an empty db (named 'scid' here), and load the PostGIS extension
createdb -U postgres -p 5436 -E UTF8 scid
psql -U postgres -d scid -p 5436 -c "CREATE EXTENSION postgis;"
psql -U postgres -d scid -p 5436 -c "CREATE EXTENSION postgis_topology;"

ogrinfo
-------

#verify that your local GDAL/OGR is built with PostGIS and FileGDB support
ogrinfo --formats

    PostgreSQL -vector- (rw+): PostgreSQL/PostGIS
    MySQL -vector- (rw+): MySQL
    OpenFileGDB -vector- (rov): ESRI FileGDB
    XPlane -vector- (rov): X-Plane/Flightgear aeronautical data
    DXF -vector- (rw+v): AutoCAD DXF
#connect to your new database (see params for the PG driver at https://gdal.org/drivers/vector/pg.html ) ogrinfo PG:"host=localhost user=postgres password=postgres port=5436 dbname=scid"
INFO: Open of `PG:host=localhost user=postgres password=postgres port=5436 dbname=scid'
      using driver `PostgreSQL' successful.
#we're in business, no errors, yet no spatial tables listed yet, because there is none
#examine the file geodatabase
ogrinfo SCID_v4.0.gdb

INFO: Open of `SCID_v4.0.gdb'
      using driver `OpenFileGDB' successful.
#in my case, MS4W uses the 'OpenFileGDB' driver, but the 'FileGDB' driver is also possible
#356 layers should be listed there, with their layer names. I'll use the last layer listed in the long list:
   356: HBVSv_MLSM_rcp85_ensembleMax_abs (Multi Polygon)

#so the layer name is 'HBVSv_MLSM_rcp85_ensembleMax_abs'

#examine the single layer through OGR/GDAL
ogrinfo SCID_v4.0.gdb HBVSv_MLSM_rcp85_ensembleMax_abs -summary

  - lists that there are 1103 features in that layer
  - EPSG (projection): https://epsg.io/3006

ogr2ogr
-------
#now you are ready to use ogr2ogr to bring the FileGDB layer into your empty PG/PostGIS database ogr2ogr -f PostgreSQL PG:"host=localhost user=postgres password=postgres port=5436 dbname=scid" SCID_v4.0.gdb HBVSv_MLSM_rcp85_ensembleMax_abs
ogrinfo
-------

#use ogrinfo to confirm that the new spatial layer exists in your PG database
ogrinfo PG:"host=localhost user=postgres password=postgres port=5436 dbname=scid"
 - should list your new layer 'hbvsv_mlsm_rcp85_ensemblemax_abs'

#examine your new layer
ogrinfo PG:"host=localhost user=postgres password=postgres port=5436 dbname=scid" hbvsv_mlsm_rcp85_ensemblemax_abs -summary
Hope this helps.  Welcome to the FOSS4G community!

-jeff


--
Jeff McKenna
MapServer Consulting and Training Services
co-founder of FOSS4G
http://gatewaygeo.com/




On 2020-06-23 4:27 a.m., Thiemo Kellner wrote:
Hi
I am new to spacial data processing. For a project of mine I try to load swedish climate data in to my PostGIS installation running/using an openSUSE Tumbleweed installation.
_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev




--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37

smime.p7s
Description: S/MIME Signature

_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Problems loading swedish climate data to PostGIS

Reply via email to