FFI Query Builder FFI Query Builder External Data
FFI Query Builder
FFI Query Builder / External Data Analysis • 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 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 • Filter
FFI Query Builder / External Data Analysis • Additional / Calculated fields
FFI Query Builder / External Data Analysis • Classify
FFI Query Builder / External Data Analysis • Classify
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Basal Area
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Basal Area
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Density
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Density
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Density
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Cover – Line Intercept
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Cover – Line Intercept
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Cover – Line Intercept
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Cover - Points
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Cover - Points
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Cover - Points
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Frequency
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Frequency
FFI Query Builder / External Data Analysis • Grouping and Summary Calculations: Frequency
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 statistical software • View analysis reports and graphs other
FFI Query Builder / External Data Analysis • External Data Analysis – Export as CSV
FFI Query Builder / External Data Analysis • External Data Analysis – Save as Excel
FFI Query Builder / External Data Analysis • External Data Analysis – Import Spreadsheet
FFI Query Builder / External Data Analysis • Report
FFI Query Builder / External Data Analysis • Graph
On-line Support FFI on FRAMES General information, training announcements, 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 software,
- Slides: 28