Skip to content

Instantly share code, notes, and snippets.

@eddyxu

eddyxu/label-by-area.sql

Last active January 29, 2022 10:41
Show Gist options
  • Save eddyxu/3950c0c2ff2dad921311d32d70c777fb to your computer and use it in GitHub Desktop.
Save eddyxu/3950c0c2ff2dad921311d32d70c777fb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
label-by-area.sql
SELECT box_area, count(*) AS cnt FROM (
SELECT
CAST(area(detection.box) / 500 AS int) * 500 AS box_area
FROM least_margin
WHERE coco_name(detection.label_ids[0]) IN ('chair', 'person')
AND coco_name(detection.label_ids[1]) IN ('chair', 'person')
) GROUP BY box_area ORDER BY box_area
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment