Changeset a9cc721 in osmose-backend


Ignore:
Timestamp:
Oct 16, 2012 11:00:30 PM (5 years ago)
Author:
Fred <fred.rodrigo@…>
Branches:
master
Children:
48a9867
Parents:
8985ed0
git-author:
Fred <fred.rodrigo@…> (14/10/2012 22:34:35)
git-committer:
Fred <fred.rodrigo@…> (16/10/2012 23:00:30)
Message:

Improve Roundabout shortcut on analyser osmosis_roundabout_level

File:
1 edited

Legend:

Unmodified
Added
Removed
  • analyser_osmosis_roundabout_level.py

    r10719bf ra9cc721  
    133133SELECT 
    134134    junction.id AS junction_id, 
    135     ST_AsText(ST_Centroid(ST_Intersection(w1.linestring, w2.linestring))) -- Centroid because can be any geom 
     135    way_locate(junction.linestring) 
    136136FROM 
    137137    ways AS junction 
     
    139139        junction.linestring && w1.linestring AND 
    140140        w1.tags?'highway' AND 
     141        w1.tags->'highway' IN ('trunk', 'trunk_link', 'primary', 'primary_link', 'secondary', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclasified', 'road') AND 
    141142        w1.id != junction.id 
    142143    JOIN ways AS w2 ON 
    143144        junction.linestring && w2.linestring AND 
    144145        w2.tags?'highway' AND 
     146        w2.tags->'highway' IN ('trunk', 'trunk_link', 'primary', 'primary_link', 'secondary', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclasified', 'road') AND 
    145147        w2.id != junction.id 
    146148WHERE 
     149    junction.tags->'highway' IN ('trunk', 'trunk_link', 'primary', 'primary_link', 'secondary', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclasified', 'road') AND 
    147150    array_length(junction.nodes, 1) > 3 AND 
    148151    junction.nodes[1] = junction.nodes[array_length(junction.nodes, 1)] AND 
Note: See TracChangeset for help on using the changeset viewer.