Skip to main content
Question

Convert from Esri shapefile to PostgreSQL database but result is missing geometry.


Forum|alt.badge.img

Hi, Im trying to convert my from Esri shapefile to PostgreSQL database, but the result is not good because the geometry is gone. Im using FME for the first time and dont know where is the problem. Please help!

4 replies

david_r
Celebrity
  • March 27, 2018

Are you using the PostgreSQL writer or the PostGIS writer?

If you want to write any geometries, you need to use the PostGIS writer.


Forum|alt.badge.img
  • Author
  • March 27, 2018

I used PostgreSQL writer. I also tried PostGIS writer but didn`t got any result. Should I install some extension to PostgreSQL?

Best regards and thank you


redgeographics
Celebrity
Forum|alt.badge.img+49
delac321 wrote:

I used PostgreSQL writer. I also tried PostGIS writer but didn`t got any result. Should I install some extension to PostgreSQL?

Best regards and thank you

Yes, you'll need to add the PostGIS extenstion to your PostgreSQL database, see http://postgis.net/ for more information.

 

 


david_r
Celebrity
  • March 27, 2018

The Postgresql writer will not write any geometries. You need to first install the PostGIS extensions into your Postgresql instance.

You then have to execute the following command in each of your spatially enabled databases:

CREATE EXTENSION postgis;

More information here: https://postgis.net/install/

You can then use the PostGIS writer in FME to write the geometries.


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