Parking Ticket Data

Neil made this Freedom of Information request to Runnymede Borough Council

The request was successful.

From: Neil

12 August 2009

Dear Sir or Madam,

Under the Freedom of Information Act 2000 I would like to request
some information relating to the enforcement of parking
restrictions, specifically penalty charge notices.

1. I would like to request the raw data set of parking tickets
issued in the name of the council within the last five year period
(22 July 2004 till now) broken down by:
date, time, location, narrative of infraction, current status of
case, next status of case, transaction details (ie. date, time and
method of payments made), officer ID

2. I would also like to request any information regarding
‘reward’/bonus schemes/contracts in place for your parking
enforcement officers. This is envisaged to cover the details of any
systems, including (where bonuses are paid) the amount per officer
per year, for the last five years.

Regarding part 1. ideally I would like the location unit to be
'street' but if this is not practical then under your section 16
duty to advise and assist I would expect you to contact me to
discuss how you record this geospatial data so that I may narrow my
request in a way that works for both of us.

As a supplementary, under section 16, I would also ask that you
provide some detail about the recording processes of this parking
information. E.g. What software is used? What data fields are
recorded? What other data sets it links to, etc.

If this information is held by an outside contractor then it is
your responsibility under the FOIA to obtain that information.

If it is held by another public body then please can you inform me
of this and if possible transfer the request to that public body.
My preferred format to receive this information is by electronic
means. For both parts I would like the response to be in the form
of a raw text file, tab delimited, with text qualifiers where
required.

If you need any clarification of this request or if it is too broad
in any way please feel free to email me. If some parts of this
request
are more difficult to answer than others please release the
answerable material as it is available rather than hold up the
entire request for the contested data.

If FOI requests of a similar nature have already been asked could
you please include your responses to those requests. I would be
grateful if you could confirm in writing that you have received
this request, and I look forward to hearing from you within the
20-working day statutory time period.

Yours faithfully,

Neil Houston

Link to this

From: Mervyn Robins
Runnymede Borough Council

18 August 2009

Dear Mr. Houston.

I am in receipt of your request under the Freedom of Information Act. In
order to progress this I would like to clarify some points please.

Firstly, information has been requested for the period from 22 July 2004.
Runnymede Borough Council took on Civil Parking Enforcement
responsibilities on behalf of the County Authority in November 2004. Prior
to that date our enforcement activities were confined only to the Borough
car parks. On taking on the new responsibilities we renewed our Debt
Management software to the current supplier, Spur information systems. I
am advised that data prior to this date is therefore no longer held by the
Council and we are therefore unable to provide it.

Secondly you have requested to be provided with `Raw data' a number of
fields recorded under that description would contain personal information
(such as names, addresses and vehicle registration numbers.) Under the
Data Protection Act we are unable to disclose that information. Currently
we have a number of reports set up on our systems to meet the requirements
of statutory reporting, these are set up with our providers to produce
data held under the following fields. Month, Location, Contravention,
Status, Numbers issued, Numbers paid and Numbers cancelled. Can you please
therefore confirm that that information would meet your needs as that
information can be provided with in a reasonable time?

In order to provide the detailed information requested in your e-mail a
significant amount of officer time would be involved the cost of which
will exceed the £450 level where a fee may be chargeable if you wish to
obtain that information.

Can you please confirm that you wish me to proceed with this and provide
you with the data we currently have available?

Regards

Mervyn Robins

Parking Manager, Technical Services.

Runnymede Borough Council.

8 [1][email address]

References

Visible links
1. mailto:[email address]
mailto:[email address]

Link to this

From: Neil

25 August 2009

Mervyn,

Firstly, thanks for the response.

On the first point, only since the council took over is fine,
(therefore Nov 2004).

Regarding the report from Spur, thanks for confirming what
information you are able to provide, by using the 'front end
reporting' features of the system you use to record PCN details.

I would just like to clarify - is it possible that the IT/database
administrator can produce the selected field extract from the
database backend (In my experience, databases often sit on MySQL/MS
SQL/Oracle backends - and the IT/database Administrator of the
system can often extract out information that the systems
'reporting' options don't allow).

If the size of the data extract is too large for it to be
compressed (zipped) and emailed, then I am happy to provide you
with FTP details (the IT contact could transfer the files), or to
receive the data on a CD/DVD. I understand that to produce some
reports in a 'paper' format is not the best for either of us.

Sizewise, the physical number of records will be no issue for me; I
cannot narrow down the request anymore than it already is. (That
being a limited number of fields, by PCN issued, for the 5 year
period).

Obviously if some of the information is not held in the database
(perhaps regarding the payment status etc,) then I would not want
to trouble you by having someone to review the actual case records
(as I understand this would be above and beyond the £450/2.5 day
limit)

Thanks,
Neil

Link to this

From: Mervyn Robins
Runnymede Borough Council

26 August 2009

Neil

Thank you for your response, I will take some advice on this from those more familiar with the capabilities of the systems we use. I advised you of the reporting systems currently written which are available to 'front line' users such as those in my department searching the SPUR system we currently use. It may be necessary to have additional reports created to provide the information you are requesting and also removing those aspects covered by Data Protection. As you have anticipated certain aspects of payment information are held on different systems and I am therefore grateful for your observations on that point.

I will get back to you in due course with our progress on this.

Regards

Mervyn

show quoted sections

Link to this

From: Mervyn Robins
Runnymede Borough Council

6 October 2009


Attachment PCN issued.xls
5.5M Download View as HTML

Attachment Payment method PCN.xls
3.0M Download View as HTML


Dear Neil

Please find the attached spreadsheets returning the information requested.
I apologise it has taken a while, but as I explained previously we did not
have a report set up to deal with it.

In relation to the second part of your request. This Council directly
employs four Civil Enforcement Officers who are subject to the same terms
and conditions of employment as other members of the Council staff. There
are therefore no `bonus' or `reward' schemes for their CEO activities. The
staff are directly appraised, by myself, in accordance with the Councils
appraisal policy. They have no objectives set in relation to the quantity
of PCNs they issue. The only assessment made by me is over the quality of
those notices.

I hope this assists.

Regards

Mervyn Robins

Parking Manager, Technical Services.

Runnymede Borough Council

Link to this

Things to do with this request

Anyone:
Runnymede Borough Council only: