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 modis_2018_colombia (
"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_2018_comoros (
"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_2018_costa_rica (
"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_2018_cote_d_ivoire (
"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_2018_croatia (
"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_2018_cuba (
"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_2018_cyprus (
"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_2018_czech_republic (
"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_2018_democratic_republic_of_the_congo (
"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_2018_dem_rep_korea (
"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_2018_denmark (
"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_2018_djibouti (
"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_2018_dominican_republic (
"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_2018_ecuador (
"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_2018_egypt (
"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_2018_el_salvador (
"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_2018_equatorial_guinea (
"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_2018_eritrea (
"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_2018_estonia (
"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_2018_ethiopia (
"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_2018_fiji (
"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_2018_finland (
"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_2018_france (
"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_2018_french_guiana (
"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_2018_french_polynesia (
"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.