Property talk:P1679

Documentation

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

Art UK artwork ID
identifier for artworks (publicly owned oil paintings and sculptures in the UK)

Associated item	Art UK (Q7257339), Art UK (Q7257339), Art UK (Q7257339)
Applicable "stated in" value	Art UK website (Q105003187)
Data type	External identifier
Domain	According to this template: Artworks. Currently oil paintings; may in future be extended to sculptures According to statements in the property: painting (Q3305213), sculpture (Q860861), print (Q11060274), stained glass window (Q21061279) or drawing (Q93184) When possible, data should only be stored as statements
Allowed values	([0-9A-Za-z\-_]*\-\d+|[0-9A-Za-z\-]{255,255})
Example	Bacchus and Ariadne (Q1206860) → bacchus-and-ariadne-114356 Portrait of Giacomo Doria (Q7232270) → giacomo-doria-142837
Source	https://artuk.org/
Formatter URL	https://artuk.org/discover/artworks/$1
Robot and gadget jobs	It may be possible to automatically match images on Commons against images in the Your Paintings collection -- eg using the new Elog.io tool for exact copies. A group at the University of Oxford also has impressive tools for non-quite exact matches (eg different images or printings of the same picture), as well as the whole of the Your Paintings image database
Tracking: usage	Category:Pages using Wikidata property P1679 (Q45312222)
Related to country	United Kingdom (Q145) (See 325 others)
See also	Art UK artist ID (P1367), Art UK venue ID (P1602), Art UK collection ID (P1751), Art Fund artwork ID (P6576), National Trust Collections ID (P4373)
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/Complex constraint violations/P1679 Database reports/Constraint violations/P1679 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 218,082 Main statement 215,916 out of 304,077 (71% complete) 99% of uses Qualifier 2 <0.1% of uses Reference 2,164 1% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Format “([0-9A-Za-z\-_]*\-\d+|[0-9A-Za-z\-]{255,255})”: value must be formatted using this pattern (PCRE syntax). (Help)

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

Distinct values: this property likely contains a value that is different from all other items. (Help)

List of violations of this constraint: Database reports/Constraint violations/P1679#Unique value, hourly updated report, 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: Q18542919, Q18542921, Q18542925, Q18542928, Q18542929, Q18542931, Q18542932, Q18542934, Q18542937, Q18542939, Q18542943, Q18542948, Q18542959, Q18542972, Q18542983, Q18542984, Q18542985, Q18542989, Q18542990, Q18542991, Q18542994, Q18542997, Q18542998, Q18543000, Q18543001, Q18543003, Q18543004, Q18543013, Q18543014, Q18543019, Q18543205, Q18543206, Q18543210, Q18543211, Q18543614, Q18543627, Q18543640, Q18543642, Q28048726
List of violations of this constraint: Database reports/Constraint violations/P1679#Single value, 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/P1679#Entity types

Type “painting (Q3305213), sculpture (Q860861), print (Q11060274), stained glass window (Q21061279), drawing (Q93184)”: item must contain property “instance of (P31)” with classes “painting (Q3305213), sculpture (Q860861), print (Q11060274), stained glass window (Q21061279), drawing (Q93184)” or their subclasses (defined using subclass of (P279)). (Help)

List of violations of this constraint: Database reports/Constraint violations/P1679#Type Q3305213, Q860861, Q11060274, Q21061279, Q93184, hourly updated report, SPARQL

