Skip to content

Instantly share code, notes, and snippets.

@eddyxu

eddyxu/hardhat-near-truck.sql

Created May 5, 2022 19:10
Show Gist options
  • Save eddyxu/65a1bef74b9a27836cb9e5b1fc05dcd4 to your computer and use it in GitHub Desktop.
Save eddyxu/65a1bef74b9a27836cb9e5b1fc05dcd4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hardhat-near-truck.sql
SELECT * FROM (
SELECT
*,
ML_PREDICT(coco_det, image) as det,
ML_PREDICT(hardhat, image) as hat
FROM hardhat
) WHERE array_contains(hat.label, "helmat")
AND array_contains(hat.label, "head")
AND array_contains(det.label, "truck")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment