Tribal Natural Resources Integrated Data Environment EPA Information Exchange Node Client Overview 26 Apr 2007

1. Shoshone Bannock Tribes Fort Hall Reservation, Idaho Bill Farr, Contractor, Shoshone Bannock Tribes T: 801-458-5900, bfarr@topvue.com John Kutch, Treasurer, Shoshone Bannock Tribes T: 208-478-3812, jkutch@shoshonebannocktribes.com Elese Teton, Manager, Water Resources, Shoshone Bannock Tribes T: 208-238-9375, eteton@shoshonebannocktribes.com Tribal Natural Resources Integrated Data Environment EPA Information Exchange Node Client Overview 26 Apr 2007 Integrated Data Environments for Natural Resource Management © 2007 Shoshone Bannock Tribes, © 2007 ResourceVue, LLC, All Rights reserved

2. Background: Why a Natural Resource IDE • Need for Compliance with Tribal Water Code • Water sources, Permitting, Tracking • Over-Appropriation, Degradation, Contamination • Pollutants are very visible Air Land Assets Water Assets GIS Ag • A system was needed that integrates data to…. • ‘Baseline’ Tribal natural resource data in common repository • Water, Land, Air, Agricultural, Equipment, GIS • Better Steward of Tribal Natural Resources • Improve immediacy with managing environmental issues • Support Self-Determination

3. etc… Fisheries Departmental Unique Data Tracking Land Use Water Resources Departmental Data Tracking Air Off-the-Shelf Tribal Natural Resources Centralized Integrated Data Environment System Land Assets Water Assets GIS Ag Tribal Business Applications Tribal Common Processes Contract, Grant Management Program Management Finance etc… ResourceVue:Integrated Natural Resource Data Mgt System EPA Data Exchange Node Clients

4. Benefits of ResourceVue • Immediate integrated database capability to manage Tribal Water, Land/Allotment, Agricultural, GIS files, ( etc.) data centralized and secure • Immediate use of off-the-shelf EPA Exchange Network capability for: • WQX (In 07) • AQS (In 07) • Others to be added as off-the-shelf in 2007, 2008 • Super-node Capability to aggregate (and separate) data for multiple Tribes • Business Management capability: Program Mgt, Contract/Grant Mgt, Cross-grant time entry/tracking

5. Data Gathering and Architecting Loose Data Logical Relationships Integrated Data Management Solid Waste Air Quality Water Land Use - ARM Water Resources Tribal Environmental Integrated Data Environment Land Use Import Governance and Program Status Tribal Contract, Grant Management Air Per Business Processes Tribal Water, Land Asset Management S e a r c h M e t r i c s XML Tagging EPA Data Exchange Formats Cross- Program Process Integration Other System Interfaces…

6. Sources: Wells, Laterals, Canals, Aquifer, etc • Points of Diversion, Equipment • Track ‘Parent’ sources • Well Identification and Inspection • Water Monitoring, and Quality Samples • Permits and Licenses • Surface Water Permit • Ground Water Permit • Transfer Permit • Storage Permit • Instream Flow Permit Discharge License Stream Zone Alteration License Well Construction License Base-lining Natural Resource ‘Assets’ • Water and Land relationships at the core of Tribal assets • ResourceVue brings the core data relationships together… • with integrated business management tools • Identify Allotments, Ownership • Land Leases • Water permits • Range Mgt Program • Agriculture Resource Mgt Program • Farms • Crop Yield Data • CRP, CCRP • AECF Payments • Livestock • Permits • Burn • Construction Land Assets Water Assets GIS File Vault

7. Program Milestones Issues Calendars, Meetings and Actions Metrics Managing the ‘Business’ and the Assets • Decision Support and Programmatic Execution Tool Set Program Management, Collaboration Air Land Assets Water Assets GIS Ag Contract and Grant Execution Schedules Data Exchange Funding Work Queues Contract / Grants Deliverables Time Entry

