A free mapping tool that allows you to create a thematic map of London without any specialist GIS skills or software - all you need is Microsoft Excel. Templates are available for London’s Boroughs and Wards. Full instructions are contained within the spreadsheets. Macros The tool works in any version of Excel. But the user MUST ENABLE MACROS, for the features to work. There a some restrictions on functionality in the ward maps in Excel 2003 and earlier - full instructions are included in the spreadsheet. To check whether the macros are enabled in Excel 2003 click Tools, Macro, Security and change the setting to Medium. Then you have to re-start Excel for the changes to take effect. When Excel starts up a prompt will ask if you want to enable macros - click yes. In Excel 2007 and later, it should be set by default to the correct setting, but if it has been changed, click on the Windows Office button in the top corner, then Excel options (at the bottom), Trust Centre, Trust Centre Settings, and make sure it is set to 'Disable all macros with notification'. Then when you open the spreadsheet, a prompt labelled 'Options' will appear at the top for you to enable macros. To create your own thematic borough maps in Excel using the ward map tool as a starting point, read these instructions. You will need to be a confident Excel user, and have access to your boundaries as a picture file from elsewhere. The mapping tools created here are all fully open access with no passwords. Copyright notice: If you publish these maps, a copyright notice must be included within the report saying: "Contains Ordnance Survey data © Crown copyright and database rights." NOTE: Excel 2003 users must 'ungroup' the map for it to work.

This is an excel mapping tool that was built based on Cuba administrative boundaries (admin2) - extracted from the GADM database (www.gadm.org), version 2.8, November 2015. Available on HDX: https://data.humdata.org/dataset/cuba-administrative-boundaries-levels-0-and-1-from-gadm). The population dataset is a sample data. The tool is built to help people to quickly map their datasets.

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.

A free mapping tool that allows you to create a thematic map of London without any specialist GIS skills or software - all you need is Microsoft Excel. Templates are available for London’s Boroughs and Wards. Full instructions are contained within the spreadsheets.

Macros

The tool works in any version of Excel. But the user MUST ENABLE MACROS, for the features to work. There a some restrictions on functionality in the ward maps in Excel 2003 and earlier - full instructions are included in the spreadsheet.

To check whether the macros are enabled in Excel 2003 click Tools, Macro, Security and change the setting to Medium. Then you have to re-start Excel for the changes to take effect. When Excel starts up a prompt will ask if you want to enable macros - click yes.

In Excel 2007 and later, it should be set by default to the correct setting, but if it has been changed, click on the Windows Office button in the top corner, then Excel options (at the bottom), Trust Centre, Trust Centre Settings, and make sure it is set to 'Disable all macros with notification'. Then when you open the spreadsheet, a prompt labelled 'Options' will appear at the top for you to enable macros.

To create your own thematic borough maps in Excel using the ward map tool as a starting point, read these instructions. You will need to be a confident Excel user, and have access to your boundaries as a picture file from elsewhere. The mapping tools created here are all fully open access with no passwords.

Copyright notice: If you publish these maps, a copyright notice must be included within the report saying: "Contains Ordnance Survey data © Crown copyright and database rights."

NOTE: Excel 2003 users must 'ungroup' the map for it to work.

London Heat Map The London Heatmap is a map-based web application you can use to find and appraise opportunities for decentralised energy (DE) projects in London. The map covers the whole of Greater London, and provides very local information to help you identify and develop DE opportunities, including data such as: Locations of existing and proposed district heating networks Locations of potential heat supply sites The London Heat Map is used by a wide variety of people in numerous ways: London Boroughs can use the new map to help develop their energy master plans. Property developers can use the map to help them meet the decentralised energy policies in the London Plan. Energy consultants can use the map to gather initial data to inform feasibility studies. More information is available here, and an interactive map is available here. The Decentralised Energy Master planning programme (DEMaP) The Decentralised Energy Master planning programme (DEMaP), was completed in October 2010. It included a heat mapping support package for the London boroughs to enable them to carry out high resolution heat mapping for their area. To date, heat maps have been produced for 29 London boroughs with the remaining four boroughs carrying out their own data collection. All of the data collected through this process is provided below. Carbon Calculator Tool Arup have produced a Carbon Calculator Tool to assist projects in their early estimation of the carbon dioxide (CO2) savings which could be realised by a district heating scheme with different sources of heating. The calculator's estimates include the impact of a decarbonising the electrical grid over time, based on projections by the Department for Energy and Climate Change, as well as the Government's Standard Assessment Procedure (SAP). The Excel-based tool can be downloaded below. Borough Heat Maps Data and Reports (2012) In March 2012, all London boroughs did a heat mapping exercise. The data from this includes the following and can be downloaded below: Heat Load for all boroughs Heat Supplies for all boroughs Heat Network LDD 2010 database Complete GIS London Heat Map Data The heat maps contain real heat consumption data for priority buildings such as hospitals, leisure centres and local authority buildings. As part of this work, each of the boroughs developed implementation plans to help them take the DE opportunities identified to the next stages. The implementation plans include barriers and opportunities, actions to be taken by the council, key dates, personnel responsible. These can be downloaded below. London Heat Network Manual London Heat Network Manual II

