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
38.7325	26.9335	302.5	1.6	1.2	Mon Jan 06 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1141	Aqua	MODIS	52	6.2	289.8	10.2	D
37.8189	31.607	312	1.2	1.1	Tue Jan 07 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1045	Aqua	MODIS	54	6.2	282.5	17.8	D
38.9445	31.8412	307.9	2.1	1.4	Wed Jan 08 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1128	Aqua	MODIS	63	6.2	286.3	26.4	D
38.3845	30.753	344.7	1.7	1.3	Wed Jan 08 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1128	Aqua	MODIS	71	6.2	283.8	118.7	D
38.9442	31.8463	306.4	2.1	1.4	Wed Jan 08 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1128	Aqua	MODIS	63	6.2	286.2	23.7	D
39.9194	33.3392	302.7	1.7	1.3	Fri Jan 10 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1116	Aqua	MODIS	53	6.2	287.2	12.2	D
38.6867	32.8869	315.4	1.5	1.2	Fri Jan 10 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1116	Aqua	MODIS	76	6.2	288	26	D
38.8124	32.7649	303.8	1.5	1.2	Fri Jan 10 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1116	Aqua	MODIS	57	6.2	287.2	12.1	D
38.685	32.8691	304.1	1.5	1.2	Fri Jan 10 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1116	Aqua	MODIS	58	6.2	287.3	11.2	D
38.8099	32.7722	300.7	1.5	1.2	Fri Jan 10 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1116	Aqua	MODIS	40	6.2	287.4	8.1	D


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