[gdal-dev] ogr2ogr (I)LIKE not caseINsensitive

Even Rouault even.rouault at spatialys.com
Thu Nov 28 08:49:03 PST 2019


On jeudi 28 novembre 2019 17:40:34 CET Jan Heckman wrote:
> That's
> ogr2ogr plangebieden.shp -t_srs EPSG:28992 -dim 2 -spat 45000 405000 140000
> 485000 WFS:"http://afnemers.ruimtelijkeplannen.nl/afnemers2012/services"
> Bestemmingsplangebied -lco ENCODING=UTF-8 -where
> "BeleidsmatigVerantwoordelijkeOverheid LIKE '_eme%' AND planstatus NOT LIKE
> 'voor%' AND planstatus NOT LIKE 'wijzig%' AND planstatus NOT LIKE
> 'concept%' AND planstatus NOT LIKE 'geconso%' AND planstatus NOT LIKE
> 'ontwerp%' AND datum > '2006' AND historisch=0 AND digitaalgewaarmerkt LIKE
> 'ja%' AND dossierstatus <> 'vervallen' AND Naam NOT LIKE '%parke%' AND Naam
> NOT LIKE '%paraplu%' AND Naam NOT LIKE '%Parke%' AND Naam NOT LIKE
> '%Paraplu%'"

I cannot reproduce a ERROR 1: Destination buffer too small. with GDAL master. 
I suspect this might have been fixed although I've no particular recollection 
of such a fix having been done.
I did get however a 
ERROR 1: Failed to parse date '2006' evaluating OGR WHERE expression
which can be fixed by using '2006/01/01' instead of '2006'

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com


More information about the gdal-dev mailing list