Project Homeland – National Geospatial-Intelligence Agency (NGA)
NGA and ESRI brought AppGeo onto the Project Homeland team for Homeland Security Infrastructure Program (HSIP) data modeling and ETL design and support work.  AppGeo contributed to revising HSIP by clarifying standard feature naming, common elements and subtypes, defining more data types and domains for attributes, and adding more feature specific attributes.  In addition, AppGeo helped define an overall framework for HSIP data completeness and quality metrics, at both feature and attribute levels.

National Capital Region (NCR) Pilot Project - USACE CADD/GIS Technology Center and National Geospatial-Intelligence Agency
Project goals were: (1) To refine the HSIP schema definition and extend SDSFIE (Spatial Data Standard for Facilities, Infrastructure and Environment) to comply with HSIP, (2) To develop a set of software tools and HSIP GIS Data Warehousing processes, and (3) To test these new schemas, tools, and processes with real data for the NCR. AppGeo participated in:

• Developing a schema for a subset of HSIP and implementing a personal Geodatabase
• Conceptualizing HSIP data warehousing scenarios and ETL procedures
• Developing tools for schema-to-schema mapping and multi-source metadata tracking
• Populating target HSIP schema with actual data from NCR
• Documenting lessons-learned and recommendations

Boston Preparedness Pilot Project - NOAA
The U. S. Dept. of Commerce, National Oceanic & Atmospheric Administration (NOAA), National Ocean Service sponsored a project to create comprehensive, high quality geospatial databases of critical infrastructure.  AppGeo acquired, reviewed, selected, integrated, documented, and developed geospatial data layers for an area encompassing 103 municipalities in the greater Boston region.  AppGeo interviewed first responders to better understand operational and data quality requirements. The final report provided recommendations for spatial data accuracy, cost effectiveness, use of existing data, and coordination requirements for distributed data collection and integration. The Pilot Project supported federal initiatives to engage state and local agencies to build an integrated and essential geospatial database in support of homeland defense and emergency preparedness for priority Urban Areas around the nation.

Geographic Army Reserve Information System (GARIS) – 94th Regional Readiness Command
AppGeo has provided support for application and tool development for the Geographic Army Reserve Information System since 1994. Initial work focused on environmental database integration and tools for the desktop. The resulting system supports the integration and management of facilities and environmental data and reporting for approximately 40 Army Reserve sites across the 6 New England states. Current work involves creating a secure Web-based system for facility data visualization, with regional, site, and room plan levels of interactive display.