September 29, 1995 1990 Census of Population and Housing Summary Tape File 3A 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴쩡컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� � Software versions � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� [2.5f, Sep 1995] Fixes minor problem causing infrequent abnormal program termination. [2.5e, May 1994] This version fixes a minor problem in creating profiles in a LAN environment. [2.5d, Jan 1994] LAN version. [2.5a, Jul 1993] Software recompiled with Clipper 5.2. [2.4, Apr 1993] This version fixes a problem in the geographic names attached to MSA and UA records in output files. This was introduced in Version 2.0. [2.0, Oct 1992] Software recompiled with Clipper 5. This version also provides the capability to copy data directly to a Lotus (WK1) spreadsheet. 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴쩡컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� � Starting the software � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� Copy the contents of the software diskette to your hard drive. Type GO [CD-ROM drive] at the DOS prompt and ENTER. Example: c:\>go m: For LAN option, type GO [CD-ROM drive] LAN. Example: c:\>go m: lan 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴쩡컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� � Using the CD-ROM � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� Some STF 3A State files require more than one CD-ROM. When a State is split, each CD-ROM contains small area summaries such as census tracts and block groups for selected counties. Each of the CD-ROMs for a State contains all summaries for places, counties, and higher levels of census geography. The 1990 Summary Tape File 3A software runs on personal computers with 640K RAM operating under MS-DOS 3.0 or higher. There are no special display requirements. The CD-ROM is in the ISO 9660 format which requires the use of Microsoft CD-ROM Extensions Version 2.0 or higher. The software displays some brief statistical definitions through the glossary function. Refer to Appendix B (\document\append_b.asc) of the technical documentation for the complete text. For direct access to the data files, one of the many software packages which recognize the dBASE III Plus (.DBF) format will be very useful. Users of other types of systems, such as the Apple Macintosh, have access to the files through support for ISO 9660 CD-ROMs. Please note that the retrieval software will only run in the MS-DOS environment. 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴쩡컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� � Some changes � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� Summary Tape File 3A CD-ROMs with issue dates of October 1992 and later have corrections in the TABLES.DBF template for population imputation tables (P128-P170). In general, the first line in each of these tables was incorrectly listed as filler. The last line is now correctly listed as filler. The exceptions are tables P129, P167, P168, P169 which have no filler, and tables P144, P156, P157, P158, P161, and P162. In this latter group, the next-to-last line is filler. Format of population imputation tables prior to October 1992: 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� � IMPUTATION OF POPULATION ITEMS � � Universe: Persons � � Filler......................... 2,469,715� � No items allocated........... 2,396,977� � One or more items allocated.. 0� 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� Format of population imputation tables beginning October 1992: 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� � IMPUTATION OF POPULATION ITEMS � � Universe: Persons � � No items allocated........... 2,469,715� � One or more items allocated.. 2,396,977� � Filler......................... 0� 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴쩡컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� � Contents of the CD-ROM � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� Volume in drive is CD90_3A_nn DOCUMENT Directory for documentation files. These are ASCII text files which contain complete technical documentation for the data. See \DOCUMENT\HOWTOUSE.ASC for information on the contents of the files. GO.BAT Batch file to execute data retrieval software. STF3A.EXE Data retrieval software. STF3??ss.DBF Statistical database files for each State. is the State abbreviation. There are 35 files for each State numbered STF300ss.DBF through STF334ss.DBF >>Reference Files<< STF3STRU.DBF This file describes the structure of the first 67 fields in the statistical database file. These are the identification fields. TABLES.DBF This file describes the numeric data tables. CNAMESss.DBF This file lists county names and FIPS codes for State . >>Index Files<< CNAMESss.NDX This is a dBASE III index file for CNAMESss.DBF. Key field is ANPSADPI. STF3AMss.NDX This is a dBASE III index file for STF300ss.DBF. Key fields are SUMLEV + CNTY + COUSUBFP + PLACEFP + TRACTBNA + BLCKGR. STF3APss.NDX This is a dBASE III index file for STF300ss.DBF. Key fields are SUMLEV + PLACEFP. STF3ATss.NDX This is a dBASE III index file for STF300ss.DBF. Key fields are SUMLEV + CNTY + TRACTBNA + BLCKGR. STF3ALss.NDX This is a dBASE III index file for STF300ss.DBF. Key fields are SUMLEV + left(ANPSADPI,1). This index is UNIQUE. TABLES.NDX This is a dBASE III index file for TABLES.DBF. Key fields are TABLE + FIELD. 旼컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴쩡컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� � Converting dBASE files � 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴� '********************************************** '*** This is a Microsoft BASIC program that *** '*** converts a dBASE (.DBF) file to ASCII *** '*** (.TXT). *** '********************************************** CLS INPUT "Database file to convert -> ", InFile$ INPUT " Text file -> ", OuFile$ OPEN InFile$ FOR BINARY AS #1 OPEN OuFile$ FOR OUTPUT AS #2 TYPE HdrStru Filler AS STRING * 4 RecCount AS LONG HdrBytes AS INTEGER RecBytes AS INTEGER END TYPE DIM Hdr AS HdrStru GET #1, , Hdr SEEK #1, Hdr.HdrBytes + 1 RecCntr = 0 DO Rec$ = STRING$(Hdr.RecBytes, " ") GET #1, , Rec$ PRINT #2, MID$(Rec$, 2) RecCntr = RecCntr + 1 IF RecCntr = Hdr.RecCount THEN EXIT DO LOOP CLOSE #1, #2 읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