Our partners in Kyrgyzstan would like to correct the plot attributes within the grid csv/ced file while also retaining data that has already been entered within Collect Earth for each plot.
Is it possible to re-upload a grid ced file with different supplementary attributes (like elevation, slope, aspect and region, NOT core attributes like plot id and XY coordinate) and have it automatically inherit data associated with the plot id in the database?
Would Saiku correct the supplementary attribute (region in this particular case) when regenerating the Saiku database?
asked 29 Oct '14, 16:04
In order to achieve this functionality ( to update the values of certain variables that have already been collected ) you need to follow these steps:
So for instance if you have a variable called "region" and when you were assessing the plots through Collect Earth that variable was not set properly. See example of a plot location file which had no good information when it was created (missing elevation, slope,aspect and region data):
Now I want to fix the region information, so what I should do is to generate a CSV file with two columns : id (which would be the ID of the plot and is usually found as the first column of a plot location file - .ced ) and region like this
That is it, if you followed the steps correctly the values stored for those variables should have changed in the Collect database ( attention : this process only updates data that is already there, it doesn't add new registers )
When you start Saiku again choose the option to refresh the Saiku database so this information is reloaded by Saiku and shown for the analysis.
Hope that was clear!
One can always add a new attribute to the survey through the Survey Designer, e.g. a region attribute of type text. Then you export the survey as a CEP file so that you can load it in Collect Earth.
This means that in the database of Collect Earth you will have your current data plus a new variable, which will be empty, called region (per record).
Finally you update the database with the process that is explained in the previous response, where you are only specifying the value for the variable region and referencing the record by its plot id.
Of course, for the area calculation to work you need to make sure that the values of the region update to the DB coincide with the values of the region on the areas_per_attribute.csv file...
After you add the "region"to the survey then you use a CSV to update it (Tools->Data Import/Export->Update current records using CSV ) like this
And then the areas_per_attribute should be something like (beware of the column name headers):
answered 19 May '16, 22:58
Open Foris ♦♦
Please, forgive me if the above answer or similar question has already been addressed. I am wondering how best to automatically update existing records at sql database during the QC/QA of completed grid.
example: I have a park boundary shapefile, and there is a column heading in my grid with the question what is the "land management" type?
I wanted to update all answers with discrepancies under this question into "conservation/protected" instead of correcting every record manually could I do this automatically somewhere and sync into SAIKU? Thank you! Tesfay
answered 11 Jul '16, 22:16
From Collect Earth the easiest thing to do would be :
So at the end you have the list of all of the plots in the DB that you want to update and their newer values!
Afterwards you can run Saiku again (making sure to say that you want to update the Saiku database when your are prompted). And that should it....
Hope this clarifies!
Thanks again! interestingly, it is not updating the records in SAIKU database. But when I check the exported .cvs file. I do see the class was updated in csv file.
answered 15 Jul '16, 20:41