{"id":32922,"date":"2018-06-24T23:55:50","date_gmt":"2018-06-25T06:55:50","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcnews&#038;p=32922"},"modified":"2023-08-07T15:08:04","modified_gmt":"2023-08-07T22:08:04","slug":"performing-data-checks-keeps-water-running","status":"publish","type":"arcnews","link":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running","title":{"rendered":"Performing Data Checks Keeps Water Running"},"author":1162,"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":[14822,801,14832],"tags":[611,1371,311,14842,1101],"arcnews_issues":[9332],"class_list":["post-32922","arcnews","type-arcnews","status-publish","format-standard","hentry","category-arcgis-data-reviewer","category-operational-intelligence","category-water-resources","tag-business-intelligence","tag-common-operating-picture","tag-data-driven","tag-efficiency","tag-modernization","arcnews_issues-arcnews-summer-2018","arcnews_sections-your-work"],"acf":{"short_description":"A Colorado water and sanitation district implemented ArcGIS Data Reviewer\u2014and will save a year of time.","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"<h2 style=\"text-align: center;\">Colorado Water and Sanitation District Implemented Data Reviewer\u2014and Will Save a Year of Time<\/h2>\r\nThe two-person GIS team at South Adams County Water and Sanitation District (SACWSD), based in Commerce City, Colorado, handles huge datasets for drinking water, irrigation, and sewage systems. Serving nearly 50,000 customers over about 65 square miles, SACWSD is the largest combined water and sanitation district in Colorado. It gets its water from wells, a reservoir, and the Denver Water utility. For a separate irrigation system, SACWSD draws water from nonpotable well supplies. In an effort to conserve drinking water, it is also building one of the largest nonpotable irrigation systems in the United States.\r\n\r\nTo keep all the water running, SACWSD has to have good, accurate data. But in fall 2016, as the district was using GPS to collect data on its infrastructure systems, GIS supervisor Cliff Sullivan and GIS technician Mark Dickman noticed that the data quality was varying widely. They were tasked with cleaning it up, and it initially appeared as though this assignment was going to be a long and tedious one.\r\n\r\nSullivan and Dickman started by manually reviewing each piece of data for spatial accuracy and attribute correctness. But this type of quality control (QC) was limited, since it was exploratory rather than comprehensive.\r\n\r\nAfter the bulk of the data had been collected, Sullivan was browsing the agenda for the Esri Water Conference and noticed that Esri offered data health checks. He then learned about ArcGIS Data Reviewer, an extension he could use with ArcGIS Desktop and ArcGIS Enterprise to make his and Dickman\u2019s QC job go much faster."},{"acf_fc_layout":"image","image":33272,"image_position":"left","orientation":"vertical","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>Learning Data Reviewer<\/h2>\r\nIn addition to getting the ArcGIS extension, SACWSD purchased on-site consulting services from Esri\u2019s Professional Services. Over two days, Sullivan and Dickman worked with Michelle Johnson, a senior GIS Quality Assurance (QA) lead and ArcGIS Data Reviewer advocate, to implement Data Reviewer and gain authoritative knowledge of the extension.\r\n\r\nData Reviewer allows users to perform hundreds of checks on their data, which is what Sullivan and Dickman liked about the extension\u2014though it also meant that they didn\u2019t really know where to start. At first, they used Data Reviewer to get an overall snapshot of the collected data. Then, with Johnson\u2019s help, they learned which data checks to prioritize and decided where to begin the editing process.\r\n\r\n\u201cMichelle was patient and very thorough in showing <em>[us]<\/em> how to use the product,\u201d said Sullivan. \u201cWe covered a lot in the two days that she was on-site. Our experience with Esri Professional Services was stellar.\u201d\r\n\r\nWorking directly with Johnson on configuring the required checks for their datasets allowed Sullivan and Dickman to make rapid progress. While some checks are self-explanatory, other more advanced ones require experience to understand the logic behind them and to get them to run correctly. For SACWSD, intergovernmental standards and best practices are now captured in templates and made available for use by anyone at the district who uses compatible software.\r\n\r\n\u201cI highly recommend this approach for small shops <em>[that]<\/em> are not able to dedicate 100 percent of their time to doing QC,\u201d said Dickman."},{"acf_fc_layout":"content","content":"<h2>Doing the Data Checks<\/h2>\r\nWith Johnson\u2019s guidance, Sullivan and Dickman decided to focus first on finding disconnected features. This ensured that all the features in a water system were correctly connected so that SACWSD\u2019s water modeling software could run successfully and provide accurate results.\r\n\r\nNext, Sullivan and Dickman used the Unique ID Check to make sure each asset ID was populated and didn\u2019t have duplicate values. This would help employees and contractors create work orders and service requests correctly within SACWSD\u2019s asset management software.\r\n\r\nJohnson was also instrumental in building the GIS team\u2019s databases and giving Sullivan and Dickman advice on data modeling. For example, it is currently best for them to use domains instead of subtypes. She also helped them build a data schema that is now self-explanatory to users at SACWSD.\r\n\r\n\u201cBy the time she left, we had our dataset on the path where we wanted to go,\u201d said Sullivan.\r\n\r\nAnd that was evident. Within three months, Sullivan and Dickman had completely cleaned up one of the three datasets they were tasked with fixing. They are now completing the spatial edits needed on the remaining two larger datasets. Using Data Reviewer also helped the GIS team standardize a new QC process, which now consists of prioritizing and finding errors and tracking corrections."},{"acf_fc_layout":"image","image":33262,"image_position":"right","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>Ahead of Schedule<\/h2>\r\nBefore they acquired Data Reviewer and contracted Johnson\u2019s help, Sullivan and Dickman were looking at a years-long process of manually checking features as they built their database. Both of them, plus an intern, were doing the work.\r\n\r\nNow, Dickman is the primary staffer working on the effort, and he is already six months ahead of schedule. By the time all three data-sets are complete, the GIS team expects to have saved more than a year of time.\r\n\r\n\u201cEnabling customers to use their GIS effectively and efficiently is what Esri does,\u201d Johnson reflected. \u201cIt was my pleasure to work with a great set of folks like Cliff and Mark, and I am happy to be part of their success.\u201d\r\n\r\nAs SACWSD continues moving forward with new infrastructure development, the GIS team plans to keep using Data Reviewer to perform QC on all new geospatial data, as well as to maintain existing data.\r\n\r\n\u201cInvesting in Data Reviewer will reward the investor by <em>[saving]<\/em> time and effort,\u201d said Sullivan. \u201cIt just gives users quality assurance that they won\u2019t have otherwise. It\u2019s well worth it.\u201d"}],"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>Performing Data Checks Keeps Water Running | Summer 2018 | ArcNews<\/title>\n<meta name=\"description\" content=\"With help from Esri Professional Services, a Colorado water and sanitation district implemented ArcGIS Data Reviewer\u2014and will save a year of time.\" \/>\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\/performing-data-checks-keeps-water-running\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performing Data Checks Keeps Water Running\" \/>\n<meta property=\"og:description\" content=\"With help from Esri Professional Services, a Colorado water and sanitation district implemented ArcGIS Data Reviewer\u2014and will save a year of time.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running\" \/>\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-08-07T22:08:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/06\/ArcNews-PerformingDataChecks-banner-card.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Performing Data Checks Keeps Water Running\" \/>\n<meta name=\"twitter:description\" content=\"With help from Esri Professional Services, a Colorado water and sanitation district implemented ArcGIS Data Reviewer\u2014and will save a year of time.\" \/>\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\/performing-data-checks-keeps-water-running\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running\",\n\t            \"name\": \"Performing Data Checks Keeps Water Running | Summer 2018 | ArcNews\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2018-06-25T06:55:50+00:00\",\n\t            \"dateModified\": \"2023-08-07T22:08:04+00:00\",\n\t            \"description\": \"With help from Esri Professional Services, a Colorado water and sanitation district implemented ArcGIS Data Reviewer\u2014and will save a year of time.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running#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\/performing-data-checks-keeps-water-running\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running#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\": \"Performing Data Checks Keeps Water Running\"\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\/a9bd4568e9ff3d11069fe7b326e0123c\",\n\t            \"name\": \"Citabria Stevens\",\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:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/CitabriaStevens2_small.jpg\",\n\t                \"contentUrl\": \"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/CitabriaStevens2_small.jpg\",\n\t                \"caption\": \"Citabria Stevens\"\n\t            },\n\t            \"description\": \"Citabria Stevens is the managing editor of Esri's ArcNews magazine. She helps users from all over the world tell compelling stories about how they employ Esri technology in innovative ways and ensures that readers stay well informed about ArcGIS solutions. Citabria began her career as a journalist at CNN before moving into the fields of international development and geopolitics. She holds a BS in communications and journalism from New York University and a dual MA\/MSc in international history from Columbia University and the London School of Economics.\",\n\t            \"sameAs\": [\n\t                \"https:\/\/x.com\/ArcNewsMagazine\"\n\t            ],\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/author\/cstevens\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Performing Data Checks Keeps Water Running | Summer 2018 | ArcNews","description":"With help from Esri Professional Services, a Colorado water and sanitation district implemented ArcGIS Data Reviewer\u2014and will save a year of time.","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\/performing-data-checks-keeps-water-running","og_locale":"en_US","og_type":"article","og_title":"Performing Data Checks Keeps Water Running","og_description":"With help from Esri Professional Services, a Colorado water and sanitation district implemented ArcGIS Data Reviewer\u2014and will save a year of time.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2023-08-07T22:08:04+00:00","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/06\/ArcNews-PerformingDataChecks-banner-card.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_title":"Performing Data Checks Keeps Water Running","twitter_description":"With help from Esri Professional Services, a Colorado water and sanitation district implemented ArcGIS Data Reviewer\u2014and will save a year of time.","twitter_site":"@Esri","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running","url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running","name":"Performing Data Checks Keeps Water Running | Summer 2018 | ArcNews","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2018-06-25T06:55:50+00:00","dateModified":"2023-08-07T22:08:04+00:00","description":"With help from Esri Professional Services, a Colorado water and sanitation district implemented ArcGIS Data Reviewer\u2014and will save a year of time.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/performing-data-checks-keeps-water-running#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":"Performing Data Checks Keeps Water Running"}]},{"@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\/a9bd4568e9ff3d11069fe7b326e0123c","name":"Citabria Stevens","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/CitabriaStevens2_small.jpg","contentUrl":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/CitabriaStevens2_small.jpg","caption":"Citabria Stevens"},"description":"Citabria Stevens is the managing editor of Esri's ArcNews magazine. She helps users from all over the world tell compelling stories about how they employ Esri technology in innovative ways and ensures that readers stay well informed about ArcGIS solutions. Citabria began her career as a journalist at CNN before moving into the fields of international development and geopolitics. She holds a BS in communications and journalism from New York University and a dual MA\/MSc in international history from Columbia University and the London School of Economics.","sameAs":["https:\/\/x.com\/ArcNewsMagazine"],"url":"https:\/\/www.esri.com\/about\/newsroom\/author\/cstevens"}]}},"sort_order":"17","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/32922","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\/1162"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/32922\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=32922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=32922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=32922"},{"taxonomy":"arcnews_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews_issues?post=32922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}