SRC Software for 2000 Census Data; Summary File 1 DVD

SRC Software for 2000 Census Data
Summary File 1 DVD
Part 1

Custom Variables | Saving Custom Variables | Custom Radii

Last updated on March 26, 2002

The Census Bureau's Summary File 1 on DVD provides superior access to 100% counts from the 2000 Census. It supports the selection of large numbers of geographic units, multiple geographic levels, distance and driving time radii, a complete set of variables, selection of individual categories within a table (e.g. just males 99 years old rather than 200+ age/sex categories), and the creation of custom variables, which may be re-executed at a later time. Although its data can be imported into GIS programs such as ARCVIEW, the DVD does not have a mapping capacity.

Accessing the Program

The program is located on two workstations in the Documents Center and on one workstation in the Map Library.

The full program is located on Documents Center Computer #3

Data on hard drive; no need to insert disks in DVD
CLICK on the red and white ICON that says SF1 - 2000 Allocate.
You can access the hard drive without staff assistance
Full version of EXCEL for manipulating data
Floppy drive (1.44 MB), zip drive (100 MB), and CD-RW drive (600 MB)
Access to IFS space through Hummingbird

The data engine only is located on Documents Center Computer #9

Requires DVD disk (Do 2) to retrieve data
CLICK on the red and white ICON that says Census 2000 Data Engine
Excel Viewer but not full version of Excel
Floppy drive (1.44 MB) and zip drive (100 MB)
Access to IFS space through Samba (L: drive)
Staff assistance needed when using C: drive

Workspace

New users can usually ignore the initial workspace tab and pick the geography tab at the top of the screen instead. The workspace screen is only important if you are opening a previous file or if the workstation is using the same data engine for several different programs, such as SF1 DVD, SF1CD, and eventually SF3.

Choosing Geography

Choosing geography is easier with the DVD because you look for the lowest level of geography you need first, rather than going from top to bottom in other programs. Below is a table of all of the geographic options on the DVD.

040 - State
050 - State-County
060 - State-County-County Subdivision - -
067 - State[Puerto Rico Only]-County-County Subdivision-Subbarrio
070 - State-County-County Subdivision-Place/Remainder
080 - State-County-County Subdivision-Place/Remainder-Census Tract
091 - State-County-County Subdivision-Place/Remainder-Census Tract-Block Group
Group 101 - State-County-County Subdivision-Place/Remainder-Census Tract-Block Group-Block
140 - State-County-Census Tract
144 - State-County-Census Tract-American Indian Area/Alaska Native Area/Hawaiian Home Land
150 - State-County-Census Tract-Block Group
154 - State-County-Census Tract-Block Group-American Indian Area/Alaska Native Area/Hawaiian Home Land
155 - State-Place-County
158 - State-Place-County-Census Tract
160 - State-Place
170 - State-Consolidated City
172 - State-Consolidated City-Place Within Consolidated City
230 - State-AlaskaNative Regional Corporation
261 - State-American Indian Area/Alaska Native Area/Hawaiian Home Land-County-County Subdivision
263 - State-American Indian Area/Alaska Native Area/Hawaiian Home Land-County- County Subdivision-Place/Remainder
283 - State-American Indian Area/Alaska Native Area (Reservation or Statistical Entity Only)
285 - State-American Indian Area/Alaska Native Area (Reservation or Statistical Entity Only)-County
265 - State-American Indian Area/Alaska Native Area (Reservation or Statistical Entity Only)-County-County Subdivision
266 - State-American Indian Area/Alaska Native Area (Reservation or Statistical Entity Only)-County-County Subdivision-Place/Remainder
267 - State-American Indian Area (Off-Reservation Trust Land Only)/Hawaiian Home Land-County-County Subdivision
268 - State-American Indian Area (Off-Reservation Trust Land Only)/Hawaiian Home Land-County-County Subdivision-Place/Remainder
280 - State-American Indian Area/Alaska Native Area/Hawaiian Home Land
281 - State-American Indian Area/Alaska Native Area/Hawaiian Home Land-Tribal Subdivision/Remainder
282 - State-American Indian Area/Alaska Native Area/Hawaiian Home Land-County
284 - State-American Indian Area/Alaska Native Area (Reservation or Statistical Entity Only)-Tribal Subdivision/Remainder

