Badger is an open source data analysis application for EPA Analysts developed in C# using WPF and released under the MIT license

Features

• Mutliple data providers.
• Charting and reporting.
• Internal web browser,Baby, with queries optimized for searching .gov domains.
• Pre-defined schema for moret than 100 environmental data models.
• Editors for SQLite, SQL Compact Edition, MS Access, SQL Server Express.
• Excel-ish UI on top of a real databases.
• Mapping for congressional earmark reporting and montioring of polluction sites.
• Finanical data bound to environmental programs and statutory authority.
• Ad-hoc calculations.
• Add agency/region/division-specific branding.
• The winforms version of Badger is Sherpa

Providers

• SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
• SQL CE is a discontinued but still useful relational database produced by Microsoft for applications that run on mobile devices and desktops.
• SQL Server Express Edition is a scaled down, free edition of SQL Server, which includes the core database engine.
• MS Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. more here

System requirements

• You need VC++ 2019 Runtime 32-bit and 64-bit versions

• You will need .NET 6.

• You need to install the version of VC++ Runtime that Baby Browser needs. Since we are using CefSharp 106, according to this we need the above versions

Documentation

• User Guide
• Compilation Guide
• Configuration Guide
• Distribution Guide

Code

• Badger uses CefSharp 106 for Baby Browser and is built on NET 6
• Badger supports AnyCPU as well as x86/x64 specific builds
• Controls - main UI layer and associated controls and related functionality.
• Enumerations - various enumerations used for budgetary accounting.
• Extensions- useful extension methods for budget analysis by type.
• Clients - other tools used and available.
• Ninja - models used in EPA budget data analysis.
• IO - input output classes used for networking and the file systemm.
• Static - static types used in the analysis of environmental budget data.
• Interfaces - abstractions used in the analysis of environmental budget data.
• bin - Binaries are included in the bin folder due to the complex Baby setup required. Don't empty this folder.
• bin/storage - HTML and JS required for downloads manager and custom error pages

Data Tools

• Datagrids

• Pivot Tables

• Plotting

The Interface.

• Excel-ish UI over a real database.

• Import and export spreadsheet data.

Maps.

• Congressional earmark reporting

• Monitor pollution site remediation costs

Baby

• Stand-alone web browser built with the Chromium Embedded Framework

• Ad-hoc searches with customized pop-up input.

• Search across multiple .gov domains

Budget Calculations

• Ad-hoc calculations directly on bound data.

• Quick access to the full functionality of the widows 10 calculator.

Federal Calendar

• Calculation based on the federal fiscal year beginning Oct 1.

• Compatible with full-time equivalency metrics.

• Ad-hoc analysis of variable periods of availability.

Orca

• Ad-hoc web development

• Network communications

• HTML5, CSS, and Javascript

Environmental Program Analysis

• Definitions and statutory authorities

• Legal information bound directly to financial data

Visualization Tools

• 3D Charting

• Pivot Charts

• Plotting & Graphs

Document Viewer

• Library of legal documentation used in evnironmental data analysis.

• Interact with, view and access PDFs outside the application

Editors

• SQLite

• MS Access

• SQL Compact Edition

• SQL Server Express