<div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Hi All, <br></div><div>I found the combo of overpass and qGIS was a really good combo specifically for this sort of thing. Then you could export into R if you wanted to run stats (qGIS has a pretty good stats engine too) <br></div><div>All you'd have to enter is the building tag as a search, and it'll return the results. <br></div><div><br></div><div>The web interface would be even faster for a non-GIS-er and you could dump it all into a nice .CSV. <br></div><div><br></div><div><br></div><div></div><div>There's a few quick tutorials under 10 minutes that should get ya up to speed. <br></div><div><a href="https://vimeo.com/189554102">https://vimeo.com/189554102</a></div><div><a href="https://wiki.openstreetmap.org/wiki/Overpass_turbo">https://wiki.openstreetmap.org/wiki/Overpass_turbo</a></div><div>and I'm by no means a "Ph. D " in OSM :) <br></div><div><br></div><div>Happy Mapping, <br></div><div>Keith <br></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Thu, Sep 13, 2018 at 7:01 AM <<a href="mailto:talk-ca-request@openstreetmap.org">talk-ca-request@openstreetmap.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Talk-ca mailing list submissions to<br>
<a href="mailto:talk-ca@openstreetmap.org" target="_blank">talk-ca@openstreetmap.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.openstreetmap.org/listinfo/talk-ca" rel="noreferrer" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ca</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:talk-ca-request@openstreetmap.org" target="_blank">talk-ca-request@openstreetmap.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:talk-ca-owner@openstreetmap.org" target="_blank">talk-ca-owner@openstreetmap.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Talk-ca digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. counting buildings - ( 2020 project ) - help please. (john whelan)<br>
2. Re: counting buildings - ( 2020 project ) - help please.<br>
(OSM Volunteer stevea)<br>
3. Re: counting buildings - ( 2020 project ) - help please.<br>
(john whelan)<br>
4. Re: counting buildings - ( 2020 project ) - help please.<br>
(OSM Volunteer stevea)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 12 Sep 2018 13:39:34 -0400<br>
From: john whelan <<a href="mailto:jwhelan0112@gmail.com" target="_blank">jwhelan0112@gmail.com</a>><br>
To: HOT <<a href="mailto:hot@openstreetmap.org" target="_blank">hot@openstreetmap.org</a>>, Talk-CA OpenStreetMap<br>
<<a href="mailto:talk-ca@openstreetmap.org" target="_blank">talk-ca@openstreetmap.org</a>><br>
Subject: [Talk-ca] counting buildings - ( 2020 project ) - help<br>
please.<br>
Message-ID:<br>
<CAJ-Ex1G9Ci2=cU6=<a href="mailto:uJzfw0LiLGHNtfCQhQOj9g-mSf6Oo7j_Jw@mail.gmail.com" target="_blank">uJzfw0LiLGHNtfCQhQOj9g-mSf6Oo7j_Jw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
One problems with this mapping project is it is difficult to see how many<br>
have been mapped.<br>
<br>
<a href="https://wiki.openstreetmap.org/wiki/WikiProject_Canada/Building_Canada_2020" rel="noreferrer" target="_blank">https://wiki.openstreetmap.org/wiki/WikiProject_Canada/Building_Canada_2020</a><br>
<br>
So I've been playing. The .OSM data structure does not lend it self easily<br>
to this sort of thing. In particular you don't know when you read a line<br>
in if you want to count it or not. The critical thing is does the way<br>
include building= if it does then we are interested in every tag even those<br>
that have been read in previously.<br>
<br>
I started following Bjenk's footsteps with R but realistically setting up<br>
the environment and parsing the file in R isn't that user friendly.<br>
<br>
So I dropped back to Visual Studio express which is free from Microsoft.<br>
I've been working in the IDE environment and I have something that counts<br>
ways at the moment. Extending it to nodes is relatively simple once I have<br>
the ways working correctly.<br>
<br>
A very small sample output is below.<br>
<br>
<br>
detached' - 3<br>
t2' - 2<br>
terraced' - 1<br>
<br>
<br>
addr:housenumber - 6<br>
addr:street - 6<br>
building:levels - 5<br>
addr:postcode - 3<br>
roof:shape - 1<br>
<br>
####<br>
<br>
I've just spotted that building types have an extra ' in the name. The<br>
Comma Separated Values (CSV) were working so they can be fed into a<br>
spreadsheet or some sort of stats program and 'Real Soon Now'™ it will be<br>
working once more.<br>
<br>
The input is an .osm file so download and chop it up with OSMconvert64 to<br>
give the area you are interested in. I have sample .bat files available<br>
that do this.<br>
<br>
What I need is someone who has use for the information to look it over and<br>
give feedback. Please contact me directly not through the group.<br>
<br>
Many Thanks<br>
<br>
Cheerio John<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.openstreetmap.org/pipermail/talk-ca/attachments/20180912/ef0ffcb9/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.openstreetmap.org/pipermail/talk-ca/attachments/20180912/ef0ffcb9/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 12 Sep 2018 10:55:19 -0700<br>
From: OSM Volunteer stevea <<a href="mailto:steveaOSM@softworkers.com" target="_blank">steveaOSM@softworkers.com</a>><br>
To: john whelan <<a href="mailto:jwhelan0112@gmail.com" target="_blank">jwhelan0112@gmail.com</a>>, talk-ca<br>
<<a href="mailto:talk-ca@openstreetmap.org" target="_blank">talk-ca@openstreetmap.org</a>><br>
Subject: Re: [Talk-ca] counting buildings - ( 2020 project ) - help<br>
please.<br>
Message-ID: <<a href="mailto:642BD244-73A9-4CA7-ABBE-D6BE7BB1F323@softworkers.com" target="_blank">642BD244-73A9-4CA7-ABBE-D6BE7BB1F323@softworkers.com</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Whew, seems like overkill. Try "overpass turbo" (OT) for such queries. Here is a sample, and the query language (OverPass QL) is text-based and OSM-friendly, as it uses the tags you're searching for:<br>
<br>
<a href="http://overpass-turbo.eu/s/BQ6" rel="noreferrer" target="_blank">http://overpass-turbo.eu/s/BQ6</a><br>
<br>
When it dialogs that the query will return a lot of data, click the "continue anyway" button and wait a few seconds. The data are returned visually and you can export them in various formats (raw OSM data, GeoJSON, GPX, KML). Look to the left column to see how easy the tags are and read our wiki on OT for rich and rewarding documentation.<br>
<br>
Have fun,<br>
<br>
SteveA<br>
California<br>
<br>
> On Sep 12, 2018, at 10:39 AM, john whelan <<a href="mailto:jwhelan0112@gmail.com" target="_blank">jwhelan0112@gmail.com</a>> wrote:<br>
(a lot about how hard it is to query our data).<br>
<br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Wed, 12 Sep 2018 14:06:31 -0400<br>
From: john whelan <<a href="mailto:jwhelan0112@gmail.com" target="_blank">jwhelan0112@gmail.com</a>><br>
To: OSM Volunteer stevea <<a href="mailto:steveaOSM@softworkers.com" target="_blank">steveaOSM@softworkers.com</a>><br>
Cc: Talk-CA OpenStreetMap <<a href="mailto:talk-ca@openstreetmap.org" target="_blank">talk-ca@openstreetmap.org</a>><br>
Subject: Re: [Talk-ca] counting buildings - ( 2020 project ) - help<br>
please.<br>
Message-ID:<br>
<<a href="mailto:CAJ-Ex1GeE0Sk2eH7PtWJc4W4eZt%2BkMuoLoys7aR_nYutqFX4xw@mail.gmail.com" target="_blank">CAJ-Ex1GeE0Sk2eH7PtWJc4W4eZt+kMuoLoys7aR_nYutqFX4xw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
One of the requirements was to create something that did not require an<br>
Internet connection or a Ph.D. in OpenStreetMap jargon.<br>
<br>
Another was the ability to combine the information with other data.<br>
<br>
As I mentioned I'm after end users rather than OSM technically<br>
knowledgeable ones.<br>
<br>
Thank you for your thoughts and hopefully the answers will clarify what<br>
sort of assistance I'm after.<br>
<br>
Cheerio John<br>
<br>
On Wed, 12 Sep 2018, 1:55 pm OSM Volunteer stevea, <<br>
<a href="mailto:steveaOSM@softworkers.com" target="_blank">steveaOSM@softworkers.com</a>> wrote:<br>
<br>
> Whew, seems like overkill. Try "overpass turbo" (OT) for such queries.<br>
> Here is a sample, and the query language (OverPass QL) is text-based and<br>
> OSM-friendly, as it uses the tags you're searching for:<br>
><br>
> <a href="http://overpass-turbo.eu/s/BQ6" rel="noreferrer" target="_blank">http://overpass-turbo.eu/s/BQ6</a><br>
><br>
> When it dialogs that the query will return a lot of data, click the<br>
> "continue anyway" button and wait a few seconds. The data are returned<br>
> visually and you can export them in various formats (raw OSM data, GeoJSON,<br>
> GPX, KML). Look to the left column to see how easy the tags are and read<br>
> our wiki on OT for rich and rewarding documentation.<br>
><br>
> Have fun,<br>
><br>
> SteveA<br>
> California<br>
><br>
> > On Sep 12, 2018, at 10:39 AM, john whelan <<a href="mailto:jwhelan0112@gmail.com" target="_blank">jwhelan0112@gmail.com</a>> wrote:<br>
> (a lot about how hard it is to query our data).<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.openstreetmap.org/pipermail/talk-ca/attachments/20180912/576c3e07/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.openstreetmap.org/pipermail/talk-ca/attachments/20180912/576c3e07/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Wed, 12 Sep 2018 11:28:41 -0700<br>
From: OSM Volunteer stevea <<a href="mailto:steveaOSM@softworkers.com" target="_blank">steveaOSM@softworkers.com</a>><br>
To: john whelan <<a href="mailto:jwhelan0112@gmail.com" target="_blank">jwhelan0112@gmail.com</a>>, talk-ca<br>
<<a href="mailto:talk-ca@openstreetmap.org" target="_blank">talk-ca@openstreetmap.org</a>><br>
Subject: Re: [Talk-ca] counting buildings - ( 2020 project ) - help<br>
please.<br>
Message-ID: <<a href="mailto:5CED8904-6EBC-4ADA-9870-166386493B1D@softworkers.com" target="_blank">5CED8904-6EBC-4ADA-9870-166386493B1D@softworkers.com</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
On Sep 12, 2018, at 11:06 AM, john whelan <<a href="mailto:jwhelan0112@gmail.com" target="_blank">jwhelan0112@gmail.com</a>> wrote:<br>
> One of the requirements was to create something that did not require an Internet connection<br>
<br>
OK, yet I had no way of knowing that from your post. Though, that is an "interesting" requirement for a crowdsourced, Internet-based map database.<br>
<br>
> or a Ph.D. in OpenStreetMap jargon.<br>
<br>
C'mon, John, I'm offering earnest help with a powerful tool familiar to a great many OSM users and a drop-dead-simple query whose guts are:<br>
<br>
{{geocodeArea:Ottawa}}->.searchArea;<br>
(way["building"="residential"](area.searchArea););<br>
<br>
That's pretty much it, and you get your results in seconds visually or in various export formats.<br>
<br>
> As I mentioned I'm after end users rather than OSM technically knowledgeable ones.<br>
<br>
By substituting "node" for "way" or other text-strings for the keys or values you're looking for, and with a multitude of output formats, this is not Ph.D.-level stuff: it is designed to easily query OSM data, returning results in familiar "map/visually" OR well-known geo datafile formats. It isn't jargon-y, it IS used by "end users" and by OSM technically knowledgeable ones alike. Using OSM data? (Yes, you are): use OSM-based tools. You want jargon, use R. I'm trying to help create light, not heat.<br>
<br>
> Another was the ability to combine the information with other data.<br>
<br>
Export the results of OT queries, and ye shall.<br>
<br>
> Thank you for your thoughts and hopefully the answers will clarify what sort of assistance I'm after.<br>
<br>
You are welcome, and I'll be curious to watch what happens. As I saw your request for feedback is to be off-list, we who are on-list (I speak for myself right here) appreciate hearing of any fruit your query may bear.<br>
<br>
Best regards,<br>
SteveA<br>
<br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
Talk-ca mailing list<br>
<a href="mailto:Talk-ca@openstreetmap.org" target="_blank">Talk-ca@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-ca" rel="noreferrer" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ca</a><br>
<br>
<br>
------------------------------<br>
<br>
End of Talk-ca Digest, Vol 127, Issue 8<br>
***************************************<br>
</blockquote></div>