Cottenham Open Status Quo

Community Engagement 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 & 13

[ Update: this spreadsheet is updated at year end here ]

Terry Jackson and I started cottenham.info almost 18 mo. ago, so perhaps it's time to look at what we've prepared so far, in order to frame the Manifesto in our next post.

Coronavirus update - Part VI

[Update: on 28 July both cases and deaths appear to be flattening at last, stay tuned!

Update: NHSx cases pass the ¼M mark with uptick and without "flattening the curve"  ]

The previous post and its updates showed the progress of NHSx and ONS daily and cumulative numbers of COVID19 cases and deaths, ending with some internal consistencies in NHSx reporting. Those appear to have been remedied now.

Coronavirus update - Part V

Update 4: another week another uptick, more on health data trials&tribulations next
Update 3: the uptick smoothed... but "flatten the curve" certainly hasn't happened yet!
Update 2: and right on cue: UK coronavirus cases no longer falling, ONS figures show
Update 1: an uptick in ONS deaths reported a week behind matches last week's uptick in NHSx cases... flattening the curve? Not!  ]

Previously we reported on extending COVID-19 datasets down to Ward (MSOA) from County (UTLA) level. To recap, NHSx post cases and deaths from hospitals in a single dashboard, whereas ONS post death data across many systems with geo-socio-economics. And while we report on the highest geographic granularity publicly available, at the country level weekly reports are the common denominator across agencies. ONS posts data weekly 2-4 weeks behind depending on scale as discussed before, whereas NHSx posts daily 1-2 days behind also discussed before. Having calculated weekly data from NHSx to match ONS time stamps. they're graphed here (click images to enlarge).

Coronavirus update - Part IV

[Update: see next a wrap-up of COVID-19 cases & deaths data across NHSx & ONS]

The last update added ONS' COVID-related death data, which augment the cases and deaths posted by NHSx at the Local Authority level akin to Counties. The post ended with: Data will be added as found and/or made available: the goal is Parish-level data to mash up with our climate change maps. We already added in the second last update a map from Cambridgeshire Live, and we now see in Cambridgeshire Independent ONS "death data by ward and by villages".

Digital terrain models help create a picture - Part II

[ Update: see new arcgis.com interface for another view of this here & under Update 5 here ]

The previous post showed how digital terrain, surface (add buildings & vegetation) and elevation (detail topography) models highlight geomorphology (land features) and infrastructure (roads, canals etc.). That was in the Cambridgeshire area of the southern Fenlands of East Anglia, as a complement to sea level rise models from coastal inundation, as well as flood risk maps from rivers and from sea.

Digital terrain models help create a picture

[ Update: next post discusses same in the East Anglia coastal area of the Fenlands ]

The previous blog showed how to effectively portray coastal inundation, as it progresses inland from the encroachment of sea level rise. These were base on 30 m. resolution Digital Elevation Models (DEM) from OS OpenData as explained previously here.

Low tech / high tech map updates, Part II

[ Update: the next blog details and updates this via a story map and new data ]

Part I showed how high contrast map symbology of Sea Level Rise can be transferred to a paper map to take around events. When asked if I could scan and reprint that paper map, I thought: why print a hand-transfer, why not print the digital original? Better still: why not try and enhance that digital map to really give an impression of sea level rise gradually invading the land?

Coronavirus daily update - Part III

[ Update: see further updates at higher granularity geography in a later post
Also ONS numbers updated weekly maintain the difference with NHSx below]

Following on Part II adding local data for East of England, let's add weekly deaths (two weeks out of date) from ONS here and here, including counts outside of daily hospital deaths (two days out of date) from NHSx. Here is a graph of the raw data collected from both sources, since end-January onset of the pandemic in the UK.

Coronavirus time-enabled maps - Part II

Following on the initial post, this is a presentation live-streamed on YouTube below - thanks Daniel P. Hoffman for organising How to do Map Stuff yesterday! - liner notes are below that, ten-slide intro and step-by-step after that. Note that while data are open and the process can be done on any platform, the coxcomb symbology (slide 21) is ArcGIS Pro, tho someone may redo it elsewhere?

Coronavirus daily update - Part II

[ Update: see a follow-up post on how ONS data augment the NHSx death statistics ]

Daily updates brought you COVID-19 data for England in a dashboard that posted according to your desktop or mobile device (tablet coming soon). These statistics from NHSx show, however, only hospital data. It's been noted in the press that cases and especially deaths outside hospitals are not captured. ONS captures death data but not in a single dashboard like NHSx and two weeks behind.