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