I am trying to import Table data into GEE. The original CSV file is at TERN Star Transects. I have followed the steps at GEE Importing Table Data (including making sure to specify either the x and y columns as "ref_x" and "ref_y", or the primary geometry column as "geom"), however I'm encountering two issues.
- Ingesting the Table (or seemingly any other table from a CSV file) increases the absolute value of the x and y coordinates of any point by around 7.
- Points appear as (160.84, 34.56) when they should be (160.84, -34.56), as they are in the CSV. This missing minus sign results in the points being placed off the coast of Japan when they should only be over Australia.
The code I'm using to display the points is
var STAR_TRANSECTS = ee.FeatureCollection("your_file_location");
print('STAR_TRANSECTS',STAR_TRANSECTS);
Map.addLayer(STAR_TRANSECTS, {}, 'STAR_TRANSECTS');
Some things I've tried:
- A fresh new CSV test file: fixes the problem with negatives not appearing but doesn't solve the weird scaling issue.
- Using someone else's CSV file they had attached to a StackExchange question. This works fine, including when I add negative values to their table!? Adding a CSV with GPS coordinates points to Google Earth Engine
- Pulling the CSV file into R. R is able to read the negative sign. Exporting as a CSV from R and trying to upload that file to GEE did not solve the issues.
More details to help solve this:
Previous thread on Tables and GEE: Adding x,y coordinates from table in Google Earth Engine
The website I am retrieving the CSV file from (includes some more info on its properties) http://data.auscover.org.au/xwiki/bin/view/Product+pages/SLATS+Star+Transect+Data
At this point I'm not sure if I'm completely misunderstanding something about GEE or if there is a problem with the original data.