Skip to Content
Report an accessibility problem

Survey 200 long term study of multiple sites in central Arizona-Phoenix

Publication date: 2005

Author(s):

  • Nancy Grimm, Global Institute of Sustainability, Arizona State University
  • Diane Hope, Global Institute of Sustainability, Arizona State University
  • Corinna Gries, Global Institute of Sustainability, Arizona State University
  • Chris Martin
  • Elizabeth Burns, School of Geographical Sciences, Arizona State University

Abstract:

The aim of the 200 survey is to quantify vegetation and built structure across the CAP LTER study area, as well as to characterize other essential ecological parameters (soil physical and chemical properties, microbial diversity, litter decomposition rates) and survey insects, birds and human activity. In addition to collecting these basic data on the structure, key biotic variables and human activity for the LTER project as a whole. This is a compilation of several protocols for the survey 200 including some instructions for procedure on the plot


Keywords:

Land-Use, Land-Cover and Land Architecture, Climate, Ecosystems and People, water dynamics in a desert city, Biogeochemical Patterns, Processes, and Human Outcomes, human decisions and biodiversity, survey 200, primary production, population studies, movement of organic matter, movement of inorganic matter, disturbance patterns sonoran desert, phoenix, urban, metropolitan area, land architecture, water dynamics in a desert city, Biogeochemical Patterns, Processes, and Human Outcomes, caplter core monitoring, core monitoring, human decisions and biodiversity, informatics, modeling, Climate, Ecosystems and People, long term monitoring, survey 200, education and outreach, knowledge transfer, long term experiments, Land-Use, Land-Cover and Land Architecture land use, plants, species, measurements, pollen, soil, surface elevation table, trees, cores, grasses caplter, central arizona phoenix longterm ecological research, arizona, caplter created, az, cap, arid land

Temporal Coverage:

1999-02-01 to 2010-06-21

Geographic Coverage:

Geographic Description: Phoenix metropolitan area in Arizona, USA
Bounding Coordinates:
Longitude:-112.794316 to -111.566698
Latitude:33.838010 to 33.198342

Contact:

Information Manager, 
Global Institute of Sustainability,Arizona State University,POB 875402,Tempe
 caplter.data@asu.edu

Methods used in producing this dataset: Show


Data Files (47) :

Tabular: 27_annuals_1_2010.csv

Description: Annual plants for the 2010 survery period
Temporal Coverage: 2010-01-01 to 2010-06-21

Column Description Type Units
site_id Unique letters and numbers used to identify the sites used in this study.
string
samp_date The date the sample was observed.
datetime Format: MM/DD/YYYY
scientific_name Scientific name
string

Tabular: 27_arthropods_taxonlist_1.csv

Description: Arthropod Taxonlist
Temporal Coverage: 1999-02-01 to 2010-06-21

Column Description Type Units
taxon Abbreviations of taxon for ID
string
taxon_id Arthropod Taxon Identification Number
integer
arth_Class Taxon Class
string
arth_order Taxon Order
string
arth_family Taxon family
string
arth_genus Taxon genus
string
old_name Taxon Name used earlier
string
display_name Taxon Name to be displayed in the input application (lowest available taxon rank for record)
string

Tabular: 27_buildings_1.csv

Description: Building Data
Temporal Coverage: 2010-01-01 to 2010-06-21

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Numbers and letters used to identify unique sites.
string
building_id internally used ID
integer
building_use Buliding Use
string
height_distance Distance from observer to base of the building
float meter
height_degree_up Degree from the observer to the top of the building
float degree
height_degree_down Degree from the base of the building to the observer
float degree
height Actual height of the building
float dimensionless
street_address Street Address
string

Tabular: 27_cacti_succ_1_2010.csv

Description: Cacti and Succulents
Temporal Coverage: 2010-01-01 to 2010-06-21

Column Description Type Units
cacti_id Identification number for the table records found
integer
survey_id Identification number for the sampling_event
integer
plant_id Identification number for the plants found
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Numbers and letters used to identify the different sites used in this study
string
scientific_name scientific name of the species
string
height Measured height of the plant
float
height_distance Measured distance between the base of the plant and the observer holding the clinometer
float meter
height_degree_down clinometer degree from the observer to the base of the plant
integer degree
height_degree_up clinometer degree from the observer to the top of the plant
integer degree
width_ns Plant's width measured north to south
float meter
width_ew Plant's width measured east to west.
float meter
stem_diameter Diameter of the stem
float centimeter
stem_height height of the stem
float centimeter
distanceNS location of plant in distance from plot center north or south
float meter
directionNS Direction from plot center the plant located
string
Enumeration:
  • N: North
  • S: South
distanceEW location of plant in distance from plot center east or west
float meter
directionEW Direction from plot center the plant is located
string
Enumeration:
  • E: East
  • W: West
pa_front number of examples of species in parcel survey, of a speices on the front part of the parcel
integer
pa_back number of examples of species in parcel survey, of a speices on the back part of the parcel
integer
classify Classification of the location of the plant
string
Enumeration:
  • Accent: Planted for landscaping accent
  • Naturalized: Growing naturally
  • Pool Planting: Planted near a pool
gps_id_2010 Internal gps ID
integer
estimate How the measurements were found
string
Enumeration:
  • Measured: measured using tools
  • estimate: measured by estimation

Tabular: 27_cacti_succ_1.csv

Description: Cacti and Succulents
Temporal Coverage: 1999-02-01 to 2005-12-31

Column Description Type Units
plant_id Identification number for the plants found
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Numbers and letters used to identify the different sites used in this study
string
taxon_id Unique numbers assigned to specific taxon
integer
height Measured height of the plant
float
height_distance Measured distance between the base of the plant and the observer holding the clinometer
float meter
height_degree_down clinometer degree from the observer to the base of the plant
integer degree
height_degree_up clinometer degree from the observer to the top of the plant
integer degree
width_ns Plant's width measured north to south
float meter
width_ew Plant's width measured east to west.
float meter
stem_diameter Diameter of the stem
float centimeter
distanceNS location of plant in distance from plot center north or south
float meter
directionNS Direction from plot center the plant located
string
Enumeration:
  • N: North
  • S: South
distanceEW location of plant in distance from plot center east or west
float meter
directionEW Direction from plot center the plant is located
string
Enumeration:
  • E: East
  • W: West
classify Classification of the location of the plant
string
Enumeration:
  • Accent: Planted for landscaping accent
  • Naturalized: Growing naturally
  • Pool Planting: Planted near a pool
gps_id_2005 Internal gps ID
integer
estimate How the measurements were found
string
Enumeration:
  • Measured: measured using tools
  • estimate: measured by estimation

Tabular: 27_climate_1.csv

Description: Climate data collected at each site during visit

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Numbers and letters used to identify specific sites used in this study.
string
location The direction that the measurements were taken within a plot
string
Enumeration:
  • N: North
  • S: South
  • E: East
  • W: West
  • C: Center
time_of_day Time at which each measurement was taken
datetime Format: HH:MM:SS
dry_temp Temperature measured using the dry thermometer
float celsius
wet_temp Temperature using the wet thermometer
float celsius
windspeed Measured speed of the wind
float milesPerHour
description Description of the ground cover above which measurements were made
string

Tabular: 27_dowels_1.csv

Description: Dowel weights before and after being buried in the ground - a measure for wood decomposition rate

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique combination of letters and numbers used to identify specific sites used in this study.
string
sample_id Identification of the samples taken
integer
dowel_preweight Weight of the dowel before it is put into the ground
float gram
dowel_postweight Weight of the dowel when it is pulled up after one year
float gram
removal_date Date the sample was removed
datetime Format: MM/DD/YYYY

Tabular: 27_hedges_1_2010.csv

Description: mearuments for hedge biovolume on plots
Temporal Coverage: 2010-01-01 to 2010-06-21

Column Description Type Units
hedge_id Number that denotes a unique identifier for the record
integer
survey_id Number that denotes a unique identifier from the sample event tabular file
integer
plant_id Nummerical Identification of the plants tested at a specific plot
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Identification numbers and letters unique to each site
string
scientific_name scientific name of the species
string
stem_diam Stem Diameter
float centimeter
shape pruned Shape of hedge
string
height_distance Distance from the base of the plant to the observer holding the clinometer
float meter
height_degree_up clinometer degree from the observer to the top of the plant
float degree
height_degree_down clinometer degree from the observer to the bottom of the plant
float degree
height Actual height of the hedge
float meter
width Width of the hedge
float meter
length Length of the hedge
float meter
crown_height Height of the crown if hedge was trimmed off the ground
float meter
missing Percent missing from a perfect circle or oval of the biomass
integer dimensionless
condition Condition of the plant based on the percent of dead or missing sections of biomass
string
Enumeration:
  • Excellent: less than 1%
  • Good: 1 –10%
  • Fair: 11 – 25%
  • Poor: 26 – 50%
  • Critical: 51 – 75%
  • Dying: 76 – 99%
  • Dead: no leaves
no_individuals Number of individual plants in hedge
integer
classify What type of use it is surving
string
Enumeration:
  • Accent: Planted for landscaping
distanceNS location of plant in distance from plot center north or south
float centimeter
directionNS Direction from plot center the plant located
string
Enumeration:
  • N: North
  • S: South
distanceEW location of plant in distance from plot center east or west
float centimeter
directionEW Direction from plot center the plant is located
string
Enumeration:
  • E: East
  • W: West
estimate How the measurements were determined
string
Enumeration:
  • measured: Plants were measured using a measuring tool
  • estimate: Measurements were found by estimation by the observer
gps_id_2010 gps location id used in the survey
integer

Tabular: 27_hedges_1.csv

Description: mearuments for hedge biovolume on plots

Column Description Type Units
plant_id Nummerical Identification of the plants tested at a specific plot
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Identification numbers and letters unique to each site
string
taxon_id Taxon Identification Number
integer
stem_diam Stem Diameter
float centimeter
shape pruned Shape of hedge
string
height_distance Distance from the base of the plant to the observer holding the clinometer
float meter
height_degree_up clinometer degree from the observer to the top of the plant
float degree
height_degree_down clinometer degree from the observer to the bottom of the plant
float degree
height Actual height of the hedge
float meter
width Width of the hedge
float meter
length Length of the hedge
float meter
crown_height Height of the crown if hedge was trimmed off the ground
float meter
missing Percent missing from a perfect circle or oval of the biomass
integer dimensionless
condition Condition of the plant based on the percent of dead or missing sections of biomass
string
Enumeration:
  • Excellent: less than 1%
  • Good: 1 –10%
  • Fair: 11 – 25%
  • Poor: 26 – 50%
  • Critical: 51 – 75%
  • Dying: 76 – 99%
  • Dead: no leaves
no_individuals Number of individual plants in hedge
integer
classify What type of use it is surving
string
Enumeration:
  • Accent: Planted for landscaping
distanceNS location of plant in distance from plot center north or south
float centimeter
directionNS Direction from plot center the plant located
string
Enumeration:
  • N: North
  • S: South
distanceEW location of plant in distance from plot center east or west
float centimeter
directionEW Direction from plot center the plant is located
string
Enumeration:
  • E: East
  • W: West
estimate How the measurements were determined
string
Enumeration:
  • measured: Plants were measured using a measuring tool
  • estimate: Measurements were found by estimation by the observer

Tabular: 27_individual_count_1.csv

Description: number of individuals per species in each quadrant of the plot (desert plots)

Column Description Type Units
site_id Unique numbers and letters assigned to the sites used in this study
string
visit_id visit id, encrypted date of visit MMDDYYYY
string
taxon_id Taxon ID number
integer
NW_quadrant Amount of individuals of a species in the northwest quadrant of the site
integer dimensionless
NE_quadrant Amount of individuals of a species in the northeast quadrant of the site
integer dimensionless
SW_quarant Amount of individuals of a species in the southwest quadrant of the site
integer dimensionless
SE_quadrant Amount of individuals of a species in the southeast quadrant of the site
integer dimensionless

Tabular: 27_insects_1.csv

Description: Insects collected via sweepnet, description of plant is in table sweepnet

Column Description Type Units
visit_id Internal Identification Number
string
site_id Unique numbers and letters given to individual sites used in this study
string
sample_id Identification numbers given to the samples taken
integer
taxon_id Unique numbers assigned to taxon
integer
determined_by Observer's name
string
individual_count Count of the individual specimens found at the site
integer

Tabular: 27_landsc_irrigation_1.csv

Description: Information on Irrigation types and landscape maintenance

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique numbers and letters assigned to individual sites used in this study
string
turf Presence of turf on the site
string
well_maintained Landscape maintenance quality
string
professionally Professionally done landscaping
string
healthy Were the plants healthy
string
injury Presence of injury on plants
string
cover_open_ground Precent of open ground; dirt or soil showing
integer dimensionless
cover_tress number of trees
integer dimensionless
cover_shrubs Number of shurbs
integer dimensionless
cover_cacti_succ Number of cacti and succulents present
integer dimensionless
cover_lawn Percent of land covered with lawn
integer dimensionless
cover_herbacous_ground Percent of land covered with herbacous plants
integer dimensionless
cover_other Percent of all non pervious surfaces on the plot (e.g. asphalt, concrete, roof)
integer dimensionless
water_hand_flood Percent flood irrigated by hand
integer dimensionless
water_drip Percent drip irrigation
integer dimensionless
water_overhead Percent of overhead irrigation used
integer dimensionless
water_subterranean Percent of subterranean water irrigation used
integer dimensionless
water_hand_flood_ap If flood irrigation is applied by hand
bit
Enumeration:
  • 0: false
  • 1: true
water_drip_ap Drip irrigation application
bit
Enumeration:
  • 0: false
  • 1: true
water_overhead_ap Overhead application
bit
Enumeration:
  • 0: false
  • 1: true
perc_imperv_irrigated Percent of pervious land that is irrigated
integer dimensionless
type_soil_ap bare soil present in plot
bit
Enumeration:
  • 0: false
  • 1: true
type_trees_ap Trees present in plot
bit
Enumeration:
  • 0: false
  • 1: true
type_shrubs_ap Shrubs present in plot
bit
Enumeration:
  • 0: false
  • 1: true
type_cact_succ_ap Cacti and succulents present in plot
bit
Enumeration:
  • 0: false
  • 1: true
type_lawn_ap Lawn present in plot
bit
Enumeration:
  • 0: false
  • 1: true
type_herb_ground_ap Hebatious present in plot
bit
Enumeration:
  • 0: false
  • 1: true
type_other_ap other surfaces/covers present in plot
bit
Enumeration:
  • 0: false
  • 1: true

Tabular: 27_landuse_1.csv

Description: landuse at each plot given in percent of area

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique numbers and letters assigned to the sites used in this study
string
landuse landuse type code
string
landuse_percent Percent of each landuse type in a site
integer dimensionless

Tabular: 27_landuse_100_m_1.csv

Description: Landuse up to 100 meters around the plot

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique letters and numbers used to identify the sites used in this study
string
direction Direction of the observer was facing
string
landuse landuse type code
string

Tabular: 27_landuse_codes_s200_1.csv

Description: Survey 200 landuse codes

Column Description Type Units
MAG_landuse Maricopa Association of Governments Landuse Codes
string
MAG_landuse_label Maricopa Association of Governments Landuse labels
string
landuse CAP landuse codes, modified from MAG
string
landuse_label CAP landuse lables
string
level1 First category tier
string
level2 Second category tier
string
level3 Third category tier
string
level4 Fourth category tier
string
level5 Fifth category teir
string
level6 Sixth category teir
string
addedlev1_lev2 Level One and Two
string

Tabular: 27_landuse_codes_1_2010.csv

Description: Survey 200 landuse codes, for 2010
Temporal Coverage: 2010-01-01 to 2010-06-21

Column Description Type Units
MAG_landuse Maricopa Association of Governments Landuse Codes
string
MAG_landuse_label Maricopa Association of Governments Landuse labels
string
landuse CAP landuse codes, modified from MAG
string
landuse_label CAP landuse lables
string
level1 First category tier
string
level2 Second category tier
string
level3 Third category tier
string
level4 Fourth category tier
string
level5 Fifth category teir
string
level6 Sixth category teir
string
addedlev1_lev2 Level One and Two
string

Tabular: 27_landusehistory_1.csv

Description: Landuse History

Column Description Type Units
site_id Unique numbers and letters used to identify the sites used in this study.
string
lu1912 Landuse in 1912 based on landuse as determined by CAPLTER Historic Landuse Project phase 1.
string
lu1934 Landuse in 1934
string
lu1955 Landuse in 1955
string
lu1970level1 Landuse in 1970 Level 1 based on landuse as determined by CAPLTER Historic Landuse Project phase 2.
string
lu1970level2 Landuse in 1970 level 2 based on landuse as determined by CAPLTER Historic Landuse Project phase 2
string
lu1975 Landuse in 1975 based on landuse as determined by CAPLTER Historic Landuse Project phase 1.
string
lu1980level1 Landuse in 1980 level 1based on landuse as determined by CAPLTER Historic Landuse Project phase 2
string
lu1980level2 Landuse in 1980 Level 2 based on landuse as determined by CAPLTER Historic Landuse Project phase 2
string
lu1990level1 Landuse in 1990 level 1based on landuse as determined by CAPLTER Historic Landuse Project phase 2
string
lu1990level2 Landuse in 1990 level 2 based on landuse as determined by CAPLTER Historic Landuse Project phase 2
string
lu1995 Landuse in 1955 based on landuse as determined by CAPLTER Historic Landuse Project phase 1
string
lu1995level1 Landuse in 1995 level 1based on landuse as determined by CAPLTER Historic Landuse Project phase 2
string
lu1995level2 Landuse in 1995 level 2 based on landuse as determined by CAPLTER Historic Landuse Project phase 2.
string
lu2000level1 Landuse in 2000 level 1 based on landuse as determined by CAPLTER Historic Landuse Project phase 2.
string
lu2000level2 Landuse in 2000 level 2 based on landuse as determined by CAPLTER Historic Landuse Project phase 2.
string
s200lu2000level1 Survey200 Landuse in 2000 level 1as found on the ground.
string
s200lu2000level2 Survey200 Landuse in 2000 level 2 as found on the ground.
string
s200lu2005level1 Survey200 Landuse in 2005 level 1as found on the ground.
string
s200lu2005level2 Survey200 Landuse in 2005 level 2 as found on the ground.
string
yearsSinceLstChng Number of years since the last landuse change based on the previous data.
integer
everInAg Whether the land has ever been used for agriculture.
string
Enumeration:
  • y: yes
  • n: no

