Predict Droughts Using Weather & Soil Data

Predicting continental US drought levels using meteorological & soil data.

@kaggle.cdminix_us_drought_meteorological_data

Table List

1 table(423.1 KB)

Soil Data

@kaggle.cdminix_us_drought_meteorological_data.soil_data

423.1 KB
3109 rows
32 columns

fips Fips	lat Lat	lon Lon	elevation Elevation	slope1 Slope1	slope2 Slope2	slope3 Slope3	slope4 Slope4	slope5 Slope5	slope6 Slope6	slope7 Slope7	slope8 Slope8	aspectn AspectN	aspecte AspectE	aspects AspectS	aspectw AspectW	aspectunknown AspectUnknown	wat_land WAT LAND	nvg_land NVG LAND	urb_land URB LAND	grs_land GRS LAND	for_land FOR LAND	cultrf_land CULTRF LAND	cultir_land CULTIR LAND	cult_land CULT LAND	sq1 SQ1	sq2 SQ2	sq3 SQ3	sq4 SQ4	sq5 SQ5	sq6 SQ6	sq7 SQ7
1001	32.536382	-86.64449	63	0.0419	0.2788	0.2984	0.2497	0.1142	0.017			0.1033	0.1859	0.2003	0.1898	0.3207	0.997399985790253	27.9404983520508	0.28889998793602	2.75027370452881	10.7147026062012	56.2934112548828	1.01481103897095	57.3082237243652	1	1	1	1	1	1	2
1005	31.87067	-85.405456	146	0.0158	0.1868	0.5441	0.2424	0.0106	0.0003			0.1415	0.2379	0.2183	0.1997	0.2026			0.414599984884262	2.22560167312622	22.9528388977051	72.5788040161133	1.82815897464752	74.4069595336914	3	2	1	1	1	1	1
1003	30.659218	-87.746067	52	0.0746	0.437	0.4415	0.0469					0.1168	0.1386	0.1048	0.1282	0.5116			3.50099992752075	4.9724555015564	28.6859912872314	59.8436393737793	2.99691390991211	62.8405532836914	3	2	1	2	1	1	1
1007	33.015893	-87.127148	93	0.0144	0.1617	0.3714	0.3493	0.0898	0.0134			0.1971	0.1885	0.2279	0.2104	0.1761			0.228299990296364	8.67466449737549	89.1721115112305	1.91659343242645	0.0083304988220334	1.92492389678955	3	2	1	1	1	1	1
1009	33.977448	-86.567246	198	0.005	0.0872	0.2799	0.3576	0.1477	0.1037	0.0189		0.2569	0.1503	0.2028	0.2978	0.0922			1.00370001792908	8.60685634613037	88.4700469970703	1.89190936088562	0.0274876691401005	1.91939699649811	3	2	1	1	1	1	1
1011	32.101759	-85.717261	152	0.0215	0.2157	0.5282	0.2253	0.0092	0.0001			0.1676	0.2007	0.195	0.1995	0.2372			0.345800012350082	8.8375825881958	90.1595230102539	0.610365331172943	0.046729288995266	0.657094597816467	3	2	1	1	1	1	1
1013	31.751667	-86.681969	103	0.0299	0.2987	0.5473	0.1207	0.0031	0.0003			0.1296	0.1992	0.1548	0.1878	0.3286			0.33610001206398	8.23111152648926	85.9736938476563	5.37155103683472	0.087543860077858	5.4590950012207	3	2	1	2	1	1	1
1015	33.771706	-85.822513	269	0.0051	0.0793	0.2525	0.2875	0.1658	0.1925	0.0173		0.2787	0.141	0.1677	0.3282	0.0844			5.38899993896484	7.89746856689453	45.2597885131836	40.9145393371582	0.539203584194183	41.453742980957	3	2	1	1	1	1	1
1017	32.917943	-85.391812	239	0.0081	0.1286	0.4832	0.3502	0.0283	0.0016			0.1789	0.269	0.2029	0.2125	0.1367			0.347699999809265	8.83713912963867	90.1598129272461	0.619837284088135	0.0355105698108673	0.65534782409668	3	2	1	1	1	1	1
1019	34.069515	-85.654242	196	0.017	0.1892	0.3063	0.225	0.1155	0.1324	0.0139	0.0007	0.2301	0.2435	0.1483	0.1719	0.2062			11.3207006454468	13.7449541091919	24.0797576904297	50.0900039672852	0.764582991600037	50.8545875549316	3	2	1	1	1	1	1


CREATE TABLE soil_data (
  "fips" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "elevation" BIGINT,
  "slope1" DOUBLE,
  "slope2" DOUBLE,
  "slope3" DOUBLE,
  "slope4" DOUBLE,
  "slope5" DOUBLE,
  "slope6" DOUBLE,
  "slope7" DOUBLE,
  "slope8" DOUBLE,
  "aspectn" DOUBLE,
  "aspecte" DOUBLE,
  "aspects" DOUBLE,
  "aspectw" DOUBLE,
  "aspectunknown" DOUBLE,
  "wat_land" DOUBLE,
  "nvg_land" DOUBLE,
  "urb_land" DOUBLE,
  "grs_land" DOUBLE,
  "for_land" DOUBLE,
  "cultrf_land" DOUBLE,
  "cultir_land" DOUBLE,
  "cult_land" DOUBLE,
  "sq1" BIGINT,
  "sq2" BIGINT,
  "sq3" BIGINT,
  "sq4" BIGINT,
  "sq5" BIGINT,
  "sq6" BIGINT,
  "sq7" BIGINT
);