john_es
Joined: 26/08/2010 12:29:41
Messages: 15
Offline
|
When I query the geoname database for a city such as Detroit with fcode = PPL, I get back multiple listings...
which one should I use:
4058738, 'Detroit', 'Detroit', 'Detroit,Детроит', 34.0281600, -88.1700400, 'P', 'PPL', 'US', '', 'AL', '075', '', '', 225, 110, 116, 'America/Chicago', '2010-01-29'
4237004, 'Detroit', 'Detroit', 'Detroit,Детроит', 39.6206000, -90.6767900, 'P', 'PPL', 'US', '', 'IL', '149', '', '', 88, 195, 191, 'America/Chicago', '2010-01-29'
4270359, 'Detroit', 'Detroit', '', 38.9350000, -97.1208500, 'P', 'PPL', 'US', '', 'KS', '041', '', '', 0, 347, 349, 'America/Chicago', '2006-01-15'
4617921, 'Detroit', 'Detroit', '', 35.5889700, -89.8136900, 'P', 'PPL', 'US', '', 'TN', '167', '', '', 0, 80, 82, 'America/Chicago', '2006-01-15'
4685987, 'Detroit', 'Detroit', 'Detroit,Детроит', 33.6615000, -95.2666200, 'P', 'PPL', 'US', '', 'TX', '387', '', '', 736, 147, 151, 'America/Chicago', '2010-01-29'
4962481, 'Detroit', 'Detroit', 'Detroit,Детроит', 44.7925700, -69.2967100, 'P', 'PPL', 'US', '', 'ME', '025', '', '', 848, 56, 61, 'America/New_York', '2010-01-29'
4990729, 'Detroit', 'Detroit', 'DTT,Detroit,Detroitas,Detrojt,Detrojto,Ntetroit,detoroito,detro'ita,di te lu,dtrwyt,dytrwyt,Ντητρόιτ,Детроит,Детройт,דטרויט,דעטרויט,ديترويت,डेट्रॉईट,デトロイト,底特律', 42.3314300, -83.0457500, 'P', 'PPL', 'US', '', 'MI', '163', '', '', 951270, 183, 181, 'America/Detroit', '2007-03-30'
5722994, 'Detroit', 'Detroit', 'Detroit,Детроит', 44.7340100, -122.1498000, 'P', 'PPL', 'US', '', 'OR', '047', '', '', 266, 491, 543, 'America/Los_Angeles', '2010-01-29'
|