Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/193/4/e09491aee3bd9ec02e805ffdac0beb12 | Name: | observation | Description: | This is the core table, which holds the observations being analyzed, eg, organism abundance or density. Observations must be linked to a taxon and to a location. Linking to ancillary observations (via observation_id) is optional. The event_id column is a placeholder, as we are considering a structure to model sampling events in the future. | Number of Records: | 2931 | Number of Columns: | 7 |
| Table Structure |
---|
Object Name: | observation.csv | Size: | 125975 bytes | Authentication: | c60115954464b0db7393259ef2472dfe
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | | | | | | |
---|
Column Name: | observation_id
| package_id
| location_id
| datetime
| taxon_id
| variable_name
| value
| Definition: | Identifier assigned to each unique observation. | Identifier of this data package. References the package_id field of the dataset_summary table. | A reference to a location. References the location_id field of the location table. | Date and time of the observation. | A reference to a taxon. References the taxon_id field of the taxon table. | Name of the measured variable. | Value of the measured variable. | External Measurement Definition, Link: | | | contains measurements of type study location identifier | contains measurements of type date and time of measurement | | contains measurements of type Measurement Type | | Storage Type: | string
| string
| string
| date
| string
| string
| float
| Measurement Type: | nominal | nominal | nominal | dateTime | nominal | nominal | ratio | Measurement Values Domain: | Definition | Identifier assigned to each unique observation. |
| Definition | Identifier of this data package. References the package_id field of the dataset_summary table. |
| Definition | A reference to a location. References the location_id field of the location table. |
| Format | YYYY-MM-DD | Precision | |
| Definition | A reference to a taxon. References the taxon_id field of the taxon table. |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | abundance | Definition | how many | Source | |
|
|
| Unit | dimensionless | Type | natural | Min | 1 | Max | 96 |
| Missing Value Code: | | | | | | | | Accuracy Report: | | | | | | | | Accuracy Assessment: | | | | | | | | Coverage: | | | | | | | | Methods: | | | | | | | |
|
Data Table | Table Structure |
---|
Object Name: | observation_ancillary.csv | Size: | 147289 bytes | Authentication: | 53ebc79bb2997a98f2f68d4fb462bbc7
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | | | |
---|
Column Name: | observation_ancillary_id
| observation_id
| variable_name
| value
| Definition: | Identifier of the observation ancillary information. | A reference to an observation. References the observation_id field of the observation table. | Name of the measured variable. | Value of the measured variable. | External Measurement Definition, Link: | | | contains measurements of type Measurement Type | | Storage Type: | string
| string
| string
| string
| Measurement Type: | nominal | nominal | nominal | nominal | Measurement Values Domain: | Definition | Identifier of the observation ancillary information. |
| Definition | A reference to an observation. References the observation_id field of the observation table. |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | trap.type | Definition | trap type | Source | |
| Code Definition | Code | trap.num | Definition | applies only to pitfall cups | Source | |
|
|
| Definition | Value of the measured variable. |
| Missing Value Code: | | | | | Accuracy Report: | | | | | Accuracy Assessment: | | | | | Coverage: | | | | | Methods: | | | | |
|
Data Table | Table Structure |
---|
Object Name: | location.csv | Size: | 45 bytes | Authentication: | 3b94b87b8e417e26c0f62d30b3189536
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | |
---|
Column Name: | location_id
| Definition: | Identifier assigned to each unique location. | External Measurement Definition, Link: | contains measurements of type study location identifier | Storage Type: | string
| Measurement Type: | nominal | Measurement Values Domain: | Definition | Identifier assigned to each unique location. |
| Missing Value Code: | | Accuracy Report: | | Accuracy Assessment: | | Coverage: | | Methods: | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/193/4/b49b65c5350c1fd5875236e399470db4 | Name: | location_ancillary | Description: | Additional information about a place that does not change frequently (e.g. lake area or depth, experimental treatment). Features that change frequently are more closely related to the observational event, and are thus kept in the observation_ancillary table. Ancillary observations are linked through the location_id, and one location_id may have many ancillary observations about it. | Number of Records: | 32 | Number of Columns: | 4 |
| Table Structure |
---|
Object Name: | location_ancillary.csv | Size: | 842 bytes | Authentication: | c8cd8d19fec41651b8d3c4271f88cce2
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | | | |
---|
Column Name: | location_ancillary_id
| location_id
| variable_name
| value
| Definition: | Identifier of the location ancillary information. | A reference to a location. References the location_id field of the location table. | Name of the measured variable. | Value of the measured variable. | External Measurement Definition, Link: | | contains measurements of type study location identifier | contains measurements of type Measurement Type | | Storage Type: | string
| string
| string
| string
| Measurement Type: | nominal | nominal | nominal | nominal | Measurement Values Domain: | Definition | Identifier of the location ancillary information. |
| Definition | A reference to a location. References the location_id field of the location table. |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | moose.cage | Definition | treatment type | Source | |
| Code Definition | Code | treatment | Definition | location of grid with respect to moose exclosure | Source | |
|
|
| Definition | Value of the measured variable. |
| Missing Value Code: | | | | | Accuracy Report: | | | | | Accuracy Assessment: | | | | | Coverage: | | | | | Methods: | | | | |
|
Data Table | Table Structure |
---|
Object Name: | taxon.csv | Size: | 1250 bytes | Authentication: | b7ff89572967226a275d673575d7499b
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | |
---|
Column Name: | taxon_id
| taxon_name
| Definition: | Identifier assigned to each unique organism. | Taxonomic name of the organism. | External Measurement Definition, Link: | | contains measurements of type taxonomic classification | Storage Type: | string
| string
| Measurement Type: | nominal | nominal | Measurement Values Domain: | Definition | Identifier assigned to each unique organism. |
| Definition | Taxonomic name of the organism. |
| Missing Value Code: | | | Accuracy Report: | | | Accuracy Assessment: | | | Coverage: | | | Methods: | | |
|
Data Table | Table Structure |
---|
Object Name: | taxon_ancillary.csv | Size: | 20812 bytes | Authentication: | 7815d0cd181734deac82cf61032d0afd
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | | | |
---|
Column Name: | taxon_ancillary_id
| taxon_id
| variable_name
| value
| Definition: | Identifier of the taxon ancillary information. | A reference to a taxon. References the taxon_id field of the taxon table. | Name of the measured variable. | Value of the measured variable. | External Measurement Definition, Link: | | | contains measurements of type Measurement Type | | Storage Type: | string
| string
| string
| string
| Measurement Type: | nominal | nominal | nominal | nominal | Measurement Values Domain: | Definition | Identifier of the taxon ancillary information. |
| Definition | A reference to a taxon. References the taxon_id field of the taxon table. |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | subfamily | Definition | ant subfamily | Source | |
| Code Definition | Code | hl | Definition | head length. We used trait definitions from Del Toro et al. (2015) and
filled in missing species’ data with information from Ellison et al. | Source | |
| Code Definition | Code | rel | Definition | eye length relative to body size | Source | |
| Code Definition | Code | rll | Definition | femur length relative to body size | Source | |
| Code Definition | Code | colony.size | Definition | size of colony for each species | Source | |
| Code Definition | Code | feeding.preference | Definition | feeding preference for each species | Source | |
| Code Definition | Code | nest.substrate | Definition | nest substrate | Source | |
| Code Definition | Code | primary.habitat | Definition | primary habitat | Source | |
| Code Definition | Code | secondary.habitat | Definition | secondary habitat associations | Source | |
| Code Definition | Code | seed.disperser | Definition | whether or not a seed dispersing species | Source | |
| Code Definition | Code | slavemaker.sp | Definition | whether or not a slavemaking species | Source | |
| Code Definition | Code | behavior | Definition | classifications based on behavioral interactions with other
ants | Source | |
| Code Definition | Code | biogeographic.affinity | Definition | biogeographic affinity based on available occurrence
records | Source | |
| Code Definition | Code | source | Definition | where trait information was found. Full citations for literature are as follows: Del Toro, I., R.R. Silva, and A.M. Ellison. 2015. Predicated impacts of climatic change on ant functional diversity and distributions in eastern North American forests. Diversity and Distributions 21:781-791; Ellison, A.M., N.J. Gotelli, G. Alpert, and E.J. Farnsworth. 2012. A field guide to the ants of New England. Yale University Press, New Haven, Connecticut, USA. | Source | |
|
|
| Definition | Value of the measured variable. |
| Missing Value Code: | | | | | Accuracy Report: | | | | | Accuracy Assessment: | | | | | Coverage: | | | | | Methods: | | | | |
|
Data Table | Table Structure |
---|
Object Name: | dataset_summary.csv | Size: | 125 bytes | Authentication: | bffb310a03ecf700aeeea6d78fdd9945
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | | | | |
---|
Column Name: | package_id
| length_of_survey_years
| number_of_years_sampled
| std_dev_interval_betw_years
| max_num_taxa
| Definition: | Identifier of this data package. | Number of years the study has been ongoing. | Number of years within the period of the study that samples were taken. | Standard deviation of the interval between sampling events. | Number of unique values in the taxon table. | External Measurement Definition, Link: | | contains measurements of type number of years | contains measurements of type number of years | | | Storage Type: | string
| float
| float
| float
| float
| Measurement Type: | nominal | ratio | ratio | ratio | ratio | Measurement Values Domain: | Definition | Identifier of this data package. |
| Unit | nominalYear | Type | natural | Min | 15 | Max | 15 |
| Unit | nominalYear | Type | natural | Min | 14 | Max | 14 |
| Unit | nominalYear | Type | real | Min | 0.67 | Max | 0.67 |
| Unit | number | Type | natural | Min | 53 | Max | 53 |
| Missing Value Code: | | | | | | Accuracy Report: | | | | | | Accuracy Assessment: | | | | | | Coverage: | | | | | | Methods: | | | | | |
|
Data Table | Table Structure |
---|
Object Name: | variable_mapping.csv | Size: | 650 bytes | Authentication: | de42c56e1f9c9e4222ef2d5b11b5202c
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \r\n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | | |
---|
Column Name: | variable_mapping_id
| table_name
| variable_name
| Definition: | Identifier of the variable mapping information. | Name of the table containing this variable. | Name of the measured variable. | External Measurement Definition, Link: | | | contains measurements of type Measurement Type | Storage Type: | string
| string
| string
| Measurement Type: | nominal | nominal | nominal | Measurement Values Domain: | Definition | Identifier of the variable mapping information. |
| Definition | Name of the table containing this variable. |
| Definition | Name of the measured variable. |
| Missing Value Code: | | | | Accuracy Report: | | | | Accuracy Assessment: | | | | Coverage: | | | | Methods: | | | |
|
Non-Categorized Data Resource |