Using the WORKING SHEET  to update Master Lists

If the information is for a TREE REMOVAL, 

1. Remove the tree information from the “Medford Campus Trees - Trees in Place” master list spreadsheet. 

2. Add that information to the “Medford Campus Trees - Removed” spreadsheet master list. 

3. If there is a tree sign, add that information to the “Tree Signs in Nature Center” list.

4. Put the tree sign in the tub in the Nature Center. Make sure it is in numberical order.

5. In the last column of the “WORKING SHEET - Trees Additions and Removals" “Added to Master?,” enter Yes or a check or something to indicate you completed this. Now you are done with a tree removal.

If the information is for a TREE ADDITION,

1. Make a temporary spreadsheet with the basic information for the tree(s) including the photo link and latitude - photo & longitude - photo. Note: the temporary spreadsheet is necessary in order to focus on a few trees at a time.

   1. If there is no latitude or longitude information and no photo, then from the given location, e.g. behind Apartment 123, print a screenshot of Google My Map Template with Grids and Courts focused on the area specified. Copy the map with a new name reflecting the trees involved (e.g. New Tree behind 123).

2. Make a new Google My Map from the Template with Grids and Courts. 

   1. Import the temporary spreadsheet created in step 2.1 from Google Drive.

   2. Copy the map with a new name reflecting the trees involved (e.g. New trees added in March 2023).

3. Use the new My Map to verify the precise location of the tree(s).

   1. Print the area of the map where the tree(s) are in satellite view.

   2. Visit the approximate location with the printed map on a clipboard.

   3. Use a white pen (blue and black don't show up so well on Satellite background) to mark the map with the precise location.

4. Use the marked up paper map to enter the precise location into the spreadsheet.

   1. In the My Map on the computer, double click the Waypoint marker for the tree and then drag it from the Photo location to the spot that was verified with the paper map in the field.

   2. From the marker pop-up window, copy the new verified latitude and longitude and enter it into the “WORKING SHEET - Trees Additions and Removals" spreadsheet in the Latitude and Longitude columns.

5. Determine the Grid Number for the tree. 

   1. Once you have determined the precise location of the tree using the Google My Map created in step 4 above, use the Grid layer to see which Grid it is in.

   2. Enter the Grid Number into the WORKING SHEET speadsheet.

6. Move the photo to Google Photos from my OneDrive (or where ever it was) to a Grid Album in Google Photos.

   1. If there is not already an Album for the Grid in question, create one.

   2. Open the Grid Album and drag the tree’s photo into the album.

   3. Enter the tree’s Common and Latin names into the info pane.

   4. Copy the Google Photos link and enter it into "Tree Photo(s) Link (Google)" column in the “WORKING SHEET - Trees Additions and Removals" row for that tree.

      1.  If the photo already exists in Google Photos, but has nothing in the ‘Info’ field and/or is not included in a Grid album, 

         1. Copy and paste the Google photo link into a new screen

         2. Click on the photo to bring up the Info sheet on the right side of the screen.

         3. Copy the tree name and number from the source, (probably the Trees in Place master list), and paste it into the Info field on the photo.

         4. If there is no Grid album listed below the Info field, click on the photo, then on the three vertical dots, then click on ‘Add to album.’ 

         5. Click on the appropriate Grid, or if it is not listed, then click on ‘New album’ and create the new Grid album.

7. Enter the tree in the Master List spreadsheet, “Medford Campus Trees - Trees in Place.”

   1. Scroll to the last row in the spreadsheet.

   2. Enter the next consecutive 4xxx Tree Number.

   3. Enter relevant  information from the working spreadsheet. Note: NOT the OneDrive photo link or the Photo Lat/Lon information.

8. Add the Tree Number to Info in Google Photos entry for that tree.

9. Record Entry of the new tree by entering a ‘Yes’ or a check mark in the last column labeled “Added to Master?” in the  “WORKING SHEET - Trees Additions and Removals" spreadsheet.

10. Delete or archive any temporary spreadsheets and My Maps used to verify the location of the tree(s).