Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 29-06-2007, 10:07 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Jun 2007
Posts: 1
Default Downloadable Horticulture database?

Does anyone know where I can get a csv file of a horticulture database
for a project I'm working on? I'm trying to create an easy-to-use
online database to help me source plants for my design projects. The
project is www.landscapedesignexchange.com.

Any leads on data would be appreciated.

Thanks.

Michael

  #2   Report Post  
Old 29-06-2007, 10:24 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Jul 2006
Posts: 195
Default Downloadable Horticulture database?

In article . com,
wrote:

Does anyone know where I can get a csv file of a horticulture database
for a project I'm working on? I'm trying to create an easy-to-use
online database to help me source plants for my design projects. The
project is
www.landscapedesignexchange.com.

Any leads on data would be appreciated.

Thanks.

Michael


It has been awhile. But I believe the Microsoft product Excel can
import CSV.

Bill who loves JMP and wonders if this helps?

--

S Jersey USA Zone 5 Shade
http://www.ocutech.com/ High tech Vison aid
This article is posted under fair use rules in accordance with
Title 17 U.S.C. Section 107, and is strictly for the educational
and informative purposes. This material is distributed without profit.
  #3   Report Post  
Old 29-06-2007, 10:38 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Jul 2006
Posts: 1,392
Default Downloadable Horticulture database?

"William Wagner" wrote in message
...
In article . com,
wrote:

Does anyone know where I can get a csv file of a horticulture database
for a project I'm working on? I'm trying to create an easy-to-use
online database to help me source plants for my design projects. The
project is
www.landscapedesignexchange.com.

Any leads on data would be appreciated.

Thanks.

Michael


It has been awhile. But I believe the Microsoft product Excel can
import CSV.

Bill who loves JMP and wonders if this helps?


He's looking for the data, not the program to import the data.


  #4   Report Post  
Old 29-06-2007, 10:50 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Jul 2006
Posts: 195
Default Downloadable Horticulture database?

In article ,
"JoeSpareBedroom" wrote:

"William Wagner" wrote in message

et...
In article . com,
wrote:

Does anyone know where I can get a csv file of a horticulture database
for a project I'm working on? I'm trying to create an easy-to-use
online database to help me source plants for my design projects. The
project is
www.landscapedesignexchange.com.

Any leads on data would be appreciated.

Thanks.

Michael


It has been awhile. But I believe the Microsoft product Excel can
import CSV.

Bill who loves JMP and wonders if this helps?


He's looking for the data, not the program to import the data.


Oh well here is 81400 hits.

http://www.google.com/search?q=csv%2...ure%20database

Bill

--

S Jersey USA Zone 5 Shade
http://www.ocutech.com/ High tech Vison aid
This article is posted under fair use rules in accordance with
Title 17 U.S.C. Section 107, and is strictly for the educational
and informative purposes. This material is distributed without profit.
  #5   Report Post  
Old 30-06-2007, 03:40 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Aug 2006
Posts: 92
Default Downloadable Horticulture database?

On Jun 29, 2:07 pm, wrote:
Does anyone know where I can get a csv file of a horticulture database
for a project I'm working on? I'm trying to create an easy-to-use
online database to help me source plants for my design projects. The
project iswww.landscapedesignexchange.com.

Any leads on data would be appreciated.

Thanks.

Michael


You can download your USDA Plants database selection in comma-
delimited text file format from he
http://plants.nrcs.usda.gov/cgi_bin/...uery_down.html
.. You can then convert to MS Excel by opening file with the program.

If other sources exist, you may find them on the EWIRM lists at
www.ergonica.com/Weed_Lists1.htm .

-----
Weeding wisdom: Mulch preventive, Twist defensive - Stow the Hoe
until you Sow!





  #6   Report Post  
Old 01-07-2007, 03:46 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Jul 2007
Posts: 7
Default Downloadable Horticulture database?

Thanks for the posts. I have found a few. I had already looked at
the USDA csv, but it's over 200k plants, many of which are weeds or
food crop. It would be rather time consuming to go through and pick
out the plants significant to landscaping.


