Plant database excel - how to achieve
How do you create a plant database?
- Open the plant database as described in Accessing the Plant Database.
- Search for the plants to include in the plant list (see Searching for Plants). ...
- Select the File > Create Vectorworks Plant List database command.
- Click OK.
Welcome back to our third tutorial article for the Natural Capital Plant Database that is Dan Halsey in this article we will focus on finding plants by trait, this page is under the Plant Database tab and then by clicking Plant Search this is at the designer and individual level of . Subscribe to available in the plant database The search for plants is done by first conducting a site assessment of your homestead or landscape on the types of environmental and climatic conditions so that you can select plants that are suitable for filling those places in the plant database search page you can search for plants by family name If you know implants by their family name and scientific name, you can search for them by family name here and all plants related to this plant can then be found. You can also search for plant types.
You have this huge one Plant list doesn't and has to rave about all of them, but to really have a very condensed list of plants specific to that specific search for a specific use we can resort to deciduous tree in this case, at other times we may look for it annual Plants for an annual garden or something we can use at home, or potted plants, but most of the annuals are for vegetable horticulture. We also have aquatic biennial plants and as you will soon be able to see all the plant species that are commonly identified in the landscape, this time we just click on deciduous tree and what zone are you going to plant plants in? Number of zones they can tolerate and maybe they have a specific zone while being revived, but if a plant can tolerate a number of zones or can thrive if you put a number here it will select all the plants that have that zone within their reach so we're going to say zone 3 here because I'm in zone 3 and sometimes in zone as we have a little bit of climate change here, but zone 3 will make sure the plants are what I have on this list difficult in zone 3 and the temperatures in winter have dropped to minus 35 degrees minus 30 degrees. The pH is also important for your soils and plants have a certain range for PA, so would you seven here is neutral? and we are looking for the neutral plants that are in zone 3 which are deciduous trees.
If I have a certain place now, this is more conventional landscaping, but if we are rebuilding polycultures and we have already built up the structure of the plants and the layers of our forest from the canopy to the shady trees to the fruit bushes and the perennials and the Grasses and ground cover and so maybe I'm looking for a plant, maybe even a deciduous tree that's pretty small, let's say I'm looking for a little apple tree the size of oh it's only about 12 feet wide orange tree that is 12-14 Feet wide and everything fits in this space I can enter this number here and the trees that are this size by the due date will be in the list No. w I leave these two empty because I want to see which selection I have for the height and Distribution on these plants has ecological functions, which were often reserved for shrubs and perennials, are also available here and you can use all of them See ecological functions available to us in nature Help us build functioning polycultures where ecological services are shared. Now in many cases we may want to create an underlayer of nitrogen fixers or nitrogen scavengers and if you roll over them, you will see that there is a little explanation of what this plant does, dynamic accumulators to soil growers and soil cultivators too, Wildlife Services restores air purifiers ecological functions are shared among the plants grown close together so you get some of which you can choose and find, and when you are making perennials or renewing shrubs, these plans have many of these services available from wood to biomass cut flowers, cut essential oils, fibers, medicine and pollard inge which is another type of harvest Essential oils that these plans can be used by humans to repel insects from us too so a combination of ecological functions and human uses can be used to find plants that have both and many times in our landscape we want things with multiple functions that is a principle of permaculture builds our systems with several functions and then we need fewer components solar requirements if they are carried in full sun and there is not much shade we would click on full sun if we were looking for a plant that is in partial shade and so on Below the canopy we could click on it, if we click for other plants, say underwood plants that are in full shade, then of course in that case you would click full shade.
Let's just say we have full sun we look for it and remember, we click deciduous tree zone 3 with a pH of 7 we have full sun and then we just look at our human use as food, which is a common parameter for a lot of our searches and then the soil type below here are the conditions of the location we are planting in so we have full sun in partial shade or shade has a certain type of soil that we plant in either wet or temperate and you can go to one Click row of these plants if you want all plants to be in full sun or partial shade.Get these too, but remember that when you click on these parameters the plants must do whatever you click. So if you click on both full sun and partial shade the plant must be able to live in full sun and partial shade it will move to these required plants that can adapt to full sun, some of them will be adaptable in partial shade , others just need full sun so our list stays big and in this case I just click on clay soils for our site specific conditions, if we have a drought problem or a flood problem if it is a low-lying area, click on it and if you work on the boulevard or any other area on the property with salt problems adjacent to the driveway in the northern climates on a boulevard on the city streets or even on a freeway on the city streets, reduce the list to only plants that can tolerate flooding Snow plows project the snow onto your property, especially with the smaller plants of Sta You want to click plants that are resistant to these animals and then finally root types when we divide the soil, when we try to put plants with different root types, some are bulbs, some are flat-grained or deep and then we plant in these Tap roots that do not interfere with these fibrous roots.
So we split up the soil by choosing plants that have a certain root type structure and then wrote great sorry sorry growth rate fast slow or moderate again to have another choice in these, so it is worth playing with a few times, Making your choice to see what kind of plants you are getting in your list and playing with them so that you can efficiently search for plants which I really appreciate suggest you just click on the parameters that apply to your place If you click many different fields here, your plant list will be considerably reduced, since whatever you select as a parameter must be reached by the plant before it is listed. In this case we have a deciduous tree in zone 3 with a pH of 7, we have not clicked any ecological functions, let's just say that this is not a requirement that does not mean that it does not select any plants with these functions just say that it does not have to have these functions but it is required to be a source of food. We look for deciduous trees with a fruit or a food that comes from the tree and that could be bark or, on many plants, that could also be leaves and stems It must be able to stand or need full sun and live in clay soils, so all of these are selected.
We're going downstairs to send an inquiry and Abracadabra here we have the trees in zone 7 that have edible food and in clay soils a different soil would now make a different list, but these plants are specially full of sun plants in clay soils excuse me pH 7 and in zone 3 if it were in zone four the plant list would probably be longer, but these are zone three tolerant plants and you will also see that there are public crops already out for apple forest fields for black cherry and Forchokecherry were developed, and there are some natural plant associations with some natural naturally occurring plants that accompany some of these plants as they grow, while there are also Polly crops that have the American plump. This is the list you have this is what you have now If you want to make your list longer, you can go back and take out some things or change the pH or change the soil type or whatever flexible on your location this list could get bigger or you could even just take that food parameter out and then this list would be a lot longer and you could find that information in your excel sheet later, okay at this point you have finished your search you have your plant list and you decided that this is a fair list to work with now. In that case, you might want to change something up and play with the search and get a little longer list, but the reason we want a pretty decent list because we can make selections here later is the export button that makes that list and exports related information to an Excel spreadsheet, dsheet on a Macintosh and most PCs, when you click on it, it downloads that spreadsheet and automatically opens Excel.
If not, you can open it from Excel Save the file too, but I open it directly in Excel XL opens and there we go and now we have the Excel spreadsheet. Close some of those toolbars here on the right and if you are familiar with xcel you will see that at the top we have the column names at the very top and so I usually select that row and do that fat face and I start formatting here I want the numbers when i collect these rows here i want the numbers centered so it is easier to see these and then of course and then i could lower the numbers second row to separate the titles a bit and then start making the columns widened so I can see what the common names are, maybe not so much the scientific names, but sometimes you want to see them all be unique if you don't specify what type of plant you want you can even suppress it, if you were to get all the plants, as in this case, if you didn't say deciduous you would get all the plant species that are in zone 3 with a pH of food grade are 7 which would be quite long then we have the height of the tree in feet and the width of the tree in feet and then the root depth here is seasonal interest more seasonal interest details the color of the flower and I scroll over this to see the root type Flowering time harvest time the texture of the plant in the form of the plant and these are terms used in landscaping, texture has to do with the finest, like grass that is really fine or linden leaves that are really big and us are very coarse so it looks from a distance and then the shape of the tree rounded pyramidal weeping irregular sometimes they are slanderous are sometimes spheres let the shape of the plant imagine its growth rate insect predation and that is when the plant s is prone to major minor insect disease problems and it doesn't give you a lot of information about what that is, but at this point, S does ie basically just pointing out that you might want to keep in mind that in this case there are some disease problems with these plants too, what kind of light it needs and you can now see us walking over or even though we clicked on full sun but many of them live in shade and partial shade, that's good to know what we learn as we learn about the plants hardiness of the plant zone 32 zone 8 now you can see these go up to zone 3 but they also go up to zone 8 soil tolerance and this is the irrigation regime for wet or temperate soils.Now many of these look like wet soils or dry soils can tolerate soils or temperate soils, so it's the tolerances they have for the soil that are shown Here we come to the list of all ecological functions and services and roles that plants can play in the landscape and then finally the M man uses this is the excel spreadsheet that will be downloaded note that the name has nothing to do with your search or what you do so you will want to save this file as and save this file to a folder for your design work right away would strongly recommend naming the file based on your search parameters as nowhere in this file are the search parameters you are using at the very bottom here or somewhere up above and enter your search parameters so you can remember what this list was for was and my final note is what doesn't appear on this list is the soil type.
So if you clicked clay or clicked other types, soil type doesn't show up on these lists and there is a good reason for it but I won't go into that but soil types don't show up on this list so make sure you for you to make a note here. If that search was for clay or whatever you were looking for back then, we will start our design work and build our polycultures and fill the structure of our landscape with plants by performing our search in the plant database that the Is excel spreadsheet, we can always go back to the website and do another search.You can also, if you have done this and want to get more information, just like in the plant list, you can go back and view details about these plants and more plant, that would show up there, so this is a very standardized format for information, it's very vo The purpose of this database is to be able to quickly proceed with your search.
Download your plant list and go and work in Excel and start developing your list so that you can also write the ones in your design to help you build a very usable and environmentally functional plant list ecologically balanced and functional landscapes thank you for this third tour with me Dan Halsey and me and Paula Westmoreland partners in naturalcapital thank you for your time and I look forward to showing you these sequel articles as we do our tutorials the next tutorial we do will be number four and that will be done before working in excel to develop your plant list and use it efficiently to apply to your design thank you
How do you keep track of your plants?
- Best overall: Planta.
- Best free app: Florish.
- Most informative: Blossom.
- Best for sick plants: PictureThis.
- Best for keeping track of progress: ThePlantMe.
- Best for reminders: Gardenia.
- Best for plant parents who already know the basics: Vera.
How do you create a database in Excel?
How to create a database in Excel Step 1: Entering the data Step 2: Entering Data Correctly Step 3: Know that the Rows are called Records Step 4: Know that the Columns are called Fields Step 5: Creating the Table Step 6: Using the Database Tools Step 7: Expanding the Database Step 8: Completing the Database Formatting
Where can I find the complete plants checklist in Excel?
Or use the file directly in Excel: copy it from the screen, paste it into a new worksheet, and select 'Text to Columns...' from the Data menu. The complete PLANTS checklist may have more records than Excel allows, so you might need to split it into two worksheets.
Is there a free garden planner template for Excel?
The Free Garden Planner Template for Excel Online can help you plan your garden and create an inventory of your plants, seeds and produce. This comprehensive template lets you keep track of your plants and harvests with every season, as well as also be updated with your seeds and seedlings.
How many plants are in the garden.org database?
There are 754,541 plants, and 664,894 images in this world class database of plants, which is collaboratively developed by over 4,000 Garden.org members from around the globe. ( View more stats)