Property talk:P6460
Jump to navigation
Jump to search
Documentation
Swedish Organization Number
sequence of two numberpairs that is unique to a Swedish company or organization given out by the responsible government department
sequence of two numberpairs that is unique to a Swedish company or organization given out by the responsible government department
[create Create a translatable help page (preferably in English) for this property to be included here]
Type “organization (Q43229)”: item must contain property “instance of (P31)” with classes “organization (Q43229)” 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/P6460#Type Q43229, SPARQL
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). List of violations of this constraint: Database reports/Constraint violations/P6460#Single value, 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/P6460#Unique value, SPARQL (every item), SPARQL (by value)
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/P6460#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P6460#Format, SPARQL
Item “country (P17): Sweden (Q34)”: Items with this property should also have “country (P17): Sweden (Q34)”. (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/P6460#Item P17, 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/P6460#Entity types
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/P6460#Item P1454, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P6460#Item P1454, search, SPARQL
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/P6460#Scope, SPARQL
Label required in languages: sv: Entities using this property should have labels in one of the following languages: sv (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/P6460#Label in 'sv' language, search, SPARQL
Item “OpenCorporates ID (P1320)”: Items with this property should also have “OpenCorporates ID (P1320)”. (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/P6460#Item P1320, search, SPARQL
![](http://178.128.105.246/cars-http-upload.wikimedia.org/wikipedia/commons/thumb/a/a6/Pictogram_voting_comment.svg/40px-Pictogram_voting_comment.svg.png)
Validate swedish 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/P6460#Validate swedish organization numbers
Report organizations with incorrect organization numbers, found by validating the checksum (Help)
Violations query:
SELECT ?item #?itemLabel ?orgnr ?checksum ?checksum2 WITH { SELECT DISTINCT * WHERE { ?item wdt:P6460 ?orgnr . FILTER(strlen(?orgnr) = 11) BIND(IF(xsd:integer(substr(?orgnr, 1, 1))*2 > 9, xsd:integer(substr(?orgnr, 1, 1))*2 - 9, xsd:integer(substr(?orgnr, 1, 1))*2) + xsd:integer(substr(?orgnr, 2, 1))*1 + IF(xsd:integer(substr(?orgnr, 3, 1))*2 > 9, xsd:integer(substr(?orgnr, 3, 1))*2 - 9, xsd:integer(substr(?orgnr, 3, 1))*2) + xsd:integer(substr(?orgnr, 4, 1))*1 + IF(xsd:integer(substr(?orgnr, 5, 1))*2 > 9, xsd:integer(substr(?orgnr, 5, 1))*2 - 9, xsd:integer(substr(?orgnr, 5, 1))*2) + xsd:integer(substr(?orgnr, 6, 1))*1 + IF(xsd:integer(substr(?orgnr, 8, 1))*2 > 9, xsd:integer(substr(?orgnr, 8, 1))*2 - 9, xsd:integer(substr(?orgnr, 8, 1))*2) + xsd:integer(substr(?orgnr, 9, 1))*1 + IF(xsd:integer(substr(?orgnr, 10, 1))*2 > 9, xsd:integer(substr(?orgnr, 10, 1))*2 - 9, xsd:integer(substr(?orgnr, 10, 1))*2) AS ?checksum) BIND(10*CEIL(?checksum/10) - ?checksum AS ?checksum2) FILTER(substr(?orgnr, 11, 1) != ?checksum2 && substr(?orgnr, 3, 1) > 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/P6460#Validate swedish organization numbers
|
|
Categories:
- Sweden-related properties
- All Properties
- Properties with external-id-datatype
- Properties used on 1000+ items
- Properties with constraints on type
- Properties with single value constraints
- Properties with unique value constraints
- Properties with format constraints
- Properties with constraints on items using them
- Properties with entity type constraints
- Properties with scope constraints
- Properties with label language constraints
- Properties with complex constraints
- Organisation properties