This test file provides users with the opportunity to test ...



. README

Census 2000 Summary File for American Samoa

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 |

|support/SF3ASCII.html . |

| |

|■ Structure files in Access97 and other formats are available at support/2000/Island_Areas/American_Samoa |

| |

| |

|■ 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. .

■ This system provides Internet access to all tables on the Summary File for American Samoa.

■ 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 (, 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 asgeo_sfia.dat

■ as is USPS state abbreviation for American Samoa

( xxxxxx is the file segment number.

( Segment geo contains the geographic information.

( Segment number range is 000001 through 000031

. See below for distribution of tables across the files.

Technical Documentation

■ The complete technical documentation for Summary File for American Samoa is available at

.

Data Records and Segmentation

■ Table distribution across data files is as follows:

Figure 2-2. File/Table Segmentation

| | | | |

|File Name |Number of |Starting |Ending |

|(CIFSN) |cells |Matrix |Matrix |

| | |Number |Number |

| asgeo_sfia.dat | | | |

| | | | |

|as000001_sfia.dat |243 |P1 |P15 |

| | | | |

|as000002_sfia.dat |221 |P16 |P28 |

| | | | |

|as000003_sfia.dat |72 |P29 |P34 |

| | | | |

|as000004_sfia.dat |221 |PBG1 |PBG21 |

| | | | |

|as000005_sfia.dat |248 |PBG22 |PBG41 |

| | | | |

|as000006_sfia.dat |249 |PBG42 |PBG89 |

| | | | |

|as000007_sfia.dat |196 |PBG90 |PBG131 |

| | | | |

|as000008_sfia.dat |244 |PCT1 |PCT6 |

| | | | |

|as000009_sfia.dat |241 |PCT7 |PCT12 |

| | | | |

|as000010_sfia.dat |248 |PCT13 |PCT19 |

| | | | |

|as000011_sfia.dat |183 |PCT20 |PCT25 |

|as000012_sfia.dat | | | |

| |221 |PCT26 |PCT31 |

| | | | |

|as000013_sfia.dat |231 |PCT32 |PCT37 |

| | | | |

|as000014_sfia.dat |239 |PCT38 |PCT42 |

| | | | |

|as000015_sfia.dat |249 |PCT43 |PCT45(pt.) |

| | | | |

|as000016_sfia.dat |219 |PCT45 (pt.) |PCT47 |

| | | | |

|as000017_sfia.dat |239 |PCT48 |PCT52 |

| | | | |

|as000018_sfia.dat |218 |PCT53 |PCT62 |

| | | | |

|as000019_sfia.dat |202 |PCT63 |PCT66 |

| | | | |

|as000020_sfia.dat |169 |PCT67 |PCT71 |

| | | | |

|as000021_sfia.dat |203 |PCT72 |PCT74 |

| | | | |

|as000022_sfia.dat |249 |PCT75 |PCT77 |

| | | | |

|as000023_sfia.dat |98 |PCT78 |PCT83 |

| | | | |

|as000024_sfia.dat |78 |H1 |H12 |

| | | | |

|as000025_sfia.dat |246 |HBG1 |HBG28 |

| | | | |

|as000026_sfia.dat |239 |HBG29 |HBG62 |

| | | | |

|as000027_sfia.dat |249 |HBG63 |HBG106 |

| | | | |

|as000028_sfia.dat |35 |HBG107 |HBG115 |

| | | | |

|as000029_sfia.dat |240 |HCT1 |HCT8 |

| | | | |

|as000030_sfia.dat |235 |HCT9 |HCT18 |

| | | | |

|as000031_sfia.dat |117 |HCT19 |HCT22 |

■ 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 31 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.

. File Record Layout

.

■ For a layout of the individual tables for each file, see the technical documentation at . Select Chapter 6, Summary Table Outlines.

FTP File Transfer

■ Summary File for the Guam FTP directory is at

ftp2.census_2000/datasets/Island_Areas/American_Samoa

■ The chart above lists the table numbers available in each of the 31 data

files.

■ 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

.

■ An Internet search using the term “download multiple files” yielded other similar products.

■ For step-by-step instructions with screen shots, please see ..

Files

( The Island Area files are not zipped.

■ Geographic header file has fixed fields.

■ File data dictionary is at

■ Data files (files 01-31) 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 support/SF3ASCII.html .

■ Structure files in Access97 and other formats are available at .

■ We are unable to provide one-on-one support for applications of the data to specific spreadsheets or data base software.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download