[postgis-users] Excel connecting and inputting into PostGIS

Paolo Cavallini cavallini at faunalia.it
Sat Aug 15 08:39:39 PDT 2020


The easiest I know of is through QGIS.
Cheers.

On 15 August 2020 17:07:06 CEST, 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

-- 
Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200815/340fef82/attachment.html>


More information about the postgis-users mailing list