topic Re: Geopandas to PostGIS to ESRI? in Python Questions

Geopandas to PostGIS to ESRI?

SamuelStroebel — Fri, 14 May 2021 20:05:31 GMT

Hello, I apologize if this is in the wrong place, what I am trying to accomplish is load data via database connection from a PostGIS table. In testing, I can use geopandas to export a load data from a shapefile and export it to a table in a PostgreSQL database. When I connect to that database via an esri product (catalog, pro, ect.) It will load the geometry in preview, but the table is blank. I have no problems if I use geopandas to write shapefile, and load the shapefile into the database via the PostGIS tool. I thought it could be a problem with a unique ID field, but I created a field titled 'FID' as the first column in the table.

Re: Geopandas to PostGIS to ESRI?

DanPatterson — Fri, 14 May 2021 22:38:19 GMT

What esri product are you using?

What version of python are you using?

Why do you have to use shapefiles and geopandas?

Re: Geopandas to PostGIS to ESRI?

SamuelStroebel — Mon, 17 May 2021 19:28:02 GMT

Use arcmap/catlog, and arcgis pro, but prefer to do analysis using pandas when possible. The reason I was looking at geopandas is it has easy methods for exporting and reading postGIS tables. I am running an second install of python from anaconda (not running geopandas on the ESRI install) python 3.8.5.