Closed jamezpolley closed 3 years ago
RTK: 462 unique requestors, up from 317 the previous year. 957 total requests up from 816
deploy@ip-172-31-43-31:/srv/www/production/current$ bundle exec rails c production
Loading production environment (Rails 3.2.22.3)
irb(main):001:0> InfoRequest.where("created_at >= ? AND created_at < ?", "2018-07-01", "2019-07-01").collect { |i| i.user }.uniq.count
InfoRequest Load (15.5ms) SELECT "info_requests".* FROM "info_requests" WHERE (created_at >= '2018-07-01' AND created_at < '2019-07-01')
=> 317
irb(main):002:0> InfoRequest.where("created_at >= ? AND created_at < ?", "2019-07-01", "2020-07-01").collect { |i| i.user }.uniq.count
=> 462
irb(main):003:0> InfoRequest.where("created_at >= ? AND created_at < ?", "2019-07-01", "2020-07-01").count
(5.6ms) SELECT COUNT(*) FROM "info_requests" WHERE (created_at >= '2019-07-01' AND created_at < '2020-07-01')
=> 957
irb(main):004:0> InfoRequest.where("created_at >= ? AND created_at < ?", "2018-07-01", "2019-07-01").count
(1.9ms) SELECT COUNT(*) FROM "info_requests" WHERE (created_at >= '2018-07-01' AND created_at < '2019-07-01')
=> 816
irb(main):005:0>
RTK breakdown by agency and state:
root@ip-172-31-43-31:~# psql -U rtk-production -d rtk-production -h postgresql.czhqms2kijym.ap-southeast-2.rds.amazonaws.com -AF,< agency-state-breakdown.psql > 1920.csv
root@ip-172-31-43-31:~# cat agency-state-breakdown.psql
SELECT t.name as name, pb.name as tag, COUNT(r.*) FROM info_requests as r, public_bodies as pb, has_tag_string_tags as t WHERE (r.created_at >= '2019-07-01' AND r.created_at < '2020-07-01') and r.public_body_id = pb.id and pb.id = t.model_id and t.name
in ('ACT','NSW','NT','QLD','SA','TAS','VIC','WA','federal') GROUP BY t.name, pb.name ORDER BY t.name, pb.name;
root@ip-172-31-43-31:~#
Full results at https://docs.google.com/spreadsheets/d/1llrfswJYgYSbWVgyMSf_tOkCqEeJ1vNWERrmR1fn9IA/edit#gid=804761463
state | count |
---|---|
ACT | 7 |
federal | 671 |
NSW | 107 |
NT | 7 |
QLD | 57 |
SA | 11 |
TAS | 9 |
VIC | 48 |
WA | 43 |
Grand Total | 960 |
state | agency | count |
---|---|---|
federal | Department of Home Affairs | 141 |
federal | Department of Human Services | 38 |
federal | Department of the Prime Minister and Cabinet | 32 |
federal | NBN Co Limited | 28 |
federal | Department of Health | 27 |
federal | Australian Taxation Office | 25 |
federal | Australian Federal Police | 20 |
federal | Department of Communications and the Arts | 18 |
federal | Department of Defence | 18 |
federal | Department of Veterans' Affairs | 17 |
federal | Australian Broadcasting Corporation | 16 |
federal | Australian Securities and Investments Commission | 15 |
federal | Administrative Appeals Tribunal | 14 |
WA | Administrative Appeals Tribunal | 14 |
federal | Department of the Treasury | 13 |
federal | Attorney-General's Department | 12 |
federal | Federal Court of Australia | 12 |
federal | Australian Prudential Regulation Authority | 10 |
federal | Department of Foreign Affairs and Trade | 10 |
federal | Department of the Environment and Energy | 10 |
federal | Therapeutic Goods Administration | 9 |
NSW | Roads and Maritime Services | 9 |
federal | Office of the Australian Information Commissioner | 8 |
QLD | Brisbane City Council | 8 |
federal | Department of Finance | 7 |
PlanningAlerts Contributors:
Total Contributions: 544 /tmp/pa_contribs/pa_contributors.txt
Contributors:
1 Daniel Hoolihan
15 James Polley
500 Matthew Landauer
1 Michael Bone
27 muzza1976
Calculated with https://raw.githubusercontent.com/wiki/openaustralia/oaf/scripts/pa_contribs.sh
Contributors as per https://raw.githubusercontent.com/wiki/openaustralia/oaf/scripts/contributor-count.sh (with dates changed)
2018-07-01 -> 2019-07-01:
36 Ben Fairless
1 Deploy user
1 Eric Tam
218 James Polley
1 Kevin Liao
6 Liz Conlan
1 Martin Wright
1051 Matthew Landauer
18 MicaelaMicaela
2019-07-01 -> 2020-07-01:
1 abimysoc
11 dependabot[bot]
2 Gareth Rees
1 Graeme Porteous
165 James Polley
1 Liz Conlan
1 Luke Bacon
10 mackaymackay
1357 Matthew Landauer
7 MicaelaMicaela
7 mlandauer@gmail.com
1 Nigel Jones
REPOS=("morph"
"morph-cli"
"openaustralia-parser"
"twfy"
"publicwhip"
"righttoknow"
"planningalerts"
"australian_local_councillors_images"
"australian_local_councillors_popolo"
"alaveteli"
"infrastructure"
"openaustralia"
"yinyo"
"buildstep"
)
Similar to #299 but for the 2019/20 FY. Process is documented at https://github.com/openaustralia/oaf/wiki/Calculating-Volunteer-numbers-for-ACNC-reports