Survey 200 long term study of multiple sites in central Arizona-Phoenix
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:
Temporal Coverage:
1999-02-01 to 2010-06-21Geographic Coverage:
Geographic Description: Phoenix metropolitan area in Arizona, USABounding 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:
|
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:
|
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:
|
gps_id_2010 | Internal gps ID |
integer | |
estimate | How the measurements were found |
string |
Enumeration:
|
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:
|
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:
|
classify | Classification of the location of the
plant |
string |
Enumeration:
|
gps_id_2005 | Internal gps ID |
integer | |
estimate | How the measurements were found |
string |
Enumeration:
|
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:
|
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:
|
no_individuals | Number of individual plants in hedge |
integer | |
classify | What type of use it is surving |
string |
Enumeration:
|
distanceNS | location of plant in distance from plot center north or
south |
float | centimeter |
directionNS | Direction from plot center the plant
located |
string |
Enumeration:
|
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:
|
estimate | How the measurements were determined |
string |
Enumeration:
|
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:
|
no_individuals | Number of individual plants in hedge |
integer | |
classify | What type of use it is surving |
string |
Enumeration:
|
distanceNS | location of plant in distance from plot center north or
south |
float | centimeter |
directionNS | Direction from plot center the plant
located |
string |
Enumeration:
|
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:
|
estimate | How the measurements were determined |
string |
Enumeration:
|
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:
|
water_drip_ap | Drip irrigation application |
bit |
Enumeration:
|
water_overhead_ap | Overhead application |
bit |
Enumeration:
|
perc_imperv_irrigated | Percent of pervious land that is
irrigated |
integer | dimensionless |
type_soil_ap | bare soil present in plot |
bit |
Enumeration:
|
type_trees_ap | Trees present in plot |
bit |
Enumeration:
|
type_shrubs_ap | Shrubs present in plot |
bit |
Enumeration:
|
type_cact_succ_ap | Cacti and succulents present in plot |
bit |
Enumeration:
|
type_lawn_ap | Lawn present in plot |
bit |
Enumeration:
|
type_herb_ground_ap | Hebatious present in plot |
bit |
Enumeration:
|
type_other_ap | other surfaces/covers present in plot |
bit |
Enumeration:
|
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:
|
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:
|
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:
|
water_feature | yard characteristics, was there a water feature (e.g. fountain) found on the parcel, subject discovery |
boolean |
Enumeration:
|
porch_patio | yard characteristics, was there a front porch or patio found on the parcel, subject discovery |
boolean |
Enumeration:
|
cats | yard characteristics, were there cats found on the parcel, subject discovery |
boolean |
Enumeration:
|
dogs | yard characteristics, were there dogs found on the parcel, subject discovery |
boolean |
Enumeration:
|
pet_waste | yard characteristics, was there pet or other animal waste found on the parcel, subject discovery |
boolean |
Enumeration:
|
statues | yard characteristics, were there religious ornaments or statues found on the parcel, subject discovery |
boolean |
Enumeration:
|
flagpole | yard characteristics, was there a flag poie(s) found on the parcel, subject discovery |
boolean |
Enumeration:
|
cars_yard | yard characteristics, were there cars in the yard found on the parcel, subject discovery |
boolean |
Enumeration:
|
potted_plant | yard characteristics, were there potted plants found on the parcel, subject discovery |
boolean |
Enumeration:
|
play_equip | yard characteristics, was there play equipment found on the parcel, subject discovery |
boolean |
Enumeration:
|
lawn_ornaments | yard characteristics, was there lawn ornaments found on the parcel, subject discovery |
boolean |
Enumeration:
|
furniture | yard characteristics, was there furniture found on the parcel, subject discovery |
boolean |
Enumeration:
|
river_bed | yard characteristics, was there a landscaped (rock) river bed found on the parcel, subject discovery |
boolean |
Enumeration:
|
yard_topography | yard characteristics, was there created yard topography found on the parcel, subject discovery |
boolean |
Enumeration:
|
litter | yard characteristics, was there litter (refuse on ground, etc) found on the parcel, subject discovery |
boolean |
Enumeration:
|
veg_litter | yard characteristics, was there vegetation litter (leaves, etc) found on the parcel, subject discovery |
boolean |
Enumeration:
|
yard_tools | yard characteristics, was there yard maintenance tools found on the parcel, subject discovery |
boolean |
Enumeration:
|
light_post | yard characteristics, was there a light post(s) found on the parcel, subject discovery |
boolean |
Enumeration:
|
other | yard characteristics, was there any other subject found on the parcel, subject discovery |
boolean |
Enumeration:
|
feature_comments | other yard characteristics noted during time of observation |
string | |
irrigation_flood | yard characteristics, flood irrigation system found within the parcel |
boolean |
Enumeration:
|
irrigation_drip | yard characteristics, drip irrigation system found within the parcel |
boolean |
Enumeration:
|
irrigation_hose | yard characteristics, hose irrigation system found within the parcel |
boolean |
Enumeration:
|
irrigation_sprinklers | yard characteristics, sprinklers irrigation system found within the parcel |
boolean |
Enumeration:
|
landsc_type | yard characteristics, landscape type |
integer |
Enumeration:
|
amount_grass | yard characteristics, amount of parcel clovered by grass |
string |
Enumeration:
|
weeds_grass | yard characteristics, % % weeds in GRASS areas found on the parcel |
integer |
Enumeration:
|
weeds_xeric | yard characteristics, % in NON-GRASS/XERIC areas found on the parcel |
integer |
Enumeration:
|
weeds_other | yard characteristics, weeds in other areas of yard (e.g. flower beds, driveway, etc) |
boolean |
Enumeration:
|
pruning_trees | yard characteristics, tree pruning (cut branches) |
string |
Enumeration:
|
pruning_shrubs | yard characteristics, shrub pruning (shaped shrubs) |
string |
Enumeration:
|
grass_patchiness | Grass patchiness (patch = at least 5% of grass area) |
integer |
Enumeration:
|
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:
|
lawn_quality | Overall Lawn quality Measure (1-10) |
integer |
Enumeration:
|
lawn_trimmed | Lawn edges trimmed |
integer |
Enumeration:
|
recent_cut | Recently Mowed |
integer |
Enumeration:
|
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:
|
cover_trees | , following new protocol, data type change required |
boolean |
Enumeration:
|
cover_shrubs | , following new protocol, data type change required |
boolean |
Enumeration:
|
cover_cacti_succ | , following new protocol, data type change required |
boolean |
Enumeration:
|
cover_lawn | , following new protocol, data type change required |
boolean |
Enumeration:
|
cover_herbacous_ground | , following new protocol, data type change required |
boolean |
Enumeration:
|
cover_other | , following new protocol, data type change required |
boolean |
Enumeration:
|
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:
|
water_drip | , following new protocol, data type change required |
boolean |
Enumeration:
|
water_overhead | , following new protocol, data type change required |
boolean |
Enumeration:
|
water_flood | , following new protocol, data type change required |
boolean |
Enumeration:
|
water_none | , following new protocol, data type change required |
boolean |
Enumeration:
|
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:
|
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:
|
classify | Classification of plant use |
string |
Enumeration:
|
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:
|
siteID | site id |
string | |
Layer | top or bottom 10 cm of the 1 inch soil
core |
string |
Enumeration:
|
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:
|
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:
|
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:
|
distanceNS | location of plant in distance from plot center north or
south |
float | meter |
directionNS | Direction from plot center the plant
located |
string |
Enumeration:
|
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:
|
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:
|
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:
|
barometric | Barometric Pressure |
float | celsius |