Le lundi 17 septembre 2012 09:44:36, Jukka Rahkonen a écrit : > Hi, > > I compared a few WFS requests with ogr2ogr by filtering either with -where > or with -sql doing the same select. The -where option was reading the > whole feature type and filtering the result on the client side while -sql > was building a GetFeature request with filter. Is it always so that with > the -where option GDAL is sending plain GetFeature and filters the result > on client side? > > My test request was the most simple one -where address='Streetname 10' vs. > -sql "select * from lv:address where address='Streetname 10"
Jukka, I don't reproduce this behaviour. See below (edited to only keep the HTTP WFS requests) $ ogr2ogr -f GML out.gml "WFS:http://demo.deegree.org/deegree-wfs/services"; app:Springs --debug HTTP,WFS -where "objectid = 10" HTTP: Fetch(http://demo.deegree.org/deegree- wfs/services?SERVICE=WFS&REQUEST=GetCapabilities&ACCEPTVERSIONS=1.1.0,1.0.0) HTTP: Fetch(http://demo.deegree.org/deegree- wfs/services?SERVICE=WFS&VERSION=1.1.0&REQUEST=DescribeFeatureType&TYPENAME=app:Springs,app:Country,app:DigitizeFeatures,app:Counties,app:Municipalities_edited,app:CountyBoundaries_edited,app:Municipalities,app:ZipCodes,app:Place,app:Philosopher,app:SI_Gazetteer,app:Railroads,app:StateBoundary) HTTP: Fetch(http://demo.deegree.org/deegree- wfs/services?SERVICE=WFS&VERSION=1.1.0&REQUEST=DescribeFeatureType&TYPENAME=app:Springs) WFS: http://demo.deegree.org/deegree- wfs/services?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=app:Springs&FILTER=%3CFilter%20xmlns%3D%22http: %2F%2Fwww.opengis.net%2Fogc%22%20xmlns:app%3D%22http: %2F%2Fwww.deegree.org%2Fapp%22%20xmlns:gml%3D%22http: %2F%2Fwww.opengis.net%2Fgml%22%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Eobjectid%3C%2FPropertyName%3E%3CLiteral%3E10%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FFilter%3E The GetFeature is sent with the appropriate FILTER. So perhaps you could provide the exact commandline you've used Best regards, Even > > > > -Jukka Rahkonen- > > > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
