Hi, If you haven't done it yet, check that you can for sure get some data out of your service.
mapserv.exe?map=address.map&typename=address&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&MaxFeatures=10 If yes, have a look at the returned data and see what kind of coordinates it likes to send you. Just to be sure that your BBOX is correct. Also, add DEBUG=5 to the layer definitions and look at the Mapserver errorfile to understand more about what is happening. -Jukka- > -----Alkuperäinen viesti----- > Lähettäjä: Jelmer Baas [mailto:[email protected]] > Lähetetty: 18. marraskuuta 2009 14:39 > Vastaanottaja: Rahkonen Jukka; [email protected] > Aihe: RE: [mapserver-users] MapServer, WFS and Oracle > > Bart, Jukka, > > The shoes taste wonderful. The request comes from OpenLayers, > and I can't find how to change it to WFS 1.1, but that'll be > another Google search, soon. Right now I thought it'd be > smart to see if I at least can get *some* results, manually. > This however also fails. > > My current request > mapserv.exe?map=address.map&typename=address&SERVICE=WFS&VERSI > ON=1.0.0&REQUEST=GetFeature&SRS=EPSG%3A28992&BBOX=125474.00000 0,381967.999850,206652.000100,470382.335300 > > The coordinates come from a previous request (gml:boundedBy) > and should definatly contain some points. An select count(id) > from address where x > 125474 and y > 206652 and x < 381967 > and y < 470382 returns 24002 rows (the geo object is also > saved as plain X/Y). > > For completeness, here's my current MAP file: > > MAP > NAME Test > STATUS ON > UNITS meters > FONTSET "fontset.txt" > > OUTPUTFORMAT > NAME aggpng24 > DRIVER AGG/PNG > TRANSPARENT ON > IMAGEMODE RGBA > MIMETYPE "image/png" > EXTENSION "png" > END > > WEB > METADATA > "wms_title" "Test" > "wfs_title" "Test" > "wms_srs" "EPSG:28992 " > "wfs_srs" "EPSG:28992 " > "wms_onlineresource" "<url>" > "wfs_onlineresource" "<url>" > END # METADATA > END #web > SYMBOLSET "symbols_mapinfo2.sym" > PROJECTION > "init=epsg:28992" > END > LAYER > NAME address > TYPE point > CONNECTIONTYPE oraclespatial > DATA "GEOLOC FROM ADDRESS USING SRID 90112 VERSION 10g" > CONNECTION "x/y/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" > "wms_title" "address" > "wms_srs" "EPSG:28992" > "gml_featureid" "ZIPCODE" > "gml_include_items" "ZIPCODE" > END > END > > END # Map File > > As you can see, I use the Dutch projection system everywhere. > Yet the request only returns: > <?xml version='1.0' encoding="ISO-8859-1" ?> <wfs:FeatureCollection > xmlns:ms="http://mapserver.gis.umn.edu/mapserver"; > xmlns:wfs="http://www.opengis.net/wfs"; > xmlns:gml="http://www.opengis.net/gml"; > xmlns:ogc="http://www.opengis.net/ogc"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > xsi:schemaLocation="http://www.opengis.net/wfs > http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd > http://mapserver.gis.umn.edu/mapserver > <url>/mapserv.exe?map=address.map&SERVICE=WFS&VERSION= > 1.0.0&REQUEST=DescribeFeatureType&TYPENAME=address& > ;OUTPUTFORMAT=XMLSCHEMA"> > <gml:boundedBy> > <gml:Box srsName="EPSG:28992"> > > <gml:coordinates>125474.000000,381967.999850 > 206652.000100,470382.335300</gml:coordinates> > </gml:Box> > </gml:boundedBy> > </wfs:FeatureCollection> > > Any more help would be greatly appreciated. > > Regards, > Jelmer > > > 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ä: [email protected] > > > [mailto:[email protected]] Puolesta > > Jelmer Baas > > > Lähetetty: 18. marraskuuta 2009 13:06 > > > Vastaanottaja: Rahkonen Jukka; [email protected] > > > 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:[email protected]] > > > > Sent: woensdag 18 november 2009 11:51 > > > > To: Jelmer Baas; [email protected] > > > > 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ä: [email protected] > > > > > [mailto:[email protected]] Puolesta > > > > Jelmer Baas > > > > > Lähetetty: 18. marraskuuta 2009 12:11 > > > > > Vastaanottaja: [email protected] > > > > > 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...@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 > > > > > [email protected] > > > > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > > > > > > > > > _______________________________________________ > > > mapserver-users mailing list > > > [email protected] > > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > > > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
