Ca y est, j'ai trouvé pour regrouper mes ways par frontière... SELECT st_assvg(st_simplify(st_transform(st_linemerge(st_collect(linestring)),2154),25),1,0) as svg FROM (SELECT w.id, min(r.id) as r1, max(r.id) as r2 FROM relations r JOIN relation_members m ON (m.relation_id=r.id) JOIN ways w ON (w.id=m.member_id) WHERE m.member_type='W' AND r.tags ? 'type' AND r.tags->'admin_level'='6' AND r.tags->'boundary'='administrative' AND r.tags->'type'='boundary' AND r.tags->'ref_NUTS' LIKE 'FR%' GROUP BY w.id) AS w JOIN ways ON (w.id=ways.id) GROUP BY r1,r2;
_______________________________________________ dev-fr mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev-fr
