<html><body><div style="color:#000; background-color:#fff; font-family:bookman old style, new york, times, serif;font-size:12pt"><div><span>Le tag surface pourrait-être pris en compte pour les stades de foot en gore ?</span></div><div> </div><div><span style="font-family:arial, helvetica, sans-serif;">Fl<span style="font-family:arial, helvetica, sans-serif;">orian.</span></span><br></div><div><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: bookman old style, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">De :</span></b> Christian Quest <cquest@openstreetmap.fr><br> <b><span style="font-weight: bold;">À :</span></b> Discussions sur OSM en français
<talk-fr@openstreetmap.org> <br> <b><span style="font-weight: bold;">Envoyé le :</span></b> Vendredi 22 mars 2013 14h15<br> <b><span style="font-weight: bold;">Objet :</span></b> Re: [OSM-talk-fr] Rendu des terrains de sport<br> </font> </div> <br>Les terrains de basket et de rugby sont désormais rendus eux aussi...<br><br><a href="http://tile.openstreetmap.fr/?lon=2.44176&lat=48.83262&zoom=17&layers=B00000" target="_blank">http://tile.openstreetmap.fr/?lon=2.44176&lat=48.83262&zoom=17&layers=B00000</a><br><br>Pour le tennis, le tag surface est pris en compte:<br><br><a href="http://tile.openstreetmap.fr/?lon=2.24749&lat=48.84697&zoom=17&layers=B00000" target="_blank">http://tile.openstreetmap.fr/?lon=2.24749&lat=48.84697&zoom=17&layers=B00000</a><br>(Roland Garros)<br><a href="http://tile.openstreetmap.fr/?lon=2.24749&lat=48.84697&zoom=17&layers=B00000"
target="_blank">http://tile.openstreetmap.fr/?lon=2.24749&lat=48.84697&zoom=17&layers=B00000</a><br>(Wimbledon)<br><br>J'ai corrigé les principaux défaut signalés en applicant une<br>simplification au polygone et en tenant compte de sa "rectangularité".<br>Si un polygone n'est pas assez rectangulaire ou de forme trop<br>irrégulière, aucun rendu spécial n'est fait.<br><br>Pour les curieux, j'ai tout commité sur github:<br><a href="https://github.com/cquest/osmfr-cartocss/commits/master" target="_blank">https://github.com/cquest/osmfr-cartocss/commits/master</a><br><br>La requête SQL ressemble à ça:<br><br>select *, abs(a12-a23) as angle_diff, (a12+a23+90)/2 as angle from<br>(select way, sport, surface, way_area, st_npoints(way2) as nb, osm_id,<br>ST_Distance(st_pointn(way2,1),st_pointn(way2,2)) as d12,<br>ST_Distance(st_pointn(way2,3),st_pointn(way2,2)) as<br>d23,ST_Distance(st_pointn(way2,1),st_pointn(way2,3)) as
d13,<br>degrees(st_azimuth(st_pointn(way2,1),st_pointn(way2,2))) as a12,<br>degrees(st_azimuth(st_pointn(way2,2),st_pointn(way2,3))) as a23 from<br>(select *, ST_ExteriorRing(ST_SimplifyPreserveTopology(way,100)) as<br>way2 from planet_osm_polygon where sport in<br>('tennis','soccer','basketball','rugby_union','rugby_league') AND way<br>&& !bbox!) as simplified) as simplified2) as sports<br><br>Y'a sûrement plus efficace et robuste !<br><br>_______________________________________________<br>Talk-fr mailing list<br><a ymailto="mailto:Talk-fr@openstreetmap.org" href="mailto:Talk-fr@openstreetmap.org">Talk-fr@openstreetmap.org</a><br><a href="http://lists.openstreetmap.org/listinfo/talk-fr" target="_blank">http://lists.openstreetmap.org/listinfo/talk-fr</a><br><br><br> </div> </div> </blockquote></div> </div></body></html>