<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, 15 Aug 2020 at 17:41, <<a href="mailto:ruvenml@beamerbrooks.com">ruvenml@beamerbrooks.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<br>
<font face="Helvetica, Arial, sans-serif">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.<br>
<br>
Ruven Brooks<br></font></div></blockquote><div><br></div><div>That sounds interesting. Can we adapt it in such a way, users just click in Excel and data gets uploaded.</div><div>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. </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><font face="Helvetica, Arial, sans-serif">
</font><br>
<br>
<div>On 8/15/2020 10:39 AM, Paolo Cavallini
wrote:<br>
</div>
<blockquote type="cite">
The easiest I know of is through QGIS.<br>
Cheers.<br>
<br>
<div class="gmail_quote">On 15 August 2020 17:07:06 CEST, Imre
Samu <a href="mailto:pella.samu@gmail.com" target="_blank"><pella.samu@gmail.com></a> wrote:
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">> Is there a simple way for users to load
their data into PostGIS?
<div><br>
</div>
<div>CSV?</div>
<div>- save as a CSV file ( contains LAT , LON columns )</div>
<div> - import CSV to Postgres<br>
- convert LAT/LON to geometry columns ... <br>
<a href="https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgresql-table" target="_blank">https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgresql-table</a><br>
</div>
<div><br>
</div>
<div>or scripting? ( Python; Julia, R , ... )</div>
<div>or any DB tool? ( <a href="https://dbeaver.com/docs/wiki/Data-transfer/" target="_blank">https://dbeaver.com/docs/wiki/Data-transfer/</a> ;
PGAdmin4: <a href="https://www.youtube.com/watch?v=Ikd2xSb00UI" target="_blank">https://www.youtube.com/watch?v=Ikd2xSb00UI</a> )</div>
<div><br>
</div>
<div>Imre</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Shaozhong SHI <<a href="mailto:shishaozhong@gmail.com" target="_blank">shishaozhong@gmail.com</a>>
ezt írta (időpont: 2020. aug. 15., Szo, 15:35):<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Scenario: Many Excel users seek to
contribute data to PostGIS. Excel can be connected to
PostGIS via ODBC.
<div><br>
</div>
<div>Is there a simply way for users to load their data
into PostGIS?</div>
<div><br>
</div>
<div>Regards,</div>
<div><br>
</div>
<div>Shao</div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
</blockquote>
</div>
<br>
-- <br>
Please excuse my brevity.
<br>
<fieldset></fieldset>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div></div>