Google Answers Logo
View Question
 
Q: area (sq. mi.) of each town in New England ( Answered 5 out of 5 stars,   2 Comments )
Question  
Subject: area (sq. mi.) of each town in New England
Category: Reference, Education and News > General Reference
Asked by: jimbrowski-ga
List Price: $5.00
Posted: 12 Apr 2005 08:00 PDT
Expires: 12 May 2005 08:00 PDT
Question ID: 508326
Where would I find data for the area of each town in New England (in sq. mi.)?
Answer  
Subject: Re: area (sq. mi.) of each town in New England
Answered By: pafalafa-ga on 12 Apr 2005 10:45 PDT
Rated:5 out of 5 stars
 
Hello Jim,

The Census Bureau is fond not only of counting the population, but of
figuring out the number of people per square mile in states, counties,
cities, etc.  And to do that, of course, they need to have the areas
of all these jurisdictions.

You can find the cities/towns file (known as the "Place" file) at:


http://www.census.gov/tiger/tms/gazetteer/places2k.txt


The file -- one of several that are available -- is described in more detail here:


http://www.census.gov/geo/www/gazetteer/places2k.html
2000 U.S. Gazetteer 


-----
The place file contains data for all Incorporated and Census
Designated places in the 50 states, the District of Columbia and
Puerto Rico as of the January 1, 2000. The file is plain ASCII text,
one line per record.


Columns 1-2: United States Postal Service State Abbreviation 
Columns 3-4: State Federal Information Processing Standard (FIPS) code 
Columns 5-9: Place FIPS Code 
Columns 10-73: Name 
Columns 74-82: Total Population (2000) 
Columns 83-91: Total Housing Units (2000) 
Columns 92-105: Land Area (square meters) - Created for statistical purposes only. 
Columns 106-119: Water Area(square meters) - Created for statistical
purposes only.
Columns 120-131: Land Area (square miles) - Created for statistical purposes only. 
Columns 132-143: Water Area (square miles) - Created for statistical
purposes only.
Columns 144-153: Latitude (decimal degrees) First character is blank
or "-" denoting North or South latitude respectively
Columns 154-164: Longitude (decimal degrees) First character is blank
or "-" denoting East or West longitude respectively
-----

The first record of the file starts off like this:

AL0100124Abbeville city       2987     1353   40301945        120383  
15.560669    0.046480



The front matter is the state and Census code, followed by the city
name, Abbeville.  After that you have:

population......................2,987
housing units...................1,353
Land area (sq meters).......4,030,195
Water area (sq meters)........120,383
Land area (sq mi)..................15.560669
Water area (sq mi)..................0.046480

I didn't include the next two numbers, which are the latititude and longitude.


This should be everything you need -- and then some -- to pull out the
town area data for New England,  but let me know if you require any
additional information.


Have fun,


pafalafa-ga




search strategy -- Used bookmarked site for the Census Bureau

Clarification of Answer by pafalafa-ga on 12 Apr 2005 11:06 PDT
In my example, I inadvertently dropped a digit off the area in sq
meters.  It should be:

40,301,945

Request for Answer Clarification by jimbrowski-ga on 12 Apr 2005 15:34 PDT
I don't think we've cracked this yet.

1. As one example, let's look at the data for NH.  If I sum the area
for each of the 60 cities and CDPs listed for NH, I get 637 sq mi. 
New Hampshire is 9,351 sq mi, so we've missed quite a bit.

2. For another example, I know that there are 50 cities and 301 towns
in MA (http://www.sec.state.ma.us/cis/cispdf/ma_city_town.pdf).  This
census file lists 235 cities and CDPs.

Addressing issue #1 is critical; addressing issue #2 would be desirable.

Clarification of Answer by pafalafa-ga on 12 Apr 2005 19:00 PDT
Good eye!

Your comment reminded me of something I read a while ago, and that I
can't bring fully to mind.  But essentially, it's this:  for obscure
historical reasons, the towns and cities in many of the New England
states are considered a different sort of creature than towns and
cities elsewhere -- at least as far as the Census Bureau is concerned.
 So...not all of them are listed in the "Places" file, even though --
to you and me -- they're certainly deserving of being considered
"places".

Turns out, the fuller listing is the subdivision file:


http://www.census.gov/tiger/tms/gazetteer/cousub2k.txt


and a check of the MA listings shows -- sure enough -- a bit more than
350 city and town listings.


I think this one should do the trick.  But if you check the file and
something seems "off", just let me know, and I'll see what else I can
come up with.


paf
jimbrowski-ga rated this answer:5 out of 5 stars

Comments  
Subject: Re: area (sq. mi.) of each town in New England
From: myoarin-ga on 12 Apr 2005 15:24 PDT
 
Pafalafa,  that was clever!
Subject: Re: area (sq. mi.) of each town in New England
From: pafalafa-ga on 12 Apr 2005 19:42 PDT
 
Not clever enough it seems.  But hopefully, second time's the charm.

And thanks fer noticin'

paf

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy