This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
For the app i’m creating I need coordinates in a different format than WGS84. Please make more formats available, this would really help me out.
Its the final step in completing my app.
@Edwin_Pleijsier
Though AppSheet does not offer a GPS system other than WGS 84 right at the moment, as far as my research it’s quite doable with webhook scripting.
@Edwin_Pleijsier
I will try to sort out something in my sample app for you but frankly I have never tried this before so I cannot promise for a success though I’m an expert at scripting. Will ping you under this post when I complete and test it. Let me investigate it a bit from the web page you have forwarded.
Maybe this you be helpfull to solve your problem :
This google script seems really higly customizable.
Im sure with some little modifications its possible to add a new projection plus a “select projection” parameter
Appsheet rely only with google Maps wich is only WGS84:4326
The support of other map service will be a real big plus even the Google Cloud Maps Platform will be a big win [ i hope for uMap OSM but ArcGisMapServer will be a dream]
I ran some test to make an “AppsheetGIS” [PostGIS and Google Spreadsheet script for .dbf in/out etc…] its workable but the lack of an "Shapefile or GEOJson support doesn’t make it fully GIS complaint.
One caveate is that the formula doesn’t take into account movement of the land over time, which NZTM is meant to. The official website where I got the formulae from doesn’t have this aspect on it. I’ll update if I ever hear back from them about it. The error shouldn’t be more than a metre though, which is inside the error of standard GPS anyway.
I came across a really easy API for coordinate conversion. It simply returns results as a JSON from a simple http request. e.g. http://epsg.io/trans?x=174&y=-41&z=0&s_srs=4326&t_srs=2193
I’ve written some code in App Script to run this as a web app. See here for mor info: