INVESTIGATIVE WILDFIRE DATA FOR TURKEY/ NASA
INVESTIGATIVE WILDFIRE CSV DATA
@kaggle.brsdincer_investigative_wildfire_data_for_turkey_nasa
INVESTIGATIVE WILDFIRE CSV DATA
@kaggle.brsdincer_investigative_wildfire_data_for_turkey_nasa
CREATE TABLE fire_nrt_j1v_c2_212463 (
"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_212462 (
"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_m_c61_212465_all_countries (
"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_212464 (
"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 modis_2017_afghanistan (
"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_2017_albania (
"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_2017_algeria (
"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_2017_american_samoa (
"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_2017_andorra (
"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_2017_angola (
"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_2017_antigua_and_barbuda (
"latitude" DOUBLE,
"longitude" DOUBLE,
"brightness" DOUBLE,
"scan" BIGINT,
"track" BIGINT,
"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_2017_argentina (
"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_2017_armenia (
"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_2017_aruba (
"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_2017_australia (
"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_2017_austria (
"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_2017_azerbaijan (
"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_2017_bahamas (
"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_2017_bahrain (
"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_2017_bangladesh (
"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_2017_barbados (
"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_2017_belarus (
"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_2017_belgium (
"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_2017_belize (
"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_2017_benin (
"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
);
Anyone who has the link will be able to view this.