[Wikidata] Re: units
Dear Olaf, look at Stack Overflow. Generics - Wikidata get all properties of an item with units - Stack Overflow https://stackoverflow.com/questions/70546557/wikidata-get-all-properties-of-an-item-with-units Le mer. 25 janv. 2023 à 11:56, John Erling Blad a écrit : > Sparql is like the secret language of the Necromongers, it is completely > incomprehensible to the uninitiated that hasn't been through the Gates of > the Underworld. > > It is perhaps the single most difficult thing to grasp for users of > Wikidata. > > ons. 25. jan. 2023, 00:32 skrev Marco Neumann : > >> Enjoy >> >> Best, >> Marco >> >> On Tue, Jan 24, 2023 at 11:30 PM Olaf Simons < >> olaf.sim...@pierre-marteau.com> wrote: >> >>> ...alles was ich machte, war mal wieder 30 mal komplizierter, >>> >>> vielen Dank! >>> Olaf >>> >>> >>> > Marco Neumann hat am 24.01.2023 23:48 CET >>> geschrieben: >>> > >>> > >>> > https://tinyurl.com/2nbqnavq >>> > ___ >>> > Wikidata mailing list -- wikidata@lists.wikimedia.org >>> > Public archives at >>> https://lists.wikimedia.org/hyperkitty/list/wikidata@lists.wikimedia.org/message/NW3SGOW6LHX3XAYMMWJZ72LDAWSJ73MU/ >>> > To unsubscribe send an email to wikidata-le...@lists.wikimedia.org >>> >>> Dr. Olaf Simons >>> Forschungszentrum Gotha der Universität Erfurt >>> Am Schlossberg 2 >>> 99867 Gotha >>> Büro: +49-361-737-1722 >>> Mobil: +49-179-5196880 >>> Privat: Hauptmarkt 17b/ 99867 Gotha >>> ___ >>> Wikidata mailing list -- wikidata@lists.wikimedia.org >>> Public archives at >>> https://lists.wikimedia.org/hyperkitty/list/wikidata@lists.wikimedia.org/message/KXGWRI3N3FYLTLSOGJ3FJ2JVKWVOHV52/ >>> To unsubscribe send an email to wikidata-le...@lists.wikimedia.org >>> >> >> >> -- >> >> >> --- >> Marco Neumann >> >> >> ___ >> Wikidata mailing list -- wikidata@lists.wikimedia.org >> Public archives at >> https://lists.wikimedia.org/hyperkitty/list/wikidata@lists.wikimedia.org/message/BSJQRJOJBG3ON747K2GNMHFSEPILOXBH/ >> To unsubscribe send an email to wikidata-le...@lists.wikimedia.org >> > ___ > Wikidata mailing list -- wikidata@lists.wikimedia.org > Public archives at > https://lists.wikimedia.org/hyperkitty/list/wikidata@lists.wikimedia.org/message/3EQ3E3FZSZYCYVEPJFVAGRQHQSGIIOYB/ > To unsubscribe send an email to wikidata-le...@lists.wikimedia.org > ___ Wikidata mailing list -- wikidata@lists.wikimedia.org Public archives at https://lists.wikimedia.org/hyperkitty/list/wikidata@lists.wikimedia.org/message/XXAZBKVJGDZU5XZJ25AILR46QNPEXHYT/ To unsubscribe send an email to wikidata-le...@lists.wikimedia.org
[Wikidata] Re: connecting coordinates
You need to have the events put in chronological order inside the database. It is not the case in the Olaf's problem because the dates come from different pages. Bruno Le 27/01/2022 à 14:48, James Heald a écrit : Agreed. I don't think it's guaranteed that the GROUP_CONCAT will respect the order of items it's given. (I believe this is a standing well-known requested feature in SPARQL circles). But yet, it seems to work. eg here's a version of the previous query, sorted by longitude https://w.wiki/4kXS and the points *do* seem to be being joined together in the right order. -- J. On 27/01/2022 13:39, Bruno BELHOSTE wrote: The real problem is how to order the events in the query according to their dates in order to draw the line from one event place to the next event place. It is clearly not easy. Best, Bruno Le 27/01/2022 à 14:04, James Heald a écrit : You're looking for a query like this one, I think https://w.wiki/4kW4 but adapted to your data. All best, James. ___ Wikidata mailing list -- wikidata@lists.wikimedia.org To unsubscribe send an email to wikidata-le...@lists.wikimedia.org ___ Wikidata mailing list -- wikidata@lists.wikimedia.org To unsubscribe send an email to wikidata-le...@lists.wikimedia.org
[Wikidata] Re: connecting coordinates
The real problem is how to order the events in the query according to their dates in order to draw the line from one event place to the next event place. It is clearly not easy. Best, Bruno Le 27/01/2022 à 14:04, James Heald a écrit : You're looking for a query like this one, I think https://w.wiki/4kW4 but adapted to your data. All best, James. On 26/01/2022 23:20, Daniel Mietchen via Wikidata wrote: Hi Olaf, you could bind the dates such that they can be used as the color layer for the dots on the map: https://tinyurl.com/y9yb6blb . This way, they are sorted in time, and you can clock your way through by looking at which dots appear or change their colour. I also looked into getting the dots connected in some way but no luck there yet. Best, Daniel On Wed, Jan 26, 2022 at 6:12 PM Olaf Simons wrote: Hi Haddad, I remain puzzled by the railway network - this is too bright for me. This search produces a person, and a series of events in chronological sequence https://tinyurl.com/ya85ymss I have no problem to get the places as dots on a map https://tinyurl.com/y997e8bc but that's not telling me how he moved... I hoped there is a nice command like bind these as sorted... Best, Olaf Haddad, TC hat am 26.01.2022 17:29 geschrieben: to join a list of points into lines, you can use LineString or MultiLineString formats: https://en.wikipedia.org/wiki/Well-known_text_representation_of_geometry presumably you would sort the points chronologically before grouping them this way to get the shape you are expecting. On Wed, Jan 26, 2022 at 4:55 AM Olaf Simons < olaf.sim...@pierre-marteau.com> wrote: [This email originated from outside of OSU. Use caution with links and attachments.] Dear all, a colleague has put data on FactGrid on a group of people travelling though early 18th-century Europe. I wonder how I could connect the geographic coordinates in their chronological order. This is the table that has the order https://tinyurl.com/ycrumyvb could somone show me how I connect the dots? much obliged, Olaf Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Am Schlossberg 2 99867 Gotha Büro: +49-361-737-1722 Mobil: +49-179-5196880 Privat: Hauptmarkt 17b/ 99867 Gotha ___ Wikidata mailing list -- wikidata@lists.wikimedia.org To unsubscribe send an email to wikidata-le...@lists.wikimedia.org ___ Wikidata mailing list -- wikidata@lists.wikimedia.org To unsubscribe send an email to wikidata-le...@lists.wikimedia.org Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Am Schlossberg 2 99867 Gotha Büro: +49-361-737-1722 Mobil: +49-179-5196880 Privat: Hauptmarkt 17b/ 99867 Gotha ___ Wikidata mailing list -- wikidata@lists.wikimedia.org To unsubscribe send an email to wikidata-le...@lists.wikimedia.org ___ Wikidata mailing list -- wikidata@lists.wikimedia.org To unsubscribe send an email to wikidata-le...@lists.wikimedia.org ___ Wikidata mailing list -- wikidata@lists.wikimedia.org To unsubscribe send an email to wikidata-le...@lists.wikimedia.org ___ Wikidata mailing list -- wikidata@lists.wikimedia.org To unsubscribe send an email to wikidata-le...@lists.wikimedia.org
Re: [Wikidata] a question of data modeling about family ties
Thank you, Lucas, for the solution! It was very simple indeed, but, shame on me, I confess I did'nt know this fundamental property path. All the best, Bruno Le 05/10/2020 à 21:36, Lucas Werkmeister a écrit : I don’t understand the problem, the query shouldn’t need to get much more complicated… what kind of query did you have in mind? Here’s a simple one for all ancestors of Frodo Baggins <https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20wd%3AQ177329%20%28wdt%3AP22%7Cwdt%3AP25%29%2a%20%3Fitem.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D>: SELECT DISTINCT ?item ?itemLabel WHERE { wd:Q177329 (wdt:P22|wdt:P25)* ?item. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } Cheers, Lucas On 05.10.20 19:10, Bruno Belhoste wrote: It works well, but it's a descendant tree (the father of Djingis Khan is not in the tree). My question is how to explore family trees in the opposite direction, I mean from children to parents, and more generally to get all the relatives of a given person. The fact that there are two different properties, one for the child-father link and one for the child-mother link, makes the query much more difficult in this case. Le 05/10/2020 à 15:58, Magnus Sälgö a écrit : Have you tested gas:traversalDirection below we follow child gas:traversalDirection "Undirected" example https://w.wiki/fDz #People related to Djingis Khan #defaultView:Graph PREFIX gas: <http://www.bigdata.com/rdf/gas#> SELECT ?item ?itemLabel ?pic ?WikiTreef ?FindAGravef ?linkTo { SERVICE gas:service { gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.SSSP" ; gas:in wd:Q720 ; gas:traversalDirection "Undirected" ; gas:out ?item ; gas:out1 ?depth ; gas:maxIterations 4 ; gas:linkType wdt:P40 . } OPTIONAL { ?item wdt:P40 ?linkTo } OPTIONAL { ?item wdt:P18 ?pic } SERVICE wikibase:label {bd:serviceParam wikibase:language "sv" } } *From:* Wikidata on behalf of Olaf Simons *Sent:* Monday, October 5, 2020 1:53 PM *To:* Discussion list for the Wikidata project. *Subject:* Re: [Wikidata] a question of data modeling about family ties Dear Wikidata list, one of our big contributors, Bruno Belhoste in Paris, just gave me a weird question which I feel I cannot answer that fast. We, FactGrid, are a Wikidata child and so it came that we adopted structures like the father/mother differentiation. Bruno's question is now whether it would not have been wise to just create just a "parent" option instead of the gender fork that splits the lineages. Let me insert his mail: > Dear Olaf, > > I have a question of data modeling in FactGrid concerning family ties. > We have one property for children (P150) and also one for siblings > (P203), but two different properties for parents: father (P141) and > mother (P142). The problem is: how can you get all the members of the > family of somebody? One have (1) to explore both the matrilinear trees > and the patrilinear trees at each generation to get all the ancestors > and (2) to get all the descents of these ancestors. It is very complex. > It would be much simpler to have only one property including the father > and the mother. > > In case we choose this solution, it would be easy to transform all the > triples with P141 or P142 into triples with the new property. What do > you think about that? Have you another solution for querying family links? > > All the best, > > Bruno I wonder what people with more data knowledge think about the proposal (which would affect just our site, not Wikidata...) (so: no worries, we can do experimental things without affecting our parent - I hesitate to speak of a father or mother - Wikidata). Best, Olaf Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Schloss Friedenstein, Pagenhaus 99867 Gotha Büro: +49-361-737-1722 Mobil: +49-179-5196880 Privat: Hauptmarkt 17b/ 99867 Gotha ___ 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
Re: [Wikidata] a question of data modeling about family ties
It works well, but it's a descendant tree (the father of Djingis Khan is not in the tree). My question is how to explore family trees in the opposite direction, I mean from children to parents, and more generally to get all the relatives of a given person. The fact that there are two different properties, one for the child-father link and one for the child-mother link, makes the query much more difficult in this case. Le 05/10/2020 à 15:58, Magnus Sälgö a écrit : Have you tested gas:traversalDirection below we follow child gas:traversalDirection "Undirected" example https://w.wiki/fDz #People related to Djingis Khan #defaultView:Graph PREFIX gas: <http://www.bigdata.com/rdf/gas#> SELECT ?item ?itemLabel ?pic ?WikiTreef ?FindAGravef ?linkTo { SERVICE gas:service { gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.SSSP" ; gas:in wd:Q720 ; gas:traversalDirection "Undirected" ; gas:out ?item ; gas:out1 ?depth ; gas:maxIterations 4 ; gas:linkType wdt:P40 . } OPTIONAL { ?item wdt:P40 ?linkTo } OPTIONAL { ?item wdt:P18 ?pic } SERVICE wikibase:label {bd:serviceParam wikibase:language "sv" } } *From:* Wikidata on behalf of Olaf Simons *Sent:* Monday, October 5, 2020 1:53 PM *To:* Discussion list for the Wikidata project. *Subject:* Re: [Wikidata] a question of data modeling about family ties Dear Wikidata list, one of our big contributors, Bruno Belhoste in Paris, just gave me a weird question which I feel I cannot answer that fast. We, FactGrid, are a Wikidata child and so it came that we adopted structures like the father/mother differentiation. Bruno's question is now whether it would not have been wise to just create just a "parent" option instead of the gender fork that splits the lineages. Let me insert his mail: > Dear Olaf, > > I have a question of data modeling in FactGrid concerning family ties. > We have one property for children (P150) and also one for siblings > (P203), but two different properties for parents: father (P141) and > mother (P142). The problem is: how can you get all the members of the > family of somebody? One have (1) to explore both the matrilinear trees > and the patrilinear trees at each generation to get all the ancestors > and (2) to get all the descents of these ancestors. It is very complex. > It would be much simpler to have only one property including the father > and the mother. > > In case we choose this solution, it would be easy to transform all the > triples with P141 or P142 into triples with the new property. What do > you think about that? Have you another solution for querying family links? > > All the best, > > Bruno I wonder what people with more data knowledge think about the proposal (which would affect just our site, not Wikidata...) (so: no worries, we can do experimental things without affecting our parent - I hesitate to speak of a father or mother - Wikidata). Best, Olaf Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Schloss Friedenstein, Pagenhaus 99867 Gotha Büro: +49-361-737-1722 Mobil: +49-179-5196880 Privat: Hauptmarkt 17b/ 99867 Gotha ___ 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