Hans Forbrich <hforbric_at_yahoo.net> wrote in message news:<s84Zb.30295$D_5.9646_at_edtnps84>...
> FinnE wrote:
> > Is it possible to have multiple spatial attributes in a single
> > database record in Oracle9i or higher?
>
> Yes.
>
> Some orgs use this fact to have high/med/low resolution point
> information in a table allowing the front-end app to switch and chose
> the appropriate amount of data to transfer.
>
> <elabortion>
> What you refer to as 'Spatial attributes' are object types. You can
> have any number in a table and each 'appears' as a column.
>
> Quick def of the spatial object: There are 5 fields
> - general type of data indicator,
> - coord-system_id (if using projected coord system),
> - single point coords (if type indicates it's only a point),
> - a list for the 2D/3D/(+added info such as LRS) data points (generally
> counter-clockwise),
> - a list that indicates at which point gives a new data definition
> (polygon starts here, curve starts here, etc.)
>
> <more info source>
> There are a number of excellent tutorials in Oracle's OnLine library at
> http://Education.oracle.com
> </more info source>
> </elabortion>
>
> HTH
> /Hans
>
> (BTW - no need to cross-post)
Where in the oracle documentation does it give you that information?
Also do you know - to what precision can Oracle Spatical store arcsec?
Erin
Received on Thu Feb 19 2004 - 13:54:28 CST
