-- Add rows to map_climates for unmapped counties 

--AL049
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('AL049','climates\USA\Alabama', 'De Kalb County', NULL, 343.479);

--CO095
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('CO095','climates\USA\Colorado\Philips County', 'CO_Philips_R_16-18', NULL, 65.5096442);

--FL027
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('FL027','climates\USA\Florida', 'De Soto County', NULL, 573.781);

--GA089
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('GA089','climates\USA\Georgia', 'De Kalb County', NULL, 312.916);

--IL037
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('IL037','climates\USA\Illinois', 'De Kalb County', NULL, 165.41);

--IL043
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('IL043','climates\USA\Illinois', 'Du Page County', NULL, 161.669);

--MN073
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('MN073','climates\USA\Minnesota', 'Lac Qui Parle County', NULL, 97.3197);

--MO063
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('MO063','climates\USA\Missouri', 'De Kalb County', NULL, 200.448);

--MS033
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('MS033','climates\USA\Mississippi', 'De Soto County', NULL, 350.844);

--MT113 Yellowstone Park -- NEED TO MAP
--insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
--values ('AL049','climates\USA\alabama', 'De Kalb County', NULL, 343.479);

--ND045
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('ND045','climates\USA\North Dakota', 'La Moure County', NULL, 71.1183);

--ND061
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('ND061','climates\USA\North Dakota', 'Mountrial County', NULL, 46.7234);

--TN041
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('TN041','climates\USA\Tennessee', 'De Kalb County', NULL, 304.109);

--TX123
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('TX123','climates\USA\Texas', 'De Witt County', NULL, 303.082);

--VA013
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('VA013','climates\USA\Virginia', 'City of Arlington', NULL, 177.583);

--VA036
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('VA036','climates\USA\Virginia', 'City of Charles', NULL, 220.129);

--WI039
insert into r2gis.map_climates (co_fips, r2_path, r2_name, ei_rang, r_factor)
values ('WI039','climates\USA\Wisconsin', 'Fond Du Lac County', NULL, 116.591);
