Loading...
HomeMy WebLinkAbout4. GIS Update Lf, b. I (P. ~ CITY OF SHAKOPEE Memorandum TO: Mayor & City Council Mark McNeill, City Administrator FROM: Bruce Loney, Public Works Director SUBJECT: Public Works Workshop Items DATE: March 24, 2009 INTRODUCTION: The Public Works Department would like to update and/or discuss three areas with these being a GIS update on Public Works Activities, various Policies and a Public Works Organizational Study. BACKGROUND: I GIS UPDATE I Staff would like to inform the City Council and the Telecommunication Advisory Committee (T AC) of the progress made to date and how the R&D funds from the T AC have been utilized. The Public Works Department started developing the GIS system in 2006 by hiring WSB & Associates, Inc. to design the system and to be the GIS Coordinator. In November, 2007 a GIS Specialist was hired to begin implementation of many of the day to day tasks. In 2008 and into 2009, progress is being made with the GIS web server implementation project to replace LOGIS MAP with an internal web based GIS server. A presentation will be made by staff to show the progress on how GIS is being used in the managing the assets in parks, street, sewer and surface drainage systems. I POLICIES I In the second item of discussion, staff would like to update Council on the various policies being developed for Public Works activities. These policies are as follows: . Street Sweeping Policy . Sidewalk/Trail Policy . Tree Maintenance Plan . Storm Drainage System Maintenance Policy ",A,' . The Street Sweeping Policy is attached and is a result of staff s investigation of adding a second sweeper. Previously, a second sweeper was included in the Capital Equipment List in 2008 and Council directed staff to investigate the options of purchase, renting, leasing and contracting. Mike Hullander will present the results of the study and staff s determination on how much sweeping is recommended. Previously, on July 24, 2008, a report prepared by the Minnesota Local Road Research Board (LRRB) was given to Council as information on sweeping practices. Staff utilized this report extensively for the preparation ofthe Draft Street Sweeping Policy. Conclusions from the year long study on sweeping and sweeper options are a follows: 1. The City is not doing as much sweeping as recommended by the LRRB report. Currently we sweep every street two times a year and the downtown every week. 2. The best option for the City is to purchase, as the cost analysis done by Mike Hullander indicates the City is cost effective to contracting rates and renting or leasing is not an option with Regenerative Air Sweepers. Items for discussion will be if the draft policy is acceptable or if there are changes that would be recommended. To meet the frequencies listed, a second sweeper would be needed. Also, discussion on the cost analysis for a Regenerative Air sweeper which is being recommended. I SIDEW ALK/TRAIL POLICY I This policy has been updated from the November 25, 2008 meeting to include trails. Mike Hullander will present the draft. I TREE MAINTENANCE POLICY I Staff will update the Council on the progress for a maintenance plan and the tasks done already, namely the tree inventory. It is staffs intent to have a plan with criteria and policy prepared this year. Mike Hullander will present the plan progress to date. I STORM DRAINAGE SYSTEM MAINTENANCE POLICY I Finally, the Storm Drainage System Maintenance Policy is a policy to guide staff on inspection and maintenance activities on various storm water facilities. Attached is a draft policy that has been formulated utilizing a LRRB on Stormwater Maintenance, BMP Resource Guide. Staff will present its preliminary findings and the policy will be useful in scheduling maintenance activities and for reporting requirements associated with the National Pollution Discharge Elimination System (NPDES) program. Staff would appreciate any feedback on the policies being presented. I 2009 PUBLIC WORKS ORGANIZATIONAL STUDY I Finally, staff would like to present the findings of the 2009 Public Works Organizational Study. Staff authorized a $2,000.00 study to review the Public Works Maintenance and Operations Divisions, particularly in the area of structure to meet the demands ofthe department. Staff in 2003, had SEH prepare a thorough study with 17 recommendations. Attached to this memo is a memo, dated February 11,2009, with an update on the recommendations. As can be noted, many of the recommendations have been completed. The purpose of the 2009 update study by SEH was to review the Public Works Organizational Study. Staff has utilized temporary leads for three years to assist the supervisors in managing areas or in their absence. Attached to this memo is the update study for 2009 and the study has eight priority recommendations and six consideration recommendations for staff and Council to consider. The main priority recommendation is for the City to consider permanent crew leads/foreman positions to support management in managing crews, documentation and monitor various activities. Three organizational charts were prepared and included in the study. Staff will present the recommendations and the three organizational charts for discussion, with a recommendation for 2009 to use temporary lead assignments from April 15 to October 15. Hiring four leads for six months has an estimated cost of $6,500.00 and sufficient funds exist in the street, fleet, park and utilities budgets. ACTION REQUESTED: Discuss the various items in the Public works Department and provide comments/direction. ~e*;( Public Works Director BUpmp ENGR/2009-PROJECTS/2009-COUNCIUWORKSHOP-ITEMS --- - - -- -- -- - - -- - - -- - --- -- -- --- - -- --- --- -- '> ~.~ - ~~ :::r- Q -t Q.~ ":s ~~ ~t., 3"" o~ ~ '2.- I --- --- ----- GIS and Asset Management I Ul2date I I . - - - ~7 i A I WSB I I I SHAKOPEE & Associates, Inc. -- - ----- -- ------ - --- ---- - -- ---- -- -- -- -- - Outline -- - . Overview . Review 2008 activities . Examples of output . Overview of 2009 work plan . Questions -~ ---- GIS and AMS Overview . --- . GIS is a computerized system for managing, analyzing, and displaying all forms of geographically I referenced information . AMS is a computerized system to: 0 Track estimated and actual costs 0 Predict asset performance 0 Manage maintenance activities 0 Reduce liability and exposure 0 Maximizes existing budget dollars and helps plan future budgets 0 Extend life of infrastructure Goals -- .... I . In the final phases of implementation 0 Data Development I 0 Implement System Tools and Procedures I Perform Pilot Project 0 I 0 Educate staff 0 System Management I 0 Evaluate System I I . Rolling out tools for decision makers I Allow decision makers to quickly analyze cost 0 implications of management strategies I . Focus on efficiency I . Focus on integration I I I ----- -- ------- ------ ----- ---- ---- - ------ --- --- ---- ------ ------ ------- -- -- --- ---- ----- -------- ------ Year in review --.. - - - . Expanded timesheet to all public works departments I . Implemented CALLdirector I I . Integrated timesheets I . Deployed canned flexible reports I I . Wireless data entry via VPN I \ . Final Implementation of GIS Web Server I I . Started to GPS Sanitary Sewer I I . Tree Inventory I I I \ I --.---- -~~ -'--.--- I CALLdirector I ---- - - - - "''''' ""'. . -.->P.::d'C ~. -. .' ".... ,," ~~"::::11 . , . " . , , . ; J @ Q ~gl~.:lJ.~ ill I ,",.,.,~ 'J'I"': "'.:l~J..J::! L1@ ~~ ~J(8 ~.lO7% .~ '~lil:.u Read ~! : ~ ll= i,;'; ~~ /'0/ . ... Implemented fall : Eire ~d~ 'tiew Insert FQ.rmat lools T~e 'tl,indow tielp POF ~Teate! Type a que::;tron for he~p . X I . lQe;;i! ], ;~ J.. Verdana .:.8.5 . ~., B I !! I~"'" ""I j= ;= 11" ~I" ~ I . . --' GJ ' . . B' , . . 1 . , ,~ . . ' , '3 , . . 4 . . , . . , ' ..h.. ~ , , . ~ ' , '01 ' . , ~ i of 2008 Work Orders I - F,ltlitr (w,;.,k O!d,er :'W../mb<<, 0=; "'ro$~23"',l Woridng $@t Filter (( \StO;O /)~t.= ~...-ro.tl i$ ",,~'t.Mf'> ~st 0 m"I'It.l>>s 3) ~ (. \Sto,'" D~t"" Act;}1I1 is ri>.}tl)) Track most calls Sort l1;'Offl C.'del. NI..mbet . GtOUP ~ De:;>l1t.>tm~f"/t, W<"."k O,wd~,' Nt..'mb.:." - Work Orders received and Department . Work Order Number 108423 ~ Completad Issue Street SiQn Priority HiQh actions taken Activity Street - Signs Start Date Actual N Address Number Stop Date Actual 12/4/2008 Ro ute D.UBUN.lN Repeat Inte..al Assi gne d To Todd Schumacher Entered By ~ In the of - Details Caller stated the Stop Sign Notes . process l&a.S hit at the corner of Dublinj.,Q 8< Dublin W ~ ~ Only a block re-evaluating I'tQlll SlmEatl:l School. labor. Actual - Start Date ID Actiwity Total Hours Cost ! SOP 12/4/2008 102233 Replacs Support 1.00 $33.00 Entry Count: 1 $33.00 ~ Equipment - Actual Start Date ID Actiwity Total Usage Cost . Entry Count: 0 $0.00 ~I Material - Actual -' Start Date ID Actiwity Quantity Cost Entry Count: 0 $0.00 - Other - Actual I Start Date Contract Actiwity Account Cost Entry Count: 0 $0.00 ~ Total for 108423 $33.00 - Total for Signs war>: Order CoU1t 1 ~J . ~ " ,; ....@! .~ '" ~ 1 . - ~'i - ~w ,., Page 2 See 1 212 At 2.4" Ln 11 Col 43 PE( TPl E.\T QVR ~ ,'--- ! I Work Orders I r. .__-_;-~~~~~---- - --~-~.~ -a Work Orders Report ('5) .rtr ~ Hlcrosoft Word a ~ s ~ j LiJ @ Q ], aJ~ !.!l!~ ofll ."", ,~ J I. " . 1"' . I ~J .}::J C@ .. 4} I ~ ~ 107'1. :: ,,., I.::u Read IJ l"'" I := ~i" ~i" L .." . .. : Eile ~d,t '!.iew Insert FQI"rMt Iools T~ble ~indow t:!.elp PDF ~reate! Type a question for help . x 1Q <.:il '. ~ L Verdan, ~ 18 . A . J[!] I U I~ ~ ~ I ,- .- ."'."' Ii . :'-- " - _ g g ~ 1=:= ~r- ::.1'"- ;~ --' GJ ;,,' BL. . . : . ~ ' . ~ . 3 . , I ' , 4 . ~ ' . . : ' . . ~ '6' '1 ~ Work Orders 1 Filter (W~fk Ofd-ftJ !if(}mpeT ~ .Stm-J") Working SElt Filb<r ({.\St",p D..tc Actu.)! is wi4:..~.in Il:tst D f'r.<N1t.~.s J} 0" (. \St(>p Dit!;@A..."tuilJis r....u'I)) Sort Worl< Orde.r Number Group By O~dttmeht, W.::>,~.1.:: OTdeT /tI/Jmt:~u Work Orders Department Work Order Number Strn.3 Statu s Completed Issue Storm Drain priority High Activity Storm - storm Drain Start Date Actual Address Number 2101 Stop Date Actual 3/24/2009 Route EAGLEWOOD CIR Repeat Interval Assigned To Keith Raines Entered By Ueurissen Details Storm drain by home is Notes pluQQ8d and water is accumulating. Resident works for Scott County. Labor. Actual Start Date ID Activity Total Hours Cost 3/23/2009 102236 Jetting 2.00 $68.00 r Entry Crunt: 1 $68.00 I r Equipment - Actual I Start Date ID Activity Total Usage Cost Entry Crunt: 0 $0.00 I~ i - Materi al . Actual Start Date ID Activity Quantity Cost I Entry Crunt: 0 $0.00 Other. Actual Start Date Contra ct Activity Account Cost I L... Entry Crunt: 0 $0.00 Total for Stm.3 $68.00 Total for Storm Sewer Maintenance Work Order Count 1 J l~ . 0 ; " " '" :> r;J r.D ~- - - 1!1J 1')1 Page 2 See 1 2/2 i<J: In Coi PEe TRK EXT .~,',...P ----- - -----.------ Timesheets and reporting I - - - -- - - - - -[g) ---- - ~ tIl!:!.!!!!"~~ .__. .. .. - . . .-. . ;R ~i.lte! .bl.S~ar~ ~t!.... .-..-- .--.. . - Implemented E mer Slop Dale. ,n 2/3112008 81 Enter Start Date: r DSI01120D8 =:B1 . l__~.__ , I Help I I Bctivate I [ Cancel [ [ Help I I Activate l [ Cancel I timesheets for all PW Staff I nteg rated dig ital ~ . 0633 Il,usi!!.ess Unit Entry Date A'i1ivitv_ I,!st ~ame Total Hou,tS Cost timesheets with 0633 10/16/2008 Football Fietd . Bisek 1.00 $33.00 2:23: 10 PM Striping 0633 5/1/2008 Softball Field - Haeg 1.00 $33.00 2:23:31 PM Bases/Rubber/H City wide orne Plate system 0633 5/2012008 Softball Field - Heyda 1.00 $33.00 6:45:33 AM Grooming 0633 6/6/2008 SOftball Field. Fl;end::ohuh O.se 516.50 6: 19:32 AM Grooming 0633 10/28/2008 Football Field - Bisek 0.50 $16.50 GIS staff develop 2:26:29 PM Stliping . 0633 10/23/2008 Softball Field - Haeg 3.00 $99.00 2:26:38 PM Grading 0633 6/3/2008 SOftball Field - Fliendshuh 0.50 $16.50 10:16:59 AM Grooming the tools for others 0633 6/1212008 Baseball Field - Heyda 0.50 $16.50 6:5~:02 AM Grooming 0633 9/16/2008 Football Field - Bisek O.se $16.50 2:20:11 P~l Striping 0633 6(4/2008 Softball Field. Fliend~huh 0.50 $16.50 to use 1C::::22 AM Grooming 0633 5/29(2008 SOftball Field. Gieseke 0.50 $16.50 2:23:41 PM Grooming 0633 6(10(2008 Baseball Field - Heyda 0.50 $16.50 2:27:28 PM Grooming Uniform set of 0633 6/9/2008 SOftball Field. Friendshuh 1.00 $33.00 . 2:22:59 PM Grooming 0633 5(1/2008 Softball Field - Friendshuh 0.50 $16.50 ::20:01 PM Grooming 0633 10/20(2008 Softball Field - Haeg 1.00 $33.00 i ntu itive tools :::1::2 PM Grading 0633 5/:8/:008 Softball Field - Gieseke o.se $16.50 1:27:37 PM Grooming $610.50 Total for SWEENEY ELEHENTARY $17,795.25 Total log 529 - - v -------~._,--_.- -----~--- EguiRm~nt Maintenance I ~ "",--<""n""" ""-_ ._ < ~. ~.._ ... " r_ ~_....- __ . "'_~ ___, - ~- ......., < ~- , ~ << -~~'.~~ __ a- I~ Filter by S!art Date .... m ill Filter by' ~top Q'!t'l Enter S larl 0 ale: 'PS/01/2008 6J Enler Slop Date: in 2/3112008 Ell I [ Help I 1 Activate J I Cancel I I Help I I Activate 11 Cancel I I {;J. $ ^ 0625 ~tb1!Y __ _lirsl~a.!!le - !-i'5t Name Start Date Total HOllrs Cost Maintenance Equipment Chad Bonine 9/3/2008 1.00 $33.00 Maintenance Equipment Chad Bonine 12/16/2008 4.00 $132.00 Maintenance Equipment Chad Bonine 6/9/2008 1.00 $33.00 Maintenance Equipment Chad Bonine 6/19/2008 1.00 $33.00 Maintenance Equipment Chac Bonine 12/1/2008 1.00 $33.00 Maintenance Equipment Chad Bonine 12/8/2008 5.00 $165.00 Maintenance Equipment Chad Bonine 6/10/2008 1.00 $33.00 Maintenance Equipment Chad Bonine 11/12/2008 8.00 $264.00 Maintenance Equipment Chad Bonine 10/22/2008 1.00 $33.00 Maintenanc€ Equipment Chac Bonine 5/13/2008 1.00 $33.00 Maintenance $13,866.75 Total For 0625 Lo~ Count 429 $13,866.75 Total log 429 3: - v -- --- I Snow removal I --.. --- - - -- I .. . , ., _00 .. -- ~." - --_.. - ~- .------ ra Sidewalk Snow Rel1loval.lldf . Adobe Reader - L;]g)f3 Eile !;:dit :iiew ~ocument 10015 ~ndow tielp x t~ *j () t~ 019 :: ~~ .v~. S E3 .'C.." . ~. Sidewalk_SnowRemoval ^' -A'Ctivi~ .. - Overtit;; 1 'Cost" ~oa: - O~erti'l'@ 1 t!2,Ur5.. ... Total Hours Maintenance - Snow Removal I Sidewalk $0.00 $136.00 0.00 4.00 Maintenance - Snow Removal Sidewalk SO.OO $68.00 0.00 2.0J Maintenance - Snow Removal Sidewalk SO.OO $165.00 0.00 3.50 It; "t) f90~i%}. Maintella/'\Ce - $nevi Removal last Name Whitaker ^ Side~"alk SO.OO $132.00 0.00 4.00 Activity Start Date Total Hours c;.ost First Name Business Unit Maintenance - Snow Removal Streets - Snow 12/23/2008 3.50 563.00 Keith 0424 Removal Sidewalk SO.OO $236.00 0.00 5.50 Streets - Sno..... 2/26/2009 3,25 558,50 Keith 0424 Maintenance - Removal Snow Removal Streets - Snow 1212312008 0.00 SO.OO Keith 0624 Sidewalk SO.OO $65.00 0.00 2.50 Removal 042~ Maintenance - Streets - Snow 12/17/2.008 4.50 561.00 Keith Snow Removal Removal Stree~ - Snow 2/21/2009 5.00 $90.00 Keith 0424 Sidewalk SO.OO $165.00 0.00 3.50 Removal Maintenance - Streets - Sno\'.: 1~9/2008 5,75 $103.50 Keith 0424 SnoYJ Rf:TTlova\ Removal Side~"alk $0.00 $236.00 0.00 5.00 Streets. Snow 12./21/2.008 6.00 5108,00 Keith 0424 Removal Maintenance - Streets. Snow 12./3/2008 4,50 $81.00 Keith 0424 SnoVl Removal Removal Sidewalk $O.CO $102.00 0.00 3.00 Streets - Snow 1'2./31/2008 4.00 $72.00 Keith 0424 Maintenance - Removal Snow Removal Streets - Snow 12/15/2008 4.00 $72.00 Keith 0424 Sidewalk $51.00 $51.00 1.00 1.00 Removal MaintenarKE: - $729.00 Snow Removal Thursday, March 19.2009 35 of 36 Sidewalk $0.00 $102.00 0.00 3.0J MaintenarKE: - Snow Removal Sidewalk $51.00 $51.00 1.00 1.00 Maintenance - Sno~i Removat - Snow Plowing Sidewalk SO.OO $204.00 0.00 6.00 - Maintenance - T ot.1 For Whit.ker Snow Removal Total Hours 4342..25 $161,546.75 - $3,357.00 $14,882.00 v v 11.00 X 8.50 in 1<111- -. ::-- -.IUI . - .:1 > ~ -~, ~- ---- -- --- , Watering_ flowers ~ ~Io~er~:p~f. ~'d~~~~~a~~~ _.~- '_.~- -" '-"'-' --_.~. -.'~.~ ".- ~-,.. --- '" -.-:'" ~.~~."~.._-=~-=~_-==.t;}(Qj~ Eile !;:dit ~iew Q.ocument Iools i!lI.indow tielp x 'Oi ~ * I i:J. ii ~ 0 I 5 II \~ ~!.> 189.5% I. II ~. 1M:: I Find I. $1,015.25 ~ Total For DOWNTOWN Log Count 16 Asset ID PUBLIC WORKS Start-Date last Name- ActiVity Total Hours Cost 3/27/200'8- --Fm;nd5huh-Pa~ 4.00 - - - S132.00 Tree/Shrub/Lan dscaping - Flo.....ers $132.00 Total For PUBUC WORKS Log Count 1 $3,074.63 Total Log 68 v --------'- -- -" ----~-----'-- , Landsca_p~ Maintenance File Edit View Document Iools Window Help x &gt * {;J. ~ ~ 0/15 <:J 0 190.1% I. 'IE!; E:3 "IF,ne, I. ~ Asset ID TAHPAH ACtivity . - Total Hours Cost ~rk fuei5tirub/~dscaprng':"PrUr;ing 8.00 -$264.00 Park Tree/Shrub/Landscaping - Pruning 7.50 $247.50 Park Tree/Shr.Jb/Landscaping - Pruning 2.00 $66.00 Park Tree/Shrub/Landscaping - pruning 2.00 $66.00 Park Tree/Shrub/Landscaping - pruning 1.00 $33.00 Park Tree/Shrub/Landscaping - Waterin(; 2.50 $82.50 Park Tree/Shrub/Landscaping - Pruning 2.00 $66.00 Park Tree/Shrub/Landscaping - Pruning 8.00 $264.00 Park Tree/Shrub/Landscaping. pruning 8.00 $264.00 Park Tree/Shrub/Landscaping - pruning 2.00 $66.00 Park Tree/Shrub/Landscaping - Pruning 2.00 $66.00 Park Tree/Shrub/Landscaping. Pruning 1.00 $33.00 Park Tree/Shrub/Landscaping - Pruning 1.00 $33.00 Park Tree/Shrub/Landscaping - Pruning 8.00 $264.00 Park Tree/Shrub/Landscaping - Pruning 7.50 $247.50 Park Tree/Shrub/Landscaping - Waterin(; 2.00 $66.00 $2,128.50 Total For TAHPAH Log Count 16 Thursday, March 19,2009 14 of 15 Shak Landscape Maint $22,297.00 - Total Log 566 ,v. ---- I Sewer_~_~tting 0" '111- .',1- t . Window Help x ',." ., ",,,...;cioi, """","~;.,""" . . -, " CD/I l~ <!~ j 100% :. ' ~ rn Eile ~dit :iiew ~ent Iools ~jl"'ldoH tielp x $ [2/3 l:l ';!:l [100% ~ . ~ E3 ^ ^ Jetting I.!? !.ellgUl 5E818-5E819 168.18 ft Jetting Hour Log 5E819-5E810 138.36 ft 5E820-SE821 115.58 ft Jetting Hour log SE821-SE822 126.01 ft SE822-SE824 108.53 ft ID 102223 SE824-SE823 185.00 ft StarCOate Total HOllrs SE824-SE825 86.13 ft Cost SE825-SE826 65.00 ft --...-- - - 3/9/2009 8.00 5272.00 5E842-5E843 80.16 ft 3/10/2009 8.00 5272.00 - 5E845-5E844 103.58 ft 3/13/2009 8.00 5272.00 5E846-5E845 105,22 ft 5E847.5E846 95.12 ft $816.00 5E847.5E848 108.52 ft Total For 102223 5E847.5E848 108.52 ft Log Count 3 5E847-5E848 108.52 ft 5E848-5E849 134.10 ft ID 102228 5E849-5E850 128.58 ft ~1i;rt'i5ate TotarHours Cost- 5E850-SE8SI 195.11 ft ---- ..."... Total Length 2,260.43 3/16/2009 8.00 5272.00 Entrv Date 3/19/2009 3/17/2009 8.00 5272.00 II? -length 3/18/2009 7.00 5238.00 5E803-5E802 205.00 ft $782.00 5E804.5E803 175.41 ft 5E827-5E816 110.87 ft Total For 102228 5E827-5E847 326.51 ft Log Count 3 SE827-SE847 326.51 ft ID 102229 SE828-SE827 225,98 ft SE829-SE828 99.18 ft Start Oate - Total Hours Cost 5E830-5E829 85.36 ft - - -- 5E831-5E830 162.53 It 3/4/2009 2.50 585.00 - 3/9/2009 8.00 5272.00 5E837'5E838 182.52 ft SE838-5E839 81.49 !t 3/10/2009 8.00 5272.00 5E840-SE841 320.44 ft 3/11/2009 2.00 568.00 Total length 2,401.78 L_ 3/13/2009 8.00 5272.00 3/16/2009 8.00 5272.00 Grand Total Length 18174.1775918 3/17/2009 B.OO 5272.00 Total Events 123 3/18/2009 8.00 5272.00 LY_ $1,785.00 a.sox 11.00 in !< 1 ;:Jf I 1>1 -. '1<1 ------ ..~ - .-- - ~ IIU I f>l - ~ I i T ree..lnventory I --- - - Row Labels Number Evergreen 695 19 ft - 30 ft 150 Cedar 16 Fair 2 Good 14 Pine 20 Excellent 12 Good 8 Spruce 114 Excellent 70 Fair 2 Good 42 2ft-8ft 225 Arborvitae 17 Good 16 Poor 1 Cedar 1 Good 1 Fir 4 Excellent 1 Good 3 -~ ~.'- - ,,-,-,..,-- --- -----'- - I SigrlS -- ..- - - I I I . 90% complete with Sign GPS collection : Todd S. will be working proactive planning . I . on In 2009 Qji;~~ _~'__~_ ____ __~..~ - .. r- , ,~ - - - - - '-. ----..-"-~-----_rn~ 1 Sign !nfor;;'atio~' 10: 11000 -, fi'~TF(HN()1 ()r,y Features Attachments - - MUTCD Cod. 03'-:] r '- - r 0-'--' i Description: StleetN"me ~~~r7r~' Symbol: ~ 5h~pe.. RectMg\e E MAIN ST I I , . ,- Text: [STREET) ..., I' Height: Bin '. Width-- location r 'Ir~ ;, .. District C--SJ RouleAheod [ Ell Route: ! Ell Roote Bock: Ell .... '" . p Address #. a I' D.etails ---.... 1/jI"'~'tll)( H . ~ ~' Sign Fedures I Support Features I Inspections Events I OriQ" I I R epl.ced: : 08/19/2008 I .I!~ New Sign ~ ~ Iii! S.ve Sign Notes 2l E'mei\Sign e Vjev..I Signs Repolt II -i:':jl,,!,!,!~~!'f! ""'~~~ ~.,..!I! - .m..'m,~,.J ~ - - _.-'-- -"""!- __,,' ._.-. _n ,...,.._..._,..., ,._ ,,_. ~ -- I GtS W~b. Application. . Replace LOGIS Map with internal application . Reduce annual costs from $32,400 to $5,000 . Add functionality . Implement in a way that City's GIS Specialist has control . High quality mapping tools . Expandable in the future . Integrated with Cartegraph - I ! Storm and Sanitary Sewer I -- - - - - Have VPN set staff enter data . the fi e I d . up so can In I Collecting GPS data I . I . Will be entering outfall inspection data this year I Adding televising data .. - ~- --- ~ ~ ~ ~ -"" y~ - , .- - .. - - LJtg]~ I . ~~~~~aph.~4vi&a.J!!_~~WUlvi~--=-[M~ins] ~__~ -~- - -- --- --- -- - -- ~ EiIe ~dil: ~jew fQrm~ Fifters B.ecOfds actiOns ~IS ReQ.OI'ts lools W.indow !::le!P _ Il' x I ..~ lli{j I ~~-=..n~~_~~ ;('~,~~~~~-'~~~~=~'~iT~-\.-n@-=~:~T~I-~=--==--- ._,--.._,~-- . . ,. ",.' , - .. EN 'dl: '{JfM~...--t ~fV'lM 10015 Mo.-.utd ~tiOt> . SEWERview - ~CrMI~ptf". $i~Fm. ~f;qlG't. &JSlwt"""'Mtg9 QSooc..n9 /S'q:l9 ~fOl'ms. ",;;;~&Carrn<<1.. Isewer Main Inform";'tion ID:~209'VP2'O 11 V'd t,1rl('(,uph I ,f/pyTFrHNn! ()(;y :.:Jd 0 El' I I~~~ :J ~J~:~J ~ E:3 il'..___n---'O . O' n FeatulC$ 1 eo ~ ~l~ Type ~--EJJ M~~~ F ~ I -~ ~ Visu-Sewer Clean & Seal, Inc. l"",th ' 266.99932304 EJ! Diemeter: '~,'....:L,.,1.;-i 7905 Beech Sreet NE. Fnd~y. MN ~-.s432 SHAKOPEE location I Tel.: 17631 252-oOC4 - F';;lJc (763) 252-Ol}o.."18 Q~ Location De-saipOOr!: Web: ww..'i.V,Sr;-5eYtt.;'f.COfll CCTV ROUI, r--E!JJ l-~~ Upstream MH Cownstream MH DlStrrct __ ~ I I VP 210 I VP 209 I j SiMvi""'C=_~ ~ I OJote Job Numbtlr LOe.Jtlon l$t,...t) U$. or Sewer ~. 12i1.'2l)OO II 08252 M~l II SCOTT ST II S,l"~itarv Pipe SIr.. M..'.r1i11 JI. SpiIoelng snilolM Flow Oir.etlon Surv,y Ol...ction lo!lstJetted: I 8 I I Po,'vvi'W/ Chkl~ I I 12 II Circu~ar II S II Downstre.l'l'1 I l&tTelevis.ed: f'EX-> " .., I p,...cl~nlno W'o1th.r Surfae. US MH O.pth OS MH O.oth Truck No. i Lo!Isllnspecled: .l.~ ~C1B. 'S!!J~ .:-~. Jenina II Snow II Asohall II 0 II 0 II 231 I ~~i "J MKlla No. OVO Tltl. No. lISurw~~ I Tota~;"gth \ \ Surwvor Cert!fle.lIt. No. ~~ .- ~ <t~I'I~I_ I 17 If 07 ,. \1 U-1207-6156 I -l beta1J~ . ., Comments N'A I Prolile I Mo!II'lholes I Lo!Iteto!lll Jnspecticrn I Events I -:f :~~j.:": pDetailedProl~e p~jtion COllt. COmllMnl a~J 1al€j~....1Il Zo,,", -'~,:::=--~:::::.~::::::~---=:--:::__-=_ ;I~ New Main I MHVP21Q - F.. II So!IveM.,in v &:j E.rM~ MMl TF TaP. FaCIOI)"M.lde 3 TF Tap.FaCIOI)"Maje , SrGNview WORKdirectar eVleW Mn Report I PARKview """ STORMview Right click and draQ toZoorn . lefl clck <YId dlag 10 PM. TFA T3(I. faaof)' M.:tde: Act..~ 10 TF Tap.FaclOl)"~ 2 - ~Pm Tot,,): 3229 Filter ~.:;- . c--- -" ---' --.-"" '---'- -- ,--- ---' -, - ------ -, ,- 2009 Work Plan I - - --- -- - - .. . Complete GIS Server Implementation and I Launching Shakopee GeoLink I \ . Tree trimming/maintenance . Sign Maintenance . Playground inspection using VPN . Continue to improve the system . Outfall inspections . Utilization of sign data r------~ -,-,------' -- -, -,- - -- ---,- - Self Assessment I --- - - - --- - - . Technology is well accepted by staff . Several operators were early adopters of technology 0 Will help with modification of work order system 0 Will help move sewer module forward . New uses for technology are being found . Staff are now using complex GIS and Asset management tools with very little assistance . GIS Specialist is handling the majority of the system management . Consultant staff implement complex tools I - -~-~---- --- ,- I Tel eC.Q m ._f un din g . System relies on a numerous Telecom funded initiatives 0 VPN for mobile 0 ArcGIS Server software 0 Server hardware 0 SAN based storage 0 Training 0 System development ~- -'-- ----",--- ----' ----' ,--' --", -- I SUJ1).ma_ry . . Shakopee GeoLink is in final. testing . AMS is in production mode . System is used daily by all PW operators . Rolling out tools for decision makers 0 Allow decision makers to quickly analyze cost implications of management strategies 0 Using the tools to generate policy . Ability to easily add new assets . Focus on efficiency . Focus on integration ,-----' --- - - I - -- --- - Questions?