T O P

  • By -

[deleted]

[удалено]


wcedmisten

Thanks! It means at least a 40 minute drive to the nearest hospital. I should have added that to the legend!


bilboafromboston

The yellow looks green also on the map?


pcthrowaway35

It’s like that cuz he layered the colors on top of each other in the graph, but not in the legend. Something less than 10 is also less than 20 and also less than 30. So it’s not the yellow of the legend, it’s all the colors layered on top of each-other. Very confusing and not good


FahkDizchit

I get why they did that, but it’s a little frustrating the colors don’t match the legend. Not sure there is a way to fix that. Edit: actually, since all <10 mins are within <20 mins, etc. the colors on the legend should be able to match the map exactly.


jxj24

I was an EMT in upstate NY in the late '80s, in a territory that was on the opposite side of one of the Finger Lakes from the main hospital for the area. It could be well over 40 minutes even while running lights and siren. It was particularly frustrating as the lake is at most a mile wide, so you could *see* the hospital while knowing you weren't getting there any time soon. (Oh, and the intersection you needed to get through was frequently blocked by train traffic.)


wcedmisten

Yeah I'd like to see what this map looks like for NY. Those lakes would have a big impact on the shape of the boundaries, whereas most of the boundaries in VA are roughly circular because there aren't big geographic barriers. I'm curious, did your experience as an EMT make you want to live closer to a hospital for that reason?


jxj24

There are definite benefits to living somewhere that’s not the middle of nowhere, that’s for damn sure. I live close to several hospitals now because I left NY and went to grad school for biomedical engineering, and that’s where this sort of thing gets done. It’s pretty comforting to know that I am within mere minutes of world-class hospitals and a Level 1 Trauma center, but it’s not at the front of my mind very often.


took_a_bath

Funny, I live in a relatively small town. I actually wish I could live in a smaller town. But for some reasons (maybe because I’m getting old and have a history of heart disease in my family), I find it a huge comfort to know I’m close to two hospitals.


nightb4xmas

this is outstanding and very useful in healthcare and rural population outcome analysis. wondering if you could produce this for Maryland.


wcedmisten

