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 2012ci2017
: Kohlenstoffinventur in 2017bwi2022
: 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.
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.
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.