{"id":726792,"date":"2025-01-12T19:59:55","date_gmt":"2025-01-13T03:59:55","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcnews&#038;p=726792"},"modified":"2025-01-12T14:32:24","modified_gmt":"2025-01-12T22:32:24","slug":"real-estate-advisers-use-gis-to-connect-systems-automate-data-integration","status":"publish","type":"arcnews","link":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration","title":{"rendered":"Real Estate Advisers Use GIS to Connect Systems, Automate Data Integration"},"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":[490692,475222,10842],"tags":[163382,165542,362132,281,1261],"arcnews_issues":[491292],"class_list":["post-726792","arcnews","type-arcnews","status-publish","format-standard","hentry","category-arcgis-data-pipelines","category-commercial-real-estate","category-data","tag-arcgis-online","tag-data-sharing","tag-integration","tag-location-intelligence","tag-real-estate","arcnews_issues-winter-2025","arcnews_sections-your-work"],"acf":{"short_description":"By implementing ArcGIS Data Pipelines, KBC Advisors has saved time, enhanced efficiency, and improved data delivery.","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"For businesses of any size, the decision to expand can help increase profits and reach new customers. This may involve adding physical locations or obtaining new spaces to produce goods. KBC Advisors assists clients with managing and executing the best real estate outcomes for their businesses using data-backed guidance. With a focus on premier industrial space, KBC\u2019s full-service platform caters to tenant, landlord, and investor needs.\r\n\r\nTo show the availability of commercial sites and their locations, the location intelligence team at KBC Advisors used to use an external app to track existing assets and land sites, export the files, and then upload the information into a separate system for visualization. This process was time-consuming and required team members to focus to avoid making errors while moving information from system to system.\r\n\r\nIn search of a better solution, KBC\u2019s location intelligence team implemented ArcGIS Data Pipelines for more seamless data integration with ArcGIS. This has improved the accuracy of data and automated processes\u2014saving time, enhancing efficiency, and enabling the location intelligence team to more effectively deliver clients and real estate brokerage professionals the data they need."},{"acf_fc_layout":"image","image":728192,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>A Disconnected, Manual Process<\/h2>\r\nIn KBC\u2019s old workflow, the location intelligence team would create data and track projects and business deals in external platforms. A GIS analyst would then use ArcGIS Pro to plot the coordinates of available site locations and publish them to ArcGIS Online. The web layers displaying the data were then showcased in client-facing apps\u2014but they would quickly become out-of-date.\r\n\r\nThe disconnected systems translated to too many manual steps, leading to inefficiencies and errors. Information was extracted dozens of times a week, so KBC\u2019s GIS team wanted a more efficient process for data visualization.\r\n\r\n\u201c[The process] was too slow,\u201d said James Drumm, director of services and technology at KBC Advisors. \u201cEdits in either application weren\u2019t always being tracked in the other application.\u201d\r\n\r\nThis was critical when tracking whether a potential site was available or unavailable. The most current status was not always reflected in the system because the data was based on a static spreadsheet downloaded at the time rather than on real-time data."},{"acf_fc_layout":"content","content":"<h2>Streamlined Data Integration<\/h2>\r\nDrumm began searching for a new solution that would help integrate outside apps with ArcGIS. After receiving email notifications about a new Esri product, Drumm and the GIS team became early adopters of ArcGIS Data Pipelines. This app streamlines data integration in ArcGIS Online by offering an efficient way to ingest, prepare, and maintain data\u2014even if it\u2019s in a separate system.\r\n\r\nThe group still needed to use a mediary data storage solution, however. When Drumm saw that Data Pipelines supported Microsoft Azure Blob Storage as an input data source, he chose that as the intermediate connector between ArcGIS Online and an outside platform.\r\n\r\nDrumm and KBC\u2019s team of GIS analysts began using Data Pipelines in late 2023, and use \u201cexploded\u201d after they established a connection to their Azure Blob Storage container, said Drumm. He added that the team found Data Pipelines easy to learn and use and that connecting the cloud storage container was very straightforward.\r\n\r\nThe implementation process began by having KBC\u2019s internal Microsoft Azure specialist set up a job that would push the data from an external platform to Azure Blob Storage. From there, Data Pipelines can access the latest data.\r\n\r\nThe integration process is now automated and set to a schedule. Azure Blob Storage refreshes multiple times per day, and the respective data pipelines are scheduled to run at the same cadence. Using this process, the data in ArcGIS Online is updated every few hours, ensuring that the latest changes are reflected throughout the day."},{"acf_fc_layout":"content","content":"<h2>Real-Time Data Reflection<\/h2>\r\nThe revamped workflow with Data Pipelines has streamlined operations and offered many benefits to the location intelligence team\u2019s daily workflows, according to Selena Lawson, GIS manager at KBC Advisors. The use of Data Pipelines has saved time, and many of the data pipelines run multiple times per day, Monday through Friday. So instead of having the team spend time on manual extract, transform, and load (ETL) processes, any data updates get automatically reflected in ArcGIS Online.\r\n\r\n\u201cThis real-time reflection of the data ensures our users have the most up-to-date information we can provide,\u201d said Lawson.\r\n\r\nData Pipelines has vastly improved the team\u2019s speed and reliability, according to Drumm. The scheduling feature that lets the location intelligence team schedule data updates based on a specified time frame is critical and helps ensure the availability of current data. The recurring Azure Blob Storage refresh operation takes only seven minutes, and then the data pipelines that are connected automatically kick off shortly afterward to update the feature services in ArcGIS Online. In total, the updates take less than 20 minutes.\r\n\r\n\u201cDue to the scheduling function, we can redirect much of our focus from repeat tasks to more intricate analyses and deliverables,\u201d said Lawson."},{"acf_fc_layout":"content","content":"<h2>Automation Improves Accuracy<\/h2>\r\nData accuracy has improved with Data Pipelines as well. Now, after researchers enter the data into KBC\u2019s main database, Data Pipelines moves it into ArcGIS Online without any additional human interaction. According to Lawson, this ensures that \u201cthe schemas match, data is formatted correctly, and no time is spent correcting transformation errors.\u201d\r\n\r\nIf an error is made when data gets entered, however, the data pipeline will catch and correct it, and the cleaned data will be reflected in ArcGIS Online.\r\n\r\n\u201cThe data update capability enables us to no longer rely on multiple sources and users for data input. Because of this, there are virtually no human errors or manual time spent on the Esri side of things,\u201d said Lawson. \u201cThis saves an average of 75 percent of our analysts\u2019 total time spent on data update requests.\u201d\r\n\r\nMoving data is no longer an issue for the team, either, because it is automated.\r\n\r\n\u201cThis saved time allows our analysts to focus on location analysis, serving our clients, and building custom applications instead of data cleanup and updates,\u201d said Drumm.\r\n\r\nPlotting the coordinates of commercial sites comprises 99 percent of the location intelligence team\u2019s workflow, according to Drumm, so it is critical work. The new workflow with Data Pipelines means that the team is no longer converting tabular locations into a feature service to show it on a map. The Create geometry tool in Data Pipelines is used instead to create a point geometry field from a tabular dataset that contains longitude and latitude fields and then update an existing feature service automatically.\r\n\r\nThe GIS team has now created hundreds of feature layers with Data Pipelines. With all that data being connected, accurate, and available in ArcGIS Online, deliverables such as a labor study or a site survey comparison can be done in a day, not weeks, helping KBC better serve its clients.\r\n\r\n\u201cOne of the most important things in our industry\u2026is speed combined with accuracy. So if I can cut out manual steps, if I can cut out extra people doing things, if I can cut out you having to enter data in four different systems, that just vastly improves our speed to a solution,\u201d said Drumm. \u201cMy personal goal for the team is speed and accuracy, and we can meet that.\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>Real Estate Advisers Use GIS to Connect Systems, Automate Data Integration | Winter 2025 | ArcNews<\/title>\n<meta name=\"description\" content=\"By implementing ArcGIS Data Pipelines, KBC Advisors has saved time, enhanced efficiency, and improved data delivery.\" \/>\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\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Real Estate Advisers Use GIS to Connect Systems, Automate Data Integration\" \/>\n<meta property=\"og:description\" content=\"By implementing ArcGIS Data Pipelines, KBC Advisors has saved time, enhanced efficiency, and improved data delivery.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration\" \/>\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\/01\/arcnews-banner-realestate-wide.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"By implementing ArcGIS Data Pipelines, KBC Advisors has saved time, enhanced efficiency, and improved data delivery.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2025\/01\/arcnews-banner-realestate-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=\"6 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\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration\",\n\t            \"name\": \"Real Estate Advisers Use GIS to Connect Systems, Automate Data Integration | Winter 2025 | ArcNews\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2025-01-13T03:59:55+00:00\",\n\t            \"description\": \"By implementing ArcGIS Data Pipelines, KBC Advisors has saved time, enhanced efficiency, and improved data delivery.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration#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\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration#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\": \"Real Estate Advisers Use GIS to Connect Systems, Automate Data Integration\"\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":"Real Estate Advisers Use GIS to Connect Systems, Automate Data Integration | Winter 2025 | ArcNews","description":"By implementing ArcGIS Data Pipelines, KBC Advisors has saved time, enhanced efficiency, and improved data delivery.","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\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration","og_locale":"en_US","og_type":"article","og_title":"Real Estate Advisers Use GIS to Connect Systems, Automate Data Integration","og_description":"By implementing ArcGIS Data Pipelines, KBC Advisors has saved time, enhanced efficiency, and improved data delivery.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2025\/01\/arcnews-banner-realestate-wide.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_description":"By implementing ArcGIS Data Pipelines, KBC Advisors has saved time, enhanced efficiency, and improved data delivery.","twitter_image":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2025\/01\/arcnews-banner-realestate-wide.jpg","twitter_site":"@Esri","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration","url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration","name":"Real Estate Advisers Use GIS to Connect Systems, Automate Data Integration | Winter 2025 | ArcNews","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2025-01-13T03:59:55+00:00","description":"By implementing ArcGIS Data Pipelines, KBC Advisors has saved time, enhanced efficiency, and improved data delivery.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/real-estate-advisers-use-gis-to-connect-systems-automate-data-integration#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":"Real Estate Advisers Use GIS to Connect Systems, Automate Data Integration"}]},{"@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":"9","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/726792","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\/5752"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/726792\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=726792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=726792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=726792"},{"taxonomy":"arcnews_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews_issues?post=726792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}