{"id":128942,"date":"2018-10-28T23:55:25","date_gmt":"2018-10-29T06:55:25","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcnews&#038;p=128942"},"modified":"2023-08-08T16:42:09","modified_gmt":"2023-08-08T23:42:09","slug":"a-vibrant-new-data-model-keeps-a-solar-field-beaming","status":"publish","type":"arcnews","link":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming","title":{"rendered":"A Vibrant New Data Model Keeps a Solar Field Beaming"},"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":[10412,401,1011],"tags":[1661,1321,16462,163392],"arcnews_issues":[138472],"class_list":["post-128942","arcnews","type-arcnews","status-publish","format-standard","hentry","category-arcgis-pro","category-government","category-utilities","tag-asset-management","tag-innovation","tag-partners","tag-solar","arcnews_issues-arcnews-fall-2018","arcnews_sections-your-work"],"acf":{"short_description":"To manage all the assets in its new solar facility, the City of Loveland, CO, uses Esri technology alongside Cityworks in an innovative way.","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"In 2013, a series of floods ravaged Colorado\u2014including the city of Loveland, which lies about 50 miles north of Denver. Flooding there razed the Idylwilde Dam, which generated hydropower for the city. This forced officials to rethink how they could produce electricity.\r\n\r\nUsing a grant from the Federal Emergency Management Administration\u2019s (FEMA) Alternate Project funds, Loveland ended up replacing its hydroelectric power source with a solar field. By the end of 2016, the Foothills Solar and Substation project had more than 10,000 solar panels up and running, producing 3.5 megawatts of electricity\u2014over three times the capacity of the dam\u2019s 900 kilowatts. That\u2019s reportedly enough to power 574 homes in Colorado for an entire year.\r\n\r\nThe City of Loveland needed a way to manage all the assets in its new solar facility\u2014preferably in a repeatable and efficient manner. The Water and Power Department wanted to be able to track not only assets but also maintenance schedules and all the costs associated with that. This would include everything from mowing the grass and cleaning the photovoltaic panels to replacing inverter air filters and inspecting the motors that enable the panels to track the sun. Additionally, the Water and Power Department wanted to use the city\u2019s existing Cityworks asset management system from Esri partner Azteca Systems, LLC, since a number of other departments also use it for maintenance management and work order tracking."},{"acf_fc_layout":"image","image":144382,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"To meet all these requirements, staff decided that employing a schema and organizing the assets into features in ArcGIS would be the best way to do this. But that would mean that every single component of the solar field would have to have a feature and\/or related asset record in ArcGIS. That was going to be a big project.\r\n\r\nInitially, the Water and Power Department tried to find an already-existing asset-driven data model or related database schema for solar fields. After scouring the Internet and contacting several organizations\u2014including Esri, the National Renewable Energy Laboratory, Colorado State University (which has a solar facility), multiple solar construction companies, and other municipal agencies\u2014to get input, staff realized that Loveland\u2019s project was unique. There were many examples of data models and schemas being used for solar site selection, but it seemed that nobody was actively employing Esri technology alongside Cityworks to manage assets in a solar facility. The city was going to have to build its own data model from scratch.\r\n\r\nIt took the Water and Power Department three months to create and start using the asset data model. First, the small team working on the project used ArcGIS Pro 2.2 to convert CAD drawings of the solar field into feature classes. Then the team took city-owned aerial photography and used the conflation tools in ArcGIS Pro to ensure that the CAD drawings matched the images. The team also went out in the field with Collector for ArcGIS to give each piece of equipment a unique ID and verify that nothing went missing during the CAD conversion. All this data was stored in the city\u2019s existing Microsoft SQL Server geodatabase.\r\n\r\nOnce the data model was deployed, the Water and Power Department built the work order requirements and their related workflows in Cityworks. Finally, staff were able to attach work orders to specific assets."},{"acf_fc_layout":"image","image":128982,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Now, every single asset in the facility\u2014from combiner boxes and track motors to inverters and transformers\u2014is stored in this system of record, which staff also use to keep track of maintenance schedules, including the time it takes to perform maintenance, how much time passes between repairs, and how long each asset has been in use. This allows the Water and Power Department to conduct more preventive and lower-cost maintenance as opposed to always having to replace pieces of equipment.\r\n\r\nAdditionally, with Cityworks mobile, field crews can take asset management requests and perform maintenance in the field\u2014all from their mobile devices. Because the entire data model was built in ArcGIS Pro, field staff can make their edits quickly and precisely, too.\r\n\r\nThe City of Loveland has been using Cityworks, ArcGIS Pro, and the data model to monitor and manage assets in its new solar field since May\u2014and staff are impressed by the results. Because each work order contains detailed information about associated equipment and assets, including costs, the city can manage warehouse materials, stock levels, and spare parts more accurately and efficiently.\r\n\r\n\u201cAs we begin tracking historical data, we can better understand each job and its associated cost,\u201d said Sterling Overturf, a business analyst at the City of Loveland. \u201cThis is impressive in itself and helps us better manage our equipment and staff time\u2014and it will lead to better management of the facility overall.\u201d\r\n\r\nIn the future, the City of Loveland intends to expand its solar data model alongside any augmentations of the solar field, so it can seamlessly handle additional assets and their maintenance, upgrade, and replacement schedules. This way, the Foothills Solar and Substation project can keep powering a growing Loveland for years to come.\r\n\r\nFor more information on Loveland\u2019s solar field asset management project, contact senior GIS specialist Ryan Smith at <a href=\"mailto:ryan.smith@cityofloveland.org\">ryan.smith@cityofloveland.org<\/a> or 970-962-3599."}],"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 Vibrant New Data Model Keeps a Solar Field Beaming | Fall 2016 | ArcNews<\/title>\n<meta name=\"description\" content=\"To manage all the assets in its new solar facility, the City of Loveland, CO, uses Esri technology alongside Cityworks in an innovative way.\" \/>\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-vibrant-new-data-model-keeps-a-solar-field-beaming\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Vibrant New Data Model Keeps a Solar Field Beaming\" \/>\n<meta property=\"og:description\" content=\"To manage all the assets in its new solar facility, the City of Loveland, CO, uses Esri technology alongside Cityworks in an innovative way.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming\" \/>\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-08T23:42:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/10\/arcnews-banner-avibrantnewdatamodel-card.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\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming\",\n\t            \"name\": \"A Vibrant New Data Model Keeps a Solar Field Beaming | Fall 2016 | ArcNews\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2018-10-29T06:55:25+00:00\",\n\t            \"dateModified\": \"2023-08-08T23:42:09+00:00\",\n\t            \"description\": \"To manage all the assets in its new solar facility, the City of Loveland, CO, uses Esri technology alongside Cityworks in an innovative way.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming#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-vibrant-new-data-model-keeps-a-solar-field-beaming\"\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-vibrant-new-data-model-keeps-a-solar-field-beaming#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 Vibrant New Data Model Keeps a Solar Field Beaming\"\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":"A Vibrant New Data Model Keeps a Solar Field Beaming | Fall 2016 | ArcNews","description":"To manage all the assets in its new solar facility, the City of Loveland, CO, uses Esri technology alongside Cityworks in an innovative way.","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-vibrant-new-data-model-keeps-a-solar-field-beaming","og_locale":"en_US","og_type":"article","og_title":"A Vibrant New Data Model Keeps a Solar Field Beaming","og_description":"To manage all the assets in its new solar facility, the City of Loveland, CO, uses Esri technology alongside Cityworks in an innovative way.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2023-08-08T23:42:09+00:00","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/10\/arcnews-banner-avibrantnewdatamodel-card.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\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming","url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming","name":"A Vibrant New Data Model Keeps a Solar Field Beaming | Fall 2016 | ArcNews","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2018-10-29T06:55:25+00:00","dateModified":"2023-08-08T23:42:09+00:00","description":"To manage all the assets in its new solar facility, the City of Loveland, CO, uses Esri technology alongside Cityworks in an innovative way.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/a-vibrant-new-data-model-keeps-a-solar-field-beaming#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 Vibrant New Data Model Keeps a Solar Field Beaming"}]},{"@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":"11","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/128942","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\/128942\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=128942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=128942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=128942"},{"taxonomy":"arcnews_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews_issues?post=128942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}