Wednesday, 28 July 2021

Unlocking Open Data from a legacy site

 In the process of looking at land cover per previous post, I found this fabulous dataset from Natural England - their story map encouraged me to enter EsriUK's latest competition - their Esri dataset is accompanied by ample documentation under data.gov. To save you reverting to ArcMap, let's use the provided layer files and a file geodatabase in three simple steps to map your own region on ArcGIS Pro. 

Note: file geodatabase and shape files can be used on other platforms, and referring to your region gives the metadata to style it. You will see that data and styles are straightforward. Can you spot below the clue to an original map package, and may it be worth asking Natural England for it?

File Geodatabase

First thing you notice is that the number of features pales in comparison to the number of layers.

That's because the tables themselves contain attributes classified by grouping in by feature:

click to enlarge

Layer files

The simplest therefore is to grab all the layer files,  post them on the map and group them by the HexGrid features. The guide pointed out above explains the hex binning used to derive these maps.

Here is the original ArcMap grouping for reference, again no need to use it here.

click to enlarge

You will get errors as the source doesn't match, but ArcGIS Pro no longer fixes broken links for all features as in ArcMap. Either you can choose which layers relate to your project, or brew yourself a cuppa and traverse all of them, while you discover what they mean in the metadata folder... 

Note: if you're handy a python or geoprocessing, you may automate that. I haven't found a way as GP appears to be geared towards portal/desktop not desktop/desktop tuning, but stay tuned! (apologies for the bad pun)


click to enlarge

Clip to area

ArcMap had a Clip&ship GP routine, which is geared to portal in ArcGIS Pro, so let's simply clip the area of interest. The trick on that many layers is to batch the process by right-clicking on the tool:

click ot enlarge


So there you go, this is what it looks like shared on ArcGIS Online, using the intro feature to help read the maps:





Friday, 16 July 2021

Land cover to study East Anglia peatlands evolution

Community Engagement 12345678910111213, 1415161718 & 19

[ Update: added Living Atlas, ESA & USGS land cover and Natural England peat lands ]

Having concluded a comprehensive synopsis on risk of flooding and sea level rise, an opportunity arose to look at land cover classification with the data below and two peat land experts who will help with this.

In East Anglia, peatlands are net carbon emitters having been drained, and work is afoot by local rural conservation efforts such Fens Biosphere, Great Fen and Future Fens, to reflood & make them carbon sinks again.  This helps conservation efforts and fights climate change literally at the grassroots level.

 See full screen

Adding latest Esri 2020 Land Cover (LC) base in prep for training and classification to study East Anglia peatlands evolution. Raw LC data and Living Atlas LC using Dan Pisut and John Nelson styling. This will be augmented with USGS Global GIS (2000) and Esri 2050 LC projection to depict evolution. 

Stay tuned!

Sunday, 11 July 2021

What is your 'ikigai'?

 Ikigai (生き甲斐, "a reason for being") is a Japanese concept referring to having a direction or purpose in life, providing a sense of fulfillment and towards which they the person may take actions, giving them satisfaction and a sense of meaning. en.wikipedia.org

Monday, 21 June 2021

"With a little help from my friends"

Part of our mandate at cottenham.info is to raise awareness around climate change issues in East Anglia. A key part is to quantify risks around flooding from land during increasingly variable weather, as well as to predict what sea level rise would look like over time from melting polar ice caps. That combines respectively excellent ground work by DEFRA - see their Future Fens twitter feed - and modelling against topography by Ordnance Survey and DEFRA. And timing of sea level rises is an emotional issue: to balance the reality of the risk with questions around time scales (see comment), will help raise awareness without unduly raising alarm.

Wednesday, 2 June 2021

Cambridgeshire COVID Info Portal 1¼ years later

Almost 1½ years from the onset of COVID, here a video of the info portal created using ESRI dashboard, inspired from the Johns Hopkins University pioneering hit - same tech with more data and expertise - our own info portal is a handy  bit.ly/CamCOVIDinfo.

Sunday, 30 May 2021

Geo-reference an image

 This update to Challenger Expedition DIY Web Map is called an "inchworm" map, as monthly points appear to worm around the globe, with an inchworm's hump at times. This caught @miniboats eye on the approach to the expedition's 150th anniversary (see also a fascination Natural History Museum post here). 

Monday, 24 May 2021

East Anglia Flood Defences Final

Community Engagement 12345678910111213, 14151617 & 18

[ Update: see post #19 on an opportunity to use land cover information to study peat lands

This extends the previous flood defences update into a 3D interactive map. It also explains the DEFRA flood defences data update, in order to map the infrastructure complete with various sea level rise elevations. [Story map full-page here.]

Sunday, 16 May 2021

East Anglia Flood Defences Update

Community Engagement 12345678910111213, 1415, 16 & 17

[ Update: the next blogpost extends this into a 3d interactive map wrapping up this 2 years study ]

This closes the trio of updates on sea level rise timelines and infrastructure based on newly available climate change data, since this project started two years ago. 

Environment Agency's DEFRA not only manages a comprehensive Risk of Flooding for River and from Sea via ground observations and mapping, but it also manages all the infrastructure related to flood risks from the same. 

Let's extend our ongoing mapping effort here to include AIMS Spatial Flood Defences (inc. standardised attributes):

Wednesday, 5 May 2021

East Anglia sea level rise infrastructure update

Community Engagement 12345678910111213, 1415 & 16

[ Update 3: the next installment includes Environment Agency's flood defence data

Update 2: here is an update via Enviro. Agency's outreach twitter @FutureFens

Update 1: here is a story map augmenting the last two posts with live maps... enjoy! ]

Following on the previous timelines update focusing on Cambridgeshire & Peterborough Combine Authority, this is an East Anglia-wide update based on Environment Agency (EA) Survey,  Office for National Statistics (ONS) Geoportal and Ordnance Survey (OS) Open Zoomstack data. 

Monday, 26 April 2021

East Anglia sea level rise timelines update

Community Engagement 12345678910111213, 14 & 15

[ Update 3: the next installment updates the infrastructure aspects of this for East Anglia

Update 2: Cambridge could be completely underwater by 2100, warns Emoov report

Update 1: added slide deck at bottom, to summarize the last two years of work on this ]

After a hiatus focusing on Coronavirus and story maps on East Anglia and other mapping topics, let's revisit that moving target of sea level rise timing.