The URL can be used to link to this page

Home My WebLink About2011-05-10; City Council; 20537; ADMENDMENT QUARTIC SOLUTIONS LLCCITY OF CARLSBAD - AGENDA BILL AB# 20,537 MTG. 5/10/11 DEPT. TRAN APPROVAL OF AMENDMENT NO. 1 WITH QUARTIC SOLUTIONS, LLC FOR ASSET INVENTORY ENTERPRISE GEODATABASE SERVICES DEPT. DIRECTOR x?j> CITY ATTORNEY y_tf CITY MANAGER ^ — RECOMMENDED ACTION: Adopt Resolution No. 2011-087 approving Amendment No. 1 to the professional services agreement with Quartic Solutions, LLC for Asset Inventory Enterprise Geodatabase Services. ITEM EXPLANATION: The City of Carlsbad utilizes an asset inventory to facilitate the efficient management of the various assets it owns, maintains and operates. The structure of the database associated with this inventory has been updated to improve the quality of the data and the ability to share the data with users throughout the City. This new structure is referred to as the Enterprise Geodatabase. The Enterprise Geodatabase will also enable the City to use more efficient data entry tools and to take advantage of current and future innovations in the asset inventory and asset management industry. The current contract with Quartic Solutions includes loading data into the Enterprise Geodatabase for the utilities and transportation assets. In addition, the current contract includes the creation of a set of data entry tools to maximize the efficiency and accuracy of the data entry related to sewer, water, recycled water and storm drain utility assets. The proposed contract amendment would expand the scope of services to include the creation of data entry tools for transportation assets which will maximize the efficiency and accuracy of the data entry related to transportation assets. ENVIRONMENTAL IMPACT: The proposed approval of a contract amendment does not qualify as a "project" under the California Environmental Quality Act (CEQA) per State CEQA Guidelines Section 15378, as it does not result in a direct or reasonable foreseeable indirect physical change in the environment. FISCAL IMPACT: The initial contract was funded using monies from the Inventory/Facility Maintenance Program project (Project No. 3634) and operating budget funds from the Utilities and Transportation Departments. The additional $22,680 cost associated with proposed Amendment No. 1 will be funded with the remainder of the unspent funds in the Inventory/Facility Maintenance Program project and Transportation Department operating budget funds. DEPARTMENT CONTACT: Marshall Plantz, (760) 602-2766, marshall.plantz@carlsbadca.gov FOR CITY CLERKS USE ONLY COUNCIL ACTION: APPROVED DENIED CONTINUED WITHDRAWN AMENDED 4- D D D CONTINUED TO DATE SPECIFIC CONTINUED TO DATE UNKNOWN RETURNED TO STAFF OTHER -SEE MINUTES n nn n Page 2 Contract Funding Summary Initial Contract Inventory/Facility Maintenance Program (Project No. 3634) Utilities Department operating budget Transportation Department operating budget Initial Contract total Amendment No. 1 Unspent appropriated funds from Project No. 3634 Transportation Department operating budget Amendment No. 1 total Contract Total with Amendment No. 1 $8,280 $44,460 $44,460 $97,200 $5,000 $17,680 $22,680 $119,880 EXHIBITS: 1. Resolution No. 2011-087 approving Amendment No. 1 to the professional services agreement with Quartic Solutions, LLC for Asset Inventory Enterprise Geodatabase Services. 2. Amendment No. 1 to Agreement for Asset Inventory Enterprise Geodatabase Services (Quartic Solutions, LLC). 1 RESOLUTION NO. 2011 -087 2 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF 3 CARLSBAD, CALIFORNIA, APPROVING AMENDMENT NO. 1 TO THE PROFESSIONAL SERVICES AGREEMENT WITH QUARTIC 4 SOLUTIONS FOR ASSET INVENTORY ENTERPRISE GEODATABASE SERVICES. 5 " 5 WHEREAS, the City Council of the City of Carlsbad, California, has determined it necessary and in the public interest to approve Amendment No. 1 to the agreement with Quartic Solutions,LLC for Asset Inventory Enterprise Geodatabase Services; and 8 WHEREAS, On February 8, 2010, the City entered into an agreement with Quartic Solutions, 9 LLC, in the amount of $97,200 to provide Asset Inventory Enterprise Geodatabase services; and 10 WHEREAS, City staff and Quartic Solutions, LLC have negotiated fees in an amount not-to- exceed $22,680 to provide additional services, as described in this Amendment No. 1 to professional 12 services agreement; and 13 WHEREAS, sufficient funds are available in the Inventory/Facility Maintenance Program, (Project No. 3634) and the Transportation Department operating budget; NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Carlsbad, 15 California, as follows: 16 1. That the above recitations are true and correct. 17 2. That Amendment No. 1 to Agreement with Quartic Solutions, LLC in an amount not- 18 to-exceed $22,680 to provide Asset Inventory and Enterprise Geodatabase service is approved and the Mayor is hereby authorized and directed to execute said amendment. 20 /// 21 /// 22 /// 23 /// 24 /// 25 /// 26 /// 27 /// 28 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 PASSED, APPROVED AND ADOPTED at a Regular Meeting of the City Council of the City of Carlsbad on the 10th day of May 2011, by the following vote to wit: AYES: Council Members Hall, Kulchin, Blackburn, Douglas, Packard. NOES: None. ABSENT: None. (SEAL) .\\UIHl;,- £ * *-. - *.. . " PWENG748 AMENDMENT NO. 1 TO AGREEMENT FOR ASSET INVENTORY ENTERPRISE GEODATABASE SERVICES (QUARTIC SOLUTIONS, LLC) Thihis Amendment No. 1 is entered into and effective as of the _ day of , 2011, amending the agreement dated February 8, 2010 (the by and between the City of Carlsbad, a municipal corporation, ("City"), and Quartic Solutions, LLC, a California Limited Liability Company, ("Contractor") (collectively, the "Parties") for geodatabase services. RECITALS A. The Parties desire to alter the Agreement's scope of work to include the development of Data Entry Tools for the transportation asset inventory data set; and B. The Parties have negotiated and agreed to a supplemental scope of work and fee schedule, which is attached to and incorporated by this reference as Exhibit "A", Scope of Services and Fee. NOW, THEREFORE, in consideration of these recitals and the mutual covenants contained herein, City and Contractor agree as follows: 1. In addition to those services contained in the Agreement, as may have been amended from time to time, Contractor will provide those services described in Exhibit "A". 2. City will pay Contractor for all work associated with those services described in Exhibit "A" on a time and materials basis not-to-exceed twenty two thousand six hundred eighty dollars ($22,680). Contractor will provide City, on a monthly basis, copies of invoices sufficiently detailed to include hours performed, hourly rates, and related activities and costs for approval by City. 3. Contractor will complete all work described in Exhibit "A" by February 8, 2012. 4. All other provisions of the Agreement, as may have been amended from time to time, will remain in full force and effect. 5. All requisite insurance policies to be maintained by Contractor pursuant to the Agreement, as may have been amended from time to time, will include coverage for this Amendment. City Attorney Approved Version 09.22.10 6. The individuals executing this Amendment and the instruments referenced in it on behalf of Contractor each represent and warrant that they have the legal power, right and actual authority to bind Contractor to the terms and conditions of this Amendment. CONTRACTOR QUARTIC SOLUTIONS, LLC, a California Limited Liability Company *By: 17 CITY OF CARLSBAD, a municipal corporation of the State of California By: ign here) (print name/title) ATTEST: "By: (sign here) L Citv Clerk r(print name/title) If required by City, proper notarial acknowledgment of execution by contractor must be attached. If a Corporation, Agreement must be signed by one corporate officer from each of the following two groups. *Group A. Chairman, President, or Vice-President "Group B. Secretary, Assistant Secretary, CFO or Assistant Treasurer Otherwise, the corporation must attach a resolution certified by the secretary or assistant secretary under corporate seal empowering the officer(s) signing to bind the corporation. APPROVED AS TO FORM: RONALD R. BALL, City Attorney By:. DeputyCity Attorney - \ City Attorney Approved Version 09.22.10 % Quartic^SOLUTIONS LLC Exhibit "A" 1380 Garnet Ave. sE-402. San Diego. CA 92109 Tel: 619.602 7606 • Fax: 858.272.3491 March 20, 2011 Marshall Plantz Sr. Civil Engineer City of Carlsbad 1635 Faraday Ave. Carlsbad, CA 92008 Reference: Proposal for GIS Consultant Services Traffic Data Entry Tools Dear Mr. Plantz: Quartic Solutions LLC proposes to provide professional GIS services in order to create GIS data entry tools needed for the City's Traffic data maintenance process. Quartic has come to know Carlsbad's GIS data well, and as an ESRI Business Partner, is well qualified and uniquely suited to perform this work. Quartic will create the currently identified ESRI featureclass extensions and data entry forms for the traffic related GIS layers. The forms will be tested completely by Quartic and City staff and rolled out in coordination with the traffic GIS data load. This estimate is based on the following assumptions: • The test environment (servers, database etc.) are identified and available • Any data cleanup and quality control reviews by are done in a thorough and timely manner • Other dependent applications (Hansen, mapbooks, online maps, reporting etc.) can be updated and rolled out separately • The changes to the data editing environment will be coordinated with the data loading. • Upon rollout of data entry forms, Carlsbad GIS staff will take over maintenance Below is a table which outlines the main tasks and scope of work. We propose to begin the project on 04/01/2011: www quarticsolutions.com GiS Consulting >) Data Entry Tools Data Entry and Hansen Required Trigger Functions: Design Primary fields Primary Related Fields (Pole, luminar, or sign) Overlay fields (including SupportID, ConnectToFrom) 'Select Fields' (Sign StreetName population only) Foreign key inserts and updates SignText LUT population Forms (Sign,light,Pole,Barrier,Sidewalk @8 hrs each) Extensions (9 layers@2 hrs each) Assist with Traffic .mxd symbology and setup table joins TestPlan, QA and bug fixing Roll-out, documentation, turn-over and acceatance SubTotal ($90/hr) 12 10 16 16 1 40 4 40 18 12 60 24 253 $22,680 If you have any questions about the tasks, estimate, or duration please do not hesitate to contact me directly. Luostarinen CEO Quartic Solutions %Quartlc~S;-)v!yT'C>*S iH' 2 I '>' .1 t;