Baselight
Sign In

Assessing Tree Health And Stability

Insights into Different Tree Species

@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor

Loading...
Loading...

About this Dataset

Assessing Tree Health And Stability

Assessing Tree Health and Stability

Insights into Different Tree Species

By [source]

About this dataset

This comprehensive dataset was compiled to capture comprehensive quantitative insights into the health, stability, and compliance of different tree species. The dataset includes cumulative data from sensors deployed on trees in various slopes across the world over a period of time. It offers an extensive view of important variables including slope IDs, tree IDs, status, rawx-rawz readings and more. Such detail enables users to identify patterns in key components that may help increase the accuracy of future analyses. Furthermore, this dataset also contains information regarding tasks performed such as start and finish times, events on trees and much more! Such information provides valuable insights for policy makers aiming to safeguard our biodiversity from increasing degradation trends that are being observed across the globe. Using this detailed dataset will allow researchers to explore new ways for monitoring critical ecosystems for better management in a timely fashion

More Datasets

For more datasets, click here.

Featured Notebooks

  • 🚨 Your notebook can be here! 🚨!

How to use the dataset

This guide will walk you through how to use this dataset for all your tree-sensor related needs so you can be informed about any changes or updates to a particular tree species’ health or stability. Let’s get started!

Research Ideas

  • To analyze tree health over an extended period of time, compare cumulative data from sensors and track trends in different slopes for different tree species.
  • Using sensor readouts to predict the stability and longevity of certain trees by looking at changes in the cumulative data over time.
  • To monitor compliance with environmental regulations by tracking sensor readings to monitor tree health and stability for particular areas or regions

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: CumulativeDailyWarning.csv