Item “creator (P170)”: Items with this property should also have “creator (P170)”. (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/P1679#Item P170, search, SPARQL

Item “location (P276)”: Items with this property should also have “location (P276)”. (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/P1679#Item P276, search, SPARQL

Item “inception (P571)”: Items with this property should also have “inception (P571)”. (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/P1679#Item P571, SPARQL

Item “title (P1476)”: Items with this property should also have “title (P1476)”. (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/P1679#Item P1476, SPARQL

Item “made from material (P186)”: Items with this property should also have “made from material (P186)”. (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/P1679#Item P186, search, SPARQL

Item “genre (P136)”: Items with this property should also have “genre (P136)”. (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/P1679#Item P136, search, SPARQL

Item “height (P2048)”: Items with this property should also have “height (P2048)”. (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/P1679#Item P2048, SPARQL

Item “width (P2049)”: Items with this property should also have “width (P2049)”. (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/P1679#Item P2049, 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/P1679#Scope, SPARQL

Item “depicts (P180)”: Items with this property should also have “depicts (P180)”. (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/P1679#Item P180, search, SPARQL

Item “copyright status (P6216)”: Items with this property should also have “copyright status (P6216)”. (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/P1679#Item P6216, search, SPARQL

Item “collection (P195)”: Items with this property should also have “collection (P195)”. (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/P1679#Item P195, search, SPARQL

Item “inventory number (P217)”: Items with this property should also have “inventory number (P217)”. (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/P1679#Item P217, search, SPARQL

Label required in languages: en: Entities using this property should have labels in one of the following languages: en (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/P1679#Label in 'en' language, search, SPARQL

Description required in languages: en: Entities using this property should have descriptions in one of the following languages: en (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/P1679#Description in 'en' language, search, SPARQL

Pattern ^([a-z0-9\-]+\-\d+)/(view_as|search)/.+$ will be automatically replaced to \1. Testing: TODO list

Items with creator not linked to Art UK artist ID
Items that have creator (P170), but that item doesn't have Art UK artist ID (P1367). Missing link can probably be added (Help)
Violations query: SELECT DISTINCT ?item ?creator { ?item wdt:P1679 ?value ; wdt:P170 ?creator . ?creator wdt:P31 [] . MINUS { ?creator wdt:P1367 [] } } LIMIT 500
List of this constraint violations: Database reports/Complex constraint violations/P1679#Items with creator not linked to Art UK artist ID

Items with collection not linked to Art UK collection/venue ID
Items that have collection (P195), but that item doesn't have a Art UK venue ID (P1602) or Art UK collection ID (P1751) statement. Missing link can probably be added (Help)
Violations query: SELECT DISTINCT ?item ?collection { ?item wdt:P1679 ?value . ?item wdt:P195 ?collection . MINUS { ?collection wdt:P1602 [] } MINUS { ?collection wdt:P1751 [] } } LIMIT 500
List of this constraint violations: Database reports/Complex constraint violations/P1679#Items with collection not linked to Art UK collection/venue ID

Items with location not linked to Art UK venue ID
Items that have location (P276), but that item doesn't have a Art UK venue ID (P1602) statement. Missing link can probably be added (Help)
Violations query: SELECT DISTINCT ?item ?location { ?item wdt:P1679 ?value . ?item wdt:P276 ?location . MINUS { ?location wdt:P1602 [] } } LIMIT 500
List of this constraint violations: Database reports/Complex constraint violations/P1679#Items with location not linked to Art UK venue ID

Sculptures too in the future

Announcing our new sculpture project. Let's wait with updating the constraints until we have sculptures to link to. Multichill (talk) 19:12, 21 June 2017 (UTC)

Ok, https://artuk.org/discover/artworks/view_as/grid/search/work_type:sculpture is filling up. Type constraint has been update to also include sculptures. Multichill (talk) 16:38, 22 February 2019 (UTC)

Adding a lot of missing links

I kind of forgot I had a bot to import links. We currently have 8200 links, let's how much that will be after import. This query shows interesting collections that have artworks that miss a link. If it doesn't have the Art UK collection ID (P1751) you can try to find it on the ART UK website (see Property talk:P1751#list of collections for some pointers). Multichill (talk) 20:32, 23 April 2018 (UTC)

Duplicates because of identifier change

Art UK made the (not so wise) decision to include the url that also includes the identifier. Every once in a while they update a title and the url breaks, but the identifier stays the same. I made a query to find these duplicates:

SELECT ?identifier (COUNT(?item) AS ?count) (GROUP_CONCAT(STR(?item)) AS ?item) (GROUP_CONCAT(STR(?value)) AS ?value) WHERE {
	?item wdt:P1679 ?value .
  BIND(REPLACE(?value, "^.*-(\\d+)$", "$1") AS ?identifier)
} GROUP BY ?identifier 
HAVING (?count > 1)
ORDER BY DESC(?identifier)
LIMIT 100

Try it!

It also contains the normal duplicates. Query could probably be improved and set up as an advanced constraint. Normally I would keep the old identifier around with a deprecated rank because it might show up in other datasets. This case it's slightly different with changes for example (on St Bartholomew (Q50813709)) from "st-bartholomew-5735" to "saint-bartholomew-5735". The integer part ("5735" in the example) stays the same so I don't think it worth keeping around. Any opinions on this? Multichill (talk) 15:03, 25 May 2023 (UTC)

I agree the old ID is not worth keeping. More importantly, we need to merge the duplicates.

• Your query (without limit) shows 657 duplicates.
• In most cases the count is 2, except there are a few rows with 3+3+4.
• Of these multiple duplicates, only these are not obviously the same: "charles-beale-the-younger-247698" vs "bartholomew-beale-247698"

So, should I write a batch to merge them?

• Is it safe to take the Art UK ID from the newest item WD, and discard any other values?
• I checked 4 cases, and that was true for them (older Art UK IDs lead to error 404)

Vladimir Alexiev (talk) 12:34, 18 November 2023 (UTC)

Incoming!

At the hackathon I discussed importing all art uk paintings with @Mike Peel, Spinster, Husky, Fuzheado: (described more in general at Wikidata talk:WikiProject sum of all paintings#Syndication of other online catalogs). People were in favor so I implemented it. Bot logic:

• The bot works from old to new
• Preventing duplicates is done based on this identifier (Art UK artwork ID (P1679)). I already matched up a lot of collections a long time ago. I'll have another look what is missing
• If the entry links to an artist and we have an Wikidata item for that artist using the same Art UK artist ID (P1367), it will be added as creator (P170)
• If the entry links to a collection and we have an Wikidata item for that collection using the same Art UK collection ID (P1751), it will be added as collection (P195) (and as qualifier to inventory number (P217))
• If the entry links to a venue and we have an Wikidata item for that venue using the same Art UK venue ID (P1602), it will be added as location (P276) and as collection (P195) (and as qualifier to inventory number (P217))

You can of course help adding the different missing Art UK identifiers to (possible new) items. In the next pass the bot will pick them up. The collection/venue logic used by Art UK might cause some issues (for example with National Trust locations). Let's see how that works out. I still have to expand the time logic a bit more so inception (P571) will be added in more cases. We currently have about 40K out of a total of 215K paintings so it might take some time. I'll probably let it run a bit more and than have a break so I can see if I get any feedback which I can use to improve future imports. Multichill (talk) 15:37, 25 May 2023 (UTC)

Query https://w.wiki/6kiS for the existing items to check. Multichill (talk) 17:08, 25 May 2023 (UTC)

• https://w.wiki/6p74 item pairs that have the same inventory number (P217) in the same collection (P195), first item has Art UK artwork ID (P1679), second doesn't. Likely duplicates that can be merged
• https://w.wiki/6p75 item pairs that have the same inventory number (P217) in the same collection (P195), both have Art UK artwork ID (P1679), but these are different. Likely duplicates that can be merged
  • https://w.wiki/6syG better version. Multichill (talk) 18:45, 26 June 2023 (UTC)

Multichill (talk) 09:17, 10 June 2023 (UTC)

Missing collection

https://w.wiki/6qB3 gives a list of collections that could be matched. That's because no item exists with the relevant Art UK venue ID (P1602) or Art UK collection ID (P1751). Help appreciated. Multichill (talk) 21:38, 14 June 2023 (UTC)

Images

We currently have 3700 art uk images on Commons that should be linked to Wikidata. Multichill (talk) 19:50, 19 June 2023 (UTC)

Portraits

Did a query to find possible portraits. It currently returns 16.000 suggestions and the number of false positives seems to be low. Not sure yet how to process them. Multichill (talk) 19:53, 20 June 2023 (UTC)

Here is a simpler regex: \\(\\d{4}–\\d{4}\\) .

Yours finds one more row because it can match more than 4 digits.

The count is now 17k. Vladimir Alexiev (talk) 12:42, 18 November 2023 (UTC)

Missing creator

https://w.wiki/6syX gives a list of painters that could be matched to Art UK artist ID (P1367). Multichill (talk) 19:05, 26 June 2023 (UTC)

Over 215K paintings linking to Art UK

Hi everyone, we now have over 215.000 paintings linking to Art UK. The power of Wikidata is providing context so the more linked these items are, the more useful these are. I hope people are willing to help improve this data. Some suggestions on how to help:

• Match missing Art UK artist ID (P1367) to add missing creator (P170) (see above).
• Match missing Art UK venue ID (P1602) or Art UK collection ID (P1751) to add missing collection (P195) and UEFA player ID (P2276) (see above)
• Add missing genre (P136). See top genres for what to add. Especially portrait (Q134307) and religious art (Q2864737) open up possibilities to add context. See Art UK possible portraits for suggestions
• Adding main subject (P921) to portraits to link it to the person in it. If a painting with the same label exists, it will show up in this list as a suggestion. For unknown people we have this list of suggestions.
• Adding main subject (P921) to religious art is much easier with this report

Some of these reports are not specific to Art UK, but can easily be forked to have a version specific for Art UK. Plenty of other things to do too. Who wants to help? Pinging some people who I think might be interested in this. Multichill (talk) 10:16, 1 July 2023 (UTC) @Mike Peel, Jheald, PKM, Vicarage, Ham II, Richard Nevell:

I’m over-committed, but I can help as time permits. Great project! PKM (talk) 20:20, 1 July 2023 (UTC)

Very interesting, I'll start chipping away where I can! One question as this stage: should UEFA player ID (P2276) mentioned above be location (P276)? Richard Nevell (talk) 19:31, 3 July 2023 (UTC)

@Richard Nevell: UEFA player ID (P2276)? Multichill (talk) 17:51, 5 July 2023 (UTC)

Two follow-up questions from having looked at a portrait:

1. What should we use as a reference for the genre? For Robert Dudley (1532–1588), Earl of Leicester (Q118875532) I've gone to the Art UK link and from looking at it, the painting is clearly a portrait because it depicts a man. There isn't a written statement on the page that it is a portrait, so is it ok to use the Art UK website as the reference?
2. main subject (P921) is suggested above, but the item documentation advises depicts (P180). Should both be used or is one or the other preferred, and under what circumstances?

Richard Nevell (talk) 19:36, 3 July 2023 (UTC)

You might not have a source, but that doesn't mean you can't add it. Art UK website doesn't state it, so it isn't a valid source to support the statement

Not sure what documentation you refer to. main subject (P921) is generally a single statement, Robert Dudley, 1st Earl of Leicester (Q318017) in this case. depicts (P180) is for all the things depicted, so in this case for example Robert Dudley, 1st Earl of Leicester (Q318017), man (Q8441), dog (Q144), etc. Multichill (talk) 17:51, 5 July 2023 (UTC)

I see, I understand the distinction now. The documentation I referred to is at Property talk:P1679#Documentation; one of the conditions is that "Item “depicts (P180)”: Items with this property should also have “depicts (P180)”", but it doesn't mention main subject (P921). The way you've explained it is clear. Richard Nevell (talk) 19:22, 5 July 2023 (UTC)

@Multichill: Just to say thanks for doing the upload, it's already coming in useful! Thanks. Mike Peel (talk) 19:15, 7 July 2023 (UTC)

@Multichill: Nice import indeed and I did follow-up by adding some images from Commons, as well as matching some missing venues I encountered. Maybe some improvements could be done with creator (P170) statements: this list for examples would have mostly "untrue" statements backed by "made-up references", in the sense that the source claims the opposite of what you add (i.e. that the artwork was not actually created by that artist). The same thing could apply to other qualifiers (after, style of, ...), though they are less definitive. --Nono314 (talk) 08:54, 9 July 2023 (UTC)

Formatter url

@Trzęsacz: what are you trying to do? A http url (instead of https) doesn't seem right in this day and age. Multichill (talk) 22:36, 1 July 2023 (UTC)