What I am trying to do is buffer a main st and a side street and get all of the points that intersect that buffer, however they need to be mutually exclusive. In the example below, my results would give me a duplicate at the intersection of Epping Forest Rd and Point No Point Dr.
Logic: I need to buffer Epping Forst Rd and get all points that intersect that buffer and buffer Point No Point Dr and get all points that intersect that buffer then compare both results and drop any points that are duplicate.
So far I have this SQL statement:
SELECT aa_points.int_id FROM aa_points, road_ln WHERE road_ln.st_nam = 'EPPING FOREST' AND ST_Intersects(aa_points.the_geom_webmercator, ST_Buffer(road_ln.the_geom_webmercator,10))
That queries one road but I am at a loss on how to do the second road in a nested statement and how to compare/drop records.