Property talk:P4293

From Wikidata
Jump to navigation Jump to search


PM20 folder ID
identifier for a folder in the ZBW Pressemappe 20. Jahrhundert (20th century press archive)
Represents20th century press archives (Q36948990)
Data typeExternal identifier
Domaintopics, events, persons, companies and goods (note: this should be moved to the property statements)
Allowed values(pe|co)\/\d{6}|(sh|wa)\/\d{6},\d{6}
ExampleWerner Heisenberg (Q40904)pe/007478
British Broadcasting Corporation (Q9531)co/002772
petroleum in the United States (Q7178964)wa/142108,141653
Baghdad Railway (Q639128)sh/141113,161612
External linksUse in sister projects: [ar][de][en][es][fr][he][it][ja][ko][nl][pl][pt][ru][sv][vi][zh][commons][species][wd].
Formatter URL$1
Robot and gadget jobsMapping from GND ID (P227) will be possible for persons and corporations when and is supplemented with the folder ID.
Tracking: usageCategory:Pages using Wikidata property P4293 (Q56249135)
Proposal discussionProposal discussion
Current uses13,690
Search for values
[create Create a translatable help page (preferably in English) for this property to be included here]
Single value: this property generally contains a single value. (Help)
Exceptions are possible as rare values may exist. Known exceptions: Dardanelles (Q6514), Österreichische Bundesbahnen (Q83822), Heinrich Schnee (Q84904), ZBW - Leibniz Information Centre for Economics (Q317179), Reichsbank (Q560183), Baghdad Railway (Q639128)
List of this constraint violations: Database reports/Constraint violations/P4293#Single value, SPARQL, SPARQL (new)
Distinct values: this property likely contains a value that is different from all other items. (Help)
Exceptions are possible as rare values may exist. Known exceptions: British Airways (Q8766)
List of this constraint violations: Database reports/Constraint violations/P4293#Unique value, SPARQL (every item), SPARQL (by value), SPARQL (new)
Format “(pe|co)\/\d{6}|(sh|wa)\/\d{6},\d{6}: value must be formatted using this pattern (PCRE syntax). (Help)
List of this constraint violations: Database reports/Constraint violations/P4293#Format, hourly updated report, SPARQL, SPARQL (new)
Scope is as main value (Q54828448), as references (Q54828450): the property must be used by specified way only (Help)
List of this constraint violations: Database reports/Constraint violations/P4293#scope, hourly updated report, SPARQL, SPARQL (new)
Item “instance of (P31): Items with this property should also have “instance of (P31)”. (Help)
Exceptions are possible as rare values may exist.
List of this constraint violations: Database reports/Constraint violations/P4293#Item P31, search, SPARQL, SPARQL (new)
Pictogram voting comment.svg Check item with `pe` prefix
Violations query: SELECT ?item ?value { ?item wdt:P4293 ?value. BIND (SUBSTR(?value, 1, 2) AS ?prefix). FILTER (?prefix IN ("pe")). FILTER NOT EXISTS { ?item wdt:P31 wd:Q5. } FILTER NOT EXISTS { ?item wdt:P214 ?viaf. } FILTER NOT EXISTS { ?item wdt:P227 ?Normdatei. } FILTER NOT EXISTS { ?item wdt:P31/wdt:P279* wd:Q8436. } }
List of this constraint violations: Database reports/Complex constraint violations/P4293#Check item with `pe` prefix

Count folder IDs by type[edit]

select (str(count(distinct ?pm20Id)) as ?idCount) ?type
where {
  ?wd wdt:P4293 ?pm20Id .
  bind(substr(?pm20Id, 0, 3) as ?type)
group by ?type
order by ?type

Try it!

Suggestion for inexactly matching companies / institutions[edit]

Having a look into the Mix-n-match catalogs for international and German PM20 company folders, there are several automatically suggested matches which don't match exactly the proposed Wikidata item. Just two examples from the top of the latter list:

Simply adding the external identier to the items would conflict with the actual definition of these items. On the other hand, just removing the proposed links would be a waste: The material in the PM20 folders could be helpful for Wikipedia authors (the according WP articles have sections about the history of the company or the building). Furthermore, when later-on an exactly matching item for the former company is created, a link could be moved to that item.

So the suggestion is to add the exernal identifier for the PM20 folder with the mapping relation type (P4390) qualifier related match (Q39894604). In a later step (after working through the M-n-m catalogs in order to identify and map all existing items), missing company items can be generated automatically from PM20 metadata (to which I have access). That should include items for all companies for which only a "related" item exists. These items will show up in the constraint violation list and/or with a specific query and can be manually resolved by inserting an appropriate link (e.g., predecessor/successor) between the Wikidata items and then removing the "related match" to the PM20 folder. Jneubert (talk) 08:53, 7 June 2018 (UTC)

@Xaimo, Maxwan, Karlum, Cavaliere_grande: Notifying the people who are working on the PM20 company catalogs. Jneubert (talk) 08:56, 7 June 2018 (UTC)
@Jneubert: Your proposal seems reasonable to me, that is the sort of thing we created those relation types for. ArthurPSmith (talk) 13:39, 7 June 2018 (UTC)
After having applied that pattern for some time, another use case is: a comany in PM20, with it's founder as an item in Wikidata, derived from a Wikipedia page which covers both. To keep track of the inexact assignments, I use this query:
select ?item ?itemLabel ?relation ?relationLabel ?pm20
where {
  ?item p:P4293 ?statement .
  ?statement pq:P4390 ?relation ;
             ps:P4293 ?pm20Id .
  bind(uri(concat('', ?pm20Id)) as ?pm20)
  service wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de" }
Try it! -- Jneubert (talk) 05:49, 7 August 2018 (UTC)

I like @Jneubert: suggestion to use mapping relation type (P4390) qualifier related match (Q39894604). I can use the same for many AAT matches, where AAT has "culture" whereas WD has only "peoples" or even "language". However @Magnus Manske: is there a way to support this pattern from MnM directly? Posted as --Vladimir Alexiev (talk) 11:17, 10 September 2018 (UTC)

Removed country (P17) Germany (Q183) and {Germany properties}[edit]

... because the archive is not about Germany in particular, but covers multiple countries and international topics - see en:20th_Century_Press_Archives. (Pinging @Thierry_Caro:, who had added the property.) Jneubert (talk) 16:20, 17 July 2018 (UTC)

country (P17) is used on many properties that are in the same situation. Thierry Caro (talk) 17:52, 17 July 2018 (UTC)
I've seen examples of the property use in the template. As far as I can see, most of the properties cover specifics of Germany (politicans, athletes, railway stations, etc.), and country (P17) makes sense there. But take the id of the Animal sound archive in Berlin Tierstimmenarchiv ID (P5397) - the very first example for the property is about the Bornean orangutan (Q599672). So the relation to Germany seems to be only by seat and by history of the institution, and that is covered completely in the related item Animal Sound Archive (Q2432535) for the institution. Jneubert (talk) 18:27, 18 July 2018 (UTC)