GetFeatureInfo from Oracle: no coordinates

[Bart van den Eijnden (OSGIS)]

I was too quick in my response and forget the actual problem was not
getting the geometry back.

After inspecting the GML I encounter the same problem (see below).

Steve, any ideas?

<msGMLOutput
	 xmlns:gml="http://www.opengis.net/gml"
	 xmlns:xlink="http://www.w3.org/1999/xlink"
	 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<AAA138_layer>
		<AAA138_feature>
			<gml:boundedBy>
				<gml:Box srsName="epsg:28992">
					<gml:coordinates>110320.007812,477782.156250
115568.656250,481898.562500</gml:coordinates>
				</gml:Box>
			</gml:boundedBy>
			<OGR_FID>69386</OGR_FID>
			<TDN_CODE>4523</TDN_CODE>
			<OMSCHRIJVI>Luchtvaartterrein Schiphol</OMSCHRIJVI>
		</AAA138_feature>
	</AAA138_layer>
</msGMLOutput>

Best regards,
Bart

> Hi Fernando, Arjen,
>
> I have no idea what this could be.
>
> I just re-tested here, and using Mapserver 4.8.3 on RHE Linux 3 and Oracle
> Spatial 10g WMS GetFeatureInfo works fine.
>
> Best regards,
> Bart
>
>> Hi Arjen,
>>     Sorry for the delay to reply your message.
>>     It's a strange problem for me because I'm not a WMS specialist,
>> maybe Bart or another guy can help you about this WMS issue (he already
>> used Oracle and WMS without problems). For Oracle Spatial connection I
>> can help you without problem.
>>      The tokens RELATE and NONE just tell to core of maporaclespatial
>> what operator of function will be used to retrieve the data from
>> database, maybe you need to check if Locator have restrictions about the
>> functions that the code use. Another way how to try to find the problem
>> it's turn on the DEBUG for your layer and check in the log (error_log in
>> Apache) what steps the maporaclespatial used to query the data, all the
>> SQL's and Mapserver calls will appear in the log.
>>      For CGI test you can just use a simple Mapserver CGI call, without
>> any WMS, to test your layer and connection. Like:
>>
>> http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/geolocator/service/out.map&mode=map&layers=test1
>>     Best regards.
>>
>> ------------------------------------------------------------------------
>> Fernando Simon
>> Mapserver and Oracle Spatial developer
>> G10 - Laboratorio de Computacao Aplicada - Brazil
>> http://www.univali.br/g10 - UNIVALI/CTTMAR
>> ------------------------------------------------------------------------
>>
>>
>> Arjen de Korte wrote:
>>> Hello Fernando and list,
>>>
>>> Thank you for your reply.
>>>
>>> The layers are drawn correctly when I do a GetMap request. So I get a
>>> correct map image.
>>>
>>> It makes no difference if I use NONE instead of RELATE; still no
>>> coordinates in the GetFeatureInfo result.
>>>
>>> Does anyone on this list have WMS GetFeatureInfo working correctly with
>>> Oracle Locator?
>>>
>>> Regards,
>>> Arjen.
>>>
>>>
>>>
>>> On Thu, 13 Jul 2006 09:06:04 -0300, Fernando Simon said:
>>>
>>>> Hi Arjen,
>>>>     Sorry for the delay to reply you.
>>>>     It's a strange problem, because you can see the attributes but no
>>>> the data, I'm not a WMS/WFS specialist and I will check if can be a
>>>> WMS/WFS problem.
>>>>     About the Oracle Spatial connection, can you check if the layer
>>>> will
>>>> be draw using Mapserver CGI directly? Another issue, I don't know if
>>>> in
>>>> Locator the RELATE with geodetic SRID will work correctly, can you try
>>>> to define the NONE instead of RELATE?
>>>>     Best regards.
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>> Fernando Simon
>>>> Mapserver and Oracle Spatial developer
>>>> G10 - Laboratorio de Computacao Aplicada - Brazil
>>>> http://www.univali.br/g10 - UNIVALI/CTTMAR
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>> Arjen de Korte wrote:
>>>>
>>>>> Hello Mapserver users,
>>>>>
>>>>> I'm trying to get Mapserver to give me a GetFeatureInfo result from
>>>>> Oracle. I do get an XML document back, with the attributes and
>>>>> bounding
>>>>> box in it, but *without* the coordinates!
>>>>>
>>>>> So I do get a valid XML response, starting with <msGMLOutput> and
>>>>> followed by the bounding box (<gml:Box>) and the attributes, but it
>>>>> does
>>>>> not contain feature coordinates like <gml:MultiPolygon>.
>>>>>
>>>>> We are using MS4W 1.5.3 and Oracle 9i Locator (no Spatial
>>>>> extensions).
>>>>>
>>>>> In the mapfile the layer is defined by:
>>>>>
>>>>> LAYER
>>>>>   NAME test1
>>>>>   METADATA
>>>>>    "ows_title" "Test 1"
>>>>>    "gml_include_items" "all"
>>>>>    "wms_extent" "0 300000 300000 600000"
>>>>>   END
>>>>>   PROJECTION
>>>>>    "init=epsg:28992"
>>>>>   END
>>>>>   STATUS ON
>>>>>   TYPE POLYGON
>>>>>   MAXSCALE 50000
>>>>>   CONNECTIONTYPE oraclespatial
>>>>>   CONNECTION "adk/adk at domain"
>>>>>   DATA "geometry from test1 using unique ID srid 90112 relate version
>>>>>   9i"
>>>>>   DUMP true
>>>>>   TEMPLATE "../templates/rivers_query_header.html"
>>>>>   TRANSPARENCY 50
>>>>>   CLASS
>>>>>    NAME "Test 1"
>>>>>    COLOR 0 100 0
>>>>>   END
>>>>> END
>>>>>
>>>>> This is the URL I use for the request:
>>>>>
>>>>> http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/geolocator/service/out.map&service=WMS&version=1.1.1&request=GetFeatureInfo&srs=EPSG:28992&bbox=174800,604995,178736,607363&info_format=application/vnd.ogc.gml&layers=bebgeb,water,test1&query_layers=test1&x=280.999999999999&y=70&width=615&height=370
>>>>>
>>>>> Does anybody have a suggestion how to fix this?
>>>>>
>>>>> Regards,
>>>>>
>>>>> Arjen.
>>>>>
>>>>>
>>>>>
>>>
>>>
>>
>
>