DRAFT: Some links provided may not be active yet. README Census 2000 Summary File 3 Delivered via FTP Contents About the FTP Application Other Sources of the Data File Naming Convention Technical Documentation Data Records and Segmentation File Record Layout FTP File Transfer UnZipping the Files Spreadsheet and Data Base Aids Maximum File Sizes þ For step-by-step instructions for moving the data and the structure into a data base format (including screen shots), please see www.census.gov/support/SF3ASCII.html . þ Structure files in Access97 and other formats are available at http://www.census.gov/support/2000/SF3/ . þ We are unable to provide one-on-one support for applications of the data to specific spreadsheets or data base software. About the FTP Application þ The application is intended for experienced users of census data, compressed files, and spreadsheet/database software. þ FTP users should have a fast file transfer capability. þ Users of the FTP application need to unzip the compressed file after downloading, then import it into the spreadsheet/database software of their choice for data analysis and table presentation. Other Sources of the Data þ American FactFinder at factfinder.census.gov . þ This system provides Internet access to all tables plus additional derived tables called Quick Tables and Geographic Comparison Tables. þ The system can create thematic maps on various data items. þ The system can create reference maps defining the geographic area. þ Tables are available on American FactFinder on the morning of public release. þ DVD/CD-ROM þ CD-ROMs are available for individual states on or shortly after the public release date. These early CD-ROMs are in flat ASCII format without software. þ DVDs are created after all states are released. These DVD's and the final CD-ROM package contain software. þ They can be purchased online ($50 for CD-ROM; $70 for DVD) from the Census Catalog (www.census.gov, select Census Catalog from left sidebar) or ordered by telephone from the Customer Services Center (301-457-INFO). þ DVDs and CD-ROMs contain the same software. þ Software is proprietary but are in a format the can easily be imported into data bases or spreadsheets. File Naming Conventions þ The naming convention for geographic header files is ssgeo_uf3.zip þ ss is USPS state abbreviation þ The codes are in technical documentation on page 7-1, located at http://www.census.gov/prod/cen2000/doc/sf3.pdf þ geo_uf3.zip is a constant across SF3 geographic header names. þ Naming convention for SF3 data files is ssiiiyy_uf3.zip. þ ss is USPS state abbreviation þ iii is the characteristic iteration (total population, race groups, American Indian and Alaska Native tribes, and Hispanic/Latino groups). These only apply to SF 2 and SF 4. In SF 1 and SF 3, the characteristic iteration will always be 000. þ yy is the number of the file þ Valid codes are 01 through 76. See below for distribution of tables across files. þ _uf3.zip is a constant across SF3 data file names Technical Documentation þ The complete technical documentation for SF3 is available at http://www.census.gov/prod/cen2000/doc/sf3.pdf . Data Records and Segmentation þ Table distribution across data files is as follows: Figure 2-2. File/Table Segmentation File Name (CIFSN) NUMBER OF DATA ITEMS STARTING MATRIX NUMBER ENDING MATRIX NUMBER stgeo.uf3 st00001.uf3 248 P1 P14 st00002.uf3 218 P15 P24 st00003.uf3 241 P25 P37 st00004.uf3 227 P38 P46 st00005.uf3 220 P47 P50 st00006.uf3 250 P51 P67 st00007.uf3 213 P68 P91 st00008.uf3 245 P92 P138 st00009.uf3 203 P139 P145C st00010.uf3 245 P145D P145H st00011.uf3 235 P145I P146F st00012.uf3 246 P146G P147I st00013.uf3 241 P148A P149D st00014.uf3 245 P149E P150I st00015.uf3 239 P151A P154D st00016.uf3 240 P154E P159G st00017.uf3 239 P159H P160E st00018.uf3 164 P160F P160I st00019.uf3 247 PCT1 PCT8 st00020.uf3 204 PCT9 PCT15 st00021.uf3 222 PCT16 PCT17 st00022.uf3 235 PCT18 PCT19 st00023.uf3 233 PCT20 PCT24 st00024.uf3 233 PCT25 PCT27 st00025.uf3 221 PCT28 PCT32 st00026.uf3 106 PCT33 PCT34 st00027.uf3 221 PCT35 PCT37 st00028.uf3 162 PCT38 PCT43 st00029.uf3 205 PCT44 PCT48 st00030.uf3 224 PCT49 PCT51 st00031.uf3 205 PCT52 PCT56 st00032.uf3 243 PCT57 PCT61 st00033.uf3 243 PCT62A PCT63C st00034.uf3 234 PCT63D PCT64H st00035.uf3 231 PCT64I PCT66C st00036.uf3 233 PCT66D PCT67E st00037.uf3 223 PCT67F PCT68C st00038.uf3 245 PCT68D PCT68H st00039.uf3 247 PCT68I PCT69I st00040.uf3 243 PCT70A PCT70I st00041.uf3 245 PCT71A PCT71E st00042.uf3 196 PCT71F PCT71I st00043.uf3 240 PCT72A PCT72B st00044.uf3 240 PCT72C PCT72D st00045.uf3 240 PCT72E PCT72F st00046.uf3 240 PCT72G PCT72H st00047.uf3 215 PCT72I PCT73A st00048.uf3 190 PCT73B PCT73C st00049.uf3 190 PCT73D PCT73E st00050.uf3 190 PCT73F PCT73G st00051.uf3 190 PCT73H PCT73I st00052.uf3 231 PCT74A PCT75C st00053.uf3 236 PCT75D PCT75G st00054.uf3 234 PCT75H PCT76D st00055.uf3 145 PCT76E PCT76I st00056.uf3 127 H1 H18 st00057.uf3 249 H19 H26 st00058.uf3 216 H27 H44 st00059.uf3 250 H45 H68 st00060.uf3 248 H69 H86 st00061.uf3 250 H87 H104 st00062.uf3 59 H105 H121 st00063.uf3 171 HCT1 HCT3 st00064.uf3 115 HCT4 HCT4 st00065.uf3 143 HCT5 HCT5 st00066.uf3 248 HCT6 HCT7 st00067.uf3 219 HCT8 HCT14 st00068.uf3 214 HCT15 HCT17 st00069.uf3 220 HCT18 HCT23 st00070.uf3 248 HCT24 HCT31C st00071.uf3 246 HCT31D HCT36D st00072.uf3 246 HCT36E HCT40I st00073.uf3 243 HCT41A HCT43I st00074.uf3 224 HCT44A HCT44G st00075.uf3 247 HCT44H HCT47F st00076.uf3 96 HCT47G HCT48I þ Five fields are carried over from the geographic header file into each data file. þ These fields are file identification (FILEID), state abbreviation (STUSAB), characteristic iteration (CHARITER), characteristic iteration file sequence number (CIFSN) and logical record number (LOGRECNO). þ These five fields appear in the geographic header file in a fixed field format. þ These five fields appear in the four data files in a comma delimited format. þ These fields are used to "match" records in the four data files to the geographic information in the geoheader. A file set structure schematic appears in the technical documentation (page xxxxx) which is located at http://www.census.gov/prod/cen2000/doc/sf3.pdf File Record Layout þ For a layout of the individual tables for each file, see the technical documentation at www.census.gov/prod/cen2000/doc/sf3.pdf . Select Chapter 6, Summary Table Outlines. FTP File Transfer þ Summary File 3 (SF3) FTP directory is at ftp2.census.gov/census_2000/datasets/Summary_File_3 . þ Each state directory provides all files for the identified state. þ The directory for each state has a geographic header file and 76 data files. þ The chart on page 3 of this document lists the table numbers available in each of the 76 þ files. þ Once uncompressed, the files are in a flat ASCII format. þ No software is provided. þ Downloading multiple files þ UNIX environment-"mget" subcommand allows transfer of multiple files using the wildcard character. þ Example: ftp> prompt off ftp>mget ne* (for this example, Nebraska is selected). þ Windows Environment-many FTP products have been developed which have the capability to download multiple files with a single command. þ We used the ws_ftp product in testing the download. þ A demonstration copy is available at http://www.ipswitch.com/ þ An Internet search using the term "download multiple files" yielded other similar products. þ For step-by-step instructions with screen shots, please see http://www.census.gov/support/2000/SF3/ .. Unzipping the Files þ Files compress at approximately 95% compression. þ Any standard UnZIP software package can be used. þ In testing we used PKZIP for Windows. It's available at www.pkware.com. . þ Unzipped files are in flat ASCII format. For step-by-step instructions with screen shots, please see http://www.census.gov/support/2000/SF3/ . Unzipped Files þ Geographic header file has fixed fields. þ File data dictionary is at http://www.census.gov/prod/cen2000/doc/sf3.pdf . See chapter 7 for the data dictionary. þ Data files (files 01-76) have comma delimited fields þ Fields from the geographic header file carried over to the data files are comma delimited in the data files . Spreadsheet and Data Base Aids þ For step-by-step instructions with screen shots for moving the data and structure to a spreadsheet, please see www.census.gov/support/SF3ASCII.html . þ Structure files in Access97 and other formats are available at http://www.census.gov/support/2000/SF3/ . þ We are unable to provide one-on-one support for applications of the data to specific spreadsheets or data base software. Maximum File Sizes þ The figures below are the maximum file sizes for SF3 and are identical to the sizes for SF1. þ As state tables are run, we will update this listing. SF3 GeoHeader and File01-File76 Maximum File Sizes unzipped zipped State Alabama 1.7G 87M Alaska .3G 11.7M Arizona 1.5G 51M Arkansas 1.5G 35M California 5.1G 260M Colorado 1.5G 75M Connecticut .6G 28M Delaware .2G 7.8M District of Columbia .6G 4.6M Florida 3.4G 170M Georgia 2.3G 110M Hawaii .2G 27.8M Idaho .9G 12.5M Illinois 4.1G 209M Indiana 2.1G 108M Iowa 1.7G 37M Kansas 1.7G 88M Kentucky 1.1G 58M Louisiana 1.5G 77M Maine .5G 10M Maryland .9G 54M Massachusetts 1.2G 58M Michigan 2.7G 136M Minnesota 2G 105M Mississippi 1.4G 33.5M Missouri 2.5G 125M Montana .9G 12M Nebraska 1.4G 21M Nevada .7G 23M New Hampshire .3G 8M New Jersey 1.7G 82M New Mexico 1.4G 26M New York 3.6G 180M North Carolina 2.5G 123M North Dakota .9G 8M Ohio 2.8G 138M Oklahoma 1.8G 90M Oregon 1.4G 71M Pennsylvania 3.5G 174M Rhode Island .24G 12M South Carolina 1.5G 35M South Dakota .8G 12M Tennessee 1.9G 42M Texas 6.8G 198M Utah .8G 21M Vermont .25G 8M Virginia 1.5G 64M Washington 2G 100M West Virginia .9G 18M Wisconsin 2G 100M Wyoming 7G 6M Puerto Rico .8G 35M . st represents the United States Postal Service 2-character alphabetic state abbreviation. 1