Connecting to a DB (PostgreSQL) and import a shapefile

337
2
03-16-2018 01:52 AM
Highlighted
New Contributor II

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

Reply
0 Kudos
2 Replies
Highlighted
New Contributor II

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... =(

Reply
0 Kudos
Highlighted
New Contributor

Hello, 

Can you paste the error from the statement?

Best,

Lyubomir

Reply
0 Kudos