ID07180034_Supporting_Documents_Part_6.pdf

March 01, 2018

Data Layer Specifications for:

Storage Tank

United States Air Force

Environmental GIS Program

Data Layer Specification – Storage Tank

Revision History Date: Version: Description of Revision:

12/12/2016 StorageTank_20161212 Removed “the vertical datum shall be Mean Sea Level

(MSL_Height),” from the Coordinate System section.

6/23/2016 StorageTank_20160623 Updated “Positional Accuracy” section.

3/9/2017 StorageTank_20170310

Updated all Air Force Standard attribute fields to match August 6, 2015 GeoBase Data Dictionary.

Updated “Positional Accuracy” section.

Updated “For Empty Text Values” subsection.

6/8/2017 StorageTank_20170608 Updated the data layer update frequency in the

“Sources and Source Selection” section.

Updated “Data Steward POC”.

12/13/2017 StorageTank_20171213

Add AFI32-7044 to Implementing Authorities and Regulations.

Update Sources and Source Selection to include guidance on minimum size of tank and tank types to include in the data layer.

03/01/2018 StorageTank_20180301

Updated the “Definition”, “Positional Accuracy”, “Attributes”, “Business Tables,” and “Appendix 1:

SDSFIE 3.1.1 AF AFCEC/CZ Adaptation Attribute Domain Tables” sections.

This Data Layer Specification (DLS) defines geospatial data specifications for the StorageTank_P data layer implemented under the United States Air Force Civil Engineer Center (AFCEC)

Environmental GIS Program.

Definition A receptacle or chamber used for storing bulk commodities or fuels. This data layer contains both above and underground tanks. If 90% or more of the tank is located above the surface of the ground it must be considered an above ground tank. If more than 10% of the tank is located below the ground surface it must be considered an underground tank.

Storage tanks with a capacity of 55 gallons or greater that hold a petroleum, oil, or lubricant (POL) product and are in-service or out of-service should be included in this data layer. The following table identifies a series of tank contents and a determination of whether they should be included in this data layer.

Content Type Included In Data Layer #1 fuel oil Yes

#2 fuel oil Yes

#3 fuel oil Yes

#4 fuel oil Yes

#5 fuel oil Yes

#6 fuel oil Yes

1010 jet engine oil Yes

Acid solution No

AFFF/HEF No

Alternative fuel e85 Yes

Antifreeze No

Automatic transmission fluid Yes

Aviation gasoline Yes

Aviation turbine fuel grade JP-10 Yes

Aviation turbine fuel grade JP-4 Yes

Aviation turbine fuel grade JP-5 Yes

Aviation turbine fuel grade JP-7 Yes

Aviation turbine fuel grade JP-8 Yes

Aviation turbine fuel grade JP-8 And 100 Additive Yes

Aviation turbine fuel jet FT Yes

Aviation turbine fuel, thermally stable Yes

Calibration fluids not otherwise classified No

Caustic solution No

Chemicals No

Cleaning compounds not otherwise classified No

Compressed Air No

Compressed natural gas No

Compressor oil Yes

Deicing fluid No

Dielectric oil Yes

Diesel fuel Yes

Domestic wastewater No

Empty Yes

Ethanol Yes

Fire protection water No

Gasoline Yes

Hydraulic fluid Yes

Hydrazine No

Jet A/ jet A-1 Yes

Jet A1 Yes

Jet B Yes

Jet engine oil 1010 Yes

Kerosene Yes

Liquefied petroleum gas No

Liquid nitrogen No

Liquefied natural gas No

Lubricating oil that is not otherwise classified Yes

Lubricating oils [0-278], [mil-prf-17331] Yes

Mineral oil Yes

Mixture of Alcohol And water No

Motor oil Yes

Non-hazardous waste paint related material No

Non-potable water No

Off-spec fuel Yes

Oil/water separator Yes

Otto fuels Yes

Pesticide/herbicide No

Potable water No

Preservation oil Yes

Propane No

Raw water No

Reclaimed fuel Yes

Reclaimed JP-8 + 100 Yes

Saltwater No

Solvent not otherwise classified No

Steam turbine lubricating oils [0-250], [mil-prf-17331] Yes

Storm water No

Treated water No

Turbine oil Yes

Used cooking oil/grease Yes

Used oil Yes

Used petroleum Yes

Used petroleum products Yes

Used pol engine/HYD JP-8 Yes

Used pol engine/HYD oil Yes

Waste fuel Yes

Waste oil Yes

Waste water No

Mobile, bowser, and/or portable storage tanks should not be included in this data layer.

Data Layer Details

SDSFIE 3.1.1 AF AFCEC/CZ

Adaptation Feature Class Name:

StorageTank_P

SDSFIE 3.1.1 AF AFCEC/CZ

Adaptation Feature Dataset:

environmentalStorageTanks

Previous Layer Names:

regulated_aboveground_storage_tank_point regulated_underground_storage_tank_point AboveGroundStorageTank_P UnderGroundStorageTank_P

Geometry Type: Point

Data Steward Organization (Program Area):

Program Area: Storage Tanks

Data Steward POC: AFCEC/CZTQ Air Force Storage Tanks Program SME

Representation:

Storage tank points are a representation of the coordinate location of that feature.

Implementing Authorities and Regulations

Implementing Program(s):

Driver(s):

HQ AF/A7CAN

AFI32-7044, Storage Tank Environmental Compliance, 18 August 2015, Incorporating Change 1, 22 April 2016

AFI32-10112, Installation Geospatial Information and Services (IGI&S), 19 October 2007

AFI32-7062, Comprehensive Planning, 27 June 2013

AFI32-7064, Integrated Natural Resources Management, 18 November 2014

AFI32-7065, Cultural Resources Management, 19 November 2014

AFH32-9007, Managing Air Force Real Property, 1 May 1999

AFI32-1084, Facility Requirements; Chapter 11-16, 1 September 1996

Implementing Program(s):

Driver(s):

Garrison Mapping Concept of Operations (CONOPS) Version 2.0, 12 June 2003

