🚶 Pavement parking hotspots

Custom SQL query returning 2,521 rows (hide)

select r.offence_location as Location, r.council_area as [Council area], count(*) as [Total reports], round(100.0 * sum(case when r.disposal not in ('NFA', 'Duplicate Submission') then 1 else 0 end) / count(*), 0) as [Action rate %], r.latitude, r.longitude from reports r where (r.offence like '%obstruction%' or r.offence like '%dangerous position%') and r.offence_location is not null group by r.offence_location, r.council_area order by [Total reports] desc

Edit SQL