8. Dept. of Defense Joint Programs Anti-Terror Planning, Program Mgt, and Data Security Managing the IT Infrastructure • Guiding Principles of ResourceVue system: • COTS (commercial off the shelf software) • SOA (services driven architecture) • Adaptable data model; meta data on-the-fly • Adaptable UI, style sheets • Modular applications • Data aggregator: by site, by org, by Tribe…. • Post 9-11 security concepts • XML schema components library and ‘tagger’ • XML-based business rules Re-usable COTS software architecture to lower costs of managing EN activities Goal: Ninety-day Apps

9. Baseline of Water Assets • Surface and Ground Water Sources • Monitoring Stations

10. Land Tracking – Allotments & GIS

11. GIS, Document Vaulting • Centralize all GIS files, Documents, Briefings, data sets, etc

12. Rules Permit End Date Lease End Date Data Integration…..Process Integration • Intra- Department Process Integration Example • Better decision making…. Water Resource Dept. Land Use Dept. Water Permit Lease Permit Mgt Allotment POD Equipment Lease Mgt If overlap, notify someone

13. Permit to Land Lease Example Business rules will keep inter-departmental Managers knowledgeable of dependencies

14. ResourceVue Node Client Flow • Sample Process for Managing Water Quality Data Exchange 400 410 Set Standards Receive Data Set EPA D A T A S T O R E P L A N N I N G 200 210 Water Quality Engineers Manage Monitoring Stations Gather Water Quality Samples 100 110 120 130 Water Resources Dept Manage Baseline Data of Water Assets Invoke Node Client to Push Data Set to EPA Import Data Into Central Repository Prepare EPA Data Exchange Format 300 Review and Assess Water Quality Data Reviewers

15. Baseline of Water Assets • Surface and Ground Water Sources • Monitoring Stations Manage Baseline Data of Water Assets Manage Monitoring Stations

16. Water Quality Sample Import • Water Quality Data is formatted into files • Imported into central database…to be XML tagged Import Data Into Central Repository Water Quality Sample from Monitoring Station Water Quality Data Centralized Data Import

17. Sample XMLGeneration (WQX) Data Exchange XML Generator • Data is ‘Tagged’ into XML format - WQX Prepare EPA Data Exchange Format

18. ResourveVue • Web Services • Authenticate • Submit • Get Status Client Partner Error Trapping Push Data via EPA Node Client • The ResourceVue Node Client connects via Web services to EPA Network Node Invoke Node Client to Push Data Set to EPA

19. Manage History of EPA Transactions • Track each node client data submission history • EPA token ID, XML file (WQX)

20. Data Security Management • Based on DoD standards

21. Super-node Capability Solid Waste Air Quality Land Use - ARM Cross- Program Process Integration Water Resources Tribal EPA Super-node Integrated Data Environment Governance and Program Status Tribal Contract, Grant Management Tribal Water, Land Asset Management S e a r c h M e t r i c s EN XML Data Transmission EPA Data Exchange Formats • Reusable: • XML schema components library • XML-based business rules Tribe 1 Tribe ‘n’ … Tribe 2

22. EPA Data Exchange • Generic Process for Managing Data Exchange 400 410 Set Standards Receive Data Set EPA 200 210 Department Workers Manage EPA EN Data Gather Data Samples 100 110 120 130 Department Director Staff Manage Overall Baseline Data Invoke Node Client to Push Data Set to EPA Import Data Into Central Repository Prepare EPA Data Exchange Format 300 Reviewers Review and Assess Data

23. Status of Node Clients • Current Shoshone-Bannock Exchange Network Grants: • Water Quality: STORET….WQX Due end of 2007 • Ready to test node client for WQX with EPA • Air Quality System: AQS 2007, although due in 2008 • Awarded Oct 06, in beginning phase of development • Not Yet Funded: • RCRAinfo • COMERR • Other….

