PWS_Attachment_14_-_3.1.0.1_-_AF_Adaptation_Data_Dictionary_(too_big_to_print_out).xls

XLS spreadsheet 29 MB Posted Aug 28, 2017

Attached to: GEOSPATIAL SERVICES
Solicitation number: FA2517-17-Q-5051
Issued by: Department of the Air Force Space Command

About this file

From the source

PWS Attachment 14

View the file

Other files

File	Type	Posted
PWS_Attachment_10_-_CavalierAFS_Spiral5_GIS_DataAudit_Priority_3AUG2017.xlsx	XLSX spreadsheet	Aug 28, 2017
FA2517-17-Q-5037_Geospatial_Services_RFQ.pdf	PDF	Aug 28, 2017
PWS_Attachment_1_-_Installation_FIAR_Guide_FINAL_17Mar2016.pdf	PDF	Aug 28, 2017
PWS_Attachment_5_-_AFI32-10112.pdf	PDF	Aug 28, 2017
PWS_Attachment_2_-_AF_Linear_Segmentation_Implementation_Guidance_-_Apr_13.pdf	PDF	Aug 28, 2017
PWS_Attachment_6_-_Cavalier_AFS_Real_Property_Listing_EGYN_as_of_30_Sep_09.pdf	PDF	Aug 28, 2017
PWS_Attachment_4_-_AFI32-9005.pdf	PDF	Aug 28, 2017
PWS_Attachment_11_-_Clear_Update_Linear_Segmentation_Status_Jan_14.xlsx	XLSX spreadsheet	Aug 28, 2017
Attachment_2_-_Contractor_Submittal_Form.pdf	PDF	Aug 28, 2017
Attachment_3_-_WD_Rev7_25JUL17.pdf	PDF	Aug 28, 2017
PWS_Attachment_13_-_EFDS_Project_Summary_26Aug2013.pdf	PDF	Aug 28, 2017
PWS_Attachment_8_-_Installation_Data_Health_Tool_Instructional_Document.pdf	PDF	Aug 28, 2017
PWS_Attachment_7_-_Clear_AFS_Real_Property_Listing_DXEB_as_of_30_Sep_09.pdf	PDF	Aug 28, 2017
PWS_Attachment_9_-_Cavalier_AFS_EFDS_Status_Spreadsheet_08082013.xlsx	XLSX spreadsheet	Aug 28, 2017
Attachment_1_-_PWS_28_Aug_2017.pdf	PDF	Aug 28, 2017
PWS_Attachment_12_-_Clear__AFS_EFDS_Status__Spreadsheet_08082013.xlsx	XLSX spreadsheet	Aug 28, 2017

Show all 16

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Home

		U.S. Air Force GeoBase
		AF Adaptation 3.1.0.1 Data Dictionary
		Prepared by the AFCEC Geospatial Integration Office
		Air Force Civil Engineer Center
		Click to browse Data Dictionary for AF Adaptation 3.1.0.1 >
	AF Adaptation 3.1 Data Dictionary Information
	Document Definition	Centralized repository of information about the AF 3.1.1 Adaptation.
	Adaptation Version	3.1.0.1
	Document Author Name	Keith McCrary, GISP - Data Development Lead Analyst at AFCEC GIO Office
	Document Author Email	keith.mccrary.ctr@us.af.mil
	Author Phone	(210) 395-0413
	Adaptation Version History:	Release Date:
	3.0 - AF Adaptation Data Dictionary	Friday, August 23, 2013
	3.1.0 - AF Adaptation Data Dictionary	Friday, February 27, 2015
	3.1.0.1 - AF Adaptation Data Dictionary	Friday, July 31, 2015
	AFCEC Geospatial Integration Office
	Office Location	Joint Base San Antonio – Lackland
	Office Contact	DSN 969-8071; Comm 210-395-8071; AFCEC.GIO.Workflow@us.af.mil
	Geospatial Information Officer (GIO) - Scott Ensign	scott.ensign.1@us.af.mil
	AF SDSFIE Adaptation Project Officer - Greg Czerniak	gregory.czerniak.1@us.af.mil
	AFCEC GIO Office Mailing Address
	Via US Postal Service:	Via UPS, FedEx, etc.:
	AFCEC/CPAB	AFCEC/CPAB
	2261 Hughes Ave. Ste. 155	3515 S. General McMullen, Bldg 171, Room 8009
	Lackland AFB, TX 78236-9853	San Antonio TX 78226-9853
	WGIO "3.1 Data Dictionary Orientation" video on milTube:
(For use with all 3.1.x Adaptation releases)	https://www.milsuite.mil/video/watch/newvideo/8636

keith.mccrary.ctr@us.af.mil scott.ensign.1@us.af.mil gregory.czerniak.1@us.af.mil Click to browse Data Dictionary for AF Adaptation 3.1.0.1 > https://www.milsuite.mil/video/watch/newvideo/8636

Stats

Adaptation Element Statistics
Geodatabase Elements	Total # in 3.0 Adaptation	Total # in 3.1 Adaptation	TOTAL CHANGE	Extra Stats
Total # of Feature Datasets	25	35	(+)10
Total # of Feature Classes	373	522	(+)149	3.1 Point FCs = 215 (41%)

3.1 Line FCs = 105 (20%)

