Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Spatial: Multiple compound elements
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