ESMIRNA (National Mining Referral Statistics in Spain)

Acronym of the case:

ESMIRNA

Web address of the case:

http://www.mityc.es/energia/mineria/Estadisti...

Country of the case:

Spain

City/region:

Spain

Posting Date:

16 March 2010

Last Edited Date:

29 March 2010

Author:

Pablo Burgos Casado (MITYC)

eprocurement | eServices for Business | employment

Type of initiative

Project or service
Strategic initiative

Case Abstract

The Mining Statistics of Spain, traditionally made by the Ministry of Industry, is the most comprehensive information on production in the extractive sector in Spain.Â The requirement of completion of national statistics is governed by the provisions of Law 12/1989 on the Civil Service Statistics, Statistics Mining being in Spain one of the statistics in the National Statistical Plan and its annual programs.

This application wa developped in order to process all information from all extractive companies in Spain and build a complete statistics report of all its aspects: production, quantities and values of extraction yield, sectorization, distribution and investments in the sector, employment, accident rates risk, etc.

The Ministry of Industry, Tourism and Trade has a downloadable application tailored to the skills needed for the completion of annual mining statistics according to the questionnaire approved for each year. This downloadable program allows users to complete the questionnaires directly within the application by sending the web form with the possibility of using certificate or by loging in directly without a certificate, with username and password if they are already registered. These procedure facilitates the reception of statistical information in telematic way in accordance with the contents of the Ministerial Order ITC/105/2007. The data is sent using the updated statistical program for the year and requested to be downloaded from the website of the Ministry.

The downloadable application is available from the ministry's Website http://www.mityc.es/energia/mineria/Estadistica/Paginas/FormulariosEstad.aspx Â called Esmina.

Description of the case

Domain

eGovernment

Topic

Sector

Employment | Local/Regional Community Development | Procurement

Start date - End date

January 2008 (Ongoing)

Date operational

May 2009

Target Users

Business (industry) | Citizen

Target Users Description

Companies, workers, citizens and other operators can consult the details of the mining sector, once identified and described the data, the various mining operations that you wish to publish and not subject to statistical confidentiality. It is the Â responsibility of the Ministry of IndustryÂ publish the data of the mining sector in Spain:

http://www.mityc.es/energia/mineria/Estadistica/Paginas/Consulta.aspx .

The annual and monthly Mining statistics of Spain, include the following:

National Mining Production.
Consolidated Summary of Production.
Mineral Extraction.
Summary by Autonomous Communities.
Performance of Coal Mine.
Sectorized supplies.
Employment by Autonomous Communities, provinces and Substance.
Distribution and Investment of production by CCAA, Provinces and Substance.
Fundamental data by size and type of mineral exploitation.

Scope

National

Status

Operation

Language(s)

Spanish

Policy Context and Legal Framework

The requirement of completion of national statistics is governed by the provisions of Law 12/1989 on the Civil Service Statistics, Statistics Mining being in Spain one of the statistics in the National Statistical Plan and its annual programs.

This application is to process all information from all extractive companies in Spain and build a complete statistics report of all its aspects: production, quantities and values of extraction yield, sectorization, distribution and investments in the sector, employment, accident rates risk, etc.

Project Size and Implementation

Type of initiative

IT infrastructures and products

Overall Implementation approach

Partnerships between administration and/or private sector and/or non-profit sector

Technology choice

Proprietary technology | Standards-based technology

Funding source

Public funding national

Project size

Implementation: €49-299,000

Yearly cost:

€49-299,000

Implementation and Management Approach

The Ministry of Industry, Tourism and Trade has a downloadable application tailored to the skills needed for the completion of annual mining statistics according to the questionnaire approved for each year. This downloadable program allows users to complete the questionnaires directly to the application by sending it telematically with the possibility of using certificate or by doing so without it if already registered, thereby facilitating the reception of statistical information economically by this Ministry in accordance with the contents of the Ministerial Order ITC/105/2007. The data is sent using the updated statistical program for the year and requested to be downloaded from the website of the Ministry.

