Add a “water bag installed date” to planting records in the dB? We can set it under it to indicate the date and a water at was installed or make it blank to indicate there is no water bag there.

This should also be searchable in the Plantings Report, so that we can search for bags that need to be picked up.

When I tried signing in yesterday and today, says that my account is not active and I'm not able to access database.

Currently it is sorting by owner name, but that info doesn't exist on most of the legacy data. So use the address to sort by.

in plantings report, sort by zone first, street name second

When I generate a report for tree care for October, the report includes trees that have already received their 3rd year check. Is there some way to keep these off of the list? Maybe I should use different search criteria?

You should be able to store the image, the date the picture it was taken, and a note field.

Lon - I have been working on cleaning up the tree list, and filling in missing information. 2 trees on the list are duplicates: Flowering Plum and Strawberry Tree. I thought I had made edits to all records that contain these names, so that there does not appear to be records with these tree names. But I am not being allowed to delete them. (I was not able to find records for the 2nd Strawberry Tree listed.)

This is separate from the rating of the tree as there may be a well-rated tree that still has a specific problem that needs to be addressed.

When you plot plantings on a map (via plantings report results), it is possible for there to be more than one planting at a given address. There is no way currently to tell how many trees are at each address by looking at the map.

Permissions should be:

-has user access - if true the user will have the ability to alter users (including delete) in the system and can send password reset emails for other users. Users should be able to change their own information and update their own password directly.

