Skip to content

FIA Working Query Bank

⚠️ This file has been reorganized for better maintainability and AI-agent accessibility.

🚀 New Organized Structure

The FIA query collection has been restructured into a modular, category-based organization:

📁 Main Query Library

Browse the complete organized collection: - 🌳 Basic Tree Queries - Fundamental tree counting and enumeration - 🌲 Growth, Removal, and Mortality - Complex GRM analysis using TREE_GRM_* tables - 🌿 Biomass and Carbon - Species-specific biomass calculations - 🌳 Tree Count and Density - Species distribution and TPA analysis - 🏛️ Ratio Estimation - Advanced statistical estimation techniques - 📊 Volume Analysis - Merchantable timber volume calculations - 🗺️ Forest Area - Land use classification and area estimates

📚 Essential Resources

🎯 Benefits of New Structure

For AI Agents:

  • 🤖 Modular Navigation: Easy to find specific query types
  • 📖 Focused Documentation: Each category has targeted explanations
  • 🔍 Better Context: Queries grouped by analytical purpose
  • ⚡ Faster Access: No need to parse 875+ line files

For Developers:

  • 🔧 Maintainable: Individual files easier to update
  • 📊 Organized: Logical categorization by analysis type
  • ✅ Validated: Each query includes expected results and validation notes
  • 📈 Scalable: Easy to add new queries to appropriate categories

For Users:

  • 🎯 Targeted: Find exactly the type of analysis you need
  • 📚 Educational: Learn FIA methodology through organized examples
  • 🚀 Efficient: Quick access to relevant queries and documentation
  • 🔄 Consistent: Standardized format across all query categories

🌟 Key Features Maintained

  • ✅ EVALIDator Compatible: All queries match Oracle EVALIDator methodology
  • 🧪 Tested & Validated: Each query includes expected results
  • 📖 Well Documented: Comprehensive methodology notes and insights
  • 🔧 Maintainable: Simplified approaches where possible without sacrificing accuracy
  • 🎯 Practical: Real-world examples with actual EVALID values and results

📋 Quick Start

  1. Browse Categories: Visit ./queries/ to see all available query types
  2. Choose Your Analysis: Select the category that matches your needs
  3. Review Documentation: Each category has a README with methodology notes
  4. Use Query Templates: Copy and modify queries for your specific EVALIDs/states
  5. Validate Results: Compare with expected outputs and EVALIDator when possible

🔄 Migration Notes

For existing users of this file: - All original queries have been preserved and enhanced - Queries now include more comprehensive documentation - Expected results and validation notes are included - Simplified versions are provided where tested to be equivalent

For AI agents: