Sensitivity of Coastal Environments and Wildlife to Spilled Oil: Southern California: BIRDS (Bird Polygons)

This data set contains sensitive biological resource data for wading birds, shorebirds, waterfowl, raptors, diving birds, seabirds, passerine birds, and gulls and terns in Southern California. Vector polygons in this data set represent bird nesting, roosting, migratory staging, and wintering sites. Species-specific abundance, seasonality, status, life history, and source information are stored in relational data tables (described in the Overview_Description) designed to be used in conjunction with this spatial data layer. This data set comprises a portion of the ESI data for Southern California. ESI data characterize the marine and coastal environments and wildlife by their sensitivity to spilled oil. The ESI data include information for three main components: shoreline habitats, sensitive biological resources, and human-use resources. See also the NESTS data layer, part of the larger Southern California ESI database, for additional bird information.

The ESI data were collected, mapped, and digitized to provide environmental data for oil spill planning and response. The Clean Water Act with amendments by the Oil Pollution Act of 1990 requires response plans for immediate and effective protection of sensitive resources.

2098

Prepared by Research Planning, Inc., Columbia, South Carolina for the National Oceanic and Atmospheric Administration (NOAA), National Ocean Service, Office of Response and Restoration, Emergency Response Division, Seattle, Washington.

In addition to the geographic data layers, six relational attribute or data tables (BIORES, BREED, SEASONAL, SOURCES, SPECIES, and STATUS) are used to store the complex biological data in the ESI data structure. The geographic data layer containing biological resource information (in this case, BIRDS) is linked to the Biological Resources table (BIORES) using the unique ID and the lookup table BIO_LUT, or it can be linked directly using RARNUM. The ID is a unique combination of the atlas number (for the Southern California atlas, the number is 209), an element/layer specific number (BIRDS are layer 1, FISH are layer 2, etc.), and a unique record number. The RARNUM represents a unique combination of species, seasonalities, concentrations, and source information. For each of these groupings, a number is generated. That number is concatenated with the atlas number to create a "resource at risk" number that is unique across atlases. BIORES and the other relational data tables are described in detail in the Detailed_Description sections. See the Browse_Graphic section for a link to the entity-relationship diagram, which describes the way these tables relate to the geographic data layers and other attribute tables in the ESI data structure. Due to the complexity of the relational database model, the data items are also post-processed into a flat file format. This table, called BIOFILE, may be used in place of the relational files described below to ease simple data queries. The items in the flat file are ELEMENT, SUBELEMENT, NAME, GEN_SPEC, S, F, NHP, DATE_PUB, CONC, JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC, BREED1, BREED2, BREED3, BREED4, BREED5, RARNUM, G_SOURCE, S_SOURCE, and BREED. All of these items are the same as their counterparts in the individual data tables (described in the Detailed_Description sections), except the BREED1-BREED5 and BREED items. BREED is a newly generated variable used to link to the BREED_DT data table, a modified, more compact version of the relational BREED data table. BREED1-BREED5 give a text summary of when each life stage occurs within the associated map object. The life stages referred to are the same as those listed in the Detailed_Description of the BREED data table. The link to the BIOFILE may be made through the BIO_LUT, using ID to link to RARNUM, or BIOFILE may be linked directly to the RARNUM in each of the geographic layer's attribute data tables. As mentioned, BREED_DT is an auxiliary support data table to the flat file structure, which allows the user to do searches based on month for seasonal breeding activities. The link from the flat file to BREED_DT is the BREED item. A second supporting data table is SOURCES. This is the same as the source file described above, and the link from the flat file is both G_SOURCE and S_SOURCE. It should be noted that although the flat file eases data query, it is not a normalized database structure, and actual updates performed by the states and other responsible agencies should be done using the relational data tables. The entity-relationship diagram, describing relationships between attribute tables in the ESI data structure, does NOT include the BIOFILE data table, and this data table is NOT described in a Detailed_Description section.

