Property talk:P2580

From Wikidata
Jump to navigation Jump to search

Documentation

Baltisches Biographisches Lexikon digital ID
person's ID at Baltisches Biographisches Lexikon digital encyclopedia (former scheme)
RepresentsBaltisches Biographisches Lexikon digital ID (Q52148147)
Data typeExternal identifier
Domain
According to this template: human (Q5)
According to statements in the property:
human (Q5) and family (Q8436)
When possible, data should only be stored as statements
Allowed values[A-Za-z0-9][-.0-9A-Za-z]{1,}
ExampleWilhelm Ostwald (Q12658) → Ostwald-Wilhelm-Friedrich-1853-1932
Sourcehttp://bbl-digital.de/
Robot and gadget jobsMy bot can import values from Wikipedias
Related to countryFlag of Germany.svg Germany (Q183) (See 27 others)
Lists
Proposal discussionProperty proposal/Archive/45#P2580
Current uses4,325
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 this constraint violations: Database reports/Constraint violations/P2580#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value), SPARQL (new)
Single value: this property generally contains a single value. (Help)
List of this constraint violations: Database reports/Constraint violations/P2580#Single value, hourly updated report, SPARQL, SPARQL (new)
Type “human (Q5), family (Q8436): element must contain property “instance of (P31)” with classes “human (Q5), family (Q8436)” or their subclasses (defined using subclass of (P279)). (Help)
Exceptions are possible as rare values may exist.
List of this constraint violations: Database reports/Constraint violations/P2580#Type Q5, Q8436, SPARQL, SPARQL (new)
Conflicts with “instance of (P31): Wikimedia disambiguation page (Q4167410): this property must not be used with the listed properties and values. (Help)
List of this constraint violations: Database reports/Constraint violations/P2580#Conflicts with P31, hourly updated report, search, SPARQL, SPARQL (new)
Format “[A-Za-z][-.0-9A-Za-z]{1,}”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist.
List of this constraint violations: Database reports/Constraint violations/P2580#Format, SPARQL, SPARQL (new)
This property is being used by:

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

SPARQL[edit]

List humans having property P2580[edit]

SELECT ?human ?humanLabel ?fatherLabel ?motherLabel ?dateOfBirth ?placeOfBirthLabel ?dateOfDeath ?placeOfDeathLabel 
?bblid ?isni ?viaf ?gnd ?geni
WHERE
{
    ?human wdt:P31 wd:Q5 .      
    ?human wdt:P2580 ?bblid .     
    OPTIONAL{?human wdt:P22 ?father .}
    OPTIONAL{?human wdt:P25 ?mother .}
    OPTIONAL{?human wdt:P569 ?dateOfBirth .}
    OPTIONAL{?human wdt:P19 ?placeOfBirth .}
    OPTIONAL{?human wdt:P570 ?dateOfDeath .}
    OPTIONAL{?human wdt:P20 ?placeOfDeath .}
    OPTIONAL{?human wdt:P213 ?isni .}
    OPTIONAL{?human wdt:P214 ?viaf .}
    OPTIONAL{?human wdt:P227 ?gnd .}
    OPTIONAL{?human wdt:P2600 ?geni .}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} ORDER BY ?dateOfBirth

Try it!

User:TweetsFactsAndQueries, Lucas, if there are multiple ?isni then one gets two rows, do you know how one could have multiple values in one table cell? 77.180.35.91 11:07, 23 April 2018 (UTC)

