Changeset 335

Timestamp:

Nov 5, 2006, 4:40:20 PM (14 years ago)

Author:

Dominic Hargreaves

Message:

Exclude Scotland and NI from missing district stats

File:

• trunk/npemap.org.uk/perllib/NPEMap/Postcodes.pm (modified) (1 diff)

trunk/npemap.org.uk/perllib/NPEMap/Postcodes.pm

@@ -95 +95 @@
     my $sql = <<EOF;
 SELECT   d.outward, d.district, d.county FROM districts AS d LEFT OUTER JOIN postcodes AS p ON (d.outward = p.outward)
-WHERE    p.id IS NULL
+WHERE    p.id IS NULL AND d.county NOT IN
+('Northern Ireland', 'All counties', 'Aberdeenshire',
+ 'Banffshire, Aberdeenshire', 'Dumfriesshire', 'Kirkcudbrightshire',
+ 'Wigtownshire', 'Midlothian', 'West Lothian', 'East Lothian',
+ 'Peeblesshire', 'Stirlingshire', 'Clackmannanshire', 'Perthshire',
+ 'Dunbartonshire', 'Inverness', 'Ross', 'Morayshire', 'Isle of Skye',
+ 'Ayrshire', 'Isle of Arran', 'Isle of Cumbrae', 'Caithness', 'Orkney',
+ 'Orkney Islands', 'Fife', 'Lanarkshire', 'Renfrewshire', 'Bute',
+ 'Argyllshire', 'Angus & Argyllshire', 'Inverness & Argyllshire',
+ 'Renfrewshire', 'Isle of Gigha', 'Isle of Islay', 'Isle of Jura',
+ 'Isle of Colonsay', 'Isle of Mull', 'Isle of Iona', 'Isle of Tiree',
+ 'Isle of Coll', 'Isle of Barra', 'Isle of South Uist', 'Isle of North Uist',
+ 'Isle of Harris', 'Isle of Scalpay', 'Isle of Harris', 'Isle of Lewis',
+ 'Isle of Benbecula', 'Perthshire', 'Angus', 'InvernesS', 'Isle of Eigg',
+ 'Isle of Rhum', 'Isle of Canna', 'Shetland')
 ORDER BY d.outward
 EOF