Loading...
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