Turkey Recent Forest Fire / CSV / NASA
Data on Recent Forest Fires in Turkey
@kaggle.brsdincer_turkey_recent_forest_fire_csv_nasa
Data on Recent Forest Fires in Turkey
@kaggle.brsdincer_turkey_recent_forest_fire_csv_nasa
CREATE TABLE brightness_sorted (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"confidence" VARCHAR,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR
);
CREATE TABLE date_index (
"unnamed_0" TIMESTAMP,
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_time" BIGINT,
"confidence" VARCHAR,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR
);
CREATE TABLE date_sorted (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"confidence" VARCHAR,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR
);
CREATE TABLE fire_nrt_j1v_c2_212247 (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"satellite" BIGINT,
"instrument" VARCHAR,
"confidence" VARCHAR,
"version" VARCHAR,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR
);
CREATE TABLE fire_nrt_m_c61_212246 (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"satellite" VARCHAR,
"instrument" VARCHAR,
"confidence" BIGINT,
"version" VARCHAR,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR
);
CREATE TABLE fire_nrt_sv_c2_212248 (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"satellite" VARCHAR,
"instrument" VARCHAR,
"confidence" VARCHAR,
"version" VARCHAR,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR
);
CREATE TABLE frp_sorted (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"confidence" VARCHAR,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR
);
CREATE TABLE glb_ts_dsst_glb_ts_dsst (
"year" BIGINT,
"jan" DOUBLE,
"feb" DOUBLE,
"mar" DOUBLE,
"apr" DOUBLE,
"may" DOUBLE,
"jun" DOUBLE,
"jul" VARCHAR,
"aug" VARCHAR,
"sep" VARCHAR,
"oct" VARCHAR,
"nov" VARCHAR,
"dec" VARCHAR,
"j_d" VARCHAR,
"d_n" VARCHAR,
"djf" DOUBLE,
"mam" DOUBLE,
"jja" VARCHAR,
"son" VARCHAR
);
CREATE TABLE group_by (
"acq_date" TIMESTAMP,
"daynight" VARCHAR,
"confidence" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_time" DOUBLE,
"bright_t31" DOUBLE,
"frp" DOUBLE
);
CREATE TABLE mission_f32_jv1_nasa_sec (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"satellite" BIGINT,
"instrument" VARCHAR,
"confidence" VARCHAR,
"version" VARCHAR,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR
);
CREATE TABLE modis_2018_turkey (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"satellite" VARCHAR,
"instrument" VARCHAR,
"confidence" BIGINT,
"version" DOUBLE,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR,
"type" BIGINT
);
CREATE TABLE modis_2019_turkey (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"satellite" VARCHAR,
"instrument" VARCHAR,
"confidence" BIGINT,
"version" DOUBLE,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR,
"type" BIGINT
);
CREATE TABLE modis_2020_turkey (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"satellite" VARCHAR,
"instrument" VARCHAR,
"confidence" BIGINT,
"version" DOUBLE,
"bright_t31" DOUBLE,
"frp" DOUBLE,
"daynight" VARCHAR,
"type" BIGINT
);
CREATE TABLE zonann_ts_dsst (
"annual" VARCHAR,
"temperature" VARCHAR,
"anomalies" VARCHAR,
"n__deg" VARCHAR,
"c" VARCHAR,
"airs" VARCHAR,
"v6" VARCHAR,
"vs" VARCHAR,
"n_2007_2016" VARCHAR
);
Anyone who has the link will be able to view this.