{"id":175301,"date":"2019-02-01T11:06:44","date_gmt":"2019-02-01T19:06:44","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcnews&#038;p=175301"},"modified":"2023-09-29T14:54:01","modified_gmt":"2023-09-29T21:54:01","slug":"gis-integrates-and-transforms-sewer-operations","status":"publish","type":"arcnews","link":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations","title":{"rendered":"GIS Integrates and Transforms Sewer Operations"},"author":1312,"featured_media":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"sync_status":"","episode_type":"","audio_file":"","castos_file_data":"","podmotor_file_id":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","itunes_episode_number":"","itunes_title":"","itunes_season_number":"","itunes_episode_type":"","_links_to":"","_links_to_target":""},"categories":[],"tags":[],"arcnews_issues":[237352],"class_list":["post-175301","arcnews","type-arcnews","status-publish","format-standard","hentry","arcnews_issues-fall-2013"],"acf":{"short_description":"San Francisco's hilly terrain that so readily defines the city also poses special challenges for area utilities.","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"<h2 class=\"subheading\" style=\"text-align: center;\">For the San Francisco Public Utilities Commission, Benefits Abound<\/h2>\r\nSituated on the Northern California coastline, San Francisco is consistently among the top tourist destinations in the world. Rich in history and culture, the \"City by the Bay\" is home to iconic landmarks, such as the Golden Gate Bridge, cable cars, Alcatraz, Fisherman's Wharf, and the famed Chinatown district. The city also is known for its striking architecture and notably steep, rolling hills."},{"acf_fc_layout":"sidebar","layout":"standard","image_reference":null,"image_reference_figure":"","spotlight_image":null,"section_title":"","spotlight_name":"","position":"Center","content":"<div class=\"highlights\">\r\n<h2>Highlights<\/h2>\r\n<ul>\r\n \t<li>Create work orders directly from service requests and aggregate duplicate service calls.<\/li>\r\n \t<li>Assign asset IDs to service call addresses in one system.<\/li>\r\n \t<li>Access up-to-date asset\/location information even in the field because of improved asset data quality.<\/li>\r\n<\/ul>\r\n<\/div>","snippet":""},{"acf_fc_layout":"content","content":"The hilly terrain that so readily defines the city also poses special challenges for area utilities, such as the San Francisco Public Utilities Commission (SFPUC). Rain events can produce flooding so significant that SFPUC can generate up to 100 service requests\/work orders an hour. The question for SFPUC becomes, How do we mitigate these calls and deploy staff quickly to resolve the problem? While the problem simply may be clogged storm water drains, if not handled swiftly, intense flooding threatens to damage nearby homes."},{"acf_fc_layout":"image","image":175421,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>The Challenge at SFPUC<\/h2>\r\nSFPUC Wastewater Enterprise operates and maintains 993 miles of combined sewers, collecting sanitary sewage from homes and businesses and street runoff. It also operates and maintains storage facilities and three sanitary sewage and storm water treatment plants.\r\n\r\nThe immediate need in SFPUC's Sewer Operations was to resolve the disconnect that existed between the work order and asset management system and the field service work taking place. As existing users of ArcGIS and IBM Maximo, staff could view asset data in tabular format within the work and asset management system and see assets using ArcGIS but could not view assets and work orders in proximity to each other.\r\n\r\nThe existing process was tedious and time-consuming. Sewer Operations received service calls based on address\/service locations. Calls were converted into work orders and assigned to field personnel on 3 x 5 cards. Work orders were then assigned manually to assets by looking up asset IDs in GIS and copying the information into work orders.\r\n\r\n\"We had two islands of information that were not connected,\" says Lewis Harrison, manager, SFPUC's Wastewater Collection System Division. \"There was a synergy there just waiting to happen.\"\r\n\r\nSFPUC sought to integrate its existing GIS with IBM Maximo Spatial Asset Management to resolve workflow issues and help address other challenges, including the following:\r\n<ul>\r\n \t<li><em>Odor issues<\/em>\u2014Visualizing on a map to better understand and solve calls relating to odor issues<\/li>\r\n \t<li><em>Intersection flooding<\/em>\u2014Responding quickly and efficiently to emergencies caused by heavy rains and identifying hot spots using GIS, asset data, and location data from incoming calls<\/li>\r\n \t<li><em>Duplicate work orders<\/em>\u2014Eliminating multiple work orders opened on the same service issue<\/li>\r\n \t<li><em>Asset data<\/em>\u2014Identifying key assets in the sewer system<\/li>\r\n \t<li><em>Access to data in the field<\/em>\u2014Reducing time and travel to obtain asset information and perform service<\/li>\r\n \t<li><em>Formalized asset management program<\/em>\u2014Developing a program to better understand asset condition and life cycle costs<\/li>\r\n<\/ul>"},{"acf_fc_layout":"image","image":175431,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Esri Silver Tier Partner EMA, Inc. (St. Paul, Minnesota), was selected to help the utility with the implementation. EMA's experience with GIS, asset management, and technology integrations supported SFPUC's goal to create tools that would enable service calls and assets to be viewed geospatially.\r\n\r\n\"Our work order history needed to be visible on the map,\" Harrison says. \"Integration of our data and systems was key.\"\r\n<h2>The Project<\/h2>\r\nThe project team identified the functional requirements of the integration and designed and developed solutions during the project's pilot phase. Implementation in Sewer Operations included a workflow gap analysis, configuration with the work and asset management system and geodatabases, data loading, synchronization, and testing.\r\n<h3>ArcGIS Interaction with Spatial<\/h3>\r\nUsing an ArcGIS API for JavaScript technology platform, maps were embedded inside Maximo screens, allowing users to interact and perform common GIS tasks and to access and view their data on actual maps.\r\n<h3>Integrating GIS and Asset Database<\/h3>\r\nGIS data resides outside the asset database in a separate geodatabase. GIS feature classes are registered as objects in the asset database, keeping the data separate but available for use in all systems. GIS attribute data would be fully accessible via the geodatabase interface, which would use an Esri SQL API to integrate the database. The direct link between the geodatabases would eliminate any need to replicate data.\r\n\r\nKey aspects of the implementation included the following:\r\n<ul>\r\n \t<li>Redefining\/Recasting assets to address existing data errors<\/li>\r\n \t<li>Securing GIS data steward services with another city department to ensure timely data updating<\/li>\r\n \t<li>Training both before and after launch that encouraged active participation and feedback, kept everyone informed, and supported the project's success<\/li>\r\n \t<li>Integrating with San Francisco's 311 (citywide 24-hour customer service center) to leverage the citizen service request and dispatch system<\/li>\r\n<\/ul>\r\n<h2>Benefits<\/h2>\r\nThe new functionality brought monumental improvements to the wastewater enterprise. The project improved the planning, scheduling, and dispatching of work in Sewer Operations by enabling staff to see what work is being done and where. Staff can cluster incoming service calls to identify problem areas to deploy crews rapidly, particularly during storm events.\r\n\r\n\"In the past, we were not concerned about the type of equipment that responded to a site but just that someone was responding,\" Harrison explains. \"Now we're looking at our screens, understanding more about a problem, and determining what kind of equipment to send.\"\r\n\r\nWorkflow improvements have eliminated multiple work orders for a service issue and reduced the dispatching of multiple service crews to the same site. At the same time, <a href=\"https:\/\/www.esri.com\/en-us\/industries\/needs\/asset-tracking-analysis\">asset management tools<\/a> are efficiently tracking and planning maintenance work.\r\n\r\n\"The increased knowledge we have on the state of our assets helps us with our maintenance, repair, and replacement decisions,\" Harrison says.\r\n\r\nArcGIS query capabilities can be performed within the work and asset management system, and asset data and location data is up-to-date\u2014even for those in the field.\r\n\r\n\"Data quality has improved dramatically,\" says Lily Dryden, enterprise GIS coordinator at SFPUC. \"Field service crews redline errors in the field and send them to our GIS data steward via the work order. Updates are seen within a day, so our knowledge on field conditions is reflected on our GIS maps.\"\r\n\r\nFor more information, contact\u00a0<a href=\"mailto:ldryden@sfwater.org\">Lily Dryden<\/a>, enterprise GIS coordinator, San Francisco Public Utilities Commission, or\u00a0<a href=\"mailto:ddisera@ema-inc.com\">Dave DiSera<\/a>, vice president and IT practice director, EMA, Inc.."}],"references":null},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GIS Integrates and Transforms Sewer Operations | Fall 2013 | ArcNews<\/title>\n<meta name=\"description\" content=\"San Francisco&#039;s hilly terrain that so readily defines the city also poses special challenges for area utilities.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GIS Integrates and Transforms Sewer Operations\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations\" \/>\n<meta property=\"og:site_name\" content=\"Esri\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-29T21:54:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-dark-grey-card.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@Esri\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\/\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations\",\n\t            \"name\": \"GIS Integrates and Transforms Sewer Operations | Fall 2013 | ArcNews\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2019-02-01T19:06:44+00:00\",\n\t            \"dateModified\": \"2023-09-29T21:54:01+00:00\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations#breadcrumb\",\n\t            \"itemListElement\": [\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 1,\n\t                    \"name\": \"Home\",\n\t                    \"item\": \"https:\/\/www.esri.com\/about\/newsroom\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 2,\n\t                    \"name\": \"ArcNews Articles\",\n\t                    \"item\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 3,\n\t                    \"name\": \"GIS Integrates and Transforms Sewer Operations\"\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/\",\n\t            \"name\": \"Esri\",\n\t            \"description\": \"Esri Newsroom\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"Person\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/07c9626c724f42455e6bbe3102fd1a31\",\n\t            \"name\": \"Tony Beshay\",\n\t            \"image\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/\",\n\t                \"url\": \"https:\/\/secure.gravatar.com\/avatar\/1ed4c97e865db254f2377bf7343801377bdf3935c4b65b54b3944483c5f89b63?s=96&d=blank&r=g\",\n\t                \"contentUrl\": \"https:\/\/secure.gravatar.com\/avatar\/1ed4c97e865db254f2377bf7343801377bdf3935c4b65b54b3944483c5f89b63?s=96&d=blank&r=g\",\n\t                \"caption\": \"Tony Beshay\"\n\t            },\n\t            \"url\": \"\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"GIS Integrates and Transforms Sewer Operations | Fall 2013 | ArcNews","description":"San Francisco's hilly terrain that so readily defines the city also poses special challenges for area utilities.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations","og_locale":"en_US","og_type":"article","og_title":"GIS Integrates and Transforms Sewer Operations","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2023-09-29T21:54:01+00:00","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-dark-grey-card.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@Esri","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations","url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations","name":"GIS Integrates and Transforms Sewer Operations | Fall 2013 | ArcNews","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2019-02-01T19:06:44+00:00","dateModified":"2023-09-29T21:54:01+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/gis-integrates-and-transforms-sewer-operations#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"ArcNews Articles","item":"https:\/\/www.esri.com\/about\/newsroom\/arcnews"},{"@type":"ListItem","position":3,"name":"GIS Integrates and Transforms Sewer Operations"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/about\/newsroom\/#website","url":"https:\/\/www.esri.com\/about\/newsroom\/","name":"Esri","description":"Esri Newsroom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/07c9626c724f42455e6bbe3102fd1a31","name":"Tony Beshay","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1ed4c97e865db254f2377bf7343801377bdf3935c4b65b54b3944483c5f89b63?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ed4c97e865db254f2377bf7343801377bdf3935c4b65b54b3944483c5f89b63?s=96&d=blank&r=g","caption":"Tony Beshay"},"url":""}]}},"sort_order":"17","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/175301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews"}],"about":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/types\/arcnews"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/users\/1312"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/175301\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=175301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=175301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=175301"},{"taxonomy":"arcnews_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews_issues?post=175301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}