Tabular: 27_litter_bags_1.csv

Description: Litter Bags

Column Description Type Units
bag_id Unique numbers assigned to each bag of litter collected
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique letters and numbers used to identify the sites used in this study
string
sample_id Sample ID numbers
integer
pre_weight air dry leaves before it goes to the site, 10g for each
float gram
location_description location the bag was placed
string
removal_date Date the bag was removed
datetime Format: YYYY-MM-DD
post_dry_weight 60 degree oven dry weight after removal
float gram
post_ash_weight ash weight after removal
float gram

Tabular: 27_mycorrhiza_numspores_1.csv

Description: Mycorrhiza Spore Count 1999

Column Description Type Units
site_id Unique numbers and letters assigned to each site used in this study
string
visit_id visit id, encrypted date of visit MMDDYYYY
string
parallel_id Parallel Identification; A, B, C
string
vegetation Vegetation around the specific sample site
string
num_spores Spore Count
float dimensionless

Tabular: 27_mycorrhiza_sample_sites_1.csv

Description: description of the exact sample locations for the mycorrhiza study

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique numbers and letters used to identify the sites used in this study
string
sample_id Sample Identification Numbers
integer
location_description Description of the exact area where the sample was taken
string
under_plant Numeric codes used to identify plant species the sample was taken under
integer

Tabular: 27_mycorrhiza_species_1.csv

Description: Species of mycorrhiza and individual count for each sample

Column Description Type Units
myco_id Mycorrhiza ID number
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique numbers and letters that identify sites used in this study
string
parallel_id Parallel Identification
string
trap_soil Describes whether the spores were obtained from the soil sample or a trap
string
taxon_id Unique Taxon Identification Number
integer

Tabular: 27_neigh_buildings_1.csv

Description: Neighborhood Buildings

Column Description Type Units
SITE_ID Unique combinations of letters and numbers used to identify the sites used in this study
string
visit_id visit id, encypted date of visit MMDDYYYY
string
neigh_buildings Building use
string

Tabular: 27_neigh_irrigation_1.csv

Description: Neighborhood irrigation

Column Description Type Units
site_id Unique combinations of numbers and letters used to identify the sites used in this study
string
visit_id visit id, encypted date of visit MMDDYYYY
string
neigh_irrigation Neighborhood irrigation systems
string

Tabular: 27_neigh_landscape_1.csv

Description: Neighborhood landscaping

Column Description Type Units
site_id Unique combination of numbers and letters used to identify the sites used in this study.
string
visit_id visit id, encypted date of visit MMDDYYYY
string
neigh_landscape Type of landscaping in the neighborhood
string

Tabular: 27_neigh_residences_1.csv

Description: Neighborhood Residences

Column Description Type Units
site_id Unique combinations of numbers and letters used to identify the sites used in this study
string
visit_id visit id, encypted date of visit MMDDYYYY
string
neigh_residences Type of residences
string

Tabular: 27_parcel_characteristics_1_2010.csv

Description: Survey 200, parcel characteristics data, At all residential sites, survey characteristics of the parcel that most overlaps with the 30x30m study plot – if not accessible, survey the parcel that is most accessible.
Temporal Coverage: 2010-01-01 to 2010-06-21

Column Description Type Units
survey_id table unique identifier, primary key for this datatable as well as a foreign key from the sampleing events datatable
integer
residence_type parcels residence type (e.g. single family)
string
social_class approximate or perceived social class of residents on the parcel (e.g. middle class)
string
front_back which section is the parcel located with in the site
string
Enumeration:
  • front: front section value for the parcel location as defined in protocol
Enumeration:
  • back: back section value for the the parcel location as defined in the protocols
appearance yard characteristics, what did the parcels upkeep and appearance convey (e.g. professionally and well maintained)
string
orderliness yard characteristics, was the placement of plants, riverbeds, etc, landscaped in a orderly fashion (e.g. highly structured and designed)
string
bird_feeder yard characteristics, was there a bird feeder found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
water_feature yard characteristics, was there a water feature (e.g. fountain) found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
porch_patio yard characteristics, was there a front porch or patio found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
cats yard characteristics, were there cats found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
dogs yard characteristics, were there dogs found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
pet_waste yard characteristics, was there pet or other animal waste found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
statues yard characteristics, were there religious ornaments or statues found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
flagpole yard characteristics, was there a flag poie(s) found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
cars_yard yard characteristics, were there cars in the yard found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovered
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
potted_plant yard characteristics, were there potted plants found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
play_equip yard characteristics, was there play equipment found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
lawn_ornaments yard characteristics, was there lawn ornaments found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovered
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
furniture yard characteristics, was there furniture found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
river_bed yard characteristics, was there a landscaped (rock) river bed found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
yard_topography yard characteristics, was there created yard topography found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
litter yard characteristics, was there litter (refuse on ground, etc) found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
veg_litter yard characteristics, was there vegetation litter (leaves, etc) found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
yard_tools yard characteristics, was there yard maintenance tools found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
light_post yard characteristics, was there a light post(s) found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
other yard characteristics, was there any other subject found on the parcel, subject discovery
boolean
Enumeration:
  • -1: a true value, presence of subject discovery
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
feature_comments other yard characteristics noted during time of observation
string
irrigation_flood yard characteristics, flood irrigation system found within the parcel
boolean
Enumeration:
  • -1: a true value, presence of subject discovered
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
irrigation_drip yard characteristics, drip irrigation system found within the parcel
boolean
Enumeration:
  • -1: a true value, presence of subject discovered
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
irrigation_hose yard characteristics, hose irrigation system found within the parcel
boolean
Enumeration:
  • -1: a true value, presence of subject discovered
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
irrigation_sprinklers yard characteristics, sprinklers irrigation system found within the parcel
boolean
Enumeration:
  • -1: a true value, presence of subject discovered
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
landsc_type yard characteristics, landscape type
integer
Enumeration:
  • 1: mesic
Enumeration:
  • 2: mixed
Enumeration:
  • 3: xeric
Enumeration:
  • 4: mostly patio
Enumeration:
  • other: anything else
amount_grass yard characteristics, amount of parcel clovered by grass
string
Enumeration:
  • 1: none
Enumeration:
  • 2: less than half
Enumeration:
  • 3: about half
Enumeration:
  • 4: more than half
Enumeration:
  • 5: all or mostly grass
weeds_grass yard characteristics, % % weeds in GRASS areas found on the parcel
integer
Enumeration:
  • 1: no grass
Enumeration:
  • 2: no weeds
Enumeration:
  • 3: few(less than 10%)
Enumeration:
  • 4: 10% - 25%
Enumeration:
  • 5: 25% - 50%
Enumeration:
  • 6: great(greater than 50%)
weeds_xeric yard characteristics, % in NON-GRASS/XERIC areas found on the parcel
integer
Enumeration:
  • 1: no grass
Enumeration:
  • 2: no weeds
Enumeration:
  • 3: few(less than 10%)
Enumeration:
  • 4: 10% - 25%
Enumeration:
  • 5: 25% - 50%
Enumeration:
  • 6: great(greater than 50%)
weeds_other yard characteristics, weeds in other areas of yard (e.g. flower beds, driveway, etc)
boolean
Enumeration:
  • -1: a true value, presence of subject discovered
Enumeration:
  • null: non-positive result, could be null or false
Enumeration:
  • 0: false, no presence of subject discovered
pruning_trees yard characteristics, tree pruning (cut branches)
string
Enumeration:
  • 1: yes
Enumeration:
  • 2: no
Enumeration:
  • 3: no trees planted
Enumeration:
  • NULL: non-positive result, null data
pruning_shrubs yard characteristics, shrub pruning (shaped shrubs)
string
Enumeration:
  • 1: yes
Enumeration:
  • 2: no
Enumeration:
  • 3: no trees planted
Enumeration:
  • NULL: non-positive result, null data
grass_patchiness Grass patchiness (patch = at least 5% of grass area)
integer
Enumeration:
  • 1: 100% even grass (no weedy or bare patches)
Enumeration:
  • 2: patches of weeds and bare soil
Enumeration:
  • 3: no value estimated
