Introduction | Getting Started | Identifying a candidate L0 dataset | Understanding the L0 dataset | Resolving issues | Omitting rows | Omitting tables | Creating the Conversion Script | Basics | Do's | Don’ts | Resolving Issues in the L1 Tables | observation | event_id | datetime | taxon_id | variable_name | location | location_id | location_name | latitude and longitude | taxon | dataset_summary | observation_ancillary | location_ancillary | taxon_ancillary | variable_mapping | General Issues | Concepts | Levels of Observation | Determining the Meaningful Level of Observation | Using the Levels of Observation to assign location_id | Determining the Meaningful Level of Observation (Visual Examples) | Frequency of Survey | Determining the Frequency of Survey | Frequency of Survey (Visual Examples) | Value-Added Features | Ontologies and Vocabularies | Natural observation vs. experiment/manipulation | For annotation of metadata and use in the variable_mapping table | Deprecating an L1 Dataset

DwC-A Event Core

For archive in a data repository | Example function: | Example function call:

Contents | Table descriptions, relationships, and requirements | Overview | Tables | Table: observation | Columns | Table: location | Table: taxon | Table: dataset_summary | Table: observation_ancillary | Table: location_ancillary | Table: taxon_ancillary | Table: variable_mapping | | column name | type | not NULL required? | references | description | example ||---------------|----------|-----------------------|-------------------|--------------|---------|| variable_mapping_id | character |yes| NA | Identifier of the variable mapping information. | 1 || table_name | character |yes| NA | Name of the table containing this variable. | my_observation || variable_name | character |yes| /table/variable_name | Name of the measured variable in another table. | sample_z || mapped_system | character | no| NA | System defining variable_name. | NERC || mapped_id | character | no| NA | Identifier of the definition in mapped_system. | SDN:P07::CFSN0721 || mapped_label | character | no| NA | Label for variable_name in mapped_system. | depth | | Entity Relationship Diagram

Search | Read | Manipulate | Plot | Save