[gdal-dev] OGR2OGR options -select and -where together

[Christy Nieman]

And apparently I'm half asleep this morning.  Didn't see your examples 
of what you've tried.  Sorry.  I tried your 3.1 ogr2ogr with your data 
and got 754 features returned with an older version of GDAL (1.7 I 
believe), but 0 with 1.8 also.

On 03/25/2011 09:46 AM, Christy Nieman wrote:
> Sorry, wrong order for the source and destination files.  Should be 
> output.shp then input.shp
>
> C
>
> On 03/25/2011 09:45 AM, Christy Nieman wrote:
>> Hello,
>>
>> You can indeed use both -select and -where together together.  For 
>> example
>>
>> ogr2ogr -select field1,field2,field3 -where "field1 = value OR field2 
>> = anotherValue" input.shp output.shp
>>
>> Best regards,
>> Christy
>>
>> On 03/25/2011 09:38 AM, Luiz Motta wrote:
>>> Devs,
>>>
>>> I would like have the subset of data, by filters of field (-select)
>>> and attributes(-where), using OGR2OGR.
>>>
>>> My enviroment is:
>>> - Windows XP
>>> - GDAL from OSGEO4W
>>> - Version: GDAL 1.8.0, released 2011/01/12
>>>
>>> At the moment, i can only make subset(field and attribute) by call
>>> separate of OGR2OGR.
>>>
>>> Has one manner to use options  "select" and "where" in the same call 
>>> OGR2OGR  ?
>>>
>>> Next, my tests  to make subsets:
>>>
>>> 1) Source data:
>>> http://www.dpi.inpe.br/prodesdigital/dadosn/2009/PDigital2009_23367_shp.zip 
>>>
>>>
>>> 2) Show info:
>>> 2.1) Summary
>>> ogrinfo -so Prodes2009_23367.shp Prodes2009_23367
>>> 2.2) Subset features (see -where)
>>> ogrinfo -q -geom=NO -where "ano = '2009' and class_name =
>>> 'DESFLORESTAMENTO'"  Prodes2009_23367.shp Prodes2009_23367 | more
>>>
>>> 3) Subset data
>>>
>>> 3.1) Filter by field(-select) and attribute(-where) ->  Empty data 
>>> output
>>> ogr2ogr -f "ESRI Shapefile" -select "ano" -where "ano = '2009' and
>>> class_name = 'DESFLORESTAMENTO'" filter_select_where.shp
>>> Prodes2009_23367.shp
>>> ogrinfo -so filter_select_where.shp filter_select_where
>>> * Feature Count = 0
>>>
>>> 3.2) Filter by field(-select)
>>> ogr2ogr -f "ESRI Shapefile" -select "ano" filter_select.shp
>>> Prodes2009_23367.shp
>>> ogrinfo -so filter_select.shp filter_select
>>>
>>> 3.3) Filter by attribute(-where)
>>> ogr2ogr -f "ESRI Shapefile" -where "ano = '2009' and class_name =
>>> 'DESFLORESTAMENTO'" filter_where.shp Prodes2009_23367.shp
>>> ogrinfo -so filter_where.shp filter_where
>>>
>>> Regards,
>>> Luiz Motta
>>> _______________________________________________
>>> gdal-dev mailing list
>>> gdal-dev at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/gdal-dev
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev