Highway Safety Information System Guidebook for the California State Data Files. Volume I: SAS File Formats

Details

• Creators:
  Council, Forrest M. ; Williams, Carolyn D. ; Chen, Li Wan ; Mohamedshah, Yusuf M.
• Corporate Contributors:
  United States. Federal Highway Administration
• Subject/TRT Terms:
  Accident Data California Crash Data Data Files File Formats Interchanges Intersections Inventory Roads Safety Traffic Accidents

  More +
• Publication/ Report Number:
  FHWA-RD-00-137
• Resource Type:
  Tech Report
• Geographical Coverage:
  California
• Edition:
  4th ed.
• Corporate Publisher:
  University of North Carolina, Chapel Hill
• Abstract:
  The California database incorporated in the Highway Safety Information System (HSIS) is derived from the California TASAS (Traffic Accident Surveillance and Analysis System). The system, maintained by the Traffic Operations Office of Caltrans, is a mainframe-based system based on COBOL programming. The Traffic Operations Office provides the data to HSIS in the form of two different data files. These contain (1) accident data and (2) roadway inventory data. Beginning in 1994, the HSIS was converted to a relational database for internal use. This database, using a SYBASE system, stores the data received from California and other States, and the data files for a given State are linked and manipulated using SQL language. However, this conversion from the original SAS-based system to the newer relational system is somewhat transparent to the end-user of the data since the output files produced by SYBASE for modeling and analysis will be SAS formatted. SAS format libraries are produced for each of the variables in each of the files. This Guidebook concerns these SAS files - their formats, completeness, and quality. This report, Volume I: SAS File Formats, contains the following: Introduction; Details of Major Files; California Contacts; Composite List of Variables; Accident Files; Roadlog File; Intersection File; and Interchange Ramp File. The Single Variable Tabulations are found in Volume II of this report.
• Format:
  PDF
• Collection(s):
  Federal Highway Administration
• Main Document Checksum:
  urn:sha-512:8863f1a4a5ad0497dccaa13e2e120a7214b2614473c5718c18ec33e0e6d8e3972ebb5ec015fd9936db4ea94f4f4aef780427c116eedcef8a66c7618ca751b115
• Download URL:
  https://rosap.ntl.bts.gov/view/dot/4825/dot_4825_DS1.pdf
• File Type:
  [PDF - 5.85 MB ]