SELECT * --id, project_name, metric_name, "time", value, display_value, geometry_id FROM public.metrics_app_timeandgeometric as a join public.metrics_app_geometry as b on a.geometry_id=b.id where project_name = 'Lasswade' and metric_name = 'peopleCount' and time >= '2022-10-20' and geometry_name in ('School entrance_count', 'School entrance high_count', 'Entrance Door 1_count', 'Entrance Door 2_count', 'Entrance Door 3_count', 'Rear exit 1_count', 'Rear exit 2_count' ) order by time
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter