With this add in it is possible to create map templates from GIS files in KML format, and create choropleths with them.

Providing you have access to KML format map boundary files, it is possible to create your own quick and easy choropleth maps in Excel. The KML format files can be converted from 'shape' files. Many shape files are available to download for free from the web, including from Ordnance Survey and the London Datastore. Standard mapping packages such as QGIS (free to download) and ArcGIS can convert the files to KML format.

A sample of a KML file (London wards) can be downloaded from this page, so that users can easily test the tool out.

Macros must be enabled for the tool to function.

When creating the map using the Excel tool, the 'unique ID' should normally be the area code, the 'Name' should be the area name and then if required and there is additional data in the KML file, further 'data' fields can be added. These columns will appear below and to the right of the map. If not, data can be added later on next to the codes and names.

In the add-in version of the tool the final control, 'Scale (% window)' should not normally be changed. With the default value 0.5, the height of the map is set to be half the total size of the user's Excel window.

To run a choropleth, select the menu option 'Run Choropleth' to get this form.

To specify the colour ramp for the choropleth, the user needs to enter the number of boxes into which the range is to be divided, and the colours for the high and low ends of the range, which is done by selecting coloured option boxes as appropriate. If wished, hit the 'Swap' button to change which colours are for the different ends of the range. Then hit the 'Choropleth' button.

The default options for the colours of the ends of the choropleth colour range are saved in the add in, but different values can be selected but setting up a column range of up to twelve cells, anywhere in Excel, filled with the option colours wanted. Then use the 'Colour range' control to select this range, and hit apply, having selected high or low values as wished. The button 'Copy' sets up a sheet 'ColourRamp' in the active workbook with the default colours, which can just be extended or deleted with just a few cells, so saving the user time.

The add-in was developed entirely within the Excel VBA IDE by Tim Lund. He is kindly distributing the tool for free on the Datastore but suggests that users who find the tool useful make a donation to the Shelter charity. It is not intended to keep the actively maintained, but if any users or developers would like to add more features, email the author.

Acknowledgments

Calculation of Excel freeform shapes from latitudes and longitudes is done using calculations from the Ordnance Survey.

High resolution scanned images of Ordnance Survey maps from 1932 and 1933 in .tif file format, and corresponding .pdf format versions of these.These show parts of Salford, including the former docks, and the western side of Manchester city centre. A0 sized poster prints of these maps were used as part of the Undiscovered Salford display in the Community Science Showcase at Manchester Science Festival's GameLab event. The event took place on 20/21 October 2018 at the University of Salford's MediaCityUK campus.Original files kindly provided by the Salford Local History Library from their archives held at the Salford Art Gallery & Museum.OS Copyright expires 50 years from the date of publication, hence these maps are copyright free.

Introduction The dataset provides detailed information about UK Power Networks' Grid and Primary Sites. It includes key characteristics such as:

Spatial coordinates of each site Year commissioned Asset counts against each site Power transformer count Local authority information Winter and summer demand Transformer ratings

This data is useful for understanding the infrastructure and capacity of the electricity network across its regions.

Methodological Approach

Source: Various internal data domains - geospatial, asset, long term development statement; as well as openly available data from the Ordnance Survey and Office of National Statistics Manipulation: Various data characteristics were combined together using Functional Locations (FLOCs)

Quality Control Statement The data is provided "as is".

Assurance Statement The Open Data team has checked the data against source to ensure data accuracy and consistency. The data domain owners have checked their respective data aspects.

Other Contains data from Office for National Statistics licensed under the Open Government Licence v.3.0. Local Authority District (2022) to Grouped Local Authority District (2022) Lookup for EW - data.gov.uk

Contains Ordnance Survey data Crown copyright and database right [2019-]. Free OS OpenData Map Downloads | Free Vector & Raster Map Data | OS Data Hub

Download dataset information: Metadata (JSON)

Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: https://ukpowernetworks.opendatasoft.com/pages/glossary/

From Parliamentary constituencies to council wards, Boundary-Line™ maps every administrative boundary in detail for you. And what's more, it's completely free to download and use.

Bring statistics to life For academics or policy-makers, Boundary-Line brings the statistics in your reports to life. It lets you show differences between regions or councils using easy-to-read shaded maps.

A robust framework Monitoring outcomes by area is key for public bodies. Boundary-Line gives you a robust analytical framework to ensure the right communities get the right resources.

Individual properties When you're consulting on updating boundaries to take account of population change, Boundary-Line lets you show on a map where the line's being drawn, right down to the level of individual properties.

This data was collected by the Geological Survey Ireland, the Department of Culture, Heritage and the Gaeltacht, the Discovery Programme, the Heritage Council, Transport Infrastructure Ireland, New York University, the Office of Public Works and Westmeath County Council. All data formats are provided as GeoTIFF rasters but are at different resolutions. Data resolution varies depending on survey requirements. Resolutions for each organisation are as follows: GSI – 1m DCHG/DP/HC - 0.13m, 0.14m, 1m NY – 1m TII – 2m OPW – 2m WMCC - 0.25m Both a DTM and DSM are raster data. Raster data is another name for gridded data. Raster data stores information in pixels (grid cells). Each raster grid makes up a matrix of cells (or pixels) organised into rows and columns. The grid cell size varies depending on the organisation that collected it. GSI data has a grid cell size of 1 meter by 1 meter. This means that each cell (pixel) represents an area of 1 meter squared.

A Sites and Monuments Record (SMR) was issued for all counties in the State between 1984 and 1992. The SMR is a manual containing a numbered list of certain and possible monuments accompanied by 6-inch Ordnance Survey maps (at a reduced scale). The SMR formed the basis for issuing the Record of Monuments and Places (RMP) - the statutory list of recorded monuments established under Section 12 of the National Monuments (Amendment) Act 1994. The RMP was issued for each county between 1995 and 1998 in a similar format to the existing SMR. The RMP differs from the earlier lists in that, as defined in the Act, only monuments with known locations or places where there are believed to be monuments are included. The large Archaeological Survey of Ireland archive and supporting database are managed by the National Monuments Service and the records are continually updated and supplemented as additional monuments are discovered. On the Historic Environment viewer an area around each monument has been shaded, the scale of which varies with the class of monument. This area does not define the extent of the monument, nor does it define a buffer area beyond which ground disturbance should not take place – it merely identifies an area of land within which it is expected that the monument will be located. It is not a constraint area for screening – such must be set by the relevant authority who requires screening for their own purposes. This data has been released for download as Open Data under the DPER Open Data Strategy and is licensed for re-use under the Creative Commons Attribution 4.0 International licence. http://creativecommons.org/licenses/by/4.0 Please note that the centre point of each record is not indicative of the geographic extent of the monument. The existing point centroids were digitised relative to the OSI 6-inch mapping and the move from this older IG-referenced series to the larger-scale ITM mapping will necessitate revisions. The accuracy of the derived ITM co-ordinates is limited to the OS 6-inch scale and errors may ensue should the user apply the co-ordinates to larger scale maps. Records that do not refer to 'monuments' are designated 'Redundant record' and are retained in the archive as they may relate to features that were once considered to be monuments but which on investigation proved otherwise. Redundant records may also refer to duplicate records or errors in the data structure of the Archaeological Survey of Ireland. This dataset is provided for re-use in a number of ways and the technical options are outlined below. For a live and current view of the data, please use the web services or the data extract tool in the Historic Environment Viewer. The National Monuments Service also provide an Open Data snapshot of its national dataset in CSV as a bulk data download. Users should consult the National Monument Service website https://www.archaeology.ie/ for further information and guidance on the National Monument Act(s) and the legal significance of this dataset. Open Data Bulk Data Downloads (version date: 23/08/2023) The Sites and Monuments Record (SMR) is provided as a national download in Comma Separated Value (CSV) format. This format can be easily integrated into a number of software clients for re-use and analysis. The Longitude and Latitude coordinates are also provided to aid its re-use in web mapping systems, however, the ITM easting/northings coordinates should be quoted for official purposes. ERSI Shapefiles of the SMR points and SMRZone polygons are also available The SMRZones represent an area around each monument, the scale of which varies with the class of monument. This area does not define the extent of the monument, nor does it define a buffer area beyond which ground disturbance should not take place – it merely identifies an area of land within which it is expected that the monument will be located. It is not a constraint area for screening – such must be set by the relevant authority who requires screening for their own purposes. GIS Web Service APIs (live views): For users with access to GIS software please note that the Archaeological Survey of Ireland data is also available spatial data web services. By accessing and consuming the web service users are deemed to have accepted the Terms and Conditions. The web services are available at the URL endpoints advertised below: SMR; https://services-eu1.arcgis.com/HyjXgkV6KGMSF3jt/arcgis/rest/services/SMROpenData/FeatureServer SMRZone; https://services-eu1.arcgis.com/HyjXgkV6KGMSF3jt/arcgis/rest/services/SMRZoneOpenData/FeatureServer Historic Environment Viewer - Query Tool The "Query" tool can alternatively be used to selectively filter and download the data represented in the Historic Environment Viewer. The instructions for using this tool in the Historic Environment Viewer are detailed in the associated Help file: https://www.archaeology.ie/sites/default/files/media/pdf/HEV_UserGuide_v01.pdf

Living England is a multi-year project which delivers a broad habitat map for the whole of England, created using satellite imagery, field data records and other geospatial data in a machine learning framework. The Living England habitat map shows the extent and distribution of broad habitats across England aligned to the UKBAP classification, providing a valuable insight into our natural capital assets and helping to inform land management decisions. Living England is a project within Natural England, funded by and supports the Defra Natural Capital and Ecosystem Assessment (NCEA) Programme and Environmental Land Management (ELM) Schemes to provide an openly available national map of broad habitats across England.This dataset includes very complex geometry with a large number of features so it has a default viewing distance set to 1:80,000 (City in the map viewer).Process Description:A number of data layers are used to develop a ground dataset of habitat reference data, which are then used to inform a machine-learning model and spatial analyses to generate a map of the likely locations and distributions of habitats across England. The main source data layers underpinning the spatial framework and models are Sentinel-2 and Sentinel-1 satellite data from the ESA Copernicus programme, Lidar from the EA's national Lidar Programme and collected data through the project's national survey programme. Additional datasets informing the approach as detailed below and outlined in the accompanying technical user guide.Datasets used:OS MasterMap® Topography Layer; Geology aka BGS Bedrock Mapping 1:50k; Long Term Monitoring Network; Uplands Inventory; Coastal Dune Geomatics Mapping Ground Truthing; Crop Map of England (RPA) CROME; Lowland Heathland Survey; National Grassland Survey; National Plant Monitoring Scheme; NE field Unit Surveys; Northumberland Border Mires Survey; Sentinel-2 multispectral imagery; Sentinel-1 backscatter imagery; Sentinel-1 single look complex (SLC) imagery; National forest inventory (NFI); Cranfield NATMAP; Agri-Environment HLS Monitoring; Living England desktop validation; Priority Habitat Inventory; Space2 Eye Lens: Ainsdale NNR, State of the Bog Bowland Survey, State of the Bog Dark Peak Condition Survey, State of the Bog Manchester Metropolitan University (MMU) Mountain Hare Habitat Survey Dark Peak, State of the Bog; Moors for the Future Dark Peak Survey; West Pennines Designation NVC Survey; Wetland Annex 1 inventory; Soils-BGS Soil Parent Material; Met Office HadUK gridded climate product; Saltmarsh Extent and Zonation; EA LiDAR DSM & DTM; New Forest Mires Wetland Survey; New Forest Mires Wetland Survey; West Cumbria Mires Survey; England Peat Map Vegetation Surveys; NE protected sites monitoring; ERA5; OS Open Built-up Areas; OS Boundaries dataset; EA IHM (Integrated height model) DTM; OS VectorMap District; EA Coastal Flood Boundary: Extreme Sea Levels; AIMS Spatial Sea Defences; LIDAR Sand Dunes 2022; EA Coastal saltmarsh species surveys; Aerial Photography GB (APGB); NASA SRT (Shuttle Radar Topography Mission) M30; Provisional Agricultural Land Classification; Renewable Energy Planning Database (REPD); Open Street Map 2024.Attribute descriptions: Column Heading Full Name Format Description

