Flowchart of a development application. Anyone? Anyone?

Having scraped through all 251 development applications on file with the City of Ottawa, one thing that pops to mind is: what's the lifecycle of a development application? The city provides a "status" field, but it's not clear to me how an application weaves its way through the process.

I think the "Recommended for approval" ones might be worth highlighting. It probably means they are soon to appear at Planning Committee.

Same with "Draft report sent to Councillor" - that's probably an important window for residents to get in touch, before the Councillors comments are decided.

Here's a summary as it stands today. Anyone know what the directed graph is for development application statuses?

+------------------------------------------------------------+----------+
| status                                                     | count(1) |
+------------------------------------------------------------+----------+
| Application on Hold                                        |      140 |
| Comment Period has Ended/Issue Resolution                  |       23 |
| Comment Period in Progress                                 |       17 |
| Application Reactivated                                    |        9 |
| By-law Passed - In Appeal Period                           |        9 |
| Zoning By-law in Effect                                    |        8 |
| OMB Package Sent                                           |        6 |
| Application Recommended to Council for Approval            |        5 |
| Draft Report Sent to Councillor and Applicant for Response |        4 |
| Notice of Public Meeting Sent                              |        4 |
| Request for Agreement Received                             |        4 |
| Appealed to OMB                                            |        3 |
| Amendment Recommended to Council for Approval              |        2 |
| Application Approved                                       |        2 |
| Application Draft Approved                                 |        2 |
| Community Information and Comment Session Held             |        2 |
| Receipt of Agreement from Owner Pending                    |        2 |
| Applicant Concurs                                          |        1 |
| Application Approved by Council                            |        1 |
| Community "Heads Up" - Completed                           |        1 |
| Councillor Concurs                                         |        1 |
| Deferred by Committee                                      |        1 |
| In Appeal Period                                           |        1 |
| No Appeal                                                  |        1 |
| Second By-law Passed - In Appeal Period                    |        1 |
+------------------------------------------------------------+----------+