<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body bidimailui-charset-is-forced="true">
<br>
<div class="moz-cite-prefix">On 14/02/2020 12:50, Jachym Cepicky
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAAZUH4Fp4vUFMexhpWKV6AL_QhY4sNZAQL_Ui4oJvyabnNxkwg@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">Hi all,
I would like to ask, whether you are aware of any big performance
differences or any other serious reasons, why could shp2pgsql and
raster2pgsql be preferred over ogr2ogr and gdal_translate ?</pre>
</blockquote>
<p><br>
</p>
<p>Encoding of attribute tables in shapefiles is often a problem,
and shp2pgsql has the -W option to help to get it right. I don't
know how I would duplicate that in ogr2ogr. Maybe with some -lco
incantation?</p>
<p><br>
</p>
<p>Thanks, Micha</p>
<p><br>
</p>
<blockquote type="cite"
cite="mid:CAAZUH4Fp4vUFMexhpWKV6AL_QhY4sNZAQL_Ui4oJvyabnNxkwg@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">
>From the users perspective, I can use both tools on similar manner and
have no problem with "complex" gdal data model and parameters options
and I would probably prefer the GDAL tools, since it allows me to
translate between various formats without specifically care, what they
are, while *2pgsql is always Postgres specific
Maybe one missing feature of the PostGIS native tools: is there
elegant way (besides of subprocess module), how to use them in
Python(3) environment?
Thank you for clarification
Jachym
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918
<a class="moz-txt-link-freetext" href="https://orcid.org/0000-0002-1128-1325">https://orcid.org/0000-0002-1128-1325</a></pre>
</body>
</html>