3.1 Area FCs = 202 (39%)

Total # of Attributes (Unique) 671 2,724 (+)2053 Note: (522 feature classes) x (# of attributes in each FC) = 23,730 total attributes

Domain Tables	543	611	(+)68
Domain Values (Unique)	9,773	11,972	(+)2199	Note: 14,867 total domain values in 3.1 Adaptation.

TOC

Table of Contents	< Home
Informational
Definitions	Definitions of fields, attributes, and ESRI file organization types.
Attribute Order	Defines the order of attributes in all feature classes.
Minimum Accuracy Standard	The Minimum Accuracy Standard defined for each feature class.
CIP Lists	List of feature classes in the AF 2.6, 3.0, 3.1 CIP's and DISDI 3.0 & 3.1 CIP's.
Documentation	Lists-out and provides a link to external documents related to the 3.1 AF Adaptation release.
FAQ	Frequently Asked Questions concerning 3.1 Adaptation documentation.
Element Summaries
Feature Datasets	Feature datasets are collections of related features represented in a group of feature classes.
Feature Classes	Definitions of all feature classes within the data dictionary.
Attributes	Definitions of all attributes within the data dictionary.
Domain Tables	Definitions of all enumerations Domain Tables (Enumerations) within the data dictionary.
Domain Values	Definitions of all enumerants Domain Values (Enumerants) within the data dictionary.
Air Force Mission Data Set (MDS) Layer List
AICUZ	Air Installation and Compatible Use Zone (AICUZ)

This Mission Dataset enables planners and decision-makers to manage Air Installation and Compatible Use Zone (AICUZ) challenges across the entire Installation Complex. Map Views are a specific resolution, perspective, or purpose for visualizing the various layers of a Mission Dataset. These views are typically of a functional or operational-specific nature overlaid foundational layers such as the CIP or aerial photography. Map views are formerly known as Tab Maps ICEMAP Installation Complex Encroachment Management Action Plan (ICEMAP) This Mission Dataset enables planners and decision-makers to manage Range operations, and encroachment and sustainment challenges across the entire Installation Complex and Mission Footprint. Map Views are a specific resolution, perspective, or purpose for visualizing the various layers of a Mission Dataset. These views are typically of a functional or operational-specific nature overlaid foundational layers such as the CIP or aerial photography. Map views are formerly known as Tab Maps.

IDP Map Views: Installation Development Plan (IDP) Map Views are a specific resolution, perspective, or purpose for visualizing the various layers of a Mission Dataset. These views are typically of a functional or operational-specific nature overlaid foundational layers such as the legacy CIP Feature Classes. Map views are formerly known as Tab Maps.

Externally Managed Feature Classes	Feature classes in Air Force Mission Data Sets that are managed outside of Air Force and SDSFIE.
Business Table Attributes	The environmental business tables were developed to capture additional information about specific features within a feature class. These attributes were deemed important enough to capture, but may not be relevant to features at all installations and were thus placed in a separate business table rather than the main attribute table.

< Home Feature Classes Attributes Minimum Accuracy Standard CIP Lists Definitions Domain Tables Domain Values Feature Datasets

FAQ

AICUZ

ICEMAP

IDP

Externally Managed Feature Classes

Definitions

