funrecdiver
Contributor
Bored and stuck in Thai Government Curfew Lockdown (TGCL) I did some research on dive sites and coordinates in Thailand.
Then I created a Google Docs spreadsheet template where anyone can read but we need to be logged into edit the spreadsheet. My idea was to have a collaborative (non-commercial, non-promotional) spreadsheet and when coords are "fully confirmed" we lock down (protect) the confirmed cells in the spreadsheets.
When I looked up some dive site coordinates (for example the HTMS Khram), I found a lot of errors on many web sites. Some web sites have the coordinates completely wrong, some use the wrong format, and the ones that seem to be "in the ball park" use different coordinate systems. For example, some sites use the two main "standards" which seem to be (based on conversion software):
Some sites use odd systems that are not really considered "standard" (again, based on conversion software):
There is one site (which I don't want to name and embarrass them) who incorrectly label "Degrees" as "Minutes" on an entire web page of Thai dive coordinates.
Also, few of the coordinates from various web sites were easy to "cut-and-paste" into Google Maps or Google Earth (and have the way point properly appear).
Hence, my thoughts were that the Thailand dive community could benefit from a reliable, collaborative spreadsheet where the coordinates are both accurate and easily cut-and-paste into Google Maps/Earth.
So, for this new "ambitious collaborative spreadsheet" effort I have hastily conceived during TGCL, what standard do you recommend for dive site coordinates?
Then I created a Google Docs spreadsheet template where anyone can read but we need to be logged into edit the spreadsheet. My idea was to have a collaborative (non-commercial, non-promotional) spreadsheet and when coords are "fully confirmed" we lock down (protect) the confirmed cells in the spreadsheets.
When I looked up some dive site coordinates (for example the HTMS Khram), I found a lot of errors on many web sites. Some web sites have the coordinates completely wrong, some use the wrong format, and the ones that seem to be "in the ball park" use different coordinate systems. For example, some sites use the two main "standards" which seem to be (based on conversion software):
- DMS: Degrees Minutes Decimal-Seconds (with decimal seconds as required)
- Decimal-Degrees
Some sites use odd systems that are not really considered "standard" (again, based on conversion software):
- Degrees Decimal-Minutes
There is one site (which I don't want to name and embarrass them) who incorrectly label "Degrees" as "Minutes" on an entire web page of Thai dive coordinates.
Also, few of the coordinates from various web sites were easy to "cut-and-paste" into Google Maps or Google Earth (and have the way point properly appear).
Hence, my thoughts were that the Thailand dive community could benefit from a reliable, collaborative spreadsheet where the coordinates are both accurate and easily cut-and-paste into Google Maps/Earth.
So, for this new "ambitious collaborative spreadsheet" effort I have hastily conceived during TGCL, what standard do you recommend for dive site coordinates?