APPENDIX I. CD-ROM Technical Information1 CONTENTS Converting to ASCII Files-------------------I-2 Equipment-----------------------------------I-1 Software------------------------------------I-1 Technical Documentation---------------------I-2 EQUIPMENT The two basic pieces of equipment needed to use CD-ROM's are a microcomputer and a CD-ROM drive. A printer is very useful but not essential. Your microcomputer should be equipped with at least 640K random access memory (RAM). While a hard disk is not required on your microcomputer, it is very useful. SOFTWARE Software is needed for accessing the CD-ROM as well as for accessing the data. MS-DOS 3.3 or higher is needed as your operating system if you have a CD-ROM reader. You will also need DOS file manager software such as Microsoft's CD-ROM Extensions. CD- ROM extensions is a collection of programs that enables the microcomputer to communicate with the attached CD-ROM drives. You must have version 2.0 or higher of the Microsoft Extensions. If you already have a CD-ROM drive, you may not know whether it is equipped with file manager software like the CD-ROM extensions. To find out, try signing on to your CD-ROM drive just as though it is a magnetic disk drive, and perform simple file management tasks, like listing the directory. (For example, from the DOS prompt, type the command DIR and the letter used to designate the CD-ROM drive followed by a colon [e.g., C>DIR L:] and press enter.) If you get an error message, it may mean that you need to obtain and install CD-ROM extensions. CD-ROM Extensions The CD-ROM is in the ISO 9660 format which requires the use of Microsoft CD-ROM Extensions Version 2.0 or higher. Although all versions of CD-ROM extensions work basically the same way, installation procedures may vary slightly from one supplier to another. Many versions contain a program that will automatically install the software for you, after you have answered a few questions about the type of equipment that you plan to use. Be sure to follow the instructions for installing CD-ROM Extensions that are provided with the software. The first step, if you are installing extensions without the aid of an automatic set-up program, is usually installing the device driver program and MSCDEX.EXE on your bootable disk. For computers containing a hard drive, this usually means drive C. The name of the device driver program varies from one version of extensions to another; one common practice of software developers is to name it after the brand of CD-ROM drive that it supports, e.g., HITACHI.SYS. The device driver program and MSCDEX are frequently set up in separate subdirectories; however, this practice is not universal. The next step is to add a line to the CONFIG.SYS file to identify the device driver program. This line typically looks something like this: DEVICE=\path\driver name/D:\driver alias/N:# For example:device=\dev\HITACHI.SYS/D:MSCD001/N:1 The driver name (e.g., HITACHI.SYS) and the driver alias should be provided by the set-up program or in the instructions that accompany the floppy disk containing the extensions software. The symbol # at the end of the line should be replaced with the number of CD-ROM drives (up to 4) that will be hooked up to the microcomputer. The third step is to add a line to the AUTOEXEC.BAT file for running MSCDEX.EXE and assigning a letter to your CD-ROM drive. Depending on your system configuration you may opt to set up one or more batch files to accomplish the same purpose. If you add a line to the AUTOEXEC.BAT file, it will probably look something like this: \path\MSCDEX.EXE/D:driver alias/M:8/L:L For example: \BIN\MSCDEX.EXE/D:MSCD001/M:12/L:L The driver alias, which is really the name that your system will use to identify the device driver, should be the same one that is named in your CONFIG.SYS file. The number following M: is the number of memory buffers allocated (usually 8, but sometimes more). The last letter, following the L:, designates the letter assigned to the CD- ROM drive. Though the final step is simple, it's also easy to overlook. You must reboot the system in order to activate the changes that you've made to your CONFIG.SYS and AUTOEXEC.BAT. Once properly installed, the device behaves much like a read-only floppy diskette drive, and simple MS-DOS commands such as DIR are possible. If the computer reports that the CD-ROM is ``not High Sierra,'' you must first upgrade your Microsoft CD-ROM Extensions software to version 2.0 or later. Data Retrieval Software2 This CD-ROM contains data retrieval software. This software was developed and tested on a COMPAQ Deskpro 286 with 640K RAM operating under MS-DOS 3.31. The software was compiled with Clipper. There are no special display requirements. Please note that the retrieval software will only run on IBM-compatibles operating under MS-DOS. The Census Bureau CD-ROM's containing 1990 census data (STF's 1 and 3) includes a simple ``point and shoot'' retrieval software. It has been nicknamed ``GO.'' This menu-driven software is on the disc and requires no installation. The menus and tables are customized for the data on the disc. The GO software is included on other Census products and is customized according to the data on the disc. The following is a description of the GO software. Using GO, you first select a specific level (e.g., State, county, place, census tract). Available features are displayed on a command bar, and most data can be accessed using the Return, PgUp/PgDn, and Up and Down arrow keys. Every STF disc also contains a ``general profile'' feature that gives you the basic population and housing information for the geographic entities shown on the disc. This is helpful when you need just the basics. Once you've identified the geographic entity you want, select specific data items. They generally are the same as the tables listed in the technical documentation. Another helpful feature is the ``Key-words'' option. After choosing a specific geographic entity, you can specify key words (such as race or ancestry groups) by hitting the letter ``K'' on your computer's keyboard. This option gets you to specific tables more quickly. GO also contains a ``Glossary'' option (hit the letter``G'' on your keyboard). Note that this feature is available within data tables. Again, features are available when shown on the command bar. In the glossary, you will find definitions for geographic entities and other terms. Refer to appendix A and B (on the CD-ROM -in the DOCUMENT directory), or the technical documentation for the complete text of definitions. GO's ``Print'' command allows you to print the tables you need. The ``Copy File'' command lets you copy files from the CD-ROM onto your computer's hard drive in three formats: ASCII flat/System Data Format (SDF), ASCII comma-delimited, and dBASE. CD-ROM's with issue dates of October 1992 and later have updated software which also provides the option for direct output to files in the WK1 spreadsheet format. This updated software also requires less memory than previous versions. The data on the CD-ROM are in dBase III+TM~ format. Data in dBase III+ format are recognized by many software packages including dBase IVTM, FoxbaseTM, ClipperTM, Supercalc VTM, Quattro ProTM, and VP-PlannerTM. Users of other types of systems, such as the Apple Macintosh, have access to the files through support for ISO 9660 CD-ROM's. CONVERTING TO ASCII FILES Users without database management software who wish to convert the files to ASCII can follow the code found in the README file on the CD-ROM. TECHNICAL DOCUMENTATION The DOCUMENT directory on the CD-ROM contains sections of the STF 3 (Puerto Rico) File technical documentation in a series of ASCII text files. These are as follows: ROSTER_P.ASC Roster Page ACKNOW.ASC Acknowledgments CONTENTS.ASC Contents ABST_S3.ASC Abstract HOWTOUSE.ASC How to Use the File SUB_LOC.ASC Subject Locator LIST_TBL.ASC List of Tables TBL_OUT.ASC Table Outlines SUM_LEV.ASC Summary Level Sequence Chart USERNOTE.ASC User Notes Explanation and Notes IDEN_FTN.ASC Identification Section of the Data Dictionary TBL_MTX.ASC Table (Matrix) Section of the Data Dictionary APPEND_A.ASC Appendix A Area Classifications APPEND_B.ASC Appendix B Subject Characteristics APPEND_C.ASC Appendix C Accuracy of the Data APPEND_D.ASC Appendix D Procedures APPEND_E.ASC Appendix E Facsimiles of Instructions APPEND_F.ASC Appendix F Data Products APPEND_G.ASC Appendix G Maps (Text only) APPEND_H.ASC Appendix H. Code Lists APPEND_I.ASC Appendix I CD-ROM Technical Information Figure 4. Reference Files STF300PR.DBF This file describes the structure of the 67 identification fields in the STF300 segment. This is in the format of a dBASE III extended structure which has been expanded to include brief field descriptions. Structure for database: stf300.dbf Number of data records: 67 Field Field Name Type Width Dec 1 FIELD_NAME Character 10 2 FIELD_TYPE Character 1 3 FIELD_LEN Numeric 3 4 FIELD_DEC Numeric 3 5 FIELD_TEXT Character 60 ** Total ** 78 TABLES.DBF This file describes the numeric data tables. Structure for database: tables.dbf Number of data records: 2,990 Field Field Name Type Width Dec 1 TABLE Character 6 2 FIELD Character 10 3 TEXT Character 68 4 SEGMENT Character 6 ** Total ** 91 CNAMESPR.DBF This file contains a list of county names and FIPS county codes for Puerto Rico. Structure for database Field Field Name Type Width Dec 1 CNTY Character 3 2 ANPSADPI Character 66 ** Total ** 91 \DOCUMENT Directory of technical documentation files in ASCII text format. Figure 5. Index Files TABLES.NDX This is a dBASE III index file for TABLES.DBF. The key field is TABLE. The following dBASE index files are for STF3??PR.DBF. STF3AMPR.NDX The key fields are SUMLEV + CNTY + COUSUBFP + PLACEFP + TRACTBNA + BLCKGR. STF3APPR.NDX The key fields are SUMLEV + PLACEFP. STF3ATPR.NDX The key fields are SUMLEV + CNTY + TRACTBNA + BLCKGR. STF3ALPR.NDX The key fields are SUMLEV + left(ANPSADPI,1). ---------- 1Portions of this appendix are adapted from Administrative Notes, the Newsletter of the Federal Depository Library Program (May 22, 1989). 2Portions of this section are adapted from Census and You, November 1992, p.3. CENSUS OF POPULATION AND HOUSING, 1990: SUMMARY TAPE FILE 3 ON CD-ROM (PUERTO RICO) DATA TECHNICAL NOTE 1 The following geographic names appear incorrectly in the summary tape files for Puerto Rico. Bold type identifies the correct entry. In the records for Aguirre (Rural) subbarrio, Salinas Municipio, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Aguirre (rural) subbarrio. In the records for Alto del Cabro subbarrio, San Juan Municipio, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Alto Del Cabro subbarrio. In the records for Baldorioty de Castro subbarrio, Ponce Municipio, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Baldorioty De Castro subbarrio. In the records for Fuig communidad, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Fuig comunidad In the records for Higuey subbarrio, Aguadilla Municipio, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Higuey subbarrio. In the records for Imbery comunidad, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Imbery comunidad. In the records for Indiera Fria barrio, Maricao Municipio, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Indiera Fna barrio. In the records for Luyando communidad, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Luyando comunidad. In the records for Maizales barrio, Naguabo Municipio, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Maizales barrio. In the records for Pozo del Hato subbarrio, San Juan Municipio, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Pozo Del Hato subbarrio. In the records for Puerta de Tierra subbarrio, San Juan Municipio, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as Puerta De Tierra subbarrio. In the records for San Cristobal subbarrio, San Juan Municipio, the name (beginning in position 192 in the identification section of the data dictionary) is shown incorrectly as San Cristobal subbarrio. October 1993 CENSUS OF POPULATION AND HOUSING, 1990: SUMMARY TAPE FILE 3 ON CD-ROM (PUERTO RICO) DATA TECHNICAL NOTE 2 The following areas should have been assigned to selected subbarrios: The unassigned portion of Aguadilla Municipio, Aguadilla barrio should be attributed to Higuey subbarrio. The unassigned portion of Salinas Municipio, Aguirre barrio should be attributed to Coqui subbarrio. The unassigned portion of San Juan Municipio, Santurce barrio should be attributed to Merhoff subbarrio. October 1993