Greetings, I have a similar issue where I want join attributes by location from line A to line B. Line B contains the attributes I'm interested to join to line A. Line A is a continuous road network, while line B is erratic gps line output. It some cases line A and line B intersect, but that is not always the case. I used the join attributes by location tool in qgis and got mixed results since the tool performs an intersect first, where I need a function to handle both an ST_overlap and ST_buffer. I think the lines are too close together to use ST_DWithin.
Perhaps something like this: SELECT ST_Overlaps(a,b) As a_overlap_b, ST_Crosses(a,b) As a_crosses_b, ST_Intersects(a, b) As a_intersects_b, ST_Contains(b,a) As b_contains_a, ST_Dimension(a) As dim_a, ST_Dimension(b) as dim_b, ST_Dimension(ST_Intersection(a,b)) As dima_intersection_b FROM (SELECT ST_Buffer(ST_GeomFromText('POINT(1 0.5)'), 3) As a, ST_Buffer(ST_GeomFromText('LINESTRING(1 0, 1 1, 3 5)'),0.5) As b) As foo; Will the attributes carry over to the output? Paul
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users