Press Alt + R to read the document text or Alt + P to download or print.
This document contains no pages.
HomeMy WebLinkAbout1984/02/15 - Agenda Packet - RDAf
15
RCrry
AKJHO CUCAWNCA
REDEVELOPMENT AGENCY
AGENDA
Lions Pnrk Community Center
9161 gaee Linn Road
panrho Cucamonga, llio:nia
Yebruar 15 1984 - 7000 •m•
1, CALF
Dahl , Frost =_+
A. Tall Ca110 S,hloo cr and�els r -
Schloesor �+
g, Approval of Hinutes. November 16, 1983
1, CONSENT CALENDAR
Calendar eme are expected to be
ine and
J They g I. oraent ic
Thill be eeced upon by
The
thetCouacil atnonentimeovlthouc discussion'
33. STS 2
HAlUCEHENT SYSTEN FOR ` e
HODEL AND _ AccompaaYing
A. FISCAL �E�pHgHTATDEYAR -NT atom will
COWi fieeal so e1 computer sy
Community Development Dapartmenc'a
reeo®endacion on a
be a review of the �nagnmanc
de ca management
needs and a recommendation for the
future intugratlon of or overall data
system.
4. ADJOURMENT
• Nprnhr 16. 1967
[
CST[ OF IANCW COGMONCA
AIDE9tlDPtim ACQCt MINUTE!
regular wettne
1. CALL lb OADQ
A regular meeting of the Redevelopment .%eect of the Ctry at 4otho Gcssdnga
was hold In the Uon. M[k c se-It7 Center, 4161 gas. u" goad, am wed nudy.
Now.ber 16, 1967 ID. uettaJ vu called to order at 7106 pea, b/ w7ot Joe
D. wt.ls.
r[esedt were Alo tr mmebenl CM rise J. 6u4uy if. uthard N. Dahl, Millip
D, Scblo.ear. and Motor Jan D. hikeb.
Montt Agony sober Jar. C treat who bad taken his wile to the hospital.
Also present wares 4ot.tive Dlrectdr. u.re4 if Varurue; Cosmiy
Dowolopaeet Director. Jack us. w legal touse.I o. pretdet.
Approval of Minute., wet were .4Datuad for appf ... 1.
J. 043QT CAL CAI
M ttus had been submitted en the Consent Glead.r.
J. STASt "MITI
A. UPDATE ON SHE SINAINUAL FW. An ml report was presented b1 the
Gam unto. uo 7 a yes. FGnAIe.
Iva Wavelet ..A Agodcy received and filed the report
4. ADJOC'WI[NT
NOTIONI Moved by Do%l. seconded by Schlomr a ed Journ the meeting. 'boom
.ar7 d 4 -1 -0 (rrost absent), the goting .d Jaurned a SIIS pa.
M.oectfalll tub.itud,
Scary Amthalet
M.utaat Secretary
x
d CITY OF RANCHO CUCAAIONGA
REDEVELOPMENi'AGENCY
STAFF REPORT
•
DATE: February 15, 1984
TO: Members of the Redevelopment Agency
FROP: Jack Lam, Community Development Director
BY: Tim J. Beedle, Senior Planner
SUBJECT: DATA PROCESSING STRATEGY AND RECORDATIONS
AdSTRACT: This report presents two issues:
1. The specific recommendation to purchase the micro computer for
the fiscal model (as described to Council several months ago).
2. A recommmendaticn on a strategy to tie together all the now
separate data management efforts into a unified system.
BACKGROUND: At the time of preparation of the financial plan scope of
wor , t was known that a computer was necessary to run the fiscal model
and funds were allocated for this purpose. However, it was decided not
to purchase any equipment until the Financial Plan consultant had an
opportunity to overview the data management system seeds of the
department and to suggest a strategy for tieing together the various
separate efforts into a unified system for data management.
As Council may recall, aside from the financial plan and fiscal model
efforts, there is the following:
A. A separate effort to develop a base mapping system for Rancho
Cucamonga. The current base map system is fully inadequate and
Inaccurate and because most of the department's work evolves around
mapping information, poor maps means inefficient work. The County
and surrounding cities either have or are converting to computer
diaitized mapping systems. This fiscal year's budget allocated the
first phase of a three year program to provide an accurate mapping
system Since the Hater District also is interested in obtaining
s.
0
U
Redevelopment Agency /City Council
Subj: Data Processing Stratrgy and Recommendations
February 15, 1984
Page 2
such mapping, staff has been working with the District to define its
specific needs so that a sharing of costs might be had if the
mappinq needs of both agencies were complimentary and the mapping
arrangement mutually acceptable. These discussions have evolved to
a point where a decision needs to be made on such a mapping system.
B. Also budgeted was a very small amount (left over from the
Redevelopment budget) to begin a parcel base data system that would
allow the unification of attribute data (currently in numerous
separate document files) with a permit tracking system. This
program also was a multi -year function.
The decision to initiate these programs was to develop better data
management to increase the level of efficiency and provide better
service. Within the next several years most titles will have in place
or be in the process of developing automatic tracking systems and data
management systems, (DMS). Since incorporation of the City, San
Bernardino County has digitized all mapping for County areas. 1-ring
the last two years, the City of Upland has digitized its city. our
City, having now initiated these programs, needs to consider the
following question: Should these systems' separate programs be
interlinked to provide a more powerful tool for data management? A
unified oMS will provide assets which include the following:
o Further implement the procedure of a single permit tracking
function.
o Lessen the staff requirements to perform mapping functions and
maintain mapping records
o Provide staff with the means to sophisticated analytical
functions which previously have been provided by services of
others with computer capabilities
o Enhance the inner department coordination of development
activities.
o Provide instantaneous public information.
o During increased development activity, will provide timely
record keeping functions that will have payoffs of better staff
allocation, resources and timely reporting information.
o Better decision making and management.
ANALYSIS AND ENDINGS: Appendix I contains a survey of DMS needs and
Appendix H summer zes our preliminary investigation of small systems
that could possibly meet cur needs.
Appendix III contains the consultant's recommendation for the Fiscal
Model Computer and overview of implementation strategy for integrating
Lath mapping and parcel based systems.
1
•
Redevelopment AgencylCity Council
Subs. Data Processing Strategy and Recommendations
February 15, 1984
Page 3
The following is important to the consideration of an overall strategy:
1. There is no one existing system which appears to contain all
the functions necessary for servicing all operations
2. It is not necessary nor possible to have a system which meets
all data management functions at once. Characteristics of a
data management system should be designed wound the most
immediate and accessible data base needs with the phasing in of
the system
3. Other cities' previous experiences to the development of DMS
has shown it is necessary to provide for both system
flexibility and growth over time.
4 San Bernardinu County currently has some services such as
mapping and parcel information that might be utilized by the
City to help augment a local system, thus saving on duplication
of both cost and hardware -- also potentially providing the
City with services to maintain information on a routine basis.
11) S. Consolidation and unification of WIS has immediate and long
range benefits over incremental development.
Since the County has a mapping system, both software and hardware, it
seems prudent to explore .iith the County the feasibility of the County
providing digitizing of maps and related services on a contractual basis
assuming the County is competitive or less expensive than comparable
private contracts. Our own data maps can be done in a compatible format
and thus can interface with county information resources.
The City should then obtain concensus with Cucamonga County Water
District on mapping cost sharing, combine resources to maximize what we
can do this year and begin digitizing basic mapping coordinates quicker
than if we implemented first phase mapping alone Additional coordinate
data can then be added with Phase II (second year increment)
Other ,jurisdictions have separate parcel base and permit tracking
systems. These, while useful, have baen fragmented and do not use the
same systems therefore resulting in mote difficult data interaction. A
unified system would cost no more, and probably much less, than separate
systems. San Bernardino County, like other jurisdictions that oegan
with seoarate systems, is currently undertaking a costly study to unify
current separate systems with its map base. It would be prudent then t,,
begin at the onset establishing a unified parcel base and permit
tracking system to avoid future duplication and conflict. Such a forn:
could implement a cco,dinated software program to incorporate the
functions of mapping, parcel attributes and permit tracking into a
single program and design a hardware system.
I/
O
ReGevelopment Agency /City Council
Subj: Data Processing Strategy and Recommendations
February 15, 1984
Page 4
It would be prudent to pool the resources of the separate multi -year
programs into a single multi -year planning effort so that withir 3 years
the OMS would be complete and interrelated,
RECOMMENDATION: Since the primary timing and costs have not been fully
eve op3iednd will take sore additional stud,/ and interaction with
vendors, the following is recommended:
1. Approve the strategy (not any specific program or fund
allocation at this time).
2 Establish an ad hoc Council task force to review and refine
proposals (costs and programs) with the staff.
3. Seek a proposal from San Bernardino County regarding use of
software and hardware services for mapping system and interface
of OMS. Seek consensus with Water District
4 Seek proposals from vendors regarding software /hardware system
for a unified OMS.
5. Unify the funds from the separate programs so that when the
system is complete, it will be unified.
6 Proceed with the purchase of a microcomputer for the fiscal
model as recommended by the Financial Plan consultant which
will be integrated with the OMS. The systems should be funded
from the Financial Plan &.count at a cost not to exceed
$10,000. Purchase of a microcomputer system designed to run
the fiscal model and work with the OMS would avoid the costly
duplication of conversion of their program to another operating
system. The microcompter can serie as a terminal for the full
OMS system later on.
It is important to note that the data processing needs for Rancho
Cucamonga is vital to the health of its future iperations and if not
implem;:,.ted early in its development will never ichieve capae:ity for
excellence In performance or service
Re ectfu}y submitted,
® Community Developmen rector""'--`
JL:TB:Jr
5
0
Redevelopment Agency /City Council
Subj; Data Processing Strategy and Recommendations
February 15, 1984
Page 5
APPODIX I
DAT MANAGEM
erA e are n ume ENT NEEDS
rous functions completed by Planning, Engineering and
Building and Safety which can be either totally operated as DMS or can
be supported by DMS functions. These include the following;
Planning
o Public information
o Development processing and tracking
o Project analysis, i.e., project suitability to site
characteristics
o Code enforcta,ent applications
o Record update, i.e., maps, revisions
o Special studies, i.e., land use studies or specific plan
o Demographic analysis, i e., housing information, Block Grant
Analysis
o Fiscal planning, i e., the fiscal model, tax increment finance
• and budget information
o Section management
Engineering
o Pudic inquiries
o Permit i.,uance
o Project tracking
o Project inspection, i.e, the coordination of public works
activities and the input of project information
o Survey checks, i.e., review plans for coordinate geometry,
perform analysis for curves and closured adjustments
o Ilydroi�gy analysis; i.e., drainage calculations and flow volume
analysis.
o Traffic analysis, i.e., traffic volume studies and traffic
projection.
o Capital improvement planning, i.e., budgeting and project area
analysis, inspection management.
o Mapping
o Section management
Building
o Public inquiry
o Permit issuance
o Permit tracking
o Mapping
o Project inspection, i.e., maintaining records on a daily basis.
u Inspection Information.
o Plan checking, i.e., calculation of structural features, energy
calculations.
0 Section management
lJ
Redevelopment Agency /City Council
Subj: Data Processing Strategy and Recommendations
February 15, 1984
Page 6
Based upon the Inventory of tasks within each department there are five
functions which characterize overall department needs which relate to d
computerized DMS.
1. Development Process Trackinq - Development prccass tracking is
a method�'or an automate management filing system which will
follow the progress of any project from the time of inception
to completion. It can be useful for public inquiries, for dal!
update on status of projects and for overall reports on
activities within the City. Some programs of tnis nature t-are
been developed to also serve as the application, for exampie,
the system offered by Professional Services actually provides
an application procedure by asking questions for completion of
the application form and computing necessary calculations.
Thus, the application would then be followed throughout the
completion of building permit process. It would also store
inforration in the dally reporting of permit inspection. This
example could be applied to any other development application
process which the City uses. This system could be used for
assisting in the development application process. This
function Mould include supporting the application and file log
entry, and fee calculatiuns scheduling, coordination with
approval conditions, inspection act vines, capital
improvements, and automated update of City records and maps.
Parcel Inventor S stem - The parcel information includes
innumera a attr ales w ch could be identi`ed for each parcel
such as assessor number, owner, name and address, situs
address, parcel value, zoning, special districts, any active or
past projects approved, any special easement or service
requirements for that parcel and special conditions associated
with the parcel, i.e., flood plain designation or on a trail
easement. The parcel besed system would provide an aggregation
of attribute information that is now scattered among different
document files
3. Map in and plotting function - This is the preparation of
over 1-1 y base maps uv iv ed `rom recorded and survey
information. The City at rime does not have an oveall
coordinated base map system napping function would serve
to provide an automated system which could print maps with any
number of parcel or area attributes for City or public use.
This funrtlon can be used with overall studies for specific
project areas in addition to detailed City map atlas necessary
for plan check and public works applications.
`)
Redevelopment Agency /city Courcil
Subs: Data Pricgeessing Strategy and Recom:tndat•ons
February 15,
Page 7
The mopping and plotting boundariesiswithin the City. This
actual digitizing Of
digitizing process is the recording of parcel boundaries,
street centerlines and easements and includes overlays such as
zoning, geophysical and planning boundaries. This process once
recorded then identifies each parcel by number and various
attrbuts. file i for e
eachlParcel ,u for lexample, dzoning boundaries attribute
could be
easily transferrd to the digitizes CIL,r base map and then by
electronic coding, each parcel identified per its zoning
boundary. Any other boundaries, such as' school parcels r as. could
all be geographically transposed to the
rindividual ddatai entry ocesTherefore, theonplotting functior
includes not only the actual mapping of lots but provid ar
simply d cost e!giboundariestonthe moasterdigitizedrtmap. f1k
q, re4a 'fecal sofp. sicaled there are
engineering and mathematical calculations, statlztica
• analysts, and other miscellaneous analysis for any particular
project.
5 ti"Fe computerin with feasibilttyanalyslsnw111
become an important tool for project planning, budget planning.
and tax increment analysis. This function is supported on th,r
fiscal model program.
W]
Redevelopment Agency /City Council
Subj: Data Processing Strategv and Recommendations
February 15, 1984
Page 8
numerGous d^ partmenta' noperal: ionssthatr can demploy a iautomatedfunctioning,
"UNITY DATA GMANAGEMSNT NEEDS
TABLE I
Pro ect arce app ng In a yt cal T --Z
ions Plotting functions Planning
SECTION OPERATIONS
`.
'! P ann n
Inquiry
x
x
x
+ u c
Oevel. Processing
x
x
x
x
x
x
Project Analysis
x
x
Code Enforcement
x
x
Records Update
x
x
x
x
x
Special Studies
x
x
x
x
x
Demographic Analysis
x
x
x
Fisca, Manning
x
x
x
x
+ © Sectio Mgmt.
x
Engineering
Public Inquiry
x
x
x
x
Permit issuance
x
x
Project Tracking
x
Project Inspection
x
x
x
Sur••ey Checking
x
x
Hydrology Analysis
x
x
Traffic Analysis
x
x
x
Capital Equip Ping
x
x
x
x
Section Mgmt,
x
Building
Public Inquiry
x
x
x
x
Permit Issuance
x
x
Permit Tracking
x
Project Inspection
x
x
t Plan Checking
x
x
Section Mgmt.
x
J
f
9 ,
19 Angus (McDonald & Associates
21505hamuk Avenue Betk¢ky.Ca'wU94704 .i - v ,z 4
Telephone 14151548 5831
MEMORANDUM i,3,:)la?IIiL??:i;,'leiiQip?s
DATE , January 16, 1984
TO t Jaek Lam, Director of %:ommunity Development
City o£ Rancho Cucamonga
FROM t Scot He Mende and
Angus N. McDonald
SUBJECT, Recommendattons for Computer Selection
Public Services 6 Facilities Financing Plan? 1752
cc The Land Economics Group
1 • SUMMARY
We recommend that the Cit} of Rancho Cucamonga, Department of
Community Development, immediately purchase a microcomputer
capable of running the fiscal mrdels and performing other
Planning functions. This microcomputer can communicate with the
Finance Department computer. The cost of acquiring the software
and hardware is esttmated at $8,500. The purchase will consume
imm weeks.
ediately, the Department t willubehinvolvedoinshands ton
processing of the fiscal models used in evaluating the Public
Facilities project.
We also recommend a Plan that addresses the longer -range major
data processing requirements of the Department (i.e,, parcel
information
of acquiring rthe i software andchardware coulda rangey from T$75,000
to $150,000 depending on system selection Department staff time
of roughly 2000 hours should be allowed for systems reviev and
data entry. The system could be on -line by July, 1985 The
following steps are required to implement this plant
o Appropriate a portion of the 1987/84 and 1984/85 budget
alloca eons to a Computer Acquisition Fund
o Define internal systems and paper flow for each application
o Prepare specification for a request for bids
G Compare bids and select the optimum configuration
O Prepare a multi -year purchasing plan
Pknnsg ManLwment &snonou /
A major step towards implementing the Department's long -range
data management plan can begin immediately. Assuming that
earlier favorable indications are confirmea during final
negotiations, a contract can be executed whereby San Bernardino
County produces base maps for Rancho Cucamonga.
II. DATA PROCESSING REQUIREMENTS-- C0:4:1UNITY DEV. DEPT.
The Community Development Department of the City of Rancho
^jcamonga has requested that McDonald 6 Associates review the
Department's data processing requirements and advise the
Department of the approp:late procedures for meeting those
requirements. Our review begins with the understanding that the
Department's requirements are of two distinct categoriesr an
immediate capacity to use the McDonald a Associates fiscal model
and a longer -range capacity to improve services by improving
access to data.
Software
Fiscal Model
The fiscal . nodel that Is being used as part of the Public
Facilities project will enable the Department to test the fiscal
impact and financing requirements of alternative land uses. The
modeling framework allows apid testing and provides clear docu-
mentation and reproducibility of results.
The fiscal modeling software written in OASIS -BASIC and OASIS -
EXEC langua Je is available to rho City at no cost from McDonald i
Associates. Conversion of the model (if necessary) to other
"dialects" or languages could be performed for a cost of $3 -5
thousand.
2. Parcel Data Systtm Information Retrieval
A Parcel Data System is any system of data storage and data
access that is keyed to the Qarcel of land. Since the major
functions of the Community Devs o—C pment pePartmc.it deal with
information about parcels of land, a parcel data system must be
the basis for the Department's mid -range and long -range data
Processing program. This decision was ranched early in the
evaluation by Department staff and Consultants. The decision to
recommend a parcel data system was confirmed after Department
staff visited other jurisdicitions and saw demonstrations of
parcel based data processing systems
Certain data are common to virtually any parcel data system
(e.g., assessor's parcel number, land area, General Plan
designation, zoning code, use code). Other data (e.g.,
environmental characters s ticu) may or may net be present
depending on the design of the data system and the uses to which
it may be applied. The common characteriatics of effectively
designed parcel data systems include
o the capacity to access all relevant information about a
Particular parcel, preferably "at the counter" while an
interested party makes an inquiry or while a decision is
being made
• A justification for the parcel data system that includes
supportive on -going administrative functiors (e.g., admini-
stration of the building permit revtew process) rather than
merely having access to data "for planning purposes"
• Ability to access other parcel based data sot (e 9. those
maintained by the o� unty Assessor) without maintaining a
duplicate copy of these data.
o A capacity to update the data base as part of ongoing
administrative procedures rather than requiring "massive
data gathering" efforts.
Given the number of parcels currently in Rancho Cucamonga and the
anticipated growth, it can be anticipated that the Community
Development Department's data system will eventually deal with
over 100,000 parcels, with perhaps 250 characters of information
per parcel. In addition, the ability to provide rapid
information retrieval as well as to provide capability for
analysis suggests that high speed access to the parcel data will
be necessary. These requt.ementc exceed the practical capacity
of an 8 bit microcomputer. Fortunately, as discussed
subsequently, a wide range of computer hardware and software
alternatives are available to meet the Department's requirements.
Hardware
L. Invantory of Current Hardware
The Finance Department recently acquired a Wang LVPC 2200 mini-
computer. The computer has 12 non - expandable serial access ports
(i.e., connections for terminals, registers, printers, and
modems). None of these ports are available to the Community
Development Department. One port is used for a printer, one is
used for a cash register, and the remaining tun are dedicated to
terminals. Nine of the ten terminals are currently utilized by
the Department of Administration and Finance 711e tenth terminal
would be utilized by a newly authorized accountant position.
This comput •.r cannot service any additional users during normal
operating hours. Off. -peak operation is unsatisfactory to the
Community Development Department given the on -line demands at the
information counter.
upThe City also owns several dedicated word processing machines
(including three at the Community Development Department). The
3 ))_
Central Processing Units (CPU's) on the word processors cannot
directly support the software models herein discu.sed. However,
the terminals to the word processors can be connected to a
minicomputer (via a. communications package) t++at enables direct
data input into the parcel data system.
2. Fiscal Model iiarewaro Heeds
The fiscal models are designed to be run on an 8 bit OA.:ic
compatible microcomputer. A high - volume, high speed "hare disk:
storage device is required. (The term "hard" disk is in contrast
to rho description of "floppy" disks which are often used for
microcomputer applications.)
Alternatively, these models could be run on any other hard disk
computer of similar or greater capacity. For example, in the
future, the fiscal models could be run on the computer that also
runs the Parcel Data System. The differences in ,rogramming
language would almost certainly necessitate a conversion of the
model
Parcel Data System and :lapping System hardware Needs
The parcel data system requires substantial software and data
storage on hard disk. Cataloguing and displaying one hundred
thousand parcels requires a powerful c omputer (i.e., more
powerful than an 3 bit microcomptiLOr). Especially important is
operating speed -- accessing records with an efficient indexing
file organization.
The mapping system requires massive software storage on hard disk
(i.e., about ten MB). The disk capacity speci£ica Lions must bear
this fact in m =nd. Of extreme importance, the Department must
decide, in advance, the best overall. scheme to run the system •-
mix and match will not work For e•iample, it would be
unacceptable to use a parcel data s /stem written for a Digital
Equipment Computer in conjunction with a mapping system written
for an Hewlett Packard computer aril finally purchase an IBM
computer.
III IaNEDIATE NEEDS - STAWO -ALONE MICROCOMPUTER
The Department should immediately proceed with purchase of a
microcomputer capable of running the fiscal models (without
conversion) and providing sproadsheet modeling capability. If
the -dpartment uses the bid process, the Request for Bids should
be preparel as shown in Exhibit 1.
"he rationa)a for acquiring a stand -alone microcomputer is as
oli iwse
o No current equipment is available to the Department.
o The fiscal models do not need to interface with the parcel
)3
data system.
• o An Oasis compatible microcomputer avoids the cost of model
conversion
o A microcomputer augments Department computer capacitI., i.e.,
backup word processing, and spreadsheet ,nOdalin
O Immedtate g.
Purchase of a microcomputer offers the opportunity
to h Land iponeeXnerienconsultanrs' current fiscal analysis
with rands- p
O An Oasis compatible microcomputer is available with software
for designing "screens ", i layouts for data entry and
data display. These screens would provide an essential
analytical tool for specifying data requirements and system
flow For the parcel data system.
o Purchase and use of a microcomputer offers the computer
experience helpful in specifying a larger and more complex
minicomputor for use u:lth the parcel Data System.
o Terminals used with the microcomputer can also access parcel
data information from the minicomputer.
IV A PLAN FOR COORDINATIt1G PARCEL INFORMATION
The Department has observed the operation and capabilities of a
variety of parcel data system
System, s The search for a Parcel Data
Mapping System, and minicomputer must proceed
simultaneously. The following paragraphs Fresent the consultants
recommendations for defining the Departnent's computer nL,ds.
A. Data Grouos
The concept of a parcel based data system has been accepted by
the Department, but a detailed system design has not been
completed. The first stop to designing the overall system is to
define who needs what. Certain data is relevant only to specific
deparrmenc decision makers and should be segregated m
presented to the public -at -large or data
tndividual parcel o from
Other data are relevant to a mapping system only. Exam
suggested in the following paragraphs. Pies are
Beginning at the individual parcel owner level, the Department
could design a screen showing the relevant data items
screen is shown in Exhibit 2, screen would provide the
variances etc. . A sample
This
parcel owner with updated information regarding zoning, lot size,
, The screen could be displayed on a terminal or
printed onto hard copy
At the public -at -large level, the Department could design an
output displaying aggregate data. Thus, An interested party
5 k
iY
EXHIBIT 1
REQUEST FOR PROPOSAL
Computer System for Fiscal Modelling
City of Rancho Cucamonga
Department of Community Development
The City of Rancho Cucamonga hereby solicits bids for a computer ,
system to provide fiscal modelling capabilities. The system should
have capabilities as followr•�
CENTRAL, PROCESSOR 180 or equi . ant microprocessor (2808 preferred)
with minimat of 64KB RAM (two user 128KB
optional).
Minimum lOtiB (formatted capacity) Winchester type
BACKUP DEVICE Tape cartridge (( inO rte+•• �j {iY�i Wj'4_
P a 9P•
CRT TERHINAL One terminal with green or orange on black
display
(14" diagonal preferred), detachable low profile
ergonomic keyboard, function keys, numeric pad,
screen tilt and swivel.
PRINTER Dot matrix with 150+ cps draft mode and 40+ cps
correspondence quality mode. Strong preference
for printers rated at < 60 dBA.
OPERATING SYSTEM Oasis.
SOFTWARE TMHA Control Toolkit Runtime License
S Utilities: Reorg (QIS) and Squeeze (QIS)
Lexisoft Spellbinder
Automated Spreadsheet
Multi -user Oasis (optional)
The bid price should include 10' cables to the printer and terminal.
The system must be provided with all software installed and all
equipment prepared for immediate operation requiring only the
connection of cables and power lines. Basic start -up tapes and
printer ribbons should be included.
Preference will be given to configurations with the following
characteristics:
Low ambient noise
Long warranty period
Expansion capability to a second terminal
Small physical size
Ergonomic design
G
EXHIBIT 2
0
fors PLANNING.SCREEN
,
COti•fROL Screen
Docunentor
5
6
7
3 4
0.. .... 0. ... S..
0 .......
9
0 ....
.........0.
Cl . .
9
. .
q
9
9
9
9
9••
q
9
4
INFORMATION
DATEW)
9
9
9
9
PARCEL
DATA FOR
01•t ;7E
9
9
PLANNING
4
q
99
9
9
9
9
K1• PARCEL
NU:taER:
q
9
q
q 9
S
9
I
4
9
q
9
q
2. STREET NA14E:9
I
4
I,
STREET NUMBER:
1
q
9
q q
q
9
9
3•
4
ZIP CODE?
I
4
9
9
9
5. BLDG. SIZE (SO
FT):
(911pRV)s
4
q.
LOT SIZE
(ACRES):
7. ASSESSEgO VALUE
q
B•
ASSESSED
VALUE (LAND):
9
9
4
q
q
9
q
9. ACTUAL US Es4
4
q
B.
ZONED USE: 4
q
q
q 4
4
9
q
q
9
q
q
9
q
q 4
9
q
q
9
9
9
9
9
9
4 4
9
9
q
9
4
q
9
9 q
9
9
q
q
9 q
4
q
9
9
q
q q
9
q
9
9
q
4 9
9
4
9
9
q
4
9
..... .
.... . ......
E
I j;o
r 1
L J
could be provided with acreage and land use data for a planning
area. Similarly, other vital statistics could be readily
available upon request.
Special data screens could also be designed organizing data for
the specific use of department decision makers. This sensitive
data should be presented separately frcm the data screens
requested by individual parcel owners or the public -at- large.
B., Mannino Canabilit
n ripping system would require a substantial investment in
spatial printers, software, and larger capacity hardware. The
Depirtment should continue to investigate alternatives to in-
hout, capability. Theae alternatives would include contracting
with the County for map production and maintenance, contracting
with a software firm to maintain the required data on their
comprier, and contracting for non - computer generated maps to be
drawn on an as needed basis. The costs of each of these
alternatives should be weighed against the dynamic needs of the
Department.
C. Selectine Software
The exercises outlined above in Sections A and B are essential in
the process of refining the search and selection for the optimum
software system. In the absence of clearly defined needs,
vendors and software firms would present a range of products
broader than necessary -- requirinq rtaff to undertake the task
of comparing apples and oranges With needs clearly defined, the
search avoids wasting time examining models that are designed for
purposes not relevant to the Department. Software companies
would offer tailored presentations that demonstrate their
abilities to deliver an appropriate software system. Department
staff could then directly compare the ability of each system to
perform the specific needs of the Department. As an additional
consideration, software products must be judged against the
software support offered by the firms.
In practice, each software system is usually written for a
specific computer. The costs of acquiring the hardware should be
viewed as part of the package deal offered by each software firm.
coo
3i.a i.11
IaIWAiIN MITI[
• 0all MCCISSIK S)5it
11wit O"
Trfl Or
C0KPuILIt
COST
rOMCTINS
Wits; D PARCEL.
horrlf0 [Sit SYSTEM
D(1nO wxr AMIiSICAI
SMACKING IAGINIIAIAG
CDWENIS
uec.
QtNW
N1t Carlin
7 ifnlmll
N,SOD
Intnf.ts 1410111[) with Ignl.'s f)ttm
S .NIq
W
4Ntmla
!17.31,000
t i 11.ItN
t t1ulN
.Sets is Nrrfntl) 61N at $J. CawU
1011 A
ft w
M
a LVIcad LINgd 11 mw . n . utn
Sfo tro
Ca Call
1,000
W functlw
A1nal.t.1
.V~ w smltss .101, plo.l.lq
taoo all.
"SA)
sool
5.500
.Cella D. uW.dN b .Ill Wall I.W n11
wft Corm.
Cal Coq
f .111. A.rLVr W f.11tl.q ftorN data
5)u. ImfIvrUlm sw. n . ftPdal.
flaltw
i7, 000
,AInN "Wtleq has IIIItN stool
SyIYU[
A.00rtlnl
t, 000
Mostly
G.Om
Ingm.wtn9
6,000
019102"1
11 /lot
M;.1 �AANAAE
LNDlllllf
Mrrlllt flQ V1
1390.011.
If5A1
M )000
I I c .5)stm t1 In gwltlan at than ld.
N1t Carlin
7 ifnlmll
N,SOD
Intnf.ts 1410111[) with Ignl.'s f)ttm
wyt"L
s2s•10.000
Mtnn is s.11 1gtN1tN V
.ICO Orooasw
ft w
M
a LVIcad LINgd 11 mw . n . utn
Sfo tro
W functlw
A1nal.t.1
p .Could of Mat" .nand City Lads
"SA)
sool
5.500
.Cella D. uW.dN b .Ill Wall I.W n11
wft Corm.
f .111. A.rLVr W f.11tl.q ftorN data
S, nt) M•ep11/ Los,. I a lielUp .0191tllll gmtoss am all W o." mgaltln
0ata Mw9.•.nt farts, Ibfol, UVQ. .
tµVOnl. Iw SIM C .CWnI) will smrldf [.FIG Iw u1 plottlnq
laws", +sap 1110 City
s nq .caasi alts grorla wNt. tv.Na en .vu,
hrtel Data as in
IN Tom plm .m d"nct IIMM N Alamo, all fit*
an f.I.M,S.
Olgttlul fl•f /l Dt
E
/P
Iniq
Ixnl enf mlY
Planer 6241
Ifcwl Mls
112 4100
.40
Ixut/l4tp'nq
[uunulu
rl.at.r u4s
s2alo,aaq
•
Ilitter
f1J.14,000
WNW
fYppinq
vocal eat.
sot. Still
Ss, 000
In CAM'.
Data Entry
Iv.."Inq
11I.511et
JIInat
r7Tu IISO
165,100 c
J R'f'f
24,000
Owe,. etc.
CAI CGW 0101
10,200
Ilettm
19,015
G"Mic car
7,000
WNW
Info nbtw Il,llwo
Data sate eq.t
Int /lcnq, to.=
I.A.0 Ie,300
Mwgf 10,000
Ina t. /Tmq 10,000
Gn�m s[Wr 2,aw
0
A
1
!9
J .IOC.I otw If ton nv4lerw fv Ie.Q
. Srft" vlll a IMgrftw .Iti wpinq wetlne
.Nmp101 f~. Mi Am .104 fp. i MIIt
fv prl.ate mplMxl.q tM pl+mlrq .xJ
.5nt- Ns sew mgl,..rlp upwllltY
t lb1[fG t sot. is vf1Y peyffvl
.acs fell Innpnnan of JI /WCUeM
.S.e Cwoty Mt fjGnxNd cmwltmt to m
4t WY for tMir 0.11.11 nfwi
.Mn afm .fw In atom 1121.,
.Sot" It n all v mtnlnq W"Ach