<html><head></head><body><div style="font-family:verdana, helvetica, sans-serif;font-size:13px;"><div style="font-family:verdana, helvetica, sans-serif;font-size:13px;"><div><div>Solutions depend how big is your data. Overpass count function might be the solution if just a one shot calculation. You would have a query for each type.<br><br>If you want to use the power of SQL databases, Sqlite is a «light solution», coupled with the DBeaver database tool.</div><div><a href="https://dbeaver.io/" rel="nofollow" target="_blank" class="">https://dbeaver.io/</a></div><div><br></div><div>I used to parse OSM xml with a Python script, but PostgreSQL + PosGIS offers more long term development options like for the Quality analysis I did on Building geometries (<a href="https://opendatalabrdc.github.io/Blog/index.html#!Database_Quality_Analysis_Tasking_Manager.md" rel="nofollow" target="_blank" class="">https://opendatalabrdc.github.io/Blog/index.html#!Database_Quality_Analysis_Tasking_Manager.md</a>). Osmosis (Osm2Pgsql schema) takes care to import OSM/Xml directly in a PostGIS database. From there, quite easy to count, filter, analyze data.<br></div><div class="ydp23801832signature"><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></div>
<div><br></div><div><br></div>
</div><div id="ydp932484d5yahoo_quoted_8896885031" class="ydp932484d5yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
Le samedi 29 septembre 2018 20 h 02 min 10 s HAE, john whelan <jwhelan0112@gmail.com> a écrit :
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp932484d5yiv9021036028"><div><div>Thank you kind sir. I've got sidetracked into trying to count types of buildings.<div><br clear="none"></div><div>I used to use VB not for its power but for its development interface. So much easier than using assembler which I started with many years ago.</div><div><br clear="none"></div><div>Apparently I need a datatable to sort a couple of columns, fine but all the documentation is for C#. It still has the nice development interface but there are differences.</div><div><br clear="none"></div><div>I know exactly what I want to do but finding the correct syntax makes me feel if you know Perl and it can do the job stay with it.</div><div><br clear="none"></div><div>Thanks John</div></div><br clear="none"><div class="ydp932484d5yiv9021036028yqt0079629154" id="ydp932484d5yiv9021036028yqt32902"><div class="ydp932484d5yiv9021036028gmail_quote"><div dir="ltr">On Sat, 29 Sep 2018, 6:26 pm Frederik Ramm, <<a shape="rect" href="mailto:frederik@remote.org" rel="nofollow" target="_blank">frederik@remote.org</a>> wrote:<br clear="none"></div><blockquote class="ydp932484d5yiv9021036028gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi,<br clear="none">
<br clear="none">
On 29.09.2018 01:59, john whelan wrote:<br clear="none">
> I thank Fredrick for his comments as well. If a more refined solution<br clear="none">
> is required then there is enough information given to make a start coding.<br clear="none">
<br clear="none">
I know Perl isn't what people use these days but just to show that it<br clear="none">
really isn't rocket science (and doesn't require elaborate routing<br clear="none">
engines for that scale) I've made a modified version of the Perl script<br clear="none">
and checked it into the SVN directory. That script will take a .osm data<br clear="none">
file as input and generate a schematic map like<br clear="none">
<br clear="none">
<a shape="rect" href="http://www.remote.org/frederik/tmp/ipswich-busstops.png" rel="nofollow" target="_blank">http://www.remote.org/frederik/tmp/ipswich-busstops.png</a><br clear="none">
<br clear="none">
(which depicts Ipswich), where nodes are coloured according to their<br clear="none">
distance from the nearest bus stop (in this picture, 500 Mercator metres<br clear="none">
or more means something gets red).<br clear="none">
<br clear="none">
Bye<br clear="none">
Frederik<br clear="none">
<br clear="none">
-- <br clear="none">
Frederik Ramm ## eMail <a shape="rect" href="mailto:frederik@remote.org" rel="nofollow" target="_blank">frederik@remote.org</a> ## N49°00'09" E008°23'33"<br clear="none">
<br clear="none">
<br clear="none">
_______________________________________________<br clear="none">
talk mailing list<br clear="none">
<a shape="rect" href="mailto:talk@openstreetmap.org" rel="nofollow" target="_blank">talk@openstreetmap.org</a><br clear="none">
<a shape="rect" href="https://lists.openstreetmap.org/listinfo/talk" rel="nofollow" target="_blank">https://lists.openstreetmap.org/listinfo/talk</a><br clear="none">
</blockquote></div></div></div></div><div class="ydp932484d5yqt0079629154" id="ydp932484d5yqt00684">_______________________________________________<br clear="none">talk mailing list<br clear="none"><a shape="rect" href="mailto:talk@openstreetmap.org" rel="nofollow" target="_blank">talk@openstreetmap.org</a><br clear="none"><a shape="rect" href="https://lists.openstreetmap.org/listinfo/talk" rel="nofollow" target="_blank">https://lists.openstreetmap.org/listinfo/talk</a><br clear="none"></div></div>
</div>
</div></div></body></html>