Re: Oracle Spatial Attributes

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Thu, 19 Feb 2004 14:56:24 GMT
Message-ID: <s84Zb.30295$D_5.9646@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) Received on Thu Feb 19 2004 - 08:56:24 CST