Hi David,
this query returns your missing 2606 items:
SELECT ?photographer ?pic
WHERE {
?photographer wdt:P2750 ?pic .
MINUS { ?photographer wdt:P106 wd:Q33231 }
}
Seems the problem with your query is that those persons are not
considered as photographers.
Either your query is wrong or items are missing an occupation statement.
Regards,
JL
On 2017-08-11 19:41, David Lowe wrote:
Magnus,
Jane was very helpful, and I was able to load in the ID which were
returning errors.
However, the problem now is that the query returns only ~11,000
results, though it should return nearly 14,000.
PREFIX wd: <http://www.wikidata.org/entity/ [10]>
PREFIX wdt: <http://www.wikidata.org/prop/direct/ [11]>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/ [12]>
PREFIX q: <http://www.wikidata.org/prop/qualifier/ [13]>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema# [14]>
SELECT ?photographer ?photographerLabel ?pic WHERE {
?photographer wdt:P106 wd:Q33231 .
?photographer wdt:P2750 ?pic .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
Order by ?pic
Here [15] are 2,600 items with PIC IDs in the record, but which were
not returned by the above search.
I trust this is sufficiently expressed.
d
David Lowe | The New York Public Library
_Specialist II, Photography Collection_
PHOTOGRAPHERS' IDENTITIES CATALOG [5]
On Fri, Aug 11, 2017 at 12:48 PM, Magnus Sälgö <salgo60(a)msn.com>
wrote:
> If you expect an answer please express what your problem is better
>
> I checked
https://www.wikidata.org/wiki/Q6272416 [2]
>
> Jonathan Allen - Wikidata [2]
> Language Label Description Also known as; English: Jonathan Allen.
> English artist
>
www.wikidata.org [3]
>
> and I can see Photographers' Identities Catalog ID [4]
>
> I do a query then I find them
>
>
http://tinyurl.com/ybnuf6es
>
> Regards
> Magnus Sälgö
>
> Ps. I did a video today of using QuickStatement to upload if that is
> the problem...
>
https://www.youtube.com/watch?v=m229Tmhfwn8 [1]
>
> -------------------------
>
> FROM: Wikidata <wikidata-bounces(a)lists.wikimedia.org> on behalf of
> David Lowe <davidlowe(a)nypl.org>
> SENT: Friday, August 11, 2017 6:36 PM
> TO: Discussion list for the Wikidata project.
> SUBJECT: Re: [Wikidata] quickstatements invalid snak.
>
> They still don't show up...
>
> David Lowe | The New York Public Library
> _Specialist II, Photography Collection_
>
> PHOTOGRAPHERS' IDENTITIES CATALOG [5]
> On Thu, Aug 10, 2017 at 11:10 AM, Jane Darnell <jane023(a)gmail.com>
> wrote:
>
> Well don't forget it's Wikimania and presumably there is a surge of
> edits, so there may be a longer database lag than usual.
>
> On Thu, Aug 10, 2017 at 10:27 AM, David Lowe <davidlowe(a)nypl.org>
> wrote:
>
> I was keeping an eye on errors. There were probably less than two
> dozen out of 2500, but I was hoping to look at those specifically.
> Not nearly enough to account for the difference.
> I also notice that this query returns either 11348 results, or 11349
> results at different times (I noticed that behavior yesterday, too).
>
> I wonder if the double quotes did something funny...
>
> David Lowe | The New York Public Library
> _Specialist II, Photography Collection_
>
> PHOTOGRAPHERS' IDENTITIES CATALOG [5]
> On Thu, Aug 10, 2017 at 9:57 AM, Jane Darnell <jane023(a)gmail.com>
> wrote:
>
> Did you check your output from quick statements? Sometimes quick
> statements returns errors (if the entry is invalid for any reason).
> I noticed that there were several contraints enabled for this
> property and oddly, one of the items I checked of the ones that I
> did yesterday also already had this property set (and it didn't
> work, so should probably be removed)
>
https://www.wikidata.org/wiki/Q64714 [6]
>
> On Thu, Aug 10, 2017 at 9:47 AM, David Lowe <davidlowe(a)nypl.org>
> wrote:
>
> So I loaded another 2500 PIC IDs yesterday, but they don't turn up
> in the WD Query Service results [7]. When I compare the results to
> what I have locally in my database, and spotcheck those not returned
> in this query, my PIC IDs are in fact in Wikidata.... Why am I
> getting incomplete results?
>
> David Lowe | The New York Public Library
> _Specialist II, Photography Collection_
>
> PHOTOGRAPHERS' IDENTITIES CATALOG [5]
> On Wed, Aug 9, 2017 at 2:13 PM, David Lowe <davidlowe(a)nypl.org>
> wrote:
>
> Yeah, I must have triggered something once I loaded 500 at once, as
> they worked with the integer before that... Anyway, glad to be back
> to work!
>
> d
>
> David Lowe | The New York Public Library
> _Specialist II, Photography Collection_
>
> PHOTOGRAPHERS' IDENTITIES CATALOG [5]
>
> On Wed, Aug 9, 2017 at 2:11 PM, Jane Darnell <jane023(a)gmail.com>
> wrote:
>
> I vaguely remember there was a problem if I tried to paste too many
> lines of statements. I can't remember what it was, but I could open
> more windows and run several batches at the same time
>
> On Wed, Aug 9, 2017 at 2:08 PM, David Lowe <davidlowe(a)nypl.org>
> wrote:
>
> Huh, weird... And thanks, Jane. I'll try that again.
>
> d
>
> David Lowe | The New York Public Library
> _Specialist II, Photography Collection_
>
> PHOTOGRAPHERS' IDENTITIES CATALOG [5]
> On Wed, Aug 9, 2017 at 2:04 PM, Jane Darnell <jane023(a)gmail.com>
> wrote:
>
> Well I just tried this and it worked with no error:
>
> Q6272416 P2750
> "1946"
>
> Q64714
> P2750
> "1956"