Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Item No. 12 - Amend. No. 4 to PSA Spicer Consulting Group, LLC GIS Services
City Council Agenda Report City of Lake Elsinore 130 South Main Street Lake Elsinore, CA 92530 www.lake-elsinore.org File Number: ID# 21-322 Agenda Date: 9/14/2021 Status: Approval FinalVersion: 1 File Type: Council Consent Calendar In Control: City Council / Successor Agency Agenda Number: 12) Amendment No. 4 to the Agreement for Professional Services with Spicer Consulting Group, LLC (SCG) for Geographic Information System (GIS) for Consulting and Support Services Approve and authorize the City Manager to execute Amendment No. 4 to the Agreement for Professional Services with SCG, LLC for Fiscal Year 2021-22 in the amount of $62,900 for Geographic Information System (GIS) for Consulting and Support Services. Page 1 City of Lake Elsinore Printed on 9/9/2021 Page 1 of 2 REPORT TO CITY COUNCIL To: Honorable Mayor and Members of the City Council From: Jason Simpson, City Manager Prepared by: Shannon Buckley, Director of Administrative Services Date: September 14, 2021 Subject: Amendment No. 4 to the Agreement for Professional Services with Spicer Consulting Group, LLC (SCG) for Geographic Information System (GIS) for Consulting and Support Services Recommendation Approve and authorize the City Manager to execute Amendment No. 4 to the Agreement for Professional Services with SCG, LLC for the Fiscal Year 2021-22 in the amount of $62,900 for Geographic Information System (GIS) Consulting and Support Services. Background The City is approximately two-thirds undeveloped and anticipating a major increase in building permit activity as the buildout of specific planned developments occurs. To help manage this build-out and support the City’s strategic initiative for service as part of its Vision Statement, the City has started implementing EnerGov, an enterprise permitting, and land management system developed by Tyler Technologies, and is upgrading its GIS servers with ESRI software. EnerGov relies on a GIS land-base which the system interfaces with to associate permitting and land management activities with the corresponding spatial features those activities occur on (e.g. parcels, addresses, etc.). Further, the City also has no current GIS staff and many GIS data layers remain stored in various formats and locations that have been developed and assembled over time from various projects. The City’s GIS environment needs to be set up so that the City can begin leveraging GIS to improve processes and support. To facilitate a well-developed and reliable integration with EnerGov, provide more widespread access to GIS services throughout the City, and ensure the City is best positioned to take full advantage of all EnerGov capabilities moving forward, the City needs to implement a new GIS design and data organization schema. SCG understands that the City will be purchasing a Small Government Enterprise License Agreement (SGELA) from ESRI to obtain the software needed to support its EnerGov rollout and its GIS expansion efforts. Under the SGEGLA, the City further intends to set up a new server on which it will install ArcGIS Enterprise (formerly ArcGIS Server) that will host a new enterprise geodatabase and a new data schema based on ESRI’s Local Government Amendment No. 4 Spicer Consulting Group September 14, 2021 Page 2 of 2 Information Model (LGIM). Once ArcGIS Enterprise is set up and the LGIM data schema is established, the City plans to migrate selected data from its older shapefile and geodatabase sources into the LGIM schema within the new enterprise geodatabase. Fiscal Impact The Information Systems Internal Services Fund has funding available for the $62,900 to implement this consulting and support services agreement. Exhibits A –Amendment No. 4 A1-Proposal B –Amendment No. 3 C- Amendment No. 2 D- Amendment No. 1 E- Original Agreement AMENDMENT NO. 4 TO AGREEMENT FOR PROFESSIONAL SERVICES SPICER CONSULTING GROUP, LLC GEOGRAPHIC INFORMATION SYSTEM CONSULTING AND SUPPORT SERVICES This Amendment No. 4 to Agreement for Professional Services (“Amendment No. 4”) is made and entered into as of 9/14/2021, by and between the City of Lake Elsinore, a municipal corporation (“City”), and Spicer Consulting Group, LLC a (“Consultant”). RECITALS A. The City and Consultant have entered into that certain Agreement for Professional Services dated as of 2/14/2017, (the “Original Agreement”). Except as otherwise defined herein, all capitalized terms used herein shall have the meanings set forth for such terms in the Original Agreement. B. The Original Agreement provided for compensation by Consultant of certain services for Geographic Information System Consulting and Support Services and compensation to Consultant therefore in an amount not to exceed $62,900.00. C. On September 26, 2018, the City approved Amendment No. 1 extending the term to June 30, 2019 and decreasing the compensation for services to $50,000.00. D. On May 28, 2019, the City approved Amendment No. 2 extending the term to June 30, 2020 and increasing the compensation for services in an amount not to exceed $62,900. E. On August 25, 2020 the City approved Amendment No. 3 extending the term to June 30, 2021 and increasing the compensation for services in an amount not to exceed $62,900. The Original Agreement, Amendment No. 1, Amendment No. 2 and Amendment No. 3 are collectively referred to as the “Agreement.” F. The Parties now desire to extend the term of the Agreement for a period of one (1) year, effective as of July 1, 2021 and ending on June 30, 2022 and to provide for compensation to Consultant for services provided under this Amendment No. 4 in an amount not to exceed $62,900.00. NOW, THEREFORE, in consideration of the mutual covenants and conditions set forth herein, City and Consultant agree as follows: 1. Section 2c, Scope of Services, of the Original Agreement is hereby amended to add the following: “The term of this Agreement shall commence upon execution of this Agreement and shall continue through June 30, 2022, unless earlier terminated as provided herein. Consultant shall complete the services within the Term of this Agreement and shall meet any other established schedules and deadlines.” 2 2. Section 3, Compensation, of the Agreement is hereby amended to add the following: “Consultant’s compensation for the period commencing July 1, 2021 through June 30, 2022 shall not exceed sixty-two thousand nine hundred and no cents ($62,900.00). Total compensation for services pursuant to this Agreement shall not exceed three hundred one thousand six hundred and no cents ($301,600.00).” 3. Except for the changes specifically set forth herein, all other terms and conditions of the Original Agreement shall remain in full force and effect. IN WITNESS WHEREOF, the parties have caused this Amendment No. 4 to be executed on the respective dates set forth below. “CITY” CITY OF LAKE ELSINORE, a municipal corporation “CONSULTANT” Spicer Consulting Group, LLC Jason Simpson, City Manager Date: Shane Spicer, Managing Director Date: __ ATTEST: City Clerk APPROVED AS TO FORM: City Attorney Administrative Services Director Attachments: Exhibit A1-Consultant’s Proposal EXHIBIT A1 CONSULTANT’S PROPOSAL [ATTACHED] EXHIBIT A CONSULTANT'S PROPOSAL Additional Laver Mioration SCG will collaborate with the City to determine additional layers, most beneficial to the City, for loading into the Enterprise Geodatabase. This will be accomplished through consultation with applicable City staff to determine layers needed to support prioritized business needs of various departments. Once the relevant layers are identified, SCG will migrate the layers to the Enterprise Geodatabase LGIM schema. The migration of existing data layers may require some level of data and attribute translation or reformatting to be properly tmported into the LGIM schema. ln these instances, SCG will collaborate with the City to ensure the translated data layer meets the City's needs. ln addition, layer consultation may reveal the need for data in the Enterprise Geodatabase that is not currently in a GIS format. Common examples of such data include paper maps, tabular lists, hardcopy descriptions of specific areas such as planning areas, Community Facilities District, special use zones, etc. ln these instances, SCG will collaborate with the City to convert the data to a digital GIS layer that is suitable for loading into the LGIM geodatabase schema. Finally, SCG will publish any newly developed or reformatted layers into new and/or revised map and feature services to incorporate the new layers into the City's ArcGlS Online Organization account. Deliverables: I Layer Consultation Meeting Notes 0 Report Listing Prioritization of Additional Layers I Newly Developed GIS Layers (As Needed) I Additions of Layers to City Enterprise Geodatabase I Published Layers Added to ArcGlS Online Organization Account Onooino Suooort SCG will continue to provide ongoing technical services related to the implementation of the City's ESRI GIS solutions. This work will be performed on a task order basis, and SCG will provide a written estimate of hours and costs prior to starting any work under this task. Work will not start until the City has authorized the work. Activities that may be performed under this task are described below. I Provide Ongoing GIS Support Services as Needed I Setup and Configuration of New Map and Feature Services in ArcGlS Organization Account0 lnstallation and Configuration of Mobile and Web Application Templates I GIS Data Collection I GIS Map Production a GIS Data Development or Conversion I GIS Data Editing and Updates I Data Migration of Additional Data into Enterprise Geodatabase t GIS lntegration with Other City Systems 0 Other Technical Services as Requested Page 1 AMENDMENT NO. 3 TO AGREEMENT FOR PROFESSIONAL SERVICES FOR GEOGRAPHIC INFORMATION SYSTEM CONSULTING AND SUPPORT SERVICES This Amendment No. 3 to Agreement for Professional Services (the "Amendment No 3") is entered into as of August 25, 2020 by and between the City of Lake Elsinore, a municipal corporation ("City") and SCG, LLC. ("Consultant"). RECITALS A. The City and Consultant have entered into that certain Agreement for Consultant Services dated February 14, 2017 (the "Original Agreement"). Except as otherwise defined herein, all capitalized terms used herein shall have the meanings set forth for such terms in the Original Agreement. B. The Original Agreement provided for performance by Consultant of certain services for geographic information system consulting and support services and compensation to Consultant therefor in an amount not to exceed $62,900.00. The Original Agreement expired June 30, 2018. C. On September 26, 2018, the City approved Amendment No. 1 extending the term to June 30, 2019 and decreasing the compensation for services to $50,000.00. The Original Agreement and Amendment No. 1 are collectively referred to as the “Agreement.” D. On May 28, 2019, the City approved Amendment No. 2 extending the term to June 30, 2020 and increasing the compensation for services in an amount not to exceed $62,900.00. The Original Agreement, Amendment No. 1 and Amendment No. 2 are collectively referred to as the “Agreement.” E. The Parties now desire to extend the term of the Agreement for a period of one (1) year, effective as of July 1, 2020 and ending on June 30, 2021 and to provide for compensation to Consultant for services provided under this Amendment No. 3 in an amount not to exceed $62,900.00. NOW, THEREFORE, in consideration of the mutual covenants and conditions set forth herein, City and Consultant agree as follows: 1. Section 2c, Term, of the Agreement is hereby amended in its entirety to read as follows. “The term of this Agreement shall commence upon execution of this Agreement and shall continue through June 30, 2021, unless earlier terminated as provided herein. Consultant shall complete the services within the Term of this Agreement and shall meet any other established schedules and deadlines.” 2. Section 3, Compensation, of the Agreement is hereby amended to add the following: “Consultant’s compensation for the period commencing July 1, 2020 through June 30, 2021 shall not exceed sixty-two thousand nine hundred and no cents ($62,900.00). Total compensation for services pursuant to this Agreement shall not exceed two hundred thirty- eight thousand seven hundred and no cents ($238,700.00).” 3. Except for the changes specifically set forth herein, all other terms and conditions of the Agreement shall remain in full force and effect. DocuSign Envelope ID: 019EBF3E-84C5-4533-BF0F-C4535D489ACC Page 2 IN WITNESS WHEREOF, the parties have caused this Amendment No. 3 to be executed on the respective dates set forth below. “CITY” “CONSULTANT” CITY OF LAKE ELSINORE, SCG, LLC a municipal corporation Grant Yates, City Manager Shane Spicer, Managing Director ATTEST: City Clerk APPROVED AS TO FORM: City Attorney _________________________________ Risk Manager Attachments: Exhibit A – Consultant’s Proposal DocuSign Envelope ID: 019EBF3E-84C5-4533-BF0F-C4535D489ACC Additional Layer Migration EXHIBIT A CONSULTANT’S PROPOSAL SCG will collaborate with the City to determine additional layers, most beneficial to the City, for loading into the Enterprise Geodatabase. This will be accomplished through consultation with applicable City staff to determine layers needed to support prioritized business needs of various departments. Once the relevant layers are identified, SCG will migrate the layers to the Enterprise Geodatabase LGIM schema. The migration of existing data layers may require some level of data and attribute translation or reformatting to be properly imported into the LGIM schema. In these instances, SCG will collaborate with the City to ensure th e translated data layer meets the City’s needs. In addition, layer consultation may reveal the need for data in the Enterprise Geodatabase that is not currently in a GIS format. Common examples of such data include paper maps, tabular lists, hardcopy descriptions of specific areas such as planning areas, Community Facilities District, special use zones, etc. In these instances, SCG will collaborate with the City to convert the data to a digital GIS layer that is suitable for loading into the LGIM geodatabase schema. Finally, SCG will publish any newly developed or reformatted layers into new and/or revised map and feature services to incorporate the new layers into the City’s ArcGIS Online Organization account. Deliverables: ◆ Layer Consultation Meeting Notes ◆ Report Listing Prioritization of Additional Layers ◆ Newly Developed GIS Layers (As Needed) ◆ Additions of Layers to City Enterprise Geodatabase ◆ Published Layers Added to ArcGIS Online Organization Account Ongoing Support SCG will continue to provide ongoing technical services related to the implementation of the City’s ESRI GIS solutions. This work will be performed on a task order basis, and SCG will provide a written estimate of hours and costs prior to starting any work under this task. Work will not start until the City has authorized the work. Activities that may be performed under this task are described below. ◆ Provide Ongoing GIS Support Services as Needed ◆ Setup and Configuration of New Map and Feature Services in ArcGIS Organization Account ◆ Installation and Configuration of Mobile and Web Application Templates ◆ GIS Data Collection ◆ GIS Map Production ◆ GIS Data Development or Conversion ◆ GIS Data Editing and Updates ◆ Data Migration of Additional Data into Enterprise Geodatabase ◆ GIS Integration with Other City Systems ◆ Other Technical Services as Requested DocuSign Envelope ID: 019EBF3E-84C5-4533-BF0F-C4535D489ACC 06/08/2020 ISU Insurance Services Cormarc Tasman 25220 Hancock Ave, Suite 200 Murrieta, CA 92562 License #: 0E63467 Helena Orosco (951)290-5040 (951)278-0664 helena@isucormarc.com 00018712-638714 7 SCG-SPICER CONSULTING GRP LLC DBA SPICER CONSULTING GROUP 41619 MARGARITA RD STE 101 TEMECULA, CA 92591 Travelers Casualty Ins Co 19046 A Y 680-2H870106 05/31/2020 05/31/2021X X X 2,000,000 300,000 5,000 2,000,000 4,000,000 4,000,000 California Automobile Ins Co 38342 B BA040000059364 05/31/2020 05/31/2021 X 1,000,000 Travelers Casualty & Surety Co. 25674 C Y UB-9P270352 05/31/2020 05/31/2021 X 1,000,000 1,000,000 1,000,000 Lloyd of London D MPL175558020 05/31/2020 05/31/2021Prof Liability Limit 2,000,000 retro date 5/31/16 Retention 10,000 The City of Lake Elsinore, its elected or appointed officers, officials, employees, agents and volunteers are named as additional insured for the insured's operations with primary wording for insured's operations per written contract. Endorsement CGD105 0494 attached. Work comp waiver of subrogation per WC040306 attached. City of Lake Elsinore LAKE130 City Manager/City Clerk 130 South Main Street Lake Elsinore, CA 92530 (ORO) Printed by ORO on June 08, 2020 at 10:04AM ANY PROPRIETOR/PARTNER/EXECUTIVE OFFICER/MEMBER EXCLUDED? INSR ADDL SUBR LTR INSD WVD DATE (MM/DD/YYYY) PRODUCER CONTACTNAME: FAXPHONE(A/C, No):(A/C, No, Ext): E-MAILADDRESS: INSURERA: INSURED INSURERB: INSURERC: INSURERD: INSURER E : INSURER F : POLICY NUMBER POLICY EFF POLICY EXPTYPE OF INSURANCE LIMITS(MM/DD/YYYY) (MM/DD/YYYY) AUTOMOBILE LIABILITY UMBRELLA LIAB EXCESS LIAB WORKERS COMPENSATION AND EMPLOYERS' LIABILITY DESCRIPTION OF OPERATIONS / LOCATIONS / VEHICLES (ACORD 101, Additional Remarks Schedule, may be attached if more space is required) AUTHORIZED REPRESENTATIVE EACH OCCURRENCE $ DAMAGE TO RENTEDCLAIMS-MADE OCCUR $PREMISES (Ea occurrence) MED EXP (Any one person) $ PERSONAL & ADV INJURY $ GEN'L AGGREGATE LIMIT APPLIES PER:GENERAL AGGREGATE $ PRO-POLICY LOC PRODUCTS - COMP/OP AGG $JECT OTHER:$ COMBINED SINGLE LIMIT $(Ea accident) ANY AUTO BODILY INJURY (Per person) $ OWNED SCHEDULED BODILY INJURY (Per accident) $AUTOS ONLY AUTOS HIRED NON-OWNED PROPERTY DAMAGE $AUTOS ONLY AUTOS ONLY (Per accident) $ OCCUR EACH OCCURRENCE $ CLAIMS-MADE AGGREGATE $ DED RETENTION $ $ PER OTH-STATUTE ER E.L. EACH ACCIDENT $ E.L. DISEASE - EA EMPLOYEE $ If yes, describe under E.L. DISEASE - POLICY LIMIT $DESCRIPTION OF OPERATIONS below INSURER(S) AFFORDING COVERAGE NAIC # COMMERCIAL GENERAL LIABILITY Y/N N/A (Mandatory in NH) SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER, AND THE CERTIFICATE HOLDER. IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must have ADDITIONAL INSURED provisions or be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). COVERAGES CERTIFICATE NUMBER: REVISION NUMBER: CERTIFICATE HOLDER CANCELLATION © 1988-2015 ACORD CORPORATION. All rights reserved. The ACORD name and logo are registered marks of ACORDACORD 25 (2016/03) CERTIFICATE OF LIABILITY INSURANCE DocuSign Envelope ID: 019EBF3E-84C5-4533-BF0F-C4535D489ACC CITY OF LAKE ELSINORE TO BE POSTED IN A CONSPICUOUS PLACE Business Name: Business Location: Owner Name(s): BUSINESS LICENSE NO. Issue Date: Description: Expiration Date: BUSINESS LICENSE THIS IS YOUR LICENSE • NOT TRANSFERABLE 41619 MARGARITA RD STE 101 Business Type: TEMECULA, CA 92591-2985 SPICER CONSULTING GROUP 41619 MARGARITA RD STE 101 TEMECULA, CA 92591-2985 This business license is issuedfor revenue purposes only anddoes not grant authorization to operate a business. This business license is issuedwithout verificationthat the holder is subject to or exempted from licensing by the state, county, federal government, or any other governmental agency. Administrative Services - Licensing 130 South Main Street, Lake Elsinore, CA 92530 PH (951) 674-3124 SPICER CONSULTING GROUP MELISSA BELLITIRE SHANE SPICER CONSULTING SERVICES SPECIAL TAX CONSULTING 022905 7/1/2020 6/30/2021 DocuSign Envelope ID: 019EBF3E-84C5-4533-BF0F-C4535D489ACC Page 1 AMENDMENT NO. 2 TO AGREEMENT FOR PROFESSIONAL SERVICES FOR GEOGRAPHIC INFORMATION SYSTEM CONSULTING AND SUPPORT SERVICES This Amendment No. 2 to Agreement for Professional Services (the "Amendment No 2") is entered into as of May 28, 2019 by and between the City of Lake Elsinore, a municipal corporation ("City") and Spicer Consulting Group (SCG), LLC. ("Consultant"). RECITALS A. The City and Consultant have entered into that certain Agreement for Consultant Services dated February 14, 2017 (the "Original Agreement"). Except as otherwise defined herein, all capitalized terms used herein shall have the meanings set forth for such terms in the Original Agreement. B. The Original Agreement provided for performance by Consultant of certain services for geographic information system consulting and support services and compensation to Consultant therefor in an amount not to exceed $62,900.00. C. On September 26, 2018, the City approved Amendment No. 1 extending the term to June 30, 2019 and increasing the compensation for services an additional $50,000.00. The Original Agreement and Amendment No. 1 are collectively referred to as the “Agreement.” D. The Parties now desire to extend the term of the Agreement for a period of one (1) year, effective as of July 1, 2019 and ending on June 30, 2020 and to provide for compensation to Consultant for services provided under this Amendment No. 2 in an amount not to exceed $62,900.00. NOW, THEREFORE, in consideration of the mutual covenants and conditions set forth herein, City and Consultant agree as follows: 1.Section 2c, Term, of the Agreement is hereby amended in its entirety to read as follows. “The term of this Agreement shall commence upon execution of this Agreement and shall continue through June 30, 2020, unless earlier terminated as provided herein. Consultant shall complete the services within the Term of this Agreement and shall meet any other established schedules and deadlines.” 2.Section 3, Compensation, of the Agreement is hereby amended to add the following: “Consultant’s compensation for the period commencing July 1, 2019 through June 30, 2020 shall not exceed sixty-two thousand nine hundred and no cents ($62,900.00). Total compensation for services pursuant to this Agreement shall not exceed one hundred seventy-five thousand eight hundred and no cents ($175,800.00).” 3.Except for the changes specifically set forth herein, all other terms and conditions of the Agreement shall remain in full force and effect. DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD Page 2 IN WITNESS WHEREOF, the parties have caused this Amendment No. 2 to be executed on the respective dates set forth below. “CONSULTANT” SCG, LLC ________________________________ Shane Spicer, Managing Director “CITY” CITY OF LAKE ELSINORE, a municipal corporation _____________________________ Grant Yates, City Manager ATTEST: _______________________________ Deputy City Clerk APPROVED AS TO FORM: ________________________________ City Attorney Attachments: Exhibit A – Consultant’s Proposal DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD EXHIBIT A CONSULTANT’S PROPOSAL Additional Layer Migration SCG will collaborate with the City to determine additional layers, most beneficial to the City, for loading into the Enterprise Geodatabase. This will be accomplished through consultation with applicable City staff to determine layers needed to support prioritized business needs of various departments. Once the relevant layers are identified, SCG will migrate the layers to the Enterprise Geodatabase LGIM schema. The migration of existing data layers may require some level of data and attribute translation or reformatting to be properly imported into the LGIM schema. In these instances, SCG will collaborate with the City to ensure the translated data layer meets the City’s needs. In addition, layer consultation may reveal the need for data in the Enterprise Geodatabase that is not currently in a GIS format. Common examples of such data include paper maps, tabular lists, hardcopy descriptions of specific areas such as planning areas, Community Facilities District, special use zones, etc. In these instances, SCG will collaborate with the City to convert the data to a digital GIS layer that is suitable for loading into the LGIM geodatabase schema. Finally, SCG will publish any newly developed or reformatted layers into new and/or revised map and feature services to incorporate the new layers into the City’s ArcGIS Online Organization account. Deliverables: ♦ Layer Consultation Meeting Notes ♦ Report Listing Prioritization of Additional Layers ♦ Newly Developed GIS Layers (As Needed) ♦ Additions of Layers to City Enterprise Geodatabase ♦ Published Layers Added to ArcGIS Online Organization Account Ongoing Support SCG will continue to provide ongoing technical services related to the implementation of the City’s ESRI GIS solutions. This work will be performed on a task order basis, and SCG will provide a written estimate of hours and costs prior to starting any work under this task. Work will not start until the City has authorized the work. Activities that may be performed under this task are described below. ♦ Provide Ongoing GIS Support Services as Needed ♦ Setup and Configuration of New Map and Feature Services in ArcGIS Organization Account ♦ Installation and Configuration of Mobile and Web Application Templates ♦ GIS Data Collection ♦ GIS Map Production ♦ GIS Data Development or Conversion ♦ GIS Data Editing and Updates ♦ Data Migration of Additional Data into Enterprise Geodatabase ♦ GIS Integration with Other City Systems ♦ Other Technical Services as Requested DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD ANY PROPRIETOR/PARTNER/EXECUTIVE OFFICER/MEMBER EXCLUDED? INSR ADDL SUBR LTR INSD WVD PRODUCER CONTACT NAME: FAXPHONE (A/C, No):(A/C, No, Ext): E-MAIL ADDRESS: INSURER A : INSURED INSURER B : INSURER C : INSURER D : INSURER E : INSURER F : POLICY NUMBER POLICY EFF POLICY EXPTYPE OF INSURANCE LIMITS(MM/DD/YYYY) (MM/DD/YYYY) AUTOMOBILE LIABILITY UMBRELLA LIAB EXCESS LIAB WORKERS COMPENSATION AND EMPLOYERS' LIABILITY DESCRIPTION OF OPERATIONS / LOCATIONS / VEHICLES (ACORD 101, Additional Remarks Schedule, may be attached if more space is required) AUTHORIZED REPRESENTATIVE EACH OCCURRENCE $ DAMAGE TO RENTEDCLAIMS-MADE OCCUR $PREMISES (Ea occurrence) MED EXP (Any one person) $ PERSONAL & ADV INJURY $ GEN'L AGGREGATE LIMIT APPLIES PER:GENERAL AGGREGATE $ PRO-POLICY LOC PRODUCTS - COMP/OP AGGJECT OTHER:$ COMBINED SINGLE LIMIT $(Ea accident) ANY AUTO BODILY INJURY (Per person) $ OWNED SCHEDULED BODILY INJURY (Per accident) $AUTOS ONLY AUTOS HIRED NON-OWNED PROPERTY DAMAGE $AUTOS ONLY AUTOS ONLY (Per accident) $ OCCUR EACH OCCURRENCE CLAIMS-MADE AGGREGATE $ DED RETENTION $ PER OTH- STATUTE ER E.L. EACH ACCIDENT E.L. DISEASE - EA EMPLOYEE $ If yes, describe under E.L. DISEASE - POLICY LIMITDESCRIPTION OF OPERATIONS below INSURER(S) AFFORDING COVERAGE NAIC # COMMERCIAL GENERAL LIABILITY Y / N N / A (Mandatory in NH) SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER, AND THE CERTIFICATE HOLDER. IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must have ADDITIONAL INSURED provisions or be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). COVERAGES CERTIFICATE NUMBER:REVISION NUMBER: CERTIFICATE HOLDER CANCELLATION © 1988-2015 ACORD CORPORATION. All rights reserved.ACORD 25 (2016/03) CERTIFICATE OF LIABILITY INSURANCE DATE (MM/DD/YYYY) $ $ $ $ $ The ACORD name and logo are registered marks of ACORD SPICE-1 OP ID: HO 05/31/2019 Jorri D Caldwell ISU Ins. Svc.-Cormarc Tasman License# 0E63467 25220 Hancock Ave. #200 Murrieta, CA 92562 Jorri D Caldwell 951-290-5040 951-278-0664 Travelers Casualty Ins Co NorGuard Insurance Company Spicer Consulting Group, LLC LLC Dba. Spicer Consulting Group dba: Spicer Consulting Group 41619 Margarita Rd, Ste 101 Temecula, CA 92591 Lloyd's of London A X 2,000,000 X X 680-2H870106 05/31/2019 05/31/2020 300,000 5,000 2,000,000 4,000,000 X 4,000,000 1,000,000A 680-2H870106 05/31/2019 05/31/2020 X X XB X SCWC994693 10/07/2018 10/07/2019 1,000,000 1,000,000 1,000,000 C MPL175558019 05/31/2019 05/31/2020 Limit 2,000,000 retro date 5/31/16 Retention 10,000 The City of Lake Elsinore, its elected or appointed officers, officials, employees, agents and volunteers are named as additional insured for the insured's operations with primary wording for insured's operations per written contract. Endorsement CGD105 0494 attached. Work comp waiver of subrogation per WC040306 attached. LAKE130 City of Lake Elsinore City Manager/City Clerk 130 South Main Street Lake Elsinore, CA 92530 951-290-5040 19046 Prof Liability DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD COMMERCIAL GENERAL LIABILITY THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY. OR CONTRACTORS This endorsement modifies insurance provided under the following: COMMERCIAL GENERAL LIABILITY COVERAGE PART PROVISIONS: CG D1 05 04 94 Includes Copyrighted Material from Insurance Services Office, Inc. BLANKET ADDITIONAL INSURED OWNERS, LESSEES Copyright, The Travelers Indemnity Company, 1994.Page 1 of 1 1.WHO IS AN INSURED (SECTION II)is amended to include as an insured any person or organiza- tion (called hereafter "additional insured")whom you have agreed in a written contract,executed prior to loss,to name as additional insured,but only with respect to liability arising out of "your work"or your ongoing operations for that addi- tional insured performed by you or for you. 2.With respect to the insurance afforded to Addi- tional Insureds the following conditions apply: a.Limits of Insurance The following limits of liability apply: 1.The limits which you agreed to provide; or 2.The limits shown on the declarations, whichever is less. b.This insurance is excess over any valid and collectible insurance unless you have agreed in a written contract for this insurance to apply on a primary or contributory basis. 3.This insurance does not apply: a.on any basis to any person or organization for whom you have purchased an Owners and Contractors Protective policy. b.to "bodily injury,""property damage,""per- sonal injury,"or "advertising injury"arising out of the rendering of or the failure to render any professional services by or for you,in- cluding: 1.The preparing,approving or failing to prepare or approve maps,drawings, opinions,reports,surveys,change or- ders, designs or specifications; and 2.Supervisory,inspection or engineering services. DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD WC 00 00 01A (05/88) Copyright 1987 National Council on Compensation Insurance INSURED COPY ISSUING COMPANY Workers' Compensation and Employers Liability Insurance Policy Information Page ACE AMERICAN INSURANCE COMPANY NCCI CARRIER CODE 12165 POLICY NUMBER X New Renewal Rewrite Workers' Compensation and Employers Liability Insurance Policy Symbol: WLR Number: C6 56 25 87 8 PREVIOUS POLICY NO.Individual Partnership Association Symbol: Number:X Corporation Joint Venture Other Legal Entity Item 1.Inter/Intrastate ID No.:TRINET GROUP, INC. Named L/C/F SCG SPICER CONSULTING GROUP LLC 9000 TOWN CENTER PARKWAY BRADENTON FL 34202 Insured Federal Employer ID No.:953359658 Mailing Address Employer's ID No.: PIIC CODE:6282 For other named insured see Extension of Information Page – Schedule of Named Insured, WC 99 99 99 A For other workplaces see Extension of Information Page – Schedule of Other Workplaces, WC 99 99 99 B Item 2.Policy period:From 12-16-2018 To 07-01-2019 12:01 A.M.,standard time at the named insured's mailing address. Item 3A.Workers' Compensation Insurance:Part One of the policy applies to the Workers' Compensation Law of the states listed here: CA Item 3B.Employers Liability Insurance:Part Two of the policy applies to work in each state listed in Item 3A. The limits of our liability under Part Two are:Bodily Injury by Accident $2,000,000 each accident Bodily Injury by Disease $2,000,000 policy limit Bodily Injury by Disease $2,000,000 each employee Item 3C. Other States Insurance: Part Three of the policy applies to the states, if any, listed here: ALL STATES EXCEPT ND,OH,WA,WY, AND STATES DESIGNATED IN ITEM 3.A Item 3D. This Policy includes these endorsements and schedules: See schedule of Forms and Endorsements WC999999D Item 4.The premium for this policy will be determined by our Manual of Rules, Classifications, Rates and Rating Plans. All information required below is subject to verification and change by audit. SEE EXTENSION OF INFORMATION PAGE –CLASSIFICATIONS If indicated here, interim adjustments of premium will be made:Minimum Premium collected in CA $ Semi-Annually Quarterly Monthly Total Estimated Premium $ Deposit Premium $ PRODUCER NAME AND MAILING ADDRESS USI INSURANCE SERVICES NATIONAL INC 2601 SOUTH BAYSHORE DRIVE 16TH FLOOR SUITE 1600 COCONUT GROVE FL 33133 PRODUCER CODE:Z05455 56-1882208 DAU MARKETING OFFICE:DALLAS BRANCH ISSUE DATE:12/27/2018 Authorized Representative DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD BUSINESS NAME: SPICER CONSULTING GROUP BUSINESS 41619 MARGARTTA RD STE101LOCATION: TEMECULA, CA 92591 SHANE SPICER I\4ELISSA BELLITIRE BUSTNESS LTCENSE NO. Llc-2017-02435 BUSINESS TYPE: CONSULTING SERVICES DESCRIPTION: SPECIALIAxCONSULTINGOWNERNAME: SPICER CONSULTING GROUP 416,19 IVARGARITA RD STE 101 TEMECULA, CA 92591 lssue Date: 0610112016 Expiration Datei 06/30/2019 DocuSign Envelope ID: ADAF86F1-6676-4F89-A2A5-769CE27D0ACD AMENDMENT NO. 1 TO AGREEMENT FOR PROFESSIONAL SERVICES FOR GEOGRAPHIC INFORMATION SYSTEM CONSULTING AND SUPPORT SERVICES This Amendment No. 1 to Agreement for Professional Services (the "Amendment No 1") is entered into as of September 26, 2018 by and between the City of Lake Elsinore, a municipal corporation ("City") and SCG, LLC. ("Consultant"). RECITALS A. The City and Consultant have entered into that certain Agreement for Consultant Services dated February 14,2017 (the "Original Agreement"). Except as otherwise deflned herein, all capitalized terms used herein shall have the meanings set forth for such terms in the Original Agreement. B. The Original Agreement provided for performance by Consultant of certain services for geographic information system consulting and support services and compensation to Consultant therefor in an amount not to exceed $62,900.00. C. The Original Agreement expired June 30, 2018. D. The Parties now desire to extend the term of the Original Agreement for a period of one 1) year, effective as of July 1, 2018 and ending on June 30, 2019 and to provide for compensation to Consultant for services provided under this Amendment No. 1 in an amount not to exceed $50,000.00. NOW, THEREFORE, in consideration of the mutual covenants and conditions set forth herein, City and Consultant agree as follows: 1 . Section 2c, Term, of the Original Agreement is hereby amended in its entirety to read as follows. The term of this Agreement shall commence upon execution of this Agreement and shall continue through June 30, 2019, unless earlier terminated as provided herein. Consultant shall complete the services within the Term of this Agreement and shall meet any other established schedules and deadlines. 2. Section 3, Compensation, of the Original Agreement is hereby amended in its entirety to read as follows: Compensation to be paid to Consultant shall be in accordance with the fees set forth in the Consultant's Proposal (Exhibit A), which is attached hereto and incorporated herein by reference, Consultant's compensation for the period commencing July 1 , 2018 through June 30, 2019 shall not exceed fifty thousand and no cents ($50,000.00). Notwithstanding any provision of Consultant's Proposal to the contrary, out of pocket expenses set forth in Exhibit A shall be reimbursed at cost without an inflator or administrative charge. Payment by City under this Agreement shall not be deemed a waiver of defects, even if such defects were known to the City at the time of payment. 1 3. Except for the changes specifically set forth herein, all other terms and conditions ofthe Original Agreement shall remain in full force and effect. lN WITNESS WHEREOF, the parties have caused this Amendment No. 1 to be executed on the respective dates set forth below. CITY' CITY OF LAKE ELSINORE, a municipal corporation ATTEST: Attachments: Exhibit A - Consultant's Proposal CONSULTANT' SCG, LLC Exhibit A Additional Laver Miqration SCG will collaborate with the City to determine additional layers, most beneficial to the City, for loading into the Enterprise Geodatabase. This will be accomplished through consultation with applicable City staff to determine layers needed to support prioritized business needs of various departments. Once the relevant layers are identified, SCG will migrate the layers to the Enterprise Geodatabase LGIM schema. The migration of existing data layers may require some level of data and attribute translation or reformatting to be properly imported into the LGIM schema. ln these instances, SCG will collaborate with the City to ensure the translated data layer meets the City's needs. ln addition, layer consultation may reveal the need for data in the Enterprise Geodatabase that is not currently in a GIS format. Common examples of such data include paper maps, tabular lists, hardcopy descriptions of specific areas such as planning areas, Community Facilities District, special use zones, etc. ln these instances, SCG will collaborate with the City to convert the data to a digital GIS layer that is suitable for loading into the LGIM geodatabase schema. Finally, SCG will publish any newly developed or reformatted layers into new and/or revised map and feature services to incorporate the new layers into the City's ArcGlS Online Organization account. Deliverables: r Layer Consultation Meeting Notes r Report Listing Prioritization of Additional Layers r Newly Developed GIS Layers (As Needed) o Additions of Layers to City Enterprise Geodatabase I Published Layers Added to ArcGlS Online Organization Account Onqoinq Supoort SCG will continue to provide ongoing technical services related to the implementation of the City's ESRI GIS solutions. This work will be performed on a task order basis, and SCG will provide a written estimate of hours and costs prior to starting any work under this task. Work will not start until the City has authorized the work. Activities that may be performed under this task are described below. r Provide Ongoing GIS Support Services as Needed r Setup and Configuration of New Map and Feature Services in ArcGlS Organization Account lnstallation and Configuration of Mobile and Web Application Templates o GIS Data Collection r GIS Map Production GIS Data Development or Conversion GIS Data Editing and Updates Data Migration of Additional Data into Enterprise Geodatabase GIS lntegration with Other City Systems o Other Technical Services as Requested 3 AGREEMENT FOR PROFESSIONAL SERVICES BETWEEN THE CITY OF LAKE ELSINORE AND SCG, LLC FOR GEOGRAPHIC INFORMATION SYSTEM CONSULTING AND SUPPORT SERVICES This Agreement for Professional Services (the "Agreement") is made and entered into as of February 14, 2017, by and between the City of Lake Elsinore, a municipal corporation ("City") and SCG, LLC. ("Consultant"). RECITALS A. The City has determined that it requires the following professional services for all consulting and support services for geographic information systems ("GIS"), including: the setup of ArcGIS Enterprise Server and Enterprise Geodatabase, Setup Local Government Information Model Schema, Migrate Data Layers to LGIM Schema to Support EnerGov, Setup ArcGIS Online Organization Account and Users, Setup ArcGIS Online Map and Layer Services for EnerGov Integration, Migrate Additional Secondary Layers to LGIM Schema, and training and ongoing support to City staff. B. Consultant has submitted to City a proposal, attached hereto as Exhibit A ("Consultant's Proposal") and incorporated herein, to provide professional services to City pursuant to the terms of this Agreement. C. Consultant possesses the skill, experience, ability, background, certification and knowledge to perform the services described in this Agreement on the terms and conditions described herein. D. City desires to retain Consultant to perform the services as provided herein and Consultant desires to provide such professional services as set forth in this Agreement. AGREEMENT 1. Scope of Services. Consultant shall perform the services described in Consultant's Proposal (Exhibit A). Consultant shall provide such services at the time, place, and in the manner specified in Consultant's Proposal (Exhibit A), subject to the direction of the City through its staff that it may provide from time to time. 2. Time of Performance. a. Time of Essence. Time is of the essence in the performance of this Agreement. The time for completion of the professional services to be performed by Consultant is an essential condition of this Agreement. Consultant shall prosecute regularly and diligently the professional services contemplated pursuant to this Agreement according to the agreed upon performance schedule in Consultant's Proposal (Exhibit A). b. Performance Schedule. Consultant shall commence the services pursuant to this Agreement upon receipt of a written notice to proceed and shall perform all services within the time period(s) established in the Consultant's Proposal (Exhibit A). When requested by Page 1 Consultant, extensions to the time periods) specified may be approved in writing by the City Manager. G. Term. The term of this Agreement shall commence upon execution of this Agreement and shall continue through June 30, 2018, unless earlier terminated as provided herein. Consultant shall complete the Services within the Term of this Agreement, and shall meet any other established schedules and deadlines. 3. Compensation. Compensation to be paid to Consultant shall be in accordance with the fees set forth in Scope of Work (Exhibit A), which is attached hereto and incorporated herein by reference. Consultant's initial compensation is sixty-two thousand nine hundred dollars and no cents ($62,900.00). Notwithstanding any provision of Consultant's Proposal to the contrary, out of pocket expenses set forth in Exhibit A shall be reimbursed at cost without an inflator or administrative charge. Payment by City under this Agreement shall not be deemed a waiver of defects, even if such defects were known to the City at the time of payment. 4. Method of Paymen#. Contractor shall promptly submit billings to the City describing the services and related work performed during the preceding month to the extent that such services and related work were performed. Contractor's bills shall be segregated by project task, if applicable, such that the City receives a separate accounting for work done on each individual task for which Contractor provides services. Contractor's bills shall include a brief description of the services performed, the date the services were performed, the number of hours spent and by whom, and a description of any reimbursable expenditures. City shall pay Contractor no later than forty-five (45) days after receipt of the monthly invoice by City staff. 5. Suspension or Termination. a. The City may at any time, for any reason, with or without cause, suspend or terminate this Agreement, or any portion hereof, by serving upon the Consultant at least ten (10) days prior written notice. Upon receipt of such notice, the Consultant shall immediately cease all work under this Agreement, unless the notice provides otherwise. If the City suspends or terminates a portion of this Agreement such suspension or termination shall not make void or invalidate the remainder of this Agreement. b. In the event this Agreement is terminated pursuant to this Section, the City shall pay to Consultant the actual value of the work performed up to the time of termination, provided that the work performed is of value to the City. Upon termination of the Agreement pursuant to this Section, the Consultant will submit an invoice to the City, pursuant to Section entitled "Method of Payment" herein. 6. Ownership_ of Documents. All plans, studies, documents and other writings prepared by and for Consultant, its officers, employees and agents and subcontractors in the course of implementing this Agreement, except working notepad internal documents, shall become the property of the City upon payment to Consultant for such work, and the City shall have the sole right to use such materials in its discretion without further compensation to Consultant or to any other parry. Consultant shall, at Consultant's expense, provide such reports, plans, studies, documents and other writings to City upon written request. City acknowledges that any use of such materials in a manner beyond the intended purpose as set forth herein shall be at the sole risk of the City. City further agrees to defend, indemnify and hold harmless Consultant, its officers, officials, agents, employees and volunteers from any claims, demands, actions, losses, damages, injuries, and liability, direct or indirect (including any and all costs and Page 2 expenses in connection therein), arising out of the City's use of such materials in a manner beyond the intended purpose as set forth herein. a. Licensinq of Intellectual Property. This Agreement creates a nonexclusive and perpetual license for City to copy, use, modify, reuse, or sublicense any and all copyrights, designs, and other intellectual property embodied in plans, specifications, studies, drawings, estimates, and other documents or works of authorship fixed in any tangible medium of expression, including but not limited to, physical drawings or data magnetically or otherwise recorded on computer diskettes, which are prepared or caused to be prepared by Consultant under this Agreement ("Documents & Data"). Consultant shall require that all subcontractors agree in writing that City is granted a nonexclusive and perpetual license for any Documents & Data the subcontractor prepares under this Agreement. Consultant represents and warrants that Consultant has the legal right to license any and all Documents & Data. Consultant makes no such representation and warranty in regard to Documents & Data which were prepared by design professionals other than Consultant or provided to Consultant by the City. City shall not be limited in any way in its use of the Documents & Data at any time, provided that any such use not within the purposes intended by this Agreement shall be at City's sole risk. b. Confidentiality. All ideas, memoranda, specifications, plans, procedures, drawings, descriptions, computer program data, input record data, written information, and other Documents & Data either created by or provided to Consultant in connection with the performance of this Agreement shall be held confidential by Consultant. Such materials shall not, without the prior written consent of City, be used by Consultant for any purposes other than the performance of the services under this Agreement. Nor shall such materials be disclosed to any person or entity not connected with the performance of the services under this Agreement. Nothing furnished to Consultant which is otherwise known to Consultant or is generally known, or has become known, to the related industry shall be deemed confidential. Consultant shall not use City's name or insignia, photographs relating to project for which Consultant's services are rendered, or any publicity pertaining to the Consultant's services under this Agreement in any magazine, trade paper, newspaper, television or radio production or other similar medium without the prior written consent of City. 7. Consultant's Books and Records. a. Consultant shall maintain any and all ledgers, books of account, invoices, vouchers, canceled checks, and other records or documents evidencing or relating to charges for services, or expenditures and disbursements charged to City for a minimum period of three (3) years, or for any longer period required by law, from the date of final payment to Consultant to this Agreement. b. Consultant shall maintain all documents and records which demonstrate performance under this Agreement for a minimum period of three (3) years, or for any longer period required by law, from the date of termination or completion of this Agreement. C. Any records or documents required to be maintained pursuant to this Agreement shall be made available for inspection or audit, at any time during regular business hours, upon written request by the City Manager, City Attorney, City Auditor or a designated representative of these officers. Copies of such documents shall be provided to the City for inspection at City Hall when it is practical to do so. Otherwise, unless an alternative is mutually agreed upon, the records shall be available at Consultant's address indicated for receipt of notices in this Agreement. Page 3 d. Where City has reason to believe that such records or documents may be lost or discarded due to dissolution, disbandment or termination of Consultant's business, City may, by written request by any of the above -named officers, require that custody of the records be given to the City and that the records and documents be maintained in City Hall. Access to such records and documents shall be granted to any party authorized by Consultant, Consultant's representatives, or Consultant's successor -in -interest. 8. Independent Contractor. It is understood that Consultant, in the performance of the work and services agreed to be performed, shall act as and be an independent contractor and shall not act as an agent or employee of the City. 9. PERS Eligibility Indemnification. In the event that Consultant or any employee, agent, or subcontractor of Consultant providing services under this Agreement claims or is determined by a court of competent jurisdiction or the California Public Employees Retirement System (PERS) to be eligible for enrollment in PERS as an employee of the City, Consultant shall indemnify, defend, and hold harmless City for the payment of any employee and/or employer contributions for PERS benefits on behalf of Consultant or its employees, agents, or subcontractors, as well as for the payment of any penalties and interest on such contributions, which would otherwise be the responsibility of City. Notwithstanding any other federal, state and local laws, codes, ordinances and regulations to the contrary, Consultant and any of its employees, agents, and subcontractors providing service under this Agreement shall not qualify for or become entitled to, and hereby agree to waive any claims to, any compensation, benefit, or any incident of employment by City, including but not limited to eligibility to enroll in PERS as an employee of City and entitlement to any contribution to be paid by City for employer contribution and/or employee contributions for PERS benefits. 10. Interests of Consultant. Consultant (including principals, associates and professional employees) covenants and represents that it does not now have any investment or interest in real property and shall not acquire any interest, direct or indirect, in the area covered by this Agreement or any other source of income, interest in real property or investment which would be affected in any manner or degree by the performance of Consultant's services hereunder. Consultant further covenants and represents that in the performance of its duties hereunder no person having any such interest shall perform any services under this Agreement. Consultant is not a designated employee within the meaning of the Political Reform Act because Consultant: a. will conduct research and arrive at conclusions with respect to his/her rendition of information, advice, recommendation or counsel independent of the control and direction of the City or of any City official, other than normal agreement monitoring; and b. possesses no authority with respect to any City decision beyond rendition of information, advice, recommendation or counsel. (FPPC Reg. 18700(a)(2).) 11. Professional Ability of Consultant. City has relied upon the professional training and ability of Consultant to perform the services hereunder as a material inducement to enter into this Agreement. Consultant shall therefore provide properly skilled professional and technical personnel to perform all services under this Agreement. All work performed by Consultant under this Agreement shall be in accordance with applicable legal requirements and shall meet the Page 4 standard of quality ordinarily to be expected of competent professionals in Consultant's field of expertise. 12. Compliance with Laws. Consultant shall use the standard of care in its profession to comply with all applicable federal, state and local laws, codes, ordinances and regulations. 13. Licenses. Consultant represents and warrants to City that it has the licenses, permits, qualifications, insurance and approvals of whatsoever nature which are legally required of Consultant to practice its profession. Consultant represents and warrants to City that Consultant shall, at its sole cost and expense, keep in effect or obtain at all times during the term of this Agreement, any licenses, permits, insurance and approvals which are legally required of Consultant to practice its profession. Consultant shall maintain a City of Lake Elsinore business license. 14. Indemnity. Consultant shall indemnify, defend, and hold harmless the City and its officials, officers, employees, agents, and volunteers from and against any and all losses, liability, claims, suits, actions, damages, and causes of action arising out of any personal injury, bodily injury, loss of life, or damage to property, or any violation of any federal, state, or municipal law or ordinance, to the extent caused, in whole or in part, by the willful misconduct or negligent acts or omissions of Consultant or its employees, subcontractors, or agents, by acts for which they could be held strictly liable, or by the quality or character of their work. The foregoing obligation of Consultant shall not apply when (1) the injury, loss of life, damage to property, or violation of law arises from the sole negligence or willful misconduct of the City or its officers, employees, agents, or volunteers and (2) the actions of Consultant or its employees, subcontractor, or agents have contributed in no part to the injury, loss of life, damage to property, or violation of law. It is understood that the duty of Consultant to indemnify and hold harmless includes the duty to defend as set forth in Section 2778 of the California Civil Code. Acceptance by City of insurance certificates and endorsements required under this Agreement does not relieve Consultant from liability under this indemnification and hold harmless clause. This indemnification and hold harmless clause shall apply to any damages or claims for damages whether or not such insurance policies shall have been determined to apply. By execution of this Agreement, Consultant acknowledges and agrees to the provisions of this Section and that it is a material element of consideration. 15. Insurance Requirements. a. Insurance. Consultant, at Consultant's own cost and expense, shall procure and maintain, for the duration of the contract, unless modified by the City's Risk Manager, the following insurance policies. i. Workers' Compensation Coverage. Consultant shall maintain Workers' Compensation Insurance and Employer's Liability Insurance for his/her employees in accordance with the laws of the State of California. In addition, Consultant shall require each subcontractor to similarly maintain Workers' Compensation insurance and Employer's Liability Insurance in accordance with the laws of the State of California for all of the subcontractor's employees. Any notice of cancellation or non -renewal of all Workers' Compensation policies must be received by the City at least thirty (30) days prior to such change. The insurer shall agree to waive all rights of subrogation against City, its officers, agents, employees and volunteers for losses arising from work performed by Consultant for City. In the event that Consultant is exempt from Worker's Compensation Insurance and Employer's Liability Insurance for his/her employees in accordance with Page 5 the laws of the State of California, Consultant shall submit to the City a Certificate of Exemption from Workers Compensation Insurance in a form approved by the City Attorney. ii. General Liability Coverage. Consultant shall maintain commercial general liability insurance in an amount not less than one million dollars ($1,000,000) per occurrence for bodily injury, personal injury and property damage. If a commercial general liability insurance form or other form with a general aggregate limit is used, either the general aggregate limit shall apply separately to the work to be performed under this Agreement or the general aggregate limit shall be at least twice the required occurrence limit. Required commercial general liability coverage shall be at least as broad as Insurance Services Office Commercial General Liability occurrence form CG 0001 (ed. 11188) or Insurance Services Office form number GL 0002 (ed. 1173) covering comprehensive General Liability and Insurance Services Office form number GL 0404 covering Broad Form Comprehensive General Liability. No endorsement may be attached limiting the coverage. iii. Automobile_ Liability Coverage. Consultant shall maintain automobile liability insurance covering bodily injury and property damage for all activities of the Consultant arising out of or in connection with the work to be performed under this Agreement, including coverage for owned, hired and non -owned vehicles, in an amount of not less than one million dollars ($1,000,000) combined single limit for each occurrence. Automobile liability coverage must be at least as broad as Insurance Services Office Automobile Liability form CA 0001 (ed. 12190) Code 1 ("any auto"). No endorsement may be attached limiting the coverage. b. Endorsements. Each general liability and automobile liability insurance policy shall be with insurers possessing a Best's rating of no less than A:VII and shall be endorsed with the following specific language: i. The City, its elected or appointed officers, officials, employees, agents and volunteers are to be covered as additional insured with respect to liability arising out of work performed by or on behalf of the Consultant, including materials, parts or equipment furnished in connection with such work or operations. ii. This policy shall be considered primary insurance as respects the City, its elected or appointed officers, officials, employees, agents and volunteers. Any insurance maintained by the City, including any self -insured retention the City may have, shall be considered excess insurance only and shall not contribute with it. iii. This insurance shall act for each insured and additional insured as though a separate policy had been written for each, except with respect to the limits of liability of the insuring company. iv. The insurer waives all rights of subrogation against the City, its elected or appointed officers, officials, employees or agents. V. Any failure to comply with reporting provisions of the policies shall not affect coverage provided to the City, its elected or appointed officers, officials, employees, agents or volunteers. Page 6 vi. The insurance provided by this Policy shall not be suspended, voided, canceled, or reduced in coverage or in limits except after thirty (30) days written notice has been received by the City. G. Deductibles and Self -Insured Retentions. Any deductibles or self -insured retentions must be declared to and approved by the City. At the City's option, Consultant shall demonstrate financial capability for payment of such deductibles or self -insured retentions. d. Certificates of Insurance. Consultant shall provide certificates of insurance with original endorsements to City as evidence of the insurance coverage required herein. Certificates of such insurance shall be filed with the City on or before commencement of performance of this Agreement. Current certification of insurance shall be kept on file with the City at all times during the term of this Agreement. 16. Notices. Any notice required to be given under this Agreement shall be in writing and either served personally or sent prepaid, first class mail. Any such notice shall be addressed to the other party at the address set forth below. Notice shall be deemed communicated within 48 hours from the time of mailing if mailed as provided in this section. If to City: City of Lake Elsinore Attn: City Manager 130 South Main Street Lake Elsinore, CA 92530 With a copy to: City of Lake Elsinore Attn: City Clerk 130 South Main Street Lake Elsinore, CA 92530 If to Consultant: SCG, LLC Attn: Shane Spicer 25220 Hancock Avenue, Suite 300 Murrieta, CA 92562 17. Entire Agreement. This Agreement constitutes the complete and exclusive statement of Agreement between the City and Consultant. All prior written and oral communications, including correspondence, drafts, memoranda, and representations, are superseded in total by this Agreement. 18. Amendments. This Agreement may be modified or amended only by a written document executed by both Consultant and City and approved as to form by the City Attorney. 19. Assignment and Subcontracting. The parties recognize that a substantial inducement to City for entering into this Agreement is the professional reputation, experience and competence of Consultant and the subcontractors listed in Exhibit B. Consultant shall be fully responsible to City for all acts or omissions of any subcontractors. Assignments of any or all rights, duties or obligations of the Consultant under this Agreement will be permitted only with the express consent of the City. Consultant shall not subcontract any portion of the work to be performed under this Agreement except as provided in Exhibit B without the written authorization of the City. If City consents to such subcontract, Consultant shall be fully responsible to City for all acts or omissions of those subcontractors. Nothing in this Agreement shall create any Page 7 contractual relationship between City and any subcontractor nor shall it create any Obligation on the part of the City to pay or to see to the payment of any monies due to any such subcontractor other than as otherwise is required by law. 20. Waiver. Waiver of a breach or default under this Agreement shall not constitute a continuing waiver of a subsequent breach of the same or any other provision under this Agreement. 21. 5everability. If any term or portion of this Agreement is held to be invalid, illegal, or otherwise unenforceable by a court of competent jurisdiction, the remaining provisions of this Agreement shall continue in full force and effect. 22. Controllinq Law Venue. This Agreement and all matters relating to it shall be governed by the laws of the State of California and any action brought relating to this Agreement shall be held exclusively in a state court in the County of Riverside. 23. Litigation Expenses and Attorneys' Fees. If either party to this Agreement commences any legal action against the other party arising out of this Agreement, the prevailing party shall be entitled to recover its reasonable litigation expenses, including court costs, expert witness fees, discovery expenses, and attorneys' fees. 24. Mediation. The parties agree to make a good faith attempt to resolve any disputes arising out of this Agreement through mediation prior to commencing litigation. The parties shall mutually agree upon the mediator and share the costs of mediation equally. If the parties are unable to agree upon a mediator, the dispute shall be submitted to JAMS or its successor in interest. JAMS shall provide the parties with the names of five qualified mediators. Each party shall have the option to strike two of the five mediators selected by JAMS and thereafter the mediator remaining shall hear the dispute. If the dispute remains unresolved after mediation, either party may commence litigation. 25. Execution. This Agreement may be executed in several counterparts, each of which shall constitute one and the same instrument and shall become binding upon the parties when at least one copy hereof shall have been signed by both parties hereto. In approving this Agreement, it shall not be necessary to produce or account for more than one such counterpart. 26. Authority to Enter Agreement. Consultant has all requisite power and authority to conduct its business and to execute, deliver, and perform the Agreement. Each party warrants that the individuals who have signed this Agreement have the legal power, right, and authority to make this Agreement and to bind each respective party. The City Manager is authorized to enter into an amendment or otherwise take action on behalf of the City to make the following modifications to the Agreement: (a) a name change; (b) grant extensions of time; (c) non - monetary changes in the scope of services; and/or (d) suspend or terminate the Agreement. 27. Prohibited Interests. Consultant maintains and warrants that it has not employed nor retained any company or person, other than a bona fide employee working solely for Consultant, to solicit or secure this Agreement. Further, Consultant warrants that it has not paid nor has it agreed to pay any company or person, other than a bona fide employee working solely for Consultant, any fee, commission, percentage, brokerage fee, gift or other consideration contingent upon or resulting from the award or making of this Agreement. For breach or violation of this warranty, City shall have the right to rescind this Agreement without liability. For the term of this Agreement, no member, officer or employee of City, during the term of his or her service Page 8 with City, shall have any direct interest in this Agreement, or obtain any present or anticipated material benefit arising therefrom. 28. Egual Opportunity Employment. Consultant represents that it is an equal opportunity employer and it shall not discriminate against any subcontractor, employee or applicant for employment because of race, religion, color, national origin, handicap, ancestry, sex or age. Such non-discrimination shall include, but not be limited to, all activities related to initial employment, upgrading, demotion, transfer, recruitment or recruitment advertising, layoff or termination. 29. Prevailinq Wades. Consultant is aware of the requirements of California Labor Code Section 1720, et seq., and 1770, et seq., as well as California Code of Regulations, Title 8, Section 16000, et seq., ("Prevailing Wage Laws"), which require the payment of prevailing wage rates and the performance of other requirements on "public works" and "maintenance" projects. Consultant agrees to fully comply with all applicable federal and state labor laws (including, without limitation, if applicable, the Prevailing Wage Laws). It is agreed by the parties that, in connection with the Work or Services provided pursuant to this Agreement, Consultant shall bear all risks of payment or non-payment of prevailing wages under California law, and Consultant hereby agrees to defend, indemnify, and hold the City, and its officials, officers, employees, agents, and volunteers, free and harmless from any claim or liability arising out of any failure or alleged failure to comply with the Prevailing Wage Laws. The foregoing indemnity shall survive termination of this Agreement. 30. Execution. This Agreement may be executed in several counterparts, each of which shall constitute one and the same instrument and shall become binding upon the parties when at least one copy hereof shall have been signed by both parties hereto. In approving this Agreement, it shall not be necessary to produce or account for more than one such counterpart. Page 9 IN WITNESS WHEREOF, the parties have caused this Agreement to be executed on the date first written above. "CITY" CITY OF LAKE ELSINORE, a "CONSULTANT" municipal SCG, LLC 17 jh"apicer"aing Director ATTEST: Pperlk=[-- OttorAPPRED AS TO FORM:-�ney Attachments: Exhibit A — Consultant's Proposal Page 10 EXHIBIT A CONSULTANT'S PROPOSAL January 24, 2017 Mr. Jason Simpson Director of Administrative Services City of Lake Elsinore 130 South Main Street Lake Elsinore, CA 92530 RE: GIS Implementation Services Spicer Consulting Group, LLC (SCG) is pleased to present this proposal for GIS implementation services for the City of Lake Elsinore (City). This proposal represents our understanding of the City's GIS needs with respect to supporting the implementation of EnerGov and the desire to expand access and use of GIS throughout the City. For this project, we have teamed with two experienced GIS professionals who are ESRI Silver Network Partners and Certified GIS professionals. Combined, they have nearly 40 years of experience with ESRI technology with specific experience implementing enterprise GIS technology for local agencies throughout Southern California. We are confident our team can design and build a GIS system that will meet the City's immediate needs for EnerGov, and provide a solid foundation for the continued expansion of GIS technology throughout the City to support its growing development. Project Understanding The City of Lake Elsinore is an incorporated city in Western Riverside County, California. It was established as a city in 1888 along the shore of Lake Elsinore, a natural freshwater lake of approximately 3,000 acres. Since its inception, the City has grown from a small resort town to a rapidly growing urbanized area with a population of over 61,006 in 2016. Population change since the year 2000 has been 107.5%. The City is approximately two-thirds undeveloped and is anticipating a major increase in building permit activity as the buildout of specific planned developments occurs. To help manage this buildout and support the City's strategic initiative for service as part of its Vision Statement, the City has started implementing EnerGov, an enterprise permitting and land management system developed by Tyler Technologies. EnerGov relies on a GIS land -base which the system interfaces with to associate permitting and land management activities with the corresponding spatial features those activities occur on (e.g. parcels, addresses, etc.). Further, with the recent retirement of the City's GIS Analyst, the City also has no current GIS staff and many GIS data layers remain stored in various formats and locations that have been developed and assembled over lime from various projects. The City's GIS environment needs to be setup so that the City can begin leveraging GIS to improve processes and support. To help ensure that the City's GIS system is set up to facilitate a well -developed and reliable integration with EnerGov, and ensure the City is best positioned to take full advantage of all EnerGov capabilities moving forward, the City desires to implement a new GIS design and data organization schema to better support its rollout of EnerGov and enable more widespread access to GIS information and GIS services throughout the City's enterprise. SCG understands that the City will be purchasing a Small Government Enterprise License Agreement (SGELA) from ESRI to obtain the software needed to support its EnerGov rollout and its GIS expansion efforts. Under the SGEGLA, the City further intends to setup a new server on which it will install ArcGIS Enterprise (formerly ArcGIS Server) that will host a a new enterprise geodatabase and a new data schema based on ESRI's Local Government Information Model (LGIM). Once ArcGIS Enterprise is setup and the LGIM data schema is established, the City plans to migrate selected data from its older shapefile and geodatabase sources into the LGIM schema within the new enterprise geodatabase. Mr. Jason Simpson City of Lake Elsinore Page 2 We also understand that the City also intends to implement a secure ArcGIS Online Organization to facilitate the organization of maps, services, and data throughout the city enterprise. Following migration of data into the LGIM schema in its new enterprise geodatabase, the City intends to develop and publish new map and feature services to its ArcGIS Organization account for sharing use by EnerGov and other City departments. We further understand that the City's immediate need is to implement an enterprise geodatabase and ArcGIS Organization structure to support its existing EnerGov applications. Subsequent additional maps, services and applications that support additional department functions and business processes will follow, as they are prioritized. We unders#and that the City's IT department will establish a new virtual server to host the pending ArcGIS Enterprise installation and geodatabase. The City will also reallocate their ArcGIS Desktop product licenses and setup one workstation for a GIS administrator and additional workstations for GIS editors. This proposal is for setting up the City's GIS environment including the GIS Server, ArcGIS Online Organization accounts, and an administrative and editor workstation. SCG will also migrate data layers to the new ArcGIS Enterprise geodatabase that are needed to access ArcGIS Online Organization web applications and services that support the City's EnerGov platform. Project Team Mr. Shane Spicer will serve as Account Manager. Shane has a strong technical and professional background with municipal agencies which make him well versed with the ability to serve the best interests of the City. Shane will be the day -today contact for City Staff, and be responsible for maintaining the project schedules, and will work with City Staff to ensure a successful outcome of this project from beginning to end. This will include a strict adherence to the project schedule that will be developed and maintained at the project's onset. Mr. John Donoghue will serve as Lead Analyst and Liaison with ESRI. John is a certified GIS Professional, ESRI Partner Network Silver Member, and an ESRI Certified ArcGIS Desktop Professional with 17+ years' experience providing integration, implementation, database design, and application development services and extensive experience applying GIS technologies in local, state, and tribal government; special districts, and other settings. He has also served the A/E/C industry leading GIS modeling for environmental impact analyses, conservation programs, and habitat conservation plans for many public, private and non -governmental organization projects throughout Southern California. In addition, he has lead GIS application development projects supporting airport noise mitigation projects in California and the eastern US. Mr. Bruce Miller will serve as Project Manager on the integration process. Bruce is the founder of Miller Spatial Services, LLC, and graduated with a B.S. degree in Environmental science from the University of California, Riverside. He is certified as a Geographic Information Systems Professional (GISP) with over 20 years of professional experienoe in GIS within the engineering industry providing GIS services to public agencies throughout California. Mr. Miller is an ESRI Silver Network Partner and a CityWorks Partner. He has Over 10 years of project management experience and has been responsible for directing complex mapping projects addressing logistical and technical concerns. Services include database development, administration and maintenance, map creation, needs assessment, implementation and integration. Mr. Jason Simpson City of Lake Elsinore Page 3 Scope of Work Based on our understanding of the project discussed above, SCG proposes to complete following scope of work: Setup ArcGIS Enterprise Server and Enterprise Geodatabase i Setup Local Government Information Model Schema + Migrate Data Layers to LGIM Schema to Support EnerGov • Setup ArcGIS Online Organization Account and Users Setup ArcGIS Online Map and Layer Services for EnerGov Integration • Migrate Additional Secondary Layers to LGIM Schema • Training and Ongoing Support Task 1: Project Initiation In this task, SCG will hold a project kickoff meeting to confirm the project requlrements and scope of work. This meeting will be held at the City and should include all staff that SCG will work with. Contact information and the technical details of the project will be documented. Deliverables: • Meeting Notes ♦ Revised Scope of Work (if necessary) Task 2. Setup GIS Server In this task, SCG will work with the City to install and configure the following software on a new virtual machine the City establishes: Microsoft SQL Server ArcGIS Enterprise (formerly ArcGIS Server) version 10.4.x ArcGIS Desktop Advanced 10.4.x Please note: The City will need to provide SCG with access to ESRI licensing and ESRI and Microsoft software prior to starting this task. SCG can obtain the licensing and software for the City if the City's customer information is provided. SCG can also be added as an Administrator through the myESRI.com website. In addition to the software being installed, SCG will also setup an enterprise geodatabase and configure the necessary permissions in SQL Server and ArcGIS Enterprise. Given the City's requirements, SCG recommends that the City implement ESRI's Local Government Information Model (LGIM) geodatabase schema to store enterprise GIS data within. This schema will allow the City to take advantage of a variety of ESRI application templates that are pre - configured to work with this model. SCG will load LGIM template into ArcGIS Enterprise to create the initial enterprise geodatabase. Deliverables: ♦ Install Microsoft SQL Server onto Virtual Server Provided by the City ♦ Install ArcGIS License Manager (If Needed) t Install ArcGIS Desktop 10.4.X On Virtual Server for Administration • Install and Configure ArcGIS Enterprise Server Version 10.4.X + Install and Configure LGIM Schema into Enterprise Geodatabase ♦ Install ArcGIS Web Adaptor Task 3: Setup ArcGIS OnlinelPortal In this task, SCG will setup the City's ArcGIS Online Organization account and users using ESRI's recommended setup for Local Government. The ArcGIS Online Organization account will be the primary access point for City staff to access GIS information. SCG will configure one ArcGIS Online Web Application for use by the City as a general GIS Viewer. Mr. Jason Simpson City of Lake Elsinore Page 4 SCG will create a digital map in ArcMap that will be used to publish a general basemap for ArcGIS Online and a general GIS Viewer application. We will worts with City staff to define the cartographic look of the map. A draft map will be reviewed with the City. The map will be revised based on feedback provided by the City. Once the map is approved by the City, map services will be created and published for access by ArcGIS Online. A Map Service is how ArcGIS Online will access the map. A geocoding service will also be setup. This service will be used to find an address or intersection on the map. r)PGvPmhlps- + ArcGIS Online Organization City Account Established • User Accounts Configured + Groups Configured ♦ Homepage Configured # Map and Geocoding Services ♦ General GIS Viewer Web Application Task 4: Data Migration for EnerGov SCG will load existing GIS data needed to support EnerGov into the LGIM schema within the ArcGIS Enterprise geodatabase and will create the basemap dataset that will be used by EnerGov. It is anticipated that the required GIS data will be either data provided by the City or data that is freely available from the County of Riverside. SCG will compare the County parcels and centerlines to the imagery to verify that the County data is spatially suitable for use by the City as a basemap. Any City provided GIS data needing to be accessed within ArcGIS Online or EnerGov (via ArcGIS Online) will need to be converted to feature classes that will reside in the Enterprise Geodatabase. For initial EnerGov support, we propose to migrate the following data into the Enterprise Geodatabase: Parcels* a Address Points a Street Centerlines* ♦ City Boundaries " SCG will compare the Riverside County Parcels and Street Centerlines to the City's imagery to verify that the spatial accuracy is suitable for the City's basemap. If issues are found, SCG will coordinate discussions with Riverside County on the best process to get the County parcels updated to meet City's needs. SCG will also develop new map and feature services for these layers in the City's ArcGIS Online Organization account and collaborate with Matt Woods to reconfigure EnerGov to access the new map and feature services. Deliverables: ♦ County Parcel/Centerline Analysis Findings ♦ Load layers into LGIM schema that support Energov + Publish layers to ArcGIS Online/Portal for EnerGov • Collaboration with Matt Woods to reconfigure EnerGov Task S: Additional Layer Migration In this task, SCG will collaborate with the City to determine additional layers, most beneficial to the City, for loading into the Enterprise Geodatabase. This will be accomplished through consultation with applicable City staff to determine layers needed to support prioritized business needs of various departments. Once the relevant layers are identified, SCG will migrate the layers to the Enterprise Geodatabase LGIM schema. Mr. Jason Simpson City of Lake Elsinore Page 5 The migration of existing data layers may require some level of data and attribute translation or reformatting to be properly imported into the LGIM schema. In these instances, SCG will collaborate with the City to ensure the translated data layer meets the City's needs. In addition, layer consultation may reveal the need for data in the Enterprise Geodatabase that is not currently in a GIS format. Common examples of such data include paper maps, tabular lists, hardcopy descriptions of specific areas such as planning areas, Community Facilities district, special use zones, etc. In these instances, SCG will collaborate with the City to convert the data to a digital GIS layer that is suitable for loading into the LGIM geodatabase schema. Finally, SCG will publish any newly developed or reformatted layers into new and/or revised map and feature services to incorporate the new layers into the City's ArcGIS Online Organization account. Deliverables: • Layer Consultation Meeting Notes • Report Listing Prioritization of Additional Layers • Newly Developed GIS Layers (As Needed) • Additions of Layers to City Enterprise Geodatabase • Published Layers Added to ArcGIS Online Organization Account Task 6: Ongoing Support In this task, SCG will provide ongoing technical services related to the implementation of the City's E S R I GIS solutions. This work will be performed on a task order basis, and SCG will provide a written estimate of hours and costs prior to starting any work under this task. Work will not start until the City has authorized the work. Activities that may be performed under this task are described below. • Provide Ongoing GIS Support Services as Needed • Setup and Configuration of New Map and Feature Services in ArcGIS Organization Account • Installation and Configuration of Mobile and Web Application Templates • GIS Data Collection • GIS Map Production • GIS Data Development or Conversion • GIS Data Editing and Updates • Data Migration of Additional Data into Enterprise Geodatabase • GIS Integration with Other City Systems • Other Technical Services as Requested Proposed Schedule Weeks Task 1 2 3 4 S 5 7+ Task 1: Project Initiation Task 2: Setup GIS Server Task 3: Setup ArcGIS Online/Portal Task 4: Data Migration for EnerGov Proposed Fee Schedule We propose Tasks 1 thru 4 on a Fixed Fee budget of ly,9d0. Due to the uncertain and highly variable level of effort that may be involved in migrating existing GIS data from its current formats and/or converting non-GIS data into GIS data that can to be loaded into a precisely defined Enterprise Geodatabase schema, we are unable to provide fixed Mr. Jason Simpson City of Lake Elsinore Page 6 cost estimates for Tasks 5 and 6. We propose to bill these tasks at the rates listed below, on a time and material basis, based on an authorized budget to be determined in consultation with the City. Task 1: Project Initiation J $3,700 Task 2: Setup GIS Server $2,300 Task 3: Setup ArcGIS ONine/Portal $3,700 Task 4: Data Migration for EnerGov $25,200 Total $34,900 Description Task 5: Additional Layer Migration Time and Materials Task 6: Ongoing Support I Time and Materials Hourly Rates Princi al $150 Senior Associate $133 Associate $115 Pro rr,raammer $ 98 $ 86 Analyst Technician $ 60 Mileage Mileage will be billed at the 2017 IRS Standard Mileage Rate of $0.535 per mile. For the services performed related to the projects which are not listed herein, compensation shall be at the hourly rates set forth, together with reimbursement, at cost, for incidental expenses incurred in connection with such services, together with reimbursement for outside services at cost plus 15%. We have enjoyed working with the City in the past and look forward to continuing our long-standing relationship. If you have any questions regarding our proposal, or if additional information is needed, please contact our office at (951) 520-3331, Sincerely, Shane Spicer cc: Matt Woods, City of Lake Elsinore Melissa Bellitire, Spicer Consulting Group