Adaptation Definitions	< Table of Contents
Data Organizational Structure
Geodatabase	A database that is optimized to store and query data that represents objects defined in a collection of geographic datasets.
Feature Dataset	A collection of related features represented in a group of feature classes.
Feature Class	A collection of geographic features with the same geometry type (such as point, line, or polygon), the same attributes, and the same spatial reference.
Attribute	Nonspatial information about a geographic feature in a GIS, usually stored in a table and linked to the feature by a unique identifier.
Domain Tables (Enumerations)	A range or set of codes to restrict field values in a field.
Domain Values (Enumerants)	Codes or values that define a set of allowed values for a field.
Table	Data organized into fields and records; a cell is where a field & record intersect. A table has a specified number of fields, but can have any number of records.
DISDI Definitions
Abstract	A brief summary of the feature dataset.
Acceptable Values	Values defined by the Air Force data owner. To be used in any QA/QC procedures.
Advocate	The advocate that recommends the attribute's existence in the feature class.
Alias Name	The name of the feature used for display or cartographic purposes.
Attribute Name	Name of Attribute name as it appears in the 3.1.0 AF Adaptation physical model.
Attribute Name	The name of the element as it appears in the 3.1.0 AF Adaptation physical model.
Business Requirement	The entity model name of the parent entity, if this is a subclass.
CAD Layer Equivalent	The layer in AutoCAD that corresponds to the element in the 3.1.0 Adaptation.
Can subtype?	Indicates whether the enumeration can be used to subtype an entity. If this field is YES, then Enumerants that belong to the Enumeration must have the subtypeCodeAlias populated and they must all be unique. IF YOU DO NOT DO THIS, the ingest process will automatically assign a serial subtypeCodeAlias for you based on the primary key of the enumerant. If the Is List? is NO then this field must be NO.
Constrained By	The model name of a constraining enumeration. The enumeration must exist in the parent adaptation or in the Enumerations Extensions tab in this workbook.
Data Type	The name of the data type for this attribute. Valid types are Integer, Real, Decimal, String, Boolean, Date, DateTime, Time, GUID, or BLOB.
Default Geometry	The primary geometry of the entity and the one that will be used unless overridden in the generation workflow.
Default Value	A value that the attribute will contain in an implementation unless the value is changed by the GIS data manager.
Definition	The definition of the entity. Definitions should follow the pattern [Entity Alias Name] is [Entity Definition]. See section 6 of the SDSFIE 4.0 Data Architecture for guidelines on definitions.
Description	Descriptions are optional and can include examples and elaboration on the definition.
DISDI Gold	Identifying what is an SDSFIE 3.1 Gold element.
Domain Table Name	Name of Domain Table as it appears in the 3.1.0 AF Adaptation physical model.
Domain Value Name	Name of Domain Value as it appears in the 3.1.0 AF Adaptation physical model.
Feature Class Name	Name of Feature Class as it appears in the 3.1.0 AF Adaptation physical model.
Feature Dataset Name	Name of Feature Dataset as it appears in the 3.1.0 AF Adaptation physical model.
First Version	First Version defines which version was the first time the entity was included in the AF Adaptation.
Justification	The justification for the new element. If you are providing Business Requirements and/or Requirements documents to support the new element, then this field should describe how those apply to the proposed element. At least one of Justification, Business Requirement #s, or Requirements Document #s must be provided.
Latest Version	Last Version defines which version was the last time the entity was included in the AF Adaptation.
Length/Precision	The number of symbols or number of digits in the attribute data type. This cannot be null for data types Real or Decimal. It can be empty for String if the attribute has a constraining enumeration.
Minimum Accuracy Standard	The Minimum Accuracy Standard as a specific grade defined for each feature class.
Note	Notes are optional and are used to describe practical constraints on the entity.
Minimum Required	Defines the advocate of the minimum requirement.
Permissible Geometries	All of the permissible geometries for this entity. The default geometry must be in the list.
Primary Key?	Indicator of whether the attribute is the primary key attribute in the entity. Each entity must have one primary key. True indicates that the attribute is the primary key of the entity. When isPK is True isNullable must be False.
Real Property Entity	Select YES if this entity represents a real property asset.
Requirements Document	The requirements document(s) for the new element represented as a comma-separated list of numbers from the Requirements (Policy) Documents tab. At least one of Justification, Business Requirement #s, or Requirements Document #s must be provided.
Scale	The number of positions to the right of the radix point in a real number. This value cannot be null when the data type is Real or Decimal
Secondary Name	The secondary name for the entity. This name will be stored in a separate "alternate name mapping" table (not with the Adaptation) and will be related to the adaptation. In PDM generation workflows, this "alternate name mapping" will be accessible as one possibility(the default one) to be used when generating the PDM.
Short Name	The name as it appears in paver or other third party Air Force entity.
Subclass Parent	The entity model name of the parent entity, if this is a subclass.
Subtype Code Alias	A long integer that overrides the default subtype code derived from the primary key. This code, when not null, is used when subtyping an entity for implementation.
Subtype?	Indicator of whether the attribute is used in defining a subtype for a feature class.

< Table of Contents

Attribute_Order

Order of Standard Attributes				< Back to Table of Contents
IDPK	Text	20	[FeatureName]IDPK is generated as follows: INST_SITE00010000001…..n, where INST is 4 character installation code, SITE0001
sdsID	GUID	38	SDSFIE (Required)
sdsFeatureName	Text	80
sdsFeatureDescription	Text	255
sdsMetadataID	Text	80
areaSize	Double		All POLYGON

feature classes only. Measurement/Locational Fields

Note for line feature classes. These fields are used for capturing locations of linear features that are analyzed for elevation or location.

areaSizeUOM	Text	20
perimeterSize	Double
perimeterSizeUOM	Text	20
latitude	Double
longitude	Double
MGRScentroid	Text	20
lengthSize	Double		All LINE

feature classes only.

lengthSizeUOM	Text	20
latitudeFrom	Double
latitudeTo	Double
longitudeFrom	Double
longitudeTo	Double
elevationFrom	Double
elevationTo	Double
elevationUOM	Text	20
latitude	Double		All POINT

feature classes only.

longitude	Double
MGRS	Text	20
elevation	Double
elevationUOM	Text	20
(attribute name)	(Varies)	(Varies)	Feature Class- Specific
installationID	Text	16	Foundational Attributes
installationName	Text	100
siteID	Text	36
majorCommand	Text	10
realPropertySiteUniqueID	Text	20
wacInnrCode	Text	10
dataSteward	Text	20
country	Text	5
owner	Text	10
createDate	Date		Air Force Feature-Level Metadata Fields
creator	Text	30
dataCollection	Text	20
dataSource	Text	100
editor	Text	30
dateEdited	Date
metaNotes	Text	255
mediaLink	Text	255	Media
notes	Text	255	General Feature Notes

< Back to Table of Contents

Minimum_Accuarcy_Standards

Minimum Accuracy Standards		< Back to Table of Contents
Minimum Accuracy Standard	Definition
Meter-plus	Recreational grade at meter-plus accuracy. Digitized from satellite imagery or from unknown origin or accuracy.
Sub-meter	Map grade at sub-meter accuracy. The use of satellite imagery, GPS, and additional equipment to deliver readings.
Centimeter	Survey grade at centimeter accuracy. The use of aerial imagery, GPS, and additional equipment to deliver precise readings.

