Re: [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""40.00 540.00 60.00 
580.00"
"wfs_abstract" "Test"
END
DUMP TRUE

   PROJECTION
"init=epsg:25832"
   END

   CONNECTIONTYPE oraclespatial 
CONNECTION "user/pass@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 
> Betreff: Re: [mapserver-users] no results for wfs getfeature request
> Datum: 16. April 2013 07:53:48 MESZ
> An: mapserver-users@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 mailto:por...@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
>>> 
>>> 

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] no results for wfs getfeature request

[Holger Porath]

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 mailto:por...@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
>> 
>>   ___
>>   mapserver-users mailing list
>>   mapserver-users@lists.osgeo.org 
>>   http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> 
>> 
>> 
>> 
>> ___
>> mapserver-users mailing list
>> mapserver-users@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> 
> 

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] no results for wfs getfeature request

[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 mailto:por...@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

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org 
http://lists.osgeo.org/mailman/listinfo/mapserver-users




___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users




--
Daniel Morissette
http://www.mapgears.com/
Provider of Professional MapServer Support since 2000

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] no results for wfs getfeature request

[Martin Kofahl]

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 

> 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
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] no results for wfs getfeature request

[porath]

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
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] no results for wfs getfeature request

[Martin Kofahl]

Holger,
can you post the full request sent to MapServer?

Martin


2013/4/13 

> Hi all!
>
> Since we moved from mapserver 5.6.3 to 6.2.0 our WFS 1.0.0 getfeature
> requests do not work any more. We always get an empty result although the
> logged sql statement returns one record when executed directly in
> sqldeveloper. Please find an excerpt of the log below:
>
> msProjectRect(): Projection library error. All points failed to reproject.
> msOracleSpatialLayerGetPaging was called.
> msOracleSpatialLayerFreeItemInfo was called.
> msOracleSpatialLayerClose was called. Layer: 0x1a2ede0, Layer name: flst.
> Layer connection:/@ORCLTST
> msOracleSpatialLayerOpen. Shared connection not available. Creating one.
> msProjectRect(): Warning: degenerate rect
> {0.00,0.00,0.00,0.00}
> msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: …
> msOracleSpatialLayerWhichShapes. Bind values: srid:-1
> minx:-2998554.423622   miny:478.980149  maxx:-2998554.423622
> maxy:478.980149
> msOracleSpatialLayerWhichShapes getting ordinate definition.
> msOracleSpatialLayerWhichShapes converting to OCIColl.
> msOracleSpatialLayerWhichShapes bind by name and object.
> msOracleSpatialLayerWhichShapes name and object now bound.
> msOracleSpatialLayerNextShape on layer 0x1a2ede0, row_num: 0
> msOracleSpatialLayerNextShape on layer 0x1a2ede0, row_num: 1
> msOracleSpatialLayerNextShape on layer 0x1a2ede0, Fetched 0 more rows (1
> total)
> msOracleSpatialLayerFreeItemInfo was called.
> msOracleSpatialLayerClose was called. Layer: 0x1a2ede0, Layer name: flst.
> Layer connection:
> msQueryByRect(): Search returned no results. No matching record(s) found.
> msProjectRect(): Warning: degenerate rect
> {0.00,0.00,0.00,0.00}
> msOracleSpatialLayerClose was called. Layer: 0x1a2ede0, Layer name: flst.
> Layer connection:
>
>
> The same request works fine on mapserver 5.6.3.
>
> Any help is highly appreciated.
>
> Holger
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] no results for wfs getfeature request

[porath]

Hi all!

 

Since we moved from mapserver 5.6.3 to 6.2.0 our WFS 1.0.0 getfeature requests do not work any more. We always get an empty result although the logged sql statement returns one record when executed directly in sqldeveloper. Please find an excerpt of the log below:

 

msProjectRect(): Projection library error. All points failed to reproject.
msOracleSpatialLayerGetPaging was called.
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerClose was called. Layer: 0x1a2ede0, Layer name: flst. Layer connection:/@ORCLTST
msOracleSpatialLayerOpen. Shared connection not available. Creating one.
msProjectRect(): Warning: degenerate rect {0.00,0.00,0.00,0.00}
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: …
msOracleSpatialLayerWhichShapes. Bind values: srid:-1   minx:-2998554.423622   miny:478.980149  maxx:-2998554.423622   maxy:478.980149
msOracleSpatialLayerWhichShapes getting ordinate definition.
msOracleSpatialLayerWhichShapes converting to OCIColl.
msOracleSpatialLayerWhichShapes bind by name and object.
msOracleSpatialLayerWhichShapes name and object now bound.
msOracleSpatialLayerNextShape on layer 0x1a2ede0, row_num: 0
msOracleSpatialLayerNextShape on layer 0x1a2ede0, row_num: 1
msOracleSpatialLayerNextShape on layer 0x1a2ede0, Fetched 0 more rows (1 total)
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerClose was called. Layer: 0x1a2ede0, Layer name: flst. Layer connection:
msQueryByRect(): Search returned no results. No matching record(s) found.
msProjectRect(): Warning: degenerate rect {0.00,0.00,0.00,0.00}
msOracleSpatialLayerClose was called. Layer: 0x1a2ede0, Layer name: flst. Layer connection:

 

 

The same request works fine on mapserver 5.6.3.

 

Any help is highly appreciated.

 

Holger
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users