Project:LHS Graphs and Visualizations: Difference between revisions

From London Hackspace Wiki
No edit summary
No edit summary
Line 1: Line 1:
{{Project|members=[[User:Teabot|Elliot]]}}
{{Project|members=[[User:Teabot|Elliot]]}}
===Overview===
==Overview==
I'd like to supplement [http://hack.rs/cacti/graph_view.php?action=tree&tree_id=1 the Cacti graphs] that we have for LHS bandwidth and power with metrics that provide insight to the growth of our community and organisation over time.
I'd like to supplement [http://hack.rs/cacti/graph_view.php?action=tree&tree_id=1 the Cacti graphs] that we have for LHS bandwidth and power with metrics that provide insight to the growth of our community and organisation over time.


Line 12: Line 12:
To chart the initial metrics various bits of data are exposed in a Cacti friendly way.
To chart the initial metrics various bits of data are exposed in a Cacti friendly way.


==Number of members==
==Stats==
===Number of members===


We may have to wait 12 months before it becomes interesting.
We may have to wait 12 months before it becomes interesting.
Line 27: Line 28:
'''URL:''' http://london.hackspace.org.uk/member_stats.php
'''URL:''' http://london.hackspace.org.uk/member_stats.php


==IRC statistics==
===IRC statistics===
''See project: [[Project:Ircensus|ircensus]]''
''See project: [[Project:Ircensus|ircensus]]''


==Wiki statistics==
===Wiki statistics===
* We get this using the MediaWiki API:
* We get this using the MediaWiki API:


Line 59: Line 60:
'''Code:''' https://github.com/londonhackspace/monitoring
'''Code:''' https://github.com/londonhackspace/monitoring


==Mailing list activity==
===Mailing list activity===


* My thanks to JamesG for his assistance and '78.86.160.161' for the original idea. We poll and scrape the groups page for members and and message count.
* My thanks to JamesG for his assistance and '78.86.160.161' for the original idea. We poll and scrape the groups page for members and and message count.
Line 69: Line 70:
'''Code:''' https://github.com/londonhackspace/monitoring
'''Code:''' https://github.com/londonhackspace/monitoring


==Space occupancy==
===Space occupancy===
''See project: [[Project:Spacensus|spacensus]]''
''See project: [[Project:Spacensus|spacensus]]''

Revision as of 19:34, 14 February 2011

LHS Graphs and Visualizations


Members Elliot
QR code

Overview

I'd like to supplement the Cacti graphs that we have for LHS bandwidth and power with metrics that provide insight to the growth of our community and organisation over time.

We chart the following:

  • Number of members
  • IRC activity
  • Wiki activity
  • Mailing list activity
  • Space occupancy

To chart the initial metrics various bits of data are exposed in a Cacti friendly way.

Stats

Number of members

We may have to wait 12 months before it becomes interesting.

This data is stored in an Sqlite database on Turing. See the Schema. It can be queried like so: 

 SELECT COUNT(id)
 FROM users
 WHERE subscribed = true;

Cacti runs on babbage but the members database is on Turing. There is a PHP script on Turing to expose the member numbers and then a script on babbage to pull this in with a HTTP request.

Code: https://github.com/londonhackspace/monitoring URL: http://london.hackspace.org.uk/member_stats.php

IRC statistics

See project: ircensus

Wiki statistics

  • We get this using the MediaWiki API:
 http://wiki.hackspace.org.uk/w/api.php?action=query&meta=siteinfo&siprop=statistics&format=xml

It returns: 

 <?xml version="1.0"?>
 <api>
   <query>
     <statistics
       pages="759"
       articles="215"
       views="229656"
       edits="7368"
       images="186"
       users="166"
       activeusers="22"
       admins="61"
       jobs="13"
     />
   </query>
 </api>


A Perl script generates the following output for cacti: pages:759 articles:215 views:229656 edits:7368 images:186 users:166 activeusers:22 admins:61 jobs:13

Code: https://github.com/londonhackspace/monitoring

Mailing list activity

  • My thanks to JamesG for his assistance and '78.86.160.161' for the original idea. We poll and scrape the groups page for members and and message count.
 http://groups.google.com/group/london-hack-space

We have a script that outputs: members:693 messages:3123

Code: https://github.com/londonhackspace/monitoring

Space occupancy

See project: spacensus

Retrieved from ‘https://wiki.london.hackspace.org.uk/w/index.php?title=Project:LHS_Graphs_and_Visualizations&oldid=10573’