[mapserver-users] MapServer, WFS and Oracle

[Jelmer Baas]

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
> > 
>