FactGrid:Sample queries: Difference between revisions

From FactGrid
Jump to navigation Jump to search
Line 88: Line 88:


=== Lines ===
=== Lines ===
* [https://database.factgrid.de/query/index.html#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fline%22%5D%7D%0ASELECT%20*%20WHERE%20%7B%0A%20%20%3Fq%20wdt%3AP2%20wd%3AQ10671%20.%0A%20%20%3Fq%20wdt%3AP95%20%3Forigin%20.%0A%20%20%3Forigin%20wdt%3AP48%20%3FcoordO%20.%0A%20%20%3Forigin%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode1.%20%3Fvaluenode1%20wikibase%3AgeoLatitude%20%3Flat1%20.%20%3Fvaluenode1%20wikibase%3AgeoLongitude%20%3Flon1.%0A%20%20%3Fq%20p%3AP28%2Fpq%3AP29%20%3Fdest%20.%0A%20%20%3Fdest%20wdt%3AP48%20%3FcoordD%20.%0A%20%20%3Fdest%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode2.%20%3Fvaluenode2%20wikibase%3AgeoLatitude%20%3Flat2%20.%20%3Fvaluenode2%20wikibase%3AgeoLongitude%20%3Flon2.%0A%20%20BIND(geof%3Adistance(%3FcoordO%2C%20%3FcoordD)%20AS%20%3Fdist).%0A%20%20BIND(floor(%3Fdist%2F100)%20AS%20%3Flayer).%0A%20%20BIND(CONCAT('LINESTRING%20('%2C%20STR(%3Flon1)%2C%20'%20'%2C%20STR(%3Flat1)%2C%20'%2C'%2C%20STR(%3Flon2)%2C%20'%20'%2C%20STR(%3Flat2)%2C%20')')%20AS%20%3Fstr)%20.%0A%20%20BIND(STRDT(%3Fstr%2C%20geo%3AwktLiteral)%20AS%20%3Fline)%0A%7D The Illuminati correspondence, who wrote whom, from where, whereto]
* [https://database.factgrid.de/query/index.html?fbclid=IwAR29yqUCMsZsCD4caHaH475VCbMICGUUb8zdjrvQ_jDT87Nj5TQEycLDGqU&fbclid=IwAR1dIHXj94VuVG3w0RAps1QbjwFDoZ2ELfXdK61X1gptkyuR7WUZkkRWHkQ#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fline%22%5D%7D%0ASELECT%20%2a%20WHERE%20%7B%0A%20%20%3Fq%20wdt%3AP2%20wd%3AQ10671%20.%0A%20%20%3Fq%20wdt%3AP97%20wd%3AQ10677%20.%0A%20%20%3Fq%20wdt%3AP95%20%3Forigin%20.%0A%20%20%3Forigin%20wdt%3AP48%20%3FcoordO%20.%0A%20%20%3Forigin%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode1.%20%3Fvaluenode1%20wikibase%3AgeoLatitude%20%3Flat1%20.%20%3Fvaluenode1%20wikibase%3AgeoLongitude%20%3Flon1.%0A%20%20%3Fq%20p%3AP28%2Fpq%3AP29%20%3Fdest%20.%0A%20%20%3Fdest%20wdt%3AP48%20%3FcoordD%20.%0A%20%20%3Fdest%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode2.%20%3Fvaluenode2%20wikibase%3AgeoLatitude%20%3Flat2%20.%20%3Fvaluenode2%20wikibase%3AgeoLongitude%20%3Flon2.%0A%20%20BIND%28geof%3Adistance%28%3FcoordO%2C%20%3FcoordD%29%20AS%20%3Fdist%29.%0A%20%20BIND%28floor%28%3Fdist%2F100%29%20AS%20%3Flayer%29.%0A%20%20BIND%28CONCAT%28%27LINESTRING%20%28%27%2C%20STR%28%3Flon1%29%2C%20%27%20%27%2C%20STR%28%3Flat1%29%2C%20%27%2C%27%2C%20STR%28%3Flon2%29%2C%20%27%20%27%2C%20STR%28%3Flat2%29%2C%20%27%29%27%29%20AS%20%3Fstr%29%20.%0A%20%20BIND%28STRDT%28%3Fstr%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%0A%7D The Illuminati correspondence, who wrote whom, from where, whereto]




| valign="top"|
| valign="top"|
== Landkarten ==
== Landkarten ==
=== Punkte ===
=== Punkte ===

Revision as of 09:08, 29 July 2020

Help:

Map: all documents of a certain research interest, where from?



Looking for people

Search all people of the same family name, sort by given names, state everyone with information about life dates and family details. Table

Personensuche

Suche alle Personen mit demselben Familienname, sortiere nach Vornamen und gebe die Informationen über Zeitraum, Vater, Mutter, und Ehe hinzu. Tabelle

Name of people who ever were a residents of place with basic personal information. Table

Nenne alle Personen, die an einem Ort wohnhaft waren, mit biographischer Basisinformation. Tabelle

Two Persons, when and where did they meet? timeline

Zwei Personen, wann und wo sind sie sich begegnet? Zeitleiste

Looking for documents

All documents written by N.N. with corresponding documents. Table

Dokumentensuche

Alle Dokumente verfasst von N.N. mit korrespondierenden Dokumenten. Tabelle

All documents sent to N.N. with corresponding documents. Table

Alle Dokumente an N.N. mit korrespondierenden Dokumenten. Tabelle

All documents mentioning N.N. with corresponding documents. Table

Alle Dokumente, die N.N. erwähnen mit korrespondierenden Dokumenten. Tabelle

All documents of a file listed in sequence. Table

Alle Dokumente einer Akte der Reihenfolge nach. Tabelle

All documents sent from (place) by date. Table

Alle Dokumente mit demselben Absendeort chronologisch. Tabelle

All documents of a specific archive and research interest by date. Table

Alle Dokumente eines bestimmten Archivs und Forschungsinteresses chronologisch. Tabelle

Maps

Dots

All documents of a specific research interest where from? Map

All persons of a certain profession in a town Map

Lines

Landkarten

Punkte

Alle Dokumente eines bestimmten Forschungsinteresses, Ort der Abfassung Landkarte

Alle Personen einer Berufsgruppe am Ort Landkarte

Linien

Tables

  • no functional query yet, but a first attempt is here, modeled after the "academic tree" graph in Scholia's author aspect

Graphs

Timelines

Grammatically intricate searches

Looking for a statement - give it with all the qualifying statements

This search is especially useful if the data model needs to be changed. It searches the database for a particular statement and gives all the instances with the respective qualifying sub-statements: 

SELECT * WHERE {
  ?s wdt:P2 wd:Q7.
  ?s p:P266 ?st. # ?s is the the statement node
  ?st ps:P266 ?o. # that simulates the predicate
  ?st ?qualifier ?value. # this is an attribute (a qualifier)
}

Wishful thinking

Retrieved from "https://database.factgrid.de/w/index.php?title=FactGrid:Sample_queries&oldid=2773984"