Intersections

[Eduardo Spremolla]

This is what I do with Postgis:

select distinct a from 
(select the_geom as a from calles_mvd where nombre='TRABAJO') as uno,
(select the_geom as b from calles_mvd where nombre='LIBERTAD') as dos
where distance(a,b)< 0.0001;

That give me the segment of the firs street that hit the second, good to
zoom center in it with some buffer.


El jue, 14-10-2004 a las 21:11, Eric Katherman escribió:
> That helps a great deal Gregory, I planned on using LIKE just for the initial
> creation of my "intersections" table which can be used for a quick SELECT
> queries later.
> 
> Thanks,
> Eric
-- 
Eduardo Spremolla <edspremolla at antel.com.uy>
Antel I+D