<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<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><br>
<br>
<div class="moz-cite-prefix">On 8/15/2020 10:39 AM, Paolo Cavallini
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:E5A4141C-735B-45DE-AFE4-3FE0F8FBA0AB@faunalia.it">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
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 class="moz-txt-link-rfc2396E" href="mailto:pella.samu@gmail.com"><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"
moz-do-not-send="true">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/"
moz-do-not-send="true">https://dbeaver.com/docs/wiki/Data-transfer/</a> ;
PGAdmin4: <a
href="https://www.youtube.com/watch?v=Ikd2xSb00UI"
moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
</blockquote>
</div>
<br>
-- <br>
Please excuse my brevity.
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>