Data handling and validation from Wisconsin's remote vehicle emissions sensing studies

Craig S. Rendahl

doi:10.1117/12.210828

31 May 1995 Data handling and validation from Wisconsin's remote vehicle emissions sensing studies

Craig S. Rendahl

Proceedings Volume 2365, Optical Sensing for Environmental and Process Monitoring; (1995) https://doi.org/10.1117/12.210828
Event: Optical Sensing for Environmental and Process Monitoring, 1994, McLean, VA, United States

Abstract

The Wisconsin Department of Natural Resources and Department of Transportation (WDOT) are conducting a joint study to determine the effectiveness of applying optical sensing techniques to vehicular emission monitoring. Two field studies using Remote Sensing Technologies, Inc. remote sensing equipment was conducted in 1993 and 1994. This paper describes the data handling and data validation activities of these studies, including identification of data elements. Data handling was performed by the same people who conducted the 180,000 vehicle emissions tests. A contemporary commercial spreadsheet from Borland International, Inc. was used to import the raw data from the remote sensor. The data was reviewed with the spreadsheet then moved into a Borland relational database product. The relational database permitted structured queries against databases of vehicle inspection/maintenance (I/M) data from WDOT, National Insurance Crime Bureau, and EnviroTest. We determined effective cut points for vehicles of different ages which delineated high-polluting vehicles (gross emitters) from vehicles in compliance. The I/M data was also used to intercompare the remote sensing results with traditional testing results. Remote sensing test results were then compared for errors of commission and omission with respect to I/M test. Ultimately, this remote sensing database technique could serve as a means for identifying gross emitters who would be required to visit an I/M facility for an out-of-cycle emissions test.

Citation Download Citation

Craig S. Rendahl "Data handling and validation from Wisconsin's remote vehicle emissions sensing studies", Proc. SPIE 2365, Optical Sensing for Environmental and Process Monitoring, (31 May 1995); https://doi.org/10.1117/12.210828

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available