I'm trying to get all the points from a Self-Intersection Line String but not find out the self intersection point in the below attached image.

The intersection point touches on the same feature how to find out the self intersection point in postGIS?

enter image description here


PostGIS has a rich functionality, as an option you can solve your problem as follows:

select st_intersection(a.geom, b.geom) as geom from yuor_table_name as a, yuor_table_name as b where st_touches(a.geom, b.geom);

Try to dig deeper...

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.