Recent comments in /f/dataisbeautiful

mildlypresent t1_jdo9xpt wrote

Currently snow pack in the Colorado River Basin is about 1.5x the 30 yr average, but that average is pulled down because the last 23 years have been in an epically historic drought.

It will be one of the better years in the last 30, but it's probably not going to be much more than what we use in any given year.

In 1921 we divied up the river assuming an average flow of 16.5 million acre feet. We've since calculated the average from the last 2000 years as about 14.5. The last 20 have averaged about 12.5.

Of that 16.5, california was awarded 4.4. California's plan to reconcile the over allocation is basically to throw up the middle finger and let the courts sort it out. The other six states came up with a plan that asks California to take a cut, but a much smaller cut than any other state.

Worst case scenario California has to give up about 1 million acre feet. Mostly likely scenario California looses 600k-800k (14%-18%ish).

Keep in minde most of that water goes to agriculture. Cites don't use that much.

To make up for the lost water; about 150k-300k could be saved from improving evaporation and leak issues in the canels system. Another few hundred by more efficient agricultural use. And another 100-150 from desalination.

Bottom line:

Don't get too worried about it. Media has a lot of doom and gloom. We deserve some shame for ignoring the issue we've known about for 50 years. In the end you'll just have to pay more for water and deal with politicians grand standing about lawns and pools.

1

mildlypresent t1_jdo7ysw wrote

Northern Cal doesn't use any Colorado Basin water.

Southern Cal gets its water from Owens Valley via the Los Angeles Aqueduct and the Colorado River via the Colorado River Aqueduct and the All-American Canal.

California withdrawals about 4.4 million acre feet (1.4 trillion gallons) from the Colorado River Annually.

1

wcedmisten OP t1_jdo2pc2 wrote

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?

11

Naturallyoutoftime t1_jdo06b5 wrote

You think that will forever be available or that there won’t be a possibility of a breakdown in the system or that the operating system will be compatible decades into the future or that anyone will know what is there or how to find it if you died unexpectedly? You have a lot of faith in technology. I am afraid I don’t.

1

jxj24 t1_jdnvqli wrote

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.)

27

jugliss t1_jdnuzio wrote

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.

8

wcedmisten OP t1_jdnngzy wrote

Interactive version: 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

Tools: Valhalla Isochrones API, 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 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.

19

cozy_ross t1_jdneec9 wrote

I don’t have the exact numbers but as a Ukrainian I can say that we have a decent number of physicians, or so I think. I haven’t ever experienced a problem of waiting in the lost for more than a few days, usually you just wait for a 2-5 hours in a live queue. And from what I heard it looks like there’s a huge problem with waiting time in other EU countries (Portugal, Poland, Germany), because people can wait for their consultation with a doctor for months there.

1

DoeCommaJohn t1_jdmyjg2 wrote

It’s not common in graphs, but in UI most elements don’t go to the edge of the screen (just look at reddit). Also, because this is a moving average, you wouldn’t have any data for the first 31 videos, so that could explain this.

The 32 means that the average doesn’t take every video, it only takes the 32 previous videos

2