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 , 14 years ago
comment:2 by , 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.
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?