[Mapserver-users] Oracle Spatial extents

[Fernando S.]

Vladimir,
   Well, the problem can be that you didn't define SRID in your query.

   Some help you can report me.
   Thank's

==================================================================
Fernando Simon - simon at cttmar.univali.br <mailto:simon at cttmar.univali.br>
==================================================================
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer
G10 - Laboratório de Computação Aplicada
Fone: 047 - 341 7960
http://g10.cttmar.univali.br
==================================================================


Vladimir Guzmán wrote:

> I have the same problem that using SDO_GEOM.SDO_MBR:
> ORA-13374:  SDO_MBR not supported for geodetic data
>
> Do you know why my data is geodetic and yours not?
> Did I create the table in the wrong way?
>
> Thanks a lot.
>
> Vladimir Ilich Guzmán R.
> ------------------------
> http://www.maintask.com
>
>
> Fernando S. wrote:
>
>> Vladimir,
>>     Hi, concerning this function, I don't know if this is the correct 
>> way to do it. Anyway I use this query to get the extent:
>> SELECT max(X2), max(Y2), min(X1), min(Y1) FROM (
>>             SELECT SDO_GEOM.SDO_MAX_MBR_ORDINATE(h.coordenada, 
>> m.diminfo, 1) AS X2
>>                 , SDO_GEOM.SDO_MAX_MBR_ORDINATE(h.coordenada, 
>> m.diminfo, 2) AS Y2
>>                 , SDO_GEOM.SDO_MIN_MBR_ORDINATE(h.coordenada, 
>> m.diminfo, 1) AS X1
>>                 , SDO_GEOM.SDO_MIN_MBR_ORDINATE(h.coordenada, 
>> m.diminfo, 2) as Y1
>>                 , h.codigo_ott
>>                 , h.codigo_dna
>>             FROM hidrografia_sc h, user_sdo_geom_metadata m
>>             WHERE m.table_name ='HIDROGRAFIA_SC'
>>             AND m.column_name = 'COORDENADA'
>>             AND h.codigo_ott = $CODE)
>>
>>     In this query HIDROGRAFIA_SC is the table that contains the 
>> geometry column (COORDENADA).  The $CODE is the unique identyfier of 
>> table.
>>
>>     This query report:
>>    MAX(X2)    MAX(Y2)    MIN(X1)    MIN(Y1)
>>     ----------      ----------        ----------      ----------
>>  -48.64248  -26.83385    -49.69149   -27.24407
>>
>>     I don't know if I help you. Sorry my poor english.
>>
>>
>> ==================================================================
>> Fernando Simon - simon at cttmar.univali.br 
>> <mailto:simon at cttmar.univali.br>
>> ==================================================================
>> DataBase Manager, Mapserver, OracleSpatial and PostGis Developer
>> G10 - Laboratório de Computação Aplicada
>> Fone: 047 - 341 7960
>> http://g10.cttmar.univali.br
>> ==================================================================
>>
>>
>> Vladimir Guzmán wrote:
>>
>>> Yes, but the information I get from the table USER_SDO_GEOM_METADATA 
>>> is the global extents of all the elements in the table, and I need 
>>> the extents of each particular element in the table.
>>> For example, my table contains information about states, and if the 
>>> user selects one state in a combo box, I need to get this particular 
>>> state's extents in order to draw it with its appropiate zoom.
>>>
>>> Any ideas?
>>>
>>> Thanks
>>
>>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>