Data from ACC

[Hitcher]

If I knew what I wanted, I wouldn't need to ask.

So long as when you didn't have your U2 moment, you didn't then presume that somebody was hiding something from you...

[Squiggles]

Of the pdf sent to Ixion, i found these interesting...(page 25 is where its at)

ACC does not collect information on the precise vehicle class associated with each Motor Vehicle Account claims. However, a recent collaborative effort with the Ministry of Transport (MoT) has allowed ACC to match its claims to records from the MoT Crash Analysis System (CAS).

Only a tad over a 1/2 those in the CAS database were matched... (108k vs 95k)

For motorcycles, 93% of recent matched CAS claims have a vehicle cc rating recorded.
Data on motorcycles without a cc rating cannot be ignored, as these help to calculate the overall relativity of Class 4 to Class 2. However, data without a cc rating cannot be used to gain information on subclass relativities within class 4.

Many Motor Vehicle Account claims are made to ACC by persons not travelling in a licensed vehicle, such as claims by pedestrians, cyclists, and equestrians. Since such claims are not associated with a particular class, the costs associated with these claims are spread across the vehicle classes, weighted by exposure. This enables each vehicle to contribute evenly to this pool of claims.

Of course, the lack of actual numbers, particularly in regards to the cc breakdown is prevalent.

[sleemanj]

Sigh

Git a reply

Hi Les - sorry, thought this was the sort of thing you were after. I'll pass your request on - probably won't be able to get anything for you until after long weekend.
Regards
David

yeah. Right. Like, a pdf report is SO much like raw data.

Heard anything yet Ixion?

[Ronin]

I thought this was interesting.

The levy rate proposals developed by ACC are based on the best information and trends
known at this stage, however both ACC and the Minister for ACC appreciate that the
increasing levels of Scheme costs are resulting in unacceptably high levy rates for all
New Zealanders.

[Eddieb]

Just seen this article about how ACC claims are dropping generally.

http://www.stuff.co.nz/national/heal...steady-decline

There's nothing bike specific in the article but if anyone knows where to get the data and there is something in their for bikes it could be useful.

or not, it could also show them going up...

[Ixion]

Nothing yet. resounding silence

I just sent a hurry up email and invoked the OIA.

[Ixion]

And a reply. "Hope to have something to you by Friday at the latest"

Reasonable , I suppose, it would take some time. What the "something" will be is the tricky bit.

[NighthawkNZ:Me]

And a reply. "Hope to have something to you by Friday at the latest"

Reasonable , I suppose, it would take some time. What the "something" will be is the tricky bit.

crock of shit if you ask me

[kwaka_crasher]

What the "something" will be is the tricky bit.

I'm thinking you should be prepared for a flaming brown paper bag on your doorstep...

[Kwaka14]

Well, I had an unsolicited call early this morning from a David Barham of ACC to say he was organising it!

I emphasised we wanted raw data , not press release figures.

He *seemed* to understand. We shall see.

As to the original $10000 figure: I'm sure that ACC have it easily accessible. But , when they supply information to the public they have to be aware of privacy issues. For instance, obviously they can't include data that has personal details (name address phone number) etc in it. Less obviously, even if the data is depersonalised and summarised, it can still be non-anonymous. For instance, if you asked for costs of crashes by month and district, including a breakdown of how much was medical costs and how much income replacement (ERC). That would probably be OK in Auckland , the number of crashes each month would be great enough that individual amounts would be lost in the big total. But, in Eketahuna, in , say, June 2006, there may have been only one crash. So the totals would actually be the details for that one crash. And it would be fairly easy to find out who it was , especially if you lived in Ekatahuna. So now you know a lot of stuff about that person (including a good estimate of their income). Oh dear.

Cleaning that sort of stuff up is time consuming and laborious - I've had to do it in the past.

I could almost guarantee they have tool like business objects or crystal or something similar that is able to pull out only the information that is required, they must have a data warehouse of information for normal reporting purposes. You want numbers (not phone numbers) and stats, surely there shouldn't be much of an issue with that.

[Ixion]

OK. We can has data !

A letter. (attached).

And a 5MB spread sheet (uncompressed)

Groan. Why a spreadsheet. Still I can get it into a database easy enough.

Dunno what's is in it, but 5MB should be something.

I'll pass it onto charles lamb also

Even zipped the files to big as an attachment, PM me an email address if you wnat a copy

EDIT: Sigh. The mountains have laboured and produced a mouse.

But it is at least something. I suspect I see some holes in it already

And I'll go back and ask for more. Of course.

[NighthawkNZ:Me]

And a 5MB spread sheet (uncompressed)

Its not really the core data you asked for now is it...

Spread sheet... ugggh

[Ixion]

Nope. But do I look surprised.

The letter BTW has a contact number, for someone who MIGHT be a tech type person.

Worth a try

[NighthawkNZ:Me]

Nope. But do I look surprised.

The letter BTW has a contact number, for someone who MIGHT be a tech type person.

Worth a try

That letter is a crook of shit and is the same BS they have been trying to push since the proposal

[zx rider]

Aahh, but you have not factored in the running costs for, bad management, meetings, lunches, expense accounts, adviser fees, lunches, bussiness class air travel, hotels, motels, lunches, admin' charges, staff vehicles and even more lunches.

See how easy it is to overspend, then blame the system, throw ya hands in the air and get more money from the public to cover it.

Someone should lose their bloody job over this, but you'll see, there will be bonuses paid out when this shit is all over.