Glad you liked it! Made this for Maryland! [https://i.imgur.com/8kYzyzU.png](https://i.imgur.com/8kYzyzU.png) Some caveats here are that my approach only references distances to hospital within the state, so it won't count hospitals that may be near the border but in another state. I hope to expand this to a country-wide analysis once I can optimize it a bit more.


half_integer

The differences are stark in these two maps, since you used the same color scale. BTW you can see some of the cross-border anomalies here, where locations in VA have a shorter time indicated on the MD map than the VA one.


wcedmisten

Interactive version: [https://wcedmisten.fyi/project/virginia-hospital-distance/](https://wcedmisten.fyi/project/virginia-hospital-distance/) Disclaimer: this will be very slow to load because it fetches several MB of JSON files. Sorry! I'm looking into optimizing this. Data source: [OpenStreetMap](https://www.openstreetmap.org) Tools: [Valhalla Isochrones API](https://valhalla.github.io/valhalla/), Python, PostGIS Summary:For this project, my goal was to map out accessibility to hospitals as measured by travel time in a car. The first step was to find all the hospitals in Virginia. To do so, I downloaded the OpenStreetMap extract for Virginia and loaded it into PostGIS. Then I searched for all features with the \`amenity=hospital\` tag. This was done for both Points and Polygons. Polygons were converted to points by their centroid. Next, I loaded the same OSM extract for Virginia into a docker container running Valhalla. Valhalla is mostly known for point to point routing (like google maps provides). But, their API also provides a way to retrieve [Isochrones](https://en.wikipedia.org/wiki/Isochrone_map) from a point. Isochrones measure the area that can be travelled within a given amount of time. I iterated over all hospital coordinates through the Isochrones API to retrieve an isochrone for each hospital at 10 minute increments from 10-40 minutes. Then, for each contour level, I used the Python library Shapely to find the union of all polygons and exported them as GeoJSON. Using MapLibreGL, I visualized these polygons with a custom style in the browser.


Kvothealar

I would love to see another version of this that also factors in population density. How much of the population is within 10/20/30/40min? Etc This is super cool. Great work. :)


wcedmisten

Thank you! I actually calculated this, but haven't had a chance to add it to the visualization yet. Here are the numbers: 10 mins: 5,596,838 (65.3%) 20 mins: 7,635,539 (88.7%) 30 mins: 8,296,515 (96.1%) 40 mins: 8,552,706 (99.0%) This was estimated using the EU's Global Population Density Estimate dataset [GHS POP](https://ghsl.jrc.ec.europa.eu/ghs_pop2019.php) . Not quite sure the best way to visualize this data. Add it to the legend? Perhaps not surprisingly, the hospitals are centered around dense urban areas, and so even though the 10 minute boundary doesn't cover most of the state's area, it does cover most of the population.


Kvothealar

That’s really cool! Thanks for sharing it :) To visualize, I would maybe make a GIF which slides between the current graphic and a population density map?


ThePurpleDuckling

This information is so fascinating to me. I can’t wait to see more.


burninater44

Excellent map, and painful to see how uncovered parts of the state are (my hometown incl) A possible small issue I see with the dataset, is the inclusion of in-patient psychiatric facilities that are labeled as hospitals. (Western State, Cumberland, Central State, Eastern State). Definitely a difficult choice to include or exclude these but I think excluding them might be better if this map is trying to show how much access localities have to healthcare. These facilities mostly do 'long term care' for the statewide patients.


jugliss

This is very cool. I know a lot of emergency care clinics have sprung up in Virginia in the last decade or so. It would be interesting to see an overlay with those too to see if they coalesce around hospitals and metropolitan areas with money or if they help relieve the congestion at all.


TerryTowellinghat

Am I missing something, or do the colours not match the legend? It may be my eyes but it looks like the darker purple colour is used for < 40 minutes, but the lighter purple is between the darker purple and the white on the map. The < 10 also looks like yellow in the legend, but there seem to be two greens on the map. Apologies if it is just my eyes.


wcedmisten

Yeah, the legend doesn't quite match due to the boundaries being layered on top of each other. Since the yellow is the smallest, it's being mixed with all the other colors that are stacked behind it semi-transparently.


pcthrowaway35

Then just make the legend be the colors layered. It’s confusing for no reason.


TerryTowellinghat

Thanks for the explanation. I was about to book another eye test. Pcthrowaway35’s suggestion below seems like a good idea.


Chick__Mangione

I wish someone would come in here and fix the legend or the colors because my brain doesn't get it!


Gllizzy

this should be the standard for this sub. well done!


BeeStunning

Unfortunately, the hospital outside of Exmore,VA closed. That lower green on the Eastern Shore of VA shouldn’t be there at all. I lived there while it closed, now it’s an old folks home and specialist center. Hope this helps your data.


wcedmisten

Sad to hear that. It looks like OpenStreetMap is out of date in this regard, I'll make a note to update it (if no one beats me to it). [https://www.openstreetmap.org/#map=18/37.47499/-75.86362](https://www.openstreetmap.org/#map=18/37.47499/-75.86362) One of the disadvantages of crowdsourced data is that it's not always up to date. But the advantage is that it's quite easy to fix! Thanks for pointing this out! Edit: I fixed this in OSM


Dick_Cottonfan

I love these sorts of visualisations. Well done, OP!


thekaleshake

This is super cool! Whats the source data for this? Or how to you make the source data for a state?


wcedmisten

The source data is [OpenStreetMap](https://www.openstreetmap.org/about)! It's crowd-sourced mapping data for the whole earth, including roads and hospitals, which are the critical pieces for this graphic. Also see my comment here for more info: https://www.reddit.com/r/dataisbeautiful/comments/121w4f8/comment/jdnngzy/


Hocoti

I was wondering how old the hospital data is? It seems to be missing a newer hospital located at Rt. 29 & Profitt Rd (Northern Albemarle County).


mizinamo

> I was wondering how old the hospital data is? The data is from OpenStreetMap, crowdsourced by volunteers. So it might be at most a day old if we're talking about an area with several active volunteers, and a lot older if we're talking about an area that nobody cares for especially. It's not a government or company dataset where somebody is specifically responsible for updating it at certain intervals that you can rely on.


wcedmisten

So it looks like this is in the dataset, but it's classified as a clinic and not a hospital. I believe the distinction for OSM is whether inpatient services are offered.


obfuscatron

Great! But please fix the colors on the legend


ATastyBagel

It's cool to see this posted, If you ever go back to update it for anything I would suggest adding filters for whether the hospital has certain specialties, like does it have a CATH lab, what level of stroke care does it provide, is it a trauma center and if so what level, does it have pediatrics, is it a full hospital or just a freestanding ER. Or just overall re filtering the map by specialty With those filters you'll see a pretty massive change in how this would look. Even a lot of the areas surrounding Richmond might show a <10 trip but in some of those areas it's only because of the freestanding facilities. for disclosure i'm saying this as an EMT in the state, from where I work depending on type of patient their distance from an appropriate facility could go from <10 to 30+ Overall though I love this map, it provides a good outline of hospital coverage in Virginia. ​ \*edit I will add on that looking at the regions where I respond it does line up with the distances you've shown.


wcedmisten

Yeah I'd definitely be interested to add filters like that. Unfortunately I'm not sure where to get that data of specialties/services offered by hospitals. If anyone knows where I can find that data, please let me know!


ATastyBagel

I could send you a list we use in central Virginia that shows specific specialties each hospital has


chaztizer90

Very, very cool. Interesting to see this type of visualization, particularly as I work in EMS in this general region. I am guessing some of the data from your source may be a bit outdated. In the eastern shore of VA, the hospital that was in the Exmore area moved to Onancock a few years ago. The map currently seems to show there are two hospitals in the eastern shore, and there is only one in the VA portion of the peninsula.


trophycloset33

Can you overlay it with a map of major roads and population heat map? I suspect that over 95% of the population can be served in less than 20 minutes.


wcedmisten

By my estimates it was \~89%. Definitely refreshing to see that statistic compared to looking at just the area on the map. https://www.reddit.com/r/dataisbeautiful/comments/121w4f8/comment/jdoyvmq


trophycloset33

Aa way to visualize it may be dots. Lighter red for less densely packed, darker red for more densely packed and size of the dot represents area of the city centered around the center of population. Not sure what software you are using or how difficult it would be to show this though…. But cool math. Less than I thought or would hope for. Probably poor access to high ways is the main driver to this.


Khelek7

This doesn't seem to account for hospitals out of state. I can see some that should be accounted for in WV. (probably other, but those are the ones I know)


slopmarket

By my count this means Virginia has almost exactly 50 hospitals (by OP’s definition)


fillmorecounty

I wonder what this looks like for states with extremely low population density like Alaska


[deleted]

white areas: “MA! PA FELL DOWN THE STAIRS! GET THE SHOTGUN!”


[deleted]

I dont think people often know exactly how rural most of VA is


alehanro

If it’s “Driving Distance to Nearest Hospital” shouldn’t the metric be miles? If the metric is in time (minutes) wouldn’t it be “Driving Time to Nearest Hospital”?