Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Spatial: Multiple compound elements
HansF <News.Hans_at_telus.net> wrote in
news:pan.2005.04.05.19.43.06.609483_at_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. :) Received on Tue Apr 05 2005 - 14:14:09 CDT