SEO

#1 (**permalink**) 02-24-2008, 12:24 PM

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.

Thanks,
BSI.

#2 (**permalink**) 02-24-2008, 12:24 PM

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 ***

#3 (**permalink**) 02-24-2008, 12:24 PM

HansF <News.Hans@telus.net> wrote in
news

an.2005.04.05.19.43.06.609483@telus.net:

> 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.
>

Thanks, Hans.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Spatial: Multiple compound elements