Imagine you are moving to London, UK. It’s a major metropolitan city, a financial hub, a famous tourist destination, and home to around 9 million people. But as with every big city, crime is a concern, and you would like to live in a neighborhood that is safe and also popular. In this blog, we’ll use the London Crime data and the Foursquare API to select which neighborhood best fits our needs.
The London Crime data consists of more than 13 million rows containing counts of criminal reports by month, LSOA (Lower Super Output Area) borough, and major/minor category. You can download the data here.
About the data:
- lsoa_code: code for Lower Super Output Area in Greater London. - borough: Common name for London borough. - major_category: High level categorization of crime - minor_category: Low level categorization of crime within major category. - value: monthly reported count of categorical crime in given borough - year: Year of reported counts, 2008-2016 - month: Month of reported counts, 1-12
# import libraries
import pandas as pd # library for data analysis
import numpy as np # library to handle data in a vectorized manner
import random # library for random number generation
import requests # library to handle requests
from bs4 import BeautifulSoup # library for web scraping
#!conda install -c conda-forge geocoder --yes
import geocoder
#!conda install -c conda-forge geopy --yes
from geopy.geocoders import Nominatim # module to convert an address into latitude and longitude values
# libraries for displaying images
from IPython.display import Image
from IPython.core.display import HTML
# transforming json file into a pandas dataframe library
from pandas.io.json import json_normalize
#!conda install -c conda-forge folium=0.5.0 --yes
import folium # plotting library
print('Libraries imported.')
Libraries imported.
Define Foursquare credentials.
= 'XXXX'
CLIENT_ID = 'XXXX'
CLIENT_SECRET = 'XXXX'
VERSION
# limit the number of venues returned by the foursquare API
= 50 LIMIT
Read the dataset into a pandas dataframe.
= pd.read_csv('london_crime_by_lsoa.csv')
df df.head()
lsoa_code | borough | major_category | minor_category | value | year | month | |
---|---|---|---|---|---|---|---|
0 | E01001116 | Croydon | Burglary | Burglary in Other Buildings | 0 | 2016 | 11 |
1 | E01001646 | Greenwich | Violence Against the Person | Other violence | 0 | 2016 | 11 |
2 | E01000677 | Bromley | Violence Against the Person | Other violence | 0 | 2015 | 5 |
3 | E01003774 | Redbridge | Burglary | Burglary in Other Buildings | 0 | 2016 | 3 |
4 | E01004563 | Wandsworth | Robbery | Personal Property | 0 | 2008 | 6 |
# dimensions of the dataframe
df.shape
(13490604, 7)
Preprocessing the data
# remove all null value entries
= df[df.value != 0]
df
# reset the index and drop the previous index
= df.reset_index(drop=True)
df
df.head()
lsoa_code | borough | major_category | minor_category | value | year | month | |
---|---|---|---|---|---|---|---|
0 | E01004177 | Sutton | Theft and Handling | Theft/Taking of Pedal Cycle | 1 | 2016 | 8 |
1 | E01000086 | Barking and Dagenham | Theft and Handling | Other Theft Person | 1 | 2009 | 5 |
2 | E01001301 | Ealing | Theft and Handling | Other Theft Person | 2 | 2012 | 1 |
3 | E01001794 | Hackney | Violence Against the Person | Harassment | 1 | 2013 | 2 |
4 | E01000733 | Bromley | Criminal Damage | Criminal Damage To Motor Vehicle | 1 | 2016 | 4 |
# new dimensions of the dataframe
df.shape
(3419099, 7)
Change the column names.
= ['LSOA_Code', 'Borough', 'Major_Category', 'Minor_Category', 'No_of_Crimes', 'Year', 'Month']
df.columns 2) df.head(
LSOA_Code | Borough | Major_Category | Minor_Category | No_of_Crimes | Year | Month | |
---|---|---|---|---|---|---|---|
0 | E01004177 | Sutton | Theft and Handling | Theft/Taking of Pedal Cycle | 1 | 2016 | 8 |
1 | E01000086 | Barking and Dagenham | Theft and Handling | Other Theft Person | 1 | 2009 | 5 |
# dataset information
df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 3419099 entries, 0 to 3419098
Data columns (total 7 columns):
# Column Dtype
--- ------ -----
0 LSOA_Code object
1 Borough object
2 Major_Category object
3 Minor_Category object
4 No_of_Crimes int64
5 Year int64
6 Month int64
dtypes: int64(3), object(4)
memory usage: 182.6+ MB
What is the total number of crimes in each Borough?
'Borough'].value_counts() df[
Lambeth 152784
Croydon 147203
Southwark 144362
Ealing 140006
Newham 137275
Brent 129925
Lewisham 128232
Barnet 127194
Tower Hamlets 120099
Wandsworth 118995
Enfield 117953
Hackney 116521
Haringey 116315
Waltham Forest 114603
Camden 112029
Islington 111755
Hillingdon 110614
Westminster 110070
Bromley 109855
Hounslow 106561
Redbridge 105932
Greenwich 104654
Hammersmith and Fulham 92084
Barking and Dagenham 86849
Havering 82288
Kensington and Chelsea 81295
Harrow 73993
Bexley 73948
Merton 73661
Sutton 62776
Richmond upon Thames 61857
Kingston upon Thames 46846
City of London 565
Name: Borough, dtype: int64
The Boroughs of Lambeth, Croydon, Southwark and Ealing have the highest number of crimes from the year 2008 to 2016.
What is the total number of crimes per major category?
'Major_Category'].value_counts() df[
Theft and Handling 1136994
Violence Against the Person 894859
Criminal Damage 466268
Burglary 441209
Drugs 231894
Robbery 163549
Other Notifiable Offences 80569
Fraud or Forgery 2682
Sexual Offences 1075
Name: Major_Category, dtype: int64
Pivot the table to view the number of crimes for each major category in each Borough.
= pd.pivot_table(df, values=['No_of_Crimes'],
London_crime =['Borough'],
index=['Major_Category'],
columns=np.sum, fill_value=0)
aggfunc London_crime.head()
No_of_Crimes | |||||||||
---|---|---|---|---|---|---|---|---|---|
Major_Category | Burglary | Criminal Damage | Drugs | Fraud or Forgery | Other Notifiable Offences | Robbery | Sexual Offences | Theft and Handling | Violence Against the Person |
Borough | |||||||||
Barking and Dagenham | 18103 | 18888 | 9188 | 205 | 2819 | 6105 | 49 | 50999 | 43091 |
Barnet | 36981 | 21024 | 9796 | 175 | 2953 | 7374 | 38 | 87285 | 46565 |
Bexley | 14973 | 17244 | 7346 | 106 | 1999 | 2338 | 22 | 40071 | 30037 |
Brent | 28923 | 20569 | 25978 | 157 | 3711 | 12473 | 39 | 72523 | 63178 |
Bromley | 27135 | 24039 | 8942 | 196 | 2637 | 4868 | 31 | 69742 | 46759 |
# reset the index
=True) London_crime.reset_index(inplace
# total crimes per Borough
'Total'] = London_crime.sum(axis=1)
London_crime[ London_crime.head()
Borough | No_of_Crimes | Total | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Major_Category | Burglary | Criminal Damage | Drugs | Fraud or Forgery | Other Notifiable Offences | Robbery | Sexual Offences | Theft and Handling | Violence Against the Person | ||
0 | Barking and Dagenham | 18103 | 18888 | 9188 | 205 | 2819 | 6105 | 49 | 50999 | 43091 | 149447 |
1 | Barnet | 36981 | 21024 | 9796 | 175 | 2953 | 7374 | 38 | 87285 | 46565 | 212191 |
2 | Bexley | 14973 | 17244 | 7346 | 106 | 1999 | 2338 | 22 | 40071 | 30037 | 114136 |
3 | Brent | 28923 | 20569 | 25978 | 157 | 3711 | 12473 | 39 | 72523 | 63178 | 227551 |
4 | Bromley | 27135 | 24039 | 8942 | 196 | 2637 | 4868 | 31 | 69742 | 46759 | 184349 |
Remove the multi-index so that it will be easier to merge the columns.
= London_crime.columns.map(' '.join)
London_crime.columns London_crime.head()
Borough | No_of_Crimes Burglary | No_of_Crimes Criminal Damage | No_of_Crimes Drugs | No_of_Crimes Fraud or Forgery | No_of_Crimes Other Notifiable Offences | No_of_Crimes Robbery | No_of_Crimes Sexual Offences | No_of_Crimes Theft and Handling | No_of_Crimes Violence Against the Person | Total | |
---|---|---|---|---|---|---|---|---|---|---|---|
0 | Barking and Dagenham | 18103 | 18888 | 9188 | 205 | 2819 | 6105 | 49 | 50999 | 43091 | 149447 |
1 | Barnet | 36981 | 21024 | 9796 | 175 | 2953 | 7374 | 38 | 87285 | 46565 | 212191 |
2 | Bexley | 14973 | 17244 | 7346 | 106 | 1999 | 2338 | 22 | 40071 | 30037 | 114136 |
3 | Brent | 28923 | 20569 | 25978 | 157 | 3711 | 12473 | 39 | 72523 | 63178 | 227551 |
4 | Bromley | 27135 | 24039 | 8942 | 196 | 2637 | 4868 | 31 | 69742 | 46759 | 184349 |
Let’s rename the columns for better comprehensibility.
= ['Borough', 'Burglary', 'Criminal Damage', 'Drugs', 'Fraud or Forgery', 'Other Notifiable Offenses',
London_crime.columns 'Robbery', 'Sexual Offences', 'Theft and Handling', 'Violence Against the Person', 'Total']
London_crime
Borough | Burglary | Criminal Damage | Drugs | Fraud or Forgery | Other Notifiable Offenses | Robbery | Sexual Offences | Theft and Handling | Violence Against the Person | Total | |
---|---|---|---|---|---|---|---|---|---|---|---|
0 | Barking and Dagenham | 18103 | 18888 | 9188 | 205 | 2819 | 6105 | 49 | 50999 | 43091 | 149447 |
1 | Barnet | 36981 | 21024 | 9796 | 175 | 2953 | 7374 | 38 | 87285 | 46565 | 212191 |
2 | Bexley | 14973 | 17244 | 7346 | 106 | 1999 | 2338 | 22 | 40071 | 30037 | 114136 |
3 | Brent | 28923 | 20569 | 25978 | 157 | 3711 | 12473 | 39 | 72523 | 63178 | 227551 |
4 | Bromley | 27135 | 24039 | 8942 | 196 | 2637 | 4868 | 31 | 69742 | 46759 | 184349 |
5 | Camden | 27939 | 18482 | 21816 | 123 | 3857 | 9286 | 36 | 140596 | 53012 | 275147 |
6 | City of London | 15 | 16 | 33 | 0 | 17 | 24 | 0 | 561 | 114 | 780 |
7 | Croydon | 33376 | 31218 | 19162 | 270 | 4340 | 12645 | 55 | 91437 | 67791 | 260294 |
8 | Ealing | 30831 | 25613 | 18591 | 175 | 4406 | 9568 | 52 | 93834 | 68492 | 251562 |
9 | Enfield | 30213 | 22487 | 13251 | 132 | 3293 | 9059 | 38 | 70371 | 45036 | 193880 |
10 | Greenwich | 20966 | 22755 | 10836 | 107 | 3598 | 5430 | 56 | 64923 | 52897 | 181568 |
11 | Hackney | 21450 | 17327 | 18144 | 143 | 3332 | 8975 | 46 | 91118 | 56584 | 217119 |
12 | Hammersmith and Fulham | 17010 | 14595 | 15492 | 91 | 3352 | 5279 | 45 | 86381 | 43014 | 185259 |
13 | Haringey | 28213 | 22272 | 14563 | 207 | 2971 | 10084 | 40 | 83979 | 50943 | 213272 |
14 | Harrow | 19630 | 12724 | 7122 | 92 | 1998 | 4242 | 27 | 40800 | 30213 | 116848 |
15 | Havering | 21302 | 17252 | 8171 | 179 | 2358 | 3089 | 19 | 52609 | 33968 | 138947 |
16 | Hillingdon | 26056 | 24485 | 11413 | 223 | 6504 | 5663 | 44 | 80028 | 55264 | 209680 |
17 | Hounslow | 21026 | 21407 | 13722 | 183 | 3963 | 4847 | 40 | 70180 | 51404 | 186772 |
18 | Islington | 22207 | 18354 | 16553 | 85 | 3675 | 8736 | 40 | 107661 | 52975 | 230286 |
19 | Kensington and Chelsea | 14980 | 9839 | 14573 | 85 | 2203 | 4744 | 24 | 95963 | 29570 | 171981 |
20 | Kingston upon Thames | 10131 | 10610 | 5682 | 65 | 1332 | 1702 | 18 | 38226 | 21540 | 89306 |
21 | Lambeth | 30199 | 26136 | 25083 | 137 | 4520 | 18408 | 70 | 114899 | 72726 | 292178 |
22 | Lewisham | 24871 | 24810 | 16825 | 262 | 3809 | 10455 | 71 | 70382 | 63652 | 215137 |
23 | Merton | 16485 | 14339 | 6651 | 111 | 1571 | 4021 | 26 | 44128 | 28322 | 115654 |
24 | Newham | 25356 | 24177 | 18389 | 323 | 4456 | 16913 | 43 | 106146 | 66221 | 262024 |
25 | Redbridge | 26735 | 17543 | 15736 | 284 | 2619 | 7688 | 31 | 71496 | 41430 | 183562 |
26 | Richmond upon Thames | 16097 | 11722 | 4707 | 37 | 1420 | 1590 | 26 | 40858 | 20314 | 96771 |
27 | Southwark | 27980 | 24450 | 27381 | 321 | 4696 | 16153 | 40 | 109432 | 68356 | 278809 |
28 | Sutton | 13207 | 14474 | 4586 | 57 | 1393 | 2308 | 20 | 39533 | 25409 | 100987 |
29 | Tower Hamlets | 21510 | 21593 | 23408 | 124 | 4268 | 10050 | 47 | 87620 | 59993 | 228613 |
30 | Waltham Forest | 25565 | 20459 | 14101 | 236 | 3040 | 10606 | 34 | 77940 | 51898 | 203879 |
31 | Wandsworth | 25533 | 19630 | 9493 | 161 | 3091 | 8398 | 47 | 92523 | 45865 | 204741 |
32 | Westminster | 29295 | 20405 | 34031 | 273 | 6148 | 15752 | 59 | 277617 | 71448 | 455028 |
Scraping data from the web
Let’s scrape additional information about the different Boroughs in London from the “List of London boroughs” Wikipedia page.
We’ll use the Beautiful Soup library to scrape the latitude and longitude coordinates of the boroughs in London.
# getting data from internet
= 'https://en.wikipedia.org/wiki/List_of_London_boroughs'
wikipedia_link = requests.get(wikipedia_link).text
raw_wikipedia_page
# using beautiful soup to parse the HTML/XML codes.
= BeautifulSoup(raw_wikipedia_page,'xml')
soup print(soup.prettify())
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html>
<html class="client-nojs" dir="ltr" lang="en">
<head>
<meta charset="UTF-8"/>
<title>
List of London boroughs - Wikipedia
</title>
<script>
document.documentElement.className="client-js";RLCONF={"wgBreakFrames":!1,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgMonthNamesShort":["","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"],"wgRequestId":"XnGIbgpAMNIAAU@V7W8AAACD","wgCSPNonce":!1,"wgCanonicalNamespace":"","wgCanonicalSpecialPageName":!1,"wgNamespaceNumber":0,"wgPageName":"List_of_London_boroughs","wgTitle":"List of London boroughs","wgCurRevisionId":943613985,"wgRevisionId":943613985,"wgArticleId":28092685,"wgIsArticle":!0,"wgIsRedirect":!1,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["Use dmy dates from August 2015","Use British English from August 2015","Lists of coordinates","Geographic coordinate lists","Articles with Geo","London boroughs","Lists of places in London"],
"wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"List_of_London_boroughs","wgRelevantArticleId":28092685,"wgIsProbablyEditable":!0,"wgRelevantPageIsProbablyEditable":!0,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgMediaViewerOnClick":!0,"wgMediaViewerEnabledByDefault":!0,"wgPopupsReferencePreviews":!1,"wgPopupsConflictsWithNavPopupGadget":!1,"wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wgMFDisplayWikibaseDescriptions":{"search":!0,"nearby":!0,"watchlist":!0,"tagline":!1},"wgWMESchemaEditAttemptStepOversample":!1,"wgULSCurrentAutonym":"English","wgNoticeProject":"wikipedia","wgWikibaseItemId":"Q6577004","wgCentralAuthMobileDomain":!1,"wgEditSubmitButtonLabelPublish":!0};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready","noscript":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"ready","user.tokens":"loading"
,"ext.cite.styles":"ready","mediawiki.legacy.shared":"ready","mediawiki.legacy.commonPrint":"ready","jquery.tablesorter.styles":"ready","jquery.makeCollapsible.styles":"ready","mediawiki.toc.styles":"ready","skins.vector.styles":"ready","wikibase.client.init":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","ext.uls.interlanguage":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["ext.cite.ux-enhancements","site","mediawiki.page.startup","skins.vector.js","mediawiki.page.ready","jquery.tablesorter","jquery.makeCollapsible","mediawiki.toc","ext.gadget.ReferenceTooltips","ext.gadget.charinsert","ext.gadget.refToolbar","ext.gadget.extra-toolbar-buttons","ext.gadget.switcher","ext.centralauth.centralautologin","mmv.head","mmv.bootstrap.autostart","ext.popups","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.eventLogging","ext.wikimediaEvents","ext.navigationTiming","ext.uls.compactlinks","ext.uls.interface",
"ext.cx.eventlogging.campaigns","ext.quicksurveys.init","ext.centralNotice.geoIP","ext.centralNotice.startUp"];
</script>
<script>
(RLQ=window.RLQ||[]).push(function(){mw.loader.implement("user.tokens@tffin",function($,jQuery,require,module){/*@nomin*/mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"});
});});
</script>
<link href="/w/load.php?lang=en&modules=ext.cite.styles%7Cext.uls.interlanguage%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediaBadges%7Cjquery.makeCollapsible.styles%7Cjquery.tablesorter.styles%7Cmediawiki.legacy.commonPrint%2Cshared%7Cmediawiki.toc.styles%7Cskins.vector.styles%7Cwikibase.client.init&only=styles&skin=vector" rel="stylesheet"/>
<script async="" src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector"/>
<meta content="" name="ResourceLoaderDynamicStyles"/>
<link href="/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector" rel="stylesheet"/>
<meta content="MediaWiki 1.35.0-wmf.22" name="generator"/>
<meta content="origin" name="referrer"/>
<meta content="origin-when-crossorigin" name="referrer"/>
<meta content="origin-when-cross-origin" name="referrer"/>
<link href="/w/index.php?title=List_of_London_boroughs&action=edit" rel="alternate" title="Edit this page" type="application/x-wiki"/>
<link href="/w/index.php?title=List_of_London_boroughs&action=edit" rel="edit" title="Edit this page"/>
<link href="/static/apple-touch/wikipedia.png" rel="apple-touch-icon"/>
<link href="/static/favicon/wikipedia.ico" rel="shortcut icon"/>
<link href="/w/opensearch_desc.php" rel="search" title="Wikipedia (en)" type="application/opensearchdescription+xml"/>
<link href="//en.wikipedia.org/w/api.php?action=rsd" rel="EditURI" type="application/rsd+xml"/>
<link href="//creativecommons.org/licenses/by-sa/3.0/" rel="license"/>
<link href="/w/index.php?title=Special:RecentChanges&feed=atom" rel="alternate" title="Wikipedia Atom feed" type="application/atom+xml"/>
<link href="https://en.wikipedia.org/wiki/List_of_London_boroughs" rel="canonical"/>
<link href="//login.wikimedia.org" rel="dns-prefetch"/>
<link href="//meta.wikimedia.org" rel="dns-prefetch"/>
<!--[if lt IE 9]><script src="/w/resources/lib/html5shiv/html5shiv.js"></script><![endif]-->
</head>
<body class="mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject mw-editable page-List_of_London_boroughs rootpage-List_of_London_boroughs skin-vector action-view">
<div class="noprint" id="mw-page-base"/>
<div class="noprint" id="mw-head-base"/>
<div class="mw-body" id="content" role="main">
<a id="top"/>
<div class="mw-body-content" id="siteNotice">
<!-- CentralNotice -->
</div>
<div class="mw-indicators mw-body-content">
</div>
<h1 class="firstHeading" id="firstHeading" lang="en">
List of London boroughs
</h1>
<div class="mw-body-content" id="bodyContent">
<div class="noprint" id="siteSub">
From Wikipedia, the free encyclopedia
</div>
<div id="contentSub"/>
<div id="jump-to-nav"/>
<a class="mw-jump-link" href="#mw-head">
Jump to navigation
</a>
<a class="mw-jump-link" href="#p-search">
Jump to search
</a>
<div class="mw-content-ltr" dir="ltr" id="mw-content-text" lang="en">
<div class="mw-parser-output">
<p class="mw-empty-elt">
</p>
<div class="thumb tright">
<div class="thumbinner" style="width:302px;">
<a class="image" href="/wiki/File:London-boroughs.svg">
<img alt="" class="thumbimage" data-file-height="386" data-file-width="489" decoding="async" height="237" src="//upload.wikimedia.org/wikipedia/commons/thumb/2/29/London-boroughs.svg/300px-London-boroughs.svg.png" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/2/29/London-boroughs.svg/450px-London-boroughs.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/2/29/London-boroughs.svg/600px-London-boroughs.svg.png 2x" width="300"/>
</a>
<div class="thumbcaption">
<div class="magnify">
<a class="internal" href="/wiki/File:London-boroughs.svg" title="Enlarge"/>
</div>
Map of the 32 London boroughs and the City of London.
</div>
</div>
</div>
<p>
This is a list of
<a href="/wiki/Districts_of_England" title="Districts of England">
local authority districts
</a>
within
<a href="/wiki/Greater_London" title="Greater London">
Greater London
</a>
, including 32
<a href="/wiki/London_boroughs" title="London boroughs">
London boroughs
</a>
and the
<a href="/wiki/City_of_London" title="City of London">
City of London
</a>
. The London boroughs were all created on 1 April 1965. Upon creation, twelve were designated
<a href="/wiki/Inner_London" title="Inner London">
Inner London
</a>
boroughs and the remaining twenty were designated
<a href="/wiki/Outer_London" title="Outer London">
Outer London
</a>
boroughs. The
<a class="mw-redirect" href="/wiki/Office_for_National_Statistics" title="Office for National Statistics">
Office for National Statistics
</a>
has amended the designations of three boroughs for statistics purposes only. Three boroughs have been granted the designation
<a class="mw-redirect" href="/wiki/Royal_borough" title="Royal borough">
royal borough
</a>
and one has
<a href="/wiki/City_status_in_the_United_Kingdom" title="City status in the United Kingdom">
city status
</a>
. For planning purposes, in addition to the boroughs and City there are also two active development corporations, the
<a href="/wiki/London_Legacy_Development_Corporation" title="London Legacy Development Corporation">
London Legacy Development Corporation
</a>
and
<a href="/wiki/Old_Oak_and_Park_Royal_Development_Corporation" title="Old Oak and Park Royal Development Corporation">
Old Oak and Park Royal Development Corporation
</a>
.
</p>
<div aria-labelledby="mw-toc-heading" class="toc" id="toc" role="navigation">
<input class="toctogglecheckbox" id="toctogglecheckbox" role="button" style="display:none" type="checkbox"/>
<div class="toctitle" dir="ltr" lang="en">
<h2 id="mw-toc-heading">
Contents
</h2>
<span class="toctogglespan">
<label class="toctogglelabel" for="toctogglecheckbox"/>
</span>
</div>
<ul>
<li class="toclevel-1 tocsection-1">
<a href="#List_of_boroughs_and_local_authorities">
<span class="tocnumber">
1
</span>
<span class="toctext">
List of boroughs and local authorities
</span>
</a>
</li>
<li class="toclevel-1 tocsection-2">
<a href="#City_of_London">
<span class="tocnumber">
2
</span>
<span class="toctext">
City of London
</span>
</a>
</li>
<li class="toclevel-1 tocsection-3">
<a href="#See_also">
<span class="tocnumber">
3
</span>
<span class="toctext">
See also
</span>
</a>
</li>
<li class="toclevel-1 tocsection-4">
<a href="#Notes">
<span class="tocnumber">
4
</span>
<span class="toctext">
Notes
</span>
</a>
</li>
<li class="toclevel-1 tocsection-5">
<a href="#References">
<span class="tocnumber">
5
</span>
<span class="toctext">
References
</span>
</a>
</li>
<li class="toclevel-1 tocsection-6">
<a href="#External_links">
<span class="tocnumber">
6
</span>
<span class="toctext">
External links
</span>
</a>
</li>
</ul>
</div>
<h2>
<span class="mw-headline" id="List_of_boroughs_and_local_authorities">
List of boroughs and local authorities
</span>
<span class="mw-editsection">
<span class="mw-editsection-bracket">
[
</span>
<a href="/w/index.php?title=List_of_London_boroughs&action=edit&section=1" title="Edit section: List of boroughs and local authorities">
edit
</a>
<span class="mw-editsection-bracket">
]
</span>
</span>
</h2>
<table class="wikitable sortable" style="font-size:100%" width="100%">
<tbody>
<tr>
<th>
Borough
</th>
<th>
Inner
</th>
<th>
Status
</th>
<th>
Local authority
</th>
<th>
Political control
</th>
<th>
Headquarters
</th>
<th>
Area (sq mi)
</th>
<th>
Population (2013 est)
<sup class="reference" id="cite_ref-1">
<a href="#cite_note-1">
[1]
</a>
</sup>
</th>
<th>
Co-ordinates
</th>
<th>
<span style="background:#67BCD3">
Nr. in map
</span>
</th>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Barking_and_Dagenham" title="London Borough of Barking and Dagenham">
Barking and Dagenham
</a>
<sup class="reference" id="cite_ref-2">
<a href="#cite_note-2">
[note 1]
</a>
</sup>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Barking_and_Dagenham_London_Borough_Council" title="Barking and Dagenham London Borough Council">
Barking and Dagenham London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Barking_Town_Hall&action=edit&redlink=1" title="Barking Town Hall (page does not exist)">
Town Hall
</a>
, 1 Town Square
</td>
<td>
13.93
</td>
<td>
194,352
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5607_N_0.1557_E_region:GB_type:city&title=Barking+and+Dagenham">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°33′39″N
</span>
<span class="longitude">
0°09′21″E
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5607°N 0.1557°E
</span>
<span style="display:none">
/
<span class="geo">
51.5607; 0.1557
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Barking and Dagenham
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
25
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Barnet" title="London Borough of Barnet">
Barnet
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Barnet_London_Borough_Council" title="Barnet London Borough Council">
Barnet London Borough Council
</a>
</td>
<td>
<a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">
Conservative
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=North_London_Business_Park&action=edit&redlink=1" title="North London Business Park (page does not exist)">
North London Business Park
</a>
, Oakleigh Road South
</td>
<td>
33.49
</td>
<td>
369,088
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.6252_N_0.1517_W_region:GB_type:city&title=Barnet">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°37′31″N
</span>
<span class="longitude">
0°09′06″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.6252°N 0.1517°W
</span>
<span style="display:none">
/
<span class="geo">
51.6252; -0.1517
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Barnet
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
31
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Bexley" title="London Borough of Bexley">
Bexley
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Bexley_London_Borough_Council" title="Bexley London Borough Council">
Bexley London Borough Council
</a>
</td>
<td>
<a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">
Conservative
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Civic_Offices&action=edit&redlink=1" title="Civic Offices (page does not exist)">
Civic Offices
</a>
, 2 Watling Street
</td>
<td>
23.38
</td>
<td>
236,687
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4549_N_0.1505_E_region:GB_type:city&title=Bexley">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°27′18″N
</span>
<span class="longitude">
0°09′02″E
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4549°N 0.1505°E
</span>
<span style="display:none">
/
<span class="geo">
51.4549; 0.1505
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Bexley
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
23
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Brent" title="London Borough of Brent">
Brent
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Brent_London_Borough_Council" title="Brent London Borough Council">
Brent London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a href="/wiki/Brent_Civic_Centre" title="Brent Civic Centre">
Brent Civic Centre
</a>
, Engineers Way
</td>
<td>
16.70
</td>
<td>
317,264
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5588_N_0.2817_W_region:GB_type:city&title=Brent">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°33′32″N
</span>
<span class="longitude">
0°16′54″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5588°N 0.2817°W
</span>
<span style="display:none">
/
<span class="geo">
51.5588; -0.2817
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Brent
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
12
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Bromley" title="London Borough of Bromley">
Bromley
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Bromley_London_Borough_Council" title="Bromley London Borough Council">
Bromley London Borough Council
</a>
</td>
<td>
<a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">
Conservative
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Bromley_Civic_Centre&action=edit&redlink=1" title="Bromley Civic Centre (page does not exist)">
Civic Centre
</a>
, Stockwell Close
</td>
<td>
57.97
</td>
<td>
317,899
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4039_N_0.0198_E_region:GB_type:city&title=Bromley">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°24′14″N
</span>
<span class="longitude">
0°01′11″E
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4039°N 0.0198°E
</span>
<span style="display:none">
/
<span class="geo">
51.4039; 0.0198
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Bromley
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
20
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Camden" title="London Borough of Camden">
Camden
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
</td>
<td>
<a href="/wiki/Camden_London_Borough_Council" title="Camden London Borough Council">
Camden London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a href="/wiki/Camden_Town_Hall" title="Camden Town Hall">
Camden Town Hall
</a>
, Judd Street
</td>
<td>
8.40
</td>
<td>
229,719
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.529_N_0.1255_W_region:GB_type:city&title=Camden">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°31′44″N
</span>
<span class="longitude">
0°07′32″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5290°N 0.1255°W
</span>
<span style="display:none">
/
<span class="geo">
51.5290; -0.1255
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Camden
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
11
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Croydon" title="London Borough of Croydon">
Croydon
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Croydon_London_Borough_Council" title="Croydon London Borough Council">
Croydon London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Bernard_Weatherill_House&action=edit&redlink=1" title="Bernard Weatherill House (page does not exist)">
Bernard Weatherill House
</a>
, Mint Walk
</td>
<td>
33.41
</td>
<td>
372,752
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.3714_N_0.0977_W_region:GB_type:city&title=Croydon">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°22′17″N
</span>
<span class="longitude">
0°05′52″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.3714°N 0.0977°W
</span>
<span style="display:none">
/
<span class="geo">
51.3714; -0.0977
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Croydon
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
19
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Ealing" title="London Borough of Ealing">
Ealing
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Ealing_London_Borough_Council" title="Ealing London Borough Council">
Ealing London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Perceval_House,_Ealing&action=edit&redlink=1" title="Perceval House, Ealing (page does not exist)">
Perceval House
</a>
, 14-16 Uxbridge Road
</td>
<td>
21.44
</td>
<td>
342,494
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.513_N_0.3089_W_region:GB_type:city&title=Ealing">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°30′47″N
</span>
<span class="longitude">
0°18′32″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5130°N 0.3089°W
</span>
<span style="display:none">
/
<span class="geo">
51.5130; -0.3089
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Ealing
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
13
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Enfield" title="London Borough of Enfield">
Enfield
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Enfield_London_Borough_Council" title="Enfield London Borough Council">
Enfield London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Enfield_Civic_Centre&action=edit&redlink=1" title="Enfield Civic Centre (page does not exist)">
Civic Centre
</a>
, Silver Street
</td>
<td>
31.74
</td>
<td>
320,524
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.6538_N_0.0799_W_region:GB_type:city&title=Enfield">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°39′14″N
</span>
<span class="longitude">
0°04′48″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.6538°N 0.0799°W
</span>
<span style="display:none">
/
<span class="geo">
51.6538; -0.0799
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Enfield
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
30
</td>
</tr>
<tr>
<td>
<a href="/wiki/Royal_Borough_of_Greenwich" title="Royal Borough of Greenwich">
Greenwich
</a>
<sup class="reference" id="cite_ref-3">
<a href="#cite_note-3">
[note 2]
</a>
</sup>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
<sup class="reference" id="cite_ref-note2_4-0">
<a href="#cite_note-note2-4">
[note 3]
</a>
</sup>
</td>
<td>
<a class="mw-redirect" href="/wiki/Royal_borough" title="Royal borough">
Royal
</a>
</td>
<td>
<a href="/wiki/Greenwich_London_Borough_Council" title="Greenwich London Borough Council">
Greenwich London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a href="/wiki/Woolwich_Town_Hall" title="Woolwich Town Hall">
Woolwich Town Hall
</a>
, Wellington Street
</td>
<td>
18.28
</td>
<td>
264,008
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4892_N_0.0648_E_region:GB_type:city&title=Greenwich">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°29′21″N
</span>
<span class="longitude">
0°03′53″E
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4892°N 0.0648°E
</span>
<span style="display:none">
/
<span class="geo">
51.4892; 0.0648
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Greenwich
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
22
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Hackney" title="London Borough of Hackney">
Hackney
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
</td>
<td>
<a href="/wiki/Hackney_London_Borough_Council" title="Hackney London Borough Council">
Hackney London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Hackney_Town_Hall&action=edit&redlink=1" title="Hackney Town Hall (page does not exist)">
Hackney Town Hall
</a>
, Mare Street
</td>
<td>
7.36
</td>
<td>
257,379
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.545_N_0.0553_W_region:GB_type:city&title=Hackney">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°32′42″N
</span>
<span class="longitude">
0°03′19″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5450°N 0.0553°W
</span>
<span style="display:none">
/
<span class="geo">
51.5450; -0.0553
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Hackney
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
9
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Hammersmith_and_Fulham" title="London Borough of Hammersmith and Fulham">
Hammersmith and Fulham
</a>
<sup class="reference" id="cite_ref-5">
<a href="#cite_note-5">
[note 4]
</a>
</sup>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
</td>
<td>
<a href="/wiki/Hammersmith_and_Fulham_London_Borough_Council" title="Hammersmith and Fulham London Borough Council">
Hammersmith and Fulham London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Hammersmith_and_Fulham_Town_Hall&action=edit&redlink=1" title="Hammersmith and Fulham Town Hall (page does not exist)">
Town Hall
</a>
, King Street
</td>
<td>
6.33
</td>
<td>
178,685
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4927_N_0.2339_W_region:GB_type:city&title=Hammersmith+and+Fulham">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°29′34″N
</span>
<span class="longitude">
0°14′02″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4927°N 0.2339°W
</span>
<span style="display:none">
/
<span class="geo">
51.4927; -0.2339
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Hammersmith and Fulham
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
4
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Haringey" title="London Borough of Haringey">
Haringey
</a>
</td>
<td>
<sup class="reference" id="cite_ref-note2_4-1">
<a href="#cite_note-note2-4">
[note 3]
</a>
</sup>
</td>
<td>
</td>
<td>
<a href="/wiki/Haringey_London_Borough_Council" title="Haringey London Borough Council">
Haringey London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Haringey_Civic_Centre&action=edit&redlink=1" title="Haringey Civic Centre (page does not exist)">
Civic Centre
</a>
, High Road
</td>
<td>
11.42
</td>
<td>
263,386
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.6_N_0.1119_W_region:GB_type:city&title=Haringey">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°36′00″N
</span>
<span class="longitude">
0°06′43″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.6000°N 0.1119°W
</span>
<span style="display:none">
/
<span class="geo">
51.6000; -0.1119
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Haringey
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
29
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Harrow" title="London Borough of Harrow">
Harrow
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Harrow_London_Borough_Council" title="Harrow London Borough Council">
Harrow London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Harrow_Civic_Centre&action=edit&redlink=1" title="Harrow Civic Centre (page does not exist)">
Civic Centre
</a>
, Station Road
</td>
<td>
19.49
</td>
<td>
243,372
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5898_N_0.3346_W_region:GB_type:city&title=Harrow">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°35′23″N
</span>
<span class="longitude">
0°20′05″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5898°N 0.3346°W
</span>
<span style="display:none">
/
<span class="geo">
51.5898; -0.3346
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Harrow
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
32
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Havering" title="London Borough of Havering">
Havering
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Havering_London_Borough_Council" title="Havering London Borough Council">
Havering London Borough Council
</a>
</td>
<td>
<a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">
Conservative
</a>
(council
<a href="/wiki/No_overall_control" title="No overall control">
NOC
</a>
)
</td>
<td>
<a class="new" href="/w/index.php?title=Havering_Town_Hall&action=edit&redlink=1" title="Havering Town Hall (page does not exist)">
Town Hall
</a>
, Main Road
</td>
<td>
43.35
</td>
<td>
242,080
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5812_N_0.1837_E_region:GB_type:city&title=Havering">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°34′52″N
</span>
<span class="longitude">
0°11′01″E
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5812°N 0.1837°E
</span>
<span style="display:none">
/
<span class="geo">
51.5812; 0.1837
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Havering
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
24
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Hillingdon" title="London Borough of Hillingdon">
Hillingdon
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Hillingdon_London_Borough_Council" title="Hillingdon London Borough Council">
Hillingdon London Borough Council
</a>
</td>
<td>
<a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">
Conservative
</a>
</td>
<td>
<a href="/wiki/Hillingdon_Civic_Centre" title="Hillingdon Civic Centre">
Civic Centre
</a>
, High Street
</td>
<td>
44.67
</td>
<td>
286,806
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5441_N_0.476_W_region:GB_type:city&title=Hillingdon">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°32′39″N
</span>
<span class="longitude">
0°28′34″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5441°N 0.4760°W
</span>
<span style="display:none">
/
<span class="geo">
51.5441; -0.4760
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Hillingdon
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
33
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Hounslow" title="London Borough of Hounslow">
Hounslow
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Hounslow_London_Borough_Council" title="Hounslow London Borough Council">
Hounslow London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
Hounslow House, 7 Bath Road
</td>
<td>
21.61
</td>
<td>
262,407
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4746_N_0.368_W_region:GB_type:city&title=Hounslow">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°28′29″N
</span>
<span class="longitude">
0°22′05″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4746°N 0.3680°W
</span>
<span style="display:none">
/
<span class="geo">
51.4746; -0.3680
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Hounslow
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
14
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Islington" title="London Borough of Islington">
Islington
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
</td>
<td>
<a href="/wiki/Islington_London_Borough_Council" title="Islington London Borough Council">
Islington London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Islington_Municipal_Offices&action=edit&redlink=1" title="Islington Municipal Offices (page does not exist)">
Municipal Offices
</a>
, 222 Upper Street
</td>
<td>
5.74
</td>
<td>
215,667
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5416_N_0.1022_W_region:GB_type:city&title=Islington">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°32′30″N
</span>
<span class="longitude">
0°06′08″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5416°N 0.1022°W
</span>
<span style="display:none">
/
<span class="geo">
51.5416; -0.1022
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Islington
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
10
</td>
</tr>
<tr>
<td>
<a href="/wiki/Royal_Borough_of_Kensington_and_Chelsea" title="Royal Borough of Kensington and Chelsea">
Kensington and Chelsea
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
<a class="mw-redirect" href="/wiki/Royal_borough" title="Royal borough">
Royal
</a>
</td>
<td>
<a href="/wiki/Kensington_and_Chelsea_London_Borough_Council" title="Kensington and Chelsea London Borough Council">
Kensington and Chelsea London Borough Council
</a>
</td>
<td>
<a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">
Conservative
</a>
</td>
<td>
<a href="/wiki/Kensington_Town_Hall,_London" title="Kensington Town Hall, London">
The Town Hall
</a>
,
<a href="/wiki/Hornton_Street" title="Hornton Street">
Hornton Street
</a>
</td>
<td>
4.68
</td>
<td>
155,594
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.502_N_0.1947_W_region:GB_type:city&title=Kensington+and+Chelsea">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°30′07″N
</span>
<span class="longitude">
0°11′41″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5020°N 0.1947°W
</span>
<span style="display:none">
/
<span class="geo">
51.5020; -0.1947
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Kensington and Chelsea
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
3
</td>
</tr>
<tr>
<td>
<a href="/wiki/Royal_Borough_of_Kingston_upon_Thames" title="Royal Borough of Kingston upon Thames">
Kingston upon Thames
</a>
</td>
<td>
</td>
<td>
<a class="mw-redirect" href="/wiki/Royal_borough" title="Royal borough">
Royal
</a>
</td>
<td>
<a href="/wiki/Kingston_upon_Thames_London_Borough_Council" title="Kingston upon Thames London Borough Council">
Kingston upon Thames London Borough Council
</a>
</td>
<td>
<a href="/wiki/Liberal_Democrats_(UK)" title="Liberal Democrats (UK)">
Liberal Democrat
</a>
</td>
<td>
<a href="/wiki/Kingston_upon_Thames_Guildhall" title="Kingston upon Thames Guildhall">
Guildhall
</a>
, High Street
</td>
<td>
14.38
</td>
<td>
166,793
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4085_N_0.3064_W_region:GB_type:city&title=Kingston+upon+Thames">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°24′31″N
</span>
<span class="longitude">
0°18′23″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4085°N 0.3064°W
</span>
<span style="display:none">
/
<span class="geo">
51.4085; -0.3064
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Kingston upon Thames
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
16
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Lambeth" title="London Borough of Lambeth">
Lambeth
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
</td>
<td>
<a href="/wiki/Lambeth_London_Borough_Council" title="Lambeth London Borough Council">
Lambeth London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a href="/wiki/Lambeth_Town_Hall" title="Lambeth Town Hall">
Lambeth Town Hall
</a>
, Brixton Hill
</td>
<td>
10.36
</td>
<td>
314,242
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4607_N_0.1163_W_region:GB_type:city&title=Lambeth">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°27′39″N
</span>
<span class="longitude">
0°06′59″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4607°N 0.1163°W
</span>
<span style="display:none">
/
<span class="geo">
51.4607; -0.1163
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Lambeth
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
6
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Lewisham" title="London Borough of Lewisham">
Lewisham
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
</td>
<td>
<a href="/wiki/Lewisham_London_Borough_Council" title="Lewisham London Borough Council">
Lewisham London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Lewisham_Town_Hall&action=edit&redlink=1" title="Lewisham Town Hall (page does not exist)">
Town Hall
</a>
, 1 Catford Road
</td>
<td>
13.57
</td>
<td>
286,180
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4452_N_0.0209_W_region:GB_type:city&title=Lewisham">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°26′43″N
</span>
<span class="longitude">
0°01′15″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4452°N 0.0209°W
</span>
<span style="display:none">
/
<span class="geo">
51.4452; -0.0209
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Lewisham
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
21
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Merton" title="London Borough of Merton">
Merton
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Merton_London_Borough_Council" title="Merton London Borough Council">
Merton London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Merton_Civic_Centre&action=edit&redlink=1" title="Merton Civic Centre (page does not exist)">
Civic Centre
</a>
, London Road
</td>
<td>
14.52
</td>
<td>
203,223
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4014_N_0.1958_W_region:GB_type:city&title=Merton">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°24′05″N
</span>
<span class="longitude">
0°11′45″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4014°N 0.1958°W
</span>
<span style="display:none">
/
<span class="geo">
51.4014; -0.1958
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Merton
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
17
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Newham" title="London Borough of Newham">
Newham
</a>
</td>
<td>
<sup class="reference" id="cite_ref-note2_4-2">
<a href="#cite_note-note2-4">
[note 3]
</a>
</sup>
</td>
<td>
</td>
<td>
<a href="/wiki/Newham_London_Borough_Council" title="Newham London Borough Council">
Newham London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Newham_Dockside&action=edit&redlink=1" title="Newham Dockside (page does not exist)">
Newham Dockside
</a>
, 1000 Dockside Road
</td>
<td>
13.98
</td>
<td>
318,227
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5077_N_0.0469_E_region:GB_type:city&title=Newham">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°30′28″N
</span>
<span class="longitude">
0°02′49″E
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5077°N 0.0469°E
</span>
<span style="display:none">
/
<span class="geo">
51.5077; 0.0469
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Newham
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
27
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Redbridge" title="London Borough of Redbridge">
Redbridge
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Redbridge_London_Borough_Council" title="Redbridge London Borough Council">
Redbridge London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Redbridge_Town_Hall&action=edit&redlink=1" title="Redbridge Town Hall (page does not exist)">
Town Hall
</a>
, 128-142 High Road
</td>
<td>
21.78
</td>
<td>
288,272
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.559_N_0.0741_E_region:GB_type:city&title=Redbridge">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°33′32″N
</span>
<span class="longitude">
0°04′27″E
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5590°N 0.0741°E
</span>
<span style="display:none">
/
<span class="geo">
51.5590; 0.0741
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Redbridge
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
26
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Richmond_upon_Thames" title="London Borough of Richmond upon Thames">
Richmond upon Thames
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Richmond_upon_Thames_London_Borough_Council" title="Richmond upon Thames London Borough Council">
Richmond upon Thames London Borough Council
</a>
</td>
<td>
<a href="/wiki/Liberal_Democrats_(UK)" title="Liberal Democrats (UK)">
Liberal Democrat
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Richmond_upon_Thames_Civic_Centre&action=edit&redlink=1" title="Richmond upon Thames Civic Centre (page does not exist)">
Civic Centre
</a>
, 44 York Street
</td>
<td>
22.17
</td>
<td>
191,365
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4479_N_0.326_W_region:GB_type:city&title=Richmond+upon+Thames">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°26′52″N
</span>
<span class="longitude">
0°19′34″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4479°N 0.3260°W
</span>
<span style="display:none">
/
<span class="geo">
51.4479; -0.3260
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Richmond upon Thames
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
15
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Southwark" title="London Borough of Southwark">
Southwark
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
</td>
<td>
<a href="/wiki/Southwark_London_Borough_Council" title="Southwark London Borough Council">
Southwark London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=160_Tooley_Street&action=edit&redlink=1" title="160 Tooley Street (page does not exist)">
160 Tooley Street
</a>
</td>
<td>
11.14
</td>
<td>
298,464
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5035_N_0.0804_W_region:GB_type:city&title=Southwark">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°30′13″N
</span>
<span class="longitude">
0°04′49″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5035°N 0.0804°W
</span>
<span style="display:none">
/
<span class="geo">
51.5035; -0.0804
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Southwark
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
7
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Sutton" title="London Borough of Sutton">
Sutton
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Sutton_London_Borough_Council" title="Sutton London Borough Council">
Sutton London Borough Council
</a>
</td>
<td>
<a href="/wiki/Liberal_Democrats_(UK)" title="Liberal Democrats (UK)">
Liberal Democrat
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Sutton_Civic_Offices&action=edit&redlink=1" title="Sutton Civic Offices (page does not exist)">
Civic Offices
</a>
, St Nicholas Way
</td>
<td>
16.93
</td>
<td>
195,914
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.3618_N_0.1945_W_region:GB_type:city&title=Sutton">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°21′42″N
</span>
<span class="longitude">
0°11′40″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.3618°N 0.1945°W
</span>
<span style="display:none">
/
<span class="geo">
51.3618; -0.1945
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Sutton
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
18
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Tower_Hamlets" title="London Borough of Tower Hamlets">
Tower Hamlets
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
</td>
<td>
<a href="/wiki/Tower_Hamlets_London_Borough_Council" title="Tower Hamlets London Borough Council">
Tower Hamlets London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Tower_Hamlets_Town_Hall&action=edit&redlink=1" title="Tower Hamlets Town Hall (page does not exist)">
Town Hall
</a>
, Mulberry Place, 5 Clove Crescent
</td>
<td>
7.63
</td>
<td>
272,890
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5099_N_0.0059_W_region:GB_type:city&title=Tower+Hamlets">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°30′36″N
</span>
<span class="longitude">
0°00′21″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5099°N 0.0059°W
</span>
<span style="display:none">
/
<span class="geo">
51.5099; -0.0059
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Tower Hamlets
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
8
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Waltham_Forest" title="London Borough of Waltham Forest">
Waltham Forest
</a>
</td>
<td>
</td>
<td>
</td>
<td>
<a href="/wiki/Waltham_Forest_London_Borough_Council" title="Waltham Forest London Borough Council">
Waltham Forest London Borough Council
</a>
</td>
<td>
<a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">
Labour
</a>
</td>
<td>
<a href="/wiki/Waltham_Forest_Town_Hall" title="Waltham Forest Town Hall">
Waltham Forest Town Hall
</a>
, Forest Road
</td>
<td>
14.99
</td>
<td>
265,797
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5908_N_0.0134_W_region:GB_type:city&title=Waltham+Forest">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°35′27″N
</span>
<span class="longitude">
0°00′48″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5908°N 0.0134°W
</span>
<span style="display:none">
/
<span class="geo">
51.5908; -0.0134
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Waltham Forest
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
28
</td>
</tr>
<tr>
<td>
<a href="/wiki/London_Borough_of_Wandsworth" title="London Borough of Wandsworth">
Wandsworth
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
</td>
<td>
<a href="/wiki/Wandsworth_London_Borough_Council" title="Wandsworth London Borough Council">
Wandsworth London Borough Council
</a>
</td>
<td>
<a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">
Conservative
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Wandsworth_Town_Hall&action=edit&redlink=1" title="Wandsworth Town Hall (page does not exist)">
The Town Hall
</a>
,
<a href="/wiki/Wandsworth_High_Street" title="Wandsworth High Street">
Wandsworth High Street
</a>
</td>
<td>
13.23
</td>
<td>
310,516
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4567_N_0.191_W_region:GB_type:city&title=Wandsworth">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°27′24″N
</span>
<span class="longitude">
0°11′28″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4567°N 0.1910°W
</span>
<span style="display:none">
/
<span class="geo">
51.4567; -0.1910
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Wandsworth
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
5
</td>
</tr>
<tr>
<td>
<a href="/wiki/City_of_Westminster" title="City of Westminster">
Westminster
</a>
</td>
<td>
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
</td>
<td>
<a href="/wiki/City_status_in_the_United_Kingdom" title="City status in the United Kingdom">
City
</a>
</td>
<td>
<a href="/wiki/Westminster_City_Council" title="Westminster City Council">
Westminster City Council
</a>
</td>
<td>
<a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">
Conservative
</a>
</td>
<td>
<a class="new" href="/w/index.php?title=Westminster_City_Hall&action=edit&redlink=1" title="Westminster City Hall (page does not exist)">
Westminster City Hall
</a>
, 64 Victoria Street
</td>
<td>
8.29
</td>
<td>
226,841
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4973_N_0.1372_W_region:GB_type:city&title=Westminster">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°29′50″N
</span>
<span class="longitude">
0°08′14″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.4973°N 0.1372°W
</span>
<span style="display:none">
/
<span class="geo">
51.4973; -0.1372
</span>
</span>
<span style="display:none">
(
<span class="fn org">
Westminster
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
2
</td>
</tr>
</tbody>
</table>
<h2>
<span class="mw-headline" id="City_of_London">
City of London
</span>
<span class="mw-editsection">
<span class="mw-editsection-bracket">
[
</span>
<a href="/w/index.php?title=List_of_London_boroughs&action=edit&section=2" title="Edit section: City of London">
edit
</a>
<span class="mw-editsection-bracket">
]
</span>
</span>
</h2>
<p>
The
<a href="/wiki/City_of_London" title="City of London">
City of London
</a>
is the 33rd principal division of Greater London but it is not a London borough.
</p>
<table class="wikitable sortable" style="font-size:95%" width="100%">
<tbody>
<tr>
<th width="100px">
Borough
</th>
<th>
Inner
</th>
<th width="100px">
Status
</th>
<th>
Local authority
</th>
<th>
Political control
</th>
<th width="120px">
Headquarters
</th>
<th>
Area (sq mi)
</th>
<th>
Population
<br/>
(2011 est)
</th>
<th width="20px">
Co-ordinates
</th>
<th>
<span style="background:#67BCD3">
Nr. in
<br/>
map
</span>
</th>
</tr>
<tr>
<td>
<a href="/wiki/City_of_London" title="City of London">
City of London
</a>
</td>
<td>
(
<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/>
<span style="display:none">
Y
</span>
)
<br/>
<sup class="reference" id="cite_ref-6">
<a href="#cite_note-6">
[note 5]
</a>
</sup>
</td>
<td>
<i>
<a href="/wiki/Sui_generis" title="Sui generis">
Sui generis
</a>
</i>
;
<br/>
<a href="/wiki/City_status_in_the_United_Kingdom" title="City status in the United Kingdom">
City
</a>
;
<br/>
<a href="/wiki/Ceremonial_counties_of_England" title="Ceremonial counties of England">
Ceremonial county
</a>
</td>
<td>
<a class="mw-redirect" href="/wiki/Corporation_of_London" title="Corporation of London">
Corporation of London
</a>
;
<br/>
<a href="/wiki/Inner_Temple" title="Inner Temple">
Inner Temple
</a>
;
<br/>
<a href="/wiki/Middle_Temple" title="Middle Temple">
Middle Temple
</a>
</td>
<td>
?
</td>
<td>
<a href="/wiki/Guildhall,_London" title="Guildhall, London">
Guildhall
</a>
</td>
<td>
1.12
</td>
<td>
7,000
</td>
<td>
<span class="plainlinks nourlexpansion">
<a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5155_N_0.0922_W_region:GB_type:city&title=City+of+London">
<span class="geo-nondefault">
<span class="geo-dms" title="Maps, aerial photos, and other data for this location">
<span class="latitude">
51°30′56″N
</span>
<span class="longitude">
0°05′32″W
</span>
</span>
</span>
<span class="geo-multi-punct">
/
</span>
<span class="geo-default">
<span class="vcard">
<span class="geo-dec" title="Maps, aerial photos, and other data for this location">
51.5155°N 0.0922°W
</span>
<span style="display:none">
/
<span class="geo">
51.5155; -0.0922
</span>
</span>
<span style="display:none">
(
<span class="fn org">
City of London
</span>
)
</span>
</span>
</span>
</a>
</span>
</td>
<td>
1
</td>
</tr>
</tbody>
</table>
<table class="noprint infobox" id="GeoGroup" style="width: 23em; font-size: 88%; line-height: 1.5em">
<tbody>
<tr>
<td>
<b>
Map all coordinates using:
</b>
<a class="external text" href="//tools.wmflabs.org/osm4wiki/cgi-bin/wiki/wiki-osm.pl?project=en&article=List_of_London_boroughs">
OpenStreetMap
</a>
</td>
</tr>
<tr>
<td>
<b>
Download coordinates as:
</b>
<a class="external text" href="//tools.wmflabs.org/kmlexport?article=List_of_London_boroughs">
KML
</a>
<b>
·
</b>
<a class="external text" href="http://tripgang.com/kml2gpx/http%3A%2F%2Ftools.wmflabs.org%2Fkmlexport%3Farticle%3DList_of_London_boroughs?gpx=1" rel="nofollow">
GPX
</a>
</td>
</tr>
</tbody>
</table>
<h2>
<span class="mw-headline" id="See_also">
See also
</span>
<span class="mw-editsection">
<span class="mw-editsection-bracket">
[
</span>
<a href="/w/index.php?title=List_of_London_boroughs&action=edit&section=3" title="Edit section: See also">
edit
</a>
<span class="mw-editsection-bracket">
]
</span>
</span>
</h2>
<ul>
<li>
<a class="mw-redirect" href="/wiki/Political_make-up_of_London_borough_councils" title="Political make-up of London borough councils">
Political make-up of London borough councils
</a>
</li>
<li>
<a href="/wiki/List_of_areas_of_London" title="List of areas of London">
List of areas of London
</a>
</li>
<li>
<a href="/wiki/Subdivisions_of_England" title="Subdivisions of England">
Subdivisions of England
</a>
</li>
</ul>
<h2>
<span class="mw-headline" id="Notes">
Notes
</span>
<span class="mw-editsection">
<span class="mw-editsection-bracket">
[
</span>
<a href="/w/index.php?title=List_of_London_boroughs&action=edit&section=4" title="Edit section: Notes">
edit
</a>
<span class="mw-editsection-bracket">
]
</span>
</span>
</h2>
<div class="reflist" style="list-style-type: decimal;">
<div class="mw-references-wrap">
<ol class="references">
<li id="cite_note-2">
<span class="mw-cite-backlink">
<b>
<a href="#cite_ref-2">
^
</a>
</b>
</span>
<span class="reference-text">
Renamed from London Borough of Barking 1 January 1980.
<cite class="citation magazine" id="CITEREFGazette48021">
<a class="external text" href="https://www.thegazette.co.uk/London/issue/48021/page/15280" rel="nofollow">
"No. 48021"
</a>
.
<i>
<a href="/wiki/The_London_Gazette" title="The London Gazette">
The London Gazette
</a>
</i>
. 4 December 1979. p. 15280.
</cite>
<span class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.jtitle=The+London+Gazette&rft.atitle=No.+48021&rft.pages=15280&rft.date=1979-12-04&rft_id=https%3A%2F%2Fwww.thegazette.co.uk%2FLondon%2Fissue%2F48021%2Fpage%2F15280&rfr_id=info%3Asid%2Fen.wikipedia.org%3AList+of+London+boroughs"/>
<style data-mw-deduplicate="TemplateStyles:r935243608">
.mw-parser-output cite.citation{font-style:inherit}.mw-parser-output .citation q{quotes:"\"""\"""'""'"}.mw-parser-output .id-lock-free a,.mw-parser-output .citation .cs1-lock-free a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/6/65/Lock-green.svg/9px-Lock-green.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output .id-lock-limited a,.mw-parser-output .id-lock-registration a,.mw-parser-output .citation .cs1-lock-limited a,.mw-parser-output .citation .cs1-lock-registration a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/d/d6/Lock-gray-alt-2.svg/9px-Lock-gray-alt-2.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output .id-lock-subscription a,.mw-parser-output .citation .cs1-lock-subscription a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/a/aa/Lock-red-alt-2.svg/9px-Lock-red-alt-2.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output .cs1-subscription,.mw-parser-output .cs1-registration{color:#555}.mw-parser-output .cs1-subscription span,.mw-parser-output .cs1-registration span{border-bottom:1px dotted;cursor:help}.mw-parser-output .cs1-ws-icon a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/4/4c/Wikisource-logo.svg/12px-Wikisource-logo.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output code.cs1-code{color:inherit;background:inherit;border:inherit;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;font-size:100%}.mw-parser-output .cs1-visible-error{font-size:100%}.mw-parser-output .cs1-maint{display:none;color:#33aa33;margin-left:0.3em}.mw-parser-output .cs1-subscription,.mw-parser-output .cs1-registration,.mw-parser-output .cs1-format{font-size:95%}.mw-parser-output .cs1-kern-left,.mw-parser-output .cs1-kern-wl-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right,.mw-parser-output .cs1-kern-wl-right{padding-right:0.2em}
</style>
</span>
</li>
<li id="cite_note-3">
<span class="mw-cite-backlink">
<b>
<a href="#cite_ref-3">
^
</a>
</b>
</span>
<span class="reference-text">
Royal borough from 2012
</span>
</li>
<li id="cite_note-note2-4">
<span class="mw-cite-backlink">
^
<a href="#cite_ref-note2_4-0">
<sup>
<i>
<b>
a
</b>
</i>
</sup>
</a>
<a href="#cite_ref-note2_4-1">
<sup>
<i>
<b>
b
</b>
</i>
</sup>
</a>
<a href="#cite_ref-note2_4-2">
<sup>
<i>
<b>
c
</b>
</i>
</sup>
</a>
</span>
<span class="reference-text">
Haringey and Newham are Inner London for statistics; Greenwich is Outer London for statistics
</span>
</li>
<li id="cite_note-5">
<span class="mw-cite-backlink">
<b>
<a href="#cite_ref-5">
^
</a>
</b>
</span>
<span class="reference-text">
Renamed from London Borough of Hammersmith 1 April 1979.
<cite class="citation magazine" id="CITEREFGazette47771">
<a class="external text" href="https://www.thegazette.co.uk/London/issue/47771/page/2095" rel="nofollow">
"No. 47771"
</a>
.
<i>
<a href="/wiki/The_London_Gazette" title="The London Gazette">
The London Gazette
</a>
</i>
. 13 February 1979. p. 2095.
</cite>
<span class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.jtitle=The+London+Gazette&rft.atitle=No.+47771&rft.pages=2095&rft.date=1979-02-13&rft_id=https%3A%2F%2Fwww.thegazette.co.uk%2FLondon%2Fissue%2F47771%2Fpage%2F2095&rfr_id=info%3Asid%2Fen.wikipedia.org%3AList+of+London+boroughs"/>
<link href="mw-data:TemplateStyles:r935243608" rel="mw-deduplicated-inline-style"/>
</span>
</li>
<li id="cite_note-6">
<span class="mw-cite-backlink">
<b>
<a href="#cite_ref-6">
^
</a>
</b>
</span>
<span class="reference-text">
The City of London was not part of the
<a href="/wiki/County_of_London" title="County of London">
County of London
</a>
and is not a London Borough but can be counted to
<a href="/wiki/Inner_London" title="Inner London">
Inner London
</a>
.
</span>
</li>
</ol>
</div>
</div>
<h2>
<span class="mw-headline" id="References">
References
</span>
<span class="mw-editsection">
<span class="mw-editsection-bracket">
[
</span>
<a href="/w/index.php?title=List_of_London_boroughs&action=edit&section=5" title="Edit section: References">
edit
</a>
<span class="mw-editsection-bracket">
]
</span>
</span>
</h2>
<div class="reflist" style="list-style-type: decimal;">
<div class="mw-references-wrap">
<ol class="references">
<li id="cite_note-1">
<span class="mw-cite-backlink">
<b>
<a href="#cite_ref-1">
^
</a>
</b>
</span>
<span class="reference-text">
<cite class="citation web">
ONS (2 July 2010).
<a class="external text" href="https://webarchive.nationalarchives.gov.uk/20160107070948/http://www.ons.gov.uk/ons/publications/re-reference-tables.html" rel="nofollow">
"Release Edition Reference Tables"
</a>
.
<i>
Webarchive.nationalarchives.gov.uk
</i>
<span class="reference-accessdate">
. Retrieved
<span class="nowrap">
5 February
</span>
2019
</span>
.
</cite>
<span class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=unknown&rft.jtitle=Webarchive.nationalarchives.gov.uk&rft.atitle=Release+Edition+Reference+Tables&rft.date=2010-07-02&rft.au=ONS&rft_id=https%3A%2F%2Fwebarchive.nationalarchives.gov.uk%2F20160107070948%2Fhttp%3A%2F%2Fwww.ons.gov.uk%2Fons%2Fpublications%2Fre-reference-tables.html&rfr_id=info%3Asid%2Fen.wikipedia.org%3AList+of+London+boroughs"/>
<link href="mw-data:TemplateStyles:r935243608" rel="mw-deduplicated-inline-style"/>
</span>
</li>
</ol>
</div>
</div>
<h2>
<span class="mw-headline" id="External_links">
External links
</span>
<span class="mw-editsection">
<span class="mw-editsection-bracket">
[
</span>
<a href="/w/index.php?title=List_of_London_boroughs&action=edit&section=6" title="Edit section: External links">
edit
</a>
<span class="mw-editsection-bracket">
]
</span>
</span>
</h2>
<ul>
<li>
<a class="external text" href="https://web.archive.org/web/20101010011530/http://londoncouncils.gov.uk/londonlocalgovernment/londonboroughs.htm" rel="nofollow">
London Councils: List of inner/outer London boroughs
</a>
</li>
<li>
<a class="external text" href="http://londonboroughsmap.co.uk/" rel="nofollow">
London Boroughs Map
</a>
</li>
</ul>
<div aria-labelledby="Governance_of_Greater_London" class="navbox" role="navigation" style="padding:3px">
<table class="nowraplinks hlist mw-collapsible mw-collapsed navbox-inner" style="border-spacing:0;background:transparent;color:inherit">
<tbody>
<tr>
<th class="navbox-title" colspan="2" scope="col">
<div class="plainlinks hlist navbar mini">
<ul>
<li class="nv-view">
<a href="/wiki/Template:Governance_of_Greater_London" title="Template:Governance of Greater London">
<abbr style=";;background:none transparent;border:none;-moz-box-shadow:none;-webkit-box-shadow:none;box-shadow:none; padding:0;" title="View this template">
v
</abbr>
</a>
</li>
<li class="nv-talk">
<a href="/wiki/Template_talk:Governance_of_Greater_London" title="Template talk:Governance of Greater London">
<abbr style=";;background:none transparent;border:none;-moz-box-shadow:none;-webkit-box-shadow:none;box-shadow:none; padding:0;" title="Discuss this template">
t
</abbr>
</a>
</li>
<li class="nv-edit">
<a class="external text" href="https://en.wikipedia.org/w/index.php?title=Template:Governance_of_Greater_London&action=edit">
<abbr style=";;background:none transparent;border:none;-moz-box-shadow:none;-webkit-box-shadow:none;box-shadow:none; padding:0;" title="Edit this template">
e
</abbr>
</a>
</li>
</ul>
</div>
<div id="Governance_of_Greater_London" style="font-size:114%;margin:0 4em">
Governance of
<a href="/wiki/Greater_London" title="Greater London">
Greater London
</a>
</div>
</th>
</tr>
<tr>
<td class="navbox-abovebelow" colspan="2">
<div id="*_City_of_London&#10;*_London">
<ul>
<li>
<a href="/wiki/City_of_London" title="City of London">
City of London
</a>
</li>
<li>
<a href="/wiki/London" title="London">
London
</a>
</li>
</ul>
</div>
</td>
</tr>
<tr>
<th class="navbox-group" scope="row" style="width:1%">
Regional
</th>
<td class="navbox-list navbox-odd" style="text-align:left;border-left-width:2px;border-left-style:solid;width:100%;padding:0px">
<div style="padding:0em 0.25em">
<ul>
<li>
<b>
<a href="/wiki/Greater_London_Authority" title="Greater London Authority">
Greater London Authority
</a>
:
</b>
<a href="/wiki/London_Assembly" title="London Assembly">
London Assembly
</a>
</li>
<li>
<a href="/wiki/Mayor_of_London" title="Mayor of London">
Mayor of London
</a>
</li>
</ul>
</div>
</td>
</tr>
<tr>
<th class="navbox-group" scope="row" style="width:1%">
<a href="/wiki/London_boroughs" title="London boroughs">
Boroughs
</a>
<br/>
(
<a class="mw-selflink selflink">
list
</a>
)
</th>
<td class="navbox-list navbox-even" style="text-align:left;border-left-width:2px;border-left-style:solid;width:100%;padding:0px">
<div style="padding:0em 0.25em">
<ul>
<li>
<b>
<a href="/wiki/London_Councils" title="London Councils">
London Councils
</a>
:
</b>
<a href="/wiki/London_Borough_of_Barking_and_Dagenham" title="London Borough of Barking and Dagenham">
Barking and Dagenham
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Barnet" title="London Borough of Barnet">
Barnet
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Bexley" title="London Borough of Bexley">
Bexley
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Brent" title="London Borough of Brent">
Brent
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Bromley" title="London Borough of Bromley">
Bromley
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Camden" title="London Borough of Camden">
Camden
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Croydon" title="London Borough of Croydon">
Croydon
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Ealing" title="London Borough of Ealing">
Ealing
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Enfield" title="London Borough of Enfield">
Enfield
</a>
</li>
<li>
<a href="/wiki/Royal_Borough_of_Greenwich" title="Royal Borough of Greenwich">
Greenwich
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Hackney" title="London Borough of Hackney">
Hackney
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Hammersmith_and_Fulham" title="London Borough of Hammersmith and Fulham">
Hammersmith and Fulham
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Haringey" title="London Borough of Haringey">
Haringey
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Harrow" title="London Borough of Harrow">
Harrow
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Havering" title="London Borough of Havering">
Havering
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Hillingdon" title="London Borough of Hillingdon">
Hillingdon
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Hounslow" title="London Borough of Hounslow">
Hounslow
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Islington" title="London Borough of Islington">
Islington
</a>
</li>
<li>
<a href="/wiki/Royal_Borough_of_Kensington_and_Chelsea" title="Royal Borough of Kensington and Chelsea">
Kensington and Chelsea
</a>
</li>
<li>
<a href="/wiki/Royal_Borough_of_Kingston_upon_Thames" title="Royal Borough of Kingston upon Thames">
Kingston upon Thames
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Lambeth" title="London Borough of Lambeth">
Lambeth
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Lewisham" title="London Borough of Lewisham">
Lewisham
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Merton" title="London Borough of Merton">
Merton
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Newham" title="London Borough of Newham">
Newham
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Redbridge" title="London Borough of Redbridge">
Redbridge
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Richmond_upon_Thames" title="London Borough of Richmond upon Thames">
Richmond upon Thames
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Southwark" title="London Borough of Southwark">
Southwark
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Sutton" title="London Borough of Sutton">
Sutton
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Tower_Hamlets" title="London Borough of Tower Hamlets">
Tower Hamlets
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Waltham_Forest" title="London Borough of Waltham Forest">
Waltham Forest
</a>
</li>
<li>
<a href="/wiki/London_Borough_of_Wandsworth" title="London Borough of Wandsworth">
Wandsworth
</a>
</li>
<li>
<a href="/wiki/City_of_Westminster" title="City of Westminster">
Westminster
</a>
</li>
</ul>
</div>
</td>
</tr>
<tr>
<th class="navbox-group" scope="row" style="width:1%">
Ceremonial
</th>
<td class="navbox-list navbox-odd" style="text-align:left;border-left-width:2px;border-left-style:solid;width:100%;padding:0px">
<div style="padding:0em 0.25em">
<ul>
<li>
<a href="/wiki/Lord_Mayor_of_London" title="Lord Mayor of London">
Lord Mayor of the City of London
</a>
</li>
<li>
<a class="mw-redirect" href="/wiki/Lord_Lieutenant_of_Greater_London" title="Lord Lieutenant of Greater London">
Lord Lieutenant of Greater London
</a>
</li>
<li>
<a href="/wiki/High_Sheriff_of_Greater_London" title="High Sheriff of Greater London">
High Sheriff of Greater London
</a>
</li>
</ul>
</div>
</td>
</tr>
<tr>
<th class="navbox-group" scope="row" style="width:1%">
<a href="/wiki/History_of_local_government_in_London" title="History of local government in London">
Historical
</a>
</th>
<td class="navbox-list navbox-even" style="text-align:left;border-left-width:2px;border-left-style:solid;width:100%;padding:0px">
<div style="padding:0em 0.25em">
<ul>
<li>
<a href="/wiki/Metropolitan_Board_of_Works" title="Metropolitan Board of Works">
Metropolitan Board of Works
</a>
<span style="font-size:85%;">
(MBW) 1855–1889
</span>
</li>
<li>
<a href="/wiki/London_County_Council" title="London County Council">
London County Council
</a>
<span style="font-size:85%;">
(LCC) 1889–1965
</span>
</li>
<li>
<a href="/wiki/Greater_London_Council" title="Greater London Council">
Greater London Council
</a>
<span style="font-size:85%;">
(GLC) 1965–1986
</span>
</li>
<li>
<a href="/wiki/List_of_heads_of_London_government" title="List of heads of London government">
Leaders
</a>
</li>
<li>
<a href="/wiki/Sheriffs_of_the_City_of_London" title="Sheriffs of the City of London">
Sheriffs of the City of London
</a>
</li>
</ul>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<!--
NewPP limit report
Parsed by mw1330
Cached time: 20200311193737
Cache expiry: 2592000
Dynamic content: false
Complications: [vary‐revision‐sha1]
CPU time usage: 0.356 seconds
Real time usage: 0.442 seconds
Preprocessor visited node count: 5140/1000000
Post‐expand include size: 79370/2097152 bytes
Template argument size: 1081/2097152 bytes
Highest expansion depth: 13/40
Expensive parser function count: 2/500
Unstrip recursion depth: 1/20
Unstrip post‐expand size: 10566/5000000 bytes
Number of Wikibase entities loaded: 0/400
Lua time usage: 0.109/10.000 seconds
Lua memory usage: 3.11 MB/50 MB
-->
<!--
Transclusion expansion time report (%,ms,calls,template)
100.00% 301.212 1 -total
38.94% 117.279 2 Template:Reflist
32.47% 97.807 2 Template:London_Gazette
30.53% 91.950 2 Template:Cite_magazine
19.10% 57.526 33 Template:Coord
12.97% 39.078 1 Template:Use_dmy_dates
10.87% 32.731 33 Template:English_district_control
7.42% 22.349 1 Template:London
5.55% 16.731 2 Template:DMCA
5.23% 15.756 1 Template:Navbox
-->
<!-- Saved in parser cache with key enwiki:pcache:idhash:28092685-0!canonical and timestamp 20200311193736 and revision id 943613985
-->
</div>
<noscript>
<img alt="" height="1" src="//en.wikipedia.org/wiki/Special:CentralAutoLogin/start?type=1x1" style="border: none; position: absolute;" title="" width="1"/>
</noscript>
</div>
<div class="printfooter">
Retrieved from "
<a dir="ltr" href="https://en.wikipedia.org/w/index.php?title=List_of_London_boroughs&oldid=943613985">
https://en.wikipedia.org/w/index.php?title=List_of_London_boroughs&oldid=943613985
</a>
"
</div>
<div class="catlinks" data-mw="interface" id="catlinks">
<div class="mw-normal-catlinks" id="mw-normal-catlinks">
<a href="/wiki/Help:Category" title="Help:Category">
Categories
</a>
:
<ul>
<li>
<a href="/wiki/Category:London_boroughs" title="Category:London boroughs">
London boroughs
</a>
</li>
<li>
<a href="/wiki/Category:Lists_of_places_in_London" title="Category:Lists of places in London">
Lists of places in London
</a>
</li>
</ul>
</div>
<div class="mw-hidden-catlinks mw-hidden-cats-hidden" id="mw-hidden-catlinks">
Hidden categories:
<ul>
<li>
<a href="/wiki/Category:Use_dmy_dates_from_August_2015" title="Category:Use dmy dates from August 2015">
Use dmy dates from August 2015
</a>
</li>
<li>
<a href="/wiki/Category:Use_British_English_from_August_2015" title="Category:Use British English from August 2015">
Use British English from August 2015
</a>
</li>
<li>
<a href="/wiki/Category:Lists_of_coordinates" title="Category:Lists of coordinates">
Lists of coordinates
</a>
</li>
<li>
<a href="/wiki/Category:Geographic_coordinate_lists" title="Category:Geographic coordinate lists">
Geographic coordinate lists
</a>
</li>
<li>
<a href="/wiki/Category:Articles_with_Geo" title="Category:Articles with Geo">
Articles with Geo
</a>
</li>
</ul>
</div>
</div>
<div class="visualClear"/>
</div>
</div>
<div id="mw-data-after-content">
<div class="read-more-container"/>
</div>
<div id="mw-navigation">
<h2>
Navigation menu
</h2>
<div id="mw-head">
<div aria-labelledby="p-personal-label" class="" id="p-personal" role="navigation">
<h3 id="p-personal-label">
Personal tools
</h3>
<ul>
<li id="pt-anonuserpage">
Not logged in
</li>
<li id="pt-anontalk">
<a accesskey="n" href="/wiki/Special:MyTalk" title="Discussion about edits from this IP address [n]">
Talk
</a>
</li>
<li id="pt-anoncontribs">
<a accesskey="y" href="/wiki/Special:MyContributions" title="A list of edits made from this IP address [y]">
Contributions
</a>
</li>
<li id="pt-createaccount">
<a href="/w/index.php?title=Special:CreateAccount&returnto=List+of+London+boroughs" title="You are encouraged to create an account and log in; however, it is not mandatory">
Create account
</a>
</li>
<li id="pt-login">
<a accesskey="o" href="/w/index.php?title=Special:UserLogin&returnto=List+of+London+boroughs" title="You're encouraged to log in; however, it's not mandatory. [o]">
Log in
</a>
</li>
</ul>
</div>
<div id="left-navigation">
<div aria-labelledby="p-namespaces-label" class="vectorTabs " id="p-namespaces" role="navigation">
<h3 id="p-namespaces-label">
Namespaces
</h3>
<ul>
<li class="selected" id="ca-nstab-main">
<a accesskey="c" href="/wiki/List_of_London_boroughs" title="View the content page [c]">
Article
</a>
</li>
<li id="ca-talk">
<a accesskey="t" href="/wiki/Talk:List_of_London_boroughs" rel="discussion" title="Discussion about the content page [t]">
Talk
</a>
</li>
</ul>
</div>
<div aria-labelledby="p-variants-label" class="vectorMenu emptyPortlet" id="p-variants" role="navigation">
<input aria-labelledby="p-variants-label" class="vectorMenuCheckbox" type="checkbox"/>
<h3 id="p-variants-label">
<span>
Variants
</span>
</h3>
<ul class="menu">
</ul>
</div>
</div>
<div id="right-navigation">
<div aria-labelledby="p-views-label" class="vectorTabs " id="p-views" role="navigation">
<h3 id="p-views-label">
Views
</h3>
<ul>
<li class="collapsible selected" id="ca-view">
<a href="/wiki/List_of_London_boroughs">
Read
</a>
</li>
<li class="collapsible" id="ca-edit">
<a accesskey="e" href="/w/index.php?title=List_of_London_boroughs&action=edit" title="Edit this page [e]">
Edit
</a>
</li>
<li class="collapsible" id="ca-history">
<a accesskey="h" href="/w/index.php?title=List_of_London_boroughs&action=history" title="Past revisions of this page [h]">
View history
</a>
</li>
</ul>
</div>
<div aria-labelledby="p-cactions-label" class="vectorMenu emptyPortlet" id="p-cactions" role="navigation">
<input aria-labelledby="p-cactions-label" class="vectorMenuCheckbox" type="checkbox"/>
<h3 id="p-cactions-label">
<span>
More
</span>
</h3>
<ul class="menu">
</ul>
</div>
<div id="p-search" role="search">
<h3>
<label for="searchInput">
Search
</label>
</h3>
<form action="/w/index.php" id="searchform">
<div id="simpleSearch">
<input accesskey="f" id="searchInput" name="search" placeholder="Search Wikipedia" title="Search Wikipedia [f]" type="search"/>
<input name="title" type="hidden" value="Special:Search"/>
<input class="searchButton mw-fallbackSearchButton" id="mw-searchButton" name="fulltext" title="Search Wikipedia for this text" type="submit" value="Search"/>
<input class="searchButton" id="searchButton" name="go" title="Go to a page with this exact name if it exists" type="submit" value="Go"/>
</div>
</form>
</div>
</div>
</div>
<div id="mw-panel">
<div id="p-logo" role="banner">
<a class="mw-wiki-logo" href="/wiki/Main_Page" title="Visit the main page"/>
</div>
<div aria-labelledby="p-navigation-label" class="portal" id="p-navigation" role="navigation">
<h3 id="p-navigation-label">
Navigation
</h3>
<div class="body">
<ul>
<li id="n-mainpage-description">
<a accesskey="z" href="/wiki/Main_Page" title="Visit the main page [z]">
Main page
</a>
</li>
<li id="n-contents">
<a href="/wiki/Wikipedia:Contents" title="Guides to browsing Wikipedia">
Contents
</a>
</li>
<li id="n-featuredcontent">
<a href="/wiki/Wikipedia:Featured_content" title="Featured content – the best of Wikipedia">
Featured content
</a>
</li>
<li id="n-currentevents">
<a href="/wiki/Portal:Current_events" title="Find background information on current events">
Current events
</a>
</li>
<li id="n-randompage">
<a accesskey="x" href="/wiki/Special:Random" title="Load a random article [x]">
Random article
</a>
</li>
<li id="n-sitesupport">
<a href="https://donate.wikimedia.org/wiki/Special:FundraiserRedirector?utm_source=donate&utm_medium=sidebar&utm_campaign=C13_en.wikipedia.org&uselang=en" title="Support us">
Donate to Wikipedia
</a>
</li>
<li id="n-shoplink">
<a href="//shop.wikimedia.org" title="Visit the Wikipedia store">
Wikipedia store
</a>
</li>
</ul>
</div>
</div>
<div aria-labelledby="p-interaction-label" class="portal" id="p-interaction" role="navigation">
<h3 id="p-interaction-label">
Interaction
</h3>
<div class="body">
<ul>
<li id="n-help">
<a href="/wiki/Help:Contents" title="Guidance on how to use and edit Wikipedia">
Help
</a>
</li>
<li id="n-aboutsite">
<a href="/wiki/Wikipedia:About" title="Find out about Wikipedia">
About Wikipedia
</a>
</li>
<li id="n-portal">
<a href="/wiki/Wikipedia:Community_portal" title="About the project, what you can do, where to find things">
Community portal
</a>
</li>
<li id="n-recentchanges">
<a accesskey="r" href="/wiki/Special:RecentChanges" title="A list of recent changes in the wiki [r]">
Recent changes
</a>
</li>
<li id="n-contactpage">
<a href="//en.wikipedia.org/wiki/Wikipedia:Contact_us" title="How to contact Wikipedia">
Contact page
</a>
</li>
</ul>
</div>
</div>
<div aria-labelledby="p-tb-label" class="portal" id="p-tb" role="navigation">
<h3 id="p-tb-label">
Tools
</h3>
<div class="body">
<ul>
<li id="t-whatlinkshere">
<a accesskey="j" href="/wiki/Special:WhatLinksHere/List_of_London_boroughs" title="List of all English Wikipedia pages containing links to this page [j]">
What links here
</a>
</li>
<li id="t-recentchangeslinked">
<a accesskey="k" href="/wiki/Special:RecentChangesLinked/List_of_London_boroughs" rel="nofollow" title="Recent changes in pages linked from this page [k]">
Related changes
</a>
</li>
<li id="t-upload">
<a accesskey="u" href="/wiki/Wikipedia:File_Upload_Wizard" title="Upload files [u]">
Upload file
</a>
</li>
<li id="t-specialpages">
<a accesskey="q" href="/wiki/Special:SpecialPages" title="A list of all special pages [q]">
Special pages
</a>
</li>
<li id="t-permalink">
<a href="/w/index.php?title=List_of_London_boroughs&oldid=943613985" title="Permanent link to this revision of the page">
Permanent link
</a>
</li>
<li id="t-info">
<a href="/w/index.php?title=List_of_London_boroughs&action=info" title="More information about this page">
Page information
</a>
</li>
<li id="t-wikibase">
<a accesskey="g" href="https://www.wikidata.org/wiki/Special:EntityPage/Q6577004" title="Link to connected data repository item [g]">
Wikidata item
</a>
</li>
<li id="t-cite">
<a href="/w/index.php?title=Special:CiteThisPage&page=List_of_London_boroughs&id=943613985" title="Information on how to cite this page">
Cite this page
</a>
</li>
</ul>
</div>
</div>
<div aria-labelledby="p-coll-print_export-label" class="portal" id="p-coll-print_export" role="navigation">
<h3 id="p-coll-print_export-label">
Print/export
</h3>
<div class="body">
<ul>
<li id="coll-create_a_book">
<a href="/w/index.php?title=Special:Book&bookcmd=book_creator&referer=List+of+London+boroughs">
Create a book
</a>
</li>
<li id="coll-download-as-rl">
<a href="/w/index.php?title=Special:ElectronPdf&page=List+of+London+boroughs&action=show-download-screen">
Download as PDF
</a>
</li>
<li id="t-print">
<a accesskey="p" href="/w/index.php?title=List_of_London_boroughs&printable=yes" title="Printable version of this page [p]">
Printable version
</a>
</li>
</ul>
</div>
</div>
<div aria-labelledby="p-lang-label" class="portal" id="p-lang" role="navigation">
<h3 id="p-lang-label">
Languages
</h3>
<div class="body">
<ul>
<li class="interlanguage-link interwiki-ru">
<a class="interlanguage-link-target" href="https://ru.wikipedia.org/wiki/%D0%A1%D0%BF%D0%B8%D1%81%D0%BE%D0%BA_%D0%BB%D0%BE%D0%BD%D0%B4%D0%BE%D0%BD%D1%81%D0%BA%D0%B8%D1%85_%D0%B1%D0%BE%D1%80%D0%BE" hreflang="ru" lang="ru" title="Список лондонских боро – Russian">
Русский
</a>
</li>
</ul>
<div class="after-portlet after-portlet-lang">
<span class="wb-langlinks-edit wb-langlinks-link">
<a class="wbc-editpage" href="https://www.wikidata.org/wiki/Special:EntityPage/Q6577004#sitelinks-wikipedia" title="Edit interlanguage links">
Edit links
</a>
</span>
</div>
</div>
</div>
</div>
</div>
<div id="footer" role="contentinfo">
<ul class="" id="footer-info">
<li id="footer-info-lastmod">
This page was last edited on 2 March 2020, at 22:20
<span class="anonymous-show">
(UTC)
</span>
.
</li>
<li id="footer-info-copyright">
Text is available under the
<a href="//en.wikipedia.org/wiki/Wikipedia:Text_of_Creative_Commons_Attribution-ShareAlike_3.0_Unported_License" rel="license">
Creative Commons Attribution-ShareAlike License
</a>
<a href="//creativecommons.org/licenses/by-sa/3.0/" rel="license" style="display:none;"/>
;
additional terms may apply. By using this site, you agree to the
<a href="//foundation.wikimedia.org/wiki/Terms_of_Use">
Terms of Use
</a>
and
<a href="//foundation.wikimedia.org/wiki/Privacy_policy">
Privacy Policy
</a>
. Wikipedia® is a registered trademark of the
<a href="//www.wikimediafoundation.org/">
Wikimedia Foundation, Inc.
</a>
, a non-profit organization.
</li>
</ul>
<ul class="" id="footer-places">
<li id="footer-places-privacy">
<a class="extiw" href="https://foundation.wikimedia.org/wiki/Privacy_policy" title="wmf:Privacy policy">
Privacy policy
</a>
</li>
<li id="footer-places-about">
<a href="/wiki/Wikipedia:About" title="Wikipedia:About">
About Wikipedia
</a>
</li>
<li id="footer-places-disclaimer">
<a href="/wiki/Wikipedia:General_disclaimer" title="Wikipedia:General disclaimer">
Disclaimers
</a>
</li>
<li id="footer-places-contact">
<a href="//en.wikipedia.org/wiki/Wikipedia:Contact_us">
Contact Wikipedia
</a>
</li>
<li id="footer-places-developers">
<a href="https://www.mediawiki.org/wiki/Special:MyLanguage/How_to_contribute">
Developers
</a>
</li>
<li id="footer-places-statslink">
<a href="https://stats.wikimedia.org/#/en.wikipedia.org">
Statistics
</a>
</li>
<li id="footer-places-cookiestatement">
<a href="https://foundation.wikimedia.org/wiki/Cookie_statement">
Cookie statement
</a>
</li>
<li id="footer-places-mobileview">
<a class="noprint stopMobileRedirectToggle" href="//en.m.wikipedia.org/w/index.php?title=List_of_London_boroughs&mobileaction=toggle_view_mobile">
Mobile view
</a>
</li>
</ul>
<ul class="noprint" id="footer-icons">
<li id="footer-copyrightico">
<a href="https://wikimediafoundation.org/">
<img alt="Wikimedia Foundation" height="31" src="/static/images/wikimedia-button.png" srcset="/static/images/wikimedia-button-1.5x.png 1.5x, /static/images/wikimedia-button-2x.png 2x" width="88"/>
</a>
</li>
<li id="footer-poweredbyico">
<a href="https://www.mediawiki.org/">
<img alt="Powered by MediaWiki" height="31" src="/static/images/poweredby_mediawiki_88x31.png" srcset="/static/images/poweredby_mediawiki_132x47.png 1.5x, /static/images/poweredby_mediawiki_176x62.png 2x" width="88"/>
</a>
</li>
</ul>
<div style="clear: both;"/>
</div>
<script>
(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgPageParseReport":{"limitreport":{"cputime":"0.356","walltime":"0.442","ppvisitednodes":{"value":5140,"limit":1000000},"postexpandincludesize":{"value":79370,"limit":2097152},"templateargumentsize":{"value":1081,"limit":2097152},"expansiondepth":{"value":13,"limit":40},"expensivefunctioncount":{"value":2,"limit":500},"unstrip-depth":{"value":1,"limit":20},"unstrip-size":{"value":10566,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 301.212 1 -total"," 38.94% 117.279 2 Template:Reflist"," 32.47% 97.807 2 Template:London_Gazette"," 30.53% 91.950 2 Template:Cite_magazine"," 19.10% 57.526 33 Template:Coord"," 12.97% 39.078 1 Template:Use_dmy_dates"," 10.87% 32.731 33 Template:English_district_control"," 7.42% 22.349 1 Template:London"," 5.55% 16.731 2 Template:DMCA"," 5.23% 15.756 1 Template:Navbox"]},"scribunto":{"limitreport-timeusage":{"value":"0.109","limit":"10.000"},"limitreport-memusage":{"value":3259903,"limit":52428800}},"cachereport":{"origin":"mw1330","timestamp":"20200311193737","ttl":2592000,"transientcontent":false}}});});
</script>
<script type="application/ld+json">
{"@context":"https:\/\/schema.org","@type":"Article","name":"List of London boroughs","url":"https:\/\/en.wikipedia.org\/wiki\/List_of_London_boroughs","sameAs":"http:\/\/www.wikidata.org\/entity\/Q6577004","mainEntity":"http:\/\/www.wikidata.org\/entity\/Q6577004","author":{"@type":"Organization","name":"Contributors to Wikimedia projects"},"publisher":{"@type":"Organization","name":"Wikimedia Foundation, Inc.","logo":{"@type":"ImageObject","url":"https:\/\/www.wikimedia.org\/static\/images\/wmf-hor-googpub.png"}},"datePublished":"2010-07-20T07:28:35Z","dateModified":"2020-03-02T22:20:38Z","headline":"Wikimedia list article"}
</script>
<script>
(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgBackendResponseTime":100,"wgHostname":"mw1368"});});
</script>
</body>
</html>
Extract the raw table inside the webpage.
= soup.find_all('table', {'class':'wikitable sortable'})
table print(table)
[<table class="wikitable sortable" style="font-size:100%" width="100%">
<tbody><tr>
<th>Borough
</th>
<th>Inner
</th>
<th>Status
</th>
<th>Local authority
</th>
<th>Political control
</th>
<th>Headquarters
</th>
<th>Area (sq mi)
</th>
<th>Population (2013 est)<sup class="reference" id="cite_ref-1"><a href="#cite_note-1">[1]</a></sup>
</th>
<th>Co-ordinates
</th>
<th><span style="background:#67BCD3"> Nr. in map </span>
</th></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Barking_and_Dagenham" title="London Borough of Barking and Dagenham">Barking and Dagenham</a> <sup class="reference" id="cite_ref-2"><a href="#cite_note-2">[note 1]</a></sup>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Barking_and_Dagenham_London_Borough_Council" title="Barking and Dagenham London Borough Council">Barking and Dagenham London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Barking_Town_Hall&action=edit&redlink=1" title="Barking Town Hall (page does not exist)">Town Hall</a>, 1 Town Square
</td>
<td>13.93
</td>
<td>194,352
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5607_N_0.1557_E_region:GB_type:city&title=Barking+and+Dagenham"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°33′39″N</span> <span class="longitude">0°09′21″E</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5607°N 0.1557°E</span><span style="display:none"> / <span class="geo">51.5607; 0.1557</span></span><span style="display:none"> (<span class="fn org">Barking and Dagenham</span>)</span></span></span></a></span>
</td>
<td>25
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Barnet" title="London Borough of Barnet">Barnet</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Barnet_London_Borough_Council" title="Barnet London Borough Council">Barnet London Borough Council</a>
</td>
<td><a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">Conservative</a>
</td>
<td><a class="new" href="/w/index.php?title=North_London_Business_Park&action=edit&redlink=1" title="North London Business Park (page does not exist)">North London Business Park</a>, Oakleigh Road South
</td>
<td>33.49
</td>
<td>369,088
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.6252_N_0.1517_W_region:GB_type:city&title=Barnet"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°37′31″N</span> <span class="longitude">0°09′06″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.6252°N 0.1517°W</span><span style="display:none"> / <span class="geo">51.6252; -0.1517</span></span><span style="display:none"> (<span class="fn org">Barnet</span>)</span></span></span></a></span>
</td>
<td>31
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Bexley" title="London Borough of Bexley">Bexley</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Bexley_London_Borough_Council" title="Bexley London Borough Council">Bexley London Borough Council</a>
</td>
<td><a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">Conservative</a>
</td>
<td><a class="new" href="/w/index.php?title=Civic_Offices&action=edit&redlink=1" title="Civic Offices (page does not exist)">Civic Offices</a>, 2 Watling Street
</td>
<td>23.38
</td>
<td>236,687
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4549_N_0.1505_E_region:GB_type:city&title=Bexley"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°27′18″N</span> <span class="longitude">0°09′02″E</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4549°N 0.1505°E</span><span style="display:none"> / <span class="geo">51.4549; 0.1505</span></span><span style="display:none"> (<span class="fn org">Bexley</span>)</span></span></span></a></span>
</td>
<td>23
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Brent" title="London Borough of Brent">Brent</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Brent_London_Borough_Council" title="Brent London Borough Council">Brent London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a href="/wiki/Brent_Civic_Centre" title="Brent Civic Centre">Brent Civic Centre</a>, Engineers Way
</td>
<td>16.70
</td>
<td>317,264
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5588_N_0.2817_W_region:GB_type:city&title=Brent"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°33′32″N</span> <span class="longitude">0°16′54″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5588°N 0.2817°W</span><span style="display:none"> / <span class="geo">51.5588; -0.2817</span></span><span style="display:none"> (<span class="fn org">Brent</span>)</span></span></span></a></span>
</td>
<td>12
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Bromley" title="London Borough of Bromley">Bromley</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Bromley_London_Borough_Council" title="Bromley London Borough Council">Bromley London Borough Council</a>
</td>
<td><a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">Conservative</a>
</td>
<td><a class="new" href="/w/index.php?title=Bromley_Civic_Centre&action=edit&redlink=1" title="Bromley Civic Centre (page does not exist)">Civic Centre</a>, Stockwell Close
</td>
<td>57.97
</td>
<td>317,899
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4039_N_0.0198_E_region:GB_type:city&title=Bromley"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°24′14″N</span> <span class="longitude">0°01′11″E</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4039°N 0.0198°E</span><span style="display:none"> / <span class="geo">51.4039; 0.0198</span></span><span style="display:none"> (<span class="fn org">Bromley</span>)</span></span></span></a></span>
</td>
<td>20
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Camden" title="London Borough of Camden">Camden</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td>
</td>
<td><a href="/wiki/Camden_London_Borough_Council" title="Camden London Borough Council">Camden London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a href="/wiki/Camden_Town_Hall" title="Camden Town Hall">Camden Town Hall</a>, Judd Street
</td>
<td>8.40
</td>
<td>229,719
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.529_N_0.1255_W_region:GB_type:city&title=Camden"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°31′44″N</span> <span class="longitude">0°07′32″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5290°N 0.1255°W</span><span style="display:none"> / <span class="geo">51.5290; -0.1255</span></span><span style="display:none"> (<span class="fn org">Camden</span>)</span></span></span></a></span>
</td>
<td>11
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Croydon" title="London Borough of Croydon">Croydon</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Croydon_London_Borough_Council" title="Croydon London Borough Council">Croydon London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Bernard_Weatherill_House&action=edit&redlink=1" title="Bernard Weatherill House (page does not exist)">Bernard Weatherill House</a>, Mint Walk
</td>
<td>33.41
</td>
<td>372,752
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.3714_N_0.0977_W_region:GB_type:city&title=Croydon"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°22′17″N</span> <span class="longitude">0°05′52″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.3714°N 0.0977°W</span><span style="display:none"> / <span class="geo">51.3714; -0.0977</span></span><span style="display:none"> (<span class="fn org">Croydon</span>)</span></span></span></a></span>
</td>
<td>19
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Ealing" title="London Borough of Ealing">Ealing</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Ealing_London_Borough_Council" title="Ealing London Borough Council">Ealing London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Perceval_House,_Ealing&action=edit&redlink=1" title="Perceval House, Ealing (page does not exist)">Perceval House</a>, 14-16 Uxbridge Road
</td>
<td>21.44
</td>
<td>342,494
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.513_N_0.3089_W_region:GB_type:city&title=Ealing"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°30′47″N</span> <span class="longitude">0°18′32″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5130°N 0.3089°W</span><span style="display:none"> / <span class="geo">51.5130; -0.3089</span></span><span style="display:none"> (<span class="fn org">Ealing</span>)</span></span></span></a></span>
</td>
<td>13
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Enfield" title="London Borough of Enfield">Enfield</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Enfield_London_Borough_Council" title="Enfield London Borough Council">Enfield London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Enfield_Civic_Centre&action=edit&redlink=1" title="Enfield Civic Centre (page does not exist)">Civic Centre</a>, Silver Street
</td>
<td>31.74
</td>
<td>320,524
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.6538_N_0.0799_W_region:GB_type:city&title=Enfield"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°39′14″N</span> <span class="longitude">0°04′48″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.6538°N 0.0799°W</span><span style="display:none"> / <span class="geo">51.6538; -0.0799</span></span><span style="display:none"> (<span class="fn org">Enfield</span>)</span></span></span></a></span>
</td>
<td>30
</td></tr>
<tr>
<td><a href="/wiki/Royal_Borough_of_Greenwich" title="Royal Borough of Greenwich">Greenwich</a> <sup class="reference" id="cite_ref-3"><a href="#cite_note-3">[note 2]</a></sup>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span> <sup class="reference" id="cite_ref-note2_4-0"><a href="#cite_note-note2-4">[note 3]</a></sup>
</td>
<td><a class="mw-redirect" href="/wiki/Royal_borough" title="Royal borough">Royal</a>
</td>
<td><a href="/wiki/Greenwich_London_Borough_Council" title="Greenwich London Borough Council">Greenwich London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a href="/wiki/Woolwich_Town_Hall" title="Woolwich Town Hall">Woolwich Town Hall</a>, Wellington Street
</td>
<td>18.28
</td>
<td>264,008
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4892_N_0.0648_E_region:GB_type:city&title=Greenwich"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°29′21″N</span> <span class="longitude">0°03′53″E</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4892°N 0.0648°E</span><span style="display:none"> / <span class="geo">51.4892; 0.0648</span></span><span style="display:none"> (<span class="fn org">Greenwich</span>)</span></span></span></a></span>
</td>
<td>22
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Hackney" title="London Borough of Hackney">Hackney</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td>
</td>
<td><a href="/wiki/Hackney_London_Borough_Council" title="Hackney London Borough Council">Hackney London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Hackney_Town_Hall&action=edit&redlink=1" title="Hackney Town Hall (page does not exist)">Hackney Town Hall</a>, Mare Street
</td>
<td>7.36
</td>
<td>257,379
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.545_N_0.0553_W_region:GB_type:city&title=Hackney"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°32′42″N</span> <span class="longitude">0°03′19″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5450°N 0.0553°W</span><span style="display:none"> / <span class="geo">51.5450; -0.0553</span></span><span style="display:none"> (<span class="fn org">Hackney</span>)</span></span></span></a></span>
</td>
<td>9
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Hammersmith_and_Fulham" title="London Borough of Hammersmith and Fulham">Hammersmith and Fulham</a> <sup class="reference" id="cite_ref-5"><a href="#cite_note-5">[note 4]</a></sup>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td>
</td>
<td><a href="/wiki/Hammersmith_and_Fulham_London_Borough_Council" title="Hammersmith and Fulham London Borough Council">Hammersmith and Fulham London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Hammersmith_and_Fulham_Town_Hall&action=edit&redlink=1" title="Hammersmith and Fulham Town Hall (page does not exist)">Town Hall</a>, King Street
</td>
<td>6.33
</td>
<td>178,685
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4927_N_0.2339_W_region:GB_type:city&title=Hammersmith+and+Fulham"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°29′34″N</span> <span class="longitude">0°14′02″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4927°N 0.2339°W</span><span style="display:none"> / <span class="geo">51.4927; -0.2339</span></span><span style="display:none"> (<span class="fn org">Hammersmith and Fulham</span>)</span></span></span></a></span>
</td>
<td>4
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Haringey" title="London Borough of Haringey">Haringey</a>
</td>
<td><sup class="reference" id="cite_ref-note2_4-1"><a href="#cite_note-note2-4">[note 3]</a></sup>
</td>
<td>
</td>
<td><a href="/wiki/Haringey_London_Borough_Council" title="Haringey London Borough Council">Haringey London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Haringey_Civic_Centre&action=edit&redlink=1" title="Haringey Civic Centre (page does not exist)">Civic Centre</a>, High Road
</td>
<td>11.42
</td>
<td>263,386
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.6_N_0.1119_W_region:GB_type:city&title=Haringey"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°36′00″N</span> <span class="longitude">0°06′43″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.6000°N 0.1119°W</span><span style="display:none"> / <span class="geo">51.6000; -0.1119</span></span><span style="display:none"> (<span class="fn org">Haringey</span>)</span></span></span></a></span>
</td>
<td>29
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Harrow" title="London Borough of Harrow">Harrow</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Harrow_London_Borough_Council" title="Harrow London Borough Council">Harrow London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Harrow_Civic_Centre&action=edit&redlink=1" title="Harrow Civic Centre (page does not exist)">Civic Centre</a>, Station Road
</td>
<td>19.49
</td>
<td>243,372
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5898_N_0.3346_W_region:GB_type:city&title=Harrow"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°35′23″N</span> <span class="longitude">0°20′05″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5898°N 0.3346°W</span><span style="display:none"> / <span class="geo">51.5898; -0.3346</span></span><span style="display:none"> (<span class="fn org">Harrow</span>)</span></span></span></a></span>
</td>
<td>32
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Havering" title="London Borough of Havering">Havering</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Havering_London_Borough_Council" title="Havering London Borough Council">Havering London Borough Council</a>
</td>
<td><a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">Conservative</a> (council <a href="/wiki/No_overall_control" title="No overall control">NOC</a>)
</td>
<td><a class="new" href="/w/index.php?title=Havering_Town_Hall&action=edit&redlink=1" title="Havering Town Hall (page does not exist)">Town Hall</a>, Main Road
</td>
<td>43.35
</td>
<td>242,080
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5812_N_0.1837_E_region:GB_type:city&title=Havering"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°34′52″N</span> <span class="longitude">0°11′01″E</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5812°N 0.1837°E</span><span style="display:none"> / <span class="geo">51.5812; 0.1837</span></span><span style="display:none"> (<span class="fn org">Havering</span>)</span></span></span></a></span>
</td>
<td>24
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Hillingdon" title="London Borough of Hillingdon">Hillingdon</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Hillingdon_London_Borough_Council" title="Hillingdon London Borough Council">Hillingdon London Borough Council</a>
</td>
<td><a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">Conservative</a>
</td>
<td><a href="/wiki/Hillingdon_Civic_Centre" title="Hillingdon Civic Centre">Civic Centre</a>, High Street
</td>
<td>44.67
</td>
<td>286,806
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5441_N_0.476_W_region:GB_type:city&title=Hillingdon"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°32′39″N</span> <span class="longitude">0°28′34″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5441°N 0.4760°W</span><span style="display:none"> / <span class="geo">51.5441; -0.4760</span></span><span style="display:none"> (<span class="fn org">Hillingdon</span>)</span></span></span></a></span>
</td>
<td>33
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Hounslow" title="London Borough of Hounslow">Hounslow</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Hounslow_London_Borough_Council" title="Hounslow London Borough Council">Hounslow London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td>Hounslow House, 7 Bath Road
</td>
<td>21.61
</td>
<td>262,407
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4746_N_0.368_W_region:GB_type:city&title=Hounslow"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°28′29″N</span> <span class="longitude">0°22′05″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4746°N 0.3680°W</span><span style="display:none"> / <span class="geo">51.4746; -0.3680</span></span><span style="display:none"> (<span class="fn org">Hounslow</span>)</span></span></span></a></span>
</td>
<td>14
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Islington" title="London Borough of Islington">Islington</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td>
</td>
<td><a href="/wiki/Islington_London_Borough_Council" title="Islington London Borough Council">Islington London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Islington_Municipal_Offices&action=edit&redlink=1" title="Islington Municipal Offices (page does not exist)">Municipal Offices</a>, 222 Upper Street
</td>
<td>5.74
</td>
<td>215,667
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5416_N_0.1022_W_region:GB_type:city&title=Islington"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°32′30″N</span> <span class="longitude">0°06′08″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5416°N 0.1022°W</span><span style="display:none"> / <span class="geo">51.5416; -0.1022</span></span><span style="display:none"> (<span class="fn org">Islington</span>)</span></span></span></a></span>
</td>
<td>10
</td></tr>
<tr>
<td><a href="/wiki/Royal_Borough_of_Kensington_and_Chelsea" title="Royal Borough of Kensington and Chelsea">Kensington and Chelsea</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td><a class="mw-redirect" href="/wiki/Royal_borough" title="Royal borough">Royal</a>
</td>
<td><a href="/wiki/Kensington_and_Chelsea_London_Borough_Council" title="Kensington and Chelsea London Borough Council">Kensington and Chelsea London Borough Council</a>
</td>
<td><a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">Conservative</a>
</td>
<td><a href="/wiki/Kensington_Town_Hall,_London" title="Kensington Town Hall, London">The Town Hall</a>, <a href="/wiki/Hornton_Street" title="Hornton Street">Hornton Street</a>
</td>
<td>4.68
</td>
<td>155,594
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.502_N_0.1947_W_region:GB_type:city&title=Kensington+and+Chelsea"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°30′07″N</span> <span class="longitude">0°11′41″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5020°N 0.1947°W</span><span style="display:none"> / <span class="geo">51.5020; -0.1947</span></span><span style="display:none"> (<span class="fn org">Kensington and Chelsea</span>)</span></span></span></a></span>
</td>
<td>3
</td></tr>
<tr>
<td><a href="/wiki/Royal_Borough_of_Kingston_upon_Thames" title="Royal Borough of Kingston upon Thames">Kingston upon Thames</a>
</td>
<td>
</td>
<td><a class="mw-redirect" href="/wiki/Royal_borough" title="Royal borough">Royal</a>
</td>
<td><a href="/wiki/Kingston_upon_Thames_London_Borough_Council" title="Kingston upon Thames London Borough Council">Kingston upon Thames London Borough Council</a>
</td>
<td><a href="/wiki/Liberal_Democrats_(UK)" title="Liberal Democrats (UK)">Liberal Democrat</a>
</td>
<td><a href="/wiki/Kingston_upon_Thames_Guildhall" title="Kingston upon Thames Guildhall">Guildhall</a>, High Street
</td>
<td>14.38
</td>
<td>166,793
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4085_N_0.3064_W_region:GB_type:city&title=Kingston+upon+Thames"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°24′31″N</span> <span class="longitude">0°18′23″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4085°N 0.3064°W</span><span style="display:none"> / <span class="geo">51.4085; -0.3064</span></span><span style="display:none"> (<span class="fn org">Kingston upon Thames</span>)</span></span></span></a></span>
</td>
<td>16
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Lambeth" title="London Borough of Lambeth">Lambeth</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td>
</td>
<td><a href="/wiki/Lambeth_London_Borough_Council" title="Lambeth London Borough Council">Lambeth London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a href="/wiki/Lambeth_Town_Hall" title="Lambeth Town Hall">Lambeth Town Hall</a>, Brixton Hill
</td>
<td>10.36
</td>
<td>314,242
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4607_N_0.1163_W_region:GB_type:city&title=Lambeth"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°27′39″N</span> <span class="longitude">0°06′59″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4607°N 0.1163°W</span><span style="display:none"> / <span class="geo">51.4607; -0.1163</span></span><span style="display:none"> (<span class="fn org">Lambeth</span>)</span></span></span></a></span>
</td>
<td>6
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Lewisham" title="London Borough of Lewisham">Lewisham</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td>
</td>
<td><a href="/wiki/Lewisham_London_Borough_Council" title="Lewisham London Borough Council">Lewisham London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Lewisham_Town_Hall&action=edit&redlink=1" title="Lewisham Town Hall (page does not exist)">Town Hall</a>, 1 Catford Road
</td>
<td>13.57
</td>
<td>286,180
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4452_N_0.0209_W_region:GB_type:city&title=Lewisham"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°26′43″N</span> <span class="longitude">0°01′15″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4452°N 0.0209°W</span><span style="display:none"> / <span class="geo">51.4452; -0.0209</span></span><span style="display:none"> (<span class="fn org">Lewisham</span>)</span></span></span></a></span>
</td>
<td>21
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Merton" title="London Borough of Merton">Merton</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Merton_London_Borough_Council" title="Merton London Borough Council">Merton London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Merton_Civic_Centre&action=edit&redlink=1" title="Merton Civic Centre (page does not exist)">Civic Centre</a>, London Road
</td>
<td>14.52
</td>
<td>203,223
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4014_N_0.1958_W_region:GB_type:city&title=Merton"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°24′05″N</span> <span class="longitude">0°11′45″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4014°N 0.1958°W</span><span style="display:none"> / <span class="geo">51.4014; -0.1958</span></span><span style="display:none"> (<span class="fn org">Merton</span>)</span></span></span></a></span>
</td>
<td>17
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Newham" title="London Borough of Newham">Newham</a>
</td>
<td><sup class="reference" id="cite_ref-note2_4-2"><a href="#cite_note-note2-4">[note 3]</a></sup>
</td>
<td>
</td>
<td><a href="/wiki/Newham_London_Borough_Council" title="Newham London Borough Council">Newham London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Newham_Dockside&action=edit&redlink=1" title="Newham Dockside (page does not exist)">Newham Dockside</a>, 1000 Dockside Road
</td>
<td>13.98
</td>
<td>318,227
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5077_N_0.0469_E_region:GB_type:city&title=Newham"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°30′28″N</span> <span class="longitude">0°02′49″E</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5077°N 0.0469°E</span><span style="display:none"> / <span class="geo">51.5077; 0.0469</span></span><span style="display:none"> (<span class="fn org">Newham</span>)</span></span></span></a></span>
</td>
<td>27
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Redbridge" title="London Borough of Redbridge">Redbridge</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Redbridge_London_Borough_Council" title="Redbridge London Borough Council">Redbridge London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Redbridge_Town_Hall&action=edit&redlink=1" title="Redbridge Town Hall (page does not exist)">Town Hall</a>, 128-142 High Road
</td>
<td>21.78
</td>
<td>288,272
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.559_N_0.0741_E_region:GB_type:city&title=Redbridge"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°33′32″N</span> <span class="longitude">0°04′27″E</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5590°N 0.0741°E</span><span style="display:none"> / <span class="geo">51.5590; 0.0741</span></span><span style="display:none"> (<span class="fn org">Redbridge</span>)</span></span></span></a></span>
</td>
<td>26
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Richmond_upon_Thames" title="London Borough of Richmond upon Thames">Richmond upon Thames</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Richmond_upon_Thames_London_Borough_Council" title="Richmond upon Thames London Borough Council">Richmond upon Thames London Borough Council</a>
</td>
<td><a href="/wiki/Liberal_Democrats_(UK)" title="Liberal Democrats (UK)">Liberal Democrat</a>
</td>
<td><a class="new" href="/w/index.php?title=Richmond_upon_Thames_Civic_Centre&action=edit&redlink=1" title="Richmond upon Thames Civic Centre (page does not exist)">Civic Centre</a>, 44 York Street
</td>
<td>22.17
</td>
<td>191,365
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4479_N_0.326_W_region:GB_type:city&title=Richmond+upon+Thames"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°26′52″N</span> <span class="longitude">0°19′34″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4479°N 0.3260°W</span><span style="display:none"> / <span class="geo">51.4479; -0.3260</span></span><span style="display:none"> (<span class="fn org">Richmond upon Thames</span>)</span></span></span></a></span>
</td>
<td>15
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Southwark" title="London Borough of Southwark">Southwark</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td>
</td>
<td><a href="/wiki/Southwark_London_Borough_Council" title="Southwark London Borough Council">Southwark London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=160_Tooley_Street&action=edit&redlink=1" title="160 Tooley Street (page does not exist)">160 Tooley Street</a>
</td>
<td>11.14
</td>
<td>298,464
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5035_N_0.0804_W_region:GB_type:city&title=Southwark"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°30′13″N</span> <span class="longitude">0°04′49″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5035°N 0.0804°W</span><span style="display:none"> / <span class="geo">51.5035; -0.0804</span></span><span style="display:none"> (<span class="fn org">Southwark</span>)</span></span></span></a></span>
</td>
<td>7
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Sutton" title="London Borough of Sutton">Sutton</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Sutton_London_Borough_Council" title="Sutton London Borough Council">Sutton London Borough Council</a>
</td>
<td><a href="/wiki/Liberal_Democrats_(UK)" title="Liberal Democrats (UK)">Liberal Democrat</a>
</td>
<td><a class="new" href="/w/index.php?title=Sutton_Civic_Offices&action=edit&redlink=1" title="Sutton Civic Offices (page does not exist)">Civic Offices</a>, St Nicholas Way
</td>
<td>16.93
</td>
<td>195,914
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.3618_N_0.1945_W_region:GB_type:city&title=Sutton"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°21′42″N</span> <span class="longitude">0°11′40″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.3618°N 0.1945°W</span><span style="display:none"> / <span class="geo">51.3618; -0.1945</span></span><span style="display:none"> (<span class="fn org">Sutton</span>)</span></span></span></a></span>
</td>
<td>18
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Tower_Hamlets" title="London Borough of Tower Hamlets">Tower Hamlets</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td>
</td>
<td><a href="/wiki/Tower_Hamlets_London_Borough_Council" title="Tower Hamlets London Borough Council">Tower Hamlets London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a class="new" href="/w/index.php?title=Tower_Hamlets_Town_Hall&action=edit&redlink=1" title="Tower Hamlets Town Hall (page does not exist)">Town Hall</a>, Mulberry Place, 5 Clove Crescent
</td>
<td>7.63
</td>
<td>272,890
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5099_N_0.0059_W_region:GB_type:city&title=Tower+Hamlets"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°30′36″N</span> <span class="longitude">0°00′21″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5099°N 0.0059°W</span><span style="display:none"> / <span class="geo">51.5099; -0.0059</span></span><span style="display:none"> (<span class="fn org">Tower Hamlets</span>)</span></span></span></a></span>
</td>
<td>8
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Waltham_Forest" title="London Borough of Waltham Forest">Waltham Forest</a>
</td>
<td>
</td>
<td>
</td>
<td><a href="/wiki/Waltham_Forest_London_Borough_Council" title="Waltham Forest London Borough Council">Waltham Forest London Borough Council</a>
</td>
<td><a href="/wiki/Labour_Party_(UK)" title="Labour Party (UK)">Labour</a>
</td>
<td><a href="/wiki/Waltham_Forest_Town_Hall" title="Waltham Forest Town Hall">Waltham Forest Town Hall</a>, Forest Road
</td>
<td>14.99
</td>
<td>265,797
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5908_N_0.0134_W_region:GB_type:city&title=Waltham+Forest"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°35′27″N</span> <span class="longitude">0°00′48″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5908°N 0.0134°W</span><span style="display:none"> / <span class="geo">51.5908; -0.0134</span></span><span style="display:none"> (<span class="fn org">Waltham Forest</span>)</span></span></span></a></span>
</td>
<td>28
</td></tr>
<tr>
<td><a href="/wiki/London_Borough_of_Wandsworth" title="London Borough of Wandsworth">Wandsworth</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td>
</td>
<td><a href="/wiki/Wandsworth_London_Borough_Council" title="Wandsworth London Borough Council">Wandsworth London Borough Council</a>
</td>
<td><a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">Conservative</a>
</td>
<td><a class="new" href="/w/index.php?title=Wandsworth_Town_Hall&action=edit&redlink=1" title="Wandsworth Town Hall (page does not exist)">The Town Hall</a>, <a href="/wiki/Wandsworth_High_Street" title="Wandsworth High Street">Wandsworth High Street</a>
</td>
<td>13.23
</td>
<td>310,516
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4567_N_0.191_W_region:GB_type:city&title=Wandsworth"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°27′24″N</span> <span class="longitude">0°11′28″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4567°N 0.1910°W</span><span style="display:none"> / <span class="geo">51.4567; -0.1910</span></span><span style="display:none"> (<span class="fn org">Wandsworth</span>)</span></span></span></a></span>
</td>
<td>5
</td></tr>
<tr>
<td><a href="/wiki/City_of_Westminster" title="City of Westminster">Westminster</a>
</td>
<td><img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>
</td>
<td><a href="/wiki/City_status_in_the_United_Kingdom" title="City status in the United Kingdom">City</a>
</td>
<td><a href="/wiki/Westminster_City_Council" title="Westminster City Council">Westminster City Council</a>
</td>
<td><a href="/wiki/Conservative_Party_(UK)" title="Conservative Party (UK)">Conservative</a>
</td>
<td><a class="new" href="/w/index.php?title=Westminster_City_Hall&action=edit&redlink=1" title="Westminster City Hall (page does not exist)">Westminster City Hall</a>, 64 Victoria Street
</td>
<td>8.29
</td>
<td>226,841
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.4973_N_0.1372_W_region:GB_type:city&title=Westminster"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°29′50″N</span> <span class="longitude">0°08′14″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.4973°N 0.1372°W</span><span style="display:none"> / <span class="geo">51.4973; -0.1372</span></span><span style="display:none"> (<span class="fn org">Westminster</span>)</span></span></span></a></span>
</td>
<td>2
</td></tr></tbody></table>, <table class="wikitable sortable" style="font-size:95%" width="100%">
<tbody><tr>
<th width="100px">Borough
</th>
<th>Inner
</th>
<th width="100px">Status
</th>
<th>Local authority
</th>
<th>Political control
</th>
<th width="120px">Headquarters
</th>
<th>Area (sq mi)
</th>
<th>Population<br/>(2011 est)
</th>
<th width="20px">Co-ordinates
</th>
<th><span style="background:#67BCD3"> Nr. in<br/>map </span>
</th></tr>
<tr>
<td><a href="/wiki/City_of_London" title="City of London">City of London</a>
</td>
<td>(<img alt="☑" data-file-height="600" data-file-width="600" decoding="async" height="20" src="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/20px-Yes_check.svg.png" srcset="//upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/30px-Yes_check.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/f/fb/Yes_check.svg/40px-Yes_check.svg.png 2x" width="20"/><span style="display:none">Y</span>)<br/><sup class="reference" id="cite_ref-6"><a href="#cite_note-6">[note 5]</a></sup>
</td>
<td><i><a href="/wiki/Sui_generis" title="Sui generis">Sui generis</a></i>;<br/><a href="/wiki/City_status_in_the_United_Kingdom" title="City status in the United Kingdom">City</a>;<br/><a href="/wiki/Ceremonial_counties_of_England" title="Ceremonial counties of England">Ceremonial county</a>
</td>
<td><a class="mw-redirect" href="/wiki/Corporation_of_London" title="Corporation of London">Corporation of London</a>;<br/><a href="/wiki/Inner_Temple" title="Inner Temple">Inner Temple</a>;<br/><a href="/wiki/Middle_Temple" title="Middle Temple">Middle Temple</a>
</td>
<td>?
</td>
<td><a href="/wiki/Guildhall,_London" title="Guildhall, London">Guildhall</a>
</td>
<td>1.12
</td>
<td>7,000
</td>
<td><span class="plainlinks nourlexpansion"><a class="external text" href="//tools.wmflabs.org/geohack/geohack.php?pagename=List_of_London_boroughs&params=51.5155_N_0.0922_W_region:GB_type:city&title=City+of+London"><span class="geo-nondefault"><span class="geo-dms" title="Maps, aerial photos, and other data for this location"><span class="latitude">51°30′56″N</span> <span class="longitude">0°05′32″W</span></span></span><span class="geo-multi-punct"> / </span><span class="geo-default"><span class="vcard"><span class="geo-dec" title="Maps, aerial photos, and other data for this location">51.5155°N 0.0922°W</span><span style="display:none"> / <span class="geo">51.5155; -0.0922</span></span><span style="display:none"> (<span class="fn org">City of London</span>)</span></span></span></a></span>
</td>
<td>1
</td></tr></tbody></table>]
Convert the table into a dataframe.
= pd.read_html(str(table[0]), index_col=None, header=0)[0]
London_table London_table.head()
Borough | Inner | Status | Local authority | Political control | Headquarters | Area (sq mi) | Population (2013 est)[1] | Co-ordinates | Nr. in map | |
---|---|---|---|---|---|---|---|---|---|---|
0 | Barking and Dagenham [note 1] | NaN | NaN | Barking and Dagenham London Borough Council | Labour | Town Hall, 1 Town Square | 13.93 | 194352 | 51°33′39″N 0°09′21″E / 51.5607°N 0.1557°E | 25 |
1 | Barnet | NaN | NaN | Barnet London Borough Council | Conservative | North London Business Park, Oakleigh Road South | 33.49 | 369088 | 51°37′31″N 0°09′06″W / 51.6252°N 0.1517°W | 31 |
2 | Bexley | NaN | NaN | Bexley London Borough Council | Conservative | Civic Offices, 2 Watling Street | 23.38 | 236687 | 51°27′18″N 0°09′02″E / 51.4549°N 0.1505°E | 23 |
3 | Brent | NaN | NaN | Brent London Borough Council | Labour | Brent Civic Centre, Engineers Way | 16.70 | 317264 | 51°33′32″N 0°16′54″W / 51.5588°N 0.2817°W | 12 |
4 | Bromley | NaN | NaN | Bromley London Borough Council | Conservative | Civic Centre, Stockwell Close | 57.97 | 317899 | 51°24′14″N 0°01′11″E / 51.4039°N 0.0198°E | 20 |
There is a second table on the webpage that contains the additional Borough - City of London.
# read the second table
= pd.read_html(str(table[1]), index_col=None, header=0)[0]
London_table1
# rename the columns to match the previous table
= ['Borough', 'Inner', 'Status', 'Local authority', 'Political control', 'Headquarters',
London_table1.columns 'Area (sq mi)', 'Population (2013 est)[1]', 'Co-ordinates', 'Nr. in map']
# view the table
London_table1
Borough | Inner | Status | Local authority | Political control | Headquarters | Area (sq mi) | Population (2013 est)[1] | Co-ordinates | Nr. in map | |
---|---|---|---|---|---|---|---|---|---|---|
0 | City of London | ([note 5] | Sui generis;City;Ceremonial county | Corporation of London;Inner Temple;Middle Temple | ? | Guildhall | 1.12 | 7000 | 51°30′56″N 0°05′32″W / 51.5155°N 0.0922°W | 1 |
Let’s append the dataframes of ‘London_table’ and ‘London_table1’ together. A continuous index value will be maintained across the rows in the new appended dataframe.
= London_table.append(London_table1, ignore_index=True)
London_table
# check the last rows of the data set
London_table.tail()
Borough | Inner | Status | Local authority | Political control | Headquarters | Area (sq mi) | Population (2013 est)[1] | Co-ordinates | Nr. in map | |
---|---|---|---|---|---|---|---|---|---|---|
28 | Tower Hamlets | NaN | NaN | Tower Hamlets London Borough Council | Labour | Town Hall, Mulberry Place, 5 Clove Crescent | 7.63 | 272890 | 51°30′36″N 0°00′21″W / 51.5099°N 0.0059°W | 8 |
29 | Waltham Forest | NaN | NaN | Waltham Forest London Borough Council | Labour | Waltham Forest Town Hall, Forest Road | 14.99 | 265797 | 51°35′27″N 0°00′48″W / 51.5908°N 0.0134°W | 28 |
30 | Wandsworth | NaN | NaN | Wandsworth London Borough Council | Conservative | The Town Hall, Wandsworth High Street | 13.23 | 310516 | 51°27′24″N 0°11′28″W / 51.4567°N 0.1910°W | 5 |
31 | Westminster | NaN | City | Westminster City Council | Conservative | Westminster City Hall, 64 Victoria Street | 8.29 | 226841 | 51°29′50″N 0°08′14″W / 51.4973°N 0.1372°W | 2 |
32 | City of London | ([note 5] | Sui generis;City;Ceremonial county | Corporation of London;Inner Temple;Middle Temple | ? | Guildhall | 1.12 | 7000 | 51°30′56″N 0°05′32″W / 51.5155°N 0.0922°W | 1 |
We’ll remove the unnecessary strings in the dataset.
= London_table.replace('note 1','', regex=True)
London_table = London_table.replace('note 2','', regex=True)
London_table = London_table.replace('note 3','', regex=True)
London_table = London_table.replace('note 4','', regex=True)
London_table = London_table.replace('note 5','', regex=True)
London_table
London_table.head()
Borough | Inner | Status | Local authority | Political control | Headquarters | Area (sq mi) | Population (2013 est)[1] | Co-ordinates | Nr. in map | |
---|---|---|---|---|---|---|---|---|---|---|
0 | Barking and Dagenham [] | NaN | NaN | Barking and Dagenham London Borough Council | Labour | Town Hall, 1 Town Square | 13.93 | 194352 | 51°33′39″N 0°09′21″E / 51.5607°N 0.1557°E | 25 |
1 | Barnet | NaN | NaN | Barnet London Borough Council | Conservative | North London Business Park, Oakleigh Road South | 33.49 | 369088 | 51°37′31″N 0°09′06″W / 51.6252°N 0.1517°W | 31 |
2 | Bexley | NaN | NaN | Bexley London Borough Council | Conservative | Civic Offices, 2 Watling Street | 23.38 | 236687 | 51°27′18″N 0°09′02″E / 51.4549°N 0.1505°E | 23 |
3 | Brent | NaN | NaN | Brent London Borough Council | Labour | Brent Civic Centre, Engineers Way | 16.70 | 317264 | 51°33′32″N 0°16′54″W / 51.5588°N 0.2817°W | 12 |
4 | Bromley | NaN | NaN | Bromley London Borough Council | Conservative | Civic Centre, Stockwell Close | 57.97 | 317899 | 51°24′14″N 0°01′11″E / 51.4039°N 0.0198°E | 20 |
# type of the dataframe
type(London_table)
pandas.core.frame.DataFrame
# shape of the dataframe
London_table.shape
(33, 10)
Check if the Borough in both the dataframes match.
set(df.Borough) - set(London_table.Borough)
{'Barking and Dagenham', 'Greenwich', 'Hammersmith and Fulham'}
These 3 Boroughs don’t match because of the unnecessary symbols like ‘[ ]’ present.
Let’s find the index of the 3 Boroughs that do not match.
print("The index of first borough is",London_table.index[London_table['Borough'] == 'Barking and Dagenham []'].tolist())
print("The index of second borough is",London_table.index[London_table['Borough'] == 'Greenwich []'].tolist())
print("The index of third borough is",London_table.index[London_table['Borough'] == 'Hammersmith and Fulham []'].tolist())
The index of first borough is [0]
The index of second borough is [9]
The index of third borough is [11]
Change the Borough names to match the other data frame.
0,0] = 'Barking and Dagenham'
London_table.iloc[9,0] = 'Greenwich'
London_table.iloc[11,0] = 'Hammersmith and Fulham' London_table.iloc[
set(df.Borough) - set(London_table.Borough)
set()
The Borough names in both dataframes match.
Now, we combine both the dataframes together.
= pd.merge(London_crime, London_table, on='Borough')
Ld_crime Ld_crime.head()
Borough | Burglary | Criminal Damage | Drugs | Fraud or Forgery | Other Notifiable Offenses | Robbery | Sexual Offences | Theft and Handling | Violence Against the Person | Total | Inner | Status | Local authority | Political control | Headquarters | Area (sq mi) | Population (2013 est)[1] | Co-ordinates | Nr. in map | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Barking and Dagenham | 18103 | 18888 | 9188 | 205 | 2819 | 6105 | 49 | 50999 | 43091 | 149447 | NaN | NaN | Barking and Dagenham London Borough Council | Labour | Town Hall, 1 Town Square | 13.93 | 194352 | 51°33′39″N 0°09′21″E / 51.5607°N 0.1557°E | 25 |
1 | Barnet | 36981 | 21024 | 9796 | 175 | 2953 | 7374 | 38 | 87285 | 46565 | 212191 | NaN | NaN | Barnet London Borough Council | Conservative | North London Business Park, Oakleigh Road South | 33.49 | 369088 | 51°37′31″N 0°09′06″W / 51.6252°N 0.1517°W | 31 |
2 | Bexley | 14973 | 17244 | 7346 | 106 | 1999 | 2338 | 22 | 40071 | 30037 | 114136 | NaN | NaN | Bexley London Borough Council | Conservative | Civic Offices, 2 Watling Street | 23.38 | 236687 | 51°27′18″N 0°09′02″E / 51.4549°N 0.1505°E | 23 |
3 | Brent | 28923 | 20569 | 25978 | 157 | 3711 | 12473 | 39 | 72523 | 63178 | 227551 | NaN | NaN | Brent London Borough Council | Labour | Brent Civic Centre, Engineers Way | 16.70 | 317264 | 51°33′32″N 0°16′54″W / 51.5588°N 0.2817°W | 12 |
4 | Bromley | 27135 | 24039 | 8942 | 196 | 2637 | 4868 | 31 | 69742 | 46759 | 184349 | NaN | NaN | Bromley London Borough Council | Conservative | Civic Centre, Stockwell Close | 57.97 | 317899 | 51°24′14″N 0°01′11″E / 51.4039°N 0.0198°E | 20 |
# shape of the dataframe
Ld_crime.shape
(33, 20)
# check if the names of Boroughs in both the dataframes match
set(df.Borough) - set(Ld_crime.Borough)
set()
Rearrange the Columns.
# list the column names of the dataframe
list(Ld_crime)
['Borough',
'Burglary',
'Criminal Damage',
'Drugs',
'Fraud or Forgery',
'Other Notifiable Offenses',
'Robbery',
'Sexual Offences',
'Theft and Handling',
'Violence Against the Person',
'Total',
'Inner',
'Status',
'Local authority',
'Political control',
'Headquarters',
'Area (sq mi)',
'Population (2013 est)[1]',
'Co-ordinates',
'Nr. in map']
# rename the Population column
= Ld_crime.rename(columns = {'Population (2013 est)[1]':'Population'}) Ld_crime
= ['Borough', 'Local authority', 'Political control', 'Headquarters', 'Area (sq mi)', 'Population', 'Co-ordinates',
columnsTitles 'Burglary', 'Criminal Damage', 'Drugs', 'Fraud or Forgery', 'Other Notifiable Offenses', 'Robbery', 'Sexual Offenses',
'Theft and Handling', 'Violence Against the Person', 'Total']
= Ld_crime.reindex(columns=columnsTitles)
Ld_crime
= Ld_crime[['Borough', 'Local authority', 'Political control', 'Headquarters', 'Area (sq mi)', 'Population', 'Co-ordinates',
Ld_crime 'Burglary', 'Criminal Damage', 'Drugs', 'Fraud or Forgery', 'Other Notifiable Offenses', 'Robbery', 'Sexual Offenses',
'Theft and Handling', 'Violence Against the Person', 'Total']]
Ld_crime
Borough | Local authority | Political control | Headquarters | Area (sq mi) | Population | Co-ordinates | Burglary | Criminal Damage | Drugs | Fraud or Forgery | Other Notifiable Offenses | Robbery | Sexual Offenses | Theft and Handling | Violence Against the Person | Total | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Barking and Dagenham | Barking and Dagenham London Borough Council | Labour | Town Hall, 1 Town Square | 13.93 | 194352 | 51°33′39″N 0°09′21″E / 51.5607°N 0.1557°E | 18103 | 18888 | 9188 | 205 | 2819 | 6105 | NaN | 50999 | 43091 | 149447 |
1 | Barnet | Barnet London Borough Council | Conservative | North London Business Park, Oakleigh Road South | 33.49 | 369088 | 51°37′31″N 0°09′06″W / 51.6252°N 0.1517°W | 36981 | 21024 | 9796 | 175 | 2953 | 7374 | NaN | 87285 | 46565 | 212191 |
2 | Bexley | Bexley London Borough Council | Conservative | Civic Offices, 2 Watling Street | 23.38 | 236687 | 51°27′18″N 0°09′02″E / 51.4549°N 0.1505°E | 14973 | 17244 | 7346 | 106 | 1999 | 2338 | NaN | 40071 | 30037 | 114136 |
3 | Brent | Brent London Borough Council | Labour | Brent Civic Centre, Engineers Way | 16.70 | 317264 | 51°33′32″N 0°16′54″W / 51.5588°N 0.2817°W | 28923 | 20569 | 25978 | 157 | 3711 | 12473 | NaN | 72523 | 63178 | 227551 |
4 | Bromley | Bromley London Borough Council | Conservative | Civic Centre, Stockwell Close | 57.97 | 317899 | 51°24′14″N 0°01′11″E / 51.4039°N 0.0198°E | 27135 | 24039 | 8942 | 196 | 2637 | 4868 | NaN | 69742 | 46759 | 184349 |
5 | Camden | Camden London Borough Council | Labour | Camden Town Hall, Judd Street | 8.40 | 229719 | 51°31′44″N 0°07′32″W / 51.5290°N 0.1255°W | 27939 | 18482 | 21816 | 123 | 3857 | 9286 | NaN | 140596 | 53012 | 275147 |
6 | City of London | Corporation of London;Inner Temple;Middle Temple | ? | Guildhall | 1.12 | 7000 | 51°30′56″N 0°05′32″W / 51.5155°N 0.0922°W | 15 | 16 | 33 | 0 | 17 | 24 | NaN | 561 | 114 | 780 |
7 | Croydon | Croydon London Borough Council | Labour | Bernard Weatherill House, Mint Walk | 33.41 | 372752 | 51°22′17″N 0°05′52″W / 51.3714°N 0.0977°W | 33376 | 31218 | 19162 | 270 | 4340 | 12645 | NaN | 91437 | 67791 | 260294 |
8 | Ealing | Ealing London Borough Council | Labour | Perceval House, 14-16 Uxbridge Road | 21.44 | 342494 | 51°30′47″N 0°18′32″W / 51.5130°N 0.3089°W | 30831 | 25613 | 18591 | 175 | 4406 | 9568 | NaN | 93834 | 68492 | 251562 |
9 | Enfield | Enfield London Borough Council | Labour | Civic Centre, Silver Street | 31.74 | 320524 | 51°39′14″N 0°04′48″W / 51.6538°N 0.0799°W | 30213 | 22487 | 13251 | 132 | 3293 | 9059 | NaN | 70371 | 45036 | 193880 |
10 | Greenwich | Greenwich London Borough Council | Labour | Woolwich Town Hall, Wellington Street | 18.28 | 264008 | 51°29′21″N 0°03′53″E / 51.4892°N 0.0648°E | 20966 | 22755 | 10836 | 107 | 3598 | 5430 | NaN | 64923 | 52897 | 181568 |
11 | Hackney | Hackney London Borough Council | Labour | Hackney Town Hall, Mare Street | 7.36 | 257379 | 51°32′42″N 0°03′19″W / 51.5450°N 0.0553°W | 21450 | 17327 | 18144 | 143 | 3332 | 8975 | NaN | 91118 | 56584 | 217119 |
12 | Hammersmith and Fulham | Hammersmith and Fulham London Borough Council | Labour | Town Hall, King Street | 6.33 | 178685 | 51°29′34″N 0°14′02″W / 51.4927°N 0.2339°W | 17010 | 14595 | 15492 | 91 | 3352 | 5279 | NaN | 86381 | 43014 | 185259 |
13 | Haringey | Haringey London Borough Council | Labour | Civic Centre, High Road | 11.42 | 263386 | 51°36′00″N 0°06′43″W / 51.6000°N 0.1119°W | 28213 | 22272 | 14563 | 207 | 2971 | 10084 | NaN | 83979 | 50943 | 213272 |
14 | Harrow | Harrow London Borough Council | Labour | Civic Centre, Station Road | 19.49 | 243372 | 51°35′23″N 0°20′05″W / 51.5898°N 0.3346°W | 19630 | 12724 | 7122 | 92 | 1998 | 4242 | NaN | 40800 | 30213 | 116848 |
15 | Havering | Havering London Borough Council | Conservative (council NOC) | Town Hall, Main Road | 43.35 | 242080 | 51°34′52″N 0°11′01″E / 51.5812°N 0.1837°E | 21302 | 17252 | 8171 | 179 | 2358 | 3089 | NaN | 52609 | 33968 | 138947 |
16 | Hillingdon | Hillingdon London Borough Council | Conservative | Civic Centre, High Street | 44.67 | 286806 | 51°32′39″N 0°28′34″W / 51.5441°N 0.4760°W | 26056 | 24485 | 11413 | 223 | 6504 | 5663 | NaN | 80028 | 55264 | 209680 |
17 | Hounslow | Hounslow London Borough Council | Labour | Hounslow House, 7 Bath Road | 21.61 | 262407 | 51°28′29″N 0°22′05″W / 51.4746°N 0.3680°W | 21026 | 21407 | 13722 | 183 | 3963 | 4847 | NaN | 70180 | 51404 | 186772 |
18 | Islington | Islington London Borough Council | Labour | Municipal Offices, 222 Upper Street | 5.74 | 215667 | 51°32′30″N 0°06′08″W / 51.5416°N 0.1022°W | 22207 | 18354 | 16553 | 85 | 3675 | 8736 | NaN | 107661 | 52975 | 230286 |
19 | Kensington and Chelsea | Kensington and Chelsea London Borough Council | Conservative | The Town Hall, Hornton Street | 4.68 | 155594 | 51°30′07″N 0°11′41″W / 51.5020°N 0.1947°W | 14980 | 9839 | 14573 | 85 | 2203 | 4744 | NaN | 95963 | 29570 | 171981 |
20 | Kingston upon Thames | Kingston upon Thames London Borough Council | Liberal Democrat | Guildhall, High Street | 14.38 | 166793 | 51°24′31″N 0°18′23″W / 51.4085°N 0.3064°W | 10131 | 10610 | 5682 | 65 | 1332 | 1702 | NaN | 38226 | 21540 | 89306 |
21 | Lambeth | Lambeth London Borough Council | Labour | Lambeth Town Hall, Brixton Hill | 10.36 | 314242 | 51°27′39″N 0°06′59″W / 51.4607°N 0.1163°W | 30199 | 26136 | 25083 | 137 | 4520 | 18408 | NaN | 114899 | 72726 | 292178 |
22 | Lewisham | Lewisham London Borough Council | Labour | Town Hall, 1 Catford Road | 13.57 | 286180 | 51°26′43″N 0°01′15″W / 51.4452°N 0.0209°W | 24871 | 24810 | 16825 | 262 | 3809 | 10455 | NaN | 70382 | 63652 | 215137 |
23 | Merton | Merton London Borough Council | Labour | Civic Centre, London Road | 14.52 | 203223 | 51°24′05″N 0°11′45″W / 51.4014°N 0.1958°W | 16485 | 14339 | 6651 | 111 | 1571 | 4021 | NaN | 44128 | 28322 | 115654 |
24 | Newham | Newham London Borough Council | Labour | Newham Dockside, 1000 Dockside Road | 13.98 | 318227 | 51°30′28″N 0°02′49″E / 51.5077°N 0.0469°E | 25356 | 24177 | 18389 | 323 | 4456 | 16913 | NaN | 106146 | 66221 | 262024 |
25 | Redbridge | Redbridge London Borough Council | Labour | Town Hall, 128-142 High Road | 21.78 | 288272 | 51°33′32″N 0°04′27″E / 51.5590°N 0.0741°E | 26735 | 17543 | 15736 | 284 | 2619 | 7688 | NaN | 71496 | 41430 | 183562 |
26 | Richmond upon Thames | Richmond upon Thames London Borough Council | Liberal Democrat | Civic Centre, 44 York Street | 22.17 | 191365 | 51°26′52″N 0°19′34″W / 51.4479°N 0.3260°W | 16097 | 11722 | 4707 | 37 | 1420 | 1590 | NaN | 40858 | 20314 | 96771 |
27 | Southwark | Southwark London Borough Council | Labour | 160 Tooley Street | 11.14 | 298464 | 51°30′13″N 0°04′49″W / 51.5035°N 0.0804°W | 27980 | 24450 | 27381 | 321 | 4696 | 16153 | NaN | 109432 | 68356 | 278809 |
28 | Sutton | Sutton London Borough Council | Liberal Democrat | Civic Offices, St Nicholas Way | 16.93 | 195914 | 51°21′42″N 0°11′40″W / 51.3618°N 0.1945°W | 13207 | 14474 | 4586 | 57 | 1393 | 2308 | NaN | 39533 | 25409 | 100987 |
29 | Tower Hamlets | Tower Hamlets London Borough Council | Labour | Town Hall, Mulberry Place, 5 Clove Crescent | 7.63 | 272890 | 51°30′36″N 0°00′21″W / 51.5099°N 0.0059°W | 21510 | 21593 | 23408 | 124 | 4268 | 10050 | NaN | 87620 | 59993 | 228613 |
30 | Waltham Forest | Waltham Forest London Borough Council | Labour | Waltham Forest Town Hall, Forest Road | 14.99 | 265797 | 51°35′27″N 0°00′48″W / 51.5908°N 0.0134°W | 25565 | 20459 | 14101 | 236 | 3040 | 10606 | NaN | 77940 | 51898 | 203879 |
31 | Wandsworth | Wandsworth London Borough Council | Conservative | The Town Hall, Wandsworth High Street | 13.23 | 310516 | 51°27′24″N 0°11′28″W / 51.4567°N 0.1910°W | 25533 | 19630 | 9493 | 161 | 3091 | 8398 | NaN | 92523 | 45865 | 204741 |
32 | Westminster | Westminster City Council | Conservative | Westminster City Hall, 64 Victoria Street | 8.29 | 226841 | 51°29′50″N 0°08′14″W / 51.4973°N 0.1372°W | 29295 | 20405 | 34031 | 273 | 6148 | 15752 | NaN | 277617 | 71448 | 455028 |
# shape of the dataframe
Ld_crime.shape
(33, 17)
Exploratory Data Analysis
# descriptive statistics of the data
London_crime.describe()
Burglary | Criminal Damage | Drugs | Fraud or Forgery | Other Notifiable Offenses | Robbery | Sexual Offences | Theft and Handling | Violence Against the Person | Total | |
---|---|---|---|---|---|---|---|---|---|---|
count | 33.000000 | 33.000000 | 33.000000 | 33.000000 | 33.000000 | 33.000000 | 33.000000 | 33.000000 | 33.000000 | 33.000000 |
mean | 22857.363636 | 19119.333333 | 14265.606061 | 161.363636 | 3222.696970 | 7844.636364 | 38.575758 | 80662.454545 | 47214.575758 | 195386.606061 |
std | 7452.366846 | 5942.903618 | 7544.259564 | 81.603775 | 1362.107294 | 4677.643075 | 15.139002 | 45155.624776 | 17226.165191 | 79148.057551 |
min | 15.000000 | 16.000000 | 33.000000 | 0.000000 | 17.000000 | 24.000000 | 0.000000 | 561.000000 | 114.000000 | 780.000000 |
25% | 18103.000000 | 17244.000000 | 8942.000000 | 106.000000 | 2358.000000 | 4744.000000 | 27.000000 | 52609.000000 | 33968.000000 | 149447.000000 |
50% | 24871.000000 | 20405.000000 | 14101.000000 | 157.000000 | 3293.000000 | 7688.000000 | 40.000000 | 77940.000000 | 50943.000000 | 203879.000000 |
75% | 27980.000000 | 22755.000000 | 18389.000000 | 207.000000 | 3963.000000 | 10084.000000 | 47.000000 | 92523.000000 | 59993.000000 | 228613.000000 |
max | 36981.000000 | 31218.000000 | 34031.000000 | 323.000000 | 6504.000000 | 18408.000000 | 71.000000 | 277617.000000 | 72726.000000 | 455028.000000 |
# import libraries for plotting
import matplotlib as mpl
import matplotlib.pyplot as plt
import matplotlib.cm as cm
import matplotlib.colors as colors
'ggplot') mpl.style.use(
Check if the column names are strings.
= list(map(str, Ld_crime.columns))
Ld_crime.columns
# check the column labels type
all(isinstance(column, str) for column in Ld_crime.columns)
True
Let’s sort the total crimes in descending order to see 5 boroughs with the highest number of crimes.
'Total'], ascending=False, axis=0, inplace=True)
Ld_crime.sort_values([
= Ld_crime.head()
df_top5 df_top5
Borough | Local authority | Political control | Headquarters | Area (sq mi) | Population | Co-ordinates | Burglary | Criminal Damage | Drugs | Fraud or Forgery | Other Notifiable Offenses | Robbery | Sexual Offenses | Theft and Handling | Violence Against the Person | Total | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32 | Westminster | Westminster City Council | Conservative | Westminster City Hall, 64 Victoria Street | 8.29 | 226841 | 51°29′50″N 0°08′14″W / 51.4973°N 0.1372°W | 29295 | 20405 | 34031 | 273 | 6148 | 15752 | NaN | 277617 | 71448 | 455028 |
21 | Lambeth | Lambeth London Borough Council | Labour | Lambeth Town Hall, Brixton Hill | 10.36 | 314242 | 51°27′39″N 0°06′59″W / 51.4607°N 0.1163°W | 30199 | 26136 | 25083 | 137 | 4520 | 18408 | NaN | 114899 | 72726 | 292178 |
27 | Southwark | Southwark London Borough Council | Labour | 160 Tooley Street | 11.14 | 298464 | 51°30′13″N 0°04′49″W / 51.5035°N 0.0804°W | 27980 | 24450 | 27381 | 321 | 4696 | 16153 | NaN | 109432 | 68356 | 278809 |
5 | Camden | Camden London Borough Council | Labour | Camden Town Hall, Judd Street | 8.40 | 229719 | 51°31′44″N 0°07′32″W / 51.5290°N 0.1255°W | 27939 | 18482 | 21816 | 123 | 3857 | 9286 | NaN | 140596 | 53012 | 275147 |
24 | Newham | Newham London Borough Council | Labour | Newham Dockside, 1000 Dockside Road | 13.98 | 318227 | 51°30′28″N 0°02′49″E / 51.5077°N 0.0469°E | 25356 | 24177 | 18389 | 323 | 4456 | 16913 | NaN | 106146 | 66221 | 262024 |
Let’s visualize these 5 boroughs.
= df_top5[['Borough','Total']]
df_tt
'Borough',inplace = True)
df_tt.set_index(
= df_tt.plot(kind='bar', figsize=(10, 6), rot=0)
ax
'Number of Crimes')
ax.set_ylabel('Borough')
ax.set_xlabel('London Boroughs with the Highest no. of crime')
ax.set_title(
# create a function to display the percentage.
for p in ax.patches:
round(p.get_height(),decimals=2),
ax.annotate(np.+p.get_width()/2., p.get_height()),
(p.get_x()='center',
ha='center',
va=(0, 10),
xytext='offset points',
textcoords= 14
fontsize
)
plt.show()
Okay. Now we know which places you need to stay away from.
Now, let’s sort the total crimes in ascending order to see 5 boroughs with the lowest number of crimes.
'Total'], ascending=True, axis=0, inplace=True)
Ld_crime.sort_values([
= Ld_crime.head()
df_bot5 df_bot5
Borough | Local authority | Political control | Headquarters | Area (sq mi) | Population | Co-ordinates | Burglary | Criminal Damage | Drugs | Fraud or Forgery | Other Notifiable Offenses | Robbery | Sexual Offenses | Theft and Handling | Violence Against the Person | Total | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6 | City of London | Corporation of London;Inner Temple;Middle Temple | ? | Guildhall | 1.12 | 7000 | 51°30′56″N 0°05′32″W / 51.5155°N 0.0922°W | 15 | 16 | 33 | 0 | 17 | 24 | NaN | 561 | 114 | 780 |
20 | Kingston upon Thames | Kingston upon Thames London Borough Council | Liberal Democrat | Guildhall, High Street | 14.38 | 166793 | 51°24′31″N 0°18′23″W / 51.4085°N 0.3064°W | 10131 | 10610 | 5682 | 65 | 1332 | 1702 | NaN | 38226 | 21540 | 89306 |
26 | Richmond upon Thames | Richmond upon Thames London Borough Council | Liberal Democrat | Civic Centre, 44 York Street | 22.17 | 191365 | 51°26′52″N 0°19′34″W / 51.4479°N 0.3260°W | 16097 | 11722 | 4707 | 37 | 1420 | 1590 | NaN | 40858 | 20314 | 96771 |
28 | Sutton | Sutton London Borough Council | Liberal Democrat | Civic Offices, St Nicholas Way | 16.93 | 195914 | 51°21′42″N 0°11′40″W / 51.3618°N 0.1945°W | 13207 | 14474 | 4586 | 57 | 1393 | 2308 | NaN | 39533 | 25409 | 100987 |
2 | Bexley | Bexley London Borough Council | Conservative | Civic Offices, 2 Watling Street | 23.38 | 236687 | 51°27′18″N 0°09′02″E / 51.4549°N 0.1505°E | 14973 | 17244 | 7346 | 106 | 1999 | 2338 | NaN | 40071 | 30037 | 114136 |
Let’s visualize these 5 boroughs.
= df_bot5[['Borough','Total']]
df_bt
'Borough',inplace = True)
df_bt.set_index(
= df_bt.plot(kind='bar', figsize=(10, 6), rot=0)
ax
'Number of Crimes')
ax.set_ylabel('Borough')
ax.set_xlabel('London Boroughs with the least no. of crime')
ax.set_title(
# create a function to display the percentage.
for p in ax.patches:
round(p.get_height(),decimals=2),
ax.annotate(np.+p.get_width()/2., p.get_height()),
(p.get_x()='center',
ha='center',
va=(0, 10),
xytext='offset points',
textcoords= 14
fontsize
)
plt.show()
The borough City of London has the lowest crime recorded over the years. Let’s look into its details.
= df_bot5[df_bot5['Borough'] == 'City of London']
df_col = df_col[['Borough','Total','Area (sq mi)','Population']]
df_col df_col
Borough | Total | Area (sq mi) | Population | |
---|---|---|---|---|
6 | City of London | 780 | 1.12 | 7000 |
According to the London Boroughs Wikipedia page, the City of London is the 33rd principal division of Greater London, but it is not a London borough. You also realise that living in this area would be very expensive and you’re not looking to spend most of your income on rent.
So let’s focus on the next safest borough i.e. Kingston upon Thames, just to keep our options open.
Visualize different types of crimes in the borough ‘Kingston upon Thames’.
= df_bot5[df_bot5['Borough'] == 'Kingston upon Thames']
df_bc1
= df_bc1[['Borough', 'Burglary', 'Criminal Damage', 'Drugs', 'Fraud or Forgery', 'Other Notifiable Offenses',
df_bc 'Robbery', 'Sexual Offenses', 'Theft and Handling', 'Violence Against the Person']]
'Borough', inplace=True)
df_bc.set_index(
= df_bc.plot(kind='bar', figsize=(10, 6), rot=0)
ax
'Number of Crimes')
ax.set_ylabel('Borough')
ax.set_xlabel('Crimes in Kingston upon Thames')
ax.set_title(
# create a function to display the percentage.
for p in ax.patches:
round(p.get_height(),decimals=2),
ax.annotate(np.+p.get_width()/2., p.get_height()),
(p.get_x()='center',
ha='center',
va=(0, 10),
xytext='offset points',
textcoords= 14
fontsize
)
plt.show()
This borough is a great option for you to live in and is also extremely safe compared to the other boroughs.
Dataset of the Neighborhood
The list of Neighborhoods in the Royal Borough of Kingston upon Thames can be found here.
= ['Berrylands','Canbury','Chessington','Coombe','Kingston upon Thames','Kingston Vale',
Neighborhood 'Malden Rushett','Motspur Park','New Malden','Norbiton','Old Malden','Surbiton','Tolworth']
= ['Kingston upon Thames','Kingston upon Thames','Kingston upon Thames','Kingston upon Thames','Kingston upon Thames',
Borough 'Kingston upon Thames','Kingston upon Thames','Kingston upon Thames','Kingston upon Thames','Kingston upon Thames',
'Kingston upon Thames','Kingston upon Thames','Kingston upon Thames']
= ['','','','','','','','','','','','','']
Latitude = ['','','','','','','','','','','','','']
Longitude
= {'Neighborhood':Neighborhood, 'Borough':Borough, 'Latitude':Latitude, 'Longitude':Longitude}
df_neigh = pd.DataFrame(data=df_neigh, columns=['Neighborhood', 'Borough', 'Latitude', 'Longitude'], index=None)
kut_neigh
kut_neigh
Neighborhood | Borough | Latitude | Longitude | |
---|---|---|---|---|
0 | Berrylands | Kingston upon Thames | ||
1 | Canbury | Kingston upon Thames | ||
2 | Chessington | Kingston upon Thames | ||
3 | Coombe | Kingston upon Thames | ||
4 | Kingston upon Thames | Kingston upon Thames | ||
5 | Kingston Vale | Kingston upon Thames | ||
6 | Malden Rushett | Kingston upon Thames | ||
7 | Motspur Park | Kingston upon Thames | ||
8 | New Malden | Kingston upon Thames | ||
9 | Norbiton | Kingston upon Thames | ||
10 | Old Malden | Kingston upon Thames | ||
11 | Surbiton | Kingston upon Thames | ||
12 | Tolworth | Kingston upon Thames |
Find the co-ordinates of each neighborhood in the Kingston upon Thames borough.
= []
Latitude = []
Longitude
for i in range(len(Neighborhood)):
= '{}, London, United Kingdom'.format(Neighborhood[i])
address = Nominatim(user_agent='London_agent')
geolocator = geolocator.geocode(address)
location
Latitude.append(location.latitude)
Longitude.append(location.longitude)
print(Latitude, Longitude)
[51.3937811, 51.41749865, 51.358336, 51.4194499, 51.4096275, 51.43185, 51.3410523, 51.3909852, 51.4053347, 51.4099994, 51.382484, 51.3937557, 51.3788758] [-0.2848024, -0.30555280504926163, -0.2986216, -0.2653985, -0.3062621, -0.2581379, -0.3190757, -0.2488979, -0.2634066, -0.2873963, -0.2590897, -0.3033105, -0.2828604]
= {'Neighborhood':Neighborhood, 'Borough':Borough, 'Latitude':Latitude, 'Longitude':Longitude}
df_neigh = pd.DataFrame(data=df_neigh, columns=['Neighborhood', 'Borough', 'Latitude', 'Longitude'], index=None)
kut_neigh
kut_neigh
Neighborhood | Borough | Latitude | Longitude | |
---|---|---|---|---|
0 | Berrylands | Kingston upon Thames | 51.393781 | -0.284802 |
1 | Canbury | Kingston upon Thames | 51.417499 | -0.305553 |
2 | Chessington | Kingston upon Thames | 51.358336 | -0.298622 |
3 | Coombe | Kingston upon Thames | 51.419450 | -0.265398 |
4 | Kingston upon Thames | Kingston upon Thames | 51.409627 | -0.306262 |
5 | Kingston Vale | Kingston upon Thames | 51.431850 | -0.258138 |
6 | Malden Rushett | Kingston upon Thames | 51.341052 | -0.319076 |
7 | Motspur Park | Kingston upon Thames | 51.390985 | -0.248898 |
8 | New Malden | Kingston upon Thames | 51.405335 | -0.263407 |
9 | Norbiton | Kingston upon Thames | 51.409999 | -0.287396 |
10 | Old Malden | Kingston upon Thames | 51.382484 | -0.259090 |
11 | Surbiton | Kingston upon Thames | 51.393756 | -0.303310 |
12 | Tolworth | Kingston upon Thames | 51.378876 | -0.282860 |
Let’s get the co-ordinates of Berrylands, which is the center neighborhood of the Kingston upon Thames borough.
= 'Berrylands, London, United Kingdom'
address
= Nominatim(user_agent='ld_explorer')
geolocator = geolocator.geocode(address)
location = location.latitude
latitude = location.longitude
longitude print('The geographical co-ordinates of Berrylands, London are {}, {}.'.format(latitude, longitude))
The geographical co-ordinates of Berrylands, London are 51.3937811, -0.2848024.
Let’s visualize the neighborhood of Kingston upon Thames borough.
# create map of London using latitude and longitude values
= folium.Map(location=[latitude, longitude], zoom_start=12)
map_lon
# add markers to map
for lat, lng, borough, neighborhood in zip(kut_neigh['Latitude'], kut_neigh['Longitude'],
'Borough'], kut_neigh['Neighborhood']):
kut_neigh[= '{}, {}'.format(neighborhood, borough)
label = folium.Popup(label, parse_html=True)
label =5, popup=label, color='blue', fill=True,
folium.CircleMarker([lat, lng], radius='#3186cc', fill_opacity=0.7, parse_html=False).add_to(map_lon)
fill_color
map_lon
Modeling
- Find all the venues within a 500 meter radius of each neighborhood.
- Perform one hot encoding on the venues data.
- Group the venues by the neighborhood and calculate their mean.
- Perform a k-means clustering.
Create a function to extract the venues from each Neighborhood
def getNearbyVenues(names, latitudes, longitudes, radius=500):
=[]
venues_listfor name, lat, lng in zip(names, latitudes, longitudes):
print(name)
# create the API request URL
= 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}&limit={}'.format(
url
CLIENT_ID,
CLIENT_SECRET,
VERSION,
lat,
lng,
radius,
LIMIT)
# make the GET request
= requests.get(url).json()['response']['groups'][0]['items']
results
# return only relevant information for each nearby venue
venues_list.append([(
name,
lat,
lng, 'venue']['name'],
v['venue']['location']['lat'],
v['venue']['location']['lng'],
v['venue']['categories'][0]['name']) for v in results])
v[
= pd.DataFrame([item for venue_list in venues_list for item in venue_list])
nearby_venues = ['Neighborhood',
nearby_venues.columns 'Neighborhood Latitude',
'Neighborhood Longitude',
'Venue',
'Venue Latitude',
'Venue Longitude',
'Venue Category']
return(nearby_venues)
= getNearbyVenues(names=kut_neigh['Neighborhood'],
kut_venues=kut_neigh['Latitude'],
latitudes=kut_neigh['Longitude']) longitudes
Berrylands
Canbury
Chessington
Coombe
Kingston upon Thames
Kingston Vale
Malden Rushett
Motspur Park
New Malden
Norbiton
Old Malden
Surbiton
Tolworth
print(kut_venues.shape)
kut_venues.head()
(171, 7)
Neighborhood | Neighborhood Latitude | Neighborhood Longitude | Venue | Venue Latitude | Venue Longitude | Venue Category | |
---|---|---|---|---|---|---|---|
0 | Berrylands | 51.393781 | -0.284802 | Surbiton Racket & Fitness Club | 51.392676 | -0.290224 | Gym / Fitness Center |
1 | Berrylands | 51.393781 | -0.284802 | Alexandra Park | 51.394230 | -0.281206 | Park |
2 | Berrylands | 51.393781 | -0.284802 | K2 Bus Stop | 51.392302 | -0.281534 | Bus Stop |
3 | Canbury | 51.417499 | -0.305553 | Canbury Gardens | 51.417409 | -0.305300 | Park |
4 | Canbury | 51.417499 | -0.305553 | The Grey Horse | 51.414192 | -0.300759 | Pub |
'Neighborhood').count() kut_venues.groupby(
Neighborhood Latitude | Neighborhood Longitude | Venue | Venue Latitude | Venue Longitude | Venue Category | |
---|---|---|---|---|---|---|
Neighborhood | ||||||
Berrylands | 3 | 3 | 3 | 3 | 3 | 3 |
Canbury | 14 | 14 | 14 | 14 | 14 | 14 |
Coombe | 1 | 1 | 1 | 1 | 1 | 1 |
Kingston Vale | 4 | 4 | 4 | 4 | 4 | 4 |
Kingston upon Thames | 50 | 50 | 50 | 50 | 50 | 50 |
Malden Rushett | 4 | 4 | 4 | 4 | 4 | 4 |
Motspur Park | 4 | 4 | 4 | 4 | 4 | 4 |
New Malden | 8 | 8 | 8 | 8 | 8 | 8 |
Norbiton | 28 | 28 | 28 | 28 | 28 | 28 |
Old Malden | 3 | 3 | 3 | 3 | 3 | 3 |
Surbiton | 33 | 33 | 33 | 33 | 33 | 33 |
Tolworth | 19 | 19 | 19 | 19 | 19 | 19 |
print('There are {} uniques categories.'.format(len(kut_venues['Venue Category'].unique())))
There are 72 uniques categories.
One hot encoding
# one hot encoding
= pd.get_dummies(kut_venues[['Venue Category']], prefix='', prefix_sep='')
kut_onehot
# add neighborhood column back to the dataframe
'Neighborhood'] = kut_venues['Neighborhood']
kut_onehot[
# move neighborhood column to the first column
= [kut_onehot.columns[-1]] + list(kut_onehot.columns[:-1])
fixed_columns = kut_onehot[fixed_columns]
kut_onehot
kut_onehot.head()
Neighborhood | Asian Restaurant | Athletics & Sports | Auto Garage | Bakery | Bar | Beer Bar | Bistro | Bookstore | Bowling Alley | … | Spa | Stationery Store | Supermarket | Sushi Restaurant | Tea Room | Thai Restaurant | Theater | Train Station | Turkish Restaurant | Wine Shop | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Berrylands | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | … | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1 | Berrylands | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | … | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2 | Berrylands | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | … | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
3 | Canbury | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | … | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
4 | Canbury | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | … | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
5 rows × 73 columns
Group the rows by neighborhood and take the mean of the frequency of coocurence of each category.
= kut_onehot.groupby('Neighborhood').mean().reset_index()
kut_grouped kut_grouped
Neighborhood | Asian Restaurant | Athletics & Sports | Auto Garage | Bakery | Bar | Beer Bar | Bistro | Bookstore | Bowling Alley | … | Spa | Stationery Store | Supermarket | Sushi Restaurant | Tea Room | Thai Restaurant | Theater | Train Station | Turkish Restaurant | Wine Shop | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Berrylands | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 | … | 0.000000 | 0.00 | 0.000000 | 0.000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 |
1 | Canbury | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 | … | 0.071429 | 0.00 | 0.071429 | 0.000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 |
2 | Coombe | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 | … | 0.000000 | 0.00 | 0.000000 | 0.000 | 1.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 |
3 | Kingston Vale | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.250000 | 0.00 | 0.000000 | 0.00 | 0.000000 | … | 0.000000 | 0.00 | 0.000000 | 0.000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 |
4 | Kingston upon Thames | 0.02 | 0.000000 | 0.000000 | 0.020000 | 0.000000 | 0.02 | 0.000000 | 0.02 | 0.000000 | … | 0.000000 | 0.02 | 0.020000 | 0.040 | 0.000000 | 0.040000 | 0.02 | 0.000000 | 0.02 | 0.000000 |
5 | Malden Rushett | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 | … | 0.000000 | 0.00 | 0.000000 | 0.000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 |
6 | Motspur Park | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 | … | 0.000000 | 0.00 | 0.000000 | 0.000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 |
7 | New Malden | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.125000 | 0.00 | 0.000000 | 0.00 | 0.000000 | … | 0.000000 | 0.00 | 0.125000 | 0.125 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 |
8 | Norbiton | 0.00 | 0.035714 | 0.035714 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 | … | 0.000000 | 0.00 | 0.035714 | 0.000 | 0.000000 | 0.035714 | 0.00 | 0.000000 | 0.00 | 0.035714 |
9 | Old Malden | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.000000 | … | 0.000000 | 0.00 | 0.000000 | 0.000 | 0.000000 | 0.000000 | 0.00 | 0.333333 | 0.00 | 0.000000 |
10 | Surbiton | 0.00 | 0.000000 | 0.000000 | 0.030303 | 0.030303 | 0.00 | 0.030303 | 0.00 | 0.000000 | … | 0.000000 | 0.00 | 0.030303 | 0.000 | 0.030303 | 0.030303 | 0.00 | 0.030303 | 0.00 | 0.000000 |
11 | Tolworth | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.00 | 0.052632 | … | 0.000000 | 0.00 | 0.000000 | 0.000 | 0.000000 | 0.052632 | 0.00 | 0.052632 | 0.00 | 0.000000 |
12 rows × 73 columns
# dimensions of the dataframe
kut_grouped.shape
(12, 73)
= 5
num_top_venues
for hood in kut_grouped['Neighborhood']:
print('----'+hood+'----')
= kut_grouped[kut_grouped['Neighborhood'] == hood].T.reset_index()
temp = ['venue', 'freq']
temp.columns = temp.iloc[1:]
temp 'freq'] = temp['freq'].astype(float)
temp[= temp.round({'freq': 2})
temp print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
print('\n')
----Berrylands----
venue freq
0 Gym / Fitness Center 0.33
1 Park 0.33
2 Bus Stop 0.33
3 Portuguese Restaurant 0.00
4 Plaza 0.00
----Canbury----
venue freq
0 Pub 0.29
1 Plaza 0.07
2 Park 0.07
3 Hotel 0.07
4 Indian Restaurant 0.07
----Coombe----
venue freq
0 Tea Room 1.0
1 Asian Restaurant 0.0
2 Market 0.0
3 Platform 0.0
4 Pizza Place 0.0
----Kingston Vale----
venue freq
0 Grocery Store 0.25
1 Bar 0.25
2 Sandwich Place 0.25
3 Soccer Field 0.25
4 Asian Restaurant 0.00
----Kingston upon Thames----
venue freq
0 Coffee Shop 0.12
1 Café 0.08
2 Department Store 0.06
3 Thai Restaurant 0.04
4 Clothing Store 0.04
----Malden Rushett----
venue freq
0 Convenience Store 0.25
1 Restaurant 0.25
2 Garden Center 0.25
3 Pub 0.25
4 Park 0.00
----Motspur Park----
venue freq
0 Gym 0.25
1 Restaurant 0.25
2 Park 0.25
3 Soccer Field 0.25
4 Mexican Restaurant 0.00
----New Malden----
venue freq
0 Gym 0.12
1 Indian Restaurant 0.12
2 Bar 0.12
3 Gastropub 0.12
4 Korean Restaurant 0.12
----Norbiton----
venue freq
0 Indian Restaurant 0.11
1 Italian Restaurant 0.07
2 Food 0.07
3 Pub 0.07
4 Wine Shop 0.04
----Old Malden----
venue freq
0 Pub 0.33
1 Food 0.33
2 Train Station 0.33
3 Platform 0.00
4 Pizza Place 0.00
----Surbiton----
venue freq
0 Coffee Shop 0.18
1 Pub 0.12
2 Italian Restaurant 0.06
3 Pharmacy 0.06
4 Grocery Store 0.06
----Tolworth----
venue freq
0 Grocery Store 0.16
1 Restaurant 0.11
2 Indian Restaurant 0.05
3 Bus Stop 0.05
4 Discount Store 0.05
Create a dataframe of the venues.
First, create a function to sort the venues in descending order.
def return_most_common_venues(row, num_top_venues):
= row.iloc[1:]
row_categories = row_categories.sort_values(ascending=False)
row_categories_sorted
return row_categories_sorted.index.values[0:num_top_venues]
Create the new dataframe and display yhe top 10 venues for each neighborhood.
= 10
num_top_venues
= ['st', 'nd', 'rd']
indicators
# create columns according to tthe number of top venues
= ['Neighborhood']
columns for ind in np.arange(num_top_venues):
try:
'{}{} Most Common Venue'.format(ind+1, indicators[ind]))
columns.append(except:
'{}th Most Common Venue'.format(ind+1))
columns.append(
# create a new dataframe
= pd.DataFrame(columns=columns)
neighborhoods_venues_sorted 'Neighborhood'] = kut_grouped['Neighborhood']
neighborhoods_venues_sorted[
for ind in np.arange(kut_grouped.shape[0]):
1:] = return_most_common_venues(kut_grouped.iloc[ind, :], num_top_venues)
neighborhoods_venues_sorted.iloc[ind,
neighborhoods_venues_sorted.head()
Neighborhood | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
---|---|---|---|---|---|---|---|---|---|---|---|
0 | Berrylands | Gym / Fitness Center | Park | Bus Stop | Wine Shop | Fast Food Restaurant | Deli / Bodega | Department Store | Discount Store | Electronics Store | Farmers Market |
1 | Canbury | Pub | Shop & Service | Spa | Plaza | Café | Indian Restaurant | Hotel | Park | Supermarket | Gym / Fitness Center |
2 | Coombe | Tea Room | Wine Shop | Fast Food Restaurant | Cosmetics Shop | Deli / Bodega | Department Store | Discount Store | Electronics Store | Farmers Market | Fish & Chips Shop |
3 | Kingston Vale | Grocery Store | Bar | Sandwich Place | Soccer Field | Furniture / Home Store | Garden Center | Fried Chicken Joint | French Restaurant | Food | Fish & Chips Shop |
4 | Kingston upon Thames | Coffee Shop | Café | Department Store | Thai Restaurant | Sushi Restaurant | Burger Joint | Pub | Clothing Store | Italian Restaurant | Asian Restaurant |
Cluster similar neighborhoods together using k-means clustering
# import k-means
from sklearn.cluster import KMeans
# set the number of clusters
= 5
kclusters
= kut_grouped.drop('Neighborhood', 1)
kut_grouped_clustering
# run k-means clustering
= KMeans(n_clusters=kclusters, random_state=0).fit(kut_grouped_clustering)
kmeans
# check cluster labels generated for each row in the dataframe
0:10] kmeans.labels_[
array([3, 1, 0, 2, 1, 1, 2, 1, 1, 4])
# add clustering labels
0,'Cluster Labels', kmeans.labels_)
neighborhoods_venues_sorted.insert(
= kut_neigh
kut_merged
# merge kut_grouped with kut_neigh to add latitude/longitude for each neighborhood
= kut_merged.join(neighborhoods_venues_sorted.set_index('Neighborhood'), on='Neighborhood')
kut_merged
kut_merged.head()
Neighborhood | Borough | Latitude | Longitude | Cluster Labels | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Berrylands | Kingston upon Thames | 51.393781 | -0.284802 | 3.0 | Gym / Fitness Center | Park | Bus Stop | Wine Shop | Fast Food Restaurant | Deli / Bodega | Department Store | Discount Store | Electronics Store | Farmers Market |
1 | Canbury | Kingston upon Thames | 51.417499 | -0.305553 | 1.0 | Pub | Shop & Service | Spa | Plaza | Café | Indian Restaurant | Hotel | Park | Supermarket | Gym / Fitness Center |
2 | Chessington | Kingston upon Thames | 51.358336 | -0.298622 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
3 | Coombe | Kingston upon Thames | 51.419450 | -0.265398 | 0.0 | Tea Room | Wine Shop | Fast Food Restaurant | Cosmetics Shop | Deli / Bodega | Department Store | Discount Store | Electronics Store | Farmers Market | Fish & Chips Shop |
4 | Kingston upon Thames | Kingston upon Thames | 51.409627 | -0.306262 | 1.0 | Coffee Shop | Café | Department Store | Thai Restaurant | Sushi Restaurant | Burger Joint | Pub | Clothing Store | Italian Restaurant | Asian Restaurant |
kut_merged.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 13 entries, 0 to 12
Data columns (total 15 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 Neighborhood 13 non-null object
1 Borough 13 non-null object
2 Latitude 13 non-null float64
3 Longitude 13 non-null float64
4 Cluster Labels 12 non-null float64
5 1st Most Common Venue 12 non-null object
6 2nd Most Common Venue 12 non-null object
7 3rd Most Common Venue 12 non-null object
8 4th Most Common Venue 12 non-null object
9 5th Most Common Venue 12 non-null object
10 6th Most Common Venue 12 non-null object
11 7th Most Common Venue 12 non-null object
12 8th Most Common Venue 12 non-null object
13 9th Most Common Venue 12 non-null object
14 10th Most Common Venue 12 non-null object
dtypes: float64(3), object(12)
memory usage: 1.6+ KB
# drop the rows with NaN value
=True) kut_merged.dropna(inplace
kut_merged.shape
(12, 15)
'Cluster Labels'] = kut_merged['Cluster Labels'].astype(int)
kut_merged[
kut_merged.info()
<class 'pandas.core.frame.DataFrame'>
Int64Index: 12 entries, 0 to 12
Data columns (total 15 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 Neighborhood 12 non-null object
1 Borough 12 non-null object
2 Latitude 12 non-null float64
3 Longitude 12 non-null float64
4 Cluster Labels 12 non-null int32
5 1st Most Common Venue 12 non-null object
6 2nd Most Common Venue 12 non-null object
7 3rd Most Common Venue 12 non-null object
8 4th Most Common Venue 12 non-null object
9 5th Most Common Venue 12 non-null object
10 6th Most Common Venue 12 non-null object
11 7th Most Common Venue 12 non-null object
12 8th Most Common Venue 12 non-null object
13 9th Most Common Venue 12 non-null object
14 10th Most Common Venue 12 non-null object
dtypes: float64(2), int32(1), object(12)
memory usage: 1.5+ KB
Visualize the clusters
# create map
= folium.Map(location=[latitude, longitude], zoom_start=11.5)
map_clusters
# set color scheme for the clusters
= np.arange(kclusters)
x = [i + x + (i*x)**2 for i in range(kclusters)]
ys = cm.rainbow(np.linspace(0, 1, len(ys)))
colors_array = [colors.rgb2hex(i) for i in colors_array]
rainbow
# add markers to the map
= []
markers_colors for lat, lon, poi, cluster in zip(kut_merged['Latitude'], kut_merged['Longitude'], kut_merged['Neighborhood'], kut_merged['Cluster Labels']):
= folium.Popup(str(poi) + ' Cluster ' + str(cluster), parse_html=True)
label
folium.CircleMarker(
[lat, lon],=8,
radius=label,
popup=rainbow[cluster-1],
color=True,
fill=rainbow[cluster-1],
fill_color=0.5).add_to(map_clusters)
fill_opacity
map_clusters
Each cluster is color coded for the ease of presentation. We can see that the majority of the neighborhoods fall in the purple cluster, which is Cluster 1. Three neighborhoods have their own cluster, which are Red, Green and Yellow, i.e. Cluster 0, 3 and 4 respectively. The Blue cluster, which is Cluster 2, consists of three neighborhoods.
Analysis
Analyze each of the clusters to identify the characteristics of each cluster and the neighborhoods in them.
Examine the first cluster.
'Cluster Labels'] == 0] kut_merged[kut_merged[
Neighborhood | Borough | Latitude | Longitude | Cluster Labels | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | Coombe | Kingston upon Thames | 51.41945 | -0.265398 | 0 | Tea Room | Wine Shop | Fast Food Restaurant | Cosmetics Shop | Deli / Bodega | Department Store | Discount Store | Electronics Store | Farmers Market | Fish & Chips Shop |
Cluster 0 has only one neighborhood in it. The most common venues are Tea Rooms, Wine Shops, and Fast Food Restaurants.
Examine the second cluster.
'Cluster Labels'] == 1] kut_merged[kut_merged[
Neighborhood | Borough | Latitude | Longitude | Cluster Labels | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Canbury | Kingston upon Thames | 51.417499 | -0.305553 | 1 | Pub | Shop & Service | Spa | Plaza | Café | Indian Restaurant | Hotel | Park | Supermarket | Gym / Fitness Center |
4 | Kingston upon Thames | Kingston upon Thames | 51.409627 | -0.306262 | 1 | Coffee Shop | Café | Department Store | Thai Restaurant | Sushi Restaurant | Burger Joint | Pub | Clothing Store | Italian Restaurant | Asian Restaurant |
6 | Malden Rushett | Kingston upon Thames | 51.341052 | -0.319076 | 1 | Convenience Store | Pub | Garden Center | Restaurant | Farmers Market | Cosmetics Shop | Deli / Bodega | Department Store | Discount Store | Electronics Store |
8 | New Malden | Kingston upon Thames | 51.405335 | -0.263407 | 1 | Indian Restaurant | Korean Restaurant | Gastropub | Gym | Bar | Sushi Restaurant | Supermarket | Chinese Restaurant | Department Store | Discount Store |
9 | Norbiton | Kingston upon Thames | 51.409999 | -0.287396 | 1 | Indian Restaurant | Pub | Italian Restaurant | Food | Hardware Store | Pizza Place | Pharmacy | Japanese Restaurant | Hotel | Wine Shop |
11 | Surbiton | Kingston upon Thames | 51.393756 | -0.303310 | 1 | Coffee Shop | Pub | Grocery Store | Italian Restaurant | Pharmacy | Breakfast Spot | Gastropub | Fast Food Restaurant | Farmers Market | Gym / Fitness Center |
Cluster 1 has six neighborhods, the highest number of neighborhoods, in it. After examining these neighborhoods, we can see that the most common venues are Restaurants, Coffee shops, Cafes, Convenience Stores, Department Stores, Grocery Stores, Pubs, Shops & Services, and Spas. There are also Gyms, Spas and other Stores around. This seems to be a great cluster to live in.
Examine the third cluster.
'Cluster Labels'] == 2] kut_merged[kut_merged[
Neighborhood | Borough | Latitude | Longitude | Cluster Labels | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | Kingston Vale | Kingston upon Thames | 51.431850 | -0.258138 | 2 | Grocery Store | Bar | Sandwich Place | Soccer Field | Furniture / Home Store | Garden Center | Fried Chicken Joint | French Restaurant | Food | Fish & Chips Shop |
7 | Motspur Park | Kingston upon Thames | 51.390985 | -0.248898 | 2 | Soccer Field | Gym | Park | Restaurant | Farmers Market | Cosmetics Shop | Deli / Bodega | Department Store | Discount Store | Electronics Store |
12 | Tolworth | Kingston upon Thames | 51.378876 | -0.282860 | 2 | Grocery Store | Restaurant | Discount Store | Pharmacy | Pizza Place | Furniture / Home Store | Italian Restaurant | Bus Stop | Indian Restaurant | Hotel |
Cluster 2 has three bneighborhoods in it. The most common venues are Grocery Stores, Soccer Fields, Bars, Restaurants, Gyms, and Parks.
Examine the fourth cluster.
'Cluster Labels'] == 3] kut_merged[kut_merged[
Neighborhood | Borough | Latitude | Longitude | Cluster Labels | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Berrylands | Kingston upon Thames | 51.393781 | -0.284802 | 3 | Gym / Fitness Center | Park | Bus Stop | Wine Shop | Fast Food Restaurant | Deli / Bodega | Department Store | Discount Store | Electronics Store | Farmers Market |
Cluster 3 has only one neighborhood in it. The most common venues are Gyms, Parks, and Bus stops.
Examine the fifth cluster.
'Cluster Labels'] == 4] kut_merged[kut_merged[
Neighborhood | Borough | Latitude | Longitude | Cluster Labels | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | Old Malden | Kingston upon Thames | 51.382484 | -0.25909 | 4 | Train Station | Pub | Food | Wine Shop | Farmers Market | Cosmetics Shop | Deli / Bodega | Department Store | Discount Store | Electronics Store |
Cluster 4 has only one neighborhood in it. The most common venues are Train Stations, Pubs, and Food Joints.
Results
The aim of this project is to help people who want to relocate to the safest borough in London. Expats can chose the neighborhoods to which they want to relocate based on the most common venues in it. For example, if a person is looking for a neighborhood with good connectivity and public transportation we can see that Clusters 3 and 4 have Bus Stops and Train Stations respectively, as the most common venues. If a person is looking for a neighborhood with stores and restaurants in a close proximity, then the neighborhoods in the Cluster 1 is suitable. For a family, I feel that the neighborhoods in Cluster 2 are more suitable due to the common venues such as Parks, Gym/Fitness centers, Bus Stops, Restaurants, Grocery Stores and Soccer Fields, which is ideal for a family.
Conclusion
This project helps a person get a better understanding of the neighborhoods with respect to the most common venues in that neighborhood. It is always helpful to make use of technology to stay one step ahead i.e. finding out more about places before moving into a neighborhood. We have just taken safety as a primary concern to shortlist the borough of London. The future of this project includes taking other factors such as cost of living in the areas into consideration to shortlist the boroughs based on safety and a predefined budget.