IGIS Env Remediation Site Excavation QAP Version 3.3~1.pdf

Army IGI&S Program

Geospatial Data Layer

Quality Assurance Plan (QAP)

Environmental Restoration Site - Excavation

SDSFIE 3.1 Gold: EnvironmentalRemediationSite

SDSFIE 3.1 Army Adaptation:

EnvRemediationSite_Excavation

Final

Version 3.3

January 10, 2017

IGI&S Program Geospatial Data Layer QAP – Environmental Restoration Site Excavation

TABLE OF CONTENTS

DOCUMENT CHANGE HISTORY

1.0 FEATURE DEFINITION

1.1 Geospatial Data Layer Roles and Responsibilities

1.2 Feature Description

1.3 Characterization

2.0 POLICY AND REGULATIONS

3.0 REPRESENTATION

3.1 Geographic Representation

3.2 Positional Accuracy

3.3 Logical Consistency

3.4 Completeness

3.5 Temporal Representation

3.6 Spatial Reference

4.0 VALID SOURCES AND SOURCE SELECTION CRITERIA

4.1 Feature Specific Sources and Toolsets

5.0 HQDA SOURCE DATABASES

6.0 SPECIFICATIONS FOR GRAPHIC ENTITIES AND ATTRIBUTES

6.1 Database Storage

6.2 Attribute Tables

6.2.1 SDSFIE 3.1 Army Adaptation Acceptable Values Clarification

DOCUMENT CHANGE HISTORY

Development

Step Description Date Completed

0.1 OACSIM IGI&S & Proponent Draft September 21, 2015

0.2 Proponent Initial Review October 6, 2015

0.3 Community Review Period November 30, 2015

0.4 OACSIM IGI&S & Proponent Final Review December 23, 2015

1.0 N/A1 N/A

2.0 N/A1 N/A

3.0 N/A1 N/A

3.1 N/A1 N/A

3.2 Published January 4, 2016

3.3 Published (Update) January 10, 2017

SUMMARY OF CHANGES

Version 3.2 updated to Version 3.3

Annual Review Conducted

1. Updated to improve standardization with other QAPs.

2. Updated to remove references to the SDSFIE 2.6 Gold model to reflect full migration to SDSFIE 3.1.

1 No versions 1.0, 2.0, 3.0, or 3.1 exist as in January 2016 all QAPs were standardized at version 3.2.

1.0 FEATURE DEFINITION

1.1 Geospatial Data Layer Roles and Responsibilities

Table 1 - Roles and Responsibilities

IGI&S Proponent: OACSIM Installation Services Directorate –

Environmental Division (DAIM-ISE)

Installation Functional SME: ENV SME or equivalent

Data Steward: ENV SME or equivalent

Prioritization: CIP

1.2 Feature Description

Environmental restoration site excavations are areas where contaminated soil or other materials related to a release of contamination to the environment are to be, or have been, excavated and removed. Environmental restoration is undertaken in geographic locations where soil, sediment, surface water, or groundwater must be removed or remediated in response to a suspected release of contamination. Please see the Environmental Remediation Site QAP for more specific information about environmental restoration sites.

1.3 Characterization

The environmental restoration site excavation geospatial data layer should be used to capture one polygon per excavation. Mapping of excavations related to environmental restoration activities is critical for long-term strategic management and monitoring. Accurate depiction of current or future excavations at environmental restoration sites will allow for the rapid identification of areas for future surveying and building of action plans to manage those areas properly. Currently, environmental restoration site excavation features will be captured in the SDSFIE 3.1 feature type EnvRemediationSite_Excavation; however, in the upcoming SDSFIE version 4.0, these features will be captured in the EnvRestorationSite_Excavation feature type.

2.0 POLICY AND REGULATIONS

Table 2 - Geospatial Data Layer Applicable Documents

Program(s) Driver(s)

Office of the Assistant

Chief of Staff for

Installation Management

(OACSIM)

- AR 115-13, Installation Geospatial Information and Services

- AR 200-1, Environmental Protection and Enhancement

- Memo DAIM-ISE, Army Compliance-Related Cleanup Program

Guidance, April 2008

- Memo DAIM-ISE, Army Environmental Cleanup Strategic Plan, Oct 2015 (updated biannually)

- DoDM 4715.20, Defense Environmental Restoration Program

Management Manual, March 2012

Federal, State, and Local

Laws and Statutes

- Sections 2700-2710 and Title 10, USC – Environmental

Restoration Program

The most recent version of the Army documents listed above can be obtained from the Army

Publishing Directorate website. The most recent version of the environmental regulatory documents listed above can be obtained from the Government Printing Office website.

