App gallery / Home
Shown in Apothecary Olive · 16 featured looks, 520+ more to choose from
Plant finder and houseplant tracker
A plant reference seeded from the USDA PLANTS Database: every accepted plant of the United States and its territories with its PLANTS symbol, scientific name, common name and family, the 44,000 older names that point to it, and the characteristic values PLANTS records (growth habit, duration, nativity, flower colour, shade and drought tolerance, height at maturity and more). A My plants table, empty to start, tracks the plants you own: where each one lives, its light, and when it was last watered and fed. Each plant links to its PLANTS profile for maps and photos.
Database app · 6 tables · design: Apothecary Olive
Making an app from a pack is for subscribers. Sign in
Tables
- families2 columns · 548 rows in the full data
- plants6 columns · 48,994 rows in the full data
- synonyms4 columns · 44,160 rows in the full data
- characteristics5 columns · 595 rows in the full data
- plant_characteristics3 columns
- my_plants10 columns
Sources and licences
- USDA PLANTS Database — US government, public domain (images have their own conditions) (Free to use)
- Own packs (ours) — Ours (Free to use)
Shown in the app and its export: Plant names and characteristics from the USDA PLANTS Database (USDA NRCS, public domain).
Sample: the whole source. Full data: 94,297 rows, 8.6 MB. Measured 2026-10-22.
Data from plants.usda.gov, imported 2026-10-22.
The full data, for your own database
94,297 rows, 2.2 MB to download. CreativePower keeps only the made-up sample rows in your project; load the full data into your own PostgreSQL database (Supabase works): download these files into one folder, unzip the .csv.gz files, then run psql "<your connection string>" -f load.sql.