02/29/1988 CONF MTG - 5017CITY OF FRIDLEY
CONFERENCE MEETING
FEBRUARY 29, 1988
7:30 P.M.
1. Discussion of MIS Computer Study and Cost Analysis
for the Next Five Years
2. Update on Cable Television Franchise Renewal
3. 1988 Budget Schedule and City Council's Instruction
to the City Manager
4.
�
�
Discussion of Shorewood Plaza Service Road Vacation
Discussion of Workers' Compensation for Councilmembers
Discussion on 72nd Avenue Parking Proposal
7. Discussion on EPA Lead Notification Procedure
8. Other
�''y � i
�
� � � :k
�.
, �
/J
0
CITY OF FRIDLEY, MIrNES(.�1'.� , :
Ca;�ZPUTER REQU�RFME!�'TS AND PLANI�II�G S'1'Ull�C'
JAi�'UAR Y 18,148'�
CHAPEL CONSULTING, INC .
MANAGEMENT CONSUITANTS
�
�: � �
TABLE OF CONTENTS �
SECTION . PAGE
/
I. INTRODUCTION
II. CURRENT STATUS OF AUTOMATION
III. SYSTEM REQUIREMENTS
A. Overview
B. City Management
C. Central Services
D. Community Development
E. Fire
F. Police
G. Public Works
H. Recreation and Natural Resource
I. System-Wide/EDP Staff
IV. MAJOR ISSUES AFFECTING DATA PROCESSING
PLANNING
A. Administrative System
B. Public Safety System
C. Geographic Information System
D. Personal Computers
E. EDP Staff
F. Document Archiving System
G. Parcel Data Base
H. Host System
I. Application Priority
V. ALTERNATE PLANS FOR AUTOMATION
VI. COST ANALYSIS
VII. SUMMARY OF RECOMMENDATIONS
a
1
4
8
8
11
14
20
22
24
27
30
32
34
34
34
34
35
36
37
37
38
39
42
45
56
�
r t
I. �NTRODUCTION
On August 18, 1987, Chapel Consulting was engaged to assist the City
of Fridley in improving the quality and effective�ess of its
information processing systems.
Our approach to meeting this objective was to divide the project
into two phases. The phases are:
i Phase I• Needs Analvsis and Cost Estimate - Define the
City's current and future data processing, word processing
j and data communications requirements. Determine the best
; approach and assess the cost of ineeting these requirements.
Phase II• New Hardware and Software Selection - Finalize the
• detailed system requirements and prepare a Request for
Proposal document. Solicit bids from computer vendors.
Select the most appropriate new system (or systems).
This report is the result of the work performed under Phase I. It
describes the general information processing requirements at the
City. It also contains an analysis of the cost of upgrading
hardware and software to meet these requirements. It is based on
information collected through interviews with City personnel, non-
City personnel and by reviewing various documents provided by the
City. City personnel interviewed include:
Citv Management
o Nasim Qureshi
o Bill Hunt
o Sue Irber
o Lynda Averette
Central Service
o Rick Pribyl
o Shirley Haapala
o Leon Madsen
o Julie Burt
o Garol Bartlett
o Sara Ruth
o Elsie Hanscom
o - Dawn Weigel
o Barbara Ridout
o Brian Hill
o Julie Hammerstrom
o Betty Okerstrom
1
�
. �
, Community Develooment
, o Jock Robertson
' o Mary Hintz
i - -
�
Fire
� o Robert Aldrich /
o Evelyn Loomis
Police
�
o James Hill
o Tim Turnbull
j o Laurel Anderson
Public Works
o John Flora
o Bob Nordahl
' Recreation and Natural Resource
o Jack Kirk
� o Susan Johnson
i
Anoka County Data Processing Department
!
o Gene Oswald
o Dale Kolstad
The Bottom Line (Archivinct Consultants)
o Nancy Freeman
o Gloria Gold
Bell & Howell �Archiving Svstem Vendorl
` o Mike Mangano
o Dick Verlo
s
� The remainder of this report is organized into seven sections.
. Section II includes a brief description of the existing hardware and
software in use at the City. An assessment of user satisfaction
� with the automated systems has been included in this Section, when
appropriate.
Section III presents a general description of the information
processing requirements at the City. The description are detailed
� only to the extent required to develop the cost estimates in
Section VI.
F�
. .
A
Section IV includes a discussion of the major issues affecting data
processing planning at the City.
` Section V discusses the three major alternatives we considered for
, enhancing automation at the City. For each alternative this section
includes a description and a summary of the advantages and
= disadvantages of the alternative. �
� Section VI summarizeb the initial and long term costs jof each
�
viable alternative.
� Section VII presents a summary of our recommendations for improving
automation at the City.
9
a
♦';
3 �.
, � p
i
II. �URRENT STATUS OF AUTOMATION
The City has been quite aggressive in automating in an attempt to
i meet its information processing requirements. It started_acquiring
hardware and software in early 1983. Currently, the City uses two
Texas Instrument minicomputers and ten personal computers. The two
� minicomputers comprise the nucleus of the hardware system; most
processing is performed on these machines. One of the mini�omputers
(the public safety systemj is used exclusively by the Police and
; Fire Departments. The personal computers are used for special
� analyses and miscellaneous applications.
There are a total of thirty workstations (including six personal
, computers with terminal emulation capabilities) and twenty-four
printers attached to the two minicomputers. These devices are
distributed throughout the City and are used by City personnel to
. operate a variety of application software. The distribution by
� department is:
�,iARDWARE
City Manaaement
0 3 Terminals
0 2 Letter Quality Printers
Central Services
Finance:
0 4
0 3
0 3
a 1
0 5
0 1
Terminals
Personal Computers (with
terminal emulation)
Personal Computers
Letter Quality Printer
Report Printers
Graphics Printer
4
SOFTWARE
o Word Processing
o Personnel (currently
under development)
�
.
.
.
.
.
.
.
0
Budgetinq and General
Ledger Accounting
Payroll
Cash Disbursements
Cash Receipts
Utility Billing
Liquor Store Inventory
Control
Word Processing
Job Accounting
Asset Inventory
Special Assessments
(currently under
development)
Budget Preparation
�
1
�
i
:
s
;
i
�
t
�
�iARDWARE
City Clerk:
0 1 Terminal
0 1 Personal Computer (with
terminal emulation)
0 1 Report Printer
Assessor:
0 2 Terminals
0 1 Report Printer
Data Processing:
0 2 Terminals
0 1 Personal Computer (with
terminal emulation)
0 1 Letter 4uality Laser Printer
0 2 Report Printers (1 high speed)
� Communitv Develonment
0 2 Terminals
0 1 Personal Computer
' 0 1 Report Printer
� 0 1 Letter Quality Printer
�
t
_
Fire
0 1 Terminal
0 1 Report Printer
0 1 Letter Quality Printer
� Police
0 5 Terminals
0 2 Report Printers
' 0 1 Letter Quality Printer
;
�
SOFTWARE
o Word Processing -
o Investments Management
o Insurance Claims .
Management
� PRINTS "
o PRINTS
o Tax Assessing System
o Word Processing
o Property Sales Tracking
o Word Processing
o PRINTS
o Spreadsheeting
o Fire Management
o Word Processing
o Training
o Fire Relief
o PRINTS
o Word Processing
o Police Recordkeeping
and Reporting
o Data Communications
with State Crime
Reporting Computer
Network
1
�
I
�
i
� 1
�ARDWARE
gublic Works
SOFTWARE
0 2 Terminals (1 at garage) o Word Processing -
0 1 Personal Computer (with o Streets Inventory
terminal emulation capabilities) o Spreadsheetinq -
0 1 Report Printer o PRINTS . ,
o i Letter Quality Printer '
Recreation and Natural Resource
0 2 Terminals
0 1 Letter Quality Printer
o Word Processing
j In very rough terms, system usage is distributed as follows:
�
�
City Management
� Central Services
Community Development
� Fire ,
Police
; Public Works
� Recreation and Naturalist
sa e
7$
47$
4$
4$
25$
9$
4$
City managers and staff are (with one notable exception)
dissatisfied with the existing information processing capabilities.
Hardware complaints include a lack of terminals and printers and
frequent slow performance of the system. Software complaints fall
� into several categories:
' o Existing software is poorly designed.
; o Existing software is cumbersome to use.
o Existing software does not meet the users' needs.
o The City does not have the appropriate software to meet certain
; important requirements.
The users are especially dissatisfied with the word processing on
the existing system.
Beyond the specific complaints about hardware and software
4 inadequacies, the City manager recognizes that the City's
� information processing requirements are not being met in a
coordinated, integrated fashion. Inefficiencies have developed and,
, in some cases, systems which were implemented have been discarded
because they proved more difficult to use than they were worth.
6
�
�
:
�
�
�
i
�
i
. �
The exception noted above is the Police Department. This Department
is satisfied with its systems (except for word processing). The
Department is seeking hardware and software enhancements to make its
systems work even better.
�]
1
i
U
i
i
i
0
III. SYSTEM REQUIREMENTS
A. OVERVIEW
This section describes the information processing requirements of
the City of Fridley. The requirements are organized and pre�ented
by department. Some applications are required by more than one
department. When this is the case, the requirement is listed undsr
each department.
The requirements of each department are shown below. An asterisk
signifies a requirement which is not currently being met or which is
being met inadequately:
Citv Manaaement
o Word Processing *
o Personnel
o Graphics *
o Desk Top Publishing *
o Spreadsheeting *
o System-Wide Access*
1
�entral Services
i
Finance:
�
�
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Fund/Budget Accounting and Reporting *
Payroll
Cash Disbursements
Cash Receipts *
Purchasing
Utility Billinq
Asset Accounting
Special Assessments
Liquor Store Merchandizing *
Word Processing *
Spreadsheeting
Graphics
Desk Top Publishing *
Business Licensing *
City Clerk:
` o Street Address/Polling Place Cross Reference
o Word Processing *
o Insurance Claims Management
- o Investment Management
, o Spreadsheeting
8
, r �
� Assessor:
o Appraisal Data Base *
► o Word Processing *
, o Property Sales Tracking
o Geographic Information System *
�ommunity Development
i o
� o
0
+ o
0
0
0
0
0
0
0
0
0
0
0
0
�
Word Processinq *
Spreadsheeting
Graphics.
Project Costing
Parcel Identification Number/Street Address Cross Reference
Building Permitting and Special Use Permittinq *
Computer Aided Design *
Geographic Information System *
ire
911 Data Communications Interface *
Hazardous Material Fire Fighting *
MFIRS Reporting
Equipment Management *
Fire Management, Including Appraisal/Street Address Data
Word Processing *
Graphics *
Desk Top Publishing*
Police
0
0
0
0
0
0
0
0
0
0
0
0
0
�
Police Recordkeeping and Reporting
State Crime Computer Network Data Communications Interface
Casewriter *
Multi-Jurisdiction Access *
Business Contacts *
Case Management *
Word Processing *
Spreadsheeting
Graphics
Desk Top Publishing *
Equipment Management *
Data File Management and Disk Storage Utilization *
ENFORC Report Generator *
- �,
9 � ,.
,
i
s
�
,
i
.
�
public Works
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Word Processing *
Spreadsheeting
Graphics
Geographic Information System *
Project Costing
Project Management *
Work Order Management *
Equipment Costing and Management *
Streets Inventory
Project Cost Estimating *
Warehouse Parts Inventory Control *
Engineering Design Tools *
Computer Aided Design *
Gasoline Pump Management *
�ecreation and Natural Resource
0
0
0
0
0
0
0
0
Facilities Scheduling *
Team and League Management *
Class Registration *
Inventory/Asset Management *
Word Processing *
Mailing List Management *
Project Costing and Revenue Accounting
Desk Top Publishing *
Svstem-Wide Requirements
o Uninterruptable Power Supply *
o Reel-to-Reel Tape *
o Fourth Generation Programming Lanquage *
o High Speed Printer
o Report Generator *
o Data Communications
10
.,
B. CITY MANAGEMENT
This office coordinates the activities of other departments, does
program analysis, supports the Council and administers the City's
personnel and cable TV functions.
�oftware Reauirements
1. Word Processina
�
Word processing is a critical automated tool. It is used heavily by
the clerical personnel in this office and throughout the City. It
is important that the word processing system be easy to learn and
operate but also include a wide variety of features to facilitate
the preparation of lengthy documents.
We recommend the City use personal computers to meet its word
processing requirements City-wide. There are several reasons for
this recommendation, including performance, quality of software,
security of data and cost.
Operating speed will be a highly critical feature of this system.
If the word processing software is running on a single centralized
minicomputer, speed will vary from very fast to very slow depending
on the mix of jobs being run at any given time. If, however, the
word processing software is runninq on a number of personal
computers (one for each user), operating speed will be very fast for
all users.
Excellent word processing software is available to run on personal
computers. In most cases it is superior to the software available
for minicomputers.
The security of word processed documents is easier to achieve on PC
based systems than on a shared system.
The cost of personal computers has fallen to the point where it is
no longer cost prohibitive to provide a PC to each word processing
user. The cost of the software is also low.
The PCs will be equipped with terminal emulation software and wired
to the City's central computer. This will allow them to be used as
terminals to run non-word processing jobs when required.
There are some problems associated with a PC based word processing
system.. The most serious is the enforcement of file backup
procedures. We feel certain that this problem can be solved.
11
,
(
2. gersonnel
The data processing
; personnel system.
► implementation and it
project. However, it
� City's requirements.
� this software.
3. Spreadsheet na
staff has just completed development of a
This system is in the early stages of
is too early to assess the success of the
is likely that the system will not meet the
TherAfore, it will be necessary to r•eplace
.
Spreadsheeting software is used heavily by the clerical and
management staff fn this office and throughout the City. Currently,
the City uses LOTUS 1-2-3 on PCs. This is a powerful, easy to use
tool which meets the City's needs in this area. The City should
continue to use LOTUS on PCs in the future.
4. G,�aphics
Graphics software will be used by this office and in other
departments at the City. LOTUS 1-2-3 can be used to generate most
of the graphs and charts required by the Manager's office.
5. �esk Top Publish'ina
Desk top publishing (DTP) is the use of PCs, laser printers,
scanners and special software to typeset and lay out publications.
For the City, DTP can save time and money in the production of a
wide variety of documents.
Although DTP could be used by several departments in the City, this
capability should not be duplicated in each department. Rather, the
City should acquire a single DTP system and share its use among the
departments. One or two staff people should become expert in the
use of the DTP and serve as the City's in-house publications
resource.
6. Svstem-Wide Inquirv
The City Manager and the Assistant City Manager should have the
ability to perform inquiries against all of the data stored in the
central system. This means that they should be able to look at but
not change or delete data stored for use by fund accounting, payroll
recreation event scheduling, public works project management or any
other app2ications. A possible exception is the police record-
keeping data. This ability would not extend to data stored on PCs.
12
i
t
1
�
1
�
�
i
!
�
�
�
i
i
,
�Iardware Reauirements
City Manager
Assistant City Manager
Secretarial and Clerical
�S
1
1
8 (1 AT for DTP)
13
Pri=
1 Report .
1 Report and
1 Letter Quality
1 Laser for DTP
1 Scanner for DTP
�
C. CENTRAL SERVICES
This Department consists of several functional areas - finance, the
City Clerk's office, the Assessor's office and data processinq.
FINANCE
Although some current
likely that all will
improvements in the
reporting.
�oftware ReQUirements
financial applications are satisfactory, it is
have to be replaced in order to obtain desired
key module - fund/budget accounting and
1. Fund/Budaet Accountina and Reoortina
This module will be used to store account balances, appropriations
and transaction detail for the current year. It will also store
prior years account balances. It will provide fund and encumbrance
accounting capabilities and accept automatic postings from other
accounting modules. A wide variety of financial and budget
comparison reports will be available. An easy-to-use report
generator must be included in this module. This module must allow
for separate accounting for the HRA. The module must easily
interact with LOTUS 1-2-3, passing data to and accepting data from
the spreadsheet software.
2. a rol
This module will generate pay checks and stubs and maintain month-
to-date, quarter-to-date and year-to-date pay and withholding data
from each employee. It must allow for a wide variety of pay and
withholding categories. The module must have the ability to
automatically allocate all personnel expenses each month based on
the distribution of payroll expenses to departments. The module
must be capable of calculating and reporting accrued vacation,
annual and wellness leave time and converting these accounts to
dollars at year end. The module must track Medicare and FICA income
and properly report these amounts on W2 forms at year end. PERA,
FICA, Federal and State reportinq on magnetic media will be
required. The module will interface with the project costing module
to allow for single entry and allocation of employee labcr costs to
project.
3. Cash Disbursement
This module will be used to generate checks to vendors. It will
store information on paymer�ts due to vendors and the history of
14
� �
�
6
payments made to each vendor. As invoice
will assist in verifying that the invoice
and (2) approved by matching it with an o
module will print checks and remittance adv
become due or on demand. Invoices enter
posted to the project costing module, when
4. Cash Receipts
s are entered, the module
is (1) not a duplicate,
pen purchase order. The
ices for invoices as they
ed will automatically be
appropriate.
�
The cash receipts module will allow for on-line entry of cash
receipts at the customer service counter and in the finance office.
Cash receipts will be for utility bills, recreation activities,
permits, fines, etc. Receipts will be printed by the system when
required. Terminals will be attached to a cash box to provide for
automated cash control. As each cash receipt is entered, the module
will prompt the operator for certain data - amount, general ledger
number, utility customer number (if appropriate), operator ID,
etc. The system will verify the data and create a cash receipts
transaction file for subsequent updating of the utility billing and
fund/budget accounting modules. The cash receipts terminals could
be equipped with bar code scanners or optical character recognition
devices to speed entry of utility cash receipts.
5. Purchasinct
The City uses an encumbrance accounting system to
purchases. Therefore the purchasing module must 1
interacting with the fund/budget accountinq module to
as new purchase orders are entered. The module will
open orders until an invoice is entered in the cash
module. Data on closed orders will be summarized and
6. Utilitv Billina
control major
�e capable of
encumber funds
store data on
disbursements
stored.
The utility billing module will calculate and bill for utility
services. Utility customer data will be entered for new customer
data and automatically updated as usage data is entered. Usage
history will be stored for verification of new meter read
��reasonableness" and for customer usage analysis. Utility bills
will be printed; they could include bar codes or optical character
rint to speed entry of utility cash receipts.
P
7. Asset Accountina
This module will be used to track the location, cost, insured value
and acquisition history of each major asset owned by the City. It
would be capable of calculatinq depreciation expense amounts for
assets held in enterprise funds. �
15 ��-
�.
s
!
t
8. Special Assessments
The data processing staff is in the process of completing a special
assessments module. It is likely that this software will meet the
City's needs. It should be retained and used with any new_ hardware
acquired. It is written in CoBOL.
9. ��c�uor Store MerchandizinQ
J
Currently, the liquor stores are equipped with electronic cash
registers capable of accumulatinq daily sales activity. The
registers also maintain perpetual inventory counts for each
inventory item. Nightly, each register is polled by the City's
central system for the day's sales activity. The central system
maintains a separate perpetual inventory for control purposes and
to provide inventory valuation and cost of sales data.
Ideally, t
capable o;
analysis,
processing
required.
e liquor stores should be equipped with in-store systems
providinq full inventory control, purchasing, sales
profitability ai�alysis and point-of-sale transaction
capabilities. A total of five in-house reqisters will be
10. Word Processina
The finance group is a light user of word processing. If PCs are
used for word processing, one PC should be sufficient to meet this
group's needs.
11. �greadsheetina
The finance group is a heavy user of
powerful and easy-to-use tool which
software should continue being used.
users in the finance group.
12. Graphics
LOTUS 1-2-3 on PCs. This is a
meets the qroup's needs. This
There are three spreadsheet
The finance group will use graphics as a tool to present financial
data in various reports and publications. Most of the graphs and
charts required can be generated by IATUS 1-2-3.
13. Desk Top Publishina
The finance group will use desk top publishing (DTP) to prepare the
annual budget document. This need can be met through the use of the
shared DTP system described above.
16
i
14. Business Licens na
The business licensing system will generate licenses on demand and
maintain a file of licenses issued. The system will use an °all-in-
one" license fona. It will cr.eate new licenses in response to
operator entry of data. It will be capable of print�ng-lists of
licenses due for renewal. .
i�ardware Requirements
Central Services Director
Assistant Finance
Director
Utility Billing Clerks
Liquor Inventory and Fund
Accounting Clerk
Cash Receipts Counter
Fund and Asset Accounting
Clerk
Payroll Clerk
Cash Disbursements
Clerk
Special Assessments Clerk
Liquor Stores
CITY CLERK
Software Requirements
Terminals Cs
1
1
2
� = �-�- J I
1
1
1
1
1
5 PC/
Registers
l. Street Address/Pollinq Place Cross Reference
r
Printers
1 Report
1 Report
1 Report
1 Report
1 Letter Quality
1 Report
5 Report/Receipt
The Clerk is responsible for identifyinq the precinct number, ward
number and all other political districts for each parcel in the
City. In addition, the Clerk must be able to identify the polling
place for each parcel. In the past, the City has used PRINTS to
store this data. This has not worked well for the Clerk because of
two problems - it is difficult to keep PRINTS up to date and PRINTS
runs slowly on the central computer.
The Clerk needs a simple system to identify the polling place,
precinct number, etc. for each street address in the City. It will
display this information when a street address is entered. It must
be very fast. It must allow for multiple simultaneous inquiries.
In the .future it could be a part of the geographic information
system. �
17
► , .
i
2. �Tord Processinq
The City Clerk will make extensive use of word processing to
� maintain the City Code, prepare and index minutes of ineetings, index
; resolutions, type correspondence and maintain mailing lists.
3. Insurance Claims Manaaement �
The Clerk is usinq LOTUS 1-2-3 to manage claims filed aqainst the
City and its insurance companies. This is a satisfactory solution
and should be continued.
4. �nvestment Management
The Clerk is using LOTUS 1-2-3 to inventory over $32 million in City
investments. The spreadsheet the Clerk is using is acceptable but
additional capabilities are required. The module must be integrated
with the fund/budget accountinq module. It must be capable of
storing and reporting based on certain key dates (interest due date,
maturation date and anticipated sale date). These enhancements
could be incorporated into the existing LOTUS spreadsheet assuminq
the new fund/budget accounting module will interface with LOTUS.
5. Spreadsheeting �
The Clerk is a heavy user of LOTUS 1-2-3 spreadsheet software on a
PC. As noted above, both insurance claims management and investment
management are processed using LOTUS.
Hardware Requirements
City Clerk
ASSESSOR
Software Requirements
1. A�oraisal Data Base
�
1
Printers
1 Report and
1 Letter Quality
The Assessor and his staff communicate changes in property
descriptions to Anoka County by revising appraisal cards by hand.
These are hand delivered to the County. The County in turn prints
and delivers new cards with the updated infonaation to the City.
18
0
5
The Assessor also maintains the same data on a jacket envelope
which contains historical appraisal data and other relevant
documents. Neither system lets the Assessor do any analysis of the
property data base or groups of properties. To facilitate this type
of analysis the City has developed a third system on-the computer
called PRINTS which contains the same information that is on the
jackets and the County's system. •
We recommend that the PRINTS system be dropped, that tiYe County
provide the City with updated property records weekly on computer
tapes, and that the City program its system to retain the current
property description from the County plus previous versions. This
plan will reduce the number of duplicate systems from three to two.
The Assessor needs a report generator and inquiry capability to
perform various ad hoc analyses of the property data. In the
future, this module could be integrated with the geographic
information system.
2. Word Processinct
The Assessor's office is a light user of word processing. Word
processing is used for occasional correspondence and reports. One
PC will be sufficient here.
3. Pro�ertv Sales Trackina
The Assessor uses this system to store and analyze real property
sales data. The data is used primarily to appraise property using
the comparable sales method. The existing system is satisfactory
and could be retained. However, the potential exists to integrate
this module with the appraisal data base and, in the future, the
geographic information system.
4. Geoaraphic Information Svstem
When the City acquires a geoqraphic information
could utilize the system to create maps
presentation purposes. The appraisal data base
with this system.
Hardware Requirements
Assessor's Office
Terminals PCs
1 1
19
system, the Assessor
for analytical and
could be integrated
Pri�
1 Report and
1 Letter Quality
D. COMMUNITY DEVELOPMENT
l. Word Processina
This Department is a heavy user of word processing. 'At -least two
PCs will be required here.
_
,
i 2. $preadsheetinq ��
LOTUS 1-2-3 spreadsheet software is used by this Department to
perform project cost and other analyses. This is a powerful and
easy-to-use tool which meets the Department's needs. However, it
is likely that new project costing software will be acquired to meet
the needs of a number of Departments; this software could also be
used by Community Development for project costing.
3. Graphics
The Community Development Department will use graphics as a tool to
present data in various reports. Most of the graphs and charts
required can be generated by LOTUS 1-2-3.
4. �roiect Costinct
The Department uses LOTUS 1-2-3 to perform some project cost
analyses. This is an adequate tool. However, more capable project
costing software will be acquired to meet the needs of other
departments (primarily, Public Works). This new software could be
used by Community Development.
5. Parcel Identification NumberlStreet Address Cross Reference
Currently, the Department uses PRINTS to store the cross reference
between street addresses and parcel identification numbers. If
PRINTS is dropped, the City will have to create a new cross
reference system using the Assessor's data base. In the future,
this could be a part of the geographic information system.
6. Buildina Permitting and Special Use Permittina
' The Department will use a building permit system to issue and track
permits and inspection activity. The system will allow for the
! entry of data on licensed contractors. Then, when a permit
: application is received, data on the application will be entered.
When the application is approved, the system will print the permit.
Inspections could be scheduled in the system. As inspections are
performed, they will be logged to the computer. After the final
20
inspection and approval, the system will print a certificate of
occupancy. The system will be capable of generating a variety of
reports summarizing permit and inspection activity. It will be
used to process many types of permits issued by the City, including
electrical, heating, plumbing, sign, moving, etc. --
This system will not save significant clerical time and .effort
during the permitting process. However, it will make it easier to
presolidateedatadcollect d by the Fire Department duri q Sfiredcode
con
inspections.
7. Computer Aided Desian
The Department will occasionally make use of a computer sided design
(CAD) system for landscape planning and other projects. This PC
based system is described in more detail in the Public Works
software requirements. The Community Development Department will
share the CAD system with Public Works.
8. Geoaraohic Information Svstem
The geographic information system (GIS) is an automated mapping and
data storage tool. It will be used primarily by the Public Works
and the Community Development Departments. GIS will be used by
Community Development to store appraisal, zoninq, flood plain, land
use and other information on each parcel in the City. Of course,
the physical location and dimensions of each parcel will also be
stored. The Department will use GIS as a research and presentation
tool when dealing with planning and economic development issues.
Hardware Requirements
Community Development
Department
Terminals
1
1 GIS (shared
with Public
Works)
1 GIS Digitizer
(shared with
Public Works)
� Printers
2 1 Letter Quality
1 Report
1 GIS Report
(shared with
Public Works)
1 GIS Plotter
(shared with
Public Works) .
21 '":
_�,
E. FIRE
The Department uses software called the fire manaqement system.
This system performs several functions and is running on the public
safety minicomputer. It stores and reports data on street
addresses. It stores data on incidents and fire fighter activity.
It prepares a variety of incident reports, some of which are used to
prepare MFIRS reports. It prepares reports summarizing fire fighter
activity. The Department is generally satisfied with thi�s system
with the exception of the items noted below.
Software Reauirements
1. 911 Data Communications Interface
Currently the County 911 dispatcher radios or telephones emergency
calls to the Fridley Fire Department. The Department enters the
address into its system to obtain further information on the
location. This data is then printed and handed to the fire
fighters if they are still in the station, or called to them on the
radio if they are not. Time could be saved if the County keyed the
call directly into Fridley's computer to trigger the printout.
The new station, when built, will need a printer with appropriate
communications to the public safety system so that printouts can be
generated there simultaneously with printouts at the main station.
2. Hazardous Material Fire Ficthtina
Fire fighters are faced with unknown hazardous substances on some
fire calls. Treatment of the fire could vary depending on the
nature of the substances encountered. Data bases of common
chemicals, identification criteria and the proper procedures and
counter chemicals to use have been created with retrieval software.
A fire fighter could call the station with a description of the
problem while a computer operator finds the answers he needs. This
is probably a PC application.
3. MFIRS Reportinq
The system currently used by the Departmen
required to prepare MFIRS reports by hand.
enhanced to automatically generate these
building inspection data needs to be added
programming can be done by the City's staff.
22
t is generating the data
This system should be
reports. In addition,
to the data base. This
, .
�
d
�
r
0
A
4. �auipment Costing and Manaaement
The Fire Department, like many other departments, will use a City-
wide system to maintain records on the equipment entrusted to the
Department. The system should contain only basic ma�ntenance and
usage information. .
5. Apnraisal/Street Address Data �
If PRINTS is eliminated, the data processing,staff will have to
write new software to update addresses in the fire management system
with new addresses in the County appraisal data base. Also, new
software will be required to pull the appraised value of property
from the data base over to the fire management system.
6. Word ProcessinQ
The Department is a moderate user of word processing.
be sufficient here.
7. Graphics
One PC will
The Department will use graphs and charts in its annual report. Its
graphics requirements could be met using LOTUS 1-2-3.
8. pesk Top Publishinct
The Department could use desk top publishing (DTP) to prepare its
annual report. This need could be met through the use of the shared
DTP system described elsewhere in this document.
�iardware Requirements
Fire Secretary
911 Dispatch
New Fire Station
Terminals
�
23
1
g� Printers
1 1 Letter Quality
1 Report
1 Report
�
F. POLICE
Software Reauirements
l.
The Department is currently using the ENFORC system tar� provide
incident and other recordkeeping and reporting. This system is also
used to communicate with and update the State CJIS. It operates on
a stand-alone public safety minicomputer. The Department is very
satisfied with this system. Some enhancements are desired to make
it a better tool for the Department. Some of these enhancements
will be developed and delivered over time by the software author,
MaSys. Some could require additional hardware (for example, the
need to support six simultaneous data communication links with the
State CJIS).
2. Casewriter
The Department types both the fill-in-the-blanks and text portions
of the patrolmen and investigator calls-for-service reports. The
fill-in-the-blanks portion of the data is then entered into the
City's computer system. The casewriter program from Masys, which is
now being tested a�t the City, will allow the Department's clerical
personnel to add the text portion of the report to the computer
version. Zf this test is successful, the Department should be
encouraged to eliminate the manual typing step and use the computer
printout instead for its permanent files.
3. Multi-Jurisdiction Access
Several years from now the Department may be able to access the
records of other jurisdictions who plan to cooperate in the
development of such a program by Masys. This effort is in the
broad planning stages at this time and the estimates of cost are
very imprecise. This capability is not anticipated during the time
frame of this data processing plan.
4. Business Contacts
Commercial properties in the City should be indexed on a system
which contains names and phone numbers of key individuals to be
contacted in case of emergencies outside of normal working hours.
Special instructions may need to be added to this file. The
Department performs this task manually now. This system need not be
integrated with the geographic information system.
24
5. �ase Manaaement System
The Chief cannot stay up-to-date on the status of all active cases
without some tools. A case management system keeps track of the
chronology of events on a case, the action taken, the actions to be
taken, investigative hours consumed, assigned personnel and problems
encountered. This system has been developed by MaSys and is
currently being tested in Minnetonka. If successful, it should be
acquired. ��
�
i 6. Word Processina
� The Department is a light user of word processing. This is in part
due to a lack of terminals and letter quality printers in the
Department. With more hardware, usage would increase. Three PCs
. will adequate.
7. ,�oreadsheetina
Spreadsheeting will be used to perform analytical studies of
numerical data. LOTUS 1-2-3 on a PC is an appropriate tool for use
in the Department.
8. Gravhics
The Department will use graphics software to create charts and
graphs for presentation in the annual report and other documents.
LOTUS 1-2-3 will meet the Department's requirements.
9. Desk Toa Publishina
The Department will use desk top publishinq (DTP) to prepare its
annual report. This need will be met through the use of the shared
DTP system described elsewhere in this report.
10. �q._u�ipment Costina and Manaaement
The Police Department will participate in a City-wide equipment
management system. The system should contain only basic maintenance
and usage information. .
11. Data File Management and Disk Storaae Utilization
The Department is running out of room to store new incident records
and other data on its system. This situation has been caused by two
deficiencies in the existing software. First, there is no software
25
the Department can use to easily purge old or unneeded data from the
data files. Second, the software is designed to reside entirely on
a sinqle disk device. This means that 64MB, almost 30$ of the total
disk storage attached to the public safety system, cannot be used
by the Department. �
The Department should acquire software from MaSys to allow- it to
delete old and unneeded data from the files. In addition, the City
must work with MaSys to modify the ENFORC system to allow i�t to use
multiple disk devices.
12. ENFORC Renort Generator
The ENFORC system generates a variety of standard reports. These
reports provide the Department with useful information on incidents
and activities. However, a report generator designed to work with
the ENFORC data files will give the Department more flexibility in
creating reports.
Hardware Requirements
Chief's Secretary
Director of Special
Projects
Investigators
Special Projects
Personnel
Front Office Records
Personnel
Patrol Room
Patrol Sergeant
Office Supervisor
Terminals
1
5
3
2
2
1
26
gCs Printers
1 1 Letter Quality
1 Report
1 Report
1
1
1
1
1
1
1
1
1
Report and
Letter Quality
Letter Quality
Report
Report
Report
Letter Quality
G. PUBLIC WORKS
1. Word Processina
The Public Works Department is a moderate user of word processinq.
It is used to prepare correspondence, various short documents•and an
occasional lengthy report. Two PCs will be sufficient.
�
2. Svreadsheetinq
Currently, the Department uses LOTUS 1-2-3 to prepare cost estimates
on new projects and project costing on ongoing projects. The
Department will continue to use LOTUS in the future.
3. Granhics
The Department will use qraphics as a tool to present numeric data
in various reports. Most of the graphs and charts required can be
generated by LOTUS 1-2-3.
4. Geoarag,hic Information Svstem
The geographic information system (GIS) is an automated mapping and
data storage tool. It will be used primarily by the Public Works
and Community Development Departments. The Public Works Department
will use the GIS to create and store a wide variety of City maps.
Map data will show streets, utility lines, special assessment
projects and other information.
The GIS will become the primary mapping tool for the Department and
the City. It will be a very effective tool for preparing working
maps and maps for presentation purposes. The GIS could also be used
to store property related data for the Assessor and other City
personnel.
5. Proiect Costina
The Department uses LOTUS 1-2-3 to perfona
analysis. This tool has proved useful, but
costinq software would be more effective. This
be used by other Departments.
some project cost
specialized project
software will also
2 7 � .:- ,.
6. groiect Manaaement
The Department will use the computer to provide basic project
management tools. These could include actual-to-estimated cost
comparison, CPM/PERT analysis and project task detinition and
tracking. _
7. Work Order Mana4ement �'
The Department will use a system tu track the status of work orders
for street repair, vehicle maintenance, parks maintenance and other
activities.,
8. �quipment Costing and Manaaement
This software will be used by the Public Works
Departments. It will maintain usage, maintenance and
equipment items. It should allow the ability
preventative maintenance.
9. Streets Inventorv
and other
cost data on
to schedule
The Department is using a system to inventory street segments. The
system stores descriptive location, maintenance history and other
data about each segment. It can generate reports detailing this
information. The system could be improved by enhancing its inquiry
and reporting capabilities.
This system was developed by Ameridata. It is written in Cobol. If
the City acquires the source code to this system, it could be used
in the future on a new administrative system. If not, new streets
inventory software will have to be acquired. This system could be
replaced by the GIS in the future.
10. groject Cost Estimatina
The Department is currently using LOTUS 1-2-3 to prepare project
cost estimate sheets. This approach is working well and will be
continued.
11. Warehouse Parts Inventorv Control
The Department will use a simple inventory control system to manage
the store of parts at the garage. This system will maintain
perpetual counts and track inventory receipts and disbursements.
28
1
0
12. Enaineerinq Design Tools
The Department will use several analytical tools to solve various
engineering design problems. These include software to address
problems involving hydrology, watershed analysis, pipe-sizing, mass
diagraming and surveying. This software will run on a PC.
13. omputer Aided Desian �
The Department will make use of a computer aided design (CAD) system
for project design work. This system will consist of a powerful PC,
graphics monitor, plotter, printer and CAD software. It could be
integrated with the GIS. The Public Works Department will share the
CAD system with Community Development.
14. Gasoline Pump Mana4ement
The Department is currently soliciting bids for a stand alone
gasoline pump management system. This system will not be
integrated with the administrative system. It is not included in
the cost analysis in this report.
Hardware Requirements
Public Works Director
Public Works Assistant
Director
Engineer
Garage
Public Works Secretary
Public Works Department
Terminals gCs
1
1
1
(AT for CAD)
1
1
1 GIS (shared
with Community
Development)
29
grinters
1 Report
1 Report
1 Letter Quality
1 GIS Report
(shared with
Community De-
velopment)
1 GIS Plotter
(shared with
Community De-
velopment)
H. RECREATION AND NATURAL RESOURCE
The recreation staff has been using the City's word
software to accomplish many tasks which word processing
was not designed to satisfy. The Department also uses �he
reqister students in classes. This software is cumbersome
G�ftware Reguirements
1. Facilities Schedulina
processinq
technology
-system to
to use.
.
Fields, courts, gyms and classrooms will be inventoried and
scheduled usinq the computer. Information on facilities out of
service (those not available because of maintenancej will be entered
and classified as unavailable durinq periods of maintenance by the
Public Works Department. Use permits issued should be recorded. A
copy of the schedule and facilities preparation work orders (for
example, field chalking requirements) will be generated for the
Public Works Department.
2. �eam and LeaQUe Manacrement
Team managers and rosters, league schedules and standinqs, and fee
payment requiremen�s will all be kept on a system. The league
scheduling system will interface with the facilities scheduling
system to match the league's needs with available facilities.
3. Class Revistration
Minimum student identification and grade level information needs to
be retained for each registrant. The class schedules and
instructors will be matched with available facilities if class
registration and facilities scheduling were integrated. Collecting
fees and material charges or fssuing refunds and fee-waivers will be
an on-line process at the registration counter. The system will
also provide statistics on class participation levels and maintain
waiting lists.
This system will generate statistics for calculating the Economic
Equivalent Index (EEI).
4. Inventorv/Asset Manaaement
The Department has a small inventory of equipment that could be
better controlled if there were an appropriate recordkeeping
system. This will be a very simple asset management system.
30
5. Word ProcessinQ and Mailinq List Manaaement
The Department is a heavy user of word processing. It maintains
extensive mailing lists and sends correspondence, announcements and
other mailings to individuals on a regular basis. Word �rocessing
will continue to be an important tool for this Department.
�
6. �raphics
The Department has a need for both business graphics (charts and
graphs) and free form graphics (freehand drawings). The business
graphics need can be met using LOTUS 1-2-3 or a low cost PC based
business graphics package. The need for free form graphics will
also be met usinq a PC based package.
7. groiect Costina and Revenue Accountina
The Department needs to measure the financial and functional
success of its programs more closely. An accounting system that
records revenues and expenses by program will be helpful.
Summarizing all the programs in one area of service will also be
helpful to measure the overall success of that area. These
requirements will be met using a combination of project costing
software and fund/budget accounting software.
8. Desk Ton Publishina
The Department will use desk top Publishing (DTP) extensively to
prepare its various publications. The Department will use the
shared DTP system described elsewhere in this report.
Hardware Rewirements
Registration Counter
Support Staff
Nature Center
Senior Center
Terminals gCs
31
1
1
1
1
grinters
1 Report
1 Letter Quality
1 Report
1 Report
I. SYSTEM-WIDE/EDP STAFF
This section describes characteristics and features required to make
a central system more useful to the City. It also describes the
terminal and printer requirements of the EDP staff. --
1. iJninterruptable Power Sup�lv
.
The central system must be protected by an uninterruptable power
supply (UPS) large enough to protect the CPU and mass storage
devices of both the administrative and public safety systems. The
purpose of this UPS will be to allow for an orderly shut-down of the
systems in the event of a power outage.
2. �eel-To-Reel Taoe
Both the administrative and public safety systems must be equipped
with reel-to-reel tape drives to facilitate tape transfer of County
Assessor data files to the City and to speed back up.
3. Fourth Generation Programmina LanauaQe
A fourth generation programming language (4GL) will improve the
productivity of the City's programming staff. Currently, the City
uses Cobol, a third generation language.
4. Nigh Speed Printer
The City will require one high speed printer to generate large
reports and other major print jobs. Currently, the City uses a 600
line per minute printer.
5. Report Generator
A simple, easy to use report generator would be used by a wide
variety of City personnel. It would reduce the demand on City
programmers by allowing users to create their own ad hoc reports.
6. Data Communications
The public safety system will require data coinmunications (DC)
capabilities with the State CJIS network. This link must be capable
of supporting four simultaneous DC sessions. If the Fire Departnent
continues to use this system, a DC link to the new firehouse will be
required. In addition, a link to the County 911 dispatcher could be
required.
32
The administrative system will require a DC link with the City
garage. This system will also require links to the nature center,
the senior center and the liquor stores.
EDP Staff Hardware Rectuirements
EDP Staff
Terminals p�s_
1 1
33
d
g�inters
1 High Speed
.�:
IV. MAJOR ISSUES AFFECTING DATA PROCESSING PLANNING
This section describes several major issues which- will affect
planning for data processing. Where appropriate, we make
recommendations for dealing with each issue. -
.
A. ADMINISTRATIVE SYSTEM
The City should replace most of its financial and administrative
support software. There is wide-spread dissatisfaction with most
of these computerized tools.
If the software is replaced, it is likely that the hardware will
also be replaced. Although there is software available which runs
on the City's existing Texas Instruments hardware, the City should
not limit it's options by looking only at this software. Instead,
the City should look at a wide variety of software and select the
software which comes closest to meetinq its overall requirements.
The hardware selection should be a bi-product of the software
selection. �
B. PUBLIC SAFETY SYSTEM
The City should continue maintaininq a separate Texas Instruments
minicomputer for use by the Police and Fire Departments. This
public safety system will run the ENFORC and fire management
software.
It does not make sense to replace this software because both the
Police and Fire Departments are happy with their systems. The City
already owns the Texas Instruments hardware which will be required
by the Departments in the future. If the City replaces its
administrative system, much of this hardware could be used by the
Police and Fire Departments.
Both Departments will have to have access to the administrative
system. This could be accomplished by using wiring switches and
PCs.
C. GEOGRAPHIC INFORMATION SYSTEM
A geographic information system (GIS) will be of great value to the
City. . It will be especially useful to the Public Works and
Community Development Departments. A GIS holds the promise of
serving as a partial data base for parcel related information.
34
The City should wait on acquiring a GIS until Anoka County has made
a decision on its GIS. There are several reasons for waiting. By
waiting, the City can guarantee that its GIS will be compatible with
the County's. Compatibility with the County is a critical issue
because of the desirability of sharing maps due to the-high cost of
creating new maps in a GIS. By waiting, the City might be able to
participate with the County in the acquisition of a GIS. Th�s could
result in the sharing of hardware and software with the County. The
cost of GIS hardware is likely to be less expensive in the �future.
Anoka County has indicated that it may acquire its GIS in 1989 or
1990. Realistically, the City should plan on acquiring its GIS in
1990.
The GIS must operate on hardware separate from the administrative
and public safety systems. This will complicate the interchange of
property related data for City-wide use.
D. PERSONAL COMPUTERS
Personal computers (PCs) should be used extensively by the City in
the future. All word processing and spreadsheeting will be
performed on PCs. It is likely that some users now usfng terminals
will use PCs in the future.
Eventually, the City could be using between 25 and 30 PCs. It will
be much easier to manage these PCs if they are all configured
identically. This probably will not be possible, but the City
should strive to configure its PCs with: �
o Full IBM PC Compatibility
o MSDOS Operating System
0 640KB Main Memory
0 20MB Hard Disk
0 1.2MB Floppy Disk
o Monochrome Graphics Screen
o IBM-Style Enhanced Keyboard (101 Keys)
o Administrative System and/or Public Safety
System Terminal Emulation Capability
0 1 Parallel Port
0 1 or 2 Serial Ports
Some of these �PCs should be equipped with high speed processors
(80286 or 80386). These will be used for desk top publishing,
computer aided design and other applications requiring faster
machines. It might be desirable to standardize on the IBM PS/2.
The PS/2 is IBM's latest personal computer product.
All of the PCs will be wired to either the administrative or public
safety systems. Some will be wired to both.
35
�
The City should not discard its existing PCs. Rather, it should
investigate the cost of upqrading them. In some cases, however, it
may not be cost effective to acquire additional disk or memory.
These PCs could end up being used by staff which do not have heavy
usage requirements. � '
A problem associated with this extensive use of PCs is data file
backup. All data stored on the public safety and administrative
systems will be backeci up daily by the EDP staff. Because these
systems are centralized, this activity is relatively easy to
perform and control. Because of their decentralized nature,
backing up PCs is hard to control. Most PC users do not have the
discipline to do it consistently. PC users not backing up are
vulnerable to losing data because of bad diskettes, hardware
malfunctions, power fluctuations, operator errors and other
problems.
There are several possible solutions to this problem. The City
could store all data on the central systems until needed by a PC
user. When needed at a PC, the data could be "down loaded"
electronically. When finished, the PC user would "up load" the data
back to the central system. This would make it easy for the EDP
staff to back up all data each day. Another approach involves
networking all of the PCs to a single large data storaqe device.
Data would be stored on this device until needed at a PC. Again,
the EDP staff could easily back up this eystem. There are other
technical solutio�s to this problem. When selecting its new system,
the City should closely review each vendor's approach to solving
this problem.
E. EDP STAFF
The City will require a 6ma11 staff to manage its administrative
and public safety systems and to undertake modest system
development projects. The staff should consist of two people - a
manager and a programmer/operator. The manager should be qualified
to design and program simple new systems. This staff will also be
responsible for training other City employees in the use of the
systems.
The staff will be responsible for the conversion of a number of
existing programs to run on the new administrative system. These
include:
o Special Assessments
o .Property Sales Tracking
36
�
�
In addition, the staff could be responsible for developinq several
new applications, including:
o Street Address/Polling Place Cross Reference
o Appraisal Data Base - -
o Parcel Identification Number/Street Address Cross
Reference • '
o MFIRS Reporting/Buildinq Inspection Data ..
o Fire Management/Appraisai and Street Address Data ,�'
F. DOCUMENT ARCHIVING SYSTEM
The City is currently assessinq various solutions to its document
archiving problem. The most attractive of the alternatfves being
considered involves the use of a document imaging system
incorporating a microcomputer and data base management software to
access archived documents. The imaging systems being considered use
either optical disk, microfilm or microfiche as the storage medium.
It might be possible to link the archivinq system to the
administrative computer system. However, there are strong reasons
for not making this a high priority. There is no overriding need
for linking the two systems together. The City would not achieve
any significant productivity increases through such a linkage. In
addition, most of the systems the City is considering are not
usually linked to computers of the type the City will need for its
administrative system. It would be difficult to link these two
systems.
G. PARCEL DATA BASE
The existing PRINTS system has not proved to be an effective tool.
There are several reasons for this, including:
o PRINTS data is difficult to maintain.
o Responsibility for data maintenance is not clearly defined.
o PRINTS is not well supported by the software vendor.
o PRINTS operates to slowly to be useful to all users.
For these reasons, we recommend that the PRINTS system be
discontinued.
� However, the City does have a need to store parcel related data.
( This requirement affects primarily:
' o City Clerk - Street Address/Polling Place Cross Reference
o Assessor - Appraisal Data Base
37
o Community Development - Parcel I.D./ Street Address Cross
Reference
o Fire - Appraisal/Street Address Data
o Public Works - Streets Inventory
In theory, a unified system should be the best way to meet the
City�s needs for parcel data. The City has learned from its
experience with PRINTS that practical realities can limit the
effectiveness of a unified system. We are skeptical t�at a new
unified system to replace PRINTS will be significantly more
effective than PRINTS.
At this time, it appears that the best way of ineeting the City�s
parcel data processing requirements is through a set of stand alone
applications. The problem of data consistency and integrity could
be minimized by using the assessment data supplied by the County to
update each stand alone application with new street address and
parcel number data. This is not a perfect solution, but it appears
better than the available options.
Despite this preliminary recommendation, the City should not close
its mind to a solution involving a unified system. If a viable
option incorporating a unified system is proposed to the City, it
should be carefully evaluated in light of the City's experience with
PRINTS. It could turn out to be workable. In the future, a GIS
could be used to store and present much of the parcel data required
by the Public Works and Community Development Departments and the
City Clerk and Assessor. There could be technical problems
associated with providing widespread, easy access to this data in a
GIS.
H. HOST SYSTEM
This section shows the most favorable distribution of application
software between the administrative and public safety systems and
various PCs.
�oolication
Word Processinq
Personnel
Graphics
Desk Top Publishing
Spreadsheeting
Fund/Budget Accounting
Payroll
Cash Disbursements
Cash Receipts
Purchasing
Utility Billing
and Reporting
38
System
PCs
Administrative
PCs
DTP PC
PCs
Administrative
Administrative
Administrative
Administrative
Administrative
Administrative
�nn7ication
Asset Accounting
Business Licensing
Special Assessments
Street Address/Polling Place Cross
Reference
Insurance Claims Management
Investment Management
Appraisal Data Base
Property Sales Tracking
Project Costing
Parcel Identification Number/Street
Address Cross Reference
Building Permitting and Special
Use Permitting
Computer Aided Design
911 Data Communications Interface
Hazardous Material Fire Fighting
Equipment Costing and Management
Fire Management
Police Recordkeepinq and Reporting
State Crime Computer Network Data
Communications Interface
Casewriter
Business Contacts
Case Management
ENFORC Data File Management
Geographic Information System
Project Management
Work Order Management
Streets Inventory
Project Cost Estimating
Warehouse Parts Inventory Control
Engineering Design Tools
Gasoline Pump Management
Facilities Scheduling
Team and League Management
Class Registration
Inventory/Asset Management
Mailing List Management
ENFORC Report Generator
Liquor Store Merchandizing
I. APPLICATION PRIORITY
This section shows the relative priority
application.
Svstem
Administrative
Administrative or PC
Administrative
Administrative
PC
PC ��
Administrative
Administrative
Administrative
Administrative
Administrative
CAD PC
Public Safety
Public Safety or PC
Administrative
Public Safety
Public Safety
Public Safety
Public Safety
Public Safety or PC
Public Safety
Public Safety
GIS Computer
PC
Administrative
Administrative
PC
Administrative
PCs
Stand Alone
PC
PC
PCs
PC
PC
Public Safety
PCs
for automation of each �
39 `�� �.
Hiah Priority A�plications
Personnel
Word Processing
Project Costing
Appraisal Data Base
Parcel Identification Number/Street
Address Cross Reference
Casewriter
ENFORC Data File Management
Geographic Information System
Class Registration
Mailing List Management
Fund/Budget Accounting and Reporting
Payroll
Cash Disbursements
Purchasing
Utility Billing
State Crime Computer Network Data
Communications Interface
Spreadsheeting
Special Assessments
Police Recordkeeping and Reporting
Project Management
: Streets Inventory
Fire Management
Property Sales Tracking
Medium Priority Applications
Building Permitting and Special
Use Permitting
Computer Aided Design
Desk Top Publishing
Equipment Costing and Management
Business Licensing
Business Contacts
Case Management
Liquor Store Merchandizing
Engineering Design Tools
Facilities Scheduling
ENFORC Report Generator
Insurance Claims Management
Investment Management
Cash Receipts
40
Year
Implementation
Starts
1988
1988
1989
� 1988
1988
1988
1988
1990
1988
1988
1989
1989
1989
1989
1989
1988 (Existing)
1988
1988
1988
1988
1988
1988
(Existing)
(Existing)
1988
(Existing)
(Existing)
(Existing)
1989
1989
1989
1988
1989
1989
1989
1990
1988
1989
1989
1988 (Existing)
1988 (Existing)
1989
,
�
i
;
,
I
i
0
Low Prioritv AQplications
Team and League Management
Graphics
Asset Accounting
911 Data Communications Znterface
Work Order Management
Project Cost Estimating
Hazardous Material Fire Fiqhting
Warehouse Parts Inventory Control
Inventory/Asset Management
Street Address/Polling Place
Cross Reference
41
Year
Implementation
Starts
1990
1988
�990
1988
1990
1990
1989
1990
1990
1990
V. ALTERNATE PLANS FOR AUTOMATION
; This section describes three alternative system configurations which
could meet the City's current and future data processing
. requirements. The major strengths and weaknesses of each approach
are listed and a recommendation is made on the most a�ropriate
` alternative.
E Each of the alternatives discussed below assumes that the publ.ic
safety system will be retained and that it will continue being run
on its own hardware. In addition, it is assumed that the GIS will
run on a separate system when it is acquired. Because of these
, assumptions, the alternatives focus on the hardware and software
configuration of the administr�tive system.
Qption One - A Central Computer And No PCs
This option consists of using a large superminicomputer to meet all
� of the City's processing requirements (except for the public safety
system and the GIS). The accounting, word processing, personnel,
assessment, park and recreation, permit tracking, engineering and
� all other requirements would be met using this machine. No PCs
� would be used at the City.
� There are some advantages to this approach:
o A single system would be easier to manage and control.
o Many applications are better run on a central system because
higher quality software is available.
o Vendor support would be better on a centralized system than
' it would be on PC-based systems.
o Some applications require multi-user capabilities. This
could not be achieved usinq PCs.
The disadvantages are:
, o A central system would be slow when a large number of users
were active simultaneously.
�
o By eliminating the use of PCs, the City would be forced into
' using the central system to run jobs better handled by PCs
(word processing, spreadsheeting, graphics, etc.)
This is a viable alternative for the City.
42
0
Option Two A Central Computer In Combination With pCs
This option includes the use of both a central system and PCs. The
; central system would be used to process those applications best run
. on a central system. The PCs would be used to run the applications
PCs are best at � word processing, spreadsheeting and other
activities. The PCs would also be used as terminals to the•central
, system. The PCs would be IBM compatible. ,�
The strengths of this approach are:
i
• o The City would be usinq the appropriate technology to meet
each of its requirements - either the central system or a PC.
o The City would get better support from its software vendor.
� o The central system would be used to run those applications
requiring multi-user capabilities.
The major disadvantages of this solution are:
i o This approach makes it more difficult to control file back up
on the PCs.
o PCs are not perfect replacements for terminals.
This alternative is viable for the City. Without considering costs,
it provides the most flexibility and power of all of the options
being considered.
Option Three A Network of PCs And No Central Computer
This alternative consists of using a network of PCs to meet all of
the City's processing requirements (except for the public safety
� system and the GIS). The network would include a large number of
PCs and printers and a large centralized mass storage capability.
The PCs would be IBM compatible.
The advantages to this approach are:
o PC networks can be easily expanded. Additional PCs and
printers can be added at will.
o PC networks have build in hardware redundancy. The failure
' of one PC does not affect the operation of the rest of the
network.
' o PCs are the best solution for some of the City's processing
requirements - word processing, spreadsheeting, computer-
aided-design, etc.
43
c
;
i
�
t
,
i
�
, �
The disadvantages of a PC network are:
o The City would be forced to use PC software even when it is
not the best solution available. Some applications (utility
billing, assessors data base, payroll, etc.) are -better run
on a minicomputer using minicomputer software. Some
applications probably could not be successfully run on a
microcomputer. �
�
o PC networks are difficult to manage.
o PC users are difficult to control. This is true of both
networked and non-networked PC users.
o PC software is not well supported by Boftware vendors.
o The distributed nature of a PC network makes it impossible to
focus maximum computer power on a job, if necessary.
This alternative is not viable for the City.
44
�
VI. �OST ANALYSIS
This section shows the costs of the two viable data -processing
alternatives described in Section V. Cost summaries of each
alternative are shown first. The cost detail follows. •
' This cost analysis is based on several assumptions: �
; o The existing administrative system will be replaced.
o Some existing administrative software will be converted to run
on the new hardware.
o The existing public safety software will be retained. The
public safety hardware will be upqraded by usinq the old
administrative system hardware.
o All new hardware and software (except for the GIS) will be
�
acquired in 1988.
� o The GIS will be installed in 1990. It will be a stand alone
, system. The cost of the GIS does not include the personnel
cost associated with diqitizing the existing maps.
The costs reflect direct cash outlays for each alternative. The
cost categories included in this analysis are: �
o�Iardware - The cost of acquiring computer hardware including
the processor, main memory, mass storage, I/O controllers,
data communications hardware and software, terminals,
printers, plotters and other equipment required for reasonable
. system performance. System software such as the operating
system, utilities and compilers are also included here.
o Software - The cost of acquiring computer proqrams from
software developers to meet the primary and secondary
: application requirements. Not all software will be
purchased; some applications will be developed in-house or
� converted to new hardware from the existing T.I. computer.
o Installation - The cost of installing and implementing the new
system. This category includes the cost of freight,
insurance, installation, electrical wiring (when necessary),
training and documentation.
o Data Communication Lines - The cost of leasing telephone lines
to provide communications between City Hall and the remote
terminal/PC sites, the State CJIS and the County 911
dispatcher. � � -•
.;
45 ��
1 1
o Hardware Maintenance - The cost of ongoing hardware
maintenance from the hardware manufacturer or a third party.
This is a recurrinq cost and is assumed to increase at 6$
annually.
o�oftware Supnort - The cost of ongoing software support for
purchased software. This support will be supplied• by the
� software vendor and could take the form. of software
enhancements or modifications. This is a recurrinc� cost and
is assumed to increase 10$ annually.
!
e
�
0
;
46
c
�
a
.
ADMINISTRATIVE
�
Hardware
Software
Installation
Subtotal
COST SiJMMARY
gLTERNATIVE ONE• A CENTRAL COMPUTER WITH NO PCs
(Assume All Implementation Begins In 1988)
1988 1989 1990 99 1992 TOTAL
/
$197,400 --- --- $ 5,000 --- $202,400
104,500 --- --- --- --- 104,500
10.000 100 10.100
$311,900 --- --- $ 5,100 --- $317,000
, Hardware Maint.* 16,000 $ 17,000 $ 18,000 19,000 $20,000 90,000
Data Comm. Lines* 1,800 1,900 2,000 2,100 2,300 10,100
Software Maint.* 10.500 I1.00U 12.000 12.000 13,000 _ 58,500
' TOTAL $340,200 $ 29,900 $ 32,000 $38,200 $35,300 $475,600
a
PUBLIC SAFETY
Hardware
Software
Installation
Subtotal
$ 18,000 --- --- --- --- $ 18,000
29,000 --- --- -�- --- 29,000
1.000 --- --- --- --- 1.000
$ 48,000 --- --- --- --- $ 48,000
Hardware Maint.* 10,000 $ 10,600 $ 11,200 $11,900 $12,600 56,300
Data Comm. Lines* 2,400 2,500 2,700 2,900 3,000 13,500
Software Maint.* 7.000 7,400 7.900 8.400 8,900 39.600
TOTAL $ 67,400 $ 20,500 $ 21,800 $23,200 $24,500 $157,400
GIS
Hardware --- --- $ 80,000 --- ---
Software --- --- 35,000 --- ---
Installation --- --- 1,000 --- ---
Hardware Maint.* --- --- 6,000 $ 7,000 $ 7,000
Software Maint.* --- --- 5.000 5.000 6.000
TOTAL . --- --- $127,000 $12,000 $13,000
GRAND TOTAL $407.600 i� .Q4. �� b' � Q y? �
* Inflated 6$ annually
47
$ 80,000
35,000
1,000
20,000
16.000
$152,000
s' �Q
.
4
!
�
. COST SZJMMARY
�LTERNATIVE TWO: A CENTRAL COMPUTER IN COMBINATION WITH PCs
(Assume All Implementation Begins In 1988)
ADMINISTRATIVE
Hardware
Software
Installation
Subtotal
1988 1989 1990 1991 1992 • TOTAL
. �
$212,400 --- --- $ 5,000 --- $217,400
85,000 --- --- --- --- 85,000
10.000 --- --- 100 --- 10.100
$307,400 --- --� $ 5,100 --- $312,500
Hardware Maint.* 17,000 $18,000 $ 19,000 21,000 $22,000 97,000
Data Comm. Lines* 1,800 1,900 2,000 2,100 2,300 30,100
Software Maint.* 8,000 9.000 9,000 10.000 10.000 46.000
! TOTAL $334,200 $28,900 $ 30,000 $38,200 $34,.300 $465,600
; PUBLIC SAFETY
Hardware
: Software
. Installation
Subtotal
$ 26,000 --- --- ---
18,100 --- --- ---
1.000 --- --- ---
$ 45,100 --- --- ---
$ 26,000
18,100
1.000
$ 45,100
Hardware Maint.* 10,000 $10,600 $ 11,200 $11,900 $12,600 56,300
Data Comm. Lines* 2,400 2,500 2,700 2,900 3,000 13,500
Software Maint.* 7.000 7.400 7.900 8,400 8,900 39.600
t
TOTAL $ 64,500 $20,500 $ 21,800 $23,200 $24,500 $154,500
0
GIS
Hardware --- --- $ 80,000 --- ---
Software --- --- 35,000 --- ---
Installation --- --- 1,000 --- ---
Hardware Maint.*� --- --- 6,000 $ 7,000 $ 7,000
Software Maint.* --- --- 5.000 00 6 0
TOTAL � --- --- $127,000 $12,000 $13,000
GRAND TOTAL S398, 700 s� .$17�, 800 y� y]1�
* Inflated 6� annually
48
$ 80,000
35,000
1,000
20,000
16.000
$152,000
S%%2,���
, .
S
COST SUMMARY
ALTERNATIVE TWO• A CENTRAL COMPUTER IN COMBINATION WITH PCs
(Assume Implementation Is Spread Over Three Years)
ADMINISTRATIVE
�
a Hardware
Software
� Installation
c
Subtotal
1988 1989 99
1991 1992 - TOTAL
��
�
$188,800 $18,400 $ 5,200 $ 5,000 --- $217,400
33,000 39,000 13,000 --- --- 85,000
8.600 1.000 400 100 --- 10.100
$230,400 $58,406 $ 18,600 $ 5,100 --- $312,500
Hardware Maint.* 15,800 17,000 18,000 20,000 $21,000 91,000
Data Comm. Lines* 1,800 1,900 2,000 2,100 2,300 10,100
Software Maint.* 3.000 7.000 9.000 10,000 10,000 39.000
TOTAL $250,200 $84,300 $ 47,600 $37,200 $33,300 $452,600
PUBLIC SAFETY
Hardware
Software
Installation
Subtotal
$ 26,000 --- --- --- --- $ 26,000
9,600 $ 8,500 --- --- --- 18,100
1.000 --- --- --- --- 1,000
$ 36,600 $ 8,500 --- --- --- $ 45,100
' Hardware Maint.* 10,000 10,600 $ 11,200 $11,900 $12,600 56,300
Data Comm. Lines* 2,400 2,500 2,700 2,900 3,000 13,500
, Software Maint.* 7.000 7.400 7.900 8.400 8.900 39.600
!
TOTAL $ 56,000 $29,000 $ 21,800 $23,200 $24,500 $154,500
1
1
�
�
GIS
Hardware --- --- $ 80,000 --- ---
Software --- --- 35,000 --- ---
Installation --- --- 1,000 --- ---
Hardware Maint.* --- � --- 6,000 $ 7,000 $ 7,000
Software Maint.* --- --- 5.000 5.000 6.000
TOTAL - --- --- $127,000 $12,000 $13,000
GRAND TOTAL S306�00 S113, 300 ,$i96, 400 i! ��
* Inflated 6� annually
49
$ 80,000
35,000
1,000
20,000
16.000
$152,OQ0
s��
, ,
COST DETAIL
ALTERNATIVE ONE• A CENTRAL COMPUTER WITH NO PCs
(Assu�e All Implementation Begins In 1988)
ADMINISTRATIVE SYSTEM
F �ardware
� CPU with:
.
�
t
]
�
6MB Main Memory
400M8 Mass Storage
48 I/O Ports
Reel-To-Reel Tape
operating System Software, Utilities
and Compilers
4 Data Communication Line Support
5
39
8
16
1
1
1
4
Cash Register/PCs for Liquor Store
Terminals
Letter Quality Printers - Laser - 8PPM
Report Printers - 100CPS
High Speed Printer - 300LPM
CAD PC
DTP PC with Scanner
9600BPS Modems
TOTAL
Software
Word Processing
Personnel
Graphics
Desk Top Publishing
Spreadsheeting
Fund/Budget Accounting and Reporting
Payroll
Cash Disbursements
Cash Receipts
Purchasing
Utility Billing
Asset Accounting
Special Assessments
Liquor Store Merchandising
Business Licensing
Street Address/Polling Place Cross Reference
Insurance Claims Management
Investment Management
50
�
gurchase��
$103,000
20,000
27,300
16,000
9,600
5,000
4,000
6,500
6.000
$197,400
$ 5,000
5,000
5,000
1,000 (on PC)
5,000
5,000
5,000
3,000
5,000
3,000
5,000
2,000
Existing
5,000
2,000
In-House
Spreadsheet
Spreadsheet
+
�
, �
Appraisal Data Base
Property Sales Trackinq
Project Costing
Parcel Identification Number/Street
Address Cross Reference
Bu�lding Permitting and Special Use
Permitting
Computer Aided Design
Project Management
Work Order Management
Equipment Costing and Management
Streets Inventory
Project Cost Estimatinq
Warehouse Parts Inventory Control
Engineering Design Tools
Facilities Scheduling
Team and League Management
Class Registration
Inventory/Asset Management
Mailing List Management
Fourth Generation Programming Language
' and Data Base Management System
TOTAL
Data Communications Lines
Liquor Stores - Dial Up
Garage - Leased Line
Senior Citizen Center - Leased Line
Nature Center - Leased Line
TOTAL
�UBLIC SAFETY SYSTEM
Hardware
1 Reel-To-Reel Tape
1 Upgrade T.I. CPU to #990/12
13 T.I. Terminals
4 Data Communication Line Support
4 9600BPS Modems (Fi�e) .
4 9600BPS Modems (Police)
TOTAL
51
Purchase
In-House
Existinq
$ 2,500
In-House .
3,000„
3,000 (on PC)
5,000
2,000
2,000
5,000
Spreadsheet
2,000
3,000
4,000
2,000
3,000
2,000
Word Processing
10,000
$104,500
N/C
$50/month
50/month
50/month
$150/month
$ 8,000
N/C
N/C
4,000
6,000
N C
$ 18,000
r:
r
�
R
�
�
�
, �
Software
911 Data Communications Interface
Hazardous Material Fire Fighting
MFIRS Reporting
Equipment Management
Fire Management, Including Appraisal/
Street Address Data
Police Recordkeeping and Reporting
State Crime Computer Network Data
Communications Interface
Casewriter
Business Contacts
Word Processing
Spreadsheeting
Graphics ,
Case Management
Data File Management and Disk Storage
Utilization
ENFORC Report Generator
TOTAL
Data Communications Lines
{ CJIS - 2 Leased Lines
County 911 Dispatch - Leased Line
New Fire House - Leased Line
i
i
�
t
TOTAL
I
52
gurchase
$ 2,000
2,000
Existing
2,000
Existinq & In-House
Existing�
Existinq
2,000
2,000
Existing
5,000
5,000
3,500
2,000
���l�a
$ 29,000
$100/month
50/month
50jmonth
$200/month
�
COST DETAIL
�1LTERNATIVE TWO• A CENTRAL COMPUTER IN COMBINATION WITH PCs
ADMINISTRATIVE SYSTEM
�Iardware
CPU with:
5
9
20
80
16
1
1
1
4
3MB Main Memory
400MB Mass Storage
48 I/O Ports
Real-To-Reel Tape
Operating System Software and Utilities
4 Data Communication Line Support
Cash Register/PCs for Liquor Store
Terminals
PCs
Upgrade Existing PCs
Letter Quality Printers - Laser - 8PPM
Report Printers - 100CPS
High Speed Printer - 300LPM
CAD PC
DTP PC with Scanner
9600BPS Modems
TOTAL
Software
Word Processing
Personnel
Graphics
Desk Top Publishing
Spreadsheeting (15 PC users)
Fund/Budget Accounting and Reporting
Payroll
Cash Disbursements
Cash Receipts
Purchasing
Utility Billing
Asset Accounting
Special Assessments
Liquor Store Merchandising
Business Licensing
Street Address/Polling Place Cross Reference
Insurance Claims Management
Investment Management
Appraisal Data Base
53
Purchase
.�
$ 94,000
20,000
6,300
40,000
5,000
16,000
9,600
5,000
4,000
6,500
6.000
$212,400
$ 5,000
5,000
Spreadsheet Graphics
1,000
3,000
5,000
5,000
3,000
5,000
3,000
5,000
2,000
Existing
5,000
2,000
In-House
Spreadsheet
Spreadsheet
In-House
i
�
i
i
i
�
t
�
. ,
Property Sales Tracking
Project Costing
Parcel Identification Number/Street
Address Cross Reference
Building Permitting and Special Use
Permitting
Computer Aided Design
Project Management
Work Order Management
Equipment Costing and Management
Streets Inventory
Project Cost Estimating
Warehouse Parts Inventory Contr.ol
Engineering Design Tools
Facilities Scheduling
Team and League Management
Class Registration
Inventory/Asset Management
Mailing List Management
Fourth Generation Programming Language
and Data Base Management System
TOTAL
�ata Communications Lines
Liquor Store - Dial Up
Garage - Leased Line
Senior Citizen Center - Leased Line
Nature Center - Leased Line
t
� TOTAL
�
N
�
�
gUBLIC SAFETY SYSTEM
Hardware
1 Reel-To-Reel Tape
1 Upgrade T.I. CPU To #990/12
9 T.I. Terminals
4 PCs
4 Data Communication Line Support
4 9600BPS Modems (Fire)
4 9600BPS Modems (Police)
TOTAL
54
gurchase
Existinq
$ 2,500
In-Hous�
3,000 '
3,000�'
500
2,000
2,000
2,000
Spreadsheet
z,000
3,000
2,000
1,000
2,000
1,000
Word Processing
10, 00.0
$ 85,000
N/C
$50/month
50/month
50/month
$150/month
$ 8,000
N/ C
N/C
8,000
4,000
6,000
N/C
$ 26,000
� C�
�
�,oftware
1
s
,
,
�
r
;
f
�
�
�
�
911 Data Communications Interface
Hazardous Material Fire Fighting
MFIRS Reporting
Equipment Management
Fire Management, Including Appraisal/
Street Address Data
Police Recordkeeping and Reporting
State Crime Computer Network Data
Communications Interface
Casewriter
Business Contacts
Word Processing (5 PC users)
Spreadsheeting (3 PC users)
Graphics
Case Management
Data File Management and Disk Storage
Utilization
ENFORC Report Generator
TOTAL
pata Communications Lines
CJIS - 2 Leased Lines
County 911 Dispatch - Leased Line
New Fire House - Leased Line
TOTAL
55
�urchase
$ 2,000
1,000
Existing
2,000
Existing & In-House
Existing '�
Existing
2,000
500
1,000
600
Spreadsheet Graphics
3,500
2,000
3.500
$ 18,100
$100/month
50/month
50/month
$200/month
, 7♦
A
VII, S�,LT,�I�',RY OF RECOMMENDATIONS
� This section consists of a summary of our most _ significant
recommendations on improving automation at the City. Some of these
q rocommendatione are explicitly etated elsewhere in this report; '
� others are merely implied. �
o Replace the existing administrative system with new hardware and '
software. Utilize a combination of a central computer and PCs.
� � q readsheeting and certain
o Use PCs for word processin , sp
j specialized applications.
� o Retain Bome software for use on the new administrative system.�
� o.;:Equip all PCs with terminal emulation capabilities.
t
o acc�uire a PC-based desktop publishing system.
� o Reglace the PRINTS software with a set of software designed to
meet the needs of each user department. Use the computer to
simplify upaa GISg inhthe futurelto porganize a d present muchaof
I the use of
the required parcel data.
o Retain the Police and Fire software. Upgrade the public safety
� hardware with the CPU, terminals and printers from the old
administrative system.
i
� o AcquirIn e ti atelshar g hardwareaandlsoftware with the Countyy
GIS. 9
( a Do not attempt to integrate the document archivinq system with
` the administrative system.
� o Maintain a small EDP staff to manage the City's systems and
1 develop some new software.
�
56
i
gt
1
�
�
'. 1 > > � � i > > i
����; ������'�'����������.�������`�
1
1
1
1
> +� D 1 P �
Y u.w 1 N N "�
w C �+ 1 � � �
t.7 7 Y 1 N 'a m
O Q 1
U t
t
1
� � � � � �� �..�r��..��� �� � ��» �� � ���...� ��.�^ ��.� � �� � ��� �--� � ���"'� �'�
1
1
1
1 �
M 1 T
� • t a. p
T■ Y 1 � w N N
�O� w I 7 >
� Y 1 L � � ` `
67 C Y 1 a � � ^ �
A � 1 �1
L 1 4.
1
1
'� � � � , � '� � � � � � — � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � » � � � � �' � « � « � �
1
1
1
a+ 1
C 1
• 1
i M �
+� v i
� w �
� Y �
G= I
Y 1
O 1
1
� � � �.. � � — ..� � � � � � � ^ � � � � � � � � � �' � � � � � � � � � � ^ � � � � � � � � � '� " �' '� w � " '� " �
1
1
1
yJ 1
C � >
r r I L
U■ 1 � C � N N N ... N
C M � 7 > '�
w � i � � e � � _
c� i o = •a n � n n � m m
-� n i r
LL Y � LL
p 1
1
" � � � � � .� » �' �� � w � � � � � � � � � � � � � — � � � » � � � � � � � � ^ � � � � � � « � '� � � " '� '� �'
1 1
a+ 1 /
c � s� � �
•i v� � �
� i ¢ � � w
Y 1 1
6 1 1 � � � � � � � � � � » � � � � � � � � �� �� �� _� �� _� �� �� �'
1 - 1 .� � � � � � � � � � � � � � �� � .� � � � � �
7 1 1
� 1 ?� L � G)
r � .+c �
C / L.i U 1
" � �� � �� ����.������ ���� �� �����r ������w��������r �»����'���'� �"
,,,., r ^'
• > u r � v
u �' > r
� ,� � ;, a c a o c
' ` J ` � w .� �1
p M p, pi O O O Y
V � � � m ; �- U r w C M
C M r �
� + ` � � 0, � f� �+ O T
� �. . w c.a • w •
w Q `"' 9 .^� m m M m o m
�„> >. r O O L r M Y m U m �` m m
� L �I �► O �+ • C? P y M� T P
N M �F Y m O 7�+ L�r M .r C^'
A � �+ U M r m O O O �1 Ci
y 4 • C M "'� ^ � U ^ �
w �
« O O +� � C O a m C m � O m U m
r 9 O O L T •..
L a+ w Q• 1. �� � M C Y� M �F r+
� A a n Y M M7 \. M M M N
� � r Y .r y U 7 � 7 `� C� O 7
pp ,... Q ,,,� A P O P O�
d C O+� M M C• ` 7 L 7 M y M J
p. A y � L O 7 ! C O 6 � Q C � 6 L Q
m y n� �► P ... O �► d �1 A Y
• P M 9 6 7 ..r C O�r E �. C P C
/ � C �1 r+ Q Y M C O L O ++ w O�+ A O
y� M A ti s+ • G �. Y M n • b P b 7 O�
` r p + M �1 C n 7 O O�
� O L o � �/ � i O L � C C C 3 ►. C u Z C
... m > > m .+ a+ � .+ w ... ... � e •.. ..» .,
... m .+ a > r � c r r �.+ '� .+ v .+ .+ a� «
� o. .,, � • �• + o a c � r ++ r c• o .+ �
ui �-. v � ... �. > n..» w... n r �r ai r "' i� ci i
rn v c x +� •.+ c • E o a u
a w.. • x c� c� �� � v c ..+ c
y -.� C � L R.� 7.� 7 O�� �...
O. • N x C a+ � � � .w m.w C O� -•r .+
r r M Y.r > t C Y Y ++ 9 Y a+ u
* = T � „ .� � c w o c
ca ra+ ...c m� m�u >>
+ s .�'+w o � M � i cn [.r• -o o,o r o• vo
• M(..1 ••r V L O� U..+ t�
« .., y •. • w n�. -» .+ m a a
s r i ca � n a 4 � � r a r T
� Q � C M O `► O L P T y T P� !� � 4
ac 09 O�► a+ > a+�m OMOr O ++ n �+M
L C O�1 r O ,,,� .r
1 • r li � y C �+ O 7. m • � +� +'
J P -•• • � �� 111 O • 4 m6./P tf.�P •U�► U
Q r C l. L � L M L O A
K u O � • �+ w v 'o ... • P • ^ � �r ~ 7 �+ 4 L �-- �'
d r+ c .w . o � ►a. rv mt • � tc c w ..
� t �. -
Q �I A P N M 1� Y Q � A � C O� M M7 • M H y �► V M V
1 O 9 C t�I L � • = L Y• � i O O� O� C
S � � + � L M i. � M ~ Y y [fl M Y L M C Q�
O 6 �.. • �r y 10 q tl1 O T 7 01 •
K m O r b• L � M• `► • 9 C O � I 7 � L >�
W o� > � 1J t a. y C 0 C P . �/t.~ a. 7
= o, ...= vr •c �n a.o� �o� �a+ aav w� �:
� m ... 7 � .�. .+ a� • -+ �+ ��.. ¢ r... ¢ oi Y E'�+ r ! r
> O� Y Y a U M X� P C N A � a.� d.M P O� 7++ � E 9 i
� .+ C u C C • �1 •� r�..r C b ■�0 V A A V A 9 M A.w 7••+
Q 7 C �I • • 7 P • O C 7 C i L Y d L Y C� � 7 N M F-
� 6 O Ot r+a+ f Om • • Om . 7 T O Y 7 OL 01t 7� t N V C t1!
Y.' O U L r Y W (.I P L > y w = L :.� � M O M M 9 M i M 9 d � O �
Op r .-. r Z � J �+ � ! .... w... M � t W U C7
y,� • !� .r 4� > >� d � • y > i f� O r. M... M r T w ..+ M O� �
V, > �+ C � O 7 +i L • "� '�'� Y a ++ E �+ Y +� C A O C a N y O C O V� Q
• • O O L ♦ •.. O t • � O•.• � b • O� 7 O� ••r L J O 2 � O •
• G U L.1 C.t G • U�► C- y O J J V M Ll L = �! 4 O U d ti 9 4 Y � m Y. '�
m � �
. .+ N H f �ff �O f� m O� "'. ' _.. __ . .'
m
.
P
w
�
L
�
�
r
LL
6
0
0
�
'�"�' �.. ; �� � � ����� ��^������ � ���������'�������_� ���� ���
�
1
1
1
.+ C �
�...r O 1 H
�+ u �.. i �
... c r+ � m
tt 7 u � -+
O a 1
U �
1
1
� � � � � � � � � � � � � ... � � � � � � � � � � w � � � � � � � � — � » .� » � « « .� � " � '�
� � « � ; � — — � �
1
1
• �
� r i � i �
a. � u � n r� v� � r �+ •
a+ O� r 1 N � � '^ \ O � ■
... w �. � � o o �
� c... i o- m • .+ o •
�o� u >
_ � o =
�
i
�
------ � --������---------------------���_�_�_����� �---�--°----
i
�
�
.+ �
c i `
r i �
E '" i a
" 9 i e
� � � r
� • � >
n= i o
4 � _
C I
1
""�� � ����«�� ��^ �� �� �"��� ��� ������ ���� �«�»�—����� ���'�' ��'�"'
1
1
1
v 1
C � • M'
b p 1 rt • 4 L L
u i 1 f� n n m i � � Y r Y
C�+ 1 N � � .� d H D a
• L 1 � m m � � � � � D � i ■
C• 1 p� .+ w m' B O m m - M m O b
... n � • � � o
LL Y � • *
D
0 1 w 2 Z
1
" � � ' " � _ � � � � � � � � �- � � r � � � � � � � � � � " � � � " r � � � � -- w �' r � �� " � � " " �� " � '�
1 1
++ 1 1
C 1 E � IL LL LL 1L
b 1 9 1 / 1 1 1
E 1 Q 1 • � ■ +
O 1 1
L 1 1 �_ � � � � � ' � � � " � � �' � "
I1 � �' � � � �' � � � � � � � � � � � � � _ � ' � ` � � � � � �� � - � » _ �
7 1 1
Q 1 !� L 1
O 1�+ t � U U U U
C 1 GA U t
� ��� � � �����»�»��»� �� �� �� ���� ������ �����—»�����.������"' �""�.�
M
r � o a. -+
o a.•. u a r �
s .. o � m v�+ �
M C W Y m 7�► a
M � L N �► a P m 1� v
� O ++ • O O � > >
6 U m O� � P P .r O
� M u m T a L
y T�1 r 9 6 O � t� � 1� � w+
C > t O m O 9
� b 1+t s/ O ~ O !
ai P -.+ • > L �1 �. o
~�► m O L L�1 Z M C L L
Y x O C P 7 M A a M � � V r
a C'
C � C O ~ Q !+i �F t M • w w
• O f. � > a 3 Y O a� • � C �
C L.... � • �+ 7 ftl O P O � N
O w O M C n > C � � _ �
9 +► M M � � r+ 7 L A 7
� o w s o m r � r � r a > >' �'
o � r� a n c.� m a a t i.• � ++ +'
0 o r • cr v� E * r r
., .+ o c a. m r o > > r t • � �
r ... ... ... m t E � m r M �. iY +�
O� 9�1 M � N L d O !� D
V � L 7 � O > O� 7 9� * `� � a +'
� ¢�,, a ... �, .� � m n r o c
m u- � � � > O � o s c
> C Y P i r O Z C M v =
? A+ ... t �► .r > C ■ � L .� �"' � L G
m C �+ M > ..+ 7 b a b . �> S
P 7/1 O L r Y M i O n � +� n M Y M
.. o a .► r �, .. �. �- • . �. u • �
t� o .. o a. c r+ ui • a. u +'
o .• o o x E r r ++ �. o � �++ r o M � O1
t. � M r .+ � a o u �• o... a a •. > o a
•+ c �c � w a. u ++ y � c c c �+ v x • � `► �
0 0= o n o • • � � r o a. u� o. u r o �
.r .. c o �. .. m c -.. y� a w �+
o.+ a i, u c r o .. -. r+� -� a w > � x
� . o n o v v u u -. • r � �.. .r • o'
r... owo • • c .. � � ...� ...ct • � �. w .+ �
p� O .�+ �+ t .+ C n O > O .M n O�. ++ M . • C
q rl C M w O �I O � O �1 � • 1� M O N ^'
M O C• � w r+ M C t M C C .r Y• M � M r �
M L O i r t a+ � � w d r r w w M A L E L P
� ...•a, � u.-. n a u � n co r�o r
n a, ++ a. o • u r �.. � a 9 ... u > a o o e. �. n � �
> >�.... u�. o •. � � .. � av w r o a -.
v �r � • ... �. � .. • �. m a .'.: n • � a. .« o.
c� o va .ra r v o �a �. r o o r s
� w r •. � • � .. � d� o�.-. n• c .�m o
m P �I L�I O n u r � +� • n O++ .� s A m u
m p� m L tf C Y M � ! 1 �1 .r Y P/ �+ • � Q
P C O` C++ m / L � � 7 O L Y C C Y A '� n"� �
.•. �• O�► m L O C L r+ Q t L O r• 7 -.• M 'O • > 7 ♦ O
y~ >... �► N ��► r O Of 0 •�► a� O 4+ d t • � •
O Y M M O O a �► �I d Q O a C.t ��+ J S L 9 Y7 OC !�
H 4.•. .+ � t � M L 9 N . -Q ��1 C/ L C W C W a
L a Y M . L C U O r • y m 6 r �. !. C�I �1 m O� + L m O
L � L•.� L i O • C C � M m C a L w�+ 7 i M L C � = V
O 9> Y�► D O �► � L� a� �. (A O� M a+ � M■ w � • W b d W
y C� > wa+� C • / ,r ..� >U C L .••� > O M�i f.7 1+
O O a ••+ N r O >•.•. R 9 �► w r/ w A G O O� +. Y W .r
� r P n E Z > N C A
m
m
P
�O
T
L
L
a
r
LL
�. u .•• ►. v r+ � v v � r •.. � a r a
u b�► �1 �1 7 U A �. 7 O L � f� 7 7> 7 M L b b O • C M r 'r � H
, O M O O Y Q O L Gi O m G d = w 6. C A d•.. M O� 'O L.t • O � O • O 4
P
� � 1 :°. � m °; • .: er n .r — .. .. +
N N [V N N �' N h � n d
� � � � � � ' � � � � � � � � � � � � � �- _._�
a
c
O
a
Q
C
O
i
O
W
>
4
0
�
�
a
v
�
m
P
m
P
T
4
9
L
LL
w
O
>
y
U
___-- � __________------------
�
�
�
�
���
r �. o �
�+ u �.. i
w C Y 1
t,> > u �
o¢i
� i
�
�
� � � � � _ _� �� � _ _ �_ �._ �
--_�� ; —�—_
i n
i � o,
M 1 • y m O'
L r 1 • �
> r u i n n n >
� Pw 1 � O L .�
.+ y �► 1 N �• ` r �
t_t C�► 1.-. N N 7 1�
s o � •.• n c n
�c � i � ¢
� r � ra
1 N
� � � � ` � � " � � � � � � « - � - �
" � r � '' " � �
1
1
♦+ 1
C I
O I
E w 1
y � i
i L • t
w � �
nx i
u i
o i
�
i
� � _ �___������__-�-�
-- -- -- - j - -- -
� n
y 1 � O�
i C I • N m P
i �1 • 1 w � m
i Y E � n n Y7 r
C +� 1 � O L �
I » L 1 N �. � N � M
I C• 1.+ N N � V
, ... v � .-. n c n
LL O 1 • Q Q
I C 1 ♦ � �7
� � N
i i r+
i 1
� � » " � '� � � � � � � '_ � � " � � � � � � �.. � .� � �
I I I
� ,+ � 1 �
I C 1 f 1
i o i a �
iE� ¢�
i v � �
i � � �
i ... � i --�� �� _-"—"—'_--».__�__�_.
i � � �
I Q 1 T L 1
I r 1++ L 1
I 1' 1 U C] 1
1 1 1
� �� �� � �� �� � �� � « � �� � �� � � � �� � � � � � � � � �
y
` • r
r1 ..w L
C � y
... y
Y C
L 9 w
C
y r C
u � o
O
v > �► •
Y L �
> r r
.. w u u
�� c
u -+ �+ -+
Y � w
L C O L
O 0
a w N `►
c � �
• 4 C • �1 +'
O O P •
y * � P
�1 L �+ C 9
L M � ♦ N m
r .. u s
v s �
C �+ T m
�1 M G • .M m
L a� 7 111 W 0'
Y � ++ N L7 �+
� O� 4 Q
p� �I O� S O 0'
r+ 7 � 7 6. �+ C
O m O 7
a �« m r w +�
v o, r ..+ w
� m a o� r • �i �
a o, m a -. -+
M D� ! 'D 7 �
r^ r -� �v �
Y • O� iO Y
�.+ ++ C �► L C
> O � O P �J O .
L.-. L m fA ++Y
Y 6 Y P P �\.
• i C � L 7 O
o r .-. n
w ... u i v a e o r
r � c c r� r • oc
u c o r .+ w •
o +� �: a o� r � • ¢ ..
> w m + �
� � M � v o n c o� ... ...
r r« o c -+ ■ o m -. u
w n M � � O++ P u c
P Y Y +, � C �
�1 'O • O C 7 � G
� y 7 C C Q L a J O-.+
c � a � r -.� �► t4
o +� z > � ac
r n o � c ¢ ... .� n. > ao
L E r A na '+ M Q �m
• O C �1 L � • M O`
G Li w C d • O G • G.1 �+
�O f� m w !V
r i i ,
c t ,
r.
/
1
�
�
CITY OF FRIDLEY
M E M 0 R A N � U M
T0: P;pSIM �URES�I, CITY MAFlAGEk
FkOM: SHARC�1 FETTI�d6. STRFF ACCOUNTAP�T
�
SUEJECT: 1989 AWAkD FOk FiISTINGUISHEU BUDGET PRE5ENTATION
DATE: FERRUARY 17, 1°86
I have reviewed the comr�ents ;�o� the Government Finance Officers
Hssociation cancerning the 1997 Budget and the Award for
Distinqui�hed F'resentatior. The �omrents and sugqestions for
improvements are broG;en in�o 4 areas and therefore I have shown
them here ir, the sasr�e far^��t. �eiaw �re the areas ae need to
work on in order ta receive the airard. Flease keep in mind that
comments or� the IS°B E�udqet are not available. The comments on
the 1967 Fudget v:ere received in mid May o* 1488.
THE RUDGET A� A FuL?CY ��CJMENT
We nee� to outiine the qcals and ot�jectives af the City
a�d t��e �epa; ta�ert�. P;e did i�;clude ma�4qement goals in
the Eudaet h�essage c� the 19°� Budget, however, I da �ot
believe th:s wiil satisfy thei- req�irenent.
THE EUBGET A5 yP: GF'�RATI�P�S GUIDE
---------------------------------
The reviewers had numerous comments on the lack o4 comparison
of persor�rel. We a�ded a narrative on perso�nel levels to
the 1988 Eudget Me=_sage and referenced it to the Drganization
Ehart which i believe shou2d satisfy the reviewers especially
since thE Citv has a corsistent number of employees.
We neec tc� develop and imp:ement a S year �apitai outiay
plan.
TNE BUDGET A:, A FIP��hCIAL F'LA��
----------------------------- �
Thz reviepiers stated therz sho:�ld Ge a Statenent of Fu�d
Balances.
The reviewers wouid a:so lik:e to see a Debt f'olicy Statement
which "auld show bott� current ar,d projected debt.
THE fL'I'3ET A5 A �or�Mur�1�Hr1or� LEVICF
------------------------------------
The revieker= men�io�ed here aqair that we r,eed a separate,
com�rehensive statea�ent of policies ig�als, cbjectives etc.l.
.
�
��
�
Engineeri�g
Sewer
Water
Parks
Streets
Maintenance
MEMORANDUM
Nasim Qureshi,.City Manager PW88-53
TO:
FROM: � G. F1ora,�Public Works Director
February 26, 1988
DATE:
SUB.IECT: �°rewood Plaza Q�Ioore Lake �nons) Road Stu�y - JF 354
Based upon the redevelopnent and upgrac7e of the Moore Lake Cw�nons proposal,
there has been sane �noern raised regarding the traffic flow, service road
connection and highway median closure. The following is a review of
sic�if icant items pertaining to the azea:
: .� ���� • �•
L
2.
3.
4.
5.
The residential traff ic mavenents f ram this neic�borhood will
not sic�if icantly change.
MnDO►T will close the median on eighway 65 at 63rd Ave.
Rice Creek Road will be upgraded to include medians for
traffic ooritrol.
Oentral Avenue traffic will be diverted to Rive Creek Road and
Hic�way 65.
The Moore Lake Commons Development will not signif icantly
impact the resideritial nei�rhood traff ic.
�:�: I �� l:i • :�1 ��
L Do rnthing other than the prop�sed Riae Creek Road impravemer�t.
2. Eliminate the servioe drive aonnection to imprave the traffic
6 ngestion on the NE quadrarit of Riae Creek Road and Highway
��i��. 1� ��: �,� • _ 4�!: �': /
L Do No�thing (Enclosure 1)
A. Advaritages
a. Most ecbnomical prop�sal
b�. I�b apparerit change
.�-
A
�
F�DL�Y
�
� Page �ro - ii�188-53
B. Disadvantages
a. Traffic will no longer be able to turn north from
Highway 65 on to the servioe drive.
a. Traffic fran the first driveways of Shorewood Plaza
and Sears will ro longer be ab�le to cross Rice Creek
Road.
c. Southbound traffic from the first Shorewood P]�za
driveway will find it very difficult to enter the left
turn lare.
d. Westbound traf f ic f rom the f irst Shorewood P1 az a
driveway will f ind it dif f icul t to e.nter the st r aight
ahead lane.
e. Southbo�nd servioe drive traffic will experience even
more hazarcbus southbound and westboind movenerits than
the Shorewood Plaza f irst driveway.
2. Qose Servioe Drive (Enclosure 2)
A. Advantages:
a. Traff ic congestion at highway intersection is
eliminated
b. Fliminates two driveways to Riae Creek Road
c. Saf er aocess to Rioe Creek Road f ran shopping oeriter
d. Lane assic�ments are well estai�lished and provide for
�nooth flow
e. U-turn on Hic�way 65 to go mrth is safer
f. Provides additional area for shopping center use,
i e. , detention pond, parking, sic�age
g. Reduoes city road maintenanoe cnsts
& Disadvaritages:
a. c�ange in existing road system
b. Requires public acoess eas�►erit from shopping center
for passage throuc,� parking lo�t
c. Vacation of service raad requires public hearing
Page Three - FW88-53
N .•►« •,
With the �noept to divert Central Av�ue traffic to Rive Creek Road, it
is essential to provide for a safe and rapid flow of traffic onto
Hic�way 65. This is achieved through channelization and medaans. If
the concept is to work� it is essential that congestion ana saf ety
prob�lens are eliminated at the sic�alled intersectiori. Zt�is can �ly be
achieved by the elimination of the servioe road and driveway access in
the left turn lane establishme� azea. Therefore, the elimination of
the servioe road entranve, and diversion of traff ic to a major driveway
renoved fran the ir�tersecton is a satisfactory alternative.
: s,fj� Y�YI ► � : � \
Recommend the Highway 65 East Service Drive access and the first
driveway of the Shorewood Shopping Center be eliminated.
JGF/ts
� U l. _ ._.______ � l___
�
`J U `,./ �1 1 ST
� � n � 1ST
�
.
DO NOTHING
� v � - � L.-_._...J l.._
�
�nn
�
�
�
CLOSE SERVICE DRIVE
. ,,,..
,
ti:+
4
F�om the desk ot
NASIM QURESHI
CITY MANAGER'S OFFICE
MEMORANDUM JF-354
DATE: Februar 23 1988 TO ACTiON UPDATE
SUBJECT: John Flora
Development Modifications in the
Area of Hwy. 65, Rice Creek Road, �
Old Central, and 63rd Avenue
Please prepare an overall base plan and come up with all the different
alternaLives that would resolve some of the traffic needs of the area.
Discuss this with me.
We defina[ely want to have this reviewed by February 29, as�it will
be on the conference meeting agenda.
Thank you for your assistance.
NMQ/la
TO:
FROM:
DATE:
Engineering
Sewer
Water
Parks
Streets
Maintenance
MEMORANDUM
Nasim Qureshi, City Manager
John G. F1ora,iPublic Works Director
Flebruary 26, 1988
SUBJECT: MO°re Lake Uo�rmo�s Traffic Patterns - JF-354
PW88-5 4
Currently, three major actions will impact the vehicle traff ic pattern of
Rive Creek Road and Highway 65:
l. Diversion of Central Avenue traff ic to Rioe Creek Road.
2. IrhDOT closing of the Hic,�way 65 median at 63rd Avenue.
3. Upgrade of Rive Creek Road to include lane mwenent wntrol ar�d medians.
The existing traffic pattern is shawn in Et�closure 1. The Rice Creek Road
improv�nent and suggested access points are shown in Enclosure 2. The
changes involve the median closure at 63rd Avenue and the East Service Road
oonnectia� and f irst driveway at the Shorewood Shopping Center on Rice Creek
Road.
The traffic movesnents in the adjoining neighborhjood are not available.
There are 73 hocnes in this area. If you oonsider four trips per day per
haae, there are 292 trips. The two oo�mercial businesses are estimated to
geryerate 400 trips per c3ay.
If one-third of all trips were to go south on the East Service Road, this
would amant to 233 trips per day (Enclosure 3) . If the Service Road was
closed, the vehicle mavenents through the Shap�ping Ceriter would not result in
a sic�ificant increase in traffic or aongestion (Enclosure 4).
In regards to the acxessabil ity to the oonmercial property off af 63rd Ave. ,
the traffic can access through the Shopping Center, or 63rd Avenue.
Southbo�d Hic�,way 65 traffic can negotiate a U-turn at the Rice Creek Road
signal. This is a safe mavement tmder a controlled sequence. Southbound
traf f ic f rom the commercial property would probably travel through the
Shopping Center which should not substantially affect its time or movement.
In addition, it would probahly result in a benefit to the Shopping Center
busiresses. Westbotnd mwenents would be attained by travelling either r,4rth
or south. I�brth and east travel is not changed.
�F/ts ,..
�' �
�_
•
�� �
�
V
� - ._......�
1
� � =_ _ J L---
�
4
�
�,� _ _ __ � i._
� � _ K _...
r
����r�r-,
�
PROPOSED TRAFFIC PATTERNS
,.� v ` _ ._..____, —_ � � � �.
_ s,00
—__
0
0
0
0
�
F
� !1 �
RESIDENTIAL
COMMERCIAL
MAXIMUM TRAFFIC
EXISTING TRAFFIC COUNTS
J ' � l_._
� l .__-_ �
�
� n
4�
� 2500
n n r----�
FITNESS TRIPS 2000
COMMERCIAL TRIPS 500
INCREASE 2500
PROPOSED TRAFFIC INCREASE
. ,�.
�-
�
�
From the desk ot
NASfM QURESHI
CfTY MANAGER'S OFFICE
MEMORANDUM JF-354
DATE: Februar 23 1988 TO ACTIQN UPDATE
SUBJECT: John Flora
Development Modifications in the ,
Area of Hwy. 65, Rice Creek Road,
Old Central, and 63rd Avenue
Please prepare an overall base plan and come up with all the different
altern�tives that would resolve some of the traffic needs of the area.
Discuss this with me.
IJe definately want to have this reviewed by February 29, as�it will
be on the conference meeting agenda.
Thank you for your assistance.
NMQ/la
�
k�'
x
1�END 'i�: NASIM M. QORE5T3I� CITY MANF+GIIt ,
,;
FROM: WILLIAM C. A[JNr� ASSISTANT 'IO '!HE �
QTY P+Il4N�lGFR
�� : as+ � • v • �• �• � �• �• �• • �� •
u � M� : �•
II�1TE : FEBFd1ARY 10, 1988
'Ihe reoent audit of our workers' a�mpensation premi�ans for
1987 indicated that City Gbuncil me�►bers are not oovered.
Zhe way the law reads, elected officials are not oovered
unless there is a specif ic resolution or ordinanoe including
then. 7his matter has been discussed before, but to chte rx>
action has been taken which would bring the City Council
menbers �nder the workers' mmpen�tion insuranve o�verage.
Our insuranoe o�nsultant, O�rsaay Olson, has su�pplied me with
a oopy of the resolution passed by the Mahtomedi city
ao�cil menbers in F�ebruary of 1986, and I have drafted a
si.milar resolution for action by our awn City Council. I
remm�nend that this matter be put before the Cb�cil at its
meeting of Ftebruary 22, 1988.
W�/ss
13/7
�� C'. C L
�
0
RESOLUTION 86-3 _
ADDITION OF THE COUNCIL MEMBERS
TO
THE CITY'S WORKERS COMPENSATION POLICY
WHEREAS, the Mahtomedi City Council is the governing body
for the City of Mahtomedi; and
WHEREAS, in the, perf.ormance of their duties they may
inadvertently be injured; and
Z•T:EREAS, this compensation coverage is available to protect
Council Members in the performance of their duties; and
NOW, THEREFORE, BE IT RESOLVED,by the City Council and
the City of Mahtomedi that City Council Members shall be added
into the City s Workmans Compensation Program.
Dated this lOth day of February, 1986.
ATTEST:
��
MARK D. LENZ, MI ISTRATOR
�
(SEAL)
�•iOVED : Becker
SECONDED: Hinderaker
VOTE: 5-0
APPROVED:
�1,0„�, .�;G�-�-v
HENRY DE SKE, MAYOR
0
�
RESCLtTrIJON N0. - 1988
RESOLUTION AURiiORIZ ING THE INQ,OSION OF FRIDLEY CITY
QOUNCILMEI�ERS IN THE CITY' S WORRERS' QOMPENSATION
INSURAN(E OJVIItPiGE
�
WHEREAS, the Fridley City Council is the governing body for the City of
Fridley; and
WI�REAS, in the performanoe of their duties they t�dercp the risk of personal
inj uYy; and
WI�REAS, w�rkers' ar�mpensation insurance ooverage is available to elected
officials to �mpensate th�n for illness or injury stemming from the
performanoe of thei r duties;
NQ�1, gIF�2EFORE, BE IT RF5C�,VED BY �IE CITY �[JNCZL OF �iE QTY OF FRIIGEY that
henoeforth City (b�mcilmenbers shall be included under the City's workers'
vompensation insuranae ooverage.
PASSID AND ADOPI'ED BY THE QTY Q�UNQL OF TfiE QTY OF FRIILEY �IIS ___ ___ �Y
OF - --_---_ , 1988.
ATi�ST :
------------------------------------
33IRLEY A. HAAA�,LA - CITY (ZERR
----------------------------------
WII.,LIAM J. NEE - MA�COR
.:.
�
.;
' �,
Enyineermq
Sewer �.f
Water "'=`
Perks
Streels '
Maintenance
MEMORANDUM
,
,
TO: Nasim 4ureshi, City Manager iin188-44 �
FROM: �n G• �lora,�Puhlic Works Director
DATE: ���rY 17, 1988
SUB,IECT: � �king - 72nd Avenue
We have been reoeiving calls regarding the parking of vehicles on 72nd Avenue
between Highway 65 and Central. Due to the nuQnber o� m�].tiple dwellings on
the south side a�f 7�nd Avenue and the industrial facil ities on the north
side, there appears to be a parking prohlen in this area.
Determan Welding is proceeding with the installation of the cvlvert in Norto�
Creek which will then beoome o�fstreet parking for his operation. But there
still appears to be a nunber o� vehicles which are affecting the traffic flaw
an the street.
It has been proposed to plaoe 'No Parking Between Sic�s" on either side of
the various driveways to the apart�nent buildings. This would result fn over
8 si�s in a relatively short area. AocorBingly, if the Co�ncil desires, we
o�uld post the south side of 72nd Avenue as "No Parking". This would be
easier to enforoe, prwide for easier egress and ingress into the apartments
and reduce the nunbez of sicps required. If the Co�cil desires, recomanend
this item be a8ded to the F�ebruary 22 meeting for action.
�F/ts
Attac�nnents
oc: Jim Bill
/
.•:: �
FW�
,_ _ -
�, ; ; ; �:;', . -�' ' :
:. '� N�� ` i: � � � ( � :c
i , . r � 1 � .,��v��,.: r- -
> 4• -� � �� �:.�" �.� _, .� ..
a � 1��l� Irl
`��- • � � � f.11 � ,�:. � _ � 1�� � _ ! � . °+ 1
� . �
�' � "� � ' 1.L, '�v� � R � • l��i�L�t :� r �� M �r -�
.� '' , �,- j�� :� ��., i ,;� � ,, � � ' �r
Y� ' �: � �• �1' : �: �. y ,� ; !°
_ � _, �; e . ;� � � ,' ; . • _ �
�� � , ���' lC^ :� i' ��� r 1��. �• ' 1 T •�I •
� fl ' f�-�•. - �►� /' , � � ' � .tii 4
� ;' , _ '`• � . . � . �, -:v..-a. .w:.°e_ :'�Ib1;�'� rr,� � - i� - �. �
• �+•s-, - �•• v
�. � �1, � �` t - - � , ' � .
.;. ,� � � a � .{ `` � y.
�` �' � � ! � + ,� .?�1 •.,, � � j � �„ � 1 �r :v�;
�3+.�'i:s : � i � `� ..� � :���'L� ��� , �� 7 T ' rs
�-='r--'.���; � -� --•�i>i► �.�..yI��C►r...fs -=-• � � � f�✓ • 'Ei ).
�"_ _=� ��� i► . .��'l��z' . "._,_ �' `a.;�,'�tRtF T .� + /
r 1"�' � � ► �i ' � _ _ ���t �; r: 3�t�C,..:�� � � .���---- � ,:..;'-►-, �-.► -
. _�
.T � il � r —•' ��~ q� • — _"�...'� — , - — � �.r�—•� =�' S�
� � : ��� �. � , _.. .. �- Tr.��iJ - f
i �
�- � � �' �; 0.a + r .� � *`�' -;t , -.
,\� �,.'°°• �� � r� � l, �t ` , ' 1l
r : , •f ft ; i t � ' • ♦: � �. • � .�.. • !- : � ,
•� �( � , 1 ' '�•'�' � • �, �� ''
� ri.►a.,�* ;�,�,I} � ti/ � '� t � i� .. Y � .�
• " �"g � 1 � I
�T� .`►:� :iry�ft�.. 1.� � ' • 1.�1C" � .�. � .., � � !i ti
� � � +f . �j � ' k .� i��,�'i�
}-. � { �� j • •' i, 7 .�. � .
. � � � � L . .T.��..
_J • • �- �•1_
�::�c.�p :� ,� �.i �F , { �'� " t .: kC�1
�r 4p � � , ti. . �',�, ` � . �tp�,
�'L i� �* � � ��+ .. � • -r ` . . � c. • �
'� � :; t= ,,{�,� , � •: � ir ; _ i�ii!�'�"M'�
� ,;��,.` ..p �''V4ar`���� � � � ii � Jr�F i�.�y`�� j_ jf _�
� , , , j .�'t ��� _r , �`- . ;�'�' . ,,, � b
� . � , � _ ..,i ..� .,� �� , � _ � • �, ,
� � � '--- { , ..... • E �E F E �. T � �� _ :�:
r � � n =.� ' �` - —'�'"'""'*' E �,: E - - �.:' r ' �
� � �'� �� —� �A1,1E R R R {� � � ;�'.
�: g � '� ' ' L �� ���� " �p � ! C,' c� � .�'_ � i , �
4 a i� � s � � Ci �p ��^ �.
_ � �( '.;1 (i -� , -1 O T �� � �}� r _ ��.' � - 1
,t
�� ` - f . ,�� r� � �+ � ''/ �S �
y , �� " �,. � � � � � .
�, � ` � � .� � . '��� I . � `� � ►� • r '� �-� .�
� -� . � �: - _ � T " . _ � � �'' � _ :,� �;� r,s.�.
_ � ; - . -• � a
� t: ., � �~ _ . -:.
r � e i ; � •: • �`r ; . �' ' `t �
;� � i '� ' , fr�• t _ � �} - '.". . �� ' '�
� � � #� S ' �` �' '� ' � '�6 1�Y' ' '
� � ti t � y. " . .. _ a 1 T .
F R ; v , � ; �; _ � , "; r� ' -.�+� � j `� y
�� , �� � : - � . r�
�. � -�: ',' ,�y - - _ I ."r',: � . �� � }.,r.
�� . � +�1 • � �' - ; � i " ' ..a:2 !: e r ! ��.� � s-: J'� 1�
t; � �'^' . �� "c 'L!i ?y_ `
�� � = � � � i v :.. rt � ,i �; .�....Z 1S �� .' ��,�,. '� ~ + � 1 i//����`�}yy,-
�t1 �' ��+y4 �. + ♦ .R ��w������i'- �lf��l.\�,�' ,�j�,��i~.. �� ��1 .� � r
�� , �,
'e' ; l�Y�-�_� !�?.i� �T ��7�-�.��Y' �r�j�„5t3�y�yj'�'^��i-�46i� � r�• � �
_T" . ♦. ^
�!I'w�J �� \�`,� 1 � V { �
� �� �+ � .=I �a � ��`t /iJjl� � �
',�- ��n�� s��;��. I� `�t_ .� ti
� � � � ' y}, I * � ' 'i _ j ^'h��►�. _ . - `. '�!► '�,.;��,��: � � . � t � �
s- i � �!s��j� ' �'.:' -c..v t ` � - `- - .� �1t�11,;, �`"�,`ci " �`'�'1'
��-''�' ��{ y � � . . �.�+►,� � �'►
V ; i" � � ^� "..`4�� � `� � _ �� � . �,r,. r ��" � �'
> : �' . ��:- T',s�" -'-` .c r• .1N .s
t.: �. t
,i.:. -
_ - — -
- �XISTIi�G NO PARKING BETWEEN SIGNS
- ��Q���TE� t�0 PARKING BETWEEN SIGNS
't
Enflineerin9
Sewer �-
Water
Psrks
Streets
Mainlenance
MEMORANDUM
�
,
TO: Nasim Qureshi, . City Manager A�d68-39
�
FROM: Jd'!n G. Flora, rublic Works Director
DATE: Flebruary 12, 1988
SUBJECT: �1 Water Natif icatian
The F�ederal EPA has directed that each water produoer will personaliy inform
each wstaner by J�ne 19, 1986 of a p�ssihle lead health hazard within the
water system The prohlen stems frcm the use of lead pipes or lead solder in
the resideritial a�pper tubing systems. �e municipal system does not have
any lead items.
Nvtive can be prwided in 1 a� 3 v�rays:
L Newspaper rntioes published monthly for 3 mrnzths a�mnencing on
J�ne 19, 1988.
2. Mailing individual rntioes with the water bill or any separate
mail ing by Jine 19, 1988.
3. Hand del ivery by June 19, 1988 to all a�staners.
The states have the notioe and enfor�nent responsibil ity for the mandated
requirement. 2l�e State Deg�rtrnent o� Iiealth should be ooming out with some
guidelirns this month. �e enforvement a� the requirenent is levied on the
State and may result in the withholding of S percent of the State Program
Grant Fluicis. Zt�e City's threat would be in a misde�neanor class action suit
initiated by a resic3er�t for failure to ir�form then.
The American Waterworks Associati� has prepared a special bill stuffer on
the lead item. Orc3ering of the bill must be accompl ished by F�ebruary 29,
1988. The aost o� the bi11s would be approxin►ately S2, 000. 00.
Based upon the sensitive issue and the nunber af calls that this item could
result in, I would re�mnend the City opt to pu4lish an article three times
in the Fridley Fbcus ao�nencing on Jine. �e article a�uld inoorperate the
mandated items identified by the state. If this is not agreeable, .then we
should orc3er the AWWA bill stu�fers as a reasonahle means of satisfying the
federal requirenent.
�
JGF/�s �
FWDI�Y
-.�
TO:
FROM:
DATE:
SU BJ ECT
�
�
Engineenng
Sewer
Water
Parks
Streets
Maintenance
MEMORANDUM
Nasim.Qureshi, City Manager
C��J
Clyde V. Moravetz, Cable Coordinator
February 26, 1988
Proposed Cable Television Franchise Ordinance
PW88-58
The Fridley Cable Television Commission, at their 4:30 p.m. a�eeting of
February 23, recommended approval of the Cable Television Ordinance draft.
The recommended revisions of the Commission are in the process of being
incorporated in the ordinance draft and should be available Within txo Weeks.
The majar issues have been resolved. $oWev r. the eable ooerator has
ind{cated to the ConLmission that they vill be seeking a reduetion in nenaltv
amounts from the CouneiL
In summary, the major issues that have been addressed are as folloWS:
1. ����omer Service Re,�eentativeslPhone lines. An earlier
draf t of the ordinance set forth a minimum nusber of incoming
telephone lines and a minimum number of customer service
representatives. For a variety of reasons, Nortel found
those requirements to be unacceptable. The Commission and
Nortel agree it Will suffice to state in the franchise that
the company �ill maintain an adequate number of incoming
telephone lines and an adequate number of custoaer serv ices
representatives.
2.
Rebate Poliev. Copies of Nortel's rebate policy �ill be
provided to all subscribers. The Com pany agreed to a
provision in the franchise ordinance whereby the rebate
policy will be distributed to Fridley subscribers on an
annual basis.
3. Franc ise Severabilitv. Nortel has agreed to this section of
the franchise ordinance. In short, this section states if
Nortel is, by virtue of legislation, administrative ruling or
a court decision, a1loWed not to provide the access ehannels,
the access grants or pay a franchise fee, the company must
give notice to the City and state Whether it will comply �aith
the franchise requirements or avail itself of the
legislation, administrative ruling or court decision. If the
cable television operator inPorms tbe City that by virtue of
the legislation, administrative ruling or court decision that
it Will no lor�er provide the access channels, the aceess
grants of pay the franchise fee, the City may, Withi n 6
months of the notice, terminate the franchise.
/
�
FWDL�Y
�
�- Page Tt,ro - PW88-58
;
�
1}. ?nstitLtiona� Network. The company is willing to provide the
necessary equipment at the headend to aecommodate seven (7)
channels on the institutional network provided the City
accepts the company's language regarding the customer service
representatives/phone lines described in paragraph 1 above.
It is my opinion that the company's offer to provide the
procesors for seven (7) channels to be a reasonable proposal.
5. Renewal Costs. Nortel has agreed to reimburse the City for
all costs incurred in the renewal process.
6. Addressable Converters. It is the company's intention to
provide addressable eonverters to only the pay TY
subscribers. One coneern that we have had is whether this
Will preclude the Basic Service subseriber from receiving
pay-per-view programming. The eompany proposes that we state
in the franchise that pay-per-view programming will be made
available to 'Basic Service subscribers only' on reasona ble
terms and conditions. In addition, the company will detail
in its operations report to be submitted to the City by
October 1 of each year how sueh programming is being made
available. I believe this is a reasonable approaeh.
7. penalties. As I noted in page one of this memo, it is my
understanding that representatives of the company want to
review the penalty dollar amounts with the Couneil. The
Commission feels the amounts, as noted in the ordina nee
draft, shoulci not be redueed.
8. Tests. The proposed cable television franchise ordinanee
requires that the company conduct certain tests on an annual
b2sis. Mr. Weaver has suggested that the company be required
to iest on an annual basis for all those technical standards
set forth in Exhibit B. It is my understanding that the
company is willing to agree to N.r. Weaver�s request but would
like to clarify certain points with Mr. Weaver. In
particular, the requirement that the audio signal level on
each channel shall be maintained at �.1 vu. I will be
meeting with Nortel and Mr. Weaver next week to resolve this
issue.
There have also been a number of other issues that have been resolved. I am
enclosing various corresponriences that will further illustrate what those
issues were. The correspondenees are as follows:
1. Letter from Matz to Abrams dated 2-3-88 regarding Commission
comments.
2. Letter from Abrams to Matz dated 2-9-88 regarding 2-5-88
meeting.
3. Letter from Matz to Abrams dated 2-11-88.
4. Letter from Matz to Hammerstrom dated 2-18-88.
G
� Page Three - PW88-58
�
Nortel has agreed to provide access agrants of $60,000.00 at the time of
acceptanee of the franchise -$60,000.00 by 3-1-93 and another $60,000.00 by
3-1-98. These amounts will be adjusted to refleet inflation in aecordance
with the ordinance Section 6.08, Paragraph D.
Exhibits D and E to the ordinanee dealing with equipment available for public
access use and loeal origination equipment available f or publie access use
will be cospleted as soon as more information is provided by Nortei.
The City Gouncil may wish to set a public heaxing on the proposed or dinance
at an early date. I suggest they set the public hearing for April �F at their
regular meeting of March 7.
CVM/ts
Ansiw• E. HEassr
DA.11EL D. TxuE
GARY R. Mwrz
ToK Toces
REESE E. CHSZICR
JoEL D. Rwra
PwvL D.Dovs
RICHARD A. EMERICH
KA7HLEE�7 A. HEANEY
( �
�
� �
HEBBST 8c TAUE, LTD.
ATTOENEYS AT LAW
9S0 vORTHLAND P1AZA
3800 WEST 80TM STREET
BLOOMII�GTOIv, MINNESOTA 85431
TELEPHO�E �612) 893-6711
Mr. Ronald L. Abrams
Attorney at Law
Fifth Floor
TELECOPIER
(612)893-6991
February 3, 1988
701 Fourth Avenue South
Minneapolis, Minnesota 55415
RE: City of Fridley, Minnesota
Our File No. 86-0102G
Dear Ron:
LBCeL Asstsrwxr CA'Iti'
ANN M. �L►THENS
TELEX
The Fridley CATV Advisory Commission met on the evening of
Tuesday, February 2, 1988, to review and discuss the proposed
cable television franchise ordinance. I have set forth below
certain comments and suggestions raised by the Commission. I
would suggest that after you have had an opportunity to review
these comments that we arrange a meeting in order that we can
finalize the Ordinance.
For your information, the Commission is scheduled to meet on
Tuesday, February 23, 1988 to review the Franchise and make the
appropriate recommendation to the City Council. According, it
will be necessary for me to distribute the revised Ordinance to
the Commission on or about Wednesday, February 17.
The comments raised by the Commission are as follows:
1. Section 4.03(C) requires that the company individually
notify all residents affected by proposed underground work prior
to commencement of that work. The Commission is concerned that
any notice be done in writing and in a timely manner.
Accordingly, the Commission proposes to state the notice must be
in writing and at least one (1) week prior�to the work.
2. Section 5.08 addresses Signal Quality. The Commission
requests that the last sentence include the concept that the
sound is undistorted and of a consistent level.
3. Section 5.09 addresses the Testing Compliance
Procedures. Burt Weaver and the Commission discussed paragraph
(B) at length during the course of the meeting. The Commission
requests that paragraph (B) reads as follows:
��
HERBST S�c THUE, LTD.
Mr. Ronald L. Abrams
February 3, 1988
Page 2
�
These tests shall be performed at not
more than six (6) locations approved by the ,�,
City.
In addition, the Commission requests that paragraph (C) read
at the second sentence as follows:
If more than ten percent (10�) of the
locations tested fail to meet the performance
standards, Grantee shall undertake and
complete corrective measures and report what
corrective measures have been taken to the
City. The entire test shall be repeated for
the locations.
Finally, the Commission proposes that paragraph (D) state
that the company may conduct this testing under an approved
alternative procedure. The results of the testing shall be
submitted to the City with the Operational Report required
elsewhere in the Franchise.
4. Section 6.02 addresses Pay Television. The Commission
wants to incorporate the concept either here or elsewhere that a
subscriber must take Basic Service in order to get Pay
Television. Many years ago the cable operator allowed
subscribers to take only one or more Pay Television services.
5. Section 6.06 Institutional Network. As you know, we
need to discuss this particular Section in more detail.
6. Section 6.07 addresses Access Channels. The
Commission appreciates and understands the company's plan to
realign the access channels to conform with the regional channel
line-up. At the same time, the access entities are concerned
with stability. Accordingly, we must address this issue. I
believe it is appropriate to set forth what channels the PEG
access channels will be carried upon followinct realignment and
state that any change thereafter requires City approval.
7. Section 6.09 states the requirements with respect to
Local Origination. First, in paragraph (A) the Commission
requests that we clarify the fifteen (15j hours of programming be
Fridley produced programming. In short, simply strike the word
"locally" and insert the word "Fridley". Finally at paragraph
(B) the Commission requests that we clarify the company will
continue to provide personnel and equipment for complete coverage
of the City Council meetings at no cost.
�
HERBST Sc THUE, LTD.
Mr. Ronald L. Abrams
February 3, 1988
Page 3
�
8. Section 7.01 contemplates the Construction Tinyetable.
Under paragraph (8) the City has forty-five (45) days to receive
a written report from an independent engineer. In order to
provide adequate time for the City to make the necessary
arrangements, the Commission requests that we include a sentence
under which the company will give the City sixty (60) days
advance notice of the completion date. This, in turn, provides a
window of one hundred five (105) days to receive the report.
9. Section 7.08 contains the requirements for
Undergrounding of Cable. The Commission wishes to clarify that
previously installed aerial cable shall be placed underground at
the Grantee's expense when both the telephone and electrical
utilities convert from aerial to underground construction. As we
discussed today, the Commission appreciates and understands your
concern with the HRA issue. Please submit language to me that
will address your concern with respect to the HRA issue.
10. Section 8.02 requires that Communications with
Regulatory Agencies be submitted to the City. The Commission
requests that responses be furnished to the City within fifteen
(15) days of receipt of the response. Accordingly, the reference
to "an expeditious" manner would be deleted.
11. �ection 8.07 contains a periodic inspection process.
According to Mr. Weaver the numerical scale set forth in
paragraph (D)(3) should actually be reversed. According to Mr.
Weaver, then number "5" represents the best picture with "1"
representing the poor picture.
12. Section 9.04 sets forth certain requirements for
Subscriber Complaint Practices. The Commission is willing to
accept the company's proposal with respect to the requirement for
specified telephone lines and customer service representatives.
This, as you may recall, relates back to our previous discussions
on the Institutional Network.
13. Section 9.05 sets forth the requirement for a
Subscriber Service Agreement. It is my understanding that Nortel
contemplates revising the current Service Agreement. We would
propose that this Section be retitled Subscriber Service
Information. The company may then provide the information to the
subscriber in any manner that the company deems feasible. This
may be through a subscriber service agreement or other -_.•
informational packet. In addition, the Commission requests that
an item (H) be added which would set forth the contact person�_�jt
the City. The Commission will review any Subscriber Agreement "
�—.r'
(
�
HERBST Bc THUE, LTD.
Mr. Ronald L. Abrams
February 3, 1988
Page 4
�
for compliance with the Franchise but this does not include
"approving" the Agreement.
%
14. Section 9.06 contains certain requirements with respect
to the Subscriber Billing practices. First, at paragraph (B) the
Commission requests that the concept of thirty (30) days advance
notice be incorporated into this paragraph. Next, with respect
to paragraph (D)(2) the Commission proposes that the late charge
not exceed Fifteen Dollars ($15.00).
15. Section 9.08 is intended to address the Annual
Subscriber Survey. It is my intention that this survey would
address the following:
A.
B.
C.
Signal quality
Response to subscriber complaints
Whether the services meet community
needs and interest
It is my understanding that Nortel would like to do this
survey through a telephone survey. I have reviewed this with the
Commission and our primary concern is that there be meaningful
assurances that the telephone survey was, in fact, done.
16. Section 12.04 sets forth certain conditions under which
the City may acquire the System. The Commission believes that
any purchase of the System upon a franchise revocation shall be
done at book value.
17. Exhibit A contains at (A)(6) a requirement for
addressable converters to be provided to all subscribers
requiring a converter. The Commission continues to believe this
should be a requirement. The Commission would, however,
entertain an alternative proposal from the company with respect
to this issue.
18. Exhibit B sets forth the technical standards for the
subscriber and institutional network. There are several comments
with respect to Exhibit B. First, Burt Weaver has suggested that
paragraph (A) include language stating that the standard apply
equally to the institutional network. Next, the Commission
requests that standards for the audio signal level be set forth
similar to paragraph (B) which sets forth the requirements for
the visual signal level. Burt Weaver has offered to assi�t on
this issue. Third, the Commission has requested that we delete.
the parentheticals presently set forth in paragraphs (G) and (J).
��
HERBST 8► THUE. LTD.
Mr. Ronald L. Abrams
February 3, 1988
Page 5
� �-.
This is based upon the perception that the NCTA is not a
recognized authority for setting forth specifications. Next, Mr.
Weaver has questioned whether paragraph (Q) is complete $s
presently drafted. I will be reviewing this with our engineer
and would welcame any comments you might have on this. Finally,
the Commission wants to include a general statement that the
Grantee will comply with all technical standards issued by or
established by any state or federal regulatory body.
Ron, those are the comments and
CATV Commission. After you have had
these comments, please contact me in
a timely manner.
GRM:dl
cc: Clyde Moravetz
Keith Cripps
Mark Hammerstrom
suggestions raised by the
an opportunity to review
order that we can proceed in
Very truly yours,
Gary R. Matz
FE•8— �9—�� TUE 1 T:06 L01`1G
, � (-- �
Ro�ald L. Abrams
Attorney at [,aw
Fif�h Floor, 901 Fourth Avenuc South
Minne�palis. Minnesota 554�5
FeDruary 9, 1988
Gary R. Mau, Esq.
Hecbst & Thue, Lid.
954 Norihland Plaza
3800 West 80th Street
Bloomington, Minnesota 55431
Dear Gary:
'��e
n. •
i
F . E+ �
612/338-],9:9
or
b12/Sa6�535b
The purpose of ihis letter Is to provide you with information you requested
at our meeting on February 5, 1988.
The language to protect the cable operator for situaiions similar to the HRA
probiem faced by Storer would be as folfows. lnsected before the �ast
sentence in Section 7.08 shovld be this sentence:
In the event that telephone or electric utilities are reimburseQ by
City or any agency thereof for the placement of cabie underground
or the movement of cabie, Grantee shait be reimbursed upon the
same terms and conditions as ibe telephone or electric utilities.
You invited Nortel's proposal regarding the provision of addressable
converters. I�iark Hammerstrom wrote a letter to Clyde Moravetz dated
january 11� 1988 in which that issue is thocoughly discussed. At the Fr'sdley
Cable Commission meeting on January 21, 1988, representatives of Nortel
also discussed that Issue at length.
Nortel wii! provide an addressable convertec to all customers subscribing lo
any monthly pay tel�vision service. Further, Nortel will wake pay-per-view
service available to "Basic-oniy" �ubscribers on reasonab!e terms and
conditions, Nottel will � require a subscriber to subscribe to a monthly
pay televisian service In order ta ceceive pay-per-view programming.
Nortel will inform the City in its arinuat report due on Aprii 1 of each year
and in its operations report due Octobec 1 of each year of the terms and
conditions upon which pay•per-view programming is available to "Basic-
onfy" subsaibers. �
FER- .9-��+ TIJE 1 T: QT LOMC �
.. . f � �
Gary R. Matz, Esq.
Febcuary 9, 1988
Page 2
P.63
Nortel does not know, ai this time, how it will market pay-per-vlew product
!o its "Basic-only" subsaibers. The pay-per-viea market �s very dynamic,
and numerous marketing approaches are being tried In the cable telev�slon
;ndustry. The F�tdley re-build will be cowlt be fuc hertdeveloped, andS
anticipated by thai time industcy trends er-view in
Nortel will have haQ some e�perience eiperimenting with pay-p
Btoomington. Nortel will keep the City informed of its plaas.
Customers find ihe addressable converter very inconvenient in comparison
with either cable-reaQy equlpment or the current converter�. Indeed, part
of ttie reason for the pay tetevislon drop-off Norte! has ezperlenced is
directly related to the Qrovislon of addressable converters to p�ayeale aisiofl
subscribers In Bloomington. Bloom�ngton subscr�becs have dr pp p Y
television service either to keep their curre�t converters or to retain the !'ull
use of their "cabie-ready" equiproent. Noroctel'sleze er ence and xperience of
ihe needs of its customers. Based upon N P
other operators in the Twin Cities, ihe provlsion of an addressable convertec
to subscrib,ers not desiring pay television services or pay-pef-view servlce Is
eztremely user-unfrlendly and will result in the alienation of many ot'
Nortel's customers.
The final lssue I wish to discuss is the definitiori of "Compiaint" and the
requirement to retain a written log of comptaints. The calls Nortel receives
faiis roughiy into two categories. Pirst, cails relatin8 to service. Second, calls
of inquiry. As to calls relating to service, as I understand ihe draft
Ocdinance, Nortel woutd be required to retaln a record of al4 reports of
outages as well as a11 calls requiring a�ovide the City a summary oPtnewe
situation. There woutd be no need to p
connections� disconnections oc change or secvIce activities. Nortel curcently
cetains an outage ceport as well as a!1 service related caUs. Nortel currently
provides the City with a summacy of all outages as well as a summary oi all
service-related calis on a monthly basis. For outages affecting more than one
subscriber, Nortel dces not retain a 3og of ali telephone calls reporiing the
outage. onty ihe ovtage itself. For reasons of prlvacy, Nartei dces not and
aiil not provide ibe City a listing by cuictRO elated cali s1 etained by Nartel
however, a record by cvstomer of secv
and is avallable for City inspection. It is me�vlce calis is�aaeptablei to the nt
ceporting method relat�ng to outages and s
City.
�r
• ♦. • • � .
Gary R. Matz, Esq.
February 9,1988
Page 3
�
As to calis of inquiry, the City wishes to requlre that all calls objecting to
Nortei's business or programming praciices be logged. That is currently
Nortei's practice. Nortel informs those callers that their objection is belAB
fogged and their objection wiil be provided to the City.
Finally, the City aishes to require that all calls cequiring subseqvent
investigation or research be logged. It is that requirement whlch Nortel
finds vague anQ very difficult to implement. Th� requirement that all calls
requiring subsequent investigaLion or research be logged wiii literaliy
require that Nortel employees retaIn a iog of ali telephone calis ihey place
back to customers for everyihing but scheduling service. Quite ofteri, the
employee who can answer the subscriber's inqviry IS either on another
telephone r,alt or otherwise unavailable. The call back aould be "subsequent
investigation" and, under the deflnition of "Compiaint" contained ln the draft
Ordinance, would have to be logged. Nortel requests that the definition of
Compiaint be amenQed to delete the term "subse uent tnvestl ation or
researc . �
I undecstand that you wlll be preparing another draft Ordinance reflecting
chang�s mutually agreed upon to this date. If I can provide you any further
information, piease feei free to contact me.
tr
Ronafd L. Abrams
Attorney at Law
cc: Geraid J. Kazma
Keith Cripps
Mark Hammerstrom
,
Ronald L. Abrams
Attomey at Law
Fifth Floor, 701 Fourth Avenue South
Minneapolis, Minnesota 55415
�
February 15, 1988
Gary R. Mau, Esq.
Herbst & Thue, Ltd.
950 Northland Plata
3800 West 80th Street
Bloomington, Minnesota 55431
Dear Gacy:
612/33&1979
or
612/546-5356
The purpose of this letter is to respond to your telecopy of February I 1,
1988 relating to the annual subscciber survey as well as the telephone call
from your secretary concerning the technical standard for audio.
The provision relating to the annual subscriber survey is acceptable to Nortel
ezcept for the phrase "statistically reliable measures". While a written
survey can be sent to a sample base which would yield statistically reliable
results within certain confidence parameters if all in the sample base
responded, the fact is that not all who receive the sucvey will respond. This
will yield a skewed response base which will not provide a"statistically
reliable measure" of subscriber preferences or satisfaction. Therefore, Norte!
would request that the word "statistically" be dropped in favor of the word
"reasonably".
Second, I have discussed the proposed audio standard with Keith Cripps.
Keith informs me that the proposed standard would be impossible to meet
and will discuss this issue directly with Burt Weaver. The Vu measurement
constantiy changes during norma! conversation.
I will be out of town until February 22, 1988. I would be available for a
meeting that afternoon if that is necessary.
,�. .
-�:
Gary R. Matz, Esq.
February 15, 1988
Page 2
Yours ry truly
!
Ronald L. Abrams
Attorney at Law
cc: Gerald j. Kazma
Keith Cripps
Mark Hammerstrom
.,
�
ADRL►� E. HEBHST
DA�IEL D. THUE
Gwai R. Mwrz
Tors Toces
REESE E. CHE2ICB
JoEL D. Rwra
PwvL D.Dova
RICHARD A. EIiERiCA
KATHLEE\ A. HEA�IEY
�
HEEBST 8c TIiUE, LTD.
ATTORNEYS AT LAW
9S0 NORTHLA:`D PLAZA
3800 1tiEST 80TM STEEET
BLOOMINGTON, MI�iNESOTA 85�331
TELEPHOrE (612) 893-6711
TELECOPIER
(612)893-6991
February 11, 1988
Mr. Ronald L. Abrams
Attorney at Law
Fifth Floor
701 Fourth Avenue South
Minneapolis, Minnesota 55415
RE: City of Fridley, Minnesota
Our File No. 86-0102G
Dear Ron:
�
LEdAL ASSISTAYT C!lTV
A.�N M. MATHENS
�
TELEX
I wanted to take this opportunity to follow-up on the
meeting of last Friday, February 5, 1988, at which time Keith
Cripps, you and I reviewed my letter of February 3, 1988, to you
as well as your letter of January 28, 1988.
Based upon those discussions on Friday, I have set forth
below my understanding of our discussion with respect to each
issue. The numbered paragraphs below correspond to those
paragraphs in my letter of February 3, 1988.
1. It is my understanding the company proposes to provide
door-hangers forty-eight (48) hours in advance of any work. This
notice would also include an employee and telephone number to
contact in the event the property owner has any questions. I
believe this is a reasonable approach and will so advise the CATV
Commission.
2. It is my understanding that the proposed language is
acceptable.
3. It is my understanding that the proposed language is
acceptable.
4. It is my understanding that the proposed language is
acceptable.
5. With respect to Section 6.06 which addresses the
Institutional Network, it is my understanding that:
�
HERHST Sc THUE, LTD.
Mr. Ronald L. Abrams
February 11, 1988
Page 2
�
A. The company will provide the
necessary headend equipment (i.e. processors)
for up to seven (7) channels on an as-needed`
basis when the user is prepared to use a
channel.
B. The company will consult with a
user to ensure compatible equipment.
C. The City and Grantee shall arrive
at a mutually acceptable allocation of
channels on the institutional network.
D. In the event a user desires
additional headend equipment the user-may
acquire such equipment and the Grantee shall
maintain such equipment at the Grantee's
actual cost. Clyde Moravetz has suggested
that the.Grantee be responsible for
pur�hasing all equipment at the headend and
that the user then reimburses the Grantee for
the purchase price.
E. The Grantee shall be responsible
for all equipment damaged by the Grantee.
6. It is my understanding that we will prepare an Exhibit
to the Model Ordinance which will designate the channel locations
for the public, educational, governmental and library access
channels. These services may not be moved to another channel or
channels without the prior consent of the City; provided,
however, that the City must object to any such move within sixty
(60) days of a request by the Grantee or the City's consent shall
be deemed to be given. In addition, no such City consent shall
be required if the Grantee is required by federal or state law to
carry another service on one of those designated channels.
7. Based upon our discussions, I propose that we leave the
word "locally" in the Ordinance. It is my understanding that the
language proposed in the final sentence of this paragraph is
acceptable to the company.
8. It is my understanding that the proposed language is
acceptable.
9. As I indicated, this concept is acceptable to the CATV
Commission. It is my understanding that you will be sending
language with respect to this provision.
� .� _ . � �
� HERBST � THUE, LTD.
Mr. Ronald L. Abrams
February 11, 1988
Page 3
10. It is my understanding that the proposed lang�age is
acceptable.
11. It is my understanding that the proposed language is
acceptable.
12. It is my understanding that the proposed language is
acceptable.
13. It is my understanding the proposed concept is
acceptable to the company. It is my further understanding that
an item (h) will be added to set forth the contact person at the
City including a telephone number.
14. It is my understanding the proposed language is
acceptable.
15. I will send proposed language for your review.
16. It is my understanding that the company will not accept
any franchise containing a provision whereby the City can acquire
the system upon a franchise revocation at book value.
Accordingly, I would propose that the purchase price upon the
revocation of the franchise be at an equitable price. This
provision would then be consistent with the Cable Communications
Policy Act of 1984 and, accordingly, neither the company or the
City will be waiving any right that it may have.
17. It is my understanding that you will be sending a
proposed alternative to the addressable converter requirement.
18. With respect to Exhibit B it is my understanding that
the technical standards will apply to the institutional network;
I will review the audio signal level requirement with Burt
Weaver; we will delete the references to NCTA contained in the
parentheticals in paragraphs (G) and (J); and that you will
review paragraph (Q) with Bruce Thompson.
The following paragraphs are in reference to your letter of
January 28, 1988, to me.
l. It is my understanding that you will be reviewing the
records with Mark Hammerstrom to determine whether Sections 3.06
and 9.04(A) are still an issue. Please understand that in my
opinion it is very important that we have a definition of what
constitutes a"Complaint" in the franchise.
� , .
,-
,
' HERBST bc THUE, LTD.
Mr. Ronald L. Abrams
February 11, 1988
Page 4
�
2. It is my understanding this is no longer an issue.
3. To the extent this remains an issue, please provide
language for my review and consideration.
4.
5.
I am in agreement with your comment.
I am in agreement with your comment.
6. This concept is acceptable to the CATV Commission.
Please contact me with language that would be acceptable.
7.
8.
I believe this is no longer an issue.
I believe this is no longer an issue.
9. I will provide this language for your review.
10. As I indicated, the penalties will remain as requested
by the CATV Commission.
Ron, please contact me should any of my understanding set
forth above not be correct.
GRM:dl
cc: Clyde Moravetz
Very-truly yours,
/
Gary= R. Matz
�
�
,/
:,D81A\ E. HERHST
DA�lEL D.TaLs
GARY R. MATZ
To�s Toaws
REESE E. CBEZICA
�TOEL D. RATH
PwcL D. Dov$
RICHARD A. EMERICA
KwTHLEE� A.HEw\EY
HERBST Bc TFiUE, LTD.
ATTOE\ EYS eT LAW
9S0 �ORTHLA\D PLAZA
�800 M EST 80*■ STREET
BLOODSI\GTO�, MI�NESOTA 55�`�l
TELEPHO�E (612) 893-6711
Mr. Mark Hammerstrom
System Manager
Nortel Cable
350 63rd Avenue N.E.
Fridley, Minnesota 55432
TELECOPIER
(612) 893-6991
February 18, 1988
RE: City of Fridley, Minnesota
Our File No. 86-0102G
Dear Mark:
LEGAL ASSISTA\T C�►'R'
Aicv �S. MATHE�+S
!
It is my understanding that Ron Abrams is out of town until
February 22, 1988. Accordingly, I have enclosed for your review
and information a copy of the cable television franchise
ordinance which I am having delivered to Clyde Moravetz today for
distribution to the CATV Commission. I have mailed a copy
directly to Ron Abrams' office.
I do want to call several provisions of this enclosed
Ordinance to your attention. Those provisions are as follows:
l. Section 6.08(e) contains a new sentence stating that
the company shall continue to provide, free of charge, office
space at the headend for an access organization. It is our
understanding from the original Nortel proposal that intent was
to continue to provide the same office space.
2. Section 9.07 contains a requirement that the company
will advise subscribers in writing on or before October 1 of each
year of the company's rebate policy and credits for the outages
of service. In Ron's absence I have inserted the date of
October 1, however, I am certainly not opposed to any other date
that would be more convenient for the company.
3. Exhibit A continues to contain the requirement for
addressable converters. It is my understanding that the company
has submitted an alternative prcposal to Clyde Moravetz. Since
this issue requires a policy decision on the part of the CATV
Commission, I have left this requirement in place. I assume this'=-_ .
will be discussed in detail at the meeting on February 23.
.:, .
� HERBST �c THUE, LTD.
Mr. Mark Hammerstrom
February 18, 1988
Page 2
4. Exhibit B contains a paragraph (c) which states that
the audio signal level on each channel shall be maintained at
4±.1 vu. This particular standard was proposed by Burt Weaver.
I have been advised by Ron Abrams that Keith Cripps has,certain
objections to this proposed standard and will be contacting Mr.
Weaver directly. Accordingly, I have left this particular
standard in the Exhibit pending further discussions with Mr.
Weaver and the Commission.
5. Exhibit C sets forth the channel locations for the
access services. As you will note, the Exhibit at paragraph (a)
states that within ninety (90) days of the acceptance of the
franchise, the access services shall be carried in accordance
with the following schedule. I assume that the company will want
to realign the channels to conform to other Nortel systems.
Accordingly, Z have assumed this would be done within ninety (90)
days of acceptance of the franchise. I would be most willing to
entertain an alternative schedule if that is desirable from your
standpoint. Finally, we need to set forth the specific channel
location to which those services will be moved.
Mark, I simply want
your attention. I assume
Monday, February 22. In
questions, please do not
GRM:dl
Enclosures
cc: Clyde Moravetz
Ron Abrams
to bring those several provisions to
that I will be visiting with Ron on
the meant�me, should you have any
hesitate to contact me.
Very truly yours,
\
ry R. Matz