REPUBLIC OF SLOVENIA MINISTRY FOR ENVIRONMENT AND SPATIAL

REPUBLIC OF SLOVENIA MINISTRY FOR ENVIRONMENT AND SPATIAL PLANNING ENVIRONMENTAL AGENCY OF RS Mario Zec, Ph. D. Office for environmental and nature protection Water emissions IS ARSO Mario Zec

Contents • • • Monitoring data and data from other legal procedures Data flows Water emissions IS and Databases Interfaces Data for public Future developments ARSO Mario Zec

Monitoring data Every Wastewater pollution source or municipal wastewater treatment plant have to provide yearly monitoring of emissions to water!! Limit values for yearly monitoring ? >50 PE OR >4000 m 3/year OR >emission limit value ARSO Mario Zec

Monitoring data Inspectors for environment EU Reporting Monitoring data Informations about Provisions Inspection Provisions OBLIGATIONS e fr o m r Fo Monitoring ……. measurements Parameters Limit values Report Auth o risat ion Decree on form of wastewater emission monitoring…. . . Regulation on the initial WHO measurements and operation HOW • frequency monitoring of waste water…. . • standards Decree on the emission of …. . substances in the discharge of • IPPC wastewater from…… Wastewater pollution sources or WWTP database EARS t por producing Authorised laboratories WWTP …. . Meat… Milk… …. 41 decrees PROCEDURES ARSO Mario Zec

Other procedures q Environmental taxation, q Water repayment, q Tax exemptions q Permitting q Authorization Act (electronic + print Data transfer and processing Form (electronic+ print) ARSO Mario Zec

Other procedures – Reporting Data in specified form Reporting tool (mdb) or QUERIES Water Emissions IS (mdb) ARSO Mario Zec

Data flows Forms Monitoring WWTP Smal WWTP Acts Industry Permit applic. (2) Tax declaration IS QUERIES Investments Auth. applic. LINKS ØTax declarations ØSmal wwtp ØPermits ØTaxation ØExemption ØAuthorisation ØPublic ØInspectors ØEARS ØWWW ØUWWD ØATLAS ØInner ØORACLE ARSO Mario Zec

SI WATER EMISSION IS Reporting, emissions and permitting IS (MS Access) Industry database Public services database Taxation (MS Access) WWTP database Lex and limit values database GIS database server (Oracle) ARSO Mario Zec

Databases characteristic Access 2002 q No outsourcing q Segmental development q Inner links(link table) q Outer ID tables (transferred into internal tables) q GIS (internally) q Interface “a la card” q ARSO Mario Zec

Databases From 2001 to 07 40235 basic records 44 tables 229 legal acts 3362 limit val. 12 tables From 00 to 07 996 facilities 2775 effluents 130000 measur. 76 tables LEX Industrial facilities From 2004 to 08 123 (wwtp) + 250 (IND) 20 tables Permits Taxation Public s. Exsemp. Pub. S. UWWTP Authorisation From 96 to 07 3961 investments 47 tables From 98 to 07 520 WWTP 1637 monitorings 26 tables From 97 to 07 210 authorisations 10 tables In total 235 tables, 5 databases, 4 basic interfaces ARSO Mario Zec

Interface – Industrial Facilities ARSO Mario Zec

Interface - WWTP ARSO Mario Zec

Interface – Public Services ARSO Mario Zec

Interface - Exemptions ARSO Mario Zec

Data for public q On request q Duplicates of Industrial facilities and WWTP databases q WWW “Onesnaževanje voda” (http: //okolje. arso. gov. si/onesnazevanje_voda) q ATLAS q “WEB-application” – in development ARSO Mario Zec

http: //okolje. arso. gov. si/onesnazevanje_voda ARSO Mario Zec

ATLAS OKOLJA: http: //gis. arso. gov. si/atlasokolja/ ARSO Mario Zec

Next steps? ! q Direct link to GIS server and transfer to outer GIS tables q Transfer of tables to Oracle q Web application for data access q Transfer to Access 2007 ARSO Mario Zec