Connecting to a DB (PostgreSQL) and import a shapefile

EvaNougier — Fri, 16 Mar 2018 08:52:59 GMT

Hi,

I try to import a shapefile in ArcGIS Pro by connecting to my DB using PostgreSQL.

When I try to put the layer in the map I have an error message "Failure for importing the data".

I check with an other shapefile coming from IGN and works when I import this data into the map, the unique difference between the two layer is the index. I haven't got a spatial index in my second data. Do you think, the problem is about that ?

How can I fix this ?

I have an another question : I have made a table in PostgrSQL and I have imported data with a .csv file but now I would like to transform this "flat" data to geometric data. The geometry will be a point, I have already two columns with X coordinate and Y coordinate. I work with the ID reference system 27564. My data don't have yet a spatial index. So, how can I add a geometry column to my data ? How can I import them in ArcGIS Pro without an error message ?

Thanks for your help,

Have a nice week-end,

Eva

Re: Connecting to a DB (PostgreSQL) and import a shapefile

EvaNougier — Fri, 16 Mar 2018 09:03:05 GMT

To add a geometry column to my table I try this SQL request but it doesn't work :

ALTER TABLE public."PYLONE"
ADD COLUMN ST_SETSRID (ST_Point (X_m,Y_m), 27564) as geom;

The error is near ST_Point, but I don't arrive to correct it... =(

Re: Connecting to a DB (PostgreSQL) and import a shapefile

LubomirAngelov — Tue, 05 Nov 2019 17:09:59 GMT

Hello,

Can you paste the error from the statement?

Best,

Lyubomir

topic Re: Connecting to a DB (PostgreSQL) and import a shapefile in Data Management Questions

Connecting to a DB (PostgreSQL) and import a shapefile

Re: Connecting to a DB (PostgreSQL) and import a shapefile

Re: Connecting to a DB (PostgreSQL) and import a shapefile