USAF Installation Geospatial Information and Services (IGI&S) Data Model, 15 December 2009

Real Property Inventory Management (RPIM), v2.0

RPIM 3.0, extracted 4/2009

The Federal Facilities compliance Act (FFCA) of 1992

South Dakota Codified Laws Chapter (34A - 2 - 98)

North Dakota Century Code (NDCC) 23-13-16

Nebraska Administrative Code (NAC) 159-1-001 to 159-001 for USTs and ASTs

Geometry/Topology

Point Features:

Points must be disjoint.

Sources and Source Selection Information for this geospatial data layer must be obtained and/or validated at the installation level. The Data Steward will have overall responsibility for completing and updating the spatial, attribute and metadata features of this geospatial data layer in accordance with this DLS. The data layer will be updated on a quarterly (3 month) basis at a minimum. More frequent updates may be performed if new data has been developed prior to the quarterly update. Additionally a quarterly

Quality Control (QC) check will be performed on all data housed in GeoBase. Updates and QC will be performed on any new data prior to uploading it to GeoBase.

Possible sources for the data layer are: planimetric data extracted from stereo or ortho-imagery, differential GPS survey, conventional surveys using a survey grade GPS, computer aided design

(CAD), imagery, hardcopy documents, attribute or tabular data.

Data should only represent tanks containing Petroleum, Oil, and Lubricants (POL) product. Tanks containing other products such as waste water, de-icing fluid, propane, or other non-POL products should not be included in the data set. The status of the tank may either be “In Service” or “Out of

Service” (valid tankStatus domain values include “inactive”, “inUse”, or “outOfService”). Out of

Service tanks are those that are still in place, but have been temporarily closed and are available for future use, or are planned for future removal. Tanks must have a capacity of 55 gallons or more.

Smaller capacity tanks will not be included in the data set. Bowser, portable, or otherwise mobile tanks will not be included in the data set.

Positional Accuracy Horizontal Accuracy: Data developed within this layer should be within 3 meters of the actual location at the 95% confidence level. Accuracy reported at the 95% confidence level means that

95% of the positions in the dataset would have an error with respect to true ground position that is equal to or smaller than the stated accuracy threshold value.

Vertical Accuracy: Not applicable.

Note: Horizontal accuracy should be recorded within the “Quality” element of the metadata. Where positional accuracy cannot be determined, this section should be populated with “Not Recorded” and a brief statement explaining why it cannot be determined should be provided.

Coordinate System The bounding coordinates to capture the north, south, east, and west-most spatial extents of the

StorageTank_P layer will be based on the Universal Transverse Mercator (UTM) Zone, meters.

Datasets within the database should have a spatial reference with a precision of 1000. The horizontal datum to be utilized for all data is World Geodetic System 1984 (WGS84), and the projection is the Universal Transverse Mercator (UTM) zone for the installation.

Attributes The following table lists the attributes for the StorageTank_P data layer.

SDSFIE 3.1.1 Air Force AFCEC/CZ Adaptation Attributes

Domain (D)

Attribute Name Definition Allowed Values Data Type

(Length) Advocate storageTankIDPK

The unique identifier for each feature in the feature class. The value should be calculated as follows:

INST_SITE0001000000

1, where INST is the 4 character installation ID, SITE0001 is the 4 character 4 digit site ID, followed by a 7 digit unique number starting with 0000001.

String (20)

AF

Domain (D)

Attribute Name Definition Allowed Values Data Type

(Length) Advocate sdsID A unique identifier for all features and objects in the SDSFIE.

GUID SDSFIE

sdsFeatureName The common name of the feature.

Allowed values can be obtained from STAR database.

String (80)

SDSFIE

sdsFeatureDescription A narrative describing the feature.

Allowed values can be obtained from STAR database.

String (255)

SDSFIE

sdsMetadataID The foreign key to a metadata record.

(80)

SDSFIE

latitude

The latitude coordinate in decimal degrees to sub foot precision.

decimal degrees Double AF longitude

The longitude coordinate in decimal degrees to sub foot precision.

decimal degrees Double AF

MGRS

Military Grid Reference System for the coordinate point.

MGRS is calculated from the Latitude and

Longitude values.

AF

elevation The elevation of the subject item in relation to a datum.

Double AF

D elevationUOM The unit of measure for elevation dimension.

foot String (25)

AF

starID The unique storage tank ID from STAR.

Allowed values can be obtained from STAR database.

String (50) realPropertyUniqueIde ntifier

The real property unique identifier (RPUID) is a non-intelligent code used to permanently and uniquely identify a real property asset.

Source: RPIM 3.0, extracted 4/2009.

Allowed values can be obtained from STAR database.

String (18)

Attribute Name Definition Allowed Values Data Type

(Length) Advocate facilityID The facility ID number.

Allowed values can be obtained from STAR database.

String (100)

AF

localDesignator

Any local designation, common name or alias for the tank as identified by the installation or other agency.

(150)

AF

D isRegulated

Indicates whether the feature is regulated by Federal, State or local jurisdiction or no regulation.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

D isRegCAA

Indicates whether the tank is regulated under the Clean Air Act.

NA, no, TBD, yes String

(3)

AF

D isRegCWA

Indicates whether the tank is regulated under the Clean Water Act.

NA, no, TBD, yes String

(3)

AF

D isRegOPPA

Indicates whether the tank is regulated under the Oil Pollution Prevention Act.

NA, no, TBD, yes String

(3)

AF

D isRegRCRA

Indicates whether the tank is regulated under the Resource Conservation and

Recovery Act.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

D isRegOther

Indicates whether the tank is regulated under other authority (e.g. STI, industry standards, specific local/regional laws, etc.). Provide specifics in the narrative field.

NA, no, TBD, yes String

(3)

Attribute Name Definition Allowed Values Data Type

(Length) Advocate

D stiCategory A descriptor that identifies the STI category for each tank.

Allowed values can be obtained from STAR database.

For the list of domain values see STIcategory in Appendix 1.

String (5)

AF

