---
title: "Creating sampling grid for Collect Earth"
url: "https://openforis.support/questions/1444/creating-sampling-grid-for-collect-earth"
tags: ["collectearth"]
status: "answered"
score: 0
answer_count: 3
asked: "2017-11-14T15:10:11"
last_activity: "2019-04-01T12:08:37"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Creating sampling grid for Collect Earth

Asked by jmbcarreiras on 2017-11-14

Greetings!

I created a grid in csv format according to the Collect Earth User Manual for Windows OS (section 5.4).

However, when I load the csv and save&apply changes using Tools > Properties > Sample Data, I get [this error][1]:

Any help is appreciated

Thanks


  [1]: https://drive.google.com/file/d/1FW5lC5Fc3vGWuKkCf8jfJI4nfuklgpTU/view?usp=sharing


## Answer (score 0, by Open Foris on 2017-11-14)

Link: https://openforis.support/questions/1444/creating-sampling-grid-for-collect-earth/1445

It seems that you are using the Namibia test survey.

If you go to Tools->Properties you can see that this survey expects a very simple CSV to define the sampling design. This CSV should just contain three columns : ID, YCOORDINATE, XCOORDINATE

If you want a simple way to produce a sample design over a country ( or province/district) you can use this script: [Google Earth Engine App to produce grid over country][1] . You just need to change the name of the country and the distance between the plots (it generates a systematic sample design)

After you **RUN** the script you nee to **click on the link on the right frame of the Code Editor (Console) to download the resulting CSV** and then "clean it" in Excel to just keep the ID, Latitude and Longitude columns. The CSV includes information on the country, province and district for the points.

Let us know is it still does not work!


  [1]: https://collectearth.users.earthengine.app/view/collect-earth-grid-generator

> Hi! Thank you so much for the prompt reply. I know this survey only expects those three columns and that's the csv I have generated and tried to load. But I keep getting the same error message. My sample points were generated using a stratified random approach and I thought I could use the Namibia test survey to load my sample dataset. But maybe I'm missing something... Many thanks again! (jmbcarreiras)

## Answer (score 0, by Open Foris on 2017-11-15)

Link: https://openforis.support/questions/1444/creating-sampling-grid-for-collect-earth/1452

Hello again.

The Namibia example is really old (we will create a new repository of example surveys instead of using the ones in the Collect Earth webiste) so maybe it is better if you use this one.

[Very Simple IPCC survey][1]

The CSV file expected for the sampling design for this one is also a simple one (ID, YCoordinate, XCoordinate)
Go to Tools->Properties and click the Browse button to select the one you have created

![alt text][2]

Hope this one works better!


  [1]: https://www.dropbox.com/s/wkybr0qtn2l0np1/simple_ipcc_survey_en_2017-11-15T17-00-31.cep?dl=0
  [2]: http://www.openforis.org/support/upfiles/soffice.bin_2017-11-15_16-58-08.png


## Answer (score 0, by jmbcarreiras on 2017-11-15)

Link: https://openforis.support/questions/1444/creating-sampling-grid-for-collect-earth/1454

Now it's working, thank you so much!

Best wishes
