County parts of 5-digit ZIP codes

The file above was obtained from 1990 Census Summary Tape File 3B (STF3B). The example shown below can be easily modified to obtain other quantities of interest.

The following example lists the following quantities to a file c:\temp.1,
for each county part of 5-digit ZIP code (1990 Census)
	5-digit ZIP code
	FIPS state code
	FIPS county code
	county name
The example requires a PC with a Web browser, PC-NFS and dBaseIV.

Alternatively, one can purchase the CD from the Census Bureau and execute the
same dBase commands.
-------------------------------------------------------------------------------
1. Get current diskNNN locations of 1990 Census STF3B (ZIP codes) from
http://merrill.olm.net/cdrom/install/contents.online.html:

 1990cen|3b      |1990 Census: STF 3B       |ZIP codes 0,1,2,3          |disk105
 1990cen|3b      |1990 Census: STF 3B       |ZIP codes 4,5,6            |disk265
 1990cen|3b      |1990 Census: STF 3B       |ZIP codes 7,8,9            |disk104
-------------------------------------------------------------------------------
2. Get current NFS locations from
http://merrill.olm.net/cdrom/install/nfsloc.online.html:

 disk105|misty.lbl.gov         |/export/cdrom/cd069
 disk265|hibana.lbl.gov        |/export/cdrom/cd007
 disk104|misty.lbl.gov         |/export/cdrom/cd068
-------------------------------------------------------------------------------
3. With PC-NFS, mount one CD on drive g: and check contents:
net use g: misty.lbl.gov:/export/cdrom/cd068
dir g:
-------------------------------------------------------------------------------
4. With dBaseIV, list the data files on the CD:
dbase
set default to g:
dir
	stf300.dbf through stf334.dbf (11103 records each)
	stf3stru.dbf (67 recs) (fields in stf300.dbf)
	tables.dbf (4780 recs) (tables in stf301.dbf through stf334.dbf)
-------------------------------------------------------------------------------
5. In stf3stru.dbf, determine the fields of interest in stf300.dbf:
use stf3stru
browse
	STUSAB		State/US Abbreviation
	SUMLEV		Summary Level
	GEOCOMP		Geographic Component
	CNTY		County
	STATEFP		State (FIPS)
	SAC1		Special Area Code (1)
	ANPSADPI	Area Name/PSAD Term/Part Indicator
-------------------------------------------------------------------------------
6.  In stf300.dbf, check fields of interest:
use stf300
browse
 STUSAB	SUMLEV	GEOCOMP	CNTY	STATEFP	SAC1	ANPSADPI
 LA	820	00	051	22	70001	Jefferson Parish (pt.)
 AK	820	00	201	02	99950	Prince of Wales-Outer Ketchikan
						Census Area (pt.)
-------------------------------------------------------------------------------
7.  Check criteria to select all county-ZIP parts:
count for sumlev="820".and.geocomp="00"
	14222 records	(zip codes 0,1,2,3)
	13070 records	(zip codes 4,5,6)
	 9507 records	(zip codes 7,8,9)
	36799 records	(zip codes 0-9)
-------------------------------------------------------------------------------
8.  List desired fields, without record numbers, to a file c:\temp.1
list off sac1,statefp,cnty,stusab,anpsadpi to file c:\temp.1 for sumlev="820".and.geocomp="00"
-------------------------------------------------------------------------------
10. Leave dbase, dismount the CD, and check resulting file:
quit
net use g: /d
type c:\temp.1
-------------------------------------------------------------------------------