Hi, in Calc 2.1-a3 i successfully imported a data-backup file. As "sampling design" I defined the plot entity as basic unit and as reporting unit (AOI) i loaded a calc-aoi.csv file joining two code variables. 1. Are these settings correct for a SRS (simple random sampling) case? 2. After loading the calc-aoi.csv file I cannot define a new variable on the lowest entity "plot" in the "Calculation" menu (error message: Form not valid). This was still possible before loading the calc-aoi.csv. Is it necessary to define all variables on plot entity before loading the calc-aoi.csv file? Thanks, Hans
asked
hfuchs |

Hi, you are right that we need to get plot and cluster level results out from Calc (or Saiku). In order to get plot results (per hectare), I have solved this by writing a R script into a calculation module at the very end of my processing chain. The plot results are written into file C:\Temp\Plot_Results.csv. This script works also in cases where plots/subplots are split into land cover/use sections, and base unit is plot section (or stand). I show this only for entities 'tree' and 'fallen_deadwood', although in the full script there are 'sapling','seedling' and some other entities too.
Regards, Lauri
answered
LauriV |

Thanks Mino, Hans and Lutz, this discussion answers main questions I had with aggregation (with newly gained knowledge on R not exceeding simple expressions to edit variables). I hope really that cluster and plot level can be included in Saiku so that i can see/check what really happens while aggregating without going to Postgres. This to encourage Mino's efforts to show cluster and plot levels soon! Further it would be advisable to extend a bit on this in the Calc manual. Thanks Joseph.
answered
joseph |

Dear Lutz, Thanks for posting your solution; the results per ha are correct, probably not totals (like volume in m3) for the Country if the sum of the area (in the aoi file you uploaded) doesn't match with the area of the country. Calc does aggregates first at the base unit level, producing per ha results; they are just not presented in Saiku; we encountered performance issues with big surveys. It then produces totals, by multiplying the, so called, expansion factor (which is calculated as Area of Admin unit / Sum of the base unit weights) with the plot results. The means are then calculated as Total / Area on the fly in Saiku for the combination of categories you select. Plot level results are accessible, at the moment, only through direct access to Postgres (e.g. with PgAdmin). The aggregated table names are produced as _{entity}_{level}_results , e.g. _tree_plot_results and are created in the database schema with the name of the workspace. Aggregated results for cluster sampling are not produced at the moment, Calc goes from plots to aoi; there are ways to play with base unit weight in combination with 'apply weight method' to calculate results using cluster sampling. I will implment the cluster sampling soon, and will think a way to show plot and cluster level results also (Probably in the data section of Calc). If you have any suggestions, would like to know more, questions, please let me know! Thank you, Mino
answered
Mino Togna ♦♦ |

Dear Mino and Hans, I just tested an alternative method that is more simple for me: I created an alternative aoi file with three levels (Country, Cluster, Subplot). I am using cluster sampling and like to get results per cluster and per subplot. I set the area (level_3_area) to 1 ha for all subplots. In Saiku I can now aggregate to all three levels (which are under the dimension "Administrative Unit"). This works fine for me. In general: The way how results are aggregated in Calc is sometimes difficult for me. Usually we are estimating means and total per ha (and plot) and also like to see these values before expanding this by any area later (might be a forest type or an administrative area). However, Calc is estimating totals for the entire area first. Lutz
answered
Fehrmann |

Dear Hans, That depends on how the survey is structured. Usually, we create code lists for such variables, (cluster ids, plot ids, ... ) so that once the survey is imported into Calc (the Collect code lists get converted into Calc categories), they are available in Saiku together with the results without any additional operation. If you haven't created code lists, then you can create a category in Calc. Please let me know if that helps or you need more info. Thank you, Mino
answered
Mino Togna ♦♦ |

Dear Mino, thank you, it works if I add the qty variables to the tree entity. What do you recommend for slicing results on plot level in Saiku? Adding the plot ID as an additional category variable in Calc or using a MDX filter expression on rows in Saiku? Regards, Hans
answered
hfuchs |

Dear Hans, I want to add more elements to the answer above. it is actually possible, but with a trick. If your inventory doesnt contain a lot of data, you can use a separate workspace (linked with same collect data) only for plot and cluster results ( Here the steps to follow: - Create a workspace
- Import collect data
- Add the qty variables you want to calculate in Calculation section (e.g. volume, basal area etc..) and select the type of aggregation you wish to apply (e.g. sum, avg etc..)
- Edit the formulas for the variables at step 3 in RStudio (BUT this time the unit should be U/ha eg. m3/ha. i.e. if you are editing volume, you first calculate volume in m3 for each tree and then divide the value for the area of the plot they where measured in).
- Execute the processing chain (click source in RStudio, with calc.R as file to execute)
- Click play in Calculation section
- Access Saiku
You should be able to slice your results for the entire hierarchy of the survey in Saiku. Please let me know if you need more info, Thank you, Mino
answered
Mino Togna ♦♦ |

Dear Hans, Those are common tree variables. they are just aggregated at plot level; therefore if you want to calculate them, you need to add them to the tree entity.
If you want to access plot and or cluster level results, you can still access them, but through PGAdmin (i.e. access directly the database). Thank you, Mino
answered
Mino Togna ♦♦ |

Dear Mino, i need results for standard variables such as mean diameter, basal area/ha, volume/ha for each plot. Is there any option to ev. use the cluster level for aggregation and displaying results in saiku? Regards, Hans
answered
hfuchs |

Hi Hans, For some technical constraints , at the moment only Categorical variables are allowed for the base unit. That's why you see that error, you are adding a quantitative variable to the base unit ( your plot ) entity. Could i know more information about the variable you want to calculate? Thank you, Mino
answered
Mino Togna ♦♦ |