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.

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.

Borough maps

• Map for quantitative data
• Map for categorical data
• Cartogram that uses squares to represent London Boroughs

Ward maps

Pre-2014 boundaries

• Greater London
• Individual Boroughs: Barking and Dagenham, Barnet, Bexley, Brent, Bromley, Camden, Croydon, Ealing, Enfield, Greenwich, Hackney, Hammersmith and Fulham, Haringey, Harrow, Havering, Hillingdon, Hounslow, Islington, Kensington and Chelsea, Kingston upon Thames, Lambeth, Lewisham, Merton, Newham, Redbridge, Richmond upon Thames, Southwark, Sutton, <a href="https://

The London Borough of Barnet is divided into 24 electoral Wards. The current warding arrangement came into effect on 5th May 2022. These maps have been created as general resource for the council. The information is sourced from Ordnance Survey Open Data products and may be used more widely subject to the Open Government Licence (v3). Each ward map is available in 2 different sizes, in pdf format and includes an approximate scale and information currency. Ward boundary information is from OS Boundary-Line™ (normally released in May and October) The A3 base map information is from OS OpenMap - Local (normally released in April and October) The A4 base map information is from OS VectorMap District (normally released in May and November) Only the latest version of the maps are published and older versions are not retained. Please note: these maps may not reflect the latest information published by Ordnance Survey, see document dates for date last updated.

The Zip folder contains a range of key GIS boundary files for ESRI and Map Info covering Greater London. The folder includes: - Output Area (OA) 2011, - Lower Super Output Area (LSOA) 2004 and 2011, - Middle Super Output Area (MSOA) 2004 and 2011, - London Wards (two files: City of London merged into single area and split into seperate wards). There are separate download file for 2014 & 2018 boundaries. - London Boroughs Note: The OA to MSOA boundaries have been generalised to reduce file size/loading time. On maps created using these boundaries the copyright must be stated. This is: "Contains National Statistics data © Crown copyright and database right [2015]" and "Contains Ordnance Survey data © Crown copyright and database right [2015]" For more information about boundary data sharing read these Terms and Conditions of Supply.

The ward profiles and ward atlas provide a range of demographic and related data for each ward in Greater London. They are designed to provide an overview of the population in these small areas by presenting a range of data on the population, diversity, households, life expectancy, housing, crime, benefits, land use, deprivation, and employment. Indicators included here are population by age and sex, land area, projections, population density, household composition, religion, ethnicity, birth rates (general fertility rate), death rates (standardised mortality ratio), life expectancy, average house prices, properties sold, housing by council tax band, tenure, property size (bedrooms), dwelling build period and type, mortgage and landlord home repossession, employment and economic activity, Incapacity Benefit, Housing Benefit, Household income, Income Support and JobSeekers Allowance claimant rates, dependent children receiving child-tax credits by lone parents and out-of-work families, child poverty, National Insurance Number registration rates for overseas nationals (NINo), GCSE results, A-level / Level 3 results (average point scores), pupil absence, child obesity, crime rates (by type of crime), fires, ambulance call outs, road casualties, happiness and well-being, land use, public transport accessibility (PTALs), access to public greenspace, access to nature, air emissions / quality, car use, bicycle travel, Indices of Deprivation, and election turnout. The Ward Profiles present key summary measures for the most recent year, using both Excel and InstantAtlas mapping software. This is a useful tool for displaying a large amount of data for numerous geographies, in one place. The Ward Atlas presents a more detailed version of the data including trend data and generally includes the raw numbers as opposed to percentages or rates. The Instant Atlas reports use HTML5 technology, which can be used in modern browsers, including on Apple machines, but will not function on older browsers. WARD PROFILES Compare the ward measure against the Borough, London and National average. WARD ATLAS Access the raw data for all London wards. WARD ATLAS FOR 2014 BOUNDARIES In May 2014, ward boundaries changed in Hackney, Kensington and Chelsea, and Tower Hamlets. This version of the ward atlas gives data for these new wards, as well as retaining data on the unchanged wards in the rest of London for comparison purposes. Data for boroughs has also been included. Very few datasets have been published for the new ward boundaries, so the majority of data contained in this atlas have been modelled using a method of proportion of households from the old boundaries that are located in the new boundaries. Therefore, the data contained in this atlas are indicative only. Instant Atlas for 2014 Ward Atlas Tips: - Select a new indicator from the Data box on the left. Select the theme, then indicator and then year to show the data. - To view data just for one borough*, use the filter tool. - Some legend settings can be altered by clicking on the cog icon next to the Wards tick box within the map legend. - The wards can be ranked in order by clicking at the top of the indicator column of the data table. Note: Additional indicator information and sources are included within the spreadsheet and Instant Atlas report. OTHER SMALL AREA PROFILES Other profiles available include Borough, LSOA and MSOA atlases. Data from these profiles were used to create the Well-being scores tool. *The London boroughs are: City of London, Barking and Dagenham, Barnet, Bexley, Brent, Bromley, Camden, Croydon, Ealing, Enfield, Greenwich, Hackney, Hammersmith and Fulham, Haringey, Harrow, Havering, Hillingdon, Hounslow, Islington, Kensington and Chelsea, Kingston upon Thames, Lambeth, Lewisham, Merton, Newham, Redbridge, Richmond upon Thames, Southwark, Sutton, Tower Hamlets, Waltham Forest, Wandsworth, Westminster. These profiles were created using the most up to date information available at the time of collection (September 2015).

