Jim Lawrence
accessd at shaw.ca
Wed Nov 15 15:38:59 CST 2006
Hi Robert: We still have room on DBA server for files and we have a SQL server as well... but if you want I could set up a re-direct to download lists from you server. Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart Sent: Wednesday, November 15, 2006 11:46 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Useful Lists Oh Well, I tried their postal code web service for the USA. Mine is 77418. The area code changed over 5 years ago from 409 to 979. Their service is still returning 409 as the area code. Art and all, Since Art cross posted this, I will put the offer here also. I am willing to host the databases in SQL Server for all to connect to for the data. As long as we all behave and keep the list up to date as well as not put junk into them. I have a couple, like the postal code list, some of the ISO standards lists for country codes, SIC and NAICS code, and so on that I can start it with it any one else is interested. I also have some of the TIGER data tables for the USA. Robert At 08:27 AM 11/15/2006, you wrote: >Date: Tue, 14 Nov 2006 21:08:15 -0800 >From: MartyConnelly <martyconnelly at shaw.ca> >Subject: Re: [AccessD] Useful Lists >To: Access Developers discussion and problem solving > <accessd at databaseadvisors.com> >Message-ID: <455AA0BF.7050407 at shaw.ca> >Content-Type: text/plain; charset=windows-1252; format=flowed > >In addition to lists there are public web services that provide things like >those listed below from places like >http://www.webservicex.net/WS/default.aspx At 12:00 PM 11/15/2006, you wrote: >Date: Tue, 14 Nov 2006 10:20:41 -0800 (PST) >From: artful at rogers.com >Subject: [dba-SQLServer] Useful Lists >To: "AccessD at databaseadvisors. com" <AccessD at databaseadvisors.com>, > dba-SQLServer <dba-SQLServer at databaseadvisors.com> >Message-ID: <20061114182042.41237.qmail at web88209.mail.re2.yahoo.com> >Content-Type: text/plain; charset=ascii > >On the basis of the thread about airport lists, I proposed to Jim >Lawrence that we accumulate a bunch of similar lists. As my father >said when I joined the CDN Air Force at 17, "Don't volunteer for >anything." O well. Jim has invited me to spearhead the acquisition >of said lists, and I have accepted the assignment. > >So, to all of you listers, three questions: > >1. What lists do you possess that you think would be useful to your >fellow AccessD/dba-SQL listers? >2. What lists do you lack that you desire? > >(I couldn't resist the old programmer's joke. There are three types >of programmers -- those who can count and those who can't.) > >Chances are that more than one of you may volunteer to contribute >similar or identical lists. The latter is easy to deal with. The >former is a little tougher, since it might require UNIONing several >lists, but that's ok. > >I have one list ready to go, which is the list of words >corresponding to letters that travel agents use to spell names. I >think it is identical to the similar list from the military, but >perhaps not. (In case you don't know what I mean, Able Baker Charlie etc.) > >I also have another list of cities within North America, and states >and provinces to correspond. It is not ready to go, there are some >duplicates, but I could prune the dupes. The list consists only of >those cities into which the company I was formerly associated with >sold products, but it numbers about 5,000 cities, give or take 3. >Far from exhaustive, but a good start, and similar lists could >easily be UNIONed. That leaves out all the listers uninterested in >cities in North America, but listers residing elsewhere might be >able to contribute more cities. On this one, there is a difficulty. >Within North America, there are states and provinces. In >Switzerland, there are cantons. > >On this subject, I have just done some searches in dictionary.com >and come up with some hilarious definitions: > >City -- an important town >Town -- a large village >Village -- a small community or group of houses in a rural area, larger than a >hamlet and usually smaller than a town, and sometimes (as in parts of >the U.S.) incorporated as a municipality. >Hamlet -- British. a village without a church of its own, belonging >to the parish of another village or town. >County (the richest by far) -- >1.the largest administrative division of a U.S. state: Miami, >Florida, is in Dade County. > >2.one of the chief administrative divisions of a country or state, >as in Great Britain and Ireland. > >3.one of the larger divisions for purposes of local administration, >as in Canada and New Zealand. > >4.the territory of a county, esp. its rural areas, as in: "We farmed >out in the county before moving to town.". > >5.the inhabitants of a county, as in, "It was supposed to be a >secret, but you told the whole county.". > >6.the domain of a count or earl. > > >All these years I have been under the (clearly false) impression >that precise population-numbers defined these terms. Apparently I >have wrong, lo these decades. I have just taken a local poll (only 4 >people) and the agreement here is that a city is 100,000 people or >more; a town is 999,999 people or fewer; a village is 2,000 people >or fewer; a hamlet is 500 people or fewer. We four Canadians readily >agreed on these numbers, but that might be something we picked up in >school that has no relation to the larger world. > >Arthur > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com