{"id":726702,"date":"2025-01-12T19:59:09","date_gmt":"2025-01-13T03:59:09","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcnews&#038;p=726702"},"modified":"2025-01-12T14:32:10","modified_gmt":"2025-01-12T22:32:10","slug":"to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis","status":"publish","type":"arcnews","link":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis","title":{"rendered":"To Survey Health-Care Adequacy, ArcGIS GeoAnalytics Engine Simplifies Analysis"},"author":5752,"featured_media":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"sync_status":"","episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","castos_file_data":"","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":[481962,731,931],"tags":[178702,611,209902,281,278402],"arcnews_issues":[491292],"class_list":["post-726702","arcnews","type-arcnews","status-publish","format-standard","hentry","category-arcgis-geoanalytics-engine","category-health","category-spatial-analysis","tag-analysis","tag-business-intelligence","tag-healthcare","tag-location-intelligence","tag-network-analysis","arcnews_issues-winter-2025","arcnews_sections-esri-technology"],"acf":{"short_description":"Monitoring network adequacy involves large datasets and complex calculations to confirm that health care is within reach for all members.","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"Health insurance plans need to provide policy holders with a sufficient number of in-network providers and services. This is called network adequacy, and it ensures that patients can access necessary medical care when they need it, without having to travel far.\r\n\r\nMonitoring network adequacy involves large datasets and complex calculations to confirm that health plan networks\u2014including doctors, hospitals, and specialized centers\u2014are within reach for all members. Understanding network adequacy is challenging due to the stringent federal and state regulations that govern health care."},{"acf_fc_layout":"image","image":728012,"image_position":"right","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"To simplify the process of calculating network adequacy, health-care companies can employ advanced tools such as ArcGIS GeoAnalytics Engine. This library for Apache Spark, which provides a collection of spatial SQL functions and analysis tools, efficiently processes large geospatial datasets and enables users to apply smart spatial heuristics\u2014ways to minimize the number of calculations that need to be made.\r\n\r\nFor perspective, a brute-force approach to calculating network adequacy might require GeoAnalytics Engine to perform up to 768 trillion network calculations at the national level. Even determining network adequacy for regional health-care plans often requires conducting billions of calculations. But techniques such as using spatial partitioning and creating service areas can optimize the geographic relationship between patients and providers and make it easier for health-care organizations to run these calculations more regularly. And that\u2019s what GeoAnalytics Engine does well."},{"acf_fc_layout":"content","content":"<h2>How to Break Down a Very Large Issue<\/h2>\r\nTo demonstrate how health-care organizations can tackle this issue, let\u2019s conduct a simulated study on primary care providers in California and the organizations\u2019 distance standards.\r\n\r\nCalifornia has more than 13 million households. In the network we\u2019re simulating, there are more than 24,000 health-care providers. Determining the network adequacy of this group of providers yields well over 300 billion potential calculations\u2014so this is a very large issue."},{"acf_fc_layout":"image","image":728022,"image_position":"left","orientation":"vertical","hyperlink":""},{"acf_fc_layout":"content","content":"To explore this problem at scale, we\u2019ll leverage the elasticity of GeoAnalytics Engine along with the scalable computing environment provided by the Spark-based Databricks Data Intelligence Platform. In addition to using scalable spatial functions and tools that take advantage of Spark\u2019s distributed processing capabilities, we\u2019ll use smart spatial heuristics such as using partitioning, creating service areas, and employing binning to make the problem smaller.\r\n<h3>Smart Spatial Partitioning<\/h3>\r\nThe first heuristic we can apply to this problem is Euclidean distance\u2014the measurement of the straight-line distance between two points\u2014to identify which facilities (representing one or more providers) are near enough to each county to potentially demonstrate network adequacy. For example, if a health-care provider requires that 90 percent of its members in a particular county have a primary care provider within 15 miles of where they live, then all facilities offering primary care that are located in the county as well as those up to 15 miles away from it could meet that standard."},{"acf_fc_layout":"image","image":728032,"image_position":"right","orientation":"vertical","hyperlink":""},{"acf_fc_layout":"content","content":"To identify these providers, we first use GeoAnalytics Engine to create buffers around each county that corresponds to this accessibility standard. Then we apply a spatial join to match which facilities are within 15 miles of each county\u2019s border. The calculation shows how many facilities there are and includes the primary care providers who practice there.\r\n\r\nBy matching each facility that is inside a county or up to 15 miles from it, we have substantially reduced the number of origin-destination calculations\u2014or how far patients living on the edge of each county would have to drive to get to a medical provider\u2014needed to complete the adequacy analysis. Applying a brute-force approach to this would have required more than 300 billion calculations. Snapping providers to facilities would have reduced that to around 54.2 billion calculations. But employing smart partitioning using county buffers reduces the number of required calculations to 4.5 billion, eliminating more than 90 percent of the calculations that would have had to be done using either of the other methods.\r\n<h3>Creating Service Areas<\/h3>\r\nIn many cases, network adequacy is determined based on Boolean criteria, which employ true-or-false logic to measure whether a provider is located within or outside a specified distance. In our example, if 90 percent of members must have a primary care provider within 15 miles of their home, then we can measure adequacy by distinguishing how many members are within 15 miles of a provider compared to how many members are farther away. Rather than calculating the distance between each member and each provider, we can use GeoAnalytics Engine to create service areas to delineate the 15-mile boundary around each provider."},{"acf_fc_layout":"image","image":728042,"image_position":"left","orientation":"vertical","hyperlink":""},{"acf_fc_layout":"content","content":"By applying the Spatiotemporal Join tool or the SQL function ST_Within, these service areas can be dissolved together into one geometry to determine who is inside versus outside the service area. Moreover, when nearby counties have the same standard, we can use the same service area to perform multiple county-level analyses instead of analyzing each county individually.\r\n\r\nEmploying this heuristic, followed by a spatial join and a dissolve, to determine which households are within the service area and which are not means that 4,000 service area calculations need to be done\u2014rather than hundreds of millions of network distance calculations, which would then need to be filtered.\r\n<h3>Aggregating Points Using Bins<\/h3>\r\nInstead of using spatial joins and dissolves, we can apply another heuristic to simplify our problem: We can create a hexagon tessellation grid\u2014a grid of cells with an area and shape that cover a specified extent\u2014to calculate the average distance or time it takes to travel across an entire network."},{"acf_fc_layout":"image","image":728052,"image_position":"right","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"GeoAnalytics Engine provides SQL functions such as ST_H3Bin and tools like Aggregate Points that use standardized hexagon bins to aggregate, for example, the number of insurance plan members in a bin. This method simplifies the process of calculating network adequacy by allowing attribute joins based on bin IDs.\r\n\r\nLet\u2019s say we have 50 bins with 100 members in each of them, plus 20 providers. Performing a spatial join would involve testing 5,000 member points against 20 provider service areas, which would warrant 100,000 comparisons. With bins, however, we only have to test 50 bin centers against 20 provider bins, which results in making 1,000 comparisons. Then we multiply the results for each bin by the number of members. This reduces the computational load significantly compared to performing spatial joins."},{"acf_fc_layout":"content","content":"<h2>Faster, More Precise Results<\/h2>\r\nUsing GeoAnalytics Engine to calculate network adequacy for health-care plans speeds up the analysis process and enhances the precision of the results. It is a valuable tool for health-care companies to use to improve service accessibility.\r\n\r\nLearn more about <a href=\"https:\/\/www.esri.com\/en-us\/arcgis\/products\/arcgis-geoanalytics-engine\/overview\">how to conduct both simple and complex analyses<\/a> using GeoAnalytics Engine."}],"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>To Survey Health-Care Adequacy, ArcGIS GeoAnalytics Engine Simplifies Analysis | Winter 2025 | ArcNews<\/title>\n<meta name=\"description\" content=\"Monitoring network adequacy involves large datasets and complex calculations to confirm that health care is within reach for all members.\" \/>\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\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"To Survey Health-Care Adequacy, ArcGIS GeoAnalytics Engine Simplifies Analysis\" \/>\n<meta property=\"og:description\" content=\"Monitoring network adequacy involves large datasets and complex calculations to confirm that health care is within reach for all members.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis\" \/>\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-tosurvey-wide.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"Monitoring network adequacy involves large datasets and complex calculations to confirm that health care is within reach for all members.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2025\/01\/arcnews-banner-tosurvey-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=\"7 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\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis\",\n\t            \"name\": \"To Survey Health-Care Adequacy, ArcGIS GeoAnalytics Engine Simplifies Analysis | 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:09+00:00\",\n\t            \"description\": \"Monitoring network adequacy involves large datasets and complex calculations to confirm that health care is within reach for all members.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis#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\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis#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\": \"To Survey Health-Care Adequacy, ArcGIS GeoAnalytics Engine Simplifies Analysis\"\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":"To Survey Health-Care Adequacy, ArcGIS GeoAnalytics Engine Simplifies Analysis | Winter 2025 | ArcNews","description":"Monitoring network adequacy involves large datasets and complex calculations to confirm that health care is within reach for all members.","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\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis","og_locale":"en_US","og_type":"article","og_title":"To Survey Health-Care Adequacy, ArcGIS GeoAnalytics Engine Simplifies Analysis","og_description":"Monitoring network adequacy involves large datasets and complex calculations to confirm that health care is within reach for all members.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis","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-tosurvey-wide.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_description":"Monitoring network adequacy involves large datasets and complex calculations to confirm that health care is within reach for all members.","twitter_image":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2025\/01\/arcnews-banner-tosurvey-wide.jpg","twitter_site":"@Esri","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis","url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis","name":"To Survey Health-Care Adequacy, ArcGIS GeoAnalytics Engine Simplifies Analysis | Winter 2025 | ArcNews","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2025-01-13T03:59:09+00:00","description":"Monitoring network adequacy involves large datasets and complex calculations to confirm that health care is within reach for all members.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/to-survey-health-care-adequacy-arcgis-geoanalytics-engine-simplifies-analysis#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":"To Survey Health-Care Adequacy, ArcGIS GeoAnalytics Engine Simplifies Analysis"}]},{"@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":"8","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/726702","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\/726702\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=726702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=726702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=726702"},{"taxonomy":"arcnews_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews_issues?post=726702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}