Questions Tagged With calc
Ask a questionCalc-use processing chain defined in workspace for other survey
Dear OF Team, when importing data from an OF Collect Survey to a different survey (of the same structure) using the .collect-data format, we can rename the collect-data file to .zip, and change the the meta data stored under info.properties to harmonize survey names and re-import. Is there a way to ...
Calc Workspace Migration to Arena
Dear OF Team, I checked the ARENA manual, but couldn't find anything. Is there a way to import workspaces from CALC into ARENA? If not, could you recommend a workaround to avoid having to manually migrate all chains manually? We have created complex processing chains in CALC for cluster and plot bas...
Calc Problem in 001-init.R
Hi, after some time, I needed Calc to run again. While the scripts seem to be working in R Studio, as soon as I press the "play" button in calculations to load them into Calc, I receive the following error message indicating that my CRAN mirror is not defined(?): *Error in 'R Scripts - Processing ch...
Deciding if I should use Calc?
Dear all, I am new to open foris and need a quick answer to see if it might fit my needs. First, I have data collected from different sources but not Collect, it is still reliable in CSV format. Can I work generally on CALC or I might encounter difficulties since is not coming from a collect file? S...
Using Calc with data not collected through Collect / Collect Mobile
I have collected data using a different software from Collect Mobile but I would like to use Open Foris Calc to analyze it. Is there a way for me to import this data into Calc?? Thanks!
calc installation in ubuntu 18.04.6
Hi Team, I struggle to get clear steps to successfully install Calc synergetically with associated software like JDK, PostgreSQL, R & RStudio in Ubuntu. I will appreciate your support on this. Regards, Jeremiah.
sample code for Calc
Dear All I just reach calc. I want to write code to implement R commands in calc calculation. have you have the documentation and code samples to study it? can you share me?
Installing calc on Mac
Hello everyone. Could you please help, how to install Open foris Calc on Mac computer? On the openforis website, there is no link for Mac installer but rather windows and Linux. I tired installing Linux on Mac but it does not work. Thanks for your assistance.
Calc 2.1 a19 not starting
Dear Mino, after some time I am trying to use Calc again. I've updated to 2.1 a19 and Calc doesn't start up anymore. I have followed the threats in the forum and also in the manual. I have updated R to 4.1.1 and R Studio, both are installed in c:\opt... I am running JDK on ver. 17. However when I st...
Species vernacular name in saiku
Hi, I would like to use the vernacular name for reporting in Saiku. I notice that only the scientific name is available for reporting from the species tables. I made a new field in OF Collect to automatically populate and store the vernacular name. However, when I export the data to OF Calc and the...
Minimum number of plots for Saiku?
Hi, I have a small amount of data (10 plots over 2 clusters within a single region) that I would like to use for prototyping and testing. I have cleaned the data in OF Collect and promoted to ready for analysis. I can import the data into my OF Calc workspace with no errors and I can then view the d...
Internal server error when starting Calc
Hi OFCteam. I have smoothly been using Calc for a couple of weeks. Suddenly, now Calc unsuccessfully opens with an internal server error "The server encountered an internal error that prevented it from fulfilling this request" I have tried un-installing & re-installing JDK, Postgres, R, RStudio and ...
Plot counts by category
Hi, My inventory has a nested sub-plot design with sub-plots of various sizes where different sized trees are measured. I have specified the plot as the base unit of aggregation in the sampling design. Several variables (e.g. primary disturbance type and topographic information) are recorded at the ...
Suggested workflow for merging data tables
Hi, My inventory uses nested sub-plots of different areas for different sized trees. In the Collect schema these trees are stored in different tables. I currently calculate variables (e.g. AGB, Carbon) for each sub-plot separately, define the plot area for each sub-plot, and can view and interact wi...
OpenForis Calc test dataset
Hi, The OpenForis Calc test dataset (Atlantis) referred to in Calc the user manual is not available at the links provided http://openforis.org/newwebsite/tools/calc/tutorials/calc-home.html and http://www.openforis.org/nexus/service/local/artifact/maven/redirect?r=releases&g=org.openforis.test-data...
Update to Calc v. 2.1-a19 (Windows)
Notice for Calc users (19/2/2021): Calc v. 2.1-a17 fails to import a collect-data file, because some new Java libraries are missing. There is an updated version Calc 2.1-a19 for Windows available at Open Foris site, for example under this link. If you have saved Saiku queries for Calc: before instal...
Problems with R script to prepare species lists for Collect
Dear OF Team, I would like to import a rather long species list (csv >700 MB) to Collect, using the provided R-scripts (https://drive.google.com/open?id=1FKe3dlFRgw1IrUmUtF6q02j4qDr9gkki). As reference, I am working with the PDF Species coding approach for Open Foris Collect and Calc. However, I can...
Updating Calc v. 2.1-a17 (Windows) and saved Saiku queries
Notice for Calc users: Calc v. 2.1-a16 fails to import a workspace file, and there is an updated version Calc 2.1-a17 for Windows available here under this link. If you have saved Saiku queries for Calc: before installing the newest version, take a safety copy of the queries from c:\opt\OpenForisCa...
Calc error double workspace name
Dear all, I accidentaly seem to have created two workspaces with the same name. I actually wanted to change the sampling desogn of an existing workspace. This didn't work out the way I wanted and as I restarted Calc, the error message told me that there are two workspaces with the same name. I dein...
Problem with multiple code attribute
Hello OF Team, I am having issues with code attributes for which I want the option of multiple selections. I have a tree entity within a plot entitiy. When I create a code-attribute on the tree level, which has the multiple box checked, to allow multiple selection, the data entered for this attribut...
Uploading AOI into Calc
Sir/Madam, I am not able to upload AOI for the analysis of inventory data. An error message pops up the 'Internal Server Error 500'. Any assistance from developers is appreciated. Thanks Dorji
Results generated from Calc is 185% higher the actual estimates
Hi Everyone, I am analyzing my forest inventory data in calc but the estimates generated are extremely high. For example, I have enumerated 2203 trees from 250 plots (Plot area = 0.05 ha). The total inventory area is 9157 ha. In MS Excel, the tree count per ha is 176 compared to 503 trees per ha gen...
Can't start Calc 2.1 on Windows 10
Hi, I'm not having any luck getting Calc 2.1 to run on my windows 10 (64-bit) machine. I followed the instructions from the manual (http://www.openforis.org/tools/calc/tutorials/calc-21-user-manual.html). I had previously installed JDK (13.0.2) and Collect (3.25.1) at C:\OpenForis\Collect. This work...
Calc Error Script for Plot-based systematic Sampling
Dear OF Team, we are in the process of analyzing our data derived via a plot-based systematic sampling grid in OF CALC. We would like to use the Error calculation script based on "Formulas for estimators and their variances in NFI 28.2.2014 K.T. Korhonen & Olli Salmensuu (Metla, Joensuu/Finland), po...
Saiku calc - no results
Hey all together, when I am trying to use Saiku from Open Foris Calc and I create a query, it says "no results" and doesn't give any output, no matter what I try to query. If I use Saiku from Collect, everything works. Did someone encounter similiar difficulties or has a solution for that?
Importing workspace to Calc
Hi Open Foris Team, We came up with an error as trying to import Calc workspace from Calc 2.1-a14 to Calc 2.1-a16. Error message was: "ERROR: Error in calculateQuantityError(dataClone, plotsClone, strata, "tree_volume"): unused argument ("tree_volume")" In function call is three parameters, but "tre...
ERROR: Error in postgresqlExecStatement(conn, statement, ...): RS-DBI driver: (could not Retrieve the result
Hi Mino et al., when trying to load my calculations from R Studio into the database via Calc, I get the following error (see below). In R, all the scripts run smoothly. Where do I have to look? Error in 'R Scripts - Processing chain' 2019-04-03 18:15:12 step : 1-init.R INFO: Processing chain start...
Error installing Calc
Hi, I am getting an error message "... The installer could not find a valid Java(tm) on this machine. Supported versions: Vendor: Any min. 1.8 max. any JDK required." I have downloaded multiple things (went to https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html) but ...
Is Sampling Point Data accessible in Calc?
Dear OF Team, Is the information in SPD accessible in Calc even if the data is not explicitly displayed in the survey form? We're planning to put administrative units information in SPD and want to be able to access it in Calc. Thanks! Andras
error message starting open foris calc
Hey all together, when I am trying to start Open Foris calc, I immediatley get an error message, "Error 500 - Internal Server Error", it specifies that: "request processing failed" and "Cursor returned more than one result". I don't know what to do, since the programme just doesn't work. Does anyone...
How do I create an autoincremented index number in the root?
Dear all, I would like an attribute "id" in the root of my survey where the value is set to the last entered value + 1. In a non-root entity, I can do that using math:parent()/tree/id + 1 But in the root I cannot make reference to parent()/ and therefore I cannot make this work. Any help will be ver...
Calc 2.1 not starting
I seem to have successfully installed Calc 2.1 but now, when I try to launch the Open Foris Calc Control Panel, nothing happens. There is no error, it simply doesn't run. Could this be a problem with my installation? I followed instructions carefully regarding R, JDK and postgres... Also it appears ...
OF Calc: filtering data according to tree species
Dear Support Team, when displaying my tree data in calc, I would like to group the data according to species (e.g. to create tree height / diameter relationships per species). However, in data view, I can only filter via the species code. Is this the only way to filter the data per species? What ca...
No webpage was found for the web address: http://127.0.0.1:8081/calc
Hi Mino, I downloaded Calc + postgres + R + Rstudio (R and Rstudio were installed before in my computer) but when I try to open Open Foris Calc Control Panel the browser shows me the error HTTP 404 No encontrado (Page not found). Can you help me please? Thank you very much. J.
Java error installing Calc 2.0-a13-Windows
I keep having the following error despite last version of Java was installed. Any idea of which is the problem? Thanks Error There has been an error. The installer could not find a valid Java(tm) on this machine. Supported versions: Vendor : Any min. 1.8 max. any JDK required Aceptar
How to export the data from the "collect" to the "calc"?
Hi, How to export the data from the "collect" to the "calc"?
error with R directory when starting calc
Hello, When we start Calc it does not go to the home screen but instead it says "R executable directory must contain valid R executable file". When we put the directory in line it does not accept it. What are we doing wrong? Calc Version: 2.1 R Version: 3.4.3 Thanks
tree_view not created if categories on plot level are active
Hi Mino et al., I have a problem with categories on plot level. I like to build slope classes for the variable plot_slope in my plot table. As soon as I activate this category in the calculation, Calc will not produce the tree_view table anymore (only plot_view), which leads to errors. This problem ...
deleting calculations
Hi all, I have a question regarding "old" (viz. deleted) variables/calculations. Soemtimes it happens that I deleted a calculation in the workflow. However, the name still appears in the data view (even if I cannot find it anymore in the database in PGAdmin). Obviously Calc also remebers the variabl...
Error in 'R Scripts - Processing chain' null
Dear OF Community, maybe someone can help me with the error message above. I just updated R and now, when I am asking Calc to write the results of the calculations (work in R without problems) into the database, I receive this error during step 1 'R Script Processing chain'. I have two different sur...
Results of script not showing on Saiku
Hi Mino, --on the tutorial database-- I have tried to add the dbh_classes using RScript instead of Category type and I am not able to see the results on Saiku. I have saved and executed it and everythinh went fine. I see the results on Calc. But when I open Saiku, it is not there (even though my oth...
New rscript variable in Calc 2.1-a3 on plot level
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 ...
Struggling with R step 5-init.R: base-unit-weight
Dear all, I changed step 005 base-unit-weight: <- NA to <- 1 but remain to get error, who knows solution? Thanks Joseph Error in 'R Scripts - Processing chain' 2017-05-22 07:03:20 step : 1-init.R INFO: Processing chain started Loading required package: methods Loading required package: DBI Loadin...
Where is the Problem when Creating Aggregate Tables??
Hi, when trying to make Calc run my calculations, I receive the following error in Step 2 "Create aggregate tables" (see below, [...] resembles same error msgs for different variables). Any idea what could be the error? Best regards, Alex Error in 'Create aggregate tables' org.jooq.exception.DataA...
No webpage was found for the web address: http://127.0.0.1:8081/calc
So I was able to install Open Foris Calc locally on my Mac computer; but when i tried to start the software I get the following error on web browser: on google chrome i get this error No webpage was found for the web address: http://127.0.0.1:8081/calc while on safari and Firefox i get empty page. H...
How to retrieve plot coordinates from NAFORMA data
Hi Open Foris Support Team; How can I extract plot coordinates from NAFORMA data using R studio. example if type View(Plot) R studio will let me see all Plot attributes e.g plot_id_, plot_region, vegetation_type.. but it doesn't display coordinates for Plot. How can be able to retrieve coordinate...
Where to calculate advanced statistics in Calc/Saiku?
Hi OF Team, I understand basic statistics are calculated directly in Saiku, using the button labelled with a Sigma. However, using this merely displays min, max, mean, sum and std. dev. Where would you recommend to calculate additional statistics like confidence intervals, SE%, etc.? Does this requ...
Calc vídeos shared in rome.
good morning, I write to consult on some short videos that were shared during the afternoon of calc training that took place in early December 2016 in Rome. I lost the link, they can share it please. greetings from Chile.
Calc filter by date error
Dear OF team, when i create a dataset in collect and successfuly import it to Calc i get an error if I want to filter tables according to dates. First of all, they are imported as text variables, which means you cannot filter for example years that are newer then 2001 (> 2001) and more importantly i...
format error when creating calc workspace from collec-data file
Dear OpenForis Team, when trying to create a calc workspace by importing a collect-data file we encounter the following Java Format error: ERROR (CollectDataController.java [importCollectData]:101) - Error extracting survey from Collect backup file java.lang.NumberFormatException: For input string:...
Most recently updated questions