Tribal Lands Forum – Oneida, WI
September 8, 2011 1
Information Management Systems
Planning for growth, development, and
environmental stewardship
Oneida Reservation is
about 65,400 acres
(approximately 100 square
miles)
Tribe currently owns
approximately 37% of the
land base
16,000 members, 6200
tribal members live on or
near the Reservation
(2006)
Multi-jurisdictional
issues-Counties, Cities, Villages,
and Towns within the
Reservation
Tribal Lands Forum – Oneida, WI
September 8, 2011 3
Oneida Facts
•Oneida employs approximately 2,800
people (second largest employer in
Northeastern Wisconsin)
•156 commercial leases including
Thornberry Creek at Oneida (golf course)
Walmart, Home Depot, Sam’s Club and
other commercial businesses.
•Main Casino & Bingo, Mason Street
Casino, and five “One-Stop” gas stations.
•The Oneida Nation supports surrounding
communities with sponsorships that allow
the Oneida Nation to connect to worthy
causes in the area.
Purpose
Define the need and use for an
“Information
Management System” (IMS)
.
Creating and implementing an IMS.
Using the IMS for decision making.
Tracking results with an IMS.
Selecting a site for environmental cleanup
Tribal Lands Forum – Oneida, WI
September 8, 2011 5
Needs Analysis
Define your “business” needs.
Who will use this information?
What you will use this information for?
Why will you use this information?
Identify current and future data sets.
PROJECT MANAGER SYLVIA CORNELIUS PROJECT MANAGER MICHAEL TROGE STUDENT INTERNS TRAVIS DESSART KYLE MOSENG PROJECT MANAGER STEVE LINSKENS ECO-SERVICES MANAGER MICHAEL FINNEY ONEIDA ENVIRONMENTAL, HEALTH & SAFETY DIVISION
LBDC OFFICE
7332 WATER CIRCLE PLACE ONEIDA, WI 54155 OFFICE: (920) 869-1600 FAX: (920) 869-1610 CONSERVATION OFFICE N8047 COUNTY ROAD U ONEIDA, WI 54155 OFFICE: (920) 869-1450 FAX: (920) 869-2743
ENVIRONMENTAL, HEALTH & SAFETY DIVISION DIRECTOR
PATRICK J. PELKY
HEALTH & INDUSTRIAL SERVICES OFFICE MANAGER BRENDA DOXTATOR ENVIRONMENTAL QUALITY SAFETY COORDINATOR DAN KING ENVIRONMENTAL SPECIALIST VICTORIA FLOWERS ENVIRONMENTAL SUPERVISOR LISA MIOTKE ENVIRONMENTAL COMPLIANCE INSPECTOR SHAWN SURI ENVIRONMENTAL SPECIALIST BILL KOONZ WATER RESOURCE SPECIALIST JASON SPIEGEL ADMINISTRATIVE ASSISTANT III INEZ DOMMER
ENVIRONMENTAL, HEALTH & SAFETY DIVISION
ENVIRONMENTAL SPECIALIST VACANT NATURAL RESOURCES TECH II LOUIS MEHOJAH FORESTER/ OCC PROGRAM MANAGER DAN BROOKS WARDEN HARVEY KOSOWSKI SENIOR WARDEN TERRY METOXEN NATURAL RESOURCES TECH II LLOYD NINHAM NATURAL RESOURCES TECH I SCOTT KING NATURAL RESOURCES TECH LEADER ROD HILL NATURAL RESOURCES DIRECTOR SHAD WEBSTER ENVIRONMENTAL HEALTH SUPERVISOR JENNIFER FALCK ENVIRONMENTAL SPECIALIST POLLUTION / RECYCLING AMY SPEARS INDUSTRIAL HYGIENIST ALBERT BAIRD WETLAND PROGRAM COORDINATOR ANTHONY KUCHMA PARKS SUPERVISOR KEVIN COTTRELL PARKS WORKERS II JARED SKENANDORE TODD HILL
SURVEY & FIELD TECHNICIAN WES JOHNSON G\EHSDIVISION\Visio\2011\EHSDIVORGCHARTFY2011 INJURY PREVENTION COORDINATOR JENNIFER JORDAN WATER RESOURCES SUPERVISOR JIM SNITGEN
WELLS & SEPTIC PROJECT MANAGER
DENNIS JOHNSON
ADMINISTRATIVE ASSISTANT III
KATHERINE JORDAN ADMINISTRATIVE ASSISTANT III JACY RASMUSSEN PUBLIC HEALTH SANITARIAN TRAINEE VANESSA MILLER FIELD TECHNICIAN LTE JON HABECK
ONEIDA POLICE DEPT. INDIRECT SERVICES REPORT ENVIRONMENTAL AREA MANAGER JEFF MEARS FY2011 Updated 6/17/2011 STUDENT INTERN MARGARET STEVENS
Tribal Lands Forum – Oneida, WI
September 8, 2011 7
Visualize Relationships
Original Parcel ID Grantor (Aka Site Name)
Address TRS Acres Leasee/Operator Funding Source Reported Elements Production Type Acre in Production Projected Yield Nutrient Management Plan Y/N
Elements of Nutrient Management Plan for
Reporting Preaquisition Level 1(ER)
Environmental Record Review Field Survey (ER) Land Use History Question(ER)
Current Land Use-Zoning Staff Assigned Oneida BF database EPA Records WDNR Database Tank Database Level II Include into Oneida BF Database Zoning
LUTU Process I/II Uses Info from all Databases including
Zoning
Current Land Use Project Site Y/N Prime Farmland Y/N
Acres for Use Ag. Production Y/N
CRP Y/N Permits Y/N Other Factors
Determine Use LUTU Design Will State Use
Permit Types Elements of Permits Restoration Project Elements of Funding Elements of Permits Water Quality Rank
Permits Y/N Restorative Efforts Y/N Wetland Determination Description- Rank Permit Elements Funding Reporting Elements MnRAM
Parcel ID and Identifiers are central & common to all databases (normalization). Any of the independent databases can be queried via parcel where activity occurs.
Date Acquired Fee Status Original Allottee LUTU Design Zoning Cultural Forestry Inventory Hazard Trees Reforestation Parks Recreation Hunting
Drinking Water Wells Indoor Air Quality
Demos Recycling Food Permits/Sanitation
Outdoor Air Quality Industrial Health & Safety
Trust Approval Date Oneida Parcel # LUTU Designation
Taxing Authority Tax Amount Trust Activities Y/N Trust Process Start Trust Process End NEPA Review BIA CE IHS CE
EA
No Link EQ
No REC - Proceed w/Purchase
DOLM ECO Conservation Elements of CE Elements of CE EIS FONSI Info from EQ, ECO Cultura l, Cons , Zoning In fo F rom LU TU2 Info for Link for LUTU
Link for LUTU
IH S Info for Trust Fee In fo f ro m L U T U 1 Yes Yes N o From NRCS To L U TU Water Team No Yes Final LUTU To Parcel via LC To LUTU To DB REC No Action Engineered Controls
Deed Notification F iled with DOLM-Eleme nts of Noted Re cord on Deed To LUTU To LUT U Zoning g/mf/quality/vflowers/parcelVisio
Creating an Information Management
System
Establish a “fixed” focal point for all information
that is common to all data-sets (normalizing
factor).
Use small pieces that can be relationally “tied”.
Start with small datasets.
Identify “database” requirements and
supporting tools (ie. Word, Excel, Powerpoint).
Become familiar with industry standards and
Tribal Lands Forum – Oneida, WI
September 8, 2011 9
Create an Information Management
System with the end in mind
Example Site (Joe’s Junkyard)
Estimated 50 year history.
Scrap metal, junk vehicles, vehicle parts, tires, leaking
drums and containers, oil filters, gas tanks, batteries,
white goods, etc.
Soil staining and oil odor.
Debris covers 11 acres of a 28 acres parcel.
Owner is scraping materials from the property.
Leased Trust property.
Three homes, with small children surround the property.
Two abandoned drinking water wells on the property.
One active well serving the three homes on the property.
High levels of arsenic and lead in soil.
Tribal Lands Forum – Oneida, WI
September 8, 2011 11
Example (continued)
Our example has key pieces of information that can be
used to create relationships with other programs
Property
Ownership
Affected
Population
Environmental
Impact
Health
Risks
Location
Nearby homes
Tribal Trust
with a leasee
Families with
small children
Groundwater &
soil
contamination
Drinking water well
& soil contaminant
exposure
Tribal Lands Forum – Oneida, WI
Tribal Lands Forum – Oneida, WI
Conclusion
Deciding on data collection, storage, retrieval
and format is an important step for all
programs.
Analyzing program functions, relationships
and customers is crucial to collecting good
data.
Creating relationships to other programs and
Tribal Lands Forum – Oneida, WI
September 8, 2011 17
Thank you!
Presented by:
Victoria Flowers, Environmental Specialist –
Brownfields
Oneida Tribe of Indians of Wisconsin
P.O. Box 365
Oneida, WI 54155
Phone: (920)496-5328