Changeset 5c8a0e8 in osmose-backend


Ignore:
Timestamp:
Aug 7, 2014 10:05:32 PM (5 years ago)
Author:
Jocelyn Jaubert <jocelyn.jaubert@…>
Branches:
master
Children:
3899007
Parents:
fff033f
Message:

Add ST_IsValid to analyser_osmosis_boundary_administrative

File:
1 edited

Legend:

Unmodified
Added
Removed
  • analysers/analyser_osmosis_boundary_administrative.py

    rfff033f r5c8a0e8  
    108108    JOIN commune_dump AS commune ON 
    109109        geodesic_hull.ref_insee = commune.ref_insee 
     110WHERE 
     111    ST_IsValid(geodesic_hull.hull) AND 
     112    ST_IsValid(commune.polygon) 
    110113GROUP BY 
    111114    commune.id, 
     
    129132WHERE 
    130133    nodes.tags?'place' AND 
    131     nodes.tags?'ref:INSEE' 
     134    nodes.tags?'ref:INSEE' AND 
     135    ST_IsValid(commune.polygon) 
    132136; 
    133137""" 
     
    143147        c1.polygon && c2.polygon AND 
    144148        ST_Overlaps(c1.polygon, c2.polygon) 
     149WHERE 
     150    ST_IsValid(c1.polygon) AND 
     151    ST_IsValid(c2.polygon) 
    145152; 
    146153""" 
Note: See TracChangeset for help on using the changeset viewer.