Wednesday 28 July 2021

Unlocking Open Data from a legacy site

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

Note: file geodatabase and shape files can be used on other platforms: the GIS User Guide from here gives not only the metadata to style it, but also the methodology to recreate it with other datasets! You will see that data and styles are quite straightforward. Can you spot below the clue to an original map package, which it may be worth asking Natural England for?


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 hexagon binning used to derive these maps.

Here is the original ArcMap grouping for reference, again no need to use the old app:

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 - mountains or coasts were skipped here - 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 at 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, but stay tuned! And hint: the package mentioned above shows here under layer properties.

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 to enlarge

This is what it looks like shared on ArcGIS Online, the intro feature helps read the map:

View full size

Note the interactive legend that allows you to query each item, say, the Outliers (>90 percentile in wine red and No Data in white). Also start with the documentation re: hexagon binning, with the County guide the easiest place to start: here is their GIS guide but do consult the originals here.



In the process of updating the map in the previous post, the Peat Status GHG and C Storage feature service use showed an empty total_c (total carbon) field! Fortunately the metadata kindly provided by Natural England showed how to calculate it. Check here the metadata extract incl. the source to see how this correction is applied in ArcGIS:

click to enlarge

Natural England have been informed, and this will be included in the land cover map update to follow.


No comments:

Post a Comment

Please send me a copy of your prospectus to