maneva38

Connecting to a DB (PostgreSQL) and import a shapefile

Discussion created by maneva38 on Mar 16, 2018
Latest reply on Mar 16, 2018 by maneva38

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

Outcomes