percent_living_grass Estimated % lawn cover(defined by area of grass) as it relates to percent living grass from attributes: (percent living grass, percent dead or dormant grass, percent bare ground, percent weeds, percent other) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
percent_bare Estimated % lawn cover(defined by area of grass) as it relates to percent bare from attributes: (percent living grass, percent dead or dormant grass, percent bare ground, percent weeds, percent other) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
percent_dead Estimated % lawn cover(defined by area of grass) as it relates to percent dead from attributes: (percent living grass, percent dead or dormant grass, percent bare ground, percent weeds, percent other) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
percent_weeds Estimated % lawn cover(defined by area of grass) as it relates to percent weeds from attributes: (percent living grass, percent dead or dormant grass, percent bare ground, percent weeds, percent other) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
percent_other Estimated % lawn cover(defined by area of grass) as it relates to percent other from attributes: (percent living grass, percent dead or dormant grass, percent bare ground, percent weeds, percent other) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
percent_no_stress Estimated % of stress of lawn as it relates to percent no stress against other attributes (percent no stress, percent little stress, percent some stress, percent moderate stress, percent severe stress) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
percent_little_stress Estimated % of stress of lawn as it relates to percent little stress against other attributes (percent no stress, percent little stress, percent some stress, percent moderate stress, percent severe stress) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
percent_some_stress Estimated % of stress of lawn as it relates to percent some stress against other attributes (percent no stress, percent little stress, percent some stress, percent moderate stress, percent severe stress) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
percent_moderate_stress Estimated % of stress of lawn as it relates to percent moderate stress against other attributes (percent no stress, percent little stress, percent some stress, percent moderate stress, percent severe stress) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
percent_severe_stress Estimated % of stress of lawn as it relates to percent severe stress against other attributes (percent no stress, percent little stress, percent some stress, percent moderate stress, percent severe stress) not to exceed 100% in total per parcel for the 5 attributes listed
integer dimensionless
lawn_overall Overall Lawn color (including grass/weeds/etc)
string
Enumeration:
  • 1: Very Green (no stress)
Enumeration:
  • 2: Moderately green (little stress)
Enumeration:
  • 3: Greenish-Yellow (some stress)
Enumeration:
  • 4: Yellowish (moderate stress)
Enumeration:
  • 5: Brownish (severe stress)
Enumeration:
  • NULL: no value recorded or entered
lawn_quality Overall Lawn quality Measure (1-10)
integer
Enumeration:
  • 1: Monoculture (no patches, no weeds), Dense, Very green grass (like golf course)
Enumeration:
  • 2: a precieved value between 1 and 3
Enumeration:
  • 3: Mostly Monoculture (few weeds), Overall Greenish-Yellow Yard
Enumeration:
  • 4: a precieved value between 3 and 5
Enumeration:
  • 5: Mixed Species (Grass & Weeds), Evenly Distributed, Overall Yellow yard
Enumeration:
  • 6: a precieved value between 5 and 7
Enumeration:
  • 7: Mixed Species (Grass & Weeds), Patchy, Overall Yellow Yard
Enumeration:
  • 10: Very Patchy (Dead Grass & Weeds + Bare Ground), Overall Brown Color
lawn_trimmed Lawn edges trimmed
integer
Enumeration:
  • 1: yes
Enumeration:
  • 2: no
Enumeration:
  • NULL: non value
recent_cut Recently Mowed
integer
Enumeration:
  • 1: yes
Enumeration:
  • 2: no
Enumeration:
  • NULL: non value
grass_height Grass Height (cm) at the parcel
integer centimeter
weed_height Weed Height (cm) at the parcel
integer centimeter

Tabular: 27_photos_1_2010.csv

Description: Photos taken in 2010 reference list to the photos, actual photos not available at this time, contact the Information Manager for assistance
Temporal Coverage: 2010-01-01 to 2010-06-21

Column Description Type Units
survey_id Sampling event unique identifier used to associate a photo to a survey and other information
integer
pic_number Photo unique identifier, used to catelogy the photos for quick reference as well as other indexing actions
integer
pic_description Other important details about how the photo was taken.
string
photographer The full name of the person who took the photograph
string

Tabular: 27_photos_old_1.csv

Description: Information on photos taken on each plot
Temporal Coverage: 1999-02-01 to 2005-12-31

Column Description Type Units
frame_number Number on the negative used to identify the order in which the pictures were taken
integer
camera_id type or brand of the camera used
string
film_number Number found on the film used
string
photographer Photographer's name
string
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique letters and numbers used to identify specific sites used in this study
string
description Description of what the photo was taken of
string

Tabular: 27_pollen_count_1.csv

