|
|
Posted by Amer Neely on 06/28/05 22:40
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!"
Navigation:
[Reply to this message]
|