286 - State-American Indian Area (Off-Reservation Trust Land Only)/Hawaiian Home Land
287 - State-American Indian Area (Off-Reservation Trust Land Only)/Hawaiian Home Land-Tribal Subdivision/Remainder
288 - State-American Indian Area (Off-Reservation Trust Land Only)/Hawaiian Home Land-County
374 - State-NewEngland County Metropolitan Area
375 - State-NewEngland County Metropolitan Area-Central City
376 - State-NewEngland County Metropolitan Area-County
390 - State-Metropolitan Statistical Area/Consolidated Metropolitan Statistical Area
391 - State-Metropolitan Statistical Area/Consolidated Metropolitan Statistical Area-Central City
392 - State-Metropolitan Statistical Area/Consolidated Metropolitan Statistical Area-County
393 - State [6 states only CT, ME, MA, NH, RI, VT]-Metropolitan Statistical Area/Consolidated Metropolitan Statistical Area-County-County Subdivision
395 - State-Consolidated Metropolitan Statistical Area-Primary Metropolitan Statistical Area
396 - State-Consolidated Metropolitan Statistical Area-Primary Metropolitan Statistical Area-County
397 - State[6statesonlyCT,ME,MA,NH,RI,VT]-Consolidated Metropolitan Statistical Area-Primary Metropolitan Statistical Area-County-County Subdivision
500 - State-Congressional District (106th)
510 - State-Congressional District (106th)-County
511 - State-CongressionalDistrict (106th)-County-Census Tract
521 - State-Congressional District (106th)-County-County Subdivision
531 - State-Congressional District (106th)-Place/Remainder
541 - State-Congressional District (106th)-Consolidated City
542 - State-Congressional District (106th)-Consolidated City-Place Within Consolidated City
550 - State-Congressional District (106th)-American Indian Area/Alaska Native Area/Hawaiian Home Land
551 - State-Congressional District (106th)-American Indian Area/Alaska Native Area(Reservation or Statistical Entity Only)
552 - State-Congressional District (106th)-American Indian Area (Off-Reservation Trust Land only)/Hawaiian Home Land
553 - State-Congressional District (106th)-American Indian Area/Alaska Native Area/Hawaiian Home Land-Tribal Subdivision/Remainder
554 - State-Congressional District (106th)-American Indian Area/Alaska Native Area (Reservation or Statistical Entity Only)-Tribal Subdivision/Remainder
555 - State-Congressional District (106th)-American Indian Area (Off-Reservation Trust Land Only)/Hawaiian Home Land-Tribal Subdivision/Remainder
560 - State-Congressional District (106th)-Alaska Native Regional Corporation
851 - State-3-DigitZIPCode Tabulation Area
852 - State-3-digitZIPCode Tabulation Area-County
871 - State-5-digitZIPCode Tabulation Area
881 - State-5-digitZIPCode Tabulation Area-County

Click on the PLUS to expand the options. Whenever you check a box (dark check mark), you automatically check all levels of geography below it. In the following example (geographic level 091), we checked DETROIT and have chosen all of the block groups in Detroit. The light gray check under Wayne County was added by the program.

The table we listed will only give Detroit block group totals. To find Detroit, Wayne County, and Michigan totals, you would have to separately choose those names under geographic categories 160, 050, and 040 respectively.

Click on NEXT to go to the OUTPUT section.

Output

The software provides an output in two formats. The Report format is meant for easy printing. This is the default. The File format is better for most research.

Factor	Report	File
Variables	Entire Tables	Parts of Tables
Demographic Profiles	Yes	No
Quick Tables	Yes	No
Geographic Indicators	No	Yes
Labels	Names	Codes
Blocks and Block Groups	Yes but not Demog. Profiles, Quick Tables, PCT Tables	Yes but not PCT Tables
Formats	.htm	.xls .csv .dbf .htm .mdb .db

REPORT

The default in the OUTPUT section is REPORT. REPORT means all of the individual tables in Summary File 1 plus the Demographic Profiles. They are presented in HTML format.

l. Leave the REPORT button checked.
2. You can leave the file name as a temporary file or name it in advance by clicking on SAVE AS, then choosing a destination and name.
3. Highlight the table you want.
4. Provide a report title.
4. Click on FINISH.

Demographic Profiles are not available at the block group and block level.

Click OK on the resulting box to open the report.

