{"id":769588,"date":"2025-11-11T17:52:00","date_gmt":"2025-11-12T01:52:00","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcuser&#038;p=769588"},"modified":"2025-11-11T17:52:00","modified_gmt":"2025-11-12T01:52:00","slug":"dashboards-track-capital-improvement-projects-in-schertz","status":"publish","type":"arcuser","link":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz","title":{"rendered":"Dashboards Track Capital Improvement Projects in Schertz"},"author":5752,"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":[493251],"tags":[35332,424992,493259,411322,493260],"arcuser_issues":[493245],"class_list":["post-769588","arcuser","type-arcuser","status-publish","format-standard","hentry","category-gis-at-work","tag-arcgis-arcade","tag-arcgis-dashboards","tag-capital-improvement-projects","tag-pop-ups","tag-schertz","arcuser_issues-fall-2025"],"acf":{"short_description":"In Schertz, Texas, a dashboard tracking capital improvements has enhanced transparency between city management and residents.","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"A perennial hurdle for cities around the world is the task of ensuring infrastructure projects are planned, communicated, and monitored clearly. These projects are the bones of any well-functioning city, and having a framework for effective communication in place can only save time and money within departments and make life easier for city residents.\r\n\r\nIn Schertz, Texas, this issue was acute. To provide effective communication about capital improvement projects (CIPs) to stakeholders, city management would have to reach out to the engineering department directly for information. This meant requiring formal reports, waiting for scheduled meeting times, or communicating vital information with numerous phone calls. The team recognized the need for a solution that would streamline this communication.\r\n\r\nThe Schertz engineering department collaborated with the city\u2019s GIS team to address this challenge by using ArcGIS Dashboards to develop the Capital Improvement Projects dashboard. This dashboard has not only improved internal processes but also enhanced transparency between city management and residents. The dashboard\u2019s ability to provide real-time project updates reduced the need for countless inquiries and allowed users to view ongoing and upcoming projects on demand."},{"acf_fc_layout":"content","content":"<h2>Elements of Design<\/h2>\r\nWhile the dashboard prioritizes a user-friendly, intuitive design and filtering capabilities, many of its impacts lie behind the scenes. ArcGIS Arcade and HTML coding enhance the pop-ups with unique features, including a dynamic progress bar, which visually represents each project\u2019s stage along its timeline. The design for the progress bar is coded using HTML in the pop-up editor in Map Viewer by adding an Arcade expression under Add Content. The information needed to feed the progress bar is housed in the attribute expressions using conditional logic and ultimately referenced in the HTML script."},{"acf_fc_layout":"image","image":769589,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Another challenge addressed through coding involved the project\u2019s start and end dates. Definitive dates for CIPs are not always available due to the bidding process and contract variations with third-party companies. To accommodate this, Arcade conditional logic ensured dates were accurate and flexible. The dashboard dynamically defaults to showing the projected season and year (e.g., \u201cSpring 2025\u201d) for projects without a finalized deadline. Once a contract is in place, the start and end dates update automatically to show the official timeline. These design features ensure that the dashboard is user-friendly and highly accurate, providing stakeholders with a clear picture of the project status when needed."},{"acf_fc_layout":"content","content":"<h2>Development and Evolution<\/h2>\r\nThe development of the CIP dashboard was a collaborative effort that spanned almost a year. The GIS team and the engineering department met monthly to discuss revisions of the design, identify pertinent project details, and determine what was deemed public information. This iterative process allowed for continued improvements and feedback from stakeholders to ensure that the tool met both functional and aesthetic needs.\r\n\r\nWhile continually evolving, the current version of the dashboard represents months of planning, coding, and testing. The result is a living, breathing application that can be updated regularly to reflect real-time data and developments.\r\n\r\n\u201cThe customization and creation of our new dashboard is not only user-friendly but it also has the capability to display all the information we want,\u201d said John Nowak, assistant city engineer for Schertz and active collaborator for the CIP dashboard. \u201cSince our dashboard has gone online, we have received many compliments from the public and our elected officials on how easy the information is to access and how helpful it is. The dashboard has been such a success that other departments are now working with GIS to develop similar dashboards for their needs.\u201d"},{"acf_fc_layout":"image","image":769590,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"The success of the current rendition of the dashboard has set the stage for future enhancements. Since the dashboard has gone live, the city has been actively working on collecting data for future projects leading all the way out to 2050. One long-term goal is to give users the ability to query upcoming projects for the next five years without having to display the linework for all future projects. This will require at least a date field reflecting the fiscal year in which the project is planned. With the use of conditional logic, as each new year begins, projects scheduled for the sixth year will automatically transition into the five-year project list, ensuring that the dashboard remains current and relevant without having to manually update all its elements. By leveraging this automation and data management, the Schertz GIS team aims to further enhance the dashboard\u2019s functionality, making it an important asset for future planning and decision-making.\r\n\r\nSchertz\u2019s Capital Improvement Projects dashboard is a straightforward, powerful example of how GIS can solve complex challenges, enhance workflows, and promote clear communication and transparency within municipalities. Combining ArcGIS Dashboards with additional coding techniques, Schertz\u2019s GIS team has developed a solution that supports communication across city management, the engineering department, and the public alike."}],"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>Dashboards Track Capital Improvement Projects in Schertz | Fall 2025 | ArcUser<\/title>\n<meta name=\"description\" content=\"In Schertz, Texas, a dashboard tracking capital improvements has enhanced transparency between city management and residents.\" \/>\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\/dashboards-track-capital-improvement-projects-in-schertz\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dashboards Track Capital Improvement Projects in Schertz | Fall 2025 | ArcUser\" \/>\n<meta property=\"og:description\" content=\"In Schertz, Texas, a dashboard tracking capital improvements has enhanced transparency between city management and residents.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz\" \/>\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\/2025\/11\/arcuser-banner-dashboards-wide.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Dashboards Track Capital Improvement Projects in Schertz | Fall 2025 | ArcUser\" \/>\n<meta name=\"twitter:description\" content=\"In Schertz, Texas, a dashboard tracking capital improvements has enhanced transparency between city management and residents.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2025\/11\/arcuser-banner-dashboards-wide.jpg\" \/>\n<meta name=\"twitter:site\" content=\"@Esri\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\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\/dashboards-track-capital-improvement-projects-in-schertz\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz\",\n\t            \"name\": \"Dashboards Track Capital Improvement Projects in Schertz | Fall 2025 | ArcUser\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2025-11-12T01:52:00+00:00\",\n\t            \"description\": \"In Schertz, Texas, a dashboard tracking capital improvements has enhanced transparency between city management and residents.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz#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\/dashboards-track-capital-improvement-projects-in-schertz\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz#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\": \"Dashboards Track Capital Improvement Projects in Schertz\"\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\/41c803b2ea8734c36f9c4e9586d1449d\",\n\t            \"name\": \"Amy Ambard\",\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\/f356480172f8ad0bc8d72b855e84171c52f1944c7c7779f3e425d73bf3efa3c7?s=96&d=blank&r=g\",\n\t                \"contentUrl\": \"https:\/\/secure.gravatar.com\/avatar\/f356480172f8ad0bc8d72b855e84171c52f1944c7c7779f3e425d73bf3efa3c7?s=96&d=blank&r=g\",\n\t                \"caption\": \"Amy Ambard\"\n\t            },\n\t            \"url\": \"\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Dashboards Track Capital Improvement Projects in Schertz | Fall 2025 | ArcUser","description":"In Schertz, Texas, a dashboard tracking capital improvements has enhanced transparency between city management and residents.","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\/dashboards-track-capital-improvement-projects-in-schertz","og_locale":"en_US","og_type":"article","og_title":"Dashboards Track Capital Improvement Projects in Schertz | Fall 2025 | ArcUser","og_description":"In Schertz, Texas, a dashboard tracking capital improvements has enhanced transparency between city management and residents.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2025\/11\/arcuser-banner-dashboards-wide.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_title":"Dashboards Track Capital Improvement Projects in Schertz | Fall 2025 | ArcUser","twitter_description":"In Schertz, Texas, a dashboard tracking capital improvements has enhanced transparency between city management and residents.","twitter_image":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2025\/11\/arcuser-banner-dashboards-wide.jpg","twitter_site":"@Esri","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz","url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz","name":"Dashboards Track Capital Improvement Projects in Schertz | Fall 2025 | ArcUser","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2025-11-12T01:52:00+00:00","description":"In Schertz, Texas, a dashboard tracking capital improvements has enhanced transparency between city management and residents.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/dashboards-track-capital-improvement-projects-in-schertz#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"Dashboards Track Capital Improvement Projects in Schertz"}]},{"@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\/41c803b2ea8734c36f9c4e9586d1449d","name":"Amy Ambard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f356480172f8ad0bc8d72b855e84171c52f1944c7c7779f3e425d73bf3efa3c7?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f356480172f8ad0bc8d72b855e84171c52f1944c7c7779f3e425d73bf3efa3c7?s=96&d=blank&r=g","caption":"Amy Ambard"},"url":""}]}},"sort_order":"11","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/769588","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\/5752"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/769588\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=769588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=769588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=769588"},{"taxonomy":"arcuser_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser_issues?post=769588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}