Hello, how can we upload a csv with custom polygons to Collect Earth now that Fusion Tables are not supported? What's an alternative way of getting the geometry attribute in the CSV? I have a custom plot layout that I am predefining with a CSV plot file.

asked 25 Oct '20, 22:53

radost's gravatar image

radost
2115
accept rate: 0%

converted to question 25 Oct '20, 22:55


GeoJSON is also supported, important to note that if you want to add extra data to the plots the geometry column must be the last one in the CSV!

alt text

This is an example of a survey to validate CCDC alerts using GeoJSON Polygons. DOWNLOAD CEP

alt text

permanent link

answered 19 May '23, 17:13

Open%20Foris's gravatar image

Open Foris ♦♦
9995714
accept rate: 10%

Dear Radost,

You are right, Fusion tables are discontinued and the proposed method to upload polygons is not working any more!

I have just released today a new version of Collect Earth (1.12.5) that fixes this by allowing the use of Well-Known-Text WKT or GeoJSON strings as opposed to the previous KML format.

This means that if one of the columns in the CSV of plots is a WKT or GeoJSON geometry, it will be used to draw the polygon in Collect Earth.

If you load a shapefile in QGis, you are able to export it to CSV ( see image in the bottom), and one of the options is to add the WKT geometry as a column, this is far easire than the previous methodology.

You still need to add an extra "From CSV" parameter to your survey called geo or geometry, which will be used to store the WKT geometry.

This is an example of a survey (with no questions) that is using a geometry column with WKT multipolygons : Super Simple WKT Survey

The CSV used in this case looks like this (the vertices of the geometries are removed as it gets quite long):

id,YCoordinate,XCoordinate,geometry
1,0,0,"MULTIPOLYGON ((( ... )))" 
2,0,0,"MULTIPOLYGON ((( ... )))" 
3,0,0,"MULTIPOLYGON (((   )))" 
4,0,0,"MULTIPOLYGON ((( ... )))"

Let me know if you have problems arranging your survey!

alt text

permanent link

answered 05 Nov '20, 15:12

collectearth's gravatar image

collectearth ♦
1.0k16
accept rate: 17%

edited 05 Nov '20, 16:08

Thank you for creating a work around for fusion table

(14 Dec '20, 17:04) radost radost'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:

×281

question asked: 25 Oct '20, 22:53

question was seen: 1,931 times

last updated: 19 May '23, 17:13