User:Robevans123/Principal areas of Wales

Principal areas edit

Came into being in 1996, based on the districts of the eight counties (now the preserved counties) from 1974.

They are:

Blaenau Gwent County Borough: Blaenau Gwent County Borough (Q596885), and view here  
Bridgend County Borough: Bridgend County Borough (Q697126), and view here  
Caerphilly County Borough: Caerphilly County Borough (Q748065), and view here  
City and County of Cardiff: Cardiff (Q24342199), and view here  
Carmarthenshire: Carmarthenshire (Q217840), and view here   (also an historic county)
Ceredigion: Ceredigion (Q217829), and view here   (also an historic county)
Conwy County Borough: Conwy County Borough (Q817971), and view here  
Denbighshire: Denbighshire (Q650682), and view here   (different from the historic county - borders)
Flintshire: Flintshire (Q505610), and view here   (different from the historic county - borders)
Gwynedd: Gwynedd (Q109128), and view here   (different from the preserved county - which includes Anglesey)
Isle of Anglesey: Anglesey (Q168159), and view here   (also an historic county)
Merthyr Tydfil County Borough: Merthyr Tydfil (Q3306663), and view here  
Monmouthshire: Monmouthshire (Q207176), and view here   (different from the historic county - borders)
Neath Port Talbot County Borough: Neath Port Talbot County Borough (Q748078), and view here  
Newport City: Newport (Q11294004), and view here  
Pembrokeshire: Pembrokeshire (Q213361), and view here   (also an historic county)
Powys: Powys (Q156150), and view here   (also a preserved county)
Rhondda Cynon Taf County Borough: Rhondda Cynon Taf (Q817960), and view here  
City and County of Swansea: Swansea (Q10996863), and view here  
Torfaen County Borough: Torfaen (Q643919), and view here  
Vale of Glamorgan County Borough: Vale of Glamorgan (Q844784), and view here  
Wrexham County Borough: Wrexham County Borough (Q843868), and view here

Labels and descriptions and aliases edit

at least in English and Welsh

Properties edit

Need to check/add:

inception dates
communities
towns/villages
area and population
refs from mapit/OS/etc
council
official name
shares border with
capital?

#principal areas of Wales - properties - Part 1
SELECT ?item ?itemLabel ?_inception ?_authorityLabel ?_legislative_bodyLabel ?_instance_ofLabel ?_coat_of_arms_image WHERE {
  ?item wdt:P31 wd:Q15979307.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P571 ?_inception. }
  OPTIONAL { ?item wdt:P797 ?_authority. }
  OPTIONAL { ?item wdt:P194 ?_legislative_body. }
  OPTIONAL { ?item wdt:P31 ?_instance_of. }
  OPTIONAL { ?item wdt:P94 ?_coat_of_arms_image. }
}

Try it!

Various categories edit

topic's main category (P910) Y
Commons category (P373) Y
category of associated people (P1792) (People from ...) Y
category for people born here (P1464) (Naissance dans le ...)
category for people who died here (P1465) (Décès dans le ...)
category for films shot at this location (P1740)

#principal areas of Wales - categories
SELECT ?item ?itemLabel ?_category_of_associated_peopleLabel ?_category_for_people_born_hereLabel ?_category_for_people_who_died_hereLabel ?_category_for_films_shot_at_this_locationLabel WHERE {
  ?item wdt:P31 wd:Q15979307.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P1792 ?_category_of_associated_people. }
  OPTIONAL { ?item wdt:P1464 ?_category_for_people_born_here. }
  OPTIONAL { ?item wdt:P1465 ?_category_for_people_who_died_here. }
  OPTIONAL { ?item wdt:P1740 ?_category_for_films_shot_at_this_location. }
}

Try it!

Various lists edit

#principal areas of Wales - lists
SELECT ?item ?itemLabel ?_has_list ?_has_listLabel WHERE {
  ?item wdt:P31 wd:Q15979307.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P2354 ?_has_list. }
}

Try it!

Possible lists:

List of places in ...
List of schools in ...
List of Grade I listed buildings in ...
List of Grade II* listed buildings in ...
List of scheduled monuments in ...
List of sites of special scientific interest in ...
List of xxxxx in ...
List of communities in ...

Identifiers edit

Part 1 edit

GeoNames ID (P1566) Y
ISO 3166-2 code (P300) Y (including Welsh versions where available, and all referenced)
Freebase ID (P646) 4 missing
FIPS 10-4 (countries and regions) (P901) Y
MusicBrainz area ID (P982) Y
Curlie ID (P998) Y

#principal areas of Wales - identifiers - Part 1
SELECT ?item ?itemLabel ?_GSS_code__2011_ ?_GeoNames_ID ?_ISO_3166_2_code ?_Freebase_ID ?_FIPS_10_4__countries_and_regions_ ?_MusicBrainz_area_ID ?_dmoz_ID WHERE {
  ?item wdt:P31 wd:Q15979307.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P836 ?_GSS_code__2011_. }
  OPTIONAL { ?item wdt:P1566 ?_GeoNames_ID. }
  OPTIONAL { ?item wdt:P300 ?_ISO_3166_2_code. }
  OPTIONAL { ?item wdt:P646 ?_Freebase_ID. }
  OPTIONAL { ?item wdt:P901 ?_FIPS_10_4__countries_and_regions_. }
  OPTIONAL { ?item wdt:P982 ?_MusicBrainz_area_ID. }
  OPTIONAL { ?item wdt:P998 ?_dmoz_ID. }
}

Try it!

Part 2 edit

#principal areas of Wales - identifiers - Part 2
SELECT ?item ?itemLabel  ?_OpenStreetMap_Relation_identifier ?_GND_ID ?_VIAF_ID ?_LCAuth_ID ?_Encyclop_dia_Britannica_Online_ID WHERE {
  ?item wdt:P31 wd:Q15979307.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P402 ?_OpenStreetMap_Relation_identifier. }
  OPTIONAL { ?item wdt:P227 ?_GND_ID. }
  OPTIONAL { ?item wdt:P214 ?_VIAF_ID. }
  OPTIONAL { ?item wdt:P244 ?_LCAuth_ID. }
  OPTIONAL { ?item wdt:P1417 ?_Encyclop_dia_Britannica_Online_ID. }
}

Try it!

Quick and dirty query edit

#principal areas of wales

SELECT ?item ?itemLabel ?_adminLabel

WHERE {
  ?item wdt:P31 wd:Q15979307.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P131 ?_admin. }
}

Try it!