<div dir="ltr"><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">Hi Meagan,</div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">
Here's an answer from The City of Edmonton.</div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">
1) We use a program called GEO Media to input data onto the City's spacial map. GEO Media is similar to ArcView. We are just starting to use Davey Tree Keeper as well as a work management tool.</div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">
<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">2) GEO Media and Davey Tree Keeper were both developed by outside, but were customized by or IT Department.</div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">
<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">3) The attributes collected are customizable. We collect Species, location DBH and other things last pruned date, date planted and near by utilities. You can customize both programs to suite your needs.</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">4) Both programs use spatial maps and we add our aerial photos. We use these photos to populate the tree location. We find that works as well as GPS.</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">5) Our data is accessible to all GEO Media users in the city, but 311 is not a user. It could be accessed on our Open Data site by anyone, including the public.</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">6) Geo Media is accessed in the field by the Tree Inventory staff. Davey Tree Keeper can be accessed by all City staff with wifi and a login to our page. The Inventory team prefers a laptop and others use tablets like iPad.</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">7) No GPS. But you can use it for populating data if you like with GEO Media.</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">8) Our IT department is responsible for all things GEO Media in Edmonton. The areas using the program train their users. We are mandated to load all data onto a SLIM map. We all have read access to each other's data. Davey Tree Keeper IT dept. worked with ours to mesh up the attributes.</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">9) Over the past 3 years we have sometimes struggled to get our projects done with the huge volume of work our IT dept. handles. Sometimes, what they wanted to charge us was outside our tiny Forestry budget. But generally out IT people work hard to get us what we need. Davey Tree Keeper staff are very available. </div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">The reason we are using 2 systems (data is synced each night) is for their different abilities. GEO Media has the ability to run multiple queries of data at the same time and you can create maps on it. Davey is more of a work management system. They also have a new app that looks promising for field staff.</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">Hope that helps.</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">
<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;color:#0000ff">
<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Apr 28, 2014 at 7:32 AM, Jeannette Wheeler <span dir="ltr"><<a href="mailto:jeannette.wheeler@edmonton.ca" target="_blank">jeannette.wheeler@edmonton.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Sherry,<div><br></div><div>Hope you had a good weekend, can you respond back on.</div><div><br></div>
<div><div><div><div dir="ltr"><font face="tahoma, sans-serif" color="#38761d">Thank you</font><div><font face="tahoma, sans-serif" color="#274e13"><br>
</font></div><div><font face="tahoma, sans-serif" color="#38761d">Jenny Wheeler P.Biol. </font></div><div><font face="tahoma, sans-serif" color="#38761d">Principal of Forestry</font></div><div><font face="tahoma, sans-serif" color="#38761d">ISA Certified Municipal Arborist</font></div>
<div><font face="tahoma, sans-serif" color="#38761d"><a href="tel:780-442-0224" value="+17804420224" target="_blank">780-442-0224</a></font></div><div><font face="tahoma, sans-serif" color="#38761d"><br></font></div><div>
<font face="verdana, sans-serif" color="#38761d"><i>We Do As We Say</i></font></div>
<div><br></div></div></div>
<br><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Meagan Hanna, Miss</b> <span dir="ltr"><<a href="mailto:meagan.hanna@mail.mcgill.ca" target="_blank">meagan.hanna@mail.mcgill.ca</a>></span><br>
Date: Sat, Apr 26, 2014 at 11:29 AM<br>Subject: [CANUFNET] FW: In-house Tree Management Databases and Big Cities<br>To: "<a href="mailto:CANUFNET@list.web.net" target="_blank">CANUFNET@list.web.net</a>" <<a href="mailto:CANUFNET@list.web.net" target="_blank">CANUFNET@list.web.net</a>><br>
<br><br>
<div>
<div style="direction:ltr;font-size:10pt;font-family:Tahoma">
<div style="font-size:16px;font-family:Times New Roman">
<div style="direction:ltr"><br>
</div>
<div></div>
<div>
<div style="direction:ltr;font-size:10pt;font-family:Tahoma"><font face="Times New Roman" size="3">Greetings all,</font>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">I see that Jessica Tivy had recently put out a question on tree inventory technology and trends in Canada. I actually have a similar inquiry of my own. In fact, I have a set of precise questions about tree inventories
in large Canadian (and American, for any neighbours on the line) cities. I am hoping to touch base with a few municipal practitioners with the goal of obtaining more information on how large cities manage their trees. </font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">To be brief, I would like to draw some comparisons between the City of Montreal's in-house, Oracle system and tree databases from other big cities. To achieve this, I am interested in discussing specific programs with
you. I am on the look-out for resource people who wouldn't mind offering some time for an email or telephone call. </font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">If you're feeling generous, you may contact me directly by email at <a href="mailto:meagan.hanna@mail.mcgill.ca" target="_blank">meagan.hanna@mail.mcgill.ca</a>. Alternatively, if you feel some of this info could be useful for all, feel free to share your comments with the group.</font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">My questions are as follows :</font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">1) What platform/system does your city use to manage its trees? </font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">2) Is your city's tree database managed through an in-house program or through software developed by an external company or organization? </font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">3) Does this program cover location, species, size class and other characteristics only or do you use it to manage your work orders, services requests and summaries of activities as well?</font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">4) Is there a geo-spatial component too? (ex: can you position and view your city's trees on a spatial database/computer-based map)?</font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">5) Is your tree inventory kept in a stand alone program or is this information integrated with other programs such as your city's mapping data, asset management system or work management system (311 call log, service
request follow-up etc.) ? Basically, does your tree database interface with other programs or is it independent from all?</font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><span style="font-family:'Times New Roman';font-size:medium">6) Do your city's inspectors, arborists or foresters have access to the database while in the field through a portable computer, tablet or other device? </span><span style="font-family:'Times New Roman';font-size:medium">If
so, can you respond to citizen requests and generate work orders in the field or do you have to complete those steps and close your ticket once back at the office? </span></div>
<div><span style="font-family:'Times New Roman';font-size:medium"><br>
</span></div>
<div><font face="Times New Roman" size="3">7) Do you use GPS equipment in the field to manage tree inspections and correctly position your city's trees?</font></div>
<div><span style="font-family:'Times New Roman';font-size:medium"><br>
</span></div>
<div><span style="font-family:'Times New Roman';font-size:medium"> If you have gotten this far, first off thank you so much! </span></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">8) Second, if your city uses software to manage its trees, I would love to know how your city manages this program. Which department(s) is (are) responsible for<i> training</i>,
<i>troubleshooting</i> and <i>development</i>? </font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">9) Are any of the three abovementioned aspects a problem in your municipality at the moment? </font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">I know this email was a whopper. Thanks for taking the time to read it. I am looking forward to your feedback and hope to be in touch with you.</font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">Have a wonderful weekend,</font></div>
<div><font face="Times New Roman" size="3">Meg</font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><br>
</div>
<div>
<div>
<div><font face="Times New Roman" size="3">
<div>Meagan Hanna</div>
<div>Technical Officer - Horticulture and Arboriculture</div>
<div>City of Montreal</div>
<div>Work email : <a href="mailto:meagan.hanna@ville.montreal.qc.ca" target="_blank">meagan.hanna@ville.montreal.qc.ca</a><br>
Personal email : <a href="mailto:meagan.hanna@mail.mcgill.ca" target="_blank">meagan.hanna@mail.mcgill.ca</a></div>
</font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div><br></div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><font face="verdana, sans-serif" color="#990000"><b>Sherry Boerefyn, LAT</b></font><div><font face="verdana, sans-serif" color="#990000">Tree Inventory Coordinator</font></div>
<div><font face="verdana, sans-serif" color="#990000">Forestry, Beautification & Environmental Services</font></div><div><font face="verdana, sans-serif" color="#990000"><a href="tel:%28780%29%20496-4693" value="+17804964693" target="_blank">(780) 496-4693</a></font></div>
<div><font face="verdana, sans-serif" color="#990000"><br>
</font></div><div><font color="#990000" face="verdana, sans-serif">We are proud to serve the public.</font></div></div>
</div></div>