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 PDF map of the London boroughs as at December 2018. The map shows the London boroughs split into inner London and outer London. (File Size - 228 KB).

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 Profiles help paint a general picture of an area by presenting a range of headline indicator data in both spreadsheet and map form to help show statistics covering demographic, economic, social and environmental datasets for each borough, alongside relevant comparator areas. The London Borough Atlas does the same but provides further detailed breakdowns and time-series data for each borough. The full datasets and more information for each of the indicators are usually available on the London Datastore. A link to each of the datasets is contained in the spreadsheet and map.

London Borough Profiles

On opening the Microsoft Excel version, a simple drop down box allows you to choose which borough profile you are interested in. Selecting this will display data for that borough, plus either Inner or Outer London, London and a national comparator (usually England where data is available). To see the full set of data for all 33 local authorities in London plus the comparator areas in Excel, click the 'Data' worksheet. A chart and a map are also available to help visualise the data for all boroughs (macros must be enabled for the Excel map to function). The data is set out across 11 themes covering most of the key indicators relating to demographic, economic, social and environmental data. Sources are provided in the spreadsheet. Notes about the indicator are provided in comment boxes attached to the indicator names. For a geographical and bar chart representation of the profile data, choose the InstantAtlas version. Choose indicators from the left hand side. Click on the comparators to make them appear on the chart and map. Sources, links to data, and notes are all contained in the box in the bottom right hand corner.

These profiles include data relating to: Population, Households (census), Demographics, Migrant population, Ethnicity, Language, Employment, NEET, DWP Benefits (client group), Housing Benefit, Qualifications, Earnings, Volunteering, Jobs density, Business Survival, Crime, Fires, House prices, New homes, Tenure, Greenspace, Recycling, Carbon Emissions, Cars, Public Transport Accessibility (PTAL), Indices of Multiple Deprivation, GCSE results, Children looked after, Children in out-of-work families, Life Expectancy, Teenage conceptions, Happiness levels, Political control, and Election turnout.

London Borough Atlas

To access even more data at local authority level, use the London Borough Atlas. It contains data about the same topics as the profiles but provides further detailed breakdowns and time-series data for each borough. There is also an InstantAtlas version available.

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. You may also find our small area profiles useful - Ward, LSOA, and "/dataset/msoa-atlas">MS

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.

A PDF map of the London boroughs as at December 2015. The map shows the London boroughs split into inner London and outer London. (File Size - 225 KB).

In 2023, Croydon had the largest population among London's 32 boroughs at 397,741, while Kensington and Chelsea had the smallest population, at 147,460.

London Heat Map --------------- The London Heat Map is a tool designed to help you identify areas of high heat demand, explore opportunities for new and expanding district heat networks and to draw potential heat networks and assess their financial feasibility. The new version of the London Heat Map was created for the Greater London Authority by the Centre for Sustainable Energy (CSE) in July 2019. The London Heat Map is regularly updated with new network data and other datasets. Background datasets such as building heat demand was last updated on 26/06/2023. 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: * Heat demand values for each building * Locations of potential heat supply sites * Locations of existing and proposed district heating networks * A spatial heat demand density map layer The map also includes a user-friendly visual tool for heat network design. This is intended to support preliminary techno-economic appraisal of potential district heat networks. 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. Building-level estimated annual and peak heat demand data from the London Heat Map has been made available through the data extracts below. The data was last updated on 26/06/2023. The data contains Ordnance Survey mapping and the data is published under Ordnance Survey's 'presumption to publish'. © Crown copyright and database rights 2023. 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. Other Useful Documents ---------------------- Other useful documents can be downloaded from the links below: Energy Masterplanning Manual Opportunities for Decentralised Energy in London - Vision Map London Heat Network Manual London Heat Network Manual II

We set ourselves the challenge of collating London’s tree data into one open source place to get a picture of London’s trees. We requested tree data from London boroughs and TfL in late 2014. The data mainly covers street trees, although it also includes some park trees, and contains location and species information for over 700,000 trees. It is estimated that there are around eight million trees in London, so this information is only a partial illustration of the species and location of trees in London.

There are several potential benefits to the public sharing of tree data. We hope that visualising tree data and providing access to it in one place will help to raise the public profile of the important contribution of trees to our urban environment and also provide operational benefits for tree managers. Sharing and standardising data could provide essential information for the strategic management of the urban forest. For example, it could help to assess species diversity and threats from pests and plant diseases across London and also help identify areas for additional planting.

