Hello Wikicommunity, What attributes are we seeking to output , just hyperlinks? The output shall easily be In tabular format for further analysis.
~ Sikeyboi On Thu, Jun 7, 2018, 3:22 PM <[email protected]> wrote: > Send Wikidata-tech mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.wikimedia.org/mailman/listinfo/wikidata-tech > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Wikidata-tech digest..." > > > Today's Topics: > > 1. Query data type using WDQS (Thad Guidry) > 2. Re: Query data type using WDQS (Lucas Werkmeister) > 3. Re: Query data type using WDQS (Thad Guidry) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 7 Jun 2018 10:01:10 -0500 > From: Thad Guidry <[email protected]> > To: Wikidata technical discussion <[email protected]> > Subject: [Wikidata-tech] Query data type using WDQS > Message-ID: > <CAChbWaPz-8bwyKbZF1pXfcB55= > [email protected]> > Content-Type: text/plain; charset="utf-8" > > 1. Ok, after 1 hour, I have given up trying to find some good documentation > on Data Type querying with Sparql and asking for assistance from experts. > > Many properties have a Data Type locked in with URL as shown on this Wiki > maintenance page: > https://www.wikidata.org/wiki/Category:Properties_with_url-datatype > > However, I don't quite understand how to get at the Data Type itself in > Sparql ? > > https://query.wikidata.org/#%23Subproperties%20of%20URL%20%28P2699%29%0ASELECT%20DISTINCT%20%3FsubProperties%20%3FsubPropertiesLabel%20WHERE%20%7B%0A%20%20%3FsubProperties%20wdt%3AP1647%2a%20wd%3AP2699.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D > > 2. Should equivalent property < > https://www.wikidata.org/wiki/Property:P1628> > and equivalent class <https://www.wikidata.org/wiki/Property:P1709> both > be > a subproperty of URL (I have applied this assumption to both, but wondering > if I might have missed some other way of expressing that or if not needed > since the Data Type is set, but having difficulty querying that in 1.) > > I'm looking to query subjects having a statement where the property is a > Data Type = URL and filtered by contains("world") (don't ask why, hahaha) > > Thanks in advance for direction and help, > -Thad > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > https://lists.wikimedia.org/pipermail/wikidata-tech/attachments/20180607/96f39568/attachment-0001.html > > > > ------------------------------ > > Message: 2 > Date: Thu, 7 Jun 2018 23:28:12 +0200 > From: Lucas Werkmeister <[email protected]> > To: [email protected] > Subject: Re: [Wikidata-tech] Query data type using WDQS > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > The property type is available under the wikibase:propertyType > predicate: > > https://query.wikidata.org/#%23Subproperties%20of%20URL%20%28P2699%29%0ASELECT%20DISTINCT%20%3FsubProperties%20%3FsubPropertiesLabel%20%3FpropertyType%20WHERE%20%7B%0A%20%20%3FsubProperties%20wdt%3AP1647%2a%20wd%3AP2699%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3ApropertyType%20%3FpropertyType.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D > > Cheers, Lucas > > On 07.06.2018 17:01, Thad Guidry wrote: > > 1. Ok, after 1 hour, I have given up trying to find some good > > documentation on Data Type querying with Sparql and asking for > > assistance from experts. > > > > Many properties have a Data Type locked in with URL as shown on this > > Wiki maintenance page: > > https://www.wikidata.org/wiki/Category:Properties_with_url-datatype > > > > However, I don't quite understand how to get at the Data Type itself > > in Sparql ? > > > https://query.wikidata.org/#%23Subproperties%20of%20URL%20%28P2699%29%0ASELECT%20DISTINCT%20%3FsubProperties%20%3FsubPropertiesLabel%20WHERE%20%7B%0A%20%20%3FsubProperties%20wdt%3AP1647%2a%20wd%3AP2699.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D > > > > 2. Should equivalent property > > <https://www.wikidata.org/wiki/Property:P1628> and equivalent class > > <https://www.wikidata.org/wiki/Property:P1709> both be a subproperty > > of URL (I have applied this assumption to both, but wondering if I > > might have missed some other way of expressing that or if not needed > > since the Data Type is set, but having difficulty querying that in 1.) > > > > I'm looking to query subjects having a statement where the property is > > a Data Type = URL and filtered by contains("world") (don't ask why, > > hahaha) > > > > Thanks in advance for direction and help, > > -Thad > > > > > > _______________________________________________ > > Wikidata-tech mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/wikidata-tech > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > https://lists.wikimedia.org/pipermail/wikidata-tech/attachments/20180607/b7b4e1bf/attachment-0001.html > > > > ------------------------------ > > Message: 3 > Date: Thu, 7 Jun 2018 17:16:19 -0500 > From: Thad Guidry <[email protected]> > To: Wikidata technical discussion <[email protected]> > Subject: Re: [Wikidata-tech] Query data type using WDQS > Message-ID: > <CAChbWaN7J_69Kk8ZE6UkSMh1zk1xTk0= > [email protected]> > Content-Type: text/plain; charset="utf-8" > > Thanks Lucas ! > > With that I was able to find and tweak another example ( since you showed > me it's a wikibase parameter itself ! thanks so much !) > > This gives me my list of all the Properties that are of " propertyType > wikibase: Url " > > > https://query.wikidata.org/#%23Properties%20of%20type%20URL%0A%23%20Make%20a%20list%20of%20properties%20of%20the%20type%20Url%0ASELECT%20%3Fproperty%20%3FpropertyLabel%20%3FpropertyDescription%20WHERE%20%7B%0A%20%20%3Fproperty%20wikibase%3ApropertyType%20wikibase%3AUrl%20.%0A%09SERVICE%20wikibase%3Alabel%20%7B%0A%09%09bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%09%7D%20%20%20%20%20%20%20%20%20%20%0A%7D%20ORDER%20BY%20%3FpropertyLabel > > > On Thu, Jun 7, 2018 at 4:28 PM Lucas Werkmeister <[email protected] > > > wrote: > > > The property type is available under the wikibase:propertyType predicate: > > > https://query.wikidata.org/#%23Subproperties%20of%20URL%20%28P2699%29%0ASELECT%20DISTINCT%20%3FsubProperties%20%3FsubPropertiesLabel%20%3FpropertyType%20WHERE%20%7B%0A%20%20%3FsubProperties%20wdt%3AP1647%2a%20wd%3AP2699%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3ApropertyType%20%3FpropertyType.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D > > Cheers, Lucas > > > > > > On 07.06.2018 17:01, Thad Guidry wrote: > > > > 1. Ok, after 1 hour, I have given up trying to find some good > > documentation on Data Type querying with Sparql and asking for assistance > > from experts. > > > > Many properties have a Data Type locked in with URL as shown on this Wiki > > maintenance page: > > https://www.wikidata.org/wiki/Category:Properties_with_url-datatype > > > > However, I don't quite understand how to get at the Data Type itself in > > Sparql ? > > > > > https://query.wikidata.org/#%23Subproperties%20of%20URL%20%28P2699%29%0ASELECT%20DISTINCT%20%3FsubProperties%20%3FsubPropertiesLabel%20WHERE%20%7B%0A%20%20%3FsubProperties%20wdt%3AP1647%2a%20wd%3AP2699.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D > > > > 2. Should equivalent property > > <https://www.wikidata.org/wiki/Property:P1628> and equivalent class > > <https://www.wikidata.org/wiki/Property:P1709> both be a subproperty of > > URL (I have applied this assumption to both, but wondering if I might > have > > missed some other way of expressing that or if not needed since the Data > > Type is set, but having difficulty querying that in 1.) > > > > I'm looking to query subjects having a statement where the property is a > > Data Type = URL and filtered by contains("world") (don't ask why, > hahaha) > > > > Thanks in advance for direction and help, > > -Thad > > > > > > _______________________________________________ > > Wikidata-tech mailing [email protected]:// > lists.wikimedia.org/mailman/listinfo/wikidata-tech > > > > > > _______________________________________________ > > Wikidata-tech mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/wikidata-tech > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > https://lists.wikimedia.org/pipermail/wikidata-tech/attachments/20180607/7952f17f/attachment.html > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Wikidata-tech mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikidata-tech > > > ------------------------------ > > End of Wikidata-tech Digest, Vol 62, Issue 2 > ******************************************** >
_______________________________________________ Wikidata-tech mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
