<html><head></head><body>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 <pella.samu@gmail.com> 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">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/">https://dbeaver.com/docs/wiki/Data-transfer/</a> ; PGAdmin4: <a href="https://www.youtube.com/watch?v=Ikd2xSb00UI">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">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.</body></html>