Home

I 1 - Simon Fraser University

1. B Structure for database SITEDBF B B B Structure for database SITETYPE DBF 4 Structure for database WASLISTDBF 4 Appendix C Coding 1 Table 1 Origin of data and codes 1 Appendix D Lookup Tables D 1 Table 1 Sub basin watershed codes and descriptions o D 1 Table 2 Region codes descriptions and the associated sub basin D 1 Table 3 B C MELP office codes and descriptions D 2 Table 4 Site industry codes and descriptions IDEM D 3 Table 5 B C MELP discharge to codes and descriptions D 33 Table 6 B C MELP waste type codes and descriptions D 33 Table 7 B C site type codes and D 34 Table 8 Parameter codes descriptions units and upper limits D 35 Appendix Import File 1 Structure for database SIMS DBF E 1 Fraser PSI Database User s Manual LIST OF FIGURES Figure 1 System 6 Figure 2 Menu d Fraser PSI Database User s Manual 1 ET 1 0 Introduction The pollution abatement component of the Fraser Riv
2. 0104 CISA Chloride S 1st Step ChorideSouble 3016 1016 Chlorine Resor colo 20000 3 8 8 i aa J em J m m amp i l i Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNI C050 Chlorodehydroabietic cos COAL Coal Cot coa o 0450 100 mL B E S amp e S zi B Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION Cu S Copper Soluble 09 ug L 20000 Cyanide Toral m 100 20000 s EN 5 Q lt N e e amp 10 P014 Di n Octyl Phthalate Dizainon PAIO Dibenzo a h anthrace B026 Dichlorobenzene 1 3 0062 Dichlorocatechols 0053 DichlorodehydroAbiet Dichloroguaiacol 012 Phthalate N It D Q Q O Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMIT D022 P011 Diethyl Pht
3. TE I 4 8 2 Exiting from the Screen Form The screen form must be exited by selecting the lt EXIT gt push button on the control window i e the menu on the right side of the editing and viewing screens 4 8 3 Site Data Screen _ Each record in the database must have an entry in the Record ID field since this is the unique identifier for each site For all sites other than federal facilities the Record ID is a 6 character string beginning with a P and ending with the numeric portion of the Waste Management Permit number For example Scott Paper Limited has a Permit No PE 335 Therefore the Record ID for Scott Paper is 0335 For federal facilities the Federal Facility number obtained from FFEAD is entered in the Record ID field and in the Federal Facility field Some federal facilities may also have a B C WASTE Management permit In this case the provincial permit number is used in the Record ID field and the federal facility number is in the Federal Facility number field This makes it possible to search for all federal facilities using the Federal Facility field and the shoe push button Pressing the F2 key while the cursor is in the sic code field activates a lookup table Entries can be selected from this lookup table by pressing Enter The user can also edit the lookup search string displayed at the top of the lookup window The user should note that the system will search by SIC name o
4. to switch to disk drive INSTALL to install the databases and program files Note do NOT type A INSTALL the difference being that you need to press the Enter key after and once again after INSTALL Now just follow the screen prompts placing the appropriate disk in drive A as directed Fraser PSI Database User s Manual UJ 4 0 Running the Program Ensure that your mouse is functional by activating it explicitly before executing the program the commands to access the mouse driver are sometimes put into the AUTOEXEC BAT file The program will run without the mouse but it will not be as simple to use To run the program Type Fraser and press the Enter button At the password entry window the user must enter his her password The user should note that the password checking program is case sensitive The system will not recognize the password if the CAPS LOCK key is on HELP is available on most of the subsequent screens by pressing the F1 key or by clicking on the Help push button 4 1 Using the Mouse Mouse operations are performed using the left mouse key Window manipulation is performed very much like window manipulation in Microsoft Windows 3 x Windows can be moved by clicking on the top side of the frame and holding the left mouse button down while dragging the mouse Windows are activated by clicking anywhere within a window the colour of the window title changes when a window is activate
5. Life Insurers Life Insurers Deposit Insurers Deposit Insurers Property and Casualty Insurers Health Insurers Other Property and Casualty Insurers Other Financial Intermediary Industries Security Brokers and Dealers Investment Dealers Stock Brokers Commodity Brokers Mortgage Brokers Mortgage Brokers Security and Commodity Exchanges Stock Exchanges Commodity Exchanges Other Financial Intermediaries n e c Other Financial Intermediaries n e c Real Estate Operator Industries Except Developers Operators of Buildings and Dwellings Operators of Residential Buildings and Dwellings Operators of Non Residential Buildings Fraser PSI Database User s Manual D 25 759 7599 76 761 7611 77 771 7711 7712 772 7721 7722 773 7731 7739 774 7741 7742 7743 7749 775 7751 7752 7759 776 7761 777 TIT 779 7791 7792 7793 7794 7795 7796 7799 81 811 8111 812 8121 8122 Other Real Estate Operators Other Real Estate Operators Insurance and Real Estate Agent Industries Insurance and Real Estate Agencies Insurance and Real Estate Agencies Business Service Industries Employment Agencies and Personnel Suppliers Employment Agencies Personnel Suppliers Computer and Related Services Computer Services Computer Equipment Maintenance and Repair Accounting and Bookkeeping Services Offices of Chartered and Certified Accountants Other Accounting and Bookkeeping Services Advertising Services Advertising
6. i 20000 20000 20000 20000 amp T039 3Chloroguaiacdl3 4 5 com T063 4ChI2BFuran 2 3 7 8 20000 SCH2BFurn23478 041 SChldibenzodioxin pon Tm t t2 gt N N gt N Q e gt gt Q Q Q Q Q e Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMIT N N t Q Q e Q e gt e Q Q Q e o e e e S S S S EE 500 500 amp amp Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMIT _ EN amp 8 8 818168 s iii E 5 6 98899688 i i Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMIT er T ates 0 C S gt gt ioyosyo roi ro O OO T O 8 e 5 amp 3 E E
7. Fraser PSI Database Users Manual 2 CODE DESCRIPTION cmo pae ow ow AD w 1 Benzo a anthracene Paos Benzo a pyrene Benzo fluoranthe Benzo ehi _ z 5 ESA Beryllium Dissolved osi pomer Bio LC50 Rainbow Tr Bio LT50 Daph Magna 0459 Bio 21 4 1416 Bioassay LCS0 Saimon Bioassay LTSO 01 I i i ui Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMI N oro gt Oo gt Bi T ele CHA Cadmium tistStep 1000 C Cadmium tnsoluble mL CASA Cadmium S 1st Step Cd S Cadmium Soluble CdTA Cas CaumSohbe Captain ooa EFIS Carbamate a 8 i Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMIT C007 Carbophenthion 20 10000 1104 Chloride Dissolved
8. 2 14 51 Updates to 14 52 Backing Up the System 2 og xor EV RS 14 5 3 User ID and Password Maintenance A Torn 14 Fraser PSI Database User s Manual iti E eg eT 6 0 System Limitations 15 7 0 Summary and Recommendations ERE ET 15 Appendix Screen Snapshots Ut 1 Figure 1 Opening screen of the Fraser 51 1 Figure 2 screen ofthe Fraser PSI program A 2 Figure 3 Selecting an option from the pulldown menu system 3 Figure 4 The site information screen A 4 Figure 5 information screen with parameter browse table A S Figure 6 Producing a report A 6 Figure 7 Setting a filter condition on the database A 7 Appendix B System Structue B Structure for database DISCLISTDBF B Structure for database B Structure for database OFFICEDBF Structure for database B 2 Structure for database PARAM DBF amp ou B 2 Structure for database PARTABLE DBF B Structure for database SICLIST DBF
9. Outfall Parameter and All Note the selection refers to a report that contains information from all three databases After selecting the desired database the user now must decide which records they want included in their report 4 10 2 1 Selecting Records For simple reports three options are available a specific Record ID all records in the currently selected database or an advanced record selection Note for a specific Record ID the number must exactly match the number in the database i e don t forget about leading 05 4 10 2 2 Advanced Record Selection Filters Filters provide the user with the ability to retrieve information above and beyond the standard reporting features of the system A filter specifies a condition that records in the current table database must meet to be accessible Through an easy step by step process the user is able to build and execute complex queries From a set of predetermined fields derived from Fraser PSI Database User s Manual 13 HET mcr DC the current database the user simply points and clicks the mouse on the desired fields to generate the required information For example if the current database was Sife you would have the option to query on Region Sub basin Industry code Industry name BC environment office and Manager After selecting one of the aforementioned fields the comparison operat
10. these changes Warning while in the edit submenu any changes made to the parameter data is saved automatically hence caution is advised when editing this data because you will be unable to cancel the changes made Fraser PSI Database User s Manual 11 NERA ER It NOCT EDI EEUU CIC Ga v c c ss cc GNU SUN IN OO NECI CN CA CDU ER IRI Rp ANDARE REESE NORIS WU UD 4 9 1 New Records New records be added to the database by clicking on the New push button at the bottom of the control window Clicking on this push button will cause the Save and Cancel push buttons to be enabled If the New push button is disabled light blue letters then you may be in viewing mode and not editing mode The system may be waiting for you to cancel or save the existing record that is displayed onscreen before it will let you add a new record Clicking on the New push button will produce different results depending on which screen is currently being edited When the site information screen is edited the system creates a new site and a blank outfall when the outfall information screen is edited the system creates a new outfall and when the parameter browse window is edited a new parameter is created Each new record in the database must have an entry in the Record ID field since this is the unique identifier for each site For all sites other than federal facilities the Record
11. 4812 4813 4814 482 4821 483 4839 484 4841 General Freight Trucking Industry Used Goods Moving and Storage Industry Bulk Liquids Trucking Industry Dry Bulk Materials Trucking Industry Forest Products Trucking Industry Other Truck Transport Industries Public Passenger Transit Systems Industries Urban Transit Systems Industry Interurban and Rural Transit Systems Industry School Bus Operations Industry Charter and Sightseeing Bus Services Industry Limousine Service to Airports and Stations Industry Other Transportation Industries Taxicab Industry Other Transportation Industries n e c Other Service Industries Incidental to Transportation Highway Street and Bridge Maintenance Industry Freight Forwarding Industry Other Service Industries Incidental to Transportation Pipeline Transport Industries Pipeline Transport Industries Natural Gas Pipeline Transport Industry Crude Oil Pipeline Transport Industry Other Pipeline Transport Industries Storage and Warehousing Industries Grain Elevator Industry Grain Elevator Industry Other Storage and Warehousing Industries Refrigerated Warehousing Industry Other Storage and Warehousing Industries n e c Communication Industries Telecommunication Broadcasting Industries Radio Broadcasting Industry Television Broadcasting Industry Combined Radio and Television Broadcasting Industry Cable Television Industry Telecommunication Carriers Industry Telecommunication C
12. Agencies Media Representatives Outdoor Display and Billboard Advertising Other Advertising Services Architectural Engineering and Other Scientific and Technical Services Offices on Architects Offices of Engineers Other Scientific and Technical Services Offices of Lawyers and Notaries Offices of Lawyers and Notaries Management Consulting Services Management Consulting Services Other Business Services Security and Investigation Services Credit Bureau Services Collection Agencies Customs Brokers Telephone Answering Services Duplicating Services Other Business Services n e c Federal Government Service Industries Defense Services Defense Services Protective Services Courts of Law Correctional Services Fraser PSI Database User s Manual D 26 ECHERGU a ee ema 8123 8125 8129 813 8131 8132 8139 814 8141 8142 815 8151 8152 8153 8154 8159 816 8161 8162 8163 8164 817 8171 8172 8173 8174 8175 8176 82 822 8221 8222 8223 8224 8225 8229 823 8231 825 8251 8252 8253 Police Services Regulatory Services Other Protective Services Labour Employment and Immigration Services Labour and Employment Services Immigration Services Other Labour Employment and Immigration Services Foreign Affairs and International Assistance Foreign Affairs International Assistance General Administrative Services Executive and Legislative Administration Finance and Economic Administrati
13. Mix Concrete Industry Glass and Glass Products Industries Primary Glass and Glass Containers Industry Glass Products Industry Except Glass Containers Abrasives Industry Fraser PSI Database User s Manual D 13 lt r Ta s lt a 3 3 _ lt a gt a MM 3571 358 3581 359 3591 3592 3593 3594 3599 36 361 3611 3612 369 3699 37 371 3711 3712 372 3721 3722 3729 373 3731 374 3741 375 3751 376 3761 377 3771 379 3791 3792 3799 39 391 3911 3912 3913 Abrasives Industry Lime Industry Lime Industry Other Non Metallic Mineral Products Industries Refractories Industry Asbestos Products Industry Gypsum Products Industry Non Metallic Mineral Insulation Materials Industry Other Non Metallic Mineral Insulating Materials Industry n e c Refined Petroleum and Coal Products Industries Refined Petroleum Products Industries Refined Petroleum Products Industry Except Lubricating Oil and Grease Lubricating Oil and Grease Industry Other Petroleum and Coal Products Industries Other Petroleum and Coal Products Industries Chemical and Chemical Products Industries Industrial chemicals Industries n e c Industrial chemicals Industries n e c Industrial Organic Chemical Industries n e c Agricultural Chemical Industries Industrial Organic Chemical Industries n e c Mixed Fertilizer Industry f Other Agricultural Chemical Industries Plastic and Synthetic Resin Industry Plastic and Synthetic R
14. Other Service Industries Incidental to Mining Food Industries Meat and Poultry Products Industries Meat and Meat Products Industry Except Poultry Poultry Products Industry Fish Products Industry Fish Products Industry Fruit and Vegetable Industries Canned and Preserved Fruit and Vegetable Industry Frozen Fruit and Vegetable Industry Dairy Products Industries Fluid Milk Industry Other Dairy Products Industries Flour Prepared Cereal Food and Feed Industries Cereal Grain Flour Industry Fraser PSI Database User s Manual D 6 1052 1053 106 1061 107 1071 1072 108 1081 1082 1083 109 109 1092 1093 1094 1099 11 111 1111 112 1121 113 1131 114 1141 12 121 1211 122 1221 15 151 1511 152 1521 159 1599 16 151 1611 162 Prepared Flour Mixes and Prepared Cereal Foods Industry Feed Industry Vegetable Oil Mills Except Corn Oil Vegetable Oil Mills Except Corn Oil Bakery Products Industries Biscuit Industry Bread and Other Bakery Products Industry Sugar and Sugar Confectionery Industries Cane and Beet Sugar Industry Chewing Gum Industry Sugar and Chocolate Confectionery Industry Other Food Products Industries Tea and Coffee Industry Dry Pasta Products Industry Potato Chip Pretzel and Popcorn Industry Malt and Malt Flour Industry Other Food Products Industries n e c Beverage Industries Soft Drink Industry Soft Drink Industry Distillery Products Industry Distillery Prod
15. Picture Exhibition Regular Motion Picture Theatres Outdoor Motion Picture Theatres Other Motion Picture Exhibition Theatrical and Other Staged Entertainment Services Entertainment Production Companies and Artists Other Theatrical and Stage Entertainment Services Commercial Spectator Sports Professional Sports Clubs Professional Athletes and Promoters on Own Accounts Horse Race Tracks Other Race Tracks Sports and Recreation Clubs and Services Golf Courses Curling Clubs Skiing Facilities Fraser PSI Database User s Manual 31 a a 9654 9659 966 9661 969 9691 9692 9693 9694 9695 9696 9699 97 971 9711 9712 9713 972 9721 9722 9723 9724 9725 9726 9729 973 9731 9732 974 9741 979 9791 9792 9799 98 981 9811 982 9821 983 9831 9839 Boat Rentals and Marinas Other Sports and Recreation Clubs Gambling Operations Gambling Operations Other Amusement and Recreational Services Bowling Alleys and Billiard Parlours Amusement Park Carnival and Circus Operations Dance Halls Studios and Schools Coin Operated Amusement Services Roller Skating Facilities Botanical and Zoological Gardens Other Amusement and Recreational Services Personal and Household Service Industries Barber and Beauty Shops Barber Shops Beauty Shops Combination Barber and Beauty Shops Laundries and Cleaners Power Laundries and or Dry Cleaners Distributors and or Agents for Dry Cleaners Self Se
16. Repair Services Electric Motor Repair Welding Other Repair Services n e c Services to Buildings and Dwellings Disinfecting and Exterminating Services Window Cleaning Services Janitorial Services Other Services to Buildings and Dwellings Travel Services Ticket and Travel Agencies Tour Wholesalers and Operators Other Services n e c Parking Lots and Parking Garages Other Services n e c Waste Disposal Operations Storage Facilities for Bulk Solids Storage Facilities for Bulk Liquids Anthracite Coal Mines Placer Mines Medical Health and Other Laboratories Other Wood Products Industries Other Repair Shops Other Recycling Operations An Industry Not Referred to Elsewhere in this Schedule Fraser PSI Database User s Manual Table 5 B C MELP discharge to codes and descriptions U Table 6 B C MELP waste type codes and descriptions Waste Type Table CODE DESCRIPTION 2 Coot Fraser PSI Database User s Manual Table 7 B C MELP site type codes and descriptions Site Type Table River Stream or Creek 01 03 05 07 13 15 17 19 21 23 25 27 29 31 33 35 36 37 38 39 Fraser PSI Database User s Manual Table 8 Parameter codes descriptions units and upper limits Parameter Table CODE DESCRIPTION 0044 2 4 D 20000 2050 2 4Dichlorophenol g
17. Toilet Preparations Wholesale Tobacco Products Wholesale Tobacco Products Wholesale Apparel and Dry Goods Industries Wholesale Apparel Wholesale Men s and Boys Clothing and Furnishings Wholesale Women s and Misses and Children s Hosiery Underwear and Apparel Accessories Wholesale Footwear Wholesale Fraser PSI Database User s Manual 3319 532 5321 5329 54 541 5411 5412 542 5421 543 5431 5431 5433 5439 S5 551 5511 5512 5519 552 5521 5529 56 561 5611 5612 5613 5619 562 5621 5622 563 5631 5632 5639 57 571 5711 572 Other Apparel Wholesale Dry Goods Wholesale Piece Goods Wholesale Notions and Other Dry Goods Wholesale Household Goods Industries Wholesale Electrical and Electronic Household Appliances and Parts Wholesale Electrical Household Appliances Wholesale Electronic Household Appliances Wholesale Household Furniture Wholesale Household Furniture Wholesale Household Furnishings Wholesale China Glassware Crockery and Pottery Wholesale Floor Coverings Wholesale Linens Draperies and Other Textile Furnishings Wholesale Other Household Furnishings Wholesale Motor Vehicle Parts and Accessories Industries Wholesale Motor Vehicles Wholesale Automobiles Wholesale Trucks and Buses Wholesale Other Motor Vehicles and Trailers Wholesale Motor Vehicle Parts and Accessories Wholesale Tires and Tubes Wholesale Other Motor Vehicle Parts and Accessories Wholesale Metals Hardware P
18. the mouse on the desired option A light blue colour for a push button window or menu option means that it is temporarily disabled or inactive 4 2 Using the Keyboard Most mouse operations can also be accomplished with the keyboard To cycle between windows press Ctrl F1 this is especially helpful when browsing all three databases The pulldown menus can be activated by typing Alt the highlighted letter on the menu bar The choices offered by the control window located on the right side of the site and outfall screens can be activated by typing Ctrl the highlighted letter Tab and Shift Tab move the cursor to the next field and previous field on the screen respectively Keyboard shortcuts are sometimes indicated beside a menu option such as Delete D Ctrl D 4 3 System Security The system security prevents unauthorized access to the database and is also used to monitor and record changes to the database The changes are stored in a transaction log file The date of last update and the user name of the person who updated the record are stored with each of the database files A separate paper transaction log should also be maintained of all changes to the database The paper transaction log is needed to reconstruct the database if a disk problem occurs and changes have been made to the database since the last time it was backed up Assigning different security levels to different users allows the system administrator to contro
19. 4 Field Crop Combination Farms 0141 Field Crop Combination Farms 015 Fruit and other Vegetable Farms 0151 Fruit Farms 0152 Other Vegetable Farms 0159 Fruit and Vegetable Combination Farms 016 Horticultural Specialties 0161 Mushrooms 0162 Green House Products 0163 Nursery Products 0169 Other Horticultural Specialties 017 Livestock Field Crop and Horticultural Combination Farms 0171 Livestock Field Crop and Horticultural Combination Farms Fraser PSI Database User s Manual D 4 02 021 0211 0212 0213 0219 022 0221 0222 0223 0229 023 0231 0239 03 031 0311 0312 032 0321 033 0331 0339 04 041 0411 05 051 0511 06 061 0611 0612 0613 0614 0615 0616 0617 0619 062 0621 0622 Service industries Incidental to Agriculture Services Incidental to Livestock and Animal Specialties Veterinary Services Farm Animal Breeding Services Except Poultry Poultry Services Other Services Incidental to Livestock and Animal Specialties Services Incidental to Agricultural Crops Soil Preparation Planting and Cultivating Services Crop Dusting and Spraying Services Harvesting Baling and Threshing Services Other Services Incidental to Agricultural Crops Other Services Incidental to Agriculture Agricultural Management and Consulting Services Other Services Incidental to Agriculture n e c Fishing and Trapping Industries Fishing Industries Salt Water Fishing Industry Inland Fishing industry Services Incide
20. 646 8647 8648 8649 865 8651 8652 8653 8654 866 8661 8662 8663 8664 8665 8666 8667 8668 8669 867 8671 8672 8679 868 8681 8682 8683 8684 8685 8689 869 8691 8692 8693 8694 8699 91 911 Child Welfare Services Family Planning Services Sheltered Workshops Home Maker Services Meal Services Non Commercial Social Rehabilitation Services Crisis Intervention Other Non Institutional Social Services Offices of Physicians Surgeons and Dentists Private Practice Offices of Physicians General Practice Offices of Physicians and Surgeons Specialists Offices of Dentists General Practice Offices of Dentists Specialists Offices of Other Health Practitioners Offices of Chiropractors and Osteopaths Offices of Nurses Registered Offices of Nurses Practical Offices of Nutritionists Dietitians Offices of Physiotherapists Occupational Therapists Offices of Optometrists Offices of Podiatrists and Chiropodists Offices of Denturists Offices of Other Health Practitioners Offices of Social Services Practitioners Offices of Psychologists Offices of Social Workers Offices of Other Social Service Practitioners Medical and Other Health Laboratories Medical Laboratories Radiological Laboratories Combined Medical and Radiological laboratories Public Health Laboratories Blood Bank Laboratories Other Health Laboratories Health and Social Service Association and Agencies Health Care and Public Safe
21. 9 296 2961 297 2971 299 2999 30 301 3011 302 3021 3022 3023 3029 303 3031 3032 3039 305 3051 3052 3053 3059 306 3061 3062 3063 3069 307 3071 308 3081 309 3091 3092 Steel Pipe and Tube Industry Iron Foundries Iron Foundries Non Ferrous Metal Smelting and Refining Industries Primary Production of Aluminum Other Primary Smelting and Refining of Non Ferrous Metal Industries Aluminum Rolling Casting and Extruding Industry Aluminum Rolling Casting and Extruding Industry Copper and Copper Alloy Rolling Casting and Extruding Industry Copper and Copper Alloy Rolling Casting and Extruding Industry Other Rolled Cast and Extruded Mon Ferrous Metal Products Industries Other Rolled Cast and Extruded Mon Ferrous Metal Products Industries Fabricated Metal Products Industries Except Machinery and Transportation Equipment Industries Power Boiler and Heat Exchanger Industry Power Boiler and Heat Exchanger Industry Fabricated Structural Metal Products Industries Metal Tanks Heavy Gauge Industry Plate Work Industry Pre Engineered Metal Buildings Industry Except Portable Other Fabricated Structural Metal Products Industries Ornamental and Architectural Metal Products Industries Metal Door and Window Industry Prefabricated Portable Metal Buildings Industry Other Ornamental and Architectural Metal Products Industries Wire and Wire Products Industries Upholstery and Coil Spring Industry Wire
22. ATABASE Record ID Waste Number Waste Water Type Discharge To Site Type SITE TYPE TABLE Site Type Code DISCHARGE TO TABLE Discharge To Code WASTE WATER TYPE TABLE Waste Water Type Code v PARAMETER DATABASE Record ID Waste Number Parameter Code eod PARAMETER CODE TABLE Parameter Code LOADTAB DATABASE Record ID Parameter Code Parameter Name Loading TN enue 19 osequie T Sd 195914 SYSTEM FILE EDIT VIEW RECORD REPORTS WINDOW MAINTENANCE Administration nuow znBra Next Security Log Browse Prior Reindex Databases Calculator Top Backup Databases Calendar Diary Bottom Environment Locate 5 SIC Browse Parameter Browse Pack W asteWater Browse Toggle Delete Discharge To Browse Site Type Browse Delete Rec from 3 Databas Office Browse Pack all 3 Databases Edit Help Test Move F7 Cycle AF1 List of currently defined window names View Permit Browse All Set Printer Driver Edit Permit Browse All Simple Form Reports Custom Reports Loading Reports Code Tables enuvjA 5 95 5 154 295911 Fraser PSI Database User s Manual 8 rd 4 8 Viewing Data View Submenu The view submenu allows the user to view each of the individual database files The system displays these files on a screen form There are two main scre
23. Administration Housing Administration Regional Planning and Development Administration Research Administration Local Government Service Industries Protective Services Courts of Law Correctional Services Police Services Firefighting Services Regulatory Services Other Protective Services General Administrative Services Executive and Legislative Administration Finance and Economic Administration Taxation Administration Intergovernmental Affairs Administration Other General Administrative Services Human Resource Administration Health Administration Social Service Administration Education Administration Recreation and Culture Administration Economic Services Administration Transportation Administration Resource Conservation and Industrial Development Administration Environment Administration Housing Administration Regional Planning and Development Administration International and Other Extra Territorial Government Service Industries International and Other Extra Territorial Agencies International and Other Extra Territorial Agencies Fraser PSI Database User s Manual D 28 85 851 8511 852 8521 853 8531 854 8541 855 8551 859 8599 86 861 8611 8612 8613 8614 8615 8616 8617 8619 862 8621 8622 8623 8624 8625 8626 8627 8628 8629 863 8631 8632 8633 8634 8635 8639 864 8641 Educational Service Industries Elementary and Secondary Education Elementary and Se
24. Fraser Point Source Inventory FRASER RIVER i Users Manual ACTION PLAN pie DOE FRAP 1993 06 BH Environment Environnement Canada Canada FRASER POINT SOURCE INVENTORY Version 3 0 USER S MANUAL DOE FRAP 1993 06 Prepared for Environment Canada Fraser Pollution Abatement Office 224 West Esplanade North Vancouver B C V7M 3H7 Prepared by The University of British Columbia Westwater Research Centre 2206 East Mall Vancouver B C V6T 123 Revised by Information and Systems 224 West Esplanade North Vancouver B C 3H7 June 1994 Fraser PSI Database User s Manual i Disclaimer This publication contains the results of a project conducted under contract to Environment Canada The ideas expressed herein do not necessarily state or reflect those of Environment Canada Comments regarding this publication should be addressed to Fraser Pollution Abatement Office Environment Canada 224 West Esplanade North Vancouver B C V7M 3H7 Fraser PSI Database User s Manual ii D E TABLE OF CONTENTS l O 5 a a ss s sr 1 2 0 2 3 0 Installing the System ere Set gud Bs 2 4 0 Running the Program s n 4 1 Using the Mouse 3 4 2 Using Keyboard 4 4 3 System Security e oee
25. ID is a 6 character string beginning with a P and ending with the numeric portion of the Waste Management Permit number For example Scott Paper Limited has a Permit No PE 335 Therefore the Record ID for Scott Paper is 0335 For federal facilities the Federal Facility number obtained from FFEAD is entered in the Record ID field and in the Federal Facility field If the federal facility also has a B C WASTE Management permit enter the provincial permit number in the Record ID field and the federal facility number is in the Federal Facility number field 4 9 2 Editing Existing Records The system monitors any changes you make to the system If you make a change to any one of the fields the system will ask you to confirm changes and will disable the record control window and some of the push buttons on the screen At this point you can continue making changes to the field however you must eventually save or discard these changes before exiting the screen 4 9 3 Deleting Records The process of deleting records involves flagging a record for deletion and then recovering the space in the file by packing the table The deletion process is done in this way because packing the table can be a very time consuming process for large databases It is more time efficient to mark for deletion all the records that you want to delete and then recover the file space by clicking on the Pack menu item in the Record submenu Fraser PSI Database Us
26. P UNITS WASTE NO SIT TYP DISC TO REL COD PAR COD DIS MIN DIS MAX DIS AVG UNIT COD DIS TIM DIS DUR DISD UNI DIS FRQ DISF UNI WAT BOD PER DAT Total SIMS DBF 2598 12 30 92 at Width Numeric 5 Numeric 2 Character 2 Character 2 Character 2 Character 1 Character 1 Character 1 Numeric 8 Character 50 Character 50 Character 150 Character 150 Character 10 Character 10 Character 6 Character 7 Character 7 Character 5 Numeric 8 Character 15 Numeric 2 Character 2 Character 1 Character 1 Character 4 Numeric 13 Numeric 13 Numeric 13 Character 8 Numeric 3 Numeric 3 Character 3 Numeric 3 Character 3 Character 40 Numeric 10 615 8 33 Dec 55
27. QUQ s s 4 4 4 Database Structure cese Ro EU 4 5 4 5 Menu Hierarchy ww Se See 5 4 6 Importing Data FileSubmenu VE s d 5 4 7 Exporting Data File Submenu eee 5 4 8 Viewing Data View Arae 8 4 8 1 Navigating Through the 8 4 8 2 Exiting from the Screen Form 9 4 8 3 Site Data Screen UTD 9 4 8 4 Outfall Data Screen aes 9 4 8 5 Parameter Data Screen 10 4 8 6 Changes to the Data r 10 4 9 Editing Data Edit Submenu 10 49 New Records oe 11 4 92 Editing Existing 11 4 9 3 Deleting Records 11 4 10 Reporting Reports 5 12 4 10 1 Setting Printer Driver 12 4 10 2 Simple Form Reporting 12 4 10 2 1 Selecting Records 12 4 10 2 2 Advanced Record Selection Filters T A ME 12 4 10 3 Custom Reporting 13 4 10 4 Loading Calculations 13 4 11 Maintenance Submenu ata 13 4 12 Exiting the 14 5 0 Maintaining the Database
28. SI database permits sophisticated reporting concerning parameter loadings in the Fraser Basin Users have the ability to produce reports from PSI reports menu or to produce customized tabular reports The following is a list of recommendations for improving the usefulness and validity of the FR_ PSI database Consistency with Other Databases Procedures need to be developed to ensure that the PSI database is regularly updated with data from the WASTE system Consistency with Wastewater Discharge Permits Each permit in PSI database needs to be fully validated against the actual paper permit This should ideally be done by the person s who is responsible for the permits in each sub basin of the Fraser River Basin because he she will be most familiar with the permits and will be quickly able to identify database entries that are incorrect e Version Control and User Registration A list of users of the system should be maintained and these users should be given regular updates to the system These updates should be dated and given a number to facilitate version control Sophisticated Reporting for Integrity Checking Reports should be created that allow for sophisticated intra record checking of data These reports should be designed to highlight extraneous data values They should be designed in conjunction with an expert in the field of permit allowance administration Standardization of Permits The
29. al D 55 Parameter Table CODE DESCRIPTION UNITS Silicon Si T Si D SiF4 Silicon Dissolved Silicon Tetra F Ag T Silver Ag D 001 Silver Dissolved d Simzine Na t Sodium NaCA Na D NaOH Sodium Hydroxide WE SR NaSA Sodium S 18 Step mg 10000 Na S Sodium Soluble 5000 EF14 Soft Drink Bottling Solvent Soluble Herb Specific Conductance Stearic 20000 Streptococcus 100mL 50000 i Sodium Borate 8 Sodium Chlorate Sodium Dissolved I Sodium Silicate i 8 SSHS 0011 011P FA06 0454 Sr T Strontium 20000 Sr D S010 Strontium Dissolved 10000 Styrene 500 8 Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER S T Sulphur Total Su2 Sulphur Bivalent amp 30 e 3 1 300 amp 1 0138 0122 Te T 0013 20000 20000 N e i Fraser PSI Database User s Manual 57 Parameter Table CODE DESCRIPTION TO20 Tetrachlorophenols 20000 TI T Thallium 10000 TI D Thallium Dissolved T l i 3 8 Sn D Tin Dissolved f Tr Titanium
30. and Wire Rope Industry Industrial Fastener Industry Other Wire Products Industries Hardware Tool and Cutlery Industries Basic Hardware Industry Metal Dies Moulds and Patterns Industry Hand Tool and Implement Industry Other Hardware and Cutlery Industries Heating Equipment Industry Heating Equipment Industry Machine Shop Industry Machine Shop Industry Other Metal Fabricating Industries Metal Plumbing Fixtures and Fittings Industry Metal Valve Industry Fraser PSI Database User s Manual D 11 3099 31 311 3111 312 3121 319 3191 3192 3193 3194 3199 32 321 3211 323 3231 324 3241 3242 3243 3244 325 3251 3252 3253 3254 3255 3256 3257 3259 326 3261 327 3271 328 3281 329 3299 33 331 3311 Other Metal Fabricating Industries n e c Machinery Industries Except Electrical Machinery Agricultural Implement Industry Agricultural Implement Industry Commercial Refrigeration and Air Conditioning Equipment Industry Commercial Refrigeration and Air Conditioning Equipment Industry Other Machinery and Equipment Industries Compressor Pump and Industrial Fan Industry Construction and Mining Machinery and Materials Handling Pan Industry Sawmill and Woodworking Machinery Industry Turbine and Mechanical Power Transmission Equipment Industry Other Machinery and Equipment Industries Transportation Equipment Industries Aircraft and Aircraft Parts Industry Aircraft and Aircraft Par
31. arriers Industry Other Telecommunication Industries Other Telecommunication Industries Postal and Courier Service Industries Postal Service Industry Fraser PSI Database User s Manual D 18 4842 49 491 4911 492 4921 493 4931 499 4999 50 501 5011 5012 5019 51 511 5111 52 521 5211 5212 5213 5214 5215 5216 5217 5219 522 5221 523 5231 5232 5239 524 5241 53 531 5311 5312 5314 Courier Service Industry Other Utility Industries Electric Power Systems Industry Electric Power Systems Industry Gas Distribution Systems Industry Gas Distribution Systems Industry Water Systems Industry Water Systems Industry Other Utility Industries n e c Other Utility Industries n e c Farm Products Industries Farm Products Wholesale Livestock Wholesale Grain Wholesale Other Farm Products Petroleum Products Industries Wholesale Petroleum Products Industries Wholesale Petroleum Products Industries Wholesale Food Beverage Drug and Tobacco Industries Wholesale Food Wholesale Confectionery Wholesale Frozen Foods Packaged Wholesale Dairy Products Wholesale Poultry and Eggs Wholesale Fish and Seafood Wholesale Fresh Fruit and Vegetables Wholesale Meat and Meat Products Wholesale Other Foods Wholesale Beverages Wholesale Beverages Wholesale Drugs and Toilet Preparations Wholesale Drugs Wholesale Toilet Soaps and Preparations Wholesale Drug Sundries and Other Drugs and
32. ast updated Field name PAR_COD PAR_NAME UNITS UPLIMIT Total Type Character Character Character Numeric 562 Width 4 25 9 15 54 02 14 94 at 13 48 Dec Fraser PSI Database User s Manual Structure for database Number of data records Field 1 2 Last updated Field name SIC COD INDUSCAT Total Structure for database Number of data records Field NPR Last updated Field name RECORD ID FED FAC PERMIT TYP MANAGER BASIN REGION SUB_BASIN SIC_CODE PROD_CAPAC UNITS MAIL ADDR FACILITY PHONE_NUM FAX_NUMBER CONTACT LEG DESCR NTS NUM UTM ZONE EASTING NORTHING LATITUDE LONGITUDE BC ENV OFF INSP DATE COMMENT UPDATE PER UPDATE DAT CB OCEAN PCB W SECLEAD DF D DF E FISHACT EEM MEAT SICLIST DBF 1247 02 16 94 at Type Width Character 5 Character 100 106 SITE DBF 459 04 28 94 at Type Width Character 6 Character 6 Character 8 Character 50 Character 20 Character 25 Character 20 Character 5 Numeric 8 Character 15 Character 150 Character 50 Character 10 Character 10 Character 20 Character 150 Character 6 Numeric 4 Numeric 10 Numeric 10 Numeric 10 Numeric 10 Character 2 Date 8 Memo 10 Character 25 Date 8 Logical 1 Logical 1 Logical 1 Logical 1 Logical 1 Logical 1 Logical 1 Logical 1 Logical 1 13 15 26 Dec 14 Dec Fraser PSI Database User s Manual 37 MINING Logical 1 38 MINING_R Logica
33. condary Education Post Secondary Non University Education Post Secondary Non University Education University Education University Education Library Services Library Services Museums and Archives Museums and Archives Other Educational Services Other Educational Services Health and Social Service Industries Hospitals General Hospitals Rehabilitation Hospitals Extended Car Hospitals Mental Psychiatric Hospitals Addiction Hospitals Nursing Stations and Outpost Hospitals Children s Paediatric Hospitals Other Specialty Hospitals Other Institutional Health and Social Services Homes for Personal and Nursing Care Homes for Physically Handicapped and or Disabled Homes for Mentally Retarded Homes for Mentally Handicapped and or Disabled Homes for Emotionally Disturbed Children Homes for Alcohol Drug Addicts Homes for Children in Need of Protection Homes for Single Mothers Other Institutional Health and Social Services n e c Non Institutional Health Services Ambulance Services Drug Addiction and Alcoholism Treatment Clinics Health Rehabilitation Clinics i Home Care Services Including Home Nursing Public Health Clinics Community Health Centres Other Non Institutional Health Services Non Institutional Social Services Child Day Care and Nursery School Services Fraser PSI Database User s Manual D 29 EA ERN UN CIN NN aE PE 8642 8643 8644 8645 8
34. d The window contents can be scrolled using the scroll bar indicators on the right hand and bottom window frames or resized by clicking and dragging on the lower right hand corner Zooming to full screen can be accomplished by clicking on the upper right hand corner of the window Push buttons signified onscreen as words enclosed by angle brackets such as lt gt lt lt gt gt Radio buttons and check boxes are signified as and respectively They can be activated using the mouse or the space bar key Radio buttons allow for users to select only one option from several options 1 e checking one option unchecks all other options for an example select Reports from the main menu then Simple Form Reports Check boxes allow users to select multiple options see the Federal Regulatory Instruments screen which is located by first viewing a permit and selecting Federal Instruments within the Site Information screen A checkbox may also trigger the display of other windows e g dialogue boxes such as what occurs when the Federal Instruments checkbox is checked on the Site Information screen Fraser PSI Database User s Manual 4A Popup lists can be activated by clicking anywhere within the popup box A pop up list allows the user to select one item from a list of entries e g sub basin field on the Site Information Screen The menu bar pulldown menu at the top of the screen is activated by clicking
35. d Banks Other Banking Type Intermediaries Trust Companies Trust Companies Deposit Accepting Mortgages Companies Deposit Accepting Mortgage Companies Except Co operatives Co operative Mortgage Companies Credit Unions Local Credit Unions Central Credit Unions Other Deposit Accepting Intermediaries Other Deposit Accepting Intermediaries Consumer and Business Financing Intermediary Industries Consumer Loan Companies Consumer Loan Companies Business Financing Companies Sales Finance Companies Credit Card Companies Factoring Companies Fraser PSI Database User s Manual D 24 BEEEZINPRSUUEDIN PR SS Swa DUM NC T DENN 7124 7125 7129 72 721 7211 7212 7213 7214 7214 722 7221 1222 7229 729 7291 7292 7299 73 731 7311 732 7321 733 7331 7339 74 741 7411 7412 7413 742 7421 743 7431 7432 749 7499 75 751 7511 7512 Financial Leasing Companies Venture Capital Companies Other Business Financing Companies Investment Intermediary Industries Portfolio Investment Intermediaries Investment Mutual Funds Retirement Savings Funds Segregated Funds Investment companies Holding Companies Mortgage Companies Mortgage Investment Companies Teal Estate Investment Trusts Other Mortgage Companies Other Investment Intermediaries Trusteed Pension Funds Estate Trust and Agency Funds Other Investment Intermediaries n e c Insurance Industries
36. d Woven Cloth Industries Other Spun Yarn and Woven Cloth Industries Broad Knitted Fabric Industry Broad Knitted Fabric Industry Textile Products Industry Natural Fibres Processing and Felt Products Industry Natural Fibres Processing and Felt Products Industry Carpet Mat and Rug Industry Carpet Mat and Rug Industry Canvas and Related Products Industry Canvas and Related Products Industry Other Textile Products Industries Narrow Fabric Industry Contract Textile Dyeing and Finishing Industry Household Products of Textile Materials Industry Hygiene Products of Textile Materials Industry Tire Cord Fabric Industry Other Textile Products Industries n e c Clothing Industry Men s and Boy s clothing Industries Men s and Boy s Coat Industry Men s and Boy s Suit and Jacket Industry Men s and Boy s Pants Industry Men s and Boy s Shirt and Underwear Industry Men s and Boy s Clothing Contractors Women s Clothing Industries Fraser PSI Database User s Manual D 8 EE MM 2441 2442 2443 2444 2445 245 2451 249 2491 2492 2493 2494 2495 2496 2499 25 _ 251 2511 2512 252 2521 2522 254 2541 2542 2543 2549 256 2561 258 2581 259 2591 2592 2593 2599 26 261 2611 2612 2619 264 Women s Coat and Jacket Industry Women s Sportswear Industry Women s Dress Industry Women s Blouse and Shirt Industry Women s Clothing Contractors Children s Clothing Industry Children s Clothing Industry Other Cl
37. e Furniture Industries Other Furniture and Fixture Industries Bead Spring and Mattress Industry Hotel Restaurant and Institutional Furniture and Fixture Industry Other Office Furniture Industries n e c Paper and allied Products Industries Pulp and Paper Industries Pulp Industry Newsprint Industry PaperBoard Industry Building Board Industry Other Paper Industries Asphalt Roofing Industry Asphalt Roofing Industry Paper Box and Bag Industries Folding Carton and Set Up Box Industry Corrugated Box Industry Paper Bag Industry Other Converted Paper Products Coated and Treated Paper Industry Stationery Paper Products Industry Paper Consumer Products Industry Other converted Paper Products Industries n e c Printing Publishing and Allied Industries Commercial Printing Industries Business Forms Printing Industry Other Commercial Printing Industries Platemaking Typesetting and Bindery Industry Platemaking Typesetting and Bindery Industry Publishing Industries Book Publishing Industry Other Publishing Industries Combined Publishing and Printing Industries Newspaper Magazine and Periodical Combined Publishing and Printing Industry Other Combined Publishing and Printing Industries Primary Metal Industries Primary Steel Industries Ferro Alloys Industries Steel Foundries Other Primary Steel Industries Steel Pipe and Tube Industry Fraser PSI Database User s Manual D 10 2921 294 2941 295 2951 295
38. en forms a site information screen and an outfall information screen Along with these two screen forms is a control window which is on the right side of the screen It contains push buttons that when selected control the position of the record pointer i e the record pointer points to the active record in the table only one record in a table can be active at any one time Browse windows are available in some of the database forms These windows can be activated or deactivated by clicking on the relevant push button e g The push button Next Page gt located in the controls section of the form screens activates the outfall information screen along with it s associated parameters Note that the parameter information takes the form of a browse window 4 8 1 Navigating Through the Database The user interface of the form screens has been modeled after an actual permit form What this means is that when viewing the site information this is known as page one of the current permit and all subsequent pages would reveal the outfall and parameter information that is associated with the current site The control window on the right hand side of the screen controls the record pointer in the database For example clicking on the lt Next gt push button moves the record pointer to the next permit site in the database while clicking on the Next Page gt push button when in the site information screen brings up that particular site s outfall and
39. er Action Plan an initiative under Canada s Green Plan directs that action be taken to identify and control contaminants entering the Fraser River Basin from point and non point effluent sources The Fraser Point Source Inventory PSI helps to address the need for a geo referenced personal computer based inventory of wastewater sources in the Fraser River Basin Selective data from the B C Ministry of Environment Lands and Parks WASTE permit management system and the Environment Canada Federal Facilities Environmental Activities Database FFEAD is contained in the FR PSI database This is supplemented by data from federal and provincial files and from personal and telephone interviews At the present time only point source site information and permit limits not monitoring data are included Various reports can be performed on the data These reports include summaries of loadings by sub basin region and SIC code The data can also be exported to an ASCII file or DBF file for GIS mapping This database is written in FOXPRO 2 5 mouse is optional but highly recommended It will run on all 640K RAM IBM compatible computers with a colour VGA monitor and a harddrive however the DOS Extended version of the program will only run on 386 and 486 computers with more than 640K memory The information contained in this database represents a best effort to collect compile and summarize the data available from many point sources of wastewa
40. er s Manual 12 SUCEICOEEEURCADPEOONNEENEEICON HELL OI OEC OM CODD CC NN CK Un GA DU IU CIRC CR RM ION CR GONE GRECO MN CS To mark a record for deletion display the record in the window and then press Ctrl D Records can also be deleted by using the Record submenu Pressing Ctrl D a second time recovers the deleted record Note that if a user wishes to delete all the data for a Record ID he she must delete records in all three databases To simplify the process there are functions at the bottom of the Record submenu that allow the user to delete a permit from all three tables or pack all three tables 4 10 Reporting Reports Submenu The reports are grouped according to their functionality and according to the complexity of the report 4 10 1 Setting Printer Driver The user can choose from several pre defined printers such as Postscript Laserjet II and Laserjet III in the reporting dialogue screen that is activated after a user chooses a report type from the Reports submenu The user can also modify the list of printer drivers and set a default driver by choosing the Modify Printer Driver option from the top of the Reports submenu From this dialogue window the user can specify a new printer driver by choosing the New push button 4 10 2 Simple Form Reporting Four types of reports may be produced depending on which database the user chooses as a base They are Site
41. es Wholesale Electrical Wiring Supplies and Electrical Construction Material Wholesale Electrical Generating and Transmission Equipment and Supplies Wholesale Electronic Machinery Equipment and Supplies Wholesale Other Electrical and Electronic Machinery Equipment and Supplies Wholesale Other Machinery Equipment and Supplies Wholesale Office and Store Machinery Equipment and Supplies Wholesale Service Machinery Equipment and Supplies Wholesale Professional Machinery Equipment and Supplies Wholesale Other Machinery Equipment and Supplies n e c Wholesale Other Products Industries Wholesale Waste Materials Wholesale Automobile Wrecking Other Waste Materials Wholesale Paper and Paper Products Wholesale Newsprint Wholesale Stationery and Office Supplies Wholesale Other Paper and Paper Products Wholesale Agricultural Supplies Wholesale Agricultural Feeds Wholesale Seeds and Seed Processing Wholesale Agricultural Chemical and Other Farm Supplies Wholesale Toys Amusement and Sporting Goods Wholesale Toys Novelties and Fireworks Wholesale Amusement and Sporting Goods Wholesale Photographic Equipment and Musical Instruments and Supplies Wholesale Photographic Equipment and Supplies Wholesale Musical Instruments and Accessories Wholesale Jewellery and Watches Wholesale Jewellery and Watches Wholesale Industrial and Household Chemicals Wholesale Industrial and Household Chemicals Wholesale General Merchandise Wholesa
42. esin Industry Pharmaceutical and Medicine Industry Pharmaceutical and Medicine Industry Paint and Varnish Industry Paint and Varnish Industry Soap and Cleaning Compounds Industry Soap and Cleaning Compounds Industry Toilet Preparations Industry Toilet Preparations Industry Other Chemical Products Industries Printing Ink Industry Adhesives Industry Other Chemical Products Industries n e c Other Manufacturing Industries Scientific and Professional Equipment Industries Indicating Recording and Controlling Instruments Industry Other Instruments and Related Products Industry Clock and Watch Industry Fraser PSI Database User s Manual D 14 1 ee eee KG CRM UT OA CIE SUC ER c 3914 Ophthalmic Goods Industry 392 Jewellery and Precious Metal Industries 3921 Jewellery and Silverware Industry 3922 Precious Metal Secondary Refining Industry 393 Sporting Goods and Toy Industries 3931 Sporting Goods Industry 3932 Toys and Games Industry 397 Sign and Display Industry 3971 Sign and Display Industry 399 Other Manufactured Products Industries 3991 Broom Brush and Mop Industry 3992 Button Buckle and Clothes Fastener Industry 3993 Floor Tile Linoleum and Coated Fabric Industry 3994 Musical Instrument and Sound Recording Industry 3999 Other Manufactured Products Industries n e c 4 Building Developing and General Contracting Industries 401 Resident
43. h Character 4 Character 6 Character 2 Numeric 13 Numeric 13 Numeric 13 Character 9 Character 9 Character 20 Character 20 Character 5 Character Numeric 5 Numeric 6 Character 2 Numeric 3 Character 50 Character 50 Numeric 13 Character 10 Numeric 13 Character 10 279 OFFICE DBF 8 05 17 93 at Type Width 2 35 38 DISCLIST DBF 5 Width 1 25 27 LOADTAB DBF 1205 11 17 93 at 13 39 Dec 15 20 Dec eoo a 9 20 Dec Fraser PSI Database User s Manual Structure for database OUTFALL DBF Number of data records Field NFR Last updated Field name RECORD ID WASTE NUM SITE TYPE TREATMENT WASTE TYPE FLOW MAX FLOW AVG UNITS DISCH DUR DISCH TO REC WAT BD UPDATE PER UPDATE DAT Total Type Character Character Character Character Character Numeric Numeric Character Numeric Character Character Character Date 594 04 28 94 at Width 6 2 2 60 1 13 13 8 3 1 25 25 8 168 Structure for database PARAM DBF Number of data records Last updated 04 28 94 at Field 0 AJO Ul b Q N P Field name RECORD_ID WASTE NUM PARAM CODE UNITS TYPE DISCH MIN DISCH MAX DISCH AVG UPDATE PER UPDATE DAT Total e Character Character Character Character Numeric Numeric Numeric Character Date 1209 Width 15 14 Dec 15 14 Dec PRR Structure for database PARTABLE DBF Number of data records Field 1 2 3 4 L
44. halate pus 20000 t N N N e e e Q Q e e amp E Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS E010 Ethyl Dichloride 12 FREP Fluoridat n Indx FLRI Fluoridat n Index 20000 20000 Cn iojo 5 Fluoride Soluble F032 F010 Formaldehyde EF11 Fruit amp Veg Proc n a 20000 10000 Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMIT MS GCMS Scan n a 1292 10 0107 H002 HCSN Hydrocarbon Scan n a mee eoe s 20000 Fe t3 e e lI Q JO l O THEE BR B Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION TS UPPER LIMIT T 1 5 N Q 19 12 5000 O IOO O O Fraser PSI Database User s Manual Paramete
45. ial Building and Development 4011 Single Family Housing 4012 Apartment and Other Multiple Housing 4013 Residential Renovation 402 Non Residential Building and Development 4021 Manufacturing and Light Industrial Building 4022 Commercial Building 4023 Institutional Building 41 Industrial and Heavy Engineering Construction Industries 411 Industrial Construction Other Than Buildings 4111 Power Plants Except Hydroelectric 4112 Gas Oil and Other Energy Related Structures Except Pipelines 4113 Gas and Oil Pipelines 4119 Other Industrial Construction 412 Highway and Heavy Construction 4121 Highways Streets and Bridge 4122 Waterworks and Sewage Systems 4123 Hydroelectric Power Plants and Related Structures Except Transmission Lines 4124 Power and Telecommunication Transmission Lines 4129 Other Heavy Construction 42 Trade Contracting Industries 421 Site Work 4211 Wrecking and Demolition 4212 Water Well Drilling 4213 Septic System Installation 4214 Excavating and Grading Fraser PSI Database User s Manual D 15 4215 4216 4217 4219 422 4221 4222 4223 4224 4225 4226 4227 4229 423 4231 4232 4233 4234 4235 4236 4239 424 4241 4242 4243 4244 425 4251 4252 4253 4254 4255 4256 4259 426 4261 427 4271 4272 4273 4274 4275 Equipment Rental With Operator Asphalt Paving Fencing Installation Other Site Work Structural and Related Work Pile Driving Work Form Work Steel Reinf
46. iance Television Radio and Stereo Repair Shops Household Furnishings Stores Floor Covering Stores Drapery Stores Other Household Furnishings Stores Automotive Vehicles Parts and Accessories Industries Sales and Service Automobile Dealers Automobile new Dealers Automobile Used Dealers Recreational Vehicle Dealers Motor Home and Travel Trailer Dealers Fraser PSI Database User s Manual D 22 6322 6323 6329 633 6331 634 6341 6342 635 6351 6352 6353 6354 6355 6359 639 6391 6399 64 641 6411 6412 6413 65 651 6511 652 6521 6522 653 6531 6532 654 6541 6542 655 655 6552 656 6561 6562 657 Boats Outboard Motors and Boating Accessories Dealers Motorcycle and Snowmobile Dealers Other Recreational Vehicle Dealers Gasoline Service Stations Gasoline Service Stations Automotive Parts and Accessories Stores Home and Auto Supply Stores Tire Battery Parts and Accessories Stores Motor Vehicle Repair Shops Garages General Repairs Paint and Body Repair Shops Muffler Replacement Shops Motor Vehicle Glass Replacement Shops Motor Vehicle Transmission Repair and Replacement Shops Other Motor Vehicle Repair Shops Other Motor Vehicle Services Washes Other Motor Vehicle Services n e c General Retail Merchandising Industries General Merchandise Stores Department Stores General Stores Other General Merchandise Stores Other Retail Stores Industries Book and Statio
47. ield or combination of field controls is necessary for each record in the table For example the Record ID or Record ID and waste number are used to control access to the site outfall and parameter records Users should exercise extreme caution when editing these fields Figure 1 illustrates the database structure of the Fraser PSI system 4 5 Menu Hierarchy A menu bar is a feature of most FOXPRO applications It acts as a pulldown menu which groups related system operations into submenus The menu can be activated by clicking on the menu bar or by pressing Alt the highlighted letter of menu option Figure 2 illustrates the menu hierarchy of the system 4 6 Importing Data File Submenu The system has the capability to import data from the provincial WASTE database The import function prompts the user for the name and path to the file that is to be imported The structure of this import file must conform to a rigid format see Appendix E Caution the import function will overwrite changes made to WASTE data in FR PSI since the last import 4 7 Exporting Data File Submenu Data can be exported to an ASCII or DBF file for use with a GIS system The system prompts the user for the name and path of this export file 921321235 T SITE DATABASE Record ID SIC Code BC Env Office OFFICE TABLE BC Env Office Code SIC CODE TABLE SIC Code OUTFALL D
48. inoleic d Organo Chlorines Organo phosphorus Oxid Red Potential Oxygen Dissolved Ozone 1000000 PCB 1242 0039 0014 3 iO oio o 03 42 e PC48 PCB 1248 PCB 1254 PCB 1260 PCB s Total 54 PC60 Q O PA03 Palmitic 10000 Parathion 20000 P002 Parathion Methyl 20000 003K Size 10 Mesh 003C Part Size 100 Mesh 0030 Part Size 140 Mesh 0033 Part Size 16 Mesh 003E Size 200 Mesh 003L Part Size 230 Mesh Part Size 270 Mesh 003A Part Size 30 Mesh Part Size 32 Mesh 003I Fraser PSI D atabase User s Manual Parameter Table 003G 003M 003B 003J 003H 003N P022 P050 PEST EF24 H009 0146 15 0117 P003 P04A 4 1118 1118 0118 DESCRIPTION UNITS Part Size 400 Mesh Part Size 4000 Mesh Part Size 50 Mesh N N IN Par sezo Perchloroethylene Pea amp Phosmet __ m Phosphate Soluble Phosphor Orth Dis LL mgL Phosphorous Ort DisP m Phosphorous O
49. l the access to different database functions Currently there are 3 security levels for the database 9 7 5 The top security level allows a user unrestricted access to the database The second level permits the user to do anything except add new users and modify passwords The third level restricts the user to viewing the data only and will not permit him her to edit the data Users ID s and passwords are maintained through the System Administration menu bar in the Maintenance sub menu Passwords can only be changed by typing in the old password first Fraser PSI Database User s Manual Note The low level access that most users are provided with only gives them access to viewing and reporting functions as well code tables in the Maintenance submenu may be viewed but not edited The system will not allow changes made to the fields to be saved 4 4 Database Structure There are three main databases site outfall and parameter They are organized in a relational database format This serves to minimize database redundancy There are also various code tables that store information about different codes in the site outfall and parameter tables For example the parameter codes table contains the parameter code the full name for the parameter the units that the parameter should be in and the upper limit for the parameter Each of these tables is indexed The indices speed up the time that it takes to access a record unique f
50. l 1 39 Logical 1 40 PETROL_G Logical 1 41 Logical 1 42 POTATO Logical 1 43 Logical 1 44 CCA Logical 1 45 Logical 1 46 CREOSOTE Logical 1 47 MARINA Logical 1 48 _ Logical 1 49 PCP W Logical 1 50 FREGS Logical 1 51 FILE NUMB Character 16 Total 696 Structure for database SITETYPE DBF Number of data records 22 Last updated 12 14 93 at Field Field name Width 1 SIT TYP Character 2 2 SIT DESC Character 25 Total 28 Structure for database WASLIST DBF Number of data records 5 Last updated 12 15 93 at Field Field name Width 1 WAS Character 1 2 WASDESC Character 25 Total 27 9 41 Dec 14 02 Dec Appendix Coding Source Fraser PSI Database User s Manual Table 1 Origin of data and codes Variable Name FR PSI WASTE FFEAD Record Id Facilit Sub basin SIC Code Production Capacit Production Units Mailing Address Location Phone Number Fax Number Contact Name Legal Address NTS Mapsheet UTM Zone UTM Easting UTM Northing Latitude Longitude MELP Office Federal Facilit Number Federal Regulations Fraser PSI Database User s Manual FR PSI WASTE FFEAD Variable Name Date of Last Update X WASTE Number xo mua _________ DischargeTo 0 Appendix D Lookup Tables Fraser PSI Database User s Manual D 1 Table 1 Sub ba
51. le General Merchandise Wholesale Other Products n e c Wholesale Books Periodicals and Newspapers Wholesale Second Hand Goods Wholesale Except Machinery and Automotive Forest Products Wholesale Fraser PSI Database User s Manual D 21 5999 60 601 6011 6012 602 6021 6022 6023 603 6031 6032 61 611 6111 612 6121 613 6131 614 6141 615 6151 62 621 6211 6212 6213 622 6221 6222 6223 623 6231 6232 6239 63 631 6311 6312 632 6321 Other Products n e c Wholesale Food Beverage and Drug Industries Retail Food Stores Food Groceries Stores Food Specialty Stores Liquor Wine and Beer Stores Liquor Stores Wine Stores Beer Stores Prescription Drugs and Patent Medicine Stores Pharmacies I Patent Medicine and Toiletries Stores Shoe Apparel Fabric and Yarn Industries Retail Shoe Stores Shoe Stores Men s Clothing Stores Men s Clothing Stores Women s Clothing Stores Women s Clothing Stores Clothing Stores n e c Clothing Stores n e c Fabric and Yarn Stores Fabric and Yarn Stores Household Furniture Appliances and Furnishings Industries Retail Household Furniture Stores Household Furniture Stores With Appliances and Furnishings Household Furniture Stores Without Appliances and Furnishings Furniture Refinishing and Repair Shops Appliance Television Radio and Stereo Stores Appliance Television Radio and Stereo Stores Television Radio and Stereo Stores Appl
52. lumbing Heating and Building Materials Industries Wholesale Metal and Metal Products Wholesale gt Iron and Steel Primary Forms and Structural Shapes Wholesale Other Iron and Steel Products Wholesale Non ferrous Metal and Metal Products Wholesale Combination Metal and Metal Products Hardware and Plumbing Heating and Air Conditioning Equipment and Supplies Wholesale Hardware Wholesale Plumbing Heating and Air Conditioning Equipment and Supplies Wholesale Lumber and Building Materials Wholesale Lumber Plywood and Millwork Wholesale Paint Glass and Wallpaper Wholesale Other Building Materials Wholesale Machinery Equipment and Supplies Industries Wholesale Farm Machinery Equipment and Supplies Wholesale Farm Machinery Equipment and Supplies Wholesale Construction Forestry and Mining Machinery Equipment and Supplies Wholesale Fraser PSI Database User s Manual D 20 a a ee 5721 5722 573 5731 574 5741 5742 5743 5749 579 5791 5792 5793 5799 59 591 5911 5919 592 5921 5922 5929 593 5931 5932 5939 594 5941 5942 595 5951 5952 596 5961 597 5971 598 5981 599 5991 5992 5993 Construction Forestry Machinery Equipment and Supplies Wholesale Mining Machinery Equipment and Supplies Wholesale Industrial Machinery Equipment and Supplies Wholesale Industrial Machinery Equipment and Supplies Wholesale Electrical and Electronic Machinery Equipment and Suppli
53. n of loadings because flow and discharge information are in separate records in the same file also the calculation of loadings results in redundant information in the database because it is a single file database Another disadvantage to the system is that facilities that are regulated federally are generally not included in the provincial database unless they have a provincial permit Therefore the need the FR PSI database was recognized in order to provide a PC based geo referenced database to allow for flexibility in analysis and reporting of information on point sources of wastewater discharges in the Fraser River Basin The PSI database has a relational 1 e multi file structure which ensures that redundant data is minimized The site flow outfall and permit allowance data is maintained in separate files tables This simplifies the calculation of parameter loadings Data from Environment Canada s FFEAD database supplemented by information provided by federal government departments is also maintained in the database 3 0 Installing the System The system needs about 6 Megabytes of disk space and also requires a setting of FILES 50 in the CONFIG SYS file see your resident computer expert about how to modify this setting Insert Fraser Installation Disk 1 into drive A If you are installing from another drive adjust the instructions accordingly Type the following at the DOS prompt and press Enter after each line
54. nery Stores Book and Stationery Stores Florists Lawn and Garden Centres Florist Shops Lawn and Garden Centres Hardware Paint Glass dan Wallpaper Stores Hardware Stores Paint Glass and Wallpaper Stores Sporting Goods and Bicycle Shops Sporting Goods Stores Bicycle Shops Musical Instrument and Record Stores Musical Instrument Stores Record and Tape Stores Jewellery Stores and Watch and Jewellery Repair Shops Jewellery Stores Watch and Jewellery Repair Shops Camera and Photographic Supply Stores Fraser PSI Database User s Manual D 23 6571 658 6581 6582 659 6591 6592 6593 6594 6595 6596 6597 6598 6599 69 691 6911 692 6921 70 701 7011 702 7021 7029 703 7031 704 7041 7042 705 7051 7052 709 7099 71 711 7111 712 7121 7212 7213 Camera and Photographic Supply Stores Toy Hobby Novelty and Souvenir Stores Toy and Hobby Stores Gift Novelty and Souvenir Stores Other Retail Stores Second Hand Merchandise Stores n e c Opticians Shops Art Galleries and Artists Supply Stores Luggage and Leather Goods Stores Monument and Tombstone Dealers Pet Stores Coin and Stamp Dealers Mobile Home Dealers Other Retail Stores n e c Non Store Retail Industries Vending Machine Operators Vending Machine Operators Direct Sellers Direct Sellers Deposit Accepting Intermediary Industries Central Bank Central Bank Chartered Banks and Other Banking Type Intermediaries Chartere
55. nly Press ESC to abort selection of a lookup value The SIC code and BC environment office fields are linked to code tables which lookup the appropriate code name for each relevant code number See Appendix D Table 3 for the B C MELP office codes and descriptions and see Table 4 for the Standard Industry Category codes and descriptions 4 8 4 Outfall Data Screen The combination of Record ID and waste number is unique for each outfall A single site may have multiple outfalls The discharge to wastewater type and site type fields are linked to code tables which lookup the appropriate code name for each relevant code number See Appendix D Table 5 for the B C MELP discharge to codes and descriptions see Table 6 for the B C MELP waste type codes and descriptions and see Table 7 for the B C MELP site type codes and descriptions Fraser PSI Database User s Manual 10 4 8 5 Parameter Data Screen The combination of Record ID waste number and parameter code is unique for each parameter A single outfall may have multiple parameters The parameter code field is linked to a code table which looks up the appropriate code name for each relevant code number See Appendix D Table 8 for the parameter codes descriptions units and upper limits The parameter data screen contains parameter limits information about each discharge Pressing the F2 key while the cursor is in the parameter code or parameter name field activates a looku
56. ntal to Fishing Services Incidental to Fishing Trapping Furs and Skins Wild Other Trapping Logging Industry Logging Industry Logging Industry Forestry Services Industry Forestry Services Industry Forestry Services Industry Mining Industries Metal Mines Gold Mines Copper and Copper Zinc Mines Nickel Copper Mines Silver Lead Zinc Mines Molybdenum Mines Uranium Mines Iron Mines Other Metal Mines Non Metal Mines Except Coal Asbestos Mines Peat Industry Fraser PSI Database User s Manual VOEE E I gS I Potash Mines Salt Mines Other Non Metal Mines Except Coal Coal Mines Bituminous Coal Mines Subbituminous Coal Mines Lignite Mines Crude Petroleum and Natural Gas Industries Crude Petroleum and Natural Gas Industries Conventional Crude Oil and Natural Gas Industry Non Conventional Crude Oil Industry Quarry and Sand Pit Industries Stone Quarries Granite Quarries Limestone Quarries Marble Quarries Sandstone Quarries Shale Quarries Sand and Gravel Pits Sand and Gravel Pits Service Industries Incidental to Mineral Extraction Service Industries Incidental to Crude Petroleum and Natural Gas Contract Drilling Oil and gas Industry Other Service Industries Incidental to Crude Petroleum and Natural Gas Service Industries Incidental to Mining Contract Drilling Industry Except Oil and Gas
57. olations have no meaning outside the planning context The following formulas are used for the loading calculations Allowable Daily Loading Maximum Concentration Limit Maximum Flow Rate Allowable Annual Loading Allowable Daily Loading Days of Discharge per Year 4 11 Maintenance Submenu The maintenance submenu allows the user to browse the system code tables for parameter names site types etc Press ESC or click on the upper left hand corner of the browse window to close the window Fraser PSI Database User s Manual 14 The system administrator can also maintain code tables using Browse submenu that is activated when an option is selected from the Maintenance submenu Memo fields are edited by double clicking on the word Memo in the browse view Records can also be deleted and added from the Browse submenu The list of users can be maintained using the Administration submenu option Click on the relevant push button to scroll through the list of users Passwords can only be changed by entering in the old password first New users are given a password of blank i e just a carriage return which must be changed by the system administrator 4 12 Exiting the System The system can be exited by choosing the Quit option from the File submenu 5 0 Maintaining the Database 5 1 Updates to the System Updates to the database should be controlled by one person Thi
58. on Other Trade Work n e c Service Industries Incidental to Construction Project Management Construction Project Management Construction Other Services Incidental to Construction Land Developers Other Services Incidental to Construction n e c Transportation Industries 1 Air Transport Industries Scheduled Air Transport Industry Non Scheduled Air Transport Chartered Industry Non Scheduled Air Transport Specialty Industry Service Industries Incidental to Air Transport Airport Operations Industry Aircraft Rental Industry Aircraft Servicing Industry Other Service Industries Incidental to Air Transport Railway Transport and Related Service Industries Railway Transport Industry Service Industry Incidental to Railway Transport Water Transport Industries Freight and Passenger Water Transport Industry Ferry Industry Marine Towing Industry Ship Chartering Industry Other Water Transport Industries Service Industries Incidental to Water Transport Marine Cargo Handling Industry Harbour and Prot Operation Industry Marine Salvage Industry Piloting Service Water Transport Industry Marine Shipping Agencies Industry Other Service Industries Incidental to Water Transport Truck Transport Industries Fraser PSI Database User s Manual D 17 4561 4562 4563 4564 4565 4569 457 4571 4572 4573 4574 4575 458 4581 4589 459 4591 4592 4599 46 461 4611 4612 4619 47 471 4711 479 4791 4799 48 481 4811
59. on Taxation Administration Intergovernmental Affairs Administration Other General Administrative Services Human Resource Administration Health Administration Social Service Administration Education Administration Recreation and Culture Administration Economic Services Administration _ Transportation and Communication Administration Resource Conservation and Industrial Development Administration Environment Administration Housing Administration Regional Planning and Development Administration Research Administration Provincial and Territorial Government Service Industries Protective Services Courts of Law Correctional Services Police Services Firefighting Services Regulatory Services Other Protective Services Labour Employment and Immigration Services Labour and Employment Services General Administrative Services Executive and Legislative Administration Finance and Economic Administration Taxation Administration Fraser PSI Database User s Manual D 27 a eom REQUE SC YXE SCORE HEC AE mE TUNER SP Intergovernmental Affairs Administration Other General Administrative Services Human Resource Administration Health Administration Social Service Administration Education Administration Recreation and Culture Administration Economic Services Administration Transportation and Communication Administration Resource Conservation and Industrial Development Administration Environment
60. oq FEIRA anon 791493 25019 UIOS uoneunojur s Qm PP ui poak poah Pei ind iq pp pm H T i Biochemical t tachloroph 9 Suion S Sun m m ers 4 e Qu ps e S b n Field Selection 2 3 Region Sub Basin Industry Code Industry Env Office Manager Advanced Record Selection For Expression Builder lt Cleax 0115 lt 1 gt Appendix B System Structure Fraser PSI Database User s Manual Structure for database Number of data records Field 1 2 Last updated Field name DISC TO DISCDESC Total Structure for database Type Character Character Number of data records Field Nr Last updated Field name PARAM CODE RECORD_ID WASTE NUM DISCH MAX FLOW MAX FLOW AVG UNITS TYPE UNITS SUB BASIN REGION SIC CODE BC ENV OFF LATITUDE LONGITUDE DISCH TO DISCH DUR FACILITY MANAGER DAI LOAD D LD UNITS ANN LOAD A LD UNITS Total Structure for database Number of data records Last updated Field Field name 1 2 ENV OFF Character OFFICE NAM Character Total 04 28 94 at Type Widt
61. or defaults to an equals which can be changed Note for string comparisons a double equals represents an exact match while a single equals represents a partial string match 4 10 3 Custom Reporting Provides client with the flexibility of designing their own tabular reports Users can specify the contents of the reports by selecting a database and then the desired fields The user determines the order of the columns on the report by the sequence in which they select or de select the fields See section 4 10 2 2 for detailed description of how to use the filter conditions Note when a filter is selected through custom reporting it appears as a header to all pages of the report _ 4 10 4 Loading Calculations A note of caution concerning the loading calculation and reports require emphasis The loading calculation module was developed to assist the planning process and to facilitate gross comparisons between regions or industrial sectors FR PSI does not include actual monitoring data In practice flows and concentrations are probably lower than Permit levels used in the loading calculation Loading values reported by the database should not be considered as a quantitative measure of actual pollutant loadings in the Basin nor as a substitute for wastewater monitoring or characterization studies The database loadings are to be used only to give a ball park idea of the total authorized loadings of permitted parameters Such extrap
62. orcing Concrete Pouring and Finishing Precast Concrete Installation Rough and Framing Carpentry Structural Steel Erection Other Structural and Related Work Exterior Close in Work Masonry Work Siding Work Glass and Glazing Work Insulation Work Roof Shingling Sheet Metal and Built up Roofing Other Exterior Close In Work Plumbing Heating and Air Conditioning Mechanical Work Plumbing Dry Heating and Gas Piping Work Wet Heating and Air Conditioning Work Sheet Metal and Other Duct Work Mechanical Specialty Work Process Piping Work Automatic Sprinkler System Installation Commercial Refrigeration Work _ Environmental Control Work Millwright and Rigging Thermal Insulation Work Other Mechanical Specialty Work Electrical Work Electrical Work Interior and Finishing Work Plastering and Stucco Work Drywall Work Acoustical Work Finish Carpentry Painting and Decorating Work Fraser PSI Database User s Manual D 16 4276 4271 4278 4279 429 4291 4292 4293 4299 44 441 441 449 4491 4499 45 451 4511 4512 4513 452 4521 4522 4523 4529 453 4531 4532 454 4541 4542 4543 4544 4549 455 4551 4552 4553 4554 4555 4559 456 Terrazzo and Tile Work Hardwood flooring Installation Resilient Flooring and Carpet Work Other Interior and Finishing Work Other Trade Work Elevator and Escalator Installation Ornamental and Miscellaneous Fabricated Metal Residential Swimming Pool Installati
63. othing and Apparel Industries Sweater Industry Occupational Clothing Industry Glove Industry Hosiery Industry Fur Goods Industry Foundation Garment Industry Other Clothing and Apparel Industries n e c Wood Industries Sawmill Planing Mill and Shingle Mill Products Shingle and Shake Industry Sawmill and Planing Mill Products Industry Except Shingle and Shakes Veneer and Plywood Industries Hardwood Veneer and Plywood Industries Softwood Veneer and Plywood Industries Sash Door and Other Millwork Industries Prefabricated Wooden Buildings Industry Wooden Kitchen Cabinet and Bathroom Vanity Industry Wooden Door and Window Industry Other Millwork Industries Wooden Box and Pallet Industry Wooden Box and Pallet Industry Coffin and Casket Industry Coffin and Casket Industry Other Wood Industries Wood Preservation Industry Particle Board Industry Wafer Board Industry Other Wood Industries n e c Furniture and Fixture Industries Household Furniture Industries Wooden Household Furniture Industry Upholstered Household Furniture Industry Other Household Furniture Industries Office Furniture Industries Fraser PSI Database User s Manual 2641 2649 269 2691 2692 2699 27 271 2711 2712 2713 2714 2719 272 2721 273 2731 2732 2733 279 2791 2792 2793 2799 28 281 2811 2819 282 2821 283 2831 2839 284 2841 2849 29 291 2911 2912 2919 292 Metal Office Furniture Industry Other Offic
64. p table Entries can be selected from this lookup table by pressing Enter The user can also edit the lookup search string displayed at the top of the lookup window The user should note that the system will search by both parameter code and parameter name Press ESC to abort selection of a lookup value Each parameter in the parameter lookup table is associated with a units field The units field contains a string defining the units assigned to each parameter in the parameter table The unit type is defaulted for any new parameter entered 4 8 6 Changes to the Data The user is not permitted to save changes to the database from within the View submenu Although the View submenu functions similar to the Edit submenu changes to the database fields cannot be saved The Save push button is never active 4 9 Editing Data Edit Submenu This section provides instructions on how to add edit and delete records For help on browsing and navigating through the database see Section 4 8 The edit submenu allows the user to edit each of the individual database files The system displays these files on a screen form When a record is initially displayed the Save and Cancel push buttons are disabled If the user makes a change to a field in the database these push buttons are enabled and the control window is disabled After the user has changed all the fields he she wants to change then he she must explicitly save these changes or discard
65. parameter information Note permit consists of a site that may have one or more outfalls and each outfall may have zero or more parameters The Locate push button on the control window allows the user to jump quickly to a record in the database To activate the Locate function the user must define an expression in the window that opens such as Record ID gt P00100 or Sub basin Lower Fraser Note that this search function is case sensitive The user must then click on the Add push button and then the lt Search Browse gt push button to see the records that match the selection criteria The user can then click on a record in the Browse window and then click on the window close icon in the upper left hand corner of the Browse window followed by clicking on the lt Exit gt push button in order to view the record The lt Q Find gt allows the user to skip to a record by specifying the Record ID or a string within the manager field i e Typing Bloedel will find the next record of Macmillan Bloedel Note that the system searches forward through the database to allow successive records to be found with the same string Press the push button before lt Q Find gt if finding the first record with a particular string is desired otherwise only records with a higher index number in the database will be located Fraser PSI Database User s Manual 9 SS a va ae SPIRE I ELLE SE UN
66. permit wording and layout should be standardized to make it easier to validate the permit data in a database against the paper permit Parameter discharge limits should be specified in standardized units Exact locations of each outfall should be permits Fraser PSI Database User s Manual i 16 TE A y E ER KK aqu ami Regular Backups of Data Regular backups of data should be done as well as recording of all edits in a paper transaction log Strict adherence to these procedures will ensure that no data is lost in the event of a major system crash e Checking with Monitoring Data Data from FR PSI system should be cross referenced to monitoring data periodically to aid in highlighting data input errors and other discharge inconsistencies Conversion to FOXPRO Windows Version The system should be converted to run under Windows 3 1 Many users are familiar with Windows and they will be able to learn the system more easily than the current DOS version Appendix Screen Snapshots Note These screen snapshots reflect the current screens of the system at the time of printing 2 Sd 195214 usas Sutued 5 2222 SIA EDN screen of the Fraser PSI program gt Figure 3 Selecting an option from the pulldown menu 1991056 ous
67. r Table CODE DESCRIPTION UNITS UPPER LIMIT M029 rs RE Mg T Magnesium E NET NI T Manganese m gt Manganese Dissolved __ Manganese Extractable pra enema usss Hel Mercury Insoluble He s Mercury souble wt Mercuy TistStep EP22 Metal Ores Proces _ MOIS 1000 amp Q D gt o e O lI O B p B 000 1 5 5 8 amp gt Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMIT T e e SS S gt R IEE JEJE E E JEJER Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER E TIEREN COME 1108 Nitrogen Amm Diss 0108 Nitrogen Amm Total i 3 amp un P 500 1114 Nitrogen Diss 200 ox 5000 Odour 0003 Ol amp Grene m 8 3 Un 5 2000 Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION FA04 OCPS OPPS Oleic L
68. rtho Phosphorous Peroxide usnu C om E E JE E JE 10000 Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNI PP S Phosphorous Tot Sol PPSA Phosphorous Tot Sol A P D Phosphorous Tot Diss P T Phosphorous Total PP T Phosphorous Total A pons 10000 8 B P007 Butoxide 5 Placer Gold Gravel Wsh EF23 Plywood amp Veneer PAH Polychlo Hydrocarbon m K S 0470 Production Quant f pors 1 PAIS g 500 50 500 500 500 023 Polychlor Biphenyls Ras Ratio Alk vs Cond EF20 0007 Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER F Res Fixed Filterable 007H Res Fixed Filterable T WEP TT T2 50 e Lr eee 10000 Se D Selenium Dissolved Selenium Extractable EF03 Septic Tank Pumb STP Sidg EFO2 Septic Tank Effluent 0023 Settleable Solids 20000 10000 10000 n a n a 1 Sewage Sludge n a 0120 1120 Silica Reactive Diss 3000 2000 Un Un re g L 8 s N e io Q 12012 Fraser PSI Database User s Manu
69. rve Laundries and or Dry Cleaners Valet Services Pressing and or Repair Linen Supply Carpet Cleaning Other Laundry and Dry Cleaning Services Funeral Services Funeral Homes Cemeteries and Crematoria Private Households Private Households Other Personal and Household Services Shoe Repair Fur Cleaning Repair and Storage Other Personal and Household Services n e c Membership Organization Industries Religious Organizations Religious Organizations Business Associations Business Associations Professional Membership Associations Professional Health and Social Service Membership Associations Other Professional Membership Associations Fraser PSI Database User s Manual D 32 984 984 986 9861 99 991 9911 9912 9913 9919 992 9921 993 9931 994 9941 9942 9949 995 9951 9952 9953 9959 996 9961 9962 999 9991 9999 NC02 NC03 NC04 NC05 NC06 NC07 NC08 NC09 NC10 NC11 Labour Organizations Labour Organizations 5 Civic and Fraternal Organizations Civic and Fraternal Organizations Other Service Industries Machinery and Equipment Renting and Leasing Services Industrial Machinery and Equipment Rental and Leasing Audio Visual Equipment Rental and Leasing _ Office Furniture and Machinery Rental and Leasing Other Machinery and Equipment Rental and Leasing Automobile and Truck Rental and Leasing Services Automobile and Truck Rental and Leasing Services Photographers Photographers Other
70. s Ti D Titanium Dissolved ai un T010 Toluenedisocyanate 500 Total Reduced Sulfur Tricglorophenoi2 3 5 20000 027 Trichlorobenzene 14 _____ 50 T040 Trichloroethane we 5 M040 Trichlorofluorometha 5 ehl 00 00 00 Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMIT 50 50 5 1021 Trichlorophenols 5 lojo T031 Trichlorpyr 500 1019 Trichlorsyringols 500 V D VOC Volatile Org Cmp 0041 50 50 wa e bq L ntu n a 5000 1000 2000 1000 20000 20000 50000 1000 Fraser PSI Database User s Manual Parameter Table CODE DESCRIPTION UNITS UPPER LIMIT Zinc Dissolved Zn E Zinc Extractable Zinc I Ist Step Zn I Zinc S 1st Step Zinc Soluble Zinc T HV Step A Zirconium Zirconium Dissolved alpha Chlordane gamma Chlordane pH rain Zinc Insoluble Domestic Sewage Appendix Import File Format Fraser PSI Database User s Manual Structure for database Number of data records nj m OA n ib Q N Last updated Field name PER_NO PER VER REG COD OFF COD DIS COD FIL TYP WAS TYP FIL STA EXP DAT CLI NAM LOCAT LEG ADD MAI ADD PHO NUM FAX NUM NTS NUM LONG SIC COD PROD CA
71. s is the only way to ensure that editing is done on a thorough and consistent basis 5 2 Backing Up the System This must be done on a regular basis in case the database is corrupted The seven main files to backup are SITE DBF SITE CDX SITE FPT OUTFALL DBF OUTFALL CDX PARAM DBF and PARAM CDX A paper transaction log must be used to record all changes to the database that are made between system backups From the main menu select Maintenance then Backup Databases This will pk zip the aforementioned databases to a file located in the fraser directory named Backup zip It is recommended that you copy this file to diskette Note when you do another backup it will overwrite the old backup zip file with the new backup zip file 5 3 User ID and Password Maintenance User ID s are maintained by choosing the system administration security access level The three security levels recognized by the system are 9 high level access 7 editing is permitted but not password maintenance and 5 no editing allowed Fraser PSI Database User s Manual 15 Se gt ____ ______ ___ ____ IN BOR LEE 262 902 FERME ATARI RC un oorr ccc M ION NERA EEE 6 0 System Limitations The accuracy of the reports in the system is only as good as accuracy of the data that the reports are derived from Please read section 4 10 3 carefully concerning the interpretation of loading calculations 7 0 Summary and Recommendations The Fraser River P
72. sin watershed codes and descriptions Dl gr m Lo __________ c North Thompson 5 0 0 7 _________ cuci _ 9 quent Loos NUS EN Table 2 Region codes descriptions and the associated sub basin Region Table Fraser PSI Database User s Manual D 2 Table 3 B C MELP office codes and descriptions BC Environment Office Table CODE LOCATION Vancouver Island Nanaimo e o Lower Mainland Surrey 0 Southern Interior Kamloops Kootenay Nelson 50 Northern Interior Williams Lake Skeena Smithers 0 Northern Interior Prince George Southern Interior Penticton Fraser PSI Database User s Manual D 3 Table 4 Site industry codes and descriptions SIC Table CODE DESCRIPTION 01 Agricultural Industries 011 Livestock farms 0111 Dairy Farms 0112 Cattle Farms 0113 Hog Farms 0114 Poultry and Egg Farms 0115 Sheep and Goat Farms 0119 Livestock Combination Farms 012 Other Animal Specialty Farms 0121 Honey and Other Apiary Product Farms 0122 Horse and Other Equine Farms 0123 Furs and Skins Ranch 0129 Other Animal Specialty Farms n e c 013 Field Crop Farms 0131 Wheat Farms 0132 Small Grain Farms Except Wheat 0133 Oilseed Farms Except Corn 0134 Grain Corn Farms 0135 Forage Seed and Hay Farms 0136 Dry Field Pea and Bean Farms 0137 Tobacco Farms 0138 Potato Farms 0139 Other Field Crop Farms 01
73. ter discharges in the Fraser River Basin Any errors or omissions are not intentional The database is designed to be updated periodically by the Fraser Pollution Abatement Office as changes in permits occur Questions or comments regarding this database are welcomed and should be addressed to the Fraser Pollution Abatement Office at the following address Environmental Protection Environment Canada 224 West Esplanade Avenue North Vancouver B C V7M 3H7 Telephone 604 666 3487 Facsimile 604 666 7294 Fraser PSI Database User s Manual 2 2 0 Background The provincial WASTE management system is single file flat file VAX based database that contains data on all the wastewater discharge permits that are administered by the Environmental Protection Division of the B C Ministry of Environment Lands and Parks There is a record in the WASTE database for each parameter that is regulated in each permit The permit allowances are specified by parameter code permit number and waste outfall number Permit allowances are specified as a maximum or typical discharge of a particular parameter Flow rates are also specified for each outfall These flow rates are specified as an additional parameter record for each unique combination of permit number and waste outfall number The WASTE system database structure does not allow for easy calculatio
74. tric Lighting Industries Lighting Fixture Industry Electric Lamp and Shade Industry Except Bulb and Tube Electric Lamp Bulb and Tube Industry Record Player Radio and Television Receiver Industry Record Player Radio and Television Receiver Industry Communication and Other Electronic Equipment Industries Telecommunication Equipment Industry Electronic Parts and Components Industry Other Communication and Electronic Equipment Industries Office Store and Business Machine Industries Electronic Computing and Peripheral Equipment Industry Electronic Office Store and Business Machine Industry Other Offices Store and Business Machine Industries Electrical Industrial Equipment Industries Electrical Transformer Industry Electrical Switchgear and Protective Equipment Industry Other Electrical Industrial Equipment Industries Communications and Energy Wire and Cable Industry Communications and Energy Wire and Cable Industry Other Electrical Products Industries Battery Industry Non Current Carrying Wiring Devices Industry Other Electrical Products Industries n e c Non Metallic Mineral Products Industries Clay Products Industries Clay Products Industry From Domestic Clay Clay Products Industry From Imported Clay Hydraulic Cement Industry Hydraulic Cement Industry Concrete Products Industries Concrete Pipe Industry Structural Concrete Products Industry Other Concrete Products Industries Ready Mix Concrete Industry Ready
75. ts Industry Motor Vehicle Industry Motor Vehicle Industry Truck and Bus Body and Trailer Industries Truck and Bus Body Industry Commercial Trailer Industry Non Commercial Trailer Industry Mobile Home Industry Motor Vehicle Parts and Accessories Industries Motor Vehicle Engine and Engine Parts Industry Motor Vehicle Wiring Assemblies Industry Motor Vehicle Stampings Industry Motor Vehicle Steering and Suspension Parts Industry Motor Vehicle Wheel and Brake Industry Plastic Parts and Accessories for Motor Vehicles Industry Motor Vehicle Fabric Accessories Industry Other Motor Vehicle Accessories Parts and Assemblies Industries Railroad Rolling Stock Industry Railroad Rolling Stock Industry Shipbuilding and Repair Industry Shipbuilding and Repair Industry Boatbuilding and Repair Industry Boatbuilding and Repair Industry Other Transportation Equipment Industries Other Transportation Equipment Industries Electrical and Electronic Products Industries Small Electrical Appliance Industry Small Electrical Appliance Industry Fraser PSI Database User s Manual D 12 332 3321 333 3331 3332 3333 334 3341 3335 3351 3352 3359 336 3361 3362 3369 337 3371 3372 3379 338 3381 339 3391 3392 3399 35 351 3511 3512 352 3521 354 3541 3542 3549 355 3551 356 3561 3562 357 Major Appliance Industry Electric and Non Electric Major Appliance Industry Electric and Non Electric Elec
76. ty Promotion Associations and Agencies Health Care Standards Agencies Health Care Research Agencies Social Service Planning and Advocacy Agencies Other Health and Social Service Associations and Agencies Accommodation Service Industries Hotels Motels and Tourist Courts Fraser PSI Database User s Manual D 30 9111 9112 9113 9114 912 9121 913 9131 914 9141 9149 92 921 9211 9212 9213 9214 922 9221 96 961 9611 9612 9613 9614 9619 962 9621 9622 9629 963 9631 9639 964 9641 9642 9643 9644 965 9651 9652 9653 Hotels and Motor Hotels Motels Tourist Courts and Cabins Guest Houses and Tourist Homes Lodging Houses and Residential Clubs Lodging Houses and Residential Clubs Camping Grounds and Travel Trailer Parks Camping Grounds and Travel Trailer Parks Recreation and Vacation Camps Outfitters Hunting and Fishing Camps Other Recreation and Vacation Camps Food and Beverage Service Industries Food Services Restaurants Licensed Restaurants Unlicensed Including Drive Ins Take out Food Services Caterers Taverns Bars and Night Clubs Taverns Bars and Night Clubs Amusement and Recreational Service Industries Motion Picture Audio and Video Production and Distribution Motion Picture and Video Production Motion Picture and Video Distribution Motion Picture Laboratories and Video Production Facilities Sound Recording Services Other Motion Picture Audio and Video Services Motion
77. ucts Industry Brewery Products Industry Brewery Products Industry Wine Industry Wine Industry Tobacco Products Leaf Tobacco Industry Leaf Tobacco Industry Tobacco Products Industry Tobacco Products Industry Rubber Products Industries Tire and Tube Industry Tire and Tube Industry Rubber Hose and Belting Industry Rubber Hose and Belting Industry Other Rubber Products Industries Other Rubber Products Industries Plastic Products Industries Foamed and Expanded Plastic Products Industry Foamed and Expanded Plastic Products Industry Plastic Pipe and Pipe Fittings Industry Fraser PSI Database User s Manual D 7 1621 163 1631 169 1691 1699 17 171 1711 1712 1713 1719 18 181 1811 182 1821 1829 183 1831 19 191 1911 192 1921 193 1931 199 1991 1992 1993 1994 1995 1999 24 243 2431 2432 2433 2434 2435 244 Plastic Pipe and Pipe Fittings Industry Plastic Film and Sheeting Industry Plastic Film and Sheeting Industry Other Plastic Products Industries Plastic Bag Industry Other Plastic Products Industries n e c Leather and Allied Products Industries Leather and Allied Products Industries Leather Tanneries Footwear Industry Luggage Purse and Handbag Industry Other Leather and Allied Products Industries Primary Textile Industries Man Made Fibre and Filament Yarn Industry Man Made Fibre and Filament Yarn Industry Spun Yarn and Woven Cloth Industries Wool Yarn an

I 1 - Simon Fraser University

Contents

Download Pdf Manuals

Related Search

Related Contents