cityworks® by azteca systems · pdf file– gis is much more then “maps in our...
TRANSCRIPT
Public Works Seminar 2007Public Works Seminar 2007 11
CityworksCityworks®® byby Azteca SystemsAzteca Systems
Brent WilsonBrent WilsonSr. Account ManagerSr. Account Manager
Azteca SystemsAzteca Systems
Public Works Seminar 2007Public Works Seminar 2007 22
Work Order Management and Permitting Work Order Management and Permitting with Cityworkswith Cityworks
Public Works Seminar 2007Public Works Seminar 2007 33
•• Exclusive ESRI Developer PartnerExclusive ESRI Developer Partner•• In Business Since 1986In Business Since 1986
–– software development since 1996software development since 1996•• Based in Sandy UT a suburb of Salt Lake CityBased in Sandy UT a suburb of Salt Lake City
–– Midwest Regional Office Midwest Regional Office –– Denver, CODenver, CO–– Southeast Regional Office Southeast Regional Office –– Arlington, TX (DFW)Arlington, TX (DFW)–– Northeast Regional Office Northeast Regional Office –– Buffalo, NYBuffalo, NY–– Great Lakes Regional Office Great Lakes Regional Office –– South Bend, INSouth Bend, IN–– West Regional Office West Regional Office –– Seattle, WASeattle, WA
•• 50+ employees50+ employees
CityworksCityworks
Public Works Seminar 2007Public Works Seminar 2007 44
•• Market is government public works, utilities, permitting and codMarket is government public works, utilities, permitting and code e enforcementenforcement
•• 300+ clients primarily in the US, Canada, and Sweden300+ clients primarily in the US, Canada, and Sweden•• Pioneered GISPioneered GIS--centric asset maintenance management (a.k.a. centric asset maintenance management (a.k.a.
CMMS)CMMS)–– GIS is much more then GIS is much more then ““maps in our appsmaps in our apps””–– GIS is a core enterprise databaseGIS is a core enterprise database
•• Geodatabase is the asset repositoryGeodatabase is the asset repository•• Organizations want to leverage their investment GISOrganizations want to leverage their investment GIS
–– GIS data is nonGIS data is non--proprietary to any 3proprietary to any 3rdrd party applicationparty application–– Maximize openness and interoperabilityMaximize openness and interoperability
CityworksCityworks
Public Works Seminar 2007Public Works Seminar 2007 55
ESRI Platform SupportESRI Platform Support
•• ArcView 3.xArcView 3.x•• ArcGIS 8.x & 9.xArcGIS 8.x & 9.x
–– First application developed for ArcInfo 8.0First application developed for ArcInfo 8.0–– ESRI ESRI Foundation Partner of the YearFoundation Partner of the Year, 2000, 2005, 2000, 2005
•• ArcGIS EngineArcGIS Engine•• ArcGIS ServerArcGIS Server
Public Works Seminar 2007Public Works Seminar 2007 66
Cityworks GISCityworks GIS--Centric Computerized Centric Computerized Maintenance Management SystemMaintenance Management System
Public Works Seminar 2007Public Works Seminar 2007 77
FunctionalFunctional
•• Service RequestService Request•• Work OrderWork Order•• Feature InventoryFeature Inventory•• Asset trackingAsset tracking
Public Works Seminar 2007Public Works Seminar 2007 88
Cityworks Cityworks Service RequestService Request
•• 311 Customer Care311 Customer Care•• Receive callsReceive calls•• Track incidentsTrack incidents•• Search callsSearch calls•• Drive Service RequestsDrive Service Requests
Public Works Seminar 2007Public Works Seminar 2007 99
CapableCapable
•• InspectionsInspections•• TaskingTasking•• Track Track
–– LaborLabor–– MaterialsMaterials–– EquipmentEquipment
•• Cost summaryCost summary•• ReportingReporting
Public Works Seminar 2007Public Works Seminar 2007 1010
IntuitiveIntuitive•• CustomizableCustomizable
–– Work order templatesWork order templates–– User accessUser access–– Labor categoriesLabor categories–– EquipmentEquipment–– MaterialsMaterials–– EmployeesEmployees
Public Works Seminar 2007Public Works Seminar 2007 1111
EffectiveEffective
•• Full search capabilitiesFull search capabilities•• AdAd--Hoc ReportingHoc Reporting
Public Works Seminar 2007Public Works Seminar 2007 1212
Cityworks Cityworks StoreroomStoreroom
•• Track assetsTrack assets•• Warehouse managementWarehouse management•• RequisitionsRequisitions•• Transaction history Transaction history
Public Works Seminar 2007Public Works Seminar 2007 1313
Cityworks Desktop–– ArcMap extension (View, Edit, Info)ArcMap extension (View, Edit, Info)
•• Mature, reliable and rich functionalityMature, reliable and rich functionality•• Client/ServerClient/Server
Public Works Seminar 2007Public Works Seminar 2007 1414
Cityworks Anywhere–– ArcGIS EngineArcGIS Engine
•• Extends the same mature, reliable and rich functionality technolExtends the same mature, reliable and rich functionality technology ogy utilized by Desktoputilized by Desktop
Public Works Seminar 2007Public Works Seminar 2007 1515
Cityworks Server MMS–– ArcGIS ServerArcGIS Server
•• BrowserBrowser--based, Nbased, N--tier architecture, central admintier architecture, central admin
Public Works Seminar 2007Public Works Seminar 2007 1616
Cityworks Server MMSCityworks Server MMS
Public Works Seminar 2007Public Works Seminar 2007 1717
Performance DashboardPerformance Dashboard
Public Works Seminar 2007Public Works Seminar 2007 1818
User InboxUser Inbox
Public Works Seminar 2007Public Works Seminar 2007 1919
User Defined InterfaceUser Defined Interface
Public Works Seminar 2007Public Works Seminar 2007 2020
Centralized Work Activity Centralized Work Activity Configuration and ManagementConfiguration and Management
Cityworks®
Cross Compatibility Assurance
Cityworks DesktopCityworks Desktop
Cityworks ServerCityworks Server
Cityworks AnywhereCityworks Anywhere
Cityworks DesignerCityworks Designer
Public Works Seminar 2007Public Works Seminar 2007 2121
The Competitions Approach–– CMMSCMMS--centric approachcentric approach
•• CMMS databaseCMMS database•• Work activity dataWork activity data•• Asset Data Asset Data
(proprietary format)(proprietary format)•• Address DataAddress Data
•• Open GISOpen GIS
•• Asset data proprietary to Asset data proprietary to CMMSCMMS
•• Address dataAddress data
Middleware Interface
XYZCMMS
Duplicate data
CMMS GIS viewed as just maps
Public Works Seminar 2007Public Works Seminar 2007 2222
Cityworks Approach–– GISGIS--centric CMMScentric CMMS
•• Unique in the IndustryUnique in the Industry
•• Open GISOpen GIS•• Asset dataAsset data•• Address dataAddress data
•• Cityworks databaseCityworks database•• Work activity dataWork activity data•• Performance ReportsPerformance Reports
Public Works Seminar 2007Public Works Seminar 2007 2323
InteroperabilityDifferent applications sharing data
Web Browser
Web ServiceWeb
Service
Homogeneous data serverIntegrating applications that utilize a common and shared Geodatabase
Maintenance Management
Pavement Management
Hydro Modeling Design Build
OpenGeodatabase
Public Works Seminar 2007Public Works Seminar 2007 2424
Cityworks Field Deployment OptionsCityworks Field Deployment OptionsA
rcVi
ewA
rcEd
itor
Arc
Info
Arc
Serv
erA
rcEn
gine
Stan
dalo
neN
O G
IS
C
i t
y
w
o r
k
s
D
e s
k
t
o p
C
i t
y
w
o r
k
s
D
e s
k
t
o p
Cityworks is the CMMS leader in ESRI GIS scalability
Cityworks ServerCityworks Server
Disconnected Wireless /Disconnected Wireless /Synchronized DatabasesSynchronized Databases
DATAPUMPDATAPUMP
RealReal--Time WirelessTime WirelessLAN / WANLAN / WAN
Cell Phone TechnologyCell Phone TechnologyCitrix or Terminal ServerCitrix or Terminal Server
WirelessWirelessDa
tapu
mp
Data
pum
p
Laptops & Tablets
Public Works Seminar 2007Public Works Seminar 2007 2525
Operational AwarenessOperational Awareness
City Manager / MayorCity Manager / Mayor
DepartmentDepartmentDirector / ManagerDirector / Manager
DivisionDivisionSupervisorSupervisor
ParkPark&&
TreesTreesAirportsAirports
ElectricElectric&&
GasGas
PublicPublicWorksWorks
UtilitiesUtilities&&
PlantsPlants
CO
MM
UN
ICA
TION
COORDINATION
Public Works Seminar 2007Public Works Seminar 2007 2626
Cityworks SolutionCityworks Solution
•• Helps Increase Coordination Between DepartmentsHelps Increase Coordination Between Departments•• Helps Improve Communication Between Helps Improve Communication Between Management and StaffManagement and Staff
Public Works Seminar 2007Public Works Seminar 2007 2727
Business Case Business Case –– Oklahoma City, OKOklahoma City, OK
“We utilize our ESRI GIS system to attach the work orders to specific assets, so we can visually track where the work is being done using custom map services written by our GIS team,”explained Stan Reichert, IT project manager with Oklahoma City. “Since Cityworks has such tight integration with GIS, our users can now utilize Cityworks and GIS simultaneously and increase the quality and quantity of their work. Utilizing the data that is collected in Cityworks, the Water Department engineers can be proactive in the decisions they make to spend money on infrastructure repairs and replacements.”
Stan Reichert – IT Project ManagerCity of Oklahoma City
Public Works Seminar 2007Public Works Seminar 2007 2828
Improving Customer ServiceImproving Customer Service
Crew LeaderCrew Leader SupervisorSupervisor
Call TakerCall Taker DirectorDirectorConcerned CitizenConcerned Citizen
II’’ll getll getsomeone onsomeone onthat for youthat for you
II’’ll need to ll need to transfer transfer
youyou
I have a I have a problemproblem
WhereWhere’’s s the the
problem?problem?
I donI don’’t t know!know!
II’’ll find outll find out
BEFORE YOU KNOW IT!!!!!BEFORE YOU KNOW IT!!!!!
Public Works Seminar 2007Public Works Seminar 2007 2929
Improving Customer ServiceImproving Customer Service
Crew LeaderCrew Leader SupervisorSupervisor
Call TakerCall Taker DirectorDirector
II’’ll get ll get someone someone on thaton that
I have a I have a problemproblem
Concerned CitizenConcerned CitizenWorkflow Takes Workflow Takes
Place In The SystemPlace In The SystemIssue Is CompletedIssue Is CompletedAnd Closed In TheAnd Closed In The
CMMSCMMSEveryone Everyone
Including The Citizen Including The Citizen Can Get Can Get
An Update AutomaticallyAn Update Automatically
Public Works Seminar 2007Public Works Seminar 2007 3030
Cityworks SolutionCityworks Solution
•• Standardized WorkflowStandardized Workflow•• Eliminate DuplicationEliminate Duplication•• Improve EfficiencyImprove Efficiency
Public Works Seminar 2007Public Works Seminar 2007 3131
Business Case Business Case –– Durham, NCDurham, NCDurham One Call officially opened for business on 6/21/2004. When the first call came into the center, no one had any idea how quickly a centralized calling concept would take off in our community. Over the last two years, Durham One Call has continued to improve on our communication, our procedures, and our processes to deliver a quality experience to our contactors. Here are just a few of our accomplishments through 6/20/2006:
• Received over 441, 000 calls• Assisted in over 423,000 Customer Relationship Transactions• Answered over 412,500 calls or 93.4%• Created over 40,000 requests for City services• Categorized 98% of answered calls• Reached a Citizen Satisfaction rating of 93%
The program we provide to our community is envied and serves as a model for otherorganizations seeking to centralize functions.
Scott B. Reed, AGCCE-TreasurerCity of Durham, City Manager's OfficeDurham One Call, Division Manager
Public Works Seminar 2007Public Works Seminar 2007 3232
Business Case Business Case –– Whitehouse, TNWhitehouse, TN
The area of the study looked at the number of common service requests and work orders assigned to field maintenance staff and the time required to complete the assigned tasks. The total number of service requests and work orders created for the time period January to March 2004 equaled 2,547. For the stated time period after the implementation of Cityworks, the number equaled 859, a 66% decrease. In addition, the man hours needed to complete assigned work dropped from approximately 204 hours to approximately 85 hours, a 58% decrease. The District realized a nearly three-fold reduction in the number of service requests and work orders assigned to fieldmaintenance staff and an equally dramatic reduction in the number of hours required to perform assigned tasks. The Cityworks implementationcorresponded with a significant decrease in the number of service requests and work orders created and the hours needed to complete assigned work.
Dawn SummersProject ManagerWhitehouse Utilities District
Public Works Seminar 2007Public Works Seminar 2007 3333
Fiscal ManagementFiscal Management
Public Works Seminar 2007Public Works Seminar 2007 3434
•• Ease of Access to Historical InformationEase of Access to Historical Information•• Improve Ability to Track and Forecast Budget RequirementsImprove Ability to Track and Forecast Budget Requirements
Cityworks SolutionCityworks Solution
Public Works Seminar 2007Public Works Seminar 2007 3535
Business Case Business Case –– St. JohnSt. John’’s County, FLs County, FL
“When using the Cityworks budgeting tools, everything comes into place by showing the costs associated with assets and mapping them out geographically,” says Rocky Agbunag, Asset Management Coordinator, St. John’s County. “The tools allow the Public Works Department to maximize our efficient use of resources and better describe our results, ideas and financial needs to upper management. In addition to many other benefits, the tools have given us a better estimate of how much will be spent in upcoming years to maintain our current level of service.”
Rocky AgbunagAsset Management CoordinatorSt. Johns County, FL
Public Works Seminar 2007Public Works Seminar 2007 3636
ReportingReporting
Public Works Seminar 2007Public Works Seminar 2007 3737
ReportingReporting
Public Works Seminar 2007Public Works Seminar 2007 3838
ReportingReporting
Public Works Seminar 2007Public Works Seminar 2007 3939
SummarySummary
•• Project Planning / CIPProject Planning / CIP•• TasksTasks•• Standardization With ScriptsStandardization With Scripts•• Speeds up TrainingSpeeds up Training•• Reduce / Eliminate Redundant RequestsReduce / Eliminate Redundant Requests•• Projects For Events (Storms, FEMA, NPDES)Projects For Events (Storms, FEMA, NPDES)•• Projects Pull Cost Together QuicklyProjects Pull Cost Together Quickly•• Reports For ManagementReports For Management
Public Works Seminar 2007Public Works Seminar 2007 4040
Overall SummaryOverall Summary
Operational AwarenessOperational AwarenessCoordination Between DepartmentsCoordination Between DepartmentsEvent LayersEvent LayersReportingReporting
Customer Service / Staff ResourcesCustomer Service / Staff ResourcesConfigurable Workflow Per Problem TypeConfigurable Workflow Per Problem TypeOne Look and FeelOne Look and Feel
Turn OverTurn OverLow ResourcesLow Resources
Poor Customer ServicePoor Customer ServiceReduce the number of Duplicate CallsReduce the number of Duplicate Calls
Infrastructure ManagementInfrastructure ManagementQuick Reporting CapabilitiesQuick Reporting CapabilitiesHow much did we spend on a certain O&M ActivityHow much did we spend on a certain O&M Activity
Operational ManagementOperational ManagementMobileMobile
Public Works Seminar 2007Public Works Seminar 2007 4141
PermittingPermitting
Public Works Seminar 2007Public Works Seminar 2007 4242
OverviewOverview
•• Technical Overview and Philosophy.Technical Overview and Philosophy.•• Product Review : Product Review : CityworksCityworks PermittingPermitting™™..
Public Works Seminar 2007Public Works Seminar 2007 4343
Technical Architecture and PhilosophyTechnical Architecture and Philosophy
Public Works Seminar 2007Public Works Seminar 2007 4444
New DesignNew Design
•• New development architecture New development architecture ––Uses latest development theory & practiceUses latest development theory & practice
•• New Entity Relationship DiagramNew Entity Relationship Diagram––Cityworks Permitting ERDCityworks Permitting ERD––Designed with Data Warehousing in mindDesigned with Data Warehousing in mind
•• Reviewed functionality needs and wants:Reviewed functionality needs and wants:––Users of Cityworks Maintenance ManagementUsers of Cityworks Maintenance Management––Potential users of CityworksPotential users of Cityworks
Public Works Seminar 2007Public Works Seminar 2007 4545
Environment: Microsoft .NetEnvironment: Microsoft .Net
•• Develop GUI in Develop GUI in ASP.NetASP.Net•• Middle tiers developed in C# (sharp)Middle tiers developed in C# (sharp)•• Supported databasesSupported databases
–– Oracle Oracle –– Microsoft SQL ServerMicrosoft SQL Server
•• Reasons for selection:Reasons for selection:–– Requests by clientsRequests by clients–– Rapid developmentRapid development–– NN--tier deploymenttier deployment
Public Works Seminar 2007Public Works Seminar 2007 4646
Database: SQL Server and Oracle
Internet Explorer reads the ASP. Net application
C # used to create the middle tier logic. GIS
Data
ESRI Tools
Public Works Seminar 2007Public Works Seminar 2007 4747
Cityworks PermittingCityworks PermittingModules and GUIModules and GUI
Public Works Seminar 2007Public Works Seminar 2007 4848
Objectives of New GUIObjectives of New GUI
•• High performance webHigh performance web--based systembased system–– can also run on an internal networkcan also run on an internal network
•• Standard user interfaceStandard user interface•• Summary screensSummary screens
–– Single source for informationSingle source for information
•• Rapid implementation toolsRapid implementation tools•• Function placed in two modulesFunction placed in two modules
–– Land ObjectsLand Objects–– Case ObjectsCase Objects
Public Works Seminar 2007Public Works Seminar 2007 4949
Land ObjectsLand Objects
Public Works Seminar 2007Public Works Seminar 2007 5050
Land ObjectsLand Objects
•• Allows for tracking of land related objectsAllows for tracking of land related objects•• Objects includeObjects include
–– ParcelsParcels–– Street segmentsStreet segments–– StructuresStructures–– EstablishmentsEstablishments–– SitesSites–– Customer specific objectsCustomer specific objects
•• Users can create any type of object desiredUsers can create any type of object desired
Public Works Seminar 2007Public Works Seminar 2007 5151
Object DetailsObject Details
•• Different types of data may be associated with an object:Different types of data may be associated with an object:–– Addresses Addresses
•• both Master and alias addressesboth Master and alias addresses–– People People
•• Owners, Taxpayers, Lawyers, Contacts, etc.Owners, Taxpayers, Lawyers, Contacts, etc.–– Zoning Zoning
•• Including both current and historical zonesIncluding both current and historical zones–– ConditionsConditions–– FlagsFlags–– Occupancy, Construction Type and UsesOccupancy, Construction Type and Uses–– Geographic AreasGeographic Areas–– Case, Permit and RFS or Enforcement historyCase, Permit and RFS or Enforcement history
Public Works Seminar 2007Public Works Seminar 2007 5252
Case ObjectsCase Objects
Applications, Permits, Licenses, Code Applications, Permits, Licenses, Code EnforcementEnforcement
Public Works Seminar 2007Public Works Seminar 2007 5353
Case ObjectsCase Objects
•• Provides transaction tracking functionsProvides transaction tracking functions•• Provides support for:Provides support for:
–– Application and PermitsApplication and Permits•• Planning, Public Works and Building permitsPlanning, Public Works and Building permits
–– Request for ServicesRequest for Services•• Code Enforcement and Service RequestsCode Enforcement and Service Requests
–– Business LicensesBusiness Licenses•• All renewal function of Licenses (release 2)All renewal function of Licenses (release 2)
Public Works Seminar 2007Public Works Seminar 2007 5454
Case ObjectsCase Objects
•• Different types of data may be associated with an object Different types of data may be associated with an object including:including:–– Addresses and land objectsAddresses and land objects–– PeoplePeople
•• Applicants, Owners, Developers, Emergency ContactsApplicants, Owners, Developers, Emergency Contacts–– Contactors and Licensed ProfessionalsContactors and Licensed Professionals–– FeesFees–– PaymentsPayments–– FlagsFlags–– Custom Data GroupsCustom Data Groups–– Workflow tasksWorkflow tasks
Public Works Seminar 2007Public Works Seminar 2007 5555
Workflow and InspectionsWorkflow and Inspections
•• Combined workflow for applications, permits, licenses and Combined workflow for applications, permits, licenses and code enforcementcode enforcement–– Tracks:Tracks:
•• Reviews Reviews •• HearingsHearings•• InspectionsInspections•• Enforcement stepsEnforcement steps
•• Fully integrated into case management with a single place Fully integrated into case management with a single place to look for all reviews, inspections and enforcement stepsto look for all reviews, inspections and enforcement steps
Public Works Seminar 2007Public Works Seminar 2007 5656
GUIGUI
Public Works Seminar 2007Public Works Seminar 2007 5757
QueriesQueries
Public Works Seminar 2007Public Works Seminar 2007 5858
SummarySummary
Public Works Seminar 2007Public Works Seminar 2007 5959
EditsEdits
Public Works Seminar 2007Public Works Seminar 2007 6060
CityworksCityworks®® -- The GISThe GIS--centric Local Government Suitecentric Local Government Suite
Client / ServerClient / ServerBrowser / ServerBrowser / Server
MMS AdminMMS Admin
Cityworks DesktopCityworks Desktop Cityworks AnywhereCityworks AnywhereCityworks MMSCityworks MMSCityworks PermitsCityworks Permits
Web ServiceWeb Service
Service Request APIService Request API
Permit AdminPermit Admin
AddAdd--onsonsStoreroomStoreroomEquipment MgrEquipment Mgr
InterfacesInterfacesCCTV, Paver, AVLCCTV, Paver, AVLOnBaseOnBase, , DigSmartDigSmartMiner & MinerMiner & MinerMWH SoftMWH Soft**
RouteSmartRouteSmart**
Tadpole Tadpole GoSyncGoSync**
*VIA NAGCS standards*VIA NAGCS standards
ArcGIS Server 9.2ArcGIS Server 9.2 ArcGIS ArcGIS ArcMapArcMap & & ArcEngineArcEngine 9.29.2
Public Works Seminar 2007Public Works Seminar 2007 6161
New Cityworks ELA AgreementNew Cityworks ELA Agreement
PopulationPopulation•• 00--25k 2525k 25--50k 5050k 50--100k100k•• This includes Unlimited Use of ALL our software:This includes Unlimited Use of ALL our software:•• Cityworks Cityworks -- Maintenance Management (includes Desktop, Anywhere & Maintenance Management (includes Desktop, Anywhere &
Server MMS) Server MMS) •• Storeroom Storeroom -- warehouse/inventory management warehouse/inventory management •• Equipment Manager Equipment Manager •• Pavement Analysis Interface Pavement Analysis Interface •• CCTV Interface CCTV Interface -- interface to PACP compliant CCTV Inspection interface to PACP compliant CCTV Inspection
Systems Systems •• Metrics API Metrics API -- components & APIcomponents & API enabling performance measurements enabling performance measurements
((egeg. SCADA) . SCADA) •• Service Request Web API Service Request Web API -- components & API enabling public requests components & API enabling public requests
via web via web •• Cityworks Permitting Cityworks Permitting -- NEW GISNEW GIS--centric permitting solution centric permitting solution
Public Works Seminar 2007Public Works Seminar 2007 6262
Questions?Questions?
Brent WilsonBrent WilsonSr. Account ManagerSr. Account ManagerDallas FortDallas Fort--Worth OfficeWorth [email protected]@azteca.com