Army Publishing Directorate (APD):

Website: http://www.apd.army.mil/

Government Printing Office (GPO):

Website: http://www.gpo.gov/

3.0 REPRESENTATION

3.1 Geographic Representation

Environmental restoration site excavation features will be stored in the SDSFIE 3.1 Army

Adaptation EnvRemediationSite_Excavation subclass, which was created to store the area where contaminated soil, buried drums, buried tanks, etc. are to be, or have been, excavated and removed. The SDSFIE 3.1 Army Adaptation EnvRemediationSite_Excavation subclass was created as a breakout from the EnvRemediationSite parent feature type. The SDSFIE 3.1 Army

Adaptation will utilize this feature type’s default geometry of area. Additional subclasses of the

EnvRemediationSite_Excavation subclass are not permitted. Use of alternate geometries is allowed for the EnvRemediationSite parent feature type and the

EnvRemediationSite_Excavation subclass.

When implementing the area geometry, the environmental restoration site excavation geospatial data layer will include closed polygons representing the outermost geographic extent of the area.

Each polygon shall pertain to a single excavation environmental restoration site. When implementing the point geometry, the environmental restoration site excavation geospatial data layer will include discrete points that represent the approximate centroid or location of the excavation site feature.

3.2 Positional Accuracy

Environmental restoration site excavation features must, at a minimum, meet a level of positional accuracy for depiction on a 1:20,000 scale cartographic product. The minimum absolute horizontal accuracy for these features is 0.3 meters. The horizontal accuracy must be compiled, tested, and reported in accordance with Part 3 of the Federal Geographic Data Committee's

Geospatial Positioning Accuracy Standards: the National Standard for Spatial Data Accuracy

(NSSDA). Spatial accuracy must be reported at the 95% confidence level. The spatial accuracy standard is available at http://www.fgdc.gov/standards/standards_publications/index_html.

Vertical accuracy is not currently tested for the environmental restoration site excavation geospatial data layer.

http://www.apd.army.mil/ http://www.gpo.gov/ http://www.fgdc.gov/standards/standards_publications/index_html

3.3 Logical Consistency

Environmental restoration site excavation polygon features may overlap, including at varying depths, but should be attributed to uniquely identify each feature. These features should be validated for connectivity and not contain undershoots, overshoots, node mismatches, dangling arcs, or self-overlaps. Excavation site point features should be individual centroids or locations with unique coordinates.

3.4 Completeness

This geospatial data layer must include all environmental restoration site excavation features within the installation’s site(s) boundary or the boundary of land owned, leased, or held by the installation.

The environmental restoration site excavation geospatial data layer will contain attribute fields in accordance with the current OACSIM approved Army Adaptation to the current SDSFIE version. Although all attribute fields must exist in the attribute table, only those attribute fields listed in Table 4 - Required Populated Attributes, are required to be populated.

3.5 Temporal Representation

The environmental remediation site excavation geospatial data layer will reflect existing conditions. Updates to the completed environmental remediation site excavation geospatial data layer will occur when existing excavations are changed or when excavation environmental remediation sites are added or removed from the installation. At a minimum, the environmental remediation site excavation geospatial data layer will be updated annually.

3.6 Spatial Reference

The bounding coordinates to capture the north, south, east, and west-most spatial extents of the environmental restoration site excavation geospatial data layer will be based on one of the following: a) Universal Transverse Mercator (UTM) Zone, meters or b) local State Plane

Coordinate System, feet. At a minimum, feature types within the database should have a spatial reference with a precision of 1,000. The horizontal datum to be utilized is World Geodetic

System 1984 (WGS84), and the vertical datum shall be Mean Sea Level (MSL) as determined by the Earth Gravitational Model 2008 (EGM2008) Geoid.

4.0 VALID SOURCES AND SOURCE SELECTION CRITERIA

Information for the environmental restoration site excavation geospatial data layer must be obtained and/or validated at the installation level from the environmental SME, or equivalent.

The environmental SME will have overall responsibility for completing and updating the spatial, attribute and metadata features of the geospatial data layer in accordance with this QAP. In all cases, the Data Steward should work with the SME to identify the most reliable source for the environmental restoration site excavation geospatial data layer.

4.1 Feature Specific Sources and Toolsets

The following sources of data will be considered for capturing new geospatial data collection efforts or updating existing geospatial data. These sources are to be used in conjunction with the sources listed in the Valid Sources and Source Selection Criteria section of the QAP General

Guidance document: https://www.us.army.mil/suite/doc/43327385.

Environmental Resources Databases – Military databased records containing environmental cleanup site inventory attributes and properties.

