CREATE TABLE `uk_postcodes` (`postcode` varchar(7) NOT NULL default '', `longt` float NOT NULL default '0', `lat` float NOT NULL default '0', `place` varchar(50) NOT NULL default '',  PRIMARY KEY  (`postcode`)) TYPE=MyISAM;
INSERT INTO `uk_postcodes` VALUES ('AB10', 57.135, -2.117, 'Altens, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB11', 57.138, -2.092, 'Altens, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB12', 57.101, -2.111, 'Altens, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB13', 57.108, -2.237, 'Altens, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB14', 57.101, -2.27, 'Altens, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB15', 57.138, -2.164, 'Altens, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB16', 57.161, -2.156, 'Altens, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB21', 57.21, -2.2, 'Aberdeen, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB22', 57.187, -2.119, 'Danestone, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB23', 57.212, -2.088, 'Balmedie, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB25', 57.153, -2.112, 'Aberdeen, Aberdeen City');
INSERT INTO `uk_postcodes` VALUES ('AB30', 56.847, -2.477, 'Arbuthnott, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB31', 57.074, -2.527, 'Auchattie, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB32', 57.156, -2.317, 'Achath, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB33', 57.225, -2.741, 'Alford, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB34', 57.094, -2.812, 'Aboyne, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB35', 57.038, -3.149, 'Allanaquoich, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB36', 57.197, -3.067, 'Badenyon, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB37', 57.331, -3.351, 'Auchbreck, Moray');
INSERT INTO `uk_postcodes` VALUES ('AB38', 57.486, -3.225, 'Archiestown, Moray');
INSERT INTO `uk_postcodes` VALUES ('AB39', 56.978, -2.217, 'Borrowfield, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB41', 57.376, -2.105, 'Ardo, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB42', 57.501, -1.888, 'Aldie, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB43', 57.658, -2.043, 'Bogfold, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB44', 57.669, -2.492, 'Macduff, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB45', 57.651, -2.566, 'Ardiecow, Moray');
INSERT INTO `uk_postcodes` VALUES ('AB51', 57.289, -2.405, 'Auchorrie, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB52', 57.344, -2.607, 'Ardlair, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB53', 57.525, -2.393, 'Auchininna, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB54', 57.454, -2.763, 'Aberchirder, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('AB55', 57.524, -2.99, 'Achnastank, Moray');
INSERT INTO `uk_postcodes` VALUES ('AB56', 57.675, -2.926, 'Arradoul, Moray');
INSERT INTO `uk_postcodes` VALUES ('AL1', 51.748, -0.322, 'St Albans, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('AL10', 51.76, -0.23, 'Hatfield, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('AL2', 51.72, -0.333, 'Bricket Wood, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('AL3', 51.778, -0.37, '');
INSERT INTO `uk_postcodes` VALUES ('AL4', 51.772, -0.294, 'Blackmore End, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('AL5', 51.816, -0.351, 'Harpenden, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('AL6', 51.831, -0.197, 'Ayot St Lawrence, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('AL7', 51.797, -0.186, 'Hatfield Hyde, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('AL8', 51.803, -0.209, 'Cromer Hyde, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('AL9', 51.745, -0.199, 'Bell Bar, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('B1', 52.478, -1.907, 'Birmingham, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B10', 52.47, -1.851, '');
INSERT INTO `uk_postcodes` VALUES ('B11', 52.454, -1.858, '');
INSERT INTO `uk_postcodes` VALUES ('B12', 52.46, -1.882, '');
INSERT INTO `uk_postcodes` VALUES ('B13', 52.437, -1.878, 'Moseley, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B14', 52.417, -1.889, '');
INSERT INTO `uk_postcodes` VALUES ('B15', 52.467, -1.924, 'Chad Valley, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B16', 52.476, -1.933, '');
INSERT INTO `uk_postcodes` VALUES ('B17', 52.461, -1.961, 'Harborne, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B18', 52.491, -1.924, '');
INSERT INTO `uk_postcodes` VALUES ('B19', 52.496, -1.905, '');
INSERT INTO `uk_postcodes` VALUES ('B2', 52.479, -1.897, 'Birmingham, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B20', 52.514, -1.918, '');
INSERT INTO `uk_postcodes` VALUES ('B21', 52.506, -1.939, 'Handsworth, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B23', 52.528, -1.854, 'Gravelly Hill, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B24', 52.519, -1.827, 'Erdington, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B25', 52.465, -1.82, 'Hay Mills, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B26', 52.461, -1.79, 'Elmdon, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B27', 52.445, -1.822, '');
INSERT INTO `uk_postcodes` VALUES ('B28', 52.427, -1.842, 'Hall Green, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B29', 52.437, -1.947, 'Bournbrook, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B3', 52.48, -1.902, 'Birmingham, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B30', 52.422, -1.927, 'Bournville, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B31', 52.408, -1.972, 'Longbridge, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B32', 52.448, -1.993, 'Frankley, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('B33', 52.48, -1.787, 'Tile Cross, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B34', 52.496, -1.781, '');
INSERT INTO `uk_postcodes` VALUES ('B35', 52.519, -1.788, '');
INSERT INTO `uk_postcodes` VALUES ('B36', 52.504, -1.779, 'Castle Bromwich, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B37', 52.478, -1.741, 'Marston Green, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B38', 52.4, -1.933, '');
INSERT INTO `uk_postcodes` VALUES ('B4', 52.482, -1.894, 'Birmingham, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B40', 52.459, -1.722, '');
INSERT INTO `uk_postcodes` VALUES ('B42', 52.533, -1.911, 'Perry Barr, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B43', 52.548, -1.929, 'Great Barr, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B44', 52.545, -1.884, 'Kingstanding, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B45', 52.388, -2.009, 'Barnt Green, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('B46', 52.508, -1.694, 'Coleshill, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('B47', 52.387, -1.88, 'Drakes Cross, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('B48', 52.355, -1.948, 'Alvechurch, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('B49', 52.217, -1.867, 'Alcester, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('B5', 52.47, -1.896, 'Birmingham, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B50', 52.169, -1.854, 'Barton, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('B6', 52.504, -1.885, 'Aston, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B60', 52.326, -2.049, 'Aston Fields, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('B61', 52.345, -2.067, 'Bournheath, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('B62', 52.456, -2.032, 'Illey, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B63', 52.452, -2.067, 'Cradley, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B64', 52.472, -2.068, 'Old Hill, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B65', 52.483, -2.042, 'Blackheath, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B66', 52.493, -1.964, 'Smethwick, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B67', 52.486, -1.977, '');
INSERT INTO `uk_postcodes` VALUES ('B68', 52.479, -2, 'Warley, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B69', 52.502, -2.028, 'Oldbury, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B7', 52.493, -1.873, '');
INSERT INTO `uk_postcodes` VALUES ('B70', 52.52, -2.003, 'West Bromwich, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B71', 52.535, -1.989, 'Bird End, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B72', 52.552, -1.821, 'Wylde Green, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B73', 52.552, -1.841, '');
INSERT INTO `uk_postcodes` VALUES ('B74', 52.583, -1.858, 'Four Oaks, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B75', 52.578, -1.809, 'Canwell Hall, Staffordshire');
INSERT INTO `uk_postcodes` VALUES ('B76', 52.545, -1.785, 'Curdworth, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('B77', 52.618, -1.667, 'Amington, Staffordshire');
INSERT INTO `uk_postcodes` VALUES ('B78', 52.606, -1.673, 'Bonehill, Staffordshire');
INSERT INTO `uk_postcodes` VALUES ('B79', 52.65, -1.681, 'Alvecote, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('B8', 52.49, -1.84, 'Saltley, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B80', 52.277, -1.895, 'Gorcott Hill, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('B9', 52.478, -1.849, '');
INSERT INTO `uk_postcodes` VALUES ('B90', 52.4, -1.824, 'Shirley, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B91', 52.413, -1.782, 'Blossomfield, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B92', 52.436, -1.774, 'Bickenhill, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B93', 52.38, -1.743, 'Barston, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('B94', 52.351, -1.791, 'Earlswood, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('B95', 52.285, -1.779, 'Aston Cantlow, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('B96', 52.252, -1.96, 'Astwood Bank, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('B97', 52.299, -1.954, 'Crabbs Cross, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('B98', 52.303, -1.914, 'Beoley, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('BA1', 51.391, -2.36, 'Bath, Bath Avon');
INSERT INTO `uk_postcodes` VALUES ('BA10', 51.113, -2.446, 'Bruton, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA11', 51.236, -2.325, 'Berkley, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA12', 51.171, -2.187, 'Barrow Street, Wiltshire');
INSERT INTO `uk_postcodes` VALUES ('BA13', 51.262, -2.179, 'Bratton, Wiltshire');
INSERT INTO `uk_postcodes` VALUES ('BA14', 51.318, -2.201, 'Ashton Common, Wiltshire');
INSERT INTO `uk_postcodes` VALUES ('BA15', 51.351, -2.265, 'Bradford Leigh, Wiltshire');
INSERT INTO `uk_postcodes` VALUES ('BA16', 51.125, -2.743, 'Overleigh, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA2', 51.36, -2.377, 'Bathampton, Bristol Avon');
INSERT INTO `uk_postcodes` VALUES ('BA20', 50.938, -2.642, 'Yeovil, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA21', 50.951, -2.633, 'Mudford, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA22', 50.968, -2.637, 'Ashington, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA3', 51.275, -2.473, 'Ashwick, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA4', 51.171, -2.531, 'Alhampton, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA5', 51.212, -2.653, 'Bleadney, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA6', 51.141, -2.705, 'Baltonsborough, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA7', 51.089, -2.518, 'Alford, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA8', 50.999, -2.411, 'Abbas Combe, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BA9', 51.057, -2.409, 'Barrow, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BB1', 53.756, -2.462, 'Belthorn, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB10', 53.799, -2.219, 'Brierfield, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB11', 53.783, -2.252, 'Burnley, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB12', 53.803, -2.29, 'Barley, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB18', 53.914, -2.171, 'Belthorn, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB2', 53.741, -2.5, 'Balderstone, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB3', 53.698, -2.465, 'Darwen, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB4', 53.703, -2.29, 'Crawshawbooth, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB5', 53.754, -2.371, 'Accrington, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB6', 53.792, -2.417, 'Great Harwood, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB7', 53.874, -2.386, 'Barrow, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB8', 53.858, -2.163, 'Barnoldswick, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BB9', 53.837, -2.214, 'Barrowford, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BD1', 53.796, -1.752, 'Bradford, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD10', 53.832, -1.725, 'Bradford, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD11', 53.751, -1.676, 'Adwalton, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD12', 53.746, -1.761, 'Low Moor, Bradford');
INSERT INTO `uk_postcodes` VALUES ('BD13', 53.786, -1.859, 'Cullingworth, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD14', 53.782, -1.816, 'Clayton, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD15', 53.81, -1.836, 'Allerton, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD16', 53.849, -1.833, 'Bingley, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD17', 53.847, -1.767, 'Baildon, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD18', 53.831, -1.776, 'Shipley, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD19', 53.727, -1.712, 'Cleckheaton, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD2', 53.814, -1.734, '');
INSERT INTO `uk_postcodes` VALUES ('BD20', 53.897, -1.947, 'Cononley, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD21', 53.864, -1.906, 'Ingrow, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD22', 53.846, -1.952, 'Cowling, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD23', 53.993, -2.054, 'Airton, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD24', 54.077, -2.274, 'Cleatop, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD3', 53.798, -1.727, '');
INSERT INTO `uk_postcodes` VALUES ('BD4', 53.776, -1.718, 'Bierley, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD5', 53.778, -1.758, '');
INSERT INTO `uk_postcodes` VALUES ('BD6', 53.765, -1.783, 'Buttershaw, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('BD7', 53.783, -1.782, '');
INSERT INTO `uk_postcodes` VALUES ('BD8', 53.801, -1.781, '');
INSERT INTO `uk_postcodes` VALUES ('BD9', 53.812, -1.789, '');
INSERT INTO `uk_postcodes` VALUES ('BH1', 50.724, -1.86, '');
INSERT INTO `uk_postcodes` VALUES ('BH10', 50.759, -1.891, '');
INSERT INTO `uk_postcodes` VALUES ('BH11', 50.761, -1.917, 'Bearwood, Poole');
INSERT INTO `uk_postcodes` VALUES ('BH12', 50.737, -1.926, 'Branksome, Poole');
INSERT INTO `uk_postcodes` VALUES ('BH13', 50.71, -1.917, 'Branksome Park, Poole');
INSERT INTO `uk_postcodes` VALUES ('BH14', 50.721, -1.944, 'Lilliput, Poole');
INSERT INTO `uk_postcodes` VALUES ('BH15', 50.722, -1.984, 'Longfleet, Poole');
INSERT INTO `uk_postcodes` VALUES ('BH16', 50.738, -2.044, 'Holton Heath, Dorset');
INSERT INTO `uk_postcodes` VALUES ('BH17', 50.746, -1.975, 'Waterloo, Poole');
INSERT INTO `uk_postcodes` VALUES ('BH18', 50.758, -1.993, 'Broadstone, Poole');
INSERT INTO `uk_postcodes` VALUES ('BH19', 50.611, -1.97, '');
INSERT INTO `uk_postcodes` VALUES ('BH2', 50.721, -1.881, 'Bournemouth, Bournemouth');
INSERT INTO `uk_postcodes` VALUES ('BH20', 50.686, -2.146, 'Arne, Dorset');
INSERT INTO `uk_postcodes` VALUES ('BH21', 50.812, -1.973, 'Boveridge, Dorset');
INSERT INTO `uk_postcodes` VALUES ('BH22', 50.805, -1.887, 'Dudsbury, Dorset');
INSERT INTO `uk_postcodes` VALUES ('BH23', 50.746, -1.754, 'Avon, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('BH24', 50.844, -1.786, 'Ashley Heath, Dorset');
INSERT INTO `uk_postcodes` VALUES ('BH25', 50.752, -1.657, 'Ashley, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('BH3', 50.735, -1.88, 'Winton, Bournemouth');
INSERT INTO `uk_postcodes` VALUES ('BH31', 50.876, -1.872, 'Romford, Dorset');
INSERT INTO `uk_postcodes` VALUES ('BH4', 50.721, -1.898, 'Westbourne, Bournemouth');
INSERT INTO `uk_postcodes` VALUES ('BH5', 50.725, -1.834, 'Boscombe, Bournemouth');
INSERT INTO `uk_postcodes` VALUES ('BH6', 50.727, -1.804, 'Southbourne, Bournemouth');
INSERT INTO `uk_postcodes` VALUES ('BH7', 50.735, -1.831, '');
INSERT INTO `uk_postcodes` VALUES ('BH8', 50.74, -1.851, 'Holdenhurst, Bournemouth');
INSERT INTO `uk_postcodes` VALUES ('BH9', 50.749, -1.871, 'Moordown, Bournemouth');
INSERT INTO `uk_postcodes` VALUES ('BL0', 53.646, -2.315, 'Edenfield, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BL1', 53.59, -2.444, 'Astley Bridge, Greater Manchester');
INSERT INTO `uk_postcodes` VALUES ('BL2', 53.588, -2.395, 'Ainsworth, Greater Manchester');
INSERT INTO `uk_postcodes` VALUES ('BL3', 53.565, -2.431, 'Daubhill, Greater Manchester');
INSERT INTO `uk_postcodes` VALUES ('BL4', 53.547, -2.4, 'Farnworth, Greater Manchester');
INSERT INTO `uk_postcodes` VALUES ('BL5', 53.549, -2.515, 'Westhoughton, Greater Manchester');
INSERT INTO `uk_postcodes` VALUES ('BL6', 53.592, -2.539, 'Adlington, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BL7', 53.63, -2.421, 'Belmont, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('BL8', 53.605, -2.327, 'Greenmount, Greater Manchester');
INSERT INTO `uk_postcodes` VALUES ('BL9', 53.592, -2.286, 'Bury, Greater Manchester');
INSERT INTO `uk_postcodes` VALUES ('BN1', 50.839, -0.138, 'Coldean, Brighton and Hove');
INSERT INTO `uk_postcodes` VALUES ('BN10', 50.795, 0.003, 'Peacehaven, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN11', 50.813, -0.376, 'West Worthing, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN12', 50.813, -0.425, 'Ferring, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN13', 50.83, -0.405, 'Clapham, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN14', 50.832, -0.38, 'Broadwater, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN15', 50.83, -0.324, 'Coombes, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN16', 50.814, -0.494, 'Angmering, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN17', 50.814, -0.535, 'Climping, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN18', 50.848, -0.579, 'Amberley, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN2', 50.824, -0.103, 'Bevendean, Brighton and Hove');
INSERT INTO `uk_postcodes` VALUES ('BN20', 50.774, 0.255, 'Birling Gap, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN21', 50.773, 0.277, 'Eastbourne, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN22', 50.788, 0.284, 'Hampden Park, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN23', 50.798, 0.314, 'Friday Street, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN24', 50.816, 0.331, 'Hankham, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN25', 50.776, 0.11, 'Bishopstone, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN26', 50.821, 0.223, 'Alciston, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN27', 50.871, 0.265, 'Bodle Street Green, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN3', 50.835, -0.174, 'Hangleton, Brighton and Hove');
INSERT INTO `uk_postcodes` VALUES ('BN41', 50.84, -0.215, 'Portslade, Brighton and Hove');
INSERT INTO `uk_postcodes` VALUES ('BN42', 50.837, -0.231, 'Southwick, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN43', 50.836, -0.266, 'Kingston by Sea, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN44', 50.89, -0.322, 'Ashurst, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN45', 50.889, -0.185, 'Poynings, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN5', 50.927, -0.268, 'Blackstone, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN6', 50.929, -0.152, 'Albourne, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN7', 50.877, 0.001, 'Cooksbridge, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN8', 50.913, 0.052, 'Barcombe Cross, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BN9', 50.795, 0.051, 'Denton, East Sussex');
INSERT INTO `uk_postcodes` VALUES ('BR1', 51.411, 0.022, 'Bickley, Greater London');
INSERT INTO `uk_postcodes` VALUES ('BR2', 51.389, 0.023, 'Bromley Common, Greater London');
INSERT INTO `uk_postcodes` VALUES ('BR3', 51.403, -0.031, 'Beckenham, Greater London');
INSERT INTO `uk_postcodes` VALUES ('BR4', 51.375, -0.007, 'West Wickham, Greater London');
INSERT INTO `uk_postcodes` VALUES ('BR5', 51.39, 0.104, 'St Mary Cray, Greater London');
INSERT INTO `uk_postcodes` VALUES ('BR6', 51.366, 0.094, 'Chelsfield, Greater London');
INSERT INTO `uk_postcodes` VALUES ('BR7', 51.41, 0.072, 'Chislehurst Caves, Greater London');
INSERT INTO `uk_postcodes` VALUES ('BR8', 51.398, 0.176, 'Crockenhill, Kent');
INSERT INTO `uk_postcodes` VALUES ('BS1', 51.453, -2.593, 'Bristol, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS10', 51.506, -2.61, 'Catbrain, South Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('BS11', 51.497, -2.675, 'Avonmouth, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS13', 51.412, -2.611, 'Bishopsworth, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS14', 51.413, -2.561, 'Whitchurch, Bristol Avon');
INSERT INTO `uk_postcodes` VALUES ('BS15', 51.459, -2.506, 'Kingswood, South Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('BS16', 51.485, -2.51, 'Downend, South Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('BS2', 51.46, -2.581, '');
INSERT INTO `uk_postcodes` VALUES ('BS20', 51.479, -2.752, 'Clapton-in-Gordano, North Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS21', 51.435, -2.849, 'Clevedon, North Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS22', 51.36, -2.929, 'Bourton, North Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS23', 51.343, -2.97, 'Uphill, North Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS24', 51.327, -2.932, 'Banwell, North Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS25', 51.32, -2.826, 'Rowberrow, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS26', 51.279, -2.855, 'Axbridge, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS27', 51.271, -2.77, 'Cheddar, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS28', 51.225, -2.814, 'Blackford, Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS29', 51.331, -2.878, '');
INSERT INTO `uk_postcodes` VALUES ('BS3', 51.438, -2.602, '');
INSERT INTO `uk_postcodes` VALUES ('BS30', 51.445, -2.472, 'Abson, South Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('BS31', 51.408, -2.491, '');
INSERT INTO `uk_postcodes` VALUES ('BS32', 51.542, -2.559, '');
INSERT INTO `uk_postcodes` VALUES ('BS34', 51.523, -2.564, '');
INSERT INTO `uk_postcodes` VALUES ('BS35', 51.596, -2.549, '');
INSERT INTO `uk_postcodes` VALUES ('BS36', 51.526, -2.486, 'Coalpit Heath, South Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('BS37', 51.539, -2.416, 'Chipping Sodbury, South Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('BS39', 51.328, -2.532, '');
INSERT INTO `uk_postcodes` VALUES ('BS4', 51.435, -2.561, 'Brislington, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS40', 51.346, -2.691, 'Brislington, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS41', 51.422, -2.651, 'Brislington, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS48', 51.425, -2.747, 'Brislington, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS49', 51.38, -2.817, 'Brislington, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS5', 51.462, -2.551, '');
INSERT INTO `uk_postcodes` VALUES ('BS6', 51.47, -2.599, 'Bristol, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS7', 51.486, -2.58, 'Horfield, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS8', 51.457, -2.621, 'Abbots Leigh, North Somerset');
INSERT INTO `uk_postcodes` VALUES ('BS9', 51.487, -2.625, 'Westbury on Trym, Bristol');
INSERT INTO `uk_postcodes` VALUES ('BS99', 51.458, -2.573, 'Bristol (PO Boxes), Bristol');
INSERT INTO `uk_postcodes` VALUES ('BT1', 53.262, -2.991, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT10', 53.22, -3.042, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT11', 53.236, -3.056, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT12', 53.254, -3.018, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT13', 53.267, -3.021, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT14', 53.282, -3.024, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT15', 53.285, -2.996, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT16', 53.257, -2.864, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT17', 53.214, -3.074, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT18', 53.306, -2.89, 'Hollywood, County Down');
INSERT INTO `uk_postcodes` VALUES ('BT19', 53.32, -2.741, 'Belfast, Belfast');
INSERT INTO `uk_postcodes` VALUES ('BT2', 53.255, -2.993, '');
INSERT INTO `uk_postcodes` VALUES ('BT20', 53.327, -2.74, '');
INSERT INTO `uk_postcodes` VALUES ('BT21', 53.311, -2.623, '');
INSERT INTO `uk_postcodes` VALUES ('BT22', 53.176, -2.588, '');
INSERT INTO `uk_postcodes` VALUES ('BT23', 53.231, -2.782, '');
INSERT INTO `uk_postcodes` VALUES ('BT24', 53.08, -2.923, '');
INSERT INTO `uk_postcodes` VALUES ('BT25', 53.053, -3.153, '');
INSERT INTO `uk_postcodes` VALUES ('BT26', 53.111, -3.109, '');
INSERT INTO `uk_postcodes` VALUES ('BT27', 53.17, -3.074, '');
INSERT INTO `uk_postcodes` VALUES ('BT28', 53.181, -3.14, '');
INSERT INTO `uk_postcodes` VALUES ('BT29', 53.276, -3.25, '');
INSERT INTO `uk_postcodes` VALUES ('BT3', 53.283, -2.969, '');
INSERT INTO `uk_postcodes` VALUES ('BT30', 53.002, -2.755, '');
INSERT INTO `uk_postcodes` VALUES ('BT31', 52.939, -3.008, '');
INSERT INTO `uk_postcodes` VALUES ('BT32', 52.99, -3.278, '');
INSERT INTO `uk_postcodes` VALUES ('BT33', 52.884, -2.93, '');
INSERT INTO `uk_postcodes` VALUES ('BT34', 52.811, -3.203, '');
INSERT INTO `uk_postcodes` VALUES ('BT35', 52.814, -3.46, '');
INSERT INTO `uk_postcodes` VALUES ('BT36', 53.339, -3.022, '');
INSERT INTO `uk_postcodes` VALUES ('BT37', 53.339, -2.977, '');
INSERT INTO `uk_postcodes` VALUES ('BT38', 53.395, -2.876, '');
INSERT INTO `uk_postcodes` VALUES ('BT39', 53.405, -3.088, '');
INSERT INTO `uk_postcodes` VALUES ('BT4', 53.266, -2.933, '');
INSERT INTO `uk_postcodes` VALUES ('BT40', 53.511, -2.906, '');
INSERT INTO `uk_postcodes` VALUES ('BT41', 53.386, -3.321, '');
INSERT INTO `uk_postcodes` VALUES ('BT42', 53.507, -3.353, '');
INSERT INTO `uk_postcodes` VALUES ('BT43', 53.544, -3.339, '');
INSERT INTO `uk_postcodes` VALUES ('BT44', 53.627, -3.362, '');
INSERT INTO `uk_postcodes` VALUES ('BT45', 53.404, -3.691, '');
INSERT INTO `uk_postcodes` VALUES ('BT46', 53.509, -3.722, '');
INSERT INTO `uk_postcodes` VALUES ('BT47', 53.604, -4.26, 'Derry, County Londonderry');
INSERT INTO `uk_postcodes` VALUES ('BT48', 53.636, -4.374, '');
INSERT INTO `uk_postcodes` VALUES ('BT49', 53.684, -4.014, '');
INSERT INTO `uk_postcodes` VALUES ('BT5', 53.252, -2.935, '');
INSERT INTO `uk_postcodes` VALUES ('BT51', 53.701, -3.753, '');
INSERT INTO `uk_postcodes` VALUES ('BT52', 53.778, -3.732, '');
INSERT INTO `uk_postcodes` VALUES ('BT53', 53.734, -3.554, '');
INSERT INTO `uk_postcodes` VALUES ('BT54', 53.854, -3.354, '');
INSERT INTO `uk_postcodes` VALUES ('BT55', 53.822, -3.789, '');
INSERT INTO `uk_postcodes` VALUES ('BT56', 53.842, -3.733, '');
INSERT INTO `uk_postcodes` VALUES ('BT57', 53.849, -3.605, '');
INSERT INTO `uk_postcodes` VALUES ('BT6', 53.243, -2.96, '');
INSERT INTO `uk_postcodes` VALUES ('BT60', 52.937, -3.668, 'Armagh, County Armagh');
INSERT INTO `uk_postcodes` VALUES ('BT61', 53.013, -3.647, '');
INSERT INTO `uk_postcodes` VALUES ('BT62', 53.061, -3.496, '');
INSERT INTO `uk_postcodes` VALUES ('BT63', 53.055, -3.424, '');
INSERT INTO `uk_postcodes` VALUES ('BT64', 53.1, -3.429, '');
INSERT INTO `uk_postcodes` VALUES ('BT65', 53.096, -3.403, '');
INSERT INTO `uk_postcodes` VALUES ('BT66', 53.108, -3.373, '');
INSERT INTO `uk_postcodes` VALUES ('BT67', 53.14, -3.313, '');
INSERT INTO `uk_postcodes` VALUES ('BT68', 53.005, -3.864, 'Caledon, County Tyrone');
INSERT INTO `uk_postcodes` VALUES ('BT69', 53.061, -3.967, '');
INSERT INTO `uk_postcodes` VALUES ('BT7', 53.245, -2.986, '');
INSERT INTO `uk_postcodes` VALUES ('BT70', 53.153, -3.913, '');
INSERT INTO `uk_postcodes` VALUES ('BT71', 53.156, -3.737, '');
INSERT INTO `uk_postcodes` VALUES ('BT74', 52.963, -4.654, 'Enniskillen, County Fermanagh');
INSERT INTO `uk_postcodes` VALUES ('BT75', 53.003, -4.318, '');
INSERT INTO `uk_postcodes` VALUES ('BT76', 53.05, -4.201, '');
INSERT INTO `uk_postcodes` VALUES ('BT77', 53.06, -4.13, '');
INSERT INTO `uk_postcodes` VALUES ('BT78', 53.197, -4.389, '');
INSERT INTO `uk_postcodes` VALUES ('BT79', 53.254, -4.224, '');
INSERT INTO `uk_postcodes` VALUES ('BT8', 53.203, -2.964, '');
INSERT INTO `uk_postcodes` VALUES ('BT80', 53.286, -3.788, '');
INSERT INTO `uk_postcodes` VALUES ('BT81', 53.315, -4.629, '');
INSERT INTO `uk_postcodes` VALUES ('BT82', 53.451, -4.458, '');
INSERT INTO `uk_postcodes` VALUES ('BT9', 53.233, -3.01, '');
INSERT INTO `uk_postcodes` VALUES ('BT92', 52.847, -4.449, '');
INSERT INTO `uk_postcodes` VALUES ('BT93', 53.081, -4.818, '');
INSERT INTO `uk_postcodes` VALUES ('BT94', 52.998, -4.537, '');
INSERT INTO `uk_postcodes` VALUES ('CA1', 54.886, -2.911, 'Carleton, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA10', 54.611, -2.659, 'Askham, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA11', 54.664, -2.786, 'Blencow, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA12', 54.602, -3.133, 'Applethwaite, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA13', 54.66, -3.366, 'Bewaldeth, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA14', 54.634, -3.537, 'Asby, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA15', 54.712, -3.481, 'Allonby, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA16', 54.574, -2.483, 'Appleby-in-Westmorland, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA17', 54.479, -2.35, 'Brough Sowerby, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA18', 54.354, -3.39, 'Broad Oak, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA19', 54.387, -3.382, 'Beckfoot, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA2', 54.884, -2.949, 'Cummersdale, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA20', 54.41, -3.461, 'Calder Bridge, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA21', 54.445, -3.515, 'Beckermet, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA22', 54.48, -3.531, 'Egremont, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA23', 54.514, -3.493, 'Cleator, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA24', 54.515, -3.542, 'Moor Row, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA25', 54.523, -3.517, 'Cleator Moor, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA26', 54.544, -3.481, 'Arlecdon, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA27', 54.491, -3.592, 'St Bees, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA28', 54.544, -3.577, 'Hensingham, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA3', 54.907, -2.939, 'Houghton, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA4', 54.847, -2.833, 'Aiketgate, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA5', 54.855, -3.015, 'Abbeytown, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA6', 54.994, -2.892, 'Bewcastle, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA7', 54.807, -3.237, 'Aikton, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA8', 54.939, -2.685, 'Banks, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CA9', 54.802, -2.419, 'Alston, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('CB1', 52.176, 0.19, 'Balsham, Cambridgeshire');
INSERT INTO `uk_postcodes` VALUES ('CB10', 52.03, 0.266, 'Ashdon, Essex');
INSERT INTO `uk_postcodes` VALUES ('CB11', 52, 0.214, 'Arkesden, Essex');
INSERT INTO `uk_postcodes` VALUES ('CB2', 52.163, 0.133, 'Babraham, Cambridgeshire');
INSERT INTO `uk_postcodes` VALUES ('CB3', 52.213, 0.025, 'Bar Hill, Cambridgeshire');
INSERT INTO `uk_postcodes` VALUES ('CB4', 52.243, 0.115, 'Boxworth End, Cambridgeshire');
INSERT INTO `uk_postcodes` VALUES ('CB5', 52.239, 0.211, 'Bottisham, Cambridgeshire');
INSERT INTO `uk_postcodes` VALUES ('CB6', 52.404, 0.224, 'Aldreth, Cambridgeshire');
INSERT INTO `uk_postcodes` VALUES ('CB7', 52.366, 0.322, 'Barway, Cambridgeshire');
INSERT INTO `uk_postcodes` VALUES ('CB8', 52.231, 0.427, 'Ashley, Cambridgeshire');
INSERT INTO `uk_postcodes` VALUES ('CB9', 52.082, 0.441, 'Barnardiston, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('CF10', 51.474, -3.176, 'Canton, Cardiff');
INSERT INTO `uk_postcodes` VALUES ('CF11', 51.473, -3.192, 'Canton, Cardiff');
INSERT INTO `uk_postcodes` VALUES ('CF14', 51.519, -3.203, 'Canton, Cardiff');
INSERT INTO `uk_postcodes` VALUES ('CF15', 51.534, -3.273, 'Canton, Cardiff');
INSERT INTO `uk_postcodes` VALUES ('CF23', 51.515, -3.151, 'Llanedeyrn, Cardiff');
INSERT INTO `uk_postcodes` VALUES ('CF24', 51.485, -3.164, 'Llanedeyrn, Cardiff');
INSERT INTO `uk_postcodes` VALUES ('CF3', 51.519, -3.111, 'Began, Caerphilly');
INSERT INTO `uk_postcodes` VALUES ('CF31', 51.509, -3.576, 'Bridgend, Bridgend');
INSERT INTO `uk_postcodes` VALUES ('CF32', 51.56, -3.583, 'Abergarw, Bridgend');
INSERT INTO `uk_postcodes` VALUES ('CF33', 51.524, -3.69, 'Kenfig Hill, Bridgend');
INSERT INTO `uk_postcodes` VALUES ('CF34', 51.61, -3.651, 'Caerau, Bridgend');
INSERT INTO `uk_postcodes` VALUES ('CF35', 51.522, -3.519, 'Blackmill, Bridgend');
INSERT INTO `uk_postcodes` VALUES ('CF36', 51.485, -3.698, 'Newton, Bridgend');
INSERT INTO `uk_postcodes` VALUES ('CF37', 51.603, -3.333, 'Clifynydd, Rhondda Cynon Taff');
INSERT INTO `uk_postcodes` VALUES ('CF38', 51.56, -3.332, 'Beddau, Rhondda Cynon Taff');
INSERT INTO `uk_postcodes` VALUES ('CF39', 51.601, -3.423, 'Coedely, Rhondda Cynon Taff');
INSERT INTO `uk_postcodes` VALUES ('CF40', 51.62, -3.45, 'Clydach Vale, Rhondda Cynon Taff');
INSERT INTO `uk_postcodes` VALUES ('CF41', 51.647, -3.481, 'Pentre, Rhondda Cynon Taff');
INSERT INTO `uk_postcodes` VALUES ('CF42', 51.667, -3.522, 'Blaencwm, Rhondda Cynon Taff');
INSERT INTO `uk_postcodes` VALUES ('CF43', 51.658, -3.449, 'Ferndale, Rhondda Cynon Taff');
INSERT INTO `uk_postcodes` VALUES ('CF44', 51.718, -3.458, 'Aber-llia, Powys');
INSERT INTO `uk_postcodes` VALUES ('CF45', 51.669, -3.361, 'Abercynon, Rhondda Cynon Taff');
INSERT INTO `uk_postcodes` VALUES ('CF46', 51.665, -3.3, 'Bedlinog, Merthyr Tydfil');
INSERT INTO `uk_postcodes` VALUES ('CF47', 51.751, -3.374, 'Merthyr Tydfil, Merthyr Tydfil');
INSERT INTO `uk_postcodes` VALUES ('CF48', 51.741, -3.369, 'Abercanaid, Merthyr Tydfil');
INSERT INTO `uk_postcodes` VALUES ('CF5', 51.482, -3.242, 'Bonvilston, Vale of Glamorgan');
INSERT INTO `uk_postcodes` VALUES ('CF61', 51.408, -3.48, 'Boverton, Vale of Glamorgan');
INSERT INTO `uk_postcodes` VALUES ('CF62', 51.404, -3.308, 'Barry, Vale of Glamorgan');
INSERT INTO `uk_postcodes` VALUES ('CF63', 51.412, -3.256, 'Cadoxton, Vale of Glamorgan');
INSERT INTO `uk_postcodes` VALUES ('CF64', 51.433, -3.189, 'Cogan, Vale of Glamorgan');
INSERT INTO `uk_postcodes` VALUES ('CF71', 51.461, -3.454, 'Aberthin, Vale of Glamorgan');
INSERT INTO `uk_postcodes` VALUES ('CF72', 51.53, -3.398, 'Bryncae, Rhondda Cynon Taff');
INSERT INTO `uk_postcodes` VALUES ('CF81', 51.7, -3.243, 'Aber Bargoed, Caerphilly');
INSERT INTO `uk_postcodes` VALUES ('CF82', 51.652, -3.236, 'Cefn Hengoed, Caerphilly');
INSERT INTO `uk_postcodes` VALUES ('CF83', 51.586, -3.217, 'Abertridwr, Caerphilly');
INSERT INTO `uk_postcodes` VALUES ('CH1', 53.202, -2.908, 'Blacon, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CH2', 53.216, -2.868, 'Backford, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CH3', 53.167, -2.822, 'Aldersey Green, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CH4', 53.168, -2.939, 'Bretton, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('CH41', 53.394, -3.03, 'Birkenhead, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH42', 53.374, -3.021, 'Birkenhead, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH43', 53.383, -3.058, 'Bidston, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH44', 53.415, -3.036, 'Wallasey, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH45', 53.428, -3.05, 'New Brighton, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH46', 53.404, -3.11, 'Moreton, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH47', 53.396, -3.168, 'Hoylake, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH48', 53.372, -3.169, 'Caldy, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH49', 53.381, -3.103, 'Upton, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH5', 53.204, -3.041, 'Aston, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('CH6', 53.25, -3.145, 'Bagillt, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('CH60', 53.326, -3.095, 'Gayton, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH61', 53.348, -3.101, 'Barnston, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH62', 53.334, -2.981, 'Bagillt, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('CH63', 53.345, -3.011, 'Wirral, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('CH64', 53.288, -3.047, 'Bagillt, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('CH65', 53.277, -2.902, 'Bagillt, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('CH66', 53.277, -2.934, 'Bagillt, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('CH7', 53.169, -3.133, 'Afon-wen, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('CH8', 53.281, -3.241, 'Babell, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('CM0', 51.663, 0.837, 'Asheldham, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM1', 51.745, 0.457, 'Broomfield, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM11', 51.623, 0.446, 'Billericay, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM12', 51.628, 0.416, 'Little Burstead, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM13', 51.615, 0.338, 'Childerditch, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM14', 51.618, 0.293, 'Brentwood, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM15', 51.643, 0.306, 'Doddinghurst, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM16', 51.7, 0.122, 'Coopersale Common, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM17', 51.771, 0.146, 'Church Langley, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM18', 51.756, 0.107, 'Broomfield, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM19', 51.76, 0.075, 'Great Parndon, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM2', 51.722, 0.487, 'Galleyend, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM20', 51.775, 0.105, 'Eastwick, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('CM21', 51.812, 0.147, '');
INSERT INTO `uk_postcodes` VALUES ('CM22', 51.862, 0.222, '');
INSERT INTO `uk_postcodes` VALUES ('CM23', 51.871, 0.16, 'Berden, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM24', 51.899, 0.207, 'Stansted Mountfitchet, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM3', 51.72, 0.585, 'Althorne, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM4', 51.674, 0.392, 'Blackmore, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM5', 51.721, 0.249, 'Abbess Roding, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM6', 51.877, 0.367, 'Aythorpe Roding, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM7', 51.897, 0.539, 'Bardfield Saling, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM8', 51.805, 0.639, 'Chipping Hill, Essex');
INSERT INTO `uk_postcodes` VALUES ('CM9', 51.741, 0.702, 'Broad Street Green, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO1', 51.889, 0.91, 'Colchester, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO10', 52.057, 0.724, 'Acton, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('CO11', 51.942, 1.079, 'Bradfield Heath, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO12', 51.931, 1.255, 'Dovercourt, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO13', 51.838, 1.239, 'Frinton-on-Sea, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO14', 51.85, 1.269, 'Walton-on-Naze, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO15', 51.796, 1.157, 'Clacton-on-Sea, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO16', 51.821, 1.126, 'Beaumont, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO2', 51.869, 0.895, 'Birch Green, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO3', 51.884, 0.863, 'Beacon End, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO4', 51.907, 0.924, '');
INSERT INTO `uk_postcodes` VALUES ('CO5', 51.814, 0.822, 'Abberton, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO6', 51.924, 0.79, 'Aldham, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO7', 51.884, 1.005, 'Aingers Green, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO8', 51.973, 0.767, 'Alphamstone, Essex');
INSERT INTO `uk_postcodes` VALUES ('CO9', 51.969, 0.611, 'Barr Hall, Essex');
INSERT INTO `uk_postcodes` VALUES ('CR0', 51.372, -0.074, 'Addington, Greater London');
INSERT INTO `uk_postcodes` VALUES ('CR2', 51.35, -0.08, 'Sanderstead, Greater London');
INSERT INTO `uk_postcodes` VALUES ('CR3', 51.287, -0.08, 'Caterham, Surrey');
INSERT INTO `uk_postcodes` VALUES ('CR4', 51.404, -0.159, 'Beddington Corner, Greater London');
INSERT INTO `uk_postcodes` VALUES ('CR5', 51.312, -0.139, 'Chipstead, Surrey');
INSERT INTO `uk_postcodes` VALUES ('CR6', 51.308, -0.052, 'Chelsham, Surrey');
INSERT INTO `uk_postcodes` VALUES ('CR7', 51.395, -0.103, '');
INSERT INTO `uk_postcodes` VALUES ('CR8', 51.336, -0.11, 'Kenley, Greater London');
INSERT INTO `uk_postcodes` VALUES ('CT1', 51.277, 1.087, 'Canterbury, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT10', 51.362, 1.431, 'Broadstairs, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT11', 51.336, 1.415, 'Ramsgate, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT12', 51.343, 1.373, 'Cliffs End, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT13', 51.267, 1.33, 'Eastry, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT14', 51.216, 1.387, 'Betteshanger, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT15', 51.171, 1.284, 'Alkham, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT16', 51.14, 1.302, 'Buckland, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT17', 51.128, 1.296, 'Maxton, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT18', 51.114, 1.15, 'Acrise Place, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT19', 51.088, 1.17, 'Cheriton, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT2', 51.293, 1.082, 'Blean, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT20', 51.079, 1.166, 'Sandgate, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT21', 51.073, 1.078, 'Court-at-Street, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT3', 51.278, 1.212, 'Adisham, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT4', 51.225, 1.068, 'Barham, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT5', 51.353, 1.037, 'Chestfield, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT6', 51.364, 1.131, 'Beltinge, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT7', 51.371, 1.301, 'Acol, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT8', 51.38, 1.341, 'Westgate on Sea, Kent');
INSERT INTO `uk_postcodes` VALUES ('CT9', 51.383, 1.391, 'Cliftonville, Kent');
INSERT INTO `uk_postcodes` VALUES ('CV1', 52.41, -1.507, 'Coventry, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('CV10', 52.525, -1.5, 'Ansley, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV11', 52.519, -1.453, 'Attleborough, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV12', 52.474, -1.473, 'Bedworth, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV13', 52.612, -1.414, 'Barlestone, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('CV2', 52.423, -1.464, '');
INSERT INTO `uk_postcodes` VALUES ('CV21', 52.368, -1.274, 'Newbold on Avon, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV22', 52.355, -1.287, 'Bilton, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV23', 52.361, -1.308, 'Ashby St Ledgers, Northamptonshire');
INSERT INTO `uk_postcodes` VALUES ('CV3', 52.393, -1.482, 'Binley, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('CV31', 52.278, -1.524, 'Radford Semele, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV32', 52.296, -1.53, 'Cubbington, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV33', 52.257, -1.484, 'Avon Dassett, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV34', 52.283, -1.579, 'Longbridge, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV35', 52.229, -1.595, 'Ashorne, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV36', 52.067, -1.625, 'Admington, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV37', 52.185, -1.713, 'Alderminster, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV4', 52.398, -1.565, 'Kirby Corner, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('CV47', 52.234, -1.385, 'Kirby Corner, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('CV5', 52.412, -1.551, 'Allesley, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('CV6', 52.432, -1.507, 'Court House Green, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('CV7', 52.444, -1.563, 'Ansty, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV8', 52.351, -1.543, 'Ashow, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CV9', 52.585, -1.558, 'Atherstone, Warwickshire');
INSERT INTO `uk_postcodes` VALUES ('CW1', 53.103, -2.434, 'Bradfield Green, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW10', 53.189, -2.445, 'Bostock Green, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW11', 53.142, -2.365, 'Arclid, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW12', 53.165, -2.212, 'Astbury, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW2', 53.081, -2.446, 'Balterley, Staffordshire');
INSERT INTO `uk_postcodes` VALUES ('CW3', 53, -2.406, 'Audlem, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW4', 53.207, -2.347, 'Blackden Heath, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW5', 53.062, -2.521, 'Acton, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW6', 53.162, -2.666, 'Alpraham, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW7', 53.19, -2.526, 'Foxwist Green, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW8', 53.254, -2.563, 'Acton Bridge, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('CW9', 53.259, -2.501, 'Antrobus, Cheshire');
INSERT INTO `uk_postcodes` VALUES ('DA1', 51.447, 0.21, 'Crayford, Greater London');
INSERT INTO `uk_postcodes` VALUES ('DA10', 51.444, 0.308, 'Northfleet, Kent');
INSERT INTO `uk_postcodes` VALUES ('DA11', 51.434, 0.354, 'Perry Street, Kent');
INSERT INTO `uk_postcodes` VALUES ('DA12', 51.427, 0.389, 'Chalk, Kent');
INSERT INTO `uk_postcodes` VALUES ('DA13', 51.382, 0.355, 'Betsham, Kent');
INSERT INTO `uk_postcodes` VALUES ('DA14', 51.425, 0.113, 'Foots Cray, Greater London');
INSERT INTO `uk_postcodes` VALUES ('DA15', 51.44, 0.1, 'Bexley, Greater London');
INSERT INTO `uk_postcodes` VALUES ('DA16', 51.464, 0.109, 'East Wickham, Greater London');
INSERT INTO `uk_postcodes` VALUES ('DA17', 51.487, 0.149, 'Belvedere, Greater London');
INSERT INTO `uk_postcodes` VALUES ('DA18', 51.492, 0.144, 'Crayford, Greater London');
INSERT INTO `uk_postcodes` VALUES ('DA2', 51.432, 0.234, 'Bean, Kent');
INSERT INTO `uk_postcodes` VALUES ('DA3', 51.385, 0.31, 'Fawkham Green, Kent');
INSERT INTO `uk_postcodes` VALUES ('DA4', 51.391, 0.233, 'Eynsford, Kent');
INSERT INTO `uk_postcodes` VALUES ('DA5', 51.44, 0.146, 'Coldblow, Greater London');
INSERT INTO `uk_postcodes` VALUES ('DA6', 51.455, 0.14, 'Bexleyheath, Greater London');
INSERT INTO `uk_postcodes` VALUES ('DA7', 51.466, 0.147, '');
INSERT INTO `uk_postcodes` VALUES ('DA8', 51.475, 0.178, 'Erith, Greater London');
INSERT INTO `uk_postcodes` VALUES ('DA9', 51.447, 0.28, 'Greenhithe, Kent');
INSERT INTO `uk_postcodes` VALUES ('DD1', 56.461, -2.977, 'Dundee, Dundee City');
INSERT INTO `uk_postcodes` VALUES ('DD10', 56.747, -2.427, 'Allardice, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('DD11', 56.573, -2.598, 'Arbirlot, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD2', 56.47, -3.027, 'Benvie, Dundee City');
INSERT INTO `uk_postcodes` VALUES ('DD3', 56.482, -2.988, 'Auchterhouse, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD4', 56.482, -2.935, 'Balgray, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD5', 56.478, -2.862, 'Affleck, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD6', 56.437, -2.925, 'Balmerino, Fife');
INSERT INTO `uk_postcodes` VALUES ('DD7', 56.503, -2.718, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AA', 56.5026, -2.7117, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AB', 56.5037, -2.7113, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AD', 56.5008, -2.7114, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AE', 56.5012, -2.7114, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AF', 56.5005, -2.7104, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AG', 56.5011, -2.7101, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AH', 56.5015, -2.7099, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AJ', 56.5007, -2.709, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AL', 56.5017, -2.7091, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AN', 56.5015, -2.708, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AP', 56.5016, -2.7087, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AQ', 56.5021, -2.7083, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AR', 56.5012, -2.7067, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AS', 56.5014, -2.7041, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AT', 56.5015, -2.7052, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AU', 56.502, -2.6998, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AW', 56.5021, -2.701, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AX', 56.5011, -2.7024, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AY', 56.5013, -2.6997, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76AZ', 56.502, -2.699, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BA', 56.5015, -2.6989, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BB', 56.5018, -2.6975, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BD', 56.5024, -2.6975, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BE', 56.5026, -2.6965, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BG', 56.5036, -2.6951, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BH', 56.5036, -2.6963, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BJ', 56.5038, -2.6969, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BL', 56.5028, -2.6985, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BN', 56.5024, -2.7013, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BP', 56.5024, -2.7, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BQ', 56.5038, -2.6979, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BR', 56.5032, -2.6988, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BS', 56.5038, -2.6994, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BT', 56.503, -2.7017, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BU', 56.504, -2.7028, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BW', 56.5034, -2.7026, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BX', 56.5027, -2.7019, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BY', 56.5023, -2.7019, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76BZ', 56.503, -2.703, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DA', 56.5037, -2.7037, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DB', 56.5035, -2.7048, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DD', 56.5018, -2.7052, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DE', 56.5023, -2.7043, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DF', 56.5022, -2.7072, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DG', 56.5027, -2.7045, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DH', 56.5031, -2.7054, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DJ', 56.5029, -2.706, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DL', 56.5049, -2.6997, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DN', 56.5041, -2.7012, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DP', 56.5063, -2.6996, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DQ', 56.507, -2.7059, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DR', 56.5051, -2.7025, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DS', 56.5067, -2.7026, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DT', 56.5077, -2.6998, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DU', 56.5047, -2.7039, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DW', 56.5046, -2.6994, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DX', 56.5086, -2.7016, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DY', 56.5096, -2.7035, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76DZ', 56.5036, -2.7027, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EA', 56.504, -2.6949, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EB', 56.5019, -2.7119, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76ED', 56.5021, -2.7104, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EE', 56.5029, -2.7093, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EF', 56.5026, -2.7101, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EG', 56.5038, -2.71, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EH', 56.5041, -2.7076, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EJ', 56.5031, -2.7068, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EL', 56.5038, -2.7057, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EN', 56.504, -2.7052, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EP', 56.5042, -2.7043, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EQ', 56.5046, -2.7043, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76ER', 56.5048, -2.7051, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76ES', 56.5047, -2.706, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76ET', 56.5045, -2.7065, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EU', 56.5057, -2.7052, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EW', 56.506, -2.7066, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EX', 56.5078, -2.7086, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76EY', 56.5077, -2.7094, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76FR', 56.5015, -2.7068, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76GP', 56.5052, -2.7182, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76GQ', 56.5081, -2.7141, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76GR', 56.5052, -2.7182, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76GS', 56.508, -2.715, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76GU', 56.5074, -2.7169, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76GX', 56.5073, -2.7159, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76GZ', 56.5071, -2.716, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HA', 56.5057, -2.707, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HB', 56.5047, -2.7075, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HD', 56.5054, -2.7076, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HE', 56.5046, -2.7091, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HF', 56.5044, -2.711, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HG', 56.5044, -2.7115, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HH', 56.5044, -2.7129, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HJ', 56.5048, -2.7138, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HL', 56.5059, -2.7133, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HN', 56.5057, -2.7136, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HP', 56.5055, -2.7141, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HQ', 56.5072, -2.7135, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HR', 56.5063, -2.7168, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HS', 56.5096, -2.7084, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HT', 56.5091, -2.7077, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HU', 56.5083, -2.7075, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HW', 56.5073, -2.7104, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HX', 56.5087, -2.7066, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HY', 56.5099, -2.7051, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76HZ', 56.506, -2.7084, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JA', 56.5061, -2.7105, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JB', 56.5072, -2.7116, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JD', 56.5067, -2.7125, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JG', 56.5105, -2.7023, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JJ', 56.5108, -2.7044, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JL', 56.5105, -2.7048, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JN', 56.5102, -2.7016, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JP', 56.5126, -2.6972, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JQ', 56.5134, -2.6867, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JR', 56.5073, -2.6877, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JS', 56.5056, -2.695, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JX', 56.5265, -2.7117, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JY', 56.5048, -2.6962, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76JZ', 56.5055, -2.698, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LA', 56.5098, -2.7266, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LB', 56.5222, -2.7393, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LD', 56.5135, -2.718, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LE', 56.5254, -2.7118, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LG', 56.5212, -2.7023, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LH', 56.531, -2.7034, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LL', 56.5217, -2.6812, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LN', 56.516, -2.668, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LP', 56.526, -2.668, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LQ', 56.5136, -2.6683, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LR', 56.5171, -2.6688, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LS', 56.5172, -2.6661, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LT', 56.5173, -2.6642, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LU', 56.5357, -2.7287, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LW', 56.5326, -2.7614, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LX', 56.5244, -2.765, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LY', 56.5156, -2.7518, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76LZ', 56.5168, -2.6679, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76PA', 56.5029, -2.7037, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76WX', 56.503, -2.7193, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76YB', 56.503, -2.7193, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76YG', 56.503, -2.7193, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76YL', 56.5106, -2.7259, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76YP', 56.503, -2.7193, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76YQ', 56.503, -2.7193, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD76YR', 56.503, -2.7193, 'Barry, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD8', 56.656, -2.922, 'Aberlemno, Angus');
INSERT INTO `uk_postcodes` VALUES ('DD9', 56.748, -2.667, 'Arnhall, Aberdeenshire');
INSERT INTO `uk_postcodes` VALUES ('DE1', 52.92, -1.475, 'Derby, Derby');
INSERT INTO `uk_postcodes` VALUES ('DE11', 52.773, -1.554, 'Blackfordby, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('DE12', 52.725, -1.553, 'Appleby Magna, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('DE13', 52.808, -1.688, 'Alrewas, Staffordshire');
INSERT INTO `uk_postcodes` VALUES ('DE14', 52.805, -1.64, 'Branston, Staffordshire');
INSERT INTO `uk_postcodes` VALUES ('DE15', 52.799, -1.608, 'Bretby, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE21', 52.933, -1.432, 'Chaddesden, Derby');
INSERT INTO `uk_postcodes` VALUES ('DE22', 52.934, -1.496, 'Allestree, Derby');
INSERT INTO `uk_postcodes` VALUES ('DE23', 52.901, -1.494, 'Littleover, Derby');
INSERT INTO `uk_postcodes` VALUES ('DE24', 52.89, -1.451, 'Alvaston, Derby');
INSERT INTO `uk_postcodes` VALUES ('DE3', 52.909, -1.54, 'Mickleover, Derby');
INSERT INTO `uk_postcodes` VALUES ('DE4', 53.127, -1.564, 'Aldwark, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE45', 53.215, -1.676, 'Alport, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE5', 53.045, -1.401, 'Butterley, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE55', 53.101, -1.371, 'Alfreton, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE56', 53.022, -1.474, 'Alderwasley, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE6', 52.993, -1.717, 'Alkmonton, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE65', 52.867, -1.61, 'Burnaston, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE7', 52.973, -1.321, 'Breadsall, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE72', 52.894, -1.359, 'Aston on Trent, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE73', 52.847, -1.435, 'Barrow upon Trent, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE74', 52.844, -1.33, 'Castle Donington, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DE75', 53.013, -1.353, 'Heanor, Derbyshire');
INSERT INTO `uk_postcodes` VALUES ('DG1', 55.073, -3.58, 'Ae Village, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG10', 55.32, -3.437, 'Beattock, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG11', 55.114, -3.336, 'Bankshill, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG12', 54.99, -3.251, 'Annan, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG13', 55.173, -3.029, 'Allangillfoot, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG14', 55.081, -2.985, 'Auchenrivock, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG16', 54.997, -3.068, 'Gretna Green, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG2', 55.065, -3.657, 'Allanton, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG3', 55.237, -3.799, 'Auchenbrack, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG4', 55.375, -3.952, 'Carco, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG5', 54.922, -3.81, 'Barnbarroch, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG6', 54.837, -4.055, 'Auchnabony, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG7', 54.968, -4.012, 'Airieland, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG8', 54.873, -4.516, 'Airyhassen, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DG9', 54.878, -5.021, 'Airies, Dumfries and Galloway');
INSERT INTO `uk_postcodes` VALUES ('DH1', 54.781, -1.566, 'Carrville, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DH2', 54.86, -1.597, 'Edmondsley, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DH3', 54.872, -1.567, 'Birtley, Tyne and Wear');
INSERT INTO `uk_postcodes` VALUES ('DH4', 54.854, -1.49, 'Bournmoor, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DH5', 54.824, -1.454, 'Easington Lane, Tyne and Wear');
INSERT INTO `uk_postcodes` VALUES ('DH6', 54.753, -1.464, 'Bowburn, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DH7', 54.79, -1.664, 'Bearpark, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DH8', 54.856, -1.844, 'Allensford, Northumberland');
INSERT INTO `uk_postcodes` VALUES ('DH9', 54.868, -1.708, 'Annfield Plain, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DL1', 54.53, -1.536, 'Barmpton, Darlington');
INSERT INTO `uk_postcodes` VALUES ('DL10', 54.414, -1.69, 'Barton, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DL11', 54.439, -1.875, 'Aldbrough St John, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DL12', 54.572, -1.985, 'Barnard Castle, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DL13', 54.716, -1.954, 'Bedburn, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DL14', 54.652, -1.69, 'Bildershaw, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DL15', 54.71, -1.728, 'Billy Row, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DL16', 54.699, -1.604, 'Byers Green, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DL17', 54.681, -1.54, 'Bishop Middleham, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DL2', 54.529, -1.601, 'Archdeacon Newton, Darlington');
INSERT INTO `uk_postcodes` VALUES ('DL3', 54.532, -1.57, 'Darlington, Darlington');
INSERT INTO `uk_postcodes` VALUES ('DL4', 54.63, -1.643, 'Middridge, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DL5', 54.617, -1.576, 'Aycliffe, County Durham');
INSERT INTO `uk_postcodes` VALUES ('DL6', 54.371, -1.389, 'Appleton Wiske, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DL7', 54.338, -1.485, 'Ainderby Steeple, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DL8', 54.293, -1.786, 'Agglethorpe, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DL9', 54.375, -1.709, 'Catterick Camp, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN1', 53.522, -1.129, 'Doncaster, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN10', 53.427, -0.943, 'Austerfield, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN11', 53.451, -1.082, 'Bircotes, Nottinghamshire');
INSERT INTO `uk_postcodes` VALUES ('DN12', 53.483, -1.221, 'Conisbrough, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN14', 53.708, -0.936, 'Adlingfleet, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN15', 53.614, -0.65, 'Alkborough, North Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN16', 53.568, -0.64, 'Ashby, North Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN17', 53.572, -0.701, 'Althorpe, North Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN18', 53.68, -0.446, 'Barton-upon-Humber, North Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN19', 53.684, -0.359, 'Barrow Haven, North Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN2', 53.533, -1.102, '');
INSERT INTO `uk_postcodes` VALUES ('DN20', 53.558, -0.505, 'Bonby, North Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN21', 53.419, -0.701, 'Blyborough, Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN22', 53.323, -0.927, 'Babworth, Nottinghamshire');
INSERT INTO `uk_postcodes` VALUES ('DN3', 53.546, -1.059, 'Armthorpe, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN31', 53.57, -0.086, 'West Marsh, North Eart Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN32', 53.562, -0.069, 'Grimsby, North Eart Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN33', 53.54, -0.097, 'Scartho, North Eart Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN34', 53.557, -0.112, 'Armthorpe, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN35', 53.555, -0.035, 'Cleethorpes, North Eart Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN36', 53.511, -0.037, 'Eskham, Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN37', 53.541, -0.135, 'Ashby cum Fenby, North Eart Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN38', 53.561, -0.392, 'Barnetby le Wold, North Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN39', 53.617, -0.334, 'Croxton, North Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN4', 53.506, -1.121, 'Bessacarr, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN40', 53.621, -0.224, 'East Halton, North Lincolnshire');
INSERT INTO `uk_postcodes` VALUES ('DN41', 53.583, -0.195, 'Bessacarr, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN5', 53.537, -1.172, 'Arksey, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN6', 53.596, -1.176, 'Adwick le Street, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN7', 53.582, -1.015, 'Braithwaite, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN8', 53.614, -0.956, 'Moorends, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DN9', 53.506, -0.894, 'Auckley, South Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('DT1', 50.711, -2.44, 'Dorchester, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DT10', 50.937, -2.333, 'Fifehead Neville, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DT11', 50.86, -2.181, 'Almer, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DT2', 50.749, -2.453, 'Affpuddle, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DT3', 50.641, -2.466, 'Abbotsbury, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DT4', 50.609, -2.464, 'Charlestown, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DT5', 50.548, -2.441, 'Easton, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DT6', 50.739, -2.775, 'Bettiscombe, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DT7', 50.729, -2.946, 'Dowlands, Devon');
INSERT INTO `uk_postcodes` VALUES ('DT8', 50.816, -2.758, 'Beaminster, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DT9', 50.941, -2.515, 'Adber, Dorset');
INSERT INTO `uk_postcodes` VALUES ('DY1', 52.516, -2.096, 'Dudley, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('DY10', 52.386, -2.224, 'Blakedown, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('DY11', 52.385, -2.261, 'Blakebrook, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('DY12', 52.385, -2.329, 'Bewdley, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('DY13', 52.336, -2.28, 'Acton, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('DY14', 52.38, -2.462, 'Baveney Wood, Shropshire');
INSERT INTO `uk_postcodes` VALUES ('DY2', 52.496, -2.08, 'Netherton, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('DY3', 52.53, -2.128, 'Gornalwood, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('DY4', 52.532, -2.053, 'Dudley Port, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('DY5', 52.48, -2.122, 'Brierley Hill, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('DY6', 52.498, -2.164, 'Kingswinford, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('DY7', 52.466, -2.224, 'Bobbington, Staffordshire');
INSERT INTO `uk_postcodes` VALUES ('DY8', 52.46, -2.154, 'Amblecote, West Midlands');
INSERT INTO `uk_postcodes` VALUES ('DY9', 52.435, -2.122, 'Belbroughton, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('E1', 51.517, -0.058, 'Aldgate East, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E10', 51.568, -0.012, 'Lea Bridge, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E11', 51.568, 0.014, 'Leytonstone, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E12', 51.55, 0.054, 'Aldersbrook, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E13', 51.527, 0.027, 'Newham, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E14', 51.506, -0.019, 'All Saints, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E15', 51.539, 0.003, 'Pudding Mill Lane, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E16', 51.511, 0.026, 'Canning Town, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E17', 51.586, -0.019, 'Blackhorse Road, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E18', 51.592, 0.027, 'South Woodford, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E1W', 51.508, -0.058, '');
INSERT INTO `uk_postcodes` VALUES ('E2', 51.529, -0.061, 'Bethnal Green, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E3', 51.528, -0.025, 'Bow Church, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E4', 51.622, -0.003, 'Chingford Green, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E5', 51.559, -0.053, 'Clapton Park, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E6', 51.526, 0.056, 'Beckton, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E7', 51.547, 0.028, 'Forest Gate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E8', 51.542, -0.064, 'Dalston Junction, Greater London');
INSERT INTO `uk_postcodes` VALUES ('E9', 51.543, -0.043, 'Hackney Wick, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC1', 51.523, -0.102, 'Aldersgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC1A', 51.52, -0.103, 'Aldersgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC1M', 51.521, -0.102, 'Aldersgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC1N', 51.52, -0.108, 'Aldersgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC1R', 51.524, -0.107, 'Aldersgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC1V', 51.526, -0.097, 'Aldersgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC1Y', 51.523, -0.093, 'Aldersgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC2', 51.52, -0.089, 'Bank, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC2A', 51.523, -0.085, 'Bank, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC2M', 51.518, -0.086, 'Bank, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC2N', 51.516, -0.086, 'Bank, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC2R', 51.517, -0.092, 'Bank, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC2V', 51.516, -0.093, 'Bank, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC2Y', 51.52, -0.096, 'Bank, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC3', 51.513, -0.083, 'Aldgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC3A', 51.515, -0.081, 'Aldgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC3M', 51.512, -0.083, 'Aldgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC3N', 51.513, -0.079, 'Aldgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC3P', 51.52, -0.101, 'Aldgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC3R', 51.512, -0.085, 'Tower of London, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC3V', 51.513, -0.086, 'Aldgate, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC4', 51.514, -0.101, 'Blackfriars, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC4A', 51.516, -0.107, 'Blackfriars, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC4M', 51.515, -0.1, 'Blackfriars, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC4N', 51.514, -0.093, 'Blackfriars, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC4R', 51.512, -0.091, 'Blackfriars, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC4V', 51.513, -0.1, 'Blackfriars, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EC4Y', 51.514, -0.107, 'Blackfriars, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EH1', 55.952, -3.188, 'Edinburgh, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH10', 55.92, -3.21, 'Fairmilehead, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH11', 55.934, -3.249, 'Edinburgh, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH12', 55.943, -3.272, 'Corstorphine, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH13', 55.908, -3.241, 'Colinton, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH14', 55.91, -3.283, 'Balerno, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH15', 55.946, -3.111, 'Duddingston, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH16', 55.923, -3.153, 'Craigmillar, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH17', 55.907, -3.142, 'Gilmerton, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH18', 55.876, -3.121, 'Polton, Midlothian');
INSERT INTO `uk_postcodes` VALUES ('EH19', 55.873, -3.104, 'Bonnyrigg, Midlothian');
INSERT INTO `uk_postcodes` VALUES ('EH2', 55.954, -3.195, 'Edinburgh, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH20', 55.879, -3.155, 'Loanhead, Midlothian');
INSERT INTO `uk_postcodes` VALUES ('EH21', 55.939, -3.045, 'Inveresk, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH22', 55.884, -3.06, 'Cousland, Midlothian');
INSERT INTO `uk_postcodes` VALUES ('EH23', 55.839, -3.051, 'Arniston Engine, Midlothian');
INSERT INTO `uk_postcodes` VALUES ('EH24', 55.851, -3.133, 'Rosewell, Midlothian');
INSERT INTO `uk_postcodes` VALUES ('EH25', 55.858, -3.175, 'Bilston, Midlothian');
INSERT INTO `uk_postcodes` VALUES ('EH26', 55.833, -3.224, 'Auchendinny, Midlothian');
INSERT INTO `uk_postcodes` VALUES ('EH27', 55.89, -3.422, 'Kirknewton, West Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH28', 55.931, -3.387, 'Newbridge, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH29', 55.956, -3.399, 'Kirkliston, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH3', 55.954, -3.2, 'Edinburgh, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH30', 55.985, -3.384, 'Abercorn, West Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH31', 56.037, -2.827, 'Gullane, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH32', 55.968, -2.948, 'Aberlady, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH33', 55.942, -2.944, 'Elphinstone, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH34', 55.909, -2.88, 'East Saltoun, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH35', 55.911, -2.942, 'Ormiston, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH36', 55.856, -2.851, 'Gilchriston, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH37', 55.862, -2.96, 'Crichton, Midlothian');
INSERT INTO `uk_postcodes` VALUES ('EH38', 55.786, -2.96, 'Dewar, Scottish Borders');
INSERT INTO `uk_postcodes` VALUES ('EH39', 56.047, -2.731, 'Athelstaneford, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH4', 55.962, -3.258, 'Blackhall, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH40', 55.99, -2.655, 'East Linton, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH41', 55.948, -2.774, 'Bolton, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH42', 55.994, -2.525, 'Belhaven, East Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH43', 55.624, -3.01, 'Walkerburn, Scottish Borders');
INSERT INTO `uk_postcodes` VALUES ('EH44', 55.62, -3.065, 'Colquhar, Scottish Borders');
INSERT INTO `uk_postcodes` VALUES ('EH45', 55.655, -3.191, 'Cardrona, Scottish Borders');
INSERT INTO `uk_postcodes` VALUES ('EH46', 55.737, -3.35, 'Blyth Bridge, Scottish Borders');
INSERT INTO `uk_postcodes` VALUES ('EH47', 55.86, -3.663, 'Blackburn, West Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH48', 55.901, -3.664, 'Armadale, West Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH49', 55.976, -3.598, 'Belsyde, West Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH5', 55.975, -3.216, 'Edinburgh, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH51', 56.011, -3.605, '');
INSERT INTO `uk_postcodes` VALUES ('EH52', 55.938, -3.483, 'Broxburn, West Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH53', 55.894, -3.476, 'East Calder, West Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH54', 55.892, -3.523, 'Bellsquarry, West Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH55', 55.848, -3.572, 'Addiewell, West Lothian');
INSERT INTO `uk_postcodes` VALUES ('EH6', 55.971, -3.174, 'Edinburgh, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH7', 55.961, -3.165, 'Edinburgh, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH8', 55.949, -3.163, 'Edinburgh, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EH9', 55.933, -3.185, 'Edinburgh, City of Edinburgh');
INSERT INTO `uk_postcodes` VALUES ('EN1', 51.653, -0.066, 'Enfield, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EN10', 51.74, -0.02, 'Broxbourne, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('EN11', 51.765, -0.007, 'Hailey, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('EN2', 51.659, -0.091, 'Botany Bay, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EN3', 51.659, -0.038, 'Ponders End, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EN4', 51.648, -0.16, 'Cockfosters, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EN5', 51.649, -0.195, 'Arkley, Greater London');
INSERT INTO `uk_postcodes` VALUES ('EN6', 51.699, -0.176, 'Cuffley, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('EN7', 51.71, -0.065, 'Churchgate, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('EN8', 51.698, -0.032, 'Cheshunt, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('EN9', 51.695, 0.014, 'Broadley Common, Essex');
INSERT INTO `uk_postcodes` VALUES ('EX1', 50.726, -3.505, 'Pinhoe, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX10', 50.693, -3.245, 'Bowd, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX11', 50.746, -3.288, 'Alfington, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX12', 50.706, -3.081, 'Axmouth, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX13', 50.786, -3.007, 'Alston, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX14', 50.813, -3.189, 'Awliscombe, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX15', 50.877, -3.338, 'Ashill, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX16', 50.923, -3.491, 'Ash Thomas, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX17', 50.812, -3.702, 'Ash Bullayne, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX18', 50.901, -3.887, 'Ashley, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX19', 50.877, -4.004, 'Beaford, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX2', 50.71, -3.517, 'Alphington, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX20', 50.75, -4.019, 'Allerford, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX21', 50.805, -4.208, 'Ashwater, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX22', 50.828, -4.367, 'Abbots Bickington, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX23', 50.824, -4.533, 'Bude, Cornwall');
INSERT INTO `uk_postcodes` VALUES ('EX24', 50.739, -3.088, 'Alphington, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX3', 50.686, -3.458, 'Clyst St George, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX31', 51.086, -4.064, 'Alverdiscott, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX32', 51.071, -4.018, 'Benton, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX33', 51.114, -4.169, 'Braunton, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX34', 51.199, -4.103, 'Berrynarbor, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX35', 51.224, -3.828, 'Barbrook, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX36', 51.016, -3.792, 'Alswear, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX37', 50.979, -3.951, 'Atherington, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX38', 50.943, -4.151, 'Frithelstock Stone, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX39', 51.014, -4.246, 'Abbotsham, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX4', 50.73, -3.526, 'Cowley, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX5', 50.757, -3.439, 'Aylesbeare, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX6', 50.677, -3.597, 'Bickham House, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX7', 50.592, -3.473, 'Ashcombe, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX8', 50.629, -3.401, 'Exmouth, Devon');
INSERT INTO `uk_postcodes` VALUES ('EX9', 50.639, -3.323, 'Budleigh Salterton, Devon');
INSERT INTO `uk_postcodes` VALUES ('FK1', 55.985, -3.793, 'Avonbridge, Falkirk');
INSERT INTO `uk_postcodes` VALUES ('FK10', 56.115, -3.781, 'Alloa, Clackmannanshire');
INSERT INTO `uk_postcodes` VALUES ('FK11', 56.15, -3.85, 'Menstrie, Clackmannanshire');
INSERT INTO `uk_postcodes` VALUES ('FK12', 56.152, -3.8, 'Alva, Clackmannanshire');
INSERT INTO `uk_postcodes` VALUES ('FK13', 56.151, -3.74, 'Coalsnaughton, Clackmannanshire');
INSERT INTO `uk_postcodes` VALUES ('FK14', 56.166, -3.66, 'Blairingone, Perth and Kinross');
INSERT INTO `uk_postcodes` VALUES ('FK15', 56.203, -3.949, 'Ashfield, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FK16', 56.191, -4.059, 'Argaty, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FK17', 56.24, -4.219, 'Anie, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FK18', 56.325, -4.328, 'Ardchullarie More, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FK19', 56.371, -4.313, 'Ardveich, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FK2', 56.005, -3.754, 'Airth, Falkirk');
INSERT INTO `uk_postcodes` VALUES ('FK20', 56.406, -4.63, 'Ardchyle, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FK21', 56.466, -4.319, 'Achmore, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FK3', 56.011, -3.719, 'Grangemouth, Falkirk');
INSERT INTO `uk_postcodes` VALUES ('FK4', 55.997, -3.906, 'Banknock, Falkirk');
INSERT INTO `uk_postcodes` VALUES ('FK5', 56.025, -3.818, 'Glenbervie, Falkirk');
INSERT INTO `uk_postcodes` VALUES ('FK6', 56.022, -3.915, 'Carron Bridge, Falkirk');
INSERT INTO `uk_postcodes` VALUES ('FK7', 56.097, -3.917, 'Bannockburn, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FK8', 56.131, -4.051, 'Aberfoyle, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FK9', 56.142, -3.94, 'Blair Drummond, Stirling');
INSERT INTO `uk_postcodes` VALUES ('FY1', 53.815, -3.046, 'Blackpool, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('FY2', 53.845, -3.039, 'Bispham, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('FY3', 53.821, -3.021, 'Great Marton, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('FY4', 53.791, -3.028, 'Common Edge, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('FY5', 53.874, -3.021, 'Burn Naze, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('FY6', 53.868, -2.981, 'Carleton, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('FY7', 53.916, -3.026, 'Fleetwood, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('FY8', 53.751, -3.002, 'Ansdell, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('G1', 55.86, -4.247, 'Glasgow, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G11', 55.874, -4.312, 'Partick, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G12', 55.88, -4.3, 'Glasgow, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G13', 55.894, -4.347, '');
INSERT INTO `uk_postcodes` VALUES ('G14', 55.881, -4.349, 'Yoker, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G15', 55.91, -4.365, 'Drumchapel, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G2', 55.864, -4.255, 'Glasgow, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G20', 55.886, -4.282, 'Maryhill, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G21', 55.881, -4.22, 'Springburn, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G22', 55.89, -4.251, '');
INSERT INTO `uk_postcodes` VALUES ('G23', 55.902, -4.284, '');
INSERT INTO `uk_postcodes` VALUES ('G3', 55.866, -4.272, '');
INSERT INTO `uk_postcodes` VALUES ('G31', 55.857, -4.208, '');
INSERT INTO `uk_postcodes` VALUES ('G32', 55.849, -4.163, 'Carmyle, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G33', 55.873, -4.165, 'Stepps, North Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G34', 55.868, -4.111, '');
INSERT INTO `uk_postcodes` VALUES ('G4', 55.868, -4.252, '');
INSERT INTO `uk_postcodes` VALUES ('G40', 55.848, -4.222, '');
INSERT INTO `uk_postcodes` VALUES ('G41', 55.838, -4.282, 'Glasgow, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G42', 55.833, -4.256, '');
INSERT INTO `uk_postcodes` VALUES ('G43', 55.818, -4.29, 'Pollokshaws, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G44', 55.814, -4.255, '');
INSERT INTO `uk_postcodes` VALUES ('G45', 55.805, -4.231, 'Castlemilk, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G46', 55.804, -4.307, 'Giffnock, East Renfrewshire');
INSERT INTO `uk_postcodes` VALUES ('G5', 55.848, -4.252, '');
INSERT INTO `uk_postcodes` VALUES ('G51', 55.858, -4.314, 'Govan, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G52', 55.848, -4.348, '');
INSERT INTO `uk_postcodes` VALUES ('G53', 55.822, -4.351, 'Nitshill, Glasgow City');
INSERT INTO `uk_postcodes` VALUES ('G60', 55.922, -4.453, 'Bowling, West Dunbart');
INSERT INTO `uk_postcodes` VALUES ('G61', 55.919, -4.33, 'Bearsden, East Dunbartonshire');
INSERT INTO `uk_postcodes` VALUES ('G62', 55.943, -4.32, 'Baldernock, East Dunbartonshire');
INSERT INTO `uk_postcodes` VALUES ('G63', 56.042, -4.364, 'Balafark, Stirling');
INSERT INTO `uk_postcodes` VALUES ('G64', 55.911, -4.217, 'Balmore, East Dunbartonshire');
INSERT INTO `uk_postcodes` VALUES ('G65', 55.973, -4.057, 'Banton, North Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G66', 55.941, -4.153, 'Auchinloch, North Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G67', 55.947, -3.985, 'Abronhill, North Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G68', 55.953, -4.01, 'Balloch, North Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G69', 55.874, -4.102, 'Chryston, North Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G71', 55.822, -4.073, 'Bothwell, South Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G72', 55.804, -4.128, 'Calderglen, South Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G73', 55.82, -4.206, 'Rutherglen, South Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G74', 55.769, -4.173, 'East Kilbride, South Lanarkshire');
INSERT INTO `uk_postcodes` VALUES ('G76', 55.778, -4.272, 'Busby, East Renfrewshire');
INSERT INTO `uk_postcodes` VALUES ('G77', 55.774, -4.33, 'Malletsheugh, East Renfrewshire');
INSERT INTO `uk_postcodes` VALUES ('G78', 55.793, -4.409, 'Barrhead, East Renfrewshire');
INSERT INTO `uk_postcodes` VALUES ('G81', 55.913, -4.406, 'Clydebank, West Dunbart');
INSERT INTO `uk_postcodes` VALUES ('G82', 55.952, -4.574, 'Ardmore, Argyll and Bute');
INSERT INTO `uk_postcodes` VALUES ('G83', 56.012, -4.585, 'Aldochlay, Argyll and Bute');
INSERT INTO `uk_postcodes` VALUES ('G84', 56.014, -4.754, 'Ardpeaton, Argyll and Bute');
INSERT INTO `uk_postcodes` VALUES ('GL1', 51.86, -2.239, 'Gloucester, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL10', 51.743, -2.284, 'Eastington, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL11', 51.689, -2.356, 'Cam, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL12', 51.625, -2.385, 'Alderley, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL13', 51.693, -2.459, 'Berkeley, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL14', 51.817, -2.479, 'Awre, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL15', 51.736, -2.551, 'Alvington, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL16', 51.795, -2.611, 'Berry Hill, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL17', 51.856, -2.514, 'Blaisdon, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL18', 51.941, -2.414, '');
INSERT INTO `uk_postcodes` VALUES ('GL19', 51.943, -2.286, 'Apperley, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL2', 51.846, -2.267, 'Arlingham, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL20', 52.003, -2.13, 'Alderton, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL3', 51.865, -2.177, 'Brockworth, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL4', 51.842, -2.216, 'Barnwood, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL5', 51.738, -2.219, 'Amberley, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL50', 51.9, -2.08, 'Cheltenham, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL51', 51.899, -2.107, 'Badgeworth, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL52', 51.916, -2.058, '');
INSERT INTO `uk_postcodes` VALUES ('GL53', 51.881, -2.067, 'Coberley, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL54', 51.897, -1.864, 'Aldsworth, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL55', 52.061, -1.768, 'Aston Subedge, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL56', 51.988, -1.704, 'Adlestrop, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL6', 51.735, -2.192, 'Barton End, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL7', 51.713, -1.897, 'Ablington, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL8', 51.642, -2.171, 'Ashley, Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GL9', 51.557, -2.298, 'Acton Turville, South Gloucestershire');
INSERT INTO `uk_postcodes` VALUES ('GU1', 51.243, -0.564, 'Burpham, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU10', 51.197, -0.796, '');
INSERT INTO `uk_postcodes` VALUES ('GU11', 51.248, -0.761, 'Farnborough, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU12', 51.251, -0.731, 'Aldershot, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU13', 51.274, -0.837, 'Church Crookham, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU14', 51.293, -0.761, 'Cove, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU15', 51.334, -0.739, 'Camberley, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU16', 51.311, -0.729, 'Deepcut, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU17', 51.329, -0.785, 'Blackwater, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU18', 51.349, -0.67, 'Lightwater, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU19', 51.36, -0.69, 'Bagshot, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU2', 51.245, -0.592, 'Onslow Village, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU20', 51.368, -0.656, 'Windlesham, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU21', 51.32, -0.577, 'Horsell, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU22', 51.312, -0.55, 'Mayford, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU23', 51.297, -0.508, 'Ockham, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU24', 51.329, -0.626, 'Bisley, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU25', 51.401, -0.57, 'Virginia Water, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU26', 51.112, -0.746, 'Beacon Hill, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU27', 51.082, -0.718, 'Camelsdale, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU28', 50.99, -0.63, 'Balls Cross, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('GU29', 50.984, -0.746, 'Bepton, West Sussex');
INSERT INTO `uk_postcodes` VALUES ('GU3', 51.246, -0.624, 'Compton, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU30', 51.074, -0.803, 'Bramshott, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU31', 50.996, -0.902, 'Buriton, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU32', 51.008, -0.97, 'East Meon, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU33', 51.049, -0.891, 'Blackmoor, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU34', 51.139, -0.983, 'Alton, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU35', 51.116, -0.846, 'Arford, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU4', 51.243, -0.541, 'Blackheath, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU46', 51.337, -0.825, 'Darby Green, Hampshire');
INSERT INTO `uk_postcodes` VALUES ('GU47', 51.348, -0.788, 'Sandhurst, Berkshire');
INSERT INTO `uk_postcodes` VALUES ('GU5', 51.203, -0.515, 'Albury Heath, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU51', 51.283, -0.84, 'Albury Heath, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU52', 51.264, -0.838, 'Albury Heath, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU6', 51.141, -0.482, 'Alfold Crossways, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU7', 51.189, -0.61, 'Busbridge, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU8', 51.151, -0.64, 'Bowlhead Green, Surrey');
INSERT INTO `uk_postcodes` VALUES ('GU9', 51.218, -0.793, 'Badshot Lea, Surrey');
INSERT INTO `uk_postcodes` VALUES ('HA0', 51.55, -0.304, 'Alperton, Greater London');
INSERT INTO `uk_postcodes` VALUES ('HA1', 51.58, -0.336, 'Greenhill, Greater London');
INSERT INTO `uk_postcodes` VALUES ('HA2', 51.574, -0.357, 'Harrow, Greater London');
INSERT INTO `uk_postcodes` VALUES ('HA3', 51.592, -0.32, 'Harrow Weald, Greater London');
INSERT INTO `uk_postcodes` VALUES ('HA4', 51.57, -0.409, 'Ruislip, Greater London');
INSERT INTO `uk_postcodes` VALUES ('HA5', 51.594, -0.385, 'Eastcote, Greater London');
INSERT INTO `uk_postcodes` VALUES ('HA6', 51.61, -0.42, 'Eastbury, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('HA7', 51.61, -0.307, 'Stanmore, Greater London');
INSERT INTO `uk_postcodes` VALUES ('HA8', 51.611, -0.272, 'Burnt Oak, Greater London');
INSERT INTO `uk_postcodes` VALUES ('HA9', 51.559, -0.287, 'Brent, Greater London');
INSERT INTO `uk_postcodes` VALUES ('HD1', 53.647, -1.788, 'Huddersfield, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HD2', 53.668, -1.775, '');
INSERT INTO `uk_postcodes` VALUES ('HD3', 53.653, -1.828, 'Lindley, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HD4', 53.626, -1.796, 'Almondbury, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HD5', 53.647, -1.746, 'Kirkheaton, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HD6', 53.702, -1.782, 'Brighouse, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HD7', 53.624, -1.877, 'Austonley, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HD8', 53.601, -1.679, 'Clayton West, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HD9', 53.58, -1.795, '');
INSERT INTO `uk_postcodes` VALUES ('HG1', 54, -1.533, 'Bilton, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HG2', 53.987, -1.526, '');
INSERT INTO `uk_postcodes` VALUES ('HG3', 54.031, -1.616, 'Beckwithshaw, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HG4', 54.156, -1.566, 'Aldburgh, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HG5', 54.013, -1.457, 'Arkendale, North Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HP1', 51.755, -0.488, 'Bourne End, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('HP10', 51.609, -0.702, 'Flackwell Heath, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP11', 51.624, -0.744, 'Wycombe Marsh, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP12', 51.625, -0.778, 'Booker, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP13', 51.633, -0.741, 'Downley, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP14', 51.649, -0.828, '');
INSERT INTO `uk_postcodes` VALUES ('HP15', 51.656, -0.712, 'Cryers Hill, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP16', 51.702, -0.717, 'Ballinger Common, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP17', 51.776, -0.87, 'Aston Sandford, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP18', 51.814, -0.982, 'Ashendon, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP19', 51.822, -0.825, 'Bourne End, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('HP2', 51.762, -0.452, 'Gaddesden Row, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('HP20', 51.819, -0.803, 'Aylesbury, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP21', 51.806, -0.805, 'Walton, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP22', 51.806, -0.766, 'Aston Abbotts, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP23', 51.795, -0.66, 'Aldbury, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('HP27', 51.719, -0.83, 'Askett, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP3', 51.737, -0.47, 'Apsley, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('HP4', 51.767, -0.567, 'Berkhamsted, Hertfordshire');
INSERT INTO `uk_postcodes` VALUES ('HP5', 51.712, -0.608, 'Ashley Green, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP6', 51.678, -0.598, 'Chesham Bois, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP7', 51.665, -0.608, 'Amersham, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP8', 51.642, -0.573, 'Chalfont St Giles, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HP9', 51.61, -0.639, 'Beaconsfield, Buckinghamshire');
INSERT INTO `uk_postcodes` VALUES ('HR1', 52.064, -2.669, 'Bartestree, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('HR2', 52.01, -2.783, 'Abbey Dore, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('HR3', 52.094, -3.075, 'Ailey, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('HR4', 52.088, -2.766, 'Birley, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('HR5', 52.192, -3.027, 'Bryngwyn, Powys');
INSERT INTO `uk_postcodes` VALUES ('HR6', 52.233, -2.771, 'Ashton, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('HR7', 52.186, -2.521, 'Bredenbury, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('HR8', 52.044, -2.444, 'Ashperton, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('HR9', 51.908, -2.582, 'Aston Crews, Hereford and Worcester');
INSERT INTO `uk_postcodes` VALUES ('HS1', 58.213, -6.381, 'Lacasdal, Western Isles');
INSERT INTO `uk_postcodes` VALUES ('HS2', 58.249, -6.468, 'Achadh Mor, Western Isles');
INSERT INTO `uk_postcodes` VALUES ('HS3', 57.879, -6.853, 'Abhainnsuidhe, Western Isles');
INSERT INTO `uk_postcodes` VALUES ('HS4', 57.87, -6.69, 'Kennavay, Western Isles');
INSERT INTO `uk_postcodes` VALUES ('HS5', 57.8, -6.961, 'An t-Ob, Western Isles');
INSERT INTO `uk_postcodes` VALUES ('HS6', 57.601, -7.299, 'Baile Glas, Western Isles');
INSERT INTO `uk_postcodes` VALUES ('HS7', 57.447, -7.34, 'Aird, Western Isles');
INSERT INTO `uk_postcodes` VALUES ('HS8', 57.233, -7.346, '');
INSERT INTO `uk_postcodes` VALUES ('HS9', 56.972, -7.472, 'Allathasdal, Western Isles');
INSERT INTO `uk_postcodes` VALUES ('HU1', 53.743, -0.335, 'Kingston upon Hull, Kingston upon Hull');
INSERT INTO `uk_postcodes` VALUES ('HU10', 53.752, -0.441, 'Anlaby, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU11', 53.826, -0.22, 'Aldbrough, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU12', 53.724, -0.13, 'Burstwick, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU13', 53.725, -0.435, 'Hessle, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU14', 53.728, -0.5, 'North Ferriby, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU15', 53.749, -0.622, 'Brantingham, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU16', 53.781, -0.419, 'Cottingham, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU17', 53.847, -0.427, 'Arram, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU18', 53.909, -0.167, 'Hornsea, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU19', 53.723, 0.036, 'Hollym, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU2', 53.75, -0.338, '');
INSERT INTO `uk_postcodes` VALUES ('HU20', 53.788, -0.513, 'Little Weighton, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU3', 53.742, -0.365, '');
INSERT INTO `uk_postcodes` VALUES ('HU4', 53.736, -0.4, '');
INSERT INTO `uk_postcodes` VALUES ('HU5', 53.76, -0.375, '');
INSERT INTO `uk_postcodes` VALUES ('HU6', 53.781, -0.369, 'Dunswell, E Riding of Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HU7', 53.789, -0.325, 'Stoneferry, Kingston upon Hull');
INSERT INTO `uk_postcodes` VALUES ('HU8', 53.769, -0.299, '');
INSERT INTO `uk_postcodes` VALUES ('HU9', 53.756, -0.286, 'Marfleet, Kingston upon Hull');
INSERT INTO `uk_postcodes` VALUES ('HX1', 53.721, -1.87, 'Halifax, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HX2', 53.738, -1.904, 'Holmfield, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HX3', 53.726, -1.844, 'Boothtown, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HX4', 53.679, -1.88, 'Barkisland, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HX5', 53.686, -1.835, 'Elland, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HX6', 53.698, -1.924, 'Booth Wood, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('HX7', 53.739, -2.007, 'Blackshaw Head, West Yorkshire');
INSERT INTO `uk_postcodes` VALUES ('IG1', 51.559, 0.075, 'Ilford, Greater London');
INSERT INTO `uk_postcodes` VALUES ('IG10', 51.648, 0.066, 'High Beach, Essex');
INSERT INTO `uk_postcodes` VALUES ('IG11', 51.535, 0.094, 'Barking, Greater London');
INSERT INTO `uk_postcodes` VALUES ('IG2', 51.574, 0.082, 'Fairlop Waters, Greater London');
INSERT INTO `uk_postcodes` VALUES ('IG3', 51.562, 0.101, 'Seven Kings, Greater London');
INSERT INTO `uk_postcodes` VALUES ('IG4', 51.577, 0.055, '');
INSERT INTO `uk_postcodes` VALUES ('IG5', 51.588, 0.066, '');
INSERT INTO `uk_postcodes` VALUES ('IG6', 51.593, 0.089, 'Barkingside, Greater London');
INSERT INTO `uk_postcodes` VALUES ('IG7', 51.613, 0.089, 'Chigwell Row, Essex');
INSERT INTO `uk_postcodes` VALUES ('IG8', 51.607, 0.034, 'Woodford Bridge, Greater London');
INSERT INTO `uk_postcodes` VALUES ('IG9', 51.623, 0.04, 'Buckhurst Hill, Essex');
INSERT INTO `uk_postcodes` VALUES ('IP1', 52.067, 1.142, 'Akenham, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP10', 52.019, 1.27, 'Brightwell, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP11', 51.97, 1.334, 'Felixstowe, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP12', 52.092, 1.373, 'Alderton, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP13', 52.185, 1.321, 'Badingham, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP14', 52.206, 1.035, 'Ashfield, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP15', 52.157, 1.597, 'Aldeburgh, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP16', 52.204, 1.586, 'Aldringham, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP17', 52.23, 1.503, 'Carlton, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP18', 52.33, 1.673, 'Blackwater, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP19', 52.34, 1.495, 'All Saints South Elmham, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP2', 52.045, 1.136, 'Chantry, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP20', 52.406, 1.321, 'Alburgh, Norfolk');
INSERT INTO `uk_postcodes` VALUES ('IP21', 52.364, 1.236, 'Ashfield Green, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP22', 52.376, 1.053, 'Blo Norton, Norfolk');
INSERT INTO `uk_postcodes` VALUES ('IP23', 52.307, 1.125, 'Bedingfield, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP24', 52.419, 0.759, 'Barnham, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP25', 52.586, 0.84, 'Ashill, Norfolk');
INSERT INTO `uk_postcodes` VALUES ('IP26', 52.508, 0.577, 'Bodney, Norfolk');
INSERT INTO `uk_postcodes` VALUES ('IP27', 52.43, 0.586, 'Brandon, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP28', 52.326, 0.549, 'Barton Mills, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP29', 52.193, 0.663, 'Barrow, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP3', 52.041, 1.188, '');
INSERT INTO `uk_postcodes` VALUES ('IP30', 52.209, 0.837, 'Beyton Green, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP31', 52.291, 0.828, 'Ampton, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP32', 52.254, 0.717, '');
INSERT INTO `uk_postcodes` VALUES ('IP33', 52.242, 0.708, 'Bury St Edmunds, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP4', 52.06, 1.181, '');
INSERT INTO `uk_postcodes` VALUES ('IP5', 52.061, 1.242, 'Kesgrave, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP6', 52.131, 1.116, 'Ashbocking, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP7', 52.068, 0.95, 'Aldham, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP8', 52.062, 1.083, 'Belstead, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IP9', 51.99, 1.149, 'Bentley, Suffolk');
INSERT INTO `uk_postcodes` VALUES ('IV1', 57.487, -4.231, 'Abersky, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV10', 57.585, -4.126, 'Balmungie, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV11', 57.677, -4.038, 'Craighead, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV12', 57.574, -3.864, 'Achindown, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV13', 57.343, -4.013, 'Balvraid, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV14', 57.586, -4.547, 'Auchterneed, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV15', 57.599, -4.43, 'Dingwall, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV16', 57.665, -4.337, 'Ardullie, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV17', 57.7, -4.26, 'Achandunie, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV18', 57.702, -4.155, 'Achnagarron, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV19', 57.805, -4.061, 'Aldie, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV2', 57.468, -4.19, 'Culcabock, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV20', 57.786, -3.907, 'Balaldie, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV21', 57.724, -5.72, 'Auchtercairn, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV22', 57.742, -5.506, 'Achgarve, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV23', 57.773, -5.01, 'Ardcharnich, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV24', 57.891, -4.355, 'Achnahanat, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV25', 57.891, -4.042, 'Achosnich, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV26', 57.916, -5.173, 'Achiltibuie, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV27', 58.277, -4.8, 'Achany, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV28', 58.015, -4.157, 'Ardochu, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV3', 57.477, -4.245, 'Abriachan, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV30', 57.654, -3.327, 'Altonside, Moray');
INSERT INTO `uk_postcodes` VALUES ('IV31', 57.717, -3.289, 'Branderburgh, Moray');
INSERT INTO `uk_postcodes` VALUES ('IV32', 57.632, -3.11, 'Auchenhalrig, Moray');
INSERT INTO `uk_postcodes` VALUES ('IV36', 57.611, -3.604, 'Ardoch, Moray');
INSERT INTO `uk_postcodes` VALUES ('IV4', 57.448, -4.533, 'Ardnagrask, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV40', 57.275, -5.65, 'Allt-na-subh, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV41', 57.274, -5.735, 'Kyleakin, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV42', 57.239, -5.829, 'Breakish, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV43', 57.156, -5.81, 'Camus Croise, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV44', 57.115, -5.874, 'Kilbeg, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV45', 57.067, -5.906, 'Aird of Sleat, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV46', 57.114, -5.984, 'Achnacloich, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV47', 57.294, -6.344, 'Bualintur, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV48', 57.311, -6.098, 'Sconser, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV49', 57.228, -5.946, 'Blackhill, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV5', 57.468, -4.411, 'Achnagairn, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV51', 57.481, -6.246, 'Balgown, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV52', 57.337, -5.651, 'Plockton, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV53', 57.344, -5.554, 'Achmore, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV54', 57.431, -5.616, 'Achintee, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV55', 57.459, -6.611, 'Balmore, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV56', 57.366, -6.429, 'Bracadale, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV6', 57.526, -4.458, 'Balvaird, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV63', 57.323, -4.505, 'Balvaird, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV7', 57.584, -4.384, 'Alcaig, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV8', 57.554, -4.265, 'Belmaduthy, Highland');
INSERT INTO `uk_postcodes` VALUES ('IV9', 57.569, -4.177, 'Avoch, Highland');
INSERT INTO `uk_postcodes` VALUES ('KA1', 55.596, -4.496, 'Adamhill, South Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA10', 55.549, -4.648, 'Barassie, South Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA11', 55.618, -4.626, 'Dreghorn, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA12', 55.619, -4.664, 'Irvine, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA13', 55.655, -4.699, 'Auchentiber, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA14', 55.74, -4.671, 'Glengarnock, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA15', 55.748, -4.625, 'Barrmill, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA16', 55.607, -4.33, 'Greenholm, East Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA17', 55.611, -4.282, 'Darvel, East Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA18', 55.451, -4.239, 'Afton Bridgend, East Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA19', 55.346, -4.667, 'Blairquhan, South Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA2', 55.596, -4.563, 'Crosshouse, East Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA20', 55.641, -4.751, 'Stevenston, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA21', 55.641, -4.783, 'Saltcoats, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA22', 55.65, -4.807, 'Ardrossan, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA23', 55.691, -4.855, 'Crosbie, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA24', 55.71, -4.715, 'Blairpark, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA25', 55.753, -4.688, 'Kilbirnie, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA26', 55.219, -4.834, 'Aldons, South Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA27', 55.539, -5.172, 'Balliekine, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA28', 55.755, -4.924, 'Ballochmartin, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA29', 55.757, -4.853, 'Fairlie, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA3', 55.644, -4.495, 'Cunninghamhead, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA30', 55.797, -4.862, 'Largs, North Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA4', 55.599, -4.382, 'Galston, East Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA5', 55.51, -4.386, 'Ballochmyle, East Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA6', 55.415, -4.505, 'Annbank, South Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA7', 55.448, -4.628, 'Alloway, South Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA8', 55.472, -4.612, 'New Prestwick, South Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KA9', 55.497, -4.604, 'Monkton, South Ayrshire');
INSERT INTO `uk_postcodes` VALUES ('KT1', 51.407, -0.297, 'Kingston upon Thames, Greater London');
INSERT INTO `uk_postcodes` VALUES ('KT10', 51.368, -0.354, 'Claygate, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT11', 51.328, -0.402, 'Cobham, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT12', 51.377, -0.407, 'Hersham, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT13', 51.368, -0.449, 'Weybridge, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT14', 51.339, -0.486, 'Byfleet, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT15', 51.363, -0.494, 'Addlestone, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT16', 51.383, -0.514, 'Chertsey, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT17', 51.341, -0.248, 'Epsom, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT18', 51.317, -0.262, 'Headley, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT19', 51.351, -0.267, 'Kingston upon Thames, Greater London');
INSERT INTO `uk_postcodes` VALUES ('KT2', 51.416, -0.289, 'Norbiton, Greater London');
INSERT INTO `uk_postcodes` VALUES ('KT20', 51.286, -0.23, 'Burgh Heath, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT21', 51.311, -0.301, 'Ashtead, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT22', 51.301, -0.337, 'Givons Grove, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT23', 51.281, -0.37, 'Fetcham, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT24', 51.269, -0.429, 'East Horsley, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT3', 51.399, -0.256, 'New Malden, Greater London');
INSERT INTO `uk_postcodes` VALUES ('KT4', 51.378, -0.242, 'Malden, Greater London');
INSERT INTO `uk_postcodes` VALUES ('KT5', 51.392, -0.286, '');
INSERT INTO `uk_postcodes` VALUES ('KT6', 51.389, -0.299, 'Surbiton, Greater London');
INSERT INTO `uk_postcodes` VALUES ('KT7', 51.389, -0.328, 'Thames Ditton, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT8', 51.401, -0.363, 'East Molesey, Surrey');
INSERT INTO `uk_postcodes` VALUES ('KT9', 51.364, -0.301, 'Chessington, Greater London');
INSERT INTO `uk_postcodes` VALUES ('KW1', 58.458, -3.121, 'Ackergill, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW10', 57.975, -3.975, 'Aberscross, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW11', 58.305, -4.13, 'Achargary, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW12', 58.506, -3.491, 'Achies, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW13', 58.455, -3.895, 'Achiemore, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW14', 58.589, -3.556, 'Achina, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW15', 58.981, -2.959, 'Berstane, Orkney Islands');
INSERT INTO `uk_postcodes` VALUES ('KW16', 58.96, -3.274, 'Aith, Orkney Islands');
INSERT INTO `uk_postcodes` VALUES ('KW17', 59.042, -3.003, 'Abune-the-Hill, Orkney Islands');
INSERT INTO `uk_postcodes` VALUES ('KW2', 58.349, -3.163, 'Bruan, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW3', 58.308, -3.279, 'Blackness, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW5', 58.287, -3.382, 'Achavanich, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW6', 58.249, -3.442, 'Achnaclyth, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW7', 58.187, -3.5, 'Badbea, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW8', 58.116, -3.664, 'Craggie, Highland');
INSERT INTO `uk_postcodes` VALUES ('KW9', 58.014, -3.858, 'Achrimsdale, Highland');
INSERT INTO `uk_postcodes` VALUES ('KY1', 56.128, -3.137, 'Coaltown of Wemyss, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY10', 56.231, -2.7, 'Abercrombie, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY11', 56.047, -3.415, 'Charlestown, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY12', 56.077, -3.492, 'Balgonar, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY13', 56.208, -3.432, 'Arlary, Perth and Kinross');
INSERT INTO `uk_postcodes` VALUES ('KY14', 56.31, -3.239, 'Auchtermuchty, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY15', 56.3, -3.051, 'Baldinnie, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY16', 56.342, -2.819, 'Balmullo, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY2', 56.123, -3.182, 'Auchtertool, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY3', 56.064, -3.23, 'Aberdour, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY4', 56.115, -3.361, 'Cowdenbeath, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY5', 56.145, -3.294, 'Auchterderran, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY6', 56.197, -3.197, 'Auchmuirbridge, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY7', 56.197, -3.154, 'Balbirnie, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY8', 56.197, -3.011, 'Backmuir of New Gilston, Fife');
INSERT INTO `uk_postcodes` VALUES ('KY9', 56.21, -2.833, 'Colinsburgh, Fife');
INSERT INTO `uk_postcodes` VALUES ('L1', 53.402, -2.979, '');
INSERT INTO `uk_postcodes` VALUES ('L10', 53.474, -2.926, 'Aintree, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L11', 53.448, -2.914, '');
INSERT INTO `uk_postcodes` VALUES ('L12', 53.435, -2.895, 'West Derby, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L13', 53.417, -2.919, '');
INSERT INTO `uk_postcodes` VALUES ('L14', 53.418, -2.879, 'Knotty Ash, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L15', 53.397, -2.919, '');
INSERT INTO `uk_postcodes` VALUES ('L16', 53.398, -2.887, 'Childwall, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L17', 53.378, -2.94, 'Aigburth, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L18', 53.38, -2.907, 'Allerton, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L19', 53.359, -2.902, 'Garston, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L2', 53.407, -2.989, '');
INSERT INTO `uk_postcodes` VALUES ('L20', 53.452, -2.988, 'Bootle, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L21', 53.471, -2.999, 'Litherland, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L22', 53.477, -3.026, 'Seaforth, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L23', 53.491, -3.022, 'Crosby, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L24', 53.343, -2.836, 'Speke, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L25', 53.378, -2.862, 'Gateacre, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L26', 53.364, -2.832, 'Halewood, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L27', 53.388, -2.837, '');
INSERT INTO `uk_postcodes` VALUES ('L28', 53.435, -2.864, '');
INSERT INTO `uk_postcodes` VALUES ('L29', 53.507, -2.983, 'Lunt, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L3', 53.409, -2.983, 'Liverpool, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L30', 53.484, -2.971, 'Ford, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L31', 53.513, -2.937, 'Lydiate, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L32', 53.478, -2.888, 'Kirkby, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L33', 53.489, -2.875, '');
INSERT INTO `uk_postcodes` VALUES ('L34', 53.437, -2.815, 'Knowsley, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L35', 53.415, -2.782, 'Rainhill Stoops, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L36', 53.414, -2.84, 'Huyton, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L37', 53.557, -3.062, 'Formby, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L38', 53.524, -3.05, 'Hightown, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('L39', 53.562, -2.896, 'Aughton Park, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('L4', 53.438, -2.96, '');
INSERT INTO `uk_postcodes` VALUES ('L40', 53.602, -2.841, 'Bescar, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('L5', 53.425, -2.975, '');
INSERT INTO `uk_postcodes` VALUES ('L6', 53.419, -2.95, '');
INSERT INTO `uk_postcodes` VALUES ('L69', 53.407, -2.974, '');
INSERT INTO `uk_postcodes` VALUES ('L7', 53.406, -2.948, '');
INSERT INTO `uk_postcodes` VALUES ('L70', 53.409, -2.97, '');
INSERT INTO `uk_postcodes` VALUES ('L8', 53.39, -2.962, '');
INSERT INTO `uk_postcodes` VALUES ('L9', 53.461, -2.952, 'Walton, Merseyside');
INSERT INTO `uk_postcodes` VALUES ('LA1', 54.046, -2.799, 'Lancaster, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('LA10', 54.314, -2.493, 'Cautley, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA11', 54.2, -2.924, 'Allithwaite, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA12', 54.203, -3.082, 'Aldingham, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA13', 54.118, -3.198, 'Dendron, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA14', 54.118, -3.23, 'Barrow-in-Furness, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA15', 54.156, -3.178, 'Dalton-in-Furness, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA16', 54.186, -3.202, 'Askam in Furness, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA17', 54.239, -3.175, 'Beck Side, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA18', 54.215, -3.275, 'Broadgate, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA19', 54.293, -3.375, 'Annaside, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA2', 54.066, -2.673, 'Abbeystead, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('LA20', 54.294, -3.205, 'Bank End, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA21', 54.364, -3.072, 'Bowmanstead, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA22', 54.422, -2.987, 'Ambleside, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA23', 54.371, -2.911, 'Bowness-on-Windermere, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA3', 54.051, -2.877, 'Heaton, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('LA4', 54.07, -2.852, 'Morecambe, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('LA5', 54.143, -2.79, 'Arnside, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA6', 54.176, -2.611, 'Arkholme, Lancashire');
INSERT INTO `uk_postcodes` VALUES ('LA7', 54.226, -2.772, 'Beetham, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA8', 54.323, -2.759, 'Beck Foot, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LA9', 54.325, -2.742, 'Burneside, Cumbria');
INSERT INTO `uk_postcodes` VALUES ('LD1', 52.261, -3.365, 'Abbeycwmhir, Powys');
INSERT INTO `uk_postcodes` VALUES ('LD2', 52.141, -3.393, 'Aberduhonw, Powys');
INSERT INTO `uk_postcodes` VALUES ('LD3', 51.96, -3.371, 'Abercynafon, Powys');
INSERT INTO `uk_postcodes` VALUES ('LD4', 52.118, -3.555, 'Cefn-gorwydd, Powys');
INSERT INTO `uk_postcodes` VALUES ('LD5', 52.127, -3.616, 'Abergwesyn, Powys');
INSERT INTO `uk_postcodes` VALUES ('LD6', 52.309, -3.508, 'Bwlch-y-sarnau, Powys');
INSERT INTO `uk_postcodes` VALUES ('LD7', 52.352, -3.085, 'Beguildy, Powys');
INSERT INTO `uk_postcodes` VALUES ('LD8', 52.268, -3.043, 'Burlingjobb, Powys');
INSERT INTO `uk_postcodes` VALUES ('LE1', 52.634, -1.128, 'Leicester, Leicester');
INSERT INTO `uk_postcodes` VALUES ('LE10', 52.537, -1.368, 'Aston Flamville, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE11', 52.769, -1.216, 'Loughborough, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE12', 52.766, -1.192, 'Barrow upon Soar, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE13', 52.765, -0.885, 'Melton Mowbray, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE14', 52.784, -0.895, 'Ab Kettleby, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE15', 52.656, -0.701, 'Allexton, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE16', 52.486, -0.892, 'Arthingworth, Northamptonshire');
INSERT INTO `uk_postcodes` VALUES ('LE17', 52.467, -1.177, 'Ashby Magna, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE18', 52.583, -1.111, 'Kilby, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE2', 52.609, -1.115, 'Aylestone, Leicester');
INSERT INTO `uk_postcodes` VALUES ('LE3', 52.628, -1.181, 'Braunstone, Leicester');
INSERT INTO `uk_postcodes` VALUES ('LE4', 52.663, -1.123, 'Belgrave, Leicester');
INSERT INTO `uk_postcodes` VALUES ('LE5', 52.636, -1.086, 'Humberstone, Leicester');
INSERT INTO `uk_postcodes` VALUES ('LE6', 52.663, -1.242, 'Groby, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE65', 52.748, -1.468, 'Ashby de la Zouch, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE67', 52.716, -1.36, 'Bagworth, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE7', 52.678, -1.068, 'Anstey, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE8', 52.553, -1.098, 'Arnesby, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LE9', 52.57, -1.287, 'Barwell, Leicestershire');
INSERT INTO `uk_postcodes` VALUES ('LL11', 53.063, -3.035, 'Brymbo, Wrexham');
INSERT INTO `uk_postcodes` VALUES ('LL12', 53.086, -2.988, 'Burton Green, Wrexham');
INSERT INTO `uk_postcodes` VALUES ('LL13', 53.036, -2.96, 'Bangor-is-y-coed, Wrexham');
INSERT INTO `uk_postcodes` VALUES ('LL14', 52.992, -3.051, 'Acrefair, Wrexham');
INSERT INTO `uk_postcodes` VALUES ('LL15', 53.103, -3.315, 'Bontuchel, Denbighshire');
INSERT INTO `uk_postcodes` VALUES ('LL16', 53.185, -3.432, 'Bodfari, Denbighshire');
INSERT INTO `uk_postcodes` VALUES ('LL17', 53.253, -3.435, 'Graig, Denbighshire');
INSERT INTO `uk_postcodes` VALUES ('LL18', 53.31, -3.475, 'Bodelwyddan, Denbighshire');
INSERT INTO `uk_postcodes` VALUES ('LL19', 53.331, -3.408, 'Gronant, Flintshire');
INSERT INTO `uk_postcodes` VALUES ('LL20', 52.959, -3.159, 'Dolywern, Wrexham');
INSERT INTO `uk_postcodes` VALUES ('LL21', 52.99, -3.409, 'Bethel, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL22', 53.269, -3.593, 'Abergele, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL23', 52.905, -3.6, 'Bala, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL24', 53.057, -3.785, 'Betws-y-coed, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL25', 53.054, -3.878, 'Blaenau Dolwyddelan, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL26', 53.139, -3.785, 'Capel Garmon, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL27', 53.147, -3.824, 'Trefriw, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL28', 53.288, -3.76, 'Bryn-y-maen, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL29', 53.289, -3.708, 'Colwyn Bay, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL30', 53.318, -3.815, 'Gogarth, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL31', 53.291, -3.81, 'Deganwy, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL32', 53.26, -3.839, 'Caerhun, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL33', 53.25, -3.98, 'Abergwyngregyn, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL34', 53.271, -3.912, 'Capelulo, Conwy');
INSERT INTO `uk_postcodes` VALUES ('LL35', 52.547, -4.041, 'Aberdyfi, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL36', 52.604, -4.063, 'Abergynolwyn, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL37', 52.666, -4.083, 'Llwyngwril, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL38', 52.698, -4.039, 'Fairbourne, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL39', 52.711, -4.011, 'Arthog, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL40', 52.756, -3.875, 'Abergwynant, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL41', 52.969, -3.938, 'Bethania, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL42', 52.725, -4.054, 'Barmouth, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL43', 52.774, -4.092, 'Tal-y-bont, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL44', 52.791, -4.096, 'Coed Ystumgwern, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL45', 52.82, -4.095, 'Llanbedr, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL46', 52.854, -4.106, 'Eisingrug, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL47', 52.902, -4.062, 'Talsarnau, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL48', 52.936, -4.07, 'Cae Ddafydd, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL49', 52.929, -4.138, 'Borth-y-Gest, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL51', 52.974, -4.238, 'Bryncir, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL52', 52.925, -4.24, 'Criccieth, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL53', 52.884, -4.491, 'Aber, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL54', 53.059, -4.285, 'Aberdesach, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL55', 53.134, -4.204, 'Beddgelert, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL56', 53.187, -4.199, 'Y Felinheli, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL57', 53.207, -4.111, 'Bangor, Gwynedd');
INSERT INTO `uk_postcodes` VALUES ('LL58', 53.28, -4.099, 'Beaumaris, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL59', 53.235, -4.159, 'Llandegfan, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL60', 53.215, -4.27, 'Gaerwen, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL61', 53.195, -4.262, 'Brynsiencyn, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL62', 53.21, -4.385, 'Aberffraw, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL63', 53.219, -4.471, '');
INSERT INTO `uk_postcodes` VALUES ('LL64', 53.228, -4.517, 'Llanfaelog, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL65', 53.301, -4.569, 'Bodedern, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL66', 53.381, -4.405, 'Rhosgoch, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL67', 53.411, -4.456, 'Cemaes, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL68', 53.398, -4.377, 'Amlwch Port, Isle of Anglesey');
INSERT INTO `uk_postcodes` VALUES ('LL69', 53.386, -4.318, 'Penysarn, Isle of Anglesey');
INSERT INTO `uk