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_2017_portugal (
"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_puerto_rico (
"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_qatar (
"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_republic_of_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_2017_republic_of_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_2017_reunion (
"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_romania (
"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_russian_federation (
"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_rwanda (
"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_saint_helena (
"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_saint_kitts_and_nevis (
"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_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_sao_tome_and_principe (
"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_saudi_arabia (
"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_senegal (
"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_serbia (
"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_sierra_leone (
"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_singapore (
"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_slovakia (
"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_slovenia (
"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_solomon_islands (
"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_somalia (
"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_somaliland (
"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_south_africa (
"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_south_sudan (
"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.