![]() Just open this spreadsheet , make a copy and see the formulae in action. With this script enabled in your Google Spreadsheet, you have access to 2 custom functions – DegreesToUTM(latitude, longitude) and UTMToDegrees(easting, norting, zone) that you can use in the formula like any other built-in function. I was able to adapt it to be used as a Apps Script in Google Spreadsheets. I found the excellent open-source YouTim: Javascript UTM Conversion library. As the data was being constantly updated, any offline solution that require exporting and importing the conversion would be cumbersome. ![]() They were collecting field data in UTM coordinates and needed a way to convert them to Latitude and Longitude to map them. Recently, someone presented me with an interesting challenge. cs2cs program, part of the PROJ.4 library is my favorite. There are a number of command line tools also available for performing bulk-conversions. Converting between different coordinate reference systems or projection is a fairly standard feature in a GIS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |