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/ PREFIX wdt: http://www.wikidata.org/prop/direct/ PREFIX wikibase: http://wikiba.se/ontology# PREFIX p: http://www.wikidata.org/prop/ PREFIX v: http://www.wikidata.org/prop/statement/ PREFIX q: http://www.wikidata.org/prop/qualifier/ PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
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 https://docs.google.com/spreadsheets/d/1Sw8UE-cZyvnKuTmzrlpzHDdzMfg0doj83GhUpwQ1SkI/edit?usp=sharing 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 http://pic.nypl.org*
On Fri, Aug 11, 2017 at 12:48 PM, Magnus Sälgö salgo60@msn.com wrote:
If you expect an answer please express what your problem is better
I checked https://www.wikidata.org/wiki/Q6272416 Jonathan Allen - Wikidata https://www.wikidata.org/wiki/Q6272416 Language Label Description Also known as; English: Jonathan Allen. English artist www.wikidata.org
and I can see Photographers' Identities Catalog ID https://www.wikidata.org/wiki/Property:P2750
I do a query then I find them
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
*From:* Wikidata wikidata-bounces@lists.wikimedia.org on behalf of David Lowe davidlowe@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 http://pic.nypl.org*
On Thu, Aug 10, 2017 at 11:10 AM, Jane Darnell jane023@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@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 http://pic.nypl.org*
On Thu, Aug 10, 2017 at 9:57 AM, Jane Darnell jane023@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
On Thu, Aug 10, 2017 at 9:47 AM, David Lowe davidlowe@nypl.org wrote:
So I loaded another 2500 PIC IDs yesterday, but they don't turn up in the WD Query Service results http://tinyurl.com/y8xw8mh8. 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 http://pic.nypl.org*
On Wed, Aug 9, 2017 at 2:13 PM, David Lowe davidlowe@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 http://pic.nypl.org*
On Wed, Aug 9, 2017 at 2:11 PM, Jane Darnell jane023@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@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 http://pic.nypl.org* >> >> On Wed, Aug 9, 2017 at 2:04 PM, Jane Darnell jane023@gmail.com >> wrote: >> >>> Well I just tried this and it worked with no error: >>> Q6272416 >>> P2750 "1946" >>> Q64714 P2750 "1956" >>> Q5301725 P2750 "1976" >>> Q18356603 P2750 "2010" >>> >>> On Wed, Aug 9, 2017 at 1:48 PM, David Lowe davidlowe@nypl.org >>> wrote: >>> >>>> Jane, >>>> I did, and still returned an error. Also, I TRIMed and multiplied >>>> the values by 1 in my spreadsheet to make sure they were integers. I copied >>>> the values from the spreadsheet both as a .csv and as an excel spreadsheet. >>>> I also copied into a word document to verify that there were TAB >>>> characters. It still returned an error. >>>> >>>> David >>>> >>>> >>>> *David Lowe | The New York Public Library **Specialist II, >>>> Photography Collection* >>>> >>>> *Photographers' Identities Catalog http://pic.nypl.org* >>>> >>>> On Wed, Aug 9, 2017 at 1:44 PM, Jane Darnell jane023@gmail.com >>>> wrote: >>>> >>>>> did you try it with quotes? Looks like your property is numeric, >>>>> but I think this doesn't matter for quick statements input >>>>> >>>>> On Wed, Aug 9, 2017 at 1:22 PM, David Lowe davidlowe@nypl.org >>>>> wrote: >>>>> >>>>>> Sjoerd, >>>>>> >>>>>> No these are unique identifiers in Photographers' Identities >>>>>> Catalog http://pic.nypl.org/constituents/1946. >>>>>> >>>>>> David >>>>>> >>>>>> >>>>>> *David Lowe | The New York Public Library **Specialist II, >>>>>> Photography Collection* >>>>>> >>>>>> *Photographers' Identities Catalog http://pic.nypl.org* >>>>>> >>>>>> On Wed, Aug 9, 2017 at 1:11 PM, Sjoerd de Bruin < >>>>>> sjoerddebruin@me.com> wrote: >>>>>> >>>>>>> Are these dates? Be sure to note them down in UNIX timestamp >>>>>>> format, as explained on the first version of QuickStatements. >>>>>>> >>>>>>> Op 9 aug. 2017 om 18:52 heeft David Lowe davidlowe@nypl.org >>>>>>> het volgende geschreven: >>>>>>> >>>>>>> I'm getting 100% "invalid snak." errors when I run >>>>>>> quickstatement (version 1 and 2). >>>>>>> It's been awhile since I used it, so I did a single statement, >>>>>>> which worked, then 10 or so, which also worked. I did 100 statements & spot >>>>>>> checked a couple of them, which seemed to work. I tried 500 and it didn't >>>>>>> (I hadn't noticed the error log beneath the HOWTO until this point). I >>>>>>> switched to version 2, and can't update with that either. I can manually >>>>>>> update the same records, but something's gone wrong with my use of >>>>>>> quickstatements. Magnus, someone help? >>>>>>> I'm copy & pasting from Excel: >>>>>>> >>>>>>> Q6272416 P2750 1946 >>>>>>> Q64714 P2750 1956 >>>>>>> Q5301725 P2750 1976 >>>>>>> Q18356603 P2750 2010 >>>>>>> >>>>>>> etc. >>>>>>> >>>>>>> Many thanks in advance (love this tool). >>>>>>> >>>>>>> David >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> *David Lowe | The New York Public Library **Specialist II, >>>>>>> Photography Collection* >>>>>>> >>>>>>> *Photographers' Identities Catalog http://pic.nypl.org* >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Wikidata mailing list >>>>>>> Wikidata@lists.wikimedia.org >>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Wikidata mailing list >>>>>>> Wikidata@lists.wikimedia.org >>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata >>>>>>> >>>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Wikidata mailing list >>>>>> Wikidata@lists.wikimedia.org >>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Wikidata mailing list >>>>> Wikidata@lists.wikimedia.org >>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Wikidata mailing list >>>> Wikidata@lists.wikimedia.org >>>> https://lists.wikimedia.org/mailman/listinfo/wikidata >>>> >>>> >>> >>> _______________________________________________ >>> Wikidata mailing list >>> Wikidata@lists.wikimedia.org >>> https://lists.wikimedia.org/mailman/listinfo/wikidata >>> >>> >> >> _______________________________________________ >> Wikidata mailing list >> Wikidata@lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/wikidata >> >> > > _______________________________________________ > Wikidata mailing list > Wikidata@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata > >
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
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@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
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@lists.wikimedia.org on behalf of David Lowe davidlowe@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@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@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@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@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@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@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@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@gmail.com wrote:
Well I just tried this and it worked with no error:
Q6272416 P2750 "1946"
Q64714 P2750 "1956"
Ah, Jean-Luc, of course- Thanks much! I was looking into whether the problem was my specifying English labels, but the answer was even simpler!
Best, d
*David Lowe | The New York Public Library**Specialist II, Photography Collection*
*Photographers' Identities Catalog http://pic.nypl.org*
On Fri, Aug 11, 2017 at 2:07 PM, Jean-Luc Léger jean-luc.leger@dspnet.fr wrote:
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@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
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@lists.wikimedia.org on behalf of David Lowe davidlowe@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@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@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@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@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@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@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@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@gmail.com wrote:
Well I just tried this and it worked with no error:
Q6272416 P2750 "1946"
Q64714 P2750 "1956"
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata