Re: Oracle Spatial Question

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Thu, 24 Feb 2005 00:08:29 +0000
Message-ID: <newscache$2t2eci$rdj$1@newsfront4.netvisao.pt>

Hi Mark,
see some answers inline.

bye,
pedro

Mark wrote:
> Hi
>
> I am new to Oracle Spatial, and have a couple of questions.
>
> It seems that a layer (table/column combination) can have mixed spatial
> types, e.g. points and polygons in the same column. Is this correct?

yes, you can have any type of geometries in one column.
>
> If so, then what is teh performance impact of this?
>
> Is it possible to have a point defined only as SDO_POINT (as Oracle
> recomends in the reference guide), in a column with a polygon, and
> everything still work?

Yes, it will work. But you can also have two columns in one table.. one for a point and one for a polygon. eg. in one column you store a land parcel and in other column a point representing the centroid.

>
> TIA
>
> Mark
>
Received on Wed Feb 23 2005 - 18:08:29 CST