I'm using below package to get the number of intersecting vertices


It is returning only 1 when there are actually 15 vertices in B.Geom. I have validated this by using Sdo_Util.Getnumvertices(B.Geom) and is returning 15 vertices.

I'm a novice in Spatial database and not very sure if Sdo_Geom.Sdo_Intersection Will remove duplicates/overlapping vertices? I wnat to be able to consider all the overlapping vertices as well. Can anyone please let me know if i'm doing right thing here?

Please see below image of intersection where B.Geom is the point (has 15 overlapping vertices) & R.Geom is the polygon.

enter image description here


I think that intersection is wrong function for you. Intersection is a new geometry and in your case it is a single point. Test by selecting Sdo_Geom.Sdo_Intersection(B.Geom,R.Geom,.00000000005) into Well Known Text. I guess that it will a a point. BTW point can't have 15 overlapping vertices. Either it is a multipoint with 15 members or 15 distinct but overlapping points.

  • Sorry it was bit ambiguous, it is a multipoint with 15 members. However for my analysis I believe intersection is the only way. You know any function which does the same work? – Vishwa Feb 18 '15 at 16:46

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.