< Back to Table of Contents

CIP_Lists

CIP Lists	List of feature classes included in each CIP.			< Back to Table of Contents
AF 2.6 CIP Layers	AF 3.0 CIP Layers	AF 3.1 CIP Layers (as of May 2013)	DISDI 3.0 CIP Layers	DISDI 3.1 CIP Layers
airfield_surface_area	AirfieldSurface	AirfieldSurface_A	<No Equivalent>	<No Equivalent>
<No Equivalent>	AccessControl_L	Gate_L	AccessControl_A	AccessControl
			AccessControl_L
			AccessControl_P
<No Equivalent>	<No Equivalent>	<No Equivalent>	AdministrativeBoundary	<No Equivalent>
<No Equivalent>	<No Equivalent>	<No Equivalent>	AirAccidentZone
airfield_surface_centerline	AirfieldSurface_L	AirfieldCenterline_L	<No Equivalent>	<No Equivalent>
athletic_court_area	<No Equivalent>	<No Equivalent>	<No Equivalent>	<No Equivalent>
athletic_field_area	<No Equivalent>	<No Equivalent>	<No Equivalent>	<No Equivalent>
<No Equivalent>	Berm	Berm_A	<No Equivalent>	<No Equivalent>
road_bridge_area	Bridge	Bridge_A	Bridge_A	Bridge
			Bridge_L
			Bridge_P
structure_existing_area	Building	Building_A	Building_A	Building
			Building_P
<No Equivalent>	<No Equivalent>	<No Equivalent>	<No Equivalent>	Cable
campground_area	Campground	Campground_A	<No Equivalent>	Campground
dam_area	Dam	Dam_A	<No Equivalent>	Dam
elevation_contour_line	ElevationContour	ElevationContour_L	<No Equivalent>	ElevationContour
<No Equivalent>	<No Equivalent>	<No Equivalent>	EnvironmentalRemediationSite_A	<No Equivalent>
			EnvironmentalRemediationSite_P
fence_line	Fence	Fence_L	Fence	Fence
footbridge_area	<No Equivalent>	<No Equivalent>	<No Equivalent>	<No Equivalent>
golf_course_area	GolfCourse	GolfCourse_A	GolfCourse	GolfCourse
mooring_facility_area	DocksAndWharfs	DocksAndWharfs_A	<No Equivalent>	DocksAndWharfs
installation_area	Installation	<No Equivalent>	<No Equivalent>	Installation
levee_berm_area	Levee_A	Levee_A	<No Equivalent>	Levee
<No Equivalent>	<No Equivalent>	<No Equivalent>	LandParcel	<No Equivalent>
<No Equivalent>	<No Equivalent>	<No Equivalent>	MilitaryTrainingLocation	<No Equivalent>
military_live_fire_range_area	<No Equivalent>	<No Equivalent>	ImpactArea	<No Equivalent>
military_range_area	MilitaryRange	MilRange_A	MilitaryRange_A	MilitaryRange
			MilitaryRange_P
<No Equivalent>	<No Equivalent>	<No Equivalent>	MilitaryTrainingLocation	<No Equivalent>
surface_water_body_area	NaturalWaterbody	NaturalWaterbody_A	<No Equivalent>	NaturalWaterbody
<No Equivalent>	PavementBranch	<No Equivalent>	PavementBranch	PavementBranch
vehicle_driveway_area	<No Equivalent>	Sidewalk_A	PavementSection	PavementSection
pedestrian_sidewalk_area
playground_area	Playground_A	Playground_A	<No Equivalent>	Playground
railroad_bridge_area	<No Equivalent>	<No Equivalent>	<No Equivalent>	<No Equivalent>
railroad_centerline	RailSegment	RailSegment_L	RailSegment	RailSegment
recreation_park_area	RecreationFeature_A	RecFeature_A	RecreationArea	RecreationFeature
recreation_trail_centerline	RecreationTrail	RecTrail_L	<No Equivalent>	RecreationTrail
road_area	RoadArea	RoadArea_A	RoadArea	<No Equivalent>
road_centerline	RoadCenterline	RoadCenterline_L	RoadCenterline	<No Equivalent>
shed_area	<No Equivalent>	<No Equivalent>	<No Equivalent>	<No Equivalent>
<No Equivalent>	<No Equivalent>	<No Equivalent>	RoadPath	<No Equivalent>
<No Equivalent>	<No Equivalent>	<No Equivalent>	RoadSeg	<No Equivalent>
Shoreline	Shoreline	Shoreline_L	<No Equivalent>	Shoreline
<No Equivalent>	<No Equivalent>	Site_A	Site	<No Equivalent>
<No Equivalent>	Structure	Structure_A	<No Equivalent>	Structure
slab_area	<No Equivalent>	Slab_A	<No Equivalent>	<No Equivalent>
surf_wat_course_centerline	WatercourseLine	WatercourseLine_L	<No Equivalent>	WatercourseLine
surface_water_course_area	WaterFeature	WaterFeature_A	<No Equivalent>	<No Equivalent>
swimming_pool_area	<No Equivalent>	<No Equivalent>	<No Equivalent>	<No Equivalent>
tower_point	Tower_P	Tower_P	Tower	Tower
tunnel_area	TransportationTunnel	TransportationTunnel_A	<No Equivalent>	TransportationTunnel
vehicle_parking_area	VehicleParking	VehicleParking_A	VehicleParking	VehicleParking
wall_line	Wall	Wall_L	<No Equivalent>	Wall
<No Equivalent>	<No Equivalent>	<No Equivalent>	Wetland	<No Equivalent>

