Loading...
88-383 WNITE - C�TV CLERK � PINK - FINANGE GITY OF SAINT PAUL Council ///yyy CANARY - DEPARTMENT /F' ��� BLUE - MAVOR File NO• �v �r - Counci Resolution q , Presente By Referred To � L e' Committee: Date �""�� � o� Out of Committee By Date Whereas, the Mayor pursuant to Section 10.07.1 of the Chaxter of the City of St. Paul, does certify that there are available for appropr'ation total revenues in excess of those estimated in �he 1987 budget and � Whereas, Council File 277510, adopted Oct. , 1981 did establish certain Special Fund Policies, �and Whereas, The Mayor recommends that the foll 'ng additions be made to the 19$8 budget: Financing Plan Current Change Revised Bud�et Budge� 205 P.W. Engineering 00000 9910 Unres. Retained Earnings 0.00 80,950.00 80,950.00 12000 �+301 Normal Activity Serv. 122,098.00 0.00 122,098.00 �z-lo2 7399 Transfers In 327,000.00 0.00 327 000.0� 9,09 .00 0,950.00 530, .00 Spending Plan 205 P.W. Engineering 12102 0856 Computer Software 5,000.00 60.000.00 65,000.00 12102 085'( Computer Hardware 6�+,600.00 20,950.00 85,550.00 All Other Codes The Same 379,�+98.00 0.00 379 498.00 9,09 .00 0,�`950.00 530 0 .00 Now, therefore, be it Resolved, That the Ci y Council adopts the above additions for the 1988 budget. . , � , Finance D' ector � � Budg t Director 1�— u- COUNCIL MEMBERS Requested by Department of: Yeas Nays Dimond Public Works-Computer Servicea--Dennis Grittner i.ong _� [n Favo Goswitz `���-�� Scheibel � _ Against BY �' Sonnen Donald E. Nygaard, tor Wilson ��p 1-IhU� � 7 � Form Approv d by i A rney Adopted by Council: Date Certified Pass b ou�Se ta BY gy. Appro 1�avor: Dat� � ���Ht� 2 � Approved M or ission to Council ` B B P��,.,�,�y� -. �� i98 �_:,:�pc� .�_ ,d �:� r " �o fl !� �:.3�''-� �,,,�.�ti, �►n� �, a► Q ��_� ` � GRE�N � No:00`E�509 5 ►���►��, ; _ - ' wBS�oN � a 'j cm c►�c � ;.:. �c�- �'CHl�I�-FI�CE Ct�I 2. O�' � QfF�'ATiOW1EY � Wiii VVWli1t� - 1A�3�l�B� IP����V1AVSi�i<# iA�lil�����VVA1 �l � �Wl7l0�W.rVn�-ACi� ��VC�� iMLiLi�� � . - . � ���'�r11S�bi7117 � � . . � . .. � . . . . 1�Ob1�lO�R1fON$:(APPtove UN 01 R�jeCt(A)1 COUtiqL N REPOR't: � . . . . fl11MHq CO�MBa10N CML BEHVICE OOMMt8S10N DATE IN� . .DATE OUT ._ MW.YBT - � ' PFI�IE N0. . � ZOf�M10 OO�BBIp�i . � .�828�FEQOL BOARD � � . . . � . . . . ...A� Si'APF . . t�1+1RTER COhMM3010N � . .A6 13� _ -ADDL MIFO.A�D* ._�Aop'L�.'� _f�6 pC�AODED* �.. D161PoCT OOUNCL � . . •E%PU1NA . � � . . � - � � � . . � &IPPOIf18 MMICM COUWGI OBJECi1VE2 .. : . � . . .. . � � . " . . . . . . .�. �. . - . . . . . : � :- . . . � . - . : . ..�.� � DO ltAIliTffi�Ai�E ItARAa�EI9T IN . �ic�.�iilrD :� � . P[1B?rIC WOItSS`t1��liG TH�.�RA- .,,�` s�vcs� n�►�s� F E B �l 1 1�88�x . . , �IAA�YOR'S O��ICE :,-� �►�a wio�t.�,,�.ovv�onn�wrrr tu+a�o.w►�a,v+n,sn.wi+�s:wnri: � (ss� �rc� A) ,� . , 19�' �ra� �r: � a�.r�D To �s� s�xn� �►v�o�r iroa �c � . cc�r��x :��vt�s: �nqzcAL a�am ��c�r �s � is�a �tn pAS(crrY cc��,2a�r) �n� � n� oF Ac�rric� To i988. - �cr►,�o���•�.�•,��..,w«dat: , t� � B� B `. F[�1)B FHt� 198�=C��TLll AOT BI� tTS�D UNT3L TRl1�I�/S A�D T�CAL � � : C�. O�IIi�Y�B�(IM�t:Vbwn:.rw so vN,on+): .. . ' : • , - , , F� so �ov�,��s� wovLn x�nT n� ��r oF �Lre � c� • s�c� � ���r �'s ��a � ��oR oa�c�rzvE �oa i�8. - _. , , ; ., ,, ,..` _. . _ . _. . _ <<, . ��►�: . � _ noae . i 1NTOIl�AM�fii: _ �JA ��: H�A ` - �. � � ^ , • /'/✓��2�� i� , �� ev -�� Co puter Services A�NC WWC 0 � 700 ity Hall Annex 92-6009 Denn Grittner,298-4402 To: All Interested persons February 8, 1988 From: Dennis Grittner Public Works Computer Servic s Manager Subj: Request for increase in spendi g authority in budget 12102 Att: Fund balances for 12102 and 1 103 as of the end of 1987 Copies of transfer authorization for funds to 12102 January 26th letter of G. Hubler of PAS to Gene Schiller and Donald Nygaard Explanation of need for s ending authority increase for 12102 History Public Works Computer Services ( PW S ) determined that it's existing Britton-Lee Database Computer had significant soft are and hardware reliability problems and that alternatives should be explored before ntinuing the use of the Britton-Lee. PWCS conducted a review of all the available tabase products and decided to compare in depth three alternative solutions. PWC negotiated with vendors for temporary licenses for Oracle and for Sybase and negotiate some different hardware configurations to test from Britton-Lee. PWCS staff worke many long, hard hours and presented their findings to Public Works Management a d to ISPAG ( Informati0n Systems Policy Advisory Group ). The unanimous concl sion of PWCS staff was to acquire Sybase based on better quality and higher perf rmance as well as better support. Dennis Grittner presented the financing eeds for this acquisition to the fund managers in Public Works who provide the funding for PWCS. They agreed to supply$60,000 in additional funding for 1987 ( with conting nt management reporting ) in order to acquire Sybase. Director ponald Nygaar requested that Gene Schiller, Director of Finance and Management Services, app ove the department's request to acquire Sybase. At the same time, Computer Se ices entered requisitions for additional main memory and disk space to allow for the limination of the Britton-Lee and the move of all it's programming and information to th Pyramid. These requisitions were put on hold by CIS Manager Greg Haupt to awa t the outcome of Mr Schiller's decision. Gene Schiller retained the City's existing onsultant, PAS, to examine the study conducted by PWCS of databases and t make a recommendation based on the status of the database industry and the nature o Public Works needs. This PAS study was presented to ISPAG in January of this ye r and concluded that Sybase best met "the department's needs". . , . ����.�� �- . • Spending Authority Increase for 1210 Page 2 Matters of parallel interest during the st few months included: Britton-Lee announced that their found rs, Geoff Lee and Dave Britton, had resigned from their Board and that Britton-Lee ould be losing approximately $10 million for 1987 and they would be reducing their staff by 20% immediately. This gave some official status to the problems that we ad been noticing. Microsoft and Ashton-Tate announced hey would be jointly developing a product for the new PC operating system, OS/2, c Iled SQL Server that was based on software developed by Sybase. Two of the top s ftware companies in the computer industry essentially agreed with the decision of WCS concerning Sybase. ummary Public Works Computer Services had f nding to acquire Sybase in 1987 and was delayed from doing so to provide adeq ate administrative review. Attached documents show the fund balance of 12102 and 1 103 ( Infrastructure Inventory ) at the end of 1987. Attached documents also show t e fund managers approval for the transfer of an additional $60,000 to 12102 of 1987 fu ds. PAS has recommended that Public Wo ks proceed with the acquisition of all the requested hardware and software in qu stion. The Council Resolution merely enables Public Works Computer Services to us the 1987 funds that were not able to be spent due to the necessity of administrative r view. I am quite proud of the excellent work d ne by my staff in our review and evaluation of databases. If anyone is interested in thi information, please contact me and I'll be happy to provide you with it. I do not inc ude it with this request since it is somewhat long and fairly technical. We are availa le to present the findings of our study before any interested City group as we did bef re Public Works Management and ISPAG. c�: �/�u� �, . • �2'�I*'iL-� �� �,�.� 1 ),�S�&cr � � � ��'-��.� M E M 0 R A N D U M T0: MR. DONALD NYGAARb � Director of Pu�?ic Works MR. EUGENE SCHILLER Director of Finance & Ma agement Services FROM: GEORGE HUBLER, Principal Associate � � Public Administration Se vice (FAS} �' DATE: January 26, 1988 SUBJECT: Update on the Selection f Database Tfanag�ment System (D�3MS) for the City's Depa tment of Public Worke 1. Reference Reference is made to the PAS R port of January 1988, sub�ect as above.This report outlined a n ed for additional data to properly "size" the DBMS. 2. Discussion Prior to meeting with the City s Information Systems Policy Advisory Group (ISPAG) on January 26, 1 88, PAS met with, and obtained from, Public Works computer services personnel addi.tional quanttfication and documentation regarding requir ment� for a d9ta base managemen[ system to support the City's infrastr cture mana�ement applicati.ons. The hard copy data provided by Pub ic WorkG is attached. Essentially, the data provided and the subsequent discussions focused on the difficulty of getting s ecific information on eventual infrastructure DBMS requiremen s. Data- needed (as outlined in t.he reference) and 'estimates' of izin�; pr�v�deci can be suntmarized as Eollows: o Infrastructure size in me abytes Currently 89 MT3 with 43 relations and 240 discrete fields Size in 3 to 4 years could exceed a �;igabyte. o Transactions entry and ma ntenance levels per day up to 100 per person. o Number o� reports, size :L pages, fzequency, features, etc• Up to 80 "central re orts annually (40,000 pages). , o Security needed. Down Co data element level met by Sybase and Public Works procedures. o Elements to be shared cit ide have not been defined. , • . C�� " �� � -2- o Number of prograrna neede and px�g:.F:r.tnE.r hours Patimated. Ten ma�or applicati n systems. No estimate on number of programs or hours o l�rogrammir.g needed. � o Type of program� needed Not answered. o Processing power speed n �eded to develop and mai.ntain database Up to Pyramid 9820 evel or 8 times current power. The data provided was useful, but sketchy, and leads to the question oF whether the infrastructure management appllcat�ons should be planned in more detail prior o moving ferward. It is PAS optnion that this planning can (and must b ) carried out concurrent with acqui.ring Sybase as is pointed out in p ragraph 4. 3. Conclusion as relates to DBMS , Our reviews have concluded th t Sybase is the appropriate DBMS to support the infrastructure ma agement applicatioris shuuld the City decide to continue with the i irastructur.e effort and we recommend that Sybase be acquired along with the fo'11�7wing supporting, requested system enhancementa: Software a.Dataserver $30 000 (Pyramid license) b.Dataworkbench $11 250 �;Pyramid license) c.App.Forms $ 4 800 (Pyramid license) . d.Formslibrary(c) $ 2 400 �Pyramid license) e.dblibrary $ 2 400 (Pyramid license) f.thru e for Sun $ 3 200 (Sun 3/52 license) g.Pyramid microcode $ 6 000 (from Pyramid-optimizes Sybasr or. Pyramid) Software Total (approxim te) $60 u�0 � Hardware a.474 megabyte fu�i (unf. rmatte3) (est. $5,C�00 3rd party) b.integrate and test for. maintenance (est. $2,000) on item a. c.ad�litional 4 MB memory (est.$10,000) (total would be 12 MB) Hardware Total (approxirn te) $17,000 Approximate Grand Total oct $77,050 , . � � ���� -3- 4. Planning of Infrastructure M agement PAS recommends that concurre t with the acquisition of Sybase and the necessary enhancement of the supporting computer system, a determined effort be made to devise a d tailed plan for the further developmenC of the infrastructure manage ent application. This plan should be finalized in the form of a p rformance contract between (and agreed upon by) the Director of Pub ic Works and the Director of Finance and Management Services. We woul suggest that this performance contract/plan be drafted by e Director of Public Works and/or his designee and include: o Prioritization of applic tion systems making up the overall infrastructure applications. o A functional requirements statement as is shown in the PAS Phase I Report for all compon t application systems. This should include a11 planned syst ms enhancements. - o A syetems design for the application system(s) that is to be undertaken first. o Milestones for completio of the priority application systems. o Periodic reviews (monthl ) by the Director of Public Works, or his designee, on progres toward milestones. o Information reportR by t e Director of Public Works to the Director of Finance .�nd anagement Services and other members of the Cabinet on progress toward application system completion, with information copies o the ISPAG. (This is due to the Citywide impact of the i fzastructure application.) o Assessment of the real n. ed to share the infrastructure data with other City departments a d a plan to do so. o Periormance reporting on the Pyramid so that timely predictions can be made regarding ne d for systems enhancements. o A detailed review at the end of one year by PAS on specific accomplishments related oward bringing on line infrastructure applications. o A decision by management: (the Director of Public Works and the Director of Finance and anagement Services) at the end of one year whether progress me its continuance of the computerized infrastructure managemen applications. Please be advised that PAS will b happy to provide assistance to qou in . setting up the previously mention d performance contract/plan and in furnishing guidance on project ma agement/control systems that are appropriate for complex pro�ects uch as the infrastructure applications. , • ,�—= ' . � , , . y� `.:: � � � o 0 0 0 0 0 �. � o 0 0 0 0 0 o � co a� o 0 0 � �e � �i' � ('7 N C'') C7 3 C� r (+� N M (� � r N N H�? Cp Z H�} E,9 (� f!T �,_"..... 4. R � � � � � � � � � Q � � Q � � � � � �y„ � � O N O I� �r � N 69 CO 0\O H�} 69 69 6F} N �. ` T � O O O � O L1� Cfl I� C'') O �t N � M O W � N c� c� O O T N O O O O O � O O O O O N � O O O O O � '- � �-'' O O C'7 O M � 0 ll') O T N T � F- .- N N d4 t0 C <f3 6F} ff3 b9 c� L U � o 0 0 ° o ao � 000 � o 0 0 0 0 0 V T ooao c�i N l� c0 � N r d4 69 (f} N � O O O O O N O O O O O O O O O O � O �Oa. � O O � T O V T LN^ T �M N T r T VT `.' -. T E� d4 E!? F�3 � C"' r-, 'D ' � C _ � _ V C U LL 7 (� > O C V � c� Q � � � C� C i � C •Ry � C � (� � � � � � � .r L � � V � C � � LL' � 3 •— •� � � C � Cn Cn W W F- � O r N M � r N C7 tt �A �D f� CO � r �- r � r ' . . (�-0 0 '•-�O� 'O�? . � ' . ' s,. � �.. � �� Y r 5A 1 iV'i" PAUL � 1 "' t�,—aS:� �. x�: � (NTER-DEP TMENTAL {NVOIGE PAGE 7 " z . �; '" �k i. � a?` � f-�, ��,'����s. � ; yit�::�� � � �•�, � .. S �; �. , �� c ;; .. s.� f , >. , -.•.�r. `�':. =s�: � a t �,s r� � ..a�«, �k � -��+ ��i�: � <i' .�, - . �;+fiy,.' wctx� «' . .-�� �ai r � �. '. � �" � � ' _.. .� "Y-: -. .� ,�. ..- er m ���'i' �� sa ��.�_°'.'. ,1�; �'�`.»s1.. .� :..- - i"5�,,.- :.� . . . .�.�' . -.;�. -ti= - - .�e � - .. ,-s. - ; s ,..� . ha�1�M, k q�' x a. ,"z ...�LAm'°a' �....., r. .�:. . . .. .:.: . a ...�«.�... ..r,. • �r,r�v GAT� : ���-��-P� ,.� 1.'.""�iJ E C) t3 Y : � C7;PT; `��:R'i ��F C�l1RL li: '�,'�RK� c� iv : ���+� icina�. �NGIN��i: ING ���t�ED TO: D�P'1': DEP7 �F PUE1L 1 C WOF2KS DIV: DIVISICIN OF STf2cETf..' AP�I�OVED: �f'�] (/ ' DUE-TU/ VE-i'ROM? t+l� �EVERS�,C7: , I..�?���� �csccm�ts�a� xsc ]f Cs7C_.. 3�mti3ft���s:J fe�m¢aai��ACa�a��xtmss7am�a�:tra:aas��mmmismr�mn,-csr...-«�em ACC4UNTS T� E3E Ct-IARGED i L�R�# !.ED�3�R �tGCOVN'i' F2EFERENCE AI�Vi�IT D 1 S6 CL �2S•-42340-053'7 � 1�7 ,00,� . v0 F-,C'1l�UN:-S GC. ^c'c'.."i--Cj:iC'OJ-�15�0 �'i�1 �t�Q(7 . 0� TGTAL � 231 ,C40 . 00 �tJ"f'?�lOFt i ZEi�fC�C�NTAGTc AL BHETKA - b�i7 �____._--LEC7GE�_____-- ^ACCOVIVT___.. ___---REFERENCE�______,_AUi�rUNT_~____,.____ , R�C� t P"i rL �0�-OOO�Q 'r90�b �`� ,AQQ . �O AGC4UNTw GL �05- 7 c^.i t�2w''T^f?9 i'��,Q�Q . 4� GL 205- 12 1{J`3-7;3f>9 45 ,OC?0. 00 'y _____..__.. _.._.� .�, TQTAL : 234 ,0�0 . QO AUTH+�R I ZERICUNTJ�CT= J!OYCE BI.UEL - 4 EO rs�srsr�a��::;�Smssr:�a�:rte�caraasssstR�fsscsaraa�a�caarfoccstaecescSa.¢azcazazaeo`arclss�msraaxr.ASa+aa�rercnaoas L�:�t�f� 1 ^7��f?�1 � TF�;:t1NyF EP, !V�QN 1 �:3 l'V CCNiPUI"�Ft at%f�tV 1��S & !��iFFiAST'riUC7VRE I t�fVENTQRY FrJF'i 1987 SPEhiD i Nr AIVrJ 19�+6 M41V i Eo SET UP A� Dl! F`RQM AT \r�l�R �NfJ i'a�Fa . �� . ��, ,/ � �, � r" — � G � ;1��� � f r.�a�-F_ -, ._c__1'_ r:F�,Yi�?Et•i"�' r,.;^S�f=r:�JF�� c3`` _.._.�' �_�..__—__._ _._.._...______.__._..._._ ._.. .. _ �, � ����� ' i 'L�2 :'- ' C.' i ?''� 'SA i NT PAUI 0�-24-$7 � 1NTER-DEPA TMENTAL tNVQICE pAaE • - 1- � 4'} c �,,� . ,.4 .,� `` r iy '* .�r ,�.Mi.. � ._ .f„*�c'i �.�,; +}�i �Y Z�`i.„(4 �.�a 1'yi J'�- �� 71 t�� 1,'�' Fa���d���£a'�T�'���°1��y 4 r � t ,�» . ��i.� �.�� *'# � ti '., Y„ �c�' � ?t^^ ._ <, +., w� m � � �� �l y j fd'�F ��� -�` �; R a�, � �, k ; ,T 3,��r �':;. a.. 2� °. , r.. ,.,.�,���1.�1, .�� q a (, �1�. �' _ � _ 1 '� ;:z r ;.i . . �> �;,� :.., .#'E. �_�. ,_ .. .a -y- - � - - � t , .,_ '., i .r r: t, 4Y yi,. AY ^.. �._ . . . .. ., �� .. . ; 1��.'. �: �.... � '��' 4'.� .f � �NTR1� DAT�. 08-21=87. :_.. _.. . . . ._ ., � - . . . _ , ,:..._ -� , _.. :. _�_ � i $SUED 8Y DEPT: DEPT OF PUB� IC Wt�RKS C� IV � MUNICiPAL ENGINEERING ISSUED TO: . D�PT� pEPT OF PUBLIG WORKS ' ' DIV: , DIVISION GF SEWER5 ' �APPROVED: NO DUE-TO/ VE-F�C1M? Nt7 REVERSED: '� s7�asntas�yaacFes�eaaa3m:ams=caaaaav�eessa sacsamseamseaatsa�mssmma�:a=ars�maosasssasxa'�ms�� � � AC�OUNTS TO B� GHARGED ` . � - � � 1 DR# ' ` ..' ; , . < LEDGER ` AGCOVNT REFERENGE � AMOUNT. i ' DISB �' G� ' _ 280-22200-0337 ' 223,000 . 00:` - AGGUUNTS GL 260-00000-9530 7�,OQA . 00 : ! ,. , . >_ : ,. <. . ,:. , ._. . TOTAI. : . 301 �0�0 00 : �. . � . . ,. „ : : ., , , ,; , .. AUTH4RIZER/CONTACT: ROY ,,$REDAHL - �. 38 : .. , ..; � �"'Y "� L.�LSGEFt .- - --`TACCpUNT r Y------REFEFENCE --- ----AMCQiJNT ,�. . , ,,REGE I PT _ GL,.. : ^�45-00000-�Q.46 - ?�3,0;00 . �0•, � A�COUNTS: -: GL, . 205-1210�-73�9 .- ' ' • :iC3 ,00Q.00- ' GL . Z05- 121U3-,2399 - 58,000� 40. . . ..., _ _ , TOTAL: 30.1 .400'�0p, �• AVTNOR t ZER/CONTACT: Jt7YCE. B�LUEL - 4 20 " �; � �t maamaxo.'�.aSEO,=S7LF3tiIraY�9SSS.0'lICC'1' ST.]Q9'3QC C�Q3"3=9fi1RfC4Sa19A"i C?0'SSd1LSC�fL'.a970tSii�22i�tOOS�lt,�Y�c . GESCRtPTfON : TRAN�FER I��rJh! I ES TO �OMPVTER SERV i CE�. & [NFRASTI'`,UCTtJRE I NVENTOFY FO 1�Q7 tiPEND!NG AND . 1�86 MON,IES .SET UP, AS D E FRC�M AT. YEAR '�END• 1�+B$ : � . . . � '� _ � ��R•-'�f�''="' '�`=.y� , , , r � � [ :i PAYMENT RPPFivVED 8Y: ______�_.__ _._.._.�__.__--- DA7E � ___._�____ _.. _, .. :. �_. �.�__ ..�.._ _. .� _ - ,...� - - � � � ��'��� � �. � ID2 . 2 , Gi7Y C SAINT PA�JL 8-21 -87 �,: • .',. : . .: . ,!�IT�R.^D�PA TMENTAL .I NYO I CE , . ` PAQE 1: ��,� 5 — �a ;,,•`t . r, t� � 5 � „� b'f' i:d'e"G'� r ?.t�r,Y.' ^Y :.�; x^',,�+ y�,i�... � �c7r .:i•., ; ,y._ �. J _ '�'� :x.�S �,•,`V " y�r'' '� �� �;� �.S .. "{�3., x f::. 3:'.::' .r , ���.,,,'-w'. ' .� . .�..�.�_ ..:.':• --y:-... ...� � .... - -� � ..,.. „ .. ��' . -..'.._; . , . ' - - - - . . - _,�.. ..._.� _.�_�.:,. . ....,.� ...: ,.,,. ,�:., ;_:.c K: ..4.:,� . .,.r..�'.� A1 , ���� �NTRY DATE 08-21 87 �� " -R;' _� ISSUEU BY : OEt�T: GEPT O� PUBLIC WORKS DlV : MUNICIPAL ENOINEERINp � 1S�UED T0: � DEPT.: .D�PT OF PV8L1C WORKS . . N. ��: . ... . , � . .� . . . � . . D I V': Q i V OF' EQU I PMENT 8ERV I GE • . _ . ' APPROVED,: 'lP1�G�/',�j`�� ' DVE-TO/ UE-FRdN17 Nd REVERSED: ' `��' �' - _ : ; � soaxsaxma�mziosr�snmmsasaat+sems�avms�a�asa�mat ss�ta�ramawaam=s��saesmmiartraesaes�o¢:=�os����mau��m0 - I AGCOUNTS TO BE CHAf2G�D ' •` ��, - , : i IDR# . ., L.E4t3.�R - AGC4UNT • � REFERENGE - AMOWNT :." . I ' � - - ,., - . ' GL . . ' 25Q-122Q2-.4537 . .. - 22,40Q.,,OO` `_ I :` D,ISB : f�GCOUNT� . ' '. ' : , � _ ;TOTA�., , �2L.'.00t2 Op ,� , .,. r - , AVTHt'JFt i ZEFfCONTA�T: -' RUN� MUNDAN4 -: 4 �-8348 , �'� ? "�`' --LEC�GER�` -_---- �ACCOUNT f�EF.�REN�E---- AMGIU�tT : . .._ RECE.I PT C3L, . ,, �(?5= 1210��-7399� .� 22�,QQp QO ..: ,i _ _ � ., , _ . . . ., �::: .... :- . � "'ACCOUNTS . ' � . _ .. , . . � -- TOTAI. . ' _ 2�'��Q4 .00 `AUTf-tCSR tZER/CONTACT: JOYCE BLVEL - 4 20 . . ; , � •�, � < _=sr.�saaasa:GsessFSasaacrs.siaaas�t-mrasaez�eas+a ass:�amsassotsstie�eaaxma�saasa�mnfeti�se:mamrsa�azarse,"st'. . DE.�''srR 1 PT 1�?N : 'TFtANBFEFt MGfV i ES TGti GCJMPUTEFi SERU 1 CES .& ; . 1NFRASTRUCTUR� INVENTORY FO 1�J8? SPENDING., _ , . , - , . .. , . . � . � ; � - , � . : _ � � ' _ ' , . � . t ' -.. '`F � : •� .. ♦ T � , . � . 'Z' Y : � � � . . .. �. . . � .. � ' . . - . . � � .. t_ v ' . �+f 4f.i:.S• '..-F ��� } i:.. '��: r PAYMENT APP�tOVED BY : ._._---__r__� ��,.____.__-._.-- UATE : .__.�._._� , � � �-�:��,� IG� . � CI �fY —� �AINT PAUL 48-21-87 �_ fNTER—DEP RTMENTAL INVOICE. PAGE 1� - y4a' L' . . .��, �f :�_� �:F1�'�n'�:..� b � � .� ' �. �. q#. � ,��.t?y, � z� ,_w � �� �' �i ?� ; c �, ' � , � , :. � ' f� f ' ��fi�� ; �i�t xL�± 'Y r+i i. � - � t �' �� � .q�� '�� `f5 ..S a '��} � ._,� [:+, ct. �.s��,�aFf- +..+4°'fiA'`.� `?��"'"��aA�f�v���'�.K 'Y�',�+�'���.'�_yl��y 1_'ri y, it. .- � � ��� ,4! � v .. ��{�iRx . �' ?+r. �e.� i����� 0�' � } h � f� .A�A � K.n. -w; ,t L,:. _ n„� iA }�.,.i t���.�_ . j:� ... �f. .. ' `g i'! a� �L :� _ ,w�''i 4�.,.a�`x -L v.i ... , ��. , 't b .. - :'. . �:; _ , .. r.r. .., z ��; _ . . ,. .. . ,�. . .... __' _ _. ". . . . . ,..-,_�' ,�x... ,... . y..�...-.,i.. .. .:,.. . . �.�.,.-T:" � .T' .�� , ....� . . ': � . . . .' . . .. . ," . . ENTRY DATE: OS-�1-87 ' ISSUED BY: OEPT : DEPT GF pUBLfC WORKS DIV : MUNICIPAL ENGINEERiNG � = I8SUED TO: - DEPT: LDEPT OF PUBLtC WORKS � . D(V: D•1 V I S I ON OF TFZRFF I C ; APPRQVED: NO - DVE-TO DUE-FR�M? NO REVERSED: vezassac�asa-.assat�sca�asstzsu-rmsnasxsraax=� ::�sYZmar_ssm�cseasas�sa�aa�smnsaas�xmasaaaansabat's ACCOUNT TO 6E CHARGED • 1OR# . LEDGER• ACC4VNT REFERENCE AMOt.1NT DI$B t3L � 001-02185-0537 1� ,00� . 40 . ':- ACCCII.)NTS' GL � 240- 1 c^OOt�+-t?S�7 i$ ,040 . 40 . ; '. , ' : � 33,000::b4 TOTAL : '•:AUTH�R I ZER%GONTAGT:,-: `DON 80BAN IA .- b 88 ''+.. . .' : _, : ` �-_--- --- --- - - --_-_-- -- __ ____�--------------------- - �- �:� �"%; ' ' � LEt�C.GEfi '. � _ +ACCOUNT~ . � REFERENIr'E AfWC�UNT�� � .,~ .,_ ,..: REG� 1.,PT - Gl, „�05,- 4210c .739f� _ 18,000 : 00 , . . ,. , - - _ . , _ . ACCAUNTS_ ,C3L .' : �05- 1�'103-7399 1� .O.00 .�OQ - TC�TAL : :;3 ,OQO .,Of3 `AUTHOR I ZER%C4KfTAC"I`: :' JOYGE BLVEL = 4 �A , r=oaesma=o¢.rssc�saa-m�e�mrzsassrraaa��ax�rra=aa= r_n�a=-aseazacc�=r_a�_scae�aavx;mmsmeraa�smaa�as� DE^GRtPTlUN : TAANBFEF'c MOIV 1 Eti TO COMP��TER SERV 1 CES �& lNFfiRSTRUCTURE INVENTOPtY FO 1�8? SPENCING . i ;, .: , , . � - � ; i , . . :,,: � ,, , � � - � . 1 ��� t � - � _ � � i � 1 PAYMENT AP�RC�VF_D E3Y : _____,__�__ ._.._...___�,_—_._ DATE ----------__._ � ' I i I � � i � ' j ' I �, ; ; i , . , , ; � � , � � � � � � � � ; ; i � , , ' ! 1 I ! � ' ; �'� ; i I � i i ; ,� � � � � � � � ��I, i � i I � � � ; ; i-- i � r � , i i � ' r � � ; � � 1 i � � n I 1 JY�N.f PO a0 1�O.�iaSlMOCp1OOO1� M O d .0 . O�OOO.T N � ..1 iV N 1 V� fl i 1 < 0p P .-i N O O Ml O.� fq v-�O O IA O O O P f� t/\ �p M ��; Q {fti O�p�M �O .� J Y� t!� � O {I � 1 � � • • • • . • • � � � • • � � • • � • � ��� � �. � • ;� • • � � r • � 1 � U I i �N.r p� O P W W O 1'1 N C O O O �D 1� N 1 O P P V 1 �P P ', r i O O N 1 n �O N N N N 1 M1 P 1 V O P .i�-f n. M1 fn O�O O P�-1 Vt v Y1 1�1 P OC �O .i �"1 1�.� tn�P m W O o0 P P t!� v1 1 '-1 11 I 1 <'p'i O�Ep O �t .-1 Y1.O M 1+1 P 00�-1 N 1+1 N P- Nl h 00 N O O i/�.i N 00 OD O O 1 N (1 � i . • . . . . . • • . . . � � i • � � • • . . � r . n � M N N�f 1` fN N e�/ 'i. �O�i Y1 i-t.: •t I 00 N N� oD H .-1 CO a4 1 P N I W j i � � � i .-1 e�i .i .i 1 M H ¢ i � � i 1 ! 1 q � W . . . , i . . � I . I � . , 1 p � ti� �. . . . � � 1 11 �. � � 1 tl I � I j ' I i n v O I ' i I i ' i N Z W ' � . ; � 1 �� ' � � �, � ry . W F- i � � 1 p � z< , ; � n �� � � i � ; u „ l � o ' , , , � � � � i , � u i a , j ! � N I i , �, , , , i n � ! ' i i i ' � ! ' i ii ' ' I ' I � 1 A � � � � I � I 1 11 , ,; . � ; I , 1 fl O tA N r'r1 N I� ' P a�M1 O O f�O O j K1 T�1 � O O K� �O-�'; O N �I O�O �: 00 O� P 00 0� 1 N 11 I W�-i P r1[� O� M i 1/�CQ.-1 O O i O O � O h N O'�O � M�' O P � �t+O �� O� IY1 V� J �t 1 M p W O � � ► �• • � , � • �.• • • '• � • ; •��� i �� • '�• � � • � � • � �. � �,� • � �� 1 . !1 I m 2.f�Q O�P 1� 00 ' �O N OD O O!�1 M N : O �f � tn 1�P �O P OO N d �. d f� A 1� I� 1 �¢ If � 0 � tU 00 P.-1 M r� v� ����, M a P.-f V��O P �O N R3 �-/P e�7� t� � �O N 00 P ' P �-1 �-1 �O �O 1 1� p ' 4\ X P.i P O ; N � V1 f7 N1 ;M O N I fV O�� 1+7 ri 1�;�� �.O N�t �0�t �.,• O 0��. �.� - O O ( �O N i W f��-1 N f� P � � ►�I \ ♦ �♦. ♦�� ♦ i .\ . s ♦ � • - ♦ .♦ 1 ♦ fl ' � \ '�: ! ri M M I O� i M OD H N d N CO N fV !� f� 1 P N 1 � r1 N � . �� N ' ! oo I n i k1 ery� ra �� .T .,t 1 v N �. \ ~ . � � � ' I �.I � �. � � . . 1 �+'1 p � ` C \ i i � I I ! ' I t u :� f- I � � n ' ; � n �-- z (''� o , � ' I i I � u •L-� •v ' 9 W � � i '. i I I �. '�� � ' x �i � ! � I I" � 1 N r �- W , �n � Q m � � ' , ! . .� � � � �� i '� 1 6 � � ; Z Z . - � ��. ' j � . � � '. 1 11 L� � \ 7 �, , . ; I i '. j 'I 1 fl �. U v v ' � � I I 1 , p i > Z � W . �. ' � �I � �I .. � : � �. .. I f Tnl � � � . . i i � ; I � � . i � ��� i U I ; � ' I�.� . I i fl v ►- �� i � � � , � I, � � � ; � � � . � �� t n � � z � ; ; , , � " • I W � � : � u Z SllC 00 O p0 Opp 0000 � p � O ! O �OQOO �� �O O O � O O 1 `O N I 4J .JO QO O 00 pOQ OOOO�i O ( O j q MQCiO - M d O � O O ( M 11 � m � '� • � '• � � t '� • � I• � � '� • I �� t � • • • �� • �• • • �• ! �� 0 � I < <i. oa o 00 � ot�o�nooin nl n 000boo ' o0 0 0 0 0 � .-� x Z J d v�I� f� O O � O�i Y\P P.t .�t P O� O a0 O O O OC �1 r/ N N 1 P II j i ►++O 00 G v� In N � f�N N�t t�l Y�M '-1 i . f+�� Y1 M O M�O '. I� �O �O ��. .-i .-i.1 a0 n I i < • • • ♦ �♦ ♦ ♦ �♦ ♦ �♦ ��.♦ �i ♦ .. • ♦ �• � ♦ I♦�� • �. • �♦ / '• tt � >N �-1 P �-1 fV e-1 ' � N�t�S +tS "tV ! CO .t� �O N � A � I �� ~ � I j � � � h � M1 � N � � N �:, V '�, �O '�C 1 W p ,. i .. j � � I . � .� ' � ., 1 M N � I ' � � ; � I ����i ; � i � � ; �� q ' � � I ; , � � � � �� � � � , � �� a � � z ' in u u� i r- , v�r- z vr ¢v ' ; � I �� <I �� W W t7 CA � K��+ �. Z I. � �.�W I ' � I i l'J V Z V'1 I IL F'�QC i � i i 041� � 2 �WJ O ♦J[,OC W J N 1 � , � � w�n <a s v !. Q �f- F- ut a v� � .� i a uv~i�� +�-� �c�z z iu �a i x� . i a i irw , p'"°°o. , wo � zo .»�-{.� , <� v►- c� � o i i i� �� so� � vvi � Qv � , a w¢r- ' = v� '_t t vt vi¢ . v� ' �m � a a � i I zw �w«.� ! w Wrr oa u,r i r �• � � ' <v � ; mz> <c� tnw c� .z wvti � vrvv��n V► � I z z a�a o i z z..�u. ti.�r+ s vI w r-r w...t ! r- z v� �t�ow: v� z..rx � ..�oa w< ...... .. �<tu«.� : ,.. v� .. I �, vi•,wz z>s <> l� i u,r= � �o � �- ' v� o E--a z... o 'i � � l�vt►-�o o� � a rr�n i !n r�. o ui .. ,n � a u- W ' z w< ; ., .+¢a u�w { � v x a.�., � z u. w ww..i w ' wwsu..uF- ;� F- F-ti-.. I � �n� wsr�� ! iu w ' v � � I �sar-wa �zzt-orr < < � viaovsu, : m z o o r- I �•.••.• cr � WfJ00<�O17� a � m I JII tvcnk. a cn i w ' ¢ z o VI h-t�W�-r Y V) C7 Z S 2 V fl II.Z h- !� �W� t ��t/1� r� 1 ��f LLl� 1 I J FI.I- m��� d 4 F- . �'��. W VI-Cr � 6da G.H Nr.N �AC� � K � � W� J�C�Vt7 � K '� ;,J ' � �JJ � ! F-r.IWWJS24.7�+ an...w ..� wrw . v G.WWr•efG �� r�+ },Z � � J..7F-W J CY . VtJJ J0.�..7<Oi7 iU{?SLL S 25...�I d ZG.4.Q � � H '-� t7 �, F- n. F- � I 7� O? S { O W W ltJ��Lt O W�S�tJ h LL ►-LLt�" �> >F�K LL.O ; t�J ��� 7Z � t ►.e a. - 4.LL. ZC�tlf ...� t1.H1-►-L]tiF-L5 ��bCf Ot�O � VY OC.O� � f- 4. �-+ G � > ; t�n � i I j I �� ' a ; in � s i u�. � i,� � I ! ! � I ; v � I , �' i 4 ! F- �-i(V N H rf �^I N M J fV�O�-4 N MT Y1�O O�1!1� O� O lT N P 00 e-1 �'� b�. . I� �� �� 2 M�rl M±T�O O N(V N N�f+�Y1 Y1 I!1 tt1�V1 1�� f�P k7� d�. �y N� 'O aO i O 1'7 O ' Y1 O 'i � I k �'"'�"�""� �NN�VNN(((VVV S'VN. N N � •O�: �MMI�MM O Lt : O� 00 Q - I _� ( OOOObO fi�.����0- O C Q�Op00�5SA4. OQ (Y! 00 00 ! M �S -:� .� , p {�p�� � i ' V ! � ; � � i � � . �� i i i i i � ;' i i � I � i I ' I � � � � ����'�.1.�,lr��X'w�. ..,.w w s A:� + C".fi� -.._ ��,��� . . . , � : �,., _ . ._ ._�_.._—� =- _ =.� �r'..'S•t�T:w . 'F�tv��=`�}�� '�1•'�< �ftic�;��.s�m�.e k• a��s�hs�qj��t�f� ki e. -�ul� 6�.`��v�?y'..]: -; ...... .___�__•�• , c� c7 r, •t�• r� ri r . . a'_ '.. �, i- �_�`�:� . . � . . - �� . � :�-. ._ . .' ---'_ ' _` '__ '.�—. ' ' . .}„ ^ 1 '' � ' . . ' ( � ! , ! � � I a � � � � , „ � ; I � � � �� � � < ; I � i � ; � ' ,' `� � � � ; ` � ° i ; ; ; ; I � ' � � � �, ; , v ' I � t � � t i t � Sh � � ao.-roeo �aa in ov� .�-�M � �:;00000 I i n ^ t �G�i0aD1��00 � M Oh P �O Nf�CC00 n Q O O 1f1 � �n CO O f P U 1 � • � � • • � � • • � '• �� � � � �• • � N O N N I N O N N 1 �O fl � ,`(�I, °t' 1 h-V�n O 1�Ml P I N O�t O N N1 ��• • • � ' � � • � � � � � y�J `� . I 1 V M tn A f0 ri N ', O� !�O O O N , C� iT �S O 1� ! A O Yl � �� � ; t;;M;�; � N oQ c0 M� .r+O`�0'ri N.-1 � �-i N rl ^ pYp i �t o 7� 1� i v\ {nj ` �� � 0O O�T d I .i q = � z .. 1 M a0 1� �O '. M V1 i ; . ',, 'i .♦ ♦ ♦ i ♦ p �, � W .-I�-1 M nr N O.t 1 1 T� q -7 W � i I �O C� .t 1 M d .-i 1 .-1 q � I ' ' . ,. � ' � � p . �'. .-i = i �� I 1 p � � _ , � I � j � i ; ' ° „ '^ v o � i ; I t a , I � � Z W; ., ,' �, i � � � i � i , I fl : s Z �C , � f ; I . I � p , ( �°c ' : I ' " 1 1 ,', � � t a ' � 'n 1 0 ' i I ' � ; 1 a ; .-t � a ; q I LL ' 1 q ! , ,, ; ' �'; . , � � j ' � , I . � p d I � � . � I �� I �� � t � I ' , . � � 1 Ipi , O o.-1 v a0.p .v� �; y1..1 P y1 rr O o q o� �� 1 q I . . W ri O OO►��O I M � � H O G7 o ff1 'i 1!� . o O 1 H p � • W p�• • •! • e i • ' ^ PM��O - NOOI O.OI N NO N hi� 1� � Op 0p 1 MA '. o Z bv�0 .-irrl , � � • •I�� � •�00 o0�v1 y1 I� • �• � ■ � � i � p �. , i � , W CO vf n H.�1 �. � �! O 1�M .t �O � .t • `t 0 0 O C 1 �D II �,. ` .� C. I X;1+1 N N a0 I P 0 0 M N V' 1f1 1!1 M1( �p ^ ri 1n 1� M1 I Pl co W I �O II �, 1� � `G N i W I�a0 1n ' N . ♦ \ � N ; ; ; �O �O 1 ri p � � ` � � Ffl N N � M � � � � � N d' �� 00 b0 1 00 i I � I .� H � I N N v1 V'1 1 N W � ��, < ! O i I i I�.. � . I;.. I 1 N 8 I ,. � Ia i � � ' � . , � � �. ' � . p � � I � � ! I j j ( 6 I �I � � �! i . ; � . I . ���i I�...� ' . i Cf o i otl � � � ��C }- W; . � �� .� . �. � �. O O � p p � � � • 1 � p �: I lL�. a � �i . � j . I .. I I . P P 1 P p ' G O t1�y,r\- I ti . •J ZI � � ( I�� �� � �, I j � fl I ' ! r Z � W j ' I I �. , � � n �� . V I M-� � ( . ; . .��i I . ..��.�� I 1 . n I ' I ; Z � ' � � � � � � �, _ � h ' w � ' � n , � �� r i w io � � b ' � � I ; i n �, � 0 0 0 0 'o 0 0p 0 0 o i p o � p � j m0 O OI� O �O 'dOO�0001 O I � � O 00 O 1 O fl I •i • -� • P�: �� � • •� �� � � � I O O O I O O O O 1 O ',� . ' < � K N �f O� ; V1 O C � 'C6 O 6 O Ih; V1 � O O N j N O O � 1 � � I ; Z � J f� O N� O O C 'O 1A C b O f�' 1� O p M O 1 N � � i `M iJ ;I.��` O �I D h0 e-7 1V fV RT I 04 N N Y� �1f� O.i �-i t ~ S � I � ?�t qC �p� p� y� I � � �I � , ♦ � ♦ .♦ ♦ ,� M N �I . 1 ♦ i I <n. ►-a a � xv ' �' � v+ �v� O r :r 1 � e � � ; � � : �.� . . � . � � �� 0 1 �O p �� . � t � N ! M tl ! i � � i �I �I � � 1 � n � � i � i I � � -� �.. � � , � I � ' � I K � ' � z � � � . �� � I tn V !yJ�i�A. I ~ I � i Vl V � Y I ! ' '� � ►'� V s Yi� �J 4J u,j W . ' , :� . ' � > Z��..Lit I � �� ..�. :i M� I 4J W i , � , � I O O liJ O C: i I W W N a .0 t,f� • � i J � Q i IZ �� � 1�.t�d I W 1—4 O V!-- ,J l7. �� � �. . "" i i M��r�-aZ N H 0..�: WO � IIi��H�t~lfI �F �. 1I I—fl � , IW � W�ctl— J Q 1 I �ol �r I LL� ; , � ' i Z kA lL'� � Z �J�. I t V1 Vf¢U �C. , � �_ ' . ' � _ � <uv�� f t�i. z�f< � W �;�j � � �- ! i Z x �o o�. I J'^ v�I t�c� I � i QOCF-C`W ,�j a �� � o,�ti'- ��; ,�c� �, zZ � ►-�w a ,n ,,.,,,., � I r�i� an.zz� �p� � � �Z<�M �Q�) _� W� M �N p I j'� �� I I �< �=iii wz = Z � �►- � ►- ��..v�' ' w w v� m '' ' '�-'a v►-�►.�..� a � r-w o�... x < � � �! ���' m a o o � • I i z �►-�-r-w.-�r vi o� x v a rcc- c' '' ai � u i w z a z o �,.+.. ! v f- ct i W i <n. ...v� in vrr� �' w Ix in , m a a c � o i..i�r-� a < ... �n r- w�u z ..v��w►-' v w� � " � � � � :..►_t tr►-w ' I J- a u,�n� a < �u.a zzl .. �o Z� W �ca � ::�"" I j ��<:o> c� < wow �a: w� r-w� > cr �.. t� r r- o n a f- � I ..N i ►.��..a�o�n� 4 u.a �-- o�.. � a ov! � �'m � � � oo > ; z i � ' I � � `" ' i � � "' � �- ` � w ► ' I �� � 1 I � v � � a ; I � ; , � r � 'r Z�� ►"'e-1 N N N.^/e-1� VP .-1 M N.�t'� I W Y I . 'Z i*'1�"'1 N�1.T�O� O '�-i N N d':Y1�� tA i!1�.if1 P I p �� P I . � �.-1.i H!.-t.-1.�i I ����O �n oG p �C!� �" I � O O Ct O iG O p jN N N�hl��N' N N N N� O �1 `• I O> I ' V' . i .�..i O O O O Oi O O O Oi N MJ d IM O �. �f O q � �' ' 0� VI � I 'SF� ! <f � i .:�i . � ��. I ' i ' , ! ' I 0.< � � I .. j . I i .. • I . .� ! '. . � . , . . . . }.�_ . . , . . . . . .. �+-> . . . . -�-- ••��--' -i�. .�..� �.r.., �r��_�f„��^FrFi �T'r�:r' .i i'..'J U�.c'V� . . . . ,. � • •n�i7wf w i� �e"R� cr.�.7'L '„',�� � .._ .�__ � �__ ,. . . � _ .___—_ . .'--- '" r� . .� r� rv rv w r, cV � � �.k� ,. ... -�-�- ,- .-.. ,.._...' "_'. .._._" . �`�,"-_ ....., Y i :��} �.i i,. ..J J ��I r�.d. . . . _ _. _._.��._ �..:. _ .. .. • ;... ' ' :. . _ . .."'' . . . �u. in .,: . _. . ._._ . y__�_; C�� °�°u Members: . � Roger J. Goswitz� chair Janice Rettman Tom Dimond Date: ��cfi 9, 1988 9:00 a.m.--City Council Chambers Com ittee Repor� - q To: Saint Paul City Coun�i From :Public Works, Uti�iti s, and Transportation Committee Roger J. Goswitz, C air COrI�IITTE OF WliOLE - THIS ITEM ONLY DISCUSSION: Shepard/Warner/East C D Bypass Environmental Impact 5tatement. � 1• Approval of minu es of February 24, }.988, Hearing Date 2. 3/15/88 VACATION: Petiti n of Dale Edward Ailport, Jr. for the vacation of the lley in Watson's Division "D" for the purpose of combi ing into one parcel (bounded by Edgerton, Reaney, Payne an Piinnehaha) . APPROVED 3. 3/24/88 FINAL ORUFR: Im roving SHEFARD ROAD FROM Gannon Road to Elway Street by onstructing a bituminous overlay and doing all other � ork necessary and incidental to complete said improvement APPROVED . 4• RESOLUTION: Ame di.ng the 1988 budget by adding $15,900 to the Financing and Spending P1ans-Traffic, Signal, Lighting Mtce. F nd. �SPPROVED ti,��,�,----.w�■-_ : _. ,c-=.---- . . '�„�_ � � 5 �,,, .. . ... . ,� . . .. :, ,. � �"� G ` r' y ,:2. . k �F' 4-� � x� ` ` � �� ' " �:. � .... .. �i � .� -'� ' . ' � � "s..� � - �� . . . ._.... . .....,. . .,.. �: . ._�;,i„ . . �—�. .,. .��n�r ... r�-.;.....___l� '°'ti� 6• RESOLUTION: App oving Ramsey County plans for the con- struction, recon truction or improvement of MC KNIGHT ROAD from Lower fton Road to North Park Drive. APPROVED �• RESOLUTION: App oving the appointments by the Mayor of Charles Cathcart and Mary Alvara�3o to serve as alternates on the Metropoli an Aircraf,t Sound Abatement Council, terms to expire ugust 1'6,=�1990'����` APPROVED