GetFeatureInfo from Oracle: no coordinates

[Fernando Simon]

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