README File
Census 2000 109th Congressional Districts - Hundred Percent
Delivered via FTP
CONTENTS
About the FTP Application
Other Sources of the Data
File Naming Convention
Technical Documentation
Data Records and Segmentation
File Record Layout
FTP File Transfer
UnZipping the Files
Spreadsheet and Data Base Aids
For step-by-step instructions for moving the data and the structure into a
data base format (including screen shots), please see
www.census.gov/support/SF1ASCII.html.
Structure files in Access2000 and other formats are available at
http://www.census.gov/support/2000/SF1/
We are unable to provide one-on-one support for applications of the data to specific
spreadsheets or data base software.
ABOUT THE FTP APPLICATION
The application is intended for experienced users of census data, compressed files,
and spreadsheet/database software.
FTP users should have a fast file transfer capability.
Users of the FTP application need to unzip the compressed file after downloading,
then import it into the spreadsheet/database software of their choice for data
analysis and table presentation.
OTHER SOURCES OF THE DATA
American FactFinder at factfinder.census.gov.
This system provides Internet access to all tables plus additional derived tables
called Quick Tables and Geographic Comparison Tables.
The system can create thematic maps on various data items.
The system can create reference maps defining the geographic area.
Tables are available on American FactFinder on the morning of public release.
DVD/CD-ROM
Data for the 109th Congressional Districts also will be available on DVD shortly
after the public release date.
The discs will contain easy-to-use software enabling users to download tabulations
from the files.
We expect the 109th Congressional District data to fit on one DVD.
For ordering information, contact the Customer Services Center at 301-763-INFO
(4636) or send an email to webmaster@census.gov. Business hours are 8:30 AM - 4:30
PM EST, Monday through Friday.
FILE NAMING CONVENTIONS
The naming convention for geographic header files is ssgeo_h09.zip
ss is USPS state abbreviation
The codes are in technical documentation on page 7-1, located at
http://www.census.gov/prod/cen2000/doc/sf1.pdf
geo_h09.zip is a constant across CD109 geographic header names.
Naming convention for CD109 data files is ssiiiyy_h09.zip.
ss is USPS state abbreviation
iii is the characteristic iteration (total population, race
groups, American Indian and Alaska Native tribes, and
Hispanic/Latino groups). These only apply to SF 2 and SF 4.
In CD109, the characteristic iteration will always be 000.
yy is the number of the file
Valid codes are 01 through 39. See below for distribution of
tables across files.
h09.zip is a constant across CD109 data file names
TECHNICAL DOCUMENTATION
The complete technical documentation for CD109 is available at
http://www.census.gov/prod/cen2000/doc/cd109h.pdf .
DATA RECORDS AND SEGMENTATION
Table distribution across data files is as follows:
File/Table Segmentation
Starting Ending
Number of Matrix Matrix
File Name Data Items Number Number
stgeo.h09
st00001.h09 222 P1 P5
st00002.h09 238 P6 P18
st00003.h09 236 P19 P33
st00004.h09 149 P34 P45
st00005.h09 245 P12A P12E
st00006.h09 241 P12F P16I
st00007.h09 234 P17A P27C
st00008.h09 247 P27D P28E
st00009.h09 244 P28F P30H
st00010.h09 229 P30I P34I
st00011.h09 180 P35A P35I
st00012.h09 235 PCT1 PCT9
st00013.h09 45 PCT10 PCT11
st00014.h09 209 PCT12 PCT12
st00015.h09 196 PCT13 PCT17
st00016.h09 209 PCT12A PCT12A
st00017.h09 209 PCT12B PCT12B
st00018.h09 209 PCT12C PCT12C
st00019.h09 209 PCT12D PCT12D
st00020.h09 209 PCT12E PCT12E
st00021.h09 209 PCT12F PCT12F
st00022.h09 209 PCT12G PCT12G
st00023.h09 209 PCT12H PCT12H
st00024.h09 209 PCT12I PCT12I
st00025.h09 209 PCT12J PCT12J
st00026.h09 209 PCT12K PCT12K
st00027.h09 209 PCT12L PCT12L
st00028.h09 209 PCT12M PCT12M
st00029.h09 209 PCT12N PCT12N
st00030.h09 209 PCT12O PCT12O
st00031.h09 245 PCT13A PCT13E
st00032.h09 235 PCT13F PCT15C
st00033.h09 225 PCT15D PCT17B
st00034.h09 225 PCT17C PCT17E
st00035.h09 225 PCT17F PCT17H
st00036.h09 75 PCT17I PCT17I
st00037.h09 217 H1 H20
st00038.h09 207 H11A H15I
st00039.h09 171 H16A H16I
Five fields are carried over from the geographic header file into each data file.
These fields are file identification (FILEID), state abbreviation (STUSAB),
characteristic iteration (CHARITER), characteristic iteration file sequence number
(CIFSN) and logical record number (LOGRECNO).
These five fields appear in the geographic header file in a fixed field format.
These five fields appear in the four data files in a comma delimited format.
These fields are used to "match" records in the four data files to the geographic
information in the geoheader.
A file set structure schematic appears in the technical documentation which is located
at www.census.gov/prod/cen2000/doc/cd109h.pdf
FILE RECORD LAYOUT
For a layout of the individual tables for each file, see the technical documentation
at ww.census.gov/prod/cen2000/doc/cd109h.pdf Select Chapter 6, Summary Table
Outlines.
FTP FILE TRANSFER
The 109th Congressional Districts (CD109) FTP directory is at
ftp2.census.gov/census_2000/datasets/109_Congressional_Districts.
Each state directory provides all files for the identified state.
The directory for each state has a geographic header file and 39 data files.
The previous chart in this document lists the table numbers available in each of the
39 files.
Once uncompressed, the files are in a flat ASCII format.
No software is provided.
Downloading multiple files
UNIX environment-"mget" subcommand allows transfer of multiple files using the
wildcard character.
Example: ftp> prompt off
ftp>mget ne* (for this example, Nebraska is selected).
Windows Environment-many FTP products have been developed which have the capability
to download multiple files with a single command.
We used the ws_ftp product in testing the download.
A demonstration copy is available at http://www.ipswitch.com/
An Internet search using the term "download multiple files" yielded other similar
products.
For step-by-step instructions with screen shots, please see
http://www.census.gov/support/2000/SF1/.
UNZIPPING THE FILES
Files compress at approximately 95% compression.
Any standard UnZIP software package can be used.
In testing we used PKZIP for Windows. It's available at www.pkware.com.
Unzipped files are in flat ASCII format.
For step-by-step instructions with screen shots, please see
http://www.census.gov/support/2000/SF1/.
UNZIPPED FILES
Geographic header file has fixed fields.
File data dictionary is at www.census.gov/prod/cen2000/doc/cd109h.pdf. See chapter 7
for the data dictionary.
Data files have comma delimited fields
Fields from the geographic header file carried over to the data files are comma
delimited in the data files .
SPREADSHEET AND DATA BASE AIDS
For step-by-step instructions with screen shots for moving the data and structure to
a spreadsheet, please see www.census.gov/support/SF1ASCII.html.
Structure files in Access97 and other formats are available at
http://www.census.gov/support/2000/SF1/.
We are unable to provide one-on-one support for applications of the data to specific
spreadsheets or data base software.