# Time Series Data in Geostreams

Several extractors push data to the Clowder Geostreams database, which allows registration of data streams that accumulate datapoints over time. These streams can then be queried, visualized and downloaded to get time series of various measurements across plots and sensors. Learn more about data in this database in this tutorial

The TERRA-REF Geostreams database organizes data into three levels:

* Location (e.g. plot, or a stationary sensor)
  * Information stream (a particular instrument's data, or a subset of one instrument's data)
    * Datapoint (a single observation from the information stream at a particular point in time)

![Generalized schema for the Geostreams database (part of clowder). ](/files/-M06GwkUV-LR0GLB0HSh)

## Sensor destinations

Here, the various streams that are used in the pipeline and their contents are listed.

* Location group
  * Stream name
    * **Datapoint property** \[units / sample value]
    * ...
* Full Field (Environmental Logger)
  * Weather Observations
    * **sunDirection** \[degrees / 358.4948271126]
    * **airPressure** \[hPa / 1014.1764580218]
    * **brightness** \[kilo Lux / 1.0607318339]
    * **relHumidity** \[relHumPerCent / 19.3731498154]
    * **temperature** \[DegCelsuis / 17.5243385113]
    * **windDirection** \[degrees / 176.7864009522]
    * **precipitation** \[mm/h / 0.0559327677]
    * **windVelocity** \[m/s / 3.4772789697]
    * raw values shown here; check if extractor converts to SI units
  * Photosynthetically Active Radiation
    * **par** \[umol/(m^2\*s) / 0]
  * co2 Observations
    * **co2** \[ppm / 493.4684409718]
  * Spectrometer Observations
    * **maxFixedIntensity** \[16383]
    * **integration time in us** \[5000]
    * **wavelength** \[long array of decimals]
    * **spectrum** \[long array of decimals]
* AZMET Maricopa Weather Station
  * Weather Observations 
    * **wind\_speed** \[1.089077491]
    * **eastward\_wind** \[-0.365913231]
    * **northward\_wind** \[-0.9997966834]
    * **air\_temperature** \[Kelvin/301.1359779]
    * **relative\_humidity** \[60.41579336]
    * **preciptation\_rate** \[0]
    * **surface\_downwelling\_shortwave\_flux\_in\_air** \[43.60608856]
    * **surface\_downwelling\_photosynthetic\_photon\_flux\_in\_air** \[152.1498155]
  * Irrigation Observations
    * **flow** \[gallons / 7903]
* UIUC Energy Farm - CEN
* UIUC Energy Farm - NE
* UIUC Energy Farm - SE
  * Energy Farm Observations - CEN/NE/SE
    * **wind\_speed**
    * **eastward\_wind**
    * **northward\_wind**
    * **air\_temperature**
    * **relative\_humidity**
    * **preciptation\_rate**
    * **surface\_downwelling\_shortwave\_flux\_in\_air**
    * **surface\_downwelling\_photosynthetic\_photon\_flux\_in\_air**
    * **air\_pressure**
* PLOT\_ID e.g. Range 51 Pass 2 (each plot gets a separate location group)
  * sensorName - Range 51 Pass 2 (each sensor gets a separate stream within the plot)
    * **fov** \[polygon geometry]
    * **centroid** \[point geometry]
  * canopycover - Range 51 Pass 2
    * **canopy\_cover** \[height/0.294124289126]


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.terraref.org/technical-documentation/geospatial-time-series-structure.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.