[mapserver-users] MapServer, WFS and Oracle

[Rahkonen Jukka]

Hi,

I hope you have tasty shoes.  WFS 1.0.0 does officially support only one projection. I am not sure how Marverver has implemented it, with Geoserver it is possible to use also other projections by adding projection parameter to request.  However, I would try GetFeature request by using BBOX in native projection.

-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 13:06
> Vastaanottaja: Rahkonen Jukka; mapserver-users at lists.osgeo.org
> Aihe: RE: [mapserver-users] MapServer, WFS and Oracle
> 
> Jukka,
> 
> Thanks for the quick reply. The request is:
> 
> mapserv.exe?map=address.map&typename=address&SERVICE=WFS&VERSI
> ON=1.0.0&REQUEST=GetFeature&SRS=EPSG%3A4326&BBOX=1.17194606291
7749,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
>