Changeset 335


Ignore:
Timestamp:
Nov 5, 2006, 4:40:20 PM (13 years ago)
Author:
Dominic Hargreaves
Message:

Exclude Scotland and NI from missing district stats

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/npemap.org.uk/perllib/NPEMap/Postcodes.pm

    r333 r335  
    9595    my $sql = <<EOF;
    9696SELECT   d.outward, d.district, d.county FROM districts AS d LEFT OUTER JOIN postcodes AS p ON (d.outward = p.outward)
    97 WHERE    p.id IS NULL
     97WHERE    p.id IS NULL AND d.county NOT IN
     98('Northern Ireland', 'All counties', 'Aberdeenshire',
     99 'Banffshire, Aberdeenshire', 'Dumfriesshire', 'Kirkcudbrightshire',
     100 'Wigtownshire', 'Midlothian', 'West Lothian', 'East Lothian',
     101 'Peeblesshire', 'Stirlingshire', 'Clackmannanshire', 'Perthshire',
     102 'Dunbartonshire', 'Inverness', 'Ross', 'Morayshire', 'Isle of Skye',
     103 'Ayrshire', 'Isle of Arran', 'Isle of Cumbrae', 'Caithness', 'Orkney',
     104 'Orkney Islands', 'Fife', 'Lanarkshire', 'Renfrewshire', 'Bute',
     105 'Argyllshire', 'Angus & Argyllshire', 'Inverness & Argyllshire',
     106 'Renfrewshire', 'Isle of Gigha', 'Isle of Islay', 'Isle of Jura',
     107 'Isle of Colonsay', 'Isle of Mull', 'Isle of Iona', 'Isle of Tiree',
     108 'Isle of Coll', 'Isle of Barra', 'Isle of South Uist', 'Isle of North Uist',
     109 'Isle of Harris', 'Isle of Scalpay', 'Isle of Harris', 'Isle of Lewis',
     110 'Isle of Benbecula', 'Perthshire', 'Angus', 'InvernesS', 'Isle of Eigg',
     111 'Isle of Rhum', 'Isle of Canna', 'Shetland')
    98112ORDER BY d.outward
    99113EOF
Note: See TracChangeset for help on using the changeset viewer.