geometry attribute in CSV without Fusion Table?

  • Asked
  • Active
  • Viewed 4950 times
0

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.

1

Accepted answer

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

Thank you for creating a work around for fusion table

radost radost
0

Accepted answer

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

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.