{"id":419272,"date":"2021-04-06T19:59:40","date_gmt":"2021-04-07T02:59:40","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcnews&#038;p=419272"},"modified":"2021-04-06T11:31:16","modified_gmt":"2021-04-06T18:31:16","slug":"a-faster-way-to-maintain-data-quality","status":"publish","type":"arcnews","link":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality","title":{"rendered":"A Faster Way to Maintain Data Quality"},"author":6921,"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,10842,275952],"tags":[300062,160952,166952,279132,157622],"arcnews_issues":[472051],"class_list":["post-419272","arcnews","type-arcnews","status-publish","format-standard","hentry","category-arcgis-data-reviewer","category-data","category-technology","tag-data-quality","tag-infrastructure","tag-utility","tag-water","tag-workflow","arcnews_issues-spring-2021","arcnews_sections-your-work"],"acf":{"short_description":"Clay County Utility Authority used ArcGIS Data Reviewer to improve quality assurance and quality control processes.","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"The agency responsible for maintaining the infrastructure for water, wastewater, and reclaimed water management in a rapidly growing Florida county needed a workflow that helped it more quickly and accurately incorporate utility drawings for new subdivisions into its GIS.\r\n\r\nClay County Utility Authority (CCUA), based in Middleburg, Florida, serves 54,000 customers and maintains 1,500 miles of utility infrastructure. From hydrant safety to asset repair and replacement, data is central to the utility\u2019s daily operations. Consequently, CCUA operators needed an efficient quality assurance (QA) and quality control (QC) processes to produce reliable data about its infrastructure.\r\n\r\nRapidly growing Clay County expects 12,000 new homes to be built within the next decade. These homes will require the creation and attribution of new assets for new subdivisions on a weekly\u2014sometimes daily\u2014basis. The GIS team at CCUA needed to keep up with this increasing workload while also ensuring the data integrity of its GIS.\r\n\r\nGIS data supports numerous projects for new subdivisions, so it\u2019s critical that data is of the highest quality. In 2016, CCUA migrated to the ArcGIS Local Government Information Model (LGIM) for water utilities. LGIM is a database schema provided by Esri for use by local governments that supports data management for the maps and apps deployed across CCUA.\r\n\r\nWhen preparing to migrate to LGIM, CCUA configured a comprehensive set of data checks using ArcGIS Data Reviewer, an extension for ArcGIS Pro, ArcGIS Enterprise, and ArcMap that provides automation and improves data quality management.\r\n\r\nAfter implementing LGIM, these checks needed to be reconfigured to work with the new schema. Until the checks could adjust, quality control was conducted visually by one person who manually checked each feature in the field. With well over 300,000 features across all three utility types, this process not only was resource intensive but also left a lot of room for human error.\r\n\r\nThe county\u2019s rapid growth meant that CCUA\u2019s GIS department needed to prioritize reconfiguring ArcGIS Data Reviewer for data QA and QC processes to work with the LGIM. Daniel Johns, GIS manager, tasked Sarah Grimsley, GIS analyst II, with reconfiguring ArcGIS Data Reviewer and improving the efficiency and performance of QA\/QC processes.\r\n\r\nTo reconfigure the data checks using ArcGIS Data Reviewer, Grimsley first referenced old checks and the sample water utility checks from Esri\u2019s Data Reviewer for Water Utilities template. Then she categorized the checks by type (geometry, attributes, and point\/line valency) for each utility type. Each utility now had data checks that were in accordance with the new schema, so the data met the business requirements for CCUA\u2019s GIS applications.\r\n\r\nIt took just two weeks for Grimsley to reconfigure the checks, even though she had no previous experience using ArcGIS Data Reviewer. Grimsley could create a check for any scenario in the utility system. She appreciated the tool\u2019s flexibility and can see how it could be used in other areas such as asset management.\r\n\r\nThe CCUA GIS team has seen significant improvement in the speed of its QA\/QC processes since implementing ArcGIS Data Reviewer for the LGIM data schema. In addition to organizing the checks by type, the number of checks required for validation was dramatically reduced due to the updated schema.\r\n\r\nFor example, domain codes for valves, mains, laterals, and casings are always one diameter. Fittings, however, can be different sizes on either end, resulting in 325 domain codes. With several hundred fitting sizes, hundreds of data checks were initially configured for each size. In the LGIM schema, Grimsley configured this check using the Table Check and applying an SQL expression within the check configuration according to fitting sizes against the equivalent pipe diameter.\r\n\r\nThis significantly reduced the number of domain-related checks. Similar improvements were experienced with the valency and geometry checks. Depending on the utility, these checks now take only 20 to 30 minutes.\r\n\r\n\u201cArcGIS Data Reviewer allows us to do our job better. Using this application, we\u2019re able to quickly and efficiently turn around new projects and get them into our GIS production system,\u201d said Grimsley.\r\n\r\nTechnicians are responsible for conducting their own checks and making their own edits. With ArcGIS Data Reviewer, Grimsley can now review the results of their QC work to see what was fixed. This allows her to track the edits completed by technicians and verify them to ensure that errors are caught, which ultimately improves data quality. Grimsley is also using ArcGIS Data Reviewer to go back and run the checks on older areas to address any outstanding issues.\r\n\r\n\u201cThe way things are set up now, we're pretty much catching everything. We're also using [ArcGIS Data Reviewer] to capture errors related to the assets that are surrounding that job,\u201d said Johns. \u201cSo getting this application back up and running against the LGIM schema was very vital.\u201d\r\n\r\nThe response from other departments at CCUA has been positive. \u201cWe haven\u2019t advertised the use of ArcGIS Data Reviewer, so a lot of our colleagues are just operating under the impression that we're able to get work out a lot quicker and with less error,\u201d said Johns. \u201cWe no longer have to deal with the slow turnaround linked to our previous processes and can now provide data to our field staff much faster.\u201d\r\n\r\nGrimsley added, \u201cI\u2019ve been told by multiple people within the organization that they are impressed with how fast we are pumping out work after getting the batch checks running. With ArcGIS Data Reviewer being so quick and efficient, we can have required edits accessible in the GIS, all within minutes.\u201d\r\n\r\nGrimsley continues to add new checks to improve QA\/QC within the utility and for the rest of the organization. She and Johns look forward to ArcGIS Data Reviewer continuing to streamline their QA\/QC processes.\r\n\r\n\u201cArcGIS Data Reviewer enables employees to operate more efficiently and reduce the amount of time it's taking them to do their work,\u201d said Johns. \u201cI can see this playing an important role as we continue to grow.\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>A Faster Way to Maintain Data Quality | ArcNews | Spring 2021<\/title>\n<meta name=\"description\" content=\"Clay County Utility Authority used ArcGIS Data Reviewer to improve quality assurance &amp; quality control processes.\" \/>\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\/a-faster-way-to-maintain-data-quality\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Faster Way to Maintain Data Quality | ArcNews | Spring 2021\" \/>\n<meta property=\"og:description\" content=\"Clay County Utility Authority used ArcGIS Data Reviewer to improve quality assurance &amp; quality control processes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality\" \/>\n<meta property=\"og:site_name\" content=\"Esri\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2021\/03\/arcnews-banner-afasterway-wide.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"A Faster Way to Maintain Data Quality | ArcNews | Spring 2021\" \/>\n<meta name=\"twitter:description\" content=\"Clay County Utility Authority used ArcGIS Data Reviewer to improve quality assurance &amp; quality control processes.\" \/>\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\/a-faster-way-to-maintain-data-quality\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality\",\n\t            \"name\": \"A Faster Way to Maintain Data Quality | ArcNews | Spring 2021\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2021-04-07T02:59:40+00:00\",\n\t            \"description\": \"Clay County Utility Authority used ArcGIS Data Reviewer to improve quality assurance & quality control processes.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality#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\/a-faster-way-to-maintain-data-quality\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality#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\": \"A Faster Way to Maintain Data Quality\"\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\/2ea2e24ff1bf1335829717357eaf3b3a\",\n\t            \"name\": \"Lidia Davidson\",\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\/69fae831c26e7d10c2c6cdaff1c8c9f2e148d083fe79f851e5ad201f7793fad5?s=96&d=blank&r=g\",\n\t                \"contentUrl\": \"https:\/\/secure.gravatar.com\/avatar\/69fae831c26e7d10c2c6cdaff1c8c9f2e148d083fe79f851e5ad201f7793fad5?s=96&d=blank&r=g\",\n\t                \"caption\": \"Lidia Davidson\"\n\t            },\n\t            \"url\": \"\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"A Faster Way to Maintain Data Quality | ArcNews | Spring 2021","description":"Clay County Utility Authority used ArcGIS Data Reviewer to improve quality assurance & quality control processes.","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\/a-faster-way-to-maintain-data-quality","og_locale":"en_US","og_type":"article","og_title":"A Faster Way to Maintain Data Quality | ArcNews | Spring 2021","og_description":"Clay County Utility Authority used ArcGIS Data Reviewer to improve quality assurance & quality control processes.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2021\/03\/arcnews-banner-afasterway-wide.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_title":"A Faster Way to Maintain Data Quality | ArcNews | Spring 2021","twitter_description":"Clay County Utility Authority used ArcGIS Data Reviewer to improve quality assurance & quality control processes.","twitter_site":"@Esri","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality","url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality","name":"A Faster Way to Maintain Data Quality | ArcNews | Spring 2021","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2021-04-07T02:59:40+00:00","description":"Clay County Utility Authority used ArcGIS Data Reviewer to improve quality assurance & quality control processes.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-faster-way-to-maintain-data-quality#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":"A Faster Way to Maintain Data Quality"}]},{"@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\/2ea2e24ff1bf1335829717357eaf3b3a","name":"Lidia Davidson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/69fae831c26e7d10c2c6cdaff1c8c9f2e148d083fe79f851e5ad201f7793fad5?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/69fae831c26e7d10c2c6cdaff1c8c9f2e148d083fe79f851e5ad201f7793fad5?s=96&d=blank&r=g","caption":"Lidia Davidson"},"url":""}]}},"sort_order":"10","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/419272","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\/6921"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/419272\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=419272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=419272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=419272"},{"taxonomy":"arcnews_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews_issues?post=419272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}