<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:13px"><div id="yui_3_16_0_1_1446035743875_20004" dir="ltr">My OSMPlanetStats script provides profile statistics of a Planet File or simple an Overpass Query output. This provides number of relations, ways and nodes classified with the main tag of the objects (the feature that it represent such as higway, building, amenity, etc). It also provide distance statistics (km of highways). If you dig in the results, you can then see Distance stats for roads classified by the type of road.<br></div><div id="yui_3_16_0_1_1446035743875_20176" dir="ltr"><br></div><div id="yui_3_16_0_1_1446035743875_20237" dir="ltr">Note that the script actually only accept as input an osm.bz2 file. The csv output file let's analyze the result in a spreadsheet. <br></div><div id="yui_3_16_0_1_1446035743875_20145" dir="ltr"><br></div><div id="yui_3_16_0_1_1446035743875_20082" dir="ltr">see <a id="yui_3_16_0_1_1446035743875_20107" href="https://github.com/pierzen/OsmPlanetStats">https://github.com/pierzen/OsmPlanetStats</a><br></div><div id="yui_3_16_0_1_1446035743875_19944"><span></span></div><div id="yui_3_16_0_1_1446035743875_20052"> </div><div id="yui_3_16_0_1_1446035743875_19934" class="signature"><span style="font-style:italic;color:rgb(0, 0, 191);font-weight:bold;"> <br><font face="garamond, new york, times, serif">Pierre </font><br></span></div><br> <div id="yui_3_16_0_1_1446035743875_19943" style="font-family: verdana, helvetica, sans-serif; font-size: 13px;"> <div id="yui_3_16_0_1_1446035743875_19942" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1446035743875_19941" dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">De :</span></b> joost schouppe <joost.schouppe@gmail.com><br> <b><span style="font-weight: bold;">À :</span></b> César Martínez Izquierdo <cesar.izq@gmail.com> <br><b><span style="font-weight: bold;">Cc :</span></b> OSM Talk <talk@openstreetmap.org> <br> <b><span style="font-weight: bold;">Envoyé le :</span></b> Lundi 26 octobre 2015 11h46<br> <b><span style="font-weight: bold;">Objet :</span></b> Re: [OSM-talk] Activity statistics per city (or region)<br> </font> </div> <div class="y_msg_container"><br><div id="yiv9621453320"><div><div dir="ltr">Cesar,<div><br clear="none"></div><div>If you are interested in road network completeness, you need road network length evolution. You can tell a network is getting completed as the network length levels out. An example in relatively complete Flanders:</div><div>As you can see here: <a rel="nofollow" shape="rect" target="_blank" href="http://i.imgur.com/2hxAXNk.gif">http://i.imgur.com/2hxAXNk.gif</a> main roads and minor roads (unclassified, residential) near completion, but slow roads and other roads keep growing.</div><div>As you say, recency only really becomes an issue for a road network once it has been completed. So only when total length has been relatively flat for a while, do you really need to look at this too.</div><div><br clear="none"></div><div>With the OSM history importer and some SQL query you can get these length statistics out of the data.</div><div><br clear="none"></div><div>Of course, as the road network comes of age, a lot of extra info gets tagged, like turn restrictions (these are relations, so harder to get evolution), pedestrian crossings, traffic, lights, etc.</div><div><br clear="none"></div><div><br clear="none"></div><div><br clear="none"></div><div><br clear="none"></div></div><div class="yiv9621453320gmail_extra"><br clear="none"><div class="yiv9621453320gmail_quote">2015-10-26 10:52 GMT+01:00 César Martínez Izquierdo <span dir="ltr"><<a rel="nofollow" shape="rect" ymailto="mailto:cesar.izq@gmail.com" target="_blank" href="mailto:cesar.izq@gmail.com">cesar.izq@gmail.com</a>></span>:<br clear="none"><div class="qtdSeparateBR"><br><br></div><div class="yiv9621453320yqt7089252068" id="yiv9621453320yqt58837"><blockquote class="yiv9621453320gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><span class="yiv9621453320">On 26 October 2015 at 10:28, Mateusz Konieczny <<a rel="nofollow" shape="rect" ymailto="mailto:matkoniecz@gmail.com" target="_blank" href="mailto:matkoniecz@gmail.com">matkoniecz@gmail.com</a>> wrote:<br clear="none">
> "provides access to existing users" - I am not sure what you want. Who<br clear="none">
> was last to edit given element? List of all user accounts? List of users<br clear="none">
> active in a given region? Something else?<br clear="none">
<br clear="none">
</span>I mean for instance list of all users and its declared location<br clear="none">
(assuming that this is a poor indicator: we tend to sometimes edit in<br clear="none">
remote places, declared location may be outdated, etc).<br clear="none">
<span class="yiv9621453320"><br clear="none">
> Also - counting all nodes will give poor result. Place with massive<br clear="none">
> amount of outdated data with dead community that used to be active will<br clear="none">
> score highly. Place with new, highly active community will score<br clear="none">
> poorly. At least, one should count only new/recently modified<br clear="none">
> ways/nodes/elements.<br clear="none">
<br clear="none">
</span>Total nodes may be a good indicator for completeness, while recent<br clear="none">
nodes may be useful for assessing the activity of the community. I am<br clear="none">
interested on both indicators.<br clear="none">
<br clear="none">
On the other hand, I believe recent nodes may be a misleading<br clear="none">
indicator on regions where the DB is quite complete (I am interested<br clear="none">
specifically about highway=*) and there is little urbanization<br clear="none">
activity. Of course, there is always some corrections to do on any<br clear="none">
area, but probably they are statistically negligible compared with a<br clear="none">
region which still has lot of unmapped roads.<br clear="none">
<span class="yiv9621453320HOEnZb"><font color="#888888"><br clear="none">
César<br clear="none">
</font></span><span class="yiv9621453320im yiv9621453320HOEnZb"><br clear="none">
<br clear="none">
<br clear="none">
--<br clear="none">
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br clear="none">
César Martínez Izquierdo<br clear="none">
GIS developer<br clear="none">
- - - - - - - - - - - - - - - - - - - -<br clear="none">
Blog: <a rel="nofollow" shape="rect" target="_blank" href="http://geotechnotes.wordpress.com/">http://geotechnotes.wordpress.com/</a><br clear="none">
ETC-SIA: <a rel="nofollow" shape="rect" target="_blank" href="http://sia.eionet.europa.eu/">http://sia.eionet.europa.eu/</a><br clear="none">
Universitat Autònoma de Barcelona (SPAIN)<br clear="none">
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br clear="none">
<br clear="none">
</span><div class="yiv9621453320HOEnZb"><div class="yiv9621453320h5">_______________________________________________<br clear="none">
talk mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:talk@openstreetmap.org" target="_blank" href="mailto:talk@openstreetmap.org">talk@openstreetmap.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="https://lists.openstreetmap.org/listinfo/talk">https://lists.openstreetmap.org/listinfo/talk</a><br clear="none">
</div></div></blockquote></div></div><br clear="none"><br clear="all"><div><br clear="none"></div>-- <br clear="none"><div class="yiv9621453320gmail_signature"><div dir="ltr"><div><div dir="ltr">Joost @</div><div dir="ltr"><a rel="nofollow" shape="rect" target="_blank" href="http://www.openstreetmap.org/user/joost%20schouppe/">Openstreetmap</a> | <a rel="nofollow" shape="rect" target="_blank" href="https://twitter.com/joostjakob">Twitter</a> | <a rel="nofollow" shape="rect" target="_blank" href="https://www.linkedin.com/pub/joost-schouppe/48/939/603">LinkedIn</a> | <a rel="nofollow" shape="rect" target="_blank" href="http://www.meetup.com/OpenStreetMap-Belgium/members/97979802/">Meetup</a> | <a rel="nofollow" shape="rect" target="_blank" href="https://www.reddit.com/u/joostjakob">Reddit</a> | <a rel="nofollow" shape="rect" target="_blank" href="https://joostschouppe.wordpress.com/">Wordpress</a></div></div></div></div>
</div></div></div><br><div class="yqt7089252068" id="yqt29914">_______________________________________________<br clear="none">talk mailing list<br clear="none"><a shape="rect" ymailto="mailto:talk@openstreetmap.org" href="mailto:talk@openstreetmap.org">talk@openstreetmap.org</a><br clear="none"><a shape="rect" href="https://lists.openstreetmap.org/listinfo/talk" target="_blank">https://lists.openstreetmap.org/listinfo/talk</a><br clear="none"></div><br><br></div> </div> </div> </div></body></html>