Property talk:P3202

Documentation

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

UAI code
official identifier of a French educational establishment

Associated item	French Ministry of education (Q2572330)
Data type	External identifier
Domain	organization (Q43229) or facility (Q13226383)
Allowed values	(0\d{2}|[67]20|9[78]\d)\d{4}[A-Z]
Example	Lycée Henri-IV (Q1878600) → 0750654D no label (Q71819874) → 0622871J Lycée Français de Varsovie (Q3268902) → 1220001N
Tracking: usage	Category:Pages using Wikidata property P3202 (Q63164535)
Related to country	France (Q142) (See 638 others)
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 Mix'n'match (Report) Database reports/Complex constraint violations/P3202 Database reports/Constraint violations/P3202 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 49,924 Main statement 49,918 out of 65,316 (76% complete) >99.9% of uses Qualifier 6 <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)

List of violations of this constraint: Database reports/Constraint violations/P3202#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

Single value: this property generally contains a single value. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: no label (Q2974825)
List of violations of this constraint: Database reports/Constraint violations/P3202#Single value, SPARQL

Format “(0\d{2}|[67]20|9[78]\d)\d{4}[A-Z]”: 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). Known exceptions: Casa de Velázquez (Q2470271)
List of violations of this constraint: Database reports/Constraint violations/P3202#Format, SPARQL

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

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Casa de Velázquez (Q2470271), French Lycée in Brussels (Q3269083)
List of violations of this constraint: Database reports/Constraint violations/P3202#Item P17, search, SPARQL

Format “\d{7}[^IOQ]”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P3202#Format, hourly updated report, SPARQL

Item “country (P17)”: Items with this property should also have “country (P17)”. (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/P3202#Item P17, search, SPARQL

Type “organization (Q43229), facility (Q13226383)”: item must contain property “instance of (P31)” with classes “organization (Q43229), facility (Q13226383)” 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/P3202#Type Q43229, Q13226383, SPARQL

Format “(?!020|096|097|098|099|989|998)\d+[A-Z]”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P3202#Format, hourly updated report, 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/P3202#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): 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/P3202#Scope, SPARQL

Inconsistency between the identifier and the location
Place with identifier prefix indicating a departement but located in another departement. (Help)
Violations query: SELECT DISTINCT ?item WHERE { { ?item wdt:P3202 ?uai; wdt:P131/wdt:P374 ?insee . FILTER( substr(?uai, 1, 1) = '0' && substr(?uai, 2, 2) != substr(?insee, 1, 2) ) } UNION { ?item wdt:P3202 ?uai; wdt:P131/wdt:P374 ?insee . FILTER( substr(?uai, 1, 1) = '6' && '2A' != substr(?insee, 1, 2) ) } UNION { ?item wdt:P3202 ?uai; wdt:P131/wdt:P374 ?insee . FILTER( substr(?uai, 1, 1) = '7' && '2B' != substr(?insee, 1, 2) ) } UNION { ?item wdt:P3202 ?uai ; wdt:P17 ?pays . FILTER( substr(?uai, 1, 1) = '1' && ?pays = wd:Q142 ) } }
List of this constraint violations: Database reports/Complex constraint violations/P3202#Inconsistency between the identifier and the location

Check letter (key)
See this example of check (Help)
Violations query: SELECT ?item ?str ?mod23xi WHERE { ?item wdt:P3202 ?str. BIND(str(?str) AS ?uai) BIND(STRLEN(?uai) AS ?strlen) BIND(substr(?str,?strlen-0,1) AS ?key) BIND(xsd:integer(substr(?str,?strlen-1,1)) AS ?x1) BIND(xsd:integer(substr(?str,?strlen-2,1)) AS ?x2) BIND(xsd:integer(substr(?str,?strlen-3,1)) AS ?x3) BIND(xsd:integer(substr(?str,?strlen-4,1)) AS ?x4) BIND(xsd:integer(substr(?str,?strlen-5,1)) AS ?x5) BIND(xsd:integer(substr(?str,?strlen-6,1)) AS ?x6) BIND(xsd:integer(substr(?str,?strlen-7,1)) AS ?x7) BIND(CONCAT(str(?x7), str(?x6), str(?x5), str(?x4), str(?x3), str(?x2), str(?x1)) AS ?concat) BIND(xsd:integer(?concat) AS ?xi) BIND(?xi-(xsd:integer(?xi/23)*23) AS ?mod23xi) BIND(REGEX (?uai, '^[1-9]{7}[A-Z]$') AS ?correct_pattern) FILTER(! ?correct_pattern) FILTER(! (?key = 'A' && ?mod23xi = 0)) FILTER(! (?key = 'B' && ?mod23xi = 1)) FILTER(! (?key = 'C' && ?mod23xi = 2)) FILTER(! (?key = 'D' && ?mod23xi = 3)) FILTER(! (?key = 'E' && ?mod23xi = 4)) FILTER(! (?key = 'F' && ?mod23xi = 5)) FILTER(! (?key = 'G' && ?mod23xi = 6)) FILTER(! (?key = 'H' && ?mod23xi = 7)) FILTER(! (?key = 'J' && ?mod23xi = 8)) FILTER(! (?key = 'K' && ?mod23xi = 9)) FILTER(! (?key = 'L' && ?mod23xi = 10)) FILTER(! (?key = 'M' && ?mod23xi = 11)) FILTER(! (?key = 'N' && ?mod23xi = 12)) FILTER(! (?key = 'P' && ?mod23xi = 13)) FILTER(! (?key = 'R' && ?mod23xi = 14)) FILTER(! (?key = 'S' && ?mod23xi = 15)) FILTER(! (?key = 'T' && ?mod23xi = 16)) FILTER(! (?key = 'U' && ?mod23xi = 17)) FILTER(! (?key = 'V' && ?mod23xi = 18)) FILTER(! (?key = 'W' && ?mod23xi = 19)) FILTER(! (?key = 'X' && ?mod23xi = 20)) FILTER(! (?key = 'Y' && ?mod23xi = 21)) FILTER(! (?key = 'Z' && ?mod23xi = 22)) } ORDER BY ?item
List of this constraint violations: Database reports/Complex constraint violations/P3202#Check letter (key)

Problem with the search engine?

Hi,

isn't there a problem with the search engine of the directory? None of my researches (on the base of existing institutions) returns matching results... Nomen ad hoc (talk) 14:18, 19 July 2018 (UTC).

Bonjour Nomen ad hoc, en fait, ça ne marche qu'avec l'intitulé précis tel qu'il est enregistré dans la base, mais pas avec les variantes. Il vaut mieux chercher par villes p. ex. Cordialement Alain Schneider (talk) 14:21, 23 August 2018 (UTC)

Bonjour Alain Schneider. Merci pour le tuyau . Cdt. Nomen ad hoc (talk) 14:54, 23 August 2018 (UTC).