<div>Hi Kai,<br></div><div></div><div>Thank you for the nice work!</div><div>As time allows I will try it out and see how it works.</div><div></div><div>While I'm very curious what <a href="http://www.kneipenculture.de">http://www.kneipenculture.de</a> is going to become in the future, I'm a little bit worrying about link consistency. Would be too bad if links would be broken in the future.</div>
<div>Probably TRAC isn't the best choice for tasks like this, but the way OpenLayers of Mapserver go with their documentation creation might be a bit overkill for pgROuting, I think.</div><div></div><div>Maybe one possibility would be to create a "documentation" directory in SVN and give access to you and others, who help with documentation, so at least someone could upload files there and link to them then in TRAC.</div>
<div></div><div>Any better idea?</div><div></div><div>Daniel</div><div></div><div></div><div></div><div><br></div><div class="gmail_quote">2009/4/22 Kai Behncke <span dir="ltr"><<a href="mailto:Kai-Behncke@gmx.de">Kai-Behncke@gmx.de</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Dear users,<br>
<br>
<br>
as posted some days ago a new workshop (OL 2.7, own osm-data (evaluating them in UMN)) has been finished. You find it at:<br>
<br>
<a href="http://pgrouting.postlbs.org/wiki/WorkshopOL2.7andOSM" target="_blank">http://pgrouting.postlbs.org/wiki/WorkshopOL2.7andOSM</a><br>
<br>
Best regards, Kai Behncke<br>
<br>
<br>
<br>
<br>
<br>
-------- Original-Nachricht --------<br>
> Datum: Mon, 20 Apr 2009 13:53:44 +0200<br>
> Von: "Kai Behncke" <<a href="mailto:Kai-Behncke@gmx.de">Kai-Behncke@gmx.de</a>><br>
> An: <a href="mailto:pgrouting-users@lists.postlbs.org">pgrouting-users@lists.postlbs.org</a><br>
> Betreff: Re: [pgrouting-users] PgRouting-Problems with own OSM-data<br>
<br>
> Dear users,<br>
><br>
> it works now. I made an extract of osm-data (with osmosis) and used then<br>
> osm2pgrouting.<br>
> Everything excellent now (I haven`t got any clue why it didn`t work with<br>
> the shapefile and<br>
> shp2pgrouting).<br>
><br>
> I`m going to start the workshop (with describing difficulties and so on)<br>
> today at:<br>
><br>
> <a href="http://pgrouting.postlbs.org/wiki/WorkshopOL2.7andOSM" target="_blank">http://pgrouting.postlbs.org/wiki/WorkshopOL2.7andOSM</a><br>
><br>
><br>
> There will be also a section about the data-problem.<br>
><br>
> thank you very much for the support.<br>
><br>
> Best regards, Kai<br>
> -------- Original-Nachricht --------<br>
> > Datum: Mon, 20 Apr 2009 09:49:19 +0200<br>
> > Von: "Kai Behncke" <<a href="mailto:Kai-Behncke@gmx.de">Kai-Behncke@gmx.de</a>><br>
> > An: Anton Patrushev <<a href="mailto:anton@orkney.co.jp">anton@orkney.co.jp</a>>,<br>
> <a href="mailto:pgrouting-users@lists.postlbs.org">pgrouting-users@lists.postlbs.org</a><br>
> > Betreff: Re: [pgrouting-users] PgRouting-Problems with own OSM-data<br>
><br>
> > Hi Anton,<br>
> ><br>
> ><br>
> > I will put it in the Wiki in a couple of hours.<br>
> > Indeed it`s a really interesting topic because meanwhile I found out<br>
> that<br>
> > there a less failures if I take OSM-XML and use osm2pgrouting (the data<br>
> > with the many, many failures were taken from out of a shape via<br>
> shp2pgsql) ,<br>
> > I will do some more tests and set it in the wiki in the afternoon.<br>
> ><br>
> > Best regards, Kai<br>
> > -------- Original-Nachricht --------<br>
> > > Datum: Mon, 20 Apr 2009 10:50:47 +0900<br>
> > > Von: Anton Patrushev <<a href="mailto:anton@orkney.co.jp">anton@orkney.co.jp</a>><br>
> > > An: <a href="mailto:pgrouting-users@lists.postlbs.org">pgrouting-users@lists.postlbs.org</a><br>
> > > Betreff: Re: [pgrouting-users] PgRouting-Problems with own OSM-data<br>
> ><br>
> > > Kai, Steve,<br>
> > ><br>
> > > It sounds like a very good example of data validation and for sure<br>
> > > will be interesting for other users.<br>
> > > Can someone of you please put it to pgRouting wiki?<br>
> > ><br>
> > > Anton.<br>
> > ><br>
> > > On Sat, Apr 18, 2009 at 8:25 PM, Kai Behncke <<a href="mailto:Kai-Behncke@gmx.de">Kai-Behncke@gmx.de</a>><br>
> wrote:<br>
> > > > Dear users,<br>
> > > ><br>
> > > > maybe the following screenshot helps fo find out what is wrong with<br>
> my<br>
> > > geodata:<br>
> > > ><br>
> > > ><br>
> > > > <a href="http://www.selbstverwaltung-bundesweit.de/weird_numbers.png" target="_blank">http://www.selbstverwaltung-bundesweit.de/weird_numbers.png</a><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > > The three numbers (blcak on grey backround) show the gid of the<br>
> > > geometry,the source-id and the target-id.<br>
> > > ><br>
> > > > The blue figure shows the id of the vertices (no dead end) and the<br>
> red<br>
> > > number is the number of the dead-end-vertices.<br>
> > > ><br>
> > > > As you cann see some are correct and some are not.<br>
> > > > This should happen at SELECT assign_vertex_id('my_table', 0.001,<br>
> > > 'the_geom', 'gid');<br>
> > > ><br>
> > > ><br>
> > > > ....but why? I cant`t see the system of that failure?<br>
> > > ><br>
> > > > Best regards, Kai<br>
> > > > -------- Original-Nachricht --------<br>
> > > >> Datum: Sat, 18 Apr 2009 00:57:30 +0200<br>
> > > >> Von: "Kai Behncke" <<a href="mailto:Kai-Behncke@gmx.de">Kai-Behncke@gmx.de</a>><br>
> > > >> An: Stephen Woodbridge <<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>>,<br>
> > > <a href="mailto:pgrouting-users@lists.postlbs.org">pgrouting-users@lists.postlbs.org</a><br>
> > > >> Betreff: Re: [pgrouting-users] PgRouting-Problems with own OSM-data<br>
> > > ><br>
> > > >> Hi Stephen, Hi mailinglist,<br>
> > > >><br>
> > > >> thank you very much for that hint. With that way I was able to find<br>
> > out<br>
> > > >> that there are far too many "dead ends" in my data, so I think this<br>
> > is<br>
> > > the<br>
> > > >> proof that it`s really a data problem?<br>
> > > >><br>
> > > >> <a href="http://www.selbstverwaltung-bundesweit.de/too_many_dead_ends.png" target="_blank">http://www.selbstverwaltung-bundesweit.de/too_many_dead_ends.png</a><br>
> > > >><br>
> > > >> I made this test also with the victoria-data, there everything is<br>
> > > correct.<br>
> > > >><br>
> > > >> To get a step further I work now with a very small dataset (just 35<br>
> > > >> geometries) (as you can see in the screenshot above) but without<br>
> > > success<br>
> > > >> so far.<br>
> > > >><br>
> > > >> >If you have a lot of red dots between segments<br>
> > > >> >that should be joined, you probably need to rebuild your vertices<br>
> > tmp<br>
> > > >> >table with a larger tolerance.<br>
> > > >><br>
> > > >> I did that, I changed 0.001 in<br>
> > > >><br>
> > > >> SELECT assign_vertex_id('auswahl_os', 0.001, 'the_geom', 'gid');<br>
> > > >><br>
> > > >> with the values 0.005, 0.01, 0.05, 0.5, 5, 50 and so on<br>
> > > >><br>
> > > >> The values <50 still show very many "dead ends". If I have higher<br>
> > > values<br>
> > > >> then<br>
> > > >> the amount of vertices in general decreases, so a routing is also<br>
> not<br>
> > > >> possible anymore, you can see it here:<br>
> > > >><br>
> > > >><br>
> > > >> <a href="http://www.selbstverwaltung-bundesweit.de/not_enough_vertices.png" target="_blank">http://www.selbstverwaltung-bundesweit.de/not_enough_vertices.png</a><br>
> > > >><br>
> > > >><br>
> > > >> Maybe the following is a hint:<br>
> > > >><br>
> > > >> If I use<br>
> > > >> SELECT assign_vertex_id('auswahl_os', 0.001, 'the_geom', 'gid');<br>
> > > >><br>
> > > >> with my data I get 54 entries in the vertices_tmp-table.<br>
> > > >> (an extract of the victorie-data (50 geometries) just gives 42<br>
> > entries<br>
> > > in<br>
> > > >> vertices_tmp).<br>
> > > >><br>
> > > >> What could be the reason that I get so many entries mith my data?<br>
> > > >><br>
> > > >> What exactly stands the value 0.001 for?<br>
> > > >><br>
> > > >> I really don`t understand what could be wrong with my geodata :-(<br>
> > > >><br>
> > > >> Might it be possible that someone would have a look to these 54<br>
> > > geometries<br>
> > > >> (4 eyes see more than two) ??<br>
> > > >><br>
> > > >> Puh....if I get it I will really write a huge tutorial in the<br>
> > > >> pgrouting-wiki.<br>
> > > >><br>
> > > >> Best regards, Kai<br>
> > > >><br>
> > > >><br>
> > > >><br>
> > > >> -------- Original-Nachricht --------<br>
> > > >> > Datum: Wed, 15 Apr 2009 13:24:21 -0500<br>
> > > >> > Von: Stephen Woodbridge <<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>><br>
> > > >> > An: Kai Behncke <<a href="mailto:Kai-Behncke@gmx.de">Kai-Behncke@gmx.de</a>><br>
> > > >> > CC: <a href="mailto:pgrouting-users@lists.postlbs.org">pgrouting-users@lists.postlbs.org</a><br>
> > > >> > Betreff: Re: [pgrouting-users] PgRouting-Problems with own<br>
> OSM-data<br>
> > > >><br>
> > > >> > Kai,<br>
> > > >> ><br>
> > > >> > First off you probably need to build some diagnostic tools to<br>
> help<br>
> > > you<br>
> > > >> > understand the problem better, especially to help you determine<br>
> if<br>
> > it<br>
> > > is<br>
> > > >> > a data problem. I find two tools that are easy to build and help<br>
> a<br>
> > > lot.<br>
> > > >> > You can see them in action here:<br>
> > > >> > <a href="http://imaptools.com/leaddog/routing/dd.html" target="_blank">http://imaptools.com/leaddog/routing/dd.html</a><br>
> > > >> > Zoom into a city, open the layerswitcher and select "Just the<br>
> > > Streets"<br>
> > > >> > and "Dead Ends"<br>
> > > >> ><br>
> > > >> > 1) create a mapfile that displays the street segments from the<br>
> > > routing<br>
> > > >> > database and add this as an optional base layer. You might want<br>
> to<br>
> > > add<br>
> > > >> > color oneway streets a different color, but in general keep the<br>
> > > display<br>
> > > >> > simple and probably single pixel lines. You might label the<br>
> > segments<br>
> > > >> > with their UID so you can go back to the database and query them<br>
> in<br>
> > > >> > detail.<br>
> > > >> ><br>
> > > >> > 2) add a column cnt integer to the vertices_tmp table and update<br>
> it<br>
> > > with<br>
> > > >> > the count of segments that reference that node. Maybe something<br>
> > like<br>
> > > >> this:<br>
> > > >> ><br>
> > > >> > alter table vertices_tmp add column cnt integer;<br>
> > > >> > update vertices_tmp set cnt=0;<br>
> > > >> > update vertices_tmp set cnt=cnt+1 where streets.source=id;<br>
> > > >> > update vertices_tmp set cnt=cnt+1 where streets.target=id;<br>
> > > >> ><br>
> > > >> > Now create a mapfile layer for points and display the<br>
> vertices_tmp<br>
> > > >> ><br>
> > > >> > LAYER<br>
> > > >> > NAME "deadends"<br>
> > > >> > TYPE POINT<br>
> > > >> > CONNECTIONTYPE "postgis"<br>
> > > >> > CONNECTION ...<br>
> > > >> > DATA ...<br>
> > > >> > CLASSEXPRESSION "cnt"<br>
> > > >> > CLASS<br>
> > > >> > EXPRESSION "cnt=1"<br>
> > > >> > STYLE<br>
> > > >> > SYMBOL "circle"<br>
> > > >> > SIZE 5<br>
> > > >> > COLOR 255 0 0<br>
> > > >> > END<br>
> > > >> > END<br>
> > > >> > CLASS<br>
> > > >> > EXPRESSION "cnt>2"<br>
> > > >> > STYLE<br>
> > > >> > SYMBOL "circle"<br>
> > > >> > SIZE 3<br>
> > > >> > COLOR 0 255 0<br>
> > > >> > END<br>
> > > >> > END<br>
> > > >> > END<br>
> > > >> ><br>
> > > >> > This will display red dots at dead ends and green dots as good<br>
> > > >> > connections be segments. If you have a lot of red dots between<br>
> > > segments<br>
> > > >> > that should be joined, you probably need to rebuild your vertices<br>
> > tmp<br>
> > > >> > table with a larger tolerance.<br>
> > > >> ><br>
> > > >> > It is very hard to debug a large black box like a router without<br>
> > > having<br>
> > > >> > some tools that can give you some better insight as to what is<br>
> > going<br>
> > > on.<br>
> > > >> ><br>
> > > >> > -Steve<br>
> > > >> ><br>
> > > >><br>
> > > >> --<br>
> > > >> Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate +<br>
> > > >> Telefonanschluss für nur 17,95 Euro/mtl.!*<br>
> > > >><br>
> <a href="http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a" target="_blank">http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a</a><br>
> > > >> _______________________________________________<br>
> > > >> Pgrouting-users mailing list<br>
> > > >> <a href="mailto:Pgrouting-users@lists.postlbs.org">Pgrouting-users@lists.postlbs.org</a><br>
> > > >> <a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a><br>
> > > ><br>
> > > > --<br>
> > > > Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit<br>
> > > allen: <a href="http://www.gmx.net/de/go/multimessenger01" target="_blank">http://www.gmx.net/de/go/multimessenger01</a><br>
> > > > _______________________________________________<br>
> > > > Pgrouting-users mailing list<br>
> > > > <a href="mailto:Pgrouting-users@lists.postlbs.org">Pgrouting-users@lists.postlbs.org</a><br>
> > > > <a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a><br>
> > > ><br>
> > ><br>
> > > _______________________________________________<br>
> > > Pgrouting-users mailing list<br>
> > > <a href="mailto:Pgrouting-users@lists.postlbs.org">Pgrouting-users@lists.postlbs.org</a><br>
> > > <a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a><br>
> ><br>
> > --<br>
> > Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit<br>
> allen:<br>
> > <a href="http://www.gmx.net/de/go/multimessenger01" target="_blank">http://www.gmx.net/de/go/multimessenger01</a><br>
> > _______________________________________________<br>
> > Pgrouting-users mailing list<br>
> > <a href="mailto:Pgrouting-users@lists.postlbs.org">Pgrouting-users@lists.postlbs.org</a><br>
> > <a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a><br>
><br>
> --<br>
> Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate +<br>
> Telefonanschluss für nur 17,95 Euro/mtl.!*<br>
> <a href="http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a" target="_blank">http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a</a><br>
> _______________________________________________<br>
> Pgrouting-users mailing list<br>
> <a href="mailto:Pgrouting-users@lists.postlbs.org">Pgrouting-users@lists.postlbs.org</a><br>
> <a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a><br>
<font color="#888888"><br>
--<br>
Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss für nur 17,95 Euro/mtl.!* <a href="http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a" target="_blank">http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a</a><br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.postlbs.org">Pgrouting-users@lists.postlbs.org</a><br>
<a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a><br>
</font></blockquote></div><br><div><br></div>