A CAST of Millions (of bytes of data)

The University of Arkansas' Center for Advanced Spatial Technologies builds an advanced spatial-data warehouse.

by / December 31, 1998 0
Besides traditional responsibilities for education and research, the Center for Advanced Spatial Technologies (CAST) at the University of Arkansas, Fayetteville, is also a National Center for Resource Innovation (NCRI). One of six Congressionally funded NCRI sites, CAST is involved in helping schools and state and local governments decide which GIS and related spatial technologies they need and how to buy them. Particular effort is directed toward rural governments. CAST's director, Fred Limp, pointed out that rural county governments often have critical need for spatial technologies, but have a low tax base or a low technology base.

"For the last 10 years, much of what we have been dealing with involves interacting with this group and trying to find ways to develop the technologies appropriate to their needs," Limp said.

SWAG

Working on the premise that resource sharing is the key issue, CAST Technical Director Jim Farley and technologists are designing the Seamless Warehouse of Arkansas Geodata (SWAG). When operational, the system will be accessible via the Internet or intranet, using any geoprocessing software supporting OpenGIS interfaces, a standard being developed and supported by major vendors of GIS technology. SWAG is designed around the spatial interoperability specification of the OpenGIS Consortium (OGC). The system runs on a Sun Enterprise 5000 Server, with UNIX; an Oracle Enterprise Server 8.i database engine using an object-relational data model; and Oracle's Spatial Cartridge, a database extension designed specifically for spatial data. When fully populated, SWAG will hold more than a terabyte of spatial data.

SWAG combines spatial data from various systems in a single database environment that allows users to locate and access them, along with associated metadata, from specific categories, or domains, such as roads, elevations, infrastructure, etc. Users can carve out a subset of data and insert it seamlessly in their own application. They will also have the ability to seamlessly overlay vector images on small or large-scale raster images.

Not Just Data Storage

Farley stressed that SWAG is not a data store. "If you throw an aggregation of data on a disk in a database, you have a data store. What we're building here is a warehouse," he said. "The difference between the two is driven by the amount of intelligence and domain expertise the interface presents to the user. In a data store, which is simply a large database, the onus is on users to have enough familiarity with the information ... to efficiently find what they need. In a data warehouse, an intelligent interface assists users in asking questions and getting information from a selected domain."

An example illustrates Farley's point and underscores the versatility SWAG achieves by melding an intelligent interface, OpenGIS implementations and a database using an object-relational data model: Users can go to the domain of cities, select one, draw a five-mile buffer around the downtown center, then ask for state highways within that area. If the original data contains different geographic scales and multiple attributes, or data layers, users can display a subset of the highways with the desired data layer and scale, and insert this in their application.

Available Data

Initially, CAST will load SWAG with neutral framework data -- elevations, roads, hydrography, political boundaries, school districts, demographics, and, where available, local parcel information -- the type of data, Farley said, that many geospatial applications are likely to need. A project team has already loaded SWAG's Sun Enterprise 5000 Server with the complete TIGER (Topologically Integrated Geographic Endcoding and Referencing) Line files of Arkansas. Eventually, the SWAG database's wide range of imagery will include digital line graphs and orthophoto quads.

"But framework data is SWAG's first mission," Farley said. "We want the data to be neutral and useable. Arkansas supports the Land Information Board, an organized forum whose mission includes a mandate to develop a policy concerning digital spatial data. As the formal policy emerges on how this information is to be shared, it is possible that additional types of data will be included. But SWAG would be successful if it simply made framework data available at a range of scales."

Susan Cromwell, director of the Office of Information Technology in the Arkansas State Department of Information Systems (ADIS), agrees with this assessment.

"Framework data is what Arkansas needs to start with. Right now we don't even have that. There are many other pieces of GIS data residing in several state agencies and databases around the state. Those, too, we will want to have in this repository, along with the appropriate metadata. Framework data is a good starting point."

The Human Factor

Getting agencies to hand over their data to a statewide repository, however, is another matter. According to Farley, this part of the project is turning out to be a tough sell.

"At the outset, I thought all the problems were going to be technical,
but there is a significant educational component associated with this whole process," he said. "People are very reluctant to trust their data to somebody else's storage system -- data is the currency of the Information Age. It's understandable that organizations want to protect their resources. Right now, the problem is getting people to come to the table to talk to each other and agree to participate. That aspect of the project is taking much longer than I had anticipated. But we are making progress."

Cromwell said her office is working with the same issues, not just in relation to SWAG, but in other IT areas as well. She finds that GIS users who have adequate input into the process, though initially protective of their turf, see the economic advantages and cooperate.

"Our office is charged with helping people come together over those conversations," Cromwell said. "We find that as long as people are included, it's very difficult for them to maintain an isolationist posture. There are many examples of resource sharing already going on in the state."

Testing
Farley said the CAST team has run SWAG through a 4