[mapserver-users] no results for wfs getfeature request

[Holger Porath]

Hi!

Please find below our map file configuration:

  LAYER
   DEBUG 10
        NAME         flst
        METADATA
            "wfs_title"  "flst"
            "gml_featureid" "fs_id"
            "gml_include_items"         "all" 
            "wfs_extent"        "400000.000000 5400000.000000 600000.000000 5800000.000000"
            "wfs_abstract" "Test"
        END
        DUMP TRUE

       PROJECTION
            "init=epsg:25832"
       END

       CONNECTIONTYPE oraclespatial     
        CONNECTION "user/pass at ORCLTST"
        DATA   "fs_tpo_pos from (select      fs_tpo_pos,
                                                                                fs_gknr,
                                                                                fs_flnr,
                                                                                fs_fsz,
                                                                                fs_fsn,
                                                                                fs_fsstatus,
                                                                                gk_gkbez,
                                                                                fs_id
                                                                from    nav.flst,
                                                                        nav.gmkg
                                                                where   gk_gknr=fs_gknr and
                                                                                fs_fsstatus='a')
                        USING UNIQUE fs_id NONE VERSION 9i"
        TYPE     POINT
        STATUS   ON
    END 

Any idea whats wrong?

Regards
Holger

Anfang der weitergeleiteten E-Mail:

> Von: Holger Porath <porath at web.de>
> Betreff: Re: [mapserver-users] no results for wfs getfeature request
> Datum: 16. April 2013 07:53:48 MESZ
> An: mapserver-users at lists.osgeo.org
> 
> Hi,
> 
> I think the extent is set correctly because the same map file configuration works with map server 5.6.3.
> 
> Furthermore, f I change the WFS version in the request from 1.0.0 to 1.1.0 the result is correct (one element found). 
> 
> Regards
> Holger
> 
> Am 15.04.2013 um 21:00 schrieb Daniel Morissette:
> 
>> I don't know if that's the issue here, but I seem to remember a problem related to WFS GetFeature request returning no results when the filter contains only attribute filters and no spatial filter.
>> 
>> In this case the default mapfile extents is used as the default spatial filter which may lead to no results if it does not overlap with the data.
>> 
>> Either try adding a spatial component to your query, or make sure the extents and projection in the mapfile are valid and overlap with the data that you are querying.
>> 
>> Daniel
>> 
>> 
>> 
>> On 13-04-15 2:55 PM, Martin Kofahl wrote:
>>> Holger,
>>> your request contains PropertyIsLike conditions only. So I don't expect
>>> the filter to be the source of the error. What about a querystring like
>>> "SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=flst_gdsrvt01&maxFeatures=1"
>>> and WFS 1.1.0? Do these requests return any results or errors? You'll
>>> probably have to post the significant parts of the mapfile, too.
>>> 
>>> Kind regards,
>>> Martin
>>> 
>>> 2013/4/15 <porath at web.de <mailto:porath at web.de>>
>>> 
>>>  Hi!
>>>  Here is the full WFS 1.0.0 request:
>>>  http://host/ogc-sec-data.ows?service=WFS&version=1.0.0&request=getFeature&typeName=flst_gdsrvt01&Filter=%3CFilter%3E%0A%3Cand%3E%0A%3CPropertyIsLike%20wildCard%3D%22%25%22%20singleChar%3D%22%3F%22%20escape%3D%22ESC%22%3E%0A%3CPropertyName%3EFS_GKNR%3C%2FPropertyName%3E%0A%3CLiteral%3E534%3C%2FLiteral%3E%0A%3C%2FPropertyIsLike%3E%0A%3CPropertyIsLike%20wildCard%3D%22%25%22%20singleChar%3D%22%3F%22%20escape%3D%22ESC%22%3E%0A%3CPropertyName%3EFS_FLNR%3C%2FPropertyName%3E%0A%3CLiteral%3E26%3C%2FLiteral%3E%0A%3C%2FPropertyIsLike%3E%0A%3CPropertyIsLike%20wildCard%3D%22%25%22%20singleChar%3D%22%3F%22%20escape%3D%22ESC%22%3E%0A%3CPropertyName%3EFS_FSZ%3C%2FPropertyName%3E%0A%3CLiteral%3E111%3C%2FLiteral%3E%0A%3C%2FPropertyIsLike%3E%0A%3C%2Fand%3E%0A%3C%2FFilter%3E
>>>  Regards
>>>  Holger
>>> 
>>>