D isSPCC Indicates whether the tank should be included in the SPCC.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

D dlaManaged

Indicates tanks that store Defense Logistics

Agency capitalized fuel.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

D isPermitRegister Indicates whether the tank is permitted or registered or not.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

permitRegisterNum

Unique identification number of the operational permit or registration received from the applicable federal, state, or local regulatory agency.

Allowed values can be obtained from STAR database.

String (50)

AF

permitRegisterDate

The date on which the tank was permitted or registered. Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915).

Allowed values can be obtained from STAR database.

Integer (Long)

AF

permitRegisterExp

Indicates the date on which the current permit or registration expires. Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915).

Allowed values can be obtained from STAR database.

Integer (Long)

AF

D permitRegisterStatus

Indicates the status of the permit or registration for the subject item.

For the list of domain values see

TankPermitStatus in Appendix 1.

String (15)

Attribute Name Definition Allowed Values Data Type

(Length) Advocate dateInstalled

Indicates the date on which the feature was/is to be installed.

Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915).

Allowed values can be obtained from STAR database.

Integer (Long)

AF

dateCertified

Indicates the date on which the tank was certified. Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915).

Integer (Long)

AF

D tankStatus A descriptor of the status of the tank.

Allowed values can be obtained from STAR database.

For the list of domain values see TankStatus in Appendix 1.

String (15)

AF

dateRemoved

Indicates the date on which the tank was/is to be removed.

Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915).

AF

D tankContents A descriptor of the contents of the tank.

Allowed values can be obtained from STAR database.

For the list of domain values see TankContents in

Appendix 1.

String (20)

AF

tankManufacturer The tank manufacturer.

Allowed values can be obtained from STAR database.

String (100)

AF

manufactDate

Indicates the manufacture date of the tank. Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915).

Allowed values can be obtained from STAR database.

Integer

Attribute Name Definition Allowed Values Data Type

(Length) Advocate modelNum The model number of the tank.

Allowed values can be obtained from STAR database.

String (60)

AF

serialNum The serial number on the tank.

Allowed values can be obtained from STAR database.

String (75)

AF

D isNamePlateLegible Indicates whether the name plate on the tank is legible.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

D areNFPAplacardsComp liant

Indicates whether the NFPA placards are properly affixed and legible on the tank.

NA, no, TBD, yes String

(3)

AF

D isUnderground

Indicates whether the tank is an underground storage tank. If false, the assumption is the tank is an above ground storage tank.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

D tankType The primary type of tank.

For the list of domain values see TankType in Appendix 1.

String (20)

AF

D tankMaterial A descriptor of the type of material of the tank.

Allowed values can be obtained from STAR database.

For the list of domain values see TankMaterial in

Appendix 1.

String (15)

AF

D pipingType A descriptor of the primary/majority type of piping used.

For the list of domain values see PipingType in Appendix 1.

String (20)

AF

D pipingMaterial A descriptor of the material composition of the pipe.

Allowed values can be obtained from STAR database.

For the list of domain values see PipingMaterial in

Appendix 1.

String

Attribute Name Definition Allowed Values Data Type

(Length) Advocate

D isPressurized Indicates whether the tank is pressurized.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

D isContained

Indicates whether the tank is surrounded by secondary containment.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

D containType

The primary type of secondary containment used for the tank if a spill or leak were to occur.

Allowed values can be obtained from STAR database.

For the list of domain values see ContainType in

Appendix 1.

String (20)

AF

containDescript

A description of the secondary containment for the tank. Include containment method and capacity in the description.

(255)

AF

D meetsContainCap

Indicates whether the secondary containment meets requirements (100% of the largest tank plus freeboard).

NA, no, TBD, yes String

(3)

AF

D isLeakDetection Indicates whether the tank has the required leak detection.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

leakDetectDescript A description of the tank's leak detection sensor.

(100)

AF

D isLeakDetectCompliant

Indicates whether the leak detection system is compliant/meets standards and in operable condition.

NA, no, TBD, yes String

Attribute Name Definition Allowed Values Data Type

(Length) Advocate

D isSpillProtection

Indicates whether the tank has the required spill protection system.

Allowed values can be obtained from STAR database.

NA, no, TBD, yes

String (3)

AF

spillProtectDescript A description of the spill protection system.

AF

D isSpillProtectComplian t

Indicates whether the spill protection is compliant/meets standards and in operable condition.

NA, no, TBD, yes String

(3)

AF

D vaporContr A descriptor of the primary vapor control.

Allowed values can be obtained from STAR database.

For the list of domain values see VaporContr in Appendix 1.

String (15)

AF

D tankRoofType A descriptor of the type of roof.

Allowed values can be obtained from STAR database.

For the list of domain values see RoofType in Appendix 1.

String (20)

AF

tankHeight The height of the tank in feet.

Allowed values can be obtained from STAR database.

Double AF tankLength The length of the tank in feet.

Allowed values can be obtained from STAR database.

Double AF tankWidth The width of the tank in feet.

Allowed values can be obtained from STAR database.

Double AF tankDiameter The diameter of the tank in feet.

Allowed values can be obtained from STAR database.

Double AF

D tankDimensionUOM The unit of measure used for the tank dimensions.

foot String (25)

Attribute Name Definition Allowed Values Data Type

(Length) Advocate tankDepth

The depth of the tank, in feet, measured as the distance from the ground surface to the bottom of the tank.

Double AF

D tankDepthUOM The unit of measure used for tank depth.

foot String (25)

AF

tankCapacity The usable tank capacity in gallons.

Allowed values can be obtained from STAR database.

Double AF

D tankCapacityUOM The unit of measure for tank capacity.

usGallon

String (20)

AF

ratedCapacity The rated tank capacity in gallons.

Double AF

D ratedCapacityUOM The unit of measure for rated capacity data.

usGallon String (20)

AF

D tankColor The color of the tank.

Allowed values can be obtained from STAR database.

For the list of domain values see TankColor in Appendix 1.

String (10)

AF

accessRestricted

A descriptor indicating whether access to the tank is restricted (e.g.

flightline, controlled, secured, or other security).