24. Other Future Initiatives • Environmental Performance Management • Self Certification with Balanced Scorecards • Geospatial Baselining Measures Trends

25. etc… Fisheries Departmental Unique Data Tracking Land Use Water Resources Departmental Data Tracking Air Off-the-Shelf Tribal Natural Resources Integrated Data Environment System Land Assets Water Assets GIS Ag Tribal Business Applications Tribal Common Processes Contract, Grant Management Program Management Finance etc… Summary: Integrated Tribal Data • ResourceVue: Off the shelf Tribal Data Management EPA Data Exchange Node Clients

26. Summary • Shoshone Bannock suffers from Fortune-500 water pollutants • Node Clients to facilitate visibility to problem for resolution Water Quality Samples Shows Pollutants

27. ResourceVue™ Water Tracking Module Overview: WaterVue

28. ResourceVue: Tribal Departmental Data Tracking • Central Database for Tribal Department Natural Resource Data • Browser-based, Oracle/SQL server, Web services, XML-soap

29. WaterVue Module • Tracks Ground, Surface Water Sources, Permits, EN Node-client, EPA project time tracking • The File Cabinet is a customizable menu that provides access to system functionality • Applications - provides access to different Tribe applications available – • Can extend it to custom tribal apps • Document Search – provides instant access to document search functionality • Menu – links grouped into folders that provide direct access to specific pages – Meeting Search, Action Insert, etc.

30. Water Use Permitting Details • Surface Water Permit • Place of Use, Lease number • Water use details: Purpose, Amount, Dates • Water Management: Monitoring, Distribution Method, Irrigation Method • Related Allotments • Ground Water Permit • Place of Use, Lease number • Water use details: Purpose, Amount, Dates • Ground Water Development: Well info, Nearest source of water • Related Allotments

31. Transfer, Storage, Instream Permitting • Transfer Permit • Place of Use, Lease number • Applicant Information; Existing permits? • Proposed Water use details: Purpose, Amount, Dates • Proposed Water Management: Monitoring, Distribution Method, Irrigation Method • Related Allotments • Storage Permit • Place of Use, Lease number • Applicant Information; Existing permits? • Storage location • Storage Description • Water use details: Purpose, Amount, Dates • Related Allotments • Instream Flow Permit • Water use description • Legal description • Approvals and Recommendations

32. Permitting Rules Example: Routing Review Launch • When A * Permit Application is updated. • If * Permit Application is updated with a status of rejected.ThenA routing will launch based on a template Permit Status = Rejected Review Status Start Routing Permit Update End

33. Licenses Track and Generate Licenses:

34. Gage Sites Import and Display Gaging data Filter by date range

35. Equipment Track Equipment and Serial Numbers – Data Loggers etc.

36. Allotments Track Allotments (GIS ID, Legal Description, etc.) Interact with IMS directly from a selected allotment Track Land Ownership and Owner Change History (under construction..)

37. Leases Track Lease data: - Term - Tenant - Acres - Etc. Track relationships -Allotments -Permits -Etc. Business rules for expiration notification, term calculation, etc.

38. Lease Expiration Business Rules If Status not equal to ‘Notified’ or ‘Expired’ and 30 days until expiration 30 Day Lease Expiration Notification Lease status set to ‘Notified’ Administrator Notified Via Email Review Status & Exp. Date Daily lease data query If Status equal ‘Notified’, and expiration date is past due End Lease Expiration Notification Lease status set to ‘Expired’ Administrator Notified Via Email

39. ResourceVue™ Other Modules • WaterVue™: Ground, Surface sources, Water Quality, Permitting, GIS, WQX • LandVue™: Allotments, Leases, and related features, GIS, FRS • AirVue™: Air Quality data tracking, AQS • TribeVue™: Tribal Integrated Business Environment • Program Mgt • Contract / Grant Mgt • Time tracking and Invoicing • Workflow • Action Items • Calendars