This question already has an answer here:

I am trying to see if two "circles" intersect. The data I have is two points and two radii (in meters). I am using srid 4326. My main issue (i think) is getting the radius in meters.

SELECT (ST_Buffer('POINT (-104.949517 39.740264)',300) && 
          ST_Buffer('POINT (-104.999924 35.000089)',300))

My questions are

  1. Is there a more clever way to do this?

  2. Or how do I convert the radius from dd to meters to get correct buffers?

marked as duplicate by underdark Mar 6 '14 at 19:04

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 1
    Calculate the distance between the 2 points. Is it smaller than the total length of the radii? – mkennedy Mar 6 '14 at 22:02
  • would that be the same as using ST_Dwithin ? – marknery Mar 18 '14 at 16:35
  • Is there any chance to repoen this question ? I am looking for the exact same thing and can't find how to do it, even with the duplicate question link (I am a SQL noob). – nha Apr 8 '15 at 18:40

Browse other questions tagged or ask your own question.