<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1321622147;
mso-list-type:hybrid;
mso-list-template-ids:-363136014 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Hi Meagan,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Briefly from City of Abbotsford;<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>I would like to predicate this with the fact that I am <b>not </b>a<b> </b>Geotech…so if any of the geomatic information sounds slightly off, perhaps it is, because I am just a tree guy. I am the end user of the Asset Inventory/Management tool, not the creator. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>TreeKeeper 7 from Davey Resource Group. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>2)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Developed by Davey but customizable internally due to the ability to choose the attributes that we wish to collect. <o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>3)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Both…we input location, species, DBH, utility etc. and then use it to track and produce work orders as per the information we input. For example, it produces work orders for pruning based on the date of installation (1, 3, 5, 7 year cycle). We can alter this cycle by species or location if they require more or less attention. <o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>4)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>There is a spatial map that is created by Davey. We forward our shape files, including an aerial photo yearly to Davey to upgrade the spatial map. The files we include contain house numbers, street names, city grid lines, park boundaries etc.<o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>5)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Our inventory is integrated (duplicated) onto our internal mapping system as an attribute on arcview. It is accessible to view by anyone who has access to arcview, but only Urban Forestry staff, via TreeKeeper have access to the actual information regarding species etc. The view of our inventory on arcview shows location only. Few members of our staff have editing abilities on TreeKeeper to ensure there is no corruption of our data.<o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>6)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>We use Panasonic TOUGHPADS in the field and they are fantastic. We test drove IPads but they were not Microsoft compatible for the Davey TreeKeeper platform (a separate cost was required). We typically only access TreeKeeper in the field to input new installations or check inventory/ownership/property lines, but any application offered by the platform could be used if desired.<o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>7)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>The spatial map on our TOUGHPADS is very accurate. By placing the cursor on the map for tree location, an x-y co-ordinate is created on TreeKeeper as an attribute. This can be used as a measure of location if so desired, but we typically use street address with side or front placement. <o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>8)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Urban Forestry staff, particularly the Street Tree/Park Tree section utilize the program. We are the editors of the information that is stored in the Davey Resource system. Our Geomatic department meshes with Davey to provide them our shape files. We train internally with assistance via conference call with Davey support staff as required. We choose which attributes (which do change as we find some redundant, and others helpful) to include, and are always looking to make things more stream lined and relevant. <o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>9)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>We have looked at bringing the whole program internal with the help from IT and geomatics. This would allow us to customize our own program as we already have all the tools available. I maybe speaking out of line, but I feel sometimes that our geomatic department is not as helpful as they could be. I believe they would like to host this on their own platform and control the information that is being meted out. It makes sense to utilize an internal program, and have the data available to all. The cost to lease the program from Davey would have to be compared to salary dollars required to have internal staff create, monitor and update the platform as required. This would reduce some duplication of data that currently exists.<o:p></o:p></span></p><p class=MsoListParagraph><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>From the ‘Sunny’ left coast….<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:14.0pt;font-family:"Arial","sans-serif";color:black'>Ken Snowden<o:p></o:p></span></b></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#4F6228'>Arbourist II<o:p></o:p></span></b></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>Parks, Recreation & Culture <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>Urban Forestry Section<o:p></o:p></span></p><p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#262626'>Tel:</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#262626'> 604-853 5485 ext. 5886<o:p></o:p></span></p><p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#262626'>Cell: </span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#262626'>604-626 3945<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#404040'><img width=276 height=82 id="Picture_x0020_1" src="cid:image001.jpg@01CF62D7.97AE58B0" alt="Operations Yard"></span><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#4F6228'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#404040'><o:p> </o:p></span></p><p class=MsoNormal><i><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#4F6228'>‘A man does not plant a tree for himself; he plants it for posterity’<o:p></o:p></span></i></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#4F6228'>Alexander Smith<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> CANUFNET [mailto:canufnet-bounces@list.web.net] <b>On Behalf Of </b>Sherry Boerefyn<br><b>Sent:</b> Monday, April 28, 2014 7:25 AM<br><b>To:</b> CANUFNET@list.web.net; meagan.hanna@mail.mcgill.ca<br><b>Subject:</b> Re: [CANUFNET] FW: In-house Tree Management Databases and Big Cities<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>Hi Meagan,<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>Here's an answer from The City of Edmonton.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>2) GEO Media and Davey Tree Keeper were both developed by outside, but were customized by or IT Department.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>7) No GPS. But you can use it for populating data if you like with GEO Media.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>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. <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'>Hope that helps.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Mon, Apr 28, 2014 at 7:32 AM, Jeannette Wheeler <<a href="mailto:jeannette.wheeler@edmonton.ca" target="_blank">jeannette.wheeler@edmonton.ca</a>> wrote:<o:p></o:p></p><div><p class=MsoNormal>Hi Sherry,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Hope you had a good weekend, can you respond back on.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><div><div><p class=MsoNormal><span style='font-family:"Tahoma","sans-serif";color:#38761D'>Thank you</span><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Tahoma","sans-serif";color:#38761D'>Jenny Wheeler P.Biol. </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Tahoma","sans-serif";color:#38761D'>Principal of Forestry</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Tahoma","sans-serif";color:#38761D'>ISA Certified Municipal Arborist</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Tahoma","sans-serif";color:#38761D'><a href="tel:780-442-0224" target="_blank">780-442-0224</a></span><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><i><span style='font-family:"Verdana","sans-serif";color:#38761D'>We Do As We Say</span></i><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt'>---------- Forwarded message ----------<br>From: <b>Meagan Hanna, Miss</b> <<a href="mailto:meagan.hanna@mail.mcgill.ca" target="_blank">meagan.hanna@mail.mcgill.ca</a>><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><o:p></o:p></p><div><div><div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><p class=MsoNormal>Greetings all,<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> <o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>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. <span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>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. <span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>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.<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>My questions are as follows :<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>1) What platform/system does your city use to manage its trees? <span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>2) Is your city's tree database managed through an in-house program or through software developed by an external company or organization? <span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>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?<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>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)?<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>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?<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt'>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? 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><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>7) Do you use GPS equipment in the field to manage tree inspections and correctly position your city's trees?<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt'> If you have gotten this far, first off thank you so much! </span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>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>? <span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>9) Are any of the three abovementioned aspects a problem in your municipality at the moment? <span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>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.<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal>Have a wonderful weekend,<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal>Meg<span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><div><div><div><p class=MsoNormal>Meagan Hanna<o:p></o:p></p></div><div><p class=MsoNormal>Technical Officer - Horticulture and Arboriculture<o:p></o:p></p></div><div><p class=MsoNormal>City of Montreal<o:p></o:p></p></div><div><p class=MsoNormal>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><o:p></o:p></p></div></div></div></div></div></div></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div><p class=MsoNormal><br><br clear=all><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>-- <o:p></o:p></p><div><p class=MsoNormal><b><span style='font-family:"Verdana","sans-serif";color:#990000'>Sherry Boerefyn, LAT</span></b><o:p></o:p></p><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:#990000'>Tree Inventory Coordinator</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:#990000'>Forestry, Beautification & Environmental Services</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:#990000'><a href="tel:%28780%29%20496-4693" target="_blank">(780) 496-4693</a></span><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:#990000'>We are proud to serve the public.</span><o:p></o:p></p></div></div></div></div></div></body></html>