National Urban Waste Water Study Volume 2, Part B NATIONAL
Contents
1. To open the database navigate in Windows Explorer to the NUWWS directory and double click on the Nuwwscollect mde file This will launch the NUWWS project into Microsoft Access 2000 The front screen of the collection database is as shown in Figure 4 below DEPARTMENT GF THE DAS OMIM DNT EBD LOCAL GOWVVtRNNHENT Department of the Environment and Local Government National Urban Waste Water Study ADD Catchment to Questionnaire UPDATE UPDATE Treatment Plant Receiving Waters Questionaire Questionaire Dewi e E Babtie Figure 4 Data collection database front screen A schematic diagram of the forms in the database is shown in Figure 5 Note that these are not actual forms but just a simplified representation of how the forms interact with each other The data is organised into three sections each based on one of three primary data sets These are Sewerage Network Treatment Plants Flow Load and Treatment Process and Receiving Waters 4 2 ACCESSING THE DATA The four buttons on the above screen commence with the words ADD or UPDATE as the initial function of the database was data capture The ADD Catchment to Questionnaire button is not required for data access purposes whilst the UPDATE buttons can equally be considered as points of entry to the above three datasets Proceeding from the point of entry the process of locating data is fairly self explanatory Guidance on the use of tabs dropdown boxes e2. Note that only catchments already listed in the database will appear here Data can then be entered in the appropriate fields on the different tab sheets Any previously entered data will be shown and can be viewed or amended as needed If a page contains too many tabs to show across the screen you should use the two navigation arrows to bring other tabs into view Additionally if multiple records can be entered on a particular page navigation buttons will be visible at the base of the sheet Both of these are visible in Figure 20 below x Catchment nnis North Catchment Reference PUE 0301 0010 Altemative Name Mantes btn County Las Ennis South 11 m Authority Ennis UDC GIS Form Exit Ennistumon 12 3 Asset Inventory 4 Operational Control 5 Existing Surveys B Adeq 4 H Easting Contacts Data Kilrush 14 Lahinch Contact Lisdoonvarna Mewrmaket an Ferqus Address PO Contact Name Contact Position Tr Contact Type FO Mobile Email Record 14 4 i n ed o bes Figure 20 NUWWS Catchment Details form Doc Nr A7090 N R 110 15 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 6 3 RS GIS Cross Reference Internal Reference for catchment 13 13 13 13 13 13 Future Development Boundary 100 100 Existing Development Boundary 101 101 Treatment works 1
3. This database holds all the raw data in tables Nuwwsdata mdb LINKED User Front End database TABLES Back End database to hold which contains forms and queries to access the data all raw data in tables Figure 3 Database overview Doc Nr A7090 N R 110 5 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 3 2 GEOGRAPHIC INFORMATION SYSTEM During the data collection phase of this project spatial data was digitised to compliment the questionnaire information The following datasets were captured in MapInfo format e Catchment Boundary e Current Development e Future Development e Trunk Sewer and Key Features e Network System e Location of flooding blockages etc e Existing Surveys e Adequacy of existing systems For each of the catchments a metadata record was captured in a separate dataset e Metadata tab A tool has been created for Maplnfo that will enable the User to choose a catchment from a list and zoom to it directly The MapInfo workspace is set to link the tables to the Map files in Maplnfo using ODBC technology Doc Nr A7090 N R 110 6 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 4 0 ACCESSING THE DATABASE 4 1 STARTING UP THE NUWWS DATABASE The NUWWS directory is located on the local drive of the user s PC e CANUWWS
4. 3 25 Optional tdD Slieels ee deele eet 19 26 Update Receiving Waters button ccc cccccceccceeceeeeeceeeeeseeeceeeesaeesaeeeeseuseensensaes 19 2f NUWWS Receiving Waters form cccccccceccceeceseeeceeeeeseeeseeceeseesseeeeseessenseeaaes 20 28 Ada RECEIVING N AETS EE 20 29 Navigation button detail Discharges ob 21 30 Scrollbar and navigation detail Discharges Lab 22 Doc Nr A7090 N R 110 iii of iii Department of the Environment Heritage and Local Government Database amp GIS 1 2 National Urban Waste Water Study Version 1 4 3 1 0 INTRODUCTION 1 1 THE STUDY A primary objective of the National Urban Waste Water Study NUWWS as stated in the brief was to collate capture in electronic form and analyse all available information relevant to this project in respect of each scheme The records are to be entered into a national database and GIS and the geographic outline of the systems will be mapped Details of waste water networks treatment plants and receiving waters were collated in mid 2002 using a standard questionnaire The data was used to populate a national database and geographic information system developed as part of the NUWWS From the above information the condition and performance of the waste water collection treatment and sludge disposal facilities was assessed Waste water scheme deficiencies including data deficiencies were subsequently identified along with the need fo
5. Enter a unique value for the GIS Sub Reference between 1000 and 1029 For this catchment Check used BIE Fam values by looking at the GIS Farm Remember to add any new Sub References to the GIS form GIS Sub Reference Name of Treatment Plant Easting Marthing Directions to Plant Undo Record Finished Record 14 4 lk ei oF 1 Figure 24 Add Treatment Works form Make sure you select the catchment that contains the treatment works you wish to add then enter the details for each treatment works you wish to add Each works must be assigned an appropriate GIS subreference and there is a facility on this screen to show the GIS Cross Reference form to aid this See section 6 3 Other details of the works such as name grid reference and directions should also be added here Once the treatment works has been added to the catchment click the Finished button to return to the questionnaire and select the treatment works from the drop down list NB This part of the questionnaire contains a number of subsections for treatments for which no data may be available For this reason a number of tab sheets are initially hidden from the user These hidden sheets are accessed via a group of tick boxes identified by blue labels on sheet 2 2 General Site Information as shown in Figure 25 In turn some of these provide access to further sheets again using tick boxes clearly identified with blue labels When all available dat
6. Reference l Main Uutta for outfall Easting Northing Type of Outfall Length ml tick one only 1060 112476 188523 concrete pipe 4 al 1061 122086 188431 E E 0 Po B Where outtall information i requested in further questions it will refer to the main ou all unless stated otherwise Record 14 4 i r r of 3 Figure 27 NUWWS Receiving Waters form The Add Receiving Waters form shown in Figure 28 is accessed from the receiving waters questionnaire using the button at the top of the screen x National Urban Waste Water Study Select the Catchment name and Treatment Plant from the pull down lists Catchment name Galway City z Treatment Plant Mutton Island Sewage Treatment Plant E Update or enter the following details for each Receiving Water for this Treatment Plant Enter a unique value for the GIS Sub Reference between 1030 and 1053 for this catchment Check used SIE values by looking at the GIS Farm Remember to add any new Sub References to the GIS form GIS Sub Reference Mame of Recenving Water Undo Record Finished Record I4 4 ral ei of 2 Figure 28 Add Receiving Waters To add a receiving water firstly a catchment should be selected followed by a treatment works The receiving water must be assigned a GIS subreference in an Doc Nr A7090 N R 110 20 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Wat
7. Reliable and up to date information was assigned a Source Code of 1 whilst information which was considered a best estimates without any supporting hard copy data was assigned Source Code 5 In some cases the terms M for measured and E for Estimate were used in the questionnaires and subsequently translated as M Source Code 3 and E Source Code 5 Once it had been developed the database was populated with information provided by the local authorities in the completed questionnaires without adjustment for omissions or inaccuracies However the source and therefore the confidence which could be placed in each item of data was recorded Prior to carrying out detailed assessment of each catchments the quality of data was reviewed and adjusted as appropriate It should be noted that for the purpose of the sewerage catchment reports the term Confidence Grade is used in place of Source Code as its meaning is more readily understood Doc Nr A7090 N R 110 2 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 2 0 SYSTEM SETUP FOR ADMINISTRATORS 2 1 PROJECT SETUP The database and associated files are provided on CD ROM The NUWWS directory on the disc should be copied to the local C drive of the PC where it will be used Once copied all files will be Read only This option should be cleared before use The file startup wor in C NUWWS setup
8. list Select the appropriate item from the list and the information will appear the popup window You can return to the list simple by clicking the List button If only one item is selected the popup window will only contain information on that object there will not be a list A number of layers in the GIS are linked to the database These are denoted with a db prefix and info suffix to their name such as db ps info shown in the list to Doc Nr A7090 N R 110 11 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 Ps db ps info Dex Cal 4 objects in 4 tables Ps s Killarney Pumping Station Bal DVX NY the left and its own popup to the lower right in Figure 15 and when clicked with the info tool will provide some additional information However if you wish view more information for an object you will need to go the database Make a note of the catchment reference ref and the object reference subref in the Info Tool popup window open the database and then navigate to the relevant catchment and section of the questionnaire x Ret 72 Em eubref 4 200 Type PS Motes Killarney Pumping Station Ballycasheen Labet ps1 re Tm BMR Info Tool x Ref 72 al Subref 1 200 be l Easting 37 335 l Northing 89 338 CAT Addrezszsl Ballycasheen Address2 Addresses Address Cag 160 Emove
9. outfall 3 1 4 Type and Length of Outfall Discharge A GIS Sub Reference l l Main Outtall for outfall Easting Morthing Type of utfall Length m tick one only Sewer pipe to river 10 E 1061 TE GIS Sub Reference l i for outfall Easting Northing Where outfall information is requested in further questi 1060 Record 14 4 i r r of 6 TOET ZS Where outfall information i requested in Further ques n lil iil Record 14 4 3 Figure 29 Navigation button detail Discharges tab Doc Nr A7090 N R 110 21 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 3 1 Discharges 3 2 Type of Hecerving Waters 3 3 Resource amp Amenity Value 3 4 Quality of Recerving Waters 3 4 Quality of Rec_4 Ischarges 3 1 2 Number of Discharges Combined iz Foul Treated Effluent 1 3 1 3 0 5 Grd Ref of end of each outfall 3 1 4 Type and Length of Outfall Discharge GIS Sub Reference for outfall Easting Morthing Type of Outtall Length m 1064 Sewer pipe to river 1065 Sewer pipe to river __ EN Where outhall information i requested in further questions it will refer to the main outfall unless stated otherwise Mam uttal ick one only Figure 30 Scrollbar and navigation detail Discharges tab Doc Nr A7090 N R 110 22 of 22
10. should then be copied to C Program Files MapInfo Professional To use the database Microsoft Access 2000 must be installed on the user s pc Additionally MapInfo and AutoCAD or alternative CAD viewer are required to view the associated GIS and CAD files 2 2 AUTOCAD USER SETTINGS It is recommended that AutoCAD is configured to use a black background This will make the drawings easier to read To change the setting from white or the current user preference first choose Tools Options Colors In the Colors Options window select Layout Tabs Background Paper in the Window Element dropdown and Black in the Color dropdown Click Apply and Close then OK to close the main options window EJ File Edit view Insert Format Tools Draw Dimension Modify Concept Design Documentation Desktop Window Help 8j x pe i BRS ec BO e e LG ieroop z zAlra g giictceweenses Ieelosegoer 25 7 amp e m m amp aa3 24 amp aeeesoeejeoeolejlwuwwiemwewcukeseueee N SAS a DG S oq cms Ai Current profile Architectural Desktop Current drawing A7080 72 5 dwg Files Display Open and Save Platting System User Preferences Drafting Selection Profiles AEC Editor Lal Tarks Legend dam PedundartUnused Plant D D Window Elements Display resolution IV Display scroll bars in drawing window 100 Arc and circle smoothness Display screen menu e Segments in a polyline curve 3 Tex
11. the laneway on the Sanitary Authority Galway County Council Marthing 2D4033 a is located Um Add Treatment Works to questionnaire GIS Form Ew Contact Details Part 1 Loadings and Flow Part 2 Treatment Process Treatment Works Mame Directions Please enter the primary contact The engineer with responsibility for the treatment aspect of the scheme should be familiar with the scheme and its history plus the plant caretaker Postal Address Galway County Council Contact Name Castle Avenue Contact Position Portumna Contact Type Co Galway Telephone Fas Mobile Email Record 14 4 i Lt rs oF 1 Figure 23 NUWWS Treatment Works form To enter information use the drop down boxes to navigate to the required record Users should first select a catchment and then a treatment plant Only previously added items will be available and each treatment works in the catchment needs to be added to the database using the Add Treatment Works form Figure 24 accessed by clicking the Add button on the form above Doc Nr A7090 N R 110 17 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 E Add Treatment Works 1 X National Urban Waste Water Study Select the Catchment name from the pull down list Catchment name Clarecaste v Update or enter the following details for each Treatment Works in this Catchment
12. with the Department of the Environment Heritage and Local Government DEHLG and the Local Doc Nr A7090 N R 110 1 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 1 3 Government Computer Services Board LGCSB that the database would be developed using MS Access software and the GIS would be Mapinfo whilst layout plans for treatment works would be prepared using CAD Access and MapInfo both form part of the Complete Information System CiS which is currently being used by the local authorities to compile detailed records of both water and waste water networks thus the opportunity for future data integration exists However as the name implies the national database and GIS developed as part of this study provide a national overview rather than a detailed local picture For the purpose of GIS records the sewerage layout plans were overlaid on the latest 1 50 000 scale Discovery Series maps from the Ordnance Survey of Ireland OSI and the composite plans were subsequently reproduced as Figures in the catchment reports The database and GIS are linked so that details of mapped features can be accessed in the database and vice versa and both can be edited and or updated as required DATA QUALITY MANAGEMENT The source and therefore the relative confidence which could be placed in of each item of data was assigned Source Code ranking from 1 to 5
13. 000 1029 Hecarving Waler 1030 1059 LI utfall 1060 1033 Combined Storm Overtlow 1700 1133 Pumping station Catchment area GIS CROSS REFERENCE FORM To ensure that the information in the database ties in with the information digitised onto the maps held in MapInfo users must assign catchment numbers and subreferences to each physical asset The subreferences follow a strict numbering protocol this is indicated at relevant places throughout the database and it is essential for all database users to understand that each subreference is not to be used more than once in each catchment It is important that the subreference numbering system be followed both in the digitising process and in the database Any items added to the maps during digitisation should also be recorded on the GIS Cross Reference form so that there is a link between the GIS maps and the database These subreferences are also referred to in some of the questions where extra details are required In order to ensure that each subreference number is used only once in each catchment a GIS Cross Reference form is available at the top the screen via the GIS Form button to show which references have been used for each asset type Figure 21 shows an example of the form Users should enter the catchment number already shown for the existing assets a permitted subreference an asset type a description of the asset and its grid reference The drop down box at the base of the scre
14. T UI DI AN ROINN COMHSHAOIL OIDHREACHTA AGUS RIALTAIS ITIUIL DEPARTMENT OF THE ENVIRONMENT HERITAGE AND LOCAL GOVERNMENT Department of the Environment Heritage and Local Government National Urban Waste Water Study Volume 2 Part B NATIONAL DATABASE amp GEOGRAPHIC INFORMATION SYSTEM USER MANUAL e3 BARRY Babti ttit p amp PARTNERS a abtie Project Design amp Management consu lting engineers Doc Nr A7090 N R 110 June 2004 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 TABLE OF CONTENTS Revision Control Table Table of Contents i 1 0 INTRODUCTION 1 1 1 MG SUMO gr et T E 1 1 2 Bata C EE 1 1 33 Data Quality Management 2 2 0 SYSTEM SETUP FOR ADMINISTRATORS 3 2 1 daier E 3 2 2 AutoCAD User EE os sadist ie ord sad donum ente ete eee ec ee eee UL 3 2 3 ODBC Data Source SOUP EE 4 3 0 OVERVIEW 5 3 1 Rer EE 5 3 2 Geographic Information Gvstem nennen nennen nnne nnne nnns 6 4 0 ACCESSING THE DATABASE 7 4 1 Starting Up The NUWWS Database nemen nnns 7 4 2 ACCESSING TNS cT 7 4 3 General Hints and Ee EE 9 5 0 ACCESSING THE GEOGRAPHIC INFORMATION 10 5 1 Geographical Information Mapinfo nnn 10 6 0 ENTERING NEW RECORDS 14 6 1 Ada eran ne 14 6 2 Update Sewerage Network Details eeeeeeeeeeeeeeeeeeneen nnn 15 6 3 GIS Cross Reference FOM ERR 16 6 4 Updat
15. a has been added click the Exit button to return to the front screen Doc Nr A7090 N R 110 18 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 MUWWS Treatment Works Catchment Name E 0 Reference PLIB 1600 0020 Treatment Works Mame 1000 County County Easting Directions Sanitary Authority U Northing Add Treatment Works to questionnaire GIS Form E xit Contact Details Part 1 Loadings and Flaw Part 2 Treatment Process 2 2 General Site Information 2 3 Preliminary Treatment 2 3 1 1 Screening 2 3 1 3 Grit Removal 2 4 Primary Treatment 2 5 Seco4 A General Site Information aite area ha 2289 reet Plant Commissioned 1383 year Is land available for expansion on site Iv 4210 Last major refurbishment pear Site Layout Plan Provided E 22401 Plant Drawings Available eat af Site Layout Plan 1384 v Aebut T Tender Not vailable Site Layout Plan prepared an Site Treatments Options in Blue wll display further Forms 23 1 Preliminary Treatment Site L t Plan checked on Sit ee S 241 Primary Treatment Process Flow Diagram provided 251 Secondary Treatment fear of Process Flow Diagram 2 6 1 Tertiary Treatment Process Flow Diagram prepared on Site D sli Sludge Treatment S xl XI I I 4 Process Flow Diagram checked on Site E Figure 25 Optional tab sheets 6 5 UPDATE RECEIVING WATERS The receivi
16. b Help S elect Create Repair Compact Advanced Sistem Database None C Database Options Figure 2 ODBC Data Source Setup Doc Nr A7090 N R 110 4 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 3 0 3 1 Nuwwscollect mde OVERVIEW The National Urban Waste Water Database and GIS was designed as an electronic duplicate of the paper questionnaire for used for collecting data for this study Once populated it is ready to be used by national or local government staff to transfer additional asset data from paper copies of questionnaires into an electronic format or to view and analyse the existing information This document is intended as a guide to the key features of the database and GIS but will not instruct users exactly where to locate data or what data to enter into each field as this should be largely self explanatory Copies of the questionnaires and associated guidance notes in Part 2A of this volume may be referred to for more information DATABASE The database is comprised of two separate Microsoft Access 2000 databases The data is managed through the use of forms and queries held in a front end database which links through to the data tables held in a back end database as illustrated in Figure 3 e Nuwwscollect mde This database acts as a front end for data e Nuwwsdata mdb
17. e Treatment e rn 17 6 5 Update Receiving Wales ccccccccsccecssccseecceeeceececeeecsuseecaeecueecseessugeesaeessaeeeaees 19 FIGURES i Changing the background colour setting in Auto Al 3 2 ODBC Dat Source SelllDis sse eenieedor Nalsxue f uox nita e olay eadaetectadtes sa rd ccce lE 4 9 Ree EE 5 4 Data collection database front screen 7 9 Schematic representation of database forms ccccccsececeeceeeeeeeeeeeneeeeeeesseeeaeeees 8 6 ROID WO UNCON EE C cH 9 ifs PAD SCC NS as she can ose rH PER tame 9 8 SIMPE text DON us otitis cies iets ee ss Pe Seana neta eae tet 9 9 erede ln Let du OOK AND RT E TR 9 10 Drop dowitcomDpo DOX EE 9 11 PICK TOK CS rsh ec e CETTE 9 12 CheOSe e een Thee 10 13 Display zoomed in to chosen catchment sees 11 14 Inro and HONK tee 11 15 Info Tool popup windows 12 16 Example CAD Crawl GS c ee tiacsecd cesi aa kb iode este Mte aa a a ERa 13 17 AGG Catchment DUMON eite oo ee Eed 14 18 Add Catchment to Questionnaire Tomm 14 19 Update Sewerage button 15 20 NUWWS Catchment Details Tomm 15 21 GIS Cross Reference form 16 22 Update Treatment Plant button ec cceccceeeceeeeeeeeesee esse eesseeeeseesaeeeseeeesaeees 17 23 NUWWS Treatment Works Tom 17 24 Add Treatment Works e EE 18 Doc Nr A7090 N R 110 ii of iii Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4
18. e of tab headings Figure 7 and can be used to bring other tabs into view Simple text box Typically text is entered can be viewed as a single line in a text box Figure 8 Scrolling text box Where the answers required more detail not all the text will be visible and two arrows will appear to the right of the text box indicating you should scroll down to see more Figure 9 Drop down combo boxes These are used in two different ways in the database The first is as a navigation tool where you choose a record such as a catchment treatment works or receiving water to move to The second is when entering data and the answer to a question is restricted to an option from a pre defined list Figure 10 Tick boxes There are a number of tick check boxes used in the database These are taken to mean No if unticked or Yes if ticked Figure 11 Doc Nr A7090 N R 110 9 of 22 Database amp GIS Version 1 4 3 H Figure 6 Help button Tab sheets Pagel Page Pages Figure 7 Tab sheets Simple text box pne line of text Figure 8 Simple text box Scrolling text box Many lines of text to display many A lines of text to display many lines of text to display many lines of Figure 9 Scrolling text box Drop down combo box Choice 1 Choice 2 w Ticked Yes Figure 11 Tick boxes Department of the Environment Heritage and Local Government Database amp GIS Nat
19. en shows the codes for each asset type and the range of subreferences available When all the data has been entered click the Exit button to return to the previous screen Figure 21 GIS Cross Reference form E x S A Sub Reference Type Mame E asting Northing O CaT Kilkee Catchment Area 100 Future Development Boundary Existing Development Boundary Receiving Water Coastal Waters Qutfall for Kilkee Network 96776 159774 1100 e50 ewe D T GO OO cy cC CO OO CH This procedure should be followed in the same way when using the sewerage treatment works or receiving waters questionnaires This GIS data may also be entered by staff that are digitising information in MapInfo who may also assign subreferences and will know the grid references from the electronic map Doc Nr A7090 N R 110 16 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 6 4 UPDATE TREATMENT WORKS The treatment works section of the database is accessed from the main form by clicking the Update Treatment Plant button Figure 22 This opens the NUWWS Treatment Works form Figure 23 UPDATE Treatment Plant Queshonaire Figure 22 Update Treatment Plant button MUWWS Treatment Works Catchment Mame 65 Reference PUEB 1200 0050 Portumna wa TF 1000 County Galway Easting 184485 From the Library take
20. er Study Version 1 4 3 identical way to those assigned for other assets using the GIS Cross Reference form which is accessible from this page NB There may be multiple discharges Section 3 1 to each receiving water this is indicated by the presence of navigation buttons at the bottom of the page A vertical scrollbar is also present Use the navigation buttons used to move between records As you do so you will notice the selected record will be highlighted and the record number changes as you move from one to another Figure 29 The scrollbar can also be used to view the different records but does not change the selection In the example shown Figure 30 the selected record number 3 is out of view When all available data has been added for receiving waters click the Exit button to return to the front screen AUS Receiving Waters E Catchment Name Sample Y Reference PUB 1600 0020 Treatment orks M ame Sample Treatment Works D County m 0 Sanitary Authority 0 Northing Name of Receiving Waters Sample Receiving Water zl U Add Receiving Waters ta questionnaire GIS Form E xit Fart 3 Receiving Waters Part 4 Receiving waters E 3 1 Discharges 3 2 Type of Receiving Waters 3 3 Resource amp Amenity Value 3 4 Quality of Receiving Waters 3 4 Quality of Rec Discharges 3 1 2 Number of Discharges Combined B Foul Treated Effluent 1 3 1 3 0 5 Grid Ref of end of each
21. fy opposite corner Cancel Command 70 98 273 89 0 00 SNAP GRID ORTHO POLAR OSNAP OTRACK L wT PAPER Figure 1 Changing the background colour setting in AutoCAD Doc Nr A7090 N R 110 3 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 2 3 ODBC DATA SOURCE SETUP The GIS uses Open Database Connectivity ODBC to access data from the questionnaire database Using the Data Sources ODBC Control Panel Applet setup a System Data Source as shown in Figure 2 This must be setup before the user uses the GIS ODBC Data Source Administrator h x User DN system DSN File DSH Drivers Tracing Connection Pooling About Sistem Data Sources Add CASS SQL Server Crystal Repository Microsoft Access Driver mdb Remove 315 Metab ata Microsoft Access Driver LocalS erver SOL Server Configure Metal etal ata Microsoft Access Driver MONS SOL Server Micrasott Access Driver treme Sample Database 9 Microsoft Access Driver ridb An ODBC System data source stores information about how to connect to the indicated data provider A System data source Is visible to all users an this machine including MT services Cancel Apply Help ODBC Microsoft Access Setup EN 2 x Data Source Mame NUWws Description NUS Asset database Cancel Database Database CANUMWAGknumascdata md
22. ional Urban Waste Water Study Version 1 4 3 5 0 ACCESSING THE GEOGRAPHIC INFORMATION 5 1 GEOGRAPHICAL INFORMATION MAPINFO A MapInfo workspace has been setup for the project This is located in the following directory e C NUWWS Workspaces To open the project simply double click the file NUWWS WOR MapInfo will open and you will see an outline map of Ireland no further details will be visible at this scale Provided on the menubar is a custom tool circled to zoom into a chosen catchment To use the tool simply choose the required catchment and click the OK button on the dialog Figure 12 MapInfo Professional Sof Ps Qut Cso Tw Stg R v O 53232 Ma DI e es e t e x ES File Edit Tools Objects Query Table Options Map Window Hel CEE l x peal 5 3 ga 55 j qaqallay a ss 24 e x E Als j Choose Catchment x 4 S Dungarvan Catchment Boundary DI Gorey Catchment Boundary Graiqguenamanagh Tinnahinch Catchment Boundary Kanturk Catchment Boundary Kenmare Catchment Boundary Kilkenny City Catchment Boundar od Killarney Catchment Boundary Killorgan Catchment Area Kingscourt Catchment Boundary Kinsale Catchment Boundary Listowel Catchment Boundar m mi Zoom 850 8 km Editing None Selecting None Figure 12 Choose Catchment tool Doc Nr A7090 N R 110 10 of 22 Department of the Environment Heritage and Local Gove
23. ners 8m dia Sludge To Agriculture 18 x Cke OQnHe Ae gn kb P d Reg Secondary Sette ment Tanks 2 Nr i Secondary Settlement Tank 25 5m dia Pi N Pump Station Surplus Sludge Final Effluent Monitoring a Treated Effluent To Folly Stream I 4 gt bl Model EE IE Legend Raw Waste Water Final Efluent Sludge Dewatered Sludge Flow to Secondary Tanks Sereenings Grit Storm Water Retum Liquors Chemical Dosing Note Piping Omitted From Undemeath 3 Nr Settling Tanks For Clarity Specify corner of window All Center Dynamnic Extents Previous Scale VWindow Command 35 44 5 92 0 00 enter a scale factor nX or nXP or real time all SNAP GRIDIIMRTHN POLAR nsNAP OTRACK LWTI PAPFR Figure 16 Example CAD Drawings Doc Nr A7090 N R 110 13 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 6 0 6 1 ENTERING NEW RECORDS ADD CATCHMENT When entering new questionnaire data the first step is to add a record for the catchment to the database From the front screen click the Add Catchment button Figure 17 to open the Add Catchment to Questionnaire form shown in Figure 18 below 400 Catchment to Questionnaire Figure 17 Add Catchment button A list of all catchments considered by the NUWWS is available in the catchment drop down box To acce
24. ng waters section of the database is accessed from the main form by clicking the Update Receiving Waters button Figure 26 This opens the NUWWS Receiving Waters form Figure 27 UPDATE Recenving waters Questionaire Figure 26 Update Receiving Waters button To enter information use the drop down boxes to navigate to the required record Users should first select a catchment secondly a treatment works and then receiving water As on previous forms only items already added to the questionnaire will be available and each receiving water for the treatment works needs to be added to the database Doc Nr A7090 N R 110 19 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 Catchment M ame Ennistuman T 12 Reference PUB 0331 0010 Treatment Works Mame Ennistemon Wastewater treatment 1000 County Sanitary Authority Llare County Council Northing 158548 Name of Receiving Waters Cullenagh Inagh Fiver Ej 1000 Add Receiving Waters ta questionnaire GIS Form E vit Fart 3 Receiving Waters 4 Part 4 Receiving Waters B 3 1 Discharges 3 2 Type of Receiving Waters 3 3 Resource amp Amenity Value 3 4 Quality of Receiving WaterA 3 4 Quality of Dec d Discharges 3 1 2 Number of Discharges Combined Foul Treated Effluent 1 3 1 3 0 5 Grd Ref of end of each outfall 3 1 4 9 Type and Length of Outfall Discharge GIS Sub
25. r T structcon 3 Mae 3 Base 2 002 Rel 2 lol al db ps info Figure 15 Info Tool popup windows Bj The Hotlink Tool To hotlink open more detailed information into a separate window e g CAD drawing to a CAD drawing select the hotlink tool with a lightening bolt on it In the Map window position the cursor over the item of interest If the curser changes from an arrow to a hand holding a lightening bolt then there is a hotlink item available to view Click on the item on the map and a new window with open with the hotlink item As both a layout drawing and process and flow diagram have been hotlinked to the treatment works when you use the tool you will see a list simple click the one you require and the drawing will open Doc Nr A7090 N R 110 12 of 22 Database amp GIS Version 1 4 3 Department of the Environment Heritage and Local Government National Urban Waste Water Study File Edit View Insert Format Tools Draw Dimension Modify Concept Design Documentation Desktop Window Help jDa Eg Si s8 c ECOee e ss LU RDekQaQ SE e Leonea n p E Du auer D Bu auer ByLayer DI a A Q Ol Q EEN C u a COSOT 2 5mm v Blower Legend Aeration Tanks Sludge Diffused Ain Redundant Unused Plant Drying pts econdary ttle ment Flow Distribution Chamber if Secondary A H Settlement A Tark Nr 1 M P ep D Oxidation T l Oxidation Ditch Nr 2 LANA E Entrance Seconda
26. r further investigations and upgrading works DATA CAPTURE The questionnaire survey forms were in five parts as listed below and included a requirement for layout plans with details of treatment works and sewerage catchments with boundaries flooding or structural failures and other salient features shown The objective was to provide sufficient data to identify the issues which could trigger further investigation and or investment in each catchment Sewerage Network Questionnaire 12 pages Treatment Plant Questionnaire in four parts e Part 1 Loadings amp Flow 6 pages e Part 2 Treatment Process 11 pages e Part 3 Receiving Waters A 3 pages e Part 4 Receiving Waters B 2 pages Copies of the questionnaires which are given in Part A2 of this volume were completed by local authority staff with guidance from the survey team Where plans of the sewerage network etc were not readily available the relevant details were marked up on copies of 1 50 000 scale Ordnance Survey Ireland OSI plans for the catchment Details of the treatment plant layout etc were compiled through a combination of local authority records and site inspections No field checking of sewerage records was involved however all significant treatment plant sites were visited and the treatment process plant layout and sample dimensions were checked Small works such as septic tanks were not generally inspected On commencement of the study it was agreed
27. rnment Database amp GIS National Urban Waste Water Study Version 1 4 3 The display will then zoom into the chosen catchment Figure 13 and all the project layers will become visible To return to the country overview at any time simply right click with the mouse choose View Entire Layer then All Layers MapInfo Professional Sof Ps Out Cso Tw Stg Ry 053232 Map 58 x ES File Edit Tools Objects Query Table Options Map Window Help NUW WS 8 x D SE al mi n daz alz 2 AS amp s Eg s d xar punn SEI OS St d NK ez Ga Ly t mre wd zc Gil E i Lei ZER ee oh etii SA ch Te Sen ao s S c 6 Gu n EA Zoom 10 83 km Editing None Selecting None Ka Figure 13 Display zoomed in to chosen catchment A legend for the base maps can be found on the OSI Discovery Series sheets and a full key to the symbols used in catchment layout plans can be found on the drawings forming appendices to the county reports The Mapinfo Info and Hotlink tools Figure 14 can be used to interrogate the map data click on the appropriate tool button which will stay depressed while the tool is active ily Figure 14 Info and Hotlink tools The Info Tool To view information about a particular item on the map select the tool button with the i on it In the Map window click on the item to be interrogated This will pop up a new information window If there has been more than one item selected the window will show a
28. ry 2 Jettlement m Adminis tr ation mi 3 Nr Aeration Tanks Surface Aeration Inlet Works amp Control Building ndaty P S Settlement R Tank Nr 4 UUN M Site Boundary gt Outlet Flaw Monitoring Monitoring a s N d d j if Secondary Y I Settlement Approx Site Boundary ning Chamber Specify corner of window Command 314 52 273 85 0 00 enter a scale factor nX or nXP or A ll Center Dynamic Extentzs Previous Scale Window real time e SNAP GRID ORTHO POLAR OSNAP OTRACK L wT PAPER DWS A Bag O0O 6 Ww Ls escoe mE 2 A S amp X Q Cu SCOOT 25mm v IBI ByLayer ByLayer ByLayer D x aa Qe ow Goa Screenings To Landfll Screenings Treatment Storm Overflow Manhole M Off Site Coarse Screens Overtow Storm Wate r Overflow Storm Water To Folly Stream Storm Screenings To Landill Land fll Grit Classifier Screenings Treatment Pump Station Storm Tank 1200m Pump Station Retum Pump Station Liquors 2 Nr Gravity Belt Thickeners 4 Nr Thermophillic Perobic Digesters 383mfTotal Digested Sludge Storage Chemical Dosing For P Reduction 2100mMbach f A Flow Meter amp Sampling Gm fi A feration Tanks 928 mMeach Fetivated Sludge Feration Tank 341 4rrAincluding Fnoxc Zones Retum Activated Sludge 2 Nr Gravity Sludge Thicke
29. ss and populate the database for one of these for the first time select the required catchment from the list and complete the on screen details Click the Finished button when done to return to the front screen Once entered a catchment is then available for selection on later forms The addition of new catchments not in the original NUWWS listing whilst not available in the current application may be added should the need arise Es Add Catchment to Questionnaire X National Urban Waste Water Study Select the Catchment name fram the pull down list to add to the questionnaire Catchment Enter or update thai Alternative Name County Sanitary Authority Carlow Mumnebhaeg Tullow B ailisbaraugh Catchment Reference Catchment Outtall 0 5 Grid reference Easting Northing Unda Finished Figure 18 Add Catchment to Questionnaire form Doc Nr A7090 N R 110 14 of 22 Department of the Environment Heritage and Local Government Database amp GIS National Urban Waste Water Study Version 1 4 3 6 2 UPDATE SEWERAGE NETWORK DETAILS Once a catchment has been added further details can be input or updated From the front screen click the Update Sewerage button Figure 19 to open the NUWWS Catchment Details form shown in Figure 20 below UPDATE Sewerage Questionnaire Figure 19 Update Sewerage button The required catchment should then be selected from the drop down box
30. t lines in command line window 0 5 Rendered object smoothness Colors Fonts Contour lines per surface r Layout elements Display performance AXrr SOSO v Display Layout and Model tabs v Pan and zoom with raster image IV Display margins v Highlight raster image frame only IV Display paper background True color raster images and rendering Iv Display paper shadow I Apply solid fill v Show Page Setup dialog for new layouts Show text boundary frame only IV Create viewport in new layouts JV Show silhouettes in wireframe POR OHGVIOVPOANODOLINN INANE OLAS Bae st als sl color Options m Crosshair size Reference Edit fading intensity Model tab Layout tabs fico o a B K File Edit File Edit A Btorm Vi ater OK Cancel P Apply Help Boreening C hamber Tees T day Wo X udge Thickening E P Buildi M cdi y H SEN IR Storm Tank Nr2 Se OI d Window Element 8 Toe Layout tabs background paper Thermo phillic Aerobic D igestion Plant E S B Sub Station amp Standby Gener ator 0 0 0 090 0 0 0 0 0 90 9 0 0 0 0 9 g Color MEETS manasi y y i d V VOU VU o VY VV kasten EDD A ALL KKK LL Default All Default one element o Existing Folly Stream to Lough Leane Apply amp Close Cancel EE Layout A Command Speci
31. tc is briefly explained in Section 4 3 and further information on database screens can be found in Section 6 Doc Nr A7090 N R 110 7 of 22 Database amp GIS Department of the Environment Heritage and Local Government National Urban Waste Water Study Version 1 4 3 Re ad r Sisi Buens LANES sos FUG 53 ORA JULES P ees Hau Are Jure amp Ed F d Dang PPY FAO uageau ppr A A me eres 55e A Pigeon d Haes sya paunga Die AR Sg SUS a LENE TLL LE veel Toup Sa qe pA Dupi aoa TM SpA WLU Pod SA wn MEI spe32d 3u3u133e SAVJATIN F jaja f F m Red 54838 hj ButAla2a al odn 9 9 eee ee ee 1 9 9 E 9 9 Wa a UN mH EE CEET ZTGTETTTe EA SUG Si 03 QUALI ELSA Figure 5 Schematic representation of database forms 8 of 22 Doc Nr A7090 N R 110 Department of the Environment Heritage and Local Government National Urban Waste Water Study 4 3 GENERAL HINTS AND TIPS Help Context sensitive help is available in many areas of the database by clicking the question mark button Figure 6 usually found towards the top right corner of the screen Tab Sheets The entire questionnaire is built using tab sheets These are several overlaid pages accessed via tabs at the top of the page On some occasions there may be too many tabs to show across the screen In this case two navigation arrows will appear to the right of the lin
Download Pdf Manuals
Related Search