Loading...
98-17 Resolution No. 98-17 RESOLUTION AUTHORIZING EXECUTION OF AN AGREEMENT WITH CAMP DRESSER & McKEE, INC. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF ELGIN, ILLINOIS, that Joyce A. Parker, City Manager, and Dolonna Mecum, City Clerk, be and are hereby authorized and directed to execute an agreement on behalf of the City of Elgin with Camp Dresser & McKee, Inc. for the development of an Automated Mapping/Facilities Management/Geographic Information System for the city' s water distribution system, a copy of which is attached hereto and made a part hereof by reference. s/ Kevin Kelly Kevin Kelly, Mayor Presented: January 28, 1998 Adopted: January 28, 1998 Omnibus Vote: Yeas 7 Nays 0 Attest: s/ Dolonna Mecum Dolonna Mecum, City Clerk ,0 OFEiC ""*' Agenda Item No. City of Elgin URATED<<� December 8, 1997 TO: Mayor and Members of the City Council FROM: Robert O. Malm, Interim City Manager SUBJECT: Water Distribution Computerized Mapping System PURPOSE The purpose of this memorandum is to seek authorization from the Mayor and members of the City Council to enter into a contract agreement with the engineering firm of Camp Dresser & McKee, Chicago, for the development of a customized Automated Mapping/Facilities Management/Geographic Information System (AM/FM/GIS) for the water distribution system. BACKGROUND Water distribution maps are presently maintained and updated rib, by employees of the Engineering Department who manually draw from printed computerized documents onto mylars . These mylars are then photocopied and distributed to several departments for their use . The current method of maintaining utility drawings is cumbersome, outdated, and inefficient while providing limited data. The Water Department' s 1997 budget contains funds to hire a part-time draftsperson to update the water distribution maps that have not, in large part, been updated since 1994 . Representatives from the Departments of Public Works, Water, and Finance reviewed the present mylar mapping system and recognized that continuation of this outdated system would not function well for the City' s expanding utility infrastructure . It was also identified that the City would be receiving later in 1997 a GIS street-based map that could be used for the further development of mapping the City' s utilities . Requests for proposals were sent to 15 engineering firms for the development of an AM/FM/GIS system. Attachment A identi- fies five firms that returned formal proposals with price quotes separately submitted. The five firms were individually ranked by the selection team members . Camp Dresser & McKee was selected as the best qualified engineering firm based on the evaluation factors . After further discussion with Camp Dresser & McKee and clarification of the scope of services, the company' s not-to-exceed fee for engineering services to develop an AM/FM/GIS system for the City of Elgin water distribution system is $90, 000 . Prices for the original submittals ranged from $60, 000 to $198, 800 . • • Water Distribution Computer Mapping System December 8, 1997 Page 2 rm. The importance of this project has brought together three departments who are sharing in the cost for development of an AM/FM/GIS system in order to provide proper management and maintenance of the City' s underground utilities . This project will ultimately provide a great service to the entire City. COMMUNITY GROUPS/INTERESTED PERSONS CONTACTED None. OIL_ FINANCIAL IMPACT The funding for this project can be accomplished as follows : Department Account Number Description Amount Water 401-4002-771 . 30-03 Arch&Eng Sery $60, 000 Engineering 010-3311-752 . 30-03 Arch&Eng Sery 20, 000 Finance 010-2006-718 . 30-99 Professional Sery 10, 000 Total $90, 000 The fees submitted for engineering services for mapping are: B&H Industries $ 60, 000 . 00 Pavia-Marting 98, 557 . 94 Clark Dietz 198, 800 . 00 Rezek, Henry Meisenheimer & Gende $64, 451 . 00-$75, 600 . 00 Camp, Dresser& McKee 90, 000 . 00 LEGAL IMPACT None. ALTERNATIVES Reject the selection committee ' s recommendation and direct it to negotiate with the second ranked firm of Rezek, Henry, Meisenheimer & Gende, Inc. , Libertyville . Water Distribution Computer Mapping System December 8, 1997 Page 3 rk. RECOMMENDATION It is recommended that the City Council direct staff to enter into an agreement with Camp Dresser & McKee for engineering services for the development of an AM/FM/GIS system for the Elgin water distribution system for a price not to exceed $90, 000 . Respectfully submitted, E 06 1.01,0x,ij Larry E. Deibert Director of Water Department G�e Ies R. Nowicki . CPA . rector of Finance _._„, /1 _.,7 David L. Lawry, P.E sir- tor of Public Wo s rm. if ' / . 41, Rob -rt O. Malm Interim City Manager ROM:LED:KME:jm Attachment r • I CITY OF ELGIN QUALIFICATION RATING SHEET " Development of an Automated Mapping/Facilities Management/Geographic Information System (AM/FM/GIS)for Elgin Water Distribution Systems October 24, 1997 CONSULTANTS EVALUATION weight Pavia Marling&Co B&II Industries Ca Dresser&McKee Clark Diaz Inc CDI Resek,Henry.FACTORS _ Camp, ( ) 11cixnhcimer&Gvnde.Inc Peer Kurt Joe Perry Gary Peter Kurt Joe Perry Gary Peter Kurt Joe perry Gary Peter Kurt Joe Perry Gary Peter Kurt Joe Perry Gary Knowledge&Experi.ncx 0.20 IS 15 18 17 17 5 0 15 14 13 20 20 17 -18 17 18 19 15 16 15 20 19 17 18 18 Project Manager 0.15 10 12 12 13 12 5 0 11 9 9 IS 15 13 13 13 13 IS 12 13 13 14 12 12 13 12 Specialized Experience 0-15 10. 13 13 12 II 2 0 10 11 10 15 15 13 14 14 12 IS 10 11 IS 15 15 13 12 12 Scope of Services 0-20 10 15 18 17 17 5 0 15 13 12 18 20 18 17 18 15 18 14 14 14 20 19 14 17 IS Level ofEffon 0-20 10 15 17 16 16 2 0 14 12 12 20 20 18 17 IS 18 15 13 14 13 20 20 17 17 17 Familiarity with 0-10 5 5 8 8 7 5 0 8 7 7 10 10 8 8 9 10 10 9 8 8 9 10 6 8 7 TOTALS 0-100 60 75 86 83 80 24 0 73 66 63 98 100 87 87 89 86 92 73 76 73 98 95 79 85 81 rik TOTAL SCORES TABLE Development of AM/FM/GIS for Elgin Water Distribution Systems October 24, 1997 EVALUATORS CONSULTANTS Peter L.Bityou Kurt Eshelman Joe Evers Perry Li Gary Gordier Pavia Marting&Co.(PM) 60 75 86 83 80 B&H Industries(B&H) 24 0 73 66 63 Camp,Dresser&McKee(CD&Mc) 98 100 87 87 89 Clark Dietz Inc.(CDI) 86 92 73 76 73 Resek,Henry,Meisenheimer& 98 95 79 85 81 Gende,Inc(RHMG) RATING TABLE Development of AM/FM/GIS for Elgin Water Distribution System October 24, 1997 SELECTION TEAM PM B&H CD&Mc CDI RHMG Peter L.Bityou 3 1 5 4 5 Kurt Eshelman 2 1 5 3 4 Joe Evers 4 1 5 1 3 Perry Li 3 1 5 2 4 Gary Gordier 3 1 5 2 4 TOTAL SCORES 15 5 25 12 20 RANK 3 5 1 4 2 Note: Assign Scores Based on the following formula:(5-First, 4-Second, 3-Third, 2-Fourth, 1-Last) f t IIP U ENGINEERING SERVICES AGREEMENT FOR WATER DISTRIBUTION AM/FM/GIS SYSTEM 1998 1 • U 9I U a' U U' w U U ow w AGREEMENT THIS AGREEMENT, made and entered into this 3 day of -�� 1998, by and between the CITY OF ELGIN, an Illinois municipal corporation (hereinafter referred to as"CITY") and Camp Dresser& McKee, Inc., an Illinois consulting engineer ow (Hereinafter referred to as"ENGINEER"). WHEREAS, the CITY desires to engage the ENGINEER to furnish certain professional woo services in connection with the development of a Automated Mapping/Facilities Management/ Geographic Information System for the City of Elgin's Water Distribution System(hereinafter referred to as the"PROJECT"). ow AND low WHEREAS,the ENGINEER represents that he is in compliance with Illinois Statutes relating to professional registration of individuals and has the necessary expertise and experience to furnish such services upon the terms and conditions set forth herein below. NOW, THEREFORE, it is hereby agreed by and between the CITY and the ENGINEER that the CITY does hereby retain the ENGINEER to act for and represent it in all engineering matters involved in the PROJECT, subject to the following terms and conditions and stipulations, to-wit: I. SCOPE OF SERVICE Under this project,the ENGINEER shall update and automate the City's Water Distribution us System Mapping, develop an ARC/INFO GIS coverage of the water distribution system, and recommend GIS applications addressing water department functions that may be developed at a low future date. The basic services of the ENGINEER are described in the Camp Dresser&McKee proposal dated October 24, 1997,which by this reference is hereby incorporated into this agreement, except as amended and supplemented as follows: BASIC SERVICES Task 1 - Development of a Water Department Needs Assessment Under this task, the ENGINEER shall prepare a needs assessment for the CITY. The purpose of • this assessment is to identify potential AM/FM/GIS Applications and data needs which will allow the CITY to use it's graphical and tabular data more efficiently. As part of this task, ENGINEER 1 ±sr Aft . g shall spend two days on-site, interviewing members of the CITY staff to identify the types of data used, frequency of use, and the specific job functions that rely upon the collection, analysis, or P• r�x presentation of data. Based on these interviews, ENGINEER shall prepare a technical memorandum describing the water department's data usage and potential GIS applications. This memorandum will be used by the ENGINEER in task 2 as part of the database design and provide the CITY with information for future AM/FM/GIS application development and budgeting activities. This task includes one trip from Kansas City to the City of Elgin. Deliverables: Technical memorandum identifying the Water Department's AM/FM/GIS application and data needs IN Task 2 - Development of a Data Conversion Plan The ENGINEER shall develop and document a process to convert the graphical data contained on the City's water distribution system maps, as-built drawings for water main extensions, subdivision drawings, and detailed drawings of complex pipe intersections, as it relates to the "' distribution system. This plan will identify the process to be used to identify facilities to be ff captured, digitizing, quality control/quality assurance, database structure, facility identification numbering system, and map review and acceptance criteria. In addition to developing a plan,the ENGINEER shall test the data conversion process on two adjacent maps. As part of the data conversion test, final plotting specifications will be developed and presented to the City. Upon fog completion of this task, all details concerning the final presentation of the data will be agreed upon by both the CITY and the ENGINEER. This task includes one trip from Kansas City to the * City of Elgin. Deliverables: Data Conversion Plan(including database design, two plotted map tiles showing final plotting specifications). IN Task 3-Data Conversion wig Task 3 consists of the implementation of the Data Conversion Plan developed under Task 2. Under this task, the ENGINEER shall automate the following water system facilities: Facility Attributes Type Pipes ID, length, diameter, Line m" pressure zone urn 2 a Valves ID, size, tie information Node Hydrants ID Point Storage Tanks and ID, Name Point Reservoirs PPP Pump Stations ID, Name Point These data will be converted from the following source materials: " Source # of Maps City's existing Water Distribution System Maps 120 opt As-built drawings for water main extension projects 30 Parcel subdivision plans 20 Complex pipe layout details 5 During the data conversion process, the water distribution data will be rectified to the new City GIS land base. The City of Elgin will be responsible for providing copies of all source material to be used during this project, this includes water distribution system maps(which include markup corrections to known errors and updates to mapping, as well as locations of pressure-system separation valves [30-50 valves]), as-built drawings, and a digital copy of the GIS land base showing road names and right-of-way boundaries. The CITY will deliver all source material to the ENGINEER within 30 days after completion of Task 1 (Needs Assessment)meetings. The ti64 ENGINEER shall be entitled to rely upon the accuracy and completeness of information, including all source material provided by the CITY to the ENGINEER. The ENGINEER shall prepare a draft set of the water distribution system maps for review by the CITY. These maps will be prepared using the plotting specifications agreed upon during task 2. Based on comments by the City,the ENGINEER shall revise the maps and prepare final maps for ! ! delivery to the CITY. This task includes one trip to the City of Elgin. fog Deliverables- Two sets of draft maps; five sets of blue lines of the final water distribution maps; digital version of the database in ArcExport; digital versions of the line work in .dxf, and .dgn formats; and a copy of the ArcView APR file used for plotting the final maps. m' 3 ile Ar U' SUPPLEMENTAL SERVICES POP Upon written authorization by the CITY, the ENGINEER shall perform special services. These services may include the following: w . „ Scrubbing/Digitizing-the ENGINEER shall provide additional assistance in conversion of graphical data from additional sources. This would include preparation of the source material for digitizing(scrubbin g), digitizing, and database development. Additional sources could include: new subdivision as-builts, new water line extension as-builts, pipe leak inventories, wastewater s collection and transmission system data, or other utility data. Application Development-the ENGINEER shall develop AM/FM/GIS applications, identified in NIP the AM/FM/GIS Needs Assessment Memorandum. Applications development could include development of new applications or customization of third party add-on's to the CITY's ARC/INFO and ArcView GIS software. Training-the ENGINEER shall provide ESRI certified ARC/INFO and ArcView training customized to address the City of Elgin's data and use of the GIS software. OPP Analysis and Mapping-the ENGINEER shall perform analysis(e.g. statistical data summaries, proximity or density analysis) or prepare thematic maps showing specific network data. Thematic maps may include pressure zones or pipe diameter. Presentations-the ENGINEER shall conduct presentations on the data conversion process and mie general AM/FM/GIS benefits. NOTICE TO PROCEED AND SCHEDULE Upon execution, the ENGINEER is authorized to proceed with the basic services in accordance with the Scope of Services above. Task 1 and 2 will begin immediately upon notice to proceed. • Task 1 shall be completed within 30 days, Task 2 shall be completed within 60 days, and Task 3 shall be completed within 200 days of receipt of the complete digital GIS land base. PP 4 • IP KEY PROJECT PERSONNEL aw The ENGINEER shall assign the following staff to this project: Category Assigned Personnel Officer-in-Charge John E. Callan, P.E. Project Manager Joseph W. Adcock, AICP Technical Advisor Phillip R. Chernin, P.E. O GIS Specialist James Carolan Any changes to ENGINEER's assigned project personnel shall receive prior approval by the CITY. ATTACHMENTS NM 1. Detailed Attachment "A" is the Proposal received from the ENGINEER signed by Robert E. Molzahn, P.E., Vice President and John E. Callan, P.E., Associate and dated October 24, 1997 is part of this agreement. *, 2. Hourly rates for supplemental services are set forth in Attachment B hereto. II. WORK PRODUCTS All work products prepared by the ENGINEER pursuant hereto including, but not limited M" to reports, designs, work drawings, studies, photographs, models and recommendations shall be the property of the CITY and shall be delivered to the CITY upon request of the DIRECTOR provided, however, that the ENGINEER may retain copies of such work products for its records. Such work products are not intended or w represented to be suitable for reuse by the CITY on any extension to the PROJECT or on any other project, and such reuse shall be at the sole risk of the CITY without liability or legal exposure to the ENGINEER. 5 O III. PAYMENTS TO THE ENGINEER A. The CITY shall pay the ENGINEER for all services under this Agreement a lump sum of Ninety Thousands Dollars ($90,000), regardless of actual costs incurred by the $° ENGINEER unless modifications to the project are authorized in writing by the DIRECTOR. woo B. The CITY shall make periodic payments to the ENGINEER based upon actual progress of work provided within 30 days after receipt and approval of invoice. • C. The ENGINEER shall also be compensated for any supplemental services set authorized in writing by the CITY. Hourly rates for supplemental services are set forth in Attachment B. IV. INVOICES A. The ENGINEER shall submit invoices in a format approved by the CITY. Such lump ow sum payment shall be paid to ENGINEER upon completion of all services provided for under this agreement. V. TERMINATION OF AGREEMENT • Notwithstanding any other provision hereof, the CITY may terminate this Agreement at any time upon fifteen(15) days prior written notice to the ENGINEER. In the event that this Agreement is so terminated, the ENGINEER shall be paid for services actually ow performed and reimbursable expenses actually incurred prior to termination, except that reimbursement shall not exceed the total amounts set forth under paragraph III or IV above,whichever is less iiS VI. T ERM This Agreement shall become effective as of the date the ENGINEER is given a written illP 6 or S Notice to Proceed and, unless terminated for cause or pursuant to Article VI foregoing. A determination of completion shall not constitute a waiver of any rights or claims which the CITY may have or thereafter acquire with respect to any breach thereof by the `" ENGINEER. S VII. NOTICE OF CLAIM S If the ENGINEER wishes to make a claim for additional compensation as a result of action taken by the CITY,the ENGINEER shall give written notice of his claim within 15 NS days after occurrence of such action. No claim for additional compensation shall be made valid unless so made. Any changes in the ENGINEER's fee shall be valid only to the extent that such changes are included in writing signed by the CITY and the ENGINEER. Regardless of the decision of the DIRECTOR relative to a claim submitted by the ENGINEER, all work required under this Agreement as determined by the DIRECTOR shall proceed without interruption. OPP VIII. BREACH OF CONTRACT w, If either party violates or breaches any term of this Agreement, such violation or breach shall be deemed to constitute a default, and the other party has the right to seek such administrative, contractual or legal remedies as may be suitable to the violation or breach; and in addition, if either party, by reason of any default, fails within fifteen(15) days after notice thereof by other party to comply with the conditions of the Agreement, the other * party may terminate this Agreement. IX. INDEMNIFICATION The ENGINEER shall indemnify and save harmless the CITY, its officers and employees up from and against any and all loss, liability and damages of whatever nature, including Workmen's Compensation claims, in any way resulting from or arising out of negligent actions or omissions of the ENGINEER in connection herewith,including negligent or omissions of employees or agents of the ENGINEER arising out of the performance of s• professional services. X. NO PERSONAL LIABILITY S w 7 No official, director, officer, agent or employee of the CITY shall be charged personally or held contractually liable under any term or provision of this Agreement or because of their u execution, approval or attempted execution of this Agreement. XI. INSURANCE A. Comprehensive Liability. The ENGINEER shall provide, pay for and maintain in effect, during the term of this Agreement, a policy of comprehensive general liability insurance with limits of at least $1,000,000 aggregate for bodily injury and fie $1,000,000 aggregate for property damage. The ENGINEER shall deliver to the DIRECTOR a Certificate of Insurance naming the CITY as additional insured. The policy shall not be modified or terminated without thirty(30) days prior written notice to the DIRECTOR. The Certificate of Insurance which shall include Contractual obligation assumed by IP the ENGINEER under Article IX entitled "Indemnification" shall be provided. u, B. Comprehensive Automobile Liability. Comprehensive Automobile Liability Insurance covering all owned, non-owned and hired motor vehicles with limits of not less than $500,000 per occurrence for damage to property. C. Combined Single limit Policy. The requirements for insurance coverage for general liability and auto exposures may be met with combined single limit of $1,000,000 per occurrence subject to a $1,000,000 aggregate. me D. Professional Liability, The ENGINEER shall carry Engineer's professional Liability Insurance Covering claims resulting from error, omissions or negligent am acts with a combined single limits of not less than $1,000,000 per occurrence $3,000,000 agreegate. A Certificate of Insurance shall be submitted to the DIRECTOR as evidence of insurance protection. The policy shall not be modified or terminated without thirty(30) days prior written notice to the DIRECTOR. • XII. CONSTRUCTION MEANS, METHODS. TECHNIQUES_ SEQUENCES, PROCEDURES AND SAFETY 8 The ENGINEER shall not have control over or charge of and shall not be responsible for 4- construction means, methods, techniques, sequences or procedures, or for safety precautions and programs in connection with the construction, unless specifically identified in the Scope of Services. XIII. NONDISCRIMINATION um In all hiring or employment made possible or resulting from this Agreement, there shall be no discrimination against any employee or applicant for employment because of sex, age, race, color, creed, national origin, marital status, or the presence of any sensory, mental or physical handicap, unless based upon a bona fide occupational qualification, and this requirement shall apply to, but not limited to, the following: employment advertising, layoff or termination, rates of pay or other forms of compensation and selection for training, including apprenticeship. um No person shall be denied or subjected to discrimination in receipt of the benefit of any services or activities made possible by or resulting from this Agreement on grounds of sex, race, color, creed, national origin, age except minimum age and retirement provisions, marital status or the presence of any sensory, mental or physical handicap. Any violation of this provision shall be considered a violation of a material provision of this Agreement and shall be grounds for cancellation, termination or suspension, in whole or in part, of the Agreement by the CITY. XIV ASSIGNMENT AND SUCCESSORS. This Agreement and each and every portion thereof shall be binding upon the successors um and the assigns of the parties hereto; provided, however,that no assignment shall be made without the prior written consent of the CITY. mu XV. DELEGATION AND SUBCONTRACTORS go Any assignment, delegation or subcontracting shall be subject to all the terms, conditions and other provisions of this Agreement and the ENGINEER shall remain liable to the CITY with respect to each and every item condition and other provision hereof to the same extent that the ENGINEER would have been obligated if it had done the work itself mu and no assignment, delegation or subcontract had been made. ,m 9 • XVI. NO CO-PARTNERSHIP OR AGENCY It is understood and agreed that nothing herein contained is intended or shall be construed to, in any respect, create or establish the relationship of co-partners between the CITY and the ENGINEER, or as constituting the ENGINEER as a general representative or general agent of the CITY for any purpose whatsoever. XVII. SEVERABILITY The parties intend and agreed that, if any para 'a h, sub-paragraph, phrase clause or other provision of this Agreement, or any portion thereof, shall be held to be void OP otherwise unenforceable, all other portions of this Agreement shall remain in full force and effect. XVIII. HEADINGS • The headings of the several paragraphs of this Agreement are inserted only as a matter of convenience and for reference and in no way are they intended to define, limit or describe the scope of intent of any provision of this Agreement, nor shall they be construed to affect in any manner the terms and provisions hereof or the interpretation or construction thereof. XIX. MODIFICATION OR AMENDMENT This Agreement and its attachments constitutes the entire Agreement of the parties on the subject matter hereof and may not be changed, modified, discharged or extended except by written amendment duly executed by the parties. Each party agrees that no representations or warranties shall be binding upon the other party unless expressed in writing herein or in a duly executed amendment hereof, or change order as herein provided. XX. APPLICABLE LAW This Agreement shall be deemed to have been made in, and shall be construed in accordance with the laws of the State of Illinois. "'"" 10 A XXI. NEWS RELEASES PIP The ENGINEER may not issue any news releases without prior approval from the DIRECTOR,nor will the ENGINEER make public proposals developed under this Agreement without prior written approval from the DIRECTOR prior to said documentation becoming matters of public record. S XXII. COOPERATION WITH OTHER CONSULTANTS The ENGINEER shall cooperate with any other consultants in the CITY's employ or any k work associated with the PROJECT. S XXIII. INTERFERENCE WITH PUBLIC CONTRACTING: P.A 85-1295 S The ENGINEER certifies hereby that it is not barred from bidding on this contract as a result of violations of either Section 33E-3 or Section 33E-4 of the Illinois Criminal Code. s XXIV SEXUAL H_ARRASSMENT w As a condition of this contract, the ENGINEER shall have a written sexual harassment policies that include, at a minimum, the following information: A. The illegality of sexual harassment; B. The definition of sexual harassment under state law; 4+4 C. A description of sexual harassment, utilizing examples; D. The vendor's internal complaint process including penalties; E. The legal recourse, investigative and complaint process available through the Illinois Human Rights Commission; F. Directions on how to contact the department and commission; G. Protection against retaliation as provided to the Department of Human Rights upon request. P.A.87-1257. fa S I I Yea- IP XXV The ENGINEER shall comply with the requirements of the Prevailing Wage Act (820 ILCS 130/0.01 et seq.) XXVI.WRITTEN COMMUNICATIONS All recommendations and other communications by ENGINEER to the DIRECTOR and other participants which may affect cost or time of completion, shall be made or confirmed in writing. The DIRECTOR may also require other recommendations and communications by the ENGINEER be made or confirmed in writing. op XXVII NOTICES +P All notices, reports and documents required under this Agreement shall be in writing and shall be mailed by First Class Mail, postage prepaid, addressed as follows: A. As to CITY: Larry E. Deibert '"" Director of Water Department City of Elgin • 150 Dexter Court Elgin, Illinois 60120-5555 +111r B. As to ENGINEER: Fbw John E. Callan, P.E., Associate Camp Dresser&McKee The Sears Tower, Suite 450 233 South Wacker Drive Chicago, Illinois 60606 S S OP S 5 12 S IMP IN WITNESS WHEREOF,the undersigned have placed their hands and seal upon and executed this Agreement in triplicate as though each copy hereof was an original and that there OPP are no other oral agreements that have not been reduced to writing in this statement. For the CITY: ATTEST: THE CITY OF ELGIN aak By /�i�L. U...�__. _ By //_ City Clerk `City Manager (SEAL) For the ENGINEER: Dated this 19th day of January A.D.'199 ow sono WITNESSED: 1 By -%i..JA Il l l B • (Print name) (Print Name) OPP Dawn M. Miskus ,a...;iA MOPY gio Officer Title. 7 ear (SEAL) • 'OFFICIAL SEAL" • • DAWN M. M;SKUS Noiary f ]aiic State of Illinois My Commission Expires 10/22/98 • PPP a fas EXHIBIT "A" TO THE AGREEMENT BETWEEN THE CITY OF ELGIN AND CAMP DRESSER&McKEE FOR DEVELOPMENT OF DATA COVERAGES FOR THE WATER DISTRIBUTION AMIFM/GIS SYSTEM VIM itit • U U CDM Camp Dresser & McKee p City Elgin of Development of a Automated Cf) Mapping/Facilities Management/ C1111) Geographic Information System for the Water Distribution System ttA October 24, 1997 110 I .;1111.4 01111111114 OP I d lit FiA ss, CDMCamp Dresser & McKee Inc. consulting The Sears Tower,Suite 450 _ _ engineering 233 South Wacker Drive construction Chicago,Illinois 60606 operations Tel:312 474-1313 Fax:312 474-1004 October 24, 1997 Mr. Larry E. Deibert, P.E. Director of the Water Department City of Elgin 150 Dexter Court Elgin, Illinois 60120-5555 Regarding: Request for Proposals—Development of a Automated Mapping/ Facilities Management/Geographic Information System Dear Mr. Deibert: Camp Dresser &McKee Inc. (CDM) is pleased to present our qualifications and proposal for your proposed development of an automated mapping/facilities management/geographic information system. Our experience with other utilities facing similar challenges in the Midwest and throughout the United States will provide the City of Elgin with a proven track record of meeting your objectives. Like many of CDM's clients, the City of Elgin is facing recent challenges which emphasize the need for strategies in dealing with rapid growth,infrastructure management,regulatory,reliability,water quantity and economic issues.This project is important in setting the course of action which will assure the citizens of.Elgin service of a safe, uninteruptable water supply that will not only help identify the present needs of the area,but will address planning for growth and reliability issues as well. Ir Our proposal is based on our understanding of the Elgin priorities and the need to partner with the consultant providing the technical analyses. Each task is to be undertaken with the understanding of the value of the outcome and the impact the decisions will have on long-and short-term management of the City infrastructure. For this reason,we have assigned personnel who have the proven experience and understanding in similar projects and of the critical issues to be addressed. Selection of CDM for this assignment will provide the City with a partner with the following attributes: INN • A proven track record in the study and design of geographic information systems,such as the recent City of Chicago City Wide Information Management System (CWIMS) • Extensive knowledge of the Elgin water system and its operation win CDMCamp Dresser&McKee • Mr. Larry E. Deibert, P.E. Page 2 '" • In-house expertise of analyses performed for a number of geographic information systems • An in-house service group that does only.GIS work • Current knowledge of technological issues regarding GIS systems • The ability to work closely in partnership with the City to maximize the value of this study, as evidenced by our previous projects OP • The personnel and resources to accomplish this project in a timely manner IP • The background to interact with City departments,public,regulatory and legal stakeholders should that be necessary We are confident that our proposal responds to the requirements contained in the RFP, and we thank the City for its consideration of our qualifications. Please do not hesitate to contact us with any questions. Very truly yours, ter CAMP DRESSER&McKEE INC. CAMP DRESSER&McKEE INC. faY( E• til v1 p E• ae-ea- Fe . Robert E.Molzahn,P.E rE� E.Callan,P.E. Vice President J I Ass 4ciate oati 110 . Table of Contents 1111 Transmittal letter Section One Introduction to CDM 1-1 Section Two Project Approach 2-1 Section Three Project Management and Team 3-1 Section Four Similar Experience 4-1 References 4-6 Appendix A Detailed Resumes Appendix B Brochures Appendix C CDM Certificate of Insurance • Project cost submitted under separate cover I .e* 111 CDM Camp Dresser&McKee i-1 he Section 1 Introduction to CDM NIP Camp Dresser & McKee Established in 1947, CDM is one of the largest consulting firms in the world specializing in environmental engineering. CDM has been within Chicago for more than 20 years. We have a combined staff of more than 50 professional engineers and scientists who are specifically trained in geographical information systems management,water and wastewater treatment,water resources tie management, solid waste management,hazard- ous waste management,air quality management, CDM is a leader in the application and financial planning. Additionally,we can pull from the experience of staff in our other eight of GIS technologies with projects Midwest offices,as well as over 2,500 employees worldwide—most of which are professionals in eit ranging from basic engineering the engineering,science, and management support to application programming consulting disciplines. CDM is committed to the Midwest and proves this commitment by and full scale im p lementation. managing and completing quality,on-time projects for Midwest clients from our Midwest OP offices,including Chicago. tie Our client liaison,Mr.John E. Callan,has been involved in several projects for the City. Although Elgin knows us best for our water,wastewater,and stormwater study and design work,CDM is also a leader in the application of GIS technologies with projects ranging from basic engineering support to application programming and full-scale implementation for clients with varying needs and varying platforms. Our GIS project experience parallels the engineering project experience that we have built our reputation for excellence in:water distribution; wastewater collection;facility siting;stormwater planning and management;and community and For a project of this magnitude and environmental planning, as well as solid and complexity, we believe our team hazardous waste assessments and remediation. offers the strongest combination of Proximity to the Project We recognize that successful implementation of the nationally recognized technical geographic information system (GIS)will require a experts and locally-based staffing high level of interaction between the City and our team's technical experts. CDM's Chicago office in resources to do the work. the Sears Tower,will,therefore, serve as the project office for the City's GIS project. tit Vision/Mission Since 1947,Camp Dresser&McKee has provided the full range of environmental iok services to clients,setting the pace for the evolving environmental industry. CDM Camp Dresser&McKee 1-1 i Introduction During that time, CDM has completed projects for thousands of clients arc OP the world. These projects range from small, short-term solutions to compl€ ongoing environmental and infrastructure management programs,but the have the same focus: CDM's driving philosophy of providing exceptional service and building long-term relationships. a At CDM,client service means exceeding client needs and expectations by listening carefully to each client's unique concerns—technical,financial, socioeconomic, and operational—every step of the way. It means understa the conflicting demands of balancing infrastructure needs and environmer public health protection with fiscal reality.And it means being flexible in F delivery by offering start-to-finish service; supporting any individual phase of a larg( The employee owners of CDM are program. people you can rely on, and they From big-picture program and infrastructi 44- . provide solutions you can trust. management,to initial studies and design, through construction and operation,CDM project teams integrate the appropriate multidisciplinary resources and streamline all efforts throughout the proje, cycle. Plus,for every CDM project,we incorporate our Total Quality Management(TQM)processes, address issues of health and safety and IP community relations, and position ourselves as strong client advocates dui regulatory strategy development and negotiations.The result is the best to solution for every client. Finally,what separates CDM from other environmental firms are our peop Client service is only as good as the people who commit their talents and attention to your project.The employee-owners of Camp Dresser&McKee people you can rely on, and they provide the solutions you can trust,locall around the world. CDM will impart this philosophy and approach in our relationship with the City of Elgin.As such,our mission statement is Our approach to professional consultant assignments includes outstanding technical expertise and responsive services,because we believe both are es: to our clients.Technical ability and responsive service are the two major IP components of an overall successful project.More and more,we are hearin clients say, "Several firms can do the work technically,but what we look fc service." CDM has grown and expanded into new geographic areas,but no because of technical ability alone. To be successful in a competitive field su consulting engineering,a firm has to provide good service.The following describe the major aspects of our service philosophy. U Attention to Clients'Needs We listen to our clients:what they say,and what they do not say. Having a understanding of the assignment is important for us. CDM Camp Dresser&McKee PP Section 1 Introduction to CDM r We blend our client's present needs, long range goals,budget constraints, and • regulatory guidelines with our knowledge and expertise to develop the most cost-effective and publicly acceptable solution on our client's behalf. *' Communications We try to make you feel we are a member of your team. Our philosophy is to keep you informed and involved in the project. You have many opportunities to OP ask questions and provide input.There should not be any surprises at the end of tto the project.Likewise, this client participation prevents us from beginning the project in the wrong direction. We use status papers and regular meetings,both MP formal and working,to enhance the client's understanding of the project's status Atat and the direction it is taking. OP Many possible assignments and projects have the potential to cause disruption ` and complaints.We will work closely with the County,thereby reducing negative reaction to the project and increasing public acceptance of the associated IF it disruptions.CDM is experienced in the preparation of notices and public presentations to discuss the project and the potential benefits. Ai Assign the Right People Not only is it important to assign technically competent people to the project,but is matching personalities as much as possible is also important.People that get along well personally, generally work together better as a team.We try to assign the right people,not just who is available.This careful assignment of a team OP ensures project success. it Good Project Management Consulting engineering is a business.Accordingly,we perform as a business, honoring our commitments and paying attention to details. We regularly review project budgets and schedules. Having the correct people and facilities available (resource management)when they are needed is also critical. telt Our frequent interaction with you and our effective response to your feedback will be important tools in managing this project well. Ili Cost Estimates Pi gt We recognize our client's need to know what a project will cost and the tit implications of budget overruns. Therefore,we emphasize the importance of accurate cost estimates. I t Quality Control A good QA/QC program,such as CDM's,is beneficial to all projects.The 1 technical reviews by senior personnel ensure that proper data and methodologies are used,and recommendations are consistent with the base data. IIS Mp.: it CDM Camp Dresser&.McKee 1-3 Section 1 Introduction to CDM Technical Review Committee A Technical Review Committee (TRC) is assembled to review each project at the point at which all key recommendations have been framed. The TRC provides a senior level review of important technical and policy issues, and is usually staffed by senior personnel who are not stakeholders in the project, and therefore have no preconceived solutions. Value-Added CDM will add value as your consultant because we know and understand your water distribution system. We understand how to effectively perform within a government organization that is moving through the sometimes painful stages of change brought on by competitive forces. Our human resources experts,working with our technical experts have successfully completed numerous challenging projects because we know change must be managed as effectively as cost reduction. Follow-Up Service op After the project is complete, our interest continues. Our project manager will follow up to satisfy himself that the information and recommendations are meeting the client's needs. You will have opportunities to ask questions and It discuss the project with someone who helped complete the project. We feel that such follow-up is important. OP The implementation of this mission statement means: • The formation of a trusting partnership with the City • An agreement between CDM and the City at the start of the project that affirms this partnership • Reaffirmation of the mission statement during the length of the contract • Attendance at the City of Elgin monthly meetings by CDM's project manager to provide advisory services • An open line to CDM's project manager,offices and technical specialists im a a CDM Camp Dresser&McKee 1-4 Section 2 Project Approach The City of Elgin is taking the first step in modernizing the management of data associated with the Water Department. This step involves updating the water distribution system maps and "digitalizing" or converting the data for use with the City's developing Geographic Information System (GIS). By organizing the Water Department's maps and tabular data into the GIS format, the city greatly expands its ability to use the data to analyze the systems performance, as well as, better determine the effectiveness and efficiency of the City's operation and I. maintenance practices. This project will develop the data which will serve as the basis of all future Water Department GIS applications and system analysis procedures. Because of this, the flexibility and adaptability of the database design to potential future applications is a critical success factor of this project. CDM will use the highest standards of quality in this data conversion effort and deliver datasets that are efficiently organized and maintainable, yet flexible for future growth of the GIS system. CDM's approach to this project rests on four fundamental principals: • Develop a Database which can serve as a foundation for future development of GIS applications for the Water Department SW _fl • Design and automate water facilities data to efficiently answer engineering questions (i.e.how many miles of 12-inch pipe does the City own?) and assist with system operation and maintenance (i.e. identify which valves to turn to isolate a water line break) • Hold the City's new base map as true and rectify all data sets on a block by block basis so that water system features are placed in the proper position relative to the landbase p • Produce high quality, complete data sets, true to the source documents While the CDM team is comprised of GIS professionals,we implement GIS projects from an engineering perspective. Drawing on over 50 years experience in water system engineering, CDM fully understands the data needs for water tlAr distribution planning, design, operation and maintenance activities. Through this knowledge and experience, CDM knows the importance of accuracy in conversion of both the graphical and tabular data. Because of this, CDM employs the strict quality assurance/quality control procedures. The following sections address our commitment to quality and our proposed approach to meeting the requirements of the RFP and the goals of the Water Department. CDM Camp Dresser&McKee 2-1 Section 2 Project Approach Quality Assurance / Quality Control CDM will implement a series of Quality Assurance/Quality Control (QA/QC) operations throughout the conversion process to assure that all final deliverable products are complete and accurately reflect the data from the source documents. CDM will carefully monitor the flow of data sets and check plots to the City, and maintain a database that tracks quality control milestones and the delivery and ew acceptance process. Status reports will be provided to the City at regular intervals. low Prior to initiating the conversion process, CDM will develop a QA/QC plan as part of a larger data conversion plan. This plan will establish the procedures to be followed during data conversion, as well as identify key quality control milestones. In addition to review and acceptance by the City, the QA/QC plan will be reviewed by CDM's Technical Review Committee, comprised of senior GIS and engineering professionals, experienced in water system data conversion projects. Scope of Work ipo To complete the mapping of the water distribution system and meet the city's goals, CDM has developed a three step approach to the project. These are: 1) - conduct a water distribution system needs assessment, 2) develop a detailed data conversion plan, and 3) convert water distribution system to a GIS format. Details of each of these steps is provided below. sP Task 1—Conduct Water Distribution Needs Assessment We feel it is important to begin this project with a search to understand the "big oil picture." Many small components, if not structured within project goals and organized with an understanding of overall requirements, will overwhelm the basic objective of creating a functional and accessible AM/FM/GIS: The key to the needs assessment is to gain an understanding of what information is needed to fulfill current operational requirements and support the strategic decision-making processes which are essential to the City's long-term mission and success. NIB With this concept in mind,CDM will,during this task, document the City's Water Department GIS needs. This needs assessment will focus on the applications and data needed to addressed the functions of the Water Department. The needs assessment will: Oit • Discuss how AM/FM/GIS can support the existing functions and management activities within the Water Department • Identify and outline the range of potential AM/FM/GIS related applications by focusing on functional requirements. Applications will be identified in a or matrix format to easily convey the interrelationship of applications to functional groups CDM Camp Dresser& McKee 2-2 PP Section 2 Project Approach • Document the database and technical requirements necessary to facilitate design and use of desired applications. • Identify the subset of data that will be converted during this project and the applications those data will support Deliverables The City will receive the following deliverables from this task: • Technical Memorandum identifying potential future applications addressing business functions of the Water Department t • Summary of database and technical requirements associated with the OP potential future applications �1s • Recommended data structure for data converted as part of this project t, Task 2—Develop Detailed Data Conversion Plan The development of AM/FM/GIS database represents the single largest task and investment of resources in the GIS implementation process. The purpose of this task is to develop a detailed plan to convert tabular source data and record maps that will form the facilities database. The data conversion plan will document the 4 following: PI • Data accuracy standards that can be optimized through effective data preparation a • Continual quality control techniques and software to be used during data conversion OP • Specific methods of automation to be used • A quality assurance plan, including procedures for acceptance,validation, and loading the database • Specific methods of registering water features to the landbase in The data conversion plan will be developed based on a thorough review of the source material. As part of this task, the conversion plan will be tested by converting two maps and the associated data prior to submitting the plan for city review. In addition, the conversion plan will include a description of a quality assurance ow procedure through which a random sample of the data will, in accordance with ANSI standards, can be compared by City staff with the source data for accuracy. +P Deliverables Deliverables from this task, the City will receive the following products: CDM Camp Dresser&McKee 2-3 w Se Project Apj • Data Conversion Plan identifying process,nomenclature, and QA/QC procedures to be used during the conversion process • Digital data for two maps • Paper plots of two maps Task 3 —Water System Data Conversion Our water conversion methodology, described below, includes: • Data Acquisition • Scrubbing "" ■ Automation • Quality Control • Production Data Acquisition Existing City Water Distribution Source materials to be used for the water conversion ai r System Assets existing water distribution system maps (120 map shee 308 miles of water mains and data from the City's existing AS400 database. 3,138 hydrants MI 4,246 valves As-built/record drawings for City water projects, digit 2,600 If of raw water main built/record drawing information for subdivisions, the 3.96 miles of sludge transmission lines base map developed as part of 911 dispatch system, an parcel maps may be used as reference. Scrubbing see A scrubbing step is required to place entity IDs on the source manuscripts ( distribution maps) and to highlight miscellaneous text and any obscurred o� difficult to read feature information that will be automated from the water distribution maps. Identification of unique pipe segments and appurtenant based on attribute values will be done during the scrub phase. Automation Automation during the data conversion process is used as part of the qualit control process. Many processes can be checked through automation. Usir series of.LSP routines developed by CDM,each facility will be reviewed to that each facility recieves a unique identifier and is connected to upstream downstream facilities. Once each sheet is automated,it will be converted t( ARC/INFO coverage. mos Only network water facilities will be digitized as part of this project. Pipe • will be based on changes in diameter or material.Valves will be located on using CAD snapping tools to ensure connectivity. Once all "network" facil have been placed in CAD, ARC/INFO will be used to generate single arc-r coverage containing these facilities. Arc/Node topology will be derived in ARC/INFO by using POINTNODE command to convert the point attribut to a node attribute table associated with the water network line coverage. CDM Camp Dresser& McKee Now Section 2 Project Approach MO 4r, Scrub Network facilities include: sir Digitizes • Pipes • Valves " ' City i • Hydrants Review' Fittings and facilities that do not affect hydraulic connectivity such as, MP Valve vaults, casings and encasements, notes describing repair and Revise' replacement, rights-of-way, easements,parcel boundaries,water features, or other utilities will not be captured as part of this project. NM Register to 4. New Land base, Table 2-1 lists all the data layers and attributes that will be designed into this project. The table notes which data attributes will be populated by wa CDM as part of this project and which ones will not. Those not populated during the project (e.g., date of installation), will be created as fields in the database for future population. w Table 2-1 Facility Type Attributes Source Capture I. Pipes Length Developed from GIS Yes Diameter Source Maps Yes Date of Installation Maintenance Records No ID number Created During Scrubbing Yes III Leak History Maintenance Records No Pressure Zone Water Department Records No Service Area Water Department Records No - Hydrants ID number Created During Scrubbing Yes Tie information (as text) Source Maps Yes Manufacturer Water Department Records No Date of Installation Water Department Records No Date of Last Water Department Records No IR Maintenance Water Department Records No lost Flow Test Data Valves Diameter Source Maps Yes MP Manufacturer Water Department Records No Date of Installation Water Department Records No Date of Last Water Department Records No Maintenance NI Pump Stations Name (as text) Source Maps Yes ido Source Maps Yes Geography* Rivers City Base Map No Iw Lakes City Base Map No Creeks City Base Map No m Reservoirs Name Water Department Records No I Size Water Department Records No Overflow Elevations Water Department Records No Overhead Towers Name Source Maps Yes IMP Location Source Maps Yes Size Water Department Records No Overflow Elevations Water Department Records No Year Constructed Water Department Records No sr Date of last Water Department Records No maintenance ow CDM Camp Dresser& McKee 2-5 Section 2 Project Approach oP Quality Control RIP Consisting of the following steps, quality control (QC) is critically important. • Machine checking of attribute/feature IDs URI • Machine checking of attribute data • Visual inspection of check plots Machine checking of attribute/feature IDs involves checking the corrected attribute database feature IDs against the feature IDs created during spatial data automation. Discrepancies will be checked against the scrubbed source manuscripts until both sets of ID information are identical. Machine checking of attribute data involves checking the corrected attribute database against existing standards and lookup tables for the attribute data. For example, IDs may have a particular structure, or pipe diameters may be verified against a lookup table (e.g. a pipe diameter of 11 inches would show up as an error). Inconsistencies will be checked against specified standards and lookup tables and errors will be corrected. OP Visual inspection of check plots will be conducted on all map sheets after water facility features and IDs have been placed in AutoCAD, after AutoCAD maps have been converted to coverages,and after they have been joined with their attribute databases. Production • All production will be completed using AutoCAD Version 13 and ArcCAD version 11.4 on a PC platform; and on ARC/INFO version 7.X. Checkplot creation AMLs will be developed using the symbolization agreed to by the City and • presented in the conversion plan. All graphic elements will be mapped and specified attributes values will be displayed using the labeling capabilites provided in ARC/INFO,wherein labels are automatically placed as so not to overlay one another. AMLs will also be developed to export these maps to both .DGN and .DXF formats. CDM will deliver the plotting and export AMLs at no extra charge,enabling city staff to reprint the water system maps upon future updating or make additional copies. Deliverables P Deliverables from this task, the City will receive the following products: • ARC/INFO GIS Coverage of the Water Distribution System in NAD83 • Two complete sets of check prints for review and correction • Original digital versions of data in ARC/INFO Export (.E00),Microstation (.DGN), and AutoCAD (.DXF) formats wr • Five complete, final sets of water distribution system maps CDM Camp Dresser &McKee 2-6 ■• s� Project Ai • • WW Documentation The documentation and tracking of conversion activities is of extreme impo when developing a high quality GIS. A database designed specifically by C for the tracking of work and materials will be used throughout the project t( provide the following information for use by both CDM and the City: OW • The date that each piece of source material was received from the City • Dates of Automation and conversion personnel for each step of autom • Tolerances used during conversion activities • Descriptions of each digital file,where it resides,when it was backed t what its completion status is This information will be then be used to develop a final automation documt delivery to the City. In addition, this document will include: • A detailed list and description of each data layer • The finalized automation procedures used throughout the project • All cartographic specifics and coding descriptions used during the prc • Final quality control documents listing any discrepancies, as well as a of the automated quality control report logs generated during the con process ow Technical Review Committee The technical review committee, made up of senior GIS and engineering • professionals,plays an important role int he overall project quality manage The TRC team members are selected because of the extensive knowledge o1 processes involved in the project and their planned limited involvement on +� to day project progress. The goal of this committee is to provide a fresh loc the project to ensure that critical factors are addressed. The committee will this project at several key stages, these include: ew • 80 percent completion of Needs Assessment • 80 percent completion of Data Conversion Plan • 30 and 85 percent completion of Data Conversion Depending on the stage of the project, the TRC addresses issues related to ,P work which has been completed and provides a platform to discuss issues to the next phase of the project. As part of our commitment to quality, CD welcomes participation by our client project manager in this open forum discussion on the project. CDM Camp Dresser&McKee OP Section 2 Project Approach Project Schedule CDM estimates that the project would require approximately nine to twelve months to complete. Should the City require an expedited schedule, it is possible „o that the project could be completed in approximately six months. Obviously, the schedule is dependent on availability and accuracy of the data, the ability of the City staff to commit to this project, client review times, etc. We would be pleased to discuss the schedule with your staff and finalize a schedule that is realistic and that meets your needs. • MN NI WI OM IN Wi NW NW IN Mw WP IP CDM Camp Dresser& McKee 2-8 r- Aix IMP Section 3 Project Management and Team Project Management The purpose of project management can be succinctly summarized in three words—scope, schedule, and budget. Effective control of these three interrelated aspects of any project will ensure that the project will be successfully completed on time and on budget. CDM provides our engineers and scientists with the latest management information systems, computerized scheduling tools, technical de- velopment, and ongoing training in the soft side of consulting business; that is, personal interactions, communications, teamwork, and client relations, to maxi- mize project success. CDM will utilize all of the project management tools it has at its disposal on projects for the City of Elgin. Schedule Control CDM has provided its project managers with both the tools and the training to assure the project is completed on time. Scheduling systems are in place to allow managers to identify potential slippage before it becomes critical to the project. They then can make corrections to provide timely completion of each work product. Our computerized project control system City of Elgin is based on a detailed breakdown of each Client Liason work activity into discrete, manageable g John Callan tasks. Individual team members are ear Project Manager P'E' regularly monitored for progress on a Joe Adcock, AICP work task over a period of time. Technical Advisory Team Key Personnel Charlie Bristol, P.E. Ed Kura CDM's project team member's have the ma Stan Plante, P.E. diversified and multi-disciplinary skills necessary for successfully completing the water distribution system mapping Application Database project for the City of Elgin. Below are Requirements Design/Conversion Mapping highlights of the key CDM GIS experts' Joe Adcock Nanc Pullen And Baranowski experience. Complete resumes for each team member can be found in Appendix A. John Callan—Client Liaison Mr. Callan has 28 years of experience in the water field. His background includes OPP design,project engineering,project management, department management, and marketing. For the City of Elgin, Mr. Callan,while with another firm,was oto responsible for more than$10 million worth of construction for water transmis- CDM Camp Dresser& McKee 3-1 gro IP SE NO Project Management an( • sion and distribution mains, sewers, storage,pumping, garage, and meter sr. facilities. Also for the City of Elgin, Mr. Callan and CDM were involved in t1 filter excavation and report for to determine condition, depth and operating .m characteristics of filter media, underdrain and support equipment. Joseph W. Adcock, AICP—Project Manager Mr. Adcock is an environmental scientist/planner in the management and planning of water resources and Geographic Information Systems. He is experienced in storm water modeling, database applications,infrastructure planning,regulatory permitting,remote sensing,wetland mitigation,forestr land management. Mr. Adcock is experienced with GIS and scientific comp software applications,including: ArcCad, ArcView,INFRAWORKS, dBASE Access, Excel,SWIM, EXTRAN, RUNOFF,TR-55,HEC-II, BRN, and AdICPF Mr. Adcock is managing the development of GIS applications for implemen of a Stormwater Utility for Pasco County. The major component of this prc the development of GIS coverage for impervious areas on 14,000 non-reside properties within the 770 square mile County. This database is being develc using heads-up digitizing made possible by the use of digital aerial photogr As part of this project, efforts have been coordinated through the County's Stormwater Management Division, GIS Division,Property Appraisers Offic +�w County Administrators Office, and Florida Department of Transportation. I project deliverables will include the development of a customer service rout ArcView to enable customers to verify the basis of their stormwater utility I addition to Pasco County, Mr. Adcock has participated in the development Stormwater Utilities for Manatee,Sarasota, and Lee Counties. For Bay County,Florida,Mr. Adcock has served has the project manager dt the implementation phase of the County's ArcCad/ArcView geographic information system. While the County is completing most of the implemen efforts using its own staff,Mr. Adcock has assisted the County in developir standards, development of a digital aerial photography plan, and with corn of data from the property appraisers office, Federal Emergency Manageme; Agency,regional planning council, and other state agencies. Mr.Adcock h; out coordinated several training sessions to make sure staff has the appropriate aro to complete the implementation tasks. Mr. Adcock is assisting on the City of North Port GIS Needs Assessment. I of this project, Mr. Adcock conducted a workshop with the City Departme Directors to discuss the principles of GIS and how GIS tools could interact 410' their departments. In addition,Mr. Adcock assisted with the data collectio interview process and assisted with the evaluation of software and hardwz needs. And,Mr. Adcock is project manager for the preparation of the NPL nicipal separate storm sewer (MS4)permits for Sarasota and Manatee Cou and task manager for the Pasco County permit where he directed the development of AM/FM and GIS applications to assist in tracking the NPI MS4 outfalls and sampling locations. In addition to coordinating these effc Adcock served as the primary contact with EPA during the permit negotia CDM Camp Dresser& McKee Section 3 • Project Management and Team - process for Sarasota County, and is providing technical guidance on the prepa- ration of the MS4 permits for Leon and Seminole Counties. Mr. Adcock has also managed several floodplain analysis projects. For Manatee County,he managed the modeling and mapping of the 25 year floodplain for 13 basins. This included development of ArcInfo coverages for use on the County's GIS to meet the County's Comprehensive Plan requirements. In North Port, Mr. Adcock managed the Big Slough Watershed Study. This study resulted in the development of new floodplain maps for the 10, 25, and 100 year storm event. In addition, Mr. Adcock has participated in several facilities planning projects. These projects include: preparing 201 Wastewater Facilities Plans for Bay,Lee, and Manatee Counties, and the Cities of Cape Coral,Sarasota, and Venice,Florida; preparing a wet weather management plans for the Manatee County Southeast WWTP and the Venice Eastside WWTP;and assisting with the development of reuse master plans for the Cities of Sarasota and Venice, and Manatee County. Mr. Adcock also conducted a comprehensive siting study for the location of a new solid waste management and disposal facility in Sarasota County. Nancy Pullen—Database Design/Conversion Ms. Pullen manages a 10-person staff of geographic information systems (GIS) professional in Cambridge, Massachusetts and serves as project manager for municipal GIS projects and senior GIS analyst on a wide variety of environmental GIS projects. She has over 9 years of GIS and data management experience including database and application design for environmental and municipal GIS; IP municipal GIS data conversion;needs assessment;QA/QC methodology design; and development and delivery of training programs. Ms. Pullen is responsible for developing scopes,budgets and quality control procedures and for coordinating project work. Her specific area of expertise is the design of data models for integration of GIS with environmental monitoring,remediation,facilities inventory,hydraulic modeling and facility work management software applications. Ms. Pullen has developed and delivered training programs for Oracle and Progress RDBMS and several CDM-developed software applications, and is an AutoCAD expert and ESRI-certified ArcCAD instructor. I For the Massachusetts Water Resources Authority (MWRA), Ms. Pullen is database design engineer for implementation of the PipeWorks Facilities and Work Order Management System as part of the Water Distribution Facilities Mapping System project. • Ms. Pullen served as GIS Task Manager for the Brockton, Massachusetts Sewer Mapping project. She developed a sewer GIS and basemap to support a$1.2 million inflow/infiltration (I/I) identification and removal project.The work involved creating a photogrammetrically-derived land base and converting 280 miles of sewer from 1,300 record plans.The conversion methodology involved extensive coverage and attribute Quality Assurance/Quality Control using Access. a Iw CDM Cane Dresser& McKee 3-3 Section 3 Project Management and Team Ms. Pullen was GIS Manager for the Brookline, Massachusetts Water/Sewer and parcel GIS Development project. And as programmer/analyst for the DuPage, Illinois JULIE one-call system. Ms. Pullen was the GIS Manager for the County Sanitation Districts of Orange County, California Outfall Repair and Stormwater Modeling project. She was responsible for coordinating the use of GIS to support hydraulic modeling and ocean outfall repair.The work also involved coordinating efforts of client and GIS data vendors, acquiring existing GIS data for Orange County, automating future landuse, and performing analysis using landuse and demographic data to estimate RIP wastewater flow for modeling. Ms. Pullen has served as GIS Consultant for the Bay County, Florida County-wide GIS project. She has been providing ongoing training in the use of ArcCAD and ArcView tools for county GIS applications. Other responsibilities include providing data conversion services and consulting in the development and use of hardware, software,networking and data for use with GIS. Ms. Pullen served as GIS Conversion Manager for the Springfield, Massachusetts Sewer Mapping and Modeling project. She developed the conversion methodology and managed the conversion of digital landbase for approximately 17,000 manholes and 666 miles of sewer and stormwater pipe with their associated attribute data. This GIS was developed to support the modeling needs of a$1.8 million I/I identification project. ' Andy Baranowski—Mapping Mr. Baranowski is a cartographer and GIS data conversion expert. He has served ON as production manager for the$10 million infrastructure management project for the City of Chicago, that involved the development of a mainframe computer database of infrastructure data to facilitate the capital planning process in the City. The database includes all of the 4,200 mile water distribution system,4,300 mile sewer system,3,800 miles of residential and arterial streets, 250 bridges and faita viaducts,and 2,500 signalized intersections. Mr. Baranowski is currently managing the land records and water district ARC/INFO-AutoCAD conversion effort for Monroe County, New York. This project involves digitizing 1,920 E-size hand-drafted Mylar sheets. He is NI responsible for creating and maintaining a productive and efficient production environment for the sewer atlas conversion process. He aided in the creation and implementation of the production techniques currently used on the project. He is directly responsible for the quality of the product generated by the sewer conversion team;he oversees the training of the conversion personal; and tracks the day to day status of the conversion operation. PIM era From 1990 to 1993,Mr. Baranowski worked for a Chicago-based firm as an Intergraph workstation operator for various cadastral mapping projects. He is an experienced Microstation operator. He has performed layout for various mapping jobs and has assisted in the construction of a county-wide GIS for Lake County, 1 CDM Camp Dresser& McKee 3-4 Section 3 Project Management and Team Illinois, designed to show the relationship between soil types, land use and land ownership. While serving as a cartographer intern with the City of Chicago Department of Planning,he participated in the 1989 West Side Industrial Study. He was responsible for preparing maps for presentation and publication in the final project report, creating graphs and charts for presentations, and analyzing and converting data collected by survey teams into a series of nine land use maps covering the study areas. ion Technical Advisory Team Stan Plante, P.E. et Mr. Plante has considerable experience in water resource and environmental engineering,which includes the design, development, and application of data base management systems to address engineering and planning issues. He has applied state-of-the-art computer models to analyze water distribution, wastewater collection, and stormwater collection systems. Mr. Plante is the regional geographic information system (GIS) leader for CDM's mid-Atlantic area. In this capacity,he is responsible for supporting and/or performing GIS applications-either stand-alone or as project components-throughout CDM's mid-Atlantic area. Specializing in GIS applications geared toward water and sewer systems, Mr. Plante has managed several projects where GIS has been used to automate overlays of land-use data on sanitary sewer areas or water distribution systems. Mr.Plante completed the development of a GIS application for the National Pollutant Discharge Elimination System (NPDES) stormwater permitting OF program. This application included both the design of a data base management system (using Informix-SQL) and the design of map feature symbology using Intergraph's MGE software. Subsequent to the design phase,he oversaw the digitization of approximately 4,000 features within a 2-month period to populate the data base. Data base reports written by Mr. Plante were used as appendices in the NPDES permit application. The data base management system tracks stormwater outfalls, sampling locations,samples,and results. The data base is configured so that stormwater conveyance systems can be added in the future to provide a stormwater modeling link within the UNIX operating system. In addition,Mr. Plante set up and supported a similar application for a stormwater master plan for the City of San Marcos,Texas. For Baltimore County, Maryland, Mr. Plante was the task manager responsible for blending a series of base maps-from different sources,systems (ARC/ INFO, IRDISI,Mapinfo,and AutoCAD), and projections-into a uniform GIS for supporting hydraulic/water quality modeling of the Back River watershed. Awt Charles R. Bristol, P.E., DEE Mr. Bristol has contributed to the development and application of data base management systems, engineering computer models and geographic information systems (GIS) in all facets of environmental engineering including infrastructure NIP CDM Camp Dresser&McKee 3-5 • Section 3 Project Management and Team management. He has designed and developed GIS, data base management systems and engineering computer models for sewer and water system analysis and design, rainfall-runoff analysis, urban stormwater management, drainage system design,water demand analysis, industrial cost recovery systems, and cost estimating. As technical manager, Mr. Bristol worked on the Rouge River National Wet Weather Demonstration Project in Wayne County, Michigan where GIS, data management, sampling,water quality modeling,nonpoint source controls, and combined sewer overflow (CSO) abatement are being integrated into a compre- hensive watershed approach to pollution control.To support the watershed management and planning efforts, the project is integrating GIS (ARC/Info and ArcView),data management (ORACLE and MS-ACCESS), sampling,nonpoint source controls,water quality modeling (RUNOFF,TRANSPORT and WASP) and CSO abatement into a decision support environment. The GIS and data management tools (DataView,Rouge Information Manager and the Kiosk) have been developed for eventual migration to a project and county Intranet and, eventually the Internet. OP Mr. Bristol was also technical director for a GIS and data management design for the Drainage Utility Department, City of Austin,Texas, to support a centralized information management approach for the department. Subsequently, CDM is go assisting the Department in developing an overall Master Plan in which the centralized data base(ORACLE) and appropriate applications are being designed and developed. The project is focusing on developing PC-based tools for GIS (ArcView) and data management (FoxPro,ACCESS) in each section within the department.Each of the department section's will support the centralized data base which will provide the entire department information through an Intranet et approach. As team leader, Mr. Bristol served on the design of the sewer and water system components of the citywide infrastructure management system utilizing Intergraph's FRAMME and MGE in Medellin, Colombia,South America.The project required an initial needs assessment and system design.The water and sewer system design included feature definitions,placement criteria and con- straints,and an attribute data base structure.Subsequent activities included the pilot conversion project to demonstrate the full complement of system functionality. XI Ed Kura Mr. Kura has 12 years of experience working in the computer graphics field,with extensive experience in creation and maintenance of GIS databases,with skills in tto both mainframe and PC network environments. For the City of Chicago, Mr. Kura is managed the conversion of approximately 2000 manually drafted source docu- ments,for water and sewer infrastructure, to a geographic information system. Mr. Kura is currently managing conversion of 1,200 miles of water pipeline in Jacksonville,Florida. CDM Camp Dresser&McKee 3-6 lam Section 3 Project Management and Team Mr. Kura is well-versed in Intergraph IGDS, MicroStation and the design data formats. He has over six years of experience in using land records to produce mapping products. He supervised all production on a county-wide mapping system conversion project, completing townships on an average of 25%below budget. Mr. Kura has developed and successfully implemented training programs for computer graphics operators and managers, and has a solid record of managing department resources for a full three shift operation to fulfill production goals on schedule. Prior to joining CDM,Mr. Kura worked for the Sidwell Company in West Chica- go, as the GIS data department supervisor, responsible for production training, personnel administration, and directing all phases of computerized map produc- tion. While with this firm,he also was responsible for producing GIS databases us and cadastral mapping systems for use by tax assessors and other governmental Aft agencies. us Mr. Kura also worked for Chicago Aerial Survey in Des Plaines producing corn- ** puterized mapping and aerial photographic products. He served as the supervisor of the interactive graphics department and was responsible for production of all computerized mapping, training and other departmental supervisory duties. OP S WitS S OP w S S CDM Camp Dresser& McKee 3-7 w Section 4 Similar Experience Computer technologies have become a vital element in our ability to provide cost-effective and efficient planning,engineering, and management consulting solutions to our clients. Geographic information systems (GISs),and the related technologies of com uter aided design(CAD) and automated The CDM Team has developed mapping/facilities management (AM/FM), are among to a solid reputation for innovative the most powerful and rapidly expanding of these tools. and sound GIS technology CDM has developed a solid reputation for innovative application to infrastructure and sound GIS technology application to environmental engineering,planning, and resource management. Our management and GIS services include needs analysis and implementation environmental engineering. plans;application design; database development; infrastructure management; and information too management. Related Experience The following paragraphs describe some of our team's specific projects most similar to the one being undertaken by the City. Geographic Information System Master Plan—Jacksonville, Florida CDM is working with the Jacksonville Electric Authority's (JEA)Water and Sewer Business Unit to implement a geographic information system(GIS). The tto first phase of the GIS implementation consisted of preparing a GIS master plan. The master plan takes into account all of the existing facilities and features of the el city's GIS and the vision of GIS as a powerful tool to enhance department operations and management. From this base,an implementation plan was developed to identify and prioritize work activities,hardware and software purchases,and policies and procedures. The GIS master Ito plan and implementation work plan emphasize an early return on Similarities to City of investment,focus on functional design and accurate/efficient data Elgin GIS conversion,and provide adequate training and support to ensure • AutoCAD,ARC/INFO the transfer of knowledge and expertise to city staff to use, and Intergraph maintain and enhance the system. ati environments Implementation of an integrated GIS introduces a number of new • Large metropolitan technologies and concepts into an organization. To ensure that service area staff understand the value and uses of a GIS,two GIS workshops oto • Existing City GIS were conducted during the planning phase. The first workshop system introduced GIS concepts and their application while the second workshop focused on the specific application of the GIS within the oto department. At CDM Camp Dresser&McKee 4-1 Section 4 w Similar Experience The Master Plan scope of work included a review of the existing environment complexity, a needs assessment, development of data conversion plan,a utility applications requirements report, and a "proof of concept" application and `"" database. The needs assessment report addressed four major topics: (1) How a GIS can support existing business functions and management; (2)The applications able to be developed to meet data management and analysis, decision support and operations needs; (3) Documentation of information technology components and database requirements to deliver the applications; and (4) How development and release of applications will maximize efficiency " gains. In addition,CDM prepared a utility applications report to document the oto data requirements, database management system needs and development costs for each application group and specific applications identified in the needs assessment. The application development costs prepared as part of this report were used to develop the final cost benefit analysis in the GIS Master Plan. The JEA has accepted CDM's Master Plan and has authorized CDM to implement the system as documented in the Master Plan. CDM's scope of work includes development of applications,installation of hardware and software,owner and support personnel training,and data conversion. The applications to be developed by CDM include project planning and permit tracking,work order management,water quality monitoring, data maintenance,incident tracking, citizens inquiry complaint tracking,and interfaces with existing hydraulic modeling application and the JEAs customer billing information system. Key Staff Involved in Project:Ed Kura got GIS Planning, Implementation, and Applications Similarities to City of Development—Massachusetts Water Resources Authority(MWRA) Elgin GIS The MWRA provides drinking water and wastewater disposal services to about 2.5 million people in 60 eastern Massachusetts communities • Conversion from through the maintenance of 600 miles of water main and interceptors hand-drafted Mylar connecting to over 8,000 miles of pipeline in the member communities. • Large metropolitan CDM conducted a user needs assessment and developed a conceptual service area design of the database, followed by design of the GIS database structure,automation of data layers,and formulation of user-friendly • Integration with water programs for assisting MWRA staff in the use of the GIS. The final step models P was to provide standards and procedures,user manuals,and data iva documentation. Model interfaces included one with SWMM and one with STONER. The project culminated in a working GIS,run by staff at • MWRA who where trained by the CDM team. Now GIS technology has grown within MWRA and has been increasingly utilized by other departments to enhance mapping and analysis capabilities. Key Staff Involved in Project:Charlie Bristol,Nancy Pullen ww CDM Camp Dresser&McKee 4-2 Section 4 WO Similar Experience City-Wide Infrastructure Management System—Chicago, Illinois The City of Chicago has approximately 50,000 street segments,4,200 miles of water main,and 4,300 miles of sewer. The city-wide infrastructure management system (CWIMS)being developed by CDM will provide an integrated spatial- /1M relational database management system that links existing departmental data systems within the city.The project's ultimate goal is to implement an information Similarities to City of management system that will be used by city Elgin GIS departments to plan,coordinate,and manage capital improvement planning and budgeting processes. • Conversion plan from hand-drafted Following a pre-design study,CDM designed a Mylar prototype of CWIMS on the city's existing Intergraph • Large metropolitan CADD system. Following implementation of the service area prototype,CDM was contracted to design and implement the complete system including data • User-friendly program conversion; development of electronic data transfer development software and procedures; data maintenance/update applications;capital planning/decision support • Staff empowerment applications; documentation; and training. and training • Future expansion to The completed database will allow managers to directly other departments and easily access infrastructure conditions,spatial project information, and incident data and relate this all to a specific location. The system design allows for future addition of engineering level data,as well as additional departmental information and applications. The system is being developed with direct participation of the Departments of Water,Sewers,Transportation,Streets and Sanitation,Planning and Development,and Management Information Systems. Key Staff Involved in Project:Ed Kura,Andy Baranowski GIS Needs Assessment and Key Implementation—Bay County, Florida CDM conducted a fast-tracked,comprehensive geographic information system (GIS)needs analysis and implementation plan for Bay County,which encompasses 840 square miles and has a population of approximately 130,000. The county contracted with CDM to produce a GIS implementation plan within 1111 40 days in order to meet bonding and inter-departmental scheduling requirements. As recommended by CDM, the GIS will be developed over a 5-year period and will include assessing,planning,water and sewer utility services,emergency management and other information. Completing the GIS needs assessment and implementation plan involved an extensive interview process of county personnel from over 20 agencies and assessment of over 50 different computer systems and computerization processes. As a result of the initial study,a GIS pilot project was implemented, U' with CDM providing GIS consultation. In addition, CDM provided certified, on-site ArcCAD training for county employees. CDM Camp Dresser&McKee 4-3 IPP Section 4 Similar Experience f CDM also developed applications for use with Bay County's GIS,including water distribution,emergency management, solid waste management, and pavement management applications. Key Staff Involved in Project:Joe Adcock,Nancy Pullen Digital Computer Mapping for Hong Kong Water—Hong Kong CDM International, a subsidiary of CDM,has launched computer-based mapping of Hong Kong's water system infrastructure under a major new project for the Water Supplies Department(WSD). When completed in 1998,the project will have converted more than 2,000 maps to an advanced digital mapping 4,4 system (DMS) to improve customer service and management of capital assets. The$1 million project is being managed from CDM's Hong Kong office. A two-phase approach is planned for the project. Phase one analysis and system design—including Similarities to City of final recommendations for the mapping software Elgin GIS and hardware platform—was completed in early 1997. For phase two implementation,CDM's • A and ARRC/INFC/INF O computer mapping team is drawing on data conversion support from the firm's digitization • Conversion from hand- center in Madras,India. drafted Mylar_ The proposed DMS will serve future applications for operations,capital projects planning,and asset management,among others,with potential links to other Government departments' geographic information system (GIS) maps and to the WSD's hydraulic analysis software. The recommended DMS was tested as a pilot prototype using a selected area to demonstrate basic mapping maintenance and plotting functionality. ! Preparation of an NPDES Stormwater Permit Application—Virginia Beach, Virginia The City of Virginia Beach selected CDM to prepare its permit application for stormwater discharges from the city's municipal separate storm sewer system and for stormwater discharges associated with municipal industrial activities. The permits were prepared in accordance with the National Pollution Discharge Elimination System(NPDES)permit application regulations set forth by the U.S. Environmental Protection Agency(EPA) as required by the Clean Water Act. This project is one of the largest planned by any municipality. • For the municipal separate storm sewer system,CDM prepared a two-part application. Part 1 of the permit application was intended to provide an adequate basis for identifying sources of pollutants;identifying non-stormwater e discharges to the storm sewer via dry-weather field screening,sampling,and analysis;and formulating a strategy for a comprehensive characterization of the pollutant discharges from the storm sewer system. ,i CDM Camp Dresser&McKee 4-4 w Section 4 Similar Experience Part 2 of the application supplemented the characterization information provided in Part 1 through wet-weather sampling studies,and allowed municipalities to develop a comprehensive stormwater quality management program to control the discharge of pollutants to the maximum extent practicable (MEP). The NPDES stormwater permitting project was designed to maximize coordination with the city's other stormwater and water quality related programs,and to assist the city with the development of a financing mechanism to implement the ! e stormwater management program. CDM used the city's geographic information system (GIS) as a key component of the NPDES permit preparation process. CDM developed a database management system using Informix SQL which was used to integrate stormwater permitting data with the city's Intergraph-based GIS. CDM designed map feature symbology using Intergraph MGE and approximately 4,000 map features were digitized over a 2 month period to populate the database. CDM then developed customized database report routines to automatically generate information required for the NPDES permit application. The city plans to enhance the GIS in the future to include storm sewer and open channel networks and incorporate the database fields required to support standard stormwater model input data for these facilities. Att Key Staff Involved in Project: Stan Plante Enterprise-wide Geographic Information System—Brookline, Massachusetts CDM developed GIS datalayers and related databases of the water,sewer, stormwater,combined sewer systems and parcels. The databases include image catalogs created by scanning over 11,000 water and fire service detail records and linking them to a building footprints datalayer. The landbase used for the project was developed by a regional electric utility from 1"=600' aerial photography. CDM's data conversion methodology fully rectified all datasets to the landbase, limiting spatial distortion to single block areas throughout the town. These data will be the first town-wide data set to be implemented and CDM installed, configured and trained town employees in system operation and applications development to support engineering and assessing functions. CDM applied proprietary data conversion methods that ensure network connectivity for the storm drain,sanitary and combined systems and that link scanned images to parcels,addresses and pipe segments. This was a significant investment in information technology infrastructure for Brookline. CDM worked directly with the Directors of Assessing,Engineering, MIS,the Town Administrator and Finance. The town is leveraged the availability of data through the local utility to get this system up and running for about half of what it would cost if they had to develop the landbase themselves. Project Sigma: GIS for Medellin—Columbia As part of a consortium of two Columbian firms and two American firms,CDM designed an AM/FM/GIS,known as Project Sigma,to serve water,sewer, telephone,and electric utilities in Medellin and the metropolitan area of Aburra 011 CDM Camp Dresser&McKee 4-5 Section 4 Similar Experience Valley. The two-year pilot development phase included Similarities to City of developing functional/user requirements,system Elgin GIS specifications, software customization,basic applications development, and staff training. The implementation phase • Intergraph MGE included complete system design,system procurement, • Water and wastewater installation, database configuration, conversion specifications, utility and startup assistance. The completed pilot development phase established the groundwork for implementing an • Pilot project AM/FM/ GIS with full information accessibility between the utility networks, as well as the city's offices. Key Staff Involved in Project: Charlie Bristol Client References We invite you to contact the following client references to discuss our work. ino City of Chicago, Illinois Mr. Dennis McDonald,CWIMS Project Manager Office of Budget and Management (312) 744-6386 Massachusetts Water Resources Authority IP Mr. Daniel Nvule,GIS Program Manager Waterworks Division (617) 242-7110 Brookline, Massachusetts Feng Yang 411" GIS Director Jack Harris City Engineer (617)730-2005 Bay County, Florida "I Mr. Charles Gonzalez,GIS Manager Bay County Planning Department (850)784-4024 Medellin, Columbia Mauricio Arias Toro Director of Information Systems Empresas Publicas de Medellin 011/57-4-515-1792 44 CDM Camp Dresser&McKee I 4-6 IP Appendix A Detailed Resumes S S S S OP UM S S 4 S S S 2 CDM Camp Dresser&McKee JOHN E. CALLAN, P.E. Associate Camp Dresser & McKee Inc. RIP ttoi Summary Mr. Callan has 26 years of experience in the water field. His background includes design,project engineering, project management, department management, and marketing. Prior to joining CDM,he held senior positions with two consulting engineering firms where most of his experience gained was on projects in Illinois and the surrounding states. Experience Water Supply and Distribution • Liaison for water projects for Hoffman Estates,Lake County Public Works, and New Lenox,Illinois. • Design of raw water pump replacements,Lake County Public Water District, Zion,Illinois. • Study for a new water supply system for the villages of New Lenox,Frank- fort, and Mokena, Illinois (Tri-Village Group). • Responsible for more than$10 million worth of construction for water transmission and distribution mains,sewers, storage,pumping,garage,and meter shop facilities for Elgin,Illinois. • Report,design, and construction services for a$70 million Lake Michigan .:: water supply system consisting of 45 miles of water transmission main rang- ing in size from 12 to 60-inches in diameter,25 MG reinforced concrete reser- voir with a 50 mgd pumping station and a 75 mgd booster pumping station for the Northwest Water Commission in Des Plaines,Illinois. 00 • Responsible for the design of 31,000 If of 24 to 30-inch prestressed concrete pipe and pump station improvements,including water contract negotiations for Glenview,Illinois. Mr.Callan served as project engineer or project coordinator for the following: Design of numerous reservoir projects including 0.5 MG elevated,single pedes- tal,spherical water storage tank in Rosemont,Illinois;0.5 MG elevated,fluted column water storage tank in Worth,Illinois;25 MG reinforced concrete reservoir for the Northwest Water Commission;and 1.0 MG elevated,single pedestal, spherical water storage tank in Park Ridge,Illinois. w CDM Camp Dresser&McKee <, John E. Callan, P.E. Page 2 Water Treatment Mr. Callan served as project manager,project director, or project engineer for the following projects: • Project manager for a long range planning study for the 37.5 mgd Central ew Lake County Joint Action Water Agency (CLCJAWA) Paul M. Neal water treatment plant. ate • Task manager for consulting services for the Des Moines Water Works,Iowa for a new 20 mgd lime softening water treatment plant. ito • Project manager for a pretreatment design study for the upgrade of an exist- ing water treatment plant for Racine,Wisconsin. muo • Water treatment audit and study for Oak Creek,Wisconsin. Investigated flow capacities, treatment plant upgrades and expansion with particular • emphasis on the impact of the existing and proposed Safe Drinking Water Act Regulations. • Filter excavation and report for Elgin,Illinois to determine condition,depth and operating characteristics of filter media,underdrain and support equip- ment. • Filter excavation and report for Manitowoc,Wisconsin to determine condi- lion, depth and operating characteristics of filter media,underdrain and support equipment. • Design of a new 3.5 mgd water softening facility,including offices,chemical feed,pumping and all related equipment, for the Village of Montgomery, Illinois. The design utilizes new state-of-the-art solids contact clarifiers. • Design of all phases of a water plant waste facility,including preliminary re- port,plans and specifications,contract documents,and inspection of con- struction for Highland Park,Illinois. • Design phases at the Hammond Water Treatment Plant and distribution system for Hammond,Indiana.The projects included the design of 20,0001f of 24 to 36-inch diameter water transmission main,several smaller water distribution projects,expert testimony before the Indiana Public Service Commission for a proposed water rate increase and an overall water system study. U CDM Camp Dresser&McKee • John E. Callan, P.E. w Page 3 W • Study, design, and construction services for a chemical storage building addition,waste backwash water disposal facility, and additional standby power capacity at the water treatment facility in Freeport,Illinois. • Design of new system including 60 miles of water distribution mains,2 mgd water treatment plant, a 0.2 MG concrete ground storage reservoir,and a 0.3 MG elevated storage facility, and construction of a new raw water intake structure for Lake Township,Michigan. • Study of the renovation or replacement of an existing 4 mgd water filtration plant originally construction in 1917, including costs of constructing a new ' water filtration plant at various alternative sites for Menominee,Michigan. • Study of a new 30 mgd water treatment plant utilizing ozone for color re- moval, and for taste and odor control for Myrtle Beach, South Carolina. Raw water source was the Infra Coastal Waterway,which had the color of strong •• tea,was very acidic from tannic acid, and also had taste and odor ramifica- tions.The final design utilized ozone,potassium permanganate, activated carbon, and alum for treatment. Ask • Study of a water treatment plant expansion and rehabilitation for a 12 mgd (expanded to 18 mgd)water treatment plant addition,new chemical feed facilities and a new 30-inch diameter water transmission main for St.Joseph, Michigan. The project also included a detailed Hardy Cross computer net- work analysis of the water distribution system. 4. Mr. Callan served as project engineer or project coordinator for the following: S • Design of an addition to the existing 6 mgd water softening plant for Hamil- ton,Ohio. He was also responsible for several projects involving treatment and disposal of water treatment plant wastes. • Feasibility study for water plant sludge for two water treatment plants (980 • mgd and 480 mgd) for Chicago, Illinois. vio • Plans and specifications for a 160 mgd tertiary filtration treatment facility in San Jose,California. • Design and office construction related work of a 6 mgd water treatment plant addition for the North Shore Water Commission in Wisconsin. log S CDM Camp Dresser&McKee John E. Callan, P.E. Page 4 • Comprehensive water system analysis including lake water supply, treat- ; ment facilities, distribution, and pumping system and operation efficiencies for Bloomington,Illinois. min • Study and design of the water treatment plant waste backwash water and alum sludge treatment and disposal for Waukegan,Illinois. • Report on treatment and disposal of water treatment wastes for the Missis- ,w sippi River lime softening plan in East Moline,Illinois. • Study and design of the lime softening water treatment plant waste treat- .. ment and disposal for St. Cloud,Minnesota. • Study and design of the water treatment plant waste disposal for an iron re- w moval facility in Freeport,Illinois.The project involved designing a holding facility for waste backwash water and iron sludge with ultimate pumping to the sewage treatment plant. Education B.S.,Civil Engineering,University of Massachusetts,Dartmouth, 1969 MI Registration Professional Engineer:Illinois,Indiana,Michigan,Ohio, and Wisconsin Associations American Water Works Association Water Environment Federation Illinois Water Environment Association America Public Works Association Diplomate:American Academy of Environmental Engineers Publications "From Dream to Reality,Lake Michigan Water for Four Chicago Suburbs,"The Journal,American Water Works Association,June 1983. UP CDM Camp Dresser&McKee JOSEPH W. ADCOCK, AICP GIS Project Manager Camp Dresser & McKee Summary Mr. Adcock is an environmental scientist/planner in the management and planning of water resources and Geographic Information Systems.He is experienced in storm water modeling, database applications,infrastructure planning,regulatory permitting, remote sensing,wetland mitigation, forestry, and land management.Mr. Adcock is experience with GIS and scientific computer software applications,including: ArcCad,ArcView,INFRAWORKS, dBASE, Access,Excel,SWIM,EXTRAN,RUNOFF,TR-55,HEC-II,BRN, and I* AdICPR. Experience Currently,Mr.Adcock is managing the development of GIS applications for implementation of a Stormwater Utility for Pasco County.The major component of this project is the development of GIS coverage for impervious areas on 14,000 non-residential properties within the 770 square mile County. This database is mu being developed using heads-up digitizing made possible by digital aerial photographs. As part of this project, efforts have been coordinated through the County's Stormwater Management Division,GIS Division,Property Appraisers Office,County Administrators Office, and Florida Department of Transportation. Final project deliverables will include the development of a customer service • routine in ArcView to enable customers to verify the basis of their stormwater utility bill.In addition to Pasco County,Mr. Adcock has participated in the development of Stormwater Utilities for Manatee,Sarasota,and Lee Counties. For Bay County,Florida,Mr. Adcock has served has the project manager during the implementation phase of the County's ArcCad / ArcView geographic information system. While the County completing most of the implementation efforts using its own staff,Mr. Adcock has assisted the County in developing ,ie data standards,development of a digital aerial photography plan,and with conversion of data from the property appraisers office,Federal Emergency Management Agency,regional planning council,and other state agencies.Mr. PO Adcock has also coordinated several training sessions to make sure staff has the appropriate skills to complete the implementation tasks. Mr.Adcock is assisting on the City of North Port GIS Needs Assessment.As part of this project,Mr.Adcock conducted a workshop with the City Department Directors to discuss the principles of GIS and how GIS tools could interact with their departments. In addition,Mr. Adcock assisted with the data collection interview process and assisted with the evaluation of software and hardware needs. CDM Camp Dresser&McKee Joseph W. Adcock, AICP Page 2 Mr. Adcock is project manager for the preparation of the NPDES municipal separate storm sewer (MS4) permits for Sarasota and Manatee Counties, and task manager for the Pasco County permit.The NPDES MS4 permits applications w process consists of inventorying and mapping all stormwater facilities; devel- opment and implementation of an illicit connection(dry weather sampling) identification program;development and implementation of a wet weather RI (storm event) monitoring program;review of legal authority to control pollutants; estimation of annual non-point source pollutant loads;and develop- ing! ment and evaluation of a comprehensive water quality management program. Mr.Adcock directed the development of AM/FM and GIS applications to assist in tracking the NPDES MS4 outfalls and sampling locations.In addition to coordinating these efforts,Mr. Adcock served as the primary contact with the EPA during the permit negotiation process for Sarasota County, and is providing technical guidance on the preparation of the MS4 permits for Leon and Seminole Counties. Mr. Adcock has also managed several floodplain analysis projects. For Manatee County,he managed the modeling and mapping of the 25-year floodplain for 13 basins.This included development of Arclnfo coverages for use on the County's GIS to meet the County's Comprehensive Plan requirements. In North Port,Mr. Adcock managed the Big Slough Watershed Study.This study resulted in the development of new floodplain maps for the 10,25, and 100 year storm event. as In addition,Mr.Adcock has participated in several facilities planning projects. These projects include:preparing 201 Wastewater Facilities Plans for Bay,Lee, and Manatee Counties, and the Cities of Cape Coral,Sarasota,and Venice, Florida;preparing a wet weather management plan for the Manatee County Southeast WWTP and the Venice Eastside WWTP; and assisting with the 5 development of reuse master plans for the Cities of Sarasota and Venice,and Manatee County.Mr.Adcock also conducted a comprehensive siting study for the location of a new solid waste management and disposal facility in Sarasota County. fii Education B.S.—Natural Resource Management,Western Carolina University, 1988 Selective graduate courses in Geography—University of South Florida 5 Certifications American Institute of Certified Planners, 1994 OSHA Health and Safety Training Memberships American Planning Association American Water Resources Association National Association of Environmental Professionals CDM Camp Dresser&McKee Joseph W. Adcock, AICP Page 3 Professional History 1988 to date Environmental Scientist, Camp Dresser& McKee, Sarasota, Florida Recent projects Mr.Adcock has worked on include: w • Project manager on the Manatee County stormwater master plan and NPDES municipal separate storm sewer permit project up • Project scientist on the environmental assessment for the Callaway ad- vanced wastewater treatment facility PO • Project scientist on the Pasco County NPDES municipal separate stormwater system permit application • Project manager on the City of North Port's Big Slough stormwater master plan project go • Project scientist on the Sarasota solid waste management program,involved OP in developing a solid waste master plan and permitting and design of a new solid waste disposal complex • Project manager on Sarasota County NPDES municipal separate storm sewer system (MS4)permit application _ • Project scientist on the Glen Creek stormwater management master plan project • Project scientist on the development of a land acquisition and management plan for the protection of the Lake Manatee reservoir. 4. Other projects Mr.Adcock has been involved with include: OP • Project manager on the review of the application for a 980-acre residential and golf course development of regional impact in Manatee County • Project scientist for the modification of the discharge permit for the City of OP Venice's reverse osmosis water treatment plant • Project scientist involved in the preliminary design of the wet weather man- ■s agement plan for the Southeast Regional wastewater treatment facility in Manatee County CDM Camp Dresser&McKee Joseph W.Adcock, AICP Page 4 • Project scientist involved in data collection and modification of a spreadsheet-based water quality model used in the evaluation of the Six Mile Cypress Slough in Lee County • Project scientist involved in data collection and database management for the Withlacoochee River management plan. Summer 1987 Co-op Technician, Camp Dresser& McKee, Bradenton, Florida • Involved in the development of the database for the Manatee County sewer assessment program. Co-op technician involved in the preparation of construction plans for the Oneco/Samoset sewer collection system in Manatee County. Summer 1986 Co-op Technician, Camp Dresser& McKee, Tampa, Florida Technician involved in the data collection and computer input for the Seminole County groundwater master plan. Field technician involved in data collection for the aquifer performance test for a PIM 3.0-mgd potable water well for the West Coast Regional Water Supply Authority. Data collection for the preliminary ground and surface water contamination CO study for the Taylor Road area in Hillsborough County. IMP O 41 w CDM Camp Dresser&McKee ato CHARLES R. BRISTOL, P.E., E Asso( Camp Dresser & Mc Summary Mr. Bristol has contributed to the development and application of data base qui management systems,engineering computer models and geographic inforn systems (GIS) in all facets of environmental engineering including infrastru( OOP management. He has designed and developed GIS, data base management systems and engineering computer models for sewer and water system ana and design, rainfall-runoff analysis, urban stormwater management,draina system design,water demand analysis, industrial cost recovery systems, an estimating. Experience Mr. Bristol was project manager for the design of an environmental inform- management system (EIMS) for the Environmental Planning and Evaluatio Department—Metropolitan Council of Environmental Services,St. Paul,Mi sota.The EIMS design included detailed data discovery interviews and a d, report outlining the work activities and associated efforts required to imple OOP the EIMS. A central NT-based environmental data server was proposed alo with an Intranet-based suite of information sharing tools. se As technical manager,Mr. Bristol worked on the Rouge River National We Weather Demonstration Project in Wayne County,Michigan where GIS,da management,sampling,water quality modeling,nonpoint source controls, combined sewer overflow (CSO) abatement are being integrated into a con hensive watershed approach to pollution control.To support the watershec management and planning efforts, the project is integrating GIS(ARC/Infc ArcView), data management(ORACLE and MS-ACCESS),sampling,nonp source controls,water quality modeling(RUNOFF,TRANSPORT and WA' me and CSO abatement into a decision support environment. The GIS and dat. management tools (DataView,Rouge Information Manager and the Kiosk) been developed for eventual migration to a project and county Intranet anc PPP eventually the Internet. Mr.Bristol was also technical director for a GIS and data management desi the Drainage Utility Department,City of Austin,Texas,to support a centre information management approach for the department. Subsequently,CDC assisting the Department in developing an overall Master Plan in which th centralized data base (ORACLE) and appropriate applications are being dE and developed.The project is focusing on developing PC-based tools for C or (ArcView)and data management(FoxPro,ACCESS) in each section within { department. Each of the department section's will support the centralized omssl CDM Camp Dresser&McKee • Charles R. Bristol, P.E., DEE Page 2 base which will provide the entire department information through an Intranet approach. " " For the Department of Public Works in Nashville,Tennessee,Mr. Bristol was technical director for a storm water NPDES project where, as part of the technical support to the city in permit reporting, CDM is conducting a data conversion pilot project for the storm water infrastructure. The pilot project is addressing a variety of technical approaches including manual field inventories,GPS technolo- gies and Orthophotography. Once the pilot project has been completed, a full scale conversion will be undertaken using ArcCAD tools,MS-ACCESS data base and a NOVELL data server. all Mr. Bristol was technical director for the mapping of the storm sewer and sani- tary sewer network for Flint,Michigan, a city of 140,000 persons where more than nine thousand plan and profile sewer drawings are being converted to a digital map.The city has no maps of the sanitary and storm sewers and this project will develop a set of 1"-100' scale maps along with a data base of attrib- utes.The mapping is being conducted in AutoCAD and then will be integrated with the city's new ARC/Info system. Similarly, the attribute data is being provided in DBF files. CDM will work with the city GIS staff to define the re- quired applications for the wastewater and storm water departments. As team leader,Mr. Bristol served on the design of the sewer and water system components of the citywide infrastructure management system utilizing Intergraph's FRAMME and MGE in Medellin,Colombia,South America. The project required an initial needs assessment and system design. The water and sewer system design included feature definitions,placement criteria and con- ,. straints, and an attribute data base structure. Subsequent activities included the pilot conversion project to demonstrate the full complement of system functional- ity. up Previously,Mr. Bristol specialized in infrastructure management and geographic information systems.Relevant projects include the development of a stormwater data base and mapping system using Intergraph's MGE software for the City of Virginia Beach;a study for the Onondaga County Water Authority where exist- ing authority procedures were reviewed and recommendations were made for automation;a study for the Jefferson Parish Department of Public Works,which addressed the mapping and management of the water,sewer,drainage and tip streets departments.Also,Mr. Bristol was the project manager for a large sewer system facilities plan for Fairfax County,Virginia,where a relational database management system was used to link and drive several engineering programs. Another sewer study for the Washington Suburban Sanitary Commission(WSSC) included a detailed system design;extensive programming;and numerous ell crb597 CDM Camp Dresser&McKee ino Charles R. Bristol, P.E., DEE Page 3 volumes of system documentation and user manuals. Mr. Bristol also has extensive experience with several hardware systems, several asi operating systems, different networks,programming languages, GIS and CAD tools, and data base management systems. Education M.S.—Sanitary Engineering,Michigan State University, 1975 B.S.—Civil Engineering,Michigan State University, 1974 S Registration Professional Engineer:Virginia,Michigan (1980) S Memberships American Academy of Environmental Engineers American Society of Civil Engineers Technical Committee for Water Resources Planning Water Resources Planning and Management Division Reviewer for Journal of Computing in Civil Engineering Water Environment Federation American Water Works Association S Honors Diplomate: American Academy of Environmental Engineers (AAEE) Publications "Interacting with Large Data Sets," Paper presented at the WEF Urban Wet Weather Pollution Conference, Quebec City,Canada,June 1996 (with S. Rood S and C. Hughes). "Innovative Display of Water Quality Data Using RPO DataView,"Presentation at the Watershed '96 National Conference on Watershed Management, Baltimore, Maryland,June 1996 (with S. Rood). "GIS and Stormwater Management,"Presentation at Practical and Cost Effective Watershed Management Conference,Burton Manor,Livonia,Michigan,May 1996. w "GIS and Watershed Management,"Paper presented at the 1996 Borchardt Conference-A Seminar on Advancements in Water and Wastewater,University of Michigan,January 1996. RIP "Data Access and Analyses,"Paper presented at the WEF Annual Conference, Miami,Florida,October 1995 (with S.Rood and K.Koleda). "GIS and Data Base Management—Rouge River,Michigan,"Paper presented at the 15th Annual ESRI Users Conference,Palm Springs,California,May 1995 crb597 CDM Camp Dresser&McKee OPP Charles R. Bristol, P.E., DEE tw Page 4 (with K. Koleda and N.Mullett). "GIS—Sampling—Modeling: Technical Support," Paper presented at the WEF Annual Conference, Chicago,Illinois, October 1994 (with N.Mullett and K. Koleda). "GIS/DBMS Applications for the NPDES Stormwater Permitting Program," Paper presented at the WEF Conference on Geographic Information Systems in Public Utilities,Orlando, Florida,December 1991 (with D. Little and S. Plante). "Database Management System for Sewer System Planning," Paper presented at et the ASCE Sixth Conference on Computing in Civil Engineering,Alexandria, Virginia,May 1991 (with S.V. Plante). en "Fast Track Approach Produces Custom Solutions for Automation,"Paper pre- sented at the American Water Works Association Computer Specialty Confer- ence, Houston, Texas -April 1991 (with S. C. Lackey). "Geographic Information Systems Technology for the Water Works Industry," • Paper presented at the New Hampshire Water Works Association,Winter 1990 (with D.H. Leighton). "Database Management and Sewer System Modeling," Paper presented at the ASCE Fifth Conference on Computing in Civil Engineering,Alexandria,Virginia, March 30, 1988 (with R.J.Jentsch and S.V. Plante). "Sewer System Modeling and Database Management in Fairfax County,Virgin- • ia,"Paper presented at the 60th Annual WPCF Conference,Philadelphia,PA, October 8, 1987(with R.J.Jentsch,R.C. Clinger, and S.V. Plante). • "Computerized Construction Cost Estimating in County Government,"Paper presented at the ASCE Fourth Conference on Computing in Civil Engineering, Boston,Massachusetts,October 30, 1986 (with R.A.Marks and J.A. Costea). "Hydrograph Decomposition:Using a Technical Database,"Paper presented at the ASCE Specialty Conference on Computer Applications in Water Resources, Buffalo,New York,June 1985 (with L.A.Roesner and S.A. Hanson). "Washington Suburban Sanitary Commission Sewer System Computer Model," Paper presented at the ASCE Specialty Conference-Urban Water '84, Baltimore, Maryland,May 1984 (with L. A. Roesner,R. L.Humphries,and J. L. Higgins). "Sanitary Sewer Analysis/Design with a Microcomputer,"Paper presented at the crb597 CDM Camp Dresser&McKee N Charles R. Bristol, P.E., 44 13 Third Conference on Computing in Civil Engineering, San Diego, California, April 4, 1984 (with J. A. Aldrich and L. A. Roesner). "Model Documentation Designed for Users," Paper presented at the ASCE F WO draulic Division Specialty Conference, Cambridge,Massachusetts,August 1 1983 (with R. L. Humphries and J. L. Higgins). 41, "The Washington Suburban Sanitary Commission Data Base and Sewer Syst Computer Model," Paper presented at the Virginia Water Pollution Control Association Annual Conference,April 1983 (with J. L.Higgins,E.J.Upton,E Graham, R. L. Humphries). n "Effects of Conservation on Water Demands," Paper presented at the ASCE Water Supply—The Management Challenge,Tampa,Florida,March 16, 198: (with R. S.Taylor). g "Effects of Conservation on Local Water Resources Plans," Paper presented American Water Resources Association's 18th Annual Water Resources Con „„„ ence,San Francisco,California,October 1982 (with R. S. Taylor). "Testing of the Portable Water Purification and Disinfection Units of the Off ** Foreign Disaster Assistance,"WASH Field Report No.41,prepared for the of Health, Bureau for Science and Technology,Agency for International De\ meat,OTD-83,April 1982. - mu "Simulation and Optimization of Acid Mine Drainage Abatement AlternatiN Paper presented at the National Symposium on Surface Mining Hydrology, Sedimentology and Reclamation,Lexington,Kentucky,December 1981. .,.,. "Cost and Energy Requirements of Sludge Handling and Disposal,"Paper• sented at the 1980 WPCF Conference,Houston,Texas,October 9, 1979. '"" "Cost and Energy Requirements of Sludge Handling and Ultimate Land Di Methods,"Prepared for the Institute of Water Research,Michigan State Un sity,August 1975 (with M. L. Davis). 4P INN es cro597 CDM Camp Dresser&McKee PP NANCY PULLEN Senior GIS Specialist, Programmer/Analyst Camp Dresser & McKee OP Summary Ms. Pullen manages a 10-person staff of geographic information systems (GIS) professional in Cambridge,Massachusetts and serves as project manager for municipal GIS projects and senior GIS analyst on a wide variety of environmental GIS projects. She has over 9 years of GIS and data management experience including database and application design for environmental and municipal GIS; municipal GIS data conversion;needs assessment;QA/QC methodology design; and development and delivery of training programs. Ms. Pullen is responsible for developing scopes,budgets and quality control procedures and for coordinating project work. Her specific area of expertise is the design of data models for integration of GIS with environmental monitoring, remediation, facilities inventory,hydraulic modeling and facility work management software applications. Ms. Pullen has developed and delivered training programs for Oracle and Progress RDBMS and several CDM-developed software applications, and is currently the only ESRI-certified ArcCAD instructor in the State of Massachusetts. Ms. Pullen is experienced in Unix and Windows operating systems;Pascal and Fortran programming languages; Oracle,Progress and Foxpro database 4 management systems,ARC/INFO,ArcView and ArcCAD GIS software. Rip Experience For the Massachusetts Water Resources Authority(MWRA),Ms. Pullen is currently lead design engineer for implementation of the PipeWorks Facilities and Work Order Management System as part of the Distribution Facilities *" Mapping System project. Ms. Pullen served as an Oracle Application Developer for the Massachusetts Division of Capital Planning and Operations project where she was responsible for designing,building and implementing an Oracle data management system. The application allows users from several state agencies to maintain and report on measures taken to bring into compliance potentially hazardous matters located at state-owned facilities.Ms.Pullen performed a needs assessment to determine user needs and the requirements for integrating the new application into an existing suite of Oracle applications which formed the backbone for the state's environmental data management system. She also designed the data structure and application,co-developed the application,and designed and conducted a training system. ' ► Ms. Pullen served as GIS Task Manager for the Brockton,Massachusetts Sewer Mapping project. She developed a sewer GIS and basemap to support a$1.2 411 CDM Camp Dresser&McKee Nancy Pullen Page 2 no million inflow/infiltration (I/I) identification and removal project.The work involved creating a photogrammetrically-derived land base and converting 280 miles of sewer from 1,300 record plans.The conversion methodology involved wis extensive coverage and attribute Quality Assurance/Quality Control using Access. Ms. Pullen was GIS Manager for the Vallecitos Water District,California Water/Sewer Modeling and GIS Development project. She was responsible for coordinating the creation of landuse and facility GIS for integration with hydraulic modeling applications. She also designed the GIS interface and operational guidelines. Ms. Pullen was the GIS Manager for the County Sanitation Districts of Orange OW County,California Outfall Repair and Stormwater Modeling project. She was responsible for coordinating the use of GIS to support hydraulic modeling and ocean outfall repair. The work also involved coordinating efforts of client and GIS '"" data vendors, acquiring existing GIS data for Orange County,automating future landuse, and performing analysis using landuse and demographic data to estimate wastewater flow for modeling. Ms. Pullen has served as GIS Consultant for the Bay County,Florida County-wide GIS project. She has been providing ongoing training in the use of ArcCAD and ArcView tools for county GIS applications. Other responsibilities include providing data conversion services and consulting in the development tip and use of hardware,software,networking and data for use with GIS. Ms. Pullen served as GIS Conversion Manager for the Springfield,Massachusetts Imp Sewer Mapping and Modeling project. She developed the conversion methodology and managed the conversion of digital landbase for approximately 17,000 manholes and 666 miles of sewer and stormwater pipe with their associated attribute data.This GIS was developed to support the modeling needs of a $1.8 million I/I identification project. Ms. Pullen was the Designer/Developer for the Infraworks and ArcWorks ArcCAD Extension project.She designed and developed ArcWorks application software, an extension to ArcCAD 11.2 GIS software. Ms. Pullen developed ArcWorks using AutoLISP to convert existing Map Manager data(previously used with CDM's Infraworks software)to ArcCAD GIS format and to facilitate the creation of landuse and drainage basin layers for use in the determination of stormwater loads to models. ,P Ms. Pullen was a senior programmer for the Infraworks facility of Work Order Management Software used by CDM in the late 1980s. Education B.S. -Computer Engineering, Bucknell University, 1987 MBA -Boston University, 1995 • CDM Camp Dresser&McKee IMO Nancy Pullen Page 3 wig Membership AM/FM International Papers/ Presentation Water Distribution and Watershed Management using a Personal Computer-based System prepared for presentation at the AWWA Computer Conference,Houston,TX,April 1991 (with Brandon G. Braley and Thomas M. Bowen) •�t GIS-CADD-AM/FM: Understanding Computerized Mapping Tools in the Water and Wastewater Industries prepared for presentation at the NEWPCA r Conference, Boston,MA,January 1992 (with Philip R. Chernin) +w �z. a IP Aft w iiir CDM Camp Dresser&McKee PIP STANLEY V. PLANTE, P.E. RIP Environmental Engineer Camp Dresser & McKee Summary Mr. Plante has considerable experience in water resource and environmental 'I" engineering,which includes the design, development, and application of data base management systems to address engineering and planning issues. He has applied state-of-the-art computer models to analyze water distribution, wastewater collection, and stormwater collection systems. Mr. Plante is the tiag regional geographic information system (GIS) leader for CDM's mid-Atlantic area. In this capacity,he is responsible for supporting and/or performing GIS applications-either stand-alone or as project components-throughout CDM's mid-Atlantic area. Specializing in GIS applications geared toward water and IF sewer systems,Mr. Plante has managed several projects where GIS has been used to automate overlays of land-use data on sanitary sewer areas or water distribution systems. Experience GEOGRAPHIC INFORMATION SYSTEMS Mr. Plante completed the development of a GIS application for the National Pollutant Discharge Elimination System(NPDES)stormwater permitting program. This application included both the design of a data base management system (using Informix-SQL) and the design of map feature symbology using Intergraph's MGE software. Subsequent to the design phase,he oversaw the digitization of approximately 4,000 features within a 2-month period to populate the data base. Data base reports written by Mr. Plante were used as appendices okt in the NPDES permit application. The data base management system tracks stormwater outfalls,sampling locations,samples,and results. The data base is configured so that stormwater conveyance systems can be added in the future to provide a stormwater modeling link within the UNIX operating system. In addition,Mr. Plante set up and supported a similar application for a stormwater master plan for the City of San Marcos,Texas. For Baltimore County,Maryland,Mr. Plante was the task manager responsible • for blending a series of base maps-from different sources,systems (ARC/ INFO, IRDISI,Mapinfo,and AutoCAD),and projections-into a uniform GIS for ,up supporting hydraulic/water quality modeling of the Back River watershed. For the U.S. Army Corps of Engineers project at Fort Belvoir,Virginia,Mr. Plante designed a data base to store monitoring-well data and converted data from a global positioning system to Intergraph's MGE management system. IMP In CDM Camp Dresser&McKee a Stanley V. Plante, P.E. Page 2 STORM DRAINAGE AND FLOOD CONTROL Mr. Plante completed the development of a GIS application for the National Pollutant Discharge Elimination System (NPDES) stormwater permitting Win program. This application included both the design of a data base management system (using Informix-SQL) and the design of map feature symbology using Intergraph's MGE software. Subsequent to the design phase,he oversaw the digitization of approximately 4,000 features within a 2-month period to populate the data base. Data base reports written by Mr.Plante were used as appendices in the NPDES permit application. The data base management system tracks stormwater outfalls, sampling locations, samples,and results. The data base is configured so that stormwater conveyance systems can be added in the future to provide a stormwater modeling link within the UNIX operating system. In addition,Mr. Plante set up and supported a similar application for a stormwater master plan for the City of San Marcos,Texas. Mr. Plante developed software to provide user-friendly links between a relational data base management system, the RUNOFF and EXTRAN modules of EPA's Stormwater Management Model (SWMM),and a graphics package involving AutoCAD. mu Mr. Plante served as project engineer for a stormwater master plan for the Powhatan Creek watershed in James City County,Virginia. WATER Mr. Plante is a firmwide technical expert for applications and problem-solving ,u associated with the following water distribution system models: KYPIPE, CYBERNET,WaterCAD,EPANET,and Stoner Workstation Service. Mr. Plante was project engineer for a water distribution system master plan for the Newport News waterworks in Virginia. He was responsible for set-up and calibration of a water distribution system model and data base management • system, adaptation of computer model to specific project needs,and modeling of the system to evaluate future improvements for a client with more than 80,000 service connections. S Mr. Plante has served as project engineer,project manager,or technical resource for a number of other water distribution studies and master plans including Stafford County,Town of Leesburg,Spotsylvania County,Arlington County, James City County,Augusta County,and Fauquier County in Virginia;Asheville, Fayetteville,and Brunswick County in North Carolina;Florence,South Carolina; Warren County,Ohio;and Boca Raton and Jacksonville/Duval County,Florida. Mr. Plante oversaw the upgrade of Spotsylvania County's water distribution system from a 700-pipe network based on KYPIPE to a 2,200-pipe network based on KYPIPE 2+. CDM Camp Dresser&McKee Stanley V. Plante, P.E. Page 3 Mr. Plante has had significant experience in translating both graphics and tabular data between different computer models,GIS systems, and planning data bases. For example,he has written programs to convert KYPIPE water distribution data sets to EPANet and Stoner Workstation Service (SWS14) data sets. WASTEWATER Mr. Plante designed and developed a wastewater reuse engineering cost model for one of Florida's Water Management Districts. This model uses PROGRESS-a in fourth generation language (4GL) relational data base management system-to store data and perform all calculations. This model has been used by the District since 1989 to analyze the feasibility of using reclaimed water for irrigation permits on a case-by-case basis. As project engineer for the Fairfax County,Virginia, sanitary sewer plan, Mr. Plante designed and developed a data base and user's manual for the Capacity Analysis Program-a peak flow routing sewer model used to per-form countywide sewer system analyses. This modeling package has been used by on county staff for more than 7 years. Each year,the county's land-use parcel file (more than 300,000 records) and water consumption records are loaded into the data base to update systemwide wastewater flow allocations. Mr. Plante served as project manager responsible for all phases of the Spotsylvania County,Virginia,water and sewer master plan. The plan included in demand and flow projections,water distribution and wastewater collection system modeling,development of a 20-year capital improvement program,and a O„ master plan report. Mr. Plante has served in a similar capacity on water and sewer master plans for Stafford County,James City County,Augusta County and Fauquier County, all in Virginia. As project engineer,Mr. Plante designed,developed, and implemented links between a relational data base,the EPA-SWMM RUNOFF and EXTRAN modules,and AutoCAD-based graphic post-processors for the City of Cincinnati/Hamilton County,Ohio,wastewater facility master plan. site WATER RESOURCES As the project engineer,Mr.Plante studied the feasibility of and procedures for establishing a turbidity water quality criterion for United States reservoirs and streams (U.S. Environmental Protection Agency Division of Criteria and Standards). OF Also as project engineer,Mr.Plante delineated best management practice(BMP) sites and developed preliminary wet pond designs for the watersheds of Skiffe's Creek Reservoir in Virginia and the Evers Reservoir in Florida. int CDM Camp Dresser&McKee Stanley V. Plante, P.E. Page 4 um As project engineer,Mr. Plante assisted with selection of potential reservoir sites and performed design and cost analyses for a water supply reservoir in southeast Virginia (Counties of Hanover,James City,New Kent, and King William). For the Maryland Water Resources Administration,Mr. Plante developed the standard planning/design manual and inspection/maintenance manual for control measures required to implement new state regulations for the management of urban stormwater and non-point pollution. IN For the Florida Department of Environmental Regulation,Mr. Plante assessed state and regional stormwater management regulations,particularly to meet the goal of simultaneous water quantity and quality control of stormwater runoff. S Education B.S. -Civil Engineering,University of Maryland, 1984 Registration Professional Engineer: Virginia (1988) Memberships American Water Works Association Honors Tau Beta Pi (Engineering Honorary) Chi Epsilon (Civil Engineering Honorary) Presentations "Strategic Planning for Water and Sewer." With C. D. Binning and A. Goldsmith. Presented at VRA Spring Seminar,Lynchburg,Virginia,May 1995. "A GIS/DBMS Application for the NPDES Stormwater Permitting Program." With J.Barrett-McDaniels and K. A. Cave. Presented at the 1992 Virginia Water Resource Conference,Richmond,Virginia,April 1992. "A Database Interface for the RUNOFF and EXTRAN Modules of SWMM." With J. A.Aldrich. Presented and published in Proceedings: Stormwater and Water Quality User's Group Meeting,Eatontown,New Jersey,April 1990. S "Sewer System Modeling: Advantages and Potential Pitfalls." With C. R.Bristol and T. Coughlin. Presented at 15th Annual National Specialty Conference,Water +� + Resources Planning and Management Division,American Society of Civil Engineers,Norfolk,Virginia,June 1988. "Database Management and Sewer System Computer Modeling." With C. R. Bristol and R.W.Jentsch. Presented at Fifth Conference on Computing in Civil Engineering,Alexandria,Virginia,March 1988. S k„. Reports "Wastewater Reuse System Engineering Cost Model (REUSE) Documentation and User's Guide,"prepared for the South Florida Water Management District, 1989. 'P CDM Camp Dresser&McKee OPP Stanley V. Plante, P.E. Page 5 "Capacity Analysis Program User's Manual,"prepared for the Office of Waste Management,Fairfax County,Virginia,January 1988. An Assessment of Stormwater Management Programs,unpublished report for the Florida Department of Environmental Regulation. With J. P. Hartigan and L. A. Roesner. 1985. Inspector's Guidelines Manual,unpublished report prepared for Sediment and Stormwater Division, Water Resources Administration,Maryland Department of Natural Resources. With J. P. Hartigan and T.S. George. 1985. Planning/Design Procedures for Infiltration Practices,unpublished report prepared for Sediment and Stormwater Division,Water Resources Administration,Maryland Department of Natural Resources. With J. P. Hartigan and T. S. George. 1985. Hydrologic Basis for Suspended Solids Criteria,unpublished report prepared for Criteria and Standards Division,Office of Water Regulations and Standards,U.S. EnvironmentaProtection Agency. With C. C. Clarkson,D. E. Lehnig,R. S.Taylor, and W. M. Williams. 1984. i RIP IP me CDM Camp Dresser&McKee EDWARD T. KURA Project Manager Camp Dresser & McKee gop Summary Mr.Kura has 12 years of experience working in the computer graphics field,with extensive experience in creation and maintenance of G.I.S. databases,with skills in both mainframe and PC network environments. No Experience Currently,Mr. Kura is managing the conversion of approximately 2000 manually drafted source documents, for water and sewer infrastructure, to a geographic information system. • Since joining CDM,Mr. Kura has attended IBM training for GeoManager and GeoGPG. He has also worked on several water quality modeling projects, in- cluding a current project for the DuPage Water Commission. Mr. Kura is well-versed in Intergraph IGDS and MicroStation. He has over six years of experience in using land records to produce mapping products. He go supervised all production on a county-wide mapping system conversion project, completing townships on an average of 25%below budget.Mr. Kura has devel- oped and successfully implemented training programs for computer graphics operators and managers, and has a solid record of managing department re- sources for a full three shift operation to fulfill production goals on schedule. Prior to joining CDM,Mr. Kura worked for the Sidwell Company in West Chica- go,as the G.I.S. data department supervisor,responsible for production training, personnel administration,and directing all phases of computerized map produc- tion. While with this firm,he also was responsible for producing G.I.S.databases IN and cadastral mapping systems for use by tax assessors and other governmental agencies. Mr.Kura also worked for Chicago Aerial Survey in Des Plaines producing com- puterized mapping and aerial photographic products.He served as the super- visor of the interactive graphics department and was responsible for production go of all computerized mapping,training and other departmental supervisory duties. Education Computer Science Courses,Roosevelt University,Chicago,Illinois, 1977-1978 Business Courses,Western Illinois University,Macomb,Illinois, 1971-1972 CDM Camp Dresser&McKee VII Appendix B Brochures I oft IMP ,i . III CDM Camp Dresser&McKee i-3 F * -SSoIutions Lif of Yo r Pr t for the Life u Project' a " r i, •y Geographic information system (GIS) Ell.. C- � • • w•... MNe..M . Ife �V1V fal•40.13.01 ,2% -111010/111131.131M3 technology has become an integral tool for ,Et1g1ri i o +v a 1 mob Mail "-'I'" x ... E providing cost-effective and long-term solutions %N� .,e. n . 0.67' 7 5 i ti ■ to engineering and management problems. The experienced GIS professionals at Camp Dresser CD &McKee (CDM) offer a full range of high-quality �'�`��` . MP g ......_ wWri htwo GIS design and management services to meet a,5 ,5 a our clients' specific needs, appropriate to their < --- „a6, 3._,____:_____________, --- organizationa and institutional resources. o a �..__-_lin• I r.12. -1°cww >1114k ♦;loft. L __ K _...__ CDM combines its engineering, scientific, - N. IP 03 /� planning, and management experience with GIS ...... . I�4 �/ ) solutions for the following types of projects: ,. G,.._ I •Water, wastewater, and stormwater _ o _ facilities management me O CDM's city-wide infrastructure management system for Chicago ■Community planning helps six city departments coordinate capital improvement ■Environmental management projects. • UM •Emergency management NM •Watershed management "'"i i k � '`' J CU •Municipal and public works operations - _ / * ' 't 1- ' 41:?::.:,.:;: IMP ■Airport and transportation planning ° .+ pia , ``, �;, • Facilities Management: In Chicago, Illinois, i g g , - is CDM designed and implemented a city-wide C u. + • _Y� ' 0 infrastructure management system (CWIMS) 1;` _ -" n-.- �, �1-� !• i to help six city departments prioritize, plan, J, - - �/1j� MP 4� and coordinate capital improvement projects. A ` Y` Spatial and tabular databases describing the ! r _ -a` // p g !/ L%� ' \ is city's infrastructure systems for logging citizens' , lB ` 't „� complaints, accident reporting, one call utility ILO notifications, permits, condition ratings, and The GIS developed for the Hackensack Meadowlands Development Commission provides planners with tools to inspection reports were integrated into a balance economic growth with environmental protection. •INN centralized GIS, which allows city staff to ON s analyze, prioritize, and summarize the data for optimum use in planning and decision making. 300 characteristics for 150 wetland areas. om CI By overlaying six alternative land use plans • Community Planning: For the Hackensack on computer-based natural resources maps, 11105 Meadowlands Development Commission in CDM was able to screen alternative manage- New Jersey, CDM created a comprehensive anent scenarios rapidly and to identify optimal Cn GIS for preparation of a federal environmental regional development plans that balance envi- ronmental protection with reasonable growth. 0 region's special area management plan. To continued ' study the effects of development on wetlands, Y p CDM Camp Dresser & McKee Inc. /� CDM created a database with more than wenvironmental Corporate Headquarters services One Cambridge Center WO kIll9 Cambridge,Massachusetts 02142 Tel:1-800 243-2677 offices worldwide http://www.cdm.com 0 Camp Dresser&McKee Inc. i Using GIS to Solve Environmental Problems III Cif) Geographic information system(GIS) technology ` The graphic analysis cape- ..1...--- bilities of GIS technology „: provides a gateway to cost-effective,lasting solutions '-v helped define an acceptable ay.0001\ — balance between open to environmental problems.Camp Dresser&McKee , . i.--,-•}1-,_ -. p c—: ;,,,-, L_,` - space preservation and (CDM)carefully selects GIS tools to meet the specific ..:'_-t future development in East needs of our clients,based on both short-and long-term Greenwich,Rhode Island. project goals and budgets. i r go 111111d = r }— • In Florida,CDM is assist- ,,•L 3.,: ing the Pinellas Park Water Management District in predicting effects of proposed drainage improvements NI AMIliiiia4 1 ` f t• on the floodplain.PC ARC/INFO®is being used to ' �t integrate lot and parcel data from county records, goi -__ ,• flood plain delineation data from the Federal Emer- gency Management Agency,and results from hydro- logic modeling.By converting model output to GIS _ data layers and displaying overlays of data on lot and illi (111) :, =' �. ---:- parcel maps,the district can determine affected - � _ parcels under future improvement scenarios and prioritize capital improvements. In 1986,CDM became a national leader in the use of pm Cin ARC/INFO®GIS technology in the environmental ■ CDM is using a GIS system to help Westchester field by developing a GIS-based assessment of naturally- County,New York site a sludge dewatering and dis- occurring radon and its potential health risk in the entire posal facility.A series of maps were used to screen IN state of New Jersey.Since then,we have applied GIS sites based on zoning,land use,regulatory buffers,and technologies to span the breadth of environmental issues . at the local and regional level—needs assessments,siting '` • : • • ow 0.0.4 studies,infrastructure master plans,environmental - ��f Z J impact studies,and community growth planning. • CID The following examples show how CDM is applying V'P' in GIS technology to meet a variety of client needs: ieV ■ For the Massachusetts Water Resources Authority, f •CDM implemented a GIS system using ARC/INFO • ' • • ; •in and ORACLE®to support the Authority's Boston •'e• -, Harbor cleanup efforts and water supply/wastewater ;,r For the disposal responsibilities across its 60-community,2.5- , = U.S.Environmental Protection Agency,CDM used a GIS system to +w million-person service area.CDM built a 70-layer !,; create generalized hydrogeologic vulnera- geographic database,created custom applications, bility maps of Connecticut. and designed data access,maintenence,quality con- subsurface and topographic conditions.Candidate UM trol,and documentation procedures.For a concurrent sites were built-out to depict post-construction con- project,CDM used the Authority's GIS in developing ditions and overlaid on photogrammetric prints. water supply protection plans for more than 60 wells and reservoirs within its 660-square-mile service area. For more information about CDM's GIS services, '"' or about other components of our Geographic •For the Hackensack Meadowlands Development Information Architecture,contact CDM's geographic Commission,CDM is preparing a federal environ- systems staff at 510 933-2980. IS mental impact statement of a Special Area Manage- ment Plan for the Hackensack Meadowlands District, a 32-square-mile area in northeastern New Jersey. environmental engineers,scientists, Because the area is largely undeveloped and includes CDTdI planners,&management consultants mu some 7,000 acres of wetlands,CDM is using GIS tech- nology to evaluate the environmental effects of alter- CAMP DRESSER & McKEE INC. native land use scenarios and to identify a manage- "'a ment plan that balances environmental protection offices worldwide with reasonable growth. ®1991 Camp Dresser&McKee Inc. AAr,1NFO aryl Pr,AP(:'INF()Ara rmicr•nA rraAarnarke of Fnvinnmw+tal Cvetome Poeaarnh InetiM1.o OPP Supporting Chicago's Infrastructure Renewal With Computers Olt ERROL R. BOS Projects are prioritized based on the •Sewer facilities, including physical Management Consultant, urgency for improvements,coordination characteristics of sewers, manholes, and with other departmental projects, and catchbasins, and outfalls. w CARL R. JOHNSON, P.E. available funding. Given the number of •Capital projects within the public capital projects and the complexity of the rights-of-way. Vice President, planning and coordination processes, •Replacement cost tables, including Camp Dresser& McKee Inc., present efforts are geared to coordinating Chicago, Illinois p g 8 planning level unit prices for various projects in the coming year. Most proj- types and classes of water, sewer, and mi I TS infrastructure is described in global ects, however, require one to two years street facilities. 4isft superlatives: the world's largest and of planning and at least a year in design. Designing the Database second largest water treatment plants,the CWIMS is intended to extend the coor- world's tallest building, the busiest air- dination in the early years of the five-year The primary objective of CWIMS—to fee port, and the largest deep tunnel storm- CIP cycle. support capital planning decision-making water storage system. Within this infra- Plannin g y the CWIMS System —provides a "top-down" perspective. structure framework sits the City of Chi- Rather than build the system up from a cago, which consists of 3,800 miles of The city and CDM conducted a pre- detailed engineering level,as is often done mio streets, 253 bridges and viaducts, and design study to establish the scope,direc- with a departmental system,the process 8,500 miles of water mains and sewers. tion, and hardware and software plat- uses a corporate planning perspective. To help Chicago manage its massive form for CWIMS. The study examined This approach provides timely completion infrastructure, Camp Dresser & McKee user needs, investigated existing data of a working,city-wide system and offers MN Inc. (CDM)is developing a state-of-the- systems in the city, and developed a early investment return benefits. It also art computer database, mapping, and general plan of the system. It was deter- allows for continuing expansion of decision support system which, when mined that initial users of CWIMS would systems for maintenance and engineering completed in 1996, will be among the be the departments of water, sewers, automation. RI most ambitious and comprehensive mu- streets and sanitation, transportation, Capital planning decisions must con- nicipal infrastructure management planning and development, office of sider technical input, such as capacity systems in the country. budget and management, and manage- analysis, modeling, and deterioration The City-Wide Infrastructure Manage- ment information systems. curves.CWIMS is designed to help engi- NS ment System (CWIMS) is a geographic Within these departments,persons who neers analyze the infrastructure and make information system (GIS) designed to identify,coordinate,prioritize,and select it easier to communicate their conclusions help more than 100 people in six city projects for the capital improvement to others within their departments and departments prioritize, plan, and coor- program would be the principal users throughout the city. Available data in- *w dinate $500 million of capital improve- of CWIMS. Another major group of dude physical condition data, incident ment projects each year.CWIMS focuses CWIMS users would be staff who update data, ratings, and past facility assess- o on the data behind the infrastructure— each department's respective databases rr ents,helping experts to evaluate capac- its physical characteristics, condition, and maps. ity, identify problem areas, and classify i replacement costs,and ongoing and pro- User needs include the following:deci- deficiencies. posed capital projects.Information about lion support to analyze infrastructure. To make effective capital planning the infrastructure can be displayed and condition and select projects proactively decisions, it is important for decision- mapped by GIS to help analyze needs and for the CIP; production of automated makers to consider current infrastructure IN coordinate and schedule capital projects. maps within each department,including condition. CWIMS will permit each de- "The tangible benefits from CWIMS facilities maps and thematic maps to help partment to store assessment values for will be fewer street re-pavings and lower assess facility conditions, track mainte- its facilities, capturing the technical construction costs when multiple infra- nance and complaint history, and iden- expertise of a department and packaging is structures within a block can be replaced tify capacity problem areas; and sched- it in a way that people outside of the together," explains Dennis McDonald, uling and coordinating CIP projects specific department can understand. Chicago's Office of Budget and Manage- among departments. CWIMS also provides a number of ment project director. "When we have To accomplish all the identified tasks, tools for the temporary manipulation of access to the up-to-date condition of all the database would have to contain spe- infrastructure and project data.Some of water mains,sewers,and street pavement cific, detailed information on the city's this"what if"data,such as planned proj- in a block that can be analyzed together, infrastructure, including: ects and proposed facilities,will be stored we will have an extraordinary tool to •Base map of the entire city,including in the central database and shared with w prioritize better and plan infrastructure all public residential and arterial streets, other departments. Data will be down- renewals within that block." highways,block outlines,city boundaries, loaded to user PC tools, such as Arc- Chicago's Existing System address ranges per block, and ward and View2(ESRI,Redlands,California)and neighborhood boundaries. Quattro Pro, and will be linked to the ft Chicago currently develops its capital •Street facilities, including physical Central DB2 database through Oracle's improvement plan(CIP)with a high level characteristics (right-of-way width, "Gateway." These "views" will enable of participation from citizens,community materials installation date)of pavements users to manipulate data and create what- groups,and outside agencies.Capital pro- and bridges. if scenarios to support the decision mak- !". jest needs are identified from systematic •Traffic signals, including physical ing process. inspections of facilities, requests from characteristics and status of meeting To counteract the rapid obsolescence aldermen, citizen requests and petition standards for modernization. of individual hardware and software corn- programs, complaint and maintenance •Condition ratings of all street,water, ponents, CWIMS follows a "data- I. histories,projects by other agencies and and sewer facilities. centric" development. Off-the-shelf, departments,departmental master plans •Water facilities, including physical standard software products are being used *" and studies,regional plans,and develop- characteristics of mains, valves, and rather than custom applications wherever ment projects. hydrants. feasible,and the city's existing electronic bi Reprinted from PUBLIC WORKS MAGAZINE, February 1995 Appendix C Certificate of Insurance IMP N. .. 4 NO CDM Camp Dresser&McKee i-4 DATE(PUTDDlyy) i22//• THIS CO2TIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE Aon Risk Se ry i c es , I nc , of MA HOLDER. THIS CERTIFICATE DOES NOT AMEND. EXTEND OR 99 High Street ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. Boston, MA 02110-3271 COMPANIES AFFORDING COVERAGE COMPANY 617-482-3100 A Zurich Insurance Company INSURED COMPANY ( M Camp Dresser & McKee Inc . B Zurich Re(UK)Ltd.&London Cos• One Cambridge Center COMPANY Cambridge, MA 02142 C COMPANY D THISIS TOCERTIFY THAT THE POLICIES OFINSURANCE LISTED BELOWHAVE BEENISSUED TO THEINSURED NAMED ABOVEFOR THE POLICY PERIOD INDICATED.NOT WITHST ANDINGANYREOUIREMENT.TERMORCONOITIONOF ANYCONTRACT OROTHERDOCUMENT WITHRESPECT TOWHICHTHIS CERTIFICATE MAY BE ISSUED ORMAY PERT AIN.THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS. EXCLUSIONS AND CONDITIONS OF SUCH POLICIES.LMITS SHOWNMAY HAVE BEEN REDUCED BY PAID CLAMS. CO EFFECTIVE POLICY EXP TYPE OF INSURANCE POLICY NUMBER POLICY EFFECTIVE LIMITS LTR DATE(MMIDDIYY) DATE(MMIDDIYY) GENERAL LIABILITY GENERAL AGGREGATE f 2.000,000 A X COMMERCIAL GEI•ERALLIABLITY GL08376632-01 1/01/97 1/01/98 PRODUCTS-COMP/OP AGO f 2.000,000 1 CLAIMS MADE© OCCLR PERSONAL T. ACV IN,A,RY f 1 .000.000 OWNER'S&CONTRACTOR'S PROT EACH OCCURRENCE f 1.0 0 0,0 0 0 FIRE DAMAGE(Any one lire) f 100,000 MED EXP(Any one person) f 5,000 AUTOMOBILE LIABILITY COMBINED SINGLE LIMIT f A X ANY AUTO BAP8376631-01 1/01/97 1/01/98 1 .000,000 - ALL OWNED AUTOS BODILY INJURY f - SCHEDULED AUTOS (Per person) )(- HIRED AUTOS BODILY INJURY f x NON-OWNED AUTOS (Per accident) PRCY'=RSV DAMAGE f OARAOE LIABILITY - AUTO ONLY-EA ACCIDENT f ANY AUTO . OTHER THAN AUTO ONLY: EACH ACCIDENT S AGGREGATE f EXCESSLIABLITY EACH OCCURRENCE $ 5.000,0 0 0 itria A ]U143RELLAFORM AU0847244601 1/01/97 1/01/98 AGGREGATE f 5.000.000 OTTER THAN UMBRELLA FORM f ( WORKERS COMPENSATION AND I STATUTORY LIMITS EMPLOYERS'LIABLITY • A tIEPROPRIEtOR! INCL WC8376633-01 1/01/97 1/01/98 ACCIDENT I 500,000 f 1,000,000 PARTIERSFEXECUTIVE OFFICERS ARE: EXCL DISEASE•EACH EMPLOYEE f 5 0 0,0 0 0 OTHER B Professional Liab. AA0010900 1/01/97 1/01/98 $2,000,000 Aggregate DESCRIPTION OF OPERATION SILOCATIONSIVEHICI.WSPEOIAI ITEMS RE: Municipal Pollution Control Facility—Sludge removal and Capacity modifications. CERTIF3GAFE NOLt)E$ CANGHltAT1014 SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF. THE ISSUING COMPANY WILL ENDEAVOR TO MAIL "FOR PROPOSAL PURPOSES ONLY" 30 DAYS WRITTEN NOTICE TO THE CERTWICATE HOLDER NAMED TO THE LEFT. BUT FAILURE TO MAIL SUCH NOTICE SHALL IMPOSE NO OBLIGATION OR LIABILITY OF ANY KID THE COMPANY. ITS AGENTS OR REPRESENTATIVES. AUTHORIZED 047180000 Ol�.t IlIR EXHIBIT B TO THE AGREEMENT BETWEEN THE CITY OF ELGIN AND CAMP DRESSER& McKEE FOR DEVELOPMENT OF DATA COVERAGES FOR THE WATER DISTRIBUTION SYSTEM AM/FM/GIS SYSTEM Hourly Rates for Supplemental Services me The following represents hourly rates for special services that may be requested by the City. Labor Classification Hourly Labor Rate Officer/Advisor $125 on Project Manager $85 44 Senior Programmer/Analyst $95 Quality Control/Assurance Specialist $75 GIS Trainer $65 , , Junior Programmer/Analyst $65 Data Scrubber/Digitizer $40 Clerical $40 mg """ Direct costs, such as printing, travel, package delivery, etc., will be billed at actual cost plus 10% for processing. 4 w.