{"id":79982,"date":"2019-02-01T14:01:19","date_gmt":"2019-02-01T22:01:19","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcnews&p=79982"},"modified":"2023-10-04T09:36:54","modified_gmt":"2023-10-04T16:36:54","slug":"automating-inspection-reports-with-mobile-gis","status":"publish","type":"arcnews","link":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis","title":{"rendered":"Automating Inspection Reports with Mobile GIS"},"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":[10392,10632],"tags":[311,134972,56832,111,157872],"arcnews_issues":[47032],"class_list":["post-79982","arcnews","type-arcnews","status-publish","format-standard","hentry","category-arcgis-online","category-collector-for-arcgis","tag-data-driven","tag-land-management","tag-precision-agriculture","tag-real-time","tag-roi","arcnews_issues-fall-2017","arcnews_sections-your-work"],"acf":{"short_description":"The Delaware Department of Agriculture has a strong history of preserving farmland. For 20 years, Delaware has purchased development rights from\u2026","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"

Delaware Cuts Time It Takes to Assess Agricultural Easements by 75 Percent<\/h2>"},{"acf_fc_layout":"image","image":79992,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"The Delaware Department of Agriculture (DDA) has a strong history of preserving farmland. For 20 years, Delaware has purchased development rights from landowners in annual rounds, investing $219 million into Delaware\u2019s agriculture industry. The success of the agriculture land preservation program is attributed to a competitive bidding process in which easements are purchased at an average 56 percent discount off the appraised value. This allows farmers to make some extra money off their land while continuing to farm it. DDA now holds permanent agricultural easements on 866 farms covering 122,000 acres of Delaware land. Additionally, DDA holds 425 temporary 10-year easements on another 55,000 acres.\r\n\r\nBecause these easements remain privately owned, DDA monitors them to ensure that landowners continue to comply with development restrictions. The inspections themselves are not complicated, but manually managing the related data and photos was becoming challenging and costly. So DDA enhanced its use of the ArcGIS platform\u2014and implemented Collector for ArcGIS\u2014to streamline inspections and automate reports.\r\n

Managing Data and Photos Manually<\/h2>\r\nPrior to 2016, DDA inspectors employed a manual workflow to conduct and report on site visits. They used paper maps to decipher property boundaries; recorded inspection notes on laptops; and used digital cameras to take photos of the properties, being sure to write down each property ID number on a piece of paper and photograph that before every inspection to keep the photos organized.\r\n\r\nAfter inspectors finished a set of hundreds of assessments, they would manually organize the photos by property ID, renaming each photo so it contained the ID and placing all the photos from each property into a folder. Inspectors then put the inspection results, photos, and captions into a report template, which contained a property map that had to be centered and edited to show the photo locations.\r\n\r\nThis process took hundreds of hours each year. Managing the data and photos manually, as well as creating individual reports for each property, was tedious. Inspectors weren\u2019t able to complete their reports until months after the inspections took place, generating a severe time lag.\r\n\r\nThe workflow was clearly in need of an upgrade, and the staff was asking for improvements.\r\n

Designing a Dual-Purpose Geodatabase<\/h2>\r\nLooking for a low-cost upgrade, DDA\u2019s GIS coordinator, Jimmy Kroon, determined that he could use Collector for ArcGIS to enable mobile data collection and the Data Driven Pages in ArcGIS Desktop to automate the reports. The enterprise GIS team at Delaware\u2019s Department of Technology and Information (DTI) had experience using Collector, so it assisted with designing the database and offered to host it in ArcGIS Server.\r\n\r\nTo get started, Kroon and DTI\u2019s GIS team designed a geodatabase that would support data-driven map documents for individual inspection reports. Then, the team adapted the geodatabase to be the backbone of the operation in Collector. Because the geodatabase structures for Collector and the data-driven map documents were slightly different, the team used ModelBuilder to create a model that transcribes records between them.\r\n\r\nTo test everything, Kroon first published the solution in ArcGIS Online. This allowed him to make quick modifications to the database schema and map symbology to ensure that the inspection workflow in Collector performed as expected. Once testing was complete, DTI\u2019s GIS team published the solution in FirstMap, Delaware\u2019s enterprise GIS, and created a secure editing environment.\r\n

Inspecting Easements with Collector<\/h2>\r\nIt took less than an hour for Kroon to train the inspectors on how to use the new solution. Within a week, DDA inspectors began using Collector to conduct a set of 306 farm inspections.\r\n\r\nThey reported that the app was easy to use. Having easement boundaries on a mobile map with real-time location details helped them get oriented quickly in the field. They liked being able to capture all inspection data and photos using a single device. And Collector\u2019s offline capabilities made rural inspections much easier, since the inspectors didn\u2019t have to search for mobile service to upload their data.\r\n\r\nOnce the inspections were complete, Kroon checked the data for errors, converted it into the reporting schema, and aligned the report template map to the inspection database. ArcGIS Desktop exported every record as an individual PDF file, each named according to the property ID.\r\n\r\nEvery report contains the inspection data that is stored in the attribute table; photos, which are stored as geodatabase attachments; and photo locations that are stored as related point feature classes. Now, exporting reports takes an hour or two of processing time (depending on the number of reports being generated) rather than weeks of manual effort."},{"acf_fc_layout":"image","image":80002,"image_position":"center","orientation":"vertical","hyperlink":""},{"acf_fc_layout":"content","content":"In the first year alone, DDA used Collector to inspect and generate reports for 730 easements throughout the state of Delaware.\r\n

