Each of the five states involved in MIDCARB has committted to installing three products to implement MIDCARB in a distributed computing environment:

RDBMS - Relational DataBase Management System - Provides network access to tabular data
SDE - Spatial Data Engine - Provides network access to spatial data
ArcIMS - Internet Map Server - Provides web access to dynamicially generated maps.

This page documents the progress to date on the installation of these three products.

State	RDBMS	SDE	ArcIMS
Illinois	Oracle 7.3.3 Upgrading to 8.1.7	8.0.2	3.0
Host:	volcano.isgs.uiuc.edu	midcarb.isgs.uiuc.edu
Operating System:	Solaris 2.5 Upgrading to Solaris 8
Port:	1521	5151
Protocol:	TCP
Instance:	isgs	midcarb
Indiana	SQL Server 2000	8.1	3.1
Host:	129.79.145.6	129.79.145.6
Operating System:	Windows NT 4.0
Port:	1433	5151
Protocol:	TCP
Instance:	Midcarb_Sources	midcarb_gis
Kansas	Oracle 8.1.7.2.0	8.0.2	3.1
Host:	abyss.kgs.ku.edu	abyss.kgs.ku.edu
Operating System:	Solaris 2.8
Port:	1521	5150
Protocol:	TCP
Instance:	ABYSS	ABYSS
Kentucky	SQL Server 7.0.961	8.0.2
Host:	128.163.49.110	128.163.49.110
Operating System:	Windows NT 4.0
Port:	1433	5151
Protocol:	TCP
Instance:		sequester
Ohio	SQL Server 2000	8.1
Host:	198.234.182.204	198.234.182.204
Operating System:	Windows NT 4.0
Port:	1433	5151
Protocol:	TCP
Instance:	OH_MIDCARB	sde_gis or OH_MIDCARB

* Each database connection requires the standard username and password.

Illinois State Geological Survey

Our web site (http://www.isgs.uiuc.edu) runs on a dual processor Sun Solaris machine using Apache, with 2 connections to the network; one for inside the building and a second one dedicated to web serving. Our goal is to put much of what we do on the web. We also serve thousands of static pages (maps, papers, etc) over the web. Much of our effort goes into serving data to staff only from our Oracle database on our Intranet.

We use Oracle's Web Application Server (3.0.1) and Oracle's PL/SQL language to generate html pages from our Oracle database in real time and deliver formatted pages to the user. We also use Developer 2000 to create Oracle input and retrieval forms for staff. We also provide custom maps, print-outs and digital data extracts from our database to the public for a fee.

We are currently running Oracle 7.3.3 on a dual processor SPARC machine (Solaris 2.5). Oracle 8i has been installed on a test platform running Solaris 8 to be used while applications are being rewritten and tested. A new data server machine has been received in house but not yet configured. We support in-house ODBC access to the database. We run ESRI's ArcSDE Spatial Data Engine 8.1 on Solaris 8, serving internal and external users of ESRI software. As an official node for the FGDC National Spatial Data Infrastructure, we maintain the Illinois Natural Resources Geospatial Data Clearinghouse, and are used to delivering data over the web.

We use ESRI products for our GIS work. We are in the process of upgrading to ArcIMS 3.1 on a Sun Ultra 10 running Solaris 8. We currently serve 6 maps to the Internet using ESRI's first Internet map product, ArcView IMS. These maps see about 40 users per month. We have recently completed a project to provide Digital Orthophoto Quarter-Quadrangles for the entire state of Illinois via ArcIMS. The DOQs are available in MrSID compression format to optimize delivery to the user. DOQs were downloaded at an average rate of 300/day in 2001 (110,000 files for a total of 385 gigabytes). The average rate for the first quarter of 2002 was 500/day.

While we have a large amount of well data in our Oracle database, there is always more data to be gathered, organized and entered. Our Geologic Records section is the main contributor to the database. The data is mainly entered into the database on a project by project basis because we lack the funding to have a full-time data entry staff.

Our Database Team has the following mission: We are responsible for awareness, ease-of-access and usability of computerized databases. We charge ourselves with gathering and disseminating information for/about existing databases, developing new/improved databases and database systems, and recommending policies and procedures for the curation of project and institutional information.

Indiana Geological Survey

The Indiana Geological Survey (IGS) hosts its own Web site (http://igs.indiana.edu) using Microsoft IIS on a Windows 2000 server. We use ColdFusion to access databases from our Web site and ESRI's Arc Internet Map Server (ArcIMS) for accessing some of our map data. We host more than 1,000 Web pages and offer GPS basestation files and various PDF documents for download.

Within the IGS, we have installed ArcGIS on many of our staff computers. We use Microsoft SQL 2000 server with ESRI's Spatial Data Engine to develop centralized Geodatabases. Additionally, some of our staff develop personal Geodatabases for their own projects. We continue to use ArcView 3.X with ESRI extensions and customized extensions that are delivered from one of our network servers.

Most IGS employees have Windows 2000 or Windows XP PCs on their desks. Networking within the IGS is performed by a series of Dell Windows NT and Windows 2000 servers. We are in the process of migrating from our departmental network domain to the University's Active Directory Services domain. We have upgraded much of the network wiring infrastructure from 10MB Ethernet to100MB Ethernet at the desktop. We are currently planning an upgrade for our network servers to Gigabyte Ethernet. Other computing equipment available to our staff includes: a 1-meter-wide, 800 dpi, full-color scanner and a desktop high-end Agfa scanner for map scanning, document conversion, and archiving; Hewlett-Packard Designjet 1055CM, 755CM, and 650C color plotters; several 36" x 48" Calcomp digitizers; Trimble GeoExplorer and Pathfinder GPS field units and Pathfinder GPS basestation; a desktop CD-R Publisher with two 12x CD-R recorders in a 4-bay unit, 100 disc hopper with a Primera Signature III Inkjet printer; and various network LaserJet and color laser printers.

Kansas Geological Survey

Our web site (http://www.kgs.ku.edu) runs on a Sun Solaris machine using Apache. Our goal is to put everything we do on the web. While we serve thousands of static pages (maps, papers, etc), much of our effort goes into serving data from our Oracle database on the web. We use Oracle 8.1.7 with the bundled Oracle Application Server and Oracle's PL/SQL language to generate html pages from our Oracle database in real time and deliver formatted pages to the user. We also support and encourage extracts from our database. Many projects have been developed using Cold Fusion 5.0. We have one large Java project being developed (http://www.kgs.ku.edu/Gemini/index.html).

We run Oracle 8.1.7.2 on a quad processor SPARC II machine (Solaris 2.8). We support Oracle DBLINK connections and ODBC access to the database. We have ESRI's Spatial Data Engine software installed, so we can provide remote access to ESRI users around the world. We offer direct access to data vendors and other interested parties, so we're used to delivering data either over the web or via direct connections to the database.

We use ESRI products for our GIS work and we are actively working to move all of our spatial data to Oracle using SDE. We have the latest version of ArcIMS installed on both Unix and NT and are working to get our maps on the web.

While we have a large oil & gas database in Oracle, it is a work in progress. We're devoting considerable resources to adding new tables all the time and improving the tables we've already loaded into Oracle.

Kentucky Geological Survey

The University of Kentucky hosts the website of the Kentucky Geological Survey (http://www.uky.edu/kgs). The University server is using Apache, but plans are being made to purchase a new server in January or February and it is not known what hardware and software will be used. KGS files on the webserver total approximately 210 MBytes with about 900 pages (not counting graphics).

The KGS maintains its own ftp server for distributing GIS coverages, pdf files, and other data (more than 1 GByte of data). The KGS does not have a database server, however, the University is going to setup a data server (probably using Cold Fusion) that we will be able to use in 2001. The Survey is investigating several options for map serving, including either setting up our own server (using ArcIMS), using a state government server, or working with the U.S.G.S. server. KGS is also researching several options for e-commerce including using commercial e-commerce services or using a state government server.

Internally, the KGS uses Microsoft SQL Server 7 running on MS Windows NT 4.0 server. Users access the database through any application utilizing ODBC (MS ACCESS, ESRI ARCView, MS EXCEL, etc). Most users have either Windows 9x PCs or Windows NT workstations served by a DELL Windows NT 4.0 Server. We are developing the spatial datasets utilizing ESRI's SDE spatial database engine and are evaluating SmallWorld in a cooperative arrangement with the USGS.

The KGS tabular database has over 400,000 unique locations and millions of related records. The spatial database is currently being built and will contain all of the 707 digital geologic maps in addition to many types of other coverages beign generated on a daily basis.

For GIS, we rely heavily on the University of Kentucky's license agreement with ESRI. Most of our users have ARCView with both Spatial Analyst and 3-D Analyst extensions. Those with the NT Workstations also have ARC/Info. We have several licenses for BlueMarble Geographic's software packages: Geographic Transformer (for georeferencing images) and Geographic Translator (for coverting from one geographic projection to another). We also have Lizardtech's MrSID image compression software.

KGS has 2 large format scanners; a 44-inch wide by unlimited length, 500 dpi, 24 bit from Tangent Imaging Systems, and a 36-inch wide by unlimited length, 400 dpi, bi-tonal and grayscale from Anatech. We have Hewlett-Packard Designjet 650c and Designjet 755CM/PS plotters. We are currently evaluating additional large-format plotters.

Ohio Geological Survey

We run SQLServer 7.0 on a dual processor MAXVISION machine (Window NT Server 4.0). We are considering an upgrade to SQL Server 2000 and Window 2000. We do not have ESRI's Spatial Data Engine software installed yet but are planning on getting it sometime in the future as we learn more and get more of our data converted to Arcinfo.

We are starting to use ESRI products for our GIS work and we are actively working to move all of our spatial data to Arcinfo and then SQL Server. Then natural progression will move us to buying ArcIMS to web enable all this data.

Some of our data is project specific data that resides in Access Databases. Our main Oil and Gas database is RBDMS (used in conjunction with the Division of Minerals Resource Management) running on SQL Server. We serve large amounts of data via our FTP site that we would like to web-enable sometime in the distant future. For example we have county basemap files, well location database files, and production data files.

[Web site at http://www.ohiodnr.com/geosurvey/]

Go to Top of Page