Mapka pokazujaca Dead End, autor SunCobalt

Uzytkownik Sun Cobalt stworzyl narzedzie pozwalajace zobaczyc kóre wektory wazniejszych dróg koncza sie w powietrzu.
Ze wzgledu na sympatie do nas w pierwszej kolejnosci oprrócz krajow niemieckojezycznych wrzucil tez Polske:

http://suncobalt.dyndns.org:82/deadend.php

Bardzo ulatwia to naprawe mapy…

SunCobalt: DANKE!

Marek

Wygląda przydatnie :slight_smile:

A da się to podpiąć pod JOSM? Widzę, że to WMS jest, próbowałem, ale na razie nie udało mi się…

Przy próbie podpięcia takiego adresu:

wms:http://suncobalt.dyndns.org:82/cgi-bin/tilecache.cgi?LAYERS=deadend&TRANSPARENT=TRUE&FORMAT=aggpng24&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&width={width}&height={height}&bbox={bbox}&srs={proj}&

dostaję:

Grabbing WMS http://suncobalt.dyndns.org:82/cgi-bin/tilecache.cgi?LAYERS=deadend&TRANSPARENT=TRUE&FORMAT=aggpng24&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&width=500&height=500&bbox=8.4209539,55.7020546,16.8419077,60.1658105&srs=EPSG:4326&
java.io.IOException: An error occurred: can't find resolution index for 0.032894. Available resolutions are:
[156543.03125, 78271.515625, 39135.7578125, 19567.87890625, 9783.939453125, 4891.9697265625, 2445.98486328125, 1222.992431640625, 611.4962158203125, 305.74810791015625, 152.87405395507812, 76.437026977539062, 38.218513488769531, 19.109256744384766, 9.5546283721923828, 4.7773141860961914, 2.3886570930480957, 1.1943285465240479, 0.59716427326202393, 0.29858213663101196]

use


http://suncobalt.dyndns.org:82/wms?FORMAT=image/jpeg&VERSION=1.1.1&SERVICE=WMS&REQUEST=GetMap&Layers=deadend&STYLES=&SRS={proj}&WIDTH={width}&HEIGHT={height}&BBOX={bbox}

replace image/jpeg with image/png for a transparent background. It is not cached, but rendered on the fly…be kind :wink:

Technical, I am downloading PL, DE and CH from Geofabrik, extracting highway=*, merging it together and push in into PostgreSQL/PostGIS. It is then rendered with MapServer. The SQL kindly provided by Maxbe is as follows. If you need further info, I am happy to help


select osm_id,way,st_endpoint(way) as endpunkt,highway from osm_line as line1 where
       (line1.way && !BOX!) and 
       line1.highway in ('motorway', ... , 'tertiary_link') and     
       (junction is null or junction!='roundabout') and
       not exists (select way from osm_line as line2 where 
                   (line2.way && expand(st_endpoint(line1.way),0.00001)) and  
                    line2.highway in ('motorway',... ,'residential','service','services') and
                    line1.osm_id!=line2.osm_id and   
                    (ST_Intersects(st_endpoint(line1.way),line2.way))) 

It works, but I get white tiles without red points :frowning:

Zoom out and click “change resolution”. It is a bit strict to avoid too many false positives

It works, thx :slight_smile:

Kolega SunCobalt powinien przy okazji zostac prze nas zaproszony na duze piwo!
Ppawel i serekmedia zreszta tez. Co ja pisze, zapominam o twórcy http://osmapa.pl/w/zmiany/diff.php i calej reszcie.
Kiedy tylko bedzie okazja zapraszam :wink: