[Mapserver-users] Oracle Spatial extents

[Vladimir Guzmán]

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
>