[postgis-users] Excel connecting and inputting into PostGIS

[Shaozhong SHI]

On Sat, 15 Aug 2020 at 17:41, <ruvenml at beamerbrooks.com> 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 <pella.samu at gmail.com>
> <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.
>
> _______________________________________________
> postgis-users mailing listpostgis-users at lists.osgeo.orghttps://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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200815/e66dee21/attachment.html>