# Presentation: 693553

## FFI Query Builder / External Data Analysis

**FFI Query Builder / External Data Analysis**

-  Filter
-  Filter by protocol, method, macroplots
-  Filter by monitoring status, sample event dates (range)
-  Filter by species attributes (genus, life form, picklist)

-  Additional / Calculated Fields
-  Sample Event fields
-  Monitoring Status fields
-  Macroplot fields
-  Species fields
-  Calculate area and number of subsamples
-  Calculate dbh^2 for basal area calculations

## FFI Query Builder / External Data Analysis

-  Classify
-  Classify any numeric field
-  dbh classes
-  height classes

-  Grouping and Summary Calculations
-  Group by macroplot, sample event
-  Group by sample attributes, method attributes
-  Group by species attributes
-  Sum sample attributes, method attributes
-  Calculations
- Density, cover, frequency, basal area

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Filter

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Additional / Calculated fields

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Classify

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Classify

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Basal Area

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Basal Area

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Density

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Density

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Density

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Cover – Line Intercept

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Cover – Line Intercept

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Cover – Line Intercept

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Cover - Points

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Cover - Points

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Cover - Points

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Frequency

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Frequency

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Grouping and Summary Calculations: Frequency

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  Query any sampling method in FFI
-  Standard FFI methods
-  User generated methods

-  Calculations provided for:
-  Basal Area, Density, Cover, Frequency
-  Work on standard and user generated methods
-  Must provide required sample/method attributes

-  External Data Analysis
-  Export query results as CSV file
-  Import into FFI External Data Analysis or    	other statistical software
-  View analysis reports and graphs

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  External Data Analysis – Export as CSV

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  External Data Analysis – Save as Excel

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  External Data Analysis – Import Spreadsheet

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  External Data Analysis
-  Report

**FFI Query Builder / External Data Analysis**

## FFI Query Builder / External Data Analysis

-  External Data Analysis
-  Graph

**FFI Query Builder / External Data Analysis**

## On-line Support

_**FFI on FRAMES**_
- General information, training announcements, 	software, 	manuals, etc.
- http://frames.nbii.gov/ffi

_**Google Discussion Group**_
- http://groups.google.com/group/ffiemu

- For general technical support contact:
- Duncan Lutes
- (406) 329-4761
- dlutes@fs.fed.us

**On-line Support**