Compare councils with a score versus councils marked as no plan

[struan]

As a cross check for councils where we don't think they have a plan but they do.

[struan]

select council_id from scoring_planscore where total > 0 and council_id not in (select distinct council_id from caps_plandocument where document_type = 1);

-> 102 (has score, no action plan)

select council_id from scoring_planscore where total > 0 and council_id not in (select distinct council_id from caps_plandocument where document_type = 1or document_type = 2);

-> 32 (has score, no action plan or climate strategy)

[struan]

In response to this have added climate strategy to the documents included in the "has a plan" indicator on CAPE.

[struan]

For reference the councils where they have a score on scorecards but not an Action Plan or Climate Strategy in CAPE are:

Boston Borough Council Bromsgrove District Council City of Lincoln Council Elmbridge Borough Council Greater Manchester Combined Authority Leeds City Council London Borough of Hammersmith & Fulham Inverclyde Council London Borough of Sutton London Borough of Tower Hamlets Nottinghamshire County Council Oxfordshire County Council Ryedale District Council Stevenage Borough Council Southend-on-Sea Borough Council Swansea City Council Warwick District Council West Midlands Combined Authority Ards and North Down Borough Council Wrexham County Borough Council Rochdale Metropolitan Borough Council Calderdale Metropolitan Borough Council Bradford Metropolitan District Council Harborough District Council London Borough of Enfield Barrow-in-Furness Borough Council Birmingham City Council Oldham Metropolitan Borough Council Neath Port Talbot County Borough Council Perth and Kinross Council Salford City Council Rotherham Metropolitan Borough Council

[struan]

Also worth noting that

select name from scoring_planscore join caps_council on council_id = caps_council.id where total = 0 and council_id in (select distinct council_id from caps_plandocument where document_type = 1or document_type = 2);

gives this list of councils that scored zero but have a plan/climate strategy:

Angus Council Derby City Council Eden District Council Isles of Scilly London Borough of Hackney London Borough of Havering North Devon Council Maldon District Council Selby District Council Sheffield City Council South Holland District Council Shetland Islands Council St Helens Metropolitan Borough Council Tameside Metropolitan Borough Council Cambridgeshire and Peterborough Combined Authority Crawley Borough Council Gloucester City Council Isle of Anglesey County Council North East Lincolnshire Council Torfaen County Borough Council Ribble Valley Borough Council