I am trying to prepare a test survey. I have prepared the points grid in QGIS, and have prepared the relevant csv file. However, when trying to open the file in Collect Earth as per manual, I get an error null message

I have made some tests modifying the csv file, and even installed LibreOffice to ensure that the problem was not in Excel, but with no result.

asked 14 Oct '14, 13:35

rbiancalani's gravatar image

rbiancalani
11445
accept rate: 0%


Final answer: Although the previous answers are valid as possible sources of problems when creating Plot location files ( the CSV files where the plot locations and IDs are stores) the real source of the problem for this user was an error on the documentation.

At the end of the process for creating the plot file in the documentation it just says that one should import the file.

This is true but not complete information. In order to import the file with the plot locations one has to go to Tools->Properties and in the first tab "Sample data" one needs to load the CSV file by clicking on the Browse button.

alt text

permanent link

answered 15 Oct '14, 16:05

sanchez_paus's gravatar image

sanchez_paus
161113
accept rate: 50%

Hi,

This could be caused by a multitude of factors.

The most likely problem is that the software you are using is not saving the CSV with the format that Collect Earth expects.

The data in the CSVs read by collect earth mus be lines with the columns separated by commas ( the use of double-quotes is not necessary although it doesn't hurt ). If you are using Excel and you save the file using the CSV (MS-DOS) format it should be fine.

So when you open the file in Notepad or similar it should look like this:

ID,LATITUDE,LONGITUDE,ELEVATION,SLOPE,ASPECT,REGION    
"68050","13.44","102.4","151","0.39","168.69","Battambang"    
"68054","13.44","102.44","147","2.91","10.71","Battambang"    
"68058","13.44","102.48","111","1.47","198.43","Battambang"    
"68062","13.44","102.52","94","0.98","341.57","Battambang"    
"68066","13.44","102.56","82","0.39","11.31","Battambang"

The only absolutely necessary columns are the three first columns, ID,LATITUDE,LONGITUDE you can keep the other columns and just fill the cells with zeroes and empty values like so:

ID,LATITUDE,LONGITUDE,ELEVATION,SLOPE,ASPECT,REGION    
"68050","13.44","102.4","0","0","0","NA"    
"68054","13.44","102.44","0","0","0","NA"    
"68058","13.44","102.48","0","0","0","NA"    
"68062","13.44","102.52","0","0","0","NA"    
"68066","13.44","102.56","0","0","0","NA"

Keep in mind that the first column ID is very important that the IDs for each plot are unique as Collect will use this information when it retrievex/stores the data for the plot.

permanent link

answered 14 Oct '14, 14:17

sanchez_paus's gravatar image

sanchez_paus
161113
accept rate: 50%

On another note, if you are not a great expert on QuantumGIS and want to add the region and DEM data (elevation,slope,aspect) you can do it through Google Earth Engine playground ( you must be a trusted tester though ).

First you must upload the points you generated in QuantumGIS to a fusion table

I have uploaded a test one here link.

Then you can use a script like this one ( if you are not a trusted tester for Google Earth Engine ask here )

Link to script

This script not only adds SRTM and Administrative area data but also Global Forest Change data for the plot, which might come handy if you want to validate the Global Forest Change product.

permanent link

answered 14 Oct '14, 14:51

sanchez_paus's gravatar image

sanchez_paus
161113
accept rate: 50%

Hi I am using the software suggested in the Collect Earth User Manual, that is QGIS and LibreOffice Calc. Nonetheless, the file exported at the end of the process has the figures saved as numbers, with no quotes. It is possible that this is the problem. I am trying to solve it but it is not easy, at least for me.

(14 Oct '14, 15:26) rbiancalani rbiancalani's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×284

question asked: 14 Oct '14, 13:35

question was seen: 24,499 times

last updated: 15 Oct '14, 16:05