Database & Mapping

Database & Mapping Techniques for inventorying sites, tracking cleanup and redevelopment progress, and community engagement

Tuesday August 12th 8:00-12:00

Cynthia Annett, PhD KSU TAB and Research Associate Professor KSU and Eric Sheets, J.D. KSU TAB and Assistant General Manager of the Prairie Band Potawatomi Nation

Welcome and Overview

8:00-8:30 Introductions of session leaders and participants, discussion of data needs and interests of participants.

Database management


Discussion of the advantages of digital data collection in the field, file formats, how to move between platforms, standards for georeferenced data, strategies for creating effective and flexible databases for use with different tools. Introduction to the KSU TAB Brownfields Inventory Tool. Click here for session materials

Data sovereignty


An important aspect of tribal sovereignty is the control of intellectual property and data from environmental programs. We will discuss data sovereignty, providing examples of important information to include in data stewardship agreements with contractors, agencies, and other institutions and individuals involved in the collection, analysis and archiving of tribal environmental data. Click here for session materials

Forms to Sheets to My Maps

9:45 - 10:30

Hands-on development of digital forms for soliciting community input that can be easily added to spreadsheets and maps used for Brownfields inventories and other geospatial databases (GIS, etc.). Click here for session materials

My Maps

10:30 - 11:15

Hands-on development of map mash-ups using publicly available data in spreadsheet and map file (KML and SHP) formats from federal and state agency websites, adding data layers from our field inventories, existing tribal databases, and community input. We will learn how to edit these maps, add photos and video to placemarks, and embed maps on our websites. Click here for session materials

Mobile Data Collection

11:15 -11:45

Hands-on learning of techniques for using mobile devices for fieldwork and inputting the data from the field into online databases and digital maps without the need for transcription. Click here for session materials

Wrap up and sharing


Group discussion about the session and what the participants accomplished. Sharing of insights, examples, and best practices.