states and state equivalents (1990 Census)

A "STATE" is a state or state equivalent in the 1990 Census.

Variables included are:

statefp		State (FIPS)
pop100		Population Count (100%)
arealand	Area (land - .001 square kilometers)
areawat		Area (water - .001 square kilometers)
intptlat	Internal Point (latitude - six decimal places)
intptlng	Internal Point (latitude - six decimal places)
stusab		State/US Abbreviation
anpsadpi	Area Name/PSAD term/Part Indicator

The following example creates a file c:\temp.1. 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 GICS from
http://merrill.olm.net/cdrom/install/contents.online.html:

 1990cen|gics    |Geog Id Code Scheme (GICS)|                           |disk251
-------------------------------------------------------------------------------
2. Get current NFS location from
http://merrill.olm.net/cdrom/install/nfsloc.online.html:

 disk251|ux1.census.gov        |/cdrom4
-------------------------------------------------------------------------------
3. With PC-NFS, mount one CD on drive g: and check contents:
net use g: ux1.census.gov:/cdrom4
dir g:
-------------------------------------------------------------------------------
4. With dBaseIV, list the data files on the CD:
dbase
set default to g:
dir
	gics9001.dbf through gics9012.dbf
	gicsstru.dbf (77 recs) (description of fields)
-------------------------------------------------------------------------------
5. In gicsstru.dbf, determine the fields of interest.  These are the
fields listed above, plus the following:
	GICSRT		GICS Record Type
	GEOCOMP		Geographic Component
use gicsstru
browse
-------------------------------------------------------------------------------
6.  In gics9009.dbf, check the fields of interest:
use gics9009
browse
-------------------------------------------------------------------------------
7.  List desired fields, without record numbers, to a new file c:\temp.1:
!del c:\temp.1
list off statefp,pop100,arealand,areawat,intptlat,intptlng,stusab,anpsadpi
	to file c:\temp.1 for gicsrt="040".and.geocomp="00"
-------------------------------------------------------------------------------
8. Leave dbase and dismount the CD:
quit
net use g: /d
-------------------------------------------------------------------------------
9. Use a text editor to remove the first two lines (a blank line and a header
line) and the last line (end-of-file) from c:\temp.1.
Remove trailing ^M and trailing blanks from each line.
-------------------------------------------------------------------------------