The REPORT OUTPUT provides a separate page for each geographic area. In this case the block groups are inadequately labelled (no tract number or city.

File

The FILE option creates spreadsheet and dbf files. The subject variables can be mixed and matched. Headings are labelled with the variable number. A separate file is automatically created with a description of the variable. FILE is much more flexible than REPORT.

1. You have already chosen the geography.

2. Then choose the FILE option. Click on SAVE AS to name your file and choose your format. Yes, you do this before you actually finish your product. File options include:
Comma-delimited text (.csv)
dBASE III (.dbf)
dBASE IV (.dbf)
dBASE 5 (.dbf)
Excel (.xls)
FoxPro 2.6 (.dbf)
HTML Export (.htm)
Microsoft Access (.mdb)
Paradox 5.x (.db)
If you plan to use EXCEL, save in .xls format. CSV files imported into Excel display a KEY (geographic identifier) as a scientific number. It does not always display correctly or completely when changed to a general number format.

3. CREATE OUTPUT AS SUMMARY option means you will get one total for all of the geographic areas you've chosen (e.g. one figure for all males 5-9 in a combination of 10 block groups rather than a separate figure for each of the 10 block groups). Not used in this example.

4. Press NEXT or choose simple variables.

Simple Variables

Simple variables are individual tables as tabulated by the Census Bureau. They are divided into four sections

GEOGRAPHIC IDENTIFIERS

It is usually a good idea to choose geographic indicators for census tracts when the final output is block groups and census tracts plus block groups when the final output is blocks.

Alaska Native Areas
American Indian Areas
Area (Land)
Area (Water)
Block
Block Group
Census Tract
Congressional District (106th)
Consolidated Metropolitan Statistical Area
County

County Subdivision
Latitude
Longitude
Metropolitan Statistical Area
Place
Primary Metrpolitan Statistical Area
Region
School District (Elementary)
School District (Secondary)
School District (United)

State Legislative District (Upper)
State Legislative District (Lower)
Size Codes
State
Subbarrio
Traffic Analysis Zone
Urban Area
Urban/Rural
Voting District
Zip Code Tabulation Area (3-digit)
Zip Code Tabulation Area (5-digit)

HOUSING (H) TABLES

POPULATION (P) TABLES - Age, race, sex, households and group quarters characteristics to the BLOCK level.

PCT TABLES - Detailed age and race tables, as well unmarried partner households, to the CENSUS TRACT level.

A printable list of all H, P, and PCT tables appears at: http://www.lib.umich.edu/govdocs/census2/sf1tab.htm

Choose variables by clicking on the + (plus) sign to expand the list. You can choose an entire table (e.g. P5) by clicking on the folder and pressing select. You can also expand the table (P5) and choose individual sub-categories by double-clicking on them or single-clicking and selecting.

It is not clear where the ranking variables are located.

You can also choose variables from more than one table. In the example above, we chose both a geographic indicator and the sub-categories within Table 5.

Click on the FINISH button at the bottom.

When the program reports back the results, the OPEN THE OUTPUT FILE button will be marked. It would be wise to also click on the OPEN THE FIELD DESCRIPTIONS FILE. Then PRESS OK.

Viewing the Results

The spreadsheet and the field descriptions will open simultaneously as shown below. Note that the the Block Group, the primary geography choice, is shown at the left. The Geographic Indicator, Census Tract, is in the third column.

The spreadsheet will open with a standardized column width. You can expand it but highlighting the column, then choosing FORMAT/COLUMN/AUTOFIT SELECTION.

The KEY is the geocode for the areas you have chosen. XLS files opened in EXCEL will display the number with a standard notation. CSV files opened in Excel appear in a scientific format and must be converted to the standard notation. In EXCEL, highlight the cells, choose FORMAT/CELLS, and then change the notation to a number.

The geocode in this case stands for STATE (26=Michigan), COUNTY (163 = Wayne), COUNTY SUBDIVISION (22000 = Detroit), and PLACE (22000).

The KEY column is correct with XLS files opened in EXCEL.

Geocodes can be found in the Geographic Identifiers section of the DVD, the OPTION (Geographic Identifiers) when looking at a table on American Factfinder, and a several different internet sites:

State and County - http://www.census.gov/geo/tigerline/append_a.pdf
Place - http://www.census.gov/geo/www/fips/
Metropolitan Area - http://www.census.gov/population/estimates/metro-city/99mfips.txt

Closing

You can close the program at any moment by clicking on the Close button on the lower lefthand side of the screen. It is not necessary to save your workspace if you have the information you need.

Grace York, Coordinator, Documents Center
University of Michigan Library
Send comments and suggestions to graceyor@umich.edu

http://www.lib.umich.edu/govdocs/census2/alloca4.htm

December 20, 2001 this page has been accessed