The downloadable application is available from the ministry's Web http://www.mityc.es/energia/mineria/Estadistica/Paginas/FormulariosEstad.aspx
called Esmina.

Technology solution

For annual mining statistics:

The database is Oracle.
There are stored procedures, tables and views, to display statistical information on the different tables.
The information received and recorded in the database is available through by Discoverer managers.
It uses XML, Visual Basic 6.0, procedures and tools PLSQL Oracle Developer Suite (Designer, Forms Developer, Reports Developer).

The monthly questionnaire completion was constructed using an engine of dynamic generation of screens, using XML, making it easier to create new forms with many similar characteristics and validation data standard.

The database is Oracle.
Oracle 10g has been used in order to store and process Monthly Mining data.
The technology used to create the user interface has been ASP. NET 2005, both C# and Visual Basic. NET Framework 2.0.
The Web server is an Internet Information Server.
Also special modules are used to generate PDF files, based on dynamic generation of forms.
The data processing was carried out with Oracle.

Impact, innovation and results

Impact

The Mining Statistics of Spain, traditionally made by the Ministry of Industry, is the most comprehensive information on production in the extractive sector in Spain.Â The requirement of completion of national statistics is governed by the provisions of Law 12/1989 on the Civil Service Statistics, Statistics Mining being in Spain one of the statistics reports in the National Statistical Plan and its annual programs.

This application has been developed in order to process all information from all extractive companies in Spain and build a complete statistics reports of all its aspects: production, quantities and values of extraction yield, sectorization, distribution and investments in the sector, employment, accident rates risk, and so on.

Track record of sharing

More than 6 500 users send each year information to create the statistical information about mining sector in Spain.

Today, according to the latest statistics of mining production for commercial mining sectors, , production amounted to about â‚¬4 359 M, representing an increase of just over 9% compared to â‚¬ 3 985M last year.

The extractive industries are described as follows:

Energy products: They include anthracite, coal, sub-bituminous coals, lignite, crude petroleum and natural gas.
Metal Minerals: These include bullion, copper concentrate, nickel-copper concentrate, nickel and tin ore.
Industrial Minerals: Include a variety of minerals, sepiolite, glauberite, sea salt, washed kaolin, rock salt, quartz, feldspar and bentonite.
Ornamental rocks: Alabaster, diorite and sandstone, limestone, quartzite, diorite, granite, marble and ornamental slate.
Quarry products, including limestone, sand and gravel, granite, clay, dolomite, gypsum, silica sand, quartzite not ornamental, Ophites and marl.

It is also important to note the information regarding the employment generated by companies in individual farms that may have, whether the company itself or by contract, as well as accident data and risk indices.

Sectors	Number of Employees
Sectors	External	Owns
Energyl Products	2 694 (20)	7 938 (364)
Metal minerals	11 (0)	334 (57)
Industrial Minerals	791 (16)	3 561 (224)
Ornamental Rocks	625 (30)	9 014 (850)
Quarry products	2 856 (64)	16 145 (882)
Total	6 977 (130)	36 992 (2.377)

Lessons learnt

The general trend of the Spanish mining sector is a slight increase in the amount ofÂ material, and in the number of farms and jobs.

In the 4 291 existing businesses, there are between 43 968 jobs that include indoor and outdoor staff, graduates and administrative cadres. More than 2 500 jobs are covered by women.

An increase of more than 1 000 jobs over the previous statistical year has taken place.

Another important factor is the mining statistics of accidents and the risk ratings, which can bring about stricter control of accidents Â in the mining sectors.

Multimedia Content Select a Tab

There isn't any image for this case

There isn't any Video for this case

Showing 3 comments

Anka Onka

Interesting.

26 March 2010 | 2648 Visits | Rating: 1 (maximum:5)

Very interesting project.

Ersin Bicer

Interesting Project

24 March 2010 | 2768 Visits | Rating: 4 (maximum:5)

At first glance I thought it as a data mining project, Â but when I read the details I understand the project. Since I am a statistician, I know that collecting the correct data is very essential.