Guest guest Posted November 21, 2001 Report Share Posted November 21, 2001 Pranaam Sanjay, Thanks to Nimmi, I got the CD with data and created a database with it in my own searchable format. I am attaching some statistics about the database below. You can find the number of cities included from each country. ACS atlas (which costs $500 per year in fees and 10% royalties on our revenues) has 150,000 US towns and 100,000 international towns. Our JH atlas now has many more international cities. We have 206,000 towns from Russia alone, 119,000 towns from Iran alone and 115,000 towns from China alone (they have 100,000 towns from all over the world, excluding USA)! The total number of towns in JH atlas now is 2,848,696 (including USA). This is about 11.4 times the ACS atlas. The size of the .adb file is 64 MB. Search for a town is faster if the name of the country is known, but one can still search in the whole world too. The software development is in the final stages now. Vijay made an InstallShield script. I will soon talk about the online help preparation. We are getting there... Software development is never-ending process if you want a perfect product. I am shooting for a " code freeze " as early as possible. So I am taking up only that additional work which is absolutely essential and without which the product cannot be released. May Jupiter's light shine on us, Narasimha -------------------------- Zimbabwe: 1262 places (total is 1262) Zambia: 15043 places (total is 16305) Yemen: 12318 places (total is 28623) Yugoslavia: 19850 places (total is 48473) Swaziland: 117 places (total is 48590) Samoa: 351 places (total is 48941) Western Sahara: 79 places (total is 49020) Wallis and Futuna: 40 places (total is 49060) West Bank: 1260 places (total is 50320) Namibia: 2380 places (total is 52700) Vietnam: 34750 places (total is 87450) British Virgin Islands: 22 places (total is 87472) Venezuela: 20598 places (total is 108070) St Vincent and the Gre...: 87 places (total is 108157) Uzbekistan: 5749 places (total is 113906) Uruguay: 1129 places (total is 115035) Burkina Faso: 10836 places (total is 125871) Ukraine: 43913 places (total is 169784) Uganda: 6211 places (total is 175995) Tanzania: 8552 places (total is 184547) Turkmenistan: 1935 places (total is 186482) Taiwan: 17840 places (total is 204322) Tuvalu: 14 places (total is 204336) Turkey: 59768 places (total is 264104) East Timor: 1705 places (total is 265809) Tunisia: 3884 places (total is 269693) Sao Tome and Principe: 250 places (total is 269943) Togo: 5345 places (total is 275288) Tonga: 139 places (total is 275427) Tokelau: 1 places (total is 275428) Turks and Caicos Islands: 21 places (total is 275449) Tajikistan: 3544 places (total is 278993) Thailand: 39971 places (total is 318964) Trinidad and Tobago: 561 places (total is 319525) Switzerland: 3648 places (total is 323173) Syria: 18735 places (total is 341908) South Georgia and the ...: 2 places (total is 341910) Sweden: 30395 places (total is 372305) Svalbard: 19 places (total is 372324) Sudan: 11316 places (total is 383640) St Lucia: 15263 places (total is 398903) Spain: 36661 places (total is 435564) Somalia: 6449 places (total is 442013) Singapore: 459 places (total is 442472) San Marino: 5 places (total is 442477) Sierra Leone: 8497 places (total is 450974) Slovenia: 4988 places (total is 455962) St Helena: 16 places (total is 455978) Senegal: 12333 places (total is 468311) South Africa: 14126 places (total is 482437) Seychelles: 21 places (total is 482458) St Kitts and Nevis: 187 places (total is 482645) St Pierre and Miquelon: 3 places (total is 482648) Saudi Arabia: 4677 places (total is 487325) Rwanda: 1623 places (total is 488948) Russia: 206323 places (total is 695271) Philippines: 42347 places (total is 737618) Romania: 29053 places (total is 766671) Marshall Islands: 6 places (total is 766677) Reunion: 432 places (total is 767109) Qatar: 326 places (total is 767435) Guinea-Bissau: 5509 places (total is 772944) Palau: 461 places (total is 773405) Papua New Guinea: 14530 places (total is 787935) Portugal: 17377 places (total is 805312) Panama: 8063 places (total is 813375) Poland: 56069 places (total is 869444) Pakistan: 38087 places (total is 907531) Spratly Islands: 1 places (total is 907532) Peru: 28880 places (total is 936412) Pitcairn Islands: 1 places (total is 936413) Paraguay: 2607 places (total is 939020) New Zealand: 2682 places (total is 941702) Nicaragua: 3493 places (total is 945195) Netherlands Antilles: 276 places (total is 945471) Suriname: 740 places (total is 946211) Nauru: 13 places (total is 946224) Nepal: 1108 places (total is 947332) Norway: 13598 places (total is 960930) No Mans Land: 41 places (total is 960971) Netherlands: 9384 places (total is 970355) Nigeria: 37566 places (total is 1007921) Vanuatu: 1401 places (total is 1009322) Niger: 9158 places (total is 1018480) Norfolk Island: 1 places (total is 1018481) Niue: 16 places (total is 1018497) New Caledonia: 743 places (total is 1019240) Mozambique: 24693 places (total is 1043933) Malaysia: 18238 places (total is 1062171) Mexico: 66742 places (total is 1128913) Mexico: 3664 places (total is 1132577) Maldives: 29 places (total is 1132606) Oman: 2911 places (total is 1135517) Malta: 604 places (total is 1136121) Mauritania: 1121 places (total is 1137242) Mauritius: 382 places (total is 1137624) Morocco: 29951 places (total is 1167575) Monaco: 7 places (total is 1167582) Mali: 12820 places (total is 1180402) Macedonia: 3107 places (total is 1183509) Malawi: 5164 places (total is 1188673) Montserrat: 92 places (total is 1188765) Mongolia: 6163 places (total is 1194928) Mayotte: 128 places (total is 1195056) Moldova: 5866 places (total is 1200922) Macau: 18 places (total is 1200940) Martinique: 843 places (total is 1201783) Madagascar: 28190 places (total is 1229973) Libya: 2004 places (total is 1231977) Luxembourg: 980 places (total is 1232957) Lesotho: 446 places (total is 1233403) Liechtenstein: 35 places (total is 1233438) Slovakia: 6956 places (total is 1240394) Liberia: 8907 places (total is 1249301) Lithuania: 17239 places (total is 1266540) Latvia: 9392 places (total is 1275932) Lebanon: 6754 places (total is 1282686) Laos: 14117 places (total is 1296803) Kazakhstan: 16416 places (total is 1313219) Kuwait: 289 places (total is 1313508) Christmas Island: 6 places (total is 1313514) Korea South: 25715 places (total is 1339229) Kiribati: 174 places (total is 1339403) Korea North: 27382 places (total is 1366785) Kyrgyzstan: 1524 places (total is 1368309) Kenya: 3056 places (total is 1371365) Jordan : 1984 places (total is 1373349) Jamaica: 2743 places (total is 1376092) Jersey: 46 places (total is 1376138) Japan: 17868 places (total is 1394006) Iraq: 15812 places (total is 1409818) Cote D'Ivoire (Ivory C...: 11309 places (total is 1421127) Italy: 21356 places (total is 1442483) Israel: 3480 places (total is 1445963) Iran: 119643 places (total is 1565606) Man Isle of: 45 places (total is 1565651) Indonesia: 38362 places (total is 1604013) Iceland: 590 places (total is 1604603) Hungary: 19522 places (total is 1624125) Croatia: 12431 places (total is 1636556) Honduras: 14471 places (total is 1651027) Hong Kong: 1373 places (total is 1652400) Haiti: 12106 places (total is 1664506) Gaza Strip: 62 places (total is 1664568) Guyana: 629 places (total is 1665197) Guinea: 8416 places (total is 1673613) Guatemala: 7709 places (total is 1681322) Greece: 21494 places (total is 1702816) Guadeloupe: 566 places (total is 1703382) Germany: 80260 places (total is 1783642) Greenland: 636 places (total is 1784278) Guernsey: 40 places (total is 1784318) Grenada: 323 places (total is 1784641) Gibraltar: 8 places (total is 1784649) Ghana: 16491 places (total is 1801140) Georgia: 7552 places (total is 1808692) Gabon: 4410 places (total is 1813102) Gambia: 2741 places (total is 1815843) French Southern and An...: 1 places (total is 1815844) France: 75178 places (total is 1891022) French Polynesia: 366 places (total is 1891388) Faroe Islands: 456 places (total is 1891844) Micronesia: 919 places (total is 1892763) Falkland Islands: 92 places (total is 1892855) Fiji: 1680 places (total is 1894535) Finland: 13957 places (total is 1908492) French Guiana: 805 places (total is 1909297) Czech Republic: 23750 places (total is 1933047) Ethiopia: 14342 places (total is 1947389) El Salvador: 5275 places (total is 1952664) Eritrea: 1258 places (total is 1953922) Estonia: 9967 places (total is 1963889) Equatorial Guinea: 2966 places (total is 1966855) Ireland: 9471 places (total is 1976326) Egypt: 12799 places (total is 1989125) Ecuador: 9631 places (total is 1998756) Dominican Republic: 11409 places (total is 2010165) Dominica: 127 places (total is 2010292) Djibouti: 89 places (total is 2010381) Denmark: 9685 places (total is 2020066) Cyprus: 2877 places (total is 2022943) Cook Islands: 35 places (total is 2022978) Cape Verde: 326 places (total is 2023304) Cuba: 11205 places (total is 2034509) Central Africa Republic: 6127 places (total is 2040636) Costa Rica: 2995 places (total is 2043631) Colombia: 25109 places (total is 2068740) Comoros: 600 places (total is 2069340) Cameroon: 10318 places (total is 2079658) Cocos (Keeling) Islands: 1 places (total is 2079659) Cayman Islands: 75 places (total is 2079734) Chile: 4547 places (total is 2084281) China: 115766 places (total is 2200047) Congo Democratic Repub...: 25960 places (total is 2226007) Congo Republic of the: 7577 places (total is 2233584) Sri Lanka: 20718 places (total is 2254302) Chad: 11943 places (total is 2266245) Cambodia: 15352 places (total is 2281597) Canada: 5536 places (total is 2287133) Burundi: 2564 places (total is 2289697) Brunei: 343 places (total is 2290040) Bulgaria: 20773 places (total is 2310813) Bhutan: 285 places (total is 2311098) Brazil: 43869 places (total is 2354967) Solomon Islands: 3747 places (total is 2358714) Belarus: 17111 places (total is 2375825) Benin: 4507 places (total is 2380332) Burma/Myanmar: 41432 places (total is 2421764) Bolivia: 18651 places (total is 2440415) Bosnia and Herzegovina: 23770 places (total is 2464185) Belize: 570 places (total is 2464755) Bangladesh: 32470 places (total is 2497225) Bahamas The: 511 places (total is 2497736) Belgium: 17461 places (total is 2515197) Bermuda: 22 places (total is 2515219) Botswana: 547 places (total is 2515766) Barbados: 539 places (total is 2516305) Bahrain: 344 places (total is 2516649) Anguilla: 42 places (total is 2516691) Austria: 16937 places (total is 2533628) Argentina: 9152 places (total is 2542780) Angola: 15305 places (total is 2558085) Andorra: 92 places (total is 2558177) Armenia: 2881 places (total is 2561058) Albania: 13807 places (total is 2574865) Azerbaijan: 11168 places (total is 2586033) Algeria: 10170 places (total is 2596203) Afghanistan: 33956 places (total is 2630159) United Arab Emirates: 777 places (total is 2630936) Antigua and Barbuda: 184 places (total is 2631120) Aruba: 115 places (total is 2631235) Australia: 10423 places (total is 2641658) India: 26911 places (total is 2668569) UK: 16869 places (total is 2685438) USA: 163258 places (total is 2848696) Number of cities in the generated database = 2848696 Quote Link to comment Share on other sites More sharing options...
Guest guest Posted November 22, 2001 Report Share Posted November 22, 2001 Namaste Narasimha, this is excellent. 2.8Million sites in 64MB of space is reasonable ( that's about ~ 3K per site). Does the Atlas folks also provide updates to the data throughout the year? and does it discern between the sites that use Daylight savings time , war time? etc? Just curious. ! Shanti, Shanti Shanti Frank in Austin , Fschmidt pvr108 [pvr108] Wednesday, November 21, 2001 12:28 PMjhora Subject: JH Atlas StatisticsPranaam Sanjay,Thanks to Nimmi, I got the CD with data and created a database with it in my own searchable format. I am attaching some statistics about the database below. You can find the number of cities included from each country.ACS atlas (which costs $500 per year in fees and 10% royalties on our revenues) has 150,000 US towns and 100,000 international towns. Our JH atlas now has many more international cities. We have 206,000 towns from Russia alone, 119,000 towns from Iran alone and 115,000 towns from China alone (they have 100,000 towns from all over the world, excluding USA)! The total number of towns in JH atlas now is 2,848,696 (including USA). This is about 11.4 times the ACS atlas. The size of the .adb file is 64 MB. Search for a town is faster if the name of the country is known, but one can still search in the whole world too.The software development is in the final stages now. Vijay made an InstallShield script. I will soon talk about the online help preparation. We are getting there...Software development is never-ending process if you want a perfect product. I am shooting for a "code freeze" as early as possible. So I am taking up only that additional work which is absolutely essential and without which the product cannot be released.May Jupiter's light shine on us,Narasimha-------------------------- Zimbabwe: 1262 places (total is 1262)Zambia: 15043 places (total is 16305)Yemen: 12318 places (total is 28623)Yugoslavia: 19850 places (total is 48473)Swaziland: 117 places (total is 48590)Samoa: 351 places (total is 48941)Western Sahara: 79 places (total is 49020)Wallis and Futuna: 40 places (total is 49060)West Bank: 1260 places (total is 50320)Namibia: 2380 places (total is 52700)Vietnam: 34750 places (total is 87450)British Virgin Islands: 22 places (total is 87472)Venezuela: 20598 places (total is 108070)St Vincent and the Gre...: 87 places (total is 108157)Uzbekistan: 5749 places (total is 113906)Uruguay: 1129 places (total is 115035)Burkina Faso: 10836 places (total is 125871)Ukraine: 43913 places (total is 169784)Uganda: 6211 places (total is 175995)Tanzania: 8552 places (total is 184547)Turkmenistan: 1935 places (total is 186482)Taiwan: 17840 places (total is 204322)Tuvalu: 14 places (total is 204336)Turkey: 59768 places (total is 264104)East Timor: 1705 places (total is 265809)Tunisia: 3884 places (total is 269693)Sao Tome and Principe: 250 places (total is 269943)Togo: 5345 places (total is 275288)Tonga: 139 places (total is 275427)Tokelau: 1 places (total is 275428)Turks and Caicos Islands: 21 places (total is 275449)Tajikistan: 3544 places (total is 278993)Thailand: 39971 places (total is 318964)Trinidad and Tobago: 561 places (total is 319525)Switzerland: 3648 places (total is 323173)Syria: 18735 places (total is 341908)South Georgia and the ...: 2 places (total is 341910)Sweden: 30395 places (total is 372305)Svalbard: 19 places (total is 372324)Sudan: 11316 places (total is 383640)St Lucia: 15263 places (total is 398903)Spain: 36661 places (total is 435564)Somalia: 6449 places (total is 442013)Singapore: 459 places (total is 442472)San Marino: 5 places (total is 442477)Sierra Leone: 8497 places (total is 450974)Slovenia: 4988 places (total is 455962)St Helena: 16 places (total is 455978)Senegal: 12333 places (total is 468311)South Africa: 14126 places (total is 482437)Seychelles: 21 places (total is 482458)St Kitts and Nevis: 187 places (total is 482645)St Pierre and Miquelon: 3 places (total is 482648)Saudi Arabia: 4677 places (total is 487325)Rwanda: 1623 places (total is 488948)Russia: 206323 places (total is 695271)Philippines: 42347 places (total is 737618)Romania: 29053 places (total is 766671)Marshall Islands: 6 places (total is 766677)Reunion: 432 places (total is 767109)Qatar: 326 places (total is 767435)Guinea-Bissau: 5509 places (total is 772944)Palau: 461 places (total is 773405)Papua New Guinea: 14530 places (total is 787935)Portugal: 17377 places (total is 805312)Panama: 8063 places (total is 813375)Poland: 56069 places (total is 869444)Pakistan: 38087 places (total is 907531)Spratly Islands: 1 places (total is 907532)Peru: 28880 places (total is 936412)Pitcairn Islands: 1 places (total is 936413)Paraguay: 2607 places (total is 939020)New Zealand: 2682 places (total is 941702)Nicaragua: 3493 places (total is 945195)Netherlands Antilles: 276 places (total is 945471)Suriname: 740 places (total is 946211)Nauru: 13 places (total is 946224)Nepal: 1108 places (total is 947332)Norway: 13598 places (total is 960930)No Mans Land: 41 places (total is 960971)Netherlands: 9384 places (total is 970355)Nigeria: 37566 places (total is 1007921)Vanuatu: 1401 places (total is 1009322)Niger: 9158 places (total is 1018480)Norfolk Island: 1 places (total is 1018481)Niue: 16 places (total is 1018497)New Caledonia: 743 places (total is 1019240)Mozambique: 24693 places (total is 1043933)Malaysia: 18238 places (total is 1062171)Mexico: 66742 places (total is 1128913)Mexico: 3664 places (total is 1132577)Maldives: 29 places (total is 1132606)Oman: 2911 places (total is 1135517)Malta: 604 places (total is 1136121)Mauritania: 1121 places (total is 1137242)Mauritius: 382 places (total is 1137624)Morocco: 29951 places (total is 1167575)Monaco: 7 places (total is 1167582)Mali: 12820 places (total is 1180402)Macedonia: 3107 places (total is 1183509)Malawi: 5164 places (total is 1188673)Montserrat: 92 places (total is 1188765)Mongolia: 6163 places (total is 1194928)Mayotte: 128 places (total is 1195056)Moldova: 5866 places (total is 1200922)Macau: 18 places (total is 1200940)Martinique: 843 places (total is 1201783)Madagascar: 28190 places (total is 1229973)Libya: 2004 places (total is 1231977)Luxembourg: 980 places (total is 1232957)Lesotho: 446 places (total is 1233403)Liechtenstein: 35 places (total is 1233438)Slovakia: 6956 places (total is 1240394)Liberia: 8907 places (total is 1249301)Lithuania: 17239 places (total is 1266540)Latvia: 9392 places (total is 1275932)Lebanon: 6754 places (total is 1282686)Laos: 14117 places (total is 1296803)Kazakhstan: 16416 places (total is 1313219)Kuwait: 289 places (total is 1313508)Christmas Island: 6 places (total is 1313514)Korea South: 25715 places (total is 1339229)Kiribati: 174 places (total is 1339403)Korea North: 27382 places (total is 1366785)Kyrgyzstan: 1524 places (total is 1368309)Kenya: 3056 places (total is 1371365)Jordan : 1984 places (total is 1373349)Jamaica: 2743 places (total is 1376092)Jersey: 46 places (total is 1376138)Japan: 17868 places (total is 1394006)Iraq: 15812 places (total is 1409818)Cote D'Ivoire (Ivory C...: 11309 places (total is 1421127)Italy: 21356 places (total is 1442483)Israel: 3480 places (total is 1445963)Iran: 119643 places (total is 1565606)Man Isle of: 45 places (total is 1565651)Indonesia: 38362 places (total is 1604013)Iceland: 590 places (total is 1604603)Hungary: 19522 places (total is 1624125)Croatia: 12431 places (total is 1636556)Honduras: 14471 places (total is 1651027)Hong Kong: 1373 places (total is 1652400)Haiti: 12106 places (total is 1664506)Gaza Strip: 62 places (total is 1664568)Guyana: 629 places (total is 1665197)Guinea: 8416 places (total is 1673613)Guatemala: 7709 places (total is 1681322)Greece: 21494 places (total is 1702816)Guadeloupe: 566 places (total is 1703382)Germany: 80260 places (total is 1783642)Greenland: 636 places (total is 1784278)Guernsey: 40 places (total is 1784318)Grenada: 323 places (total is 1784641)Gibraltar: 8 places (total is 1784649)Ghana: 16491 places (total is 1801140)Georgia: 7552 places (total is 1808692)Gabon: 4410 places (total is 1813102)Gambia: 2741 places (total is 1815843)French Southern and An...: 1 places (total is 1815844)France: 75178 places (total is 1891022)French Polynesia: 366 places (total is 1891388)Faroe Islands: 456 places (total is 1891844)Micronesia: 919 places (total is 1892763)Falkland Islands: 92 places (total is 1892855)Fiji: 1680 places (total is 1894535)Finland: 13957 places (total is 1908492)French Guiana: 805 places (total is 1909297)Czech Republic: 23750 places (total is 1933047)Ethiopia: 14342 places (total is 1947389)El Salvador: 5275 places (total is 1952664)Eritrea: 1258 places (total is 1953922)Estonia: 9967 places (total is 1963889)Equatorial Guinea: 2966 places (total is 1966855)Ireland: 9471 places (total is 1976326)Egypt: 12799 places (total is 1989125)Ecuador: 9631 places (total is 1998756)Dominican Republic: 11409 places (total is 2010165)Dominica: 127 places (total is 2010292)Djibouti: 89 places (total is 2010381)Denmark: 9685 places (total is 2020066)Cyprus: 2877 places (total is 2022943)Cook Islands: 35 places (total is 2022978)Cape Verde: 326 places (total is 2023304)Cuba: 11205 places (total is 2034509)Central Africa Republic: 6127 places (total is 2040636)Costa Rica: 2995 places (total is 2043631)Colombia: 25109 places (total is 2068740)Comoros: 600 places (total is 2069340)Cameroon: 10318 places (total is 2079658)Cocos (Keeling) Islands: 1 places (total is 2079659)Cayman Islands: 75 places (total is 2079734)Chile: 4547 places (total is 2084281)China: 115766 places (total is 2200047)Congo Democratic Repub...: 25960 places (total is 2226007)Congo Republic of the: 7577 places (total is 2233584)Sri Lanka: 20718 places (total is 2254302)Chad: 11943 places (total is 2266245)Cambodia: 15352 places (total is 2281597)Canada: 5536 places (total is 2287133)Burundi: 2564 places (total is 2289697)Brunei: 343 places (total is 2290040)Bulgaria: 20773 places (total is 2310813)Bhutan: 285 places (total is 2311098)Brazil: 43869 places (total is 2354967)Solomon Islands: 3747 places (total is 2358714)Belarus: 17111 places (total is 2375825)Benin: 4507 places (total is 2380332)Burma/Myanmar: 41432 places (total is 2421764)Bolivia: 18651 places (total is 2440415)Bosnia and Herzegovina: 23770 places (total is 2464185)Belize: 570 places (total is 2464755)Bangladesh: 32470 places (total is 2497225)Bahamas The: 511 places (total is 2497736)Belgium: 17461 places (total is 2515197)Bermuda: 22 places (total is 2515219)Botswana: 547 places (total is 2515766)Barbados: 539 places (total is 2516305)Bahrain: 344 places (total is 2516649)Anguilla: 42 places (total is 2516691)Austria: 16937 places (total is 2533628)Argentina: 9152 places (total is 2542780)Angola: 15305 places (total is 2558085)Andorra: 92 places (total is 2558177)Armenia: 2881 places (total is 2561058)Albania: 13807 places (total is 2574865)Azerbaijan: 11168 places (total is 2586033)Algeria: 10170 places (total is 2596203)Afghanistan: 33956 places (total is 2630159)United Arab Emirates: 777 places (total is 2630936)Antigua and Barbuda: 184 places (total is 2631120)Aruba: 115 places (total is 2631235)Australia: 10423 places (total is 2641658)India: 26911 places (total is 2668569)UK: 16869 places (total is 2685438)USA: 163258 places (total is 2848696)Number of cities in the generated database = 2848696 Quote Link to comment Share on other sites More sharing options...
Guest guest Posted November 22, 2001 Report Share Posted November 22, 2001 OM SRI GURAVE NAMAH Dear Narasimha, MASSIVE like Jagannath.. yes this looks more like a perfection in Karma Yoga now. This is what I was hoping to see one day..perfectionin work without a drop of the reward in expectation.. Your prayers to Jagannath seem to have worked well. Best Regards Sanjay Rath http://sanjayrath.tripod.com - <pvr108 <jhora > Thursday, November 22, 2001 1:57 AM JH Atlas Statistics > Pranaam Sanjay, > > Thanks to Nimmi, I got the CD with data and created a database with > it in my own searchable format. I am attaching some statistics about > the database below. You can find the number of cities included from > each country. > > ACS atlas (which costs $500 per year in fees and 10% royalties on our > revenues) has 150,000 US towns and 100,000 international towns. Our > JH atlas now has many more international cities. We have 206,000 > towns from Russia alone, 119,000 towns from Iran alone and 115,000 > towns from China alone (they have 100,000 towns from all over the > world, excluding USA)! The total number of towns in JH atlas now is > 2,848,696 (including USA). This is about 11.4 times the ACS atlas. > The size of the .adb file is 64 MB. Search for a town is faster if > the name of the country is known, but one can still search in the > whole world too. > > The software development is in the final stages now. Vijay made an > InstallShield script. I will soon talk about the online help > preparation. We are getting there... > > Software development is never-ending process if you want a perfect > product. I am shooting for a " code freeze " as early as possible. So I > am taking up only that additional work which is absolutely essential > and without which the product cannot be released. > > May Jupiter's light shine on us, > Narasimha > -------------------------- > Zimbabwe: 1262 places (total is 1262) > Zambia: 15043 places (total is 16305) > Yemen: 12318 places (total is 28623) > Yugoslavia: 19850 places (total is 48473) > Swaziland: 117 places (total is 48590) > Samoa: 351 places (total is 48941) > Western Sahara: 79 places (total is 49020) > Wallis and Futuna: 40 places (total is 49060) > West Bank: 1260 places (total is 50320) > Namibia: 2380 places (total is 52700) > Vietnam: 34750 places (total is 87450) > British Virgin Islands: 22 places (total is 87472) > Venezuela: 20598 places (total is 108070) > St Vincent and the Gre...: 87 places (total is 108157) > Uzbekistan: 5749 places (total is 113906) > Uruguay: 1129 places (total is 115035) > Burkina Faso: 10836 places (total is 125871) > Ukraine: 43913 places (total is 169784) > Uganda: 6211 places (total is 175995) > Tanzania: 8552 places (total is 184547) > Turkmenistan: 1935 places (total is 186482) > Taiwan: 17840 places (total is 204322) > Tuvalu: 14 places (total is 204336) > Turkey: 59768 places (total is 264104) > East Timor: 1705 places (total is 265809) > Tunisia: 3884 places (total is 269693) > Sao Tome and Principe: 250 places (total is 269943) > Togo: 5345 places (total is 275288) > Tonga: 139 places (total is 275427) > Tokelau: 1 places (total is 275428) > Turks and Caicos Islands: 21 places (total is 275449) > Tajikistan: 3544 places (total is 278993) > Thailand: 39971 places (total is 318964) > Trinidad and Tobago: 561 places (total is 319525) > Switzerland: 3648 places (total is 323173) > Syria: 18735 places (total is 341908) > South Georgia and the ...: 2 places (total is 341910) > Sweden: 30395 places (total is 372305) > Svalbard: 19 places (total is 372324) > Sudan: 11316 places (total is 383640) > St Lucia: 15263 places (total is 398903) > Spain: 36661 places (total is 435564) > Somalia: 6449 places (total is 442013) > Singapore: 459 places (total is 442472) > San Marino: 5 places (total is 442477) > Sierra Leone: 8497 places (total is 450974) > Slovenia: 4988 places (total is 455962) > St Helena: 16 places (total is 455978) > Senegal: 12333 places (total is 468311) > South Africa: 14126 places (total is 482437) > Seychelles: 21 places (total is 482458) > St Kitts and Nevis: 187 places (total is 482645) > St Pierre and Miquelon: 3 places (total is 482648) > Saudi Arabia: 4677 places (total is 487325) > Rwanda: 1623 places (total is 488948) > Russia: 206323 places (total is 695271) > Philippines: 42347 places (total is 737618) > Romania: 29053 places (total is 766671) > Marshall Islands: 6 places (total is 766677) > Reunion: 432 places (total is 767109) > Qatar: 326 places (total is 767435) > Guinea-Bissau: 5509 places (total is 772944) > Palau: 461 places (total is 773405) > Papua New Guinea: 14530 places (total is 787935) > Portugal: 17377 places (total is 805312) > Panama: 8063 places (total is 813375) > Poland: 56069 places (total is 869444) > Pakistan: 38087 places (total is 907531) > Spratly Islands: 1 places (total is 907532) > Peru: 28880 places (total is 936412) > Pitcairn Islands: 1 places (total is 936413) > Paraguay: 2607 places (total is 939020) > New Zealand: 2682 places (total is 941702) > Nicaragua: 3493 places (total is 945195) > Netherlands Antilles: 276 places (total is 945471) > Suriname: 740 places (total is 946211) > Nauru: 13 places (total is 946224) > Nepal: 1108 places (total is 947332) > Norway: 13598 places (total is 960930) > No Mans Land: 41 places (total is 960971) > Netherlands: 9384 places (total is 970355) > Nigeria: 37566 places (total is 1007921) > Vanuatu: 1401 places (total is 1009322) > Niger: 9158 places (total is 1018480) > Norfolk Island: 1 places (total is 1018481) > Niue: 16 places (total is 1018497) > New Caledonia: 743 places (total is 1019240) > Mozambique: 24693 places (total is 1043933) > Malaysia: 18238 places (total is 1062171) > Mexico: 66742 places (total is 1128913) > Mexico: 3664 places (total is 1132577) > Maldives: 29 places (total is 1132606) > Oman: 2911 places (total is 1135517) > Malta: 604 places (total is 1136121) > Mauritania: 1121 places (total is 1137242) > Mauritius: 382 places (total is 1137624) > Morocco: 29951 places (total is 1167575) > Monaco: 7 places (total is 1167582) > Mali: 12820 places (total is 1180402) > Macedonia: 3107 places (total is 1183509) > Malawi: 5164 places (total is 1188673) > Montserrat: 92 places (total is 1188765) > Mongolia: 6163 places (total is 1194928) > Mayotte: 128 places (total is 1195056) > Moldova: 5866 places (total is 1200922) > Macau: 18 places (total is 1200940) > Martinique: 843 places (total is 1201783) > Madagascar: 28190 places (total is 1229973) > Libya: 2004 places (total is 1231977) > Luxembourg: 980 places (total is 1232957) > Lesotho: 446 places (total is 1233403) > Liechtenstein: 35 places (total is 1233438) > Slovakia: 6956 places (total is 1240394) > Liberia: 8907 places (total is 1249301) > Lithuania: 17239 places (total is 1266540) > Latvia: 9392 places (total is 1275932) > Lebanon: 6754 places (total is 1282686) > Laos: 14117 places (total is 1296803) > Kazakhstan: 16416 places (total is 1313219) > Kuwait: 289 places (total is 1313508) > Christmas Island: 6 places (total is 1313514) > Korea South: 25715 places (total is 1339229) > Kiribati: 174 places (total is 1339403) > Korea North: 27382 places (total is 1366785) > Kyrgyzstan: 1524 places (total is 1368309) > Kenya: 3056 places (total is 1371365) > Jordan : 1984 places (total is 1373349) > Jamaica: 2743 places (total is 1376092) > Jersey: 46 places (total is 1376138) > Japan: 17868 places (total is 1394006) > Iraq: 15812 places (total is 1409818) > Cote D'Ivoire (Ivory C...: 11309 places (total is 1421127) > Italy: 21356 places (total is 1442483) > Israel: 3480 places (total is 1445963) > Iran: 119643 places (total is 1565606) > Man Isle of: 45 places (total is 1565651) > Indonesia: 38362 places (total is 1604013) > Iceland: 590 places (total is 1604603) > Hungary: 19522 places (total is 1624125) > Croatia: 12431 places (total is 1636556) > Honduras: 14471 places (total is 1651027) > Hong Kong: 1373 places (total is 1652400) > Haiti: 12106 places (total is 1664506) > Gaza Strip: 62 places (total is 1664568) > Guyana: 629 places (total is 1665197) > Guinea: 8416 places (total is 1673613) > Guatemala: 7709 places (total is 1681322) > Greece: 21494 places (total is 1702816) > Guadeloupe: 566 places (total is 1703382) > Germany: 80260 places (total is 1783642) > Greenland: 636 places (total is 1784278) > Guernsey: 40 places (total is 1784318) > Grenada: 323 places (total is 1784641) > Gibraltar: 8 places (total is 1784649) > Ghana: 16491 places (total is 1801140) > Georgia: 7552 places (total is 1808692) > Gabon: 4410 places (total is 1813102) > Gambia: 2741 places (total is 1815843) > French Southern and An...: 1 places (total is 1815844) > France: 75178 places (total is 1891022) > French Polynesia: 366 places (total is 1891388) > Faroe Islands: 456 places (total is 1891844) > Micronesia: 919 places (total is 1892763) > Falkland Islands: 92 places (total is 1892855) > Fiji: 1680 places (total is 1894535) > Finland: 13957 places (total is 1908492) > French Guiana: 805 places (total is 1909297) > Czech Republic: 23750 places (total is 1933047) > Ethiopia: 14342 places (total is 1947389) > El Salvador: 5275 places (total is 1952664) > Eritrea: 1258 places (total is 1953922) > Estonia: 9967 places (total is 1963889) > Equatorial Guinea: 2966 places (total is 1966855) > Ireland: 9471 places (total is 1976326) > Egypt: 12799 places (total is 1989125) > Ecuador: 9631 places (total is 1998756) > Dominican Republic: 11409 places (total is 2010165) > Dominica: 127 places (total is 2010292) > Djibouti: 89 places (total is 2010381) > Denmark: 9685 places (total is 2020066) > Cyprus: 2877 places (total is 2022943) > Cook Islands: 35 places (total is 2022978) > Cape Verde: 326 places (total is 2023304) > Cuba: 11205 places (total is 2034509) > Central Africa Republic: 6127 places (total is 2040636) > Costa Rica: 2995 places (total is 2043631) > Colombia: 25109 places (total is 2068740) > Comoros: 600 places (total is 2069340) > Cameroon: 10318 places (total is 2079658) > Cocos (Keeling) Islands: 1 places (total is 2079659) > Cayman Islands: 75 places (total is 2079734) > Chile: 4547 places (total is 2084281) > China: 115766 places (total is 2200047) > Congo Democratic Repub...: 25960 places (total is 2226007) > Congo Republic of the: 7577 places (total is 2233584) > Sri Lanka: 20718 places (total is 2254302) > Chad: 11943 places (total is 2266245) > Cambodia: 15352 places (total is 2281597) > Canada: 5536 places (total is 2287133) > Burundi: 2564 places (total is 2289697) > Brunei: 343 places (total is 2290040) > Bulgaria: 20773 places (total is 2310813) > Bhutan: 285 places (total is 2311098) > Brazil: 43869 places (total is 2354967) > Solomon Islands: 3747 places (total is 2358714) > Belarus: 17111 places (total is 2375825) > Benin: 4507 places (total is 2380332) > Burma/Myanmar: 41432 places (total is 2421764) > Bolivia: 18651 places (total is 2440415) > Bosnia and Herzegovina: 23770 places (total is 2464185) > Belize: 570 places (total is 2464755) > Bangladesh: 32470 places (total is 2497225) > Bahamas The: 511 places (total is 2497736) > Belgium: 17461 places (total is 2515197) > Bermuda: 22 places (total is 2515219) > Botswana: 547 places (total is 2515766) > Barbados: 539 places (total is 2516305) > Bahrain: 344 places (total is 2516649) > Anguilla: 42 places (total is 2516691) > Austria: 16937 places (total is 2533628) > Argentina: 9152 places (total is 2542780) > Angola: 15305 places (total is 2558085) > Andorra: 92 places (total is 2558177) > Armenia: 2881 places (total is 2561058) > Albania: 13807 places (total is 2574865) > Azerbaijan: 11168 places (total is 2586033) > Algeria: 10170 places (total is 2596203) > Afghanistan: 33956 places (total is 2630159) > United Arab Emirates: 777 places (total is 2630936) > Antigua and Barbuda: 184 places (total is 2631120) > Aruba: 115 places (total is 2631235) > Australia: 10423 places (total is 2641658) > India: 26911 places (total is 2668569) > UK: 16869 places (total is 2685438) > USA: 163258 places (total is 2848696) > > Number of cities in the generated database = 2848696 > > > > > > Quote Link to comment Share on other sites More sharing options...
Guest guest Posted November 23, 2001 Report Share Posted November 23, 2001 Dear Frank, ACS uses 7.8 MB for 250,000 sites. BTW, 64 MB for 2.8 million sites 23 bytes per site and not 3,000 bytes per site. I am concerned about the size (64 MB!), but reducing it further would make the searches very slow. Even now, searching in a given country is very fast (immediate), but searching in the whole world is pretty slow (about 10 seconds on my 400 MHZ Pentium-II computer). Yes, the atlas contains the standard timezone and summer timezone info of each place. It automatically finds when the summer timezone comes into effect and leaves, for USA. I am planning to add similar logic for other nations (Australia has different conventions). But the good thing is that the atlas file itself has the standard and summer timezone values encoded in it. The only drawback is that it does not have the historical values. Some timezone boundaries slightly changed during the last 50 years, esp in Indiana and some other states with multiple timezones. The atlas I put together knows the longitude/latitude demarcation of the timezone boundaries as of today. If one town changed from one timezone to another in 1972, for example, then the software does not know it. However, there is no need to panick, because the changes in boundaries have not been drastic! There were only minor shifts over the time. Moreover, based on the information in the public domain, we can try to improve this in future. Our original goal was to put together something that is not so bad, in order to avoid ACS's exorbitant fees. What we have now lags behinf ACS in just one issue (namely, shifts in timezone boundaries with time), but beats it in everything else (11.4 times the number of sites, speed, ability to search for a city when you don't know the name of the country, ability to do approximate matches when there are no correct matches etc). So I am a happy man. Of course, we can try to make it more perfect in time. But, this is one heck of a start! Once I put in the daylight time start/end date logic for Australia and other non-USA countries, I will look at online help. May Jupiter's light shine on us, Narasimha > Namaste Narasimha, > this is excellent. 2.8Million sites in 64MB of space is reasonable ( > that's about ~ 3K per site). > Does the Atlas folks also provide updates to the data throughout the > year? > and does it discern between the sites that use Daylight savings time , > war time? etc? > Just curious. > ! Shanti, Shanti Shanti > Frank in Austin Quote Link to comment Share on other sites More sharing options...
Guest guest Posted November 24, 2001 Report Share Posted November 24, 2001 Dear Narasimha, thx for the correction on my math ( those darn decimal points!) 10 Sec on PII is not bad... Is it a linear function of CPU power? or would more memory make the difference...? in either case, 10 seconds is good performance. pvr108 [pvr108] Thursday, November 22, 2001 10:40 PMjhora Subject: Re: JH Atlas StatisticsDear Frank,ACS uses 7.8 MB for 250,000 sites. BTW, 64 MB for 2.8 million sites 23 bytes per site and not 3,000 bytes per site.I am concerned about the size (64 MB!), but reducing it further would make the searches very slow. Even now, searching in a given country is very fast (immediate), but searching in the whole world is pretty slow (about 10 seconds on my 400 MHZ Pentium-II computer).Yes, the atlas contains the standard timezone and summer timezone info of each place. It automatically finds when the summer timezone comes into effect and leaves, for USA. I am planning to add similar logic for other nations (Australia has different conventions). But the good thing is that the atlas file itself has the standard and summer timezone values encoded in it.The only drawback is that it does not have the historical values. Some timezone boundaries slightly changed during the last 50 years, esp in Indiana and some other states with multiple timezones. The atlas I put together knows the longitude/latitude demarcation of the timezone boundaries as of today. If one town changed from one timezone to another in 1972, for example, then the software does not know it. However, there is no need to panick, because the changes in boundaries have not been drastic! There were only minor shifts over the time.Moreover, based on the information in the public domain, we can try to improve this in future.Our original goal was to put together something that is not so bad, in order to avoid ACS's exorbitant fees. What we have now lags behinf ACS in just one issue (namely, shifts in timezone boundaries with time), but beats it in everything else (11.4 times the number of sites, speed, ability to search for a city when you don't know the name of the country, ability to do approximate matches when there are no correct matches etc).So I am a happy man. Of course, we can try to make it more perfect in time. But, this is one heck of a start! Once I put in the daylight time start/end date logic for Australia and other non-USA countries, I will look at online help.May Jupiter's light shine on us,Narasimha> Namaste Narasimha,> this is excellent. 2.8Million sites in 64MB of space is reasonable (> that's about ~ 3K per site).> Does the Atlas folks also provide updates to the data throughout the> year?> and does it discern between the sites that use Daylight savings time ,> war time? etc?> Just curious.> ! Shanti, Shanti Shanti> Frank in Austin Quote Link to comment Share on other sites More sharing options...
Guest guest Posted November 24, 2001 Report Share Posted November 24, 2001 Dear Frank, > Dear Narasimha, > > thx for the correction on my math ( those darn > decimal points!) > 10 Sec on PII is not bad... Is it a linear function > of CPU power? or > would more memory > make the difference...? in either case, 10 seconds > is good performance. Yes, it typically is linearly proportional to the CPU speed. Actually, I made some optimizations to the atlas database structure today and now it takes 2-4 sec to search for a city name in the whole world (including USA). Searching in a single country (e.g. USA, Russia) is almost instantaneous. The only thing is that if there is no match and we have to go for a partial match, it can take longer. BTW, memory does not matter much. Pentium 2/3/4 also does not matter much in this particular case. Only the clock speed does. May Jupiter's light shine on us, Narasimha GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities./ps/info1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.