I am looking for the PostGIS ST_function that will give me the same results as running the ArcGIS Analyis-> Overlays-> Intersect tool on two polygons.

1 Answer 1


What your looking for is ST_Intersection.

ST_Intersection — (T) Returns a geometry that represents the shared portion of geomA and geomB. The geography implementation does a transform to geometry to do the intersection and then transform back to WGS84.

geometry ST_Intersection( geometry geomA , geometry geomB );

You can see a query that implements it in this question (down at the bottom).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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