Abstract
Building a Map as a Fish Sampling and Assessment Tool Track: Forestry, Wildlife, and Fisheries Management Author(s): Sue Roberts, Robert Brodberg, Margy Gassel The Office of Environmental Health Hazard Assessment issues fish consumption advisories for chemically contaminated sport fish. We are using ArcGIS to make decisions about sampling and when to merge or separate data in the development of advisories for large water bodies with multiple sampling sites. As an example, we compiled data for Sacramento-San Joaquin Delta water bodies, using a relational database management system (MS Access) to merge multiple MS Excel files, saving the resulting file in dBASE format. A map displaying mercury concentrations in largemouth bass on the San Joaquin River was created using Esri ArcMap software, incorporating multiple attributes from fish data files with sample location and position. We added appropriate river and county shapefiles to ArcMap and brought in the dBASE file, using the latitude and longitude (X,Y) values to display sampling sites and chemical concentrations. This work has facilitated selection of target species and sampling sites. Sue Roberts Cal/EPA OEHHA PETS 1515 Clay St., 16th Floor Oakland , CA 94612 US Phone: 510-622-3148 Fax: 510-622-3218 E-mail: sroberts@oehha.ca.gov Robert Brodberg Cal/EPA Office of Environmental Health Hazard Assessment PETB 1515 Clay Street, 16th Floor Oakland , CA 94612 US Phone: 1-916-323-4763 E-mail: rbrodber@oehha.ca.gov Margy Gassel Cal/EPA Office of Environmental Health Hazard Assessment Pesticide and Environmental Toxicology Branch 1515 Clay Street, 16th Floor Oakland 94612 US Phone: 510-622-3166 Fax: 1-510-622-3218 E-mail: mgassel@oehha.ca.gov |
|||||
