On Sat, 15 Aug 2020 at 17:41, <[email protected]> wrote: > > 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 >
That sounds interesting. Can we adapt it in such a way, users just click in Excel and data gets uploaded. Before you are to go on holiday, simply drop them a note what to do. Bear in mind that they have no clue of SQL. > > > 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]> > <[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 >> >> > -- > Please excuse my brevity. > > _______________________________________________ > postgis-users mailing > [email protected]https://lists.osgeo.org/mailman/listinfo/postgis-users > > > _______________________________________________ > 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
