Page 7 of 7

Re: Link to Virginia Tech Dendrology Lab

PostPosted: Thu Mar 16, 2017 9:02 am
by dbhguru
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

Re: Link to Virginia Tech Dendrology Lab

PostPosted: Thu Mar 16, 2017 9:49 am
by Erik Danielsen
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.

Re: Link to Virginia Tech Dendrology Lab

PostPosted: Thu Mar 16, 2017 3:22 pm
by dbhguru
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

Re: Link to Virginia Tech Dendrology Lab

PostPosted: Fri Mar 17, 2017 4:18 pm
by Larry Tucei
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

Re: Link to Virginia Tech Dendrology Lab

PostPosted: Sat Mar 18, 2017 5:47 pm
by dbhguru
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

Re: Link to Virginia Tech Dendrology Lab

PostPosted: Sun Mar 19, 2017 2:30 pm
by dbhguru
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