# Presentation: 324688

## USDA Geospatial Data Warehouse

**USDA Geospatial Data Warehouse**

**NCGC**
**Data Center**
**15 TB ****Online Data**

***Bi-directional Data***
***Replication and Failover***
***for Business Continuity***

**Data Themes:**
- NAIP
- MDOQ
- CLU
- Soils (SSURGO)
- Hydrography
- Geopolitical
- Transportation
- Elevation
- TeleAtlas
- DRG

**NRCS**** at Fort Collins, CO**
**Geospatial Data Mart in **
**Web Farm**

**APFO**
** ****Data Center**
**15 TB ****Online Data**

**FSA**** ****at Kansas City, MO**
**Geospatial Data Mart in**
**Web Farm**

**RD**** at**** ****St. Louis, MO**
**Geospatial Data Mart in**
**Web Farm**

**Aerial Photography Field Office**
**Salt Lake City, UT**

**National Cartography and Geospatial Center**
**Fort Worth, TX**

**Field Service Centers**

**Ag Users/Partners**

**Internet**

##     Field Service Center GISGDW  Architecture

**Internet**

**Web **
**Farms**

**Data**
**Centers**

**Ft Collins**

**Ft Worth/NCGC**

**Salt Lake City/APFO**

**Kansas City**

**St Louis**

**Replication**

## GDW and NAIP Delivery

- Near Line Component
- Tape silo
- Archive
- On-line Component
- Arc SDE Database
- Supports web service
- 3. Delivery Component
- APFOBD
- Geospatial Data Gateway
- Data Provisioning System
- WMS image streaming

## NAIP Delivery Two Products

- Compressed County Mosaics
- Full Resolution Quarter Quads

## NAIP Delivery 

- Compressed County Mosaics

- Optimized for local use
- -MrSID MG3 format
-    -compressed
-    -performs well
-        image pyramid
- “Interim Release”
- Before QA
_**30 days after acquisition**_
- “Final Release”
- -Can contain/represent rework

## NAIP Delivery

- Quarter Quadrangles

- “Raw Data”, “Basic Building Blocks”
-     -non-proprietary format (GeoTIFF)
-     -quarter quad  unit corresponds
-           -single acquisition date
-              -metadata reference

## Annual NAIP Timeline (2004)

- Image Acquisition

**Annual NAIP Timeline (2004)**

- June

- July

- Aug

- Sept

- Oct

- Nov

- Dec

- Jan

- Feb

- Mar

- April

- May

- May

- “Interim” Compressed
- County Mosaic

- Cost Share
-  Partners

- Full Resolution
- Quarter quads

- QA

- Cost Share
-  Partners

- Project
- Close out

## Annual NAIP Timeline (2005-06)

- Image Acquisition

**Annual NAIP Timeline (2005-06)**

- June

- July

- Aug

- Sept

- Oct

- Nov

- Dec

- Jan

- Feb

- Mar

- April

- May

- May

- “Interim” Compressed
- County Mosaic

- Cost Share
-  Partners

- Full Resolution
- Quarter quads

- QA

- Cost Share
-  Partners

- Project
- Close Out

## NAIPProduction Process

-  Acquisition

## NAIPProduction Process

-  Acquisition

- Aero
- Triangulation

## NAIPProduction Process

-  Acquisition

- Aero
- Triangulation

- Ortho
- Production

## NAIPProduction Process

-  Acquisition

- Compressed
- County Mosaics

- Aero
- Triangulation

- Ortho
- Production

## Annual NAIP Timeline (2005-06)

- Image Acquisition

**Annual NAIP Timeline (2005-06)**

- June

- July

- Aug

- Sept

- Oct

- Nov

- Dec

- Jan

- Feb

- Mar

- April

- May

- May

- “Interim” Compressed
- County Mosaic

- Cost Share
-  Partners

- Full Resolution
- Quarter quads

- QA

- Cost Share
-  Partners

- Project
- Close Out