GROUP BY the other variables and use GROUP_CONCAT for the columns with potential duplicate values:
SELECT
?human ?humanLabel ?fatherLabel ?motherLabel ?dateOfBirth ?placeOfBirthLabel ?dateOfDeath ?placeOfDeathLabel
(GROUP_CONCAT(DISTINCT ?bblid) AS ?bblids) (GROUP_CONCAT(DISTINCT ?isni) AS ?isnis) (GROUP_CONCAT(DISTINCT ?viaf) AS ?viafs) (GROUP_CONCAT(DISTINCT ?gnd) AS ?gnds) (GROUP_CONCAT(DISTINCT ?geni) AS ?genis)
WHERE {
    ?human wdt:P31 wd:Q5 .      
    ?human wdt:P2580 ?bblid .     
    OPTIONAL{?human wdt:P22 ?father .}
    OPTIONAL{?human wdt:P25 ?mother .}
    OPTIONAL{?human wdt:P569 ?dateOfBirth .}
    OPTIONAL{?human wdt:P19 ?placeOfBirth .}
    OPTIONAL{?human wdt:P570 ?dateOfDeath .}
    OPTIONAL{?human wdt:P20 ?placeOfDeath .}
    OPTIONAL{?human wdt:P213 ?isni .}
    OPTIONAL{?human wdt:P214 ?viaf .}
    OPTIONAL{?human wdt:P227 ?gnd .}
    OPTIONAL{?human wdt:P2600 ?geni .}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?human ?humanLabel ?fatherLabel ?motherLabel ?dateOfBirth ?placeOfBirthLabel ?dateOfDeath ?placeOfDeathLabel
ORDER BY ?dateOfBirth
Try it! --TweetsFactsAndQueries (talk) 11:15, 23 April 2018 (UTC)
Thank you! 77.180.110.58 20:43, 25 April 2018 (UTC)

List humans having property P2580 and no other identifier[edit]

# items with property P2580 and no other identifiers
SELECT ?item ?itemLabel ?value ?st
{
  {
       SELECT *
       { ?item wdt:P31 wd:Q5 .
          ?item wdt:P2580 ?value ; wikibase:identifiers 1
       }
       LIMIT 1000
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?value

Try it!

List humans having property P2580 and no ISNI[edit]

SELECT ?human ?humanLabel ?fatherLabel ?motherLabel ?dateOfBirth ?placeOfBirthLabel ?dateOfDeath ?placeOfDeathLabel 
?bblid ?isni ?viaf ?gnd ?geni
WHERE
{
    ?human wdt:P31 wd:Q5 .      
    ?human wdt:P2580 ?bblid .     
    OPTIONAL{?human wdt:P22 ?father .}
    OPTIONAL{?human wdt:P25 ?mother .}
    OPTIONAL{?human wdt:P569 ?dateOfBirth .}
    OPTIONAL{?human wdt:P19 ?placeOfBirth .}
    OPTIONAL{?human wdt:P570 ?dateOfDeath .}
    OPTIONAL{?human wdt:P20 ?placeOfDeath .}
    MINUS {?human wdt:P213 ?isni .}
    OPTIONAL{?human wdt:P214 ?viaf .}
    OPTIONAL{?human wdt:P227 ?gnd .}
    OPTIONAL{?human wdt:P2600 ?geni .}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} ORDER BY ?isni ?viaf ?dateOfBirth

Try it!

Mix'n'match[edit]

Mix'n'match catalogue[edit]

User:Jonathan Groß found you at https://tools.wmflabs.org/mix-n-match/#/catalog/317. I think I have also seen a catalog for "Baltisches Biographisches Lexikon digital ID" Property:P2580, but cannot find it at https://tools.wmflabs.org/mix-n-match/#/group/ig_identifier/ . Could you help? 77.180.35.91 12:43, 23 April 2018 (UTC)

@77.180.35.91: This - https://tools.wmflabs.org/mix-n-match/#/catalog/177 ? --Tagishsimon (talk) 13:33, 23 April 2018 (UTC)
Tagishsimon - Yes! Just a minute ago I found it at the Property page. Do you know why it is not listed at https://tools.wmflabs.org/mix-n-match/#/group/ig_identifier/order_id ? I see 169 then 182 - no 177. 77.180.35.91 13:52, 23 April 2018 (UTC)
@77.180.35.91: Seems to be filed under Biography - https://tools.wmflabs.org/mix-n-match/#/group/biography ... not clear how Magnus draws the distinction. And I lied, below, and created some more BBLIds whilst having a tea-break :) --Tagishsimon (talk) 13:56, 23 April 2018 (UTC)
Thanks for the info and turning a statement about the future into a "lie" ;-) 77.180.35.91 15:12, 23 April 2018 (UTC)

Mix'n'match create more items[edit]

User:Tagishsimon you created an item with mix'n'match and in the 4th edit added BBLd ID (P2580) [1]. Can you create more BBLd items? 77.180.35.91 13:27, 23 April 2018 (UTC)

Probably not. I mix'n'match when I've run out of inspiration. Right now busy with en.wiki stuff. Sorry. --Tagishsimon (talk) 13:33, 23 April 2018 (UTC)
Thanks! 77.180.35.91 13:52, 23 April 2018 (UTC)

Mix'n'match update connections[edit]

sync manually : https://tools.wmflabs.org/mix-n-match/#/sync/177

connections here, but not on Wikidata[edit]

Tagishsimon it says "48 connections here, but not on Wikidata" - this needs QS (QuickStatements) and Widar-login - could you do that? ""77.180.35.91 15:12, 23 April 2018 (UTC)"

@77.180.35.91: I'm not following you; where does it say that? Link please. I have Widar, so can do when I understand. Might be later tonight. Magnus has fixed the name of BBL in M'n'M. --Tagishsimon (talk) 15:54, 23 April 2018 (UTC)

Tagishsimon https://tools.wmflabs.org/mix-n-match/#/sync/177 and then click on "Update Wikidata". In the list of statements I saw some before that did not look good and work on the items manually. Now the list looks fine. Please scroll through, all items should be in the form "Abcde-Abcde optional(xyz)-YYYY-YYYY", where the last two are year of birth and of death. If there is no YYYY-YYYY please remove the statement before running the list. Please tell here when it has been done, I can then check your edit hist and click each item and try to add ISNI, GND ID, VIAF if not present. 77.180.35.91 16:44, 23 April 2018 (UTC)

@77.180.35.91: Done. I imagine it might take some time before mix-n-match updates its understanding of the situation. --Tagishsimon (talk) 16:46, 23 April 2018 (UTC)
Tagishsimon, I thought I could have a break, but then I saw you run the QS-list, so I clicked through all of them, added some more extIDs. MnM doesn't show the section "connections here, but not on Wikidata" - so I assume it means there are none. 77.180.35.91 17:50, 23 April 2018 (UTC)

Tagishsimon, can you run these:

Q36538626	P2580	"Beggrow-Hartmann-Olga-1862-1922 "
Q2646847	P2580	"Brasse-Forstmann-Alice-1903 "
Q52151754	P2580	"Behr-Helmut-1903-1981 "

I would like to know what QS does with the spaces. Yes, they are required, see

77.180.35.91 20:26, 23 April 2018 (UTC)

QS1 returns an error. QS2 trims the final space off it. You cannot put in the string by hand if there's a trailing space. So it's not right now looking good for these. --Tagishsimon (talk) 20:41, 23 April 2018 (UTC)
https://www.wikidata.org/w/index.php?title=Wikidata%3AProject_chat&type=revision&diff=668633857&oldid=668615598 --Tagishsimon (talk) 21:14, 23 April 2018 (UTC)

connections on Wikidata, but not here[edit]

Also 48, no idea what can be done. 77.180.35.91 15:12, 23 April 2018 (UTC)

User:Magnus Manske - it says "Done! 46 IDs from Wikidata not found in Mix'n'match." - How can they be transferred to MnM? 77.180.35.91 17:51, 23 April 2018 (UTC)
User:Magnus Manske - or maybe they shall be deprecated in WD because not present on site anymore - but how to find them? 77.14.46.178 00:07, 25 April 2018 (UTC)
Last update seems to have added them? --Magnus Manske (talk) 14:55, 25 April 2018 (UTC)

@Magnus Manske: - dont think so. Here's the result I got a minute ago. And what's with the Wikidata says, M'n'M says? --Tagishsimon (talk) 15:25, 25 April 2018 (UTC)

  • Done!
  • 48 IDs from Wikidata not found in Mix'n'match.
  • 6 mismatches between Wikidata and Mix'n'match
  • Enty #9929029: Wikidata says Q36538626 [Q36538626], Mix'n'match says Q36538626 [Q36538626]
  • Enty #9929033: Wikidata says Q52151754 [Q52151754], Mix'n'match says Q52151754 [Q52151754]
  • Enty #9929317: Wikidata says Q2646847 [Q2646847], Mix'n'match says Q2646847 [Q2646847]
  • Enty #9929095: Wikidata says Q52152633 [Q52152633], Mix'n'match says Q52152633 [Q52152633]
  • Enty #9929275: Wikidata says Q50641037 [Q50641037], Mix'n'match says Q50641037 [Q50641037]
  • Enty #9931863: Wikidata says Q12358822 [Q12358822], Mix'n'match says Q12358831 [Q12358831]
OK, I fiddled with the autoscraper and got ~700 new entries, but still ~30 from WD not in Mix'n'match. Not sure why. Details here. --Magnus Manske (talk) 12:52, 26 April 2018 (UTC)

Trailing space in IDs[edit]

Q36538626	P2580	"Beggrow-Hartmann-Olga-1862-1922 "
Q52152633	P2580	"Bergholz-Nikolaus-James-1902-1977 "
Q2646847	P2580	"Brasse-Forstmann-Alice-1903 "
Q52153094	P2580	"Engelhardt-Karl-1852-1930 "
Q52151754	P2580	"Behr-Helmut-1903-1981 "
Q50641037	P2580	"Bordelius-Max-v.-1886-1964 "
Fixed the IDs on Mix'n'match.--Magnus Manske (talk) 15:00, 2 May 2018 (UTC)
@Magnus Manske: - thanks, but there's still an issue, described at https://phabricator.wikimedia.org/T193214 --Tagishsimon (talk) 16:18, 2 May 2018 (UTC)

fundamental change in access URLs[edit]

Please note that the access URL has recently (2018-09-04) changed to an ISNI-derived scheme cf. bbld.de/web/aktuell. Unfortunately, no direct mapping from previous values to current ones seems to exist. -- Gymel (talk) 19:00, 12 September 2018 (UTC)

  • We already store ISNI. Please don't delete valid entries in the old format. --- Jura 19:29, 12 September 2018 (UTC)
  • Reading bbld.de/web/isni, they say that they have converted 1,153 ids to ISNI, but I'm having trouble seeing what their long-term plan is. Do they plan to change all ids to ISNI eventually? What about entries that have no ISNI equivalent? Will they maintain information on the old ids? Should we (as Jura1 suggests) stick with their old ids because storing ISNIs would be redundant for us? Is anyone in contact with bbld? According to this query, there are 109 items for which we know both BBLD and ISNI, but all but 4 appear to be post-conversion. Bovlb (talk) 15:44, 13 September 2018 (UTC)
I have no direct communications with bbld.de but have been told that the long-term plan is to convert all URLs to the ISNI-based scheme. The current situation seems to be a fluid mix of both schemes: The old "IDs" cease to exist exactly in the moment when the entry is associated with an ISNI... So I see the rise of another instance of the discussion whether Wikidata should take up the task of documenting "historic" identifiers of (still living but rather carelessly operating) external projects in order to faciliate third parties a future conversion of their link collections. -- Gymel (talk) 19:12, 13 September 2018 (UTC)
That's ... not how identifier schemes are supposed to work. :( Thanks for the explanation. Bovlb (talk) 21:58, 13 September 2018 (UTC)
  • As we already have a property for ISNI, changing some values in a random manor to ISNI seems inconsistent. We are here to provide structured data and this includes stable identifiers. It seems that some premature changes need fixing. BTW, when editing this property, please bear in mind not to help block evasion. --- Jura 08:58, 25 September 2018 (UTC)