Listed below are the 2001 presentations, in various formats. Simply click
on the link to download the document. If you are prompted for a password, hit
CANCEL.
Size
Title
19 kb
20 kb
161 kb
408 kb
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.
22 kb
23 kb
65 kb
176 kb
Are you an AutoCAD user who is eager to learn how to integrate your
external databases? This course
will give a basic introduction to AutoCAD’s database connectivity
features. The course will address the advantages of using external
databases over other methods such as block attributes. The course will
also demonstrate how DbConnect can be used to establish links between
AutoCAD objects and external databases. Attendees will learn how to
configure AutoCAD’s database environment, establish database
links, and create dynamic labels. Scott McFarlane - Epoch, Inc.
870 kb
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
854 kb
24 kb
112 kb
This presentation will cover Purdue's office ergonomic program, ergonomic
risk factors, and setting up an ergonomically sound office work station. Alan Gerth - Purdue University
1,376 kb
System Development·Integration (SDI) has designed and
built a Web-enabled Facility Tracking System (FTS) to track and report
space inventory. Scanned and converted construction drawings are field
verified with accurate architectural base plans created and linked
to a relational database. Using a Web browser, authorized users can
query facility space/department information in the database in a secured
intranet environment to view user-friendly reports. The Web-enabled
FTS allows users to query for, and view, facility data and drawings
24 hours a day, 7 days a week. The ability to link all spaces to the
relational database is useful to view and plot graphic elements, track
space availability, and create space department and square footage
reports. In addition, construction drawings are archived into a document
management system providing instant, real-time access to the information
within the platform independent FTS. Bob Ladner - SDI
16,592 kb
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
25 kb
The Future of CMMS: Integrated Systems for the 21st Century - CMMS systems
can no longer be thought of as stand-alone systems. The increasing complexity
of Facility Management has caused a trend towards integration of Facility
IT systems to work together as an integrated whole. Increasingly, systems
such as Building Automation, Fire protection, and security systems are
becoming integrated, both by manufacturers, and by Integration companies
providing custom integration solutions. This presentation discusses the
introduction to CMMS Integration principles and methods, products available,
methods
of integration, some current examples of integration (such as
Airports, Facilities, and Universities), the Benefits
of Integration
(cost-benefit
analysis,
strategic and operational benefits, etc.), the likely future of integrated
systems. This presentation addresses both the IT challenges as well as
the Facility Management challenges involved, and will provide an overview
of the current and future state of the art in CMMS integration. I believe
that this presentation will be equally appealing to Facilities and IT
professionals. Thomas Condon - SDI
788 kb
The presentation discusses the implementation of a geodatabase in developing
an integrated GIS for Facilities Management at UVA. The project focuses on trying
to integrate utilities information, spatial and relational, and distributing
the same over the intranet and internet. The project also brings together data
from other source, including Property & Real Estate and Space Management.
The presentation explores the challenges and opportunities in implementing a
geodatabase in a traditionally CAD environment where it is absolutely essential
to exchange information, AutoCAD drawings, with external contractors & consultants.
Dhruv Jain - University of Virginia
3,221 kb
This session concentrates on the efforts that Purdue University
GIS/BIS Staff, with assistance from Woolpert LLP of Dayton OH, put
into creating a GIS, how it will be used with Project Design, and how
other Departments interact with the GIS. Purdue University is using
Bentley’s Microstation as a Graphic tool and Bentley’s
GepGraphics as the GIS tool.
Keith Moore - Physical Facilities, Purdue University
4,649 kb
GPS Demonstration - Michael O’Grady conducts a field presentation
on data collection using GPS equipment then show the office procedures
to bring that data to any CADD platform. Michael O'Grady - Trimble Navigation
19 kb
Michigan State University's GIS System - MSU's GIS system uses a variety
of different hardware and software platforms. This presentation will outline
the various components of the system and how the system is maintained and
expanded. A Q&A session will follow the presentation, time permitting.
MSU's use of the following will be covered: Apache+SSL, Tomcat/Java Server
Pages, MapGuide Server/Author/Utilities, Autocad Map/Architectural Desktop/Utilities,
Oracle/MySQL, CVS Code Versioning, DreamWeaver, Forte for Java, and custom
utilities including dynamic PDF generation. Chris Perry - Michigan State University
Keeping the Capital Plan on Track - This presentation focuses on how
the University of Iowa chose a project management system to help a small
staff manage an ever-increasing workload. The solution focused on the need
to
maintain the university’s current project management methodology
and enable it to quickly adopt new best practices, as well as help support
the Design and Construction Service department. The above project management
system has these project management process components: Project Scope Management,
Project Time Management, Project Cost Management, Project Resource Management,
Project Communication Management, Project Procurement Management. The Project
management system interfaces with a work order system, space management
system, document management system, and the University's Accounting, Human
Resources Systems and other ERP systems.
Randy Rohovit - University of Iowa
11,125 kb
3,113 kb
2,224 kb
System Development·Integration (SDI) has been assisting
the Computing Services group within Purdue’s Physical Facilities
Department to integrate the various automation components comprising
the Leapfrog Program. SDI was charged with investigating integration
technologies, researching best practices, and developing a plan for
integration. This presentation details the structured methodology developed
by SDI specifically to identify integration opportunities and
techniques for the Leapfrog applications, as well as with university-wide
and other departmental applications. Raymond Erdman - SDI
6,640 kb
89 kb
Physical Facilities Computer Support describes their experiences
with supporting a CAD environment. Chris will explain their server
infrastructure and what it takes to maintain them. The emphasis will
be on CAD software, file storage, and plotting. This presentation may
be set up as a panel discussion.
Purdue's Archiving System - This presentation discusses the process that
Facilities Planning at Purdue has gone through to replace the microfilming
method of drawing archival with a document imaging and retrieval method.
This Electronic Document Management System project included hardware, softwar,e
and services for design and implementation internal to Purdue University’s
Engineering, Utilities and Construction department. This project has addressed
the scanning, storage, and management of various paper documents. VanAusdall & Farrar
will implement a solution that will scan standard documents and large drawings.
Purdue has selected Hummingbird CyberDOCS as the EDMS system to allow for
storage and management of paper documents.
Mark Townsend - Physical Facilities, Purdue University
Purdue Consultants Package - a product produced by the GIS/BIS Staff
and Woolpert of Dayton, OH. This package includes graphic standards that
are required for all design work being produced by or for Purdue University.
The Consultants Package establishes as-built standards, minimizing the
effort essential to import information into the GIS. Therefore, these standards
improve our ability to translate design files from AutoCAD to Microstation
and back to AutoCAD. This session shows how established standards can improve
all methods of round tripping graphic files.
Keith Moore - Physical Facilities, Purdue University
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.
University of Washington's Approach to Document Management
Like most institutions, University of Washington has seen a tremendous
increase in the number of engineering documents delivered to support a
project. This presentation looks at the approach UW is taking to keep up
with and perhaps regain control of the documentation avalanche with staffing
available. Bert Johnson - University of Washington
22 kb
1,190 kb
Take your spatial data to the Web! This presentation discusses the
process of spatial-enablng data using a GIS web map product. Discussion
focuses on the necessary considerations to take into account when
Web-enabling spatial data. The presentation includes a live
demonstration based on a web project completed for a county government
Land Information Office.
The demo will show custom queries of both spatial and tabular data. Rebecca Cooper - SDI
5,255 kb
University of Wisconsin GIS Development and Photogrammetric Mapping -
The presentation discusses the University of Wisconsin - Madison's efforts
to develop and distribute campus map information through CAD and geographic
information systems (GIS). The University is currently in the process of
updating its digital orthophotography and planimetric base map and is developing
new distribution systems for map data. The speakers will address GIS and
photogrammetric mapping projects currently underway at UW Madison and the
University's plans for future GIS and mapping projects.
Steve Lacey - University of Wisconsin
Jason Nyberg - Ayres Associates