I'll check out the links you guys gave. Most of the stuff I have
found, people want to sell their database. I'm willing to trade the
information with anyone else who has info, so it's not like I'm only
looking to receive.

Thanks again for all the leads.

MIchael

On Jun 29, 4:07 pm, wrote:
Does anyone know where I can get a csv file of a horticulturedatabase
for a project I'm working on? I'm trying to create an easy-to-use
onlinedatabaseto help me source plants for my design projects. The
project iswww.landscapedesignexchange.com.

Any leads on data would be appreciated.

Thanks.

Michael



  #7   Report Post  
Old 01-07-2007, 08:34 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Jul 2006
Posts: 1,392
Default Downloadable Horticulture database?

Does the USDA file put genus, species and varietal name in 3 different
fields?

wrote in message
oups.com...
Thanks for the posts. I have found a few. I had already looked at
the USDA csv, but it's over 200k plants, many of which are weeds or
food crop. It would be rather time consuming to go through and pick
out the plants significant to landscaping.


I'll check out the links you guys gave. Most of the stuff I have
found, people want to sell their database. I'm willing to trade the
information with anyone else who has info, so it's not like I'm only
looking to receive.

Thanks again for all the leads.

MIchael

On Jun 29, 4:07 pm, wrote:
Does anyone know where I can get a csv file of a horticulturedatabase
for a project I'm working on? I'm trying to create an easy-to-use
onlinedatabaseto help me source plants for my design projects. The
project iswww.landscapedesignexchange.com.

Any leads on data would be appreciated.

Thanks.

Michael





  #8   Report Post  
Old 01-07-2007, 11:34 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Jul 2007
Posts: 7
Default Downloadable Horticulture database?

On Jul 1, 2:34 pm, "JoeSpareBedroom" wrote:
Does the USDA file put genus, species and varietal name in 3 different
fields?

wrote in message

oups.com...

Thanks for the posts. I have found a few. I had already looked at
the USDA csv, but it's over 200k plants, many of which are weeds or
food crop. It would be rather time consuming to go through and pick
out the plants significant to landscaping.


I'll check out the links you guys gave. Most of the stuff I have
found, people want to sell their database. I'm willing to trade the
information with anyone else who has info, so it's not like I'm only
looking to receive.


Thanks again for all the leads.


MIchael


On Jun 29, 4:07 pm, wrote:
Does anyone know where I can get a csv file of a horticulturedatabase
for a project I'm working on? I'm trying to create an easy-to-use
onlinedatabaseto help me source plants for my design projects. The
project iswww.landscapedesignexchange.com.


Any leads on data would be appreciated.


Thanks.


Michael


No. It puts it all in one field. So after having to sort thru 200k
of plants to find out the ones significant to landscaping, I'd have to
transform it. After all that, it is missing all of the relevant
criteria to select a plant for a landscape project. It seems to me
that it is more trouble than it's worth just to get the scientific/
common name and nothing else.

  #9   Report Post  
Old 01-07-2007, 11:39 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Jul 2006
Posts: 1,392
Default Downloadable Horticulture database?

wrote in message
oups.com...
On Jul 1, 2:34 pm, "JoeSpareBedroom" wrote:
Does the USDA file put genus, species and varietal name in 3 different
fields?

wrote in message

oups.com...

Thanks for the posts. I have found a few. I had already looked at
the USDA csv, but it's over 200k plants, many of which are weeds or
food crop. It would be rather time consuming to go through and pick
out the plants significant to landscaping.


I'll check out the links you guys gave. Most of the stuff I have
found, people want to sell their database. I'm willing to trade the
information with anyone else who has info, so it's not like I'm only
looking to receive.


Thanks again for all the leads.


MIchael


On Jun 29, 4:07 pm, wrote:
Does anyone know where I can get a csv file of a horticulturedatabase
for a project I'm working on? I'm trying to create an easy-to-use
onlinedatabaseto help me source plants for my design projects. The
project iswww.landscapedesignexchange.com.


Any leads on data would be appreciated.


Thanks.


