Opened 14 years ago

Last modified 14 years ago

#3256 new defect

No valid WFS geometries from Oracle Spatial data source via PHP MapScript

Reported by: tnolte Owned by: sdlime
Priority: normal Milestone:
Component: MapServer C Library Version: 5.6
Severity: normal Keywords: oracle, wfs
Cc:

Description

I'm using a PHP MapScript WFS wrapper script:

$request = ms_newOwsRequestObj();

/* set some parameters specifically */
if (!array_key_exists('SERVICE',$_REQUEST)) {
	$_REQUEST['SERVICE'] = "WFS";
}

if (!array_key_exists('VERSION',$_REQUEST)) {
	$_REQUEST['VERSION'] = "1.0.0";
}

foreach ($_REQUEST as $key => $value) {
	$request->setParameter($key, $value);
}

ms_ioinstallstdouttobuffer();

if ($_GET['features'] == "sites") {
	$oMap = ms_newMapObj("../map/sites.map");
} else {
	$oMap = ms_newMapObj("../map/wfs.map");
}

$oMap->owsdispatch($request);

$contenttype = ms_iostripstdoutbuffercontenttype();

$buffer = ms_iogetstdoutbufferstring();

header('Content-Type: '.$contenttype);
echo $buffer;

ms_ioresethandlers();

My WFS client is receiving the data columns but there is no geometry data returned to the client to map. The client that I an using is MapInfo 9.5.1. Server versions are: Apache 2.2.4, PHP 5.2.6, Oracle 10G R2, MapServer 5.6

Change History (2)

comment:1 by tnolte, 14 years ago

I have reverted my Development server back to MS 5.4.2 and the WFS is working again. I looked at the same request using DEBUG and can see that the process that is used to query the Oracle Spatial data is completely different. I'm suspecting these are the single-pass query changes that were made in 5.6 for WFS. I need to find out if there is now code changes that need to be made in PHP MapScript or if this is indeed a 5.6 defect. Can anyone else verify this?

comment:2 by tnolte, 14 years ago

Basics of my mapfile:

MAP
	NAME "iPCS Wireless MapServer"
	SHAPEPATH "../data"
	SYMBOLSET "../etc/symbols.txt"
	FONTSET "../etc/fonts.txt"
	
	STATUS ON
	SIZE 768 576 #600 400
	EXTENT -104.29 29.71 -71.55 52.63 #-128.2 16.9 -65.2 58.9
	UNITS DD
	IMAGECOLOR 156 188 217
	CONFIG PROJ_LIB "/usr/local/share/proj"
	CONFIG MS_ERRORFILE "/export/home/www/ipcs/wfs_error.log"
	DEBUG 5
	STATUS ON

	# ==================================================
	# Web Interface Definition
	# ==================================================
	WEB
		METADATA
			wfs_title "iPCS Wireless MapServer"
			wfs_abstract "iPCS MapServer WFS Service"
			wfs_onlineresource "http://ms-test.ilpcs.com/cgi-bin/mapserv?map=/export/home/www/ipcs/map/wfs.map&"
			wfs_request_method "GET"
			wfs_srs "EPSG:4269"
			ows_schemas_location "http://schemas.opengis.net/wfs/"
		END
		IMAGEPATH "/export/home/www/ipcs/mapserver/.cache/ms_tmp/"
		IMAGEURL "/ms_tmp/"
	END
	
	# ==================================================
	# Projection Definition
	# ==================================================
	PROJECTION
		"init=epsg:4269"
	END

	LAYER
		GROUP CELLSITES
		NAME onairkw
		TYPE POINT
		STATUS ON
		DEBUG 5
		CONNECTIONTYPE oraclespatial
		INCLUDE "./templates/oracle.ref"
		PROCESSING "CLOSE_CONNECTION=DEFER"
		DATA "geom FROM ms_sites_onair_kw_vw USING UNIQUE site_id SRID 8307"
		#LABELITEM "bts_switch_id"
		METADATA
			wfs_title "Cell Sites: On-Air (KW)"
			wfs_extent "-104.29 29.71 -71.55 52.63"
			wfs_typename "onairkw"
			gml_geometries "msGeometry"
			gml_msGeometry_type "point"
			gml_featureid "site_id"
			gml_include_items "all"
		END
		DUMP TRUE
	END
  
END # Map File
Note: See TracTickets for help on using tickets.