https://wiki.dh-minor.org/index.php?action=history&feed=atom&title=Agenda_for_17_March_2018
Agenda for 17 March 2018 - Revision history
2026-06-01T20:20:50Z
Revision history for this page on the wiki
MediaWiki 1.31.0
https://wiki.dh-minor.org/index.php?title=Agenda_for_17_March_2018&diff=1363&oldid=prev
FF: created page
2018-04-10T20:08:07Z
<p>created page</p>
<p><b>New page</b></p><div>__NOTOC__<br />
== Agenda for today's lecture ==<br />
<br />
* [https://sharedocs.huma-num.fr/wl/?id=BdzMTmdQC8NhbxhXwUqVVVzesjlKhSg2 Slides for today's lecture (PDF)] ("Using Linked Open Data as Network Data")<br />
<br />
== Some SPARQL Queries ==<br />
<br />
Go to http://dbpedia.org/snorql/ and enter:<br />
<br />
=== Университеты (много грязи выдает, увы) ===<br />
<br />
<nowiki><br />
SELECT ?uni WHERE {<br />
?uni a dbo:University.<br />
}<br />
</nowiki><br />
<br />
=== Девизы университетов ===<br />
<br />
<nowiki><br />
PREFIX prop: <http://dbpedia.org/property/><br />
SELECT ?uni ?deviz WHERE {<br />
?uni a dbo:University. <br />
?uni dbo:motto ?deviz<br />
}<br />
</nowiki><br />
<br />
=== Девизы РФ ===<br />
<br />
<nowiki><br />
PREFIX dbo: <http://dbpedia.org/ontology/><br />
PREFIX prop: <http://dbpedia.org/property/><br />
SELECT ?uni ?deviz WHERE {<br />
?uni a dbo:University. <br />
?uni prop:country ?strana .<br />
?uni dbo:motto ?deviz .<br />
FILTER regex(?strana,"Russia")<br />
}<br />
</nowiki><br />
<br />
=== Ученые и их аспиранты (легко превратить в граф для гефи) ===<br />
<br />
<nowiki><br />
PREFIX dbo: <http://dbpedia.org/ontology/><br />
SELECT ?scientist ?student WHERE {<br />
?scientist a dbo:Scientist .<br />
?scientist dbo:doctoralStudent ?student .<br />
}<br />
</nowiki><br />
<br />
=== Гео: Метро ===<br />
<br />
<nowiki><br />
PREFIX yago: <http://dbpedia.org/class/yago/><br />
PREFIX dbp: <http://dbpedia.org/property/><br />
SELECT ?mosstation ?lat ?long ?depth WHERE {<br />
?mosstation a yago:WikicatMoscowMetroStations .<br />
?mosstation dbp:latitude ?lat .<br />
?mosstation dbp:longitude ?long .<br />
?mosstation dbo:depth ?depth .<br />
}<br />
</nowiki><br />
<br />
=== Что-то про координаты универов, можно пропустить ===<br />
<br />
<nowiki><br />
PREFIX dbo: <http://dbpedia.org/ontology/><br />
PREFIX prop: <http://dbpedia.org/property/><br />
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#><br />
SELECT ?uni ?shirota ?dolgota WHERE {<br />
?uni a dbo:University. <br />
?uni prop:country ?strana .<br />
?uni geo:lat ?shirota .<br />
?uni geo:long ?dolgota .<br />
FILTER regex(?strana,”Russia")}<br />
</nowiki></div>
FF