SegID SegID Character (100) Unique Living England segment identifier. Format is LEZZZZ_BGZXX_YYYYYYY where Z = release year (2223 for this version), X = BGZ and Y = Unique 7-digit number

Prmry_H Primary_Habitat Date Primary Living England Habitat

Relblty Reliability
Character (12) Reliability Metric Score

Mdl_Hbs Model_Habs Interger List of likely habitats output by the Random Forest model.

Mdl_Prb Model_Probs Double (6,2) List of probabilities for habitats listed in ‘Model_Habs’, calculated by the Random Forest model.

Mixd_Sg Mixed_Segment Character (50) Indication of the likelihood a segment contains a mixture of dominant habitats. Either Unlikely or Probable.

Source Source

Description of how the habitat classification was derived. Options are: Random Forest; Vector OSMM Urban; Vector Classified OS Water; Vector EA saltmarsh; LE saltmarsh & QA; Vector RPA Crome, ALC grades 1-4; Vector LE Bare Ground Analysis; LE QA Adjusted

SorcRsn Source_Reason

Reasoning for habitat class adjustment if ‘Source’ equals ‘LE QA Adjusted’

Shap_Ar Shape_Area

Segment area (m2) Full metadata can be viewed on data.gov.uk.

A more sophisticated classification was developed for woodlands in Scotland due to the nature of the available historical sources. IMPORTANT. For Scottish woods, the category Ancient comprises woods recorded as being of semi-natural origin on EITHER the 1750 Roy maps OR the 1st Edition Ordnance Survey maps of 1860. This is due a) to the likelihood of the latter having been omitted from the Roy maps and b) to render the Scottish classification compatible with that for England and Wales.More information at the NatureScot websiteComplete metadata

A Site of Special Scientific Interest (SSSI) is the land notified as an SSSI under the Wildlife and Countryside Act (1981), as amended. Sites notified under the 1949 Act only are not included in the Data set. SSSI are the finest sites for wildlife and natural features in England, supporting many characteristic, rare and endangered species, habitats and natural features. The data do not include "proposed" sites. Boundaries are generally mapped against Ordnance Survey MasterMap.

This file contains the digital vector boundaries for Counties and Unitary Authorities in the United Kingdom, as at December 2019. The boundaries available are: (BUC) Ultra Generalised (500m) - clipped to the coastline (Mean High Water mark). Contains both Ordnance Survey and ONS Intellectual Property Rights. Download File SizesUltra Generalised (500m) - clipped to the coastline (200 KB)Units for the following fields:St_length = metresSt_area = metres2REST URL of ArcGIS for INSPIRE View Service https://ons-inspire.esriuk.com/arcgis/rest/services/Administrative_Boundaries/Counties_and_Unitary_Authorities_December_2019_Boundaries_UK_BUC2/MapServer/exts/InspireView REST URL of ArcGIS for INSPIRE Feature Download Service https://ons-inspire.esriuk.com/arcgis/rest/services/Administrative_Boundaries/Counties_and_Unitary_Authorities_December_2019_Boundaries_UK_BUC2/MapServer/exts/InspireFeatureDownload REST URL of Feature Access Service https://ons-inspire.esriuk.com/arcgis/rest/services/Administrative_Boundaries/Counties_and_Unitary_Authorities_December_2019_Boundaries_UK_BUC2/FeatureServer