On Sat, 15 Aug 2020 at 16:07, 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 > > 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 <[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] >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users We have been doing that way for a long while. I just wonder whether there can be a way to set things up, and Excel users can easily upload data, while you are on leave and spending a holiday on golden beaches.
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
