Standardise status text

[adrianshort]

Rename status to status_raw.

Parse status_raw into a new Status field according to the LGA standard:

• Live (in the process of being decided)
• Withdrawn
• Decided
• Appeal (in the process of being decided via a non-determination appeal)
• Called in (in the process of being considered by the Secretary of State)
• Referred to SoS (in the process of being considered by the Secretary of State) # FIXME - appears to be a duplicate of Called in
• Invalid (requires something to happen to it before it can be decided)
• Not ours (belong to other planning authorities)
• Registered (received but not yet been processed and validated)

This is the status at the extracted date.

[adrianshort]

A scrape of approx 5000 decided planning applications in London came up with 39 distinct status codes:

statuses.csv.txt

The data is from the London planning applications scraper.