Duplicate Areas

[Old Blue]

We currently have an area called 'Vauxhall' based in SE11 and a separate wrongly spelled 'Vauxall' area based in SW8. These should be combined as one 'Vauxhall' area.

I also wondered whether it's possible to run some sort of query to tease out any other area duplication anomalies, as it's not the first I've spotted and there are bound to be others?

[NickDavies]

We currently have an area called 'Vauxhall' based in SE11 and a separate wrongly spelled 'Vauxall' area based in SW8. These should be combined as one 'Vauxhall' area.

Oops my fault I think, correct now I hope

[Conrad]

We currently have an area called 'Vauxhall' based in SE11 and a separate wrongly spelled 'Vauxall' area based in SW8. These should be combined as one 'Vauxhall' area.

I also wondered whether it's possible to run some sort of query to tease out any other area duplication anomalies, as it's not the first I've spotted and there are bound to be others?

Ah the perennial problem for coders, the report on a thingie that looks like a thingie. Sadly a bit beyond my skill I am afraid