Parquet files

If you need to query several municipalities, indicators and zonal statistics, we recommend to download and locally query the parquet files using the arrow package.

BR-DWGD (13.65 GB)

• Evapotranspiration: https://brdwgd.nyc3.cdn.digitaloceanspaces.com/parquet/eto.parquet
• Precipitation: https://brdwgd.nyc3.cdn.digitaloceanspaces.com/parquet/pr.parquet
• Relative Humidity: https://brdwgd.nyc3.cdn.digitaloceanspaces.com/parquet/rh.parquet
• Solar radiation: https://brdwgd.nyc3.cdn.digitaloceanspaces.com/parquet/rs.parquet
• Maximum temperature: https://brdwgd.nyc3.cdn.digitaloceanspaces.com/parquet/tmax.parquet
• Minimum temperature: https://brdwgd.nyc3.cdn.digitaloceanspaces.com/parquet/tmin.parquet
• Wind speed: https://brdwgd.nyc3.cdn.digitaloceanspaces.com/parquet/u2.parquet

TerraClimate (1.02 GB)

• Actual Evapotranspiration: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/aet.parquet
• Climate Water Deficit: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/def.parquet
• Potential evapotranspiration: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/pet.parquet
• Precipitation: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/ppt.parquet
• Runoff: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/q.parquet
• Soil Moisture: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/soil.parquet
• Downward surface shortwave radiation: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/srad.parquet
• Snow water equivalent: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/swe.parquet
• Max Temperature: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/tmax.parquet
• Min Temperature: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/tmin.parquet
• Vapor pressure: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/vap.parquet
• Wind speed: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/ws.parquet
• Vapor Pressure Deficit: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/vpd.parquet
• PDSI: https://terraclimate.nyc3.cdn.digitaloceanspaces.com/parquet/pdsi.parquet

Query example

After downloading the parquets files, you can query them using the arrow package.

library(tidyverse)
library(arrow)

brdwgd <- open_dataset(sources = "/parquet/files/address/")

brdwgd %>%
  filter(code_muni %in% c(3105608, 3304557, 3136702)) %>%
  filter(name == "Tmax_mean") %>%
  filter(date >= as.Date("2008-01-01") & date <= as.Date("2008-12-31")) %>%
  select(code_muni, date, value) %>%
  collect()