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

edwardchalstrey1 commented 2 years ago

@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

[ ] colouring-cities/colouring-london#250

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)
- Note: we'll want the edits to be made in the usual way so they show up in the edit history - see colouring-cities/colouring-london#250
[ ] 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

We may have to test with just London data, until there is an available testing environment for "Colouring Birmingham" or as part of "Colouring Britain"
Before rolling out to production, we may want to come up with a way to differentiate computational edits vs manual - see comments in colouring-cities/colouring-london#250

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 commented 2 years ago

@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 commented 2 years ago

@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 commented 2 years ago

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

polly64 commented 10 months ago

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

colouring-cities / colouring-britain