These ward level well being scores present a combined measure of well-being indicators of the resident population based on 12 different indicators. Where possible each indicator score is compared with the England and Wales average, which is zero. Scores over 0 indicate a higher probability that the population on average will experience better well-being according to these measures.

Users can adjust the weight of each indicator depending on what they consider to be the more or less important, thus generating bespoke scores. This is done either by entering a number between 0 and 10. The scores throughout the spreadsheet will update automatically.

The tool combines data across a range of themes for the last five years of available data (2009-2013).

Either view the results in the online interactive tool here,

Or download the interactive spreadsheet here

The well-being scores are then presented in a ranked bar chart for each borough, and a ward map of London.

The spreadsheet also highlights wards in the top and bottom 25 per cent in London. Wards that have shown significant improvement or reduction in their scores relative to the average over the five year period are also highlighted.

Borough figures are provided to assist with comparisons.

Rankings and summary tables are included. The source data that the tool is based on is included in the spreadsheet.

The Excel file is 8.1MB.

IMPORTANT NOTE, users must enable macros when prompted upon opening the Excel spreadsheet (or reset security to medium/low) for the map to function. The rest of the tool will function without macros.

If you cannot download the Excel file directly try this zip file (2.6MB).

If you experience any difficulties with downloading this spreadsheet, please contact the London Datastore in the Intelligence Unit.

Detailed information about definitions and sources is contained within the spreadsheet.

The 12 measures included are:

Health
- Life Expectancy
- Childhood Obesity
- Incapacity Benefits claimant rate

Economic security
- Unemployment rate

Safety
- Crime rate
- Deliberate Fires

Education
- GCSE point scores

Children
- Unauthorised Pupil Absence

Families
- Children in out-of-work households

Transport
- Public Transport Accessibility Scores (PTALs)

Environment
- Access to public open space & nature

Happiness
- Composite Subjective Well-being Score (Life Satisfaction, Worthwhileness, Anxiety, and Happiness) (New data only available since 2011/12)

With some measures if the data shows a high figure that indicates better well-being, and with other measures a low figure indicates better well-being. Therefore scores for Life Expectancy, GCSE scores, PTALs, and Access to Public Open Space/Nature have been reversed so that in all measures low scores indicate probable lower well-being.

The data has been turned into scores where each indicator in each year has a standard deviation of 10. This means that each indicator will have an equal effect on the final score when the weightings are set to equal.

Why should measuring well-being be important to policy makers?
Following research by the Cabinet Office and Office for National Statistics, the government is aiming to develop policy that is more focused on ‘all those things that make life worthwhile’ (David Cameron, November 2010). They are interested in developing new and better ways to understand how policy and public services affect well-being.

Why measure well-being for local areas?
It is important for London policy makers to consider well-being at a local level (smaller than borough level) because of the often huge differences within boroughs. Local authorities rely on small area data in order to target resources, and with local authorities currently gaining more responsibilities from government, this is of increasing importance. But small area data is also of interest to academics, independent analysts and members of the public with an interest in the subject of well-being.

How can well-being be measured within small areas?
The Office for National Statistics have been developing new measures of national well-being, and as part of this, at a national and regional level, the ONS has published some subjective data to measure happiness. ONS have not measured well-being for small areas, so this tool has been designed to fill this gap. However, DCLG have published a tool that models life satisfaction data for LSOAs based on a combination of national level happiness data, and 'ACORN' data. Happiness data is not available for small areas because there are no surveys large enough for this level of detail, and so at this geography the focus is on objective indicators. Data availability for small areas is far more limited than for districts, and this means the indicators that the scores are based on are not all perfect measures of well-being, though they are the best available. However, by using a relatively high number of measures across a number of years, this increases the reliability of the well-being scores.

