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

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

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

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.

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

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

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.

Showing the boundaries of historic instances of river flooding in and around the London Borough of Lambeth

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.

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.

Showing boundaries of areas which provide people with access to nature close to home; they are those parks and green spaces where there is some intrinsic nature conservation value

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.

showing location of sites whose previous uses could have caused the land to be contaminated

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.

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.