This test file provides users with the opportunity to test ...
README
Census 2000 American Indian and Alaska Native Summary File
Delivered via FTP
.
Contents
About the FTP Application
Other Sources of the Data
File Naming Conventions
Technical Documentation
Data Records and Segmentation
File Record Layout
FTP File Transfer
Unzipping the Files
Unzipped Files
Spreadsheet and Data Base Aids
| |
|■ For step-by-step instructions for moving the data and the structure into a spreadsheet (including screen shots), please see |
| |
| |
|■ Structure files in Access2000 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. |
| |
. 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 plus additional derived tables called Quick Tables.
■ The system can create reference maps defining the geographic area.
■ Tables are available on American FactFinder on the morning of public release.
■ DVD
■ DVDs with software will be created.
■ They can be purchased online from the Census Catalog (, select Census Catalog from left sidebar) or ordered by telephone from the Customer Services Center (301-763-INFO).
■ Software is proprietary but are in a format that can easily be imported into data bases or spreadsheets.
. File Naming Conventions
■ The naming convention for geographic header files is usgeo_ai1.zip
■ The AIAN SF technical documentation is not available at this time. For an example of what will be available in the AIAN SF technical documentation, please see the SF4 codes that are available in SF4 technical documentation on page 7-1, located at
■ geo_ai1.zip is a constant across AIAN SF geographic header names.
■ Naming convention for AIAN SF data files is usiiiyy_ai1.zip.
■ iii is the characteristic iteration (total population, American Indian and Alaska Native tribes. )
. ■ The characteristic iteration codes can be found on the FTP directory in MS Excel format.
.
■ yy is the number of the file
. ■ Valid codes are 01 through 38. See below for distribution of tables across files.
■ _ai1.zip is a constant across AIAN SF data file names
Technical Documentation
■ The complete technical documentation for the AIAN SF is not available at this time. It will be released at a later date.
Data Records and Segmentation
Table distribution across data files is as follows:
| |Number of |Starting |Ending |
| |data |matrix |matrix |
|File name |items |number |number |
|usgeo.ai1 | | | |
|usiii01.ai1 |220 |PCT1 |PCT4 |
|usiii02.ai1 |249 |PCT5 |PCT16 |
|usiii03.ai1 |208 |PCT17 |PCT34 |
|usiii04.ai1 |189 |PCT35 |PCT37 |
|usiii05.ai1 |244 |PCT38 |PCT45 |
|usiii06.ai1 |240 |PCT46 |PCT49 |
|usiii07.ai1 |214 |PCT50 |PCT61 |
|usiii08.ai1 |248 |PCT62 |PCT67 |
|usiii09.ai1 |220 |PCT68 |PCT71 |
|usiii10.ai1 |221 |PCT72 |PCT76 |
|usiii11.ai1 |106 |PCT77 |PCT78 |
|usiii12.ai1 |234 |PCT79 |PCT81 |
|usiii13.ai1 |99 |PCT82 |PCT84 |
|usiii14.ai1 |223 |PCT85 |PCT86(pt.) |
|usiii15.ai1 |237 |PCT86(pt.) | |
|usiii16.ai1 |250 |PCT87 |PCT103 |
|usiii17.ai1 |207 |PCT104 |PCT120 |
|usiii18.ai1 |185 |PCT121 |PCT131 |
|usiii19.ai1 |157 |PCT132 |PCT137 |
|usiii20.ai1 |213 |PCT138 |PCT143 |
|usiii21.ai1 |144 |PCT144 | |
|usiii22.ai1 |247 |PCT145 |PCT150 |
|usiii23.ai1 |244 |PCT151 |PCT156 |
|usiii24.ai1 |228 |PCT157 |PCT162 |
|usiii25.ai1 |246 |PCT163 |PCT208 |
|usiii26.ai1 |49 |PCT209 |PCT213 |
|usiii27.ai1 |240 |HCT1 |HCT9 |
|usiii28.ai1 |199 |HCT10 |HCT18 |
|usiii29.ai1 |222 |HCT19 |HCT22 |
|usiii30.ai1 |165 |HCT23 |HCT25 |
|usiii31.ai1 |236 |HCT26 |HCT29 |
|usiii32.ai1 |250 |HCT30 |HCT39 |
|usiii33.ai1 |187 |HCT40 |HCT55 |
|usiii34.ai1 |222 |HCT56 |HCT61 |
|usiii35.ai1 |145 |HCT62 |HCT70 |
|usiii36.ai1 |236 |HCT71 |HCT81 |
|usiii37.ai1 |218 |HCT82 |HCT86 |
|usiii38.ai1 |238 |HCT87 |HCT110 |
Five fields are carried over from the geographic header file into each data file.
■ These fields are file identification (FILEID), state/US abbreviation (STUSAB), characteristic iteration (CHARITER), characteristic iteration file sequence number (CIFSN) and logical record number (LOGRECNO).
■ These five fields appear in the geographic header record in a fixed field format.
■ These five fields appear in the 38 data files in a comma-delimited format.
■ These fields are used to “match” records in the38 data files for a particular characteristic iteration to the geographic information in the geoheader.
■ The AIAN SF technical documentation is currently unavailable. A file set structure schematic similar to that which will appear in the AIAN SF technical documentation can be found in the SF 4 technical documentation located at
.
. File Record Layout
.
■ The AIAN SF technical documentation is not available at this time. For a layout of the individual tables similar to that which will be used in the AIAN SF for each file, see the SF 4 technical documentation at .
FTP File Transfer
■ American Indian Alaska Native Summary File (AIAN SF) FTP directory is at .
■ The ‘National’ directory provides all files available.
■ The directory has one geographic header file and 38 files for each iteration that meets the criteria for inclusion in this product
■ The chart on page 3 of this document lists the table numbers available in each of the 38 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 us
■ Windows Environment—many FTP products have been developed which have the capability to download multiple files with a single command.
■ There is also an ‘all_aian.tar’ file that contains all of the data files plus the geo id file.
■ 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
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 .
■ Unzipped file is in flat ASCII format.
Unzipped Files
■ Geographic header file has fixed fields.
■ The AIAN SF technical documentation is currently unavailable. However, the AIAN SF data dictionary will be identical to that used in SF4. The SF4 data dictionary is available at . See chapter 7 for the data dictionary.
■ Data files (files 01-38) 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/SF4ASCII.html.
■ Structure files in Access2000 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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.