A complete description of entity types, attributes, and attribute values for ESI atlases can be found in the NOAA ESI Guidelines (http://response.restoration.noaa.gov/esi_guidelines).

Although these data have been processed successfully on a computer system at the National Oceanic and Atmospheric Administration, no warranty, expressed or implied, is made by NOAA regarding the utility of the data on any other system, nor shall the act of distribution constitute any such warranty. NOAA warrants the delivery of this product in computer-readable format, and will offer a replacement copy of the product when the product is determined unreadable by computer input peripherals, or when the physical medium is delivered in damaged condition.

Contact NOAA for distribution options (see Distributor). ESI data are processed into multiple formats to make them useful to a wider community of GIS/mapping users. Distribution formats include ARC export, MOSS and Shape files, and MARPLOT map folders. An ArcView ESI project and ESI_Viewer product are also included on the distribution CDs for ease of use of the ESI data. The database files are distributed both in the NOAA standard relational database format (see NOAA Technical Memorandum NOS ORCA 115) and in a simplified desktop flat file format. This metadata document includes information on both of these database formats.;

None

DO NOT USE MAPS FOR NAVIGATIONAL PURPOSES. Besides the above warning, there are no use constraints on these data. Note that the ESI database should not be used to the exclusion of other pertinent data or information held by state or federal agencies or other organizations. Likewise, information contained in the database cannot be used in place of consultations with environmental, natural resource, and cultural resource agencies, or in place of field surveys. Recognize that the information contained in the ESI database represents known concentration areas or occurrences of natural, cultural, and human-use resources, but does not necessarily represent the full distribution or range of each species or resource. This is particularly important to recognize when considering potential impacts to protected resources, such as endangered species, wetlands, etc. Acknowledgment of the originators, publishers, contributors, and sources listed would be appreciated in products derived from these data.

The software packages used to develop the atlas are Environmental Systems Research Institute's ARC/INFO(R) (version 9.3) and SQL SERVER(R) (version 2000). The hardware configuration is PC's with Windows Operating System (2000/XP/2003). The Spatial_Data_Organization Information section refers only to the source files in the ARC export format. The following files are included in the data set: acp.e00, birds.e00, esi.e00, fish.e00, fishl.e00, habitats.e00, hydro.e00, index.e00, invert.e00, m_mammal.e00, mgt.e00, nests.e00, reptiles.e00, socecon.e00, and t_mammal.e00. Associated relational and desktop data tables provided in Arc export and text format are bio_lut.e00, biofile.e00, biores.e00, breed.e00, breed_dt.e00, seasonal.e00, soc_dat.e00, soc_lut.e00, sources.e00, species.e00, and status.e00.

A multi-stage error checking process is used to verify both attribute accuracy and logical consistency throughout data production. The process includes a standardized data entry methodology, hardcopy data review by in-house and external resource experts, a final Quality Assurance/Quality Control (QA/QC) process, and multiple automated logical consistency checks. Quantitative data (such as densities, counts, abundances, or concentrations) provided by resource experts for inclusion in the data set may vary widely in attribute accuracy, depending upon the methodology used to collect and compile such data. For a more detailed evaluation of source data attribute accuracy, contact the sources listed in the Lineage section.

Spatial components for the biological data layers can come from expert interviews, hardcopy, or digital sources. Some of the spatial components of the biological data layers may have been developed using regional experts who estimate concentration areas. It is difficult to estimate the positional accuracy of such data, except to state that they are compiled on hardcopy base maps with a scale of 1:24,000. Some of the spatial components of the biological data sets are developed from pre-existing digital or hardcopy sources and reflect the positional accuracy of these original data. Note that biological resource data by their very nature are considered "fuzzy", and this should be understood when considering the positional accuracy of vector digital objects representing these resources. See the Lineage and Process_Description sections for more information on the original source data and how these data were integrated or manipulated to create the final data set.

These data represent a synthesis of expert knowledge, available hardcopy documents, and digital data on bird nesting, wintering, migratory staging and other spatial/temporal concentration areas. See also the NESTS data layer, part of the larger Southern California ESI database, for additional bird information. These data do not necessarily represent all bird occurrences in Southern California. The following species are included in this data set: (Species_ID, Common Name, Scientific Name [n/a if not applicable]): 1, Common loon, Gavia immer; 3, Red-throated loon, Gavia stellata; 6, Eared grebe, Podiceps nigricollis; 7, Western grebe, Aechmophorus occidentalis; 8, Double-crested cormorant, Phalacrocorax auritus; 9, Brandt's cormorant, Phalacrocorax penicillatus; 10, Pelagic cormorant, Phalacrocorax pelagicus; 12, Canada goose, Branta canadensis; 13, Brant, Branta bernicla; 14, Greater white-fronted goose, Anser albifrons; 15, Snow goose, Chen caerulescens; 16, Mallard, Anas platyrhynchos; 17, Northern pintail, Anas acuta; 18, Green-winged teal, Anas crecca; 20, Northern shoveler, Anas clypeata; 21, Canvasback, Aythya valisineria; 22, Greater scaup, Aythya marila; 23, Lesser scaup, Aythya affinis; 24, Common goldeneye, Bucephala clangula; 26, Bufflehead, Bucephala albeola; 30, Surf scoter, Melanitta perspicillata; 31, Pacific loon, Gavia pacifica; 33, Red-breasted merganser, Mergus serrator; 34, American coot, Fulica americana; 36, Glaucous-winged gull, Larus glaucescens; 37, Western gull, Larus occidentalis; 39, California gull, Larus californicus; 40, Ring-billed gull, Larus delawarensis; 42, Bonaparte's gull, Larus philadelphia; 43, Heermann's gull, Larus heermanni; 45, Common tern, Sterna hirundo; 46, Common murre, Uria aalge; 47, Pigeon guillemot, Cepphus columba; 49, Cassin's auklet, Ptychoramphus aleuticus; 50, Rhinoceros auklet, Cerorhinca monocerata; 52, Wilson's phalarope, Phalaropus tricolor; 53, Red-necked phalarope, Phalaropus lobatus; 54, Great blue heron, Ardea herodias; 55, Whimbrel, Numenius phaeopus; 57, Wandering tattler, Heteroscelus incanus; 58, Greater yellowlegs, Tringa melanoleuca; 60, Red knot, Calidris canutus; 62, Least sandpiper, Calidris minutilla; 63, Dunlin, Calidris alpina; 64, Short-billed dowitcher, Limnodromus griseus; 65, Long-billed dowitcher, Limnodromus scolopaceus; 66, Western sandpiper, Calidris mauri; 67, Sanderling, Calidris alba; 68, Black oystercatcher, Haematopus bachmani; 69, Semipalmated plover, Charadrius semipalmatus; 70, Killdeer, Charadrius vociferus; 71, Black-bellied plover, Pluvialis squatarola; 72, Surfbird, Aphriza virgata; 73, Ruddy turnstone, Arenaria interpres; 74, Black turnstone, Arenaria melanocephala; 76, Bald eagle, Haliaeetus leucocephalus; 77, Osprey, Pandion haliaetus; 85, California least tern, Sternula antillarum browni; 86, Least tern, Sternula antillarum; 87, Little blue heron, Egretta caerulea; 88, Great egret, Ardea alba; 89, Snowy egret, Egretta thula; 90, Black-crowned night-heron, Nycticorax nycticorax; 96, Leach's storm-petrel, Oceanodroma leucorhoa; 97, Green heron, Butorides virescens; 100, Black-legged kittiwake, Rissa tridactyla; 107, Peregrine falcon, Falco peregrinus; 118, Brown pelican, Pelecanus occidentalis; 124, Redhead, Aythya americana; 129, Northern fulmar, Fulmarus glacialis; 131, White-tailed kite, Elanus leucurus; 133, Black skimmer, Rynchops niger; 134, Gull-billed tern, Gelochelidon nilotica; 136, Caspian tern, Hydroprogne caspia; 137, Royal tern, Thalasseus maximus; 138, Forster's tern, Sterna forsteri; 141, American avocet, Recurvirostra americana; 142, Black-necked stilt, Himantopus mexicanus; 143, Xantus's murrelet, Synthliboramphus hypoleucus; 144, Ashy storm-petrel, Oceanodroma homochroa; 145, Elegant tern, Thalasseus elegans; 146, Black storm-petrel, Oceanodroma melania; 148, Ruddy duck, Oxyura jamaicensis; 152, American oystercatcher, Haematopus palliatus; 155, Willet, Catoptrophorus semipalmatus; 160, Red phalarope, Phalaropus fulicaria; 162, Gadwall, Anas strepera; 163, Reddish egret, Egretta rufescens; 169, American wigeon, Anas americana; 172, Sandhill crane, Grus canadensis; 176, Short-eared owl, Asio flammeus; 179, Pied-billed grebe, Podilymbus podiceps; 181, Northern harrier, Circus cyaneus; 182, American kestrel, Falco sparverius; 187, Virginia rail, Rallus limicola; 188, Sora, Porzana carolina; 200, Sooty shearwater, Puffinus griseus; 202, Pink-footed shearwater, Puffinus creatopus; 205, Light-footed clapper rail, Rallus longirostris levipes; 209, Long-billed curlew, Numenius americanus; 210, Marbled godwit, Limosa fedoa; 216, Belted kingfisher, Ceryle alcyon; 220, Merlin, Falco columbarius; 225, Marsh wren, Cistothorus palustris; 230, Red-tailed hawk, Buteo jamaicensis; 239, Clark's grebe, Aechmophorus clarkii; 261, Brown booby, Sula leucogaster; 270, Western snowy plover, Charadrius alexandrinus nivosus; 271, Rails, n/a; 272, Teals, Anas sp.; 273, Geese, n/a; 278, Saltmarsh sharp-tailed sparrow, Ammodramus caudacutus; 286, Dowitchers, Limnodromus spp.; 299, Scaup, Aythya spp.; 302, Scoters, Melanitta spp.; 326, Jaegers, Stercorarius spp.; 345, Storm-petrels, Oceanodroma spp.; 349, Burrowing owl, Athene cunicularia hypugea; 387, Buteo hawks, Buteo spp.; 396, Phalaropes, Phalaropus spp.; 406, Cinnamon teal, Anas cyanoptera; 455, Yellow-billed cuckoo, Coccyzus americanus; 462, Loons, Gavia spp.; 646, Black-vented shearwater, Puffinus opisthomelas; 722, Common yellowthroat, Geothlypis trichas; 811, Willow flycatcher, Empidonax traillii; 851, Belding's savannah sparrow, Passerculus sandwichensis beldingi; 852, Buller's shearwater, Puffinus bulleri; 853, California horned lark, Eremophila alpestris actia; 854, Coastal California gnatcatcher, Polioptila californica californica; 855, Large-billed savannah sparrow, Passerculus sandwichensis rostratus; 856, Least Bell's vireo, Vireo bellii pusillus; 857, Ross's goose, Chen rossii; 1001, Gulls, n/a; 1002, Shorebirds, n/a; 1003, Waterfowl, n/a; 1004, Wading birds, n/a; 1005, Raptors, n/a; 1006, Diving birds, n/a; 1008, Terns, n/a; 1009, Shearwaters, n/a; 1010, Pelagic birds, n/a; 1013, Dabbling ducks, n/a; 1014, Diving ducks, n/a; 1015, Egrets, n/a; 1016, Herons, n/a; 1019, Sea ducks, n/a; 1021, Ducks, n/a; 1022, Seabirds, n/a; 1024, Alcids, n/a; 1026, Grebes, n/a; 1035, Pelicans, Pelecanus spp.; 1037, Cormorants, Phalacrocorax spp.

A multi-stage error checking process, described in the above Attribute_Accuracy_Report, is used to verify both attribute accuracy and logical consistency throughout data production. This process includes multiple automated logical consistency checks that test the files for missing or duplicate data, rules for proper coding, GIS topological consistencies (such as dangles, unnecessary nodes, etc.), and SQL SERVER(R) to ARC/INFO(R) consistencies. A final review is made by the GIS manager, where the data are written to CD/DVD and the metadata are written. After the data are delivered to NOAA, they are again subjected to a number of quality and consistency checks. In the process of checking for topological and database consistencies, new ID's and RARNUM's or HUNUM's are also generated. The new ID's are a combination of atlas number, element number, and record number. In addition, the value used to represent the element is modified to reflect the type of feature being mapped. In the case of an element that is normally represented by a point or polygon, a value of 20 is added to the standard element value for mapping of linear features. In the case where an element usually mapped as a polygon is represented by a point, a value of 30 is added to the regular element value. The RARNUM's are also modified to include the atlas number, so multiple atlases can be combined and RARNUM's remain unique. RARNUM's are redefined on an element basis, so "resource at risk" groupings will contain only a single element. HUNUM's are also modified to include the atlas number.