Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Spatial: Multiple compound elements

Re: Spatial: Multiple compound elements

From: HansF <News.Hans_at_telus.net>
Date: Tue, 05 Apr 2005 18:41:24 GMT
Message-Id: <pan.2005.04.05.19.43.06.609483@telus.net>


On Tue, 05 Apr 2005 18:22:19 +0000, BSI interested us by writing:

> Hi there,
>
> I'm new to Spatial and i have a question. I have a series of regions that I
> would like to be represented as multiple compound elements that is stored
> as a single record in a table. So, SDO_ELEM_INFO would be look like this:
> <header triplet 1>, <line string 1>, <line string 2>, <line string 3>,
> <header triplet 2>, <line string 1>, <line string 2>, <line string 3>,
> <line string 4>, <line string 5> Is this possible? Or a better question
> would be is this the correct way of handling multiple compound elements?
>
> Platform is Oracle 9i on Windows.
>

Yes, this is possible and this is the correct way of handling this IF the elements really make up a single logical (retrieve all-or-nothing) unit.

The usual demo of this is the states of the USofA. Each state is represented by a separate row in the 'states' table, and the entire set of Hawaiian Islands are entered into the spatial column of a single row.

The trick is to use the SDO_ELEM_INFO_ARRAY portion of the spatial column properly - it identifies the start, type (probably polygons, eg. 1003 for you) and interpretation of each element.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***
Received on Tue Apr 05 2005 - 13:41:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US