I am looking to find a way using SDO Geometry to overlay two polygons, Polygon A and Polygon B. I consider Polygon A to be my bottom layer. Wherever Polygon B overlaps Polygon A, I want to cut that geography out of Polygon A. Basically, the geography of Polygon B will take precedence over Polygon, without getting rid of all of Polygon A.

My intent is to throw the now-modified Polygon A and Polygon B into a new Feature Class. This Feature Class will eventually be made into an ArcGIS Service.

Some Visuals:

Blue = Polygon A

Red = Polygon B

enter image description here

When we place Polygon B on Polygon A. We'll cut out where Polygon B is. If we think of this example as 1 layer, this would also be the intended end result.

enter image description here

Polygon A after we remove the chunk where Polygon B was.

enter image description here

Edit: This was marked as a duplicate. Although I can see how this is a duplicate from an ArcGIS Perspective, the answer that was marked as duplicate did not mention anything about SDO Geometry. I would like to see if there is an option available via SDO Geometry as well,(Even if it's not the best solution) in the event that I must end up using SDO. I've removed the references to ArcMap to designate this as more of an SDO Question.

  • 2
    Do you have an Advanced (ArcInfo) license? Have a look at the Erase tool. – Midavalo Feb 21 '17 at 21:55
  • 2
    If you don't have Advanced license, look at gis.stackexchange.com/questions/103746/… – Midavalo Feb 21 '17 at 21:58
  • 1
    Erase, union, and arcpy.Geometry functions would all work; it's reasonable to assume that Oracle has a difference operator – Vince Feb 21 '17 at 22:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.