'Google BigQuery for sentinel-2 data

I want to download sentinel-2 data from Google Cloud using BigQuery as shown below:

#standardSQL
SELECT base_url 
FROM   `bigquery-public-data.cloud_storage_geo_index.sentinel_2_index` 
WHERE (mgrs_tile="20HKH" OR mgrs_tile="20HKJ" OR mgrs_tile="20HLD") 
AND EXTRACT(YEAR FROM sensing_time) = 2019

I have a lot of sentinel-2 tiles – about 400 – that I want download. What should I do about the following line of code "WHERE (mgrs_tile="20HKH" OR mgrs_tile="20HKJ" OR mgrs_tile="20HLD") since the tiles are so numerous?

sqlimagegoogle-bigquery


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions