London Borough of Havering requests via KADOE

Francis Jackson made this Freedom of Information request to Driver and Vehicle Licensing Agency

This request has been closed to new correspondence from the public body. Contact us if you think it ought be re-opened.

The request was partially successful.

Francis Jackson

Dear Driver and Vehicle Licensing Agency,

This request relates to the previous request for the following information that I had made back on the 4th February 2018.
https://www.whatdotheyknow.com/request/l...

In the above thread I asked a few questions of clarification to the format of the data held (7th May - 17 days) as I have not received any response on that matter, I trust that there is no issue either from a technical or cost implication of providing me with the data in the format that I had requested.

Following the ICO decision notice and your subsequent letter of information, I shall amend the request as below.

------------------------------------------------------------------------------------------------------------------------
Please could you provide me with details of ALL requests made by London Borough of Havering (London Borough of Havering, Traffic & Parking control, Town Hall, Main Road, Romford, RM1 3BB) for registered keeper information via the Keeper at Date of Event (KADOE) system.

PERIOD
The request is for data that covers the following period
1st January 2016 - 24th May 2019

REQUEST DETAILS
Please include the following items of information that is held against EACH of the individual requests made by Havering via KADOE

1./ Date of Event (format: day of month/month/year)
2./ Date of Enquiry (format: day of month/month/year)
3./ Date of response by DVLA (format: day of month/month/year)
4./ Enquiry reason
5./ Enquiry reference number (as provided by London Borough of Havering)
6./ Registered keeper primary database key
7./ Response file name / Batch id

CLARIFICATION POINTS
Items 1-4 you have commented on already in your previous response. I shall provide further clarification on items 5, 6 and 7 below. I ask that you provide advice and assistance with these items if applicable.

Detail (5) The form of the enquiry reference number used by Havering is in the form HGHG000001234, it relates to a record held in the Havering system. Are you familiar with the format of Havering systems? I ask you to consider whether the likelihood of the ability to match against that information to retrieve the VRM. To do so I would need access to the systems of Havering Council, and by that fact the information requested in this request would be available in that system anyway. Also the fact is that the event is based on a vehicle not a person and there is no such evidence that actually identifies a person i.e. the driver.

https://ico.org.uk/for-organisations/gui...

Detail (6) Havering request is made against the VRM, however I would expect your database to use index keys in the tables, only an index key is required that relates to the VRM is requested. Are there any primary or index keys present in the database table?

Detail (7) In my original request I enquired about a batch id, you mentioned in your response that there is no batch id. My understanding is that the response from the KADOE system XML schema indicates that there is such a batch id. The response file name would also be sufficient if it is possible to provide that. For example, on 30th Dec 2017, the DVLA issued a file with the name: DVLIMD6437845340.xml. Is there any such identifier that indicate the file that the request details were returned?

According to your previous response you have confirmed that items 1-4 are available, if available items 5-7, however if on review of my comments above the DVLA still wishes to withhold items 5-7 or the cost implications are such that would exceed the then please provide details of 1-4 along with the reasons for withholding items 5-7.

KADOE DATABASE SERVER EDITION AND VERSION
I note in your previous response that you have mentioned, "the DVLA does not hold the data in the format that you have requested". I have asked several questions that relate to this topic, however I have not received any response on that matter under the decision notice, which is disappointing. Your responses imply that there may be some issue here, yet you have not provided any clarity whether there is or not, it seems very guarded.

The IDEAL for me is that the data be supplied in the following format. All major database servers (Oracle, SQL Server etc) provide an interface that allow export of data to standard csv file.

https://dabblingwithdata.wordpress.com/2...

8./ Please provide the name and version of the database server used for the KADOE system

IDEAL FORMAT OF FILE
Ideally the data supplied for each request of items 1-7 (or 1-4 if 5-7 refused), should be in a standard text delimited file format, with each request detail provided on a single line.

The first line containing headers of the columns and details of each request made on a new line. Where duplicate requests have been made for the same enquiry reference number, they should all be included with the appropriate dates.
file example,

EventDate,EnquiryDate,ResponseDate,EnquiryReason,EnquiryReference,KeeperIndexKey,ResponseFile
21/2/2018,25/2/2018,26/2/2018,MovingTraffic,HG00001,5623,DVLIMD0000000001.xml
24/2/2018,25/2/2018,26/2/2018,MovingTraffic,HG00002,5624,DVLIMD0000000001.xml
15/4/2018,16/4/2018,17/4/2018,MovingTraffic,HG00001,5623,DVLIMD0000000002.xml

