SQL Workbench/J can read/write Excel files directly. It's pretty much a replacement for pgAdmin and for most of the things that are done in psql.
Ruven Brooks On 8/15/2020 10:39 AM, Paolo Cavallini wrote:
The easiest I know of is through QGIS. Cheers. On 15 August 2020 17:07:06 CEST, Imre Samu <[email protected]> wrote: > 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 <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/ <https://dbeaver.com/docs/wiki/Data-transfer/> ; PGAdmin4: https://www.youtube.com/watch?v=Ikd2xSb00UI <https://www.youtube.com/watch?v=Ikd2xSb00UI> ) Imre Shaozhong SHI <[email protected] <mailto:[email protected]>> 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 [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users <https://lists.osgeo.org/mailman/listinfo/postgis-users> -- Please excuse my brevity. _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
