URGENT MESSAGE: Time is running out. Click here to find out why.
Log InRegister
Home PageAbout MindatThe Mindat ManualHistory of MindatCopyright StatusWho We AreContact UsAdvertise on Mindat
Donate to MindatCorporate SponsorshipSponsor a PageSponsored PagesMindat AdvertisersAdvertise on Mindat
Learning CenterWhat is a mineral?The most common minerals on earthInformation for Educators
Minerals by PropertiesMinerals by ChemistryAdvanced Locality SearchRandom MineralRandom LocalitySearch by minIDLocalities Near MeSearch ArticlesSearch GlossaryMore Search Options
Search For:
Mineral Name:
Locality Name:
The Mindat ManualAdd a New PhotoRate PhotosLocality Edit ReportCoordinate Completion ReportAdd Glossary Item
StatisticsThe ElementsUsersBooks & MagazinesMineral MuseumsMineral Shows & EventsThe Mindat DirectoryDevice Settings
Photo SearchPhoto GalleriesNew Photos TodayNew Photos YesterdayMembers' Photo GalleriesPast Photo of the Day Gallery

Rounding error in Lat/Long

Posted by Bruce Kelley  
Bruce Kelley February 13, 2018 10:27PM
The WGS84 Latitude and Longitude has a rounding error such that it can end up with X° Y' 60'' rather than the correct X° Y+1' 0".
An example can be found here: https://www.mindat.org/loc-19989.html

Latitude & Longitude (WGS84): 68° 52' 60'' North , 140° 17' 60'' East
Latitude & Longitude (decimal): 68.8833333333, 140.3
David Von Bargen February 14, 2018 09:21AM
It's a bug that got fixed in the location edit, but some of the previously generated lat/long are still in the database.
Uwe Kolitsch February 14, 2018 10:57AM
David: can you find out how many datasets? If manually fixing them would be too time-consuming, could this be done by some kind of search-and-replace method?
David Von Bargen February 14, 2018 11:12AM
It is only a problem in the longitude field. There are 2300 records.
Sorry, only registered users may post in this forum.

Click here to login

Mineral and/or Locality  
Mindat.org is an outreach project of the Hudson Institute of Mineralogy, a 501(c)(3) not-for-profit organization.
Copyright © mindat.org and the Hudson Institute of Mineralogy 1993-2018, except where stated. Mindat.org relies on the contributions of thousands of members and supporters.
Privacy Policy - Terms & Conditions - Contact Us Current server date and time: August 22, 2018 08:04:19
Go to top of page