Mapping London

Mapping London

• Improve data visualization • Enhance communication • Capture the audience’s attention • Display large amount of information Software examples • MapInfo • Arc GIS- Same functionality as MapInfo • Instant Atlas • MapQuest and others

Presenting Data

• Thematic mapping – Shaded/coloured map, Bar/Pie charts, Dot density, Grid • Point mapping – Uses X & Y coordinates to display geographical data or landmarks • Geo-coding – Uses postcode to display geographical data or landmarks

Thematic Mapping

• Map boundaries – – Supplied by ordnance survey (OS) • Different geographies – Regional, Local Authority, Ward, MSOA, LSOA

Thematic Mapping

• Data in Excel columns • Boundary Code – E.g. 00AC = Barnet 00AW 00AX 00AY 00AZ 00BA 00BB 00BC 00BD 00BE 00BF 00BG 00BH 00BJ 00BK

LACode

00AB 00AC 00AD 00AE 00AF 00AG 00AA 00AH 00AJ 00AK 00AL 00AM 00AN 00AP 00AQ 00AR 00AS 00AT 00AU

Local Authority

Barking and Dagenham Barnet Bexley Brent Bromley Camden City of London Corporation Croydon Ealing Enfield Greenwich Hackney Hammersmith and Fulham Haringey Harrow Havering Hillingdon Hounslow Islington Kensington and Chelsea Kingston upon Thames Lambeth Lewisham Merton Newham Redbridge Richmond upon Thames Southwark Sutton Tower Hamlets Waltham Forest Wandsworth Westminster

Hospital Admissions (NI39)

1973.67

1444.07

1287.05

1873.66

1431.26

1843.76

952.16

1657.79

2183.90

1586.30

1517.84

1986.43

2130.08

1948.82

1407.35

1547.66

1973.42

2061.43

2393.62

1209.81

1365.26

1684.65

1730.71

1419.97

2348.13

1625.02

1241.89

1524.31

1522.78

1840.68

2166.29

1671.09

1503.21

Thematic Mapping

• Map layers – Supplied by OS • Landmarks or points of interest such as rivers, roads or parks

Thematic Mapping

Point Mapping/Geo-coding

• Displaying geographical information such as landmarks – Use postcodes – Use X & Y coordinates- eastings and northings coordinates.

– Coordinates from a specific reference point on the earth’s surface – For example the coordinates for the Indian YMCA are X= 529229, Y=182087

Point Mapping/Geo-coding

• Mapping NHS organisations in London – Acute Trusts – Foundation Trusts – Mental Health Trusts – Primary Care Trusts • Converted postcodes to XY coordinates

Interactive Mapping

• MapInfo built in clickable PDF • Enable use of dynamic layers • Use this for point and thematic mapping • Enables users to select and use what they require

Interactive Mapping- Thematic

• Dynamic layers • Multiple indicators

Interactive Mapping

• MapInfo converts information into html allowing for web-based interactive maps.

Instant Atlas

• User friendly interactive maps • Quick to produce • More dynamic than MapInfo • Double map allows view of multiple indicators • Easy to access- web-based • Time-series

Instant Atlas- NOO example

Example in policy work

• London survey on attitudes towards alcohol – Average weekly spend by LA • Graph or map?

• No geographical visualisation with a graph

Local Authority

Newham Waltham Forest Barking & Dagenham Greenwich Southwark Brent Harrow Barnet Croydon Ealing Hounslow Redbridge Hillingdon Havering Enfield Bexley City of London Hackney Haringey Sutton Tower Hamlets Lewisham Kingston-Upon-Thames Bromley Lambeth Merton Hammersmith & Fulham Wandsworth Kensington & Chelsea Islington Richmond Upon Thames Westminster Camden

Mean Weekly Spend

4.2146

5.4661

5.7137

5.7295

6.0185

6.2302

6.2730

6.5470

6.6058

7.0265

7.1187

7.3953

7.4098

7.6197

7.9505

8.2046

8.2891

8.2891

8.6667

8.6744

8.9833

9.0929

9.8165

9.8899

10.2001

10.5526

11.0953

11.3926

11.9369

13.3151

14.3877

15.9459

16.2768

Example in policy work

Example in policy work

• What may be causing the high weekly spend?

• A high number of alcohol points of sale? • Wealthy residents?

– DCMS (Department for Culture, Media and Sport) data on number of licensed premises per borough.

– ONS data on residents per borough – Outlet density (number of residents per alcohol outlet)

Example in policy work

Example from policy work

• Association is not causation • More investigation always required – Cost benefit analysis of night time economy – Impact of interventions e.g change of licensing law

Mapping in the future

• People living on less than $1 a day

Mapping in the future

People earning over $200 a day