🌳
Freetown
  • Freetown Statistics
  • SQLs
  • Custom solutions (hacks)
Powered by GitBook
On this page

Freetown Statistics

This is the working doc defining the weekly stats for the Freetown City council project Freetown the Treetown.

NextSQLs

Last updated 3 years ago

Basic Project Statistics Visualisation:

  • Number of CBOS (with captures per CBO)

  • Number of planters currently working by CBO

  • Total number of captures

  • Total number of approved captures / number of captures rejected

  • Total earnings

  • Total planter receiving earnings

  • Total number of rejected captures

  • Total number of species

  • Number of captures tracked by growers

  • number of captures report dead during verification

  • percentage of note fields filled out

  • percentage of note fields providing usable data

Visualization of total counts and month by month totals are both desired.

The open (public facing) statistics of the project should have #of CBOs, #of Planters, #of captures, #of approved trees, #of earnings and #of paid planters, #of rejected trees, #species. There has to be a total count and a monthly overview.

Link to SQL Statements