Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Spatial intersection of 2 geometry layers

Daniel TaitMar 15 2016 — edited Mar 16 2016

I have 2 spatial tables which I want to spatially intersect and keep only the areas which overlap. I thought that this would be the SDO_GEOM.SDO_INTERSECTION function however is this only for intersecting 2 geometry objects rather than all the geometries from 2 spatial tables?

For example I have 2 spatial tables each with 1000s of rows and each with a geometry column called 'geometry'. So I tried:

SELECT SDO_GEOM.SDO_INTERSECTION(a.geometry, b.geometry, 1) as intersect_geom

FROM table a, table b;

I was expecting to have geometry type column returned called intersect_geom but instead I got a large number of rows with null values for intersect_geom.

Cheers

This post has been answered by [Deleted User] on Mar 16 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2016

Added on Mar 15 2016

#database-key-features, #spatial

2 comments

3,215 views