{"id":309912,"date":"2020-02-17T13:56:31","date_gmt":"2020-02-17T21:56:31","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcwatch&#038;p=309912"},"modified":"2020-04-16T11:34:41","modified_gmt":"2020-04-16T18:34:41","slug":"the-property-mappers","status":"publish","type":"arcwatch","link":"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers","title":{"rendered":"The Property Mappers"},"content":{"rendered":"","protected":false},"author":1172,"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":"","footnotes":"","_links_to":"","_links_to_target":""},"categories":[423862],"tags":[424992,295842,425562,209772,425572],"arcwatch_issues":[416622],"class_list":["post-309912","arcwatch","type-arcwatch","status-publish","format-standard","hentry","category-arcgis-dashboards","tag-arcgis-dashboards","tag-arcpy","tag-auditors","tag-esri","tag-franklin-county-ohio","arcwatch_issues-april-2020","arcwatch_sections-the-headlines"],"acf":{"short_description":"Creative thinkers find new ways to use ArcGIS Dashboards, such as the Real Estate Sales Dashboard from the Franklin County Auditor in Ohio. ","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"The thousands of dashboards that have been created using <a href=\"https:\/\/www.esri.com\/en-us\/arcgis\/products\/arcgis-dashboards\/overview\">ArcGIS Dashboards<\/a> (formerly Operations Dashboard for ArcGIS), from Esri, keep organizations and the public in the know with a vast amount of valuable information daily.\r\n\r\nDashboards track election results, 311 citizen requests for service, bird migrations, building permit information, opioid overdoses, capital improvement and real estate development projects, and crime statistics, to name a few examples.\r\n\r\nCreative thinkers always come up with new ideas for dashboards, such as the recently launched <a href=\"https:\/\/fca.maps.arcgis.com\/apps\/opsdashboard\/index.html#\/91742f7a936e482e8f5db6c2e453deb7\">Real Estate Sales Dashboard<\/a> from the Franklin County Auditor's Office in Ohio. The dashboard, which went live last September on the <a href=\"https:\/\/www.franklincountyauditor.com\/\">auditor's website<\/a>, displays the most recent month's data, including\r\n<ul>\r\n \t<li>The residential real estate sales total for Franklin County and for more than 80 local municipalities, area commissions, school districts, and townships.<\/li>\r\n \t<li>The median sales price for homes in each area.<\/li>\r\n \t<li>The number of sales in each area.<\/li>\r\n \t<li>The number of sales per school district, displayed in a pie chart.<\/li>\r\n \t<li>The location of each building sold, shown on a map. Pop-ups on each feature include a photograph and the address of the building, the property's acreage, and the parcel ID. The parcel ID links to more detailed information about the building, including the date it was sold, its owners' names, the year the structure was built, its square footage, the current market value of the property, and the current taxable value.<\/li>\r\n<\/ul>\r\nThe data is updated monthly."},{"acf_fc_layout":"image","image":310302,"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/fca.maps.arcgis.com\/apps\/opsdashboard\/index.html#\/91742f7a936e482e8f5db6c2e453deb7"},{"acf_fc_layout":"content","content":"Franklin County auditor Michael Stinziano said the Real Estate Sales Dashboard resulted from a request from neighborhood groups. The organizations wanted the auditor's office website to provide authoritative, easily accessible, and hyperlocalized real estate sales information due to the impact the current booming real estate market is having on neighborhoods' property values and school districts' funding in Franklin County.\r\n\r\n\"Ohio is one of the hottest real estate markets in the country,\" Stinziano said in a recent interview. Home sales in Franklin County topped $5.3 billion in 2019, an increase of 4.4 percent over 2018.\r\n\r\n\"Having such a competitive housing market means buyers, sellers, and agents are constantly reviewing properties for sale,\" Stinziano said. \"Our dashboard gives accessible and transparent data to help inform those choices.\""},{"acf_fc_layout":"image","image":310092,"image_position":"left","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Franklin County (pop. 1.3 million) is home to Ohio's state capital, Columbus, named by <em>Forbes<\/em> magazine in 2019 as the top real estate market in the nation. Columbus was also recently included in the Top 10 Outperforming Metro Markets Report by the National Association of REALTORS, meaning that over the next three to five years, real estate sales should be strong based on factors that make home buying more attainable. Some of those factors include housing affordability for residents new to the area, home price appreciation, and consistent job growth relative to the national average.\r\n\r\nRealtors like the dashboard because it's a good resource to search for comparable sales. School district officials also will find the dashboard useful because they can see, at a glance, the number of home sales in their particular districts each month, along with the total sales amount and the median sales price.\r\n\r\nMatt Shade, the GIS manager for the auditor's office, said this project was the first time his team had created a configurable web app using ArcGIS Dashboards and that it was easy to do.\r\n\r\nEach month, the previous month's real estate transfer data is plotted as points on a map. The points are queried to ensure they are valid arm's-length transactions. Using an <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/arcpy\/get-started\/what-is-arcpy-.htm\">ArcPy<\/a> script, boundaries for each area are overlaid, and summary statistics are generated to get the number of transactions, the median sales price, and the total number of sales for the month.\r\n\r\n\"We publish that through ArcGIS Online and it goes to the dashboard,\" Shade said."},{"acf_fc_layout":"image","image":310362,"image_position":"right","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Once the geoprocessing script was developed, design considerations became the main focus. The GIS team kept the amount of information on the dashboard to a minimum, with only four major data points plus the map.\r\n\r\n\"We utilized Esri's training when we [went] to share this data,\" Shade said. \"The recommendation from Esri is to keep it simple. You don't want to overload people [with information].\"\r\n\r\nTo find a solution for mobile viewing, the team developed a second dashboard that only displays statistics for each area and not the map. Users are redirected based on screen width. Another consideration was the basemap. The team decided to combine Esri's <a href=\"https:\/\/www.arcgis.com\/home\/item.html?id=ed712cb1db3e4bae9e85329040fb9a49\"><em>World Light Gray Base<\/em><\/a> map with labels from Esri's Human Geography basemap. Developing the dashboard took the GIS team about a month from start to finish.\r\n\r\nThe GIS team used ArcGIS Dashboards for this project because it provides a seamless and efficient way to share key statistics generated in ArcGIS, according to Shade. The team plans to release an ArcGIS StoryMaps app highlighting annual sales trends by compiling monthly data from the Real Estate Sales Dashboard and perspectives from local real estate experts."}],"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>The Property Mappers<\/title>\n<meta name=\"description\" content=\"The Franklin County Auditor&#039;s Office in Ohio used ArcGIS Dashboards to give the public, Realtors, and buyers and sellers an interesting view of current local real estate sales.\" \/>\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\/arcwatch\/the-property-mappers\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Property Mappers\" \/>\n<meta property=\"og:description\" content=\"The Franklin County Auditor&#039;s Office in Ohio used ArcGIS Dashboards to give the public, Realtors, and buyers and sellers an interesting view of current local real estate sales.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers\" \/>\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=\"2020-04-16T18:34:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2020\/02\/columbusohio-wide.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\/arcwatch\/the-property-mappers\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers\",\n\t            \"name\": \"The Property Mappers\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2020-02-17T21:56:31+00:00\",\n\t            \"dateModified\": \"2020-04-16T18:34:41+00:00\",\n\t            \"description\": \"The Franklin County Auditor's Office in Ohio used ArcGIS Dashboards to give the public, Realtors, and buyers and sellers an interesting view of current local real estate sales.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers#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\/arcwatch\/the-property-mappers\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers#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\": \"ArcWatch Articles\",\n\t                    \"item\": \"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 3,\n\t                    \"name\": \"The Property Mappers\"\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\/a808f3d3f9baab44de2533028998afe9\",\n\t            \"name\": \"Carla Wheeler\",\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\/carla.jpeg\",\n\t                \"contentUrl\": \"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/carla.jpeg\",\n\t                \"caption\": \"Carla Wheeler\"\n\t            },\n\t            \"description\": \"Carla Wheeler is a former technology writer and editor at Esri and a former newspaper journalist. She graduated from the University of Minnesota with a Bachelor of Arts degree in journalism and political science. She was the previous editor of ArcWatch and worked with ArcGIS StoryMaps apps. Follow her on Twitter @gisjourno.\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/author\/cwheeler\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The Property Mappers","description":"The Franklin County Auditor's Office in Ohio used ArcGIS Dashboards to give the public, Realtors, and buyers and sellers an interesting view of current local real estate sales.","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\/arcwatch\/the-property-mappers","og_locale":"en_US","og_type":"article","og_title":"The Property Mappers","og_description":"The Franklin County Auditor's Office in Ohio used ArcGIS Dashboards to give the public, Realtors, and buyers and sellers an interesting view of current local real estate sales.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2020-04-16T18:34:41+00:00","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2020\/02\/columbusohio-wide.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\/arcwatch\/the-property-mappers","url":"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers","name":"The Property Mappers","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2020-02-17T21:56:31+00:00","dateModified":"2020-04-16T18:34:41+00:00","description":"The Franklin County Auditor's Office in Ohio used ArcGIS Dashboards to give the public, Realtors, and buyers and sellers an interesting view of current local real estate sales.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcwatch\/the-property-mappers#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"ArcWatch Articles","item":"https:\/\/www.esri.com\/about\/newsroom\/arcwatch"},{"@type":"ListItem","position":3,"name":"The Property Mappers"}]},{"@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\/a808f3d3f9baab44de2533028998afe9","name":"Carla Wheeler","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\/carla.jpeg","contentUrl":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/carla.jpeg","caption":"Carla Wheeler"},"description":"Carla Wheeler is a former technology writer and editor at Esri and a former newspaper journalist. She graduated from the University of Minnesota with a Bachelor of Arts degree in journalism and political science. She was the previous editor of ArcWatch and worked with ArcGIS StoryMaps apps. Follow her on Twitter @gisjourno.","url":"https:\/\/www.esri.com\/about\/newsroom\/author\/cwheeler"}]}},"sort_order":"4","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcwatch\/309912","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcwatch"}],"about":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/types\/arcwatch"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/users\/1172"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcwatch\/309912\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=309912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=309912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=309912"},{"taxonomy":"arcwatch_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcwatch_issues?post=309912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}