AF

orgID ID or symbol of the organization owning the tank.

AF

business The business or organization utilizing the tank system.

AF

businessID

The ID of the business or organization utilizing the tank system.

AF

poc The point of contact for the tank.

Allowed values can be obtained from STAR database.

String

Attribute Name Definition Allowed Values Data Type

(Length) Advocate tankCorrosion A descriptor of any corrosion occurring on or in the tank.

AF

pipeCorrosion A descriptor of any corrosion occurring on the piping.

AF

D installationID

Installation identifier assigned to the

Installation by real property.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (16)

AF

D installationName

The actual name of the installation that is associated with the installation ID defined by real property.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (100)

AF

D siteID Installation identifier assigned to the Site by real property.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (36)

AF

D majorCommand Service Major

Command of the installation.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (10)

AF

D realPropertySiteUniqu eID

The unique identifier (UID) used to permanently identify a Site. This UID will be a

Real Property Site Unique Identifier (RPSUID). Source:

RPIM, v3.0, extracted 4/2009.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String

Attribute Name Definition Allowed Values Data Type

(Length) Advocate wacInnrCode The NGA World

Airfield Identifier.

The NGA World Airfield Identifier

Code: List of codes can be accessed at the following site:

https://www.extranet.

nga.mil/

String (10)

AF

dataSteward

The data steward is the entity that oversees the data content, context, and associated business rules of the feature class.

AF

D country

The country code is an abbreviation for the country that owns the specific feature class.

For the list of domain values see ISO ALPHA-

2 Code / FIPS 10-4 standard.

String (5)

AF

D owner

The military service, country, government that owns that specific feature.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (10)

AF

createDate

Date the feature was originally acquired, created or generated.

If the day is unknown, default to the first day of the month. If only the year is known, default to the first day of the year.

Date AF creator

Person who created the feature. Last name of the person and first initial. Example: Jane

Smith would be attributed as "SmithJ."

(30)

AF

https://www.extranet.nga.mil/ https://www.extranet.nga.mil/ http://www.nationsonline.org/oneworld/country_code_list.htm http://www.nationsonline.org/oneworld/country_code_list.htm

Attribute Name Definition Allowed Values Data Type

(Length) Advocate

D dataCollection

Coded domain value which identifies the collection methodology used to calculate, create or record the feature.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (20)

AF

dataSource

Identifies the installation office, government agency, contractor or vendor that acquired, created or generated the feature.

AF

editor

Contractor or person that edited the feature attribution or geometry from its original or previous value. Last Name of the person and first initial. For example, Jane Smith would be attributed as SmithJ.

AF

dateEdited

Date that the feature was edited from its original or previous value.

Date AF metaNotes

Describes other details about what was created or edited and why.

AF

mediaLink

Used to link the record to associated multimedia records that reference data such as imagery, video, audio, scanned documents, drawings, and other digital media.

AF

narrative Any additional comments or notes.

Attribute Name Definition Allowed Values Data Type

(Length) Advocate

GEOLOC

JOPES geolocator code.

(4)

AF

Business Tables The business tables will contain information that goes beyond the attribute table information, which will be related to the data layer using a Feature Key or other Identifier found in both the attribute table and business table. Additional attributes to be determined by the Program Area

Manager. The business table for StorageTank_P is:

Table Name Identifier Source et_StorageTank_P starID Program Area Manager

“No Data” Value in Attributes Directions for populating required attributes for which no data/information is available. Use the appropriate values below:

For Empty Text Values TBD (To Be Determined) – A value is required but the value has yet to be determined.

unknown The value cannot be reasonably determined.

NA (Not Applicable) No value exists.

For Empty Integer Values 99999 (To Be Determined) – A value is required but the value has yet to be determined.

88888 The value cannot be reasonably determined.

77777 (Not Applicable) No value exists.

For Empty Date Values 9/9/9999 (To Be Determined) – A value is required but the value has yet to be determined.

8/8/8888 The value cannot be reasonably determined.

7/7/7777 (Not Applicable) No value exists.

Extent The data layer’s extent will be to the installation boundary, unless otherwise noted by the program area manager.

Metadata Complete Federal Geographic Data Committee (FGDC) compliant metadata for the data layer using the Procedures for Creating Metadata document. Update the metadata Lineage section as edits are made or as necessary.

Theme Keywords: Storage Tanks, Storage Tank

Appendix 1: SDSFIE 3.1.1 AF AFCEC/CZ Adaptation

Attribute Domain Tables DOMAIN TABLE NAME: ContainType

ATTRIBUTE NAME: containType

CODED DOMAIN DEFINITION

berm Containment type is a berm.

concreteConstruct Containment type is a constructed concrete structure.

concreteCurb Containment type is a constructed concrete curb.

concreteDike Containment type is a concrete dike.

concreteVault Containment type is a concrete vault tank.

doubleBottom Containment type is double bottom.

doubleWalled Containment type is double-walled tank.

integral Containment type is integral to the tank construction.

metalPan Containment type is a metal pan.

NA Not Applicable: No value exists.

other Other. Must be described in the sdsFeatureDescription attribute.

plasticPanSystem Containment type is a plastic pan containment system.

portableContain Containment type is a portable containment device.

remoteImpound Containment type is a remote impoundment.

responseCapability Containment type is response capability to include deployment of spill kits and use of internal response resources for initial spill.

spillPan Containment type is a spill pan.

steelDike Containment type is a steel dike.

TBD To Be Determined: A value is required but the value has yet to be determined.

DOMAIN TABLE NAME: PipingMaterial

ATTRIBUTE NAME: pipingMaterial

CODED DOMAIN DEFINITION

aluminum Piping material consists of aluminum.

brass Piping material consists of brass.

castIron Piping material consists of cast iron.

copper Piping material consists of copper.

fiberglass Piping material consists of fiberglass.

NA Not Applicable: No value exists.

other Other. Must be described in the sdsFeatureDescription attribute.

plastic Piping material consists of plastic.

