Organization of USDA plants data. WIP

all-props.json

[
  [
    "usdaplants_table",
    "characteristics_20160713_table",
    "usda_plants_20160713_table"
  ], [
    "id",
    "betydb.species.id",
    "Genus",
    "Species",
    "ScientificName",
    "CommonName",
    "notes",
    "created_at",
    "updated_at",
    "AcceptedSymbol",
    "SynonymSymbol",
    "Symbol",
    "PLANTS_Floristic_Area",
    "State",
    "Category",
    "Family",
    "FamilySymbol",
    "FamilyCommonName",
    "xOrder",
    "SubClass",
    "Class",
    "SubDivision",
    "Division",
    "SuperDivision",
    "SubKingdom",
    "Kingdom",
    "ITIS_TSN",
    "Duration",
    "GrowthHabit",
    "NativeStatus",
    "FederalNoxiousStatus",
    "FederalNoxiousCommonName",
    "StateNoxiousStatus",
    "StateNoxiousCommonName",
    "Invasive",
    "Federal_TE_Status",
    "State_TE_Status",
    "State_TE_Common_Name",
    "NationalWetlandIndicatorStatus",
    "RegionalWetlandIndicatorStatus",
    "ActiveGrowthPeriod",
    "AfterHarvestRegrowthRate",
    "Bloat",
    "C2N_Ratio",
    "CoppicePotential",
    "FallConspicuous",
    "FireResistance",
    "FlowerColor",
    "FlowerConspicuous",
    "FoliageColor",
    "FoliagePorositySummer",
    "FoliagePorosityWinter",
    "FoliageTexture",
    "FruitColor",
    "FruitConspicuous",
    "GrowthForm",
    "GrowthRate",
    "MaxHeight20Yrs",
    "MatureHeight",
    "KnownAllelopath",
    "LeafRetention",
    "Lifespan",
    "LowGrowingGrass",
    "NitrogenFixation",
    "ResproutAbility",
    "Shape_and_Orientation",
    "Toxicity",
    "AdaptedCoarseSoils",
    "AdaptedMediumSoils",
    "AdaptedFineSoils",
    "AnaerobicTolerance",
    "CaCO3Tolerance",
    "ColdStratification",
    "DroughtTolerance",
    "FertilityRequirement",
    "FireTolerance",
    "MinFrostFreeDays",
    "HedgeTolerance",
    "MoistureUse",
    "pH_Minimum",
    "pH_Maximum",
    "Min_PlantingDensity",
    "Max_PlantingDensity",
    "Precipitation_Minimum",
    "Precipitation_Maximum",
    "RootDepthMinimum",
    "SalinityTolerance",
    "ShadeTolerance",
    "TemperatureMinimum",
    "BloomPeriod",
    "CommercialAvailability",
    "FruitSeedAbundance",
    "FruitSeedPeriodBegin",
    "FruitSeedPeriodEnd",
    "FruitSeedPersistence",
    "Propogated_by_BareRoot",
    "Propogated_by_Bulbs",
    "Propogated_by_Container",
    "Propogated_by_Corms",
    "Propogated_by_Cuttings",
    "Propogated_by_Seed",
    "Propogated_by_Sod",
    "Propogated_by_Sprigs",
    "Propogated_by_Tubers",
    "Seeds_per_Pound",
    "SeedSpreadRate",
    "SeedlingVigor",
    "SmallGrain",
    "VegetativeSpreadRate",
    "Berry_Nut_Seed_Product",
    "ChristmasTreeProduct",
    "FodderProduct",
    "FuelwoodProduct",
    "LumberProduct",
    "NavalStoreProduct",
    "NurseryStockProduct",
    "PalatableBrowseAnimal",
    "PalatableGrazeAnimal",
    "PalatableHuman",
    "PostProduct",
    "ProteinPotential",
    "PulpwoodProduct",
    "VeneerProduct"
  ], [
    "Accepted Symbol",
    "Synonym Symbol",
    "Scientific Name",
    "PLANTS Floristic Area",
    "Active Growth Period",
    "After Harvest Regrowth Rate",
    "Bloat",
    "C:N Ratio",
    "Coppice Potential",
    "Fall Conspicuous",
    "Fire Resistance",
    "Flower Color",
    "Flower Conspicuous",
    "Foliage Color",
    "Foliage Porosity Summer",
    "Foliage Porosity Winter",
    "Foliage Texture",
    "Fruit Color",
    "Fruit Conspicuous",
    "Growth Form",
    "Growth Rate",
    "Height at Base Age, Maximum (feet)",
    "Height, Mature (feet)",
    "Known Allelopath",
    "Leaf Retention",
    "Lifespan",
    "Low Growing Grass",
    "Nitrogen Fixation",
    "Resprout Ability",
    "Shape and Orientation",
    "Toxicity",
    "Adapted to Coarse Textured Soils",
    "Adapted to Medium Textured Soils",
    "Adapted to Fine Textured Soils",
    "Anaerobic Tolerance",
    "CaCO<SUB>3</SUB> Tolerance",
    "Cold Stratification Required",
    "Drought Tolerance",
    "Fertility Requirement",
    "Fire Tolerance",
    "Frost Free Days, Minimum",
    "Hedge Tolerance",
    "Moisture Use",
    "pH (Minimum)",
    "pH (Maximum)",
    "Planting Density per Acre, Minimum",
    "Planting Density per Acre, Maximum",
    "Precipitation (Minimum)",
    "Precipitation (Maximum)",
    "Root Depth, Minimum (inches)",
    "Salinity Tolerance",
    "Shade Tolerance",
    "Temperature, Minimum (°F)",
    "Bloom Period",
    "Commercial Availability",
    "Fruit/Seed Abundance",
    "Fruit/Seed Period Begin",
    "Fruit/Seed Period End",
    "Fruit/Seed Persistence",
    "Propogated by Bare Root",
    "Propogated by Bulbs",
    "Propogated by Container",
    "Propogated by Corms",
    "Propogated by Cuttings",
    "Propogated by Seed",
    "Propogated by Sod",
    "Propogated by Sprigs",
    "Propogated by Tubers",
    "Seeds per Pound",
    "Seed Spread Rate",
    "Seedling Vigor",
    "Small Grain",
    "Vegetative Spread Rate",
    "Berry/Nut/Seed Product",
    "Christmas Tree Product",
    "Fodder Product",
    "Fuelwood Product",
    "Lumber Product",
    "Naval Store Product",
    "Nursery Stock Product",
    "Palatable Browse Animal",
    "Palatable Graze Animal",
    "Palatable Human",
    "Post Product",
    "Protein Potential",
    "Pulpwood Product",
    "Veneer Product"
  ], [
    "Accepted Symbol",
    "Synonym Symbol",
    "Symbol",
    "Scientific Name",
    "Hybrid Genus Indicator",
    "Genus",
    "Hybrid Species Indicator",
    "Species",
    "Subspecies Prefix",
    "Hybrid Subspecies Indicator",
    "Subspecies",
    "Variety Prefix",
    "Hybrid Variety Indicator",
    "Variety",
    "Subvariety Prefix",
    "Subvariety",
    "Forma Prefix",
    "Forma",
    "Genera/Binomial Author",
    "Trinomial Author",
    "Quadranomial Author",
    "Questionable Taxon Indicator",
    "Parents",
    "Common Name",
    "PLANTS Floristic Area",
    "Category",
    "Genus",
    "Family",
    "Family Symbol",
    "Family Common Name",
    "Order",
    "SubClass",
    "Class",
    "SubDivision",
    "Division",
    "SuperDivision",
    "SubKingdom",
    "Kingdom",
    "ITIS TSN",
    "Duration",
    "Growth Habit",
    "Native Status",
    "Federal Noxious Status",
    "Federal Noxious Common Name",
    "State Noxious Status",
    "State Noxious Common Name",
    "Invasive",
    "Federal T/E Status",
    "State T/E Status",
    "State T/E Common Name",
    "National Wetland Indicator Status",
    "Regional Wetland Indicator Status"
  ]
]

