Changeset 493 for trunk


Ignore:
Timestamp:
Mar 17, 2007, 11:14:16 AM (13 years ago)
Author:
Dominic Hargreaves
Message:

Enable Scottish districts in our missing list

File:
1 edited

Legend:

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

    r433 r493  
    105105SELECT   d.outward, d.district, d.county FROM districts AS d LEFT OUTER JOIN postcodes AS p ON (d.outward = p.outward)
    106106WHERE    p.id IS NULL AND d.county NOT IN
    107 ('Northern Ireland', 'All counties', 'Aberdeenshire',
    108  'Banffshire, Aberdeenshire', 'Dumfriesshire', 'Kirkcudbrightshire',
    109  'Wigtownshire', 'Midlothian', 'West Lothian', 'East Lothian',
    110  'Peeblesshire', 'Stirlingshire', 'Clackmannanshire', 'Perthshire',
    111  'Dunbartonshire', 'Inverness', 'Ross', 'Morayshire', 'Isle of Skye',
    112  'Ayrshire', 'Isle of Arran', 'Isle of Cumbrae', 'Caithness', 'Orkney',
    113  'Orkney Islands', 'Fife', 'Lanarkshire', 'Renfrewshire', 'Bute',
    114  'Argyllshire', 'Angus & Argyllshire', 'Inverness & Argyllshire',
    115  'Renfrewshire', 'Isle of Gigha', 'Isle of Islay', 'Isle of Jura',
    116  'Isle of Colonsay', 'Isle of Mull', 'Isle of Iona', 'Isle of Tiree',
    117  'Isle of Coll', 'Isle of Barra', 'Isle of South Uist', 'Isle of North Uist',
    118  'Isle of Harris', 'Isle of Scalpay', 'Isle of Harris', 'Isle of Lewis',
    119  'Isle of Benbecula', 'Perthshire', 'Angus', 'InvernesS', 'Isle of Eigg',
    120  'Isle of Rhum', 'Isle of Canna', 'Shetland', 'Sutherland', 'Banffshire',
    121  'Roxburghshire', 'Selkirkshire', 'Berwickshire')
     107('Northern Ireland', 'All counties')
    122108ORDER BY d.outward
    123109EOF
Note: See TracChangeset for help on using the changeset viewer.