Design and Implementation of a Database for the Estimation of Environmental Indicators in an Input - Output Framework with the Use of NAMEA Tables

Belegri-Roboli, Athena and Markaki, Maria and Michaelides, Panayotis G. and Milios, John G. and Papakyriakopoulos, Thymios and Tsolas, Ioannis (2006): Design and Implementation of a Database for the Estimation of Environmental Indicators in an Input - Output Framework with the Use of NAMEA Tables. Published in: WIT Transactions on Ecology and the Environment, Vol 98, © 2006 WIT Press , Vol. Vol 98, : pp. 329-336.

Abstract

The aim of the present paper is to design and implement a database for the estimation of environmental indicators by sector of economic activity at the macroeconomic level by means of input–output analysis with the use of NAMEA environmental tables. The database is programmed in VBA with the use of SQL queries and is implemented in a Microsoft Access environment through a friendly interface for inserting the data requested by the model (number of sectors, number of pollutants, etc). The computational results of the dataset of the relevant pollution coefficients (direct, indirect and total) by sector of economic activity are inserted in the database for further elaboration. Through the creation of the database we can pinpoint the sectors and the pollutants that cause the largest environmental load and compare the results with the corresponding databases of other countries.

• Item Type: MPRA Paper
• Language: English
• Keywords: database, VBA, SQL, environmental input–output, NAMEA.
• Subjects: C - Mathematical and Quantitative Methods > C6 - Mathematical Methods ; Programming Models ; Mathematical and Simulation Modeling > C61 - Optimization Techniques ; Programming Models ; Dynamic Analysis; C - Mathematical and Quantitative Methods > C6 - Mathematical Methods ; Programming Models ; Mathematical and Simulation Modeling > C63 - Computational Techniques ; Simulation Modeling; C - Mathematical and Quantitative Methods > C6 - Mathematical Methods ; Programming Models ; Mathematical and Simulation Modeling > C67 - Input-Output Models; C - Mathematical and Quantitative Methods > C8 - Data Collection and Data Estimation Methodology ; Computer Programs

References

[1] Mylonas, N. Economakou, M. Frankopoulos, N. Krasadakis, A. Molfetas, K. Stromplos, N. & P.Vlachos, Natural Resource and Environmental Input-Output Tables for Greece, 1988-98, Eurostat and Institute of Computer and Communications Systems (ICCS), National Technical University of Athens, 2000.

[2] Wier, M., Sources of Changes in Emissions from Energy, Economic Systems Research, 10, pp.99-112, 1998.

[3] Ostblom, G., The environmental outcome of emissions-intensive economic growth: a critical look at official growth projections of Sweden up to year 2000, Economic System Research, 10, pp. 19-29,1998.

[4] Wilting, H.C., W. Biesiot, & H.C. Moll, Analyzing Potentials for Reducing the Energy Requirements of Households in the Netherlands, Economic Systems Research, 11, p. 233-243, 1999.

[5] Cadarso, A. & Fernandez-Bolanos A.F., Patterns of growth and consumption and their influence on the environmental in Spain, Fourteenth International Conference on Input- Output Techniques, 2002.

[6] Braibant, M., Environmental Accounts in France: NAMEA pilot study for France, Fourteenth International Conference on Input- Output Techniques, 2002.

[7] De Haan, M. & Kee, P., Accounting for Sustainable Development: The Namea-Based Approach, Statistics Netherlands, 2004.

[8] OECD, Indicators to measure decoupling of environmental pressure from economic growth, OECD SG/SD (2002) 1/FINAL, 2002.

[9] United Nations, European Commission, International Monetary Fund, Organisation for Economic Co-operation and Development, World Bank: Integrated Environmental and Economic Accounting, 2003.

[10] Belegri-Roboli, A., Markaki, M. & Michaelides, P., Environmental Emissions and the Role of Technological Change by Sector of Economic Activity in Greece: An Input-Output Analysis (1988-1998), IASME Transactions, Issue 3, Vol 2, May, pp. 371-375, 2005.

[11] Belegri-Roboli, A. and. Tsolas, I., Estimation of Intensity Coefficients of Total Emission in Greece (1988-96): An Environmental Input-Output Analysis, Proceedings of the 9th International Conference on Environmental Science and Technology, Rhodes Island, Greece, September 1-3, 2005.

[12] Roman, S., Access Database Design & Programming, Second Edition, O’Reily, Sebastopol, 1999.

[13] Andersen, V., How to Do Everything with Microsoft Office Access 2003, McGraw-Hill/Osborne, 2003.

[14] Viescas, J., Microsoft Office Access 2003 Inside Out, Microsoft Press, Redmond, 2004.

[15] King, K., SQL Tips and Techniques, Premier Press Inc, 2002