[Mapserver-users] Oracle Spatial extents

[Vladimir Guzmán]

Yes, that's what I want.
But when I try it, Oracle says:
ORA-13374:  SDO_MBR not supported for geodetic data
In the documentation says:
Usage Notes:
This function is not supported with geodetic data.

What do they mean with 'geodetic data'?
Data with a SRID?
The information in the table is stored with SRID 8307 (WGS84).
Should I change it in order to make it work?

Thanks a lot for your help.

Vladimir Ilich Guzmán R.
------------------------
http://www.maintask.com 



Mills, Daniel wrote:

>what you want is 
>
>SELECT SDO_GEOM.SDO_MBR(c.shape) 
>  FROM cola_markets c;
>
>This will give you the mbr (extent) of the shape as a geometry object.  
>OR
>
>CREATE TYPE vertex_set_type as TABLE OF vertex_type;
>
>Oracle Spatial defines the object type VERTEX_TYPE as:
>
>CREATE TYPE vertex_type AS OBJECT
>   (x  NUMBER,
>    y  NUMBER,
>    z  NUMBER,
>    w  NUMBER);
>
>SELECT c.name, t.X, t.Y
>   FROM cola_markets c,
>   TABLE(SDO_UTIL.GETVERTICES(SELECT SDO_GEOM.SDO_MBR(c.shape) 
>  FROM cola_markets c)) t;
>
>THIS WILL PUT THE VERTICES INTO A TABLE.
>
>Daniel Mills
>GIS Consultant
>
>Tel:	+ 44 (0) 1793 865205
>Fax:	+ 44 (0) 1793 865001
>E-mail:	mills_d at wrcplc.co.uk
>Website:	www.wrcplc.co.uk
>
>
>
>-----Original Message-----
>From: Vladimir Guzmán [mailto:bigfoot at main-task.com]
>Sent: Wednesday, 18 February 2004 16:59
>To: David Fawcett; Mapserver-Userlist
>Subject: Re: [Mapserver-users] Oracle Spatial extents
>
>
>That's exactly what I need.  The problem is that Oracle Spatial does not 
>have such a function "extent",
>
>  
>