Description: Pollen Count
Temporal Coverage: 1999-02-01 to 2010-06-21

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique letters and numbers used to identify the sites used int this study
string
Abies Amount of Abies pollen found at each site
decimal dimensionless
Picea Amount of Picea pollen found at each site
decimal dimensionless
Pinus Amount of Pinus pollen found at each site
decimal dimensionless
Total Conifer Taxa (TCT) Total amount of conifer taxa pollen found at each site
decimal dimensionless
CUPRESSACEAE Amount of Cupressaceae pollen found at each site
decimal dimensionless
Alnus Amount of Alnus pollen found at each site
decimal dimensionless
ARACEAE Amount of Araceae pollen found at each site
decimal dimensionless
Washingtonia Amount of Washingtonia pollen found at each site
decimal dimensionless
Cycas Amount of cycas pollen found at each site
decimal dimensionless
Brachychiton Amount of brachychiton pollen found at each site
decimal dimensionless
Bursera Amount of Bursera pollen found at each site
decimal dimensionless
Callistemon Amount of Callistemon pollen found at each site
decimal dimensionless
Carissa Amount of Carissa pollen found at each site
decimal dimensionless
Carya Amount of Carya pollen found at each site
decimal dimensionless
CarpinusOstrya Amount of Carpinus Ostrya pollen at each site
decimal dimensionless
Celtis Amount of celtis pollen found at each site
decimal dimensionless
Citrus Amount of citrus pollen at each site
decimal dimensionless
Corylus Amount of corylus pollen found at each site
decimal dimensionless
EucalyptusMyrtus Amount of eucalyptus myrtus pollen found at each site
decimal dimensionless
FABACEAE Amount of fabaceae pollen found at each site
decimal dimensionless
Acacia Amount of acacia pollen found at each site
decimal dimensionless
Bauhinia Amount of Bauhinia pollen found at each site
decimal dimensionless
Cassia Amount of cassia pollen found at each site
decimal dimensionless
Caesalpinia Amount of caesalpinia pollen found at each site
decimal dimensionless
Calliandra Amount of calliandra pollen found at each site
decimal dimensionless
Dalbergia Amount of dalbergia pollen found at each site
decimal dimensionless
Dalea Amount of dalea pollen found at each site
decimal dimensionless
Lotus Amount of lotus pollen found at each site
decimal dimensionless
Mimosa Amount of mimosa pollen found at each site
decimal dimensionless
Marina Amount of marina pollen found at each site
decimal dimensionless
Olneya Amount of olneya pollen found in each sample
decimal dimensionless
Parkinsonia Amount of parkinsonia pollen found at each site
decimal dimensionless
Pithecellobium Amount of pithecellobium pollen found at each site
decimal dimensionless
Prosopis Amount of prosopis pollen found at each site
decimal dimensionless
Fraxinus Amount of fraxinus pollen found at each site
decimal dimensionless
Hibiscus Amount of hibiscus pollen found at each site
decimal dimensionless
Jacaranda Amount of jacaranda pollen found at each site
decimal dimensionless
Juglans Amount of juglans pollen found at each site
decimal dimensionless
Larrea Amount of larrea pollen found at each site
decimal dimensionless
Ligustrum Amount of ligustrum pollen found at each site
decimal dimensionless
Melia Amount of melia pollen found at each site
decimal dimensionless
Myoporum Amount of myoporum pollen found at each site
decimal dimensionless
Morus Amount of morus pollen found at each site
decimal dimensionless
Nerium Amount of Nerium pollen found at each site
decimal dimensionless
NYCTAGINACEAE Amount of nyctaginaceae pollen found at each site
decimal dimensionless
Bougainvillea Amount of bougainvillea pollen found at each site
decimal dimensionless
OleaJasminum Amount of olea jasminum pollen found at each site
decimal dimensionless
Pittosporum Amount of pittosporum pollen found at each site
decimal dimensionless
Punica Amount of punica pollen found at each site
decimal dimensionless
Populus Amount of populus pollen found at each site
decimal dimensionless
Pistacia Amount of pistacia pollen found at each site
decimal dimensionless
Quercus Amount of quercus pollen found at each site
decimal dimensionless
ROSACEAE Amount of rosaceae pollen found at each site
decimal dimensionless
Prunus Amount of prunus pollen found at each site
decimal dimensionless
Pyracantha Amount of pyracantha pollen found at each site
decimal dimensionless
Rosa Amount of rosa pollen found at each site
decimal dimensionless
Rhamnus Amount of rhamnus pollen at each site
decimal dimensionless
Rhus Amount of rhus pollen found at each site
decimal dimensionless
Schinus Amount of schinus pollen found at each site
decimal dimensionless
Salix Amount of salix pollen found at each site
decimal dimensionless
Sarcobatus Amount of sarcobatus pollen found at each site
decimal dimensionless
Tamarix Amount of tamarix pollen found at each site
decimal dimensionless
Tecoma Amound of tecoma pollen found at each site
decimal dimensionless
Ulmus Amount of ulmus pollen found at each site
decimal dimensionless
Vitex Amount of vitex pollen found at each site
decimal dimensionless
Xylosma Amount of xylosma found at each site
decimal dimensionless
EuonymusType Amount of euonymus type pollen found at each site
decimal dimensionless
Gardenia Amount of gardenia pollen found at each site
decimal dimensionless
Lantana Amount of lantana pollen found at each site
decimal dimensionless
Leucophyllum Amount of leucohyllum pollen found at each site
decimal dimensionless
Ribes Amount of ribes pollen found at each site
decimal dimensionless
Salazaria amount of salazaria pollen found at each site
decimal dimensionless
SOLANACEAE Amount of solanaceae pollen found at each site
decimal dimensionless
Lycium Amount of lycium pollen found at each site
decimal dimensionless
TotalTreeShrubs Total count of tree shrubs
decimal dimensionless
Krameria Amount of krameria pollen found at each site
decimal dimensionless
HighSpineAsteraceae pollen Amount of high spine asteraceae
decimal dimensionless
LowSpineAsteraceae Amount of low spine asteraceae pollen
decimal dimensionless
AmbrosiaType Amount of ambrosia type pollen found at each site
decimal dimensionless
Liguliflorae Amount of liguliflorea pollen found at each site
decimal dimensionless
ChenoAm Amount of Chenopodium and Ambrosia pollen found at each site
decimal dimensionless
EphedraN amount of ephedra N pollen found at each site
decimal dimensionless
EphedraT Amount of ephedra T pollen found at each site
decimal dimensionless
Eriogonum Amount of erigonum pollen found at each site
decimal dimensionless
LILIACEAE Amount of liliaceae pollen found at each site
decimal dimensionless
Asparagus Amount of asparagus pollen found at each site
decimal dimensionless
Plumbago Amount of plumbago pollen found at each site
decimal dimensionless
Rosmarinus Amount of rosmarinus pollen found at each site
decimal dimensionless
Sphaeralcea Amount of sphaeralcea pollen found at each site
decimal dimensionless
Tidestromia Amount of tidestromia pollen found at each site
decimal dimensionless
Vinca Amount of vinca pollen found at each site
decimal dimensionless
TotalShrubSubshrub Total shrub sub-shrubs pollen found at each site
decimal dimensionless
Simmondsia Amount of simmondsia pollen found at each site
decimal dimensionless
AGAVACEAE Amount of agavaceae pollen found at each site
decimal dimensionless
Yucca Amount of yucca pollen found at each site
decimal dimensionless
Aloe Amount of Aloe pollen found at each site
decimal dimensionless
Hesperaloe Amount of hesper aloe pollen found at each site
decimal dimensionless
CACTACEAE Amount of cactaceae pollen found at each site
decimal dimensionless
Carnegia Amount of carnegia pollen found at each site
decimal dimensionless
Echinocereus Amount of echinocereus pollen found at each site
decimal dimensionless
Echinocactus Amount of echinocactus pollen found at each site
decimal dimensionless
Ferocactus Amount of ferocactus pollen found at each site
decimal dimensionless
Opuntia Amount of opuntia pollen found at each site
decimal dimensionless
Cylindropuntia Amount of cylindropuntia pollen found at each site
decimal dimensionless
Platyopuntia Amount of platyopuntia pollen found at each site
decimal dimensionless
Fouquieria Amount of fouquieria pollen found at each site
decimal dimensionless
Holacantha Amount of holacatha pollen found at each site
decimal dimensionless
TotalXerophyte Amount of total xerphyte pollen found at each site
decimal dimensionless
Acalypha Amount of acalypha pollen found at each site
decimal dimensionless
APIACEAE Amount of apiaceae pollen found at each site
decimal dimensionless
CRUCIFERAE Amount of cruciferae pollen found at each site
decimal dimensionless
Erodium Amount of erodium pollen found at each site
decimal dimensionless
EUPHORBIACEAE Amount of euphorbiaceae pollen found at each site
decimal dimensionless
ONAGRACEAE Amount of onagraceae pollen found at each site
decimal dimensionless
Galium Amount of galium pollen found at each site
decimal dimensionless
JusticiaType Amount of justicia-type pollen found at each site
decimal dimensionless
LAMIACEAE Amount of lamiaceae pollen found at each site
decimal dimensionless
Ruellia Amount of ruellia pollen found at each site
decimal dimensionless
Rumex Amount of rumex pollen found at each site
decimal dimensionless
Taraxacum Amount of taraxacum pollen found at each site
decimal dimensionless
Urtica Amount of urtica pollen found at each site
decimal dimensionless
Verbena Amount of verbena pollen found at each site
decimal dimensionless
TotalHerbForb Total herb pollen found at each site
decimal dimensionless
CYPERACEAE Amount of cyperaceae pollen found at each site
decimal dimensionless
POACEAEsmall Amount of small poaceae pollen found at each site
decimal dimensionless
POACEAlarge Amount of large poaceae pollen found at each site
decimal dimensionless
Cucurbita Amount of cucurbita pollen found at each site
decimal dimensionless
Gossypium Amount of gossypium pollen found at each site
decimal dimensionless
Plantago Amount of plantago pollen found at each site
decimal dimensionless
Phaseolus Amount of phaseolus pollen found at each site
decimal dimensionless
Physalis Amount of physalis pollen found at each site
decimal dimensionless
Solanum Amount of solanum pollen found at each site
decimal dimensionless
Zea Amount of zea pollen found at each site
decimal dimensionless
MALVACEAE Amount of malvaceae pollen found at each site
decimal dimensionless
TotalCropGarden Total amount of crop and garden pollen found at each site
decimal dimensionless
Unknown1 Amount of unidentifiable pollen found at each site
decimal dimensionless
NID Amount of NID pollen found at each site
decimal dimensionless
Lycopodium Amount of lycopodium pollen found at each site
decimal dimensionless
TOTAL Total amount of pollen found at each site
decimal dimensionless
VolumeCubiccm Volume of soil subsample in which the pollen were counted
decimal cubicCentimetersPerCubicCentimeters
LycopodiumAdded Total amount of lycopodium pollen added to the sample
decimal dimensionless

Tabular: 27_sampling_event_1.csv

Description: Sampling conditions, locations, participants, ect
Temporal Coverage: 1999-02-01 to 2010-06-21

Column Description Type Units
survey_id Unique identifier value for the sampling events
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique numbers and letters used to identify the sites used in this study
string
survey_type Parcel type identification value, parcel types added in 2010 survey
string
samp_date Date the samples were taken on
datetime Format: MM/DD/YYYY
description Descriptions of the locations where the samples were taken from
string
traffic The type of road, street, ect. that the sample site is located on
string
crew_members Names of the crew members
string
weather_set_up Start times for weather
datetime Format: HH:MM:SS AM/PM
weather_stop End times for weather
datetime Format: HH:MM:SS AM/PM
path Paths seen throughout the site
string
footprints Footprints seen throughout the site
string
bike_tracks Bike tracks within the site
string
off_road_vehicle Presence of off road vehicles
string
small_litter Amount of small litter
string
dumped_trash_bags Amount of dumped trash bags
string
graffiti Amount of graffiti present
string
abandoned_vehicles Amount of abandoned vehicles at the site
string
injured_plants Amount of injured plants
string
informal_play Amount of informal play going on within the site
string
informal_recreation Amount of informal recreation going on within the site
string
informal_living Amount of informal living within each site
string
sports_equipment Amount of sports equipment used within the site
string
number_cars Number of cars
integer dimensionless
number_motorcycles Number of motorcycles
integer dimensionless
number_bycicles Number of bycicles
integer dimensionless
number_houses Number of houses
integer dimensionless
number_rv Number of RVs
integer dimensionless
social_class_plot Social class of the area the plot is located in
string
social_class_neigh Neighborhood social class
string
buildings Types of buildings at the site
string
type_residence Type of residence
string
yard_upkeep Yard upkeep
string
irrig_neigh Type of irrigation used in the neighborhood
string
landscape_type Type of landscaping within the plot
string
tree_density Density of the trees at the site
string
notes Extra observations made by the crew
string
start_time Starting time
datetime Format: HH:MM:SS: AM/PM
end_time Ending time
datetime Format: HH:MM:SS: AM/PM
percent_visible Percent of the plot visible
integer dimensionless
turf Presence of turf on the plot
string
well_maintained Was the turf well maintained
string
professionally Is the turf professionally maintained
string
healthy Is the landscaping healthy
string
injury Presence of injured plants
string
cover_open_ground open ground, following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value
cover_trees , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value
cover_shrubs , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value
cover_cacti_succ , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value
cover_lawn , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value
cover_herbacous_ground , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value
cover_other , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value
old_cover_open_ground Percent of open ground
integer dimensionless
old_cover_tress Percent of plot covered by trees
integer dimensionless
old_cover_shrubs Percent of plot covered by shrubs
integer dimensionless
old_cover_cacti_succ Percent of plot covered by cacti and succulents
integer dimensionless
old_cover_lawn Percent of plot covered by lawn
integer dimensionless
old_cover_herbacous_ground Percent of plot covered by herbacous plants
integer dimensionless
old_cover_other Percent of plot covered by other things like cement
integer dimensionless
recent_rain Recent rainfall
string
todays_weather Weather on the day the samples were taken
string
weather_comments Exrta weather notes
string
water_hand , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value or false value, error in data entry application
water_drip , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value or false value, error in data entry application
water_overhead , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value or false value, error in data entry application
water_flood , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value or false value, error in data entry application
water_none , following new protocol, data type change required
boolean
Enumeration:
  • -1: true
