Skip to content

Instantly share code, notes, and snippets.

@shotleft

shotleft/bq_nest3.txt

Last active December 27, 2019 06:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shotleft/6adfb63ded63aa196f15d4252443b009 to your computer and use it in GitHub Desktop.
Save shotleft/6adfb63ded63aa196f15d4252443b009 to your computer and use it in GitHub Desktop.
Download ZIP
bq_nest3
Raw
bq_nest3.txt
SELECT
object_id
, y
, x
FROM
`bigquery-public-data.the_met.vision_api_data` AS main
CROSS JOIN UNNEST(faceAnnotations) fA
CROSS JOIN UNNEST(fA.boundingPoly.vertices) vertices
WHERE
object_id BETWEEN 647500 and 647600
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment