[GIS] Using Fiona to Convert file geodatabase to PostgreSQL / PostGIS

file-geodatabasefionapostgispostgresql

Is there a way to use Fiona instead of OGR to convert a GDB over to postgresql / postgis within Python? If so, how or where can I look? I cannot seem to find this within the Fiona site or by simply Googling around.

Best Answer

Fiona does not currently connect to PostgreSQL/PostGIS as shown here, and sort-of documented here.

OGR is still a useful tool for PostgreSQL/PostGIS, and other spatial databases.

Related Solutions

python – Accessing Non-Spatial PostgreSQL Tables with OGR Python Bindings

You can execute any arbitrary SQL from the connection. For example, to get data from spatial_ref_sys, which is a non-spatial table:

from osgeo import ogr
conn = ogr.Open('PG:dbname=postgis user=postgres')

sql = 'SELECT * FROM spatial_ref_sys LIMIT 10;'
for row in conn.ExecuteSQL(sql):
    print('%s:%d | %s'%(row.auth_name, row.auth_srid, row.proj4text))

[GIS] How to cast geometry to varbinary in PostGIS / PostgreSQL

They're two different representations of the same binary data. SET bytea_output = 'hex' will switch to the hex representation that it sounds like you want.

Here's a couple of examples:

postgres=> SET bytea_output='escape';
postgres=> SELECT ST_AsBinary('POINT (24.3 41.7)'::geometry);
                              st_asbinary                              
-----------------------------------------------------------------------
 \001\001\000\000\000\315\314\314\314\314L8@\232\231\231\231\231\331D@
(1 row)

and

postgres=> SET bytea_output to 'hex';
postgres=> SELECT ST_AsBinary('POINT (24.3 41.7)'::geometry);
                 st_asbinary                  
----------------------------------------------
 \x0101000000cdcccccccc4c38409a99999999d94440
(1 row)

Best Answer

Related Solutions

python – Accessing Non-Spatial PostgreSQL Tables with OGR Python Bindings

[GIS] How to cast geometry to varbinary in PostGIS / PostgreSQL

Related Question