[mapserver-users] MapServer, WFS and Oracle

[Bart van den Eijnden]

WFS 1.0 does not support reprojection AFAIK. At least the OGC spec does not, don't know if Mapserver implemented it vendor-specific like Geoserver did, but I could be wrong.

Try version 1.1.0.

Best regards,
Bart

On Nov 18, 2009, at 12:05 PM, Jelmer Baas wrote:

> Jukka,
> 
> Thanks for the quick reply. The request is:
> 
> mapserv.exe?map=address.map&typename=address&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&SRS=EPSG%3A4326&BBOX=1.171946062917749,52.038473357169345,5.173921509856943,52.03887593415947
> 
> (Very zoomed out)
> 
> If this is another projection issue, I'm going to eat my shoe. ;)
> 
> Regards,
> Jelmer
> 
>> -----Original Message-----
>> From: Rahkonen Jukka [mailto:Jukka.Rahkonen at mmmtike.fi] 
>> Sent: woensdag 18 november 2009 11:51
>> To: Jelmer Baas; mapserver-users at lists.osgeo.org
>> Subject: Re: [mapserver-users] MapServer, WFS and Oracle
>> 
>> Hi,
>> 
>> You seem not to get even a single feature back, all you get 
>> is an empty bounding box. How does you GetFeature request look like?
>> 
>> -Jukka Rahkonen-
>> 
>> 
>> 
>>> -----Alkuperäinen viesti-----
>>> Lähettäjä: mapserver-users-bounces at lists.osgeo.org 
>>> [mailto:mapserver-users-bounces at lists.osgeo.org] Puolesta 
>> Jelmer Baas
>>> Lähetetty: 18. marraskuuta 2009 12:11
>>> Vastaanottaja: mapserver-users at lists.osgeo.org
>>> Aihe: [mapserver-users] MapServer, WFS and Oracle
>>> 
>>> Hello list,
>>> 
>>> I'm trying to get MapServer running as a WFS server with an 
>>> Oracle data source. When using TAB files I have no problem, 
>>> also using the Oracle datasource and letting MapServer draw 
>>> it (WMS) works properly.
>>> 
>>> However, the WFS request only returns one result (a correct 
>>> one). My total resulting XML is:
>>> <wfs:FeatureCollection 
>> xsi:schemaLocation="http://www.opengis.net/wfs
>>> http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd
>>> http://mapserver.gis.umn.edu/mapserver
>>> http://x.x.x/scripts/mapserv.exe?map=address.map&SERVICE=WFS&V
>>> ERSION=1.0
>>> .0&REQUEST=DescribeFeatureType&TYPENAME=address&OUTPUTFORMAT=X
>>> MLSCHEMA">
>>> <gml:boundedBy>
>>> <gml:Box srsName="EPSG:4326">
>>> <gml:coordinates>5.172200,52.038485 
>>> 5.173701,52.038853</gml:coordinates>
>>> </gml:Box>
>>> </gml:boundedBy>
>>> </wfs:FeatureCollection>
>>> 
>>> There should be more results (confirmed by the WMS image and 
>>> by monitoring the query in Oracle). I also set DUMP to true 
>>> and "gml_include_items" "all" in my layer METADATA, so I also 
>>> expected more fields. My layer definition is as follows:
>>> 
>>> 	LAYER
>>> 		NAME address
>>> 		TYPE point
>>> 		CONNECTIONTYPE oraclespatial
>>> 		DATA "GEOLOC FROM ADDRESS USING SRID 90112 VERSION 10g"
>>> 		CONNECTION "x/y at z"
>>> 		DUMP TRUE
>>> 		PROCESSING "CLOSE_CONNECTION=DEFER"
>>> 		CLASS
>>> 			SYMBOL "circle"
>>> 			OUTLINECOLOR 255 0 0
>>> 			SIZE 6
>>> 			NAME "address"
>>> 		END
>>> 		PROJECTION
>>> 			"init=epsg:28992"
>>> 		END
>>> 		METADATA
>>> 			"wfs_title" "address"
>>> 			"wfs_srs" "EPSG:28992 EPSG:900913"
>>> 			"wms_title" "address"
>>> 			"wms_srs" "EPSG:28992 EPSG:900913"
>>> 			"gml_featureid" "ID"
>>> 			"gml_include_items" "all"
>>> 		END
>>> 	END
>>> 
>>> Any idea what I'm doing wrong? I'm using MapServer 5.4.2 with 
>>> Oracle 10g.
>>> 
>>> Regards,
>>> Jelmer Baas
>>> _______________________________________________
>>> mapserver-users mailing list
>>> mapserver-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>> 
>> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>