[postgis-users] Excel connecting and inputting into PostGIS

[Imre Samu]

> Is there a simple way for users to load their data into PostGIS?

CSV?
-  save as a CSV file  ( contains LAT , LON columns )
 - import CSV to Postgres
-  convert LAT/LON  to geometry columns ...
https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgresql-table

or scripting?  ( Python; Julia, R , ...  )
or any DB tool?  ( https://dbeaver.com/docs/wiki/Data-transfer/ ; PGAdmin4:
https://www.youtube.com/watch?v=Ikd2xSb00UI )

Imre




Shaozhong SHI <shishaozhong at gmail.com> ezt írta (időpont: 2020. aug. 15.,
Szo, 15:35):

> Scenario:  Many Excel users seek to contribute data to PostGIS.  Excel can
> be connected to PostGIS via ODBC.
>
> Is there a simply way for users to load their data into PostGIS?
>
> Regards,
>
> Shao
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200815/1952d339/attachment.html>