BEGIN TRANSACTION updateRSCrops;

INSERT INTO rset.rs_crop (rs_crop_id, rs_cover_1, rs_cover_2, rs_crop_name, rs_crop_type_id, rs_crop_units, rs_lbs_per_unit, rs_crop_pct_dmat, rs_pct_nitrogen, rs_nitrogen_yield, rs_pct_phosphorus, rs_phosphorus_yield, rs_residue_score) 
VALUES(132, 'Other Vegetables and Truck Crops','Banana','Banana',4,'tons/ac',2000,0.2574,0.6402,3.296,0.0777,0.4,2);

INSERT INTO rset.rs_crop (rs_crop_id, rs_cover_1, rs_cover_2, rs_crop_name, rs_crop_type_id, rs_crop_units, rs_lbs_per_unit, rs_crop_pct_dmat, rs_pct_nitrogen, rs_nitrogen_yield, rs_pct_phosphorus, rs_phosphorus_yield, rs_residue_score) 
VALUES(133, 'Other Vegetables and Truck Crops','Plantain','Plantain',4,'tons/ac',2000,0.3472,0.5991,4.16,0.0979,0.68,2);

INSERT INTO rset.rs_crop (rs_crop_id, rs_cover_1, rs_cover_2, rs_crop_name, rs_crop_type_id, rs_crop_units, rs_lbs_per_unit, rs_crop_pct_dmat, rs_pct_nitrogen, rs_nitrogen_yield, rs_pct_phosphorus, rs_phosphorus_yield, rs_residue_score) 
VALUES(134, 'Other Vegetables and Truck Crops','Pineapple','Pineapple',4,'tons/ac',2000,0.135,0.4622,1.248,0.0519,0.14,2);

INSERT INTO rset.rs_crop (rs_crop_id, rs_cover_1, rs_cover_2, rs_crop_name, rs_crop_type_id, rs_crop_units, rs_lbs_per_unit, rs_crop_pct_dmat, rs_pct_nitrogen, rs_nitrogen_yield, rs_pct_phosphorus, rs_phosphorus_yield, rs_residue_score) 
VALUES(135, 'Other Vegetables and Truck Crops','Mango','Mango',4,'tons/ac',2000,0.1829,0.4461,1.632,0.0601,0.22,2);

INSERT INTO rset.rs_crop (rs_crop_id, rs_cover_1, rs_cover_2, rs_crop_name, rs_crop_type_id, rs_crop_units, rs_lbs_per_unit, rs_crop_pct_dmat, rs_pct_nitrogen, rs_nitrogen_yield, rs_pct_phosphorus, rs_phosphorus_yield, rs_residue_score) 
VALUES(136, 'Other Vegetables and Truck Crops','Avocado','Avocado',4,'tons/ac',2000,0.2573,1.2312,3.296,0.1593,0.4,2);

INSERT INTO rset.rs_crop (rs_crop_id, rs_cover_1, rs_cover_2, rs_crop_name, rs_crop_type_id, rs_crop_units, rs_lbs_per_unit, rs_crop_pct_dmat, rs_pct_nitrogen, rs_nitrogen_yield, rs_pct_phosphorus, rs_phosphorus_yield, rs_residue_score) 
VALUES(137, 'Other Vegetables and Truck Crops','Papaya','Papaya',4,'tons/ac',2000,0.1117,0.8738,1.952,0.0448,0.1,2);

INSERT INTO rset.rs_crop (rs_crop_id, rs_cover_1, rs_cover_2, rs_crop_name, rs_crop_type_id, rs_crop_units, rs_lbs_per_unit, rs_crop_pct_dmat, rs_pct_nitrogen, rs_nitrogen_yield, rs_pct_phosphorus, rs_phosphorus_yield, rs_residue_score) 
VALUES(138, 'Other Vegetables and Truck Crops','Apples','Apples',4,'tons/ac',2000,0.1822,0.3388,6.336,0.0518,0.82,2);

INSERT INTO rset.rs_crop (rs_crop_id, rs_cover_1, rs_cover_2, rs_crop_name, rs_crop_type_id, rs_crop_units, rs_lbs_per_unit, rs_crop_pct_dmat, rs_pct_nitrogen, rs_nitrogen_yield, rs_pct_phosphorus, rs_phosphorus_yield, rs_residue_score) 
VALUES(139, 'Other Vegetables and Truck Crops','Okra','Okra',4,'tons/ac',2000,0.12,2.6667,6.4,0.525,1.26,1);

INSERT INTO rset.rs_crop (rs_crop_id, rs_cover_1, rs_cover_2, rs_crop_name, rs_crop_type_id, rs_crop_units, rs_lbs_per_unit, rs_crop_pct_dmat, rs_pct_nitrogen, rs_nitrogen_yield, rs_pct_phosphorus, rs_phosphorus_yield, rs_residue_score) 
VALUES(140, 'Other Vegetables and Truck Crops','Coffee','Coffee',4,'tons/ac',2000,0.88,5.1519,90.6731,0.3858,6.7905,2);

COMMIT TRANSACTION updateRSCrops;