Environmental Restoration Information System (ERIS) – ERIS and ERIS Range is a central repository for Army installation chemical, geological, and hydrology data to document the Army environmental restoration and range program field data.

5.0 HQDA SOURCE DATABASES

The Headquarters Department of the Army (HQDA) source database is the authoritative, auditable source of information where data is recorded. Properly utilizing HQDA source databases is crucial to maintaining accurate and relevant information. Maintaining duplicative databases is inefficient, undermines the reliability of the information, and creates unsustainable business processes. Departments within HQDA are currently collaborating to ensure business systems are interoperable to ensure reduced redundancy.

Environmental Database of Record

Headquarters Army Environmental System (HQAES) is the enterprise information system that enables the Army to collect, analyze, and report environmental data in an efficient and effective manner.

Headquarters Army Environmental System: HQAES is the authoritative environmental database of record for the Army Environmental Program. Users at any level can see and use their environmental data in HQAES. This system utilizes technology with sufficient tools to support Army Headquarters, Commands, and installation needs. The data collected for reporting is transparent and supports interoperability. HQAES collects all data once and distributes the information to several enterprise and feeder systems.

Website: https://hqaes.army.mil/my.policy

6.0 SPECIFICATIONS FOR GRAPHIC ENTITIES AND

ATTRIBUTES

The DoD I&E community has been operating in compliance with the SDSFIE data model since

FY07. The SDSFIE 3.1 Army Adaptation is the current geospatial data standard for the Army https://www.us.army.mil/suite/doc/43327385 https://hqaes.army.mil/my.policy

IGI&S community. Further guidance pertaining to the implementation of the SDSFIE 3.1 Army

Adaptation can be found in the guide listed below.

Army IGI&S Program SDSFIE Implementation Guidance:

https://www.us.army.mil/suite/doc/42118840

6.1 Database Storage

Table 3 – SDSFIE Database Storage

SDSFIE 3.1 Gold

Modeled Bin: EnvironmentalManagementRestorationAndOEHazards

Feature Type: EnvironmentalRemediationSite

SDSFIE 3.1 Army Adaptation

Functional Theme: Clean Up

Feature Type: EnvRemediationSite_Excavation

6.2 Attribute Tables

In order to comply with DoD and Army IGI&S Program geospatial data standards, all attributes must exist in the EnvRemediationSite_Excavation feature type; however, not all of the attribute fields are required to be populated in every feature type. Table 4 identifies the attribute fields required to be populated, their definitions, acceptable values, and the authoritative data source from where the attribute value should originate. In addition to the attributes listed in Table 4, the geometry-appropriate SDSFIE 3.1 Gold Foundational attributes must be present in the feature type schema. See the QAP General Guidance for more information about Foundational and

Common attributes.

GIS databases are the authoritative data source for only feature level latitude and longitude attribute data. Other feature level attribute data must be properly obtained from its appropriate authoritative data source, per guidance in this QAP, and not maintained in a GIS attribute table.

Departments within OACSIM are currently collaborating to ensure all vital data is stored and maintained in its proper business system. When connectivity with HQDA source databases is established, only those attribute fields whose source database is “IGI&S Generated” will be stored in the geospatial database. As such, attributes identified as belonging in HQAES but not currently located in HQAES, have been placed into a section in attribute table titled “Pending

HQAES Interface”. These attributes should continue to be collected and maintained utilizing guidance in this QAP until new guidance is published indicating their placement in HQAES.

https://www.us.army.mil/suite/doc/42118840

1SDSFIE 3.1 Army Adaptation attribute information corresponds to the SDSFIE 3.1 Army Adaptation published on 08/11/2014.

2This attribute/enumeration list has been added or changed since the release of the SDSFIE 3.1 Army Adaptation. It will be updated in the next model release.

Table 4 - Required Populated Attributes

Common

Name

SDSFIE 3.1

Army Adaptation1

Attribute

Definition

SDSFIE 3.1

Army Adaptation

Acceptable Values1

Attributed

Example

Feature

Geometry

Type

IGI&S GENERATED

Army Environmental

Database

AEDB_R

Used to link the record to the applicable record in the Army Environmental

Database – Restoration Module.

User Defined 4977TBD Area or Point

Cerclis Status cerclis

Indicates whether the site is listed in the Comprehensive Environmental

Response, Compensation, and Liability Information System (CERCLIS).

CERCLIS is managed by the EPA.

Predefined Domain:

Yes, No, Unknown No Area or Point

Excavation

Environmental

Restoration Identifier envRemediationSiteIDPK Primary Key. A unique, user-defined identifier for each record or instance of an entity.

<Site Identifier> plus <Unique Excavation Environmental

Restoration Site Identifier>

