Standardise decision text

[adrianshort]

Rename decision to decision_raw.

Create a new field Decision and parse decision_raw into the LGA standard codes:

• Approve
• Refuse
• Split
• Withdrawn
• Prior not required (prior approval not required)
• Prior granted (prior approval required and granted)
• Prior refused (prior approval required and refused)
• Prior refused permission required (prior approval refused because planning permission required)

[adrianshort]

A sample of ~5000 planning decisions in London came up with over 190 distinct decision codes:

decisions.csv.txt

The data comes from the London planning applications scraper.