{"id":201862,"date":"2019-01-21T23:55:40","date_gmt":"2019-01-22T07:55:40","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcnews&#038;p=201862"},"modified":"2021-09-01T19:05:29","modified_gmt":"2021-09-02T02:05:29","slug":"massachusetts-keeps-drinking-water-safe","status":"publish","type":"arcnews","link":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe","title":{"rendered":"Massachusetts Keeps Drinking Water Safe"},"author":1432,"featured_media":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"sync_status":"","episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","castos_file_data":"","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":[401,10652,14832],"tags":[18742,171542,209122,279132,179952],"arcnews_issues":[300072],"class_list":["post-201862","arcnews","type-arcnews","status-publish","format-standard","hentry","category-government","category-survey123-for-arcgis","category-water-resources","tag-inspections","tag-microsoft-flow","tag-recreation","tag-water","tag-water-quality","arcnews_issues-arcnews-winter-2019","arcnews_sections-your-work"],"acf":{"short_description":"Using Survey123 for ArcGIS and Microsoft Flow, water management staff save time and money conducting boat inspections.","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"<h2 style=\"text-align: center;\">Using Survey123 for ArcGIS and Microsoft Flow, Water Management Staff Save Time and Money Conducting Boat Inspections<\/h2>\r\nThe Quabbin Reservoir is one of only five major unfiltered drinking water supplies in the United States. It is part of the system that supplies water for more than 2.5 million residents in the Greater Boston area.\r\n\r\nWhile boat-based fishing is permitted in certain areas of the reservoir, the potential for those boats to introduce aquatic invasive species into the water supply is a real risk. That is why the Division of Water Supply Protection (DWSP), inside the Massachusetts Department of Conservation and Recreation\u2019s Office of Watershed Management, takes pains to protect the integrity of the Quabbin Reservoir and ensure that the only boats allowed onto it are contaminant-free."},{"acf_fc_layout":"image","image":201892,"image_position":"left","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"It does this via a boat seal program, whereby boaters wishing to use the reservoir must have their boats inspected, decontaminated, and sealed to their trailers by an unbreakable piece of wire with a special, numbered tag that DWSP tracks in a database. Only boats that pass the inspection are given a seal signifying that they are contaminant-free, which allows them to launch on the reservoir. And when these boats return to land, they are given new boat seals that tag them to their trailers. Boats without intact seals are prohibited from launching.\r\n\r\nThe boat inspection and decontamination program has historically relied on a combination of manual and paper-based workflows for scheduling inspections, maintaining seal data, and monitoring inspection activities. With about 200 boat inspections to perform each year, sustaining the various workflows throughout the entire process became inefficient.\r\n\r\n\u201cThere was a huge input of staff time\u2014over 700 hours annually\u2014on translating paper-based information into other systems,\u201d said Erica Tefft, DWSP\u2019s watershed GIS coordinator. \u201cIt was, frankly, an expensive waste of people\u2019s time that they could have used to do other things.\u201d\r\n\r\nThe program\u2019s management team\u2014DWSP director John Scannell, DWSP\u2019s Quabbin and Ware River assistant regional director Lisa Gustavsen, and DWSP\u2019s Quabbin and Ware River regional director Dr. Daniel Clark\u2014sought a modern, digital solution for managing the boat seal program. They wanted to <a href=\"https:\/\/www.esri.com\/en-us\/industries\/needs\/operational-efficiency\">streamline the data<\/a>, as well as all the manual processes DWSP\u2019s environmental quality section was using to administer the master boater database."},{"acf_fc_layout":"sidebar","layout":"standard","image_reference":null,"image_reference_figure":"","spotlight_image":null,"section_title":"","spotlight_name":"","position":"Right","content":"By implementing Survey123 for ArcGIS and the Survey123 Connector for Microsoft Flow, the Division of Water Supply Protection (DWSP) realized a 137 percent initial-year return on investment in labor costs for its boat inspection program.","snippet":""},{"acf_fc_layout":"content","content":"After attending the 2018 Esri User Conference and regional user group meetings, Tefft learned about Survey123 for ArcGIS, a formcentric solution for creating surveys, collecting answers, and analyzing results. Survey123 was perfectly suited to capturing the tabular type of data required for boat inspections. In addition, the Survey123 Connector for Microsoft Flow would allow surveys to be configured so that when submitted, a trigger would initiate an automated action, such as sending specific data to the Google Calendar and Google Sheets DWSP uses.\r\n\r\nFor the boat seal program, Tefft designed two Survey123 surveys that together replaced the original manual processes.\r\n\r\nThe first survey Tefft built was the Quabbin Boat Seal Appointment and Decontamination Survey. Staff at the Quabbin Reservoir Visitors Center use it on desktop computers to set boat inspection and decontamination appointments, while Quabbin Watershed rangers use it on iPads to record critical details, such as regulatory requirements for each boat and motor, during the on-site appointments.\r\n\r\nNext, Tefft built the Quabbin Boat Seal Program\u2014In\/Out Survey. Boat Launch Area (BLA) staff use this survey to check in boaters who have an inspection seal and sign them out with a new seal when they leave the water.\r\n\r\nThe two surveys capture all the data DWSP needs to ensure that the Quabbin Reservoir remains contaminant-free, including each boat owner\u2019s name and contact information, the boat registration number, the date of the decontamination, and the date and time of every launch."},{"acf_fc_layout":"image","image":201902,"image_position":"left","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"To get the survey-captured data to automatically flow into other systems, Tefft used the Survey123 Connector for Microsoft Flow. From the Quabbin Boat Seal Appointment and Decontamination Survey, the Convert Time Zones action is triggered to automatically detect the appointment date and time, adjust to the correct time zone, and create an end time to reflect a 20-minute duration. The Create an Event Flow is automatically triggered as well, which makes a Google Calendar event. Now, staff use the Google Calendar to see all the appointments for scheduled decontamination days, which eliminates the need to print out each day\u2019s itinerary.\r\n\r\nWhen BLA staff submit a Quabbin Boat Seal Program\u2014In\/Out Survey, it automatically triggers the Tag_InOut_Flow in Microsoft Flow. This sends the data to a master Google Sheet that BLA employees, staff in the environmental quality section, and Quabbin Watershed rangers use to monitor boat activity on the reservoir for any given day. Having this data available in real time allows watershed rangers to know who is on or off the water at all times, satisfying a long-standing need.\r\n\r\nThrough Flow actions, the Download Survey123 Data Python script, and an R script, all the data from both surveys is automatically pulled into the master boater database, a repository that contains records for more than 2,300 boats. Having this information automatically entered into the database ensures better data quality and near real-time information. Additionally, the new workflows for digitally collecting the data with surveys and automating the flow of data throughout DWSP\u2019s systems reduce the annual number of labor hours by 72 percent.\r\n\r\nUsing Survey123 and the Survey123 Connector for Microsoft Flow to digitally transform the manual workflows has enabled DWSP to realize a 137 percent initial-year return on investment in labor costs for the boat inspection program. All stakeholders now benefit from having accurate, complete, and up-to-date boat and boater data readily available at any time.\r\n\r\n\u201cOverall, using these surveys with the Survey123 Connector for Microsoft Flow is helping improve the quality of the boat\/boater database to ensure the Quabbin Reservoir\u2019s water quality is being maintained at the highest possible level,\u201d concluded Tefft."}],"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>Massachusetts Keeps Drinking Water Safe<\/title>\n<meta name=\"description\" content=\"Using Survey123 for ArcGIS and Microsoft Flow, water management staff save time and money conducting boat inspections.\" \/>\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\/massachusetts-keeps-drinking-water-safe\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Massachusetts Keeps Drinking Water Safe\" \/>\n<meta property=\"og:description\" content=\"Using Survey123 for ArcGIS and Microsoft Flow, water management staff save time and money conducting boat inspections.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe\" \/>\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=\"2021-09-02T02:05:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/01\/arcnews-banner-drinkingwater-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\/massachusetts-keeps-drinking-water-safe\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe\",\n\t            \"name\": \"Massachusetts Keeps Drinking Water Safe\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2019-01-22T07:55:40+00:00\",\n\t            \"dateModified\": \"2021-09-02T02:05:29+00:00\",\n\t            \"description\": \"Using Survey123 for ArcGIS and Microsoft Flow, water management staff save time and money conducting boat inspections.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe#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\/massachusetts-keeps-drinking-water-safe\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe#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\": \"Massachusetts Keeps Drinking Water Safe\"\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\/b7332d419608ac1a0291ec30de119efb\",\n\t            \"name\": \"April Mann\",\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\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g\",\n\t                \"contentUrl\": \"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g\",\n\t                \"caption\": \"April Mann\"\n\t            },\n\t            \"url\": \"\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Massachusetts Keeps Drinking Water Safe","description":"Using Survey123 for ArcGIS and Microsoft Flow, water management staff save time and money conducting boat inspections.","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\/massachusetts-keeps-drinking-water-safe","og_locale":"en_US","og_type":"article","og_title":"Massachusetts Keeps Drinking Water Safe","og_description":"Using Survey123 for ArcGIS and Microsoft Flow, water management staff save time and money conducting boat inspections.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2021-09-02T02:05:29+00:00","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/01\/arcnews-banner-drinkingwater-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\/massachusetts-keeps-drinking-water-safe","url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe","name":"Massachusetts Keeps Drinking Water Safe","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2019-01-22T07:55:40+00:00","dateModified":"2021-09-02T02:05:29+00:00","description":"Using Survey123 for ArcGIS and Microsoft Flow, water management staff save time and money conducting boat inspections.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/massachusetts-keeps-drinking-water-safe#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":"Massachusetts Keeps Drinking Water Safe"}]},{"@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\/b7332d419608ac1a0291ec30de119efb","name":"April Mann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g","caption":"April Mann"},"url":""}]}},"sort_order":"14","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/201862","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\/1432"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/201862\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=201862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=201862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=201862"},{"taxonomy":"arcnews_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews_issues?post=201862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}