Michael


No. It puts it all in one field. So after having to sort thru 200k
of plants to find out the ones significant to landscaping, I'd have to
transform it. After all that, it is missing all of the relevant
criteria to select a plant for a landscape project. It seems to me
that it is more trouble than it's worth just to get the scientific/
common name and nothing else.


You should be able to parse the words into separate columns easily.
Assuming, for example, that you have things like this in one field:

Pieris japonica

(all words separated by spaces, in other words), do a search-replace,
converting all spaces into some useless character like the tilde ~. Then,
use the text to columns thing with the tilde as the delimiter. Voila.


  #10   Report Post  
Old 02-07-2007, 03:43 PM posted to rec.gardens
external usenet poster
 
First recorded activity by GardenBanter: Jul 2007
Posts: 7
Default Downloadable Horticulture database?

On Jul 1, 5:39 pm, "JoeSpareBedroom" wrote:
wrote in message

oups.com...



On Jul 1, 2:34 pm, "JoeSpareBedroom" wrote:
Does the USDA file put genus, species and varietal name in 3 different
fields?


wrote in message


groups.com...


Thanks for the posts. I have found a few. I had already looked at
the USDA csv, but it's over 200k plants, many of which are weeds or
food crop. It would be rather time consuming to go through and pick
out the plants significant to landscaping.


I'll check out the links you guys gave. Most of the stuff I have
found, people want to sell their database. I'm willing to trade the
information with anyone else who has info, so it's not like I'm only
looking to receive.


Thanks again for all the leads.


MIchael


On Jun 29, 4:07 pm, wrote:
Does anyone know where I can get a csv file of a horticulturedatabase
for a project I'm working on? I'm trying to create an easy-to-use
onlinedatabaseto help me source plants for my design projects. The
project iswww.landscapedesignexchange.com.


Any leads on data would be appreciated.


Thanks.


Michael


No. It puts it all in one field. So after having to sort thru 200k
of plants to find out the ones significant to landscaping, I'd have to
transform it. After all that, it is missing all of the relevant
criteria to select a plant for a landscape project. It seems to me
that it is more trouble than it's worth just to get the scientific/
common name and nothing else.


You should be able to parse the words into separate columns easily.
Assuming, for example, that you have things like this in one field:

Pieris japonica

(all words separated by spaces, in other words), do a search-replace,
converting all spaces into some useless character like the tilde ~. Then,
use the text to columns thing with the tilde as the delimiter. Voila.


I understand parsing text files to csv and then flipping it to a
database. I've worked on quite a few databases as my day job is as a
computer geek (I'm only a plant geek by night/weekends). The major
problem with the USDA csv is that it contains a massive amount of
irrelevant data. Beyond that, not all plants fall easily into the
example Genus Species Cultivar/Var. For example, Abelia ' Edward
Goucher' omits species and has 2 words for cultivar. I've been doing
quite a bit of clean-up on the csv files I've been able to get. I'm
just dreading tackling the USDA csv with 200k+ entries then
eliminating tens of thousands of irrelevant entries and then cleaning
up 40-60% that don't easily convert.

Then I end up with tens of thousands of relevant plants with zero
information about them. Over time as I use them in design projects I
can add data, but I'm still forced to go outside my database to pull
relevant information.

I know this is going to be a massive undertaking and an on-going
project. I appreciate all the suggestions and if anyone is interested
in trading content, get with me at http://www.landscapedesignexchange.com.
Thanks again.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
looking for downloadable owners manual Eric Lawns 2 21-09-2004 05:19 AM
OT (sorry!) Horticulture/landscaping employment agencies in the E. Anglia region Synaptic Flow United Kingdom 4 27-11-2003 11:20 PM
Enterting the Horticulture Field II/Thank you. Joel Jac0b Gardening 4 30-03-2003 05:08 AM
Entering the Horticulture Field. :) Joel Jac0b Gardening 7 27-03-2003 01:32 AM


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 GardenBanter.co.uk.
The comments are property of their posters.
 

About Us

"It's about Gardening"

 

Copyright © 2017