[mapserver-users] possible bug in oracle spatial support regarding WFS 1.0.0

[Holger Porath]

Andrea!

Thanks for your reply.

The extent is already set on map level but it is not passed over. Here is our complete map file:

MAP
	CONFIG  "MS_ERRORFILE" "stderr"
    NAME sec-data
    EXTENT 400000 5000000 500000 6000000
    WEB
        METADATA
			"wfs_title"            		"test"
		    "wfs_onlineresource"   		"http://gdsrve01/cgi-bin/lika-services/private/mapserv_test?"  
			"wfs_enable_request" "*"
	        "wfs_srs"                   "EPSG:25832"
        END
    END
            
   LAYER
   DEBUG 10
        NAME         flst_gdsrvt01
        METADATA
            "wfs_title"  "flst_gdsrvt01"
            "gml_featureid"	"fs_id"
            "gml_include_items"         "all"  
            "wfs_abstract" "test"
            "wfs_extent"    "3400000.000000 5400000.000000 3600000.000000 5800000.000000" 
        END
        DUMP TRUE 

       PROJECTION
            "init=epsg:31467"
       END

       CONNECTIONTYPE oraclespatial		
       CONNECTION "user/pass at ALKIS_ALBTST.WORLD"

        DATA   "fs_koordinate from (select      fs_koordinate,
                                                                                fs_gknr,
                                                                                fs_flnr,
                                                                                fs_fsz,
                                                                                fs_fsn,
                                                                                fs_fsstatus,
                                                                                gk_gkbez,
                                                                                fs_id
                                                                from    os_flst,
                                                                        gmkg
                                                                where   gk_gknr=fs_gknr and
                                                                                fs_fsstatus='a')
                        USING UNIQUE fs_id NONE VERSION 9i"
        TYPE     POINT
        STATUS   ON
    END # layer
END # map

Best regards
Holger

Am 25.04.2013 um 20:29 schrieb Andrea Peri:

> I experience a similar (i guess) problem.
> 
> I was resolved when I set the extent a map level.
> 
> 
> 
> 2013/4/25 Holger Porath <porath at web.de>
> Hi all!
> 
> We made some further testing on WFS 1.0.0/ MapServer 6.2.0 and found out that MapServer obviously does not provide an extent when calling msOracleSpatialLayerWhichShapes. The MapServer debug log shows following entry:
> 
> msOracleSpatialLayerWhichShapes. Bind values: srid:-1   minx:0.000000   miny:0.000000  maxx:0.000000  maxy:0.000000
> msQueryByRect(): Search returned no results. No matching record(s) found.
> msProjectRect(): Warning: degenerate rect {0.000000,0.000000,0.000000,0.000000}
> 
> The same getFeature (filter) request with WFS version set from 1.0.0 to 1.1.0 works correctly and the log then reads:
> 
> msOracleSpatialLayerWhichShapes. Bind values: srid:-1   minx:400000.000000   miny:5000000.000000  maxx:500000.000000   maxy:6000000.000000
> 
> It seems that this is a bug that came in with MapServer 6.x. If we submit a WFS 1.0.0 request to map server 5.6.3 everything is fine and the debug log states:
> 
> msOracleSpatialLayerWhichShapes. Bind values: srid:-1   minx:399996.701914   miny:5399998.334331  maxx:600003.563487   maxy:5800001.763759
> 
> Is there anybody who can fix this and provide a patch so that we can recompile MapServer?
> 
> Thanks in advance.
> Holger
> 
> 
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 
> 
> -- 
> -----------------
> Andrea Peri
> . . . . . . . . . 
> qwerty àèìòù
> -----------------