select s3_key from umbra where osm_region like '%zone%' and s3_key like '%GEC.tif' ORDER BY 1;
┌─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ s3_key │
│ varchar │
├─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤
│ sar-data/tasks/ad hoc/0ce837c5-e3a8-4b30-b5a4-5420c5fedfba/2024-06-06-15-20-13_UMBRA-04/2024-06-06-15-20-13_UMBRA-04_GEC.tif │
│ sar-data/tasks/ad hoc/Bhopal_India/f3ff6f0d-dc99-42dc-9704-3d9adc3f5e56/2024-02-14-16-57-13_UMBRA-07/2024-02-14-16-57-13_UMBRA-07_GEC.tif │
│ sar-data/tasks/ad hoc/HAL_Airport_India/fdf98394-efc4-4419-9c2b-7536b102b644/2024-02-23-04-37-42_UMBRA-04/2024-02-23-04-37-42_UMBRA-04_GEC.tif │
│ sar-data/tasks/ad hoc/Indian_Institute_of_Science/432eb431-9fc0-4db6-a945-e48498869b98/2024-02-23-04-37-05_UMBRA-04/2024-02-23-04-37-05_UMBRA-04_GEC.tif │
│ sar-data/tasks/ad hoc/Mumbai_IN_GatewayofIndia/69f20435-8fee-4091-9b4f-af31eec80a89/2024-03-09-16-22-34_UMBRA-04/2024-03-09-16-22-34_UMBRA-04_GEC.tif │
│ sar-data/tasks/ad hoc/Narayansar, India (Cyclone Biparjoy)/70ef88a1-6497-4fbd-a494-7c5c7d9e7731/2023-06-17-05-22-13_UMBRA-05/2023-06-17-05-22-13_UMBRA-05_GEC.tif │
│ sar-data/tasks/ad hoc/New Delhi, India/7301f30d-857e-463d-b4f9-ce838cf62209/2023-06-22-05-17-12_UMBRA-06/2023-06-22-05-17-12_UMBRA-06_GEC.tif │
│ sar-data/tasks/ad hoc/Sikkim Glacial Lake/0277ec04-74dc-49a5-b3c9-b05d796b66d7/2023-10-09-17-01-54_UMBRA-06/2023-10-09-17-01-54_UMBRA-06_GEC.tif │
│ sar-data/tasks/ad hoc/Sikkim Glacial Lake/1d14deb0-e76d-4214-ba3b-58d2bac0cbb0/2023-10-08-15-40-37_UMBRA-05/2023-10-08-15-40-37_UMBRA-05_GEC.tif │
│ sar-data/tasks/ad hoc/Sikkim Glacial Lake/35340db9-d9aa-4581-b443-a82b6c7f7996/2023-10-07-15-38-22_UMBRA-04/2023-10-07-15-38-22_UMBRA-04_GEC.tif │
│ sar-data/tasks/ad hoc/Sikkim Glacial Lake/5029013e-f216-40c8-9075-d67ac914b006/2023-10-07-03-32-55_UMBRA-04/2023-10-07-03-32-55_UMBRA-04_GEC.tif │
│ sar-data/tasks/ad hoc/Sikkim Glacial Lake/5b232906-ba71-4813-931e-e6f9af424d4b/2023-10-07-15-38-52_UMBRA-04/2023-10-07-15-38-52_UMBRA-04_GEC.tif │
│ sar-data/tasks/ad hoc/Sikkim Glacial Lake/63087e34-9f0b-49e8-aa0f-d231ee64d39f/2023-10-07-03-32-16_UMBRA-04/2023-10-07-03-32-16_UMBRA-04_GEC.tif │
│ sar-data/tasks/ad hoc/Sikkim Glacial Lake/bb8985c1-9bac-4467-9076-9a706dcba521/2023-10-08-03-33-20_UMBRA-05/2023-10-08-03-33-20_UMBRA-05_GEC.tif │
│ sar-data/tasks/ad hoc/Surat Diamond Bourse, Gujarat, India/3db80a41-5e25-4786-a832-717d43f2a3ea/2023-08-11-16-12-10_UMBRA-05/2023-08-11-16-12-10_UMBRA-05_GEC.tif │
│ sar-data/tasks/ad hoc/Surat, India - Diamond Cutting Complex/4845fc93-554b-4005-886d-9e05af0be65b/2023-07-31-04-59-55_UMBRA-05/2023-07-31-04-59-55_UMBRA-05_GEC.tif │
│ sar-data/tasks/ad hoc/Taj_Mahal_India/aa2b92e3-4fbf-4b72-b579-550c1b8b3a19/2024-02-13-16-00-32_UMBRA-04/2024-02-13-16-00-32_UMBRA-04_GEC.tif │
│ sar-data/tasks/ad hoc/Thangassery_Breakwater_India/7c34f1f9-bcf6-48f4-88b3-3ccc4e5fa49d/2024-02-14-04-31-53_UMBRA-05/2024-02-14-04-31-53_UMBRA-05_GEC.tif │
│ sar-data/tasks/ad hoc/Tirumala_Tirupati_India/47b7e674-9bf2-40b9-aff0-dd994a5e7c17/2024-02-13-04-51-44_UMBRA-06/2024-02-13-04-51-44_UMBRA-06_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/1a7b81dc-c62d-4d5f-9482-83befcf6b558/2023-08-27-03-42-51_UMBRA-05/2023-08-27-03-42-51_UMBRA-05_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/2593298c-7b77-4da7-90af-00f6dcadd8a8/2023-08-13-16-33-17_UMBRA-06/2023-08-13-16-33-17_UMBRA-06_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/26b9ac0c-37e4-4811-88e4-6a97292249f6/2023-07-02-15-38-57_UMBRA-04/2023-07-02-15-38-57_UMBRA-04_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/27a8c3ae-c526-4b4e-a535-d0b88dc33e49/2023-07-02-16-40-10_UMBRA-06/2023-07-02-16-40-10_UMBRA-06_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/3a82ac31-5c77-4048-a6b5-644726cd4ca7/2023-06-30-17-04-23_UMBRA-06/2023-06-30-17-04-23_UMBRA-06_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/4c0e9724-d2fb-4c78-9f21-d997625e2874/2023-06-29-17-14-07_UMBRA-06/2023-06-29-17-14-07_UMBRA-06_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/68b8cb88-83a4-4789-853e-69ff600392de/2023-08-22-15-19-06_UMBRA-05/2023-08-22-15-19-06_UMBRA-05_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/71167c4e-d276-44b8-be69-a3e0a8fb2a1b/2023-01-24-04-43-07_UMBRA-04/2023-01-24-04-43-07_UMBRA-04_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/8434c86d-94fe-4918-a456-fa0817cd6200/2023-06-30-16-05-29_UMBRA-04/2023-06-30-16-05-29_UMBRA-04_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/8e802bcc-571b-4002-8020-dee255641eb4/2023-08-09-04-35-32_UMBRA-04/2023-08-09-04-35-32_UMBRA-04_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/9d6a100e-0c8e-4069-b394-7d10911b11e2/2023-08-17-04-22-47_UMBRA-05/2023-08-17-04-22-47_UMBRA-05_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/af455c69-b312-4f96-8bff-f3e7a6a65a91/2023-08-31-04-16-34_UMBRA-06/2023-08-31-04-16-34_UMBRA-06_GEC.tif │
│ sar-data/tasks/ship_detection_testdata/c1945f94-4f01-426f-b69c-29206c73be02/2023-02-18-16-04-28_UMBRA-05/2023-02-18-16-04-28_UMBRA-05_GEC.tif │
├─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤
│ 32 rows │
└─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
