Wikidata

Wikidata:WikiProject Netherlands Public Libraries/MonitoringQueries

< Wikidata:WikiProject Netherlands Public Libraries
(Redirected from Wikidata:WikiProject Netherlands Public Libraries/Admin)

Monitoring queries & data quality edit

Goal of this page: monitor that data about Dutch public library organisations (DPLO) and branches (DPLB) on Wikidata is of good quality, that it is not being messed with

DPL Branches edit

Check that every Dutch public library branch item has:

Instances (P31, Q28564, Q11396180) edit

  • Public library branch Q-items *must* be instances of (P31) both public library (Q28564) and library branch (Q11396180).
  • If a Dutch PL branch item has only one of the values Q28564 or Q11396180 in the P31 field, it is not found, as we query for both Q28564 and Q11396180 :
  • Query for all Dutch public libraries (P31:Q28564 + P17:Q55) [Check]. We find 3 groups: 1) DPL organisations, 2) DPL branches related to an organisation and 3) Other DPLs
  • Query for all Dutch library branches (P31:Q11396180 + P17:Q55) [Check]. We also find branches of non-public Dutch librariess

Query work in progress

  • Q28564 + Q11396180 are both compulsory in the P31 statement
  • Library building (Q856584), building (Q41176) and other Q-values are optional.
  • All Q-values in the P31 statement must have normal ranks.

Labels, descriptions, native name, photo edit

  • Labels and descriptions - Checks
  • Labels in NL and EN are both compulsory
  • Descriptions in NL and EN are both compulsory
  • Native label (P1705) - use above query to check
  • Compulsory
  • Single value
  • Must be in Dutch
  • Optional
  • One image per library

Headquarters edit

  • All organisations must have one unique headquarters location (P159)
  • The branch that is the administration/management office must be an instance of (P31) headquarters Q7540126.
  • Q7540126 must have normal rank
  • Q7540126 must have the the qualifier "of" (P642), with Q-value of the PL organisation
  • Find the HQs (and ranks) of all PL organisatations via the property "Headquarters location" P159
  • Verify that the found HQ is indeed an instance of HQ (P31 --> Q7540126)
  • Verify that the found HQ is the HQ of the stated PL organisation
  • For instance: The HQ location of (P159) the Rivierenland Public Library Foundation (Q59771462) is Tiel public library (Q59772808), which is an instance of (P31) headquarters (Q7540126) of (P642) Rivierenland Public Library Foundation (Q59771462)
  • Find all PL braches and filter those that are (also) instances of headquarters Q7540126.
  • Find the organisation these libraries are the HQs of (via 'of' (P642) as qualifier)
  • Find the HQs of these organisations (via P159)
  • Query 1 and query 2 must give identical results

Part Of, Has Parts edit

  • Branches must be Part of (P361) of parent library organisation
  • PartOf statement can have multiple values (e.g. OBA Hallen)

Visitors location (not: postal) edit

  • Located on street (P669) - Checks
  • A PLB (or better: the main entrance of the PLB) can be only on one street, so P669 can have only one value
  • Public library branches - are they in the correct street and is that street in the correct location & municipality?
  • I.e. check that the street the PLB lies on (P669), is situated in the correct location (P276) and municipality (P131) (via the WD-descriptions of street , location and municipality)
  • Street number (P670) and Postal code (P281) - Check
  • Street number (P670) and Postal code (P281) must both be qualifiers for Located on street (P669)
  • Postal code as qualifier of P669 must match (be the same as) the postal code code as statement P281
  • Unique value (?)
  • Can be empty ! (e.g. for Q61764040, Bibliotheek Scherpenzeel)
  • Can be a city, town, village, settlement, place, neighbourhood, borough, building, cultural center etc.
  • Can't be the same value as 'located in the administrative territorial entity' P131, which must be a municipality
  • Must lie in the municipality stated in the P131 field, but....
  • ....NOTE: A location (village etc) can lie in more that 1 municipality, eg. OBA Ouderkerk is located in the village of Ouderkerk aan de Amstel, which is located in the municipalities of Ouder-Amstel AND Amstelveen
  • Located in the administrative territorial entity (P131) --> municipality & province - Checks
  • Library must lie in a Dutch municipality
  • Unique value, as a library can only be in one municipality
  • Can not be empty, as there are no libraries that are NOT in a municipality
  • The municipality must lie in a Dutch province (found via P131 in the WD-item of the municipality

STILL TO CHECK CHECK THESE:

  • Give preferred rank to the value "Dutch province" in P131 (in this case : Noord-Holland)
  • Study this page to request all (so also all non-truthy) values of P131 and filter out those values that are instances of "province of the Netherlands (Q134390)"
  • Every Dutch public library branch (plb) must have a P17/Q55 statement, as all Dutch libraries are located in the country (P17) of The Netherlands (Q55).
  • Does not (yet) include the Carribean parts of the Kingdom of the Netherlands
  • Count the number of public library branches that are in Nederland (Q55)
  • Located at street address (P6375, P696) - Check
  • Deprecated 'located at street address' stuff (P696) vs. current 'located at street address' stuff (P6375)

Geo-coordinates, OSM, elevation edit

  • Coordinate location (P625) and Elevation (P2044) - Checks
  • Every branch, except library bus services (not: bus stops), must have one pair of geo-coordinates P625
  • Branch must have one Open Street Map URL as reference for the coordinate location
  • Branch can have one optional value for elevation P2204

Contact details edit

  • Phone number (P1329) - Check
  • Phone number is optional
  • Can have multiple values (fixed, mobile..)
  • Must have standardized format RFC3966 --> decompose phone number into 4 parts
  • Official website URL (P856) - Check
  • Must have Retrieved (P813) as qualifier (ie. NOT as source reference!)
  • Cannot have the url-value as reference (P854), as this woud be self-reference
  • Email address (P968) - Check
  • Email is optional, 0 or more values
  • Must start with 'mailto:' and contain a '@' and end with a '.tld'
  • One or more source references must be given, in each of which p:P854 is a URL and p:P813 is a timestamp

External reference edit

  • Described at URL (P973) - Check
  • Is optional
  • Is unique ?? Or can there be more than 1 value?
  • If it is stated, it must be a https://www.gidsvoornederland.nl URL ?? Or can it also be a different website?
  • If it is stated, it must have an Internet Archive URL (https://web.archive.org) as reference (P1065)
  • The web.archive.org-URL must contain the Gidsvoornederland-URL
  • Timestamp must be "Retrieved" (P813), not "Archive date" (P2960)
  • Is optional
  • Is unique
  • Reference URL (P854) must be https://www.gidsvoornederland.nl url
  • ISIL codes of Dutch public library branches must start with "NL-0"
  • ISIL codes of Dutch public library branches must be 13 characters long
  • ISIL codes of Dutch public library headquarters/main offices (hoofdvestigingen, basisbibliotheken) must end with "0000"
  • Check nu of alle vestigingen waarvan de isilcode eindigt op 0000, inderdaad hoofdvestigingen/hoofdkantoren zijn (instances of (P31)headquarters (Q7540126)) --> find differences between ISIL and Administrative ISIL codes, and correct these
  • Middle part of isil (?isilmiddle) must correspond with library organisation (PartOf)
Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Netherlands_Public_Libraries/MonitoringQueries&oldid=1281128647"