[dba-SQLServer] Useful Lists

artful at rogers.com artful at rogers.com
Wed Nov 15 19:58:34 CST 2006

What a cool offer! I will immediately convert the Access DBs that I have so far to MS-SQL then zip the backups and send them to you for restoration.


----- Original Message ----
From: Robert L. Stewart <rl_stewart at highstream.net>
To: dba-sqlserver at databaseadvisors.com
Sent: Wednesday, November 15, 2006 2:46:26 PM
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

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.


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

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.

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list