U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Science and Technology > Computers
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 08-07-2016, 03:43 PM
 
999 posts, read 668,399 times
Reputation: 1153

Advertisements

We have an orchard with 4000 trees over 40 acres. 3000 pistachios 1000 Pecans.

We would like a program that sorts individual trees by rows. A-1 etc and could input a few features for each tree ie Pistachio Male maybe a 1-1- rating of condition or show an icon which after one clicks would display info or a photo of each tree.

We then would like it platted out so we could see the the entire orchard with rows , columns and the trees displayed.



What might do this?
Reply With Quote Quick reply to this message

 
Old 08-07-2016, 05:00 PM
 
Location: League City
3,488 posts, read 6,757,061 times
Reputation: 4192
Look up "software to catalog tree orchard" on google. Here's one hit with lots of ideas.

https://www.reddit.com/r/farming/com...ut_an_orchard/

If you wanted to get familiar with MS Access, you could store the data for individual trees that way. Visualizing the data from Access to a map would be another topic altogether, but it can certainly be done.
Reply With Quote Quick reply to this message
 
Old 08-07-2016, 05:30 PM
 
Location: St. Louis
3,287 posts, read 1,674,680 times
Reputation: 2163
Quote:
Originally Posted by WestGuest View Post
We have an orchard with 4000 trees over 40 acres. 3000 pistachios 1000 Pecans.

We would like a program that sorts individual trees by rows. A-1 etc and could input a few features for each tree ie Pistachio Male maybe a 1-1- rating of condition or show an icon which after one clicks would display info or a photo of each tree.

We then would like it platted out so we could see the the entire orchard with rows , columns and the trees displayed.



What might do this?
DanielWayne's post sounded good to me. As for the mapping, have you looked at your property in Google Earth?
Reply With Quote Quick reply to this message
 
Old 08-07-2016, 05:54 PM
 
Location: Florida
4,635 posts, read 3,969,190 times
Reputation: 4504
You will list each tree on its own row and in the columns you will add what ever description you want. For example


Tree # Row Number Type of Tree xxxxx xxxxx xxxxx.

You want to use a spreadsheet. Microsoft's excel will do this. Look at pivot tables for even better control. You basically have a data base and use excel to read it. Microsoft will have free courses on using.

You can also use openoffice which is free https://www.openoffice.org/ if you do not have excel.
Reply With Quote Quick reply to this message
 
Old 08-07-2016, 08:29 PM
 
999 posts, read 668,399 times
Reputation: 1153
Quote:
Originally Posted by rjm1cc View Post
You will list each tree on its own row and in the columns you will add what ever description you want. For example


Tree # Row Number Type of Tree xxxxx xxxxx xxxxx.

You want to use a spreadsheet. Microsoft's excel will do this. Look at pivot tables for even better control. You basically have a data base and use excel to read it. Microsoft will have free courses on using.

You can also use openoffice which is free https://www.openoffice.org/ if you do not have excel.

but will it plot to map view?
Reply With Quote Quick reply to this message
 
Old 08-07-2016, 09:41 PM
 
40,296 posts, read 41,850,213 times
Reputation: 16809
Quote:
Originally Posted by WestGuest View Post
but will it plot to map view?
Are trees equidistant or close to it? That's going to be more diffcicult to map if they are not. If physical row A and B is 500 linear feet but there is 200 trees in row A and 210 in row B you will need some kind reference to their location before you even begin to consider mapping them.

For example you would create a database table including 2 columns for GPS coordinates.


Tree ID--Tree Species--Tree Condition--Tree Row--Tree number in row-- Xcoodinate--Ycoordinate--ImageReference--Date Pruned--Date XXXX--Yield

Once you have this information in database table sorting and selecting things is not that difficult. You can go right into the database and select all pecan trees with condition A in Row C that were last pruned in 2015 and yielded 10 or more pounds of nuts... This is very easy to do with just a database.

Beyond that there is all kinds of things you can do with it, but it's going to take a little research and learning especially for creating maps.

If you do not have Office try Open Office or Libre Office. Create a database.

One last bit of advice, if you decide to pursue this and your trees do not have individual ID tags I'd suggest putting them on especially if they are not equidistant.
Reply With Quote Quick reply to this message
 
Old 08-08-2016, 01:35 PM
 
Location: (six-cent-dix-sept)
4,915 posts, read 2,511,124 times
Reputation: 3152
i dont think there is anything cots that will do this. you mite need to engineer something to approximate what you want to do.

[spit-balling]:
maybe using a cellular-camera-fone you can take pictures of each one with the gps tag feature enabled.
then using image-magick in a loop you can scrape off the lats and longs from each file and store them in a table.
maybe using something like open-street-map you can overlay the lats/longs onto a clik-able map with floating descriptions of each tree.
Reply With Quote Quick reply to this message
 
Old 08-08-2016, 10:08 PM
 
40,296 posts, read 41,850,213 times
Reputation: 16809
Quote:
Originally Posted by stanley-88888888 View Post
then using image-magick in a loop you can scrape off the lats and longs from each file and store them in a table.
maybe using something like open-street-map you can overlay the lats/longs onto a clik-able map with floating descriptions of each tree.
Extracting the coordinates from the image is actually a great idea to speed things along for the data collection process but unless there is something that works out of the box it is problematic for the average user.
Reply With Quote Quick reply to this message
 
Old 08-09-2016, 07:38 AM
 
Location: (six-cent-dix-sept)
4,915 posts, read 2,511,124 times
Reputation: 3152
Quote:
Originally Posted by thecoalman View Post
Extracting the coordinates from the image is actually a great idea to speed things along for the data collection process but unless there is something that works out of the box it is problematic for the average user.
this problem doesnt seem very average so i dont know of any cots software that they would be able to buy. op will either have to boil a pot of coffee and roll up their sleeves (and ask specific questions here along the way when discovering certain things dont work as expected) or pay someone to hax something together.

edit:
probably a spreadsheet would be all that is needed ?

Last edited by stanley-88888888; 08-09-2016 at 07:53 AM..
Reply With Quote Quick reply to this message
 
Old 08-09-2016, 08:54 AM
 
Location: McAllen, TX
3,989 posts, read 2,627,494 times
Reputation: 4769
I was going to suggest to just stick with Excel although it does have it's limitations. I do not know the scope of the project as in number of records, photos etc. You did mention the number of trees. I do not know how Ec el would handle large numbers of photos if that's what you wanted. The advantage do Excel is that the spreadsheet could provide a visual representation of the orchard (sort of). Ideally you would be best to design a custom application in Access or something similar. Get a quick-learn book (for dummies) for Access.

There are also build your own database systems including
Filemaker
Zoho Creator

and a google search on
Orchard Management Software
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Science and Technology > Computers
Similar Threads
Follow City-Data.com founder on our Forum or

All times are GMT -6. The time now is 05:22 AM.

© 2005-2019, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 - Top