Skip to content

Instantly share code, notes, and snippets.

@revox
Created February 3, 2014 20:54
Show Gist options
  • Save revox/8792188 to your computer and use it in GitHub Desktop.
Save revox/8792188 to your computer and use it in GitHub Desktop.
SPARQL query to get schools with nurseries in a ONS code (run at http://openuplabs.tso.co.uk/sparql/gov-education)
PREFIX sch-ont: <http://education.data.gov.uk/def/school/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?name ?ptr ?address1 ?address2 ?postcode ?town WHERE {
?school a sch-ont:School;
sch-ont:establishmentName ?name;
sch-ont:nurseryProvision "true"^^xsd:boolean;
sch-ont:districtAdministrative <http://statistics.data.gov.uk/id/local-authority-district/00AZ>.
OPTIONAL {
?school sch-ont:address ?address.
?address sch-ont:address1 ?address1;
sch-ont:address2 ?address2;
sch-ont:postcode ?postcode;
sch-ont:town ?town.
}
}
ORDER BY ?name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment