[OSM-dev-fr] Générer des fichiers SVG par script...

[Christian Quest]

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;