Skip to Content
Report an accessibility problem

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-31

Geographic 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:
  • desert: desert
  • urban: urban
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:
  • blue: blue palo verde
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
email 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:
  • 0: false
  • 1: true
name Names of the teachers participating.
string
school_id Unique identification of the schools participating in this study.
string

Download EML Metadata for this data package