Enumeration:
  • 0: false
Enumeration:
  • NULL: no value or false value, error in data entry application
percent_pervious_irrigation , following new protocol, data type change required
integer dimensionless
old_water_hand_flood Percent of the plants watered by hand flooding
integer dimensionless
old_water_drip Percent of the plants watered by drip irrigation
integer dimensionless
old_water_overhead Percent of the plants watered by overhead irrigation
integer dimensionless
old_water_subterranean Percent of plants watered by subterranean irrigation
integer dimensionless
old_water_none Percent of plants not watered
integer dimensionless
landuse Landuse classifications code
string
landcover_98 Description of landcover from the 1998 land cover/use classification
string
watering_main Main form of watering
string
weed_cover Percent of plot covered in weeds
float dimensionless
rope_length Annual species, regional annuals, that were touching the rope(s) sections were summed up from leaf tip to leaf along the 60 meters of total rope length possible, refer to the protocol for more details
integer meter
timestamp_val a record timestamp
datetime Format: YYYY-MM-DD hh:mm:ss

Tabular: 27_shrub_perennial_1.csv

Description: mearuements of shrubs and other small perennials

Column Description Type Units
survey_id Survey Identifier index number
integer
plant_id Plant ID number
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique letters and numbers used to identify the sites in this study
string
scientific_name the scientific name of the species
string
shrub_shape Shape of the biomass of the shrub
string
height Measured height or calculated height of the shrub_perennial subject, used height_distance, height_degree_up, and height_degree_down to calculate height
float meter
height_distance distance away from the center shrub_perennial subject where the angle measurements height_degree_up and height_degree_down were taken
integer meter
height_degree_up the angle degree measurement up from the height_distance away from the center of the shrub_perennial subject
integer degree
height_degree_down the angle degree measurement down from the height_distance away from the center of the shrub_perennial subject
integer degree
width_ns Plant's width measured north to south
float centimeter
width_ew Plant's width measured east to west.
float centimeter
stem_diameter Diameter of the stem
float centimeter
distanceNS location of plant in distance from plot center north or south
float dimensionless
directionNS Direction from plot center the plant located
string
Enumeration:
  • N: North
  • S: South
distanceEW location of plant in distance from plot center east or west
float dimensionless
directionEW Direction from plot center the plant is located
string
Enumeration:
  • E: East
  • W: West
classify Classification of plant use
string
Enumeration:
  • Accent: Planted for landscaping accent
  • Naturalized: Growing naturally
  • Pool Planting: Planted near a pool
  • Foundation Planting: Foundation
gps_id_2005 Identification number of the GPS unit used in 2005
integer
gps_id_2010 Identification number of the GPS unit used in 2010
integer
estimate Estimation of measurements or using tools
string

Tabular: 27_sites_1.csv

Description: Sites

Column Description Type Units
site_id Unique numbers and letters assigned to specific sites used in this study
string
elevation The elevation of the site
float
slope The slope of the site
float
aspect The aspect of the site
integer
USGS_soilmap_mukey1 United States Geological Survey soilmap key
string
USGS_soilmap_cokey United States Geological Survey soilmap cokey
string
census1990blkGroupID census 1990 block group id
string
census1990areaName1990 census 1990 area name
string
census2000 Census 2000 block group ID
string
distance_urban_center Distance of the site from the urban center
float

Tabular: 27_soil_1.csv

Description: Soil data for 2000
Temporal Coverage: 1999-02-01 to 2000-05-17

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
sampling_year a year the sample was collected
datetime Format: YYYY
Code lab internal sample id
string
parallel replicates for 10 samples for quality control
string
Enumeration:
  • a: first parallel
  • b: second parallel
siteID site id
string
Layer top or bottom 10 cm of the 1 inch soil core
string
Enumeration:
  • TOP: top 10 cm of soil core
  • BOTTOM: 20 cm to bottom of soil core
KCl_FW Fresh weight of the sample KCl extracted for chemical analysis
float gram
Pan weight of pan used to determine fresh / dry weight ratios
float gram
Pan_plus_FW weight of pan and fresh subsample
float gram
Pan_plus_DW weight of pan and dry soil subsample
float gram
Dry_div_Wet ratio of dry weight to wet weight of subsample
float gram
percent_Mois percent moisture content of sample (g water per 100g dry soil)
float dimensionless
KCl_DW calculated dry of weight of sample KCl extracted for chemical analysis
float gram
Btl60_ml code for bottle in which the KCl soil extract is stored
string
NH4_N_mg_l raw NH4-N data from chromatograph
float milligramsPerLiter
NO3_N_mg_l raw NO3-N data from chromatograph
float milligramsPerLiter
H_BDC_cm height of 2 inch soil core
float centimeter
FW_BDC fresh weight of 2 inch soil core
float gram
FW_div_V_kg_L fresh weight per volume of 2 inch soil core
float kilogramPerLiter
Height_cm height of 1 inch soil core, combined for all 4 cores per site
float centimeter
FW_g fresh weight of 1 inch soil core, combined for all 4 cores per site
float gram
FW_div_V fresh weight per volume of 1 inch soil core, combined for all 4 cores per site
float kilogramPerLiter

Tabular: 27_soilbulkdensity_1.csv

Description: Bulk Density of Soil for 2000
Temporal Coverage: 1999-02-01 to 2000-05-17

Column Description Type Units
ID Unique numbers used to identify the samples
integer
site_id Unique combinations of numbers and letters used to identify sites used in this study
string
sample_date Date the samples were taken
datetime Format: MM/DD/YYYY
core_hight_cm Height of the core sample
float centimeter
fresh_weight Weight before processing
float gram
FWperVolume Fresh weight per volume in grams per cubic centimenter
float gram
more_2_mm_g Weight of the particles larger than 2mm
float gram
less_2mm_air_dry Weight of the particles less than 2mm that fell from the sieve after they air dried
float gram
total_air_dry Total weight after air drying
float gram
total_less_2_mm Total weight of the particles smaller than 2 mm
float gram
large_stones Weight of the large stones removed from the sample
float gram
mixed_soil Weight of the soil befor the large stones are removed and it is sieved
float gram
wet_sieve_sample Weight of samples prior to being processed through a wet sieve apparatus
float gram
wet_sieve_yield Weight of the sample after being sifted through the wet sieve
float gram
plant_matter Weight of any plant matter found within the sample
float gram
batch_date Date the sample was processed
datetime Format: MM/DD/YYYY
pan_weight Weight of the pan used for drying the sample
float gram
pan_air_dry Weight of the pan and soil sample after the sample has air dried
float gram
pan_oven_60 Weight of the pan and soil sample after the sample has been in a 60 degree oven for 48 hours
float gram
pan_oven_105 Weight of the pan and soil sample after the sample has been in a 105 degree oven for 48 hours
float gram
bulk_density Bulk density is a measure of the weight of the soil per unit volume (g/cm3)
float gramsPerCubicCentimeter

Tabular: 27_soil_samples_1.csv

Description: Description of where the Soil Samples where taken on the plot
Temporal Coverage: 1999-02-01 to 2010-06-21

Column Description Type Units
soil_sample_id Auto-incremented index to track unique records, referenced in data files: 27_soil_center_cores_2005_to_2010.csv and 27_soil_perimeter_cores_2005_to_2010.csv
integer
survey_id Unique number references records within file 27_sampling_event_1.csv
integer
location_description location description of soil samples
string
center_utm center utm testing point value, marks the center core was taken for a soil sample and sampleing event
double meter
north_utm north utm testing point value, marks the north core was taken for a soil sample and sampleing event
double meter
south_utm south utm testing point value, marks the south core was taken for a soil sample and sampleing event
double meter
east_utm east utm testing point value, marks the east core was taken for a soil sample and sampleing event
double meter
west_utm west utm testing point value, marks the west core was taken for a soil sample and sampleing event
double meter
sampling_notes description of soil sample notes for a specific event by record
string

Tabular: Collection of soil samples from plot center, 2005 to 2010

Description: Soil samples (20-cm depth) collected near survey plot center for analysis of chemical and, primarily, physical properties of soils for sample periods 2005 and 2010.
Temporal Coverage: 2005-02-15 to 2010-06-21

