1INSTALL h3 FROM community; LOAD h3;
2
3-- days per year at or above 40 °C near Sacramento, by scenario and period
4SELECT scenario, period, days_mean, days_min, days_max
5FROM read_parquet('https://s3-west.nrp-nautilus.io/public-caladapt/loca2-hybrid/tasmax-exceedance/hex/h0=*/data_0.parquet',
6                  hive_partitioning = true)
7WHERE h7 = h3_latlng_to_cell(38.58, -121.49, 7) AND threshold_c = 40.0
8ORDER BY scenario, period;

1INSTALL h3 FROM community; LOAD h3;
2
3-- days per year at or above 40 °C near Sacramento, by scenario and period
4SELECT scenario, period, days_mean, days_min, days_max
5FROM read_parquet('https://s3-west.nrp-nautilus.io/public-caladapt/loca2-hybrid/tasmax-exceedance/hex/h0=*/data_0.parquet',
6                  hive_partitioning = true)
7WHERE h7 = h3_latlng_to_cell(38.58, -121.49, 7) AND threshold_c = 40.0
8ORDER BY scenario, period;