Submitted by John Goodwin on 1st August 2011
How many cases of antisocial behaviour were reported for each ward in the month of June?
Query:
select ?wardlabel (COUNT(?crime) as ?number)
where
{
?crime <http://commons.psi.enakting.org/def/period> <http://time.psi.enakting.org/interval/2011-06-01T00:00:00ZP1M> .
?crime <http://commons.psi.enakting.org/def/nearest-postcode> ?postcode .
?crime <http://crime.rkbexplorer.com/id/crime-type> <http://crime.rkbexplorer.com/id/anti-social-behaviour> .
?postcode <http://data.ordnancesurvey.co.uk/ontology/postcode/ward> ?ward .
?ward <http://www.w3.org/2000/01/rdf-schema#label> ?wardlabel .
}
group by ?wardlabel
order by ?number
| Dataset | Southampton |
|---|---|
| Created By | John Goodwin |
| Published | 2011-08-01 11:30 |