< Back to Table of Contents AirfieldSurface_L Levee_A Playground_A Tower_P Campground_A Dam_A DocksAndWharfs_A ElevationContour_L Fence_L GolfCourse_A Levee_A Playground_A RailSegment_L RoadArea_A RoadCenterline_L Sidewalk_A Site_A Structure_A Tower_P TransportationTunnel_A VehicleParking_A Wall_L WatercourseLine_L WaterFeature_A MilRange_A RecFeature_A RecTrail_L Berm_A AirfieldSurface_A AccessControl_L AirfieldSurface Building_A AccessControl_L Bridge_A Building_A MilRange_A Sidewalk_A

Documentation

Documentation	< Table of Contents
3.1.1 Adaptation Package Documents	Click Here To Access All Documents (CAC-Enabled)
Primary & Techinical Documents	AF Adaptation Archive (pre-3.1)
Implementation Guidance & Governance	ESS [Explosive Safety] Data Dictionary
Feature-Level Metadata SOP Document	AF Adaptation 3.0 Data Dictionary
3.1 Adaptation Schema Formatting Rules	AF Adaptation 26-30 CIP Crosswalk
Schema Change Request Form	AF Adaptation 30-31 CIP Crosswalk
AF Adaptation 3.1.1 Data Dictionary	AF Adaptation of SDSFIE 3.0 (v.1.2).pdf
3.1 Tools	AF Adaptation 3.0 CIP model
2.6-3.1 Migration Tool	AF Adaptation 3.1 CIP model
3.0-3.1 Migration Tool	2.6 AF Adaptation Geodatabase Shell
3.1 Geodatabase Shell Creator Tool	3.0 AF Adaptation Geodatabase Shell
3.1 Orientation & Tutorial Videos	SDSFIE 3.1 Gold
3.1 AF Adaptation Package Orientation	DISDI 3.0 CIP
3.1 AF Adaptation Data Dictionary Orientation	DISDI 3.1 CIP
3.1.x AICUZ GuidanceMDS Tutorial Video	Schema Change Catalog
3.1.x ICEMAP Guidance MDS Tutorial Video	A/E/C CAD Standard Release 5.0
3.1.x IDP Guidance MDS Tutorial Video	ESS [Explosive Safety] Data Dictionary
WGIO GIS Methodology DCO Videos Archive	ect.

< Table of Contents Click Here To Access All Documents (CAC-Enabled)

FAQ

Frequently Asked Questions	< Table of Contents
Click Here To Access All Documents (CAC-Enabled)
Q: Is there a set of primary and/or secondary set of documentation that accompanied the AF Adaptation 3.1.0 release?
A: Click on the link above • Click on "3.1 Documentation"
Q: This Data Dictionary Excel file has a lot of information in it, is there a short and simple video that can help me navigate?
A: Click on the link above • Click on "3.1 Orientation Videos" • Click on "Data Dictionary Orientation Video"
Q: How do I find a full model of the 2.6, 3.0, and 3.1 AF CIP models?
A: Click on the link above • Click on "Adaptation Archive"
Q: How do I find a full model of the 3.0 and 3.1 DISDI CIP models?
A: Click on the link above • Click on "Adaptation Archive"
Q: Where can I find CAD standards as taught at Fort Leonard Wood?
A: Click on the link above • Click on "Adaptation Archive"
Q: Where can I get 2.6-3.0 or 3.0-3.1 AF Adaptation CIP crosswalks?
A: Click on the link above • Click on "Adaptation Archive"
Q: Is there an Explosives Safety Siting (ESS) Data Dictionary?
A: Click on the link above • Click on "Adaptation Archive"
Q: I would like to submit an add/revise/delete to be reflected in the future 3.1.1 model, what is the document I need to fill out and submit to AFCEC?
A: Click on the link above • Click on "3.1 Documentation" • Click "Schema Change Request Form"
Q: I need to know more about feature-level metadata as it relates to AF Adaptation, is there a document for this?
A: Click on the link above • Click on "3.1 Documentation" • Click "Feature-Level Metadata - Standard Operating Procedure"
Q: A majority of features have a uniform look in terms of letter casing, is there a document that defines standard formats in the 3.1.0 AF Adaptation?
A: Click on the link above • Click on "3.1 Documentation" • Click "Adaptation Schema Formatting Rules & Guidance"
Q: Where can I get the 2.6-3.1 & 3.0-3.1 migration tool? Is there a tool that will be an empty 3.1.0 AF Adaptation geodatabase shell?
A: Click on the link above • Click on "3.1 Tools"
Q: Where are the ancillary tables I used to see in AF Adaptation 3.0?
A: Starting in AF Adaptation 3.1, standard ancillary tables have been removed.
Q: What DWG-approved values do I use to represent 'TBD', 'NA', or 'other' into an empty integer field?
77777 = Not Applicable: No value exists ("NA" numeric equivalent)