-has write access - if true the user will be able to create and edit any records in the system (besides users as that is a separate permission.

-has delete access - if true the user will be able to delete any record in the system (besides users as that is a separate permission)

Per Liz, that is obsolete and will probably never be used now the the pre-assessed flag has been added.

Hello,

On Feb 24, 2016, Ruby 2.0.0 security maintenance will reach its end-of-life. When this happens, Ruby 2.0.0 will no longer receive security updates. We recommend that you upgrade your app to a supported Ruby version, e.g. 2.2.4, to ensure that your application is running in a secure environment.

After Feb 24, 2017, a year from the Ruby 2.0.0 sunset date, you will no longer be able to push your application using the official buildpack without upgrading to a supported Ruby version.

The following apps which have received traffic recently, that you own or are collaborated on, currently run on Ruby 2.0.0:

To migrate your app, you will need to add ruby "2.2.4" line to the top of your Gemfile if it doesn't already exist.

From there, you can do a normal deploy:

$ git add Gemfile
$ git commit -m "Upgrading Ruby to 2.2.4"
$ git push heroku master
For more details on updating your Gemfile to specify a supported Ruby see this Dev Center article.

One thing to note when upgrading your Ruby 2.0.0 app, is that Ruby is known to use slightly more memory for increased performance. If you run into R14 errors because of this, please take a look at this article

On the sunset date, Heroku will release a legacy version of its buildpack that will continue to run Ruby 2.0.0, but it will be unsupported. Please see refer to our Language Sunset Policy for more information.

We encourage you to do upgrade as soon as possible. If you have any questions, please let us know.

Happy coding,

Heroku

Search for "3001" house number and it does not show any results. There should be at least 3 results for 3001 esmond.

This was requested by Liz, as COR requires that information in the planting data we send to them.

To recreate:

-log in and create a new user
-check the email you used on the new user and you will see that it does not arrive. (review of logs confirms that email send is not being triggered. Password reset emails work fine.)

To recreate:

• Log in and click on Plantings in the nav bar.
• click on Details on the first planting
• add a note with arbitrary text
• delete the note you just added
• bug: you will still see the note on the details screen, but if you click on delete again it will say the note doesn't exist.

See #18. This is simpler than adding a "move to trash" option. HIdden records should not show in any listings or report results. If there is an issue they can be manually restored.

From Liz:

The spreadsheet I've attached contains all the information needed to contact the adopter, as well as the type of tree they are requesting. That makes it easy to send a summary on to someone else with all the important information from their adoption form (actually, it would be good to add "wires?", because that helps decide which tree to plant). As I say, this is a secondary request, since I'm not sure how much work this would be for you, and I'd hate to come back to you a month from now and say, "actually, it would be nice to have the reports included different information".

forLorenzo 11.21.16.xls.zip

After our February 7 planting, I entered the trees that we planted into the database, but the data does not seem to be there. Is it possible that the data is hidden somewhere, or did I make some other mistake?

wouldn't work on planting id 2751. there is a duplicate note - try to delete the first one.

do it.

We have 5 adoption requests where there is no room for a tree, but they remain on the list. How do we keep the information that there is no room at that address, but take that address off of the pending list? (P.s. I just added 780 32nd, so that address has not been checked to see if there is room for a tree, but there was a tree planted at that address in 2014.)

from @lizbittner

HI Lon,
I am having problems with the "map results" function in the db. (I am putting together info for tree care this weekend)

I've had problems in the past, when I click map results, i just get a new window with the search results listed, not a map. If I click enough times, I do eventually get a map. This time, I can't seem to get a map at all.

Thanks for your help with this!

It would make sorting easier when making a list of trees that still need to be assessed (by RT), to make a report that will exclude requests that have already been assessed (by RT).

The GPS latitude and longitude coordinates of tree locations are required by COR for any planting data that is sent to them.

It would be good to be able to create a report or list for a tree planting event from the adoption requests. Report criteria could include street name and date form received, or house number range and street name(s). And then be able to map the results of the report to use for the planting event. Or it could simply be an export to csv.

Right now you have to search by address, but it is possible for there to be more than one adoption request with the same address, which makes it very confusing.

Options would be

• Richmond Trees
• CORS
• Owner Planted
• Unknown

There were 4 planting records for Cerrito, but only one tree at that address. I attempted to delete 3, but looks like all 4 records are now deleted. Can you restore the record that includes tree care information from 11/15/15? Thanks!

Depends on #1 and #2. Right now after maintenance is done, you have to update the system one by one. This means you have to pull the report or search for the address, then enter a maintenance record and a note, the latter is optional.

It would be faster to have a flow that allows you to enter the planting id, maintenance record, and note all on one page and save it, then automatically be taken the the entry form again to enter another one in an endless loop. Everytime you start over, the previously entered maintenance date should be pre-populated.

This can be used to enable or disable a user account.

The info window should show:

-list each tree at the marker along with it's type.

So that we can map currently open, unfulfilled requests.

See #18

A quick review showed that this record does not show up when searching for "2901" house number and "%lowell%" street name, but IT SHOULD.

-[ RECORD 3 ]-----------+---------------------------
id                      | 2726
adoption_request_id     | 1889
tree_id                 | 44
created_at              | 2016-03-15 13:54:55.467381
updated_at              | 2017-03-20 03:29:38.926673
planted_on              | 2015-12-09
event                   |
placement               | south on 29th
plant_space_width       |
stakes_removed          | f
user_id                 | 2
last_maintenance_date   | 2017-03-19
last_status_code        | A
initial_checks_received | f
ignore                  | f

It looks like legacy adoption request data from before the creation of this system did not have the date that the adoption request was received. This means that the received_on field is null for all those entries. Since the new adoption requests report needs to allow searches by the received_on date, we need a good way to populate that data.

To resolve this, I propose to update the received_on date to equal the earliest maintenance record associated with the adoption request, minus one year, on all adoption requests where the received_on field is null. This is because maintenance is usually done within the first year that the tree is planted. This is not perfect, but will give a best-guess estimate of when the adoption request was received.

In main listing, add link to go to the details of the adoption request.

Add "Concrete" column to adoption list and report results.

Add all fields to the adoption requests export. Right now it is just a subset of fields.

Hi Lon, I am looking for a request on 32nd Street that was completed (tree died and was replaced, so I want to add a new planting for that address). I put in search criteria for street %32% and completed: both. nothing comes up.

Is there a way to ask for a report for a few different zones, but not all zones? (I tried listing with commas in between). There is just one tree due for care in Zone 2. It would be good if I could lump it with zone 3 for mapping purposes.

Thanks!

one address that did not show up on the database map, and I notice on google maps you can't get a street view: 968 34th.

this happend after switching to the new heroku-20 stack. fix it

When assessing a site, we need to know if there is concrete present at any of the planting sites so that we can make the necessary arrangements to have it removed. We should be able to track concrete status at the adoption level, as well as the planting/tree level.

For Adoption:

• Add true/false option for "Concrete"
  For Plantings:
• Add select option for "Concrete":
  • No
  • Partial
  • Full