Designing Geodatabases for Transportation. J. Allison Butler
Чтение книги онлайн.

Читать онлайн книгу Designing Geodatabases for Transportation - J. Allison Butler страница 4

Название: Designing Geodatabases for Transportation

Автор: J. Allison Butler

Издательство: Ingram

Жанр: Базы данных

Серия:

isbn: 9781589482913

isbn:

СКАЧАТЬ is whether the organization can survive the changes that go with implementing the solution.

      This implementation issue is addressed in two ways. First, the book focuses on the data editing part of the geodatabase design problem so that any changes would affect a small part of a larger organization, limited to the people who edit data for others to use. This is done by separating the editing database—which should be normalized to preclude data redundancy and its resulting data quality effects—from the published database—which should be defined by the needs of applications that use it. This is the heart of the “measure once, cut twice” philosophy. Rather then separately and duplicatively maintaining all the parallel, application-specific databases a large organization may need, you create an editing environment that feeds information to those applications. Not only does this approach allow the applications and the supporting editing process to evolve independently, it reduces the impact of change in geodatabase design to the data-maintenance portion of the organization.

      This is the first book to show the ArcGIS user how IT database design concepts can be employed by GIS data of all themes. When you follow these concepts, you are reducing risk to your organization and facilitating the migration of spatial data previously reserved for a few GIS users to the enterprise. You are also reducing risk for yourself, while increasing your value to the organization.

      The second way Designing Geodatabases for Transportation attempts to address the difficulty of change is by presenting design ideas as a cafeteria of choices rather than as a fixed-price menu. Change can be implemented gradually. There is no need for an all-or-nothing decision. Certainly, you must set a goal, but you can reach it in small steps. Each step along the way provides additional functionality and/or solves an existing problem. As long as you know where you are going, you can get there with the solutions offered in this book.

      Some of the larger graphics in the book are available for easier viewing at ESRI’s transportation industries Web site:

      http://www.esri.com/industries/transport/resources/data_model.html.

      Whether you are interested in transportation geodatabase design for a city, county, state, province, or country, Designing Geodatabases for Transportation provides insight into the problems you face and the various ways they can be solved. For those agencies that share data with others or receive their data from an external source, this book illustrates how to integrate data using various structures. As the road and bridge building boom of last century has faded, transportation agencies have shifted their focus to maintenance and operation. Such a change in mission underscores the need for multimodal geodatabases in transportation agencies. Designing Geodatabases for Transportation shows how to meet the needs of each mode within the context of a multimodal editing environment.

      J. Allison Butler

      Orlando, Florida

       Acknowledgments

      No book of this magnitude makes it to publication without a host of people providing critical support along the way. Principal among these is Dr. Kenneth J. Dueker, professor emeritus of Portland State University’s Center for Urban Studies. Although he is now officially retired, Ken continues to be active in his newly adopted community of Kirkland, Washington, where he and his wife, Donna, care for their grandchildren. Ken and I first started talking back in 1994, when we were both reviewers of the work by the National Cooperative Highway Research Program (NCHRP) 20-27(2), which developed the first industry data model for transportation geographic information systems. Within a year, Ken and I were co-authoring papers on the subject. Ken has been a mentor, collaborator, and good friend ever since. He was the first person to read the entire final draft. I am grateful that he has provided the foreword to top off his many contributions to this book. Designing Geodatabases for Transportation would not exist without Ken’s guidance over the past 13 years.

      In many ways, this book has been written over a 22-year period with a wide number of “co-authors.” It began in 1986 with Jim Smith and me developing some prototype relational databases for work program administration at the Florida DOT. This effort then grew through Jesse Day, Gordon Morgan, and others to become the Traffic and Roadway Characteristics Reporting system, which resulted in the first statewide GIS in Florida. Switching to local government in 1997, Mayor Claude Ramsey and Assessor of Property Bill Bennett in Hamilton County Tennessee provided the support necessary to expand the state DOT work to meet the needs of local and regional users. Alan Voss at the Tennessee Valley Authority provided considerable professional guidance for the work at Hamilton County. That effort then led to my projects with Mike Wierzbinski and Bill Campbell at Farragut Systems, such as the data model development program at the Colorado DOT, where Tammy Lang, Marvin Koleis, Lou Henefeld, Paul Tessar, and many others both refined the ideas and provided a real-world test of most of the major ideas presented in this book. John Sutton provided the opportunity to work on a very different data structure with Nancy Armentrout at the Maine DOT, which tested the flexibility of the design.

      Along the way, there were others who have contributed ideas and support. Alan P. Vonderohe, Teresa M. Adams, and Nicholas Koncz have to be at the top of that list with their work on the NCHRP 20-27 project. Al Vonderohe also worked with Todd Hepworth to develop the concepts of a linear datum. Bruce Spear and Mark Bradford at the U.S. DOT sponsored a number of efforts that generated ideas on feature identification. Harvey J. Miller and Shih-Lung Shaw, who wrote the very first scholarly book on GIS-T, set the stage for my subsequent work. Even the people who disagreed with some of my ideas, like David Fletcher, Paul Scarponcini, Val Noronha, and Zhong-Ren Peng, helped improve the content of this book through their challenging critiques of earlier work.

      Equally responsible for this book’s publication is the project’s sponsor, Terry Bills, the transportation industry manager at ESRI. Shortly after Terry took the job, he came to me and said, “We need to do something.” Do something, we have. Terry put his money where his mouth is, resulting in this book. His guiding hand was instrumental in setting the direction for the book and making sure that it both met the reader’s needs and was technically correct.

      Aiding Terry and me in that last task were Adrien Litton, Heather McCracken, Eric Floss, and Laurie Cooper of ESRI; and Ron Cihon of the Washington State Department of Transportation. They each spent days reading the draft chapters and offering constructive criticisms. All of these people had to make time in their schedules to get this work done, but no one else could have provided the technical insight and user perspective.

      The work of all of these people would never have reached your hands without the hard work of people at ESRI Press. My editor was Mike Kataoka, who worked with designers Donna Celso and Jennifer Hasselbeck, graphics editor Jay Loteria, and copy editor Julia Nelson to produce the book under the guidance of Judy Hawkins, former ESRI Press manager, and Peter Adams, current manager. Stacks of written pages and scores of figures have been transformed into this attractive book through their hands.

      I also thank David Arctur and Michael Zeiler, authors of the ESRI Press publication, Designing Geodatabases, for setting the standard for geodatabase design books, and Steve Grisé, chief data modeler for ESRI, for providing much of the data model development guidance contained in the book.

      Of course, all the folks at ESRI and ESRI Press work for Jack and Laura Dangermond, whose financial support of this book was critical. But their support goes further than the ESRI checkbook. ESRI, under Jack’s leadership, has been pursuing ways to open up the transportation world to GIS for 20 years with product functions like dynamic segmentation and support of industry data-modeling efforts like the Unified Network for Transportation (UNETRANS) effort at the University of California at Santa Barbara.

      The people who were especially patient with me СКАЧАТЬ