I sincerely hope that you are now able to provide this information. I thank you for your time in this matter.

Yours faithfully,
Francis Jackson

Francis Jackson

Dear Driver and Vehicle Licensing Agency,

Please may I have a confirmation of receipt for this request dated: 24th May 2019

Yours faithfully,

Francis Jackson

FOI FOI, Driver and Vehicle Licensing Agency

Good Morning Mr Jackson

Thank you for your email yesterday and apologies for not acknowledging receipt of your email dated 24 May before now.

The matter is in hand and you can expect to receive a response no later than 21 June. As a result of previous correspondence regarding the matter, the reference number FOIR7631 has been re-allocated to this request of 24 May.

Regards
Ian

Ian Aubrey
Freedom of Information Team – C2/W
Data Sharing & Protection Group | Strategy, Policy and Communications Directorate | DVLA | Swansea | SA6 7JL

New vehicle tax rates for cars registered on or after 1 April 2017.
Find out more: www.gov.uk/newvehicletaxrates

************************************************************************************
Correspondents should note that all communications to DVLA may be automatically logged, monitored and/or recorded for lawful purposes.

Please visit www.gov.uk/browse/driving for government information on all aspects of motoring, ranging from log books and driving licences to driving tests and vehicle tax.
************************************************************************************

FOI FOI, Driver and Vehicle Licensing Agency

Good Afternoon Mr Jackson

I wrote to you on 6 June acknowledging receipt of your request and advised you that you should expect to receive a response by today (Friday 21 June). It was hoped that you would have received a response today but unfortunately, due to an oversight with dates, a response is now likely to be with you on Monday 24 June.

The DVLA is well aware of its legal obligation under the FOI Act to respond within 20 working days and I apologise for this oversight.

Regards
Ian

Ian Aubrey
Freedom of Information Team – C2/W
Data Sharing & Protection Group | Strategy, Policy and Communications Directorate | DVLA | Swansea | SA6 7JL

New vehicle tax rates for cars registered on or after 1 April 2017.
Find out more: www.gov.uk/newvehicletaxrates

************************************************************************************
Correspondents should note that all communications to DVLA may be automatically logged, monitored and/or recorded for lawful purposes.

Please visit www.gov.uk/browse/driving for government information on all aspects of motoring, ranging from log books and driving licences to driving tests and vehicle tax.
************************************************************************************

Francis Jackson

Dear Mr Aubrey,

Many thanks, I appreciate the update.

Kind regards,
Francis Jackson

FOI FOI, Driver and Vehicle Licensing Agency

7 Attachments

Dear Mr Jackson

Please find attached the reply to your Freedom of Information request FOIR7631.

Regards

Ian Davies
Freedom of Information Team, Data Sharing & Protection Group | Strategy, Policy & Communications Directorate| C2 - West | DVLA | Swansea | SA6 7JL
Twitter: @dvlagovuk

We can always spot an untaxed car. Tax it or lose it.
Rydym wastad yn llwyddo i ddod o hyd i gar heb dreth. Trethwch ef neu byddwch yn ei golli.
Go to/Ewch i www.gov.uk/vehicletax

show quoted sections

Francis Jackson

Dear FOI,

I would like to thank the DVLA for it's time in this matter. Although I have not received all of the information I had requested, I'm satisfied with the response and handling of this request at this time.

However if you may just clarify the following item:

1./ In your response you indicate the meaning of the reason codes as follows:
00AC – Off Street Parking
00AD – On Street Parking
00AF – Moving Traffic Offence

However, the data also contains reason codes, that are not referenced in your response. Please can you indicate what the following codes refer to:
00AE
00FB

Yours sincerely,
Francis Jackson

FOI FOI, Driver and Vehicle Licensing Agency

Dear Mr Jackson

Please find below the meanings for the reason codes you have requested.

00AE - bus lane

00FB - breeching a public space protection order (PSPO)

Regards

Ian Davies
Freedom of Information Team, Data Sharing & Protection Group | Strategy, Policy & Communications Directorate| C2 - West | DVLA | Swansea | SA6 7JL
Twitter: @dvlagovuk

We can always spot an untaxed car. Tax it or lose it.
Rydym wastad yn llwyddo i ddod o hyd i gar heb dreth. Trethwch ef neu byddwch yn ei golli.
Go to/Ewch i www.gov.uk/vehicletax

show quoted sections

Francis Jackson

Dear Mr Davies,

Thank you for the clarification.

Yours sincerely,
Francis Jackson