US Census data for MySQL

You can download for free several text files (5) of census data from
http://www.census.gov/geo/www/gazetteer/places2k.html

However, these files are not in an immediately usable format to import
into MySQL (or any database for that matter except a flat file).

I've split up the files into sub-files, and was wondering if there is a
need for such things. I would charge a nominal fee for each set of
files. There is one file per field, as well as one concatenated file
containing all original fields delimited by a colon ':' with leading and
trailing spaces removed.

For example, the 'county_2k.txt' file contains 12 fields. Each field is
split out and saved to its own file.

* Columns 1-2: United States Postal Service State Abbreviation
* Columns 3-4: State Federal Information Processing Standard (FIPS) code
* Columns 5-7: FIPS county code
* Columns 8-13: Census Tract Number
* Columns 14-22: Total Population (2000)
* Columns 23-31: Total Housing Units (2000)
* Columns 32-45: Land Area (square meters) - Created for statistical
purposes only.
* Columns 46-59: Water Area(square meters) - Created for statistical
purposes only.
* Columns 60-73: Land Area (square miles) - Created for statistical
purposes only.
* Columns 74-87: Water Area (square miles) - Created for statistical
purposes only.
* Columns 88-101: Latitude (decimal degrees) First character is blank or
"-" denoting North or South latitude respectively
* Columns 102-116: Longitude (decimal degrees) First character is blank
or "-" denoting East or West longitude respectively

If anyone is interested in these files send a personal email and we can
discuss further.

I'm also looking into doing something similar with Canadian Postal and
demographic data if I can get my hands on it. So if anyone knows where I
can get that please let me know as well.
--
Amer Neely, Softouch Information Services
Home of Spam Catcher
W: www.softouch.on.ca
E: trudge@softouch.on.ca
Perl | MySQL | CGI programming for all data entry forms.
"We make web sites work!"

Amer Neely wrote:

> For example, the 'county_2k.txt' file contains 12 fields. Each field is
> split out and saved to its own file.

The original post had the wrong description of that file. This is correct:

The county file contains data for primary legal divisions or
statistically equivalent entities in the 50 states, District of Columbia
and Puerto Rico as of the 2000 Census. 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-7: FIPS county code
* Columns 8-71: Name
* Columns 72-80: Total Population (2000)
* Columns 81-89: Total Housing Units (2000)
* Columns 90-103: Land Area (square meters) - Created for statistical
purposes only.
* Columns 104-117: Water Area (square meters) - Created for statistical
purposes only.
* Columns 118-129: Land Area (square miles) - Created for statistical
purposes only.
* Columns 130-141 Water Area (square miles) - Created for statistical
purposes only.
* Columns 142-151 Latitude (decimal degrees) First character is blank or
"-" denoting North or South latitude respectively
* Columns 152-162 Longitude (decimal degrees) First character is blank
or "-" denoting East or West longitude respectively

Sorry about that.
--
Amer Neely, Softouch Information Services
Home of Spam Catcher
W: www.softouch.on.ca
E: trudge@softouch.on.ca
Perl | MySQL | CGI programming for all data entry forms.
"We make web sites work!"