GetFeatureInfo from Oracle: no coordinates

[Bart van den Eijnden (OSGIS)]

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.
>>>>
>>>>
>>>>
>>
>>
>