We note that the process of collating and cleaning the tree data we received in 2014-15 has been complex and lengthy due to the variety of systems and formats in place for recording tree data. A more standardised method of recording data for trees in the public realm could improve this in the future.

Notes on the data:

• Data was not received from six boroughs. One other borough did not record location data in a form that was possible to easily map and so those trees could not be included. We aim to add any additional data received to the Datastore and online map.
• Whilst the data was provided in 2014-15 the trees will have been surveyed some time before this and so some records may be several years old.
• The data received varied significantly by borough. Some boroughs have only included trees on highways, whilst others have included trees on housing land, in schools or in parks. In some cases trees were recorded only when work was carried out.
• There is not a consistent or agreed format for collecting or recording tree data across London. This presents a challenge in collating data across multiple boroughs. Many boroughs collect a range of information about their trees (e.g. age, height). However this varied by borough in terms of the information collected and categorisations used so that the GLA was not able to standardise this information.
• The GLA requested tree species information as common names. Five boroughs only had Latin names recorded. The common names given also varied widely in terms of consistency of names, spelling, etc. As such, the GLA has gone through the data and standardised the names to come up with a simplified common name for display on the tree webmap (e. g. “Pear”). These are the common names for the 22 types of tree appearing most frequently in the data (which encompass 90% of all trees), with the remaining trees categorised as “Other”. We have also left the species name as provided by the borough in the data. In total over 2,000 different species of tree were recorded, grouped into over 100 types of tree using the common names.
• The ‘tree ID’ number has been added to the data to help map it. This number is not linked to borough’s tree management systems. Although for future data updates it would be helpful to establish such a link.

Click on the image below to view the data mapped.

Warning: Large file size may result in a long download time

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.

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.

Transport for London's (TFL) Public Transport Accessibility Levels (PTALs)

PTALS are a detailed and accurate measure of the accessibility of a point to the public transport network, taking into account walk access time and service availability. The method is essentially a way of measuring the density of the public transport network at any location within Greater London.

Each ares is graded between 0 and 6b, where a score of 0 is very poor access to public transport, and 6b is excellent access to public transport.

The current methodology was developed in 1992, by the London Borough of Hammersmith and Fulham. The model has been thoroughly reviewed and tested, and has been agreed by the London Borough-led PTAL development group as the most appropriate for use across London.

The measure therefore reflects:

• • Walking time from the point-of interest to the public transport access points;
• • The reliability of the service modes available;
• • The number of services available within the catchment; and
• • The level of service at the public transport access points - i.e. average waiting time.

It does not consider:

• • The speed or utility of accessible services;
• • Crowding, including the ability to board services; or,
• • Ease of interchange.

The PTAL methodology was developed for London where a dense integrated public transport network means that nearly all destinations can be reached within a reasonable amount of time. Research using the ATOS (Access to Opportunities and Services) methodology shows that there is a strong correlation between PTALs and the time taken to reach key services – i.e. high PTAL areas generally have good access to services and low PTAL areas have poor access to services.

Notes

6-digit references identify 100m grid squares.

The 2012 CSV file previously available on the Datastore is now only available via the TfL feeds page.

The 2014 files are available to download below. This includes the GIS contour files.

Current PTAL values can be viewed at TfL’s web site: www.webptals.org.uk

The GLA has calculated the percentage of population for each ward, LSOA, MSOA and borough within each PTAL. The files for 2014 are available below. The method used mapped the number of addresses (using Ordinance Survey AddressBase Plus, and 2011 Census London Output Areas boundaries).

TFL also publish on their website a tool that shows travel time and PTAL maps from any point within London. Click anywhere on the map or input a postcode to change the selected location.

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.

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). )

This report was released in September 2010. However, recent demographic data is available on the datastore - you may find other datasets on the Datastore useful such as: GLA Population Projections, National Insurance Number Registrations of Overseas Nationals, Births by Birthplace of Mother, Births and Fertility Rates, Office for National Statistics (ONS) Population Estimates

FOCUSONLONDON2010:POPULATIONANDMIGRATION

