Basic SQL.doc
Basic SQL.ppt
If you are serious about using databases with your CAD system, you will need a basic understanding of SQL. Most CAD systems allow you to use SQL to communicate with and manage external databases. This course focuses on the key concepts of SQL and relational databases that are especially important to CAD users. Following a discussion on basic database design concepts, attendees will learn how to use SQL to create tables; establish relationships between tables; create queries; and insert, delete, and update values in tables. This course also introduces the concept of the VIEW, a SQL feature that can be very useful when linking databases to CAD.
Scott McFarlane - Epoch, Inc.

Distributed Use and Maintenance of CAD-based Thematic Mapping.ppt
The University of Maryland maintains a central CAD fileserver system that is the repository of the university base mapping as well as thematic overlays for special purpose mapping. The presentation focuses on the various special purpose uses of CAD mapping in use at Maryland. It also discusses the procedures used for developing and maintaining these thematic maps through distributed CAD maintenance responsibilities, coordinating various CAD sites, and thematic use coordination and development.
Charles Bowler

Flood Planning with GIS.ppt
The Ohio University campus has 114 buildings that are in the Hocking River flood plain. Through the years, the campus has suffered several devastating floods. In the 1970s, the river was relocated to help protect the campus. Since that time, the University has started to move into lower levels of building that are in the flood plain. To determine the best course of action in a flood situation, this program was developed.
In 1995, OU hired Woolpert to develop a planametric utility map of the campus. In conversations with the Cartography Department at the University, it was determined that we might be able to use this 3-dimentional map to predict flooding scenarios. Over the course of two years and several detours, a 3-dimentional model of the campus was developed that shows where the water would first come over the levee and how it would migrate through the campus. This will be used to determine where the efforts in flood control would be the most beneficial. Also a web site has been developed that departments can type in what the expected flood level is and how it will affect their buildings.
Howard Fokes - Ohio University

UC San Diego’s "FacilitiesLink" website
The focus of the presentation is a realistic account of our work: the goals, challenges, real-world costs, ideas, problems, solutions, successes and value we've been able to add to our campus. We've been engaged in a 2-year $250K effort to develop a web-based campuswide data warehouse of information on campus facilities. We started in 1998 from ground zero with not much data and are now about 70% of the way there. The data warehouse includes:

• Campus maps, photography, and clickable navigation engine
• Accurate CAD space plans and raster/scanned as-builts
• Online, secure and updateable space inventories
• Building, department and neighborhood directories
• Facilities-related documents, reports, data and links

The data ownership and actual maintenance effort remains decentralized across about 10 different campus departments involved in various aspects of FM/AEC. The site uses web-based tools to provide decentralized control. Access is account-based and includes users from all different parts of the campus. This presentation provides (a) a picture of the situation at San Diego, (b) an overview of the system we built to address the campus' needs, and (c) talk about some of the important design and implementation decisions.