Latitude and Longitude of Standard Metropolitan Areas

The file above was obtained from 1990 Census Summary Tape File 3C (STF3C) (urbanized areas). 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 of the 396 SMAs (Standard Metropolitan Areas) in the 1990 Census:
	4-digit code
	name of SMA
	latitude of an internal point (6 decimal places)
	longitude of an internal point (6 decimal places)

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 diskNNN location of 1990 Census STF3C Urbanized Areas from
http://merrill.olm.net/cdrom/install/contents.online.html:

 1990cen|3c      |1990 Census: STF3C        |US Urbanized Areas         |disk83 
-------------------------------------------------------------------------------
2. Get NFS location of disk83 from
http://merrill.olm.net/cdrom/install/nfsloc.online.html:

 disk83 |ucdata9.berkeley.edu  |/export_cdroms/juke2/disk5  
-------------------------------------------------------------------------------
3. With PC-NFS, mount the CD on drive g:
net use g: ucdata9.berkeley.edu:/export_cdroms/juke2/disk5
-------------------------------------------------------------------------------
4. With dBaseIV, list the data files on the CD:
dbase
set default to g:
dir
	stf300us.dbf through stf334us.dbf (16207 records each)
	tables.dbf (4780 recs) (tables in stf301us.dbf through stf334us.dbf)
	stf3stru.dbf (67 recs) (fields in stf300us.dbf)
	unames.dbf (396 recs) (SMAs)
-------------------------------------------------------------------------------
5. In stf3stru.dbf, determine the fields of interest in stf300us.dbf:
use stf3stru
browse
	SUMLEV		Summary Level
	GEOCOMP		Geographic Component
	LOGRECNU	Logical Record Number
	URBAREA		Urbanized Area
	ANPSADPI	Area Name/PSAD Term/Part Indicator
	INTPTLAT	Internal Point (latitude - six decimal places)
	INTPTLNG	Internal Point (longitude - six decimal places)
-------------------------------------------------------------------------------
6. In unames.dbf, check names of SMAs:
use unames
browse
goto top
	ANPSADPI	LOGRECNU
	Abilene, TX	014867
goto last
	ANPSADPI	LOGRECNU
	Yuma, AZ--CA	031057 
-------------------------------------------------------------------------------
7.  In stf300us.dbf, check fields of interest:
use stf300us
browse
 SUMLEV	GEOCOMP	LOGRECNUURBAREA	ANPSADPI	INTPTLAT	INTPTLNG	
 400	00	014867	0040	Abilene, TX	+32453450	-099746242	
 ...
 400	00	031057	9360	Yuma, AZ--CA	+32684143	-114624457	
-------------------------------------------------------------------------------
8.  Check criteria to select 396 SMAs:
count for sumlev="400".and.geocomp="00"
	396 records
-------------------------------------------------------------------------------
9.  List desired fields, without record numbers, to a file c:\temp.1:
list off urbarea,intptlat,intptlng,anpsadpi to file c:\temp.1 for sumlev="400".and.geocomp="00"
-------------------------------------------------------------------------------
10. Leave dbase and check resulting file:
quit
type c:\temp.1
-------------------------------------------------------------------------------