[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