London is the United Kingdom’s only city region. Its population of 7.75 million is 12.5 per cent of the UK population living on just 0.6 per cent of the land area. London’s average population density is over 4,900 persons per square kilometre, this is ten times that of the second most densely populated region.

Between 2001 and 2009 London’s population grew by over 430 thousand, more than any other region, accounting for over 16 per cent of the UK increase.

This report discusses in detail the population of London including Population Age Structure, Fertility and Mortality, Internal Migration, International Migration, Population Turnover and Churn, and Demographic Projections.

Population and Migration report is the first release of the Focus on London 2010-12 series. Reports on themes such as Income, Poverty, Labour Market, Skills, Health, and Housing are also available.

REPORT:

Read the full report in PDF format.

https://londondatastore-upload.s3.amazonaws.com/fol/FocusOnLondonCoverweb.jpg" alt=""/>

PRESENTATION:

To access an interactive presentation about population changes in London click the link to see it on Prezi.com

DATA:

To access a spreadsheet with all the data from the Population and Migration report click on the image below.

Report data

MAP:

To enter an interactive map showing a number of indicators discussed in the Population and Migration report click on the image below.

Interactive Maps

FACTS:

● Top five boroughs for babies born per 10,000 population in 2008-09:

1. Newham – 244.4
2. Barking and Dagenham – 209.3
3. Hackney – 205.7
4. Waltham Forest – 202.7
5. Greenwich – 196.2

-32. Havering – 116.8

-33. City of London – 47.0

● In 2009, Barnet overtook Croydon as the most populous London borough. Prior to this Croydon had been the largest since 1966

● Population per hectare of land used for Domestic building and gardens is highest in Tower Hamlets

● In 2008-09, natural change (births minus deaths) led to 78,000 more Londoners compared with only 8,000 due to migration. read more about this or click play on the chart below to reveal how regional components of populations change have altered over time.

The five largest residential schemes approved in the stated month based on proposed residential units.

This is a list of the five largest planning permissions in terms of proposed residential units granted during the stated month, including renewal of previously approved schemes and details permissions for major schemes previously approved in outline.

This is based on the entries to the London Development Database submitted by the London Boroughs. Note that the London Boroughs are responsible for the quality of the data.

Borough data is not always submitted on time so the schemes shown are subject to change as the data are checked and missing permissions are added.

The CSV file is automatically updated on the 1st day of every month.

Open an interactive map of all LDD permissions data.

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.

Data from the 2008 Annual School Census shows for the first time the distribution of different languages spoken in London. 2008 represents the first year in which this data was available for all state schools.

Borough data (Excel)

Data for all languages above a threshold of 50 across London are presented at borough level. Numbers are rounded to ten. Percentages are rounded to 0.1.

Note: Within 'Others' there was at least one speaker from 118 different languages.

MSOA data (Excel)

Middle Super Output Area (MSOA) data is shown in the spreadsheet by the range which it belongs to in the map. Due to restrictions on use of the data, it is not possible to distribute the actual numbers (rounded or unrounded) down to MSOA level.

Interactive Maps

Data for both Borough and MSOA level are shown in the same map. To switch between the two geographies click on the 'choose geography' button at the top left of the screen.

Then choose a language under the 'most recent data' heading.

At Middle Super Output Area (MSOA) data for the main languages are best presented at using the interactive maps.

The publication of this data follows research by Institute for Education, Centre for Analysis of Social Exlusion and the London Borough of Newham. More information is on the UPTAP website.

Note: It is not possible to use the export image function on the map. This is a software issue and a solution is currently being worked on. As an interim method of copying the map image, please use the Print Screen option on your keyboard to copy an image to your clipboard.

Based on the First Revised Series of the Ordnance Survey London Town Plans. You can find a different version of the Georeferenced maps on the National Library of Scotland website:

https://maps.nls.uk/geo/explore/#zoom=11&lat=51.4907&lon=-0.1331&layers=163&b=1

Each factory is coded to indicate whether it is on both or just one of the two 19th century series of Ordnance Survey London Town Plans. I have also tried to catagorize the factories. There are some other incomplete fields or fields used in earlier versions of this database.

Data used in Jim Clifford, West Ham and the River Lea A Social and Environmental History of London’s Industrialized Marshland, 1839–1914, UBC Press, 2017, https://www.ubcpress.ca/west-ham-and-the-river-lea

All car parks owned and managed by the London Borough of Croydon.