[postgis-users] Custom st_simplify function

2020-02-14 Thread Alexander Gataric
Is there a way to modify st_simplify to have a maximum segment length? I want to be able to limit it to 500 feet. ⁣Get BlueMail for Android ​ On Feb 14, 2020, 1:13 PM, at 1:13 PM, Regina Obe wrote: >gdal_translate does not have a PostGIS raster writer (or at least not >last time I checked).

Re: [postgis-users] gdal or shp2pgsql

2020-02-14 Thread Regina Obe
gdal_translate does not have a PostGIS raster writer (or at least not last time I checked). So you can’t use it to load rasters into PostGIS, but can use it to output postgis raster to other formats. Need to use raster2pgsql for PostGIS raster loading. As far as ogr2ogr vs. shp2gpsql

Re: [postgis-users] gdal or shp2pgsql

2020-02-14 Thread Illya
Is it not: -lco ENCODING=YOUR_CODE On Fri, 14 Feb 2020 at 11:03, Micha Silver 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 >

Re: [postgis-users] gdal or shp2pgsql

2020-02-14 Thread Micha Silver
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 ?

[postgis-users] gdal or shp2pgsql

2020-02-14 Thread Jachym Cepicky
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 ? From the users perspective, I can use both tools on similar manner and have no problem with