Skip to main content
Question

file Geodatabase to Postgis translation

  • May 21, 2014
  • 5 replies
  • 30 views

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.

 

 
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

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

 

What is the problem you are facing?

 

Have you tried the option to generate a workspace?

david_r
Celebrity
  • 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
Celebrity
  • 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