rubber Piping material consists of rubber.

stainlessSteel Piping material consists of stainless steel.

steel Piping material consists of steel.

DOMAIN TABLE NAME: PipingType

ATTRIBUTE NAME: pipingType

CODED DOMAIN DEFINITION

flangeAndThreadPipe Piping type is flanged and threaded pipe.

flexible Piping type is flexible.

hose Piping type is hose.

DOMAIN TABLE NAME: PipingType

ATTRIBUTE NAME: pipingType NA Not Applicable: No value exists.

other Other. Must be described in the sdsFeatureDescription attribute.

rigid Piping type is rigid.

threadedPipe Piping type is threaded pipe.

DOMAIN TABLE NAME: STICategory

ATTRIBUTE NAME: stiCategory

CODED DOMAIN DEFINITION

The STI category is 1 - ASTs with spill control and continuous release detection monitoring (CRDM).

The STI category is 2 - ASTs with spill control but without continuous release detection monitoring (CRDM).

The STI category is 3 - ASTs without spill control or continuous release detection monitoring (CRDM).

NA Not Applicable: No value exists.

other Other. Must be described in the sdsFeatureDescription attribute.

DOMAIN TABLE NAME: TankColor

ATTRIBUTE NAME: tankColor

CODED DOMAIN DEFINITION

black The tank color is black.

blue The tank color is blue.

brown The tank color is brown.

combo The tank is a combination of colors.

cream The tank color is cream.

gray The tank color is gray.

green The tank color is green.

NA Not Applicable: No value exists.

other Other. Must be described in the sdsFeatureDescription attribute.

purple The tank color is purple.

red The tank color is red.

silver The tank color is silver.

TBD To Be Determined: A value is required but the value has yet to be determined.

white The tank color is white.

yellow The tank color is yellow.

DOMAIN TABLE NAME: TankContents

ATTRIBUTE NAME: tankContents

CODED DOMAIN DEFINITION

acidSolution Tank contains an acid solution.

afffHEF Tank contains aqueous film forming foam / high expansion foam (AFFF / HEF).

alcoholWater Tank contains a mixture of alcohol and water.

antiFreeze Tank contains anti-freeze.

autoTransFluid Tank contains automatic transmission fluid.

avGasoline Tank contains aviation gasoline.

burnerFuel1 Tank contains burner fuel No. 1.

burnerFuel2 Tank contains burner fuel No. 2.

burnerFuel3 Tank contains burner fuel No. 3.

burnerFuel4 Tank contains burner fuel No. 4.

burnerFuel5 Tank contains burner fuel No. 5.

burnerFuel6 Tank contains burner fuel No. 6.

calibrationFluidNOC Tank contains calibration fluid that is not otherwise classified.

causticSolution Tank contains a caustic solution.

chemicals Tank contains chemicals (please list actual chemicals in the feature description).

cleaningCompoundNOC Tank contains cleaning compound that is not otherwise classified.

cng Tank contains compressed natural gas (CNG).

compressedAir Tank contains compressed air.

compressorOil Tank contains compressor oil.

deicing Tank contains deicing fluid.

dielectricOil Tank contains non-conducting dielectric oil.

dieselFuel Tank contains diesel fuel. This includes auto diesel, bio diesel, marine diesel, or any other form of diesel fuel.

domesticWstewtr Tank contains domestic wastewater.

e85 Tank contains alternative fuel E85.

ethanol Tank contains ethanol.

fireProtectWtr Tank contains fire protection water.

gasoline Tank contains gasoline. This includes any form of gasoline.

hydraulicFluid Tank contains hydraulic fluid.

hydrazine Tank contains hydrazine - water (H-70).

jetAA1 Tank contains aviation turbine fuel Jet A or Jet A-1.

jetB Tank contains aviation turbine fuel Jet B.

jetEngineOil1010 Tank contains jet engine oil 1010.

jetFT Tank contains aviation turbine fuel Jet FT.

jp10 Tank contains aviation turbine fuel Grade JP-10.

jp4 Tank contains aviation turbine fuel Grade JP-4.

jp5 Tank contains aviation turbine fuel Grade JP-5.

jp7 Tank contains aviation turbine fuel Grade JP-7.

jp8 Tank contains aviation turbine fuel Grade JP-8.

jp8-100Additive Tank contains aviation turbine fuel Grade JP-8 + 100 additive.

jpts Tank contains aviation turbine fuel, thermally stable.

kerosene Tank contains kerosene.

liquidNitrogen Tank contains liquid nitrogen.

lng Tank contains liquefied natural gas (LNG).

lpg Tank contains liquefied petroleum gas (LPG).

lubricatingOilNOC Tank contains lubricating oil that is not otherwise classified.

mineralOil Tank contains mineral oil.

motorOil Tank contains motor oil.

NA Not Applicable: No value exists.

nonHazWstePaintMat Tank contains non-hazardous waste paint related material.

nonPotWtr Tank contains non-potable water.

o250 Tank contains steam turbine lubricating oils [0-250], [MIL-PRF-17331].

o278 Tank contains lubricating oils [0-278], [MIL-PRF-9000].

offSpecFuel Tank contains off-spec fuel.

oilyWstewtr Tank contains oily wastewater.

otto Tank contains OTTO Fuels.

pesticideHerbicide Tank contains pesticide or herbicide.

potWtr Tank contains potable water.

preservationOil Tank contains preservation oil.

propane Tank contains propane.

rawWtr Tank contains raw water.

reclaimedFuel Tank contains reclaimed fuel.

reclaimedJP8-100 Tank contains reclaimed JP-8 + 100.

saltwater Tank contains saltwater.

solventNOC Tank contains solvent that is not otherwise classified.

stormwater Tank contains stormwater.

TBD To Be Determined: A value is required but the value has yet to be determined.

treatedWtr Tank contains treated water.

usedCookingOil Tank contains used cooking oil.

usedOil Tank contains used oil.

usedPetro Tank contains used petroleum.

usedPetroProd Tank contains used petroleum products.

