Real-Time Notifications Dashboard Using Cityworks & Operations Dashboard
Create a dashboard for real-time notifications using Cityworks and Operations Dashboard to monitor work orders, asset management, and critical information. Utilize GIS-centric tools for efficient data visualization and decision-making. Enhance operational efficiency and collaboration within the organization.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Creating a Dashboard for Real-Time Notifications Using Cityworks and Operations Dashboard Presented by: Kelly Haws April 26, 2018 GEOG 596A Project Proposal Adviser: Jim Detwiler
Background Sewer & Water Utility Cityworks-Field Operations captures work order data Implemented in 2008 Over 1,000 Open work orders Re-implemented in Dec. 2017 SQL Server 2014
Cityworks Asset Management Program GIS-centric Uses one map SDE GIS updates are automatically shown.
Project Proposal Develop a dashboard using Esri s Operations Dashboard Boil Advisories and Water Main Breaks For use internally and for customers
Operations Dashboard See -in one view- all the information needed to make decisions Monitor the most important information about your day-to-day operations Ensure all your colleagues are on the same page, through viewing and using the same information Monitor the health of a business, product, organizational team, or campaign Create a personalized view of a larger set of data, to show all the metrics that matter to you No programming
Operations Dashboard Figure 5. Some Example Operations Dashboard in ArcGIS Apps & Resources. Example of Law s Heroin/Fentanyl Overdose Deaths in Will County, IL Operations Dashboard.
Literature Review: St. Johns County, FL Figure 3. Hurricane Matthew Preparedness & Recovery with Cityworks. Map created by St. John s County using Esri s Web App Builder to show service requests captured in Cityworks.
Literature Review: Columbia County, GA Hurricane Irma Cityworks Operations Dashboard & Web App Builder
Methodology Microsoft SQL views Spatial views ArcMap ArcGIS Server ArcGIS Online Operations Dashboard
Data Sources: Cityworks Screenshot of a Closed work order for a Pass Out Boil Notice.
Data Source: Cityworks Screenshot of an Open work order for a Repair Main Break.
Future Dashboard: Water Boil Advisory Zoomed in Zoomed out
User Testing Status of work orders Browser Devices Testing by non-GIS users
Foreseeable Issues Ensuring correct data selection Correct Cityworks work order status Missing features in GIS City of Miami, FL Cityworks upgrade Cityworks work order name changes
Timeline 6 Months 2 Months - Dashboard 4 Months - Testing Presentation Esri s Water Conference Nashville, TN February 4, 2019
Sources Baird, G (2017, February). Hurricane Matthew Preparedness & Recovery with Cityworks. Retrieved March 12, 2018 from http://proceedings.esri.com/library/userconf/water17/papers/water_08.pdf Butler, R (2018, February) Disaster Preparation and Recovery. Retrieved March 12, 2018 from http://woolpert.com/wp-content/uploads/2018/02/DisasterPrep.pdf Castro, A (2015). Miami Beach Calls in the Inspector (ArcGIS & Cityworks) to Investigate Sewer Line Breaks. InPrint, 2015. Retrieved March 19, 2018 from http://www.cityworks.com/wp-content/uploads/2016/01/InPrint_Fall-2015_Web.pdf Donia, K (2017). Configure Your First Dashboard. GeoNet The Esri Community. Retrieved April 13, 2018 from https://community.esri.com/community/gis/applications/operations-dashboard-for-arcgis/blog/2017/12/07/configure-your-first-dashboard Esri (2017). Example: Creating a spatial view in SQL Server. ArcMap. Retrieved April 15, 2018 from http://desktop.arcgis.com/en/arcmap/10.5/manage-data/using-sql-with-gdbs/example-creating-a-spatial-view-in-sql-server-using-sql.htm Esri (2017). What are the Requirements? Operations Dashboard for ArcGIS Online. Retrieved April 5, 2018 from https://doc.arcgis.com/en/operations-dashboard/faqs/requirements.htm Esri (2018). Configure Clustering. ArcGIS Online Help. Retrieved April 12, 2018 from https://doc.arcgis.com/en/arcgis-online/create-maps/configure-clustering.htm Esri (2018). Feature Service. ArcGIS Rest API. Retrieved April 5, 2018 from https://developers.arcgis.com/rest/services-reference/feature-service.htm Esri (2018). Filter Data. Operations Dashboard for ArcGIS Online. Retrieved April 12, 2018 from https://doc.arcgis.com/en/operations-dashboard/help/filter-data.htm Esri (2018). Map Service. ArcGIS Rest API. Retrieved April 5, 2018 from https://developers.arcgis.com/rest/services-reference/map-service.htm Esri (2018). Set Refresh Interval. ArcGIS Online Help. Retrieved April 12, 2018 from https://doc.arcgis.com/en/arcgis-online/create-maps/set-refresh-interval.htm Learning SQL (2007). Beginner SQL Tutorial. Retrieved April 15, 2018 from http://beginner-sql-tutorial.com/sql-views.htm Olmstead, K (2017, May). A third of Americans live in a household with three or more smartphones. Pew Research Center. Retrieved April 25, 2018 from http://www.pewresearch.org/fact-tank/2017/05/25/a-third-of-americans-live-in-a-household-with-three-or-more-smartphones/
