Statsguru for AFL Tables

[arrow_dactyl]

Recently I've been conversing with Paul, the man behind AFL Tables, about introducing a Statsguru like feature to the website. He told me that he's thought about doing it in the past, but was stalled, by his lack of computer know how. Paul also felt that he was getting a bit on in years to start learning the systems required and that there was a chance that he could leave the system open to being tampered with if he didn't do it properly.

I'm just posting this on here to ask if anyone either has the knowledge or knows someone to help Paul to move this project forward.

I believe it would be a addition to the website and I think that most people who have visited it in the past would agree.

 

[Barry_Badrinath]

That would be awesome. I think Ron The Bear has his own sort of private Statsguru thing going on. I think it might be private though.

 

[Ron The Bear]

there was a chance that he could leave the system open to being tampered with if he didn't do it properly.

SQL injection attack? There are some devious bastards out there.

That would be awesome. I think Ron The Bear has his own sort of private Statsguru thing going on. I think it might be private though.

Kind of. I don't have the time to maintain a public website, though. Happy to provide a copy of my db to anyone with the inclination, time and skills to build a website on top of it.

 

[arrow_dactyl]

Kind of. I don't have the time to maintain a public website, though. Happy to provide a copy of my db to anyone with the inclination, time and skills to build a website on top of it.

That'd be great. Even if it's not completed anything that you've started would be helpful

 

[Schauermann]

What is meant by a Statsguru like feature? Really like AFL tables. It so old school and working nicely. Don't think it needs any change.

 

[McCrann]

AFL Tables is awesome the way it is - the best place to check for attendances for instance (I find). Great job Paul.

As a personal habit I love monitoring record home game attendances for teams.

