Difference between revisions of "Template:Database"
From Wikishire
| Line 18: | Line 18: | ||
|type=county | |type=county | ||
|county town=Beaumaris | |county town=Beaumaris | ||
| − | |area= | + | |area=277 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 111: | Line 111: | ||
|type=county | |type=county | ||
|county town=Bedford | |county town=Bedford | ||
| − | |area= | + | |area=468 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 150: | Line 150: | ||
|type=county | |type=county | ||
|county town=Brecon | |county town=Brecon | ||
| − | |area= | + | |area=742 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 163: | Line 163: | ||
|type=county | |type=county | ||
|county town=Aylesbury | |county town=Aylesbury | ||
| − | |area= | + | |area=746 |
|flag=Flag of Buckinghamshire.svg | |flag=Flag of Buckinghamshire.svg | ||
|badge=Buckinghamshire Swan Badge.svg | |badge=Buckinghamshire Swan Badge.svg | ||
| Line 189: | Line 189: | ||
|type=county | |type=county | ||
|county town=Caernarfonshire | |county town=Caernarfonshire | ||
| − | |area= | + | |area=563 |
|flag=Flag of Caernarfonshire.png | |flag=Flag of Caernarfonshire.png | ||
|badge=Flag of Caernarfonshire.png | |badge=Flag of Caernarfonshire.png | ||
| Line 215: | Line 215: | ||
|type=county | |type=county | ||
|county town=Cambridgeshire | |county town=Cambridgeshire | ||
| − | |area= | + | |area=858 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 228: | Line 228: | ||
|type=county | |type=county | ||
|county town=Cardigan | |county town=Cardigan | ||
| − | |area= | + | |area=693 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 241: | Line 241: | ||
|type=county | |type=county | ||
|county town=Carmarthen | |county town=Carmarthen | ||
| − | |area= | + | |area=937 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 254: | Line 254: | ||
|type=county | |type=county | ||
|county town=Chester | |county town=Chester | ||
| − | |area= | + | |area=1035 |
|flag=Cheshire Flag.svg | |flag=Cheshire Flag.svg | ||
|badge=Azure, a garb Or.svg | |badge=Azure, a garb Or.svg | ||
| Line 280: | Line 280: | ||
|type=county | |type=county | ||
|county town=Bodmin or Truro | |county town=Bodmin or Truro | ||
| − | |area= | + | |area=1365 |
|flag=Flag of Cornwall.svg | |flag=Flag of Cornwall.svg | ||
|badge=Arms of the Duchy of Cornwall (Variant 1).svg | |badge=Arms of the Duchy of Cornwall (Variant 1).svg | ||
| Line 305: | Line 305: | ||
|Welsh=Cumberland | |Welsh=Cumberland | ||
|type=county | |type=county | ||
| − | |county town= | + | |county town=Carlisle |
| − | |area= | + | |area=1525 |
|flag=Cumberland flag.svg | |flag=Cumberland flag.svg | ||
|badge=Cumberland flag.svg | |badge=Cumberland flag.svg | ||
| Line 319: | Line 319: | ||
|type=county | |type=county | ||
|county town=Denbigh | |county town=Denbigh | ||
| − | |area= | + | |area=668 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 332: | Line 332: | ||
|type=county | |type=county | ||
|county town=Derby | |county town=Derby | ||
| − | |area= | + | |area=1017 |
|flag=Derbyshire flag.svg | |flag=Derbyshire flag.svg | ||
|badge=Derbyshire flag.svg | |badge=Derbyshire flag.svg | ||
| Line 345: | Line 345: | ||
|type=county | |type=county | ||
|county town=Exeter | |county town=Exeter | ||
| − | |area= | + | |area=2621 |
|flag=Flag of Devon.svg | |flag=Flag of Devon.svg | ||
|badge=Flag of Devon.svg | |badge=Flag of Devon.svg | ||
| Line 358: | Line 358: | ||
|type=county | |type=county | ||
|county town=Dorchester | |county town=Dorchester | ||
| − | |area= | + | |area=1005 |
|flag=FlagOfDorset.svg | |flag=FlagOfDorset.svg | ||
|badge=FlagOfDorset.svg | |badge=FlagOfDorset.svg | ||
| Line 412: | Line 412: | ||
|type=county | |type=county | ||
|county town=Durham | |county town=Durham | ||
| − | |area= | + | |area=1022 |
|flag=County Durham Flag.svg | |flag=County Durham Flag.svg | ||
|badge=County Durham Flag.svg | |badge=County Durham Flag.svg | ||
| Line 438: | Line 438: | ||
|type=county | |type=county | ||
|county town=Chelmsford | |county town=Chelmsford | ||
| − | |area= | + | |area=1591 |
|flag=Flag of Essex.svg | |flag=Flag of Essex.svg | ||
|badge=Arms of Essex.svg | |badge=Arms of Essex.svg | ||
| Line 477: | Line 477: | ||
|type=county | |type=county | ||
|county town=Flint | |county town=Flint | ||
| − | |area= | + | |area=260 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 490: | Line 490: | ||
|type=county | |type=county | ||
|county town=Cardiff | |county town=Cardiff | ||
| − | |area= | + | |area=827 |
|flag=Glamorgan Flag.svg | |flag=Glamorgan Flag.svg | ||
|badge=Iestyn & De Clare - Glamorgan shields.svg | |badge=Iestyn & De Clare - Glamorgan shields.svg | ||
| Line 503: | Line 503: | ||
|type=county | |type=county | ||
|county town=Gloucester | |county town=Gloucester | ||
| − | |area= | + | |area=1293 |
|flag=Severn Cross.svg | |flag=Severn Cross.svg | ||
|badge=Severn Cross.svg | |badge=Severn Cross.svg | ||
| Line 516: | Line 516: | ||
|type=county | |type=county | ||
|county town=Winchester | |county town=Winchester | ||
| − | |area= | + | |area=1656 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 529: | Line 529: | ||
|type=county | |type=county | ||
|county town=Hereford | |county town=Hereford | ||
| − | |area= | + | |area=837 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 542: | Line 542: | ||
|type=county | |type=county | ||
|county town=Hertford | |county town=Hertford | ||
| − | |area= | + | |area=633 |
|flag=County Flag of Hertfordshire.svg | |flag=County Flag of Hertfordshire.svg | ||
|badge=Hertford shield.svg | |badge=Hertford shield.svg | ||
| Line 555: | Line 555: | ||
|type=county | |type=county | ||
|county town=Huntingdon | |county town=Huntingdon | ||
| − | |area= | + | |area=366 |
|flag=FlagOfHuntingdonshire.PNG | |flag=FlagOfHuntingdonshire.PNG | ||
|badge=FlagOfHuntingdonshire.PNG | |badge=FlagOfHuntingdonshire.PNG | ||
| Line 581: | Line 581: | ||
|type=county | |type=county | ||
|county town=Maidstone or Canterbury | |county town=Maidstone or Canterbury | ||
| − | |area= | + | |area=1611 |
|flag=Flag of Kent.svg | |flag=Flag of Kent.svg | ||
|badge=Red Kentish Horse.svg | |badge=Red Kentish Horse.svg | ||
| Line 646: | Line 646: | ||
|type=county | |type=county | ||
|county town=Lancaster | |county town=Lancaster | ||
| − | |area= | + | |area=1909 |
|flag=FlagOfLancashire.svg | |flag=FlagOfLancashire.svg | ||
|badge=Lancashire rose.svg | |badge=Lancashire rose.svg | ||
| Line 659: | Line 659: | ||
|type=county | |type=county | ||
|county town=Leicester | |county town=Leicester | ||
| − | |area= | + | |area=836 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 672: | Line 672: | ||
|type=county | |type=county | ||
|county town=Lincoln | |county town=Lincoln | ||
| − | |area= | + | |area=2687 |
|flag=Lincolnshire flag.svg | |flag=Lincolnshire flag.svg | ||
|badge=Lincolnshire flag.svg | |badge=Lincolnshire flag.svg | ||
| Line 699: | Line 699: | ||
|type=county | |type=county | ||
|county town=Harlech | |county town=Harlech | ||
| − | |area= | + | |area=676 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 738: | Line 738: | ||
|type=county | |type=county | ||
|county town=Monmouth | |county town=Monmouth | ||
| − | |area= | + | |area=542 |
|flag=Flag of Monmouthshire.svg | |flag=Flag of Monmouthshire.svg | ||
|badge=Flag of Monmouthshire.svg | |badge=Flag of Monmouthshire.svg | ||
| Line 751: | Line 751: | ||
|type=county | |type=county | ||
|county town=Montgomery | |county town=Montgomery | ||
| − | |area= | + | |area=796 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 790: | Line 790: | ||
|type=county | |type=county | ||
|county town=Norwich | |county town=Norwich | ||
| − | |area= | + | |area=2057 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 803: | Line 803: | ||
|type=county | |type=county | ||
|county town=Northampton | |county town=Northampton | ||
| − | |area= | + | |area=998 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 816: | Line 816: | ||
|type=county | |type=county | ||
|county town=Alnwick | |county town=Alnwick | ||
| − | |area= | + | |area=2019 |
|flag=Flag of Northumberland.svg | |flag=Flag of Northumberland.svg | ||
|badge=Flag of Northumberland.svg | |badge=Flag of Northumberland.svg | ||
| Line 829: | Line 829: | ||
|type=county | |type=county | ||
|county town=Nottingham | |county town=Nottingham | ||
| − | |area= | + | |area=843 |
|flag=County Flag of Nottinghamshire.svg | |flag=County Flag of Nottinghamshire.svg | ||
|badge=Nottinghamshire - Robin Hood.svg | |badge=Nottinghamshire - Robin Hood.svg | ||
| Line 855: | Line 855: | ||
|type=county | |type=county | ||
|county town=Oxford | |county town=Oxford | ||
| − | |area= | + | |area=754 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 881: | Line 881: | ||
|type=county | |type=county | ||
|county town=Pembroke | |county town=Pembroke | ||
| − | |area= | + | |area=625 |
|flag=Flag of Pembrokeshire.svg | |flag=Flag of Pembrokeshire.svg | ||
|badge=Flag of Pembrokeshire.svg | |badge=Flag of Pembrokeshire.svg | ||
| Line 907: | Line 907: | ||
|type=county | |type=county | ||
|county town=New Radnor | |county town=New Radnor | ||
| − | |area= | + | |area=470 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 998: | Line 998: | ||
|type=county | |type=county | ||
|county town=Shrewsbury | |county town=Shrewsbury | ||
| − | |area= | + | |area=1342 |
|flag=Flag of Shropshire.svg | |flag=Flag of Shropshire.svg | ||
|badge=Salop roundel.svg | |badge=Salop roundel.svg | ||
| Line 1,011: | Line 1,011: | ||
|type=county | |type=county | ||
|county town=Taunton | |county town=Taunton | ||
| − | |area= | + | |area=1633 |
|flag=Somerset Flag.svg | |flag=Somerset Flag.svg | ||
|badge=Somerset dragon.svg | |badge=Somerset dragon.svg | ||
| Line 1,024: | Line 1,024: | ||
|type=county | |type=county | ||
|county town=Stafford | |county town=Stafford | ||
| − | |area= | + | |area=1176 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 1,050: | Line 1,050: | ||
|type=county | |type=county | ||
|county town=Ipswich | |county town=Ipswich | ||
| − | |area= | + | |area=1505 |
|flag= | |flag= | ||
|badge=Suffolk St Edmund shield.svg | |badge=Suffolk St Edmund shield.svg | ||
| Line 1,063: | Line 1,063: | ||
|type=county | |type=county | ||
|county town=Guildford | |county town=Guildford | ||
| − | |area= | + | |area=759 |
|flag= | |flag= | ||
|badge=De Warrenne Surrey Arms.svg | |badge=De Warrenne Surrey Arms.svg | ||
| Line 1,076: | Line 1,076: | ||
|type=county | |type=county | ||
|county town=Chichester | |county town=Chichester | ||
| − | |area= | + | |area=1466 |
|flag=Flag of Sussex.svg | |flag=Flag of Sussex.svg | ||
|badge=Sussex shield.svg | |badge=Sussex shield.svg | ||
| Line 1,115: | Line 1,115: | ||
|type=county | |type=county | ||
|county town=Warwick | |county town=Warwick | ||
| − | |area= | + | |area=918 |
|flag= | |flag= | ||
|badge= | |badge= | ||
| Line 1,141: | Line 1,141: | ||
|type=county | |type=county | ||
|county town=Appleby in Westmorland | |county town=Appleby in Westmorland | ||
| − | |area= | + | |area=785 |
|flag=FlagOfWestmorland.png | |flag=FlagOfWestmorland.png | ||
|badge=FlagOfWestmorland.png | |badge=FlagOfWestmorland.png | ||
| Line 1,167: | Line 1,167: | ||
|type=county | |type=county | ||
|county town=Salisbury | |county town=Salisbury | ||
| − | |area= | + | |area=1374 |
|flag=County Flag of Wiltshire.svg | |flag=County Flag of Wiltshire.svg | ||
|badge=County Flag of Wiltshire.svg | |badge=County Flag of Wiltshire.svg | ||
| Line 1,180: | Line 1,180: | ||
|type=county | |type=county | ||
|county town=Worcester | |county town=Worcester | ||
| − | |area= | + | |area=709 |
|flag=Flag of Worcestershire.svg | |flag=Flag of Worcestershire.svg | ||
|badge=Black pear icon.svg | |badge=Black pear icon.svg | ||
| Line 1,193: | Line 1,193: | ||
|type=county | |type=county | ||
|county town=York | |county town=York | ||
| − | |area= | + | |area=6081 |
|flag=FlagOfYorkshire.svg | |flag=FlagOfYorkshire.svg | ||
|badge=Yorkshire rose.svg | |badge=Yorkshire rose.svg | ||
| Line 1,205: | Line 1,205: | ||
|Welsh= | |Welsh= | ||
|type=riding | |type=riding | ||
| − | |area= | + | |area=1173 |
|badge=Yorkshire rose.svg | |badge=Yorkshire rose.svg | ||
|Chapman code=ERY | |Chapman code=ERY | ||
| Line 1,216: | Line 1,216: | ||
|Welsh= | |Welsh= | ||
|type=riding | |type=riding | ||
| − | |area= | + | |area=2127 |
|badge=Yorkshire rose.svg | |badge=Yorkshire rose.svg | ||
|Chapman code=NRY | |Chapman code=NRY | ||
| Line 1,227: | Line 1,227: | ||
|Welsh= | |Welsh= | ||
|type=riding | |type=riding | ||
| − | |area= | + | |area=2763 |
|badge=Yorkshire rose.svg | |badge=Yorkshire rose.svg | ||
|Chapman code=WRY | |Chapman code=WRY | ||
Revision as of 11:23, 5 February 2014
Template:Database is a general database constructed as the Mediawiki programme permits, as nested switch functions. The data may be extracted easily whether within an article or in a template.
The database contains counties, territories etc, but also units of measurement, which feed the "Convert" function of Template:Convert.
Examples
The following examples demonstrate how to extract data:
| [[File:{{Database|Monmouthshire|flag}}|center|50px]] | will give: |  |
| {{Database|Monmouthshire|Welsh}} | will give: | Sir Fynwy |
Caution: blank fields
Not every data field is completed nor can be. Care must therefore be taken to ensure that you still achieve the right result in every case.
The first example above but substituting "Ayrshire" in place of "Monmouthshire" would produce an error as there is no Ayrshire flag image, so an {{:if: or {{:ifeq: function should be used where there might be a blank field.
