Dear Olaf,
I would never use SPARQL for a data manipulation like you desire. Up to the
best of my knowledge, SPARQL (even not GeoSPARQL) is not even capable of
fulfilling your needs. Simply because it can't return both a table of
results (which you probably need as you query for multiple properties) and
a single result (which would the connection of the points be).
Export your ordered results into some table or JSON file and post-process
it with some other tool/language. That is the best advice I can give you at
the moment.
Yet the simple requirement and the fact that no one was able to answer your
question within 1 day has driven my attention. So I experimented and I
think that something like the following query should give you the journey
you seek (connection of points in given order).
Why it refuses to render as a map, I don't honestly know, but might be
because the result itself is a string.
But of course, by this approach you loose all the interesting information
about the points/events. You *only *get the journey.
SELECT (concat("LINESTRING(",group_concat(?coor;separator=", "),")") AS
?journey) WITH {
SELECT DISTINCT ?coordinates WHERE {
?person wdt:P2 wd:Q9;
wdt:P106 ?dob.
FILTER(("1700-01-01"^^xsd:dateTime <= ?dob) && (?dob <
"1720-01-01"^^xsd:dateTime))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
?person wdt:P47 ?Localisation.
?Localisation wdt:P48 ?coordinates .
FILTER BOUND(?coordinates).
}
ORDER BY DESC(?dob)
} AS %q
WHERE {
INCLUDE %q
BIND((STRLEN(?coordinates)-7) AS ?len) .
BIND(SUBSTR(?coordinates,7,?len) AS ?coor).
}
Best regards
Jan
On Wed, 26 Jan 2022 at 13:55, Olaf Simons <[email protected]>
wrote:
> 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 -- [email protected]
> To unsubscribe send an email to [email protected]
>
_______________________________________________
Wikidata mailing list -- [email protected]
To unsubscribe send an email to [email protected]
