Los Angeles World Airports (LAWA) is required to regulate and monitor the use of products that contain Volatile Organic Compounds (VOC) on a daily basis for each of its three airports. The company was tracking products containing VOCs in an Access database, which did not have some reporting functionality such as roll-up calculations.
LAWA transitioned its existing Access database for the Ontario Airport into the Enviance System, which has ensured database consistency and enabled a product type database. In addition, roll-up calculations ensure that LAWA is within its limits on certain products and changes to regulatory limits are easier to manage.
Los Angeles World Airports (LAWA) consists of four facilities: Los Angeles International Airport (LAX), the departure point for more trips than any other airport in the world, LA/Ontario International Airport, Van Nuys Municipal Airport and Palmdale Airport, which is closed but used by several lease tenants and major movie studios.
LAWA airports reside in the South Coast Air Quality Management District (SCAQMD), which has more than 15 million people living in the region. Although air quality has improved over the last decade, the region still has the dirtiest air in the nation. As a result, regional air quality regulations are stringent, and qualifying businesses – such as LAWA –need to track daily use of products that contain Volatile Organic Compounds (VOCs). For LAWA, this means listing the more than 600 products used in its construction and maintenance shops, including architectural coatings, solvents in degreasers and other cleaning activities, metal parts and product coatings, wood products coatings, adhesives and sealants, and polyester resin operations, and determining whether they are subject to the VOC Program.
LAWA previously tracked products containing VOCs in an Access database, which was only partially functional. The database kept track of products and usage could be logged, but some reporting functions – such as roll-up calculations – didn’t work. In addition, the creator of the database no longer worked at the consulting company, which employed no one who knew how to fix it.
After selecting the Enviance System, LAWA began a pilot study at the Ontario Airport in early 2011 to track the use of products through Enviance. The pilot included 12 different construction and maintenance shops, 13 different applicable AQMD rules, approximately 180 categories and VOC limits in those 13 different rules, and 600+ products evaluated for use.
A Custom Field Template is applied to each product, which contains numerous static and dropdown fields to specify the SCAQMD rule [LAWA has approximately 10 different rules they can fall into], the specific rule category and the specifics of the product from its MSDS sheet (VOC g/l, specific gravity, MSDS date), and whether recordkeeping is required.
As a result of the successful pilot, construction supervisors at the Ontario pilot site are entering data into Enviance. In addition, roll-up calculations are working to ensure LAWA is within its limits on certain products. LAWA’s Enviance database is consistent and changes to regulatory limits are easier to manage. With AQMD inspectors auditing each LAWA airport every year, having an accurate database is essential to ensure compliance. Additionally, LAWA can now maintain a product type database within the Enviance System, and can easily copy product profiles to create new ones.
Benefits LAWA has experienced since implementing the Enviance System include:
- Greater accountability – Enviance requires users to log in, which means that data is tracked, making it easier for supervisors to monitor data.
- Data consistency – Drop-down menu selections and link- listed options reduce operator entry error and improve data consistency.
- Functioning roll-up calculations
- Ability to generate reports
- Product type database
LAWA will be migrating both its LAX Airport and Van Nuys Airport VOC databases from Access into Enviance.