Parcon Clearinghouse

Database Table Format

The following is the current structure of the database tables:

Generic Databases

 

 

Energy Production

Energy Import

Energy Demand

Air Quality Status

Air Quality Limits

Emissions Regulations

Study Group-Specific Databases

Research Projects

Compliance Stategies

Compliance Histories

Generic Databases

1. Energy Production (
   1. Country (California, Japan, Korea, and/or Taiwan)
   2. Year (1970, 1990, 2010)
   3. Coal (in Quadrillion Joules)
   4. Natural gas (in Quadrillion Joules)
   5. Crude Oil/Petroleum (in Quadrillion Joules)
   6. Nuclear (in Quadrillion Joules)
   7. Hydroelectric (in Quadrillion Joules)
   8. Solar (in Quadrillion Joules)
   9. Wind (in Quadrillion Joules)
   10. Other, including geothermal and waste (in Quadrillion Joules)
   11. Total (in Quadrillion Joules)
   12. Reference Source (report title and date)
   13. Time of Update (date of last revision of data)
   14. Graphic (if appropriate, a pie chart for each country can be imported)

top

1. Energy Import
   1. Country (California, Japan, Korea, and/or Taiwan)
   2. Year (1970, 1990, 2010)
   3. Coal (in Quadrillion Joules)
   4. Natural gas (in Quadrillion Joules)
   5. Crude Oil/Petroleum (in Quadrillion Joules)
   6. Nuclear (in Quadrillion Joules)
   7. Hydroelectric (in Quadrillion Joules)
   8. Solar (in Quadrillion Joules)
   9. Wind (in Quadrillion Joules)
   10. Other, including geothermal and waste (in Quadrillion Joules)
   11. Total (in Quadrillion Joules)
   12. Reference Source (report title and date)
   13. Time of Update (date of last revision of data)
   14. Graphic (if appropriate, a pie chart for each country can be imported)

top

1. Energy Demand
   1. Country (California, Japan, Korea, and/or Taiwan)
   2. Year (1970, 1990, 2010)
   3. Residential and Commercial (in Quadrillion Joules)
   4. Industrial (in Quadrillion Joules)
   5. Transportation (in Quadrillion Joules)
   6. Total (in Quadrillion Joules)
   7. Reference Source (report title and date)
   8. Time of Update (date of last revision of data)
   9. Graphic (if appropriate, a pie chart for each country can be imported)

top

1. Air Quality Status
   1. City, Country (Los Angeles, California; Tokyo, Japan; Seoul, Korea; Taipei, Taiwan)
   2. Year (1970, 1990, current)
   3. Ozone (days exceeded limit)
   4. NOx (days exceeded limit)
   5. CO (days exceeded limit)
   6. SOx (days exceeded limit)
   7. Particulate (days exceeded limit)
   8. Ozone (maximum level reached, ppm)
   9. NOx (maximum level reached, ppm)
   10. CO (maximum level reached, ppm)
   11. SOx (maximum level reached, ppm)
   12. Particulate (maximum level reached, ppm)
   13. Reference Source (report title and date)
   14. Time of Update (date of last revision of data)
   15. Graphic (if appropriate)

top

1. Air Quality Limits
   1. Country (California, Japan, Korea, and Taiwan)
   2. Year (1970, 1990, current)
   3. Ozone limit (in ppm or ppm/hr)
   4. NOx limit (in ppm or ppm/hr)
   5. CO limit (in ppm or ppm/hr)
   6. SOx limit (in ppm or ppm/hr)
   7. Particulate limit (in ppm or ppm/hr)
   8. Enforcement Agency (in ppm or ppm/hr)
   9. Reference Source (report title and date)
   10. Time of Update (date of last revision of data)
   11. Graphic (if appropriate)

top

1. Emissions Regulations
   1. City/Area, Country
   2. Species (NOx, CO, hydrocarbons, etc.)
   3. Application (electricity production, glass furnace, petroleum industry, etc.)
   4. Size/Power (in kW or MW)
   5. Limit (ppm, ppm/ton fuel, etc.)
   6. Effective date (date when rule takes/took effect)
   7. Enforcement Agency
   8. Reference Source (report title and date)
   9. Time of Update (date of last revision of data)
   10. Graphic (if appropriate)
   11. Notes (summary of the rule, etc.)
       
       

top

Study Group-Specific Databases

1. Research Projects
   1. Research Topic (one line description, e.g. low NOx burner)
   2. Country (California, Japan, Korea, and Taiwan)
   3. Organization (where the research is being conductesd)
   4. Principal Investigator(s)
   5. Application (Industrial, Utility, Commercial, Residential, Transportation, etc.)
   6. Contact (who to contact for more information)
   7. Abstract (summary of the research)
   8. Time of Update (date of last revision of data)

top

1. Compliance Stategies
   1. Country (California, Japan, Korea, and Taiwan)
   2. Species (NOx, CO, hydrocarons, etc.)
   3. Limit/Goal (this can be linked to the "Emissions Regulations" database table)
   4. Effective Date
   5. Technology (type of control strategy employed)
   6. Classification (current, advanced, conservation, renewable, etc.)
   7. Capital Cost (typical capital outlay for control strategy)
   8. Operational and Maintenance Costs (typical O&M costs for control strategy)
   9. Results (results or expected results of implementation; i.e. % NOx reduction)
   10. Reference Source (report title and date)
   11. Time of Update (date of last revision of data)
   12. Graphic (if appropriate)
   13. Notes
   
   
   
2. Compliance Histories
   1. Country (California, Japan, Korea, and Taiwan)
   2. Species (NOx, CO, hydrocarons, etc.)
   3. Implementation Date (date technology was installed and operational)
   4. Technology (type of control strategy used)
   5. Site (location of implementation)
   6. Capital Cost (typical capital outlay for control strategy)
   7. Operational and Maintenance Costs (typical O&M costs for control strategy)
   8. Results (savings in terms of dollars, reduced emissions, etc.)
   9. Reference Source (report title and date)
   10. Time of Update (date of last revision of data)
   11. Graphic (if appropriate)
   12. Notes

top

To request more information, send e-mail to info@parcon.uci.edu