2000-2020 TURKEY WILDFIRE DATA / NASA

latitude Latitude	longitude Longitude	brightness Brightness	scan Scan	track Track	acq_date Acq Date	acq_time Acq Time	satellite Satellite	instrument Instrument	confidence Confidence	version Version	bright_t31 Bright T31	frp Frp	daynight Daynight	type Type
37.0918	40.5227	300.6	1	1	Sun Jan 04 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	809	Terra	MODIS	40	6.2	280.3	6.1	D
36.7329	36.2149	303.4	1.3	1.1	Fri Jan 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2348	Aqua	MODIS	55	6.2	284.5	11.1	N	2
36.7285	36.2118	302.9	1.1	1	Sun Jan 18 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	821	Terra	MODIS	41	6.2	288.4	6.8	D	2
39.9792	26.2074	301.5	2.3	1.5	Tue Jan 20 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	947	Terra	MODIS	36	6.2	283.4	17.7	D
36.7298	36.2104	301.4	1.6	1.2	Fri Feb 06 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	852	Terra	MODIS		6.2	287.4	10.9	D	2
39.7067	31.6849	322.6	1.2	1.1	Sat Feb 07 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	1110	Aqua	MODIS	82	6.2	293	23.7	D
38.2898	26.8819	302.9	1.1	1	Sat Feb 07 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	1110	Aqua	MODIS	54	6.2	292.4	5	D
38.3455	26.8854	301	1.1	1	Sat Feb 07 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	1110	Aqua	MODIS	44	6.2	290.8	3.7	D
38.7357	26.9445	305	1.1	1	Sat Feb 07 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	1110	Aqua	MODIS	60	6.2	294.9	5.5	D
38.5049	28.266	306.3	1	1	Sat Feb 07 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	1110	Aqua	MODIS	63	6.2	293.1	5.3	D


CREATE TABLE modis_2004_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
);