Greater London Authority (GLA)
Data from the London Datastore
Datasets 1 and 2 are converted from original sources found at http://data.london.gov.uk/ .
Dataset-1 - GLA budget 2009 from London Data Web Site
Dataset-2 - GLA committee members from London Data Web Site
Simple queries on Dataset-1
Run Query: "Number of unique Cost Codes"
PREFIX go: <http://www.govobjects.org/govobjects#>
select distinct ?costcode from <http://virtuoso.govobjects.org/gla/>
where {
?entity go:CostCode ?costcode .
} order by ?costcode
Filtering Dataset-1
Run Query: "Budgets of more than £5000 where actual expenditure exceeded the allocation"
PREFIX go: <http://www.govobjects.org/govobjects#>
select distinct ?costcode ?service ?expensecode ?budget ?actual
(?actual-?budget) as ?excess where {
?entity go:CostCode ?costcode .
?entity go:Service ?service .
?entity go:ExpenseCode ?expensecode .
?entity go:Budget ?budget .
?entity go:ActualExpenditure ?actual .
FILTER(?actual > ?budget ) .
FILTER(?budget > 5000) .
} order by desc(?actual-?budget )
Combining Dataset-1 and Dataset-2 and graphing with Google Chart API
Run Query: "The value of every expense report with a service name which matches a party name"
PREFIX go: <http://www.govobjects.org/govobjects#>
select ?costcode, ?directorate, ?party_name, ?actual where {
?party rdf:name ?party_name .
?expense go:Service ?party_name .
?expense go:ActualExpenditure ?actual .
?expense go:Budget ?budget .
?expense go:CostCode ?costcode .
?expense go:Directorate ?directorate .
} order by desc (?actual)
Graphing Dataset-1 using Google Chart API
Run Query: "Total budget for each Directorate"
PREFIX go: <http://www.govobjects.org/govobjects#>
select distinct ?directorate sum(?budget) as ?total
from <http://virtuoso.govobjects.org/gla/>
where {
?entity go:Budget ?budget .
?entity go:CostCode ?costcode .
?entity go:Service ?service .
?entity go:Directorate ?directorate .
}
GROUP BY ?directorate