How can this tool be used to help policy makers?
Each neighbourhood will have its own priorities, but the data in this tool could help provide a solid evidence base for informed local policy-making, and the distribution of regeneration funds. In addition, it could assist users to identify the causes behind an improvement in well-being in certain wards, where examples of good practice could be applied elsewhere.

Differences to the previous report

This is the 2013 edition of this publication, and there is one change from 2012. Indicators of Election turnout has been replaced with a composite score of subjective well-being indicators.

Past versions are still available for 2011 and 2012. The rationale/methodology paper from 2011 is here. The scores from the 2012 spreadsheet are also available in PDF format. The scores in Intelligence Update 21-2012 are based on equal weightings across each measure.

This tool was created by the GLA Intelligence Unit. Please contact datastore@london.gov.uk for more information.

The Zip folder contains a range of key GIS boundary files for ESRI and Map Info covering Greater London.

The folder includes:

- Output Area (OA) 2011,

- Lower Super Output Area (LSOA) 2004 and 2011,

- Middle Super Output Area (MSOA) 2004 and 2011,

- London Wards (two files: City of London merged into single area and split into seperate wards). There are separate download file for 2014 & 2018 boundaries.

- London Boroughs

- Greater London boundary

Note: The OA to MSOA boundaries have been generalised to reduce file size/loading time.

On maps created using these boundaries the copyright must be stated. This is: "Contains National Statistics data © Crown copyright and database right [2015]" and "Contains Ordnance Survey data © Crown copyright and database right [2015]"

For more information about boundary data sharing read these Terms and Conditions of Supply.

Electoral Wards/Divisions are the key building blocks of UK administrative geography. They are the spatial units used to elect local government councillors in metropolitan and non-metropolitan districts, unitary authorities and the London boroughs in England; unitary authorities in Wales; council areas in Scotland; and district council areas in Northern Ireland.

The Wards and Electoral Divisions list contains 9,481 areas of the following constituent geographies:

• 7,218 Census Wards in England
• 453 Census Electoral Divisions in England
• 7 Census Merged Wards in England
• 582 Census Wards in Northern Ireland
• 353 Census Wards in Scotland
• 856 Census Electoral Divisions in Wales
• 12 Census Merged Wards in Wales

Please visit ONS Beginner's Guide to UK Geography for more info.

The boundaries are available as either extent of the realm (usually this is the Mean Low Water mark but in some cases boundaries extend beyond this to include off shore islands) or

clipped to the coastline (Mean High Water mark).

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 report includes a great deal of detail on every aspect of the 2014 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). The report also contains analysis of the European election results for London that took place on the same day. Printed Copies We are able to accept orders for hard copies £30. Click here for further details. Details of all previous elections reports in the series can be found here. Summary results of the 2014 local elections in London, showing number and percentage of seats won, turnout and political control. Final 2014 ward results These results show the number of votes for each candidate in each ward in London. Turnout, number of ballots, postal votes, and breakdown of rejected votes, Mayoral and European voting figures are also included where available. Map showing political control in each ward. Also, using these ward results, Oliver O'Brien from CASA has created some eye catching interactive ward maps. The borough map shows the summary results in both the 2010 and 2014 elections. The ward interactive map shows the detailed results for each candidate at ward level for the last three elections between 2006 and 2014. This motion chart shows the relationship, between share of votes and seats won by the major parties in elections since 1964 at borough level (requires Adobe Flash Player). )

Compilation of maps of Jobseekers Allowance (JSA) claimants and/or JSA rates covering the London boroughs, Camden wards and Camden LSOAs in a single PDF document. Updated monthly to show the latest data. Previous months maps available upon request from population@camden.gov.uk.

London Borough Council Elections - 6 May 2010

https://s3-eu-west-1.amazonaws.com/londondatastore-upload/boro-elections-2010-cover.png" alt="REPORT">

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/

REPORT:

The report is available in PDF format.

Hard copies are available from the Intelligence Unit for £20. Please contact intelligence@london.gov.uk or tel 020 7983 4922 (credit card or cheque accepted).

https://s3-eu-west-1.amazonaws.com/londondatastore-upload/lbce-excel-thumb.png" alt="DATA">

DATA:

All the data contained within the 'London Borough Council Elections 2010' report can be accessed in this spreadsheet. This contains results for each candidate standing in all 624 wards in the London boroughs (excluding the City of London which operates on a different electoral model).

Also available in the following spreadsheets:

● Full results for every ward and every candidate from 2006 and 2010

● A summary of the number of seats won by each party by borough including political control.

● Ward and borough turnout data.

MOTION CHART:

https://s3-eu-west-1.amazonaws.com/londondatastore-upload/elections-motion-thumb.png" alt="CHART">

