Ceidars

1
Ceidars

• Thoan Christopher Nguyen, P.E.
• Emission Inventory Workshop
• Air Resources Board
• March 13, 2006

2
Overview

• Database Structure
• Data Dictionary
• Transaction Format

3
Database Structure
4
Main Tables

• Facility
• Stack
• Device
• Process
• Emission
• Excess

5
Utility Tables

• COABDIS
• SIC/NAICS
• SCC
• Category/EIC
• Pollutant

6
Summary

• CEIDARS Structure
• Relational Database
• Tables
• Key Fields
• Relationship Between Tables
• Main Tables
• Utility Tables

7
Data Dictionary - Introduction

• Dictionary of Tables and Fields
• Data Elements

8
Data Dictionary Step 1
9
Data Dictionary Step 2
10
Data Dictionary Step 3
11
Data Dictionary Step 4
12
Summary

• Ceidars Tables and Fields
• Descriptions of Fields
• How Tables are Related

13
Transaction Format What is it?

• Specified Format File
• Comma Delimited Format
• Types of transactions
• Positions of Fields
• Types
• Maximum Widths and Decimal Places
• Instructions

14
Transaction Format - Link

• http//www.arb.ca.gov/app/emsinv/dist/doc/transfmt
  .pdf

15
Example

• FAC Transaction
• STK Transaction
• DEV Transaction
• PRO transaction
• EMS transaction
• EXCESS transaction

16
Example
17
Conclusions

• Database Structure
• Relational Database
• Data Dictionary
• Descriptions of Tables and Fields
• Transaction Format
• Transferring Data