Assessing Tree Health And Stability
Insights into Different Tree Species
@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor
Insights into Different Tree Species
@kaggle.thedevastator_assessing_tree_health_and_stability_with_sensor
CREATE TABLE cumulativedailywarning (
"date_compared" VARCHAR,
"date_assessed" VARCHAR,
"slope_ids" VARCHAR,
"tree_ids" VARCHAR,
"status_in_order_follow_up" VARCHAR
);
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
);
CREATE TABLE datacumulatedflex2 (
"maxdiff" DOUBLE,
"date" TIMESTAMP,
"deviceid" BIGINT
);
CREATE TABLE pivotflexbarrier (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"deviceid" BIGINT,
"n_2022_10_03" DOUBLE,
"n_2022_10_04" DOUBLE,
"n_2022_10_05" DOUBLE,
"n_2022_10_06" DOUBLE,
"n_2022_10_07" DOUBLE,
"n_2022_10_08" DOUBLE,
"n_2022_10_09" DOUBLE,
"n_2022_10_10" DOUBLE,
"n_2022_10_11" DOUBLE,
"n_2022_10_12" DOUBLE,
"n_2022_10_13" DOUBLE,
"n_2022_10_14" DOUBLE,
"n_2022_10_15" DOUBLE,
"n_2022_10_16" DOUBLE,
"n_2022_10_17" DOUBLE,
"n_2022_10_18" DOUBLE,
"n_2022_10_19" DOUBLE,
"n_2022_10_20" DOUBLE,
"n_2022_10_21" DOUBLE,
"n_2022_10_22" DOUBLE,
"n_2022_10_23" DOUBLE,
"n_2022_10_24" DOUBLE,
"n_2022_10_25" DOUBLE,
"n_2022_10_26" DOUBLE,
"n_2022_10_27" DOUBLE,
"n_2022_10_28" DOUBLE,
"n_2022_10_29" DOUBLE,
"n_2022_10_30" DOUBLE,
"n_2022_10_31" DOUBLE,
"n_2022_11_01" DOUBLE,
"n_2022_11_02" DOUBLE,
"n_2022_11_03" DOUBLE,
"n_2022_11_04" DOUBLE,
"n_2022_11_05" DOUBLE,
"n_2022_11_06" DOUBLE,
"n_2022_11_07" DOUBLE,
"n_2022_11_08" DOUBLE,
"n_2022_11_09" DOUBLE,
"n_2022_11_10" DOUBLE,
"n_2022_11_11" DOUBLE,
"n_2022_11_12" DOUBLE,
"n_2022_11_13" DOUBLE,
"n_2022_11_14" DOUBLE,
"n_2022_11_15" DOUBLE,
"n_2022_11_16" DOUBLE,
"n_2022_11_17" DOUBLE,
"n_2022_11_18" DOUBLE,
"n_2022_11_19" DOUBLE,
"n_2022_11_20" DOUBLE,
"n_2022_11_21" DOUBLE,
"n_2022_11_22" DOUBLE,
"n_2022_11_23" DOUBLE,
"n_2022_11_24" DOUBLE,
"n_2022_11_25" DOUBLE,
"n_2022_11_26" DOUBLE,
"n_2022_11_27" DOUBLE,
"n_2022_11_28" DOUBLE,
"n_2022_11_29" DOUBLE,
"n_2022_11_30" DOUBLE,
"n_2022_12_01" DOUBLE,
"n_2022_12_02" DOUBLE,
"n_2022_12_03" DOUBLE,
"n_2022_12_04" DOUBLE,
"n_2022_12_05" DOUBLE,
"n_2022_12_06" DOUBLE,
"n_2022_12_07" DOUBLE,
"n_2022_12_08" DOUBLE,
"n_2022_12_09" DOUBLE,
"n_2022_12_10" DOUBLE,
"n_2022_12_11" DOUBLE,
"n_2022_12_12" DOUBLE,
"n_2022_12_13" DOUBLE,
"n_2022_12_14" DOUBLE,
"n_2022_12_15" DOUBLE,
"n_2022_12_16" DOUBLE,
"n_2022_12_17" DOUBLE,
"n_2022_12_18" DOUBLE,
"n_2022_12_19" DOUBLE,
"n_2022_12_20" DOUBLE,
"n_2022_12_21" DOUBLE,
"n_2022_12_22" DOUBLE,
"n_2022_12_23" DOUBLE,
"n_2022_12_24" DOUBLE,
"n_2022_12_25" DOUBLE
);
CREATE TABLE tasks_info (
"task" VARCHAR,
"start" TIMESTAMP,
"finish" TIMESTAMP,
"events" VARCHAR,
"slopeid" VARCHAR,
"treeid" VARCHAR
);
CREATE TABLE task_info_flex (
"task" VARCHAR,
"start" TIMESTAMP,
"finish" TIMESTAMP,
"description" VARCHAR,
"slopeid" VARCHAR,
"sensorid" VARCHAR
);
CREATE TABLE treeinfodailyupdate (
"unnamed_0" BIGINT,
"date_compared" TIMESTAMP,
"date_assessed" TIMESTAMP,
"slope_ids" VARCHAR,
"tree_ids" VARCHAR,
"status_in_order_follow_up" VARCHAR
);
Anyone who has the link will be able to view this.