The URL can be used to link to this page

Home My WebLink About0323.094.: , ! l j I • ~. '" ' . . , . ,,,~- June 16, 1994 TilE IIONORABLE CITY COUNCIL Palo Alto, California 4 Conf.Julting,..-Servige Contract for Applks!.t.iQIL_P~~.19~;I.9~ ililQ9.rSWhic Infol'mation Sy.§.tQm Members of the Council ~ This report requests t.hat Council approve ~nd allthorize the Mayor to execute the attached Amendment No. 2 to Contl.-act S3036240 ",oiith Geodesy a general partnership for software application development associated with the Geographic Information SYHtem (GIS). The contract \'1il1 be in the amcunt of $56 1 250.00 -and the funds are included in the FY 1994-95 Utilities Operating Budget. Thia is one of three separate contracts requested fm: the continuing implementation of the GIS. Background The Geographic Xnfol.'1rlation System (OrS) was originally {o!pproved in August 1989. Thie project is a joint effort of the Utilitiea, Public Works, and Planning Oepartments. A coutl."act [or a City wide basemap was awarded in April 1993. Application development will ea('le end user interaction with the GIS System by doveloping a menu-driven access to frequently used functions. This will reduce the amount of training required to use the GIS System. Charles Eitzel, a partner of Geodesy, has been closely involved with ,the City from the initial benchmark testing with McDonnell Douglas to hi.s current contract for application d.evelopment and CMR:323:94 databas~ design. under'standing of source contract. It ia because of Mr. Eitzel'B unique the City's cUstomi2ed GIS that this is a sole Environmental Irnp~a8seBBment The Council' finds that this is not a project under the California Environmental Ouality Act and, therefore, no envixonmental impact assessment is necessary. ~..Qffime ndal: ion Staff recommends that Councii approve and authorize the r.'ayor to execute the attached GIS application development Amendment No. 2 to Contract S3036240 with Geodesy in the amount of $56.250.00. Respectfully submitted, &i (l '-.. ~-C::.~ GL NN E. LOO, Superv i80r Ut litie~8 Computer Services /~. BDW D J. MRI EK Dir ctor of Utili\ies ~1\\.~ BERNARD M. STROJNY Assistant City t-Ianager Attachmentr Amendment No.2 Exhibit A Exhibit B CMR,323:94 ~M2N'l' NO. 2 TO CONTAAC't NO. 83036240 IIBTHBBN CITY OF PALO At-TO AND GBODESY This Amendment No.2 to Contract No. S3036240 is Rlade and ~mtered into this day of June, 1994, by and between the City of Pah, lllto~ a chUtered city and a rr.unicipal corporation of the ptate of California 'IoCity") and Geodesy, a gener.al partnership 1Taxpayer's Identification No. 94-3191197' (r!GeodesY"l. RBCITALSI WHEREAS, City and Charles Bltzel entered into Contract No. 83036240. dated October 9, 1992, PAgreert'lent") for certain application software development services associated with the euppor;t of City's Geographic Information System and its conversion (rOIS')i and ~EREAS. City and Geodesy. of which Charles Ritzel is a partnor, desire to modify their contt"act to reflect a new 8cope of services, a modified compensation schemer and a term of services; NOW, THBREFORE, in consideration of the following terms, cOlld1tion9~ and covenants, the parties agree a~ follows! SBcrIUtL . .l. Section 3.1 of the Agn·.~ment is hereby {Utlended to read in accordance with the termB of new Hxhibit A, attached her~to and incorporated herein by this reference. ~Z. Section 4 of the Agreement is hereby amended in its ~ntirety to read as follows: -For t.he full performance of the services described herein by CONTRACTOR, CITY shall pay CO~~CTOR a total sum not to exceed fifty~six thousand two hundred fifty dollat"a ($56,250), payable at the :rate of seventy~five dollars ($75) per hour, upon submission by CONTRACTOR of its itemized billings, in triplicate, in accordance with the terms of the new Fee Schedule, attached hereto as Bxhibit 'B' and incorporated herein by this reference,. SECTION 3. Section 6 of the Ayreem~nt is hereby anlCnded in its entirety to read as followB: 'The services to be COnlnence on October 9, 1992, shall be extended from June performed hereunder shall and the time for perfol1"M.nce 30, 1994 to June 30, 1.995. n ~~..tQtLA. All othel." provisions of t,he Agreement not amended herein by this Amendment No.2 t.o Agreement shall remain in full force and effect. 1 ~IO 1)'11 (X)]rO.ws .. ",' Clara, EXECUTED BY THE PARTIBS in Palo Alto, County of Sa~ta California on the date fit:st above stated. A'l'l'BST, city Clerl< APPRoveD I\S 1'0 FORM, SenfO"--ASBt. cIty Attorney APPl\OIll1D, CITY OF PALO ALTO 2 .' ", ,e" CERTIFICATE OF ~CKNOWLEDGMENT ICivil Code S 1189) ST~TS OF _ Cl!tU.(-'(,Ut< COUNTY OF _iJJ~_i'hJ/L_ Wr~fNESS my hand and official seal. 3 · .. EXHIBIT A Aplil 27, 1994 Priority 1 Landmark GIS Conversion SeIVlce Support Task 1,1 QC application Addition of functionality (e.g. checking attriblJles to see thaI thay exist in the feature class's scl1ema) to the exlsUng Quality Conllol applicalion. 60 hrs. T .. k 1,2 Conventions Develop the conventions for the COAX communications system. Int~rate upda16s from landmark which occur during the COUTS 9 of the conversion project. 1611rs. Task 1,3 Support file. Complete the symbol libral)' for 111_ el.c~iCJI subi_ds. lJp<lale lI1e Ilbral)' as needed to reflect al!erations in the graphic slandards h, response 10 user criticism. 2011rs. Task 1.4 Publish approvad conventions Pubtish the PAGIS standards manual at version 1.0 (epprov2d). Update a~1 or the standards manuals on the distribution list 10 ~,rs. Task 1,5 Project """'lings Attond thi) monthiy project sta!l!S meetings. 24 hrs. Priority 2 CPA Start Skill Development Task 2.1 GIS dala malnlenance Work with the drafting technicians to support their d{sfting and development efforts for the marnlenanca or the GIS data. Devefop proce<tures Yli'th the lachnk:ians (or lI1e inlegration of proied work into lIle GIS. eo hIS. Task 2.2 User group meetlngs Propare for and attend the monthly user group meetings. 24 hrs. Task 2.3 rechnlclan training and support Continue the education of the drafting technidans in the use of GDS for drafting and GIS. Inlrod"ce RDBMS technology to Ihe staff. 60 hrs. I"~, ",,--, .. ApnI27~,1~9~9~~ ______ \:~._· ____ , ________ " _______________________ ~P~.~g~.~2 Priority 3 ROBMS Extensions to the Data Model Tux 3.1 Table design DesIgn the: en~ty fenture class aHtibule lables. This is an extension 10 the data modeling wor!: which has been completed. 50 hrs. T .. k 3.2 Databasa construction Build and document the tables and fl"ldexes as designed in Task 1. 30 hrs. . T •• k 3.3 Import dab rrom GDS Develop lIle program(s) to 'oon the GDS dalabase and transfer the attribute data stored the,e to lIle R DBMS attribule lables. 60 hrs. Task 3.4 Fom) access to data Develop data entry/updato forms to provide user access to the ROBMS based elata. 120 hr •. Ta.k 3.5 SQl'CAD links Build tho mapping table. requireo 10 link the GDS dala 10 the RDBMS attribule tabla •. 20 hrs. PriOrity 4 Software Set-up Task 4.1 Orac i. Unk Oracle wilh GDS and documenllhe connection. 20 hrs. Task 4.2 Pel-Imaging link PCI willl GDS. rest Imago file lormal •. 16 hrs. Task 4.3 Application Builder Set·up the data dictionary .and populate it With several test feature classes. Bljild a menu launch point for the Application Builder into the existing PAGIS menu sys!em. 20 hr •. ..\ . , Apfi127. lS91 '-'-Page 3 Priority 6 Address Support Task 5.1 Str •• t name reconciliation Reoooole the exi"Ung street name ~Sl Yl'ith the Tree Jnven~ory and Utility Billing dalab<l..... P\Jl>lish lIle ,esullS. 20M. oalaba •• design Oe:\lgn the ad<ll ... lables. 25 lifo. rook 6.3 OaJabase construction BtID<i PM document the lablf3s and ind&)(es as deslgned in Task 2. 15M. Task 5.4 o.,t8 entry automatiol'l l)e.V&!op appfK'.ation support for the entry of tt)e .a<1dresses into the GiS and p.&rformlnij t.~e establishm&nt of the keys to link the spatial and tabular data. 60 hrs. Exhlbil e err c;;; o~~ ,cc"i"'-""~~ I • to f~--~~ .. ~J,~~:;;J""'.. ~~i-~~~.·~ ·~ .. j~~ .. ~~ ....•.•• ~~~ •• · .. ~2.··o.1 I~ ()~"'I>'IY ;';'~1Oo;; .....•.. ~.... ..... . ~~ I~·····~·· .. ~. ~ .. -~~lUl ISUIfI I I ' ..."6< 100 ,. I Poge 1