IMPORTANT MESSAGE. We need your support now to keep running. 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:

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 is an outreach project of the Hudson Institute of Mineralogy, a 501(c)(3) not-for-profit organization.
Copyright © and the Hudson Institute of Mineralogy 1993-2018, except where stated. relies on the contributions of thousands of members and supporters.
Privacy Policy - Terms & Conditions - Contact Us Current server date and time: November 13, 2018 22:48:04
Go to top of page