The URL can be used to link to this page

Home My WebLink AboutCC AG PKT 2012-02-13 #IDATE: February 13, 2012 TO: Honorable Mayor and City Council THRU: Jill R. Ingram, City Manager FROM: Sean P. Crumby, Assistant City Manager /Public Works SUBJECT: AWARD CONTRACT FOR GEOGRAPHIC INFORMATION SYSTEM (GIS) SUMMARY OF REQUEST: BACKGROUND AND ANALYSIS: AGENDA STAFF REPORT Agenda Item 1 That the City Council adopt Resolution No. 6223 approving an agreement with Digital Map Products, Inc. in the amount of $144,000 (initial set -up cost). In the approved FY 2011 -12 Budget, a Capital Improvement Project was budgeted to prepare and build a database for the City's Geographic Information System (GIS). GIS is database of information that allows users to view and obtain data graphically through maps and drawings. GIS systems allow the City to automate some of the tasks that employees perform thereby saving time and increasing efficiency. The State of California Regional Water Quality Control Board has mandated that the City have a GIS system for its cleanwater program (storm drains). The end product will allow staff to reduce trips to the field, increase efficiency with searching records for drawings and providing data and drawings faster electronically with updated aerial photos. This contract will build the GIS system for the City. It is being funded by the Water and Sewer enterprise funds. The system will assist the engineering staff at City Hall and assist the Water and Sewer field crews. This project will obtain all the City's drawings including infrastructure, maps, building plans, and other future needs to build a database. As part of the project, it will include new aerial photos, topographic survey and elevation models will be included. Numerous agencies are utilizing GIS systems to aid in the operation of all departments. Police Departments utilize GIS systems to display crime statistics, and have officer's access GIS systems in the field. Development Services Departments utilize planning features such as zoning, specific plans, and code enforcement issues. Community Services Departments utilize GIS systems to aid with management of facilities. Finance Department utilizes the GIS system to help with billing and business retention. This GIS system can be expanded after the initial construction to add features that will assist other departments within the City. On October 2011, staff released a Request for Proposal (RFP) to various GIS consultants. On December 15, 2011, staff received a total of nine proposals and interviewed four consultants. During the interview process, staff selected Digital Map Products, Incorporated. Consultant - =' Proposal Digital Map Products, Inc. $144,000.00_ Nobel Systems $162,058.00 Quartic Solutions, LLC $162,470.00 Technology Assoc. $206,931.06 Digital Map Products, Inc. was selected based upon the experience, clear approach to the scope of work, meeting and exceeding the City's needs for GIS, strong client list, well qualified staff and user friendly product. Digital map Products has developed and operates GIS systems for numerous other agencies. Within Orange county Digital Map Products has worked with the Cities of Orange, San Juan Capistrano, San Clemente and Westminster. Staff has verified their references from numerous other agencies and found positive feedback. In reviewing the proposal, scope of work, interviews and conference calls, staff recommends selecting Digital Map Products, Inc. in the amount of $144,000 for the scope of services outlined in the December 15, 2011 proposal. The GIS data is stored and operated in separate sites, which allows the City access at all times even in the event of an emergency. This will assist the City should a large scale natural disaster occur. ENVIRONMENTAL IMPACT: There is no Environmental Impact related to this item. LEGAL ANALYSIS: The City Attorney approves as to form. FINANCIAL IMPACT: In the approved FY2011 -12 Budget, $150,000 is budgeted for this project. The consultant has submitted a onetime cost of $144,000 to perform all work. Page 2 RECOMMENDATION: It is recommended City Council adopt Resolution No. 6223 approving an agreement with Digital Map Products, Inc. in the amount of $144,000 (initial set- up cost). SUBMITTED BY: _ NOTED AND APPROVED: Sean P. Crumby Assistant City Manager /Public Works Prepared by: Michael Ho, City Engineer Attachments: A. Resolution No. 6223 B. Contract Agreement Page 3 L R . R. Ingram, City RESOLUTION NUMBER 6223 A RESOLUTION OF THE SEAL BEACH CITY COUNCIL APPROVING A PROFESSIONAL SERVICES AGREEMENT WITH DIGITAL MAP PRODUCTS, INC. FOR THE CITY GEOGRAPHIC INFROMATION SYSTEM THE SEAL BEACH CITY COUNCIL DOES HEREBY RESOLVE: Section 1. The City Council hereby approves a professional services agreement (Agreement) and Subscription Services Agreement (Subscription) between the City of Seal Beach and Digital Map Products, Inc. for the City's GIS in the amount of $144,000. Section 2. The City Council hereby authorizes the City Manager to execute the Agreement and the Subscription. PASSED, APPROVED and ADOPTED by the Seal Beach City Council at a regular meeting held on the 13th day of February , 2012 by the following vote: AYES: Council Members NOES: Council Members ABSENT: Council Members ABSTAIN: Council Members ATTEST: City Clerk STATE OF CALIFORNIA } COUNTY OF ORANGE } SS CITY OF SEAL BEACH } I, Linda Devine, City Clerk of the City of Seal Beach, do hereby certify that the foregoing resolution is the original copy of Resolution Number 6223 on file in the office of the City Clerk, passed, approved, and adopted by the Seal Beach City Council at a regular meeting held on the 13th day of February , 2012. City Clerk Mayor S7296-0001 11423855v 1. d o c PROFESSIONAL SERVICES AGREEMENT Between City of Seal Beach 211 - 8th Street Seal Beach, CA 90740 & Digital Map Products, Inc. 18831 Von Karman Avenue, Suite 200 Irvine, CA 92612 This Professional Service Agreement ( "the Agreement ") is made as of February 13, 2012 (the "Effective Date "), by and between Digital Map Products, Inc. ( "Consultant "), a privately held company, and the City of Seal Beach ( "City "), a California charter city, (collectively, "the Parties "). RECITALS A. City desires certain professional services. B. Consultant represents that it is qualified and able to provide City with such services. NOW THEREFORE, in consideration of the Parties' performance of the promises, covenants, and conditions stated herein, the Parties hereto agree as follows. 1.0 Scope of Services AGREEMENT 1.1. Consultant shall provide those services ( "Services ") set forth in the attached Exhibit A— excepting "Work Element 2 (Option B) – Data Migration," "Optional Work Element 1 – Data Delivery," and Optional Work Element 2 – Integration for Future Utility Information into GIS." The City may in its sole discretion elect to subscribe to Consultant's Web -Based GIS (City GIS & Concierge Services) in future years, provided it shall have no obligation to subscribe for any given 12 -month period beyond the first 12 months of this Agreement. 1.2. Exhibit A is hereby incorporated by this reference. To the extent that there is any conflict between Exhibit A and this Agreement, this Agreement shall control. 1.3. Consultant shall perform all Services under this Agreement in accordance with the standard of care generally exercised by like professionals under similar circumstances and in a manner reasonably satisfactory to City. 1.4. In performing this Agreement, Consultant shall comply with all applicable provisions of federal, state, and local law. 1.5. Consultant will not be compensated for any work performed not specified in the Scope of Services unless the City authorizes such work in advance and in writing. The City Manager may authorize payment for such work up to a cumulative maximum of $10,000. Payment for additional work in excess of $10,000 requires prior City Council authorization. 2.0 Ownership of Work Product All reports, documents, information, databases, writings, or other materials created or developed by Consultant in the performance of this Agreement shall be and remain the property of City without restriction or limitation upon its use or dissemination by City. Such material shall not be subject of a copyright application by Consultant. Any alteration or reuse by City of any such material S7296 -0001 \1423855v1.doc 2 of 9 on any project other than the project for which they were prepared shall be at the sole risk of City unless City compensates Consultant for such use. 3.0 Term This term of this Agreement shall commence as of the Effective Date and shall continue for a term of 1 year unless previously terminated as provided by this Agreement. 4.0 Consultant's Compensation City will pay Consultant for in accordance with the hourly rates shown on the fee schedule set forth on page 40 of Exhibit A but in no event will the City pay more than $144,000 for the initial 12 -month period of this Agreement. If in subsequent 12 -month periods, the City elects to subscribe to Consultant's Web - Based GIS (CityGIS & Concierge Services), City will pay consultant $18,000 for each 12 -month subscription. Any additional work authorized by the City pursuant to Section 1.5 will be compensated in accordance with the fee schedule set forth in Exhibit A, page 40. 5.0 Method of Payment 5.1. Consultant shall submit to City monthly invoices for all services rendered pursuant to this Agreement. Such invoices shall be submitted within 15 days of the end of the month during which the services were rendered and shall describe in detail the services rendered during the period, the days worked, number of hours worked, the hourly rates charged, and the services performed for each day in the period. City will pay Consultant within 30 days of receiving Consultant's invoice. City will not withhold any applicable federal or state payroll and other required taxes, or other authorized deductions from payments made to Consultant. 5.2. Upon 24 -hour notice from City, Consultant shall allow City or City's agents or representatives to inspect at Consultant's offices during reasonable business hours all records, invoices, time cards, cost control sheets and other records maintained by Consultant in connection with this Agreement. City's rights under this Section 4.2 shall survive for two years following the termination of this Agreement. 6.0 Termination 6.1. This Agreement may be terminated by City, without cause, or by Consultant based on reasonable cause, upon giving the other party written notice thereof not Tess than 30 days prior to the date of termination. 6.2. This Agreement may be terminated by City upon 10 days' notice to Consultant if Consultant fails to provide satisfactory evidence of renewal or S7296 -0001 \1423855v 1.doc 3 of 9 replacement of comprehensive general liability insurance as required by this Agreement at least 20 days before the expiration date of the previous policy. 7.0 Party Representatives 7.1. The City Manager is the City's representative for purposes of this Agreement. 7.2. Benjamin Webb is the Consultant's primary representative for purposes of this Agreement. 8.0 Notices 8.1. All notices permitted or required under this Agreement shall be deemed made when personally delivered or when mailed 48 hours after deposit in the United States Mail, first class postage prepaid and addressed to the party at the following addresses: To City: City of Seal Beach 211 -8th Street Seal Beach, California 90740 Attn: City Manager To Consultant: Digital Map Products, Inc. 18831 Von Karman Ave., Suite 200 Irvine, CA 92612 Attn: Benjamin Webb 8.2. Actual notice shall be deemed adequate notice on the date actual notice occurred, regardless of the method of service. 9.0 Independent Contractor 9.1. Consultant is an independent contractor and not an employee of the City. All services provided pursuant to this Agreement shall be performed by Consultant or under its supervision. Consultant will determine the means, methods, and details of performing the services. Any additional personnel performing services under this Agreement on behalf of Consultant shall also not be employees of City and shall at all times be under Consultant's exclusive direction and control. Consultant shall pay all wages, salaries, and other amounts due such personnel in connection with their performance of services under this Agreement and as required by law. Consultant shall be responsible for all reports and obligations respecting such additional personnel, including, but not limited to: social security taxes, income tax withholding, unemployment insurance, disability insurance, and workers' compensation insurance. 9.2. Consultant shall indemnify and hold harmless City and its elected officials, officers, employees, servants, designated volunteers, and agents S7296- 0001 \1423855v1.doc 4 of 9 serving as independent contractors in the role of City officials, from any and all liability, damages, claims, costs and expenses of any nature to the extent arising from Consultant's personnel practices. City shall have the right to offset against the amount of any fees due to Consultant under this Agreement any amount due to City from Consultant as a result of Consultant's failure to promptly pay to City any reimbursement or indemnification arising under this Section. 10.0 Subcontractors No portion of this Agreement shall be subcontracted without the prior written approval of the City. Consultant is fully responsible to City for the performance of any and all subcontractors. 11.0 Assignment Consultant shall not assign or transfer any interest in this Agreement whether by assignment or novation, without the prior written consent of City. Any purported assignment without such consent shall be void and without effect. 12.0 Insurance 12.1. Consultant shall not commence work under this Agreement until it has provided evidence satisfactory to the City that Consultant has secured all insurance required under this Section. Consultant shall furnish City with original certificates of insurance and endorsements effecting coverage required by this Agreement on forms satisfactory to the City. The certificates and endorsements for each insurance policy shall be signed by a person authorized by that insurer to bind coverage on its behalf, and shall be on forms provided by the City if requested. All certificates and endorsements shall be received and approved by the City before work commences. The City reserves the right to require complete, certified copies of all required insurance policies, at any time. 12.2. Consultant shall, at its expense, procure and maintain for the duration of the Agreement, insurance against claims for injuries to persons or damages to property that may arise from or in connection with the performance of this Agreement. Insurance is to be placed with insurers with a current A.M. Best's rating no less than A:VIII, licensed to do business in California, and satisfactory to the City. Coverage shall be at least as broad as the latest version of the following: (1) General Liability: Insurance Services Office Commercial General Liability coverage (occurrence form CG 0001); (2) Automobile Liability: Insurance Services Office Business Auto Coverage form number CA 0001, code 1 (any auto); and, if required by the City, (3) Professional Liability. Consultant shall maintain limits no less than: (1) General Liability: $2,000,000 per occurrence for bodily injury, personal injury and property damage and if Commercial General Liability Insurance or other form with a general aggregate limit is used, either the general aggregate limit shall apply separately to this Agreement/location or the general aggregate limit shall be twice the required occurrence limit; (2) Automobile Liability: $1,000,000 per accident for bodily injury S7296 -0001 \1423855v1.doc 5 of 9 and property damage; and (3) Professional Liability: $1,000,000 per claim /aggregate. 12.3. The insurance policies shall contain the following provisions, or Consultant shall provide endorsements on forms supplied or approved by the City to state: (1) coverage shall not be suspended, voided, reduced or canceled except after 30 days prior written notice by certified mail, return receipt requested, has been given to the City; (2) any failure to comply with reporting or other provisions of the policies, including breaches of warranties, shall not affect coverage provided to the City, its directors, officials, officers, (3) coverage shall be primary insurance as respects the City, its directors, officials, officers, employees, agents and volunteers, or if excess, shall stand in an unbroken chain of coverage excess of the Consultant's scheduled underlying coverage and that any insurance or self - insurance maintained by the City, its directors, officials, officers, employees, agents and volunteers shall be excess of the Consultant's insurance and shall not be called upon to contribute with it; (4) for general liability insurance, that the City, its directors, officials, officers, employees, agents and volunteers shall be covered as additional insureds with respect to the services or operations performed by or on behalf of the Consultant, including materials, parts or equipment furnished in connection with such work; and (5) for automobile liability, that the City, its directors, officials, officers, employees, agents and volunteers shall be covered as additional insureds with respect to the ownership, operation, maintenance, use, loading or unloading of any auto owned, leased, hired or borrowed by the Consultant or for which the Consultant is responsible. 12.4. All insurance required by this Section shall contain standard separation of insureds provisions and shall not contain any special limitations on the scope of protection afforded to the City, its directors, officials, officers, employees, agents, and volunteers. 12.5. Any deductibles or self- insured retentions shall be declared to and approved by the City. Consultant guarantees that, at the option of the City, either: (1) the insurer shall reduce or eliminate such deductibles or self - insured retentions as respects the City, its directors, officials, officers, employees, agents, and volunteers; or (2) the Consultant shall procure a bond guaranteeing payment of losses and related investigation costs, claims and administrative and defense expenses. 13.0 Indemnification, Hold Harmless, and Duty to Defend Consultant shall defend, indemnify, and hold the City, its officials, officers, employees, volunteers and agents serving as independent contractors in the role of city officials (collectively "Indemnitees ") free and harmless from any and all claims, demands, causes of action, costs, expenses, liability, loss, damage or injury, in law or equity, to property or persons, including wrongful death, in any manner arising out of or incident to any acts or omissions of Consultant, its employees, or its agents in connection with the performance of this Agreement, S7296 -0001 \1423855v 1.doc 6 of 9 including without limitation the payment of all consequential damages and attorneys' fees and other related costs and expenses, except for such loss or damage arising from the sole negligence or willful misconduct of the City. With respect to any and all such aforesaid suits, actions, or other legal proceedings of every kind that may be brought or instituted against Indemnitees, Consultant shall defend Indemnitees, at Consultant's own cost, expense, and risk, and shall pay and satisfy any judgment, award, or decree that may be rendered against Indemnitees. Consultant shall reimburse City and its directors, officials, officers, employees, agents and /or volunteers, for any and all legal expenses and costs incurred by each of them in connection therewith or in enforcing the indemnity herein provided. Consultant's obligation to indemnify shall not be restricted to insurance proceeds, if any, received by Consultant, the City, its directors, officials, officers, employees, agents or volunteers. All duties of Consultant under this Section shall survive termination of this Agreement. 14.0 Equal Opportunity Consultant affirmatively represents that it is an equal opportunity employer. Consultant shall not discriminate against any subcontractor, employee, or applicant for employment because of race, religion, color, national origin, handicap, ancestry, sex, sexual orientation, or age. Such non- discrimination includes, but is not limited to, all activities related to initial employment, upgrading, demotion, transfer, recruitment or recruitment advertising, layoff, or termination. 15.0 Labor Certification By its signature hereunder, Consultant certifies that it is aware of the provisions of Section 3700 of the California Labor Code that require every employer to be insured against liability for Workers' Compensation or to undertake self- insurance in accordance with the provisions of that Code, and agrees to comply with such provisions before commencing the performance of the Services. 16.0 Entire Agreement This Agreement contains the entire agreement of the parties with respect to the subject matter hereof, and supersedes all prior negotiations, understandings, or agreements. This Agreement may only be modified by a writing signed by both parties. 17.0 Severability The invalidity in whole or in part of any provisions of this Agreement shall not void or affect the validity of the other provisions of this Agreement. S7296- 0001\1423855v1.doc 7 of 9 18.0 Governing Law This Agreement shall be governed by and construed in accordance with the laws of the State of California. 19.0 No Third Party Rights No third party shall be deemed to have any rights hereunder against either party as a result of this Agreement. 20.0 Waiver No waiver of any default shall constitute a waiver of any other default or breach, whether of the same or other covenant or condition. No waiver, benefit, privilege, or service voluntarily given or performed by a party shall give the other party any contractual rights by custom, estoppel, or otherwise. 21.0 Prohibited Interests; Conflict of Interest 21.1. Consultant covenants that it presently has no interest and shall not acquire any interest, direct or indirect, which may be affected by the Services, or which would conflict in any manner with the performance of the Services. Consultant further covenants that, in performance of this Agreement, no person having any such interest shall be employed by it. Furthermore, Consultant shall avoid the appearance of having any interest, which would conflict in any manner with the performance of the Services. Consultant shall not accept any employment or representation during the term of this Agreement which is or may likely make Consultant "financially interested" (as provided in California Government Code § §1090 and 87100) in any decision made by City on any matter in connection with which Consultant has been retained. 21.2. Consultant further warrants and maintains that it has not employed or retained any person or entity, other than a bona fide. employee working exclusively for Consultant, to solicit or obtain this Agreement. Nor has Consultant paid or agreed to pay any person or entity, other than a bona fide employee working exclusively for Consultant, any fee, commission, gift, percentage, or any other consideration contingent upon the execution of this Agreement. Upon any breach or violation of this warranty, City shall have the right, at its sole and absolute discretion, to terminate this Agreement without further liability, or to deduct from any sums payable to Consultant hereunder the full amount or value of any such fee, commission, percentage or gift. 21.3. Consultant warrants and maintains that it has no knowledge that any officer or employee of City has any interest, whether contractual, non - contractual, financial, proprietary, or otherwise, in this transaction or in the business of Consultant, and that if any such interest comes to the knowledge of Consultant at any time during the term of this Agreement, Consultant shall immediately make a complete, written disclosure of such interest to City, even if S 7296- 000111423855v 1. doc 8 of 9 such interest would not be deemed a prohibited "conflict of interest" under applicable laws as described in this subsection. 22.0 Attorneys' Fees If either party commences an action against the other party, either legal, administrative or otherwise, arising out of or in connection with this Agreement, the prevailing party in such litigation shall be entitled to have and recover from the losing party all of its attorneys' fees and other costs incurred in connection therewith. 23.0 Exhibits All exhibits referenced in this Agreement are hereby incorporated into the Agreement as if set forth in full herein. In the event of any material discrepancy between the terms of any exhibit so incorporated and the terms of this Agreement, the terms of this Agreement shall control. 24.0 Corporate Authority The person executing this Agreement on behalf of Consultant warrants that he or she is duly authorized to execute this Agreement on behalf of said Party and that by his or her execution, the Consultant is formally bound to the provisions of this Agreement. IN WITNESS WHEREOF, the Parties hereto, through their respective authorized representatives have executed this Agreement as of the date and year first above written. CITY OF SEAL BEACH By: Attest: By: Jill R. Ingram, City Manager Linda Devine, City Clerk Approved as to Form: By: Quinn Barrow, City Attorney S7296- 0001 \1423855v1.doc 9 of 9 CONSULTANT Name: LA -tes vs! its: C�3 By: Name: 14:iQ lkgi, Its: CVO S7296-0001\ 1423855v1.doc Exhibit "A" Scope of Services (Proposal) DIGITAL MAP PRODUCT Digital Map Products Response to: City of Seal Beach Request for Proposal Geographic Information System Prepared by: Digital Map Products, Inc. 18831 Von Karman Avenue Irvine, CA 92612 Phone: (949) 333 -5111 Fax: (949) 333 -5112 Contact: Benjamin Webb Project Manager (949) 333 -5186 Date Submitted: December 15, 2011 PSO M Ars Eig DIGITAL MAP PRODUCTS TABLE OF CONTENTS W7 * �ra Public Works PROPOSAL - Geographic Information System SECTION TITLE PAGE Section I. TECHNICAL APPROACH 5 DIGITAL MAP PRODUCTS, INC. 5 PSOMAS 5 Section II. SCOPE OF SERVICE 5 WORK ELEMENT 1- PHOTOGRAMMETRIC SERVICES 5 WORK ELEMENT 2 (OPTION A) - DATA CONVERSION & ENHANCEMENT WORK ELEMENT 2 (OPTION B) - DATA MIGRATION 11 WORK ELEMENT 3 - WEB -BASED GIS SYSTEM 13 DMP PRODUCT FUNCTIONALITY TABLE 15 CITYGIS'' CONCIERGE SERVICES 16 WORK ELEMENT 4 - LINK EXISTING AS-BUILDS 17 WORK ELEMENT 5 - DATABASE TEMPLATES FOR WATER & SEWER, 18 WORK ELEMENT 6 - GIS NEEDS ASSESSMENT & IMPLEMENTATION 18 OPTIONAL WORK ELEMENT 1- DATA DELIVERY 21 OPTIONAL WORK ELEMENT 2 - INTEGRATION OF FUTURE UTILITY INFORMATION INTO GIS 21 Section III. PROFILE OF THE FIRMS 22 COMPANY PROFILE - DIGITAL MAP PRODUCTS 22 PROJECT TEAM MEMBERS - DIGITAL MAP PRODUCTS 23 RESUMES 24 COMPANY PROFILE - PSOMAS 28 PROJECT TEAM MEMBERS - PSOMAS 28 RESUMES 29 Section IV. REFERENCES 38 DIGITAL MAP PRODUCTS 38 PSOMAS 39 Section V. FEE SCHEDULE 40 Section VI. BUDGET 41 Section VII. ACTION PLAN 42 Page 1 4 DIGITAL MAP PRODUCTS SECTION I. TECHNICAL APPROACH Psomas SECTION II — SCOPE OF SERVICES Pok!!C Works PROPOSAL — Geographic Information System Digital Map Products, Inc. A GIS system offers a city many advantages including increased efficiency, better decision making tools, and cost savings. While assembling the individual GIS components is crucial, successful GIS systems require leadership, an understanding of the process, a GIS needs and implementation strategy, and on- going professional guidance. The DMP and Psomas team combines 35 years of leadership and innovation in the implementation of GIS systems. The DMP and Psomas team have a proven work plan gained from years of experience with similarly sized cities across the region. Each work element in the Scope of Services is designed to not only meet the requirements of the RFP but to guide the city towards the successful implementation of a GIS system. DMP's core competency is acquiring and processing a wide range of commonly needed data sets and providing an easy to use navigation tool to leverage this content from one location via a web -based platform. With nearly 15 years of municipal experience in Southern California, including many long -term clients, DMP knows the tools, personnel, and data necessary to make a GIS system successful. Lastly, DMP recognizes that alternative proposals may offer more cost effective photogrammetric services. Psomas is the preferred photogrammetric services provider because of their high quality product offering but DMP is open to alternative photogrammetric services providers combined with our other proposed work elements. DMP is flexible and wants the City to succeed in the development and implementation of their GIS system. Psomas is a leader in providing high quality and precise aerial imagery, digital elevation models, and contours. Small miscalculation or shortcuts can greatly reduce the overall quality of photogrammetric services. The Psomas Team is composed of GIS experts fully capable of handling your data conversion and management needs. Psomas has been serving municipal clients across California for over 20 years. With Psomas in the lead on providing these critical data elements, you can rest assured that you will receive the highest quality product. An invaluable work element in the creation of a GIS system is the development of a GIS Needs Assessment. This process gathers and informs stakeholders, identifies key issues, develops top -to- bottom buy -in and develops a process for change management. This process and resulting document will be the roadmap for the implementation and evolution of GIS for the next 10 years and beyond. Psomas will lead the process and development of the GIS Needs Assessment and DMP will handle the on -going updates and stakeholder meetings in the years to follow. Both DMP and Psomas are committed to the successful implementation of this GIS system. Work Element 1: Photograinmetric Services (Aerial, DTM, LiDAR) The creation of new orthorectified aerial imagery for the city's GIS system shall be accomplished through an integration of new LIDAR data and new aerial photography. With the requested final Page 1 5 DIGITAL MAP PRODUCTS ,p d Public Works PROPOSAL - Geographic Information System products and with considerations to costs, we propose that the project be flown with photography at a nominal scale of 1" =500' (allows the creation of 0.25' pixel resolution without over resampling). Task A. Aerial Photography • Appropriate communications will be established priorto flight to coordinate airspace restrictions. • 24 HV targets will be pre - paneled and controlled priorto flight. • When weather conditions prevail we will fly the 9 strips at an altitude of 3000' above ground. • The exposures will be shot with a 60% overlap and 30% sidelap to establish the stereo models for map extraction • The aerial negatives will be scanned at 12.5 microns to attain the necessary resolution for the final Orthorectification. Task B. LIDAR • The LIDAR flight will be planned concurrent with the aerial flight mission • Data acquisition will be from 4000' above ground for a vertical accuracy of 95% at 0.6' Task C. DTM Surface (Contours) • The DTM /DEM surface will be created from an integration of LIDAR data and breaklines extracted from the aerial stereo models. The breaklines will supplement the LIDAR points to help define hard - breaks and terrain changes that the LIDAR density may not capture. • This surface will be the foundation for the Orthorectification process. Geometric and radiometric corrections will be applied to create a seamless Orthophoto mosaic with a 0.25' pixel resolution. (Delivered in a TIF and SID format with corresponding world header file) • 1' contours will be generated for GIS application only (not suitable for design). Task D. Hardcopy prints • 25 plots (tiles TBD) will be generated from the mosaic at a scale of 1" =300' at 400 DPI on %z" Gatorboard with mounting blocks included. o City boundary, scale, index and north arrow shall be included in each plot. • A single plot showing the full city limits can be plotted at a scale of 1" =600' on a 42" x 42" board Task E. On - Going Imagery Updates • To maintain regularly updated imagery in a cost effective manner the City has the option of purchasing Eagle 1ft imagery on an annual basis. Many existing DMP clients annually purchase imagery to maintain a robust and current GIS system. • DMP and Psomas recommend flying new hi -res aerial imagery after 5 years. Similarly sized cities typically update their in -house imagery in 5 year increments. It is likely that technology will improve and costs will be reduced for equivalent imagery in the future as referenced in Year 6 in the Budget. Work Element 2 (Option A): Data Conversion and Enhancement This option (A) provides the preferred and suggested solution for the City. In order to fulfill the City's desires as specified in the RFP, the corresponding GIS requires high - quality utility data. Based on the RFP, Psomas assumes that the City has already determined that GIS data, with higher quality than the existing shapefiles) is necessary through some type of data conversion and /or enhancement efforts. Page 16 DIGITAL MAP PRODUCTS } a. s e , e► -1 Public Works PROPOSAL - Geographic Information System The existing utility data samples (presented in shapefile format) do contain spatial and attribute information and are not consistent with the requirements of high - quality GIS data. Building on this exiting GIS utility data, in lieu of conversion, will not produce data repository with proper controls (i.e. format, accuracy, maintenance, and functional standards) that can address the City's current application needs in any sustainable manner. The existing format can serve as a great platform for reference but will be insufficient as a source dataset for utility database. The new GIS utility data should be converted /generated from as -built drawings (per RFP requirements,) thus providing quality spatial location with underlying feature attributes already identified as industry standards and adopted by other cities with similar GIS needs. In addition, creating high quality GIS utility data now will ensure the implementation of functions (desired applications) identified in the RFP, as well as enabling sustained and flexible future enhancements, such as utility network tracing, public utility work orders, infrastructure reporting, facility management, utility modeling, utility maintenance, planning, etc. Psomas recommends data conversion of the water, sewer, storm drain, and other landbase attributes from as -built drawings, tract maps, and parcel maps. The conversion process will produce respective geodatabase /featureclasses. This approach will ensure seamless integration with CityGIS, and that City's current investment in ArcGIS tools are leveraged and extended. Psomas will create the GIS datasets following DMP's standard data layer models to allow the City to capitalize on advanced layer integration and future functionality. The data conversion will be accomplished through following sub - tasks. Task A. Data Assessment Collect and assess required source documents and existing GIS data, identify gaps, define the City's GIS data standards, and develop a draft conversion plan describing the conversion process and expected product /deliverables. The following data attributes are included in the assessment: • parcel, streets • city facilities /buildings • tree data (existing) • water system assets • sewer system assets • storm drain assets Psomas will acquire the current parcel and centerline data from DMP. An Access database will be used to inventory and track all data received. Psomas will evaluate each data layer to determine its level of quality and usefulness for the project. Psomas will create a Data Dictionary based on the Inventory report submitted which will document the data structure of all data layers and tables received. For each layer and table inventoried, the document will identify all field characteristics (such as field name, type, size, keys, and domain), relationships (attribute and spatial), and spatial projection information. This Data Dictionary will be updated to include the new featureclasses and tables created for this project. Deliverables: • Data Inventory in Microsoft Access format • Data Dictionary in Microsoft Excel format Page 1 7 TABLE MATCHING CI -IECK FAIL 21 FIELD MATCHING CHECK PASS 0 CHECK IIYDRANT SOURCE PASS 0 CHECK LATERAI.INF PROJECTNUMBER PASS 0 CI IF.C FITI ROTATION PASS 0 CHECK NULL .- NNO LENGTH PASS 0 GI:C)DATA13AS1i VALIDATION WARNING 795 DIGITAL MAP PRODUCTS Task B. Conversion Plan and QC Plan Develop and finalize the conversion plan and quality control plan through subtasks as presented below. Data Conversion Plan An enhanced mapping specification will be prepared defining feature spatial positioning, attribution, topological, and metadata requirements. The specification expands beyond the ESRI data model to address the complete definition of the GIS data deliverables. The migration plan describes all rules and processes used during the mapping of the utility featureclasses including topology and geometric network rules required for the geodatabase. The Data Conversion Plan also documents the workflow for mapping the utilities from the City's current scanned drawings, quality management and confirmation, data loading into Geodatabase and City review and acceptance processes. Quality Control Plan This plan will document acceptance criteria and how testing will be performed and compliance to the data specification confirmed. The Quality Control Plan (QC Plan) identifies quality requirements, quality control procedures, data flow between the City and Psomas, and tools and methods for testing the conformance of the data to the defined specifications. The Quality Control Plan includes automated and visual testing of each deliverable. Psomas will use our quality control software application configured to the City's data specifications to evaluate data quality. The application provides complete testing of all database elements and rules. Examples of output from the application are presented below. .9utuninted Cheeks Sununmy Tint Result Errors Figure: Sample Automated Report Summary Public Works PROPOSAL - Geographic Information System Page 1 8 DIGITAL MAP PRODUCTS Figure: Sample Detailed Report Summary Deliverables: • Draft Data Model Diagram • Data Conversion Migration Plan • Quality Control Plan • Proof of Concept Geodatabase (pilot) ids) a f � ZAZ laTA Public Works PROPOSAL - Geographic Information System Reason Rertsa,r Fining junction /i•unrre r'uhn•pe: SIcere/ tour nut eornn•c•i to the Pre...v•ccdAlai,r edge feature (subtype: l)r..tr•ibution.11urn/. Reason Fining junction, feature tsuhrrpe: Cowl may not connect to the• Lutc•ralLine cdge rsubtrpc•: Metered t. Object Id 1852 Object Id 2636 Fitting junction feature txubt pe: Topping . It ( (') may n01 c onneet m the l,,ncrull.icrc edge frown. (subtype: Ilydr•uutLutcr•ulcl. Object ld 559 560 1932 Task C. Pilot Data Conversion Based on the definitions from the assessment findings, develop geodatabase templates for each GIS featureclasses. Conduct pilot conversions of each featureclass to validate the processes outlined in the conversion plan, and /or identify modification requirements. Develop Data Model Once the existing data sources are documented in the Data Dictionary, an overall GIS Vision Data Model diagram will be developed using the ESRI utility data models as a templates. The diagram will show all the data layers, tables and their relationships to each other and the systems that will integrate with GIS and DMP. Develop Preliminary Metadata Requirements Psomas will define the metadata requirements that document detailed aspects of the GIS data content, sources, accuracy, and development processes. Metadata will be documented within the ESRI ArcGIS environment using the Federal Geographic Data Committee FGDC and ISO standard. Psomas will document the metadata requirements in the Data Conversion Plan. Develop Proof of Concept Dataset A small area of the City will be used as a proof of concept to verify that the data model, data conversion process, and Data Conversion Plan meet the City's expectations. A sample Personal Geodatabase will be created that represents that logical model. Psomas will meet with the City to review the proof of concept dataset and how it will be integrated with CityGIS and how City staff may work with the data in ArcGIS. Page I 9 DIGITAL MAP PRODUCTS Quality checks will be conducted at two levels. 0. feak . asrszcX Public Works PROPOSAL - Geographic Information System Develop Final Geodatabase Model Once the City has approved the final data models, Psomas will generate a Personal Geodatabase that matches the data model. The Geodatabase will include all datasets, featureclasses, tables, relationships, Geometric Network/Topology, and domains. Deliverables: O Final Geodatabase Model Task D. Conversion Perform conversion activities for the remaining source documents through sub tasks described below. Geo- Referencing of As -built Plan Maps As -built Maps will be geo- referenced based on the existing Iandbase using ArcGIS. The location of As -built maps will be identified using the existing parcels with reference to the street names. An RMS error report will be generated. The error report will be used as criteria to check the Geo- referencing results. Spatial Alignment of Existing Data Features will be spatially aligned based on parcels using ArcGIS. The spatial adjustment will be carried out using "Transformation - Affine" (scaling, rotating, and shifting) with reference to the control points. Update Layers and Edge- Matching Before updating, the geo- referenced As -built Maps and existing data are verified to be in the right location. The existing parcels are used as a reference in the background. All Point and Linear features are updated as per the procedures in the Conversion Plan. Utility assets and its features are to be seamlessly edge matched between As -built maps to create a seamless wastewater data network feature. Task E. Post Conversion Processing and Final QC Perform any required post conversion processing to ensure seamless integration with CityGIS and establish ongoing maintenance standards to incorporate future updates. Once integrated, perform final QC and acceptance testing with the City representatives. Psomas will perform quality control according to the Quality Control Plan at each significant processing step and final quality control at the conclusion of the adjustment and update task. Final Quality Control is performed independently from the conversion team. Automated and manual checking procedures will be employed to test and document the quality of the data. The data will meet the minimum accuracy standards (98% correct) established for the project. Psomas will perform all tests identified in the Quality Control Plan and develop Quality Control report. Each test will indicate PASS, FAIL, or WARNING. A warning indicates that the test found potential errors. These records need to be reviewed. If any tests fail, the report is sent back to the conversion team for correction. Page I 10 DIGITAL MAP P RODUCTS Plot - Quality Check The completed production file will be plotted and checked with respect to the scrubbed hardcopy for missing features, wrong placement and wrong attributes which will be marked on plotted maps. If an error exceeds the criteria it will be sent back to production, if errors are within criteria that is passed to next preceding process where these errors are also fixed. Screen /Automated - Quality Check The Following checks will be performed and any identified errors will be corrected: • Check the data as per the "Acceptance Criteria" derived from the Quality Control Plan. • Check for data /attribute completeness and correctness with respect to source images • Check for the appropriate feature placement with respect to source images • Check for connectivity errors and snapping errors. • Run Automated QC application Delivery Management All deliveries will be delivered on CD or DVD. The final delivery will include the Quality Control Report. The final geodatabase will also be submitted to DMP for integration into CityGIS platform. Deliverables: • Geodatabases • Quality Control Report Task F. Map Production Psomas will create a Map Book Template using ArcGIS to facilitate atlas book generation. The application will allow the City to print entire Map Books or individual pages. The pages will be based on Assessor Map page extents. Deliverables: • ArcMap Map Book template • Hardcopy version of Map Book Work Element 2 (Option B): Data Migration Public Works PROPOSAL - Geographic Information System This option (B) is designed to leverage the City's existing GIS data and extend its utility by migrating it to geodatabase format, thus building the foundation for accurate utility data framework. Psomas will perform data migration for water and sewer data (existing in shapefile format) and develop additional features (i.e. City facilities, street centerline) that are already in digital format. The migrated geodatabase will enable capture /integration of all future data sources. The Option (B) does not include data conversion processes and thus exclude storm drain dataset if they are still in hard copy format. Without full data conversion process, the accuracy of the existing data sets will be carried onto the new geodatabase. Task A. Data Assessment Collect and assess required source documents and existing GIS data, identify gaps, define the City's GIS data standards, and develop a draft conversion plan describing the conversion process and expected product /deliverables. The following data features are included in the assessment: • parcel, streets Page 1 11 VI DIGITAL MAP PRODUCTS �._ Rally Works PROPOSAL - Geographic Information System • city facilities /buildings • tree data (existing) • water system assets • sewer system assets Psomas will acquire the current parcel and centerline data from DMP. An Access database will be used to inventory and track all data received. Psomas will evaluate each data layer to determine its level of quality and usefulness for the project. Psomas will create a Data Dictionary based on the Inventory report submitted which will document the data structure of all data layers and tables received. For each layer and table inventoried, the document will identify all field characteristics (such as field name, type, size, keys, and domain), relationships (attribute and spatial), and spatial projection information. This Data Dictionary will be updated to include the new featureclasses and tables created for this project. Deliverables: • Data Inventory in Microsoft Access format • Data Dictionary in Microsoft Excel format Task B. Geodatabase Design Based on the definitions from the assessment findings, develop geodatabase templates for each GIS featureclasses. Develop Data Model Once the existing data sources are documented in the Data Dictionary, an overall GIS Vision Data Model diagram will be developed using the ESRI utility data models as a templates. The diagram will show all the data layers, tables and their relationships to each other and the systems that will integrate with GIS and DMP. Develop Preliminary Metadata Requirements Psomas will define the metadata requirements that document detailed aspects of the GIS data content, sources, accuracy, and development processes. Metadata will be documented within the ESRI ArcGIS environment using the Federal Geographic Data Committee FGDC and ISO standard. Psomas will document the metadata requirements in the Data Conversion Plan. Develop Final Geodatabase Model Once the City has approved the final data models, Psomas will generate a Personal Geodatabase that matches the data model. The Geodatabase will include all datasets, featureclasses, tables, relationships, Geometric Network /Topology, and domains. Deliverables: • Geodatabase Model Task C. Existing Data Migration Psomas will perform data processing to transform existing shapefiles to comply with the geodatabase requirements, and then migrate the existing data into the new geodatabases. Data Development Page 1 12 DIGITAL MAP PRODUCTS For non - utility feature classes, Psomas will develop data (City facilities, trees, street centerline) from existing digital data sets. Information not in digital format (i.e. hard copy maps) will not be converted nor included in the new database. Data Migration For utility feature classes, provided in shapefile format, Psomas will process and migrate into the new geodatabase. The final geodatabase will also be submitted to DMP for integration into CityGIS platform. Deliverables: • Geodatabase Task D. Map Production Psomas will create a Map Book Template using ArcGIS to facilitate atlas book generation. The application will allow the City to print entire Map Books or individual pages. The pages will be based on Assessor Map page extents. Deliverables: • ArcMap Map Book template • Hardcopy version of Map Book Work Element 3: Web -Based GIS Bundle fi t/ Public Works PROPOSAL - Geographic Information System Through the RFP process, the City voiced their overall GIS needs and requirements that they hoped to accomplish in the near term as well as requesting more long -term solutions. Based on this knowledge, DMP proposes a comprehensive web -based GIS bundle that includes the CityGISTM subscription as well as on -site GIS Concierge Services. DMP strongly believes that this combination of services not only fulfills the short term objectives of this RFP but also provide for long -term GIS success at the City of Seal Beach. CityGISTM" Enterprise CityGISTM provides a powerful, easy -to -use Internet -based software application that enables users to find, view and search subject properties, use aerial imagery backdrops and parcels to analyze important data, use access to property and tax data to find ownership, use the drawing and annotation tools that incorporate aerial imagery and search inquiry tools into presentations, and more. With CityGIS, city staff will be empowered from the start with functionality and capabilities to truly interact with City maps and data and be able to collaborate effectively on projects, not just view data with a starter application. The latest CityGIS software updates and technology additions are automatically installed and available to subscribers as part of the service. With licensing of CityGIS, your Information Technology (IT) staff will not be tasked with complex, vertical technology implementation. Using the CityGIS Hosted Subscription model, DMP takes responsibility for everything "behind the screen ". DMP offers high availability (24/7) and performance (application uptime minimum of 99.9 %) as well as all system and data backups, offloading maintenance and infrastructure headaches from IT staff. The DMP application service platform is co- located at a secure $100M SBC facility in Irvine, CA with a backup facility located in Austin, TX. With this model, DMP clients enjoy the benefits of easily accessible, large- scale, highly functional systems that do not require extensive resources or personnel to develop and maintain. Pagel 13 El DIGITAL MAP PRODUCTS Psl1/ls Works PROPOSAL - Geographic Information System As the City's GIS grows and evolves, the CityGISTM will grow with you. The City has identified Public Works as the first department to utilize the new GIS system. With CityGISTM, you will incur no additional cost as additional users and departments are brought on- board. DMP has already set up an account for the City of Seal Beach which includes all standard data layers and full functionality. The City can begin to utilize the CityGISTM solution now and as other work elements are completed as part of this RFP, they will be seamlessly incorporated into CityGISTM. The City can fully evaluate CityGISTM for the next 30 days. To access this service, go to: URL: http : / /maps.digitalmapcentral.com User ID: CityofSB Password: Dmp123 Account ID: sealbeach CityGISTM Functionality CityGISTM was designed to be both intuitive and easy to use for any professional, regardless of their background or work responsibility. CityGISTM utilizes industry standard map navigation tools including zoom in and out, pan, zoom to full extent, and zoom to selected features. Collaboration tools include the ability to export a map image, email a view, and print functionality. Within CityGISTM, users have a wide variety of search tools including search by owner, address, APN, street name, location, land use, zoning, and sales transaction. Additional, advanced functionality is described below: Notification & Mailing Lists Once a search has captured results based on designated criteria, you have the ability to quickly create address labels. You have the option to include APN and designate whether it goes to Site or Owner address. Buffer Search A Buffer search can be done on an active parcel to encompass all parcels within a specific distance. The resultant search would generate a list of all parcels that fall within that radius. Similarly, you can draw a LINE on the map and run a buffer search and collect all parcels within a specified distance. Finally, you can draw a closed POLYGON and capture all parcels that fall within the boundary. Multiple search results can be consolidated into one "Master Results List ". Measure Tools There is a generic "Measure — On /Off" setting that will provide distance, boundary, and area measurements for any active entity. (Parcel, Line, Polygon). The measure tool will allow you to measure anything on the map in an "Active" format. This also includes distance and area. Attached Document Once an object is identified (Parcel, SCAG Data Layer Entity), an electronic file (JPEG, TIFF, Word, Excel, PDF, etc.) can be attached to that object to add additional valuable information that relates to it. Multiple objects can be added to any object. Extract The extract function provides ability to query a set of data and pull this data from the system in the form of a CSV /Excel file or a Shape file for use in other applications such as other ESRI Arc applications. Parcel Edit Override Market research has proven that property records are not 100% complete or accurate, regardless of source. DMP provides this Editable Data Layer to help address this need. If Property information is Page 114 DMP Product Functionality Table Update Frequency National Center for Education Statistics Public Schools Annual School Districts Annual TeleAtlas Data Street Centerlines Bi- Annual Railroads Bi- Annual Parks Bi- Annual Census Tracts and Blocks Bi- Annual Postal Codes Bi- Annual Points of Interest Bi- Annual Water Bi- Annual Political — City, County, State Bi- Annual Parcel Data Parcels Boundaries Annual Property Records & Owner Information (Assessor) Annual Property Records & Owner Information (Sales) Weekly Tax Maps Annual Aerial Imagery Eagle Imagery Annual Microsoft Bing Imagery Based on Microsoft USGS Aerials As Required USGS Topo As Required Hazards Data FEMA DFIRM Flood Quarterly USFWS Wetlands As provided Seismic Liquefaction As provided Wildland Fire As provided Severe Fire As provided Fault Zone As provided Dam Inundation As provided DIGITAL MAP PRODUCTS f f orzzie La Public Works PROPOSAL - Geographic Information System found to be incorrect (prior to an update occurring), CityGISTM allows user to edit the record via this Data Layer so that property information is up to date. The system will identify the source of change and keep a change log. Once updates occur to Property data, those changes will be flagged. Parcel Notes Property notes provide the ability to make general notes by type about a property (Parcel Owner, Tenant, and Condition Note) along with other related fields. These fields are all searchable for later use. Image Overlay This functionality allows for images to be overlaid on the map with partial transparency used in combination drawing and annotation tools, it makes this a great tool for presentation of proposed ideas. Markup Tools Markup tools are provided to make presentation of data more impactful. These markups also contain searchable attributes that allow you to find this information for later use. Markup Tools include lines, polygons, symbols, text, and leader lines including entity property controls. Other layers are also available upon request such as: Trees, Signs, Capital Improvement Projects, NPDES, etc. CityGISTM is a GIS hosted subscription that will enable Seal Beach to leverage an intelligent, interactive map that incorporates the datasets listed in the table below. The data below is included for all of the city as well as areas within a 500' buffer of the municipal boundary Page 115 DIGITA MAP PRODUCTS mktit _zip few 1 ;aced Public Works PROPOSAL - Geographic Information System CItyGISTM Concierge Services The on -site concierge service is our company's gold standard service program. The experienced DMP team will work with you to help manage and direct your GIS initiatives. Through years of work, with cities of your size, DMP has identified the most crucial elements necessary for long -term GIS success. Many DMP client communities lack the time necessary to lead and guide a city -wide GIS system. In many instances, after the initial services work is complete and the GIS system is installed, only a few individuals utilize the data and momentum is lost. DMP strongly believes in on -going management of not only the GIS system and but the individuals, departments, and decisions as part of the GIS system. As part of this management, DMP will create and foster a city -wide GIS stakeholders group that will meet on a bi- annual basis. This group will be composed of technical liaisons as well as key decision makers. Through involvement in the GIS Needs Assessment planning process, DMP will be well prepared to build off of the plan and guide the needs, decision and best practices of the City. In addition to management, DMP proposes on -site bi- annual training to engage new and long -time employees in a more intimate learning environment. The City will receive two on -site training sessions tailored around relevant topics and issues. In these sessions, City staff can explore departmental specific workflows, advanced functionality, industry best practices and learn about new data and data sources. DMP will work with Seal Beach to ensure that the proper blue print is created and the necessary steps are taken to achieve these milestones. We are going to provide the essential resources, continuing education, product management, and the overall best practices that will create a successful environment for the city. Task A. CityGIST"' • DMP will work with the City to ensure staff computers are configured to maximize their CityGIST"" experience (95% of user computers are properly configured from the start, requiring no additional changes). • DMP will gather a list of users and passwords from the City so all staff can login into the web -based system. • The City and DMP will set up a training schedule for City Staff to ensure all users are given the necessary education to utilize the system. • Support line is available 24/7 for all technical questions related to CityGIST' • All DMP clients benefit from free online documentation, bi- monthly webinar trainings, as well as on- demand training videos. Task B. CityGlS"" Concierge Services • Onsite Training o Each year, DMP will conduct two on -site CityGISTM training sessions for staff focused around the specific needs of the City. • GIS Management Support o Establish a City GIS stakeholder group based on findings from the Needs Assessment process. o Facilitate and support the GIS Stakeholder group at bi- annual meetings o Manage meeting agenda items, GIS implementation, needs, and key decisions. o This group will be composed of technical liaisons as well as key decision makers. DMP will facilitate and support this group at bi- annual meetings. Page 1 16 DIGITAL MAP PRODUCTS Task A. Attain URL links to document image library Guide the City in the creation of URL links to the Sewer, Water, Parcels, and Storm Drains and Streets layers Task 8. Create URL link in GIS Data DMP will develop links to appropriate features within each layer in CityGISTM Task C. Utilization of links within CityGIS CityGISTM' user will be able to click (Identify) a feature within the linked layer and then be offered the option of clicking a link which opens the as -build document. 0/ (0;z/ca. (/ Public Works PROPOSAL - Geographic Information System Work Element 4: Link Existing As- Builds CityGISTM' has the built -in capability of providing users with the ability to view as- builds and other document images within the application. As identified in the pre - proposal Q &A, you have over 3,500 as- builds spread across 6 different file types. CityGIS" 6: Dom estic Water Mis ACRD ANGL 71146 ! , • � Source Doc 4 ecentty voewed DWYG?A6 DW0263 04 Itirt Page 117 DIGITAL MAP PRODUCTS e Palle Works Work Element 5: Database Templates for Water & Sewer The ability to in sewer or water issues to related parcels is a common workflow for many cities. DMP recognized this need and has built -in functionality within CityGISTM to address this task. Within CityGISTM the user searches to the parcel associated with the water or sewer issue and is then offered a full menu of information associated with that specific parcel (property information, transaction history, zoning, land use, hazards delineation, political districts and more) as well as ways to interact and add information to that specific parcel. Two feature links within this menu of data and information include the "Attach Document" and "Add a New Note ". Each feature allows the user to upload or input information and have it attached to that parcel as a searchable and editable layer within CityGISTM. Task A. Develop a Workflow for Water & Sewer Issues Work with City staff to determine which technique is most applicable to City data and needs. Task B. Train Staff on Linking Water & Sewer Issues PROPOSAL - Geographic Information System Note type Parcel Owner Note Desolation. Rle• 1 Submit !Close I Browse... I aboutblank Property APN 04344234.!" t:, APN: 34311234 Lot Depth: Address: 311 MAIN ST . SEAL BEACH CA. 93740 Owner Name: KARAHALIOS.MICHAEL E TRUST Owner Address: 939 ELECTRIC AVE 214. SEAL BEACH CA, 90740 Owner Phone: • Building SF: 12933 Acres (Assessor):3.5422 Acres 3.5422 (Calculated): Lot Front - I STANTON & LOTHIANS 1ST ADD LOT 1 BLK 206 Description: (AND LOTS 3. 5, 7, 9, 11, 13 6 15 updaale zone z Land SF Assessor): Land SF Calculated): 23617.0 23617 0 Land Use: COMMERCIAL: COMMERCIAL (NEC) ear Built 1953 ssessed Value: 53,115,002 8M Page: E4-625 silica q?roJeatt rs'`_7•.+1 . Mt _�.aonvrtszwtrt7 5 a,.� :e... �.�f!ii�r6l:wt.3RaGV•sF.M al�s't' 1�G.' r iteliNe, T'P_ry .trr... ew FIRM Panel: 06037C2076F effective 09/26/20013 U FIRM Panel: 06059CO226J effective 12/03/2009 U Not In A Flood Zone (Zone X) Mau moglas U Tax Maps U In Dam Inundation Hazard U In One Mile Industrial Commercial Zone U Not in 100yr FEMA Flood Zone U Not in Fault Zone Hazard Li Not in Seismic Landslide Hazard Work Element 6: GIS Needs Assessment & Implementation Psomas will perform GIS needs assessment and implementation planning in a systematic manner consistent with our proven methodology that provides predictability of outcomes, process efficiency, and thoroughness to assure the needs and opportunities are addressed in our recommendations. The project methodology has been developed and refined through over 50 GIS strategic planning projects of varying scales and focus, including large agency enterprise strategic plans down to focused departmental plans. The project methodology provides an incremental and progressive means for developing a GIS strategy and work plan aligned to address the needs and priorities of the City. Key to the Psomas methodology is engagement of stakeholders and defining clear linkages between GIS application and the business Page 1 18 DIGITA MAP PRODUCTS Public Work PROPOSAL — Geographic Information System processes they support. City's stakeholders buy -in and clear business justification for GIS are essential plan elements. Psomas will perform GIS needs assessment activities to capture current GIS and other technology environment, identify unmet business and operational needs that can be enhanced with GIS, and develop GIS implementation plan describing a practical road map. Psomas will employ our proven methodology, as depicted in the below diagram, that derives at necessary implementation starting from business needs that defines corresponding GIS application, which in turn, identifies information needs. �C titi:R Environmental Trends —' Business Needs Document Business Needs Step t Step 2 Apptcahon Needs Dale Needs Detine GIS Solutions Program Goals Weedier GIs hnplmramaion Prefects Mai rganiza - t lprlal Benefda �; Industry gest PnGticee 8tenduds orld;S t31Drw ! = Develop EGIS Goals Strategy and and Directions Implementation Planning Step S Step 4 . K F r .f7!YF7' '�3�r_ ' ?fi Task A. Document Business Needs and Gap Analysis This identifies business needs of individual stakeholder units and recognizes external drivers including regulations, economy and other environmental trends. Business needs focusing on gaps are documented through a review of existing systems current GIS implementation, departmental interview findings, and a compilation of enterprise needs contrasted to individual business unit needs. Citywide GIS Orientation Facilitate a GIS orientation workshop with City stakeholders to present 1) upcoming needs assessment process, 2) participation requirements and preparation needs, and 3) best practices and case studies to promote common level of exposure, understanding, and expectations. Needs Assessment Interviews The main objective of the needs assessment is to understand the business needs of the City that can be supported and enhanced with GIS. Through individual departmental interviews, Psomas will collect the business needs, GIS application opportunities, data needs, and existing practices, related to GIS. We will also seek departmental perspectives on prioritization of GIS initiatives, risks, key success factors and other opinions to aid in GIS implementation planning. Psomas will work with the City to coordinate interview scheduling and time allocation. Interview durations will be between Y2 hour to 2 hours depending on department size and GIS application opportunities. The City is responsible for scheduling meetings and reserving interview space. Psomas would like to meet with departments intheir workspace areas so that we can see the Page 119 DIGITAL MAP PRODUCTS oda afkaz4 Public Works PROPOSAL - Geographic Information System physical setting and how they currently use geospatial data, access documents, maps, information systems, and other relevant information. Psomas may conduct interviews by telephone with any outside agencies that are currently or potentially contributors to City GIS operations. Psomas will document the Aggregate Needs Assessment Report which includes the following elements: • Current environment summary • Business needs for GIS • GIS Application needs • Data and maintenance needs • Technology needs • Operations and maintenance • Governance and organization Deliverables: • Orientation Presentation • Aggregate Needs Assessment Report Task 6. GIS Implementation Planning The implementation planning will transform aggregated GIS needs into practical GIS initiatives /projects that can be prioritized for consideration and implementation. The resulting recommendations, compiled into the implementation plan, will define a practical road map that identifies tasks that the City must perform to execute and sustain. Each GIS initiative /project will be defined with the following elements: • Objectives • Functional requirements • GIS technology components • Project implementation tasks • Recommended schedule • Estimated project budget (for planning purposes only) • Special considerations (i.e. special resources, change management, etc) Psomas will present the implementation plan to City management, or any audience City project manager defines, as a final step in the task. The presentation to City management will focus on clarifying the plan elements, desired outcomes, and potential challenges. Deliverables: • GIS Implementation Plan • Presentation Workshop Task C. GIS Implementation Plan Update Conduct two GIS plan update sessions with GIS stakeholder group as defined above. The plan update is recommended annually to ensure appropriate progress and mitigate barriers, challenges, or need for changes to the current direction. Page 120 DIGITAL MAP PRODUCTS Public Works PROPOSAL - Geographic Information System Optional Work Element 1: Data Delivery The City of Seal Beach currently receives an annual on -site data delivery for Parcel boundaries and Property Data at a cost of $ 2,600. If the City had the desire to have this data as part of their in -house GIS system, this data delivery remains an option. However, it is important to note that with a subscription to CityGISTM, the City would receive annual parcel boundary and property data updates and weekly sales transaction information seamlessly integrated into the system at no additional cost to the City. With quick and easy access to this regularly updated parcel information, the City could eliminate this costly data delivery option for Orange County parcel data. Optional Work Element 2: Integration of Future Utility Information into GIS As the city receives new as- builds, this data should be actively incorporated into the existing GIS database to ensure data remains current and accurate. This task will be completed on a time and materials basis with a not -to- exceed budget. Based on the size of the City and our expert opinion, it is estimated that the city should budget $5,000 per year for this service. Task A. Receive As Builds from City Psomas will collect /receive new as -built drawings /images from the City in digital format, compile, categorize, and index. New data source may also extend beyond as -built drawings; Psomas will collect other GIS data sources corresponding to feature classes in the new geodatabase. Task B. Integration of Data into GeoDatabase Psomas will perform geodatabase compliant processing, and migrate new GIS data sources into the City's geodatabase. Psomas and DMP will then integrate updated Geodatabase to CityGIST""platform for immediate usage by the City. Task C. As Builds Linked within CityG15TM Based on a URL link within the GIS database to the As -Build image file, DMP will create functionality within CityGISTM for the user to pull up the As -Build document from the image server. This same workflow was described in Work Element 4. Page [ 21 DIGITAL MAP PRODUCTS • California* • Arizona • Colorado • Connecticut • Florida • Georgia • Illinois • Kansas • Maryland • Massachusetts • Nevada • New Hampshire *California includes the required county: Orange. T� . a Public Works PROPOSAL - Geographic Information System SECTION III - PROFILE OF THE FIRMS Company Profile: Digital Map Products Digital Map Products, Inc. (DMP) has been in business since 1997 and is a privately held company based in Irvine, CA (www.digitalmapcentral.com). The work on this project will be done in our Irvine office, telephone number (949) 333 -5111. DMP extends the power of GIS to the millions of users waiting to use a map to interface with data. DMP develops proprietary software solutions that employ a powerful map -based interface to optimize work flow by automating research and analysis tasks that previously required customers to possess specialized, costly expertise and make significant technology investments. DMP applications are designed to be used by the non - technical audience. The company and its GIS -based "Software as a Service" (SaaS) model provides affordable access over the Internet. DMP collects and maintains the complex databases that fuel the system, providing the industry's only web -based turn -key solution. DMP customers are primarily based in the following markets: • Local, State and Federal Government • Law Enforcement • Builder - Developer • Residential Real Estate • Real Estate Disclosure DMP collects data and hosts it through our applications to more than 525 customers and over 200,000 registered subscribers of DMP SaaS products across the following twenty -three (23) states: • New Jersey • New York • North Carolina • Ohio • Oregon • Pennsylvania • Texas • Utah • Vermont • Virginia • Washington To fuel the DMP Solutions, DMP maintains about 16 terra -bytes of GIS data which is continually maintained by a team of data developers. Ninety percent of DMP's data repository falls into the following categories: • Digital Imagery • Weekly Sales Transactions • National Street Centerline Database • Parcel Boundaries • Property Record Tax Roll • Scanned Assessor Tax Maps • Flood Plain Data • School District Boundaries Pagel 22 DIGpTAL MAP � ) Public Works PROPOSAL - Geographic Information System DMP's data development expert's research, collect, aggregate, enhance and maintain these databases on a continual basis. This extensive ongoing effort is transparent to the everyday users of DMP's SaaS products. Because DMP maintains such a comprehensive data repository, this bulk data can be made available on a very cost effective basis to more sophisticated GIS users who maintain their own hardware /software platform. A growing number of DMP customers are becoming users of both bulk data and SaaS applications. Project Team Members: Digital Map Products James Skurzynski, Project Director As Project Director, Mr. Skurzynski will be the executive level interface between Seal Beach and DMP and have overall responsibility for allocating the required resources to fulfill the scope outlined in this proposal. As President and CEO of Digital Map Products, Mr. Skurzynski is an expert of spatial technology, computing in the cloud and on -line real estate and governmental mapping technology. A founder of Digital Map Products, Mr. Skurzynski has spent the majority of his career designing and managing the deployment of technology solutions in a variety of public and private sector environments. Benjamin Webb, Project Manager As Project Manager, Mr. Webb will be the main liaison between Seal Beach and DMP and responsible for coordinating the tasks and deliverables of this project as well as on -going support for the City and their GIS needs. As Customer Success Team Engineer, Ben works with many DMP government accounts in support of implementing and extending CityGISTM throughout each agency. He has over seven years experience in the GIS and Planning industry as a technical manager and consultant in the public and private sector. Ben has successfully managed numerous land use planning projects with a variety of clients ranging from municipalities to regional economic development organizations. Steven Cheng, GIS Database Administrator As GIS Database Administrator, Mr. Cheng will provide any database analysis and reconfiguration as needed to meet the project requirements. Steven is the Data Development Team Manager at DMP which maintains a data warehouse that serves DMP platform. Steven performs data analysis and develops automated workflows to extract, transform and load data from multiple sources to DMP data repositories. Skip Cody, Senior Software Engineer As Senior Software Engineer, Skip Cody is responsible for custom application development at DMP. He has been with DMP since 2004 and has worked in the GIS /Mapping industry for the past 15 years. Skip's prior work experience was as an application engineer at Thomas Bros. Maps (Rand McNally). He has helped in the design and delivery of many successful GIS application integration projects in both the private and public sector. His project experience ranges from SQL synchronization projects with MLS and Title Companies, to custom GIS workflow applications within State, and Local government. Pagel 23 DIGITAL MAP PRODUCTS Project Team Members Resumes James Skurzynski President 1 CEO Digital Map Products, Inc. - Digital Map Products, Inc. Experience As President and CEO of Digital Map Products, Mr. Skurzynski is an expert of spatial technology, computing in the cloud and on -line real estate and governmental mapping technology. A founder of Digital Map Products, Mr. Skurzynski has spent the majority of his career designing and managing the deployment of technology solutions in a variety of public and private sector environments. Digital Map Products 1 President & CEO, Co- Founder JSA International 1 Managing Partner QC Data De Mexico 1 President QC Data 1 Vice President Professional Design Resources ( Vice President, Co- Founder %) �1 Public Works PROPOSAL - Geographic Information System Present 5.5 years 3 years 6 years 6 years Specialties Entrepreneur, Geographic Information Systems, Spatial Technology, Internet Mapping, GIS in the Cloud, SaaS, GIS Web Services, Startup Company, Local Government Productivity Solutions Co- founder of this venture - backed company that provides spatial -based Software -as -a- Service (SaaS) platform technology, as well as SaaS finished goods applications into the government, utilities and real estate markets. The company's CityGISTM product provides small to midsize local government agencies with turnkey enterprise GIS that can be deployed instantly for a fraction of the cost of a traditional desktop implementation. Both CityGISTM and LandVisionTM are built upon the company's SpatialStream technology that is open to other third party software developers through API calls allowing them to deploy sophisticated spatial technology in their own internet -based applications in a fraction of the traditional development time. Predominate SpatialStream customers include many large consumer real estate portals, member -based real estate portals, real estate multiple listing services (MLS) and residential /commercial real estate brokers. Page 124 DIGITAL MAP PRODUCTS Education Milo Works Benjamin Webb Project Manager I Customer Support Engineer for CityGIST" Digital Map Products, Inc. PROPOSAL - Geographic Information System University of Wisconsin, Madison WI 1 Environmental Studies & Land Use Planning 1 MS 2007 Denison University, Granville, OH 1 Environmental Studies & GIS IBA 2003 Honors, Magna Cum Laude Experience Digital Map Products 1 Project Manager, 6 months Current Vandewalle & Associates, Madison, WI 1 GIS Planner 3.5 years State of Ohio 1 Watershed Planner 2 years Project Management Experience CityGISTM, Southern California Association of Governments (SCAG) 2011 Web -based Interactive Economic Development Map, Dekorra, WI 2010 Hazard Mitigation Plan, Darlington, WI 2010 Hazard Mitigation Plan, Montello, WI 2009 GIS -Based Walkability Analysis, Wauwatosa, WI 2008 Alternative Approaches to Community -Based Planning, Master's Thesis 2007 Darby Creek Watershed Plan, Marysville, OH 2006 Software Knowledge Open Source GIS, CityGIS, LandVision, ArcGIS 9.x/10, Arclnfo, ArcEdit, ArcView, MS Access, AutoCAD, Microsoft Office, Microsoft Project Selected Projects LaserFiche Integration with CityGIS", Westminster, CA: Project Manager and Lead Consultant responsible for completing guiding and leading phase one implementation and creating phase two of the document imaging integration. Public Works System Integration with CityGIS", San Juan Capistrano, CA: Project Manager responsible for directing internal resources, project scope, and guiding and leading phase one implementation and creating phase two of the document imaging integration. CommunityView" Launch, Goleta, CA: Project Manager and Lead GIS Consultant responsible for project scope, data editing and loading of 35 layers, and creating a PR and marketing campaign for the City. Page 1 25 DIGITAL MAP PRODUCTS Shouliang Cheng Data Development Manager Digital Map Products, Inc. Education Ohio State University, Columbus, OH 1 Geodetic Science & Surveying, Digital Mapping and Geographical Information Science Specialization 1 MS 1998 National Chung Kung University, Tainan, Taiwan 1 Surveying Engineering 1 BS 1994 Certificates Microsoft Certified Solution Developer Microsoft Certified Database Administrator Microsoft Certified Systems Engineer Relevant Training ESRI, Redlands, CA 1 Introduction to ArcSDE using Arclnfo; ArcSDE Admin for SQL Server Oracle Education Center, Taipei, Taiwan 1 Participant, Oracle DBA Training Program Institute for Information Industry, Education & Training Division, Taipei, Taiwan 1 Internet Application Development Training Program UCOM Education Center, Taipei, Taiwan 1 Participant, Microsoft Certified Solution Developer Training Program Technical Skills GIS Software: ArcGIS; ArcObjects; GeoExpress Database Technologies: SQL Server 2005/2008; SQL Server Reporting Services, SQL Server SSIS; MySQL Experience With Digital Map Products for 11 years; with other firms for 1 year (Digital Map Products Employment Date 02/2001) yekaLar Public Works PROPOSAL - Geographic Information System Background Mr. Cheng leads Data Development Team at Digital Map Products in developing and maintaining data warehouse serving subscription -based web - hosted mapping application services for local government agencies, utilities, real estate developers, multiple listing service and internet content providers. Performs data evaluation, analysis, data modeling and integration. Develops automated workflows to extract, transform and Toad data from multiple sources to data warehouse. Data includes parcel boundary data, assessor tax data, imagery data, hazard data, street centerline data and other data. Page 1 26 DIGITAL MAP PRODUCTS Stan (Skip) Cody Senior Software Engineer Digital Map Products, Inc. Public Works PROPOSAL - Geographic Information System Education California State University, Humboldt' Geography, Emphasis in GIS IMA 1995 Continued Education: Courses in C, C + +, Java, ASP, and VB.NET UCI Extension: Introduction to .NET Framework Technologies 1 June 2004 Programming ASP .NET CALTECH IRCI Successful Project Management 1 Feb 2005 UCLA Extension 1 Transitioning from Technical to Managerial Responsibilities 'Aug 2005 Experience Digital Map Products, Inc. Irvine, CA 2004 - Present Senior GIS Applications Programmer 1 Customer Success Manager Automate workflows and data processes using C# and ESRI ArcObjects. Manage a unique department that not only supported the client base but also worked with sales and software engineering to define data implementation and manage client expectation to enhance their user experience. Designed and wrote many of DMP's account setup tools and data processing tools used today. Designed and maintain Operations intranet site that allows Sales and Management a view into our client base and allow the CST team to update and maintain client settings through a ASP.net based application. Rand McNally (Previously Thomas Bros. Maps) Irvine, CA 1999 - 2004 GIS Software Engineer Work within a group of 8 software engineers to design, code, and maintain local travel mapping systems based around ESRI ArcGIS products using COM and ESRI's ArcObjects technology. From requirements to implementation, deliver, maintain and enhance Rand McNally's local travel mapping system. Give technical support along with GIS consultation to 45 in house users. Project Management Experience • Worked within a team environment to deliver 3 different mapping systems used to create digital and print products. • GIS applications include ArcMap, Workstation ARC /INFO, ArcView, Mapinfo and AutoCad, ESRI 9.X. • Database experience: SQL, SQL Server 2000, Access 2000, SDE • Programming Languages: C #, C + +, Visual Basic, VB.Net, ASP.Net, XSLT, XML, ESRI AML Script • A full understanding of ESRI's ArcObject's object model. • Proven abilities in application programming, system design, and support for a variety of GIS needs • Maintain, enhance, and add functionality to Thomas Bros. Maps Original digital mapping system. Written in AML, FORTRAN, and C shell. This system allows an editor to create a Thomas Guide from source to film. • Skilled in data conversion, utilizing techniques in conflation, COGO, addressing and batch data processing. Writing tools in many languages to enhance the work of people who do not make GIS their main profession. • Wrote and maintained department website that is used to query, update and generate reports from SQL Server Page 127 DIGITAL MAP PRODUCTS Public Works PROPOSAL - Geographic Information System Company Profile: Psomas Founded over 65 years ago, Psomas provides services from offices throughout California, Arizona, and Utah. Psomas is a leading consulting engineering firm serving clients in the water /wastewater; transportation; public, institutional and private land development markets. Ranked as one of Engineering News Record (ENR) magazine's Top 150 Engineering Firms in the United States, we offer civil engineering, land surveying, planning and entitlements, program /construction management, natural resources, GIS consulting, and Special District Financing services to the public and private sector. Psomas is an employee -owned California corporation with nearly 450 employees. The firm is governed by a five - member Board of Directors, including Chairman Blake Murillo; and President Jacob Lipa, and three Directors at Large. In addition, the firm currently has 31 principals. These principals are legal binders for the firm and have been active for various durations ranging from one year to 35 years. New principals are integrated into our current management through annual merit nominations and elections. Psomas' Spatial Technology Solutions Team provides GIS needs assessment, planning, and implementation services primarily to local governments and utilities. Our GIS services are provided in three practice areas: GIS consulting, system integration /software development, and data integration /management. We have developed and evolved methodologies in each of the practice areas over the past 20 years of serving our customers. Psomas' technical skills are complemented with very broad subject matter expertise in local government. We understand the operations and challenges of City operations based on our team's prior experience as public employees and over 100 GIS planning and implementation projects with local government. Together the technical and business orientation enables our team to communicate effectively with City stakeholders and focus on the most important issues for enterprise GIS deployment. Project Team Members: Psomas Han Chu, GIS Consultant Mr. Chu will serve as the GIS Consultant, supporting the project manager in overall project delivery. He will be responsible for GIS planning and needs assessment, data assessment and management, and other support requirements. Sedat Macoglu, GIS Programmer Mr. Macoglu will provide his expertise in GIS technology, information systems, GIS platforms, interoperability and system integration. He will support the lead consultant in developing the database and network requirements to support recommended GIS implementation and operations. Alex Evett, GIS Analyst Mr. Evett will provide his expertise in GIS data architecture, including the design, development, and operations of GIS data repository. He is an expert in data assessment, conversion, and integration leveraging various source types and formats common to cities and local municipalities. Ron Moojen, Photogrammetrist Mr. Moojen will lead the data collection and integration of aerial mapping and LIDAR for the development of the Orthorectified Imagery and the DTM /DEM. His expertise is based upon 35 plus years in the mapping industry working with production and development programs. Page 1 28 DIGITAL MAP PRODUCTS Project Team Members Resumes Han Chu Project Manager /Senior Consultant Spatial Technology Solutions Psomas Education Publlc Works PROPOSAL - Geographic Information System - Psomas MBA /1999 /Information & Technology Management /University of California, Irvine BS /1991 /Civil Engineering/California State Polytechnic University, Pomona Registration 1995 /Professional Engineer /California / #C53166 — Expires 06/03/13 1997 /Professional Land Surveyor /California / #L7334 - Expires 12/31/11 Affiliations American Association of Airport Executives (AAAE) Bay Area Automated Mapping Association (BAAMA) Experience With Psomas for 13 years; with other firms for 8 years (Psomas Employment Date 01/98) Background Mr. Chu provides program oversight, project management, and consulting services in technology planning, development, implementation, and sustained operations. His strength is in exploring opportunities for technology- driven improvements that will enhance operational efficiency, implement technology, and promote positive cultural changes within a business entity. Mr. Chu develops strategies for the technology selection, development, implementation, and management in support of the organization's vision, ensuring direct and tangible connections to business requirements. His project management philosophy is founded on the balanced integration of technology that can address business needs while managing critical and necessary changes. He provides technical expertise in operations assessment, process analysis and engineering, conceptual data modeling, feasibility studies, strategic planning, implementation planning, and change management. Mr. Chu is highly skilled in facilitating group meetings, resolving differences of priorities, and finding solutions with group consensus. Complementing his business and technology consulting experience, Mr. Chu is a registered civil engineer, licensed surveyor, and real estate broker, who is experienced and understands the issues and needs of the technology user community. He also has experiences in the design and construction of commercial and residential development projects and has managed public works projects including water resources, water supply, and water quality improvements. Page ! 29 DIGITAL MAP PRODUCTS Han Chu Project Manager /Senior Consultant Spatial Technology Solutions Psomas (Continued) -fsi a Public Works PROPOSAL - Geographic Information System Selected Projects Enterprise GIS Needs Assessment Plan, City of Dublin, CA: Project Manager and Lead Consultant responsible for the development of the Enterprise GIS Needs Assessment report and subsequent Implementation Plan. The project included current environment assessment through interviews with City's business units, GIS needs identification and validation, enterprise GIS program design, , and tactical plan for implementation and operations of a sustained enterprise GIS program. Technology Services for Noise Management Program, Milwaukee International Airport, WI: Program Manager, Project Manager, and Lead Consultant responsible for the development, implementation, and management for the web based Case Management System in support of the Airport's noise management program. Mr. Chu facilitated program workflow design and engineering sessions, lead the design and technical team that developed NMP's web portal — includes case management system and GIS integrated seamlessly with document management system. The case management system is built in modular format and using "Agile Development" process that minimized the development cycle, all the while introducing deployment flexibility and program sustainability. Psomas also served.as system and data administrator, and provided system hosting services. RSIP Enterprise GIS Program, Great Falls International Airport, MT: Program Manager, Project Manager, and Lead Consultant responsible for the development, implementation, and management for the RSIP GIS Program in support of the Great Falls International Airport. Mr. Chu provided oversight of the business process engineering, business form interface, centralized data repository, and web based GIS application, throughout the design, development, integration, implementation, and deployment phases. This airport- wide GIS program is designed to provide a unified information management framework for the life span of RSIP, as well as beyond in serving the general airport business and operations. Psomas also provided hosting services for this Case Management System. Quieter Home Program GIS Technology Services, San Diego International Airport, CA: Program Manager, Project Manager, and Lead Consultant responsible for the Program Management System (including GIS application) development, implementation, and management for the Quieter Home Program (QHP) for San Diego International Airport under the administration of San Diego County Regional Airport Authority (SDCRAA). Mr. Chu provided oversight of the business process engineering, business form interface, centralized data repository, and web based GIS application, throughout the design, development, integration, implementation, and deployment phases. The Program Management System is designed to provide a unified information management framework for QHP, consultants, vendors, and other external stakeholders. Psomas also provided hosting services for this Program Management System called Quiet Link. Page 1 30 DIGITAL MAP PRODUCTS Sedat Macoglu Technical Manager /Programmer Spatial Technology Solutions Psomas Affiliations Bay Area Automated Mapping Association (BAAMA) Inland Empire GIS User Group Experience With Psomas for 9 years Public Works PROPOSAL - Geographic Information System Education Microsoft Certified Professional Web Developer /2010 /Microsoft Working with the ArcGIS API for Microsoft Silverlight /WPF /2010 /ESRI Developer Summit Patterns and Best Practices for Building Applications with the ArcGIS API for Microsoft Silverlight /WPF /2010/ ESRI Developer Summit Certificate in "ArcGIS Server Enterprise Configuration and Tuning for SQL Server" /2008 /ESRI, Redlands, CA SQL Server 2005 - Implementation and Maintenance /2008 /UCR Extension /Riverside, CA Certificate in "Introduction to Programming ArcObjects with VBA" /2007 /ESRI, Redlands, CA Certificate in "Developing Application with ArcGIS Server Using the Microsoft .NET Framework" /2007 /ESRI, Redlands, CA Certificate in "Introduction to ArcGIS Server" /2007/ ESRI, Redlands, CA Certificate in "Programming with Microsoft Visual Basic.NET" /2006 /QuickStart, Irvine, CA Certificate in "Introduction to ArcGIS I & II" /2003 /ESRI, Redlands, CA Bachelor in Science Minor Information Management Specialty /2003 /San Bernardino, CA Associate in Science Minor Computer Information Systems — Computer Programming/2000 /Riverside Community College, Riverside, CA Background Mr. Macoglu has more than 9 years of experience working with GIS based applications for database entry, web and GIS applications. Skills and Competency • Possesses significant knowledge of client server and internet systems architectures. • Creates well designed, reusable objects. • Understands the benefits of the various design methodologies and object oriented environments • Understands complex database concepts as well as the implications of different database designs. • Effectively employs many different database design techniques. • Creates efficient and logical databases for clients. • Designs and codes superior technical solutions. • Easily recognizes system deficiencies and implements effective solutions. Page 1 31 DIGITAL MAP 1 1 'P Pane Z k PRODUCTS �_ PROPOSAL - Geographic Information System Sedat Macoglu Technical Manager /Programmer Spatial Technology Solutions Psomas (Continued) Software Expertise GIS ArcGIS Desktop, ArcGIS Server & ArcSDE 9.x & 10 Installation & Maintenance, ArcView and ArcIMS administration /customization, ArcGIS Model Builder, ArcGIS Server Client APIs, Personal Geodatabase, File Geodatabase. Database MS SQL Server 2000 & 2005 & 2008, Oracle 9i & 10g, MS Access, MySQL, PostGreSQL Programming Language and Development Tools C #, ASP.NET, Silverlight 3 & 4, Visual Basic 5.0 & 6.0, Python Scripting, Adobe Flex development & Action Script, CSS, JavaScript, ASP, PHP, MS Office, MS Visio, MS SQL Server Integration, 115 Administration, Amazon Cloud Reporting Tools Microsoft Reporting Services, Crystal Reports 8.5 & X1, MS Access Reporting, iTextSharp Open Source PDF Library Projects Great Falls International Airport, Great Falls, Montana: Lead programmer responsible for designing, implementation, and maintenance of web based Residential Sound Insulation Program portal which is a Psomas hosted solution. Designing and implementing web forms to collect data and web reports pertaining to the program. Designing and implementing a SQL Server database and ArcSDE and ArcGIS Server administration. Rancho California Water District, Temecula, California: Lead programmer for design and implementation of web based GIS application using ArcGIS Server Web ADF which includes custom searches, search results, editing tools, and print mapping functionalities to assist agency users to view and update irrigated area boundary information. Southern California Association of Governments: Responsible for setting up a data repository using MS SQL Server 2008, loading data and performing data analysis, calculations, and reporting for Greenhouse Gas (GHG) emission usage for residential properties. Cal Water, San Jose, California: Lead programmer for designing and implementation of web based Emergency Notification application based on the ArcGIS Server Silverlight API with SQL Server and ArcSDE database technologies. Designing and implementing web reports pertaining to door hanger notification and a Premier phone system integration and automation for customer notification. Designing and implementing an intuitive configurable framework for ArcGIS Server Map Services and spatial searches for multiple districts. Page 1 32 0 DIGITAL MAP PRODUCT'S Sedat Macoglu Technical Manager /Programmer Spatial Technology Solutions Psomas (Continued) Public Works PROPOSAL — Geographic Information System Center City Development Corporation, San Diego, California: Assistant programmer responsible for parking meter data import automation for both single and multi space parking meters and creating reports for the CCDC Web Portal. Alameda Corridor Property Information Management System, Los Angeles, California: Lead programmer responsible for designing and implementing SQL database structure, and creating ETL tools to integrate Paragon Data Quest (PDQ) data. Responsible for design, implementation, and maintenance of web editing tools and reports within ACTA's GIS system. Design and implement SQL database structure to support financial data and design and develop ETL tools to load monthly financial data into the RAMS database. City of Los Angeles, Department of Traffic: Lead programmer responsible for creating, designing, and managing web application and crystal reports for the traffic count database. Sacramento Area Flood Control Agency, Levee Management GIS, Sacramento, California: Lead programmer for design and implementation of web based GIS and right of way & encroachment management system. Application solutions include ArcGIS Server web application to show diverse information about levees and levee construction plans. Web based mapping to show levee encroachment locations and digital images of the existing encroachments. Nye County: Lead programmer responsible for design and implementation of an ArcMap extension custom toolbar for Master Address Database editing application which allows county staff to add, update, and retrieve a single or range of address points Page 33 DIGITAL MAP PRODUCTS Arthur (Alex) Evett GIS Analyst Psomas Education BS- Aerospace Engineering/Cal Poly Pomona, California Introduction to Arclnfo - University of California, Riverside Access - University of California, Riverside Database Management - University of California, Riverside Arclnfo- Environmental Systems Research Institute, Redlands, California Software Knowledge ArcGIS 9.x /10, Arclnfo, ArcEdit, ArcView, ArcGIS Server & Server Manager, ArcIMS, Cadastral Editor, Model Builder, ArcPad, GBA Facility Management, LizardTech GeoExpress Mr Sid image creation and manipulation, MapMerger,Google Earth and kml, MS Access, AutoCAD and Raster Design, Microsoft Office Affiliations Inland Empire GIS Users Group Bay Area Automated Mapping Association (BAAMA) Experience With Psomas for 14 years: with other firms for 10 years. (Psomas Employment Date 09/96) Public Works PROPOSAL - Geographic Information System Background Mr. Evett is experienced in Geographic Information Systems (GIS). He has extensive knowledge and expertise in basemap, water, wastewater, stormwater, zoning, addressing, emergency services projects. As a senior analyst, expertise with GIS database designs, GIS tools, and client business needs enable him to assess, design, and produce effective GIS solutions. His responsibilities include training other technicians, development of production procedures, resource allocation, subcontractor coordination, overseeing conversion operations, and serving on the Quality Assurance /Quality Control Oversight Committee. Skills and Competency • Expert in the use of ArcGis and Autodesk tools and practices • Broad subject matter expert applied to GIS applications • GIS database architect and data documentation • Data analysis, integration, and quality management • Performs field data collection using GPS enabled data collectors • Complex spatial analysis, map design and production for atlas books, online map repositories, and analytical wall maps. Pagel 34 PI DIGITAL MAP PRODUCTS Arthur (Alex) Evett GIS Analyst Psomas (Continued) F''. l olizeZ Public Works PROPOSAL — Geographic Information System Selected Projects Los Angeles City Colleges, Los Angeles CA, Infrastructure Mapping - CAD Migration to GIS SDSFIE Standards Southern California Edison — Environmental Impact Analysis and Exhibits throughout Southern California Region University of Southern California, Los Angeles CA, Facilities Mapping — CAD Migration to GIS Geodatabase Southern California Gas Company - Infrastructure Mapping - CAD Migration to GIS SDSFIE Standards Rancho California Water District, RCWD, Temecula CA, Irrigatable Landcover Analysis: GIS Analyst responsible for analysis and reporting of irrigatable area per meter service area based on landcover type and surface slope of property. Paradise Valley, Riverside County, CA: GIS Analyst responsible for creating exhibits for Planning Report for submittal to county. Created single geodatabase to house GIS data layers, do automated reporting based on zoning and planning densities, and master planning of all major utilities in the master layout of this new city. Created ArcGis Server website and Google Earth kml datasets for client review and 3D analysis of all planning layers, including preliminary lot build out and phasing. City of Moreno Valley West End Area Drainage Plan, CA: GIS Technician responsible for data layer gathering, editing, analysis, and exhibits for presentation to council covering issues pertaining to drainage area fees within the project area. County of Sacramento - Capital Southeast Connector Project, Data Mining & Research, Data Conflation, Exhibit Creation, CA: GIS Analyst responsible for data mining and standardization; creation of exhibits and analysis for reports and public meetings related to the creation of a new highway, through the southern part of the county; traffic, environmental sensitive areas and species, existing land uses and facilities along multiple alternative potential routes. City of Upland Basemap, Zoning and General Plan Updates, CA: GIS Technician responsible for performing updates, quality assurance, and exhibit creation. Costa Mesa Master Drainage Plan Conversion, CA: GIS Technician responsible for the database design, conversion from as- builts, GPS correlation, and quality assurance using ArcEdit, ArcView, and Access. Page 135 DIGITAL MAP PRODUCTS Ron Moojen Photogrammetrist Psomas Education Affiliations (.1 est44‘ Public Works PROPOSAL - Geographic Information System Analytical Triangulation Certification /1986 / /Fresno State College, CA DTM Certification /1986 /Fresno State College, CA Orthophotography Classes /1994/LH Systems, Inc. American Society of Photogrammetry and Remote Sensing (ASPRS) American Congress on Surveying and Mapping (ACSM) Urban Regional Information Systems Association (URISA) International Society for Photogrammetry and Remote Sensing (ISPRS) Experience With Psomas for 6 years; with other firms for 30 years. Background Mr. Moojen has close to 36 years of experience in the aerial mapping industry including 25 years specializing in analytical triangulation and digital orthophoto production. He has been extensively involved in various projects utilizing softcopy technology using digital imagery. His experience also includes the integration of Geographic Information Systems (GIS) data into aerial imagery. Mr. Moojen has BETA tested Aerotriangulation Software and Orthophoto Software as technology developed for leading vendors such as LEICA - SocetSet, Albany AT, ZEISS and KORK mapping software. He has been using the Intergraph suite of photogrammetric softcopy software in conjunction with ArcMAP 8.3 for the last four years for our mapping and imagery products. He has worked on both the Autodesk and Microstation platforms throughout the last 20 years and still uses both LDT and INROADS surface and design modules for our contouring and surface generations. Projects USC University Park Master Plan Aerial Topographic Mapping and Wet Utility Planning, Los Angeles, CA: Photogrammetrist for preparation of an aerial topographic map of the USC campus and surrounding areas. Work products included mapping at 40 -scale 1' contours and a color orthophoto of the project. The project is intended to enable USC to review potential locations to build or expand additional development projects on the campus. • Metropolitan Water District, On -Call Professional and Tehnical Aerial Photogrammetry and Mapping Services, CA: As Photogrammetrist, providing aerial ortho- mosaic and photogrammetric mapping, covering the proposed San Diego Pipeline No. 6 South Alternative Alignment, comprising approximately 24,500 acres in Riverside and San Diego counties; and bathymetric mapping, covering Lake Perris, comprising approximately 1,238 submerged acres in the San Jacinto area of Riverside County. Page 1 36 DIGITAL MAP PRODUCTS Ron Moojen Photogrammetrist Psomas (Continued) Gib° ski .ra.Zk (-) " Public Works PROPOSAL - Geographic Information System Exposition Corridor Light Rail Transit (LRT) Project, Phase I, Los Angeles, CA: Psomas provided right - of- way mapping, boundary surveys, aerial control, major survey control, and photogrammetric mapping for the initial six -mile segment of the project. As Photogrammetrist, provided control survey and preliminary right -of -way mapping. On - Call Surveying Services — City of Carson Redevelopment Agency, CA: Serving as Project Photogrammetrist in preparing traditional photogrammetry mapping of 34 ALTA Surveys on multiple parcels encompassing over 135 acres of land as part of a future redevelopment project. Caltrans On - Call Aerial Photography /Photogrammetry Contract: Photogrammetrist for aerial mapping, photogrammetry and analytical triangulation services for on -call contract for projects located throughout California. Metropolitan Water District of Southern California, Cross Connection Prevention Program Survey, San Bernardino, CA: Photogrammetry Manager for a current contract to protect MWD's treated water supply systems from potential contamination by the implementation of the Cross Connection Prevention Program, which consists of the modification or relocation of approximately 1,280 structures located along various feeders and scattered over a vast area in over 70 cities. Digital Orthos for Diamond Valley Lake, Metropolitan Water District of Southern California: Imagery Manager for production of DTM and orthophotography at 1' = 100' with 0.5' pixels for the proposed reservoir. Digital Orthos for the Integrated Waste Management District, Los Angeles, CA: Imagery Manager for the production of color 1" = 100' orthophotography of the District with 0.5' pixels. Perris Transportation Center, San Diego, CA: Provided photogrammetric mapping for the proposed rail station at 1 " =40' mapping scale. UCSD Graduate Housing Project, San Diego, CA: Provided photogrammetric mapping at 1 " =20' mapping scale. Digital Orthos for City of Seaside, CA: Imagery Manager for production of citywide color orthophotography at 1" = 100' with 0.5' pixels. Orthophotography for the City of Palmdale, CA: (2001) Imaging Manager for color orthophotography at 1" = 200' with 1.0' pixels including 5' contour and orthophoto mylar plots. Also included use of airborne GPS and analytical triangulation of the imagery. Upper Little Colorado River, Springerville and Eager, AZ: Imagery Manager for production of 1 "= 100' mapping with 0.5' orthophotography and 2' contours. The project also included an area of 1" = 200' mapping with 1' orthophotography and 5' contours. Completed the aerotriangulation of a block of 400 photos. Page 137 El DIGITAL MAP SECTION IV - REFERENCES Digital Map Products Public Works PROPOSAL - Geographic Information System City of San Juan Capistrano, CA The City of San Juan Capistrano was provided with a CityGISTM subscription to access the Orange County Parcel and Right -of -Way database, property ownership information, Thomas Bros. Maps digital database, 3" color imagery, environmental geo- hazards database and black and white high resolution orthophotography. Along with these base data sets, the city has posted data including water, sewer, and storm drains, created by outside consultants as well as providing the city's zoning designations in digital format for access by developers. CityGIST"" works in parallel with the city's minimal number of existing ArcView licenses as the enterprise wide deployment solution for staff to access the city's data. Staff members throughout the organization access the city's GIS data over the Internet at their desktops and the public counter. Sponsor: Ziad Mazboudi City Engineer City of San Juan Capistrano 32400 Paseo Adelanto San Juan Capistrano, CA 92675 zmazboudi(sanivancapistrano.org 949.234.4413 City of San Clemente, CA The City of San Clemente was provided with a CityGISTM subscription to access the Orange County Parcel and Right -of -Way database, property ownership information, Thomas Bros. Maps digital database, premium color imagery, and environmental geo- hazards database. Along with these base data sets, the city has posted data including Beach Access and Parking information, Bike Lanes, City Facilities, Historical and Landmark structures, HOA information, OC Fire Authority, Parks and Open Space, Potable Water Facilities, Redevelopment Agency and Specific Plan Areas, Traffic Signals, Trails and Trash Pickup layers. CityGISTM works in parallel with the city's minimal number of existing ArcView licenses as the enterprise wide deployment solution for staff to access the city's data. Staff members throughout the organization access the city's GIS data over the Internet at their desktops and the public counter. Sponsor: Larry Moore Director City of San Clemente 100 Avenida Presidio San Clemente, CA 92672 moorel@san- clemente.org 949.361.8307 City of Malibu, CA The City of Malibu was provided with a CityGISTM subscription to access the Orange County Parcel and Right -of -Way database, property ownership information, premium imagery, and environmental geo - hazard information. Along with these base data sets, the city has posted data including park and trail information, along with their city's boundary and zoning designations. Staff members throughout the organization access the city's GIS data over the Internet at their desktops and the public counter. Pagel 38 DIGITA MAP PRODUCTS Sponsor: Jim Thorsen City Manager City of Malibu 23815 Stuart Ranch Road Malibu, CA 90265 jthorsen(Wmalibucitv.org 310.456.2489 x226 .County of Orange, CA The County of Orange was provided with a CityGISTM subscription to access the Orange County Parcel and Right -of -Way database, property ownership information, Thomas Bros. Maps digital database, premium imagery, and environmental geo- hazards database. Along with these base data sets, the county has posted data including Supervisorial Districts, Watershed information, Drainage lines and CWA segments. Staff members throughout the organization access the city's GIS data over the Internet at their desktops and the public counter. Sponsor: Jon Anderson Program Supervisor County of Orange 222 East Bristol Lane Orange, CA 92865 jon.andersonPocpw.ocgov.com 714.955.0110 Psoinas ' } 0 Public Works PROPOSAL - Geographic Information System Enterprise GIS Implementation Services Performed GIS needs assessment for enterprise GIS application for the entire organization; developed and deployed the enterprise GIS web portal and business modules. This project was completed in 2009. Sponsor: Chuck Wilmot Information Technology Manager, Centre City Development Corporation wilmot@ ccdc.com (619) 533 -7117 Enterprise GIS Needs Assessment Performed GIS needs assessment with all departments within the City; developed implementation plan to support sustained GIS operations for next 5 years and beyond. This project was completed in 2011. Sponsor: Tim Eisler GIS Coordinator, City of Dublin tim.eisler @ci.dublin.ca.us (925) 829 -9248 NAVFAC Southwest Capital Improvement; Mapping Services Performed GIS Mapping and Orthophotography for San Clemente Island. This project was completed in 2010. Sponsor: Michael Prather NAVFAC (619) 532 -0782 Page 39 DIGITAL MAP PRODUCTS Psomas Project Manager /GIS Consultant $185/Hou r GIS Programmer $140 /Hour GIS Analyst $110 /Hour Photogrammetrist $135 /Hour 0491 ur Mile Works Professional Services Fee Schedule Digital Map Products, Inc. Project /Principal Manager $175 /Hour Product Specialist $150 /Hour Senior Software Engineer /Architect $250 /Hour Software Engineer $150 /Hour Instructor $150 /Hour GIS Technician $85 /Hour Add Data Layer $600 /Each Theme Active Layer $1,500 /Each Training Credits $100 /Each Travel At cost plus 15% Travel Time Half Rate PROPOSAL — Geographic information System Page 1 40 Section VII. Budget City of Seal Beach GIS Alf Et-PMENITA*' 1. Photogrammetric Services (Aerial, LiDAR, 1ft Contours) V ihi.Z.0a140 $2,500 2. (Option A) Data Conversion 2. (Option B) Data Migration 3. Web-Based GIS (CityGISTM & Concierge Services) 4. Link Existing As-Builds 5. Database Templates for Water & Sewer 6. GIS Needs Assessment & Implementation Totals graMMA 4. MAR119 Q.BTIONALSWORK gLEM tigs!rt Annual Data Delivery* ?VA $60,000 $37, 000 $12,000 $18,000 $5,000 $0 $24,000 A - $144,000 B - $119,000 *MP' RO.Pro$1241 $2,600 , yigar 2., $2,500 $0 $0 $18,000 $0 $0 $4,000 $24,500 idtpneWrt• 241,7! mervc -tY:PaTR:i $2,600 $2,500 $0 $0 $18,000 $0 $0 $4, 000 $24,500 v.Yeart3t. $2,600 $0 $0 $18,000 $0 $0 $4,000 $2,600 selor $2,500 $0 $0 $18,000 $0 $0 $4,000 $24,500 c 1'10 4-91egriiie $2,600 44 40.fpgrit.6.0t, $25,000 $0 $0 $18,000 $0 $0 $4,000 $47,000 $2,600 It :WV mg.g.re $2,500 $0 $0 $18,000 $0 $0 $4,000 $24, 500 $2,600 PO Lfi 4.V..64.ra Wag!: 9A $2,500 $2,500 $0 $0 $18,000 $0 s0 $4,000 $24, 500 $2,600 $0 $0 $18,000 $0 $0 $4,000 $24,500 WA, . %fat. $2,600 ZearAl,(2, $2,500 $0 s0 $18,000 $0 $0 $4,000 $24,500 $2,600 I mop eiS tir4gfa $105,000 $37,000 $12,000 $180,000 $5,000 $0 $60,000 $24, 500 A - $387,000 B - $362,000 $26,000 Integration of Future Utility Information into GIS (Time and Materials, not-to-exceed) *Price may fluctuate pending Orange County Pricing $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $50,000 Digital Map Products Updated 1/17/2012