Evaluating Return on Investment<\/h2>\r\nOne year after implementation, DDA looked back at the process and calculated its return on investment (ROI) for the solution.\r\n\r\nIndeed, it took much less time to generate reports. The staff was thrilled about not having to complete these assessments manually. And DDA\u2019s funding partners were happy to be getting inspection reports more quickly. Even better, reports were now more thorough because they contained extra data pulled from the program\u2019s GIS database and county GIS servers.\r\n\r\nDuring the ROI appraisal, DDA uncovered an unexpected benefit as well. Inspectors revealed that they were completing their site visits about twice as fast using Collector as they did with the old workflow. This was attributed to having data, real-time location, mapping, and photo capture all in one device.\r\n\r\n\u201cJust the\u00a0[federally funded]<\/em>\u00a0properties would normally take about 20 days to finish at 7.5 hours daily, so 150 hours to complete,\u201d said Milton Melendez, a planner in the agriculture land preservation program. \u201cNow, it takes just about 75 hours to finish in about 10 days.\u201d\r\n\r\nKroon also gathered information on how long it took, on average, to complete reports using both the old and new workflows, and DTI\u2019s enterprise GIS team helped estimate how long it took to create the solution. Additional costs, including purchasing new smartphones and a new cellular service plan with data, were also included in the detailed ROI report.\r\n\r\nIn the end, DDA reaped very clear benefits from the new workflow. Setting up the solution required a one-time investment of 41 hours, and now DDA saves nearly 500 hours annually\u201475 percent of the time it used to take\u2014on completing inspections. Generalizing employee costs for everyone involved in the inspections\u2014including their average salary, health care and fringe benefits, and overhead expenses\u2014DDA saved $22,710 in the first year and is slated to save more than $25,000 in each ensuing year.\r\n\r\nAfter reviewing the ROI report, Delaware\u2019s deputy secretary of agriculture, Austin Short, concluded, \u201cWith all the focus on budget reductions, exercises such as this one are great examples of how DDA is saving money.\u201d\r\n\r\nFor more information about this project, email\u00a0Kroon<\/a>, MGIS."}],"references":null},"yoast_head":"\nAutomating Inspection Reports with Mobile GIS | Fall 2017 | ArcNews<\/title>\n<meta name=\"description\" content=\"Delaware cuts the time it takes to assess agricultural easements by 75 percent.\" \/>\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\/automating-inspection-reports-with-mobile-gis\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automating Inspection Reports with Mobile GIS\" \/>\n<meta property=\"og:description\" content=\"Delaware cuts the time it takes to assess agricultural easements by 75 percent.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis\" \/>\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-10-04T16:36:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-purple-red-card.jpg\" \/><meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-purple-red-card.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Automating Inspection Reports with Mobile GIS\" \/>\n<meta name=\"twitter:description\" content=\"Delaware cuts the time it takes to assess agricultural easements by 75 percent.\" \/>\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\/automating-inspection-reports-with-mobile-gis\",\n\t \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis\",\n\t \"name\": \"Automating Inspection Reports with Mobile GIS | Fall 2017 | ArcNews\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t },\n\t \"datePublished\": \"2019-02-01T22:01:19+00:00\",\n\t \"dateModified\": \"2023-10-04T16:36:54+00:00\",\n\t \"description\": \"Delaware cuts the time it takes to assess agricultural easements by 75 percent.\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis#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\/automating-inspection-reports-with-mobile-gis\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis#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\": \"Automating Inspection Reports with Mobile GIS\"\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":"Automating Inspection Reports with Mobile GIS | Fall 2017 | ArcNews","description":"Delaware cuts the time it takes to assess agricultural easements by 75 percent.","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\/automating-inspection-reports-with-mobile-gis","og_locale":"en_US","og_type":"article","og_title":"Automating Inspection Reports with Mobile GIS","og_description":"Delaware cuts the time it takes to assess agricultural easements by 75 percent.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2023-10-04T16:36:54+00:00","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-purple-red-card.jpg","type":"","width":"","height":""},{"width":1920,"height":1080,"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-purple-red-card.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_title":"Automating Inspection Reports with Mobile GIS","twitter_description":"Delaware cuts the time it takes to assess agricultural easements by 75 percent.","twitter_site":"@Esri","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis","url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis","name":"Automating Inspection Reports with Mobile GIS | Fall 2017 | ArcNews","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2019-02-01T22:01:19+00:00","dateModified":"2023-10-04T16:36:54+00:00","description":"Delaware cuts the time it takes to assess agricultural easements by 75 percent.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/automating-inspection-reports-with-mobile-gis#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":"Automating Inspection Reports with Mobile GIS"}]},{"@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\/79982","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\/79982\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=79982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=79982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=79982"},{"taxonomy":"arcnews_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews_issues?post=79982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}