News for hackers. Stuff that matters.
Re:Show HN: For all cities over 100k, calculated the farthes... by googleme on Monday July 31, 2017 @11:23AM (#14892816)
How I built this: I pulled the population data from the UN statistics report on cities over 100k and then batch geocoded all of the cities (there was also a fair bit of data cleansing required). I then used a macro in excel to calculate the distance between every city pair (using Vincenty's formula) and uploaded the results to a database. Happy to share more if anyone is curious.
Re:Show HN: For all cities over 100k, calculated the farthes... by qubex on Monday July 31, 2017 @11:31AM (#14892895)
This is quite fun actually. I live in Milan (Italy) and my cousin lives in Aukland (NZ). These cities are listed as being the furthest from each other at more than 18,000 km.

Incidentally as a kid I was quite obsessed with the idea of visiting the antipode of my home's exact geographic location, but sadly, when I finally got around to calculating it, I discovered it lay in a nondescript expanse of ocean.

Re:Show HN: For all cities over 100k, calculated the farthes... by mapster on Monday July 31, 2017 @02:57PM (#14894911)
Whats the tech stack may I ask? I like the simple design and interactions. easy to noodle around and learn.
Re:Show HN: For all cities over 100k, calculated the farthes... by googleme on Tuesday August 01, 2017 @02:49AM (#14898406)
Just some simple PHP / MySQL
Re:Show HN: For all cities over 100k, calculated the farthes... by mapster on Tuesday August 01, 2017 @01:22PM (#14903089)
ok. was wondering if you used open source data tools etc.
Re:Show HN: For all cities over 100k, calculated the farthes... by googleme on Wednesday August 02, 2017 @01:25PM (#14912656)
I took the list of 4 thousand odd cities from the UN statistics report of cities over 100k and then ran it through the batch geocoding site: http://www.findlatitudeandlongitude.com/ ... apart from that just old fashioned excel to calculate
Re:Show HN: For all cities over 100k, calculated the farthes... by jim_d on Monday July 31, 2017 @02:56PM (#14894893)
This was definitely fun to try.