Changeset a9ea64d in osmose-backend


Ignore:
Timestamp:
Dec 29, 2014 9:38:33 PM (5 years ago)
Author:
Frédéric Rodrigo <fred.rodrigo@…>
Branches:
master
Children:
7570d45
Parents:
1e9cbfc
git-author:
Frédéric Rodrigo <fred.rodrigo@…> (28/12/2014 11:19:32)
git-committer:
Frédéric Rodrigo <fred.rodrigo@…> (29/12/2014 21:38:33)
Message:

Remove false positive on missing power tower inside power substation

File:
1 edited

Legend:

Unmodified
Added
Removed
  • analysers/analyser_osmosis_powerline.py

    r111f7c8 ra9ea64d  
    7171 
    7272sql22 = """ 
    73 CREATE VIEW line_terminators AS 
     73CREATE TEMP TABLE line_terminators AS 
    7474( 
    7575SELECT 
    76     'N' as type, 
    77     id, 
    7876    geom 
    7977FROM 
     
    8684( 
    8785SELECT 
    88     'W' as type, 
    89     id, 
    9086    linestring AS geom 
    9187FROM 
     
    109105        ST_Distance_Sphere(nodes.geom, line_terminators.geom) < 150 
    110106WHERE 
    111     line_terminators.id IS NULL 
     107    line_terminators.geom IS NULL 
    112108""" 
    113109 
     
    172168    JOIN nodes ON 
    173169        way_nodes.node_id = nodes.id 
    174 WHERE 
     170    LEFT JOIN line_terminators ON 
     171        ST_Distance_Sphere(nodes.geom, line_terminators.geom) < 150 
     172WHERE 
     173    line_terminators.geom IS NULL AND 
    175174    nodes.id != ways.nodes[1] AND 
    176175    nodes.id != ways.nodes[array_length(nodes,1)] AND 
Note: See TracChangeset for help on using the changeset viewer.