HomeMy WebLinkAbout2.d. Engineerign Division StaffingAGENDA ITEM: Engineering Division Staffing
AGENDA SECTION:
PREPARED BY Jamie Verbrugge, City Administrator
Andrew J. Brotzler, P E., City Engineer
AGENDA NO.
R
ATTACHMENTS: Information from CarteGraph; Draft Job
Descriptions; Proposed Wage Rates
APPROVED BY:
RECOMMENDED ACTION: Discussion Only
City Council Work Session Date: May 24, 2005
CITY OF ROSEMOUNT
EXECUTIVE SUMMARY FOR ACTION
ISSUE:
Consider proposed restructuring of positions within the Engineering Division.
BACKGROUND:
With the recent departure of two employees from the Engineering Division, Staff has been reviewing the
tasks performed by the Division and the needs of the Division, specifically related to the advancement of
the City's Geographic Information System (GIS) system and development of an Asset Management
Program At this time, the Engineering Division is comprised of the following positions:
Pubhc Works Secretary
Management Analyst (New in 2005)
Senior Engmeermg Technician
Senior Engineering Techmuan (Vacant)
Water Resource Engineer (Vacant)
Project Engineer
City Engineer
Staff is proposmg the elimination of the two vacant positions of Senior Engineering Technician and Water
Resource Engineer, and the creation of two new positions of GIS Coordinator and Staff Engineer. With
the recent addition of the Management Analyst and Pubhc Works Supernsor position and reallocation of
duties to other Staff, there is an opportunity to create a GIS Coordinator position to focus on the
development and enhancement of the City's GIS system and to develop a Comprehensive Asset
Management Program. Followmg is an overview of the positions proposed to be restructured.
SENIOR ENGINEERING TECHNICIAN (Vacant)
The former employee who held one of the Senior Engineering Technician positions performed a number
of duties. The general dunes performed are hsted below:
Annual audit and year finance work
This work was reallocated to the existing Senior Engmeermg Technician position in 2005.
Traffic Counting
The City is required to complete traffic counts on the City's Municipal State Aid street system
every 2 years. The completion of this work along with other traffic counts as determined to be
necessary will be transferred to the existing Senior Engineering Technician position.
Assessment Roll Preparation and Administration
Work associated with the preparation of assessment rolls and administration of assessments Ins
been reallocated to the Pubhc Works Secretary and Project Engineer. The Management Analyst
will also provide assistance with the preparation and administration of future assessment projects.
Pavement Management Program
The administration and contmuation of the Pavement Management Program has been assumed by
the Project Engineer. As in the past, the existing Senior Engineering Technician will continue to
complete the annual field rating of City streets. It is anticipated that the proposed Staff Engineer
will provide support with the administration and coordination of the Pavement Management
Program in the future.
Administration of Municipal State Aid System
In 2005, annual work to update the City's Municipal State Aid System was completed by the
Project Engineer. It is anticipated that the proposed Staff Engineer will assist with the completion
of this work in the future.
Special Projects
Through the course of work, there are any number of special projects that come up. This can
range from the review of as- builts and projects to researching records to provide information that
is requested both internally and externally and responding to calls and front counter requests. As
the former employee who held this position was primarily m the office, he provided a significant
amount of support with a multitude of tasks While some of these duties can and have been
transferred to other employees within the Division, there is currently insufficient staff time
available to meet these demands m the future. The addition of the proposed Staff Engineer will
address this deficiency
grtvs \EngineenngDivS taffingC W SS -2405
2
GIS and Asset Management
The development of the City's GIS system was a part of the vacated Senior Engmeenng
Technician position While work was performed on this GIS system by the former employee, due
to the many other tasks and responsibilities of the position, hmited development of the City's GIS
system has occurred. There are many aspects of GIS that once developed will allow the City to
efficiently and effectively continue to meet the needs of the organization. More detail of the City's
GIS and Asset Management goals are outhned further m the report.
WATER RESOURCE ENGINEER (Vacant)
Following is a summary of the duties previously performed by the Water Resource Engineer:
Building Permit Review
The review of building permits for conformance with development grading plans and erosion
control requirements has been transferred to the Senior Engineering Technician Building
Division staff is also providing assistance with this work.
Erosion Control Inspection
The inspection of building sites for conformance with erosion control requirements is now being
completed by the Senior Engineering Technician who will continue to perform this work m the
future. For development sites and projects, the erosion control monitoring is being completed by
the on -site project representatives with the City's consultant engineer.
Administration of Wetland Programs
Work associated with the administration of wetland programs and permits is now being
coordinated by the Management Analyst with support from the City Engineer. It is anticipated
that the proposed Staff Engineer will assume some of these duties.
Wellhead Protection Plan
The administration of the Wellhead Protection Plan will be coordinated between Operations and
Engineering.
Administration of NPDES Phase II Permit
The administration of the NPDES Phase II permit is anticipated to be coordinated by the
proposed Staff Engineer.
As noted above, several of the duties previously performed by the vacant Senior Engineering Technician
and Water Resource Engineer positions have been transferred to the existing Senior Engineering
Technician position. This is possible as a result of the added positions of Management Analyst and Pubhc
Works Supervisor. Several of the maintenance type activities previously performed by the existing Senior
gmis \EngnneenngDivStaffingC WS5 -24-05
3
Engineering Technician have been transferred to the new Public Works Supervisor and the Management
Analyst has assumed the responsibility of maintaining project updates
PROPOSED GIS COORDINATOR
The GIS Coordinator will be responsible for the coordination, development and maintenance of a GIS
system. This position will direct all of the GIS work and necessary data entry to keep the GIS system
current and functional as a tool for other users within the organization. A proposed job descnption rs
attached.
As a GIS system will support and benefit all departments within the City, there is a significant amount of
work associated with the development and maintenance of a GIS system The City currently employs a
part-time person who prepares maps and provides support with the maintenance of the GIS system and
data. As part of the 2006 budget process, Staff will be evaluating the need to make permanent a GIS
Technician position to support the City's goal to advance the City's GIS system
In addition to the above responsibilities, the GIS Coordinator will also be responsible for development
and adnnmstration of an Asset Management Program.
PROPOSED STAFF ENGINEER
The proposed Staff Engineer will be responsible for performing a wide range of tasks withm the
organization. Following is a hst of activities that will be performed by this position:
Plan reviews for development projects
Review drainage issues and develop solutions
Assist with erosion control inspections
Assist with the administration of Wetland programs and permits
Respond to resident calls and front counter walk -ms
Assist with design and coordination of maintenance projects
Examples include storm sewer and drainage projects along with pond maintenance
projects.
Assist with the coordination and administration of the Comprehensive Stormwater Management
Plan
Coordinate and maintain City Municipal State Aid system
Support Pavement Management Program
gnus \EngmeemgDivStaffingC WS5 -2405
4
Engineering Technician have been transferred to the new Pubhc Works Supervisor and the Management
Analyst has assumed the responsibihty of maintaining project updates
PROPOSED GIS COORDINATOR
The GIS Coordinator will be responsible for the coordination, development and maintenance of a GIS
system This position will direct all of the GIS work and necessary data entry to keep the GIS system
current and functional as a tool for other users within the organization. A proposed job description is
attached.
As a GIS system will support and benefit all departments within the City, there is a significant amount of
work associated with the development and maintenance of a GIS system The City currently employs a
part -time person who prepares maps and provides support with the maintenance of the GIS system and
data. As a separate item, the Community Development Director will be preparing during the 2006 budget
process a recommendation to create a full-time GIS Technician position. This proposed additional
position will support the City's goal to advance the City's GIS system.
In addition to the above responsibilities, the GIS Coordinator will also be responsible for the developing
and administration of an Asset Management Program
PROPOSED STAFF ENGINEER
The proposed Staff Engineer will be responsible for performing a wide range of tasks within the
organization. Following is a hst of activities that will be performed by this position.
Plan renews for development projects
Review drainage issues and develop solutions
Assist with erosion control inspections
Assist with the admuustration of Wetland programs and permits
Respond to resident calls and front counter walk -ins
Assist with design and coordination of maintenance projects
Examples include storm sewer and drainage projects along with pond maintenance
projects.
Assist with the coordination and administration of the Comprehensive Stormwater Management
Plan
Coordinate and maintain City Municipal State Aid system
Support Pavement Management Program
gins \EngtneenngDivStaffingC W S5 -24-05
4
Special projects and research
GOALS FOR GIS SYSTEM AND ASSET MANAGEMENT
As previously discussed the City currently utili 'es GIS. The main function that the City's GIS system is
used for is the preparation of maps ranging from street and utility maps to maps for presentations At this
time, there is a lmuted ability to fully utilize GIS due to the status and configuration of the data. A fully
developed GIS system, coupled with an Asset Management Program, can be an asset for an organization
to manage data, infrastructure, resident calls, public works activities, City properties, etc.
Following is a summary of the GIS goals.
City base maps
The City base map is current but requires regular updates to account for new developments.
Utility base maps
sanitary sewer
water
storm sewer
record drawings electronically linked to base maps and accessible electronically from a
remote location
street hghts
street signs
The sanitary sewer, water and storm sewer maps are partially complete. One of the major goals is
to electronically link the City's record drawings to these base maps to allow for quick and efficient
access to record drawings. Once complete, Staff will have the ability to move forward to set -up
laptops for field vehicles for access to the record drawings and utility information.
Staff has previously acquired GPS information for a majority of the street signs within the City.
However, due to hnutations of the current GIS system, this information has not been linked to
GIS in a usable manner Once complete, Staff will have the ability to develop a street sign
maintenance and replacement programs
Another item that has regularly consumed a significant amount of Staff time is the maintenance of
street lights. A goal of Staff is to acquire GPS information of the street hghts in the City including
ownership and maintenance responsibilities to assist Staff with the mcreasmg street light
maintenance responsibilities
Infrastructure information hnked to utihty base maps
location
size
material
gnus \EngineenngDivStaffmgC WS5-2405
5
age
repairs /maintenance
valve and replacement cost
At this time there is limited infrastructure information organized in an electronic database
Through the development of a comprehensive GIS system the above information will be
electronically organized and linked to the utility maps
Parks Equipment Inventory
Currently there is no GIS information that has been collected for the City's parks other than the
property location
Mappmg
Map of maintained areas
Inventory of equipment
type
location
repairs /maintenance
valve and replacement cost
Land use
Zoning
Address maps
Easements
The City currently has complete zoning and land use maps An address map was recently
developed for Staff use but requires programming improvements to allow for greater flexibility and
use When projects are completed, the City often acquires easements as part of the project. At
this tune, there is no map available that shows all of the easements in favor of the City. In addition
to the identified maps, there are a number of other specific maps that are routinely requested
In addition to the GIS goals, Staff has completed some preliminary research on various software programs
that can function with GIS to manage City assets, track resident calls, generate and track work orders, and
track maintenance activities. One of the programs that has been researched is distributed by CarteGraph.
Attached are some examples of the various modules that CarteGraph provides
The CALLImk module allows for the tracking of all calls received. When hnked with GIS, calls can be
shown specifically on a base map. This can be useful when working to identify and resolve a recurring
type of issue. Through the use of CALLhnk and CALLhnk, work orders can be developed and tracked
electronically, ensuring that all items are responded to.
The CALLhnk module, m addition to hi with CALLIink, will also provide a tool to develop work
orders to promote the ability to better track work activities including personnel, equipment and materials.
Other CarteGraph modules as shown add to the overall GIS system to track maintenance activities such as
gnus \EngmeenngDmStaf6ngC Ws5 -24-05
6
sewer jetting, sewer televising, catch basin cleanout, and repair and replacement of infrastructure.
SUMMARY:
Staff is requesting Council direction on the proposed restructuring of positions within the Engineering
Division.
gmis \EngneenngDivStaffingC Ws5 -24-05
7
r
Request
IJ H C Q CIO kiL7IWw :R Lt HI S?YA 01141 CA
04JOraotatamal:: ri_WeN
Monger -filer
Caller
one Number '(319) 555 -7057
First Nome :Steve
Last Name Monger
CNzen Address Number 11090
Citizen Route 9TH STREET
Chien Zip Code ;50366
_IS k Irkernd'
Request Number (AthoNumber)
Issue pothole
Aotivly Roadway Pavement Pa
_DeperlrrrerA Road 8 Sireel
Detmis '_erge pot In the left sid
Observed oalerrtne �o5r902o03 35559 PM
s
Address Number r 1040
Rohe 9TH STREET
sodded Work Order 1
1 a
lsio ersgW ono a u 1, elr- dxm
w...- w.]
1. CALLfrnk is the starting point to
record service requests and initiate
work activities. Citizen requests are
simplified with the ability to create
citizen Libraries of standard data. You
Can also search for caller history and/
or similar work orders and requests.
2 Easily communicate work requests
with others in office via e-mail.
3. Automatically transfer key
information to a work order through
WORKdrrector integration.
4 Work orders completed in
WORKdrrector can automatically
populate asset history in any
CarteGraph wewSERI ES application
5. All work requests can easily be
displayed on a map.
CarteGraph
'mar .o-. .ivv
aarTH 1 r e
fl
Ca
0
Save I 0 Clear
MIR 1101.0.
1165 1452 ST
await/. SUSSWEI ON SI
XMAS.? 57
litSki,57 MIS Sn 1/44.
VOLO 51616.4 3,1? MVO
Sapp IgOtITOL
14•1 Iwo „Veal. 540S PLASvd
rR,t on rave
r Email request on save.
CALLIink rs CarteGraph's innovative application for problem
report taking, recording and resolution CALLltnk provides an
intuitive interface that gives the administrator the tools to gather
all the information needed to record any work request.
CALL/rud dynamically links to CarteGraph's WORKrirrecror
to generate work orders or work requests For an even more
powerful management solution, use WORKdnectot and
MA Nip ector applications to spatially display work requests
on a basemap
Power i n g Public Works
SERVICE REQUE
MANAGEMENT i s
S e r v i c e R e q u e s t M a n a g e m e n t
.oaar}e.n n.a,
,aa:. larks Isw
ct_,RM,. i,RRrPK
f1 nortvati
Lj 11 ct,L t1 1,11MIL a M ItlE1 Z F1 IHLI ta
r
s
eenlrLT -'S
1, WORKdirector simplifies resource
accounting All work management
components, such as labor, equipment
and materials, can be tracked to
assist in budgeting and GASB 34
compliance
2 WORKdtrectori directly with
CALLbnk as the starting point to
record service requests and initiate
work activities.
3. Work orders completed in
WORKdrrector can automatically
populate asset history in any
CarteGraph wewSERIES application.
4. All work orders and projects can easily
be disptayed and quened in GIS using
one of CarteGraph's MAPdvector
applications
CarteGraph
;lily Mad b'f
Caw,W61tMk!4)c atoraSSi M_ Tifir r
ma,$Mnb ,WO
wi !encl.
K [4 n+ yu qn, &w4 ry sn, a,pu _mP y pe
ilre'lk&Pate- N-ia9 s e a 4 r ii lr h�
napiES
R
cw
MMf rWlvPnanv, iaimJ
Ons
k Er
N ea
We dor
,�aex,mr J
n
mE J
EralAddx
SwaluM, I
Pam PEEI 4 iM fM,n E JCdn �J
0, c„ J
M.r rP J
^a` 4lea xiws
p V V. Dos ,41
4244 r,P.4 r Owl.' a el 39 1101 11 Hum
It is the responsibility of your organization to maintain the
public infrastructure to a satisfactory level of service
this is ajob made easier with Cart&Graph's WORKdrrecfor
In an easy -to- master interface, WORKduector provides
the functionality that allows you to manage all of the work
activities performed in your organization. From initial
request for work to the scheduling of routine maintenance
through the completion of each project, WORKehrector
tracks and maintains data on activities, materials,
employees, equipment —and more
With its completely customizable interface, including
forms, libraries and reports, WORKd,rector has
virtually unlimited potential to seamlessly automate your
hia i r
W o r k M a n a g e m e n t
P o w e r i n g P u b l i c Works
daily tasks Quickly and easily modify field names, design
on -line work orders to match current paper fomts, create
reports to output information —even add software func-
tionalitythrough a built -in VBScnpt" editor
Although a powerful tool when used alone,
WORKdrreclor can provide additional benefits when
combined with other CarteGraph applications as part ofa
complete Public Works management solution Create
independent work orders or associate a work order to a
specific asset record— WORKd,recto, links to any
wewSERIES application Or use MAPd,, ector software
to spatially display your work activities in a GIS
WORKdirector SPECIFICATIONS
Daab,ue
Labor
aCC
rtIy
Licensing
Data Slunng
SmartTools
Cuslominilion
Location
Requests
Work Orders
Equpment
HARDWARE
Typical workstation* mammon requirements
Processor
RAM
Network TCP/IP recommended for 9oncurren t h.clw e
&our:mend may vary 'kl *nil mon Gams well a. the database type (Acura SQL Sayer, arOncte), whether tMmmp ter4
'unevaae lux dtnbas,o ,aamini•mme uorkwamn or,.henl wvrkeuaun, and how may mopes are Installed IciM11M
requomenupkarennl row oneFapo mMnnmve
free disk space
OS
Video
CD -ROM dote
CarteGraph
3600 Digital Drive Dubuque, lows 52003
800 688 2656
563 556 8120
563 556 8149 (fax)
www cartegra ph com
Microsoft` Access 2010
Microsoft' SQL Server 7 x, 2000
pmCIL 8 Ix
Miooso0 Windows' 93, MB 2000. XP, NT
Navigator workspace
WORK/mortar pages include Requests, Work Orders. Labor,
Equipment, Malena's, Vendors, Worksheets
WORIOhrector f a i r s include Request, Accounting, Identification,
Work, Rates, Vendors, Summery. Associations, Quick Entry,
Management Form
Mull- record grid to view all records or record subsets
Tab mode or Iildfcim mode
Application Log/Multi Edit Lagrimpvl- Export Log
Manage 'users, robs and permissions wldlin Oc database
Define and maintain database and application secunly
Coscurranl network licensing
Stand alone
held licence check Mcheck out
Deer tmpon'cxpmt funcuonamy and format builder
forms sa•cJ as Individual files
Repons saved as sndlwdual files
Database shared amen other Cant Graph application
Match cones to existing list members or default values
Pop-up calendars and number key pads
English to metnc conversion
Default, carryover and regusred data options
Unhmted number of aunhute Gelds
Create custom fours
Add custom fields to track additional infmswuon al the fly
Buell -m BScnpn eddor
Vminor. coordinates, road network, mlcrscc ion or description
Geller information
Issue
Desorption
Request location
Requal history
Assign resounes (labor, equipment, material. tongue's, do )10 work
anrviucs
Schedule end track work orders through stages of created, slaved, opm
and completed
Monitor and track work backlog
Create and generate work orders
Credit work od erz independently or from requests
Create a work order wills multiple sequential work steps
Crease and manage unscheduled work activities
Access an -line work orders by work order ID, location activity or
assigned supervisor
Rtlneve work orders based on multiple selection criteria Including
planted. scheduled, active, suspended, complete, closed and canceled
Charge costs for resources--direct or indirect-41a defined rate
Update an open work order at any time
Add resources to an existing open work order
Recall open work orders
Assign multiple resources m a work order lack
Display work order status
View or pnnt work orders with all estimated and/or actual memgrs
View or porn details of closed work orders
Produce both corrective and preventative work orders
Employee information and images
Compensation histones
Work crew associations and assignments
Work histories
Labor rates and security
Identification and descnptim
Costs and maintenance schedules
Deprecation and salvage values
Operation log books
Pentium 500 MHa
256 MB
100 MB
Windows 98, Mw NT 1, ever, tr 'AP
6MB f
CD burner for tcclmical support
Malcnals
on
On -litre Libraries
Attachments
Actions
History
Scheduled Activates
`Pons
Filler/Son
Synduonixenon/Replication
Mdsonal Inventory
Inventory reduction
Reorder mvenmry tuggers
Inventory method
Magna' history
On -line pans or material catalogs
Magna' pncc hits
Vendor database with unique Vendor ID codes
Vendor address contact mime, phone, a -mud and fax
Putt quotations
C mute custom Ispmry mores
Attachment and display of digital photos I BMP, 1PG or GIF files) to
Individual records
Attachment of any electronic file including PDF, DOC, XLS, video
and OLE- linked documents to mdi idual records
Lank CAD as-built (plan, profile, cross section) design documents to
individual records
Include multiple attachments to each database record
Share attachments with other CarteGraph applications
Filler and son on Images
Predefined task aecamm inclu mg Convert Request to W ear
Recalculate Costs Add Material, Order Material
linlory of 511 acbvnia
Schedule toucan and/or recumng maintenance ant. toes
Maintain hewn of activity logs
Pre cmned upon include Department Requests Report, Matrnals
Available Report, Work Order Dew's/Simple Ripon Open Work
Orders Within I Month Report Labor Events Ripon
Define custom reports from all database fields and save for figure use
Include sub-reports
Finn -sp lc or table -style formats
N hew aeons on -line, generate hardcopv reports or e.mail report data
Define coiena to display record sets such as open requests, request
priority unassigned work orders and equipment status
Define cntma forrccord order
Expos data sets fu field data collection, maintenance or Inspection
Update main database with these records upon roam to office
PRODUCTS /ACCESSORIES
The following products integrate with WORKthrector m create a complete and custom
management solution.
.;ygE�ViC�E�RE�QUE5T5
CALLQnk
Requester Information
Requester history
Duplicate request Identification
Work request generation
stet Rs4" {tor
ASSET MANAGEMEIJT, r e;'
vfewSERIES'
VERSA(ools
Asset features
Location
Inspections
GASB 34 reports
MAPduec(oe
MAPdirector, for ArcVlew
Raster /vector map display
Thematic data presentation
Pal and 200555
Cant-Graph GveLlne
•fi .:FR:fia'.'W'
6 ,1213 E. IELO us
CAMhnk
Transfer digital images
Foil
DMihiC
Download lk!LLICC c.:n'ta g
Instrument (DMI) data
Standard operating procedures cue
On•Iuie `amen database
Complaint tracking
u.74(1rr
Idenufcabon
History
Scheduled acovthes
Lusmu_nsoJe s}moology
Layer /theme control
,Placemenr/ediong tools
CarteGraph
Powering Public Works
\ZVhnk
Capture Global Positioning System (GPS)
eoordmatos from a TnrnbleGPS receiver
BARlulk'
Scan bar code mfamianott
Cork S d. CAewonSldeubme Wu..W.n
Coons Now
Ay
—I-
torilaEq[y
:LJ
Don 1 301
J ta t1UCH JS1 J2LJ vu is
Mao Poc.,11,
CarteGraph
I
I 1
1. VERSAtools provides the tool kit that
makes it easy to build a management
solution that exactly matches your
specific needs
2 Create your application by determin-
ing layout, selecting functionality, and
adding and modifying fields.
3 The built- in VBScnpt editor allowsyou
to control the functions of each form,
adding even more power to your
custom application
4 Among the many administration
features, VERSAtools lets you control
functionality and user permissions
within your application.
5 VERSAtools applications are ready to
link directly to work management and
GIS
il•IIXcGiGK•ls NPa. ep N 1 s Nltl
curb SW c.a.mnn sll✓cl,rt..,n]prmun..
Doan. s•o 10033
NYiip,o IA,IWIEW
J h
sr N.. J
w.. IAOwo.o NODS l., rs..esm...,
N n iw A I oob, Typo
Slow
-7 r w, magi
?NUJ. ,J, u. a.L. am
.VMS. Con z .I� J 1 ws.ovl.. n, s..,
Is t rN LI JY•
.eww
J
M a n a
IT c n
o ..o1
Dei•IIR 14V1O1X CMOS
n
VERSAtools is CarleGraph's innovative developer toolbox
designed to give you the power to create a completely customized
management solution Drag and drop functionality allows you
to include all of the features of a standard CartaGraph
application including data screens, Ilbranes, reports, images
and filter: designed to your exact specifications TheVBSenpt
editorgives you options to include advanced funtionality within
your program
Applications created with VERSAtoo /s not only link to other
CartaGraph databases, but also have theability to control work
management activities through the built -in link to
WOR&Grecto, VERSAtools applications also easily integrate
with ESRI's ArcView or CarteGraph's MAPdu
J ii
umN Jr s 1�
COI o.,..,Dt
J,
s.s..aN. 10.175
now vp. 1.5.
J .+woo_ y..
A„ Polk UpOtoolo tw.o. 76” 21
r -r..rs r< ...ue_ r
r
Cemeteries
Solid waste collection
Roadside vegetation
Parks/ playgrounds
Parking meters
Trees
Graffiti removal
Permits
Sidewalks
Dams
Guardrails
and more!
VERSAtools SPECIFICATIONS
Database
Interface
Security
Licensing
Data Sharing
SmartTools
Customization
Location
Templates
Features
CASH 34
On -hoc Libraries
Attachments
History
Scheduled Activities
Inspections
Reports
Filler /Sort
Synchronization /Replication
CarteGraph
3600 Digital Drive Dubuque, Iowa 52003
8D0 688 2656
563 556 6120
563 56 8149 Itaxt
www rtegra ph corn
Microsoft' Access 2000
Microsoft Server 7,x, 2000
Oracle" 8 Ix
Micrasof Windows" 98, ME, 2000, XP, NT
Navigator' workspace
Design Mode/Run Mode
Form (window) templates Include Identification, History, Location,
Attachment, Inspection, Features and Financial Summary
Mulu- record gnd to view all records or record subsets
Tab niode or ule /fomi mode
Application Los/Multi Edit Lop/Import-Export Log
Manage users, roles and pemrssions within the database
Define and maintain database and application secunty
Concurrent network licensing
Stand alone
Field license check in /check out
Data ImporVexport functionality and formal budder
Forms saved as individual files
Reports saved as individual files
Database shared among other CadtGmph applications
Match entries to existing list members or default values
Pop -up caIendals and number key pad tools
English la metric conversion
Default carryover and required data options
Unlnnaul number of attribute fields
Rename fields
Create custom forms
Add custom fields to track additional information on the fly
Built -in %/Men r editor
Vinmly, coordinates, road network, Intersection or description
Capture and record CPS coordinates with %YZlurk
Point -based form templates
Linear-based fom templates
Top-level Starter (no fom lemptates)
Create new or customize foot templates with the Cartetoolbox
Alphalnumenc data fields
Grids /chaos
Drop lists
Buttons /cheekboxes
Slider /scroll bars
Drag and -drop data fields from Chooser list
Data groups
Alignment tools
Financial Summary Form
Financial reports
Depreciation or Modified Approach
Create custom library entnes
Include attachments and other data
Attachment and display of digital photos (OMP, JPG or .GIF files) to
individual records
Attachment of any electronic file including PDF, DOC, .XLS, video and
OLE -linked documents to individual records
Link CAD as -built (plan, profile. cross section) design documents to
individual records
Include multiple attachments to each database record
Share attachments with other CarteGrapll applications
Filter and sort on Ima
Lifecvdc history including onein/change dates, activities, work orders
Schedule routine and/or recurring maintenance activities
Maintain history of activity logs
Date
Rating
Ptedcfined reports include Asset Condition Report, Asset Events Report,
Asset ID Report, Asset Location Report
Define custom reports from any field m the database
Include sub reports
Define cntena to display record sets such as code, rating, route and
inspection dates
Define coterie for record order
Export data sets for field data collection, maintenance or inspection
Update main database with these records upon return to office
PRODUCTS /ACCESSORIES
CarteGraap
Powering Public Works
0 :IA_ Cor“Ireph Synnne, h A.JMle sun ,qaaxndpellblanshaiba•pen —t•ta WwA Mlin•, aid*. Wrbm Igoe minnend inalonsdu ofMwnCngMm All MMIMeneA•nerse,W w}IM•mlM popsy air
MC IP 1,11,[0”i hOMOI
[a in
7. c.S
Walk Sawvlir
Work Orar
n.Nuuno
arte raph
po.veimR public Walks
Tnnalk.nrmvlrJ• 0110
nna.rnn
JIe
O br 'weka616. N-' PnOz
ink Order Weida.
JT4Ittal2lalr5
<..vem
EMer1PV Priam Wooer J
LoCve Im.IV200111 37 01 PM
N•M r
eu. I J 1
p—lP
�I.
41-•:
NeNno
S.,o-cr hIufl ,nr-4n.p
Dace a y
1a rst
I P WT'*' qm e.ma Wm n. m. 1— M.— Lob
'!s L•.•6 V BaRx a NekNLl 211:1b0
v w
vi w
Jwrma,vr
Lw. I rn Jft ae.6o-:h
..ten
j 1
Ww loft owls' Mc r r..a J rR
ia a la u. al ra—
ro IO .(`iM1 yw N0
Wr
vararnarromarn
a I. a 1 4• 51.55 r_n
c h
♦!8 vin 11 +1
video
l•- •••■•••••..•-•d 4I«l•'IIIz1Nlo
.11 0.Waph WdFFbr 10ONUImninr.
laws _k pin egn. 1
ci a x le i 1 W tl
1. An inventory of pipes, components
and inspections and the ability to
schedule maintenance activities is
vital to the success of any Public
Works management system.
2. In addition to the asset data
contained in the CarteGraph
vewSERIES applications, SEWERwew
also provides graphical representation
of the data through the Schematic
Viewer
3. SEWERwew easily Integrates with
CALLIink to record service requests
and initiate work activities
4. Link work activities and maintenance
details from WORKdirector back to
specific SEWERwew asset records.
5. SEWERwew data can fuel your GIS!
The sewer information can be
graphically displayed and mamputated
in a GIS environment. The live link
between the map and your
SEWERwew database allows you to
quickly display specific records or to
graphically update sewer data
ES111
ED
CarteGraph
nyJ
f7 IN
Taw uo vin.....
ct r t...amw.
Managing a sewer network for a community is a constant battle of juggling preventative mainte-
nance activities, responding to emergency overflows and completing the long list of maintenance
and improvements that are needed daily SEWERveew provides you with a tool to organize, record
and display each of your daily activities, enhancing your ability to Insure your organization runs
smoothly.
SEWERwew contains the latest technology to display sewer video Inspections and to detail the
various distress observations on a pipe A repair and replacement schedule of activities can be
generated A pipe profile from manhole to manhole allows users to quickly see where cracking, root
intrusion or other distresses are located on each segment ofpipe
Inspections and routine maintenance schedules are available to track all of your sewer system
infrastructure including pumps located in lift stations throughout the city or sewer distnct A data-
base of sewer accounts along with WORKd and CALLInk will keep an up -to -date list of
service requests and the status of the work orders needed to complete each job The enhanced
reporting engine allows for quick and detailed reports of work orders completed, job costs, sewer
system component inventory and inspections, sewer overflows and many other daily activities.
Database
Interface
ecunty
Licensing
Data Stearns
martTaot
CLstoimnban
Location
Features
GASB 34
On -line LlWaries
Altaclunents
Actions
CMS
lipce ens
Fillcr/Son
SynchronlzltimlRep
SIGNvicw
SIGNALview
LICHTvltav
MARKINGview
SEWERview
STORMiiew
WATERview
PAVEMENTview
PAVEMENTriew Plus
WORKdirector
CALLfmk
CARTE/Ice/
VERSAfoofs
MAI'dirccvor
MAP director forArcGIS
MAPdirecto, for ArcView
CartgGraph
3600 Digital Drive Dubuque, Iowa 52003
800 608 2656
563 556 0120
563 556 8149 (fax)
www cartegraph cam
M lcrosoll• Muss
MwrosolDSQL Server
M¢mson Data Enginc —MSDe
Oracle`
Microsoft Wndowt 98, ME, 2000, XP NT
Navigator workspace
Sundmd Carl @Graph forms (windows) Include Attachments. Financial
Summary, History. Location, Condition and Notes
Multi- record grid to view all records or record subsets
Tab mode or Ilerform mode
Application Log/Multi Edit LoW1mpart -Export Lag
Manage users. roles and permissions within the database
Define and maintain database and application security
Concuteent network licensing
Standalone
Field license check mhhcck oul
Data l mpoNCxporl funcnonahiy and lonnatbuilder
Forms saved as mdn ritual files
Reports saved u individual files
Database shared among other C utecrraa di applications
Match enmcs to existing list meta rs orbe dcfauh values
Pop -up calendars and number kcy pad tools
English to memo conversion
Default, carryover and required data options
Unlimited number of attribute fields
Rename Gilds
Create custom forms
Add custom Acids to track additional tnramatian on the fly
Stint -In VBSermix editor
Ninny, cord hales, road nelworl, a tISWNOn m desenptimn
Romr/dislanccroliset
Capture and record GPS caordmutes with %Yank
Track sewer mums. laterals, manholes, pumps, auxiliary equipment, facilities. Ialemi
clearwuls and main cleanouu
CariiGrapll ficxFORMS Included
Con cctivdy browser
Video logging
Ability to inspect conditions by numenc Index or subjective soling
Schemal¢ Viewer
1 inancial Summary form
Financial reports
D eprecia Zion or Modi fied A pproach
SE`NERview component libraries
Abdny lo attach nudges to library entries
Create custom library mimes
Attachment and display of digital photos BMP. 1PG or GE Inks) b
mdn ritual records
Attachment of any electronic G4 Including PDF, DOC, ALS, video and
OLE linked documents to indvidual records
Ability to link CAD as bush aoftle cross seeoon) design
documents to nidividual rccords
Include multiple attachments to each dd ebase record
Share attachments with other Cart6Graph application
Filter and sort on Images
Go to Pipe ID, Rcwkulate Dependent Route Data, Recalculate Key Dales,
Recalculate Inspcctwns, Enter Evens
Track history of each in he ua stain component
Ability to create histo cal rcpons
Track scheduled activities for each component
Track important key dates
Schedule reoccurring amanita
Video log inspection
Establish Overall Condition Index
Predict Mc replacement dale and the condition
Abdul to ins ct conditions b numeric mdcx or sub =live rultm_
Prede mod sports Include Inspection Report and Inventory Repon
Define custom reports from all database Gelds and save for future use
Includesub- reports
Faun- styiea table style formats
View reports on -line generate hardcopy reports or e-mail report data
Define criteria to display specific sou of records
Define emend for record order
Export data cols f or field data collection, maintenance or Inspection
Update main database with these records upon return 10 office
The following products Integrate with
SEWERvuew to create a complete and custom
management solution
SERVICE REQUESTS
CALL(rnk°
1141 MOW•direert.
Requester information
Requester history
Duplicate request idenhficanon
On-line citizen database
Standard operating procedures cue
Complaint hacking
Work request generation
WORK MANAGEMENT
WORKdireerof
Work request generation
Work order generation
Automated notification
Work order referencmg
Labor tracking
Equipment hacking
Material hacking
Job cost tracking
Maintenance schedulmg
GIS INTEGRATION
MAPdfree:or
MAPdhectof for Arc in 3 x
%IAPdirectoe for AreGIS"
Raster/vector map display
Thematic data presentation
Custonnzable symbology
Pan and zoom
Layer /theme control
Placementiediong tools
CartcGrapli LrvcLmk
MOBILE FIELD USE
CAM link"
Transfer digital Images
DMI(rnk°
Download Distance Measuring
Instrument (DMI) data
XYTlink°
Capture Global Postponing System
(GPS) coordmaics from a Tumble
GPS recmver
BARImk°
Senn bar code mfonnanon
CarteGraph
98103LafOOt ph 4WUnv. Inc Sanaa, fnlm,opamis as seecineatmasmipen enchant MWM IMV. MIumw ll. Wmdmw, and at Maims brow tegMedirakmvk•orMa,s,fCminntxn Alluilreakmahsurrep,Wedlademarb unlit pngarwnf
Wee r upnnx looms
CITY OF ROSEMOUNT JOB DESCRIPTION
MAY 2005
POSITION TITLE: GIS Coordinator
DEPARTMENT: Public Works
ACCOUNTABLE TO: City Engineer
SUMMARY OF POSITION
Primarily responsible for development and administration of a well planned and
accurately integrated Geographic Information System (GIS) operation and systems
mapping, and Asset Management, to meet the goals and objectives of the City and
agencies of the City. Person requires minimum supervision and completes projects in a
timely manner. Responsible for performing application modifications, utilizing GIS
applications which produce reports in tabular and /or map form, incorporating menus,
macros and definition for linking relational databases to geographic databases.
Transfers /updates files for various departmental GIS systems as required.
ESSENTIAL DUTIES AND RESPONSIBILITIES
1. Provides assistance to City staff as required in the use of ArcCad, AutoCad, ArcView
and associated software for access to the City's database with special attention
directed towards programs that will alter or modify existing data.
2. Acts as a liaison, resource and support person for other departments. Responsible
for finding GIS solutions to business problems.
3. Updates and maintains "as- built" record data within the City database and
associated base maps database.
4. Work is generally independent in nature. The assignments and objectives are
prescnbed but the methods are not typically reviewed or controlled while the work is
in progress. The employee is expected to take the initiative in solving most
problems of detail, except those which are new or unusually complex in nature.
5. Manipulates graphic data and relates to attribute data for desired product.
6. Imports from various media, loads to database, checks and verifies data created by
other personnel and departments. When possible, distributes data to proper system
locations and data bases. Creates and maintains data files.
7. Manages and maintains the City GIS official map(s): i.e., street, utility, zoning, land
use, etc.
8. Analyzes and resolves problems with GIS and CAD computer hardware, software
and applications.
9. Reviews and recommends purchase of all GIS and CAD software /hardware
applications to ensure compatibility with City's overall system.
10.Aids in preparing programs and budgets for the Engineering Division.
11.Oversees and directs GIS staff when working on GIS operations, systems mapping,
or CAD /Civil drafting
12. Performs GIS analysis, application development, writes GIS applications to help
users interface with and analyze GIS data and which build reports in tabular and
map form incorporating on- screen menus, macros, key definitions and programming
language for linking relational database to the geographic database.
13. Manages and oversees the development and implementation of the City GIS and
participates in the budgeting process.
14. Performs such other duties as assigned.
MINIMUM QUALIFICATIONS
1. Four years experience in Geographic Information Systems using ARC /INFO,
ArcView, Relational Data Bases and Computer Aided Drafting experience using
AutoCAD or combination of experience and education.
2. Equivalency of a bachelor's degree (master's degree preferred) in Geographic
Information Systems, Computer Science, or directly related field. Strong preference
given for GIS certifications on at least two types of software.
DESIRABLE QUALIFICATIONS
1. Experience working for local government.
2. One year experience administrating a Windows NT Server.
3. Knowledge of Computerized Mapping Techniques.
4. Knowledge of survey methods and techniques.
5. Five years experience in the planning, designing, construction, inspection and
maintenance of Public Works Projects or combination experience and education.
NECESSARY KNOWLEDGE, SKILLS AND ABILITIES
1 Knowledge of computers, experience using GIS software with NT workstations
required and ARC /INFO preferred; GIS or AM /FM computer experience is required.
LAN experience; networking of PC's or workstation is desired.
2. Mastery of the GIS software and hardware and a desire to explore the capabilities to
obtain maximum utilization of the system. Should be innovative in testing the limits
of the GIS.
3. Knowledge of Coordinate Geometry, Electronic Data Collectors, and Land Survey
practices.
4. Thoroughly familiar with all GIS and mapping procedures, symbols, supplies,
equipment, and have the ability to read and understand maps, schematic drawings
and diagram and instruction manuals.
5. The ability to work independently, make decisions, assign projects, and follow
projects through to completion as required by responsibilities and authorities in this
position description.
6. Must possess a working knowledge of all maps and files relating to the mapping and
data base structure.
7. Considerable ability to analyze and resolve problems with GIS computer hardware,
software and applications.
8. Must determine and implement new procedures regarding methods used for GIS
and mapping.
9. Must accept multiple tasks and be adaptable to a variety of disciplines and requests.
10. Must communicate effectively both verbally and written, to assure that applications
are developed with the end user's best interest and ease of use in mind.
11. Must have a willingness to share knowledge and work harmoniously with others.
12.Ability and knowledge to train technicians and operators.
13 Ability to coordinate with City Departments, County and Utility Companies who need
expertise and assistance with GIS and CAD projects.
14. Ability to reason through project and determine best way to solve using various
modules of GIS and CAD software.
The person in this position must be competent in one or a combination of any of
the following projects:
GEOGRAPHIC INFORMATION SYSTEM DATABASE MANAGEMENT
Knowledge and skill for loading of graphic files and extracting of graphic files by
layers, classification and location.
Knowledge and ability to check and verify data received from aenal photography
stereo digitizing.
Knowledge in file format needed for the exchange of data between different
mapping and GIS systems.
Knowledge of quality control procedures to insure data integrity.
Knowledge and ability to maintain accuracy and integrity of the GIS database.
Knowledge in how each agency interfaces in GIS.
Knowledge of data source information.
GEOGRAPHIC INFORMATION SYSTEM APPLICATION DEVELOPMENT
Ability to recognize new potential for GIS use.
Knowledge of techniques for indexing, optimizing, and relating various
components of the GIS data.
Knowledge of file types and how to convert between them.
Knowledge of operating system environment (NT).
Knowledge and ability to prepare Procedure Documentation.
Knowledge of Application Programming Language (AML).
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by
an employee to successfully perform the essential functions of the position. The
employee is frequently required to walk, sit, talk and hear. The employee is
occasionally required to use hands to finger, hand, feel or operate objects; and reach
out with hands and arms. The employee is occasionally required to climb or balance,
stoop, kneel or crouch. The employee can occasionally be required to stand for
extended periods of time. The employee must occasionally lift and/or move up to 50
pounds. Specific vision abilities required by this job include vision, distance vision,
peripheral vision, depth perception and the ability to adjust focus.
WORK ENVIRONMENT
The work environment characteristics described here are representative of those an
employee encounters while performing the essential functions of this job. Noise level in
the work environment is usually fairly quiet while in the office, although the ability to
work with constant noise distractions is required.
The duties listed above are intended only as illustrations of the various types of work
performed and are not all- inclusive. This job description does not constitute an
employment agreement between the employer and the employee, and is subject to
change by the employer as the needs of the employer and requirements of the job may
change.
STATUS
Exempt
Reviewed by:
Dawn Weitzel, Assistant City Administrator Jamie Verbrugge, City Administrator
CITY OF ROSEMOUNT JOB DESCRIPTION
MAY 2005
POSITION TITLE: Staff Engineer
DEPARTMENT: Public Works
ACCOUNTABLE TO: City Engineer
SUMMARY OF POSITION
Under the general direction of the City Engineer, the Staff Engineer's responsibilities
include performing planning, technical and administrative duties to ensure that public
improvements and private developments (residential, commercial, industrial) conform
with applicable engineering standards, ordinance requirements, and policy guidelines.
ESSENTIAL DUTIES AND RESPONSIBILITIES
1. Reviews private project development plans for compliance with codes, regulations,
and standards, adequacy of applications for permits and compliance with approved
plans.
2. Coordinates and administers wetland programs and permits.
3. Responds to public or other inquiries relative to engineering policies and procedures
on specific projects and other information. Evaluates issues and options regarding
municipal public works and make recommendations.
4. Provides customer service, responding to citizen inquiries over the telephone and in
person at the City Hall engineering office.
5. Reviews construction plans and record drawings of builders /developers, particularly
as they relate to site grading, erosion control, utility construction and drainage on
private property to insure conformance to city policy or other requirements.
6. Completes annual MnDOT state aid reports including: Certification of Mileage,
mapping status reports and construction needs updates.
7. Reviews preliminary plats, preliminary utility plans, grading plans, final plats,
construction plans, drawings, and specifications submitted by consultants,
engineers, and developers to determine whether they conform to City
comprehensive plans, guidelines, policies, ordinances and engineering standards.
8. Prepares written recommendations to City departments, committees, commissions,
and the City Council.
9. Remain up -to -date on all specifications, regulations, codes, construction practices
and generally accepted engineering standards.
10. Help address and resolve residents, developers, and property owners concerns.
11.Assist in implementing engineering activities conducted by the Engineering Division.
12. Establishes and maintains effective working relationships with other City
Departments.
13. Keeps supervisor promptly informed of significant developments in areas of
accountability.
14. Performs such other duties as assigned.
MINIMUM QUALIFICATIONS
1. A Bachelor's Degree in Civil Engineering or related municipal engineering field and
Engineer In Training (E.I.T.) Certification.
2. Minimum of six months experience in municipal engineering.
3. A valid driver's license.
4. Ability to drive personal or city vehicle.
5. Bachelor's Degree in Civil Engineering.
6. Proficiency in word processing, spreadsheet, and database softwares.
DESIRABLE QUALIFICATIONS
1. Construction and surveying experience.
2. Previous experience as a Staff Engineer.
3. Proficiency in computer- aided design software, pavement management system,
Microsoft PowerPoint, and a Geographic Information System.
NECESSARY KNOWLEDGE, SKILLS AND ABILITIES
1. Demonstrates completeness, accuracy, and timeliness in plan review, written reports
and supporting data.
2. Demonstrates knowledge of engineering standards, construction techniques, and
municipal development procedures and practices.
3. Demonstrates ability to work independently, making decisions based upon
established City policy, standards or requirements
4. Demonstrates ability to coordinate with the work of others and to receive direction
from supervisor.
5. Demonstrates an ability to communicate clearly and effectively, both orally and in
writing
6. Demonstrates ability to establish and maintain effective communications with
citizens, property owners, developers, consultants, contractors, members of boards,
commissions and task forces, representatives of other public agencies, City
employees and officials.
7. Demonstrates ability to manage numerous projects performed by several
consultants in coordination with other review /regulatory agencies.
8. Demonstrates computer knowledge and ability to use computer in carrying out duties
and responsibilities.
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by
an employee to successfully perform the essential functions of the position. The
employee is frequently required to walk, sit, talk and hear. The employee is
occasionally required to use hands to finger, hand, feel or operate objects; and reach
out with hands and arms. The employee is occasionally required to climb or balance,
stoop, kneel or crouch. The employee can occasionally be required to stand for
extended periods of time. The employee must occasionally lift and /or move up to 50
pounds. Specific vision abilities required by this job include vision, distance vision,
peripheral vision, depth perception and the ability to adjust focus.
WORK ENVIRONMENT
The work environment characteristics described here are representative of those an
employee encounters while performing the essential functions of this job. Reasonable
accommodations may be made to enable individuals with disabilities to perform the
essential functions of the job.
While performing the duties of this job, the employee occasionally works in outside
weather conditions. The employee occasionally works near moving mechanical parts
and in high, precarious places and is occasionally exposed to wet and /or humid
conditions, fumes or airborne particles, toxic or caustic chemicals, risk of electrical
shock and vibration.
The noise level in the work environment is usually quiet to moderate.
The duties listed above are intended only as illustrations of the various types of work
performed and are not all- inclusive. This job description does not constitute an
employment agreement between the employer and the employee, and is subject to
change by the employer as the needs of the employer and requirements of the job may
change.
STATUS
Non Exempt
Reviewed by:
Dawn Weitzel, Assistant City Administrator Jamie Verbrugge, City Administrator
Vacant position
$45,666 57,831
Vacant position
$45,666 57,831
Sr. Engineering
Water Resources
Tech.
Tech.
Replacement
$48,028 60,090
Replacement
$43,825 55,452
GIS Coordinator
Staff Engineer
Difference
$2,362 2,259
($1,841 2,379)