air force environmental gis - nmfwa.org
TRANSCRIPT
Air Force Environmental GIS
D EV ELO P M ENT O F A N A I R FO RCE W I D E AU THO RI TAT I V E CO M P REHENS I V E ENV I RO NM ENTA L G I S DATA BA S E : S U CCES S A ND CHA L L ENG E
1
USAF Identified a Need• Fill Data Gaps• Recognized up to 28 applicable data layers with incomplete or no spatial data• Complete datasets provide more complete plans• Comprehensive datasets allow for spatial analysis with data from other organizations e.g. utilities
• Data standardization• Base specific data models made analysis across installations difficult• Allows Subject Matter Experts to identify enterprise trends and address non-compliance issues• Enables enterprise wide planning
• Updated data• Provides a more accurate picture of what is on the ground
2
Pilot Year• Project began in 2014
• Tasked by AFCEC to work with Subject Matter Experts (SMEs) to develop standardized SDSFIE 3.0 AF Adaptation data models
• Initially began with 8 bases: Eglin, Hill, Offutt, Patrick, JBSA, Scott, Tinker, Peterson
• Tasked by AFCEC to place GIS Analysts at each Installation Support Section (ISS) to be responsible for all bases within the ISS
• Evaluate state of existing environmental GIS data (for applicability, completeness and against the SDSFIE standard)
• Additional bases were added following the pilot
3
Initial Objectives• Provide support for the acquisition, maintenance, analysis, and application of data to maintain
compliance of Environmental programs
• Develop data models in support of Environmental Management programs sections of the AF Adaptation of Spatial Data Standards for Facilities, Infrastructure, and Environment (SDSFIE)
• Collect, aggregate, integrate, and standardize geospatial data for inclusion into Environmental Management data models to support AF GeoBase
4
Phase 1Assessment
Phase 2Standardization
& MigrationPhase 3
Quality Control
Project Organization• Funding from US Army Corps of Engineers Cooperative Agreements
• CSU/ CEMML tasked by AFCEC/CZCA
• ISS GIS Analysts• Co-located with AFCEC/CZO ISS & RSB installations
• Execute data development and maintenance tasks as directed by CSU-CEMML • Assist with GIS Support requested directed by the Environmental Programs
• Technical Support Center (TSC)• Located at CSU-CEMML in Fort Collins, CO
• Coordinate ISS GIS Analysts workflow & processes
• Provide reach back support to ISS GIS Analysts
5
6
Installations by ISS/RSB Locations
7
Installations by Storefront Locations
Supported Programs• All major medias are supported
to include:• Air Quality
• Cultural Resources• Environmental Constraints
• Hazardous Materials & Waste
• Integrated Solid Waste
• Natural Resources
• Restoration• Tanks
• Water Quality
• A total of 70 Environmental feature classes are maintained
8
Data Model Developmento Met with AFCEC SMEs to determine feature classes needed to support environmental program
compliance
o Evaluated feature classes already existing within SDSFIE schema and identified gaps
o Consulted with SMEs and determined necessary attributes and domains for each feature class to ensure utility
o Developed detailed Data Layer Specifications documents for each feature class to assist with development and standardization
o Compiled necessary change requests to adjust the data model and coordinated with AFCEC GeoBase
o Result: Environmental GIS SDSFIE 3.1 schema
9
AssessmentFollowing development of the data model an evaluation was conducted for each base
The data evaluations were used to identify:•Which layers were applicable to the installation•Current data model utilized•Positional Accuracy•Data completeness•Completeness of the Attribution•Percentage populated of metadata
10
Phase 1Assessment
Data Development ProcessData was developed from multiple sources including:• Existing geospatial data• Digital or hard copy surveys• Authoritative Databases• GPS data collection• Institutional knowledge of PMs and others
Development for each feature class included ensuring complete spatial data, attribution, and metadata
A project-wide quarterly data development schedule was implemented to ensure on-time completion of data development and for tracking purposes
11
Phase 2Data
Standardization
Data Development Cont.Data Tracker: DevelopmentWeekly Updates Required§ Applicable§ Data Status§ Fieldwork Required§ Spatial Data Complete§ Attribute Data Complete§ Metadata Complete§ QC Complete
12
Phase 2Data
Standardization
Authoritative DatabasesAuthoritative Databases (AD) were utilized to retrieve source data in addition to Base PM input◦ Air Program Information Management System (APIMS)◦ Enterprise Environmental, Safety, and Occupational Health Management Information System (EESOH-MIS◦ Environmental Resources Program Information Management System (ERPIMS)◦ Spill Incident Release Internet System (SIRIS)◦ Storage Tank Accounting and Reporting (STAR)◦ Water Enterprise Tracking (WET)
Delivered Authoritative Database Data Discrepancy reports to AFCEC for APIMS, EESOH-MIS, ERPIMS, SIRIS, STAR and WET
13
Phase 2Data
Standardization
Data Quality Control
14
Phase 3Quality Control
Process 1Analyst
Operations
Analyst Informal Review
Analyst Positional Accuracy Review
Process 2PM
Operation
PM Quality Control Review
Process 3TSC
OperationsTSC Initial
ReviewTSC Spatial
ReviewTSC
Attribute Review
TSC Metadata Review
Air Quality: Before & AfterThe AFCEC Environmental GIS Project has resulted in more complete datasets
15
Storage Tanks: Before & After
16
The AFCEC Environmental GIS Project has resulted in more complete datasets
Data Development AccomplishmentsData Development completed for 98 installations
Standardized 69 environmental feature classes and approximately 4,000 environmental layers AF wide
Over 2,000 GIS Support Requests completed
The Benefits:• Data Standardization allows for enterprise comparison, analysis, and planning• Allows Subject Matter Experts to identify enterprise trends and address non-compliance issues
• A more accurate picture of what is on the ground• Installation Development Plans
• Area Development Plans
• Floodplain Analysis
• NEPA Requirements
◦ Environmental Management Plans for all major media areas◦ AD improvement
17
Current Objectives1. Provide GIS support for data maintenance, mapping and analysis to Air Force installations across
the U.S., PACAF, and USAFE in order to maintain compliance of Air Force environmental management programs.
2. Technical assistance is provided from CSU/CEMML’s Fort Collins AFCEC Environmental GIS Technical Support Center (TSC) and Air Force AFCEC Environmental ISS/RSB locations.
18
Phase 4Data
Maintenance
Step 1Data
Review
Step 2Data
updates
Step 3Quality Control
Data MaintenanceRegularly Scheduled Updates◦ Data Layer Specifications (DLS) set the minimum update frequency◦ Update Frequency is set by program area and occurrence ranges from
quarterly to annual
As Needed Updates◦ Out of cycle updates can be performed as required between regularly
scheduled updates◦ Updates should align with the receipt of contract deliverables,
management plan updates, and other applicable program requirements
Authoritative Database updates are incorporated into regularly scheduled data maintenance◦ AD Exports are provided by AFCEC to align with the maintenance
schedule
Program Manager and Technical Support Center QC are still incorporated prior to the completion of data updates
19
ProgramArea
Update Frequency
Annual Bi-Annual Quarterly
AQ X
CR X
ISWM X X
HM/HW X
NR X
Restoration X
Tanks X
WQ X
GIS SupportCEMML provides general GIS assistance to ISS and base environmental staff to include:• Cartographic support• Management Plan Maps• Map books for performing inventories and site visits• Constraints maps showing areas of concern for planning
• Data collection and maintenance for non-MDS layers• Environmental GIS data call support • Enterprise-wide analysis for Programmatic Biologic Assessments and Installation
Development Plans
• General GIS technical assistance and training• Spatial analysis/spatial queries• Calculations to include distance, extraction by attributes or spatial location, and
interpolation from sampled point values
ISS and base level environmental program staff request support directly from the ISS-based CSU GIS analysts. The CSU TSC element provides reach-back support.
The AFCEC/CZCA-based CSU GIS Program Analyst provides GIS support to AFCEC/CZ with reach-back support provided by the CSU TSC element.
20
21
Cartographic Support - EIS Maps
22
Cartographic Support – Management Plan Maps
23
Cartographic Support – Survey/Inspection Maps
Map Books
Media Linked Maps
Spatial Analysis – 3D Visualization
24
Performed spatial analysis to determine the best locations to install fish habitat structures.
25
Spatial Analysis – 3D Visualization
26
Web Application – Floodplain Story Map
Lessons Learned◦ ADs discovered to be utilized to different extents depending on the installation◦ Project-wide data development schedule was determined to be necessary◦ Data model development was more involved than initially anticipated◦ Centralized environmental GIS data storage and access Integration with AF
GeoBase program◦ Air Force Environmental GIS data needs versus current SDSFIE version 3.1
implementation◦ Access to cultural resource data and other sensitive layers
27
GIS AccomplishmentsAccomplishments◦ Standardized 70 layers across 102 installations◦ Completed over 3,500 GIS Support requests to date◦ Delivered Authoritative Database Data Discrepancy reports for APIMS, EESOH-
MIS, ERPIMS, SIRIS, STAR and WET◦ Fully integrated with Air Force Geospatial Information Management System
(AFGIMS) with data hosted on the AFGIMS 1.0 Viewer◦ Responded to enterprise data calls including the annual DISDI data call◦ Developed and migrated to SDSFIE 3.1.1. AF Environmental data model
28
Next Steps• Continue to provide enterprise Data Maintenance
• Increase GIS Support through education of available products and services that support environmental compliance to Environmental, Planning, and beyond
• Continue to improve and expand on the development of national data sets to include floodplain, vegetation, and landcover.
• Continue to develop Toxics data for AF installations
• AFGIMS – Continue to develop new resources on the GeoPortal to include web applications and Story Maps
• SDSFIE – V 4.0 Air Force Adaptation – Environmental Data Sets development and implementation
• AFCEC SME coordination completed
• GeoBase review completed
• SDSFIE Validation completed
• Submitted to SDSFIE
• Awaiting SDSFIE approval allowing for FY21 schema and data migration
29
Resources & ContactsAFGIMS GeoPortal Environmental Dashboard:https://maps.af.mil/geoportal/apps/sites/#/environmental
AFGIMS Viewer: https://maps.af.mil
eDASH: https://cs2.eis.af.mil/sites/10621/GIS/
Shannon Voggesser [email protected]
Gwynn Ellis [email protected]
30