json_etn

{
  "profile": "tabular-data-package",
  "resources": [
    {
      "name": "animals",
      "path": "animals.csv",
      "profile": "tabular-data-resource",
      "encoding": "utf-8",
      "format": "csv",
      "schema": {
        "fields": [
          {
            "name": "animal_id",
            "type": "integer",
            "description": "Foreign Key linked to the Animal_ID"
          },
          {
            "name": "animal_project_code",
            "type": "string",
            "description": "Code of the animal project linked to this detection"
          },
          {
            "name": "tag_serial_number",
            "type": "integer"
          },
          {
            "name": "tag_type",
            "type": "string"
          },
          {
            "name": "tag_subtype",
            "type": "string"
          },
          {
            "name": "acoustic_tag_id",
            "type": "string"
          },
          {
            "name": "acoustic_tag_id_alternative",
            "type": "string"
          },
          {
            "name": "scientific_name",
            "type": "string",
            "description": "Scientific name of animal that carries the tag"
          },
          {
            "name": "common_name",
            "type": "string",
            "description": "The species' common English name"
          },
          {
            "name": "aphia_id",
            "type": "integer",
            "description": "The Aphia ID linked to the scientific name. The Aphia ID can be found at http://www.marinespecies.org/aphia.php?p=webservice"
          },
          {
            "name": "animal_label",
            "type": "string",
            "description": "Identification code that uniquely identifies each animal, as specified by the researcher"
          },
          {
            "name": "animal_nickname",
            "type": "string",
            "description": "Nickname given to the tagged animal"
          },
          {
            "name": "tagger",
            "type": "string",
            "description": "Person conducting tagging"
          },
          {
            "name": "capture_date_time",
            "type": "datetime",
            "description": "Date and time that animal was caught, in 24h UTC. Datetime fields should follow the ISO-8601 format"
          },
          {
            "name": "capture_location",
            "type": "string",
            "description": "Name of capture location. Please refer to a specific nearby point of land, town, island, or body of water that uniquely identifies this tagging location. Okay to leave blank if same as release location"
          },
          {
            "name": "capture_latitude",
            "type": "number",
            "description": "Latitude of capture location. Leave blank if same as release location. Note: in the southern hemisphere all latitudes must be negative"
          },
          {
            "name": "capture_longitude",
            "type": "number",
            "description": "Longitude of capture location. Leave blank if same as release location. Note: in the western hemisphere all longitudes must be negative"
          },
          {
            "name": "capture_method",
            "type": "string",
            "description": "Name of the method and materials used to capture animal"
          },
          {
            "name": "capture_depth",
            "type": "string",
            "description": "Water depth at which the animal was caught"
          },
          {
            "name": "capture_temperature_change",
            "type": "string",
            "description": "Difference between water temperature of the system where the fish was caught and the water temperature of the holding reservoir"
          },
          {
            "name": "release_date_time",
            "type": "datetime",
            "description": "Date and time that tagged animal was released, in UTC"
          },
          {
            "name": "release_location",
            "type": "string",
            "description": "Name of release location. Please refer to a specific nearby point of land, town, island, or body of water that uniquely identifies this tagging location"
          },
          {
            "name": "release_latitude",
            "type": "number",
            "description": "Latitude of release location. Note: in the southern hemisphere all latitudes must be negative"
          },
          {
            "name": "release_longitude",
            "type": "number",
            "description": "Longitude of release location. Note: in the western hemisphere all longitudes must be negative"
          },
          {
            "name": "recapture_date_time",
            "type": "datetime",
            "description": "If applicable, date of recapture of the tagged animal"
          },
          {
            "name": "length1_type",
            "type": "string",
            "description": "Specify type of length recorded (e.g. hood length, fork length, standard length, etc.)"
          },
          {
            "name": "length1",
            "type": "number",
            "description": "Length of animal that carries tag, depending on 'Length type', in units specified in 'Length units'"
          },
          {
            "name": "length1_unit",
            "type": "string",
            "description": "Units of lenght"
          },
          {
            "name": "length2_type",
            "type": "string",
            "description": "Specify type of secondary size measurement (e.g. width)"
          },
          {
            "name": "length2",
            "type": "number",
            "description": "Secondary length measurement, depending on 'Length2 type', in units specified in 'Length2 units'"
          },
          {
            "name": "length2_unit",
            "type": "string",
            "description": "Units of secondary length"
          },
          {
            "name": "length3_type",
            "type": "string",
            "description": "Specify type of tertiary size measurement (e.g. width)"
          },
          {
            "name": "length3",
            "type": "number",
            "description": "Tertiary length measurement, depending on 'Length3 type', in units specified in 'Length3 units'"
          },
          {
            "name": "length3_unit",
            "type": "string",
            "description": "Units of tertiary length"
          },
          {
            "name": "length4_type",
            "type": "string",
            "description": "Specify type of quaternary size measurement (e.g. width)"
          },
          {
            "name": "length4",
            "type": "number",
            "description": "Quaternary length measurement, depending on 'Length4 type', in units specified in 'Length4 units'"
          },
          {
            "name": "length4_unit",
            "type": "string",
            "description": "Units of quaternary length"
          },
          {
            "name": "weight",
            "type": "number",
            "description": "Weight of animal that carries tag, in units specified in 'Weight units'"
          },
          {
            "name": "weight_unit",
            "type": "string",
            "description": "Units of weight"
          },
          {
            "name": "age",
            "type": "number",
            "description": "Age of animal that carries tag, the units are specified in 'Age units'"
          },
          {
            "name": "age_unit",
            "type": "string",
            "description": "Units of age"
          },
          {
            "name": "sex",
            "type": "string",
            "description": "Sex of animal. "M" or "F". Can enter unknown ("U")"
          },
          {
            "name": "life_stage",
            "type": "string",
            "description": "Life stage of animal. This will depend on the species being studied and can be a standard code used for that species, a description, or both"
          },
          {
            "name": "wild_or_hatchery",
            "type": "string",
            "description": "Origin of animal that carries the tag. Enter "wild","hatchery" or "unknown""
          },
          {
            "name": "stock",
            "type": "string",
            "description": "Water body of origin. Can enter unknown or not applicable"
          },
          {
            "name": "surgery_date_time",
            "type": "datetime",
            "description": "Date that surgery was conducted. Date fields should follow the ISO-8601 format"
          },
          {
            "name": "surgery_location",
            "type": "string",
            "description": "	Short name of surgery location (i.e. hatchery name)"
          },
          {
            "name": "surgery_latitude",
            "type": "number",
            "description": "Latitude of surgery location. Note: in the southern hemisphere all latitudes must be negative"
          },
          {
            "name": "surgery_longitude",
            "type": "number",
            "description": "Longitude of surgery location. Note: in the western hemisphere all longitudes must be negative"
          },
          {
            "name": "treatment_type",
            "type": "string",
            "description": Contains a designation of treatment group as appropriate for the particular study. Researchers will have to contact the authors directly for definitions. Try to make these as clear as possible (e.g. use Control instead of C, Lake release instead of Lake)"
          },
          {
            "name": "tagging_type",
            "type": "string",
            "description": "Indicates how tag was attached to animal (e.g. "internal","external","oral","gastric","subcutaneous", etc.)"
          },
          {
            "name": "tagging_methodology",
            "type": "string",
            "description": "Describe method and materials used to attach tag to animal"
          },
          {
            "name": "dna_sample",
            "type": "string",
            "description": "Indicates whether the animal that carries the acoustic tag is also sampled for DNA"
          },
          {
            "name": "sedative",
            "type": "string",
            "description": "Name of sedative used if applicable"
          },
          {
            "name": "sedative_concentration",
            "type": "string",
            "description": "Concentration of sedative"
          },
          {
            "name": "anaesthetic",
            "type": "string",
            "description": "Name of anaesthetic used if applicable"
          },
          {
            "name": "buffer",
            "type": "string",
            "description": "Name of buffer used if applicable"
          },
          {
            "name": "anaesthetic_concentration",
            "type": "string",
            "description": "Concentration of anaesthetic"
          },
          {
            "name": "buffer_concentration_in_anaesthetic",
            "type": "string",
            "description": "Concentration of buffer in anaesthetic"
          },
          {
            "name": "anaesthetic_concentration_in_recirculation",
            "type": "string"
            "description": "Concentration of anaesthetic in recirculation bath"
          },
          {
            "name": "buffer_concentration_in_recirculation",
            "type": "string",
            "description": "Concentration of buffer in recirculation bath"
          },
          {
            "name": "dissolved_oxygen",
            "type": "string",
            "description": "This measure is the lowest oxygen level the fish will experience during the surgery"
          },
          {
            "name": "pre_surgery_holding_period",
            "type": "string",
            "description": "Time that animal is held prior to surgery"
          },
          {
            "name": "post_surgery_holding_period",
            "type": "string"
            "description": "Time the animal is held after surgery until release"
          },
          {
            "name": "holding_temperature",
            "type": "string",
            "description": "This measure is the highest or lowest water bath temperature the fish will experience during holding (depends if surgical water temperatures are increasing or decreasing relative to initial water temperature reading). For example, if tagging is being cond"
          },
          {
            "name": "comments",
            "type": "string",
            "description": "Any comments deemed to have scientific relevance by the tagger"
          }
        ],
        "primaryKey": "animal_id",
        "foreignKeys": [
          {
            "fields": "tag_serial_number",
            "reference": {
              "resource": "tags",
              "fields": "tag_serial_number"
            }
          }
        ]
      }
    },
    {
      "name": "tags",
      "path": "tags.csv",
      "profile": "tabular-data-resource",
      "format": "csv",
      "encoding": "utf-8",
      "schema": {
        "fields": [
          {
            "name": "tag_serial_number",
            "type": "integer"
          },
          {
            "name": "tag_type",
            "type": "string"
          },
          {
            "name": "tag_subtype",
            "type": "string"
          },
          {
            "name": "sensor_type",
            "type": "string",
            "description": "Type of tag sensor. Predefined options: "P","T" or "A". P = pressure, T = temperature, A = acceleration"
          },
          {
            "name": "acoustic_tag_id",
            "type": "string",
          },
          {
            "name": "acoustic_tag_id_alternative",
            "type": "string"
          },
          {
            "name": "manufacturer",
            "type": "string",
            "description": "Name of receiver manufacturer. Predefined options: "VEMCO","CHELONIA" or "THELMA BIOTEL""
          },
          {
            "name": "model",
            "type": "string",
          },
          {
            "name": "frequency",
            "type": "string",
            "description": "Frequency at which the tag emits a signal"
          },
          {
            "name": "status",
            "type": "string",
            "description": "Current status of the tag. Three options: "available","active" or "ended""
          },
          {
            "name": "activation_date",
            "type": "datetime",
            "description": "Date and time the tag was activated, in UTC"
          },
          {
            "name": "battery_estimated_life",
            "type": "string",
            "description": "Estimated duration of time during which the tag will be transmitting"
          },
          {
            "name": "battery_estimated_end_date",
            "type": "datetime",
            "description": "Estimated date at which tag will stop transmitting. Date fields should follow the ISO-8601 format"
          },
          {
            "name": "length",
            "type": "number",
          },
          {
            "name": "diameter",
            "type": "number"
          },
          {
            "name": "weight",
            "type": "number"
          },
          {
            "name": "floating",
            "type": "boolean"
          },
          {
            "name": "archive_memory",
            "type": "string"
          },
          {
            "name": "sensor_slope",
            "type": "number",
            "description": "Raw value of slope, as used for sensor calibration"
          },
          {
            "name": "sensor_intercept",
            "type": "number",
            "description": "Raw value of intercept, as used for sensor calibration"
          },
          {
            "name": "sensor_range",
            "type": "string",
            "description": "Maximum range of sensor"
          },
          {
            "name": "sensor_range_min",
            "type": "integer"
          },
          {
            "name": "sensor_range_max",
            "type": "integer"
          },
          {
            "name": "sensor_resolution",
            "type": "number"
          },
          {
            "name": "sensor_unit",
            "type": "string",
            "description": "Unit of measured sensor value"
          },
          {
            "name": "sensor_accuracy",
            "type": "number",
          },
          {
            "name": "sensor_transmit_ratio",
            "type": "integer",
            "description": "Ratio of transmission between sensors present. If for example both a T and P sensor are present and T transmits twice as often as P, the range is 2 to 1"
          },
          {
            "name": "accelerometer_algorithm",
            "type": "string",
            "description": "There are two possible modes of operation of the accelerometer algorithm: Activity or Tailbeat"
          },
          {
            "name": "accelerometer_samples_per_second",
            "type": "number"
          },
          {
            "name": "owner_organization",
            "type": "string"
          },
          {
            "name": "owner_pi",
            "type": "string"
          },
          {
            "name": "financing_project",
            "type": "string"
          },
          {
            "name": "step1_min_delay",
            "type": "string"
          },
          {
            "name": "step1_max_delay",
            "type": "string"
          },
          {
            "name": "step1_power",
            "type": "string"
          },
          {
            "name": "step1_duration",
            "type": "integer"
          },
          {
            "name": "step1_acceleration_duration",
            "type": "integer"
          },
          {
            "name": "step2_min_delay",
            "type": "string"
          },
          {
            "name": "step2_max_delay",
            "type": "string"
          },
          {
            "name": "step2_power",
            "type": "string"
          },
          {
            "name": "step2_duration",
            "type": "integer"
          },
          {
            "name": "step2_acceleration_duration",
            "type": "integer"
          },
          {
            "name": "step3_min_delay",
            "type": "string"
          },
          {
            "name": "step3_max_delay",
            "type": "string"
          },
          {
            "name": "step3_power",
            "type": "string"
          },
          {
            "name": "step3_duration",
            "type": "integer"
          },
          {
            "name": "step3_acceleration_duration",
            "type": "integer"
          },
          {
            "name": "step4_min_delay",
            "type": "string"
          },
          {
            "name": "step4_max_delay",
            "type": "string"
          },
          {
            "name": "step4_power",
            "type": "string"
          },
          {
            "name": "step4_duration",
            "type": "integer"
          },
          {
            "name": "step4_acceleration_duration",
            "type": "integer"
          },
          {
            "name": "tag_id",
            "type": "string"
          },
          {
            "name": "tag_device_id",
            "type": "integer"
          }
        ],
        "primaryKey": "tag_id"
      }
    },
    {
      "name": "detections",
      "path": "detections.csv",
      "profile": "tabular-data-resource",
      "format": "csv",
      "encoding": "utf-8",
      "schema": {
        "fields": [
          {
            "name": "detection_id",
            "type": "integer"
          },
          {
            "name": "date_time",
            "type": "datetime"
          },
          {
            "name": "tag_serial_number",
            "type": "integer"
          },
          {
            "name": "acoustic_tag_id",
            "type": "string"
          },
          {
            "name": "animal_project_code",
            "type": "string"
          },
          {
            "name": "animal_id",
            "type": "integer"
          },
          {
            "name": "scientific_name",
            "type": "string"
          },
          {
            "name": "acoustic_project_code",
            "type": "string"
          },
          {
            "name": "receiver_id",
            "type": "string"
          },
          {
            "name": "station_name",
            "type": "string"
          },
          {
            "name": "deploy_latitude",
            "type": "number"
          },
          {
            "name": "deploy_longitude",
            "type": "number"
          },
          {
            "name": "depth_in_meters",
            "type": "number"
          },
          {
            "name": "sensor_value",
            "type": "number"
          },
          {
            "name": "sensor_unit",
            "type": "string"
          },
          {
            "name": "sensor2_value",
            "type": "number"
          },
          {
            "name": "sensor2_unit",
            "type": "number"
          },
          {
            "name": "signal_to_noise_ratio",
            "type": "integer"
          },
          {
            "name": "source_file",
            "type": "string"
          },
          {
            "name": "qc_flag",
            "type": "boolean"
          },
          {
            "name": "deployment_id",
            "type": "integer"
          }
        ],
        "primaryKey": "detection_id",
        "foreignKeys": [
          {
            "fields": "receiver_id",
            "reference": {
              "resource": "receivers",
              "fields": "receiver_id"
            }
          },
          {
            "fields": "acoustic_tag_id",
            "reference": {
              "resource": "tags",
              "fields": "acoustic_tag_id"
            }
          },
          {
            "fields": "animal_id",
            "reference": {
              "resource": "animals",
              "fields": "animal_id"
            }
          },
          {
            "fields": "deployment_id",
            "reference": {
              "resource": "deployments",
              "fields": "deployment_id"
            }
          }
        ]
      }
    },
    {
      "name": "deployments",
      "path": "deployments.csv",
      "profile": "tabular-data-resource",
      "format": "csv",
      "encoding": "utf-8",
      "schema": {
        "fields": [
          {
            "name": "deployment_id",
            "type": "integer"
          },
          {
            "name": "receiver_id",
            "type": "string"
          },
          {
            "name": "acoustic_project_code",
            "type": "string"
          },
          {
            "name": "station_name",
            "type": "string"
          },
          {
            "name": "station_description",
            "type": "string"
          },
          {
            "name": "station_manager",
            "type": "string"
          },
          {
            "name": "deploy_date_time",
            "type": "datetime"
          },
          {
            "name": "deploy_latitude",
            "type": "number"
          },
          {
            "name": "deploy_longitude",
            "type": "number"
          },
          {
            "name": "intended_latitude",
            "type": "number"
          },
          {
            "name": "intended_longitude",
            "type": "number"
          },
          {
            "name": "mooring_type",
            "type": "string"
          },
          {
            "name": "bottom_depth",
            "type": "string"
          },
          {
            "name": "riser_length",
            "type": "string"
          },
          {
            "name": "deploy_depth",
            "type": "string"
          },
          {
            "name": "battery_installation_date",
            "type": "datetime"
          },
          {
            "name": "battery_estimated_end_date",
            "type": "datetime"
          },
          {
            "name": "activation_date_time",
            "type": "datetime"
          },
          {
            "name": "recover_date_time",
            "type": "datetime"
          },
          {
            "name": "recover_latitude",
            "type": "number"
          },
          {
            "name": "recover_longitude",
            "type": "number"
          },
          {
            "name": "download_date_time",
            "type": "datetime"
          },
          {
            "name": "download_file_name",
            "type": "string"
          },
          {
            "name": "valid_data_until_date_time",
            "type": "datetime"
          },
          {
            "name": "sync_date_time",
            "type": "datetime"
          },
          {
            "name": "time_drift",
            "type": "string"
          },
          {
            "name": "ar_battery_installation_date",
            "type": "datetime"
          },
          {
            "name": "ar_confirm",
            "type": "string"
          },
          {
            "name": "transmit_profile",
            "type": "string"
          },
          {
            "name": "transmit_power_output",
            "type": "string"
          },
          {
            "name": "log_temperature_stats_period",
            "type": "integer"
          },
          {
            "name": "log_temperature_sample_period",
            "type": "integer"
          },
          {
            "name": "log_tilt_sample_period",
            "type": "integer"
          },
          {
            "name": "log_noise_stats_period",
            "type": "integer"
          },
          {
            "name": "log_noise_sample_period",
            "type": "integer"
          },
          {
            "name": "log_depth_stats_period",
            "type": "integer"
          },
          {
            "name": "log_depth_sample_period",
            "type": "integer"
          },
          {
            "name": "comments",
            "type": "string"
          }
        ],
        "primaryKey": "deployment_id",
        "foreignKeys": [
          {
            "fields": "receiver_id",
            "reference": {
              "resource": "receivers",
              "fields": "receiver_id"
            }
          }
        ]
      }
    },
    {
      "name": "receivers",
      "path": "receivers.csv",
      "profile": "tabular-data-resource",
      "format": "csv",
      "encoding": "utf-8",
      "schema": {
        "fields": [
          {
            "name": "receiver_id",
            "type": "string"
          },
          {
            "name": "manufacturer",
            "type": "string"
          },
          {
            "name": "receiver_model",
            "type": "string"
          },
          {
            "name": "receiver_serial_number",
            "type": "string"
          },
          {
            "name": "modem_address",
            "type": "string"
          },
          {
            "name": "status",
            "type": "string"
          },
          {
            "name": "battery_estimated_life",
            "type": "string"
          },
          {
            "name": "owner_organization",
            "type": "string"
          },
          {
            "name": "financing_project",
            "type": "string"
          },
          {
            "name": "built_in_acoustic_tag_id",
            "type": "string"
          },
          {
            "name": "ar_model",
            "type": "string"
          },
          {
            "name": "ar_serial_number",
            "type": "string"
          },
          {
            "name": "ar_battery_estimated_life",
            "type": "string"
          },
          {
            "name": "ar_voltage_at_deploy",
            "type": "string"
          },
          {
            "name": "ar_interrogate_code",
            "type": "string"
          },
          {
            "name": "ar_receive_frequency",
            "type": "string"
          },
          {
            "name": "ar_reply_frequency",
            "type": "string"
          },
          {
            "name": "ar_ping_rate",
            "type": "string"
          },
          {
            "name": "ar_enable_code_address",
            "type": "string"
          },
          {
            "name": "ar_release_code",
            "type": "string"
          },
          {
            "name": "ar_disable_code",
            "type": "string"
          },
          {
            "name": "ar_tilt_code",
            "type": "string"
          },
          {
            "name": "ar_tilt_after_deploy",
            "type": "string"
          }
        ],
        "primaryKey": "receiver_id"
      }
    }
  ]
}