Difference between revisions of "Template:Database"
From Wikishire
| Line 22: | Line 22: | ||
|flag=Flag of Anglesey.svg | |flag=Flag of Anglesey.svg | ||
|badge=Flag of Anglesey.svg | |badge=Flag of Anglesey.svg | ||
| + | |motto=Môn Mam Cymru<br />(Anglesey mother of Wales) | ||
|Chapman code=AGY | |Chapman code=AGY | ||
|HCS code=AGL | |HCS code=AGL | ||
| Line 36: | Line 37: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Lippen on Angus<br />(Trust in Angus) | ||
|Chapman code=ANS | |Chapman code=ANS | ||
|HCS code=ANG | |HCS code=ANG | ||
| Line 95: | Line 97: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=God Shaw the Right | ||
|Chapman code=AYR | |Chapman code=AYR | ||
|HCS code=AYS | |HCS code=AYS | ||
| Line 109: | Line 112: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Spe et Spiritu<br />(With hope and courage) | ||
|Chapman code=BAN | |Chapman code=BAN | ||
|HCS code=BNF | |HCS code=BNF | ||
| Line 123: | Line 127: | ||
|flag=Bedfordshire County Flag.svg | |flag=Bedfordshire County Flag.svg | ||
|badge=Bedfordshire County Flag.svg | |badge=Bedfordshire County Flag.svg | ||
| + | |motto=Constant Be | ||
|Chapman code=BDF | |Chapman code=BDF | ||
|HCS code=BED | |HCS code=BED | ||
| Line 165: | Line 170: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Undeb Hedd Llwyddiant<br />(Unity, peace, prosperity) | ||
|Chapman code=BRE | |Chapman code=BRE | ||
|HCS code=BRN | |HCS code=BRN | ||
| Line 179: | Line 185: | ||
|flag=Flag of Buckinghamshire.svg | |flag=Flag of Buckinghamshire.svg | ||
|badge=Buckinghamshire Swan Badge.svg | |badge=Buckinghamshire Swan Badge.svg | ||
| + | |mottom=Vestigia Nulla Retrorsum<br />(No stepping back) | ||
|Chapman code=BKM | |Chapman code=BKM | ||
|HCS code=BUC | |HCS code=BUC | ||
| Line 207: | Line 214: | ||
|flag=Flag of Caernarfonshire.svg | |flag=Flag of Caernarfonshire.svg | ||
|badge=Flag of Caernarfonshire.svg | |badge=Flag of Caernarfonshire.svg | ||
| + | |motto=Cadernid Gwynedd<br />(The strength of Gwynedd) | ||
|Chapman code=CAE | |Chapman code=CAE | ||
|HCS code=CRN | |HCS code=CRN | ||
| Line 221: | Line 229: | ||
|flag=Flag of Caithness.svg | |flag=Flag of Caithness.svg | ||
|badge=Flag of Caithness.svg | |badge=Flag of Caithness.svg | ||
| + | |motto=Commit thy Wark to God | ||
|Chapman code=CAI | |Chapman code=CAI | ||
|HCS code=CTN | |HCS code=CTN | ||
| Line 235: | Line 244: | ||
|flag=Cambridgeshire Flag.svg | |flag=Cambridgeshire Flag.svg | ||
|badge=Cambridgeshire Flag.svg | |badge=Cambridgeshire Flag.svg | ||
| + | |motto=Per undas, per agros<br />(Through waves, through fields) | ||
|Chapman code=CAM | |Chapman code=CAM | ||
|HCS code=CMB | |HCS code=CMB | ||
| Line 249: | Line 259: | ||
|flag= | |flag= | ||
|badge=Cardiganshire badge.svg | |badge=Cardiganshire badge.svg | ||
| + | |motto=Golud Gwlad Rhyddid<br />(A nation's wealth is freedom) | ||
|Chapman code=CGN | |Chapman code=CGN | ||
|HCS code=CRG | |HCS code=CRG | ||
| Line 263: | Line 274: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Rhyddid gwerin ffyniant gwlad<br />(A free people a prosperous country) | ||
|Chapman code=CMN | |Chapman code=CMN | ||
|HCS code=CRM | |HCS code=CRM | ||
| Line 277: | Line 289: | ||
|flag=Cheshire Flag.svg | |flag=Cheshire Flag.svg | ||
|badge=Azure, a garb Or.svg | |badge=Azure, a garb Or.svg | ||
| + | |motto=Jure et dignitate gladii<br />(By the right and dignity of the Sword) | ||
|Chapman code=CHS | |Chapman code=CHS | ||
|HCS code=CHE | |HCS code=CHE | ||
| Line 291: | Line 304: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Look Aboot Ye | ||
|Chapman code=CLK | |Chapman code=CLK | ||
|HCS code=CLM | |HCS code=CLM | ||
| Line 305: | Line 319: | ||
|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 | ||
| + | |motto=Onen Hag Oll<br />(One and all) | ||
|Chapman code=CON | |Chapman code=CON | ||
|HCS code=CNW | |HCS code=CNW | ||
| Line 333: | Line 348: | ||
|flag=Cumberland flag.svg | |flag=Cumberland flag.svg | ||
|badge=Cumberland badge.svg | |badge=Cumberland badge.svg | ||
| + | |motto=Perfero<br />(I carry through) | ||
|Chapman code=CUL | |Chapman code=CUL | ||
|HCS code=CUM | |HCS code=CUM | ||
| Line 347: | Line 363: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Duw â digon<br />(God is sufficient) | ||
|Chapman code=DEN | |Chapman code=DEN | ||
|HCS code=DBH | |HCS code=DBH | ||
| Line 361: | Line 378: | ||
|flag=Derbyshire flag.svg | |flag=Derbyshire flag.svg | ||
|badge=Derbyshire flag.svg | |badge=Derbyshire flag.svg | ||
| + | |motto=Bene consulendo<br />(By good counsel) | ||
|Chapman code=DBY | |Chapman code=DBY | ||
|HCS code=DRB | |HCS code=DRB | ||
| Line 375: | Line 393: | ||
|flag=Flag of Devon.svg | |flag=Flag of Devon.svg | ||
|badge=Flag of Devon.svg | |badge=Flag of Devon.svg | ||
| + | |motto=Auxilio Divino<br />(By divine aid) | ||
|Chapman code=DEV | |Chapman code=DEV | ||
|HCS code=DVN | |HCS code=DVN | ||
| Line 389: | Line 408: | ||
|flag=FlagOfDorset.svg | |flag=FlagOfDorset.svg | ||
|badge=FlagOfDorset.svg | |badge=FlagOfDorset.svg | ||
| + | |motto=Who's Afear'd | ||
|Chapman code=DOR | |Chapman code=DOR | ||
|HCS code=DRS | |HCS code=DRS | ||
| Line 432: | Line 452: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Levenax<br />(Land of the elm trees) | ||
|Chapman code=DNB | |Chapman code=DNB | ||
|HCS code=DUN | |HCS code=DUN | ||
| Line 503: | Line 524: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Virtute et opera<br />(By virtue and by industry) | ||
|Chapman code=FIF | |Chapman code=FIF | ||
|HCS code=FFE | |HCS code=FFE | ||
| Line 517: | Line 539: | ||
|flag=Flag of Flintshire.svg | |flag=Flag of Flintshire.svg | ||
|badge=Flag of Flintshire.svg | |badge=Flag of Flintshire.svg | ||
| + | |motto=Gorau tarian, cyfiawnder<br />(The best shield is justice) | ||
|Chapman code=FLN | |Chapman code=FLN | ||
|HCS code=FLT | |HCS code=FLT | ||
| Line 531: | Line 554: | ||
|flag=Glamorgan Flag.svg | |flag=Glamorgan Flag.svg | ||
|badge=Iestyn & De Clare - Glamorgan shields.svg | |badge=Iestyn & De Clare - Glamorgan shields.svg | ||
| + | |motto=A ddioddefws a orfu<br />(He that endureth, overcometh) | ||
|Chapman code=GLA | |Chapman code=GLA | ||
|HCS code=GLM | |HCS code=GLM | ||
| Line 545: | Line 569: | ||
|flag=Severn Cross.svg | |flag=Severn Cross.svg | ||
|badge=Severn Cross.svg | |badge=Severn Cross.svg | ||
| + | |motto=Prorsum semper<br />(Ever forwards) | ||
|Chapman code=GLS | |Chapman code=GLS | ||
|HCS code=GLC | |HCS code=GLC | ||
| Line 573: | Line 598: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Pulchra Terra Dei Donum<br />(This fair land is the gift of God) | ||
|Chapman code=HEF | |Chapman code=HEF | ||
|HCS code=HRF | |HCS code=HRF | ||
| Line 587: | Line 613: | ||
|flag=County Flag of Hertfordshire.svg | |flag=County Flag of Hertfordshire.svg | ||
|badge=Hertford shield.svg | |badge=Hertford shield.svg | ||
| + | |motto=Trust and fear not | ||
|Chapman code=HRT | |Chapman code=HRT | ||
|HCS code=HTF | |HCS code=HTF | ||
| Line 601: | Line 628: | ||
|flag=Flag of Huntingdonshire.svg | |flag=Flag of Huntingdonshire.svg | ||
|badge=Huntingdonshire roundel.svg | |badge=Huntingdonshire roundel.svg | ||
| + | |motto=Labore omnia florent<br />(By labour everything prospers) | ||
|Chapman code=HUN | |Chapman code=HUN | ||
|HCS code=HNT | |HCS code=HNT | ||
| Line 615: | Line 643: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Air son Math na Siorrachd<br />(For the good of the county) | ||
|Chapman code=INV | |Chapman code=INV | ||
|HCS code=INS | |HCS code=INS | ||
| Line 629: | Line 658: | ||
|flag=Flag of Kent.svg | |flag=Flag of Kent.svg | ||
|badge=Red Kentish Horse.svg | |badge=Red Kentish Horse.svg | ||
| + | |motto=Invicta<br />(unconquered) | ||
|Chapman code=KEN | |Chapman code=KEN | ||
|HCS code=KNT | |HCS code=KNT | ||
| Line 643: | Line 673: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Laus Deo<br />(Praise to God) | ||
|Chapman code=KCD | |Chapman code=KCD | ||
|HCS code=KNC | |HCS code=KNC | ||
| Line 657: | Line 688: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=For all Time | ||
|Chapman code=KRS | |Chapman code=KRS | ||
|HCS code=KNR | |HCS code=KNR | ||
| Line 699: | Line 731: | ||
|flag=Lancashire County Flag.svg | |flag=Lancashire County Flag.svg | ||
|badge=Red Rose of Lancaster.svg | |badge=Red Rose of Lancaster.svg | ||
| + | |motto=In consilio consilium<br />(In counsel is wisdom) | ||
|Chapman code=LAN | |Chapman code=LAN | ||
|HCS code=LCS | |HCS code=LCS | ||
| Line 713: | Line 746: | ||
|flag= | |flag= | ||
|badge=Leicestershire cinquefoil badge on red.svg | |badge=Leicestershire cinquefoil badge on red.svg | ||
| + | |motto=For'ard For'ard | ||
|Chapman code=LEI | |Chapman code=LEI | ||
|HCS code=LCR | |HCS code=LCR | ||
| Line 727: | Line 761: | ||
|flag=Lincolnshire flag.svg | |flag=Lincolnshire flag.svg | ||
|badge=Lincolnshire flag.svg | |badge=Lincolnshire flag.svg | ||
| + | |motto=Perseverance vincit<br />(Perseverance conquers) | ||
|Chapman code= | |Chapman code= | ||
|HCS code= | |HCS code= | ||
| Line 756: | Line 791: | ||
|flag=Flag of Merionethshire.svg | |flag=Flag of Merionethshire.svg | ||
|badge=Flag of Merionethshire.svg | |badge=Flag of Merionethshire.svg | ||
| + | |motto=Tra môr, tra Meirion<br />(While the sea lasts, so shall Merioneth) | ||
|Chapman code=MER | |Chapman code=MER | ||
|HCS code=MRN | |HCS code=MRN | ||
| Line 798: | Line 834: | ||
|flag=Flag of Monmouthshire.svg | |flag=Flag of Monmouthshire.svg | ||
|badge=Flag of Monmouthshire.svg | |badge=Flag of Monmouthshire.svg | ||
| + | |motto=Utrique Fidelis<br />(Faithful to both) | ||
|Chapman code=MON | |Chapman code=MON | ||
|HCS code=MNM | |HCS code=MNM | ||
| Line 812: | Line 849: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Powys paradwys Cymru<br />(Powys paradise of Wales) | ||
|Chapman code=MGY | |Chapman code=MGY | ||
|HCS code=MTG | |HCS code=MTG | ||
| Line 826: | Line 864: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=In Spe (In hope) | ||
|Chapman code=MOR | |Chapman code=MOR | ||
|HCS code=MOY | |HCS code=MOY | ||
| Line 840: | Line 879: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Unite and be Mindful | ||
|Chapman code=NAI | |Chapman code=NAI | ||
|HCS code=NRN | |HCS code=NRN | ||
| Line 868: | Line 908: | ||
|flag=Flag of Northamptonshire.svg | |flag=Flag of Northamptonshire.svg | ||
|badge=Flag of Northamptonshire.svg | |badge=Flag of Northamptonshire.svg | ||
| + | |motto=Rosa Concordiae Signum<br />(The Rose: Emblem of Harmony) | ||
|Chapman code=NTH | |Chapman code=NTH | ||
|HCS code=NHP | |HCS code=NHP | ||
| Line 896: | Line 937: | ||
|flag=County Flag of Nottinghamshire.svg | |flag=County Flag of Nottinghamshire.svg | ||
|badge=Nottinghamshire - Robin Hood.svg | |badge=Nottinghamshire - Robin Hood.svg | ||
| + | |motto=Sapienter proficiens<br />(Progress with wisdom) | ||
|Chapman code=NTT | |Chapman code=NTT | ||
|HCS code=NOT | |HCS code=NOT | ||
| Line 910: | Line 952: | ||
|flag=Orkney county flag.svg | |flag=Orkney county flag.svg | ||
|badge=Orkney county flag.svg | |badge=Orkney county flag.svg | ||
| + | |motto=Boreas Domus Mare Amicus<br />(Home to the winds, friend of the sea) | ||
|Chapman code=OKI | |Chapman code=OKI | ||
|HCS code=ORN | |HCS code=ORN | ||
| Line 924: | Line 967: | ||
|flag=Flag of Oxfordshire.svg | |flag=Flag of Oxfordshire.svg | ||
|badge=Flag of Oxfordshire.svg | |badge=Flag of Oxfordshire.svg | ||
| + | |motto=Sapere Aude<br />(Dare to be wise) | ||
|Chapman code=OXF | |Chapman code=OXF | ||
|HCS code=OXD | |HCS code=OXD | ||
| Line 938: | Line 982: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Contra Nando Incrementum<br />(Against the stream they multiply) | ||
|Chapman code=PEE | |Chapman code=PEE | ||
|HCS code=PBS | |HCS code=PBS | ||
| Line 952: | Line 997: | ||
|flag=Flag of Pembrokeshire.svg | |flag=Flag of Pembrokeshire.svg | ||
|badge=Flag of Pembrokeshire.svg | |badge=Flag of Pembrokeshire.svg | ||
| + | |motto=Ex unitate vires<br />(Out of unity is strength) | ||
|Chapman code=PEM | |Chapman code=PEM | ||
|HCS code=PMB | |HCS code=PMB | ||
| Line 966: | Line 1,012: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Pro Lege et Libertate<br />(For law and liberty) | ||
|Chapman code=PER | |Chapman code=PER | ||
|HCS code=PRT | |HCS code=PRT | ||
| Line 980: | Line 1,027: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Ewch yn Uwch<br />(Higher and higher) | ||
|Chapman code=RAD | |Chapman code=RAD | ||
|HCS code=RDN | |HCS code=RDN | ||
| Line 1,022: | Line 1,070: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Tu ne cede malis sed contra audenitor ito<br />(Yield not to misfortunes<br />but advance boldly against them) | ||
|Chapman code=ROX | |Chapman code=ROX | ||
|HCS code=RXB | |HCS code=RXB | ||
| Line 1,036: | Line 1,085: | ||
|flag=Rutland County Flag.svg | |flag=Rutland County Flag.svg | ||
|badge=Rutland County Flag.svg | |badge=Rutland County Flag.svg | ||
| + | |motto=Multum In Parvo<br />(much in little) | ||
|Chapman code=RUT | |Chapman code=RUT | ||
|HCS code=RTL | |HCS code=RTL | ||
| Line 1,064: | Line 1,114: | ||
|flag=Flag of Shetland.svg | |flag=Flag of Shetland.svg | ||
|badge=Flag of Shetland.svg | |badge=Flag of Shetland.svg | ||
| + | |motto=Með Lögum Skal Land Byggja<br />(With laws shall this land be built) | ||
|Chapman code=SHI | |Chapman code=SHI | ||
|HCS code=SHT | |HCS code=SHT | ||
| Line 1,078: | Line 1,129: | ||
|flag=Flag of Shropshire.svg | |flag=Flag of Shropshire.svg | ||
|badge=Salop roundel.svg | |badge=Salop roundel.svg | ||
| + | |motto=Floreat Salopia<br />(Let Shropshire flourish) | ||
|Chapman code=SAL | |Chapman code=SAL | ||
|HCS code=SHP | |HCS code=SHP | ||
| Line 1,092: | Line 1,144: | ||
|flag=Somerset Flag.svg | |flag=Somerset Flag.svg | ||
|badge=Somerset dragon.svg | |badge=Somerset dragon.svg | ||
| + | |motto=Sumorsaete ealle<br />(All the people of Somerset) | ||
|Chapman code=SOM | |Chapman code=SOM | ||
|HCS code=SMS | |HCS code=SMS | ||
| Line 1,106: | Line 1,159: | ||
|flag=Staffordshire Flag.svg | |flag=Staffordshire Flag.svg | ||
|badge=Staffordshire roundel.svg | |badge=Staffordshire roundel.svg | ||
| + | |motto=The knot unites | ||
|Chapman code=STS | |Chapman code=STS | ||
|HCS code=STF | |HCS code=STF | ||
| Line 1,134: | Line 1,188: | ||
|flag=Flag of Suffolk.svg | |flag=Flag of Suffolk.svg | ||
|badge=Suffolk St Edmund badge.svg | |badge=Suffolk St Edmund badge.svg | ||
| + | |motto=Opus Nostrum Dirige<br />(Direct our work) | ||
|Chapman code=SFK | |Chapman code=SFK | ||
|HCS code=SFF | |HCS code=SFF | ||
| Line 1,162: | Line 1,217: | ||
|flag=Flag of Sussex.svg | |flag=Flag of Sussex.svg | ||
|badge=Sussex shield.svg | |badge=Sussex shield.svg | ||
| + | |motto=We wunt be druv | ||
|Chapman code=SSX | |Chapman code=SSX | ||
|HCS code=SUS | |HCS code=SUS | ||
| Line 1,176: | Line 1,232: | ||
|flag=Flag of Sutherland.svg | |flag=Flag of Sutherland.svg | ||
|badge=Flag of Sutherland.svg | |badge=Flag of Sutherland.svg | ||
| + | |motto=Dluth Lean Do Dhuthchas Le Durachd<br />(Cling to thy heritage with diligence) | ||
|Chapman code=SUT | |Chapman code=SUT | ||
|HCS code=SRL | |HCS code=SRL | ||
| Line 1,204: | Line 1,261: | ||
|flag=Flag of Warwickshire.svg | |flag=Flag of Warwickshire.svg | ||
|badge=Warwickshire roundel.svg | |badge=Warwickshire roundel.svg | ||
| + | |motto=United to serve | ||
|Chapman code=WAR | |Chapman code=WAR | ||
|HCS code=WRW | |HCS code=WRW | ||
| Line 1,218: | Line 1,276: | ||
|flag= | |flag= | ||
|badge= | |badge= | ||
| + | |motto=Aye for the Common Weal | ||
|Chapman code=WLN | |Chapman code=WLN | ||
|HCS code=WLT | |HCS code=WLT | ||
Revision as of 11:08, 24 April 2018
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.