usedPOLEng-HydJP8 Tank contains used POL Eng/Hyd JP-8.

usedPOLEng-HydOil Tank contains used POL Eng/Hyd oil.

wastewater Tank contains wastewater. This excludes domestic wastewater.

wsteFuel Tank contains waste fuel.

wsteOil Tank contains waste oil.

DOMAIN TABLE NAME: TankMaterial

ATTRIBUTE NAME: tankMaterial

CODED DOMAIN DEFINITION

aluminum Tank is constructed from aluminum.

carbonFiber Tank is constructed from carbon fiber.

carbonSteel Tank is constructed from carbon steel.

composite Tank is constructed from composite.

concrete Tank is constructed from concrete.

fiberglass Tank is constructed from fiberglass.

NA Not Applicable: No value exists.

other Other. Must be described in the sdsFeatureDescription attribute.

plastic Tank is constructed from plastic.

polyethylene Tank is constructed from polyethylene.

stainlessSteel Tank is constructed from stainless steel.

steelConcrete Tank is constructed from a combination of steel and concrete.

steelFiberglass Tank is constructed from a combination of steel and fiberglass.

TBD To Be Determined: A value is required but the value has yet to be determined.

thermoplastic Tank is constructed from thermoplastic.

unknown Tank is constructed from an unknown material.

DOMAIN TABLE NAME: TankPermitStatus

ATTRIBUTE NAME: permitRegisterStatus

CODED DOMAIN DEFINITION

appNotSub The permit or registration application has not been submitted to the regulatory authority.

appUnderRev The permit or registration application is under review by the regulatory authority.

DOMAIN TABLE NAME: TankPermitStatus

ATTRIBUTE NAME: permitRegisterStatus denied The permit or registration has been denied by the regulatory authority.

expired The permit or registration has expired.

issued A permit or registration has been issued by the regulatory authority.

NA Not Applicable: No value exists.

notIssued A permit or registration has not been issued.

notReq A permit or registration is not required.

other Other. Must be described in the sdsFeatureDescription attribute.

reappUnderRev A permit or registration reapplication is under review by the regulatory authority.

removed The permit or registration has been removed by the regulatory authority.

DOMAIN TABLE NAME: TankRoofType

ATTRIBUTE NAME: tankroofType

CODED DOMAIN DEFINITION

buttWeld Roof type is butt welded.

buttWeldCone Roof type is butt welded cone.

domedExternFloat Roof type is domed external floating roof.

domedFixed Roof type is domed fixed roof.

domedInternFloat Roof type is domed internal floating roof.

externFloat Roof type is external floating roof.

flat Roof type is flat.

flatHeads Roof type is flat heads.

flatWLid Roof type is flat with lid.

horizExternFloat Roof type is horizontal external floating roof.

horizFixed Roof type is horizontal fixed roof.

horizInternFloat Roof type is horizontal internal floating roof.

internFloat Roof type is internal floating roof.

NA Not Applicable: No value exists.

other Other. Must be described in the sdsFeatureDescription attribute.

plasticLid Roof type is plastic lid.

pressDome Roof type is pressed dome.

pressHeads Roof type is pressed heads.

TBD To Be Determined: A value is required but the value has yet to be determined.

vertExternFloat Roof type is vertical external floating roof.

vertFixed Roof type is vertical fixed roof.

vertInternFloat Roof type is vertical internal floating roof.

DOMAIN TABLE NAME: TankStatus

ATTRIBUTE NAME: tankStatus

CODED DOMAIN DEFINITION

abandoned Tank is permanently out of service and has not been removed or "closed" in accordance with the appropriate environmental regulations.

closedInPlace Tank was permanently taken out of service, filled with inert material, left in place, site has been closed in accordance with appropriate environmental regulations.

closedRemoved Tank was permanently taken out of service, has been removed, and the tank site has been closed in accordance with all appropriate environmental regulations.

filled Tank was permanently taken out of service, filled with inert material, left in place, site was not closed in accordance with current appropriate environmental regulations.

DOMAIN TABLE NAME: TankStatus

ATTRIBUTE NAME: tankStatus inactive Tank is temporarily inactive, but is available for future service.

inUse Tank is currently in service or active use.

NA Not Applicable: No value exists.

other Other. Must be described in the sdsFeatureDescription attribute.

outOfService Tank is temporarily out of service, but is available for future service or removal/replacement.

removed Tank was permanently taken out of service and removed, but the tank site was not closed in accordance with all current applicable environmental regulations.

DOMAIN TABLE NAME: TankType

ATTRIBUTE NAME: tankType

CODED DOMAIN DEFINITION

astInBldg The tank is an aboveground storage tank inside a building.

astOutBldg The tank is an aboveground storage tank outside a building.

bowser The tank is a bowser tank.

chemical The tank is a chemical tank.

elevated The tank is an elevated tank.

fuel The tank is a fuel tank.

highPress The tank is a high pressure tank.

highTherm The tank is a high thermal tank.

horizCylind The tank is a horizontal cylindrical tank.

horizRect The tank is a horizontal rectangular tank.

mobile The tank is a mobile tank.

NA Not Applicable: No value exists.

other Other. Must be described in the sdsFeatureDescription attribute.

ows The tank is an oil/water separator.

portable The tank is a portable tank.

TBD To Be Determined: A value is required but the value has yet to be determined.

vertCylind The tank is a vertical cylindrical tank.

vertRect The tank is a vertical rectangular tank.

DOMAIN TABLE NAME: VaporContr

ATTRIBUTE NAME: vaporContr

CODED DOMAIN DEFINITION

EV Vapor control consists of an emergency vent.

IFR Vapor control consists of an internal floating roof.

NA Not Applicable: No value exists.

none Vapor control does not exist.

other Other. Must be described in the sdsFeatureDescription attribute.

PEV Vapor control consists of a primary emergency vent.

pressVac Vapor control consists of a pressure vacuum.

pressVent Vapor control consists of a pressure vent.

SEV Vapor control consists of a secondary emergency vent.

ventOpenToAtmos Vapor control consists of a vent open to atmosphere.

