Question

file Geodatabase to Postgis translation


Hi, I am Sajid Ali studying in HFT Stuttgart. I am facing a problem when I am going to translate Esri File Geodatabase to Postgis. I ahve FME 2013 Version installed and the version of Poistgis is 2.1.2. Please help me out.

 

 

5 replies

Userlevel 4
Badge +13
Hi,

 

What is the problem you are facing?

 

Have you tried the option to generate a workspace?
Userlevel 4
Hi,

 

 

as Itay suggests, try the following in FME:

 

File -> New -> Generate workspace using wizard...

 

 

If you have problems, please post screenshots and/or log file here, together with a description of what you were doing the error occurred.

 

 

David
Badge +5
Has PostGIS been enabled on the database? 

 

 

See 2.5 and 2.6 at http://postgis.refractions.net/documentation/manual-1.5/ch02.html#templatepostgis

 

 

Gary
Userlevel 2
Badge +17
Hi,

 

 

probably Gary is spot on, you will have to create a PostgreSQL database for PostGIS.

 

You can also add functions for PostGIS to a PostgreSQL database with executing SQL statements stored in these files.

 

-----

 

postgis.sql

 

postgis_comments.sql

 

spatial_ref_sys.sql

 

postgis_upgrade_21_minor.sql

 

-----

 

These files are saved in

 

"C:\\Program Files\\PostgreSQL\\9.3\\share\\contrib\\postgis-2.1"

 

Note: the directory path and version number may be different according to your installing condition.

 

 

Takashi

Reply