Changes between Version 1 and Version 2 of Ticket #3205


Ignore:
Timestamp:
Jul 18, 2015, 1:29:22 AM (9 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #3205 – Description

    v1 v2  
    4949with surface distance
    5050
     51
     52{{{
    5153SELECT DISTINCT ON (pe.edge_id) edge_id, gid
    5254    FROM problematic_edges AS pe, my_source_lines AS ul
     
    5456    ORDER BY pe.edge_id, ST_Area(ST_Intersection(ST_Buffer(pe.geom,1,'quad_segs=2'),ST_Buffer(ul,1,'quad_segs=2'))) DESC
    5557
     58}}}
     59