Remove some records (test plots) from existing sqlite .db file

Question

We would like to remove some records from existing sqlite .db file. Could you please explain how to implement this removing?

Answer 1

0	For a newer and improved function to delete plots please see the answer to THIS QUESTION IN THE FORUM! permanent link answered 25 Aug '21, 09:54 Open Foris ♦♦ 999●5●7●14 accept rate: 10%

Answer 2

Dear Haraguchi,

As of now there is no easy way to do this, we will be adding a function to do this in coming versions,

Right now, as we don't have a better way, you will need to install the "SQLite Database Browser" application so that you can remove the records directly from the database.

Open the application and then open the Collect Earth database ( located in the file C:\Users\SanchezPausDiaz\AppData\Roaming\CollectEarth\collectEarthDatabase.db )

Once you open the database find the ID of the survey in the ofc_survey table.

Then you can run the query :

delete from ofc_record where of_survey_id = 1 and key1=PLOT_ID

Substitute PLOT_ID with the ID of the record you want to remove.

alt text

Remove some records (test plots) from existing sqlite .db file

Follow this question

Related questions