<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div></div></div><div><br></div><div><a href="https://dl.dropboxusercontent.com/u/4647535/GlebeTrees.pdf">https://dl.dropboxusercontent.com/u/4647535/GlebeTrees.pdf</a></div><div><br></div><div>Cheers,</div><div><br></div><div>Dan Buijs</div><div><br></div><div><br><div><div>On 2014-05-20, at 8:55 PM, Joseph Potvin wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Thanks Tyler. Sounds like a great agenda item for the OGRUG meeting<br>that David Bissessar is talking about organizing.<br><br>Joseph Potvin<br><br>On Tue, May 20, 2014 at 8:03 PM, Tyler Smith <<a href="mailto:tyler@plantarum.ca">tyler@plantarum.ca</a>> wrote:<br><blockquote type="cite">Hi Joseph,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I am a botanist at Agriculture Canada, and also a reasonably experienced R<br></blockquote><blockquote type="cite">user. I am very interested in this project, and would be happy to contribute<br></blockquote><blockquote type="cite">a either a plant biologist, an R coder or both.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">At present I am in the field, and won't be back to Ottawa until the<br></blockquote><blockquote type="cite">beginning of June.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Best,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Tyler<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">On 17/05/14 06:39 PM, Joseph Potvin wrote:<br></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Anyone in the OGRUG community have a bit of time & expertise to share<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">towards advancing data-driven analysis of Ottawa's trees using R?<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Some current discussion is forwarded below.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Note to Daniel and Erwin: OGRUG is the Ottawa-Gatineau R Users Group.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Joseph Potvin<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">---------- Forwarded message ----------<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">From: Daniel Buijs <<a href="mailto:dbuijs@gmail.com">dbuijs@gmail.com</a>><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Date: Sat, May 17, 2014 at 5:48 PM<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Subject: Re: CIty of Ottawa Trees dataset<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">To: Erwin Dreessen <<a href="mailto:erwin_dreessen@ncf.ca">erwin_dreessen@ncf.ca</a>><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Cc: "J. P. Unger" <<a href="mailto:ungerjp@yahoo.com">ungerjp@yahoo.com</a>>, Amy Kempster<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><<a href="mailto:Amykempster@bell.net">Amykempster@bell.net</a>>, "Nicole Desroches (home)"<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><<a href="mailto:nicolepdesroches@gmail.com">nicolepdesroches@gmail.com</a>>, Sol Shuster <<a href="mailto:sshuster@magma.ca">sshuster@magma.ca</a>>,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="mailto:elina.here@hotmail.com">elina.here@hotmail.com</a>, Jason Kania <<a href="mailto:jason.kania@ymail.com">jason.kania@ymail.com</a>>, Joseph<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Potvin <<a href="mailto:jpotvin@opman.ca">jpotvin@opman.ca</a>><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Hi Erwin,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">It would take a bit of work to turn this into an app, and I'm afraid<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">that's a skill set that I don't have at the moment ;) I would be very<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">happy to chat with someone technically inclined who would be<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">interested in turning it into an app, and I could perhaps suggest some<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">more or less straightforward ways to do that.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">The file that the city published is in a format that can be opened by<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Google Earth, but it was just so massive that I stopped waiting for it<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">after an hour or so on my little laptop, so I figured out how to slice<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">it up into smaller pieces with the free software package RStudio<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">(<a href="http://www.rstudio.org">www.rstudio.org</a>). On the most basic level, I can take the 200 MB kml<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">file that's on the City's website and turn it into a simple<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">spreadsheet table that should be fairly straightforward to use in<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">things like Google Maps. The bells and whistles, in terms of<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">colour-coding by species, making the dot size represent tree diameter,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">and overlaying Xs on the ones that are being treated for Emerald Ash<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">borer are things I figured out how to do in R for static PDF<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">documents. I'm sure you could do things like this in a web app, I just<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">don't know how.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">As far as the data itself, my understanding of what the City published<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">is that it's an extract of their internal database that the forestry<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">department uses anyway, so I don't think they have any dedicated<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">resources to publishing it or have committed to any particular update<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">frequency. The date on the dataset is April 2013. I would certainly<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">like to see them update it on some sort of predictable schedule, but<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">my experience with open data at the moment is that you take what you<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">can get and don't ask too many questions. :)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">The City indicates that the dataset includes only city-owned street<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">trees, so no private trees, and none of the city trees in parks or<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">other greenspace. The data they have included is the GPS co-ordinates<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">(which seem to line up with Google maps without any further<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">adjustment, at least in my neighbourhood), the species of tree,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">diameter at breast height (no units given, but I'm guessing in cm),<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Ward, Street Number and Name, location of the tree in relation to the<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">property, location of street trees that aren't associated with a civic<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">address (i.e. medians, etc.), whether the tree is being treated for<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">dutch elm disease or emerald ash borer, and the tree tag number for<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">trees that are being treated.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">No, I'm not working with Kevin. I've only just seen his website, with<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">your note below. I'm certainly happy to share what I've learned with<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">anyone who's interested. I'm afraid I have no particular intent or<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">agenda with this, I really just wanted to find out what kind of tree<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">was kitty-corner to my house and whether the City was going to treat<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">it for Emerald Ash Borer. In retrospect, there were perhaps less<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">onerous ways to do this ;).<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Cheers,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Dan<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">On 2014-05-17, at 3:15 PM, Erwin Dreessen wrote:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Hello Daniel Buijs,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Thanks for this. I knew the City was brewing up various data about<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">the city-owned trees. You're way ahead of me on the technology, but<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">the example you gave, adapting the City's raw data, looks terrific.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">If this app could be made available via our web site, that would be<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">excellent. Jason Kania is your contact if this requires anything<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">special.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Do you believe the City is committed to keeping the data current? Any<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">idea what percent of its resources is going to this?<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">The Tree Canopy project, as I understand it, makes no distinction<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">between public and private trees, nor does it distinguish species. It<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">is only concerned with tree canopy cover.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Are you working with Kevin O'Donnell? (<a href="http://ottwatch.ca/">http://ottwatch.ca/</a>) It would<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">be good to find your app there.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Regards,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Erwin<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">cc: Board, Joseph<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">From: J. P. Unger [mailto:ungerjp@yahoo.com]<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Sent: Friday, May 16, 2014 10:59 PM<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">To: Erwin Dreessen; Amy Kempster; Nicole Desroches (home); Sol<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Shuster; <a href="mailto:elina.here@hotmail.com">elina.here@hotmail.com</a>; 'Jason Kania'<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Subject: Fw: CIty of Ottawa Trees dataset<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Hi!<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">This came in...<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I sent a quick reply with thanks, saying I'd forward it to the chair &<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">directors (cc'ing Joseph Potvin).<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">JP<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">----- Forwarded Message -----<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">From: Daniel Buijs <<a href="mailto:dbuijs@gmail.com">dbuijs@gmail.com</a>><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">To: <a href="mailto:contact@greenspace-alliance.ca">contact@greenspace-alliance.ca</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Cc: <a href="mailto:jpotvin@opman.ca">jpotvin@opman.ca</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Sent: Friday, May 16, 2014 9:43:15 PM<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Subject: CIty of Ottawa Trees dataset<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Hi,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Joseph Potvin forwarded a note about your upcoming meeting where you<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">will discuss the Ottawa Tree Canopy project. I thought you might find<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">it helpful to know (if you didn't already) that the City of Ottawa has<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">published a dataset of City-Owned street trees, available here:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://data.ottawa.ca">data.ottawa.ca</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">It's available as a kml file. I found the kml file a bit too unwieldy,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">so I wrote an R script that can extract the data into a more useful<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">format and intelligible plot. The plot below shows the trees of the<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Glebe, colour coded by species, with dot sizes representing diameter.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Trees marked with an X have been treated for Emerald Ash Borer.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">If this is useful and/or of interest to you or your group, I can share<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">the scripts I used to extract the data and to produce the plot below.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Daniel Buijs<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">---------- Forwarded message ----------<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">From: Erwin Dreessen <<a href="mailto:erwin_dreessen@ncf.ca">erwin_dreessen@ncf.ca</a>><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Date: Thu, May 15, 2014 at 5:50 PM<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Subject: Greenspace Alliance AGM - Thursday, May 29, 7 p.m.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">To: <a href="mailto:green-news@greenspace-alliance.ca">green-news@greenspace-alliance.ca</a>,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Hello Members and Friends,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">You are heartily invited to the Greenspace Alliance's Annual General<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Meeting on Thursday, May 29, 2014, starting at 7 p.m. at the<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Hintonburg Community Centre, 1064 Wellington Street West (Laurel<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Room).<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Our feature presentation will be on Phase 1 of the Ottawa Tree Canopy<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">project. Unfortunately, Regie Alam had to cancel but the project's<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">co-leader, Eric Jones, will present in his stead, assisted by Iola<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Price. This is a citizen science project that is estimating the tree<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">canopy within the urban boundary on a ward basis, using open data and<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">open source tools.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">The agenda is below. Come early (6:45 p.m.) to renew your membership or<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">apply!<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">A brief General Meeting will follow the AGM.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Hope to see many of you there.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Erwin<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">_______________________________________________<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">R-UG-Ottawa mailing list<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="mailto:R-UG-Ottawa@r-project.org">R-UG-Ottawa@r-project.org</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="https://stat.ethz.ch/mailman/listinfo/r-ug-ottawa">https://stat.ethz.ch/mailman/listinfo/r-ug-ottawa</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><br></blockquote><br><br><br>-- <br>Joseph Potvin<br>Operations Manager | Gestionnaire des opérations<br>The Opman Company | La compagnie Opman<br><a href="mailto:jpotvin@opman.ca">jpotvin@opman.ca</a><br>Mobile: 819-593-5983<br></div></blockquote></div><br></div></body></html>