Changing plot attributes in the Collect Earth database

Dear Tesfay,

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

id,region 
1,Region1 
2,Region1
3,Region2

And then the areas_per_attribute should be something like (beware of the column name headers):

region,area,weight
Region1,10000,1
Region2,5000,1

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

Hi Tesfay,

From Collect Earth the easiest thing to do would be :

1. Create a CSV file with the data ( go to Tools->Data Import/Export -> Export data to CSV)

2. Open the file using Excel, LibreOffice or any other style sheet type of software. In Excel you will need to load the CSV file by using the Data tab

3. Now filter the data however you want through Excel/LibreOffice and remove all the columns in the CSV file except for the id ( the id of the plot in the DB) column and the column that you want to update. The result would be something like (assuming the attribute you want to change is called land_management, check the headers in your CSV!! ):

id,land_management

1,"conservation/protected"

2,"conservation/protected"

3,"conservation/protected"

4,"conservation/protected"

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!

1. SO the last steep is to import this data back into Collect Earth. Go to Tools->Data Import/Export->Update current records using CSV , and use this CSV that you have created!

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.

Tesfay