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