Air Force Plant 4 and adjacent Naval Air Station-Joint Reserve Base Carswell Field at Fort Worth, Texas, constitute a government-owned, contractor-operated facility that has been in operation since 1942. Contaminants from AFP4, primarily volatile organic compounds and metals, have entered the ground-water-flow system through leakage from waste-disposal sites and from manufacturing processes. The U.S. Geological Survey developed a comprehensive geodatabase of temporal and spatial environmental information associated with the hydrogeologic units (alluvial aquifer, Goodland-Walnut confining unit, and Paluxy aquifer) beneath the facility and a three-dimensional conceptual model of the hydrogeologic units integrally linked to the geodatabase. The geodatabase design uses a thematic layer approach to create layers of feature data using a geographic information system. The various features are separated into relational tables in the geodatabase on the basis of how they interact and correspond to one another. Using the geodatabase, geographic data at the site are manipulated to produce maps, allow interactive queries, and perform spatial analyses. The conceptual model for the study area comprises computer-generated, three-dimensional block diagrams of the hydrogeologic units. The conceptual model provides a platform for visualization of hydrogeologic-unit sections and surfaces and for subsurface environmental analyses. The conceptual model is based on three structural surfaces and two thickness configurations of the study area. The three structural surfaces depict the altitudes of the tops of the three hydrogeologic units. The two thickness configurations are those of the alluvial aquifer and the Goodland-Walnut confining unit. The surface of the alluvial aquifer was created using a U.S. Geological Survey 10-meter digital elevation model. The 2,130 point altitudes of the top of the Goodland-Walnut unit were compiled from lithologic logs from existing wells, available soil-boring logs, and previous studies. Data from 120 wells, primarily from existing reports, were used to create a map of the approximate altitude of the Paluxy aquifer.
