Data Table | Table Structure |
---|
Object Name: | location.csv | Size: | 69474 bytes | Authentication: | 1dc8ede59a9cf222bd713b23ceeb8ea4
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
| location_name
| latitude
| longitude
| elevation
| parent_location_id
| Definition: | Identifier assigned to each unique entry. | Sampling location full name. | Latitude of the sampling location in decimal degrees. Latitudes south of the equator are negative. | Longitude of the sampling location in decimal degrees. Longitudes west of the prime meridian are negative. | Sampling location elevation in meters relative to sea level. Above sea level is positive. Below sea level is negative. | Sampling location identifier from this table for the parent of this sampling location. Presence indicates nested locations. | External Measurement Definition, Link: | | | contains measurements of type latitude coordinate | contains measurements of type longitude coordinate | contains measurements of type elevation | | Storage Type: | string
| string
| float
| float
| float
| string
| Measurement Type: | nominal | nominal | ratio | ratio | ratio | nominal | Measurement Values Domain: | Definition | Identifier assigned to each unique entry. |
| Definition | Sampling location full name. |
| Unit | degree | Type | real | Min | 42.475 | Max | 42.475 |
| Unit | degree | Type | real | Min | -72.215 | Max | -72.215 |
| Unit | squareMeter | Type | natural | Min | 220 | Max | 220 |
| Definition | Sampling location identifier from this table for the parent of this sampling location. Presence indicates nested locations. |
| Missing Value Code: | | | | | | | Accuracy Report: | | | | | | | Accuracy Assessment: | | | | | | | Coverage: | | | | | | | Methods: | | | | | | |
|
Data Table | Table Structure |
---|
Object Name: | taxon.csv | Size: | 2788 bytes | Authentication: | 37fa3c5999fce02031b9f338b5b86127
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_rank
| taxon_name
| authority_system
| authority_taxon_id
| Definition: | Identifier used in the dataset. | Taxonomic rank of the organism name. | Taxonomic name of the organism. | Name of the system assigning the taxon identifier. | Identifier in the authority system. | Storage Type: | string
| string
| string
| string
| string
| Measurement Type: | nominal | nominal | nominal | nominal | nominal | Measurement Values Domain: | Definition | Identifier used in the dataset. |
| Definition | Taxonomic rank of the organism name. |
| Definition | Taxonomic name of the organism. |
| Definition | Name of the system assigning the taxon identifier. |
| Definition | Identifier in the authority system. |
| Missing Value Code: | | | | | | Accuracy Report: | | | | | | Accuracy Assessment: | | | | | | Coverage: | | | | | | Methods: | | | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/94/1/c5659950e47dde5476d1a49883b26328 | Name: | observation.csv | Description: | Core table holding the observations being analyzed (e.g. organism abundance, density, etc.). Observations are linked to a taxon and to a location. Linking to ancillary observations (via event_id) is optional, and event_id is required to be populated only if the observation_ancillary table is created. | Number of Records: | 2931 | Number of Columns: | 9 |
| Table Structure |
---|
Object Name: | observation.csv | Size: | 244066 bytes | Authentication: | ff66894f4772b62cdc1ee82e51bbc589
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
| event_id
| package_id
| location_id
| observation_datetime
| taxon_id
| variable_name
| value
| unit
| Definition: | A unique ID for this record. | The ID of the sampling event. References the event_id field of the observation_ancillary table, if this table exists. | The ID 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. | The taxon ID. References the taxon_id field of the taxon table. | Name of the measured variable. | Value of the measured variable. | Unit of the measured variable. | External Measurement Definition, Link: | | | | contains measurements of type study location identifier | | | contains measurements of type Measurement Type, is about individualCount | | | Storage Type: | string
| string
| string
| string
| date
| string
| string
| float
| string
| Measurement Type: | nominal | nominal | nominal | nominal | dateTime | nominal | nominal | ratio | nominal | Measurement Values Domain: | Definition | A unique ID for this record. |
| Definition | The ID of the sampling event. References the event_id field of the observation_ancillary table, if this table exists. |
| Definition | The ID 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 | The taxon ID. 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 |
| Definition | Unit of the measured variable. |
| Missing Value Code: | | | | | | | | | | Accuracy Report: | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | Coverage: | | | | | | | | | | Methods: | | | | | | | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/94/1/6a23437697d89ed7e87460e9e5cfa45e | Name: | location_ancillary.csv | Description: | Additional information about a place that does not change frequently, e.g., lake area or depth, experimental treatment. Features that change frequently are probably more closely related to the observational event, and so should be 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: | 1885 | Number of Columns: | 6 |
| Table Structure |
---|
Object Name: | location_ancillary.csv | Size: | 117063 bytes | Authentication: | fd192e4292a29779f835a23565563993
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
| datetime
| variable_name
| value
| unit
| Definition: | Identifier of the sampling location ancillary. | Identifier of the location for reference. | Date and time of the ancillary information. | Meaured variable. | Value of the measured variable. | Unit 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, is about Manipulative experiment | | | Storage Type: | string
| string
| date
| string
| string
| string
| Measurement Type: | nominal | nominal | dateTime | nominal | nominal | nominal | Measurement Values Domain: | Definition | Identifier of the sampling location ancillary. |
| Definition | Identifier of the location for reference. |
| Format | YYYY-MM-DD | Precision | |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | treatment | Definition | treatment type | Source | |
|
|
| Definition | Value of the measured variable. |
| Definition | Unit of the measured variable. |
| Missing Value Code: | | | | | | | Accuracy Report: | | | | | | | Accuracy Assessment: | | | | | | | Coverage: | | | | | | | Methods: | | | | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/94/1/de0fa7e610eb68f440a7a7755d19316b | Name: | taxon_ancillary.csv | Description: | Additional info about an organism that does not change frequently, e.g., trophic level. Features that change frequently are probably observations. Ancillary observations are linked through the taxon_id, and one taxon_id may have many ancillary observations about it. | Number of Records: | 742 | Number of Columns: | 7 |
| Table Structure |
---|
Object Name: | taxon_ancillary.csv | Size: | 40707 bytes | Authentication: | 40243f41aa1aef3f930ba0e762e49a04
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
| datetime
| variable_name
| value
| unit
| author
| Definition: | Identifier for the taxon ancillary. | The ID of the taxon table. References the taxon_id field of the taxon table. | Date and time of the ancillary information. | The measured variable. | Value for the measured variable. | Unit for the measured variable. | Author associated with taxon identification for this dataset. | External Measurement Definition, Link: | | | contains measurements of type date and time of measurement | contains measurements of type Measurement Type, is about measurementType, is about Population, is about behavior, is about type of habitat, is about references | | | contains measurements of type observer name | Storage Type: | string
| string
| date
| string
| string
| string
| string
| Measurement Type: | nominal | nominal | dateTime | nominal | nominal | nominal | nominal | Measurement Values Domain: | Definition | Identifier for the taxon ancillary. |
| Definition | The ID of the taxon table. References the taxon_id field of the taxon table. |
| Format | YYYY-MM-DD hh:mm:ss | Precision | |
| 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 | |
|
|
| Definition | Value for the measured variable. |
| Definition | Unit for the measured variable. |
| Definition | Author associated with taxon identification for this dataset. |
| Missing Value Code: | | | | | | | | Accuracy Report: | | | | | | | | Accuracy Assessment: | | | | | | | | Coverage: | | | | | | | | Methods: | | | | | | | |
|
Data Table | Table Structure |
---|
Object Name: | dataset_summary.csv | Size: | 217 bytes | Authentication: | 5adccdace117085892eeadca87b583c9
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
| original_package_id
| length_of_survey_years
| number_of_years_sampled
| std_dev_interval_betw_years
| max_num_taxa
| geo_extent_bounding_box_m2
| Definition: | ID of the level-1 data package (i.e. this data package). | ID of the level-0 data package (i.e. parent 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. | Area of the study location. | External Measurement Definition, Link: | | contains measurements of type data source | contains measurements of type number of years | contains measurements of type number of years | | | contains measurements of type Sampling Site Area | Storage Type: | string
| string
| float
| float
| float
| float
| float
| Measurement Type: | nominal | nominal | ratio | ratio | ratio | ratio | ratio | Measurement Values Domain: | Definition | ID of the level-1 data package (i.e. this data package). |
| Definition | ID of the level-0 data package (i.e. parent data package). |
| Unit | dimensionless | Type | natural | Min | 15 | Max | 15 |
| Unit | dimensionless | Type | natural | Min | 14 | Max | 14 |
| Unit | dimensionless | Type | real | Min | 0.08 | Max | 0.08 |
| Unit | dimensionless | Type | natural | Min | 53 | Max | 53 |
| Unit | meter | Type | natural | Min | 913451 | Max | 913451 |
| Missing Value Code: | | | | | | | | Accuracy Report: | | | | | | | | Accuracy Assessment: | | | | | | | | Coverage: | | | | | | | | Methods: | | | | | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/94/1/0ae037e0429b64e7212fe519d3147646 | Name: | variable_mapping.csv | Description: | Information linking a variable_name used in a data table to an external definition. This optional table holds mappings (or relations) between variable names in the data tables and measurement definitions external to the data package. This table has multiple uses: (1) provides definitions for variables in the datasets (more extensive than might be found in metadata), (2) code can use this table to to create EML code-definition pairs or annotations in metadata, (3) a single column in a data table may have mappings to multiple dictionaries, by including multiple rows for it | Number of Records: | 16 | Number of Columns: | 6 |
| Table Structure |
---|
Object Name: | variable_mapping.csv | Size: | 1867 bytes | Authentication: | 6a212995b234f7d89b36c806e08a2ece
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
| mapped_system
| mapped_id
| mapped_label
| Definition: | The ID of the variable mapping, a row or record identifier | The name of the table holding this variable. | The variable name in anothre data table. | System defining this variable_name. | ID of the definition in that system. | Label for this variable in that mapped system. | External Measurement Definition, Link: | | | contains measurements of type Measurement Type | | | | Storage Type: | string
| string
| string
| string
| string
| string
| Measurement Type: | nominal | nominal | nominal | nominal | nominal | nominal | Measurement Values Domain: | Definition | The ID of the variable mapping, a row or record identifier |
| Definition | The name of the table holding this variable. |
| Definition | The variable name in anothre data table. |
| Definition | System defining this variable_name. |
| Definition | ID of the definition in that system. |
| Definition | Label for this variable in that mapped system. |
| Missing Value Code: | | | | | | | Accuracy Report: | | | | | | | Accuracy Assessment: | | | | | | | Coverage: | | | | | | | Methods: | | | | | | |
|
Non-Categorized Data Resource
Non-Categorized Data Resource |