Land Use Control

Data Layer Specification – Land Use Control

2 | P a g e

12/12/2016 LandUseControl _20161212

Removed “the vertical datum shall be Mean Sea Level (MSL_Height),” from the Coordinate System section.

6/23/2016 LandUseControl _20160623

Added authoritative source language to the “Allowed Values” column under “Attributes” section.

Updated “Positional Accuracy” section.

3/9/2017 LandUseControl _20170310

Updated all Air Force Standard attribute fields to match August 6, 2015 GeoBase Data Dictionary.

Updated “Positional Accuracy” section.

Updated “For Empty Text Values” subsection.

6/8/2017 LandUseControl _20170608

Updated the data layer update frequency in the “Sources and Source Selection” section.

Updated “Data Steward POC”

3/1/2018 LandUseControl _20180301

Updated Geometry/Topology, Positional Accuracy, and Attributes section.

3 | P a g e

This Data Layer Specification (DLS) defines geospatial data specifications for the LandUseControl_A data layers implemented under the United States Air Force Civil Engineer Center (AFCEC)

Environmental GIS Program.

Definition Locations where land use is restricted due to environmental restoration or compliance purposes.

Data Layer Details

SDSFIE 3.1.1 AF AFCEC/CZ

Adaptation Feature Class Name:

LandUseControl_A

SDSFIE 3.1.1 AF AFCEC/CZ

Adaptation Feature Dataset:

environmentalRestoration

Previous Layer Names: brownfield_area

Geometry Type: Polygon

Data Steward Organization (Program Area):

Program Area: Environmental Restoration

Data Steward POC: AFCEC/CZTE Air Force Environmental Restoration Program SME

Representation:

Land use control areas are represented as closed polygons depicting the outermost extent of the area.

Each individual land use control area site is represented by a single area feature.

Implementing Authorities and Regulations

Implementing Program(s):

Driver(s): List the drivers for the feature class

HQ AF/A7CAN

AFI32-10112, Installation Geospatial Information and Services (IGI&S), 19 October 2007

AFI32-7062, Base Comprehensive Planning, 13 November 2009

AFI32-7064, Integrated Natural Resources Management, 18 November 2014

AFI32-7065, Managing Cultural Resources Management Program, 19 November 2014

AFH32-9007, Managing Air Force Real Property, 1 May 1999

AFI32-1084, Facility Requirements; Chapter 11-16, 1 September 1996

Garrison Mapping Concept of Operations (CONOPS) Version 2.0, 12 June 2003

USAF Installation Geospatial Information and Services (IGI&S) Data Model, 15 December 2009

Real Property Inventory Management (RPIM), v2.0

4 | P a g e

Driver(s): List the drivers for the feature class

RPIM 3.0, extracted 4/2009

AFI32-7020, The Environmental Restoration Program, 7 November

Geometry/Topology

Polygon Features:

Polygons must be single part features.

Polygons must be larger than cluster tolerance (.001 meter).

Sources and Source Selection Information for this geospatial data layer must be obtained and/or validated at the installation level. The Data Steward will have overall responsibility for completing and updating the spatial, attribute and metadata features of this geospatial data layer in accordance with this DLS. The data layer will be updated on an annual (yearly) basis at a minimum. More frequent updates may be performed if new data has been developed prior to the annual update. Additionally a bi-annual

(every 6 months) Quality Control (QC) check will be performed on all data housed in GeoBase.

Updates and QC will be performed on any new data prior to uploading it to GeoBase.

Possible sources for the data layer are: planimetric data extracted from stereo or ortho-imagery, differential GPS survey, conventional surveys using a survey grade GPS, computer aided design

(CAD), imagery, hardcopy documents, attribute or tabular data.

Positional Accuracy Horizontal Accuracy: Data developed within this layer should be within 6 meters of the actual location at the 95% confidence level. Accuracy reported at the 95% confidence level means that

95% of the positions in the dataset would have an error with respect to true ground position that is equal to or smaller than the stated accuracy threshold value.

Vertical Accuracy: Not applicable.

Note: Horizontal accuracy should be recorded within the “Quality” element of the metadata. Where positional accuracy cannot be determined, this section should be populated with “Not Recorded” and a brief statement explaining why it cannot be determined should be provided.

Coordinate System

The bounding coordinates to capture the north, south, east, and west most spatial extents of the

LandUseControl_A layer will be based on the Universal Transverse Mercator (UTM) Zone, meters.

Datasets within the database should have a spatial reference with a precision of 1000. The

5 | P a g e horizontal datum to be utilized for all data is World Geodetic System 1984 (WGS84), and the projection is the Universal Transverse Mercator (UTM) zone for the installation.

Attributes The following table lists the attributes for the LandUseControl_A data layer.

SDSFIE 3.1.1 Air Force AFCEC/CZ Adaptation Attributes

Domain (D)

Attribute Name Definition Allowed Values Data Type

(Length) Advocate landUseControlIDPK

The unique identifier for each feature in the feature class. The value should be calculated as follows:

INST_SITE0001000000

1, where INST is the 4 character installation ID, SITE0001 is the 4 character 4 digit site ID, followed by a 7

AF

sdsID A unique identifier for all features and objects in the SDSFIE.

GUID SDSFIE

sdsFeatureName The common name of the feature.

The local name for the Land Use Control area.

String (80)

SDSFIE

sdsFeatureDescription A narrative describing the feature.

Any descriptive information about the Land Use Control that is not already included in the attribute table.

String (255)

SDSFIE

sdsMetadataID

SDSFIE

areaSize The value of the measured area.

Recorded to the 1/1000 of an acre.

Double AF

D areaSizeUOM The unit of measure for the area of the calculated area.

acre

String (20)

AF

perimeterSize The value of the measured perimeter.

Recorded to the 1/1000 of a foot.

Double AF

D perimeterSizeUOM The perimeter unit of measure.

foot

String (25)

6 | P a g e

Attribute Name Definition Allowed Values Data Type

(Length) Advocate latitude

