# Querying CSV files: aviation weather reports (METAR)

This demo project queries meteorogical data from the US Aviation Weather Center: [https://www.aviationweather.gov/metar](https://www.aviationweather.gov/metar)

The data is delivered as a CSV file from the following link: [https://aviationweather.gov/adds/dataserver_current/current/metars.cache.csv](https://aviationweather.gov/adds/dataserver_current/current/metars.cache.csv)

- [Example: Find the temperature, dewpoint, wind, and clouds in Boston](#example-find-the-temperature-dewpoint-wind-and-clouds-in-boston)
- [Example: Which weather stations are reporting 25+ knot winds and gusty conditions?](#example-which-weather-stations-are-reporting-25-knot-winds-and-gusty-conditions)

## Example: Find the temperature, dewpoint, wind, and clouds in Boston

Query: ([link](example_queries/boston_weather.ron))
```graphql
{
    LatestMetarReportForAirport(airport_code: "KBOS") {
        wind_speed_kts @output
        wind_direction @output
        wind_gusts_kts @output
        temperature @output
        dewpoint @output

        cloud_cover @fold {
            sky_cover @output
            base_altitude @output
        }
    }
}
```

To run it:
```
$ cargo run --example weather query ./examples/weather/example_queries/boston_weather.ron
< ... cargo output ... >

{
  "base_altitude": [
    2200
  ],
  "dewpoint": 0.6,
  "sky_cover": [
    "OVC"
  ],
  "temperature": 5.0,
  "wind_direction": 90,
  "wind_gusts_kts": null,
  "wind_speed_kts": 15
}
```

## Example: Which weather stations are reporting 25+ knot winds and gusty conditions?

Query: ([link](example_queries/high_winds.ron))
```graphql
{
    MetarReport {
        station_id @output
        latitude @output
        longitude @output

        wind_speed_kts @output @filter(op: ">", value: ["$min_wind"])
        wind_direction @output
        wind_gusts_kts @output @filter(op: "is_not_null")
        temperature @output
        dewpoint @output

        cloud_cover @fold {
            sky_cover @output
            base_altitude @output
        }
    }
}
```
with arguments `{ "min_wind": 25 }`.

To run it:
```
$ cargo run --example weather query ./examples/weather/example_queries/high_winds.ron
< ... cargo output ... >

{
  "base_altitude": [
    3200
  ],
  "dewpoint": -7.0,
  "latitude": 44.9,
  "longitude": -91.87,
  "sky_cover": [
    "OVC"
  ],
  "station_id": "KLUM",
  "temperature": 1.2,
  "wind_direction": 240,
  "wind_gusts_kts": 33,
  "wind_speed_kts": 26
}

{
  "base_altitude": [
    3200
  ],
  "dewpoint": -6.0,
  "latitude": 44.12,
  "longitude": -93.25,
  "sky_cover": [
    "OVC"
  ],
  "station_id": "KOWA",
  "temperature": -1.0,
  "wind_direction": 260,
  "wind_gusts_kts": 33,
  "wind_speed_kts": 26
}

< ... more results ... >
```