[postgis-users] Excel connecting and inputting into PostGIS

[Shaozhong SHI]

On Sat, 15 Aug 2020 at 16:07, Imre Samu <pella.samu at gmail.com> 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 <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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200815/39c8e6c5/attachment.html>