Property talk:P3911

Documentation

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

STW Thesaurus for Economics ID
identifier for a descriptor of the STW Thesaurus for Economics, linking to literature on economics and business administration

Applicable "stated in" value	STW Thesaurus for Economics (Q26903352)
Data type	External identifier
Allowed values	\d+\-\d
Example	financial crisis (Q114380) → 19664-4 (RDF) New York City (Q60) → 30104-5 (RDF)
Source	https://zbw.eu/stw/version/latest/about
Formatter URL	https://zbw.eu/stw/version/latest/descriptor/$1/about
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/Constraint violations/P3911 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 6,661 Main statement 5,693 out of 5,777 (99% complete) 85.5% of uses Qualifier 5 <0.1% of uses Reference 963 14.5% 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/P3911#Unique value, 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: Caribbean Community (Q205995)
List of violations of this constraint: Database reports/Constraint violations/P3911#Single value, SPARQL

Format “[1-9]\d*\-\d”: value must be formatted using this pattern (PCRE syntax). (Help)

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

Required qualifier “mapping relation type (P4390)”: this property should be used with the listed qualifier. (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/P3911#mandatory qualifier, 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/P3911#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/P3911#Scope, SPARQL

Mapping relation mandatory

I've added a mandatory constraint for mapping relation type (P4390). All 395 existing values of the property were set to exact match (Q39893449), with a few changed manually afterwards. Jneubert (talk) 15:54, 19 October 2017 (UTC)

After a second thought, I have refrained from setting the constraint status (P2316) to mandatory constraint (Q21502408): During, e.g., larger Mix-n-match runs multiple temporary violations of the constraint may be unavoidable. Jneubert (talk) 15:09, 27 April 2018 (UTC)

Reports for the maintenance of the STW ID / Wikidata mapping

The rationale behind these reports is two-fold:

• creating a replacement for the standard "single"/"different" constraint violation reports, which does not work well with n:m mappings (whereas the warnings of the "check constraints" gadget are helpful against accidentally introduced redundancies)
• helping to trace the mapping, particularly in regard to the non-exact mappings, and supporting search for possible better matching newly introduced Wikidata items

Report	load query and execute
Full mapping, with relation types (sort by relation type to spot missing ones)	wikidata_mapping
Single value violations (multiple exact matches from an item)	exact_single_violations
Distinct values violations (multiple exact matches to different items)	exact_distinct_violations
Multiple ID values per item (which may or may not indicate an error)	multiple_id_values
Same ID value in different items (which may or may not indicate an error)	same_id_value
All non-exact relationships, with a link to search Wikidata for possible newly introduced better matches	inexact_wikidata_mapping

Note:

• Currently, only STW sub-thesaurus G (geographic names) is mapped to Wikidata. Jneubert (talk) 15:23, 6 November 2017 (UTC)
• Mapping of STW sub-thesaurus W (Economic sectors) is now on the way. Jneubert (talk) 07:08, 29 August 2018 (UTC)
• Mapping of STW sub-thesaurus P (Products) and STW sub-thesaurus B (Business Economics) is now mostly done. Jneubert (talk) 13:40, 14 December 2022 (UTC)
• Mapping of STW is finished by STW-Release V9.16 --Agruetzner (talk) 08:25, 7 December 2023 (UTC)