The latitude coordinate of the "centroid" of the polygon in decimal degrees.

decimal degrees Double AF longitude

The longitude coordinate of the "centroid" of the polygon in decimal degrees.

decimal degrees Double AF

MGRScentroid

Military Grid Reference System for the centerpoint of the

(area) critical infrastructure. MGRS is calculated from the

Latitude and Longitude values.

AF

eesohmisSiteID

The ID for the restoration site(s) taken from EESOH-

MIS.

Allowed values can be obtained from EESOH-

MIS.

String (80)

AF

associatedOU Identifies the associated operable unit.

AF

LUCstartDate

Date the restriction took effect. Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915).

AF

modificationDate

Date the restriction was last modified.

Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915). If not applicable, use 99999999.

7 | P a g e

Attribute Name Definition Allowed Values Data Type

(Length) Advocate terminationDate

Date the restriction terminated. Format for date is YYYYMMDD (i.e., September 15, 1994 = 19940915). If not applicable, use

99999999.

AF

LUCduration A narrative description of the duration of the

LUC.

AF

LUCdecisionalDoc

Identifies the decisional document

(e.g., Record of Decision, Remedial Action, etc.) for the LUC at the site ID.

AF

LUCdisclaimer Any disclaimers associated with the

AF

LUCtype

The general type(s) of LUC applied to the site, such as "groundwater related", "soil related", or "soil and subsurface debris related."

AF

D LUCstatus Identifies the status of the LUC Site.

For a list of domain values, see LUCstatus in Appendix 1.

String (10)

AF

D LUCmonitor

Identifies the monitoring frequency associated with the

LUC.

For a list of domain values, see

MonitoringFreq in Appendix 1.

String (20)

AF

D LUCaccess

Identifies the level of access to a site in accordance with the LUC(s) at the site.

For a list of domain values, see LUCaccess in Appendix 1.

String (20)

AF

D isEnvCovenants

Indicates whether there are LUC type environmental covenants.

NA, no, TBD, yes String

(3)

AF

D isEasements Indicates whether there are LUC type easements.

NA, no, TBD, yes

String

8 | P a g e

Attribute Name Definition Allowed Values Data Type

(Length) Advocate

D isDigPermits Indicates whether there are LUC type dig permits.

NA, no, TBD, yes String

(3)

AF

D isDeedRestrict Indicates whether there are LUC type deed restrictions.

NA, no, TBD, yes String

(3)

AF

D isDeedNotices Indicates whether there are LUC type deed notices.

NA, no, TBD, yes

String (3)

AF

D isFences Indicates whether there are LUC type fences.

NA, no, TBD, yes

String (3)

AF

D isGuards Indicates whether there are LUC type guards.

NA, no, TBD, yes

String (3)

AF

D isLocUseOrdinance Indicates whether there are LUC type local use ordinances.

NA, no, TBD, yes

String (3)

AF

D isMasterPlanNotation

Indicates whether there are LUC type notations in master plan.

NA, no, TBD, yes String

(3)

AF

D isSigns Indicates whether there are LUC type signs.

NA, no, TBD, yes

String (3)

AF

D isZoning Indicates whether there is LUC type zoning.

NA, no, TBD, yes

String (3)

AF

D isResidentialUse Indicates whether residential use is prohibited.

NA, no, TBD, yes

String (3)

AF

D isSensitiveUse

Indicates whether activities are prohibited due to sensitive use (e.g.

hospital, daycare, school).

NA, no, TBD, yes String

(3)

AF

D isHumanGrndwtrCons um

Indicates whether human consumption of groundwater is prohibited.

NA, no, TBD, yes String

9 | P a g e

Attribute Name Definition Allowed Values Data Type

(Length) Advocate

D isDrinkingWtrWellInst

Indicates whether installation of drinking water well is prohibited.

NA, no, TBD, yes String

(3)

AF

D isAgriGrndwtrUse

Indicates whether agricultural/irrigation/l ivestock use of groundwater is prohibited.

NA, no, TBD, yes String

(3)

AF

D isSurfaceWtrExp Indicates whether exposure to surface water is prohibited.

NA, no, TBD, yes String

(3)

AF

D isSoilExposure Indicates whether exposure to soils is prohibited.

NA, no, TBD, yes

String (3)

AF

D isSedimentExp Indicates whether exposure to sediments is prohibited.

NA, no, TBD, yes String

(3)

AF

D isIndustCommUse

Indicates whether land use is restricted to industrial/commercial only.

NA, no, TBD, yes String

(3)

AF

D isAgriOrParkUse Indicates whether agricultural and park land use is prohibited.

NA, no, TBD, yes String

(3)

AF

associatedCost

Annual maintenance/complia nce costs with the

AF

programManager

The Environmental Restoration point of contact responsible for the feature.

AF

pocContactInfo

The contact information for the point of contact responsible for the

AF

D installationID

Installation identifier assigned to the

Installation by real property.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (16)

10 | P a g e

Attribute Name Definition Allowed Values Data Type

(Length) Advocate

D installationName

The actual name of the installation that is associated with the installation ID defined by real property.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (100)

AF

D siteID Installation identifier assigned to the Site by real property.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (36)

AF

D majorCommand Service Major

Command of the installation.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (10)

AF

D realPropertySiteUniqu eID

The unique identifier (UID) used to permanently identify a Site. This UID will be a

Real Property Site Unique Identifier (RPSUID). Source:

RPIM, v3.0, extracted 4/2009.

For the list of domain values see the Air

Force GeoBase Data Working Group AF

Adaptation 3.1.1 Data Dictionary.

String (20)

AF

wacInnrCode The NGA World

Airfield Identifier.

The NGA World Airfield Identifier

Code: List of codes can be accessed at the following site:

https://www.extranet.

nga.mil/

String (10)

AF

dataSteward

The data steward is the entity that oversees the data content, context, and associated business

AF

https://www.extranet.nga.mil/ https://www.extranet.nga.mil/

11 | P a g e

Attribute Name Definition Allowed Values Data Type

(Length) Advocate

D…