base-tables.md

WIP: Base Plants resource should include props from USDA tables plus props not provided by USDA

PLANTS

• common_name {string}

• duration {string} - ["annuel" | "perenial"]

• img_url {string}

• ?fruit_bearing

• ?flowering

grouped-props.md

Grouped lists of USDA props

This is a first draft of how the props from merged collection of usdaplants table, characteristics_20160713 table and usda_plants_20160713 table could be broken down into smaller more cohesive groups.

NOT YET GROUPED

• Bloat

• Duration

• Bloom Period

• C2N_Ratio

• Foliage Texture

• Foliage Color

• Foliage Porosity Summer

• Foliage Porosity Winter

• Fall Conspicuous

• Flower Conspicuous

• Flower Color

• Invasive

• Leaf Retention

• Low Growing Grass

• Palatable Browse Animal

• Palatable Graze Animal

• Palatable Human

• Parents

• Shape and Orientation

• Small Grain

• State

• PLANTS_Floristic_Area

• Protein Potential

• Toxicity

• Nitrogen Fixation

• Known Allelopath

---

Preferences

• Adapted to Coarse Textured Soils

• Adapted to Fine Textured Soils

• Adapted to Medium Textured Soils

• Cold Stratification Required

• Frost Free Days, Minimum

• Fertility Requirement

