[postgis-users] gdal or shp2pgsql

Illya illya.sparkes.santos at gmail.com
Fri Feb 14 03:16:31 PST 2020


Is it not:

-lco ENCODING=YOUR_CODE





On Fri, 14 Feb 2020 at 11:03, Micha Silver <tsvibar at gmail.com> wrote:

>
> On 14/02/2020 12:50, Jachym Cepicky wrote:
>
> 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 ?
>
>
> 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?
>
>
> Thanks, Micha
>
>
> 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
>
> --
> Micha Silver
> Ben Gurion Univ.
> Sde Boker, Remote Sensing Lab
> cell: +972-523-665918https://orcid.org/0000-0002-1128-1325
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Email - Illya.sparkes.santos at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200214/26aa5692/attachment.html>


More information about the postgis-users mailing list