TEI Managed Louisiana’s Data for the Largest Oil Spill in American History
Reduce paper and manual processing
Improve staff efficiency by streamlining operations
Increase transparency through public awareness website
Created an informational asset for Deepwater Horizon scientific data
Provides data validation and verification
Facilitates collaboration and coordination between environmental protection agencies
Stores terabytes of litigation sensitive data
Summary of Work
Soon after the Deepwater Horizon oil spill in May 2010, TEI contracted with Coastal Protection and Restoration Authority (CPRA) to develop work plan tracking and data management systems to collect, organize and archive scientific data needed to make an accurate damage assessment and begin the restoration planning and implementation process. TEI analysts and software developers implemented an approach to meeting the requirements of the public, scientists, and attorneys. The public site needed graphic designers and requirements analysts to design an easy-to-use web interface to keep the general public informed. The LOSDMS system required a software/database architect, software engineers and data management specialists to create data collection protocols, database schemas, GIS interface and other functionalities needed to manage the Natural Resource Damage Assessment (NRDA) process.
In 2015, once the chaos of the spill was over, TEI contracted with Louisiana Oil Spill Coordinator’s Office (LOSCO) to continue the maintenance of the Deepwater Horizon public system. TEI is utilizing the knowledge and technologies from the Deepwater Horizon spill to create a collective oil spill tracking system to manage all spills through the Natural Resource Damage Assessment (NRDA) process.
Content Managed Deepwater Horizon Public System
Transparency to the public for Deepwater Horizon Oil Spill Natural Resource Damage Assessment is essential. Therefore, TEI developed and deployed the Deepwater Horizon Public Website (http://la-dwh.com). This website is the designated platform that allows CPRA and LOSCO staff the ability to release Louisiana NRDA Workplans, NRDA data, Administrative Record Documents, News & Media, and Restoration Project information. The site also affords the public a place to suggest restoration projects to be considered for this spill and gives trustees the capability to release proposed restoration projects back to the public through interactive ESRI maps and filtered lists. Restoration for this spill will continue for years, and this spill is a major historical event. This content management system allows CPRA to release this information quickly and fulfill the overwhelming public records requests.
NRDA Workplan Component
NRDA Data Search Component
News & Media Component
Configurable code tables
Customized Security Component
Image Slider Management
Restoration Project Component
Restoration Project Online Submittal Form
Restoration Plan Component
Restoration Plan Online Comment Form
Deepwater Horizon Oil Spill Management System
A work plan tracking system, a data repository for all scientific data, and a sample tracking system to manage analytical samples collected during the Deepwater Horizon spill are components of the Louisiana Oil Spill Management System (LOSDMS). The data repository archives tens of thousands of documents, videos, photos, digital sound recordings and other data needed by scientists to document and assess the extent of damage to Louisiana’s marshes and coastline. In 2010, TEI developed the work plan tracker component in LOSDMS to address the immediate need for accurate tracking of work plans from the federal and state agencies. The work plan tracker system established an identification number for all work plans and streamlined the approval process among the various Louisiana agencies, Federal agencies, and BP. After the implementation of the work plan tracker, TEI focused on categorizing the hundreds of data sources for this spill. Additionally, TEI developed data intake interfaces with the various state and federal environmental agencies to collect continuously and process the datasets into a relational database structure. This system heavily aided Louisiana trustees in its decision making during the pre-assessment and injury assessment phases of the largest oil spill in American history.
Data Repository Management System
Customized Security Component
Integrated file transfer solution
Robust reporting capabilities
ESRI ArcGIS Mapping Component
Extensible Framework for Integrating Other Management Systems
Louisiana Sample System
Configurable code tables
Louisiana Oil Spill Management System
The Louisiana Oil Spill Management System (LOSMS) operationalizes portions of the Louisiana Oil Spill Coordinators Office’s activities associated with Spill Response, Natural Resource Damage Assessment, and Restoration for past, present, and future oil spills. The LOSMS management portal allows Louisiana State Trustees the ability to enter tracking information, activities, milestones, documents, injury, and negotiations associated with Spill Response, NRDA, and Restoration. The LOSMS management portal also provides the ability to build administrative records and publish various data elements to the public portal. The LOSMS public portal (https://data.losco.org/) facilitates the ability to search and view publicly available Spill Response, Natural Resource Damage Assessment, and Restoration data.