CHAPTER XVI Census of Transportation--Geographic Area Series Abstract XVI-3 File Specifications XVI-5 File Layouts XVI-7 Database Structures XVI-11 User Notes XVI-15 CENSUS OF TRANSPORTATION--GEOGRAPHIC AREA SERIES Abstract CONTENTS Citation XVI-3 Type of File XVI-3 Universe Description XVI-3 Subject-Matter Description XVI-3 Geographic Coverage XVI-3 Technical Description XVI-3 Reference Materials XVI-3 Related Printed Reports XVI-4 Availability XVI-4 CITATION Census of Transportation on CD-ROM, 1987: Geographic Area Series [machine- readable data files] / prepared by the Bureau of the Census. Washington: The Bureau [producer and distributor], 1990. Type of File: Summary statistics. Universe Description: The universe is establishments with paid employees in selected transportation industries, including motor freight transportation and warehousing, water transportation, and transportation services. Subject-Matter Description: This series of two files includes number of establishments with payroll, employment, payroll and revenues for selected transportation industries. The data in these files are the same as those in the TC87-A-1 report, described below. Geographic Coverage: Data are provided for the U.S., States, District of Columbia, Metropolitan Statistical Areas (MSA), Consolidated Metropolitan Statistical Areas (CMSA), and Primary Metropolitan Statistical Areas (PMSA). Technical Description: File Structure: dBase III+ The data are recorded in two files: TC87A1US: 1. File Sequence: National records (by kind-of-business), followed by records for States, then records for MSAs. 2. Available Indexes: a. TC87K1US: By kind of business, record type and geography. b. TC87S1US: First record for each State. c. TC87M1US: First record for each MSA and PMSA. d. TC87N1US: First record for each PMSA. 3. Linkable Label Files: a. TRN87KB (kind-of-business labels) b. MISCCODE (record-type labels) c. STCODE (state names) d. MSA (MSA, CMSA, and PMSA titles) TC87A2US: 1. File Sequence: All record type 10 records, followed by all type 11 records, followed by all type 12 records. Each group has records by state by kind of business. 2. Available Indexes: a. TC87K2US: By kind of business, by State. b. TC87R2US: By record type (table), by State. 3. Linkable Label Files: a. TRN87KB (kind-of-business labels) b. MISCCODE (record-type labels) c. STCODE (state names) Reference Materials: 1987 Economic Censuses CD-ROM Volume 1: Report Series Release 1B Technical Documentation. This documentation has general information, a glossary, record layouts for all files, a questionnaire facsimile, and other reference material. One copy accompanies each CD-ROM order. Additional copies are available for $5 from Customer Services, Data User Services Division, Bureau of the Census, Washington, DC 20233. Guide to the 1987 Economic Censuses and Related Statistics. Describes the scope, coverage, classification systems, data items, and data products for each of the economic censuses and related surveys. Data comparability and uses are also discussed. Single copies are free from Customer Services, Data Users Services Division, Bureau of the Census, Washington, DC 20233. Standard Industrial Classification Manual 1987. Prepared by the Executive Office of the President, Office of Management and Budget and available from Superintendent of Documents, U.S. Government Printing Office, Washington, DC 20402. GPO Stock No.041-001-00314-2. Price is $24. Related Printed Reports: 1987 Census of Transportation, Geographic Area Series (TC87-A-1). The report presents data for establishments with payroll from selected transportation industries for the United States, each State, the District of Columbia, and a selected metropolitan statistical areas (MSA's). Data contents are identical to the CD-ROM files. For sale by the Superintendent of Documents, U.S. Government Printing Office, Washington, DC 20402. For information about availability and prices for individual reports, contact Customer Services, Data User Services Division, Bureau of the Census, Washington, DC 20233. Phone: (301) 763-4100. 1987 Census of Transportation, Subject Reports (TC87-S-1). This report presents data for establishments with payroll based on size of establishment, size of company or firm, and legal form of organization. Establishment statistics are presented by revenue size and by employment size; statistics for firms by revenue size (including concentration by largest firms), by employment size, and by number of establishments operated (single units and multiunits). Most sources of revenue and purchased transportation are provided for some kinds of business. Statistics are presented by kind of business on the number of establishments, revenue, and payroll. Data are presented for the United States as a whole and, where feasible, for the States and selected MSA'S. Availability: The CD-ROM is a part of the series of releases for the Economic Census file. This data set is available on one CD-ROM for microcomputers. The subscription price of $475 includes up to 7 successive editions of discs as reissued every 3 to 4 months. Individual discs are $150. CENSUS OF TRANSPORTATION--GEOGRAPHIC AREA SERIES File Specifications CONTENTS General Data Specifications XVI-5 File Layout XVI-5 General Data Specifications Data Fields. All files are recorded in dBase III+ format. Numeric data fields contain no alphabetic information. A few fields (those in percentage form) have explicit decimals, unlike corresponding data on tape, which carry only implied decimals. On the other hand, many data items are scaled in thousands or millions, and this is noted only in the file layouts. Any data field which is subject to any special conditions (e.g., suppression to avoid disclosure, not applicable) is preceded by an information flag field which contains explanatory codes. Record Sequence and Geographic Coding. Records are arranged with like records together (e.g., State records, followed by MSA records.) Names for geographic variables are carried in files separate from the data files. Each is indexed, so that geographic names can be accessed in conjunction with the corresponding data values. See the Introduction to this CD-ROM for more information on geographic variables. Kind-of-Business Labels. Records in the TC87A1 and TC87A2 files are specific to a particular kind of business, as identified by the TRN87KB code. The term "kind of business" is used instead of "standard industrial classification" (SIC) because some kind-of-business categories represent either combinations or subdivisions of SIC categories. Titles for each kind of business are available in Appendix F, and also in the file TRN87KB.dbf on the CD-ROM. Kind-of-business titles can be linked to data files using the dBase SET RELATION command. Index Files. Each data file has one or more index files which can be used quickly jump to desired records (e.g., using the dBase FIND command) or to change the sequence of access. Available index files are listed in the abstract. Where noted in the abstract that an index is to the "first record for" a particular type of area, the index can be used during dBase FIND's, but the index must be shut off with SET INDEX TO in order to get access to records other than the first for each area. File Layout Most data items have an associated "flag" to describe any special conditions applicable. All flags other than `0' indicate that the data are not shown and the corresponding data fields contain zeroes. The codes are the same for all flags, but are listed in the record layout only for the first flag. In the geographic identification field in each file, NA fields contain either all zeroes or all 9's. See Geographic Code Structure. For those data fields in files TC87A2 that are always NA for certain types of records (as shown in the record layout), both the data field and the corresponding information flag contain zeroes. Census of Transportation, 1987 Geographic Area Series FILE 1 LAYOUT --------------------------------------------------------------------------- Location Record Type File Description --------------------------------------------------------------------------- Mnemonic Num of Selected Char US State MSA/ (Table (Table CMSA/PMSA 1) 1) (Table 5) --------------------------------------------------------------------------- ST 2 Data Data NA FIPS State Code MSA 4 NA NA Data MSA/CMSA Code(1) PMSA 4 NA NA Data/NA PMSA Code1 RECTYPE 2 01 02 04 Record Type Code TRN87KB 3 Data Data Data Kind-of-Business Code (Table Stub Line Number) ESTAB 6 Data Data Data Number of establishments, 1987 REVENUEF 1 Data Data Data Data Flag 0 No suppression 1 Data are withheld to avoid disclosing data for individual (D) 5 Data not applicable (X) REVEUE 9 NA Data NA Revenue ($1,000), 1987 PAYROLLF 1 Data Data Data Data Flag PAYROLL 8 Data Data Data Payroll entire year ($1,000), 1987 PAYRO1QF 1 Data Data Data Data Flag PAYRO1Q 7 Data Data Data Payroll first quarter ($1,000), 1987 EMPLOYEF 1 Data Data Data Data Flag EMPLOYE 7 NA Data Data Number of paid employees for pay period including March 12, 1987 SOLEPRO 5 Data NA NA Unincorporated business- Number of sole proprietorships, 1987 PARTSHP 4 Data Data Data Unincorporated business- Number of partnerships, 1987 Record size is 66 characters. Equivalent printed report tables are 1 and 5 in the geographic area series publication. January 5, 1990 (1)Areas not in MSA or PMSA have codes of `9999' Census of Transportation, 1987 Geographic Area Series FILE 2 LAYOUT --------------------------------------------------------------------------- Location Record Type File Description --------------------------------------------------------------------------- Mnemonic Num Tab2 Tab3 Tab4 of US,State US,State US, State Char Ratios Bridge SIC's, Tables that Changed 1972-87 --------------------------------------------------------------------------- ST 2 Data Data Data FIPS State Code RECTYPE 2 10 11 12 Record Type Code TRN87KB 3 Data Data Data Kind-of-Business Code (Table Stub Line Number e.g. 101=Total Taxable Transportation) ESTAB 6 Data Data Data Number of establishments, 1987 ESTAB82F 1 Data Data Data Data Flag 0 No suppression 1 Data are withheld to avoid disclosing data for individual companies (D) 5 Data not applicable (x) ESTAB82 6 NA Data NA Number of establishments, 1982 REVENUEF 1 Data Data Data Data Flag REVENUE 9 NA Data Data Revenue ($1,000), 1987 REV82F 1 Data Data Data Data Flag REV82 9 NA Data NA Revenue ($1,000), 1982 REVCHGF 1 Data Data Data Data Flag REVCHG 5 NA Data NA Revenue, percent change 1982-87 (1 implied decimal) PAYROLLF 1 Data Data Data Data Flag PAYROLL 8 NA Data Data Payroll entire year ($1,000), 1987 PAYRO82F 1 Data Data Data Data Flag PAYRO82 5 NA Data NA Payroll first quarter ($1,000), 1982 PAYROCHF 1 Data Data Data Data Flag PAYROCH 8 NA Data NA Payroll entire year, percent change, 1982-1987 (1 explicit decimal) PAYRO1QF 1 Data Data Data Data Flag PAYRO1Q 7 NA NA Data Payroll first quarter ($1,000), 1987 EMPLOYEF 1 Data Data Data Data Flag EMPLOYE 7 NA Data Data Number of paid employees for pay period including March 12, 1987 EMPLO82F 1 Data Data Data Data Flag EMPLO82 7 NA Data NA Number of paid employees for pay period including March 12, 1982 REVESTF 1 Data Data Data Data Flag REVEST 8 Data NA NA Revenue per establishment (In $), 1987 REVEMPF 1 Data Data Data Data Flag REVEMP 6 Data NA NA Revenue per employee (In $), 1987 PAYEMPF 1 Data Data Data Data Flag PAYEMP 6 Data NA NA Annual payroll per employee ($), 1987 EMPESTF 1 Data Data Data Data Flag EMPEST 4 Data NA NA Employees per establishment (whole number), 1987 Record size is 123 characters. Equivalent printed report tables are 2, 3, and 4 in the geographic area series publication. CENSUS OF TRANSPORTATION, 1987 on CD-ROM DATABASE STRUCTURE FILE 1 Selected Ratios and Comparative Statistics --------------------------------------------------------------------------- Field Field Field Deci- Name Type Size mal Field Description --------------------------------------------------------------------------- ST C 2 0 N FIPS State code RECTYPE C 2 0 N Record Type (01 = State table 2, 11 = table 3, 12 = table 4) TRN87KB C 3 0 N Transportation Kind-of-Business Code (001 = Total) ESTAB N 6 0 N Number of establishments, 1987 ESTAB82F N 1 0 N Flag for ESTAB82 (0 = data, 1 = withheld to avoid disclosure) ESTAB82 N 6 0 N Number of establishments, 1982 REVENUEF N 1 0 N Flag for revenue (0 = data, 1 = withheld to avoid disclosure) REVENUE N 9 0 N Sales ($1,000), 1987 (0 = data, 1 = withheld to avoid disclosure) REV82F N 1 0 N Flag for REV82 (0 = data, 1 = withheld to avoid disclosure) REV82 N 9 0 N Sales ($1,000), 1982 REVCHGF N 1 0 N Flag for REVCHG (0 = data, 1 = disclosure, 5 = not computed) REVCHG N 5 1 N Percent change in sales, 1982-1987 PAYROLLF N 1 0 N Flag for PAYROLL (0 = data, 1 = withheld to avoid disclosure) PAYROLL N 8 0 N Payroll entire year ($1,000), 1987 PAYRO82F N 1 0 N Flag for PAYRO82 (0 = data, 1 = withheld to avoid disclosure) PAYRO82 N 8 0 N Payroll entire year ($1,000), 1982 PAYROCHF N 1 0 N Flag for PAYROCH (0 = data, 1 = disclosure, 5 = not computed) PAYROCH N 5 1 N Percent change in payroll entire year, 1982- 1987 PAYRO1QF N 1 0 N Flag for PAYRO1Q (0 = data, 1 = withheld to avoid disclosure) PAYRO1Q N 7 0 N Payroll first quarter ($1,000), 1987 EMPLOYEF N 1 0 N Flag for EMPLOYE (0 = data, 1 = withheld to avoid disclosure EMPLOYE N 7 0 N Number of paid employees for pay period including Mar 12, 1987 EMPLO82F N 1 0 N Flag for EMPLO82 (0 = data, 1 = disclosure) EMPLO82 N 7 0 N Number of paid employees for pay period including Mar 12, 1982 REVESTF N 1 0 N Flag for REVEST (0 = data, 1 = disclosure) REVEST N 8 0 N Sales per establishment ($), 1987 REVEMPF N 1 0 N Flag for REVEMP (0 = data, 1 = disclosure) REVEMP N 6 0 N Sales per employee ($), 1987 PAYEMPF N 1 0 N Flag for PAYEMP (0 = data, 1 = disclosure) PAYEMP N 6 0 N Annual payroll per employee ($), 1987 EMPESTF N 1 0 N Flag for EMPEST (0 = data, 1 = disclosure) EMPEST N 4 0 N Employees per establishment, 1987 (whole number) ***Total*** 112 CENSUS OF TRANSPORTATION, 1987 on CD-ROM DATABASE STRUCTURE FILE 2 General Statistics -------------------------------------------------------------------------- Field Field Field Name Type Size Decimal Index Field Description --------------------------------------------------------------------------- ST C 2 0 N FIPS State code MSA C 4 0 N MSA or CMSA Code (9999 = not in MSA, 0000 in New England) PMSA C 4 0 N PMSA Code (9999 = not in PMSA) RECTYPE C 2 0 N Record Type (01 = U.S., 02 = State, 04 = MSA) TRN87KB C 3 0 N Transportation Kind-of-Business Code (001 = Total) ESTAB N 6 0 N Number of establishments, 1987 REVENUEF N 1 0 N Flag for revenue (0 = data, 1 = withheld to avoid disclosure) REVENUE N 9 0 N Revenue ($1,000), 1987 PAYROLLF N 1 0 N Flag for PAYROLL (0 = data, 1 = withheld to avoid disclosure) PAYROLL N 8 0 N Payroll entire year ($1,000) (0 = data, 1 = withheld to avoid disclosure PAYRO1QF N 1 0 N Flag for PAYRO1Q (0 = data, 1 = withheld to avoid disclosure) PAYRO1Q N 7 0 N Payroll first quarter ($1,000), 1987 EMPLOYEF N 1 0 N Flag for EMPLOYE (0 = data, 1 = withheld to avoid disclosure EMPLOYE N 7 0 N Number of employees during pay period including Mar 12, 1987 SOLEPRO N 5 0 N Unincorporated businesses: Number of sole proprietorships 87 ***Total*** 61 CENSUS OF TRANSPORATION--GEOGRAPHIC AREA SERIES User Notes This section will contain information relevant to the Census of Transportation on CD-ROM: 1987 Geographic Area Series that indicates specific problems with the data, or that becomes available after the file is released. The cover letter to the updated information should be filed behind this page. User Notes will be sent to all users who (1) purchased their file (or technical documentation) from Census Bureau and (2) returned the coupon following the title page.