Property talk:P12123

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

‎North Rhine-Westphalian school ID
6-digit number used by the Ministry of Innovation, Science and Research of North Rhine-Westphalia to identify schools

Represents	unknown
Associated item	Ministry of Innovation, Science and Research of North Rhine-Westphalia (Q1636435)
Has quality	numeric identifier (Q93868746)
Data type	External identifier
Corresponding template	Template:Infobox school (Q5618975)
Domain	school (Q3914)
Allowed values	^\d{6}$
Example	no label (Q55975517) → 125581 Zeppelin-Gymnasium Lüdenscheid (Q15855675) → 169808 Verbundschule Schalksmühle (Q2134827) → 198638
Source	https://www.schulministerium.nrw
Formatter URL	https://www.schulministerium.nrw.de/BiPo/SchuleSuchen/pages/schulsuche/schule_information_seite.xhtml?schulnummer=$1
Related to country	Germany (Q183) (See 346 others) (North Rhine-Westphalia (Q1198))
See also	Austrian school ID (P10181), Bavarian school ID (P12350), Rhineland-Palatinate school ID (P12274), JedeSchule.de ID (P9224)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Database reports/Complex constraint violations/P12123 Database reports/Constraint violations/P12123 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 745 Main statement 741 out of 5,400 (14% complete) 99.5% of uses Qualifier 3 0.4% of uses Reference 1 0.1% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P12123#Unique value, SPARQL (every item), SPARQL (by value)

Format “^\d{6}$”: value must be formatted using this pattern (PCRE syntax). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P12123#Format, SPARQL

Type “school (Q3914)”: item must contain property “instance of (P31)” with classes “school (Q3914)” or their subclasses (defined using subclass of (P279)). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P12123#Type Q3914, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P12123#Entity types

Scope is as main value (Q54828448): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P12123#Scope, SPARQL

Item “country (P17): Germany (Q183)”: Items with this property should also have “country (P17): Germany (Q183)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P12123#Item P17, search, SPARQL

In North Rhine-Westphalia
School must be in North Rhine-Westphalia (Q1198). (Help)
Violations query: SELECT ?item ?loc { ?item wdt:P12123 []. ?item wdt:P131 ?loc. FILTER NOT EXISTS { ?loc wdt:P131* wd:Q1198 }. }
List of this constraint violations: Database reports/Complex constraint violations/P12123#In North Rhine-Westphalia

Talk:Q2111126#North_Rhine-Westphalian_school_ID

Please also check

• Talk:Q2111126#North_Rhine-Westphalian_school_ID
• de:Diskussion:Liste_der_Gymnasien_in_Nordrhein-Westfalen
• de:Portal:Nordrhein-Westfalen/Schulen

--M2k~dewiki (talk) 21:26, 30 October 2023 (UTC)

At the moment, there are some schools with other schools as parts listed as exceptions of the single value constraint.

With @M2k~dewiki, it was discussed that these schools shouldn't have multiple values, they should have no value.

I propose

1. to remove these school centers from the exception list
2. to document which schools or even kinds of schools actually don't have this school ID
   • examples: schools having parts, closed schools, music schools, folk high schools

As a further consequence, I wonder whether the expected completeness of this property should be „always incomplete“ instead of „eventually complete“.

Are there any comments on this? T. Wirbitzki (talk) 21:49, 30 October 2023 (UTC)

Hello @T. Wirbitzki: how is the "state of completeness" relevant? How does this make a difference? Regardaring removing the exceptions I agree, they are not necessary, since every school should have exactly one ID. Regarding additional documentation, which objects do not have an ID I do not see the advantage. For which purpose would such a documentation helpful? M2k~dewiki (talk) 22:37, 30 October 2023 (UTC)

You are right, this discussion here documents the process of loading the school IDs from WP sufficiently, to answer the question why loading of the harvest template will necessarily list some constraint violations, even if all possible school IDs were imported. Regarding the expected completeness: I don't know the relevance of the value, so the value is ok for me.

I will remove the school centers from the single value constraint exceptions as long as they contain schools. However, there is an example of a bundled school Bischöfliche Clara-Fey-Schule (Q51830042) which instantiates two school types. T. Wirbitzki (talk) 23:32, 1 November 2023 (UTC)

I've erased all cases of schools with multiple school numbers by letting them having parts with a school number, e.g. Bischöfliche Clara-Fey-Schule (Q51830042).

About 13 cases in actual NRW Wikidata are real school centers or constructs of several schools at one place operated by the same institution, similar to a school center.

5 cases like e.g. Georg-Müller-Schulen Bielefeld (Q1503426) are associated schools of one operator, split into several locations, some of these associations having only one published school number for two schools, e.g. Erzbischöfliches Berufskolleg Neuss (Q1363868). T. Wirbitzki (talk) 18:31, 17 December 2023 (UTC)