Stats Graphs

Discussion about the Geocaching Australia web site
User avatar
riblit
It's the journey.
It's the journey.
Posts: 3444
Joined: 04 April 03 6:30 pm
Location: Land Grant of John Campbell

Post by riblit » 10 August 05 11:56 pm

The graphs look pretty good C@W. Sufficient to get me interested in how to make them, so I read up on graphs over the last couple of days.<p>

Before the move the database wasn't mysql, there is a good chance it still isn't.</p>

You can set privileges on mysql from the shell if you use the mysql command. The syntax is <a href="http://dev.mysql.com/doc/mysql/en/grant.html">here</a> if you want to play around with it and have shell access to your server.<p>
Remote access is simple. Just replace 'localhost' with the fqn of the server in the connect string.

User avatar
ideology
Posts: 2763
Joined: 28 March 03 4:01 pm
Location: Sydney
Contact:

Post by ideology » 11 August 05 8:34 am

hi c@w

we are trying to figure out a way of opening up the database in a secure way
the server is constantly getting hammered by port scans, etc trying to break in all the time
opening the database is easy, but even if it is a trusted host, it's still an untrusted network and we need to make sure that we don't get hit by the zillions of attacks constantly buzzing around the net

as riblit says, the cache listings are in postgres, but it's pretty similar at the sql level except for some nested queries and stuff

test environment? umm... you're looking at it! the current geocache listings was the beta site where we were doing development and we were forced by hardware failures to turn it on earlier than expected. we had a different data model at the back end and that is why it is taking a while to get all the new functionality working - the front end didn't match the changed back-end data structures. we will be re-establishing a test environment in the near future.

in the interim we will pm you a present!

regards
i!

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 11 August 05 8:38 am

Hmmmmmmmm. postgres. Something new to learn now :D

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 12 August 05 12:23 am

Thanks to the small present from Ideology, here is some real data for Ideology, Mind Socket and (of course) myself.

Why only the 3? I've been suffering grief all night trying to load the full compliment of data, so I pulled a subset. I'll try and get some more up tomorrow.

<<REMOVED OLD GRAPH IMAGES>>

Whaddyathink?

There's probably a small glitch in my SQL statements around the fact that some finds have a status of " " which I'm not sure how to interpret. Webcams for one show up like this.

Apart from that my testing shows it working.

Still got a few things to tidy up.
Last edited by caughtatwork on 25 August 05 9:39 pm, edited 1 time in total.

Mind Socket
Posts: 1329
Joined: 29 March 03 6:04 pm
Location: Gladesville, Sydney
Contact:

Post by Mind Socket » 12 August 05 10:37 am

Coooooooooooool!!!

It would be interesting (amongst the hundreds of other potential stats/graphs) to see whether find frequency is seasonal. The find graph by month but ignoring the year would do that. Then you could plot it against average temperature and rainfall for the region. :twisted:

- Rog

PS George, we need to get out more. :p

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 12 August 05 11:46 am

Mind Socket wrote:It would be interesting (amongst the hundreds of other potential stats/graphs) to see whether find frequency is seasonal. The find graph by month but ignoring the year would do that.
<<REMOVED OLD GRAPH IMAGES>>

Yes (ish) for you and Ideology. For me, it's the middle of winter.
Last edited by caughtatwork on 25 August 05 9:40 pm, edited 1 time in total.

crew 153
9000 or more caches found
9000 or more caches found
Posts: 1099
Joined: 09 October 04 7:51 pm
Location: Calamvale, Brisbane
Contact:

Post by crew 153 » 12 August 05 11:51 am

That wouldn't be because you have cached for 2 Julys and 1 December would it :)

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 12 August 05 12:48 pm

Yes in (great) part.

I took a holiday to Queensland this year for my birthday and hit 26 caches in three days up there as well as the usual compliment in Melbourne.

Last year was only my 2nd full month (started in May 2004) so I was keen, bored, time on my hands and there were still heaps of caches around me. I got 80 in that month :shock: Nothing compared to the hundreds that are found nowadays.

So you are correct that you can't draw simple conclusions based on date. You also need to know how many months are in that month :-)

I really need to get the data for maccamob up there. Then we'll see some interesting stuff.

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 12 August 05 1:29 pm

Australia's most prolific finder (and hider I think too).

<<REMOVED OLD GRAPH IMAGES>>
Last edited by caughtatwork on 25 August 05 9:40 pm, edited 3 times in total.

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 12 August 05 1:31 pm

And of course, our favourite reviewer.

<<REMOVED OLD GRAPH IMAGES>>
Last edited by caughtatwork on 25 August 05 9:40 pm, edited 1 time in total.

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 12 August 05 1:36 pm

Just some random person I know

<<REMOVED OLD GRAPH IMAGES>>
Last edited by caughtatwork on 25 August 05 9:40 pm, edited 1 time in total.

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 12 August 05 1:38 pm

Some other shmoe I know (who gets a special URL for their graph)

<<REMOVED OLD GRAPH IMAGES>>
Last edited by caughtatwork on 25 August 05 9:41 pm, edited 1 time in total.

User avatar
Facitman
1400 or more caches found
1400 or more caches found
Posts: 463
Joined: 18 June 04 3:58 pm
Location: Melbourne
Contact:

Post by Facitman » 12 August 05 4:56 pm

Ta c@w, am wondering how long it will take my employer to work out that your other domain is as evil as the one they've blocked. :twisted:
<br><br>
Hmmm really shows up my laziness terrain-wise. Must try some Derringer caches :) :roll:

User avatar
ideology
Posts: 2763
Joined: 28 March 03 4:01 pm
Location: Sydney
Contact:

Post by ideology » 19 August 05 7:43 am

caw, we just saw your posting in the victorian forum about not having state information

is there any other types of information you need to produce whiz-bang graphs like this? if so, please let us know. we could produce a regularly updated extract that you have up-to-date information

User avatar
caughtatwork
Posts: 17015
Joined: 17 May 04 12:11 pm
Location: Melbourne
Contact:

Post by caughtatwork » 23 August 05 10:53 pm

Hi dudes.

<<REMOVED OLD GRAPH IMAGES>>

A last quick graph (after some slight mods) to the formats. Let's see how this one looks.

One moe thing and I'm finished.

i! if you could provide me one last extract (same as last time with state would be nice) I'll run one more batch of tests, then the code should be ready to hand over.

Post Reply