88888 = Other. Must be described in the sdsFeatureDescription attribute. ("other" numeric equivalent) 99999 = To Be Determined: A value is required but the value has yet to be determined. ("TBD" numeric equivalent)

Q: What is the formula used to generate the [FeatureName]IDPK?

INST_SITE00010000001…..n - Where INST is 4 character installation code, SITE0001 • Click on the link above • Click on "3.1 Documentation" • Click on "AF Adaptation of SDSFIE 3.1" for more information.

[FeatureName]IDPK is a text attribute 20 Characters in length. The Air Force will use this field to generate a unique primary key. No duplicates are allowed. If the IDPK is a primary or foreign key to other authoritative business data, the key cannot be altered and the feature cannot be deleted without co-coordinating with the functional owner or business line that has a shared relationship with IDPK. It will be the responsibility of both the GIO and the functional business owner to ensure relationship integrity is maintained.

Q: Are SHAPE_Length and SHAPE_Area standard attribution?

A: SHAPE_Length and SHAPE_Area are ESRI-generated fields. The data types are often classified as esriFieldTypeDouble. The SHAPE_Area field is automatically is generated for polygon feature classes and the SHAPE_Length field is automatically generated for line and polygon feature classes.

< Table of Contents Click Here To Access All Documents (CAC-Enabled)

Feature_Datasets

	Feature Datasets					< Back to Table of Contents
	Feature Dataset
Name	Definition	Description	Note	Justification	Abstract	Business Requirement	Requirements Document	First Version	Latest Version	3.0 Name
	Auditory	The Auditory feature dataset is a collection of features relating to sources and zones of sounds.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Auditory
	Cadastre	The Cadastre feature dataset is a collection of registered properties and showing the extent, value, and ownership of land.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Cadastre
	Emergency	The Emergency feature dataset is a collection of feature locations that required immediate attention.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Emergency
	environmentalAirQuality	Air quality is the measurement of pollutants in the air.	See AFCEC Environmental Data Layer Standards (DLS)	TBD	Created by AFCEC Environmental GeoBase program.	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	3.1.0	TBD	<Not Present in 3.0>
	environmentalCulturalResources	The CulturalResources feature dataset is a collection of features significant to history, architecture, archeology, or culture.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	CulturalResources
	environmentalHazMat	Hazardous materials are any substances or materials that have the potential to cause harm to the public, animals or environment.	See AFCEC Environmental Data Layer Standards (DLS)	TBD	Created by AFCEC Environmental GeoBase program.	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	3.1.0	TBD	<Not Present in 3.0>
	environmentalHazWaste	Hazardous waste is any waste that is potentially harmful to the public or environment.	See AFCEC Environmental Data Layer Standards (DLS)	TBD	Created by AFCEC Environmental GeoBase program.	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	3.1.0	TBD	<Not Present in 3.0>
	environmentalIntegratedSolidWaste	The Environmental Protection Agency (EPA) defines integrated solid waste management as a comprehensive waste prevention, recycling, composting, and disposal program.	See AFCEC Environmental Data Layer Standards (DLS)	TBD	Created by AFCEC Environmental GeoBase program.	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	3.1.0	TBD	<Not Present in 3.0>
	environmentalNaturalResources	The Natural Resources feature dataset is a collection of mapped natural features and species data.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	NaturalResources
	environmentalRestoration	The Environmental Restoration feature dataset is a collection of features relating to hazardous locations or places where environmental remediation has occurred or is under way.	See AFCEC Environmental Data Layer Standards (DLS)	TBD	Created by AFCEC Environmental GeoBase program.	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	3.1.0	TBD	<Not Present in 3.0>
	environmentalStorageTanks	Containers used for the short- or long-term storage of commodities, fuels or chemicals. These can either be aboveground or underground tanks.	See AFCEC Environmental Data Layer Standards (DLS)	TBD	Created by AFCEC Environmental GeoBase program.	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	3.1.0	TBD	<Not Present in 3.0>
	environmentalWaterQuality	Water quality is the measure of the suitability of water for a specified use, based on selected physical, chemical, and biological characteristics.	See AFCEC Environmental Data Layer Standards (DLS)	TBD	Created by AFCEC Environmental GeoBase program.	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	See AFCEC Environmental Data Layer Standards (DLS)	3.1.0	TBD	<Not Present in 3.0>
	GeneralMisc	The GeneralMisc feature dataset is a collection of features found throughout the installation that are unassigned to a specific feature dataset.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	General
	Geodetic	The Geodetic feature dataset is a collection of features relating to land surveying.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Geodetic
	Landform	The Landform feature dataset is a collection of features relating to the earth's surface.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Landform
	MilitaryRangeTraining	The Military Range Training feature dataset is a collection of features representing designated areas used to train military personnel in their use and handling of weapons.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	MilitaryRangeTraining
	MissileField	The MissileField feature dataset is a collection of features relating to missile fields.	TBD	TBD	TBD	TBD	TBD	TBD	3.1.0	TBD	<Not Present in 3.0>
	Pavements	The Pavements feature dataset is a collection of pavement data.	TBD	TBD	TBD	TBD	TBD	TBD	3.1.0	TBD	<Not Present in 3.0>
	Planning	The Planning feature dataset is a collection of features relating to development projects and land management.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Planning
	RealProperty	The RealProperty feature dataset is a collection of features representing Real Property features.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	RealProperty
	Recreation	The Recreation feature dataset is a collection of features representing activities of leisure.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Recreation
	Security	The Security feature dataset is a collection of features representing locations that secure personnel from danger or threat.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Security
	SpaceUtilization	The SpaceUtilization feature dataset is a collection of GIS and CAD-related features representing building interiors.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	SpaceUtilization
	Transportation	The Transportation feature dataset is a collection of features representing the system or means of transporting people or goods.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Transportation
	ULUC2	The ULUC2 feature dataset is a collection of feature classes concerning the Unit Level Bridge to Unit Command and Control.	TBD	TBD	TBD	TBD	TBD	TBD	3.1.0	TBD	<Not Present in 3.0>
	utilitiesElectrical	The utilitiesElectrical dataset captures utilities system features. These features are mapped in real world coordinates. Features inside system related buildings or structure or where features are tightly clustered may be mapped in real world coordinates or represented schematically within the network.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	eUtilities
	utilitiesFuels	The utilitiesFuels dataset captures utilities system features. These features are mapped in real world coordinates. Features inside system related buildings or structure or where features are tightly clustered may be mapped in real world coordinates or represented schematically within the network.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	oUtilities
	utilitiesGas	The utilitiesGas dataset captures utilities system features. These features are mapped in real world coordinates. Features inside system related buildings or structure or where features are tightly clustered may be mapped in real world coordinates or represented schematically within the network.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	gUtilities
	utilitiesMisc	The utilitiesMisc feature dataset is a collection of features representing the locations of the public service utility infrastructure.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	Utilities
	utilitiesSewer	The utilitiesSewer dataset captures utilities system features. These features are mapped in real world coordinates. Features inside system related buildings or structure or where features are tightly clustered may be mapped in real world coordinates or represented schematically within the network.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	sUtilities
	utilitiesStormwater	The utilitiesStormwater dataset captures utilities system features. These features are mapped in real world coordinates. Features inside system related buildings or structure or where features are tightly clustered may be mapped in real world coordinates or represented schematically within the network.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	dUtilities
	utilitiesThermal	The utilitiesThermal dataset captures utilities system features. These features are mapped in real world coordinates. Features inside system related buildings or structure or where features are tightly clustered may be mapped in real world coordinates or represented schematically within the network.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	tUtilities
	utilitiesWater	The utilitiesWater dataset captures water utility system features. These features are mapped in real world coordinates. Features inside system related buildings or structures, e.g., pumping stations, pressure reducing stations, etc., or where features are tightly clustered may be mapped in real world coordinates or represented schematically within the network.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	wUtilities
	WaterControl	The WaterControl feature dataset is a collection of features that are methods to reduce or prevent the detrimental effects of flood waters.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	WaterControl
	WaterWays	The WaterWays feature dataset is a collection of features and events found in or by a water feature.	TBD	TBD	TBD	TBD	TBD	TBD	3.0	TBD	WaterWays

Auditory Cadastre environmentalCulturalResources Emergency GeneralMisc Geodetic Landform MilitaryRangeTraining environmentalNaturalResources Planning RealProperty Recreation Security SpaceUtilization Transportation utilitiesMisc WaterControl WaterWays < Back to Table of Contents utilitiesWater utilitiesElectrical utilitiesFuels utilitiesGas utilitiesSewer utilitiesStormwater utilitiesThermal MissileField environmentalAirQuality environmentalIntegratedSolidWaste environmentalStorageTanks environmentalHazMat environmentalHazWaste environmentalWaterQuality environmentalRestoration Pavements

ULUC2

FD-AUDITORY

Auditory

< Back to Feature Datasets

To next feature class >

Feature Class

Name

Alias Name

Secondary Name

Short Name

Definition

Description

Note

Default Geometry

Permissible

Geometries

Subclass Parent

Feature Dataset Name

Advocate

DISDI Gold

Real Property

Entity

Justification

Business

Requirement

Requirements

Document

Abstract

Minimum Accuracy

Standard

First Version

Latest Version

CAD Layer

Equivalent

3.0 Name

MilFlightTrack_L

Military Flight Track

TBD

Flight paths in and out of the airfield traffic area on the installation.

TBD

YES

Line/Point/Polygon

TBD

Auditory

Air Force

To capture flight paths for planning and mission support.

TBD

Meter-plus

3.1.0

TBD

NoiseAbatementFeature_A

TBD

Any man-made device or equipment, not attached to the source itself, used to reduce noise.

TBD

Line/Point/Polygon

TBD

Auditory

Air Force

TBD

Meter-plus

3.1.0

TBD

NoiseAbatementFeature_A

NoiseAbatementFeature_L

TBD

Any man-made device or equipment, not attached to the source itself, used to reduce noise.

TBD

Line/Point/Polygon

TBD

Auditory

Air Force

TBD

Meter-plus

3.1.0

TBD

NoiseAbatementFeature_L

NoiseAbatementFeature_P

TBD

Any man-made device or equipment, not attached to the source itself, used to reduce noise.

TBD

YES

Line/Point/Polygon