Adelaide need 10 crowds over 49,513 to dislodge Football Park from all but the top spot (51,140) on their Top 20 home attendances. Estimated timeline? 2022?
Carlton need 6 crowds over 77,770 to dislodge Waverley Park completely from their Top 20 home attendances and 9 crowds over 79,999 to insure all their Top 20 home attendances are at least 80,000. Estimated timeline - a long-time - 2030?
Essendon need 4 crowds over 79,999 to insure all their Top 20 home attendances are at least 80,000. Estimated timeline 2021? 4 ANZAC Days takes 8 years (2017, 2019, 2021, 2023) - but surely they'll squeeze another good crowd in there somewhere.
Fremantle need 20 crowds over 42,213 (not at Subiaco) to dislodge Subiaco completely from their Top 20 home attendances. Estimated timeline 2020?
Geelong need 6 crowds over 59,999 to insure all their Top 20 home attendances are at least 60,000 and 7 crowds over 60,228 to dislodge Docklands & Waverley Park from their Top 20 home attendances. Estimated timeline 2020?
Hawthorn need 6 crowds over 69,999 to insure all their Top 20 home attendances are at least 70,000 and 9 crowds over 72,130 to dislodge Waverley Park from all but top spot (92,935) on their Top 20 home attendances. Estimated timeline? 2022?
Melbourne need 3 crowds over 69,999 to insure all their Top 20 home attendances are at least 70,000. Estimated timeline - 2017? (3 Queen's Birthdays) - Melbourne on the improve one would hope.
North Melbourne need 4 crowds over 49,999 to insure all their Top 20 home attendances are at least 50,000, 9 crowds over 53,312 (at the MCG) to completely remove Docklands from their Top 20 home attendances and 10 crowds over 54,173 (at the MCG) to completely remove Waverley Park from their Top 20 home attendances. Estimated timeline - a long-time - 2030?
Port Adelaide need 15 crowds over 49,999 to insure all their Top 20 home attendances are at least 50,000 and 17 crowds over 50,275 to completely remove Football Park from their Top 20 home attendances. Estimated timeline - a long-time - 2030?
St. Kilda need 4 crowds over 49,999 to insure all their Top 20 home attendances are at least 50,000. Estimated time-line - 2022?
West Coast need 20 crowds over 43,527 (not at Subiaco) to dislodge Subiaco completely from their Top 20 home attendances. Estimated time-line 2020?

Any clubs not mentioned are because I can't see them doing anything 'interesting' like the above, either dislodging a stadium from the list or exceeding a certain benchmark anytime soon - ie - not in the next 20 years. I am particularly interested in how long it takes Fremantle & West Coast (who get a new Stadium - 60,000 or thereabouts in 2018) to dislodge Subiaco totally from the list. 2020 assumes an average of 7 home games a year with decent attendances. 7/11 seems reasonable, although it could take a year or two more depending on how the two teams are travelling at the time obviously.

Will Melbourne beat Hawthorn to the 70,000+ lock-out? Could be close. Ha, the things that interest me.

 

[SJ]

What is meant by a Statsguru like feature? Really like AFL tables. It so old school and working nicely. Don't think it needs any change.

Basically the ability to make queries: http://stats.espncricinfo.com/ci/engine/stats/index.html?class=1;type=team

 

[Belnakor]

Basically the ability to make queries: http://stats.espncricinfo.com/ci/engine/stats/index.html?class=1;type=team

yeah from what i understand statsgurus just builds SQL queries on the backend - essentially minor joins and where clauses? You could obviously get pretty exotic.

 

[Belnakor]

SQL injection attack? There are some devious bastards out there.

Kind of. I don't have the time to maintain a public website, though. Happy to provide a copy of my db to anyone with the inclination, time and skills to build a website on top of it.

I assume its running on SQL server not mysql/oracle/DB2 or something exotic?

 

[Ron The Bear]

I assume its running on SQL server not mysql/oracle/DB2 or something exotic?

Yeah it's in SQL Server 2014. Can supply a backup (.bak) file ready for a database restore, or extract the tables to MS Access or text files or maybe even Excel if someone wants to transfer the data to their database software of choice. Excel doesn't handle dates < 1/01/1900, though.

Anyone interested can PM me with a preferred method for sharing a large file (e.g. Dropbox), or supply a mailing address and I'll post a DVD.

NB I don't have the time to provide ongoing support!

 

[FootyJunkie]

I like AFL Tables... great reference to look up high level data on old games.

However, I suspect some of the start times displayed for some games other than those that were played at the traditional time slot on Saturday afternoon are a bit inaccurate.

Ex. I know for a fact West Coast v Essendon from Round 1 1993 was definitely a noon game local time in Perth. The Eagles did play home games that early on Sundays to accommodate the 2pm telecast in the east. The site shows that the game was 2pm local game, 4pm game out east, which did happen for Channel 7 double header Sundays, but that was not the case for Round 1.

Very minor thing though.

 

[Randomizor]

Hmm could be interesting. I make web apps for a living so would be right up my alley. I'll think about it.

 

[Billy ray]

I like AFL Tables... great reference to look up high level data on old games.

However, I suspect some of the start times displayed for some games other than those that were played at the traditional time slot on Saturday afternoon are a bit inaccurate.

Ex. I know for a fact West Coast v Essendon from Round 1 1993 was definitely a noon game local time in Perth. The Eagles did play home games that early on Sundays to accommodate the 2pm telecast in the east. The site shows that the game was 2pm local game, 4pm game out east, which did happen for Channe 7 double header Sundays, but that was not the case for Round 1.

Very minor thing though.

Is it also true that the afl scheduled west coast to play in melbourne once on queens birthday which was not a holiday back in perth?

 

[35Daicos]

Is it also true that the afl scheduled west coast to play in melbourne once on queens birthday which was not a holiday back in perth?

West Coast played Melbourne at the MCG on Monday June 13 1988.
http://afltables.com/afl/seas/1988.html#11

The previous year Collingwood had played West Coast at Subiaco Oval on Monday June 1, which would have been a holiday in WA but not in Victoria.
http://afltables.com/afl/seas/1987.html#10

In 1997 Fremantle played Adelaide at Subiaco Oval on Monday June 2, which would have been a holiday in WA but not in SA. It was a night game, however.
http://afltables.com/afl/seas/1997.html#10

In 1999 North Melbourne (Kangaroos) hosted West Coast at the SCG on Monday 14 June (Queen's Birthday holiday in some places, presumably not in Perth).
http://afltables.com/afl/seas/1999.html#11

 

[*Paul*]

I like AFL Tables... great reference to look up high level data on old games.

However, I suspect some of the start times displayed for some games other than those that were played at the traditional time slot on Saturday afternoon are a bit inaccurate.

Absolutely. Pretty much any game in WA or SA from 1987 to at least 2000 is open to question (perhaps others also). At least in the main newspapers of the day, this information I found surprisingly difficult to pin down, either not mentioned at all or uncertainty about local or east coast times. Hands were thrown up; dodgy times remained.

So as we're in pleading for help mode, if any one has some useful insights that can sort them out, do tell.

As for any query system, the main hurdle is the setup, of which I know nothing. Once it's running, maybe I can get my head around how works then. Naturally enough, I would supply the data, so it gels with the rest of the site.