Link to Virginia Tech Dendrology Lab

Moderators: edfrank, dbhguru

#61)  Re: Link to Virginia Tech Dendrology Lab

Postby dbhguru » Thu Mar 16, 2017 9:02 am

Ents,

  Larry Tucei's loblolly pine data are nearly ready to be sent to VA Tech. Measurements in the import file include only those made by members who have signed on to our partnership. John won't get to Larry's second batch for maybe a week or two, but then it should show up.

  The next major conversion will be Elijah's data. Eventually we'll end up with several thousand tree measurement records.

Bob
Robert T. Leverett
Co-founder and Executive Director
Native Native Tree Society
Co-founder and President
Friends of Mohawk Trail State Forest

For this message the author dbhguru has received Likes :
Larry Tucei
User avatar
dbhguru
 
Posts: 3924
Joined: Mon Mar 08, 2010 10:34 pm
Location: Florence, Massachusetts
Has Liked: 3 times
Has Been Liked: 1035 times
Print view this post

#62)  Re: Link to Virginia Tech Dendrology Lab

Postby Erik Danielsen » Thu Mar 16, 2017 9:49 am

That's excellent, very glad this is moving forward as it is. I'm getting all my records put together in fits and spurts- this is the busy season at my day job but hopefully I'll have a more substantial chunk of data to submit in the near future.
User avatar
Erik Danielsen
 
Posts: 499
Joined: Mon Mar 17, 2014 6:46 pm
Location: NYC
Has Liked: 217 times
Has Been Liked: 272 times
Print view this post

#63)  Re: Link to Virginia Tech Dendrology Lab

Postby dbhguru » Thu Mar 16, 2017 3:22 pm

Ents,

  Attached is a download of the trees that are currently in our new SuperlativeNativeTrees Database. The entire database, or portions thereof, can be exported to CSV file. It can then be imported into Excel and saved as an Excel file in CSV format. That is what the attachment is.

  I've completed Larry's loblolly pine export file and sent it to John. It will likely be a week or two before he can import it.

  Next is working on  Elijah's dataset. It is in good shape so final field conversions will be minimal. For example, height is a pure numeric field. The trailing feet indication must be stripped off. No big deal. Lats and longs are in pure decimal degrees. Again, no big deal. Onward and upward.

Bob
Attachments
SuperlativeNativeTreesDatabaseDownload.csv
(66.1 KiB) Downloaded 9 times
Robert T. Leverett
Co-founder and Executive Director
Native Native Tree Society
Co-founder and President
Friends of Mohawk Trail State Forest
User avatar
dbhguru
 
Posts: 3924
Joined: Mon Mar 08, 2010 10:34 pm
Location: Florence, Massachusetts
Has Liked: 3 times
Has Been Liked: 1035 times
Print view this post

#64)  Re: Link to Virginia Tech Dendrology Lab

Postby Larry Tucei » Fri Mar 17, 2017 4:18 pm

Hi Bob-  The Loblolly Listing has been imported to VT site I just looked at it. Thanks to you and John for all your hard work. It's great to see it all coming together.  Larry
User avatar
Larry Tucei
 
Posts: 1753
Joined: Tue Mar 09, 2010 11:44 am
Location: Southern Mississippi
Has Liked: 632 times
Has Been Liked: 564 times
Print view this post

#65)  Re: Link to Virginia Tech Dendrology Lab

Postby dbhguru » Sat Mar 18, 2017 5:47 pm

Larry,

  Larry, I have one other spreadsheet from you. I'll get to it in due course.

All,

  I just sent John Peterson import files for Elijah's and Dale's data. Before anyone sends me another Excel spreadsheet for conversion, let me provide better guidance and some conversion routines for individual fields to get them into the right final format. If you can use the routines, please do so, but if their confusing, don't worry. Just send the data as is. I'll begin sending conversion guidance and routines in the next few days.

Bob
Robert T. Leverett
Co-founder and Executive Director
Native Native Tree Society
Co-founder and President
Friends of Mohawk Trail State Forest
User avatar
dbhguru
 
Posts: 3924
Joined: Mon Mar 08, 2010 10:34 pm
Location: Florence, Massachusetts
Has Liked: 3 times
Has Been Liked: 1035 times
Print view this post

#66)  Re: Link to Virginia Tech Dendrology Lab

Postby dbhguru » Sun Mar 19, 2017 2:30 pm

Ents,

This is the first of a series of planned posts to help with conversions to get data into the proper format for the Superlative Native Tree Database. You can always elect to send me your data for conversion, but if you want to learn how to do it on your own, hopefully, the series of posts will help.

These posts may prove more than most of you need, but going from a source that is often text-based to numeric format for the MYSQL VA Tech database can be a real pain, especially where you already have your data in a list form that is not strictly numeric and you want to import it into an SQL database looking for numeric formats. Here is an example, it is not uncommon for people to enter heights into a column in a format such as 120.5' or 120.5 ft. The destination is a field that expects a pure number as opposed to a string of characters (text) that includes a numeric piece of information. If the information is already in Excel, we have one of two courses: (1) edit the 120.5' or 120.5 ft to just be 120.5 or convert the the 120.5' or 120.5 ft to 120.5 by some conversion method that can be applied to all cells in the column with the text-based heights. The attachment (to come) will provide a solution for Excel columns with text-based entries that start as numbers and end with a character such as ' or " that is non-numeric, or possible two characters such as Ft or In. One formula won't suffice, as you'll see in the upcoming attachment.

I'll be providing solutions for converting lat and long coordinates to all decimal formats, and other good stuff. It is pretty basic to those who write macros in Excel, but can look like gibberish to others. These solutions only make sense where you already have lots of data in a list or table format, but it is not in an acceptable form to our database. Also, I don't always think of the most compact solution for a particular problem. Please feel free to propose Excel formulas that do the job more efficiently.

Bob
Robert T. Leverett
Co-founder and Executive Director
Native Native Tree Society
Co-founder and President
Friends of Mohawk Trail State Forest
User avatar
dbhguru
 
Posts: 3924
Joined: Mon Mar 08, 2010 10:34 pm
Location: Florence, Massachusetts
Has Liked: 3 times
Has Been Liked: 1035 times
Print view this post

#67)  Re: Link to Virginia Tech Dendrology Lab

Postby dbhguru » Thu Mar 30, 2017 11:33 am

Ents,

  We now have 1789 records in our NTS-Cadre-VA Tech Dendrology database. Imports have been completed for Larry, Dale, and Elijah's data. Presently, Jared Lockwood and I are entering records almost on a daily basis, but we feel kind of lonesome. We don't want to be the only ones regularly entering records. We look forward to others joining us.

   Yesterday, Jared and Ray visited Bryant Woods and Jared re-measured the Bryant black cherry and confirmed the state champion hop hornbeam. I'll defer to Jared to report the details with some great photos. The Massachusetts A-Team is alive and well.

Bob
Robert T. Leverett
Co-founder and Executive Director
Native Native Tree Society
Co-founder and President
Friends of Mohawk Trail State Forest
User avatar
dbhguru
 
Posts: 3924
Joined: Mon Mar 08, 2010 10:34 pm
Location: Florence, Massachusetts
Has Liked: 3 times
Has Been Liked: 1035 times
Print view this post

Previous

Return to Links to Other Tree Groups

Who is online

Users browsing this forum: No registered users and 1 guest