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

[Luiz Motta]

Thank's  Christy.

The idea is report this problem, or verify , if i am using correct
form the OGR2OGR.

Luiz



2011/3/25 Christy Nieman <cnieman at dmsolutions.ca>:
> 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
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>