Title: CSV and Excel file formats for eSPIRS(*) updating. Technical document for the management of the data to be imported in the Seveso establishment data base [(*)Seveso Plants Information Retrieval System]
Editors: WOOD Maureen
Publisher: Publications Office of the European Union
Publication Year: 2014
JRC N°: JRC93184
ISBN: 978-92-79-44803-4 (print)
978-92-79-44802-7 (pdf)
ISSN: 1018-5593 (print)
1831-9424 (online)
Other Identifiers: EUR 27047
OP LB-NA-27047-EN-C (print)
OP LB-NA-27047-EN-N (online)
URI: http://publications.jrc.ec.europa.eu/repository/handle/JRC93184
DOI: 10.2788/338215
Type: EUR - Scientific and Technical Research Reports
Abstract: The European Union hosts approximately 11.000 establishments, that are considered major hazards by virtue of the dangerous substances present on the site in excess of the threshold quantity limits established by the Seveso Directive (Directive 2003/105/EC and amendments). Each Member State of the EU is committed to communicating to the European Commission an inventory of Seveso establishments located in their country. According to the Directive, the European Commission is obligated maintain a database containing the information on all Seveso establishments. Since 2001, an ad-hoc geographical information retrieval system (SPIRS – Seveso Plant Information Retrieval System) has been developed for this purpose by the JRC’s Major Accident Hazards Bureau (MAHB. Since reporting became mandatory in 2005, the EU Member States, together with Iceland, Norway, and Switzerland on a voluntary base, are contributing these data to SPIRS with regular updates. Normally the updating should be performed by transmitting files in the SPIRS unique file format. HistoricallyMember States also have had the possibility to provide the data by means of a conventional CSV file, derived eventually from spreadsheets (e.g. Excel), if properly formatted, under a well-defined set of rules. The aim of this technical document is to draw attention on the formats that should be used for such purposes and document good practice for using a CSV file to update SPIRS data. Presently, a new web-based information system (eSPIRS) for the management of the Seveso establishment is under development in line with the new Seveso III Directive and will soon replace the desktop version of SPIRS. Hence, the purpose of this document is to provide a frame and format of the information actually present in SPIRS and that will be transferred to the new eSPIRS. Furthermore, this document can be used as a basis for formatting the XML data interchange protocol for uploading the national Seveso data to eSPIRS.
JRC Directorate:Space, Security and Migration

Files in This Item:
File Description SizeFormat 
lbna27047enn.pdf1.24 MBAdobe PDFView/Open

Items in repository are protected by copyright, with all rights reserved, unless otherwise indicated.