This motion chart shows the relationship, between share of votes and seats won by the major parties in elections since 1964 at borough level (requires Adobe Flash Player).

MAP:

)

These interactive ward maps help to geographically present election results from 2006 and 2010 and display results for each candidate (requires Adobe Flash Player).

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.

DATA The results for the Mayoral and Assembly elections down to constituency level are available (including turnout and spoils etc). All Geographies - This spreadsheet includes data for Constituencies, Boroughs, Wards and postal votes. Also includes turnout figures and first choice by second choice Mayoral vote matrices. Detailed Constituencies - Contains more detailed data at Constituency level. Includes percentages and a table showing how the London-wide assembly seats were allocated. Time series - Contains elections data from 2000 to 2016 for Constituency and Borough level. Please note that due to boundary changes, 2016 ward data is not comparable with previous years' data. INTERACTIVE MAPPING The 2000-2012 election data for wards, boroughs, and constituencies is presented using interactive maps and charts in an InstantAtlas report. Click on the image below to launch the tool. More info on the 2016 elections can be found on the London Elects website.

These fuel poverty risk indicators provide users with a nuanced picture of the impact of various risk factors, exacerbating factors and indicators for fuel poverty. It was developed with the Assembly Health and Public Services Committee in their investigation into fuel poverty in London. The Committee's report explains how the tool could be used strategically to help organisations target specific wards that are at high risk of fuel poverty. Appendix 4 in the report set out the rationale for the risk factors present in the tool.

Users can adjust the weighting of the indicators to show their relative significance. Isolating specific indicators could help organisations determine what type of support is likely to have greatest impact in an area. For example, wards with a low score for cavity wall insulation would indicate wards that could be targeted for promoting uptake of cavity wall insulation.

Read Victoria Borwick's blog "Using public data to tackle fuel poverty - can you help?"

The fuel poverty scores measure risk of fuel poverty based on 12 indicators. The England and Wales average each year is 0. Scores below 0 are more likely to be at risk from fuel poverty according to these measures.

The indicators are:

Housing
Dwellings without central heating
Cavity walls that are uninsulated
Lofts with less than 150mm insulation

Health
Health Deprivation & Disability domain (ID2010)
Standardised Mortality Ratio
Incapacity Benefit claimant rate

Older people
People aged 60 and over
Older people claiming pension credit

Worklessness
Unemployment

Poverty
Income Support claimant rate
Child Poverty rates
Households classified 'fuel poor'

The Excel tool includes a ward map, charts and rankings.

Note: Users must enable macros when prompted upon opening the spreadsheet (or reset security to medium/low) for the map to function. The rest of the tool will function without macros.

https://s3-eu-west-1.amazonaws.com/londondatastore-upload/fp-dashboard-map.jpg" alt="Excel Tool"/>

Lookup table of 2011-based Lower-layer Super Output Areas (LSOAs) by Camden 2002 wards; and individual ward maps showing the location of LSOAs within.

This file contains the names and codes for electoral wards/divisions in the United Kingdom as at 2nd May 2024. (File Size - 800 KB)Field Names - WD24CD, WD24NM, WD24NMWField Types - Text, Text, TextField Lengths - 9, 53, 45

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/ REPORT: The report is available in PDF format. Hard copies are available from the Intelligence Unit for £20. Please contact intelligence@london.gov.uk or tel 020 7983 4922 (credit card or cheque accepted). DATA: All the data contained within the 'London Borough Council Elections 2010' report can be accessed in this spreadsheet. This contains results for each candidate standing in all 624 wards in the London boroughs (excluding the City of London which operates on a different electoral model). Also available in the following spreadsheets: ● Full results for every ward and every candidate from 2006 and 2010 ● A summary of the number of seats won by each party by borough including political control. ● Ward and borough turnout data. MOTION CHART: This motion chart shows the relationship, between share of votes and seats won by the major parties in elections since 1964 at borough level (requires Adobe Flash Player). MAP: ) These interactive ward maps help to geographically present election results from 2006 and 2010 and display results for each candidate (requires Adobe Flash Player). 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.

This includes ward population and dwelling counts per ward, based on Statistics Canada Census for the London Census Subdivision (City of London).

Contained within the 2nd Edition (1915) of the Atlas of Canada is a plate comprised of three maps that shows the cities of Ottawa, Hamilton, and London. Each map indicates the location of city wards, electric railways, select buildings and churches.

This file contains the names and codes for electoral wards/divisions in the United Kingdom as at 5th May 2022. (File Size - 241KB)Field Names - WD22CD, WD22NM, WD22NMWField Types - Text, Text, TextField Lengths - 9, 53, 45