Property talk:P650
Documentation
identifier in the RKDartists database (Rijksbureau voor Kunsthistorische Documentatie)
List of violations of this constraint: Database reports/Constraint violations/P650#Unique value, SPARQL (every item), SPARQL (by value)
List of violations of this constraint: Database reports/Constraint violations/P650#single best value, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Entity types
List of violations of this constraint: Database reports/Constraint violations/P650#Item P106, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Item P21, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Item P569, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Conflicts with P4989, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Label in 'en' language, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Label in 'nl' language, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Label in 'de' language, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Label in 'fr' language, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Label in 'es' language, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Description in 'nl' language, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Label in 'pt' language, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P650#Label in 'it' language, search, SPARQL
List of works that have RKDimages ID (P350) set, but that creator doesn't have a RKDartists ID (P650) link (Help)
Violations query:
SELECT ?item ?creator { ?item p:P350 []. ?item wdt:P170/wdt:P31 wd:Q5 . FILTER NOT EXISTS { ?item wdt:P170/wdt:P650 [] } } ORDER BY ?creator
List of this constraint violations: Database reports/Complex constraint violations/P650#Works with creator missing link
People with RKDartists ID (P650) born before the year 1900, but no date of death (P570) (Help)
Violations query:
SELECT DISTINCT ?item WHERE { ?item wdt:P650 [] . ?item p:P569 ?birthclaim . MINUS { ?item p:P570 [] } ?birthclaim ps:P569 ?birth . FILTER(?birth < "+1900-00-15T00:00:00Z"^^xsd:dateTime) . } ORDER BY ?birth LIMIT 1000
List of this constraint violations: Database reports/Complex constraint violations/P650#Probably death
People with Biografisch Portaal van Nederland ID (P651) and occupation (P106) (or subclass) visual artist (Q3391743), but no RKDartists ID (P650) (Help)
Violations query:
SELECT DISTINCT ?item WHERE { ?item wdt:P651 [] . { ?item wdt:P106/wdt:P279* wd:Q3391743 . } UNION { ?item wdt:P106/wdt:P279* wd:Q5322166 } MINUS {?item wdt:P650 [] . } . # This is the exceptions list MINUS {VALUES ?item {wd:Q84841 wd:Q968254 wd:Q1433073 wd:Q2010943 wd:Q2094344 wd:Q2161324} } }
List of this constraint violations: Database reports/Complex constraint violations/P650#Biografisch Portaal artists without RKDartists
People with RKDartists ID (P650) born after 1900, but no country of citizenship (P27) (Help)
Violations query:
SELECT DISTINCT ?item WHERE { ?item wdt:P650 [] . ?item p:P569 ?birthclaim . MINUS { ?item p:P27 [] } ?birthclaim ps:P569 ?birth . FILTER(?birth > "+1900-00-00T00:00:00Z"^^xsd:dateTime) . } ORDER BY ?birth LIMIT 1000
List of this constraint violations: Database reports/Complex constraint violations/P650#20th-century artists without nationality
People with occupation (P106) but without a visual artist (Q3391743) or designer (Q5322166) profession (Help)
Violations query:
SELECT DISTINCT ?item { ?item p:P650 []. ?item p:P106 []. ?item wdt:P31 wd:Q5. MINUS { VALUES ?occ { wd:Q3391743 wd:Q5322166 } ?item wdt:P106/wdt:P279* ?occ }. } LIMIT 1000
List of this constraint violations: Database reports/Complex constraint violations/P650#No profession in visual art or design
Items with RKDartists ID (P650) with a label in either Dutch, English, German or French that looks like a disambiguation. (Help)
Violations query:
SELECT DISTINCT ?item ?label WHERE { VALUES ?lang { "de" "en" "fr" "nl" } . ?item wdt:P650 ?rkdid . ?item rdfs:label ?label . FILTER (REGEX(STR(?label), ".*\\(.*") && (!(REGEX(STR(?label), ".*\\(I.*")))) . FILTER( LANG( ?label ) = ?lang ) . } ORDER BY ?label LIMIT 1000
List of this constraint violations: Database reports/Complex constraint violations/P650#Possible disambiguation in key language label
This property is being used by:
Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.) |
|
|
Duplicates
[edit]I contacted the Netherlands Institute for Art History (Q758610) and they are going to work on resolving a number of duplicates in their collection. Multichill (talk) 12:50, 4 April 2015 (UTC)
- Starting in November 2015, an IP located at the Dutch National Library is taking care of the duplicates roughly once a week. Usually the here happen some hours (up to a couple of days) before they are reflected in the RKDartists web database. Our remaining task here is to remove the associations in Mix'n'Match by setting them to "n/a" and keep the duplicates indicated on the Mix'n'match sync page in close sync with those reported here (Keep the duplicates in exact alignment before attempting to sync Wikidata and Mix'n'match!). -- Gymel (talk) 07:42, 29 January 2016 (UTC)
- I didn't notice that ip yet Gymel. That's so nice that they're doing this on a regular basis now! Multichill (talk) 18:24, 2 February 2016 (UTC)
Constraints restored
[edit]I restored the contraints for occupation (P106), sex or gender (P21), date of birth (P569) & place of birth (P19) that were removed by Matěj Suchánek. We have 41612 items with a RKD link of which 41540 (99,83%) are humans. Only 72 items (0,17%) are not humans. That makes the human constraints quite applicable. I'm not a big fan of false positives so I added the 72 items as exceptions. I hope everyone agrees and is happy with this solution. Multichill (talk) 18:45, 2 February 2016 (UTC)
- No problem, maybe I was lazy to do this like you did. Matěj Suchánek (talk) 19:22, 2 February 2016 (UTC)
- For future reference: Download a fresh list, do a regex replace "\r\nQ" -> "]], [[Q", fix the first and last entry and paste it here.
- I also imported gender so that list should drop from about 3300 to about 330. Multichill (talk) 13:34, 7 February 2016 (UTC)
- @Multichill: What about removing item-requires-statement constraint (Q21503247): sex or gender (P21) and date of birth (P569) now that BotMultichill adds those? I guess (most of) the remaining ~2.5k simply don't have that data given at RKDartists? And those cases spam Wikidata:Database reports/Constraint violations/P650 and impede the display of labels. What do you think? --Marsupium (talk) 00:42, 11 September 2017 (UTC)
- Reports for sex or gender (P21) and date of birth (P569) are available at Wikidata:Database reports/Humans with missing claims/P650, so I have removed them as constraints what will hopefully bring the use of
{{Q}}
to Wikidata:Database reports/Constraint violations/P650. But feel free revert me! --Marsupium (talk) 17:03, 23 October 2017 (UTC)- Restored it. I generally clean it up every once in a while and keep it to zero. Some of the big imports seem to have increased the numbers a bit. I'll do some clean up in the next couple of weeks. Multichill (talk) 17:01, 24 October 2017 (UTC)
- Ok, I didn't that know you are using it actively … --Marsupium (talk) 17:02, 24 October 2017 (UTC)
- Haven't really done it for a while, User:Multichill/Humans no gender used to be empty ;-) Multichill (talk) 17:12, 24 October 2017 (UTC)
- Ok, I didn't that know you are using it actively … --Marsupium (talk) 17:02, 24 October 2017 (UTC)
- Restored it. I generally clean it up every once in a while and keep it to zero. Some of the big imports seem to have increased the numbers a bit. I'll do some clean up in the next couple of weeks. Multichill (talk) 17:01, 24 October 2017 (UTC)
- Reports for sex or gender (P21) and date of birth (P569) are available at Wikidata:Database reports/Humans with missing claims/P650, so I have removed them as constraints what will hopefully bring the use of
- @Multichill: What about removing item-requires-statement constraint (Q21503247): sex or gender (P21) and date of birth (P569) now that BotMultichill adds those? I guess (most of) the remaining ~2.5k simply don't have that data given at RKDartists? And those cases spam Wikidata:Database reports/Constraint violations/P650 and impede the display of labels. What do you think? --Marsupium (talk) 00:42, 11 September 2017 (UTC)
@Marsupium: I believe this query gives the missing exceptions for sex or gender (P21):
SELECT ?item ?itemLabel ?itemDescription ?value ?valueLabel
WHERE
{
?item wdt:P650 ?value .
FILTER NOT EXISTS { ?item wdt:P21 [] } .
FILTER NOT EXISTS { ?item wdt:P31 wd:Q5 } .
FILTER NOT EXISTS {
SELECT ?item WHERE {
wd:P650 p:P2302 ?propertyconstraint .
?propertyconstraint ps:P2302 wd:Q21503247 .
?propertyconstraint pq:P2306 wd:P21 .
?propertyconstraint pq:P2303 ?item .
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
LIMIT 1000
and this one for date of birth (P569):
SELECT ?item ?itemLabel ?itemDescription ?value ?valueLabel
WHERE
{
?item wdt:P650 ?value .
FILTER NOT EXISTS { ?item wdt:P569 [] } .
FILTER NOT EXISTS { ?item wdt:P31 wd:Q5 } .
FILTER NOT EXISTS {
SELECT ?item WHERE {
wd:P650 p:P2302 ?propertyconstraint .
?propertyconstraint ps:P2302 wd:Q21503247 .
?propertyconstraint pq:P2306 wd:P569 .
?propertyconstraint pq:P2303 ?item .
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
LIMIT 1000
Can you double check? I wonder if quickstatements works on properties too. If that's the case we could just have these queries output something we can throw in quickstatements. Also shouldn't be too hard to create queries to find exceptions that no longer need to be an exception. Multichill (talk) 17:25, 24 October 2017 (UTC)
- @Multichill: The queries look fine for me!
- Help:QuickStatements doesn't say anything about it explicitly.
- Which items do you have in mind with "exceptions that no longer need to be an exception"? --Marsupium (talk) 17:39, 24 October 2017 (UTC)
- See for example RKDimages ID (P350) for some exceptions that are actually redirects now (you might need to copy User:Multichill/common.css to see them easily) Multichill (talk) 18:43, 24 October 2017 (UTC)
- Ah, redirects, yes I see them, but there aren't any here and just two at RKDimages ID (P350). --Marsupium (talk) 00:39, 25 October 2017 (UTC)
- See for example RKDimages ID (P350) for some exceptions that are actually redirects now (you might need to copy User:Multichill/common.css to see them easily) Multichill (talk) 18:43, 24 October 2017 (UTC)
- @Multichill: I'd still prefer to use Wikidata:Database reports/Humans with missing claims/P650 and bring back
{{Q}}
s to Wikidata:Database reports/Constraint violations/P650. item-requires-statement constraint (Q21503247)s are a critical thing. :-) --Marsupium (talk) 10:24, 28 April 2018 (UTC)- You're more than welcome to help reduce the number of violations. Multichill (talk) 10:37, 28 April 2018 (UTC)
- @Multichill:
- Restarting this discussion a few years later. On an relative scale, there is still a majority of human, no problem, the constraints are mostly good ; but on a absolute scale, there is more and more exceptions. I fear, there is too much to be reasonably dealt with exception to constraint (P2303). To be honest, I'm not sure what to do ; hence why I start this discussion to gather more opinion/comment/advice/etc.
- Cheers, VIGNERON (talk) 12:18, 26 May 2024 (UTC)
https instead of http
[edit]After consulting the RKD I have changed the access mechanism from http to https. Although both work, https is the preferred one. --HarmN (talk) 12:10, 8 December 2016 (UTC)
- Good improvement. We prefer https over http too. I vaguely remember something with broken https, but all seems good now. RKDimages ID (P350) has been https for quite some time, I guess we just never switched this one. Multichill (talk) 12:40, 8 December 2016 (UTC)
Error reports removed
[edit]@Marsupium: I removed the error reports. You seem to have created the system and the only one using them. It gave the false impression that someone was actually looking at it, but it was actually not reported to anyone. If you found something in one of the RKD databases you should either report it on their site or leave a note on User talk:RKDdata. Multichill (talk) 21:55, 18 March 2018 (UTC)
- @Multichill: I think it would have been kind to discuss this beforehand or at least transfer the information for it not to get lost, I've done that now. Indeed here User talk:RKDdata can be used as well. However, I disagree on some points:
- It's perhaps mainly, but still not exclusively me who created and uses the system. And I don't see a problem in that, in fact it should be used more widely to help improve quality of external sources.
- There are the columns "Reported" etc. indicating if the data maintainer has been informed yet. I admit all those columns are all but perfect, but I'm not aware of an established better way of keeping track of issues and their processing status.
- I use the reports exactly for "report it on their site". For Getty and Sandrart.net at least it turned out it is helpful to collect the issues and not to send an email for every single one. As the issues get collected publicly and the status is noted everyone can write such an email! Feel free!
- Having the issues collected at one point helps estimating the data quality of the source of a property.
- As with RKDdata there is an account onwiki as an exception and the talk page is a viable way I don't revert the removal, still even for this case the use of the table by those finding the issues and RKDdata together appeared to me at least for some aspects superior to the talk page. I don't set my heart on those reports in that form. They are actually quite flawed. I'd be open and happy to improve the handling of issues in external sources! It would be preferable to store that information in the database directly, that might require additional properties though. Sorry for the long writing, thanks for reading and in advance for possible further input! Cheers, --Marsupium (talk) 01:52, 19 March 2018 (UTC)
Artists with multiple names (and multiple RKDartists records)
[edit]Q1392811 links to two RKDartists IDs, one of which is just a different name for the other. What would be the best way to handle this in WD? Add a single value constraint exception for this item to P650, just remove the ID that only contains the different name, or change the rank of the actual RKD artists record to preferred rank? Best,--RKDdata (talk) 12:00, 24 December 2019 (UTC)
- @RKDdata: Indeed, https://rkd.nl/nl/explore/artists/246022 is a mere redirect. Therefore this ID should be deleted from WD (RKDartists IDs is for people not redirects), and such entries should not be included in Mix-n-Match. Is there a way to recognize such entries in the RKDartists API/data export? --Vladimir Alexiev (talk) 07:01, 15 July 2020 (UTC)
- https://api.rkd.nl/api/record/artists/246022?format=json shows this. I think "label": "Zie voorkeursnaam" ("label": "See preferred name") is the signal --Vladimir Alexiev (talk) 07:09, 15 July 2020 (UTC)
"hoofdTitel": {
"kunstenaarsnaam": {
"label": "Naam",
"contents": "Joaquim Sunyer Miró"
},
"voorkeursnaam_naam": {
"label": "Zie voorkeursnaam",
"contents": "Sunyer Miró, Joaquín"
},
Single value constraint and deprecated rank
[edit]@Multichill: It seems that the single value constraint report ignores deprecated ranks (see for example Q6539264). Is there a way to fix this? --RKDdata (talk) 07:54, 27 February 2020 (UTC)
- I replaced here the constraint single-value constraint (Q19474404) with single-best-value constraint (Q52060874), that constraint checks for one best value. --Hannolans (talk) 19:56, 27 February 2020 (UTC)
- @Hannolans: Thanks for updating the constraint. However, the report still includes items where one value of P650 is set to deprecated while the other is ranked normal (see for example Q6539264 which is still in the report). Is there a way to exclude those from these reports? Best, --RKDdata (talk) 09:12, 27 May 2020 (UTC)
languages
[edit]fr was a required label language since a few days, but RKDartists website is available in english and dutch as far as I know. so removed the requirement. But RKD is not really bilingual. Names are not translated. For example "Uitgeverij Artimo" is in the english version https://rkd.nl/en/explore/artists/425067 'Uitgeverij Artimo' and not 'Artimo publishers'. Hannolans (talk) 06:14, 19 August 2022 (UTC)
- @Hannolans: this property is used 105,693 times
- The coverage of all of these is high enough to set up a constraint. The majority of items is about humans and a small part about organizations. These are all given names where unless a commonly used name exists, the label just get copied. It's not that we call the Rijksmuseum (Q190804) the "empire museum" or "state museum". I'll restore the last two as suggestions. Multichill (talk) 09:19, 21 August 2022 (UTC)
9000 verweesde personen
[edit]Mijn bot die personen voorziet van meer informatie gebaseerd op RKDartists had al een tijdje niet goed gelopen. Toen ik daarnaar keek viel met me op dat we meer dan 9000 personen hebben die alleen deze identifier hebben en geen binnenkomende link (van in totaal 104030 personen). Ik ben wel benieuwd hoe dit aantal gaat veranderen door de tijd bijvoorbeeld door het importeren van collecties die we nu nog niet hebben. Multichill (talk) 09:51, 3 September 2022 (UTC)
- De focus van collecties op Wikidata plaatsen ligt bij schilderijen. De eerste die ik klikte was een keramist. Ik ben zelf wat terughoudend om van reproducties individuele prenten en tegels etc op Wikidata te plaatsen, 'werken in collectie' is wellicht voorlopig voldoende. Binnenkort ga ik met LIMA, ZKM en IFFR aan de slag om videokunstenaars verder op Wikidata aan te vullen, ik zie dat er 900 in staan in de query. Videokunstenaars zitten echter weer niet altijd in collecties, omdat ze als filmregisseur of televisieproducent actief kunnen zijn. --Hannolans (talk) 07:28, 6 September 2022 (UTC)
434,316 records?
[edit]@RPI2026F1: 434,316 records is complete nonsense. The current number is 381608 records. You probably incorrectly included redirects. Please correct and also check other properties for which you did the same change. Multichill (talk) 21:48, 16 January 2023 (UTC)
- I'm pulling the data from the number of entries from Mix'n'Match. RPI2026F1 (talk) 00:46, 17 January 2023 (UTC)
- @RPI2026F1: I guess the number of entries contains more that just the records. Thanks for fixing it. Multichill (talk) 20:32, 18 January 2023 (UTC)
- I added a new condition where if previous entries for number of records exist and they use any source that isn't Mix'n'Match the bot won't touch those. RPI2026F1 (talk) 22:26, 18 January 2023 (UTC)
- @RPI2026F1: I guess the number of entries contains more that just the records. Thanks for fixing it. Multichill (talk) 20:32, 18 January 2023 (UTC)
vervangen door RKD research
[edit]Vandaag is RKDartists vervangen door RKD-research, de links blijken gelukkig nog gewoon te werken. Zie https://www.rkd.nl/rkd-research-is-gelanceerd Hannolans (talk) 16:24, 14 December 2023 (UTC)
- Netherlands-related properties
- All Properties
- Properties with external-id-datatype
- Properties used on 100000+ items
- Properties with format constraints
- Properties with unique value constraints
- Properties with single best value constraints
- Properties with entity type constraints
- Properties with scope constraints
- Properties with constraints on type
- Properties with constraints on items using them
- Properties with conflicts with constraints
- Properties with label language constraints
- Properties with description language constraints
- Properties with complex constraints
- Art person properties
- Authority control properties