Skip to main content
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

fmelizard
Contributor
Forum|alt.badge.img+16
  • Contributor
  • May 21, 2014
Hi,

 

What is the problem you are facing?

 

Have you tried the option to generate a workspace?

david_r
Evangelist
  • May 22, 2014
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

  • Author
  • May 22, 2014

gazza
Contributor
Forum|alt.badge.img+6
  • Contributor
  • May 22, 2014
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

takashi
Contributor
Forum|alt.badge.img+17
  • Contributor
  • May 24, 2014
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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings