90-18 Generation 5 Technology - GIS Software Purchase (GEO/SQL)C9o-~i~
d _ , „ 7
Kodiak Island Borough
~_.
-~~,4,,°
~r±'` MEMORANDUM
DATE: July 20, 1990
TO: Kodiak Island Borough Assembly
THRU: Jerome M. Selby, Mayor
~/
FROM: Linda L. Freed, Community Development Department Dire to
RE: Request for Assembly authorization to purchase Geographic Information
Software (Geo/SQL) from Generation 5 Technology.
BACKGROUND
The purpose of this request is to obtain Assembly approval for a computer software
purchase costing more than $5,000 in accordance with Sections 3.16.020 and
3.16.070A of the Borough Code. The cost of Geo/SQL software is $9,500 for the first
copy; each additional copy is available at a reduced price. The funds to purchase this
software are already budgeted in the Data Processing Department's FY91 budget. The
program is intended to be used in the Community Development Department, as well as
in the Assessing Department and the Resource Management Office.
Geo/SQL is a geographic information system (GIS) that has recently been developed to
function with AutoCAD using personal computers. It also has the capability of
intertacing with the mainframe computer (IBM AS400). At this time, the Borough has
seven employees that have been trained or are otherwise qualified to work with
AutoCAD, however, only the Draftsman is doing substantial work with the village and
urban base maps that were originally digitized several years ago.
Geo/SQL is presently aone-of-a-kind program (as required in Kodiak Island Borough
Code Section 3.16.070A). All Borough AutoCAD users and Data Processing personnel
agree that the Geo/SQL program is the best option to extend the value of the existing
digitized maps to all AutoCAD users. In addition, Geo/SQL will allow people without
AutoCAD skills to combine information from the Borough's mainframe computer with the
Geo/SQL Software Page 1 of 2 Assembly: August 2. 1990
~ y ~ it "j .. "r
Memorandum dated July 20, 1990
to the Kodiak Island Borough Assembly
from the Community Development Department
Page Two
digitized maps by simple queries. The output can then be plotted without the need for
making large map and data files on a personal computer.
Use of the existing digitized maps has been slow, due to hardware limitations, as the
complexity of information being mapped has increased. AutoCAD is a computer aided
design program which provides for fast and accurate maintenance and plotting of maps
and other drawings that have been digitized. The program is limited however, in that
digitized drawings do not contain any information that is not physically digitized. If a
special map is required, for example, for a comprehensive plan or some other purpose,
it can take the draftsman as much time to digitize the necessary information as it would
take to do the task by hand. The benefit of a GIS is that maps can be created by any
AutoCAD user from the existing base maps without time consuming digitization. Maps
can be recreated periodically as the mainframe and graphic databases are updated.
Attached is some information on the Geo/SQL program and information relating to
Geographic Information Systems generally.
REQUEST /PROPOSED MOTION
Staff requests authorization from the Assembly to purchase up to three (3) copies of
Geo/SQL software -one copy for the Community Development Department, one for the
Assessing Department, and one for the Resouroe Management Officer.
Should the Assembly agree with the staff request, the following motion is appropriate:
Move to authorize the purchase of up to three (3) copies of
Geo/SQL software at a cost not to exceed $21,375; the
funds will be expended from appropriated monies in the Data
Processing Department and Community Development
Department budgets. This purohase is exempt from the
bidding requirements of Chapter 13.16, per Section
13.16.070A since the software is a "unique service."
Geo/SoL Software Page 2 of 2 Assembty: August 2, 1990
i ; ,,
GEOPROCESSING APPLICATIONS FOR
LOCAL GOVERNMENT
Automated pperatlons Planning Tax/
Mapping License
Public
Plpe b Street Work Orders;
Irnentories; Maintenance
Schedules;
Excavation
Works Network Maps:
Computer-Aided
Complaint
CapNailmprovements Permits; ROW
UssPermits
Design 3Engineering Treckirg Work Load Analysis
Fire and Polbe
P U b I i C
Crime b Fire Dispatching; Districting: Crime
'
Safety
InCiderq Maps Routing F
re Analysis by
Area
Planning
Zoning; Historic
SRePlan Land Development
Analysa;Travel
UsePernils;
Districts: Land Use; Approval
Route Analysis;
Statistbal Mapping
Pipe System Work Orders;
Complaint Consumptbn analysis;
Utilities Inventory; Customer
Tracking; Work Load anaysis;
Locatbn; Co
mputer- Inventories Maintenance Schedules
Aded Design 8 Eng.
i
Code
Inspectbn
Development .
Allpermrts--
EntotCement Permit ti lnspectbn Management; Trends:Work Load; Building,
Activity Violation 3 and Plumbing
EnlorcemeM Electrical
Trends
Executive
Illutttratbns for
Presenlatbna
Services try
neighborhood:
costs by location
Tax
Assessment
Cadastral Ma Assessment:
PPing: billing
Parcel Mapping
Equivalent properties:
neighbofiood values
_ ^ ~" ~ ~ Workshops HDR , 1986
WLSt7onlin L21t~ r~iCOfils COtMllt16t1: Flnal Aepon
A.
B.
C.
D.
E.
F.
G.
H.
Concept for a
Multipurpose Land Information System
Section 22, TIN, R9E,'Lbwn d N4stport, Dane County, tNisrnnaia
Data Layers: Reapenaible Agengt
A. Parcels Surveyor Dane County land Regulation and Records Department.
B. Zoning ~ Zoning Administrator, Dane County Land Regulation and Remrda Department.
G Floodplains ' Zoning Adminiahator, Dane County Land Regulation and Records Department.
D. i
Wetlands Wixonsin Department of Natural Resources.
E. Land Cover Dane County Land Conservation Committee.
F. Soils United States Department o(Agnicuituro, Soil Conservation Service.
G. Re(erena Framework Publk Land Survey System comer with geodetic coordinates.
N. Compailt t~urday LayeM integrated as nerded, esamp(t shown parcels, toils and reftrtrrct Jrametvork.
~~ Workshopt
DANE COUNTY LAND RECORDS PROJECT, 1986
', RELATED TECHNOLOGIES
GEOGRAPHIC INFORMATION SYSTEMS: Dealgned for flexible storage, retrieval, and
analyals of spatially referenced information within an integrated computing environment.
o Focus upon Integration of data for presentation and analysis.
o Data model optimized for analysis rather than for efficient storage.
o Cartographic flexibility 1s secondary consideration.
o Commands and funetlons designed for spatial analyals.
o Logically continuous geographic coordinate systems.
o Graphic features flexibly linked to attribute databases.
o Maps as graphic reports.
o Single-user or multi-user systems; microcomputer or minicomputer.
COMPUTER AIDED DRAFTING SYSTEY8 (CAD): Designed for efficient and accurate drawing
creation, maintenance, and reproduction.
o Dealgned for precise and flexible Input and retrieval of graphic elements.
o Ysy provide for 3-D coordinate systems.
o Non-geographic coordltsate systems.
o Graphics may be linked (o attribute database.
o Drawing-specific data storage.
o Single-user or multi-user; microcomputer or minicomputer.
AUTOMATED YAPPING SYSTlgYB: Systems designed to provide for efficient, accurate, and
flexible maintenance of com),lex maps.
o Precise and flexible graphic input and retrieval functions.
o Multi-user systems, requiring minlcomputers or networked workstations.
o Large data storage needs,.
o Graphics linked to specialized databases to permit query by attribute.
o No analytical capablllties.
DESKTOP YAPPING SYSTEMS: Dealgned to provide low-cost solution for specialized but
llmlted display and/or analyals of geographic data.
o Mapping equivalent to presentation graphics software.
o Mape as reports; conformant or pin-map output.
o Few graphic Input features; rely on precoded graphic tiles.
o Coordinate precision not an issue.
o Low resolution graphics adequate.
o Single-user software for microcomputers.
FACILITIES MANAGEMENT SYSTEY8 (PY): Dealgned to support facilities management
functions (le., electric'utillty !toes, phone lines, wastewater lines).
o Precise and flexible graphic Input and retrieval functions.
o Large volume data storage.
o Graphics linked to specitlized databases to permit query by attribute.
o Analytical funetlons llmlted to those required for facilities management.
o Usually multi-user systems using minlcomputers or networked workstations.
- -Overview
I ,~ j ,. n '? ? ~, ,
Geo/SQL
What could be more perfect?
a powerful, C-based, object-o
topological GIS data structur
interactive embedded SQL, a
off with an easy-to-use Auto
Litrrnlly fhmrsanAs of organizations
use AutoCAD for mopping and
farilities managerernt applications
every day. Geo/SQL gives you yet
nnoPoer reason for your CAD graphin
choice. Now you can use AutoCAD,
not just far maps f+drawings, but for
Aevcloping your Geographic Infor-
rnntion System (GIS). Geo/SQL is
based on the newest state of the art in
AistributeA database and SQL
(Sfnrctured Query Language)
technology. It can work standalone,
in n nehvork, and through
Geo ViewsTM can be interactively
linked with R:Base, ORACLE, and
other SQL databases running on PCs,
nehuorks, or mainframe host
cornputero.
idea and counties, utilities, major
corporations and industrial facilities
throughout the U.S. and Canada
are using the new GedSQLT" from
Generation 5 Technology, as the foundation of
their GIS/mapping and facilities management
systems. CeaSQL is being used to develop appli-
cations from municipal maintenance, to electri-
cal distribution power analysis, to environmen-
tal protection, hazardous material management
& control, and much more.
The Geo/SQL Continuous
Topological Data Model
A Geo/SQL GIS begins by providing you
with the most important element of a true
GIS: topology. Geo/SQL spatial data elements
include points, Linea, polylinea, and polygons.
Geo/SQL'e seamless, continuous database ie
limited only by disk size. Through Ceo/SQL's
Intelligent IndexingT",all spatial objects are
organized both thematically and spatiallg
allowing rapid eceesa to your map/drawing
data, even in very large databases. Double-
precision Boating-point X,Y, and 2 coordinates
ere stored for every point.
Query your SQL Databases
Interact/velywith GeoViewsT""
Imagine a map or facilitiee drawing on
your PC workstation; now imagine clicking on
any object displayed an the screen. Suddenly
you are looking at a live, real-time, multi-user
SQL database record. GeoWewsTn expands on
the powerful SQL concept of a multi-table join
or'view' to include spatial data. There is no
need to import data into Geo/SQL. You can
work with your existing DBMS, on your exist-
ing computer hardware. All Geo/SQL opera-
tionaincluding create, insert, drop, update,
delete, and query operate upon live SQL data.
Because Geo/SQL supports the SQL standard,
Geotrewa can interactively link SQL tables
and logical views from a number of ANSI stan-
dard SQL DBMS systems.
AutoCAD Makes It Easy to Use
Don't be fooled by all the power and Bexi-
bility of Geo/SQL. When you sit down in front
of the screen, it will look surprisingly familiar.
We've not only integrated the entire AutoCAD
graphics environment, we've used the new
pop-down AutoCAD user interface to make it
work just like AutoCAD too. Easy to use and
easy to learn.
To convert an AutoCAD drawing into a
topological GIS data model, you pulldown an
AutoCAD menu labeled Insert. Geo/SQL
establishes topology, eliminates redundant
points, and links the spatial objects with an
indexed SQL Geo~ew. Data collection tools
within AutoCAD provide for programmable
Geo1'agsTU for quick GIS data entry, including
field validation, auto-increment, computed
fields, and select-from-lief. Full 3-D support
means that you can draw and manipulate any
3-D AutoCAD model, and afore it in Geo/SQL's
topological database.
~~~~' u Ana'ytical
c~„y n Programs
oetscie
r«mra: Geo-
Spold processlnQ
Dtfc>bate Tcols
(GOL)
Geo/Si
Learn about GIS by working with a real GIS today.
(like lla eoordlnde preelslon and paramehic dale ~,
other GIS. And Geo/SAL's hue spallal GIS dalobase '~~
your GIS In J-4 weeks Msfsad oI monNu a yeah.
rt? You begin with
~t-oriented
Lure, add full,
., and then top it
toCAD® Interface.
You Can Use Digital Map Data
from Anywhere
DXF is the defacto induatry•atandard
neutral file format for GIS graphics. GedSQL
uses the DXF format as the basis for all its
graphics data descriptions. Virtually any GIS
or digital map source that otTere DXF will
work with GedSQL, including DIME, TIGER,
DLG, IGES, ETAK, STAT Canada AMF,
ARC/Info, Intergraph, Synercom, and many
others. GedSQL supports both DXF, and
GXFT"' neutral file formats.
Ask Duestions, Get Answers
GedSQL's non-procedural Embedded
SQL commands may be accessed from either
the AutoCAD interface, the command line or
from within your SQL database. Remember:
Geo/SQL is fully interactive with your SQ[.
dbma. Getting an on-demand AutoCAD draw-
ing, athematic map, a 3-D GIS histogram, or a
tabular report utilizes the same, straightfor-
ward, Ask Questions, Get Anawere approach
ae a typical SQL query. For example:
E>i DB -
~yflcal ~
raa
~
~fam5
:,.-
O
Datiibuletl t4ckls+0~M."
~ Dora
saa°isa "Bar ~(_....>....
~ao-
ca551n7
c
l
A11fIbW~
Ddabos~
kanSE/DpgN ';
o
s
ISGU Fcx • or»mo~ .
i ~lt~q _
Geo-Bbaed Reports
I /~`[7~ Inferac~tlVe EcGTlrig `
rodoY. AuIoCAD provides advanced graphics
data entities) Ihal simply don't exist !n any
,base is ao easy to learn, you can slam building
ws.
SELECT OBJECTS
FROM GEOV-EW PARCEL
WHERE IMPROVED_VALUE >150000
WIfERE CROSSING (getwindowl
AS DXF
would draw a map of parcels whose
improved value is greater than $150,000.
Geo/SQL provides full access to all ANSI SQL
commands from inside the spatial database, at
all interface levels. Spatial column values
such as perimeter, area, etc. are automatically
derived for every spatial object.
Both derived column values and SQL col-
umn values may be used to determine the the-
matic output of the AutoCAD drawing, includ-
ing text font, color, layer, thickness, elevation,
symbol, rotation, justification, etc. An optional
module provides coordinate translation to and
from all major coordinate systems. And with
AutoScriptc" you can output your map to any
Poatacriptr" printer for typeset-quality carto-
graphic output.
Fast, Production Mapping
GedSQL doesn't just help you get on-
demand maps and graphics out of your GIS
system. A range of coordinate geometry and
drawing cleanup tools provide you with an
easy method of compiling your maps and draw-
ings. Interactive, on-screen AutoCAD-based
COGO functions include bearing & distance
intereediona, solved point, full-screen interac-
tive entry of 5eld notes, and 3rd party support
for GPS and data collection instruments.
Additional utilities extend lines and arcs,
join lines, connect lines between lines, and
more. Engineering software from AutoCAD,
and other engineering and non-topological
mapping systems provide fast and easy ways
to move data from existing maps and engineer-
ing drawings to GedSQL's topological data
structure.
3rd Party Applications
Geo/SQL'e AutoCAD interface and its
structured non-procedural command language
make it the right choice for developing GIS
applications. Geo/SQL queries may be saved,
and interactive procedures can be put into
AutoCAD pop-down menus. The system -
adminiatrator or applications developer can
modify GedSQL menus to build a turnkey
application for their usere. Links to existing ~-
analytical and operations/management sot
ware have been prototyped in a matter of
hours, not weeks or months. Firma like Scott
& Scott, Stoner Aaeuc., Permatrack, Auto-
mated Compliance Systems and others are '..
helping put together advanced applications far i.
every area of GTS. '..
Works for Small Projects Too
GedSQ1, doesn't only work fur large cities'.
and government agencies. It works fur indus-
trial facilities, small-scale studies and ecientif-
is projects, too. GedSQL is the perfect foul for
developing a G[S pilot project, or for just get- ,
ling your staff up and running on GIS con- '
cepta. AutoCAD makes it easy to use, and yet '.
you get the full power of both SQI., and a true
topological GIS data structure.
Generation 5 Technology
Generation 5 Technology ie a pacesetter
in the development of industry-standard GIS
systems. Our G5/Cartotechnical Group pro-
video Generation b Technology diente with an
international network of G[S expertise
through its membership of software develop- -~
ere, system integrators, VARe, service bureaus,;
and GIS/engineering consulting services firma
In software, in services and in the support
provide to our clients around the world, we
thoroughly committed to our focus on quality i
and excellence.
Geo/SQL"
The Nezf Revolution
In Information Management
Structured, Non-
Procedural Language
Embedded SQL
Coniinuous
Topological Database
GeoViewsrM
Coordinate Geometry
Data Exchange
Specifications ~ ~ ,
°I '~
• All access to spatial data is made
through structured SQL -like
language
• Also includes object-oriented
macro IanguUge with over 160
pre-written 16nctions
• Full source code available for all
menus and macron
•. Full access to all ANSI SQL
commends from inside the epetisl
database, at all interface levele.
•. Complete support of SQL
commands to limit access and
audit use of spntinl dntabnse
• Support for multi-table and
'logical' views of epetisl data
• Supported objects include point,
line, polyline & polygon.
• Seamleae, Continuous database
limited only by disk size.
• Full double-precision Floating point
accuracy in spatial database.
• X,Y,Z coordinates for all points.
• ~ True circular arcs supported.
•, Automatic elimination of
~. redundancies in points & lines
• Extension to the SQL Date
Dictionary GA ~ncnmpass spatial
and integrated attribute date.
• On-The-Fly Addreae Geocoding
supported for both points & lines.
• Supports muU.iple SQL tables
and/or logicgl views addressing
spatial auhjucts.
• Simple, mewl driven interface for
creation & Aaintenance of views.
• ~ Full project management through
GeoView cheek-in, check-out.
• Bearing/bearing $ bearing/diatance
intersection; Irearing/dietance &
angle/dietence solved point; etc.
• Full-screen interactive entry of
survey data from field notes.
• Uaer-definable scale, UTM, layer
conventions, traverse adjustment.
• Utilities to extend lines and arcs,
join lines, connect lines between
linee, & arcs.
• Supports DXF end GXFrM open-
format ASCII neutral file formats.
• Files may be exchanged to and
from: DIME, DLG, IGES, T[GER,
ETAK, ARC/Info, Intergraph
Microetetion GIS, Synercom.
Intelligent IndexingTM • All spatial objects are organized
both thematically and spatially,
allowing rapid access, even in very
large databases.
AutoCAD®Graphics • ceo/sQL*M fully integrated with
popular AutoCAD graphite
environment.
• Full support for AutoCAD's eaey-
to-use pop-down menu interface.
• Date reports from Geo/SOLs may
control all AutoCAD formatting,
layering, colors, hatch patterns,
text & symbol Font, juatiflcation,
rotation, etc,
Data Collection Tools • Programmable attribute entry
using unique GeoTagT" concept.
- Field validation, auto-increment,
computed fields, select-from-list.
• Direct insertion into spatial and
SQL data files.
• Dynamic prompting for defaults,
constants, visibility, etc.
3-D Support • Transparent linkage to variety of
industry-standard DTM software.
• 3-D hiatagram reproeentatione of
any SQL data.
Cartographic • Crid ticks, unlimited loofa, symbol
Enhancements libraries, hatch patterns,
linestyles.
• Coordinate Translation to find
from all major coordinate systems.
• NAD 83 support.
• Postscript typesetting output
3rd Party • Electrical distribution mapping,
Applications facilities management, trouble-call
tracking & power distribution
analysis.
• Gas & Water distribution analysis
• Public Works Maintenance,
Operations Rr Managment.
• Pavement management &
highways facilities management.
• CERCLS $ SARA Title III
compliance, right-to-know.
• Environmental Protection analysis
& data management.
• Oil & Gas oil field facilities &
pipeline management.
• Land records information, leases,
tax- mapping, permits,
inspections.
• Emergency preparedness
planning, impact modeling &
analysis
'some of the above require optional packages.
4»989•Y aareralionBTMrNapy, AA aBM1b nMrVaB Gea3CL, MUrMBP, GepV:Ew, InlaNlpmAlrWAirq,eM as aro lroMm•rFA Ol OanaMMn STacMWOpr •ublLaoBbrA918Ma8 wMrIM U.3 pelanl8 Tra8emak alliwwauAC8e86,
Mq. •6~c8. P8R •M IBM era baBArrlaM W IBM Corp.OrUCLE, a~BW. ET1x. NAGIMO, MMmAM1bn OIB, W 8ynermm AN ba8emahA a QaMa. Lap.. MbpRM bc., ETax, Nc.. ESRI Inc. IMappll. ar10 9rrwm. r•AgcMaA.
For More Information: In Canada Contact Generation 5 Technology (403) 455-9197
In U.S. Contact Generation 5 Technology (303) 427-0055