Skip to content

Instantly share code, notes, and snippets.

@northernjamie

northernjamie/ODC_Google_Chart_SPARQL_1_Line.SPARQL

Created January 30, 2018 14:46
Show Gist options
  • Save northernjamie/797c0414390f02d15c8e894deead2250 to your computer and use it in GitHub Desktop.
Save northernjamie/797c0414390f02d15c8e894deead2250 to your computer and use it in GitHub Desktop.
Download ZIP
SPARQL query to get one series of data for ODC google chart demo
Raw
ODC_Google_Chart_SPARQL_1_Line.SPARQL
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?periodlabel ?count
WHERE {
?obs <http://purl.org/linked-data/cube#dataSet> <http://opendatacommunities.org/data/homelessness/rough-sleeping/count> .
?obs <http://opendatacommunities.org/def/ontology/geography/refArea> <http://opendatacommunities.org/id/geography/administration/ctry/E92000001> .
?obs <http://opendatacommunities.org/def/ontology/time/refPeriod> ?perioduri .
?obs <http://opendatacommunities.org/def/ontology/homelessness/roughSleepingObs> ?count .
?perioduri rdfs:label ?periodlabel .
}
ORDER BY ?periodlabel
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment