Changeset 8d51981 in osmose-backend


Ignore:
Timestamp:
Nov 18, 2012 9:17:50 PM (5 years ago)
Author:
Fred <fred.rodrigo@…>
Branches:
master
Children:
0d5f1106
Parents:
34174d9
Message:

Add black list for geosedie on building

File:
1 edited

Legend:

Unmodified
Added
Removed
  • analysers/analyser_osmosis_geodesie.py

    rfeccd33 r8d51981  
    4949        ('tour') 
    5050    ) AS k(kw) ON 
    51         nodes.tags ? 'man_made' AND 
    52         nodes.tags->'man_made' = 'survey_point' AND 
    53         nodes.tags ? 'description' AND 
    54         position(k.kw in lower(nodes.tags->'description')) > 0 AND 
    55         position('point constaté détruit' in lower(nodes.tags->'description')) = 0 AND 
    56         SUBSTRING(nodes.tags->'description' from '#"%#" -%' for '#') IS NOT NULL 
    57 ; 
     51        position(k.kw in lower(nodes.tags->'description')) > 0 
     52    JOIN (VALUES 
     53        ('marche') 
     54    ) AS z(kw) ON 
     55        position(z.kw in lower(nodes.tags->'description')) <= 0 
     56WHERE 
     57    nodes.tags ? 'man_made' AND 
     58    nodes.tags->'man_made' = 'survey_point' AND 
     59    nodes.tags ? 'description' AND 
     60    position('point constaté détruit' in lower(nodes.tags->'description')) = 0 AND 
     61    SUBSTRING(nodes.tags->'description' from '#"%#" -%' for '#') IS NOT NULL 
    5862""" 
    5963 
Note: See TracChangeset for help on using the changeset viewer.