User:Robevans123/Principal areas of Wales

Principal areasEdit

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

They are:

Labels and descriptions and aliasesEdit

at least in English and Welsh

PropertiesEdit

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 categoriesEdit

#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 listsEdit

#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 ...

IdentifiersEdit

Part 1Edit

#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 2Edit

#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 queryEdit

#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!