Column name Description
Date compared Date when the data was compared. (Date)
Date assessed Date when the data was assessed. (Date)
Status (in Order / follow-up Status of the tree in order or follow-up. (String)

File: DataCumulated2.csv

Column name Description
rs2Time Time of the sensor reading. (DateTime)
rs2Mean Mean of the sensor readings. (Float)
rs2STD Standard deviation of the sensor readings. (Float)
rs2ComX X-axis component of the sensor readings. (Float)
rs2ComY Y-axis component of the sensor readings. (Float)
rs2ComZ Z-axis component of the sensor readings. (Float)
rawx Raw x-axis readings from the sensor. (Float)
rawy Raw y-axis readings from the sensor. (Float)
rawz Raw z-axis readings from the sensor. (Float)

File: DataCumulatedFlex2.csv

Column name Description
MaxDiff Maximum difference between x/y/z axes. (Float)
date Date of the measurement. (Date)

File: Task_Info_Flex.csv

Column name Description
Task The type of task that was conducted. (String)
Start The start date of the task. (Date)
Finish The end date of the task. (Date)
Description A description of the task. (String)

File: Tasks_info.csv

Column name Description
Task The type of task that was conducted. (String)
Start The start date of the task. (Date)
Finish The end date of the task. (Date)
Events Descriptor of any sensed events like wind blasts etcetera during the given period. (String)

File: pivotFlexBarrier.csv

Column name Description
Slope ID Unique identifier for each slope. (Integer)

File: treeInfoDailyUpdate.csv

Column name Description
Slope ID Unique identifier for each slope. (Integer)
Date compared Date when the data was compared. (Date)
Date assessed Date when the data was assessed. (Date)
Status (in Order / follow-up Status of the tree in order or follow-up. (String)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Cumulativedailywarning

@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor.cumulativedailywarning
  • 16.01 kB
  • 1,558 rows
  • 5 columns
Loading... 
CREATE TABLE cumulativedailywarning (
  "date_compared" VARCHAR,
  "date_assessed" VARCHAR,
  "slope_ids" VARCHAR,
  "tree_ids" VARCHAR,
  "status_in_order_follow_up" VARCHAR  -- Status (in Order / Follow-up
);

Datacumulated2

@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor.datacumulated2
  • 5.94 MB
  • 124,878 rows
  • 12 columns
Loading... 
CREATE TABLE datacumulated2 (
  "slopeid" VARCHAR,
  "treeid" VARCHAR,
  "deviceid" BIGINT,
  "rs2time" TIMESTAMP,
  "rs2mean" DOUBLE,
  "rs2std" DOUBLE,
  "rs2comx" DOUBLE,
  "rs2comy" DOUBLE,
  "rs2comz" DOUBLE,
  "rawx" DOUBLE,
  "rawy" DOUBLE,
  "rawz" DOUBLE
);

Datacumulatedflex2

@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor.datacumulatedflex2
  • 4.97 kB
  • 356 rows
  • 3 columns
Loading... 
CREATE TABLE datacumulatedflex2 (
  "maxdiff" DOUBLE,
  "date" TIMESTAMP,
  "deviceid" BIGINT
);

Pivotflexbarrier

@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor.pivotflexbarrier
  • 63.62 kB
  • 5 rows
  • 87 columns
Loading... 
CREATE TABLE pivotflexbarrier (
  "unnamed_0_1" BIGINT  -- Unnamed: 0.1,
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "deviceid" BIGINT,
  "n_2022_10_03" DOUBLE  -- 2022-10-03,
  "n_2022_10_04" DOUBLE  -- 2022-10-04,
  "n_2022_10_05" DOUBLE  -- 2022-10-05,
  "n_2022_10_06" DOUBLE  -- 2022-10-06,
  "n_2022_10_07" DOUBLE  -- 2022-10-07,
  "n_2022_10_08" DOUBLE  -- 2022-10-08,
  "n_2022_10_09" DOUBLE  -- 2022-10-09,
  "n_2022_10_10" DOUBLE  -- 2022-10-10,
  "n_2022_10_11" DOUBLE  -- 2022-10-11,
  "n_2022_10_12" DOUBLE  -- 2022-10-12,
  "n_2022_10_13" DOUBLE  -- 2022-10-13,
  "n_2022_10_14" DOUBLE  -- 2022-10-14,
  "n_2022_10_15" DOUBLE  -- 2022-10-15,
  "n_2022_10_16" DOUBLE  -- 2022-10-16,
  "n_2022_10_17" DOUBLE  -- 2022-10-17,
  "n_2022_10_18" DOUBLE  -- 2022-10-18,
  "n_2022_10_19" DOUBLE  -- 2022-10-19,
  "n_2022_10_20" DOUBLE  -- 2022-10-20,
  "n_2022_10_21" DOUBLE  -- 2022-10-21,
  "n_2022_10_22" DOUBLE  -- 2022-10-22,
  "n_2022_10_23" DOUBLE  -- 2022-10-23,
  "n_2022_10_24" DOUBLE  -- 2022-10-24,
  "n_2022_10_25" DOUBLE  -- 2022-10-25,
  "n_2022_10_26" DOUBLE  -- 2022-10-26,
  "n_2022_10_27" DOUBLE  -- 2022-10-27,
  "n_2022_10_28" DOUBLE  -- 2022-10-28,
  "n_2022_10_29" DOUBLE  -- 2022-10-29,
  "n_2022_10_30" DOUBLE  -- 2022-10-30,
  "n_2022_10_31" DOUBLE  -- 2022-10-31,
  "n_2022_11_01" DOUBLE  -- 2022-11-01,
  "n_2022_11_02" DOUBLE  -- 2022-11-02,
  "n_2022_11_03" DOUBLE  -- 2022-11-03,
  "n_2022_11_04" DOUBLE  -- 2022-11-04,
  "n_2022_11_05" DOUBLE  -- 2022-11-05,
  "n_2022_11_06" DOUBLE  -- 2022-11-06,
  "n_2022_11_07" DOUBLE  -- 2022-11-07,
  "n_2022_11_08" DOUBLE  -- 2022-11-08,
  "n_2022_11_09" DOUBLE  -- 2022-11-09,
  "n_2022_11_10" DOUBLE  -- 2022-11-10,
  "n_2022_11_11" DOUBLE  -- 2022-11-11,
  "n_2022_11_12" DOUBLE  -- 2022-11-12,
  "n_2022_11_13" DOUBLE  -- 2022-11-13,
  "n_2022_11_14" DOUBLE  -- 2022-11-14,
  "n_2022_11_15" DOUBLE  -- 2022-11-15,
  "n_2022_11_16" DOUBLE  -- 2022-11-16,
  "n_2022_11_17" DOUBLE  -- 2022-11-17,
  "n_2022_11_18" DOUBLE  -- 2022-11-18,
  "n_2022_11_19" DOUBLE  -- 2022-11-19,
  "n_2022_11_20" DOUBLE  -- 2022-11-20,
  "n_2022_11_21" DOUBLE  -- 2022-11-21,
  "n_2022_11_22" DOUBLE  -- 2022-11-22,
  "n_2022_11_23" DOUBLE  -- 2022-11-23,
  "n_2022_11_24" DOUBLE  -- 2022-11-24,
  "n_2022_11_25" DOUBLE  -- 2022-11-25,
  "n_2022_11_26" DOUBLE  -- 2022-11-26,
  "n_2022_11_27" DOUBLE  -- 2022-11-27,
  "n_2022_11_28" DOUBLE  -- 2022-11-28,
  "n_2022_11_29" DOUBLE  -- 2022-11-29,
  "n_2022_11_30" DOUBLE  -- 2022-11-30,
  "n_2022_12_01" DOUBLE  -- 2022-12-01,
  "n_2022_12_02" DOUBLE  -- 2022-12-02,
  "n_2022_12_03" DOUBLE  -- 2022-12-03,
  "n_2022_12_04" DOUBLE  -- 2022-12-04,
  "n_2022_12_05" DOUBLE  -- 2022-12-05,
  "n_2022_12_06" DOUBLE  -- 2022-12-06,
  "n_2022_12_07" DOUBLE  -- 2022-12-07,
  "n_2022_12_08" DOUBLE  -- 2022-12-08,
  "n_2022_12_09" DOUBLE  -- 2022-12-09,
  "n_2022_12_10" DOUBLE  -- 2022-12-10,
  "n_2022_12_11" DOUBLE  -- 2022-12-11,
  "n_2022_12_12" DOUBLE  -- 2022-12-12,
  "n_2022_12_13" DOUBLE  -- 2022-12-13,
  "n_2022_12_14" DOUBLE  -- 2022-12-14,
  "n_2022_12_15" DOUBLE  -- 2022-12-15,
  "n_2022_12_16" DOUBLE  -- 2022-12-16,
  "n_2022_12_17" DOUBLE  -- 2022-12-17,
  "n_2022_12_18" DOUBLE  -- 2022-12-18,
  "n_2022_12_19" DOUBLE  -- 2022-12-19,
  "n_2022_12_20" DOUBLE  -- 2022-12-20,
  "n_2022_12_21" DOUBLE  -- 2022-12-21,
  "n_2022_12_22" DOUBLE  -- 2022-12-22,
  "n_2022_12_23" DOUBLE  -- 2022-12-23,
  "n_2022_12_24" DOUBLE  -- 2022-12-24,
  "n_2022_12_25" DOUBLE  -- 2022-12-25
);

Task Info Flex

@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor.task_info_flex
  • 4.64 kB
  • 5 rows
  • 6 columns
Loading... 
CREATE TABLE task_info_flex (
  "task" VARCHAR,
  "start" TIMESTAMP,
  "finish" TIMESTAMP,
  "description" VARCHAR,
  "slopeid" VARCHAR,
  "sensorid" VARCHAR
);

Tasks Info

@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor.tasks_info
  • 4.77 kB
  • 9 rows
  • 6 columns
Loading... 
CREATE TABLE tasks_info (
  "task" VARCHAR,
  "start" TIMESTAMP,
  "finish" TIMESTAMP,
  "events" VARCHAR,
  "slopeid" VARCHAR,
  "treeid" VARCHAR
);

Treeinfodailyupdate

@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor.treeinfodailyupdate
  • 5.32 kB
  • 13 rows
  • 6 columns
Loading... 
CREATE TABLE treeinfodailyupdate (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date_compared" TIMESTAMP,
  "date_assessed" TIMESTAMP,
  "slope_ids" VARCHAR,
  "tree_ids" VARCHAR,
  "status_in_order_follow_up" VARCHAR  -- Status (in Order / Follow-up
);

Share link

Anyone who has the link will be able to view this.