• MinFrostFreeDays

• Moisture Use

• pH_Maximum

• pH_Minimum

• Planting Density per Acre, Maximum

• Planting Density per Acre, Minimum

• Precipitation_Maximum

• Precipitation_Minimum

• Temperature, Minimum (°F)

---

Fruit

• Fruit Color
• Fruit Conspicuous
• Fruit/Seed Abundance
• Fruit/Seed Period Begin
• Fruit/Seed Period End
• Fruit/Seed Persistence

---

Seeds

• Seed Spread Rate
• Seedling Vigor
• Seeds per Pound

---

Growth

• Active Growth Period

• After Harvest Regrowth Rate

• Growth Form

• Growth Habit

• Growth Rate

• Height at Base Age, Maximum (feet)

• Height, Mature (feet)

• MatureHeight

• Coppice Potential

• Lifespan

• Max_PlantingDensity

• MaxHeight20Yrs

• Min_PlantingDensity

• Root Depth, Minimum (inches)

• Vegetative Spread Rate

• Resprout Ability

---

Tolerances

• Anaerobic Tolerance
• CaCO3Tolerance
• Drought Tolerance
• Fire Tolerance
• Fire Resistance
• Hedge Tolerance
• Salinity Tolerance
• Shade Tolerance

---

Propogation

• Propogated by Bare Root
• Propogated by Bulbs
• Propogated by Container
• Propogated by Corms
• Propogated by Cuttings
• Propogated by Seed
• Propogated by Sod
• Propogated by Sprigs
• Propogated by Tubers

---

Products

• Veneer Product

• Berry_Nut_Seed_Product

• Christmas Tree Product

• Fodder Product

• Fuelwood Product

• Lumber Product

• Naval Store Product

• Nursery Stock Product

• Post Product

• Pulpwood Product

• Commercial Availability

---

Statuses

• ^Federal Noxious Status

• State Noxious Status

• National Wetland Indicator Status

• Regional Wetland Indicator Status

• Native Status

  Threatened or Endangered

  • Federal Threatened or Endangered Status
  • State Threatened or Endangered Status

---

Naming

• Category
• Common Name
• Noxious Common Name State
• Noxious Common Name Federal
• Scientific Name
• Symbol
• Symbol Accepted
• ^Symbol Synonym
• Threatened or Endangered Common Name State

---

Taxonomy

• SubClass

• ^SubDivision

• SubKingdom

• Subspecies Prefix

• Subspecies

• Subvariety Prefix

• Subvariety

• SuperDivision

• Variety Prefix

• Variety

• xOerder

• Species

• Order

• Genus

• Class

• Division

• Family Common Name

• Family Symbol

• Family

• Forma Prefix

• Forma

• Kingdom

• Questionable Taxon Indicator

• Hybrid Genus Indicator

• Hybrid Species Indicator

• Hybrid Subspecies Indicator

• Hybrid Variety Indicator

---

Random

• ^notes
• betydb.species.id
• ITIS_TSN
• Genera/Binomial Author
• Trinomial Author
• Quadranomial Author

merged-props-no-dupes.md

