Re: Major cities around the world
Carlos A said the following on 6/26/2006 4:24 PM: > I'm looking for a service that will provide a database containing > 200-300 countries with a related table containing the major "states" > (I know other countries do not necessarily refer to them as states) > for each country. I've purchased the Globixdata product but it has > just under 3 million "states"! United States has over 180,000 "state" > entries alone. > > I have a country select list that will dynamically populate a "state" > select list based on the country selected. I plan on using ajaxCFC to > accomplish this. > > Any info the list can provide will be greatly appreciated. This isn't exactly what you want, but the CIA World Factbook might be useful: http://www.cia.gov/cia/publications/factbook/index.html -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management 210-490-2415 (office), 210-232-2790 (mobile) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244869 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Major cities around the world
There are 191 UN member countries and the US State Department formally recognizes 192 countries. Of course, some people will add in a couple of extras like Taiwan and E. Timor and Palestine, claiming that these are sovereign nations. So when you get right down to it, you've got a maximum of about 194 possibilities and a minimum of 188 depending upon whom you ask. * Ken Ferguson 214.636.6126 * Tom Chiverton wrote: > On Monday 26 June 2006 22:24, Carlos A wrote: > >> I'm looking for a service that will provide a database containing 200-300 >> countries >> > > Which planets that then ? > There are only just under two hundred countries > (http://www.un.org/Overview/unmember.html) :-) > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244865 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Major cities around the world
> > I'm looking for a service that will provide a database containing > > 200-300 countries > > Which planets that then ? > There are only just under two hundred countries > (http://www.un.org/Overview/unmember.html) :-) That is a list of the 191 UN Member States, there are loads of countries on this planet who are not members of the UN. http://en.wikipedia.org/wiki/List_of_countries lists 243 countries and I am sure even they have missed a few. -- Jay -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.5/376 - Release Date: 26/06/2006 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244849 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Major cities around the world
On Monday 26 June 2006 22:24, Carlos A wrote: > I'm looking for a service that will provide a database containing 200-300 > countries Which planets that then ? There are only just under two hundred countries (http://www.un.org/Overview/unmember.html) :-) -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of the Year at the 2005 Growth Company Awards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244846 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Major cities around the world
On 6/26/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > > I'm liking the webservice idea for this type data. Kewl! > > Dennyjust don't forget...any reliance on external apps (which > webservices > are) means more potential points of failure and coding to deal with it ;-) Heh. I added a "google news" thingie to an intranet, just to mess with RSS really, and quickly figured out I needed to cache stuff if I wanted any type of reliability. Besides the fact that I felt it was mean of me to send out a request for new stuff every freaking request. Every 10 minutes, sure, that's ok, I rationalized. So the worst that happens now is stale news. I feel it's better than 50 requests in 10 seconds for the same info tho. I'd think that you'd probably want some type of cache anyways, right? Is that a best practice with webservices? I can see where that would mess you up tho, so... man, this caching issue pops up all over. Databases, webservices, who know where else. I can see how whole methodologies could spring up around various ideas... A pet project of mine for years now is the "sometimes connected" idea. Maybe flash will help me make it a reality, otherwise it's looking like java. Eh. Interesting stuff. :DeN ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244827 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Major cities around the world
> I'm liking the webservice idea for this type data. Kewl! Dennyjust don't forget...any reliance on external apps (which webservices are) means more potential points of failure and coding to deal with it ;-) So yep...they can be great...like postal datagreat because you don't have to keep the data up to date. If the web service chokes...so does your app (especially if it's calculating shipping rates...hehe).not so great. Now of course if you pay for a webservice at least you can yell and scream at them if it does tank ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244824 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Major cities around the world
Heh. Anyone else find it funny that big $$ are made off of data that should be public domain? I was stoked to see my state put it's GIS data online, for free, as it should be. Maybe things have changed, I haven't checked the new webservices offered by UPS and such, but just getting zipcodes was a major pain in the buttox like 5 years ago. Like, one list of all of them? Niet! Had to scrape, scrape, scrape. I'm liking the webservice idea for this type data. Kewl! Yeah, you'd really want to use AJAX for those drill-down selects. Many AJAX implementations have examples of how to do it... scrip.tacu.lous (dots may be off) jumps to mind off hand... I think. Fun stuff, :DeN On 6/26/06, Mike Tangorre <[EMAIL PROTECTED]> wrote: > > I would check the UPS, FedEx, and USPS web sites for services they offer. > If > you do get your hands on such a database, please pass it along. :-) > > > From: "Carlos A" <[EMAIL PROTECTED]> > > I'm looking for a service that will provide a database containing > 200-300 > > countries with a related table containing the major "states" (I know > other > > countries do not necessarily refer to them as states) for each country. > > I've purchased the Globixdata product but it has just under 3 million > > "states"! United States has over 180,000 "state" entries alone. > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244822 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Major cities around the world
I would check the UPS, FedEx, and USPS web sites for services they offer. If you do get your hands on such a database, please pass it along. :-) From: "Carlos A" <[EMAIL PROTECTED]> > I'm looking for a service that will provide a database containing 200-300 > countries with a related table containing the major "states" (I know other > countries do not necessarily refer to them as states) for each country. > I've purchased the Globixdata product but it has just under 3 million > "states"! United States has over 180,000 "state" entries alone. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244811 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54