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 <wikidata-tech-request@lists.wikimedia.org> wrote:
Send Wikidata-tech mailing list submissions to
        wikidata-tech@lists.wikimedia.org

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
        wikidata-tech-request@lists.wikimedia.org

You can reach the person managing the list at
        wikidata-tech-owner@lists.wikimedia.org

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 <thadguidry@gmail.com>
To: Wikidata technical discussion <wikidata-tech@lists.wikimedia.org>
Subject: [Wikidata-tech] Query data type using WDQS
Message-ID:
        <CAChbWaPz-8bwyKbZF1pXfcB55=Mc3PDOcN_y3fRhMDH1H+39rw@mail.gmail.com>
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 <mail@lucaswerkmeister.de>
To: wikidata-tech@lists.wikimedia.org
Subject: Re: [Wikidata-tech] Query data type using WDQS
Message-ID: <c6bf27ea-a75c-2ed2-ba3c-50df00b1d0d7@lucaswerkmeister.de>
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
> Wikidata-tech@lists.wikimedia.org
> 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 <thadguidry@gmail.com>
To: Wikidata technical discussion <wikidata-tech@lists.wikimedia.org>
Subject: Re: [Wikidata-tech] Query data type using WDQS
Message-ID:
        <CAChbWaN7J_69Kk8ZE6UkSMh1zk1xTk0=vcEdQ+RLL4oBPqEwYg@mail.gmail.com>
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 <mail@lucaswerkmeister.de>
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 listWikidata-tech@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/wikidata-tech
>
>
> _______________________________________________
> Wikidata-tech mailing list
> Wikidata-tech@lists.wikimedia.org
> 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
Wikidata-tech@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-tech


------------------------------

End of Wikidata-tech Digest, Vol 62, Issue 2
********************************************