We've got all the geospatial information of our company within an ArcSDE Database (over SQL Server):
- points (locations of the antennas),
- lines (elevation, rivers),
- polygons (protected areas, houses).
We consume these data with ArcGIS Desktop and with ArcGIS Server.
We are planning to migrate all the information to PostGIS (over PostgreSQL), and wonder if there is any documentation/webpage to follow some steps, and some considerations to keep in mind. Is it very hard to export the Data Model?
I've been investigating and been doing some tests with GDAL-Python scripts to read from SDE and write into PostGIS, but any experience will be appreciated.
By the way, we plan to consume the information from PostGIS with ArcGIS Desktop (along with QGIS) and GeoServer.
Thank you very much in advance.
Best Answer
Have you looked at any other spatial ETL solutions? There are some open source solutions like GeoKettle and Spatial Data Integrator.