Contents
Can a geodatabase be read from a PostGIS reader?
The old Personal Geodatabases depend on MS Access and there are readers and code available. If you have a 10.x file geodatabase you can read layer from FileGDB and load into PostGIS with a single ogr2ogr command (see documentation):
How to convert an ESRI file to a PostGIS database?
The aim of this tool is to convert an ESRI file Geodatabase to a PostGIS database maintaining data, domains, subtypes and relationships. The tool will copy over the feature classes as postgis layers and the tables as standard tables. The domains and subtypes will be converted to PostgreSQL lookup tables.
Is there a GDB to PostGIS loader for GDAL?
FWIW work is going on to create a GDB to postgis loader. This depends on latest GDAL trunk which has GDB bindings. Haven’t had a chance to compile and try myself but hope to before PostGIS 2.0 is out. For the Personal GeoDatabase format, GDAL can read that fine and that’s what I usually use to export data out of personal geodb.
Is the ESRI geodatabase API compatible with GDAL?
The Esri file geodatabase API only works with file geodatabases created using 10.x – the older versions will not work with GDAL, QGIS or anything else that depends on the open file geodatabase API. The old Personal Geodatabases depend on MS Access and there are readers and code available.
Are there readers for the old Personal geodatabases?
The old Personal Geodatabases depend on MS Access and there are readers and code available. In order to do this I also had to download VS2010 express edition and build my own GDAL, ogr plugin and 1.3 of the open file geodatabase API.
How to load shape files in PostGIS database?
The shp2pgsql utility makes shape data usable in PostGIS by converting it from binary data into a series of SQL commands that are then run in the database to load the data. 5.4. Loading with shp2pgsql ¶ The shp2pgsql converts Shape files into SQL. It is a conversion utility that is part of the PostGIS code base and ships with PostGIS packages.
How to migrate SQL Server data to PostgreSQL?
I want to migrate data from a MS SQL Server + ArcSDE to a PostgreSQL + PostGIS, ideally using SQLAlchemy. I am using SQLAlchemy 1.0.11 to migrate an existing database from MS SQL 2012 to PostgreSQL 9.2 (upgrade to 9.5 planned).
How to convert GDB to shp in ArcGIS?
The solution I found online talked about using ArcGIS to convert GDB to SHP and then importing SHP to PostGIS. I do it all the time for my clients. For FileGDB, you need to make sure that the FileGDB driver is installed. You do it with: which should show FileGDB somewhere to tell you it is installed.