90-18 Generation 5 Technology - GIS Software Purchase (GEO/SQL)Kodiak Island Borough
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
interfacing 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 a one -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
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 Resource 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 purchase is exempt from the
bidding requirements of Chapter 13.16, per Section
13.16.070A since the software is a "unique service."
Goo/SOL Sottware Page 2 of 2 Assembty: August 2, 1990
GEOPROCESSING APPLICATIONS FOR
LOCAL GOVERNMENT
Automated Operations Planning Tax/
Mapping License
Public
Pipe &Street
Work Orders;
Inventories;
Maintenance
Schedules;
Excavation
Works
Network Maps:
Computer -Aided
Complaint
Capital Improvements
Permits; ROW
Use Permits
Design &Engineering
Tracking
Work Load Analysis
Fire and Police
Public
Crime & Fire
Dispatching;
Districting: Crime
Safety
Incident Maps
Routing
Fire Analysis by
Area
Planning
Zoniicts;L
Land Development
Analysis; Travel
Use Permits;
Districts: Land Use;
Land
l
Approval
Approval
Route Analysis;
Statistical Mapping
Pipe System
Work Orders;
Complaint
Consumption analysis;
Utilities
Inventory; Customer
Tracking;
Work Load analysis;
Location; Co
Computer-
Inventories
Maintenance Schedules
Aided Design & Eng.
Code
Inspection
Development
AllpermAs--
Enforcement
Permit & Inspection
Management;
Trends;Work Load;
Building,
Activity
Violation & and
Plumbing
Enforcement
Electrical
Trends
Executive
Tax
Assessment
Illustrations for
Presentations
CadastralMa Assessment:
mapping: billing
Parcel Mapping
Services by
neighborhood;
costs by location
Equivalent properties;
neighborhood values
P• qt" " 0 Workshops HDR , 1986
A.
B.
C.
M
E.
F.
G.
R.
! WL04OR M LOu t4kords Cotnmltles: Flnal Report
Concept for a
Multipurpose Land Information System
�aq Workshops
DANE COUNTY LAND RECORDS PROJECT, 1986
Section 22, TON, ME, Town of N4stport, Dane County, Wisconsin
Data Layers:
Respandble Agency:
A.
Parcels
Surveyor Dane County Land Regulation and Records Department.
B.
Zoning I
Zoning Administrator, Dane County Land Regulation and Records Department.
C.
Floodplain
Zoning Administrator, Dane County Land Regulation and Records Department.
D.
tlktlands
Wisconsin Department of Natural Resources.
E.
Land Cover
Dane County Land Conservation Committee.
R
Soils
United States Department of Agriculture, Soil Conservation Service.
G.
Reference Framework
Public Land Survey System comers with geodetic coordinates.
N.
Composite otrday
[ayes integrated as herded, example shoto parols, soils and reference Jrammork.
�aq Workshops
DANE COUNTY LAND RECORDS PROJECT, 1986
RELA TED TECHNOLOGIES
GEOGRAPHIC INFORMATION SYSTEMS: Designed for flexible storage, retrieval, and
analysis 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 Is secondary consideration.
o Commands and functions designed for spatial analysis.
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 SYSTEMS (CAD): Designed for efficient and accurate drawing
creation, maintenance, and reproduction.
o Designed for precise and flexible Input and retrieval of graphic elements.
o May provide for 3-D coordinate systems.
o Non -geographic coordinate systems.
o Graphics may be linked to attribute database.
o Drawing -specific data storage.
o Single -user or multi-user; microcomputer or minicomputer.
AUTOMATED MAPPING SYSTIFMS: Systems designed to provide for efficient, accurate, and
flexible maintenance of complex maps.
o Precise and flexible graphic input and retrieval functions.
o Multi-user systems, requiring minicomputers or networked workstations.
o Large data storage needs.
o Graphics linked to specialized databases to permit query by attribute.
o No analytical capabilities.
DESKTOP MAPPING SYSTEMS: Designed to provide low-cost solution for specialized but
limited display and/or analysis of geographic data.
o Mapping equivalent to presentation graphics software.
o Maps as reports; conformant or pin -map output.
o Few graphic input features; rely on precoded graphic files.
o Coordinate precision not an Issue.
o Low resolution graphics adequate.
o Single -user software for microcomputers.
FACILITIES MANAGEMENT SYSTEMS (FM): Designed to support facilities management
functions (le., electric'utillty lines, phone lines, wastewater lines).
o Precise and flexible graphic Input and retrieval functions.
o Large volume data storage.
o Graphics linked to specialized databases to permit query by attribute.
o Analytical functions limited to those required for facilities management.
o Usually multi-user systems using minicomputers or networked workstations.
Literally thousands of organizations
use AutoCAD for mapping and
facilities management applications
every day. Geo/SQL gives you yet
another reason for your CAD graphics
choice. Now you can use AutoCAD,
not just far maps £+drawings, but for
developing your Geographic Infor-
mation System (GISL Geo/SQL is
based on the newest state of the art in
distributed database and SQL
(Structured Query Language)
technology. It can work standalone,
in a network, and through
Geo ViewsTM can be interactively
linked with R:Base, ORACLE, and
other SQL databases running on PCs,
networks, or mainframe host
computers.
— Overview
Geo/SQL
What could be more perfect?
a powerful, C -based, object -e
topological GIS data structur
interactive embedded SQL, a
off with an easy-to-use Auto(
idea and counties, utilities, major
corporations and industrial facilities
throughout the U.S. and Canada
are using the new Geo/SQL TM from
Generation 5 Technology, as the foundation of
their GIS/mapping and facilities management
systems. GeaSQL 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, lines, polylines, and polygons.
Geo/SQL's seamless, continuous database is
limited only by disk size. Through Geo/SQL's
Intelligent Indexinem, all spatial objects are
organized both thematically and spatially,
allowing rapid access to your map/drawing
data, even in very large databases. Double -
precision Boating -point X,Y, and 2 coordinates
are stored for every point.
Query your SQL Databases
Interactively with GeoViewsTM
Imagine a map or facilities drawing on
your PC workstation; now imagine clicking on
any object displayed on the screen. Suddenly
you are looking at a live, real-time, multi-user
SQL database record. GeoWewsTM 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-
tions including create, insert, drop, update,
delete, and query operate upon live SQL data.
Because Geo/SQL supports the SQL standard,
GeoWews 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 flexi-
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 GeOView. Data collection tools
within AutoCAD provide for programmable
GeoTagsTM for quick GIS data entry, including
field validation, auto -increment, computed
fields, and select -from -list. Full 3-D support
means that you can draw and manipulate any
3-D AutoCAD model, and store it in Geo/SQL's
topological database.
���' u Ana'ytical
ccp ffy n Programs
oefscie
Fes w Geo-
Spatialprocessing
Ddcbate Tcoh
(GOL)
Geo/Si
Learn about GIS by working with a roof GIS today.
(like Its coordinate precision and parametric date
other GIS. And Geo/SAL's true spatial GIS database
your GIS In 3-4 weeks instead of months or years.
ct? You begin with
1 -oriented
Lure, add full,
and then top it
toCAD° Interface.
You Can Use Digital Map Data
from Anywhere
DXF is the defacto industry -standard
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 offers DXF will
work with Geo/SQL, including DIME, TIGER,
DLG, IGES, ETAK, STAT Canada AMF,
ARC/Info, Intergraph, Synercom, and many
others. Geo/SQL supports both DXF, and
GXFTm neutral file formats.
Ask Questions, Get Answers
Geo/SQL'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 SQI.
dbms. Getting an on -demand AutoCAD draw-
ing, a thematic map, a 3-D GIS histogram, or a
tabular report utilizes the same, straightfor-
ward, Ask Questions, Get Answers approach
as a typical SQL query. For example:
today. AutoCAD provides advanced graphics
data entities) that simply don't exist In any
,base is so easy to learn, you can start building
I s.
Geo/SQL"
-
%
4 __J
.wc.ro
SELECT OBJECTS
FROM GEOVIEW PARCEL
WHERE IMPROVED -VALUE >150000
WHERE CROSSING (getwindow)
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
AutoScriptr" you can output your map to any
PostscriptT" printer for typeset -quality carto-
graphic output.
Fast, Production Mapping
Geo/SQL 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
intersections, solved point, full -screen interac-
tive entry of field 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 Geo/SQL's topological data
structure.
3rd Party Applications
Geo/SQL's AutoCAD interface and its
structured non -procedural command language
make it the right choice for developing CIS
applications. Geo/SQL queries may be saved,
and interactive procedures can be put into
AutoCAD pop -down menus. The system
administrator or applications developer can
modify Geo/SQL menus to build a turnkey
application for their users. Links to existin,
analytical and operations/management sof
ware have been prototyped in a matter of
hours, not weeks or months. Firms like Scott
& Scott, Stoner Assoc., Permatrack, Auto-
mated Compliance Systems and others are
helping put together advanced applications for
every area of GIS.
Works for Small Projects Too
Geo/SQL doesn't only work for large cities
and government agencies. It works for indus-
trial facilities, small-scale studies and scientif-
ic projects, too. Geo/SQL is the perfect tool for
developing a GIS pilot project, or for just get-
ting your staff up and running on GIS con-
cepts. AutoCAD makes it easy to use, and yet
you get the full power of both SQL, and a true
topological GIS data structure.
Generation 5 Technology
Generation 5 Technology is a pacesetter
in the development of industry -standard GIS
systems. Our G5/Cartotechnical Group pro-
vides Generation 5 Technology clients with an
international network of GIS expertise
through its membership of software develop-
ers, system integrators, VARa, 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
and excellence.
raa
wticol
�fam5
E?<is11nQ OB -
Datiibuletl
Dora
Afhlbule
Database
at4UYlhyN..,:•;-
ao-
ca551n7
cols
IBM /M
RSASE/Dbgo
SW Dotgbau
ISGU
i
�lE�q
Geo -Based Reports
f /SQ
H
InferaFtiVe Editing
staNstical surnmades
today. AutoCAD provides advanced graphics
data entities) that simply don't exist In any
,base is so easy to learn, you can start building
I s.
Geo/SQL"
-
%
4 __J
.wc.ro
SELECT OBJECTS
FROM GEOVIEW PARCEL
WHERE IMPROVED -VALUE >150000
WHERE CROSSING (getwindow)
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
AutoScriptr" you can output your map to any
PostscriptT" printer for typeset -quality carto-
graphic output.
Fast, Production Mapping
Geo/SQL 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
intersections, solved point, full -screen interac-
tive entry of field 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 Geo/SQL's topological data
structure.
3rd Party Applications
Geo/SQL's AutoCAD interface and its
structured non -procedural command language
make it the right choice for developing CIS
applications. Geo/SQL queries may be saved,
and interactive procedures can be put into
AutoCAD pop -down menus. The system
administrator or applications developer can
modify Geo/SQL menus to build a turnkey
application for their users. Links to existin,
analytical and operations/management sof
ware have been prototyped in a matter of
hours, not weeks or months. Firms like Scott
& Scott, Stoner Assoc., Permatrack, Auto-
mated Compliance Systems and others are
helping put together advanced applications for
every area of GIS.
Works for Small Projects Too
Geo/SQL doesn't only work for large cities
and government agencies. It works for indus-
trial facilities, small-scale studies and scientif-
ic projects, too. Geo/SQL is the perfect tool for
developing a GIS pilot project, or for just get-
ting your staff up and running on GIS con-
cepts. AutoCAD makes it easy to use, and yet
you get the full power of both SQL, and a true
topological GIS data structure.
Generation 5 Technology
Generation 5 Technology is a pacesetter
in the development of industry -standard GIS
systems. Our G5/Cartotechnical Group pro-
vides Generation 5 Technology clients with an
international network of GIS expertise
through its membership of software develop-
ers, system integrators, VARa, 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
and excellence.
Geo/SQL"
The Next Revolution
In Information Management
Structured, Non -
Procedural Language
Embedded SQL
Continuous
Topological Database
Geol/lewsrM
Coordinate Geometry
Data Exchange
Specifications
• All access to spatial data is made
through structured SQL -like
language
• Also includes object-oriented
macro Ianguuge with over 150
pre -written functions
• Full source code available for all
menus and macros
•. Full access- to all ANSI SQL
commands from inside the spatial
database, at all interface levels.
•. Complete support of SQL
commands to limit access and
audit use of spatial database
• Support for multi -table and
'logical' views of spatial data
• Supported objects include point,
line, polyline & polygon.
• Seamless, 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 pointe & lines
• Extension to the SRL Data
Dictionary to encompass spatial
and integrated attribute data.
• On -The -Fly Address Gemoding
supported for both points & lines.
• Supporta mull.iple SQL tables
and/or logical views addressing
spatial subjucts.
• Simple, mewl driven interface for
creation & maintenance of views.
• Full project management through
GeoView check-in, check-out.
• Bearing/bearing & bearing/distance
intersection; hearing/distance &
angleldistance solved point; etc.
• Full -screen interactive entry of
survey data from field notes.
• User -definable scale, UTM, layer
conventions, traverse adjustment.
• Utilities to extend lines and arcs,
join lines, connect lines between
linea, & arca.
• Supports DXF and GXFTM open -
format ASCII neutral rite formate.
• Files may be exchanged to and
from: DIME, DLG, ICES, TIGER,
ETAK, ARC/Info, Intergraph
Microstation GIs, Synercom.
Intelligent IndexingTM
• All spatial objects are organized
both thematically and spatially,
allowing rapid access, even in very
large databases.
AutoCAD® Graphics
_
• Geo/SQLTM fully integrated with
popular AutoCAD graphics
environment.
• Full support for AutoCAD's easy-
to-use pop -down menu interface.
• Data reports from Geo/SQLTM may
control all AutoCAD formatting,
layering, colors, hatch patterns,
text & symbol font, justification,
rotation, etc,
Data Collection Tools
a Programmable attribute entry
using unique GeoTagTM 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 histogram representations of
any SQL data.
Cartographic
• Grid ticks, unlimited fonts, symbol
Enhancements
libraries, hatch patterns,
linestyles.
• Coordinate Translation to and
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 & 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 aawralS BTM,Napy, AA rIBM10 n C".
Gea3LL, MutlAaP, GepV:M,In1eNIpmII,WAirq,eM aB aro lroMmA,AAWOanaMMn STacMWop_ ♦uroWft,.eW.ft.. ESRI , peWWh. l•89 alliesmWKM*b,
MM. •6.0p. P8R aM IBM a,a baBAplaM W IBM Cap.OMLLE, R�BW. ET1x. NAGIMo, MMmAM1Mn OIB, W 8yne,mm AN ba8emahA a QaMa. Lap.. MbpRM bc., ETN(. ft.. ESRI Inc. IMappll. ar10 9rrwm..•AgcMaA.
For More Information: In Canada Contact Generation 5 Technology (403) 455-9197
In U.S. Contact Generation 5 Technology (303) 427-0055