PWS_Attachment_9_-_Cavalier_AFS_EFDS_Status_Spreadsheet_08082013.xlsx
XLSX spreadsheet 36 KB Posted
- Attached to
- GEOSPATIAL SERVICES Federal contract opportunity
- Solicitation number
- FA2517-17-Q-5051
About this file
PWS Attachment 9
View the file
Other files for this federal contract opportunity
Show all 16
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Legend
| White Cells (not highlighted) | This feature class does not appear to be currently applicable to the installation. If it is, then supporting data is needed to identify it. |
| Yellow Cells | More information is needed to complete this feature class. Please refer to the follow-on questions in column G |
| Green Cells | Feature class is complete. |
EGYN CEA Checklist
| ENVIRONMENTAL MISSION DATA SET ASSET MANAGER CHECKLIST | ||||||||
| INSTALLATION: CAVALIER AFS | ORGANIZATION: 10 SWS (David Anderson 21 CES/CEIE Site Manager) | AS OF DATE: 30 MAY 2013 | ||||||
| ENTITY TYPE | DEFINITION (SDSFIE 2.600) | APPLICABLE TO INSTALLATION? (Y/N) | DATA ACQUIRED & POPULATED? (Y/N) | CURRENT STATUS | NOTES | QUESTIONS TO BE ANSWERED TO HELP CLOSE DATA GAPS | RESPONSE/DIRECTION FROM SITE MANAGER | 3.0 SD SFIE CROSSWALK FEATURE |
| dod_rpi_land_parcel_area | Represents the researched boundaries of land in which DoD holds fee-simple title (owned) or has retained certain less-than-fee surface rights and interests (non-owned). | Y | N | Incomplete | Only the installation area feature class exists for this entity type. The entity type could not be created and attributes properly updated. | Does parcel data exist for Cavalier AFS representative of the entity type definition found in cell B4? | LandParcel | |
| dod_rpi_site_area | Represents the geographic extent of all contiguous land parcels in which the DoD has legal interest. This includes owned lands (such as DoD holds fee-simple title to the land), and "non-owned" lands including leased land and other less-than-fee surface rights and interests currently held by DoD. | Y | N | Incomplete | Only the installation area feature class exists for this entity type. The entity type could not be created and attributes properly updated. | Does parcel data exist for Cavalier AFS representative of the entity type definition found in cell B5? | Site | |
| terrestrial_archeological_site | The location of a registered archeological site. | N | N | N/A | No registered archeological sites exist on the installation based on available documentation. | |||
| historic_structure_site | A structure that has cultural significance due to its historic background, association with a famous person, or its architectural features. | Y | Y | Complete | Cavalier ICRMP used as data source to complete feature class. | Nov 2008 Re-Evaluation of the National Register of Historic Places Eligibility of 34 Buildings and Structures and Four Roads Associated with the Perimeter Acquisition Radar Historic District at Cavalier Air Force Station, Pembina County, North Dakota sent for possible use in locating these structures. | HistoricObject | |
| cultural_survey_site | A site where detailed investigation has been conducted for cultural resources. This investigation could involve test pits, excavation areas, surface surveys, etc. | N | N | N/A | No cultural resources exist on the installation based on available documentation. | |||
| aquatic_habitat_area | Location in which aquatic plant and animal populations have been identified, mapped, or studied. | N | N | N/A | No aquatic habitat areas exist on the installation based on available documentation. | |||
| essential_fish_habitat_area | Essential fish habitats (EFH) are those regulatory defined waters and substrate necessary for fish for spawning, breeding, feeding, or growth to maturity | N | N | N/A | No fish habitats exist on the installation based on available documentation. | |||
| ecology_management_site | Ecology management areas including Eco regions. | Y | Y | Complete | http://www.epa.gov/wed/pages/ecoregions/ndsd_eco.htm Abstract: Eco regions by state were extracted from the seamless national shapefile. Eco regions denote areas of general similarity in ecosystems and in the type, quality, and quantity of environmental resources. They are designed to serve as a spatial framework for the research, assessment, management, and monitoring of ecosystems and ecosystem components. These general purpose regions are critical for structuring and implementing ecosystem management strategies across federal agencies, state agencies, and nongovernment organizations that are responsible for different types of resources within the same geographical areas. The approach used to compile this map is based on the premise that ecological regions can be identified through the analysis of patterns of biotic and abiotic phenomena, including geology, physiography, vegetation, climate, soils, land use, wildlife, and hydrology. The relative importance of each characteristic varies from one ecological region to another. A Roman numeral hierarchical scheme has been adopted for different levels for ecological regions. Level I is the coarsest level, dividing North America into 15 ecological regions. Level II divides the continent into 50 regions (Commission for Environmental Cooperation Working Group, 1997). At Level III, the continental United States contains 105 regions whereas the conterminous United States has 85 (U.S. Environmental Protection Agency, 2011). Level IV Eco regions are further subdivisions of Level III Eco regions. Methods used to define the Eco regions are explained in Omernik (1995, 2004), Omernik and others (2000), and Gallant and others (1989). | LandManagementZone | ||
| asbestos_cont_material_point | A room, space, or other location where an asbestos containing materiel (ACM) is present. | Y | Y | Complete | Data obtained from the Asbestos_Management_Plan_-_EPP_1_(2012_Plan) Note: Some features in the feature class represent more than one location within the facility that contain asbestos. Refer to the narrative field for a description. | HazardousMaterialSource | ||
| building_environmental_concern_site | Site of building or structure which contains one or more building environmental hazards. | Y | N | Incomplete | This feature class is a composite of other existing feature classes. | This feature class is a composite of other feature classes such as asbestos containing material point and lead paint hazard point. Does CAFS want this feature class created by merging the already created feature classes? | PotentialEnvironmentalSite_P | |
| lead_paint_hazard_point | A room, space, or other location where a paint or coating containing lead is present. | Y | N | Incomplete | The LBPP does not list the facilities with lead paint. The plan reads, "Records of LBP surveys conducted in 1995 and 1998 are located at the CAFS OM&S Contractor’s Environmental office, on the Local Area Network, and the 21 AMOS/SGPB Office. |
& LBP records are managed manually and electronically".
| Please provide the LBP records with Facility ID in order to complete this feature class. | HazardousMaterialSource | |||||||
| potential_pollution_rel_point | Location of an item which has been identified as a potential spill, emission, or pollution release source. | Y | Y | Complete | Data was obtained using Appendix 12 Summary of Potential Spills in the SPCC | EnvironmentalDischargePoint | ||
| field_sample_collection_location_point | The physical location at which one or more environmental hazards field samples are collected. | Y | N | Incomplete | Are field samples collected on the installation? Perhaps for old IRP sites? If so please provide documentation. | EnvironmentalSampleLocation | ||
| hazardous_waste_disposal_area | A location which has been used for the disposal of hazardous waste (e.g., pit, buried drums, etc.). | N | N | N/A | No hazardous waste disposal areas exist on the installation based on available documentation. | |||
| polluted_area_of_concern_area | The defined area of a polluted area of concern located within an environmental hazards site. | N | N | N/A | No polluted area of concern exist on the installation based on available documentation. | |||
| pollution_source_point | Point of origin of a chemical, radioactive, medical, or mixed non-permitted waste discharge, spill, or uncontrolled release which can result in pollution to the environment. | N | N | N/A | No pollution source points exist on the installation based on available documentation. | |||
| hazardous_materiels_storage_location_site | Location where hazardous materials are stored. | Y | N | Incomplete | The Hazardous Waste Management Plan does not list the locations where hazardous materials are stored. | Need list of facilities that store HAZMAT. | HazardousMaterialManagement | |
| hazwaste_storage_loc_point | Location points or areas where hazardous waste is stored. | Y | Y | Complete | Data obtained from the Hazardous Waste Management Plan - EPP 3 (2012 Plan) | HazardousWasteManagement_A | ||
| aboveground_storage_tank_site | A receptacle or chamber used for storing bulk fuels or chemicals of which 90 percent or more is located above the surface of the ground. | Y | Y | Complete | Data obtained from the SPCC April 2012 Appendix 1 and 2 | AboveGroundStorageTank | ||
| underground_storage_tank_site | A receptacle or chamber used for storing bulk fuels or chemicals of which 10 percent or more is located beneath the surface of the ground. | Y | Y | Complete | Data obtained from the SPCC April 2012 Appendix 1 and 2 | UnderGroundStorageTank_P | ||
| environmental_restoration_site | A geographic area where an active environmental study or project is underway to remediate pollutants located in the soil, sediment, surface water, or groundwater. | Y | N | Incomplete | Old Skeet Range Clean-Up Site | Is documentation available to help create this feature class? | EnvironmentalRemediationSite | |
| potential_env_concern_site | A site of suspected environmental contamination. | N | N | N/A | No areas of suspected contamination exist on the installation based on available documentation. | |||
| solid_waste_dump_area | Any discernible unit at which solid wastes have been discarded or disposed of at any time, which was not specifically designed, managed, and/or permitted for such purpose. | N | N | N/A | No solid waste dump areas exist on the installation based on available documentation. | |||
| solid_waste_landfill_area | A facility or site, permitted by a regulatory authority, which is specifically designed and managed for the land disposal of solid waste | N | N | N/A | No landfills exist on the installation based on available documentation. | |||
| solid_waste_stockpile_area | Area used for short term collection and storage of solid waste prior to it's transfer to a disposal or treatment facility. | Y | N | Incomplete | Data obtained from the Solid Waste Management Plan Rev-C May 2012 Section 5.7 | Confirm the locations and extend of the polygons of the feature class to ensure the location is accurate. | TBD | |
| fauna_hazard_area | An area where there are hazards due to wildlife activities. This includes bird aircraft strike hazard (BASH) areas, and deer strike areas. | N | N | N/A | No BASH or deer strike areas exist on the installation based on available documentation. | |||
| fauna_special_species_site | A site or location where the specific species associated with the habitat require special attention according to law. These are normally threatened, sensitive, or endangered species habitats. | N | N | N/A | No fauna special species data exists based on available documentation. | |||
| fauna_species_site | A site or location where a specific species is observed. | N | N | N/A | No fauna species site data exists based on available documentation. | |||
| fauna_viewing_point | A site where wildlife can be regularly viewed. | N | N | N/A | No fauna viewing points exist on the installation based on available documentation. | |||
| government_wildlife_management_area | An area either owned by federal, state, or local governments or government agencies specifically identified for management or preservation of wildlife. | N | N | N/A | No WMAs exist on the installation based on available documentation. | |||
| flora_special_species_site | A site or location where there are threatened, endangered, invasive, or sensitive floral species. | N | N | N/A | No flora special species site data exists on the installation based on available documentation. | |||
| flora_species_site | The specific location where an individual flora species or an aggregate of flora species has been identified | N | N | N/A | No flora species site data exists on the installation based on available documentation. | |||
| land_vegetation_area | A discrete area where land flora has been classified. | N | N | N/A | No land vegetation data exists on the installation based on available documentation. | |||
| flora_fire_area | Areas where a fire has occurred in the past with some regularity/frequency, and/or, reason to expect fires could occur within a particular habitat area in the future. Can be a prescribed fire that burns within prepared lines, enclosing a designated area, under predetermined conditions or an unplanned fire. | N | N | N/A | No fauna viewing points exist on the installation based on available documentation. | |||
| forest_management_area | A dense growth of trees and underbrush covering a large tract. | N | N | N/A | No fauna viewing points exist on the installation based on available documentation. | |||
| wilderness_area | Bounded land, virtually unsettled and uncultivated (natural); includes areas designated by an administrative group as wilderness, primitive, wild and scenic, or similar designations. Has use restrictions. | N | N | N/A | No WMAs exist on the installation based on available documentation. | |||
| surface_riparian_area | A vegetated ecosystem along a water body through which energy, material, and water pass and is managed to maintain the integrity of stream channels and shorelines, to reduce the impact of upland sources of pollution by trapping, filtering, and converting sediments, nutrients, and other chemicals, and to supply food, cover, and thermal protection to fish and other wildlife. | |||||||
| N | N | N/A | No riparian areas exist on the installation based on available documentation. | |||||
| shoreline_buffer_critical_area | An area of land extending from the shoreline or from the landward boundary of any adjacent tidal wetland where development is regulated. Activities within this critical area have the greatest potential for affecting water quality as well as fish, plant, and wildlife habitat. | N | N | N/A | No shorelines exist on the installation based on available documentation. | |||
| flood_zone_area | An area where statistically derived flood inundation may exist within a specific return period, i.e. 100 year or 500 year chance of flooding, for insurance and floodplain management purposes. | N | N | N/A | No flood zones exist on the installation based on available documentation. | |||
| playa_lake_area | A desert basin that temporarily becomes a shallow lake after heavy rains. | N | N | N/A | No desert basins exist on the installation based on available documentation. | |||
| watershed_area | The region or area drained by, or to, a particular body of water. | Y | Y | Complete | Data downloaded from: http://web.apps.state.nd.us/hubdataportal/srv/en/main.home. This data set is a complete digital hydrologic unit boundary layer to the sub-watershed (12-digit) 6th level for the entire United States. | AdministrativeBoundary | ||
| watershed_drainage_area | A specific subarea of a watershed. | N | N | N/A | The watershed drainage area could not be located online or via available documentation. | |||
| reservoir_management_area | A man-made area intended to contain or store water. | Y | N | Incomplete | Add from CIP Survey. Underground Structure | Any documentation in reference to the reservoir is needed to create this feature class. | TBD | |
| aquifer_area | An area of subsurface water bearing stratum, sand or gravel. | N | N | N/A | No aquifer data exists based on available documentation. | |||
| canal_area | An area feature of an artificial watercourse of relatively uniform dimension, cut through an inland area, and designated for navigation, drainage, or irrigation, with or without flow. | N | N | N/A | No canals exist on the installation based on available documentation. | |||
| canal_centerline | The centerline of an artificial watercourse of relatively uniform dimension, cut through an inland area, and designated for navigation, drainage, or irrigation, with or without flow. | N | N | N/A | No canals exist on the installation based on available documentation. | |||
| ditch_aqueduct_centerline | Manmade or improved waterway designed to transport water for irrigation or other use. | N | N | N/A | No ditch/aqueduct exist on the installation based on available documentation. | |||
| wetland_area | Those areas that are inundated or saturated by surface or ground water at a frequency and duration sufficient to support, and that under normal conditions do support, a prevalence of vegetation typically adapted for life in saturated soil conditions. | N | N | N/A | No wetlands exist on the installation based on available documentation. | |||
| wetland_buffer_area | Areas surrounding certain types of wetlands where any development is restricted. The buffer distance can differ based upon state regulations and the type of wetland. | N | N | N/A | No wetlands exist on the installation based on available documentation. | |||
| boat_ramp_site | A partially submerged hard surfaced structure on a shoreline for launching or retrieving vessels or vehicles. | N | N | N/A | No boat ramps exist on the installation based on available documentation. | |||
| fishing_site | A site specifically designated for sport or recreational fishing. | N | N | N/A | No fishing areas exist on the installation based on available documentation. | |||
| hunting_area | Areas specifically designated for the controlled hunting of one or more wildlife species. | N | N | N/A | No hunting areas exist on the installation based on available documentation. | |||
| marine_recreation_area | Areas in or near water where recreation occurs and that can be used to manage individual activities. | N | N | N/A | No marine recreation areas exist on the installation based on available documentation. | |||
| miscellaneous_recreation_area | An area set aside for use in general recreation activities, which does not qualify for in any of the other outdoor recreation entity types. | Y | Y | Complete | This feature class existed. I add the skate rink Facility ID 719 (west of MFH). The Facility ID for the existing recreation areas should be added. | Do Facility ID's exist for the horse shoe pits and BBQ pits? | Nov 2008 Re-Evaluation of the National Register of Historic Places Eligibility of 34 Buildings and Structures and Four Roads Associated with the Perimeter Acquisition Radar Historic District at Cavalier Air Force Station, Pembina County, North Dakota has playground, pavilion and ice rink noted in it that might help populate these features. | RecreationArea_A |
| picnic_site | A site designated for outdoor consumption of food, either with tables or simply as a scenic spot for eating. | Y | N | Incomplete | No data to confirm this feature class is valid. | Is this feature class applicable for Cavalier AFS? | RecreationArea_A | |
| recreation_feature_point | Recreation facility features such as recreation trail entry/exit points, exercise equipment, etc. | Y | N | Incomplete | No data to confirm this feature class is valid. | Is this feature class applicable for Cavalier AFS? | RecreationArea_A | |
| recreation_trail_site | Trails for recreational activities (running/walking, biking, hiking). | N | N | N/A | No recreation trails exist on the installation based on available documentation. | |||
| natural_resources_well_point | N | N | N/A | No natural resource wells exist on the installation based on available documentation. | ||||
| well_field_site | An area containing natural resources wells for example oil or gas wells. | N | N | N/A | No natural resource wells exist on the installation based on available documentation. | |||
| agricultural_tract_area | Location of agricultural tract areas | N | N | N/A | No agricultural tracts exist on the installation based on available documentation. | |||
| cemetery_site | An area containing one or more human gravesites. | N | N | N/A | No cemetery's exist on the installation based on available documentation. | |||
| grounds_maintenance_area | Outside areas where landscaped vegetation are maintained. | Y | Y | Complete | Completed using the Cavalier INRMP Figure 9.7.1 Grounds Maintenance Plan (May 2007) | GroundsMaintenance | ||
| interest_point | Points of general interest including, but not limited to, environmental, cultural, historic and civic sites. | Y | N | Incomplete | Is this valid? What points are considered? | TBD | ||
| land_cover_area | This feature describes the appearance of the surface of the Earth. | Y | N | Incomplete | A valid feature class could not be created from external data sources. Are they any maps or PDFs with land use/land cover? | LandCover | ||
| land_use_area | This feature describes man's categorization of the use of land and water. | Y | N | Incomplete | A valid feature class could not be created from external data sources. Are they any maps or PDFs with land use/land cover? | LandUse | ||
| land_reclamation_project_site | Sites where an ecosystem has been reclaimed or enhanced by man's efforts. This includes the restoration or creation of wetlands, dunes, stable shorelines, etc. | Y | N | Incomplete | Is the old IRP site information valid for this feature class? If so please provide the documentation. | NaturalResourceResRecProject | ||
| land_restriction_area | Areas which are subject to local limitations on actions which can be performed on the land. | N | N | N/A | No restricted land areas exist based on available documentation. | |||
| pest_management_site | A site where specific actions are being taken to control insects, rodents, or other pests. | Y | N | Incomplete | Need a copy of the Cavalier Invasive Control Plan FINAL May 2005.pdf | Are there exterior areas treated for pests? (Could not determine locations in the IPMP. Do you want to add invasive plant species to this feature class as a pest? If so does the Cavalier Invasive Control Plan FINAL May 2005.pdf display these areas? | PestManagement | |
| underwater_rock_area | A rock or mass of stony material or coral which is awash or below the surface of the water. | N | N | N/A | No underwater structures exist on the installation based on available documentation. | |||
| soil_map_unit_area | An area with similar soil characteristics. The size of the units used for an installation differs based upon the smallest area of land that is managed for a particular land use. | Y | Y | Complete | Data obtained from: http://soildatamart.nrcs.usda.gov/ Description: This data set is a digital soil survey and generally is the most detailed level of soil geographic data developed by the National Cooperative Soil Survey. The information was prepared by digitizing maps, by compiling information onto a planimetric correct base and digitizing, or by revising digitized maps using remotely sensed and other information. | NaturalResourceSurvey | ||
| airfield_area | The area associated with an airfield, either military or civilian, including any buildings or facilities intended to be used wholly or in part for the arrival or departure and surface movement of aircraft. | N | N | N/A | No airfield area exists on the installation based on available documentation. | |||
| wastewater_grease_trap_point | A tank which separates grease from water, collects the grease for removal, and allows the water to exit. | Y | N | Incomplete | The SPCC does not list grease traps. | Are grease traps on the installation? If so is there documentation that references their location? | WastewaterUtilityNode | |
| STAND-ALONE ATTRIBUTE TABLES (NOT A FEATURE CLASS) | ||||||||
| REGULATED_STORAGE_TANK | This table is a parent table establishing a unique identifier for a fuel or chemical storage tank regulated by an environmental regulatory authority. | Y | N | Incomplete | Need unique identifier for tanks in order to complete this table | NA | ||
| CONSTR_STRMWAT_PERMIT | This table contains information about a construction storm water National Pollutant Discharge Elimination System (NPDES) permit. | N | N | N/A | No construction storm water permits exist based on available documentation. | |||
| HAZARDOUS_WASTE_GENERATOR | This table contains information about facilities whose activities generate one or more hazardous wastes. | Y | N | Incomplete | The HWMP does not list locations that generate hazardous waste on the installation. If documentation exists please provide. | NA | ||
| HAZARDOUS_WASTE_RCRA_PERMIT | This table contains information about hazardous waste permits. | N | N | N/A | No HAZWASTE/RCRA permits exist based on available documentation. | |||
| ON_SITE_HAZ_WASTE_TREATMENT | This table contains information about on-site (e.g., on a military installation) treatment of hazardous wastes, on a container specific basis | N | N | N/A | No onsite HAZWASTE treatment data exists based on available documentation. | |||
| HUC_DATA | This table contains supplemental information about the hydrologic unit code (HUC) of a watershed | Y | Y | Complete | Data downloaded from: http://web.apps.state.nd.us/hubdataportal/srv/en/main.home. This data set is a complete digital hydrologic unit boundary layer to the sub-watershed (12-digit) 6th level for the entire United States. | NA | ||
| GROUNDWATER_LEVEL_DATA | This table contains groundwater level information representing a single groundwater level measurement. | Y | N | Incomplete | What source is groundwater pulled from? | NA | ||
| AIR_EMISSION_PERMIT | This table contains information about air emission permits. | Y | Y | Complete | 2010 AEI Cavalier AFS | NA |
Completion Summary
| LAYERS COMPLETED | LAYERS INCOMPLETE | LAYERS APPLICABLE BUT DATA NOT AVAILABLE TO POPULATE | LAYERS NOT APPLICABLE |
| aboveground_storage_tank_site | solid_waste_stockpile_area | dod_rpi_land_parcel_area | terrestrial_archeological_site |
| asbestos_cont_material_point | dod_rpi_site_area | cultural_survey_site | |
| ecology_management_site | building_environmental_concern_site | aquatic_habitat_area | |
| grounds_maintenance_area | lead_paint_hazard_point | essential_fish_habitat_area | |
| hazwaste_storage_loc_point | field_sample_collection_location_point | hazardous_waste_disposal_area | |
| historic_structure_site | hazardous_materiels_storage_location_site | polluted_area_of_concern_area | |
| miscellaneous_recreation_area | environmental_restoration_site | pollution_source_point | |
| potential_pollution_rel_point | reservoir_management_area | potential_env_concern_site | |
| soil_map_unit_area | picnic_site | solid_waste_dump_area | |
| underground_storage_tank_site | recreation_feature_point | solid_waste_landfill_area | |
| watershed_area | interest_point | fauna_hazard_area | |
| land_cover_area | fauna_special_species_site | ||
| land_use_area | fauna_species_site | ||
| land_reclamation_project_site | fauna_viewing_point | ||
| pest_management_site | government_wildlife_management_area | ||
| wastewater_grease_trap_point | flora_special_species_site | ||
| flora_species_site | |||
| land_vegetation_area | |||
| flora_fire_area | |||
| forest_management_area | |||
| wilderness_area | |||
| surface_riparian_area | |||
| shoreline_buffer_critical_area | |||
| flood_zone_area | |||
| playa_lake_area | |||
| watershed_drainage_area | |||
| aquifer_area | |||
| canal_area | |||
| canal_centerline | |||
| ditch_aqueduct_centerline | |||
| wetland_area | |||
| wetland_buffer_area | |||
| boat_ramp_site | |||
| fishing_site | |||
| hunting_area | |||
| marine_recreation_area | |||
| recreation_trail_site | |||
| natural_resources_well_point | |||
| well_field_site | |||
| agricultural_tract_area | |||
| cemetery_site | |||
| land_restriction_area | |||
| underwater_rock_area | |||
| airfield_area |
File details come from the government source that posted it. Updated .