Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Data: Energy: Add London/Birmingham energy performance certificate (EPC) data #126

Open
3 tasks
edwardchalstrey1 opened this issue Aug 16, 2022 · 4 comments · May be fixed by colouring-cities/colouring-core#896
Open
3 tasks

Data: Energy: Add London/Birmingham energy performance certificate (EPC) data #126

edwardchalstrey1 opened this issue Aug 16, 2022 · 4 comments · May be fixed by colouring-cities/colouring-core#896

Comments

@edwardchalstrey1
Copy link

edwardchalstrey1 commented Aug 16, 2022 •
edited
Loading

@iagw has uploaded data at: https://github.com/iagw/colouring-cities

The dataset is split into two parquet files – which have the GLA (Greater London Authority) local authorities and the West Midlands Combined Authority local authorities.

The data has been reduced to the following columns:

importColumns = ['CURRENT_ENERGY_RATING',
                 'LODGEMENT_DATE',
                 'FLOOR_LEVEL',
                 'CONSTRUCTION_AGE_BAND',
                 'UPRN',
                 'EPCDatafromFile',
                 'TOID']

Prerequisite

Task

  • Create script(s) to add the above EPC data fields into the Colouring London database (i.e. add to buildings table via linking on TOID)
  • Colour buildings based on the colouring scheme used by the energy performance certificates themselves, i.e. the value of 'CURRENT_ENERGY_RATING' (see code snippet that has colours from the mapbox site for Birmingham below)

Note

Birmingham mapbox colours

'circle-color': [
    "match",
    [
        "get",
        "current_energy_rating"
    ],
    "A",
    "hsl(214,45%,49%)",

    "B",
    "hsl(150,86%,28%)",

    "C",
    "hsl(87,53%,56%)",

    "D",
    "hsl(58,87%,58%)",

    "E",
    "hsl(38,91%,59%)",

    "F",
    "hsl(20,87%,56%)",

    "G",
    "hsl(357,82%,53%)",
    "hsla(0, 0%, 0%, 0)",
],
@edwardchalstrey1
Copy link
Author

edwardchalstrey1 commented Aug 16, 2022 •
edited
Loading

@polly64 @iagw can you advise/remind me whether the new fields we can get from this data, presumably 'CURRENT_ENERGY_RATING', 'LODGEMENT_DATE', 'FLOOR_LEVEL', 'CONSTRUCTION_AGE_BAND', 'EPCDatafromFile' should be added to an existing category or a new category?

@polly64
Copy link

polly64 commented Aug 16, 2022 •
edited
Loading

@edwardchalstrey1

  • Current EPC energy rating goes under existing EPC category under SUSTAINABILITY - https://colouringlondon.org/view/sustainability/
  • ''Lodgement date' (currently no subcategory so would need to be added as 'date lodged/lodgement' under SUSTAINABILITY
  • 'Floor level'- not a subcategory so need to be added as ' EPC rating - floor level' under the EPC rating under SUSTAINABILITY
  • 'Construction Age band' goes under existing Year built. Best estimate under 'AGE" -https://colouringlondon.org/view/age/2523341
  • EPC data from file (not sure what this means? @iagw could you possibly add thoughts on this

@iagw
Copy link

iagw commented Aug 16, 2022 •
edited by edwardchalstrey1
Loading

Thanks @edwardchalstrey1, @polly64 and @dayjkbham
the floor level was more for internal consideration - rather than thinking at this stage it would be useful to put into the data - however, if it seems useful - then it could be of use. FYI - i've seen the floor level change between subsequent EPC surveys for the same UPRN
'Lodgement date' perhaps the subcategory could be 'epc lodgement date' to provide the 'epc' prefix to everything that comes from an epc certificate

EPC data from file (not sure what this means? @iagw could you possibly add thoughts on this

  • this is internal use - just to detail the file that data came from - so - could be dropped

This was referenced Aug 26, 2022
Draft
Closed
@polly64 polly64 transferred this issue from colouring-cities/colouring-core Dec 27, 2023
@polly64 polly64 changed the title Add London/Birmingham energy performance certificate (EPC) data DataL Energy: Add London/Birmingham energy performance certificate (EPC) data Jan 6, 2024
@polly64 polly64 changed the title DataL Energy: Add London/Birmingham energy performance certificate (EPC) data Data: Energy: Add London/Birmingham energy performance certificate (EPC) data Jan 6, 2024
@polly64
Copy link

polly64 commented Jan 6, 2024

@MKIM1008 let's talk re a comparison of loughboough and london epc age data with other age data we are generating

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add EPC data to Colouring London colouring-cities/colouring-core
3 participants
@edwardchalstrey1 @iagw @polly64