This is the dataset used for the Ebrahimi et al. (2018) article "Experimental study on scour at a sharp-nose bridge pier with debris blockage" published in the Journal of Hydraulic Engineering.

This dataset was scrapped from pharmacyregulation.org, it contains an excel file with the names and addresses of all the regestered pharmacies in the UK. The challenge for this data set will be to use the addresses to create a density map of the pharmacy locations in the UK.

This is the ONS Postcode Directory (ONSPD) for the United Kingdom as at February 2023 in Comma Separated Variable (CSV) and ASCII text (TXT) formats. This file contains the multi CSVs so that postcode areas can be opened in MS Excel. To download the zip file click the Download button. The ONSPD relates both current and terminated postcodes in the United Kingdom to a range of current statutory administrative, electoral, health and other area geographies. It also links postcodes to pre-2002 health areas, 1991 Census enumeration districts for England and Wales, 2001 Census Output Areas (OA) and Super Output Areas (SOA) for England and Wales, 2001 Census OAs and SOAs for Northern Ireland and 2001 Census OAs and Data Zones (DZ) for Scotland. It now contains 2021 Census OAs and SOAs for England and Wales. It helps support the production of area based statistics from postcoded data. The ONSPD is produced by ONS Geography, who provide geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations. The ONSPD is issued quarterly. (File size - 234 MB)NOTE: The 2022 ONSPDs included an incorrect update of the ITL field with two LA changes in Northamptonshire. This error has been corrected from the February 2023 ONSPD.NOTE: There was an issue with the originally published file where some change orders yet to be included in OS Boundary-LineÔ (including The Cumbria (Structural Changes) Order 2022, The North Yorkshire (Structural Changes) Order 2022 and The Somerset (Structural Changes) Order 2022) were mistakenly implemented for terminated postcodes. Version 2 corrects this, so that ward codes E05014171–E05014393 are not yet included. Please note that this product contains Royal Mail, Gridlink, LPS (Northern Ireland), Ordnance Survey and ONS Intellectual Property Rights.

The results for each candidate standing in all 73 seats in Greater London are available as an Excel file. The data is also presented as an interactive map below.

The files includes election results from the last three parliamentary constituency elections between 2005 to 2015.

The results presented here include turnout, majority and percentage of vote for each candidate that stood in the election that took place on 7 May 2015.

Read the blog, The 2015 election – the numbers behind the result, which analyses some of the results.

https://londondatastore-upload.s3.amazonaws.com/images/seats-chart-2015.png" alt=""> https://londondatastore-upload.s3.amazonaws.com/images/share-chart-2015.png" alt="">

London Maps

The London data is presented in this interactive Instant Atlas report.

UK Maps

Some interactive maps of the UK results have been created using Tableau.

Analyses of minerals in chondrules and associated silica-rich igneous rims in CR chondrites. Data are from quantitative wavelength dispersive spectroscopy (WDS) X-ray maps obtained on the JEOL JXA-8530F electron microprobe at the University of Manchester. Powerpoint files show locations of areas extracted from WDS maps: each area is an individual analysis of a mineral grain. Excel files contain extracted data for each location.

The administrative boundaries of local authorities in England as provided by the ONS for the purposes of producing statistics.

Supplementary datasets for the paper "A machine framework for extracting biologial pathway information from the literature".

The datasets include Supplementary Data 1 (Training dataset images for training EBPI arrow detection model), Supplementary Data 2 (Test dataset images for validating EBPI arrow detection model), Supplementary Data 3 (Labeling dataset excel file for training and test dataset), Supplementary Data 4 (EBPI text classification model training dataset), Supplementary Data 5 (Collecting and processing of images illustrating biological pathways across 466 target chemicals from the bio-based chemicals map), Supplementary Data 6 (Information on reactions obtained through EBPI from images of biological pathways, focusing on target chemicals from maps of bio-based chemicals), Supplementary Data 7 (Target chemicals satisfying criteria for biosynthetic reactions not covered by biological pathway databases).

London Borough Council Elections - 6 May 2010 With the aim of making the democratic process as transparent as possible to the London electorate, this report includes a great deal of detail on every aspect of the 2010 London Borough council general elections. No other single volume presents the full results and election statistics from the 32 London boroughs enabling the reader to analyse and compare the results across London in one place. The report presents data for every candidate in every ward (excluding the City of London which operates on a different electoral model). Summaries are provided in the form of maps and tables, and to make comparisons easier, they mostly match those included in the 2006 report with a few useful additions. Results of all council by-elections between the general elections in 2006 and 2010, as well as details of the elections in the three boroughs that directly elect a mayor, are also presented here. This is the latest report in a long series of council election reports dating back to 1964. Find other election reports at http://data.london.gov.uk/elections/ Data for the elections in the three boroughs that directly elect a mayor (Newham, Lewisham and Hackney) are not included in the map but are included in the Excel spreadsheet of results.