Changeset 2d3620a in osmose-backend


Ignore:
Timestamp:
Nov 21, 2012 7:40:30 PM (5 years ago)
Author:
Jocelyn Jaubert <jocelyn.jaubert@…>
Branches:
master
Children:
14682f7
Parents:
c97d32a
git-author:
Fred <fred.rodrigo@…> (18/11/2012 21:17:50)
git-committer:
Jocelyn Jaubert <jocelyn.jaubert@…> (21/11/2012 19:40:30)
Message:

Add black list for geosedie on building

File:
1 edited

Legend:

Unmodified
Added
Removed
  • analysers/analyser_osmosis_geodesie.py

    rfeccd33 r2d3620a  
    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.