{"id":494952,"date":"2022-02-22T19:07:11","date_gmt":"2022-02-23T03:07:11","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcuser&#038;p=494952"},"modified":"2022-02-22T19:07:11","modified_gmt":"2022-02-23T03:07:11","slug":"automating-everyday-workflows-using-custom-modelbuilder-tools","status":"publish","type":"arcuser","link":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools","title":{"rendered":"Automating Everyday Workflows Using Custom ModelBuilder Tools"},"author":1031,"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":[10412,25022],"tags":[472461,23402,178472,452361],"arcuser_issues":[477652],"class_list":["post-494952","arcuser","type-arcuser","status-publish","format-standard","hentry","category-arcgis-pro","category-hands-on","tag-arcuser","tag-automation","tag-best-practices","tag-modelbuilder","arcuser_issues-winter-2022"],"acf":{"short_description":"Automating routine GIS tasks using ModelBuilder save time, reduce error, and standardize workflows.","pdf":{"host_remotely":false,"file":494972,"file_url":""},"flexible_content":[{"acf_fc_layout":"blockquote","content":"Author\u2019s note: I work for WRA, Inc., an environmental consulting firm in the San Francisco Bay Area. The firm has slightly fewer than 100 employees, and I am one of six full-time GIS staff members who support the company\u2019s GIS efforts. WRA receives about 200 new projects each year and continues to work on many existing projects for years, even decades."},{"acf_fc_layout":"content","content":"With so many active projects that often require the same GIS tasks, automation is key for operational efficiency. In this article, I\u2019m going to share some of these automation tools. All these tools were built within ModelBuilder, a visual programming language for building geoprocessing workflows, using simple geoprocessing tools and feature template domains. None required any scripting.\r\n\r\nWorkflows that are repeated\u2014whether several times a month or week or every day\u2014are perfectly suited for automation. Although these workflows may not be very exciting when compared with complex GIS analyses, they are arguably the most used and often the most useful.\r\n<h3>Create Workspace Model<\/h3>\r\nThe essential model is the Create Workspace model. This tool is run for every new project to set up the entire workspace for all GIS work. This model sets up folders, creates geodatabases and feature datasets, and then imports premade and empty feature classes and their domains. To run the tool, the only model parameters required are the root folder by year on the server, the new project number, the project name for name of the main geodatabase, and the project\u2019s state plane coordinate system.\r\n\r\nThe model not only creates a space for GIS work, it also creates a highly organized space for implementing a database management system so that data and GIS products can be easily managed and located. In addition, the main project geodatabase already contains empty feature classes and fields that are ready to use. For most projects, these feature classes are all that is needed to complete the project. Table 1 describes each folder in the directory structure and its use.\r\n\r\nThe main geodatabase is organized by feature datasets for base files, delineation, permitting, rare plants, setbacks, and wildlife. Each feature dataset has empty feature classes ready for editing, and pertinent fields with domain constraints. For example, the feature dataset for rare plants has feature classes for rare plant points and polygons with fields for code, common and scientific name, count, and a dropdown for jurisdiction.\r\n\r\n&nbsp;"},{"acf_fc_layout":"image","image":495002,"image_position":"right","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3>DEM Processor Tools<\/h3>\r\nAs an environmental consulting firm, WPA requires field efforts to map out biological resources, and the biggest component is aquatics resources (i.e., wetlands, waters, riparian areas). WPA biologists need field maps\u2014either hard-copy or web maps\u2014 to help delineate features while on-site. Topographic information is extremely helpful to them because aquatic features are topography driven. With the availability of high-resolution lidar projects covering much of the earth, high-quality topographic work products can be automated using the DEM Processor toolbox to support field efforts.\r\n\r\nThe Run Topo Focal Hillshade tools (1.1 to 1.4) in the DEM Processor toolbox simply create the DEM geodatabase where all products will be stored and named by the associated lidar project. The Run Hydrology tool creates contours and a hillshade. It then performs a focal analysis to produce a more smoothed DEM, contours, and hillshade. Intervals and the focal neighborhood are parameterized, and there are four variations of the tool to ensure that all x, y, and z measurements are in feet.\r\n\r\nRun Hydrology Tools include all hydrology tools\u2014Fill, Flow Direction, and Flow Accumulation\u2014if more products are desired.\r\n\r\nThe Modeled Drainage tool produces possible stream vectors based on the size a watershed needs to be before the stream begins. The only parameters are the cell size of the DEM and the size in acres (with a default set at three acres).\r\n\r\nThe Interactive Watershed tool is a simple tool that uses a feature set to drop pour points on the map to then derive watersheds.\r\n\r\nThe Depression Extractor tool subtracts the filled DEM from the nonfilled DEM, extracts all positive values, and converts the output to polygons.\r\n\r\nThe DEM Processor toolbox also contains Slope and DEM Clip tools.\r\nSince the tools derive the raw and focal-smoothed contours, the GIS staff member or biologist can decide which to use. The Depression Extractor was used on the map to help target flat areas that may be wetlands.\r\nThe following tools have also proved very useful. [These tools were developed by the author, who will share them.]\r\n\r\n&nbsp;"},{"acf_fc_layout":"image","image":495022,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"image","image":495032,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<strong>Sample Point Tool:<\/strong> For every aquatic delineation submitted to the US Army Corps of Engineers, sample points must be taken in the field and a form filled out for each point. Because many of these fields are geographic, the data input can be automated using GIS. Once the sample point feature class is complete, it merely needs to be plugged into the tool, and a Microsoft Excel table is exported for the delineator. The tool calculates the points\u2019 coordinates, then goes through a series of spatial joins to add information for township and range, soil type, NWI-CARI [National Wetland Inventory-California Aquatic Resources Inventory] intersects, major land resources, and slope (obtained from the DEM Processor Tools).\r\n\r\n<strong>SURGGO Soils Extract:<\/strong> Takes a Natural Resources Conservation Service (NRCS) soils layer file (with useful table joins already executed in the layer file) and clips it to a project's study area, then adds a field for the legend that combines soil type with the label identifier.\r\n\r\n<strong>CNDDB Extract:<\/strong> Generates a five-mile buffer around a project then selects out all intersecting California Department of Fish and Wildlife (CDFW) California Natural Diversity Database (CNDDB) occurrences separated by wildlife and plants. Additional dissolve and explode operations are performed for cartographic purposes.\r\n\r\nFor more information, contact <a href=\"rochelle@wra-ca.com\">Michael Rochelle<\/a>."},{"acf_fc_layout":"blockquote","content":"I\u2019ve briefly described several tools that WPA employs regularly because they have proven very useful. I\u2019ve also developed several other tools that I use regularly or might use only a few times a year. If it\u2019s something repeatable and has more than a few steps, I immediately begin considering if it is a process that should be automated in ModelBuilder. WPA has just started using arcpy.mp for ArcGIS Pro to automate map production, and I see a lot of future modeling efforts to be implemented."}],"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>Automate workflows with ModelBuilder<\/title>\n<meta name=\"description\" content=\"The author shares strategies he employs to automate regular workflows with ModelBuilder to save time, improve accuracy, and standardize 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\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automating Everyday Workflows Using Custom ModelBuilder Tools\" \/>\n<meta property=\"og:description\" content=\"The author shares strategies he employs to automate regular workflows with ModelBuilder to save time, improve accuracy, and standardize processes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools\" \/>\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\/2022\/01\/automatingMB_banner.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\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools\",\n\t            \"name\": \"Automate workflows with ModelBuilder\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2022-02-23T03:07:11+00:00\",\n\t            \"description\": \"The author shares strategies he employs to automate regular workflows with ModelBuilder to save time, improve accuracy, and standardize processes.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools#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\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools#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\": \"Automating Everyday Workflows Using Custom ModelBuilder Tools\"\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\/82e5143bcdebadf8fd64d84e503ca468\",\n\t            \"name\": \"Monica Pratt\",\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\/MonicaMug_agol2.jpg\",\n\t                \"contentUrl\": \"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/MonicaMug_agol2.jpg\",\n\t                \"caption\": \"Monica Pratt\"\n\t            },\n\t            \"description\": \"Monica Pratt is the founding and current editor of ArcUser magazine, the executive editor of ArcNews magazine, the editor of Esri Globe and head of the Publications team at Esri. She has been writing on technology topics, specializing in GIS, for more than 30 years. Before joining Esri in 1997, she worked for newspapers and in the financial industry.\",\n\t            \"sameAs\": [\n\t                \"https:\/\/x.com\/ArcUser\"\n\t            ],\n\t            \"url\": \"\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Automate workflows with ModelBuilder","description":"The author shares strategies he employs to automate regular workflows with ModelBuilder to save time, improve accuracy, and standardize 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\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools","og_locale":"en_US","og_type":"article","og_title":"Automating Everyday Workflows Using Custom ModelBuilder Tools","og_description":"The author shares strategies he employs to automate regular workflows with ModelBuilder to save time, improve accuracy, and standardize processes.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2022\/01\/automatingMB_banner.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\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools","url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools","name":"Automate workflows with ModelBuilder","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2022-02-23T03:07:11+00:00","description":"The author shares strategies he employs to automate regular workflows with ModelBuilder to save time, improve accuracy, and standardize processes.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/automating-everyday-workflows-using-custom-modelbuilder-tools#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"Automating Everyday Workflows Using Custom ModelBuilder Tools"}]},{"@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\/82e5143bcdebadf8fd64d84e503ca468","name":"Monica Pratt","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\/MonicaMug_agol2.jpg","contentUrl":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/MonicaMug_agol2.jpg","caption":"Monica Pratt"},"description":"Monica Pratt is the founding and current editor of ArcUser magazine, the executive editor of ArcNews magazine, the editor of Esri Globe and head of the Publications team at Esri. She has been writing on technology topics, specializing in GIS, for more than 30 years. Before joining Esri in 1997, she worked for newspapers and in the financial industry.","sameAs":["https:\/\/x.com\/ArcUser"],"url":""}]}},"sort_order":"12","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/494952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser"}],"about":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/types\/arcuser"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/users\/1031"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/494952\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=494952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=494952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=494952"},{"taxonomy":"arcuser_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser_issues?post=494952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}