import_new.sql

CREATE TABLE usda(
id integer,
Symbol varchar,
Accepted_Symbol_x varchar,
Synonym_Symbol_x varchar,
Scientific_Name_x varchar,
Hybrid_Genus_Indicator varchar,
Hybrid_Species_Indicator varchar,
Species varchar,
Subspecies_Prefix varchar,
Hybrid_Subspecies_Indicator varchar,
Subspecies varchar,
Variety_Prefix varchar,
Hybrid_Variety_Indicator varchar,
Variety varchar,
Subvariety_Prefix varchar,
Subvariety varchar,
Forma_Prefix varchar,
Forma varchar,
Genera_Binomial_Author varchar,
Trinomial_Author varchar,
Quadranomial_Author varchar,
Questionable_Taxon_Indicator varchar,
Parents varchar,
Common_Name varchar,
State_and_Province varchar,
Category varchar,
Family varchar,
Family_Symbol varchar,
Family_Common_Name varchar,
xOrder varchar,
SubClass varchar,
Class varchar,
SubDivision varchar,
Division varchar,
SuperDivision varchar,
SubKingdom varchar,
Kingdom varchar,
Duration varchar,
Growth_Habit varchar,
Native_Status varchar,
Federal_Noxious_Status varchar,
State_Noxious_Status varchar,
State_Noxious_Common_Name varchar,
Invasive varchar,
Federal_T_E_Status varchar,
State_T_E_Status varchar,
State_T_E_Common_Name varchar,
Accepted_Symbol_y varchar,
Synonym_Symbol_y varchar,
Scientific_Name_y varchar,
Active_Growth_Period varchar,
After_Harvest_Regrowth_Rate varchar,
Bloat varchar,
C_N_Ratio varchar,
Coppice_Potential varchar,
Fall_Conspicuous varchar,
Fire_Resistance varchar,
Flower_Color varchar,
Flower_Conspicuous varchar,
Foliage_Color varchar,
Foliage_Porosity_Summer varchar,
Foliage_Porosity_Winter varchar,
Foliage_Texture varchar,
Fruit_Color varchar,
Fruit_Conspicuous varchar,
Growth_Form varchar,
Growth_Rate varchar,
Height_at_Base_Age_Maximum_feet varchar,
Height_Mature_feet varchar,
Known_Allelopath varchar,
Leaf_Retention varchar,
Lifespan varchar,
Low_Growing_Grass varchar,
Nitrogen_Fixation varchar,
Resprout_Ability varchar,
Shape_and_Orientation varchar,
Toxicity varchar,
Adapted_to_Coarse_Textured_Soils varchar,
Adapted_to_Medium_Textured_Soils varchar,
Adapted_to_Fine_Textured_Soils varchar,
Anaerobic_Tolerance varchar,
CaCO_3_Tolerance varchar,
Cold_Stratification_Required varchar,
Drought_Tolerance varchar,
Fertility_Requirement varchar,
Fire_Tolerance varchar,
Frost_Free_Days_Minimum varchar,
Hedge_Tolerance varchar,
Moisture_Use varchar,
pH_Minimum varchar,
pH_Maximum varchar,
Planting_Density_per_Acre_Minimum varchar,
Planting_Density_per_Acre_Maximum varchar,
Precipitation_Minimum varchar,
Precipitation_Maximum varchar,
Root_Depth_Minimum_inches varchar,
Salinity_Tolerance varchar,
Shade_Tolerance varchar,
Temperature_Minimum_F varchar,
Bloom_Period varchar,
Commercial_Availability varchar,
Fruit_Seed_Abundance varchar,
Fruit_Seed_Period_Begin varchar,
Fruit_Seed_Period_End varchar,
Fruit_Seed_Persistence varchar,
Propogated_by_Bare_Root varchar,
Propogated_by_Bulbs varchar,
Propogated_by_Container varchar,
Propogated_by_Corms varchar,
Propogated_by_Cuttings varchar,
Propogated_by_Seed varchar,
Propogated_by_Sod varchar,
Propogated_by_Sprigs varchar,
Propogated_by_Tubers varchar,
Seeds_per_Pound varchar,
Seed_Spread_Rate varchar,
Seedling_Vigor varchar,
Small_Grain varchar,
Vegetative_Spread_Rate varchar,
Berry_Nut_Seed_Product varchar,
Christmas_Tree_Product varchar,
Fodder_Product varchar,
Fuelwood_Product varchar,
Lumber_Product varchar,
Naval_Store_Product varchar,
Nursery_Stock_Product varchar,
Palatable_Browse_Animal varchar,
Palatable_Graze_Animal varchar,
Palatable_Human varchar,
Post_Product varchar,
Protein_Potential varchar,
Pulpwood_Product varchar,
Veneer_Product varchar,
Genus varchar
);

.separator ,
.import usda_plants_20160223_nona.csv usda