Column Description Type Units
center_core_id primary key for the table
integer
soil_sample_id foriegn key references to the soil_samples table
integer
core_height_cm height of soil in the 2-inch soil core soilbulkdensity core_hight_cm bulkdensity height (cm)
double centimeter
soil_bulkdensity_fw fresh weight of the 2-inch soil core soilbulkdensity fresh_weight bulkdensity fresh wt (g)
double gram
dw_more_2_mm weight of fractions greater than 2 mm soilbulkdensity more_2_mm_g bulkdensity dry wt (>2mm)
double millimeter
dw_less_2_mm weight of fractions less than 2 mm soilbulkdensity less_2mm_air_dry bulkdensity dry wt (<2mm)
double millimeter
plant_matter plant matter weight soilbulkdensity plant_matter bulkdensity veg matter (g)
double gram
conductivity conductivity of soil soilncphconduct top- / bottom-conductivity soil pH and conductivity conductivity (mS - millisiemen)
double siemen
pH pH of soil soilncphconduct top- / bottom-pH pH pH
double dimensionless
pan weight of pan used to determine soil moisture correction factor (soilbulkdensity pan_weight bulk density.xlsx) pan tare (g)
double gram
pan_plus_fw weight of pan and fresh subsample (soilbulkdensity pan_air_dry bulk density.xlsx) pan + soil wt (g)
double gram
pan_plus_dw60 weight of pan and dry soil subsample dried at 60 deg Celsius (soilbulkdensity pan_oven_60 bulk density.xlsx) pan + dry soil (g) ((60 degrees))
double gram
pan_plus_dw105 weight of pan and dry soil subsample dried at 105 deg Celsius (soilbulkdensity pan_oven_105 bulk density.xlsx) pan + dry soil (g) ((105 degrees))
double gram
soil_texture_fw sample weight of soil for texture analysis unbelievably not in current DB, need to upload for 2005 2010_200 survey soil texture.xls sample (g)
double gram
temperature initial temperature reading soil texture temperature 2010_200 survey soil texture.xls C
double celsius
r05 hydrometer reading of soil solution at 30 seconds soil texture r05 2010_200 survey soil texture.xls r0.5
double dimensionless
r1 hydrometer reading of soil solution at 1 minute soil texture r1 2010_200 survey soil texture.xls r0.5
double dimensionless
t1 temperature reading at 1 minute soil texture t1 2010_200 survey soil texture.xls t1
double celsius
r90 hydrometer reading of soil solution at 90 minutes soil texture r90 2010_200 survey soil texture.xls r90
double dimensionless
t90 temperature reading at 90 minutes soil texture t90 2010_200 survey soil texture.xls t90
double celsius
r1440 hydrometer reading of soil solution at 24 hours soil texture r90 2010_200 survey soil texture.xls r1440
double dimensionless
t1440 temperature reading at 24 hours soil texture t1440 2010_200 survey soil texture.xls t1440
double celsius
notes soil texture analysis notes soil texture notes 2010_200 survey soil texture.xls Notes:
string
cal_texture_fw blank calibration run for patch of samples proccesed, soil texture fw (should be 0.00000).
double gram
cal_temp blank calibration run for patch of samples proccesed, temperature.
double celsius
cal_r05 blank calibration run for patch of samples proccesed, r .05.
double dimensionless
cal_r1 blank calibration run for patch of samples proccesed, r 1.
double dimensionless
cal_t1 blank calibration run for patch of samples proccesed, t 1.
double celsius
cal_r90 blank calibration run for patch of samples proccesed, r 90.
double dimensionless
cal_t90 blank calibration run for patch of samples proccesed, t 90.
double celsius
cal_r1440 blank calibration run for patch of samples proccesed, r 1440.
double dimensionless
cal_t1440 blank calibration run for patch of samples proccesed, t 1440.
double celsius
cal_run_date blank calibration run for patch of samples proccesed, run time date.
date Format: YYYY-MM-DD

Tabular: Collection of soil samples from 4 points around the plot center sample, 2005 to 2010

Description: homogenized samples of four soil samples (30-cm depth, split into separate top 10-cm and bottom 20-cm layers) collected in cardinal directions approximately 10 m from survey plot center for analysis of chemical properties of soils for sample periods 2005 and 2010..
Temporal Coverage: 2005-02-15 to 2010-06-21

Column Description Type Units
deep_core_id primary key for the table
integer
soil_sample_id foriegn key references to the soil_samples table
integer
deep_core_type location of the core type, top or bottom, reference protocol for specifics
string
Enumeration:
  • top: top part of the core sample
  • bottom: bottom part of the core sample
  • unknownA: an unknown core sample(A)
  • unknownB: an unknown core sample(B)
pan weight of pan used to determine fresh / dry weight ratios, soil, Pan, soil moisture and organic matter.xlsx, pan wt
double gram
pan_plus_fw weight of pan and fresh subsample, soil, Pan_plus_FW, soil moisture and organic matter.xlsx, pan + fr soil
double gram
pan_plus_dw60 weight of pan and dry soil subsample dried at 60 deg Celsius, soil, Pan_plus_DW, soil moisture and organic matter.xlsx, pan + dry soil (60 degrees)
double gram
pan_plus_aw weight of pan and ashed soil subsample dried at 500 deg Celsius, soil moisture and organic matter.xlsx, pan + dry soil (500 degrees)
double gram
soil_n_fw freshweight of soil sample for N analyses, Avail N.xls, soil fr wt (g)
double gram
n_extract_volume volume of KCl extract (mL) for N analyses, hard code 40
integer milliliter
nh4_n raw NH4-N data from chromatograph (mg N/L,) soil, NH4_N_mg_l, Avail N.xls, NH4(ppm)
double milligramsPerLiter
no3_n raw NO3-N data from chromatograph (mg N/L), soil, NO3_N_mg_l, Avail N.xls, NO3(ppm)
double milligramsPerLiter
soil_p_fw freshweight of soil sample for P analyses, need to extract from data sheets for 2005, SRP analysis.xlsx, weight
double gram
p_extract_volume volume of NaHCO3 extract (mL) for P analysis, need to extract from data sheets for 2005, SRP analysis.xlsx, ExtractantVol(mL)
integer milliliter
po4_p raw PO4-P data from chromatograph (mg P/L) milligrams Per Liter, need to extract from data sheets for 2005, SRP analysis.xlsx, mg P/L
double milligramsPerLiter
percent_total_c percentage of total carbon, soilchemconc, Bot-/Top- PercTotalC, Total C and N.xls, % Total C
double dimensionless
percent_inorg_c percentage of inorganic carbon, soilchemconc, Bot-/Top- PercInorgC, Total C and N.xls, % Inorg C
double dimensionless
percent_total_n percentage of total nitrogen, soilchemconc, Bot-/Top- PercTotalN, Total C and N.xls, % Total N
double dimensionless

Tabular: 27_soil_texture_1.csv

Description: Soil Texture from 2000
Temporal Coverage: 1999-02-01 to 2000-05-17

Column Description Type Units
ID primary key
integer
analysis analysis date
datetime Format: MM/DD/YYYY
bottle_number bottle number
float
tube_number tube number
float
temperature initial temperature reading
float celsius
R05 hydrometer reading of soil solution at 30 seconds
float dimensionless
RL05 hydrometer reading of blank at 30 seconds
float dimensionless
R1 hydrometer reading of soil solution at 1 minute
float dimensionless
RL1 hydrometer reading of blank at 1 minute
float dimensionless
T1 temperature reading at 1 minute
float celsius
R90 hydrometer reading of soil solution at 90 minutes
float dimensionless
RL90 hydrometer reading of blank at 90 minutes
float dimensionless
T90 temperature reading at 90 minutes
float celsius
R1440 hydrometer reading of soil solution at 24 hours
float dimensionless
RL1440 hydrometer reading of blank at 24 hours
float dimensionless
T1440 temperature reading at 24 hours
float celsius
clay_percentOriginal Percent clay calculated according to the formula
float dimensionless
sand_percentOriginal Percent sand calculated according to the formula
float dimensionless
silt_percentOriginal Percent silt calculated according to the formula
float dimensionless
analystTech abbreviation for name of technician who did the the analysis
string
clayPercentCorrected Same as original, corrected when negative content was calculated in original
float dimensionless
sandPercentCorrected Same as original, corrected when negative content was calculated in original
float dimensionless
siltPercentCorrected Same as original, corrected when negative content was calculated in original
float dimensionless
notes addtional notes
string
sampling_year a year the sample was gathered
datetime Format: YYYY
site_id Unique numbers and letters identifying sites
string

Tabular: 27_soilchemconc_1.csv

Description: Chemical concentrations in soil samples for 2000
Temporal Coverage: 1999-02-01 to 2000-05-17

