USGS
South Florida Information Access
SOFIA home
Help
Projects
by Title
by Investigator
by Region
by Topic
by Program
Results
Publications
Meetings
South Florida Restoration Science Forum
Synthesis
Information
Personnel
About SOFIA
USGS Science Strategy
DOI Science Plan
Education
Upcoming Events
Data
Data Exchange
Metadata
geer > 2003 > posters > creation of a geodatabase of the digital aerial photography archives for the greater everglades of south florida and the southern inland and coastal system


Creation of a Geodatabase of the Digital Aerial Photography Archives for the Greater Everglades of South Florida and the Southern Inland and Coastal System

Poster presented April 2003, at the Greater Everglades Ecosystem Restoration Conference

Coffin1, A.C., Mounts2, H., Henkel3, H., Briere4, P.R., Foster5, A.M., Smith3 III, T.J., and Wertz3, R.R.

1 University of Florida, Dept. of Geography / LUECI and U.S. Geological Survey, Gainesville, FL
2 GIS Solutions, St. Petersburg, FL
3 U.S. Geological Survey, St. Petersburg, FL
4 Dyncorp Systems and Solutions, LLC, Gainesville, FL (currently 3001, Inc.)
5 U.S. Geological Survey, Gainesville, FL

Acknowledgements: The authors are grateful for the contributions of Kristi Capobianco and Andrea Chavez in georeferencing imagery

[ Disclaimer ]

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.

overlapping images of Seven Palm Lake from three time periods, and map of Florida showing location of Seven Palm Lake
Overlapping images of Seven Palm Lake from three time periods show the differing scales of the original imagery. [larger image]

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.

A sample of records from the database
a sample of records from the database
[click here to view an html version of this table]

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
Map showing approximate center points of photography in the Digital Aerial Photography Archives for the Greater Everglades. [larger image]

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/).

1964 SICS Area Photography shown on a map
[larger image]
1987 SICS Area Photography shown on a map
[larger image]



printer icon Click here for a printable version of this poster (note: document will open in a new browser window)

PDF icon Click here to download an 8.5 x 11 PDF version of the original poster (592 KB). PDF files require the Free Adobe Acrobat Reader ® to be read.

Related information:

SOFIA Project: Creation of a Digital Archive of Historical Aerial Photographs for Everglades National Park and the Greater Everglades Ecosystem




| Disclaimer | Privacy Statement | Accessibility |

U.S. Department of the Interior, U.S. Geological Survey
This page is: http://sofia.usgs.gov/geer/2003/posters/geodatabase/index.html
Comments and suggestions? Contact: Heather Henkel - Webmaster
Last updated: 09 October, 2003 @ 01:57 PM(TJE)