Property talk:P4156
Latest comment: 1 year ago by Jklamo in topic RES database
Documentation
Czech Registration ID (IČO)
8-digit identifier for an organization (or self-employed entrepreneur) in the Czech Republic, conferred by the Czech Statistical Office
8-digit identifier for an organization (or self-employed entrepreneur) in the Czech Republic, conferred by the Czech Statistical Office
[create Create a translatable help page (preferably in English) for this property to be included here]
List of violations of this constraint: Database reports/Constraint violations/P4156#Format, hourly updated report, SPARQL
Type “organization (Q43229), juridical person (Q155076), human (Q5)”: item must contain property “instance of (P31)” with classes “organization (Q43229), juridical person (Q155076), human (Q5)” 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/P4156#Type Q43229, Q155076, Q5, SPARQL
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/P4156#Unique value, SPARQL (every item), SPARQL (by value)
Single best value: this property generally contains a single value. If there are several, one would have preferred rank (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/P4156#single best value, SPARQL
Item “country (P17): Czech Republic (Q213), Czechoslovakia (Q33946)”: Items with this property should also have “country (P17): Czech Republic (Q213), Czechoslovakia (Q33946)”. (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/P4156#Item P17, search
Conflicts with “instance of (P31): Wikimedia disambiguation page (Q4167410), Wikimedia category (Q4167836)”: this property must not be used with the listed properties and values. (Help)
List of violations of this constraint: Database reports/Constraint violations/P4156#Conflicts with P31, hourly updated report, SPARQL List of violations of this constraint: Database reports/Constraint violations/P4156#Item P31, hourly updated report, search, 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/P4156#Entity types
Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)
List of violations of this constraint: Database reports/Constraint violations/P4156#Scope, hourly updated report, SPARQLLabel required in languages: cs: Entities using this property should have labels in one of the following languages: cs (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/P4156#Label in 'cs' language, search, SPARQL
Validate czech organization numbers
Report organizations with incorrect organization numbers, found by validating the checksum (Help)
Violations query:
List of this constraint violations: Database reports/Complex constraint violations/P4156#Validate czech organization numbers
Report organizations with incorrect organization numbers, found by validating the checksum (Help)
Violations query:
SELECT ?item #?itemLabel ?iconr ?checksum ?checksum2 ?quot ?rem WITH { SELECT DISTINCT * WHERE { ?item wdt:P4156 ?iconr . FILTER(strlen(?iconr) = 8) BIND(xsd:integer(substr(?iconr, 1, 1))*8 + xsd:integer(substr(?iconr, 2, 1))*7 + xsd:integer(substr(?iconr, 3, 1))*6 + xsd:integer(substr(?iconr, 4, 1))*5 + xsd:integer(substr(?iconr, 5, 1))*4 + xsd:integer(substr(?iconr, 6, 1))*3 + xsd:integer(substr(?iconr, 7, 1))*2 AS ?checksum) #BIND(floor(?checksum/11) AS ?quot) #BIND(?checksum - 11*?quot AS ?rem) BIND(11 - ?checksum + 11*floor(?checksum/11) AS ?checksum2) FILTER(substr(?iconr, 8, 1) != substr(?checksum2, strlen(?checksum2), 1)) } #LIMIT 1000 } AS %i WHERE { INCLUDE %i SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } }List of this constraint violations: Database reports/Complex constraint violations/P4156#Validate czech organization numbers
| Pattern ^(\d{7})$ will be automatically replaced to 0\1. Testing: TODO list |
| Pattern ^(\d{6})$ will be automatically replaced to 00\1. Testing: TODO list |
| Pattern ^(\d{5})$ will be automatically replaced to 000\1. Testing: TODO list |
| Pattern ^(\d{4})$ will be automatically replaced to 0000\1. Testing: TODO list |
| Pattern ^(\d{3})$ will be automatically replaced to 00000\1. Testing: TODO list |
|
This property is being used by: Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.) |
RES database
editCzech Statistical Office (Q3504917) has finally updated its RES database GUI so that it is now possible to refer directly to the IČO and thus have formatter URL. Also, the amount of information about the subject has been slightly expanded. So I suggest to change the formatter URL to https://apl.czso.cz/res/detail?ico=$. There is more information in the business registry, but not all types of entities are there. Jklamo (talk) 21:36, 27 August 2023 (UTC)
- I have added the RES link about half a year ago as a “third-party formatter URL”. So if the question is “should we switch the primary”… I don’t care really; the same question has been raised for the ARES link and… it doesn’t matter to me, but yes, it makes some sense to have a formatter link which works for (almost?) all values, not only for juridical persons. --Mormegil (talk) 08:51, 28 August 2023 (UTC)
- Me neither, but I remember there was a discussion somewhere (I can't remember where) about limited business registry coverage. RES looks like it's struggling with long-denfunct entities (see [1] vs [2], but otherwise it's probably complete. Jklamo (talk) 19:35, 28 August 2023 (UTC)