Column Description Type Units
sample_id table id representing each unique record
integer
site_id Unique numbers and letters used to identify the sites used in this study
string
sampling_year a year the sample was gathered
datetime Format: YYYY
BotPercTotalC bottom 20 cm of soil core percentage of total carbon
float dimensionless
BotPercInorgC bottom 20 cm of soil core percentage of inorganic carbon
float dimensionless
BotPercOrgC bottom 20 cm of soil core percentage of organic carbon
float dimensionless
BotPercTotalN bottom 20 cm of soil core percent of total nitrogen
float dimensionless
BotmgNH4kgsoil Ammonium concentration ( milligramsPerKilogram - mg/Kg ) in homogenized soil samples at 20-30 cm depth
float dimensionless
BotmgNO3kgsoil Nitrate concentration ( milligramsPerKilogram - mg/Kg ) in homogenized soil samples at 20-30 cm depth
float dimensionless
BotmgPperkgsoil bottom 20 cm of soil core milligram NaHCO3 extractable inorganic Phosporus per kilogram soil
float dimensionless
BotPercSOM bottom 20 cm of soil core percentage of soil organic matter
float dimensionless
TopPercTotalC top 10 cm of soil core percentage of total carbon
float dimensionless
TopPercInorgC top 10 cm of soil core percentage of inorganic carbon
float dimensionless
TopPercOrgC top 10 cm of soil core percentage of organic carbon
float dimensionless
TopPercTotalN top 10 cm of soil core percentage of total nitrogen
float dimensionless
TopmgNH4kgsoil Ammonium concentration ( milligramsPerKilogram - mg/Kg ) in homogenized soil samples at 10-20 cm depth
float dimensionless
TopmgNO3kgsoil Nitrate concentration ( milligramsPerKilogram - mg/Kg ) in homogenized soil samples at 10-20 cm depth
float dimensionless
TopmgPperkgsoil top 10 cm of soil core milligram NaHCO3 extractable inorganic Phosphorus per kilogram soil
float dimensionless
TopPercSOM top 10 cm of soil core percentage of soil organic matter
float dimensionless

Tabular: 27_soilchemmass_1.csv

Description: Chemicals in soil samples in gram per square meter for samples taken in 2000
Temporal Coverage: 1999-02-01 to 2000-05-17

Column Description Type Units
site_id Unique numbers and letters assigned to each site
string
BotTotalC bottom 20 cm of soil core total cabon per area soil surface
float gramsPerSquareMeter
BotInorgC bottom 20 cm of soil core inorganic carbon per area soil surface
float gramsPerSquareMeter
BotOrgCgm2 bottom 20 cm of soil core organic carbon per area soil surface
float gramsPerSquareMeter
BotTotalNgm2 bottom 20 cm of soil core total nitrogen per area soil surface
float gramsPerSquareMeter
BotExtractPgm2 bottom 20 cm of soil core NaHCO3 extractable inorganic Phosphorus per area soil surface
float gramsPerSquareMeter
BotOMgm2 bottom 20 cm of soil core organic matter per area soil surface
float gramsPerSquareMeter
BotorgCN bottom 20 cm of soil core organic carbon to nitrogen ratio
float dimensionless
TopTotalCgm2 top 10 cm of soil core total carbon per area soil surface
float gramsPerSquareMeter
TopInorgCgm2 top 10 cm of soil core inorganic carbon per area soil surface
float gramsPerSquareMeter
TopOrgCgm2 top 10 cm of soil core organic carbon per area soil surface
float gramsPerSquareMeter
TopTotalNgm2 top 10 cm of soil core total nitrogen per area soil surface
float gramsPerSquareMeter
TopPgm2 top 10 cm of soil core NaHCO3 extractable inorganic Phosphorus per area soil surface
float gramsPerSquareMeter
TopOMgm2 top 10 cm of soil core organic matter per area soil surface
float gramsPerSquareMeter
ToporgCN top 10 cm of soil core organic carbon to nitrogen ratio
float dimensionless

Tabular: 27_soilncphconduct_1.csv

Description: Soil conduction from 2000
Temporal Coverage: 1999-02-01 to 2000-05-17

Column Description Type Units
sample_id Sample id
integer
site_id Unique site ID
string
topNH4_N top NH4_N in mg N per kg soil
float dimensionless
topNO3_N top NO3_N in mg N per kg soil
float dimensionless
toppH pH value at the top of the soil
float dimensionless
topconductivity Conductivity at top of soil
float siemen
notes additional notes
string
bottomNH4_N bottom NH4_N in mg N per kg soil
float dimensionless
bottomNO3_N bottom NO3_N in mg N per kg soil
float dimensionless
bottompH pH value at the bottom of the soil
float dimensionless
bottomconductivity Conductivity at bottom of soil
float siemen
sample_year Year of sample observation
integer dimensionless
ph pH value of the soil
float dimensionless
conductivity Conductivity of soil
float siemen

Tabular: 27_sweepnet_1.csv

Description: arthropod counts collceted by sweepnet

Column Description Type Units
sweepnet_id Primary key for the data table sweepnet, unique identifier
integer
survey_id Sampling event unique identifier used to associate a sweepnet to a survey and other information
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id unique numbers and letters used to identify sites
string
sample_id Indentification number unique within each site
integer
display_name Arthropod Identification Name
string
notes Additional Notes
string

Tabular: 27_taxonlist_1.csv

Description: plant and mycorrhiza taxon lookup table

Column Description Type Units
taxon_id Unique numbers used to identify taxon
integer
lter_taxon_id Abbreviations used to identify taxon
string
scientific_name The species' scientific name
string
common_name Species' common name
string
taxonomic_family Species' family
string
genus Species' genus
string
species Species name
string
subspecies Subspecies name
string
origin Origin of the species
string
author Author of the name
string
curname Species' curname
string
type Type of plant the species is
string
native Whether the plant is native or not
string
asu_itis Interanlly used code
integer

Tabular: 27_traffic_type_1.csv

Description: Traffic

Column Description Type Units
survey_id Sampling event unique identifier used to associate a traffic_type to a survey and other information
integer
site_id Unique combinations of numbers and letters used to identify the sites used in this study
string
visit_id visit id, encypted date of visit MMDDYYYY
string
surround_traffic Type of street, road, highway, ect. present in or around the site
string
timestamp_val a record timestamp
datetime Format: YYYY-MM-DD hh:mm:ss

Tabular: 27_trees_1.csv

Description: Trees

Column Description Type Units
tree_id ID used to help identify them in the GIS dataset
integer
survey_id Unique identifier value for the sampling events
integer
plant_id ID used to help identify them in the GIS dataset
integer
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id unique numbers and letters used to identify the sites used in this study
string
tree_classification Classification of the type of the tree in relation to it's purpose within it's location
string
scientific_name Scientific name used to identify the species to the community.
string
tree_shape What shape the foliage is
string
stem_count Count of the tree's major stems
integer dimensionless
stem_diameter_at Where the stem diameter was measured
string
Enumeration:
  • DBH: diameter at breast height of 4.5 ft; measured in cm
  • DGH: diameter at ground height; measured if tree too small or stems too numerous at breast height
stem_diameter Measured diameter of the stems
float centimeter
height_distance Distance of the observer from the base of the tree trunk for clinometer measurement of height
float meter
height_degree_down Degree from the observer to the base of the tree
float degree
height_degree_up Degree from the observer to the top of the crown
float degree
height_in_m Height of the tree in meters
float meter
crown_width_ns crown's width measured north to south
float meter
crown_width_ew Crown's width measured east to west
float meter
crown_hight Crown's height
float meter
missing Number of missing branches
integer
condition The condition of the tree
string
Enumeration:
  • Excellent: Less than 1%
  • Excellent: 1 –10%
  • Fair: 11 – 25%
  • Poor: 26 – 50%
  • Critical: 51 – 75%
  • Dying: 76 – 99%
  • Dead: no leaves
distanceNS location of plant in distance from plot center north or south
float meter
directionNS Direction from plot center the plant located
string
Enumeration:
  • N: North
  • S: South
distanceEW location of plant in distance from plot center east or west
float meter
directionEW Direction from plot center the plant is located
string
Enumeration:
  • E: East
  • W: West
gps_id_2005 Identification number on the GPS used that day in 2005
integer
gps_id_2010 Identification number on the GPS used that day in 2010
integer
estimate Tells if the tree's height was found by estimation or direct measuring
string

Tabular: 27_weather_station_1.csv

Description: summary weather station data for each site and sampling event

Column Description Type Units
visit_id visit id, encrypted date of visit MMDDYYYY
string
site_id Unique numbers and letters used to identify the sites used in this study
string
survey_time Time the surveys started
datetime Format: HH:MM:SS AM/PM
th_index Heat index
float celsius
temperature Outside temperature
float celsius
wind_chill Wind Chill
float celsius
hi_temp Temperature high
float celsius
low_temp Low Temperature
float celsius
humidity Percent Humidity
float dimensionless
dew_point Dew Point
float dimensionless
wind_speed Average Wind Speed
float milesPerHour
hi_wind High wind
float milesPerHour
dir_wind WInd direction
string
Enumeration:
  • N: North
  • S: South
  • E: East
  • W: West
barometric Barometric Pressure
float millibar
date_data Date the data was taken
datetime Format: MM/DD/YYYY

Tabular: 27_weather_upload_1.csv

Description: raw data uploaded from the weather station logger

Column Description Type Units
survey_date Datas the measurements took place
datetime Format: MM/DD/YYYY
survey_time Time the measurements were started
datetime Format: HH:MM:SS AM/PM
th_index Heat Index
float celsius
temperature Average outside temperature
float celsius
wind_chill Wind Chill
float celsius
hi_temp High Temperature
float celsius
low_temp Low Temperature
float celsius
humidity Percent Humidity
float dimensionless
dew_point Dew Point
float dimensionless
wind_speed Average Wind Speed
float celsius
hi_wind Highest windspeed
float milesPerHour
dir_wind Wind Direction
string
Enumeration:
  • N: North
  • S: South
  • E: East
  • W: West
barometric Barometric Pressure
float celsius

Download EML Metadata for this data package