[postgis-users] geopands data frame write to PostGreSQL

[Wang, Sandra]

Hi Nahum,
As I have mentioned I used Geopands data frame inside of databrick code and assigned CRS and point lat/long , It displayed right inside data bricks then I write the geopands data frame to PostgrsSQL , it did showed up as feature class but can't display.

[cid:image002.png at 01D80B8A.D6D252D0]

This is using Arccatalog opened.

When you see the structure in postgres sql , it did showed up as geometry type.


[cid:image003.png at 01D80B8B.51226D40]

I feel like structure of table actually can't be recognized by ESRI somehow.

Thank you for the ideas and time trying to help.

Sandra


From: postgis-users <postgis-users-bounces at lists.osgeo.org> On Behalf Of Nahum Castro
Sent: Friday, January 14, 2022 10:36 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: [**EXTERNAL**] Re: [postgis-users] geopands data frame write to PostGreSQL

How are you generating your maps?

There any errors generated by python?

Please install dbeaver and chey if your tables are in the correct projection. https://dbeaver.io/
when you connect to the database and navigate the data, do click in the geom column, the data should be displayed.

Best regards.
Nahum

El mié, 12 ene 2022 a la(s) 15:52, Wang, Sandra (SandraWang at chevron.com<mailto:SandraWang at chevron.com>) escribió:
Hello Anyone has experience write the Geopands data frame from data bricks into PostGreSQL as feature class ?
I have posted question :

python - Writing to geodatabase as feature layer with GeoPandas - Geographic Information Systems Stack Exchange<https://gis.stackexchange.com/questions/420658/writing-to-geodatabase-as-feature-layer-with-geopandas>

here's my PostGIS version:

Can anyone help ?

Much appreciated !

[cid:image001.png at 01D80B8A.5A13A960]



_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users


--
Nahum Castro González
Blvd. Perdigón 214, Brisas del Lago.
CP 37207
León, Guanajuato, México

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220117/2a583af7/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 17613 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220117/2a583af7/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 16718 bytes
Desc: image002.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220117/2a583af7/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 20819 bytes
Desc: image003.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220117/2a583af7/attachment-0002.png>