Collection of props across all three tables with duplicates removed and sorted alphabetically.

• Active_Growth_Period
• Adapted_to_Coarse_Textured_Soils
• Adapted_to_Fine_Textured_Soils
• Adapted_to_Medium_Textured_Soils
• After_Harvest_Regrowth_Rate
• Anaerobic_Tolerance
• Berry_Nut_Seed_Product
• betydb.species.id
• Bloat
• Bloom_Period
• C2N_Ratio
• CaCO3Tolerance
• Category
• Christmas_Tree_Product
• Class
• Cold_Stratification_Required
• Commercial_Availability
• Common_Name
• Coppice_Potential
• Division
• Drought_Tolerance
• Duration
• Fall_Conspicuous
• Family
• Family_Common_Name
• Family_Symbol
• ^Federal_Noxious_Status
• Federal_Threatened_or_Endangered_Status
• Fertility_Requirement
• Fire_Resistance
• Fire_Tolerance
• Flower_Color
• Flower_Conspicuous
• Fodder_Product
• Foliage_Color
• Foliage_Porosity_Summer
• Foliage_Porosity_Winter
• Foliage_Texture
• Forma
• Forma_Prefix
• Frost_Free_Days_Minimum
• Fruit_Color
• Fruit_Conspicuous
• Fruit/Seed_Abundance
• Fruit/Seed_Period_Begin
• Fruit/Seed_Period_End
• Fruit/Seed_Persistence
• Fuelwood_Product
• Genera/Binomial_Author
• Genus
• Growth_Form
• Growth_Habit
• Growth_Rate
• Hedge_Tolerance
• Height_at_Base_Age_Maximum_feet
• Height_Mature_feet
• Hybrid_Genus_Indicator
• Hybrid_Species_Indicator
• Hybrid_Subspecies_Indicator
• Hybrid_Variety_Indicator
• Invasive
• ITIS_TSN
• Kingdom
• Known_Allelopath
• Leaf_Retention
• Lifespan
• Low_Growing_Grass
• Lumber_Product
• MatureHeight
• Max_PlantingDensity
• MaxHeight20Yrs
• Min_PlantingDensity
• MinFrostFreeDays
• Moisture_Use
• National_Wetland_Indicator_Status
• Native_Status
• Naval_Store_Product
• Nitrogen_Fixation
• ^notes
• Noxious_Common_Name_Federal
• Noxious_Common_Name_State
• Nursery_Stock_Product
• Order
• Palatable_Browse_Animal
• Palatable_Graze_Animal
• Palatable_Human
• Parents
• pH_Maximum
• pH_Minimum
• Planting_Density_per_Acre_Maximum
• Planting_Density_per_Acre_Minimum
• PLANTS_Floristic_Area
• Post_Product
• Precipitation_Maximum
• Precipitation_Minimum
• Propogated_by_Bare_Root
• Propogated_by_Bulbs
• Propogated_by_Container
• Propogated_by_Corms
• Propogated_by_Cuttings
• Propogated_by_Seed
• Propogated_by_Sod
• Propogated_by_Sprigs
• Propogated_by_Tubers
• Protein_Potential
• Pulpwood_Product
• Quadranomial_Author
• Questionable_Taxon_Indicator
• Regional_Wetland_Indicator_Status
• Resprout_Ability
• Root_Depth_Minimum_inches
• Salinity_Tolerance
• Scientific_Name
• Seed_Spread_Rate
• Seedling_Vigor
• Seeds_per_Pound
• Shade_Tolerance
• Shape_and_Orientation
• Small_Grain
• Species
• State
• State_Noxious_Status
• State_Threatened_or_Endangered_Status
• SubClass
• ^SubDivision
• SubKingdom
• Subspecies
• Subspecies_Prefix
• Subvariety
• Subvariety_Prefix
• SuperDivision
• Symbol
• Symbol_Accepted
• ^Symbol_Synonym
• Temperature_Minimum_Fahrenheit
• Threatened_or_Endangered_Common_Name_State
• Toxicity
• Trinomial_Author
• Variety
• Variety_Prefix
• Vegetative_Spread_Rate
• Veneer_Product
• xOerder

^ = largley empty data set