Bronze level automatically awarded GB final

This data has achieved Bronze level on 02 December 2014 which means this data makes a great start at the basics of publishing open data.

Excel Mapping Template for London Boroughs, and Wards

Summary

Type of release
ongoing release of a series of related datasets

Licence
UK Open Government Licence

Verification
automatically awarded

Release Date
16 October 2014
Modified Date
16 October 2014
Update Frequency
Ad hoc
Publishers
Greater London Authority (GLA)
Keywords
gis, mapping, maps, wards

Community verification

Other people can verify whether the answers on this certificate are correct.

This certificate is automatically awarded.

Sign in to verify or report this certificate

Description

Have you ever wanted to create a quick thematic map of London but lacked the GIS skills or software to do it yourself? These free mapping tools from the GLA Intelligence Unit allows the user to input their own data to create an instant map that can be copied over into Word or another application of your choice. The user can also copy over the legend, and add labels. The template allows the user to select either 4 or 5 ranges, and it even has a function to change the colours on the map (default colours are blue). The tool now also allows users to input their own ranges, which will override the automatic ranges. There is: [**Standard borough thematic map**](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-London-boroughs.xls) [![](https://londondatastore-upload.s3.amazonaws.com/borough-map-template1.PNG)](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-London-boroughs.xls) [**Borough thematic map for categories**](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-London-boroughs-categoric.xls) (as opposed to numbers). And **ward maps for individual boroughs** see list below. Copyright notice: If you publish these maps, a copyright notice must be included within the report saying: "Contains Ordnance Survey data © Crown copyright and database rights." **Ward maps** Ward mapping tools for each borough have also been created. Select the borough you require from the list below: [**All** London Wards map with pre-2014 boundaries](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-london-ward-map-2013.xls) [Barking and Dagenham](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-B&D.xls), [Barnet](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Barnet.xls), [Bexley](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Bexley.xls), [Brent](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Brent.xls), [Bromley](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Bromley.xls), [Camden](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Camden.xls), [Croydon](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Croydon.xls), [Ealing](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Ealing.xls), [Enfield](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Enfield.xls), [Greenwich](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Greenwich.xls), [Hackney (pre 2014)](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hackney.xls), [Hammersmith and Fulham](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hammersmith&Fulham.xls), [Haringey](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Haringey.xls), [Harrow](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Harrow.xls), [Havering](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Havering.xls), [Hillingdon](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hillingdon.xls), [Hounslow](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hounslow.xls), [Islington](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Islington.xls), [Kensington and Chelsea (pre 2014)](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Ken&Chel.xls), [Kingston upon Thames](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Kingston.xls), [Lambeth](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Lambeth.xls), [Lewisham](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Lewisham.xls), [Merton](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Merton.xls), [Newham](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Newham.xls), [Redbridge](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Redbridge.xls), [Richmond upon Thames](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Richmond.xls), [Southwark](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Southwark.xls), [Sutton](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Sutton.xls), [Tower Hamlets (pre 2014)](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Tower-Hamlets.xls), [Waltham Forest](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Waltham-Forest.xls), [Wandsworth](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Wandsworth.xls), [Westminster](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Westminster.xls) New ward boundaries - came into effect from May 2014 [**All London wards map 2014**](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-london-ward-map-2014.xls) including the new ward boundaries for Hackney, Kensington and Chelsea, and Tower Hamlets following changes in May 2014. [Hackney](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hackney-2014.xls), [Kensington and Chelsea](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Ken&Chel-2014.xls), [Tower Hamlets](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Tower-Hamlets-2014.xls) ![Alt text](https://londondatastore-upload.s3.amazonaws.com/london-excel-map-thumb.JPG) NOTE: Excel 2003 users must 'ungroup' the map for it to work. Full instructions are contained within the spreadsheet. If you have any questions about these tools please contact [Gareth Piggott](mailto:gareth.piggott@london.gov.uk). **Macros** The tool works in any version of Excel. But the user MUST ENABLE MACROS, for the features to work. There a some restrictions on functionality in the ward maps in Excel 2003 and earlier - full instructions are included in the spreadsheet. To check whether the macros are enabled in Excel 2003 click Tools, Macro, Security and change the setting to Medium. Then you have to re-start Excel for the changes to take effect. When Excel starts up a prompt will ask if you want to enable macros - click yes. In Excel 2007 and later, it should be set by default to the correct setting, but if it has been changed, click on the Windows Office button in the top corner, then Excel options (at the bottom), Trust Centre, Trust Centre Settings, and make sure it is set to 'Disable all macros with notification'. Then when you open the spreadsheet, a prompt labelled 'Options' will appear at the top for you to enable macros. To create your own thematic borough maps in Excel using the ward map tool as a starting point, read these [instructions](https://londondatastore-upload.s3.amazonaws.com/create-excel-map-instructions.pdf). You will need to be a confident Excel user, and have access to your boundaries as a picture file from elsewhere. The mapping tools created here are all fully open access with no passwords.

General Information

Legal Information

  • This data was

    originally created or generated by its curator Do you think this data is incorrect? Let us know

  • The rights statement is at

    http://data.london.gov.uk/dataset/excel-mapping-template-for-london-boroughs-and-wards Do you think this data is incorrect? Let us know

  • This data is available under

    UK Open Government Licence Do you think this data is incorrect? Let us know

  • There are

    yes, and the rights are all held by the same person or organisation Do you think this data is incorrect? Let us know

  • The content is available under

    UK Open Government Licence Do you think this data is incorrect? Let us know

  • This data contains

    no data about individuals Do you think this data is incorrect? Let us know

Practical Information

  • The data appears in this collection

    http://data.london.gov.uk Do you think this data is incorrect? Let us know

  • This data changes

    no Do you think this data is incorrect? Let us know

Technical Information

Social Information

  • The documentation includes machine-readable data for

    title Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    description Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    release frequency Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    publisher Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    keyword(s) or tag(s) Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    distribution(s) Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    release date Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    modification date Do you think this data is incorrect? Let us know

Create a certificate

Don't have an account?

Don't worry, you can register later to save your work.

Create an account