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
- Slides: 18