[Mapserver-users] Oracle Spatial extents

[Vladimir Guzmán]

Thanks all for your valuable help.
I solved using SRID=1 (Sinusoidal WGS 84)  instead of SRID=8307 
(Geodetic WGS 84)
I don't know the difference, but now I can get (finally) the geometry's 
extents.

Thanks a lot.

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



Vladimir Guzmán wrote:

> 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",
>>
>>  
>>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>