To get the table from the Plants Database. We can use it’s API, and with the use of the jsonlite package it is very easy to obtain.
First we load the package
library(jsonlite)Then we make a list of the species codes:
Species <- c("RHCO", "ACPL")We use those to get the species codes:
IDs <- character()
for(i in 1:length(Species)){
IDs[i] <- jsonlite::read_json(paste0('https://plantsservices.sc.egov.usda.gov/api/PlantProfile?symbol=', Species[i]))$Id
}Which gets us the vector of IDs which in this case is 92952, 92843. Finally we scrape the characterisitcs table, and generate a final table:
Data <- list()
for(i in 1:length(IDs)){
Data[[i]] <- jsonlite::read_json(paste0('https://plantsservices.sc.egov.usda.gov/api/PlantCharacteristics/', IDs[i]), simplifyVector = T)
Data[[i]]$Species <- Species[i]
}
Data <- do.call(rbind, Data)Which generates the following table:
| PlantCharacteristicName | PlantCharacteristicValue | PlantCharacteristicCategory | CultivarName | SynonymName | Species |
|---|---|---|---|---|---|
| Active Growth Period | Spring and Summer | Morphology/Physiology | NA | NA | RHCO |
| Bloat | None | Morphology/Physiology | NA | NA | RHCO |
| C:N Ratio | High | Morphology/Physiology | NA | NA | RHCO |
| Coppice Potential | No | Morphology/Physiology | NA | NA | RHCO |
| Fall Conspicuous | Yes | Morphology/Physiology | NA | NA | RHCO |
| Fire Resistant | No | Morphology/Physiology | NA | NA | RHCO |
| Flower Color | Yellow | Morphology/Physiology | NA | NA | RHCO |
| Flower Conspicuous | No | Morphology/Physiology | NA | NA | RHCO |
| Foliage Color | Green | Morphology/Physiology | NA | NA | RHCO |
| Foliage Porosity Summer | Dense | Morphology/Physiology | NA | NA | RHCO |
| Foliage Porosity Winter | Porous | Morphology/Physiology | NA | NA | RHCO |
| Foliage Texture | Coarse | Morphology/Physiology | NA | NA | RHCO |
| Fruit/Seed Color | Brown | Morphology/Physiology | NA | NA | RHCO |
| Fruit/Seed Conspicuous | Yes | Morphology/Physiology | NA | NA | RHCO |
| Growth Form | Rhizomatous | Morphology/Physiology | NA | NA | RHCO |
| Growth Rate | Moderate | Morphology/Physiology | NA | NA | RHCO |
| Height at 20 Years, Maximum (feet) | 8 | Morphology/Physiology | NA | NA | RHCO |
| Height, Mature (feet) | 8.0 | Morphology/Physiology | NA | NA | RHCO |
| Known Allelopath | No | Morphology/Physiology | NA | NA | RHCO |
| Leaf Retention | No | Morphology/Physiology | NA | NA | RHCO |
| Lifespan | Moderate | Morphology/Physiology | NA | NA | RHCO |
| Low Growing Grass | No | Morphology/Physiology | NA | NA | RHCO |
| Nitrogen Fixation | None | Morphology/Physiology | NA | NA | RHCO |
| Resprout Ability | Yes | Morphology/Physiology | NA | NA | RHCO |
| Shape and Orientation | Erect | Morphology/Physiology | NA | NA | RHCO |
| Toxicity | None | Morphology/Physiology | NA | NA | RHCO |
| Adapted to Coarse Textured Soils | Yes | Growth Requirements | NA | NA | RHCO |
| Adapted to Fine Textured Soils | Yes | Growth Requirements | NA | NA | RHCO |
| Adapted to Medium Textured Soils | Yes | Growth Requirements | NA | NA | RHCO |
| Anaerobic Tolerance | Medium | Growth Requirements | NA | NA | RHCO |
| CaCO3 Tolerance | Low | Growth Requirements | NA | NA | RHCO |
| Cold Stratification Required | No | Growth Requirements | NA | NA | RHCO |
| Drought Tolerance | Medium | Growth Requirements | NA | NA | RHCO |
| Fertility Requirement | Low | Growth Requirements | NA | NA | RHCO |
| Fire Tolerance | High | Growth Requirements | NA | NA | RHCO |
| Frost Free Days, Minimum | 140 | Growth Requirements | NA | NA | RHCO |
| Hedge Tolerance | Low | Growth Requirements | NA | NA | RHCO |
| Moisture Use | Low | Growth Requirements | NA | NA | RHCO |
| pH, Maximum | 7.5 | Growth Requirements | NA | NA | RHCO |
| pH, Minimum | 5.3 | Growth Requirements | NA | NA | RHCO |
| Planting Density per Acre, Maximum | 2700 | Growth Requirements | NA | NA | RHCO |
| Planting Density per Acre, Minimum | 700 | Growth Requirements | NA | NA | RHCO |
| Precipitation, Maximum | 60 | Growth Requirements | NA | NA | RHCO |
| Precipitation, Minimum | 28 | Growth Requirements | NA | NA | RHCO |
| Root Depth, Minimum (inches) | 14 | Growth Requirements | NA | NA | RHCO |
| Salinity Tolerance | None | Growth Requirements | NA | NA | RHCO |
| Shade Tolerance | Intolerant | Growth Requirements | NA | NA | RHCO |
| Temperature, Minimum (°F) | -28 | Growth Requirements | NA | NA | RHCO |
| Bloom Period | Mid Spring | Reproduction | NA | NA | RHCO |
| Commercial Availability | Routinely Available | Reproduction | NA | NA | RHCO |
| Fruit/Seed Abundance | High | Reproduction | NA | NA | RHCO |
| Fruit/Seed Period Begin | Summer | Reproduction | NA | NA | RHCO |
| Fruit/Seed Period End | Fall | Reproduction | NA | NA | RHCO |
| Fruit/Seed Persistence | Yes | Reproduction | NA | NA | RHCO |
| Propagated by Bare Root | Yes | Reproduction | NA | NA | RHCO |
| Propagated by Bulb | No | Reproduction | NA | NA | RHCO |
| Propagated by Container | Yes | Reproduction | NA | NA | RHCO |
| Propagated by Corm | No | Reproduction | NA | NA | RHCO |
| Propagated by Cuttings | No | Reproduction | NA | NA | RHCO |
| Propagated by Seed | Yes | Reproduction | NA | NA | RHCO |
| Propagated by Sod | No | Reproduction | NA | NA | RHCO |
| Propagated by Sprigs | No | Reproduction | NA | NA | RHCO |
| Propagated by Tubers | No | Reproduction | NA | NA | RHCO |
| Seed per Pound | 57000 | Reproduction | NA | NA | RHCO |
| Seed Spread Rate | Slow | Reproduction | NA | NA | RHCO |
| Seedling Vigor | High | Reproduction | NA | NA | RHCO |
| Small Grain | No | Reproduction | NA | NA | RHCO |
| Vegetative Spread Rate | Rapid | Reproduction | NA | NA | RHCO |
| Berry/Nut/Seed Product | No | Suitability/Use | NA | NA | RHCO |
| Christmas Tree Product | No | Suitability/Use | NA | NA | RHCO |
| Fodder Product | No | Suitability/Use | NA | NA | RHCO |
| Lumber Product | No | Suitability/Use | NA | NA | RHCO |
| Naval Store Product | No | Suitability/Use | NA | NA | RHCO |
| Nursery Stock Product | No | Suitability/Use | NA | NA | RHCO |
| Palatable Browse Animal | Low | Suitability/Use | NA | NA | RHCO |
| Palatable Graze Animal | Low | Suitability/Use | NA | NA | RHCO |
| Palatable Human | No | Suitability/Use | NA | NA | RHCO |
| Post Product | No | Suitability/Use | NA | NA | RHCO |
| Protein Potential | Low | Suitability/Use | NA | NA | RHCO |
| Pulpwood Product | No | Suitability/Use | NA | NA | RHCO |
| Veneer Product | No | Suitability/Use | NA | NA | RHCO |
| Active Growth Period | Spring and Summer | Morphology/Physiology | NA | NA | ACPL |
| Active Growth Period | Spring and Summer | Morphology/Physiology | Crimson King | NA | ACPL |
| Bloat | None | Morphology/Physiology | NA | NA | ACPL |
| Bloat | None | Morphology/Physiology | Crimson King | NA | ACPL |
| C:N Ratio | High | Morphology/Physiology | NA | NA | ACPL |
| C:N Ratio | High | Morphology/Physiology | Crimson King | NA | ACPL |
| Coppice Potential | Yes | Morphology/Physiology | NA | NA | ACPL |
| Coppice Potential | Yes | Morphology/Physiology | Crimson King | NA | ACPL |
| Fall Conspicuous | Yes | Morphology/Physiology | NA | NA | ACPL |
| Fall Conspicuous | Yes | Morphology/Physiology | Crimson King | NA | ACPL |
| Fire Resistant | No | Morphology/Physiology | NA | NA | ACPL |
| Fire Resistant | No | Morphology/Physiology | Crimson King | NA | ACPL |
| Flower Color | Green | Morphology/Physiology | NA | NA | ACPL |
| Flower Color | Green | Morphology/Physiology | Crimson King | NA | ACPL |
| Flower Conspicuous | No | Morphology/Physiology | NA | NA | ACPL |
| Flower Conspicuous | No | Morphology/Physiology | Crimson King | NA | ACPL |
| Foliage Color | Green | Morphology/Physiology | NA | NA | ACPL |
| Foliage Color | Red | Morphology/Physiology | Crimson King | NA | ACPL |
| Foliage Porosity Summer | Dense | Morphology/Physiology | NA | NA | ACPL |
| Foliage Porosity Summer | Dense | Morphology/Physiology | Crimson King | NA | ACPL |
| Foliage Porosity Winter | Moderate | Morphology/Physiology | NA | NA | ACPL |
| Foliage Porosity Winter | Porous | Morphology/Physiology | Crimson King | NA | ACPL |
| Foliage Texture | Coarse | Morphology/Physiology | Crimson King | NA | ACPL |
| Foliage Texture | Medium | Morphology/Physiology | NA | NA | ACPL |
| Fruit/Seed Color | Brown | Morphology/Physiology | NA | NA | ACPL |
| Fruit/Seed Color | Brown | Morphology/Physiology | Crimson King | NA | ACPL |
| Fruit/Seed Conspicuous | Yes | Morphology/Physiology | NA | NA | ACPL |
| Fruit/Seed Conspicuous | Yes | Morphology/Physiology | Crimson King | NA | ACPL |
| Growth Form | Single Stem | Morphology/Physiology | NA | NA | ACPL |
| Growth Form | Single Stem | Morphology/Physiology | Crimson King | NA | ACPL |
| Growth Rate | Rapid | Morphology/Physiology | NA | NA | ACPL |
| Growth Rate | Slow | Morphology/Physiology | Crimson King | NA | ACPL |
| Height at 20 Years, Maximum (feet) | 25 | Morphology/Physiology | NA | NA | ACPL |
| Height at 20 Years, Maximum (feet) | 35 | Morphology/Physiology | Crimson King | NA | ACPL |
| Height, Mature (feet) | 50.0 | Morphology/Physiology | NA | NA | ACPL |
| Height, Mature (feet) | 50.0 | Morphology/Physiology | Crimson King | NA | ACPL |
| Known Allelopath | No | Morphology/Physiology | NA | NA | ACPL |
| Known Allelopath | No | Morphology/Physiology | Crimson King | NA | ACPL |
| Leaf Retention | No | Morphology/Physiology | NA | NA | ACPL |
| Leaf Retention | No | Morphology/Physiology | Crimson King | NA | ACPL |
| Lifespan | Moderate | Morphology/Physiology | NA | NA | ACPL |
| Lifespan | Moderate | Morphology/Physiology | Crimson King | NA | ACPL |
| Low Growing Grass | No | Morphology/Physiology | NA | NA | ACPL |
| Low Growing Grass | No | Morphology/Physiology | Crimson King | NA | ACPL |
| Nitrogen Fixation | None | Morphology/Physiology | NA | NA | ACPL |
| Nitrogen Fixation | None | Morphology/Physiology | Crimson King | NA | ACPL |
| Resprout Ability | Yes | Morphology/Physiology | NA | NA | ACPL |
| Resprout Ability | Yes | Morphology/Physiology | Crimson King | NA | ACPL |
| Shape and Orientation | Erect | Morphology/Physiology | Crimson King | NA | ACPL |
| Shape and Orientation | Rounded | Morphology/Physiology | NA | NA | ACPL |
| Toxicity | None | Morphology/Physiology | NA | NA | ACPL |
| Toxicity | None | Morphology/Physiology | Crimson King | NA | ACPL |
| Adapted to Coarse Textured Soils | No | Growth Requirements | NA | NA | ACPL |
| Adapted to Coarse Textured Soils | No | Growth Requirements | Crimson King | NA | ACPL |
| Adapted to Fine Textured Soils | No | Growth Requirements | NA | NA | ACPL |
| Adapted to Fine Textured Soils | No | Growth Requirements | Crimson King | NA | ACPL |
| Adapted to Medium Textured Soils | Yes | Growth Requirements | NA | NA | ACPL |
| Adapted to Medium Textured Soils | Yes | Growth Requirements | Crimson King | NA | ACPL |
| Anaerobic Tolerance | None | Growth Requirements | NA | NA | ACPL |
| Anaerobic Tolerance | None | Growth Requirements | Crimson King | NA | ACPL |
| CaCO3 Tolerance | Medium | Growth Requirements | NA | NA | ACPL |
| CaCO3 Tolerance | Medium | Growth Requirements | Crimson King | NA | ACPL |
| Cold Stratification Required | Yes | Growth Requirements | NA | NA | ACPL |
| Cold Stratification Required | Yes | Growth Requirements | Crimson King | NA | ACPL |
| Drought Tolerance | Low | Growth Requirements | NA | NA | ACPL |
| Drought Tolerance | Low | Growth Requirements | Crimson King | NA | ACPL |
| Fertility Requirement | Medium | Growth Requirements | NA | NA | ACPL |
| Fertility Requirement | Medium | Growth Requirements | Crimson King | NA | ACPL |
| Fire Tolerance | Low | Growth Requirements | NA | NA | ACPL |
| Fire Tolerance | Low | Growth Requirements | Crimson King | NA | ACPL |
| Frost Free Days, Minimum | 100 | Growth Requirements | Crimson King | NA | ACPL |
| Frost Free Days, Minimum | 130 | Growth Requirements | NA | NA | ACPL |
| Hedge Tolerance | Medium | Growth Requirements | NA | NA | ACPL |
| Hedge Tolerance | None | Growth Requirements | Crimson King | NA | ACPL |
| Moisture Use | Medium | Growth Requirements | NA | NA | ACPL |
| Moisture Use | Medium | Growth Requirements | Crimson King | NA | ACPL |
| pH, Maximum | 6.8 | Growth Requirements | Crimson King | NA | ACPL |
| pH, Maximum | 7.2 | Growth Requirements | NA | NA | ACPL |
| pH, Minimum | 4.8 | Growth Requirements | NA | NA | ACPL |
| pH, Minimum | 4.8 | Growth Requirements | Crimson King | NA | ACPL |
| Planting Density per Acre, Maximum | 700 | Growth Requirements | NA | NA | ACPL |
| Planting Density per Acre, Maximum | 700 | Growth Requirements | Crimson King | NA | ACPL |
| Planting Density per Acre, Minimum | 170 | Growth Requirements | NA | NA | ACPL |
| Planting Density per Acre, Minimum | 300 | Growth Requirements | Crimson King | NA | ACPL |
| Precipitation, Maximum | 50 | Growth Requirements | NA | NA | ACPL |
| Precipitation, Maximum | 60 | Growth Requirements | Crimson King | NA | ACPL |
| Precipitation, Minimum | 24 | Growth Requirements | Crimson King | NA | ACPL |
| Precipitation, Minimum | 32 | Growth Requirements | NA | NA | ACPL |
| Root Depth, Minimum (inches) | 30 | Growth Requirements | Crimson King | NA | ACPL |
| Root Depth, Minimum (inches) | 40 | Growth Requirements | NA | NA | ACPL |
| Salinity Tolerance | Medium | Growth Requirements | NA | NA | ACPL |
| Salinity Tolerance | Medium | Growth Requirements | Crimson King | NA | ACPL |
| Shade Tolerance | Intermediate | Growth Requirements | NA | NA | ACPL |
| Shade Tolerance | Intermediate | Growth Requirements | Crimson King | NA | ACPL |
| Temperature, Minimum (°F) | -28 | Growth Requirements | NA | NA | ACPL |
| Temperature, Minimum (°F) | -33 | Growth Requirements | Crimson King | NA | ACPL |
| Bloom Period | Early Spring | Reproduction | NA | NA | ACPL |
| Bloom Period | Mid Spring | Reproduction | Crimson King | NA | ACPL |
| Commercial Availability | Routinely Available | Reproduction | NA | NA | ACPL |
| Commercial Availability | Routinely Available | Reproduction | Crimson King | NA | ACPL |
| Fruit/Seed Abundance | High | Reproduction | NA | NA | ACPL |
| Fruit/Seed Period Begin | Summer | Reproduction | NA | NA | ACPL |
| Fruit/Seed Period Begin | Summer | Reproduction | Crimson King | NA | ACPL |
| Fruit/Seed Period End | Fall | Reproduction | NA | NA | ACPL |
| Fruit/Seed Period End | Fall | Reproduction | Crimson King | NA | ACPL |
| Fruit/Seed Persistence | No | Reproduction | NA | NA | ACPL |
| Fruit/Seed Persistence | No | Reproduction | Crimson King | NA | ACPL |
| Propagated by Bare Root | Yes | Reproduction | NA | NA | ACPL |
| Propagated by Bare Root | Yes | Reproduction | Crimson King | NA | ACPL |
| Propagated by Bulb | No | Reproduction | NA | NA | ACPL |
| Propagated by Bulb | No | Reproduction | Crimson King | NA | ACPL |
| Propagated by Container | Yes | Reproduction | NA | NA | ACPL |
| Propagated by Container | Yes | Reproduction | Crimson King | NA | ACPL |
| Propagated by Corm | No | Reproduction | NA | NA | ACPL |
| Propagated by Corm | No | Reproduction | Crimson King | NA | ACPL |
| Propagated by Cuttings | No | Reproduction | NA | NA | ACPL |
| Propagated by Cuttings | Yes | Reproduction | Crimson King | NA | ACPL |
| Propagated by Seed | No | Reproduction | Crimson King | NA | ACPL |
| Propagated by Seed | Yes | Reproduction | NA | NA | ACPL |
| Propagated by Sod | No | Reproduction | NA | NA | ACPL |
| Propagated by Sod | No | Reproduction | Crimson King | NA | ACPL |
| Propagated by Sprigs | No | Reproduction | NA | NA | ACPL |
| Propagated by Sprigs | No | Reproduction | Crimson King | NA | ACPL |
| Propagated by Tubers | No | Reproduction | NA | NA | ACPL |
| Propagated by Tubers | No | Reproduction | Crimson King | NA | ACPL |
| Seed per Pound | 2640 | Reproduction | NA | NA | ACPL |
| Seed Spread Rate | Slow | Reproduction | NA | NA | ACPL |
| Seedling Vigor | Low | Reproduction | NA | NA | ACPL |
| Small Grain | No | Reproduction | NA | NA | ACPL |
| Small Grain | No | Reproduction | Crimson King | NA | ACPL |
| Vegetative Spread Rate | None | Reproduction | NA | NA | ACPL |
| Vegetative Spread Rate | None | Reproduction | Crimson King | NA | ACPL |
| Berry/Nut/Seed Product | No | Suitability/Use | NA | NA | ACPL |
| Berry/Nut/Seed Product | No | Suitability/Use | Crimson King | NA | ACPL |
| Christmas Tree Product | No | Suitability/Use | NA | NA | ACPL |
| Christmas Tree Product | No | Suitability/Use | Crimson King | NA | ACPL |
| Fodder Product | No | Suitability/Use | NA | NA | ACPL |
| Fodder Product | No | Suitability/Use | Crimson King | NA | ACPL |
| Fuelwood Product | Medium | Suitability/Use | NA | NA | ACPL |
| Fuelwood Product | Medium | Suitability/Use | Crimson King | NA | ACPL |
| Lumber Product | No | Suitability/Use | Crimson King | NA | ACPL |
| Lumber Product | Yes | Suitability/Use | NA | NA | ACPL |
| Naval Store Product | No | Suitability/Use | NA | NA | ACPL |
| Naval Store Product | No | Suitability/Use | Crimson King | NA | ACPL |
| Nursery Stock Product | Yes | Suitability/Use | NA | NA | ACPL |
| Nursery Stock Product | Yes | Suitability/Use | Crimson King | NA | ACPL |
| Palatable Browse Animal | Low | Suitability/Use | NA | NA | ACPL |
| Palatable Graze Animal | Low | Suitability/Use | NA | NA | ACPL |
| Palatable Human | No | Suitability/Use | NA | NA | ACPL |
| Palatable Human | No | Suitability/Use | Crimson King | NA | ACPL |
| Post Product | No | Suitability/Use | NA | NA | ACPL |
| Post Product | No | Suitability/Use | Crimson King | NA | ACPL |
| Pulpwood Product | No | Suitability/Use | NA | NA | ACPL |
| Pulpwood Product | No | Suitability/Use | Crimson King | NA | ACPL |
| Veneer Product | No | Suitability/Use | Crimson King | NA | ACPL |
| Veneer Product | Yes | Suitability/Use | NA | NA | ACPL |