BEGIN TRANSACTION;
CREATE TABLE soils_legend (id numeric, shortname TEXT, longname TEXT);
INSERT INTO soils_legend VALUES(0,'no data','no data');
INSERT INTO soils_legend VALUES(1,'AaB','Alice fine sandy loam, 0 to 6');
INSERT INTO soils_legend VALUES(2,'Ba','Barnum silt loam');
INSERT INTO soils_legend VALUES(3,'Bb','Barnum silt loam, channeled');
INSERT INTO soils_legend VALUES(4,'BcB','Boneek silt loam, 2 to 6');
INSERT INTO soils_legend VALUES(5,'BcC','Boneek silt loam, 6 to 9');
INSERT INTO soils_legend VALUES(6,'BeE','Butche stony loam, 6 to 50');
INSERT INTO soils_legend VALUES(7,'BhE','Butche rock outcrop complex, 25 to 50');
INSERT INTO soils_legend VALUES(8,'BkD','Butche Satanta loams, 6 to 25');
INSERT INTO soils_legend VALUES(9,'CBE','Citadel association, hilly');
INSERT INTO soils_legend VALUES(10,'CaD','Canyon-Bridget complex, 6 to 25');
INSERT INTO soils_legend VALUES(11,'CaE','Canyon-Bridget complex, 9 to 50');
INSERT INTO soils_legend VALUES(12,'Cc','Dumps,mine');
INSERT INTO soils_legend VALUES(13,'GBE','Grizzly-Virkula association, steep');
INSERT INTO soils_legend VALUES(14,'GaD','Glenberg Variant fine sandy loam');
INSERT INTO soils_legend VALUES(15,'GcD','Grummit-Rock outcrop complex, 3 to 20');
INSERT INTO soils_legend VALUES(16,'GdE','Grummit-Rock outcrop complex, 15 to 50');
INSERT INTO soils_legend VALUES(17,'GeD','Gypnevee-Rekop loams, 6 to 25');
INSERT INTO soils_legend VALUES(18,'HBF','Hisega-Rock outcrop association, steep');
INSERT INTO soils_legend VALUES(19,'Ha','Higgins silt loam');
INSERT INTO soils_legend VALUES(20,'KaB','Kyle clay, 2 to 6');
INSERT INTO soils_legend VALUES(21,'LaE','Lakoa silt loam, 25 to 50');
INSERT INTO soils_legend VALUES(22,'MaC','Maitland loam, 2 to 9');
INSERT INTO soils_legend VALUES(23,'MaD','Maitland loam, 9 to 50');
INSERT INTO soils_legend VALUES(24,'McD','Midway-Razor silty clay loams, 6 to 25');
INSERT INTO soils_legend VALUES(25,'NaB','Nevee silt loam, 2 to 6');
INSERT INTO soils_legend VALUES(26,'NaC','Nevee silt loam, 6 to 9');
INSERT INTO soils_legend VALUES(27,'Nac','Nevee silt loam, 6 to 9');
INSERT INTO soils_legend VALUES(28,'NbD','Nevee-Spearfish-Rock outcrop complex, 9 to 40');
INSERT INTO soils_legend VALUES(29,'NcD','Nihill gravelly loam, 6 to 25');
INSERT INTO soils_legend VALUES(30,'NdB','Nunn clay loam, 2 to 6');
INSERT INTO soils_legend VALUES(31,'NdC','Nunn clay loam, 6 to 9');
INSERT INTO soils_legend VALUES(32,'PbE','Paunsaugunt-Rock outcrop complex, 6 to 50');
INSERT INTO soils_legend VALUES(33,'PcB','Pierre clay, 2 to 6');
INSERT INTO soils_legend VALUES(34,'PcD','Pierre clay, 6 to 25');
INSERT INTO soils_legend VALUES(35,'Pe','Pits, quarry');
INSERT INTO soils_legend VALUES(36,'RBF','Rock outcrop-Pactola association, steep');
INSERT INTO soils_legend VALUES(37,'RCF','Rock outcrop-Vanocker association, very steep');
INSERT INTO soils_legend VALUES(38,'RaE','Rekop-Gypnevee-Rock outcrop complex, 15 to 50');
INSERT INTO soils_legend VALUES(39,'SaA','Satanta loam, 0 to 2');
INSERT INTO soils_legend VALUES(40,'SaB','Satanta loam, 2 to 6');
INSERT INTO soils_legend VALUES(41,'SbB','Savo silt loam, 2 to 6');
INSERT INTO soils_legend VALUES(42,'Sd','Stetter Variant silty clay loam');
INSERT INTO soils_legend VALUES(43,'ShA','St. Onge loam, 0 to 2');
INSERT INTO soils_legend VALUES(44,'Sk','Swint silt loam');
INSERT INTO soils_legend VALUES(45,'TaA','Tilford silt loam, 0 to 2');
INSERT INTO soils_legend VALUES(46,'TaB','Tilford silt loam, 2 to 6');
INSERT INTO soils_legend VALUES(47,'TaC','Tilford silt loam, 6 to 9');
INSERT INTO soils_legend VALUES(48,'VBF','Vanocker-Citadel association, steep');
INSERT INTO soils_legend VALUES(49,'VCE','Virkula association, hilly');
INSERT INTO soils_legend VALUES(50,'VaA','Vale silt loam, 0 to 2');
INSERT INTO soils_legend VALUES(51,'VaB','Vale silt loam, 2 to 6');
INSERT INTO soils_legend VALUES(52,'VaC','Vale silt loam, 6 to 9');
INSERT INTO soils_legend VALUES(53,'WaA','Weber loam, 0 to 2');
INSERT INTO soils_legend VALUES(54,'Wb','Winetti cobbly loam');
INSERT INTO soils_legend VALUES(55,'water','');
COMMIT;