|
Creation of a Geodatabase of the Digital Aerial Photography Archives for the Greater Everglades of South Florida and the Southern Inland and Coastal System
Coffin1, A.C., Mounts2, H., Henkel3, H., Briere4, P.R.,
Foster5, A.M., Smith3 III, T.J., and Wertz3, R.R.
1University of Florida, Dept. of Geography / LUECI and U.S. Geological Survey, Gainesville, FL
2GIS Solutions, St. Petersburg, FL
3U.S. Geological Survey, St. Petersburg, FL
4Dyncorp Systems and Solutions, LLC, Gainesville, FL (currently 3001, Inc.)
5U.S. Geological Survey, Gainesville, FL
Presented at the Joint Conference on the Science and Restoration of the Greater Everglades
and Florida Bay Ecosystem, Palm Harbor, FL April 2003.
Digital archives of historic aerial photography
The project to create a digital archive of historical aerial photographs for the Greater Everglades is an important first step in the development of an understanding of the pre-drainage vegetation in the south Florida landscape. This knowledge is essential in the development of endpoints, restoration goals and performance measures to gauge restoration success. Work on the digital archive has progressed with the creation of two open file reports publishing maps from 1927 – 1935 and imagery from 1940.
Database development
Concurrent with the development of the digital archive, information about the photography was recorded in a relational database using Microsoft Access. The data recorded included information on the flight, the photography, the scanning process and detailed information on each individual photograph.
|
 As of March, 2003, over 8000 photographs have been cataloged
in the Everglades Historical Aerial Photographic Database. (click to enlarge)
|
|
|
Spatial integration of database and imagery in a geographic information system (GIS)
After scanning of the photography, georeferenced mosaics of the flight lines were constructed indicating the general locations of the photography. From these mosaics, approximate center points of each photograph were recorded in the database, thereby providing general locations to which the photographic metadata could be linked. The utility of linking the metadata with physical locations became readily apparent. It would be even more useful if the metadata about the photograph could be linked to each georeferenced raster image in the archive.
It has always been the intention of the digital archives project to create georeferenced imagery of the south Florida photography. However, in order for the imagery to be useful as a tool, it must be integrated into a geographic information system (GIS). This presents a challenge to users since, as individual files, the raster images are very large thus limiting their use to small study areas, and effectively restricting their use in landscape-scale analyses. The challenge of incorporating raster images with large file sizes (e.g., 160 MB) into a geographic information system is resolved in the ArcGIS geodatabase system using ArcSDE and Oracle database management software.
|
 Map showing approximate center points of photography in the Digital Aerial Photography Archives for the Greater Everglades. (click to enlarge)
|
|
|
Creation of a geodatabase
To test the geodatabase system as it applies to the Digital Aerial Photography Archives for the Greater Everglades of South Florida, a limited area was selected as a pilot project. The project consists of a geodatabase that includes georeferenced raster imagery from 1940, 1964 and 1987 incorporated with tables of detailed information about the photographs. It also includes vector files and raster imagery of the T-sheets that are based on a 1927 aerial photographic survey. The selected area corresponds to the Southern Inland and Coastal System of the Everglades. The geodatabase is part of the South Florida Information Access (SOFIA) clearinghouse and can be searched and used free of charge by accessing the SOFIA web address (http://sofia.usgs.gov/exchange/).
|
U.S. Department of the Interior |
U.S. Geological Survey