TBD

Auditory

SDSFIE

YES

TBD

Meter-plus

3.1.0

TBD

NoiseAbatementFeature

NoiseIncident_P

Noise Incident Location

TBD

This feature is used for tracking locations for noise complaints or damage claims

TBD

YES

Line/Point/Polygon

TBD

Auditory

Air Force

To capture noise complaints or damage claims for planning and development purposes.

TBD

Meter-plus

3.1.0

TBD

NoiseReceiver_P

TBD

The location where a loud noise or a noise induced vibration has been received. This feature is used for tracking locations for complaints or damage claims. Incident details should be recorded in sdsFeatureDescription.

TBD

YES

Line/Point/Polygon

TBD

Auditory

SDSFIE

YES

TBD

Meter-plus

3.1.0

TBD

NoiseReceiver

NoiseSource_L

TBD

The location of a noise source. Record the activity start, stop, duration, recurrence and/or frequency (or schedule) during which the noise source is active in the sdsFeatureDescription.

TBD

Line/Point/Polygon

TBD

Auditory

Air Force

TBD

Meter-plus

3.1.0

TBD

NoiseSource_L

NoiseSource_P

TBD

The location of a noise source. Record the activity start, stop, duration, recurrence and/or frequency (or schedule) during which the noise source is active in the sdsFeatureDescription.

TBD

YES

Line/Point/Polygon

TBD

Auditory

SDSFIE

YES

TBD

Meter-plus

3.1.0

TBD

NoiseSource

NoiseZone_A

TBD

An area (or the external boundary of an area) describing the sound levels attributed to a noise source.

TBD

YES

Line/Point/Polygon

TBD

Auditory

SDSFIE

YES

TBD

Meter-plus

3.1.0

TBD

NoiseZone

NoiseZone_L

TBD

An area (or the external boundary of an area) describing the sound levels attributed to a noise source.

TBD

Line/Point/Polygon

TBD

Auditory

Air Force

TBD

Meter-plus

3.1.0

TBD

NoiseZone_L

< Back to Feature Datasets To next feature class > NoiseAbatementFeature_P NoiseAbatementFeature_A NoiseAbatementFeature_L NoiseReceiver_P NoiseSource_P NoiseSource_L NoiseZone_A NoiseZone_L Meter-plus MilFlightTrack_L Meter-plus NoiseIncident_P To next feature class > < Back to Feature Datasets

MilFlightTrack_L

< Back to AUDITORY feature dataset

< To previous feature class

To next feature class >

Attribute Name

Alias Name

Definition

Description

Note

Data Type

Length/Precision

Scale

Default Value

Constrained By

Minimum Required

Primary Key?

DISDI Gold

Advocate

Justification

Business

Requirement

Requirements

Document

Subtype?

Acceptable Values

First Version

Latest Version

AttrbiuteRank

milFlightTrackIDPK

The unique identifier for each feature in the feature class.

TBD

Text

NONE

Air Force

YES

Air Force

TBD

3.0

TBD

sdsID

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

TBD

GUID

NONE

SDSFIE

YES

SDSFIE

TBD

3.0

TBD

sdsFeatureName

The common name of the feature.

TBD

Text

NONE

SDSFIE

YES

SDSFIE

TBD

3.0

TBD

sdsFeatureDescription

A narrative describing the feature.

TBD

Text

255

NONE

SDSFIE

YES

SDSFIE

TBD

3.0

TBD

sdsMetadataID

The foreign key to a metadata record.

TBD

Text

NONE

SDSFIE

YES

SDSFIE

TBD

3.0

TBD

lengthSize

The value of the measured length.

TBD

Double

NONE

Air Force

YES

Air Force

TBD

3.1.0

TBD

lengthSizeUOM

The unit of measure for the area of the calculated length.

TBD

Text

TBD

GSIP_LengthUOM

Air Force

YES

Air Force

TBD

3.1.0

TBD

latitudeFrom

The latitude coordinate of the beginning (upstream/up gradient) coordinate point in decimal degrees.

TBD

Double

NONE

Air Force

YES

Air Force

TBD

3.1.0

TBD

latitudeTo

The latitude coordinate of the ending (downstream/down gradient) coordinate point in decimal degrees.

TBD

Double

NONE

Air Force

YES

Air Force

TBD

3.1.0

TBD

longitudeFrom

The longitude coordinate of the beginning (upstream/up gradient) coordinate point in decimal degrees.

TBD

Double

NONE

Air Force

YES

Air Force

TBD

3.1.0

TBD

longitudeTo

The longitude coordinate of the ending (downstream/down gradient) coordinate point in decimal degrees.

TBD

Double

NONE

Air Force

YES

Air Force

TBD

3.1.0

TBD

elevationFrom

The elevation component of the beginning (upstream/upgradient) coordinate point in feet.

TBD

Double

NONE

Air Force

YES

Air Force

TBD

3.1.0

TBD

elevationTo

The elevation component of the ending (downstream/downgradient) coordinate point in feet.

TBD

Double

NONE

Air Force

YES

Air Force

TBD

3.1.0

TBD

elevationUOM

The unit of measure for elevation dimension.

TBD

Text

TBD

GSIP_LengthUOM

Air Force

YES

Air Force

TBD

3.1.0

TBD