Skip to content

Filter by Interval

Data is collected in regular intervals. Currently ci2012, ci2017 and bwi2022 are available. The interval data is stored in the interval_name columne of the inventory_archive.plot table. The interval_name is used to identify the data of a specific interval.

  • ci2012: Kohlenstoffinventur in 2012
  • ci2017: Kohlenstoffinventur in 2017
  • bwi2022: Bundeswaldinventur in 2022

Read by Interval

To read data from a specific interval, you can use the interval_name column in the inventory_archive.plot table. The following example shows how to query data for the ci2017 interval.

INFO

Every request lower or equal plot table should include the filter interval_name=eq.XXX to ensure that only data from the selected interval is returned.

txt
curl -X GET "https://ci.thuenen.de/rest/v1/plot?interval_name=eq.ci2017" -H "Accept-Profile: inventory_archive" -H "apikey: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoiYW5vbiIsImlzcyI6InN1cGFiYXNlIiwiaWF0IjoxNzQ1NzkxMjAwLCJleHAiOjE5MDM1NTc2MDB9.hXiYlA_168hHZ6fk3zPgABQUpEcqkYRMzu0A5W5PtYU"

This will return all plots that are part of the ci2017 interval.

More information about Horizontal Filtering.

Comparing Intervals

To compare cluster data from different intervals, you can use the interval_name column in the inventory_archive.cluster table.

The following example shows how to query a specific cluster (cluster_name=eq.5207) for the ci2012 and ci2017 intervals.

txt
curl -X GET "https://ci.thuenen.de/rest/v1/cluster?cluster_name=eq.5207&select=*,plot(*,tree(*),deadwood(*),regeneration(*),structure_lt4m(*),structure_gt4m(*),edges(*),plot_landmark(*),position(*),subplots_relative_position(*))&plot.interval_name=in.(ci2012,ci2017)" -H "Accept-Profile: inventory_archive" -H "apikey: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoiYW5vbiIsImlzcyI6InN1cGFiYXNlIiwiaWF0IjoxNzQ1NzkxMjAwLCJleHAiOjE5MDM1NTc2MDB9.hXiYlA_168hHZ6fk3zPgABQUpEcqkYRMzu0A5W5PtYU"

This will return the cluster data for the specified cluster, including 8 plots. 4 plots are from the ci2012 interval and 4 plots are from the ci2017 interval. The data is structured in a way that allows you to compare the data from both intervals.