Ecology Explorers educational data: bruchid data from multiple school locations in the central Arizona-Phoenix area
Author(s):
- Ecology Explorers Program
Abstract:
The Sonoran Desert has one of the most diverse native plant and animal species of any desert in the world. Many trees are uniquely adapted to living here and they are part of food webs that include animals and insects also are adapted to desert living. Phoenix is an expanding urban area located within the Sonoran Desert.
One Sonoran Desert plant that has found its way into urban landscapes is the palo verde tree. In the desert, this tree supports a community of animals including bruchid beetles. These insects lay their eggs on palo verde seedpods and the larvae feed on the seeds.
The interactions between plants and animals can provide vital information on the health of an ecosystem. Ecologists are interested in determining whether the interactions between urban Palo Verde Trees and bruchid beetles is similar or different than their interactions in undisturbed Sonoran Desert communities.
You can provide important data by investigating the palo verde trees and bruchid beetle populations in your schoolyard.
Keywords:
Temporal Coverage:
1998-11-12 to 2003-12-31Geographic Coverage:
Geographic Description: Phoenix metropolitan area in Arizona, USA (needs better bounding coordinates)Bounding Coordinates:
Longitude:-112.373614 to -111.612936
Latitude:33.708829 to 33.298975
Contact:
Information Manager, Arizona State University,Global Institute of Sustainability,POB 875402,TEMPE
caplter.data@asu.edu
Methods used in producing this dataset: Show
Data Files (6) :
Tabular: 13_bruchid_pods_1.csv
Description: Seed and hole count per pod
Column | Description | Type | Units |
---|---|---|---|
tree_id | Unique letters and numbers assigned to specific trees. |
string | |
pod_id | Sequential unique whole numbers used to identify individual pods. |
string | |
sample_id | Sequential unique numbers used to identify samples. |
integer | |
hole_count | The number of holes found in the pods. |
integer | number |
seed_count | number of seeds in each pod. |
integer | number |
date_entered | Date the data was entered |
datetime | Format: MM/DD/YYYY |
Tabular: 13_bruchid_sample_1.csv
Description: Date and other information for each sampling event
Column | Description | Type | Units |
---|---|---|---|
sample_id | Sequential unique numbers used to identify samples. |
integer | |
site_id | Unique numbers and letters used to identify sites used in this study. |
string | |
school_id | Unique abbreviations used to identify schools participating in this study. |
string | |
site_type | Whether the site is urban or desert. |
string |
Enumeration:
|
sample_date | The date the sample was taken. |
datetime | Format: MM/DD/YYYY h:mm |
location | Description of the area the sample was taken from. |
string | |
observer | Name of the observer collecting samples. |
string | |
date_entered | Dates the data was entered. |
datetime | Format: MM/DD/YYYY |
class_id | unique numbers used to identify the school classes. |
integer | |
tree_type | Species of tree from which the samples were taken. |
string |
Enumeration:
|
new_date | No Metadata Provided: a date |
datetime | Format: MM/DD/YYYY h:mm |
Tabular: 13_sites_1.csv
Description: sites within a school where sampling takes place
Column | Description | Type | Units |
---|---|---|---|
site_id | Unique arbitrary ID letters and numbers to identify specific sites. |
string | |
school_id | Abbreviations identifying specific schools used in this study. |
string | |
sitename | The name of the sites corollating with the site ID. |
string | |
address | US street address of the sites used in this study. |
string | |
description | Discription of the sites used by observers working on this study. |
string | |
city | The cities within Phoenix and the metropolitan area in which the locations containing sites are located. |
string | |
zipcode | US zip code of the locations containing sites used in this study |
string | |
date_entered | The date the information was entered into the system. |
datetime | Format: MM/DD/YYYY |
location | The approximate location of the sites used in this study. |
string |
Tabular: 13_school_1.csv
Description: Address of school
Column | Description | Type | Units |
---|---|---|---|
school_id | Unique abbreviations assigned to the schools used in this study. |
string | |
school_name | Names of the schools used in this study. |
string | |
address | The US street addresses of the schools used in this study. |
string | |
zipcode | The US zip codes for the schools used in this study. |
string | |
city | Cities that the schools in this study are located within Phoenix and the metropolitan area. |
string | |
date_entered | The date the data was entered. |
datetime | Format: MM/DD/YYYY |
Tabular: 13_class_1.csv
Description: The class that did the investigation
Column | Description | Type | Units |
---|---|---|---|
class_id | Sequential unique whole numbers used to identify a specific school class. |
integer | |
class_name | The names of the classes involved in the study. |
string | |
grade | The grade levels of the classes doing the studies. |
string | |
date_entered | The date the data was entered. |
datetime | Format: MM/DD/YYYY |
teacher_id | Unique identification of the teachers running the surveys. |
string | |
school_id | Unique ID letters and numbers to identify specific schools used in this study. |
string |
Tabular: 13_teacher_1.csv
Description: The teacher who lead the investigation
Column | Description | Type | Units |
---|---|---|---|
teacher_id | Unique identification of the teachers leading the studies in thier class. |
string | |
The e-mail addresses of the teachers participating. |
string | ||
active | Whether the teachers are actively participating in the study in a particular year. |
bit |
Enumeration:
|
name | Names of the teachers participating. |
string | |
school_id | Unique identification of the schools participating in this study. |
string |