498002459 Area or Point

Environmental Restoration

Category envRestorationCategory The general category of an environmental restoration site.

Predefined Domain:

See Table 5, “EnvironmentalRestorationCategory”2

CERCLA Area or Point

EPA Designation epaDesignation Unique site-specific designation developed and used by the EPA. User Defined MIK689267391 Area or Point

Feature Area featureArea The size of the polygon.

Up to 8 Position Number

(Whole Number)

25.2 Area or Point

Hazard Category

Code hazardCategoryCode

Lists the general category or type of polluted matrix at an environmental hazards site.

Predefined Domain:

AIR, GROUNDWATER, NA, Other, SEDIMENT, SOIL, SOIL AND GW, SOLID, SURFACE WATER, TBD

Groundwater Area or Point

Hazards Site Foreign Key hazardsSiteIDFK Foreign Key. Used to link the record to the applicable Environmental Hazards

Site record.

User Defined AEDB-R Area or Point

Installation Code installationID The code assigned by the Military Service or Agency used to identify the site or group of sites that make up an installation.

HQIIS PRNT_INSTL_CD Value 51105 Area or Point

NPL Add Date nplAddDate Date the installation or environmental restoration site was added to the EPA’s

National Priorities list.

YYYYMMDD 19940915 Area or Point

NPL Indicator nplIndicator Indicates whether the site is on the National Priorities List (Superfund Site).

Predefined Domain:

Yes, No, Unknown Yes Area or Point

1SDSFIE 3.1 Army Adaptation attribute information corresponds to the SDSFIE 3.1 Army Adaptation published on 08/11/2014.

2This attribute/enumeration list has been added or changed since the release of the SDSFIE 3.1 Army Adaptation. It will be updated in the next model release.

Table 4 - Required Populated Attributes

Common

Name

SDSFIE 3.1

Army Adaptation1

Attribute

Definition

SDSFIE 3.1

Army Adaptation

Acceptable Values1

Attributed

Example

Feature

Geometry

Type

IGI&S GENERATED (Cont.)

NPL Removal Date nplRemovalDate Date the installation or environmental restoration site was removed from the

EPA National Priorities List.

YYYYMMDD 19940915 Area or Point

Operational Status operationalStatus Operational status of the feature. User Defined Active Area or Point

Remediation Required remediationRequired Indicates whether further action or remediation is necessary.

Predefined Domain:

Yes, No, Unknown

Yes Area or Point

Removal Action removalAction Use to show if the restoration site has undergone a removal action during the remediation process.

Predefined Domain:

Yes, No, Unknown Yes Area or Point

Real Property Site Unique Identifier rpsuid The unique identifier (UID) used to permanently identify a Site. HQIIS SITE_UID Value 4980 Area or Point

Feature Description sdsFeatureDescription A narrative describing the feature. User Defined Excavated old oil drums Area or Point

Feature Name sdsFeatureName The common name of the feature. User Defined North Excavation

Site Area or Point

INTERFACE WITH HQAES

Environmental Unique ID environmentalUID Foreign Key. Used to link the record to the applicable record in the HQAES database system.

Text (20) TBD Area or Point

6.2.1 SDSFIE 3.1 Army Adaptation Acceptable Values Clarification

The table below outlines the domain values and their definitions for specific attributes as cited in the Required Populated Attributes table (Table 4).

Table 5 –Acceptable Values Clarification

EnvironmentalRestorationCategory

BRAC

Department of Defense Base Relocation and Closure Program

Site

CERCLA

A site requiring investigation or action in order to comply with the requirements of the Comprehensive Environmental

Response, Compensation, and Liability Act

ER

Environmental Restoration Site not included in another environmental restoration site category

FUDS Formerly Used Defense Site

IRP Installation Restoration Program Site

RCRA

A site requiring investigation or action to comply with requirement of the Resource Conservation and Recovery Act

Superfund

Geographic area, designated by Environmental Protection

Agency, where hazardous waste is either abandoned or uncontrolled, as mandated and defined by CERCLA

SWMU

An area designated as a Solid Waste Management Unit for management and compliance with RCRA regulations

MMRP Military Munitions Response Program Site

MRS Munitions Response Site

CAMU

An area designated as a Corrective Action Waste Management

Unit for management and compliance with RCRA regulations

Other Cleanup conducted under regulations other than CERCLA or

RCRA

CC

Department of Defense Non-DERP Cleanup Program Site

(Army Compliance-related Cleanup)

NPL

Comprehensive Environmental Response, Compensation, and

Liability Act (CERCLA) National Priorities List (NPL)

Overseas Environmental restoration for Department of Defense activities overseas