Online database access help file

Map features

The watershed map displays features such as roads, creeks, subwatershed boundaries, aerial photographs, contour lines, sample points, etc…. As the map is zoomed-in for more detail, features such as contour lines and aerial photographs will appear. Simple directional tools exist on four sides of the map: north, south, east, and west. Click on these buttons to move the view in that general direction. To quickly zoom-in and zoom-out of the area there is a weighted scale bar located in the left side of the map.

There are three radio button selectable options for quick navigation, these include:

1. Zoom in - Either single click on the map to zoom in one step at a time or click and drag a box in the area you want the map to zoom to.
2. Re-center - Click on the map and that point will become the center of the map view.
3. Sample point - Click on the sample point symbol and the map will zoom in to that sample point.

Viewing data

1. To view data either choose a sample point from the dropdown box and click “Submit” (the point will become highlighted) or select the radio “sample point” button and click on the sample point on the map.
2. Dates will appear in the View data tables for all dates the chemical and field information was collected.
3. Click on a date in either the chemical or field data tables.
4. Click the “View” button

Entering a new data point

1. Click the “Sign in” button
2. Enter your username and password
3. Select the radio “Create XY point” button
4. Use the feature location tool  to add new data point
5. X and Y coordinates will be generated and added to the data table on the right column for the new point
6. Enter the required fields to describe the site: master_site_id, and site_description.
7. Click “Add record”

Add new data to an existing sample data point

1. Choose the sample point you want to add new data
2. Click “Add new” button either under the chemical or field table
3. Enter the information into the form, use the “tab” button to enter and advance to the next field. Please note none of the site specific data information pertaining to the x and y coordinates, subwatershed name, site description, etc… can be changed in this view.
4. Verify data information entered is correct, click “Update Record”

Delete data at an existing data point

1. Choose the date of the information you want deleted and click “delete”.
2. You will be prompted to click yes or no to continue this action that can not be undone.

Edit existing data table

1. Choose the sample point you want to edit
2. Choose the date the data was collected that you want to edit
3. Click “Edit”
4. Enter the new data you want to edit.
5. Click “Update Record”

Download databases

Under the download database title there are three data download options, click on either the “Chemical EXCEL Download”, “Field EXCEL Download”, or ACCESS download. The ACCESS download will contain both the chemical and field data in separate tables.

Print Map

Create the map of interest to the level of detail you want, click the print button (located beneath the zoom scale bar). Once the map print view is created you can add a title. The legend is automatically generated and displayed next to the map. Change the printer setup to print the map in landscape to maximize the view.

Technical assistance

Direct all inquires to Jen Bowman at ILGARD’s Environmental Management Program, bowmanj2@ohio.edu or call 740-597-3101