Structure of database / letter storage on HS2

Humphrey Systems Ltd made this Freedom of Information request to High Speed Two (HS2) Limited

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

Roedd y cais yn llwyddiannus.

Humphrey Systems Ltd

Dear High Speed Two (HS2) Limited,

Background
==========

In FOI12-487, HS2 give "database search" for a single postcode (up to 16 houses) as likely to cost more than £450.

I can see such an argument could apply to manual storage, or redacting review (depending on what was in a letter, given data-protection), but the question was how many letters, not what is in them.

Since inception, decades ago, Unix and Microsoft have provided text search facility. eg. "UB5 6YW".

Although given 2 streets, and SQL works on databases, I would imagine criteria like POSTCODE="UB5 6*" AND (ROADNAME="Rabournmead Drive" OR ROADNAME="Wheatsheaf Close" etc.

As an IT consultant, I find your FOI response indicative of either a) poorly constructed databases or b) excuse.

For example, POSTCODE, HOUSE_NUMBER and NAME are required fields for any such "public facing" database.

For example given these, Heathrow Airport could track where your suitcase went; even though this requires interfacing several databases, eg. booking, flight, luggage routing through conveyors, etc.

There is probably already a tool that already exists for normal administration. Just ask you IT Geeks, this really is easy. (Even if you had scanned letters, I could do this as an overnight batch using Text Recognition Reader software, piped into Grep etc. Heck, even Bookies used to do this with Scanned Receipts, for customer disputes, See Alphameric in Andover).

FOI Request (1)
===============

List of IT service providers for HS2, if suppliers have a "SERVICE_TYPE" property (field). Otherwise, simply a list of all suppliers, and I can do the work, working out what they do. In any competent company, there will be such a list.

The present government's manifesto included opening up government contracts to small and medium businesses.

FOI Request (2)
===============

The operating system, application name, and purpose of major databases involved in dealing with public house-holders.
eg. Redhat, Oracle, Public-Contacts.
eg. Windows, SQL Server 2010, EHS-Compensation.

This information is probably already contained in your IT Emergency or Backup Plan. Just photocopy the relevant pages.

FOI Request (3)
===============

List of database fields. eg. SELECT * FROM SYSTABLE etc.

The £25 per hour "FOI government level" can probably be met by whatever IT staff you employ. This equates to £48750 pa.

Alternatively, given FOI 1 and 2, I could probably work out suitable queries for free. Which you IT can check and use.

Alternatively, I am available for contract at £35ph (given I am not local and need a hotel etc). Past projects include CocaCola, Quaker Oats, Highland Spring, RollsRoyce, Thames Water etc. (These have very large databases).

Regards,

HUMPHREY SYSTEMS LTD
COMMONWEALTH OF ENGLAND 16 CARNFORTH CLOSE
STAPLEFORD
NOTTINGHAM
NOTTS
ENGLAND
NG9 7EZ
Company No. 08106660

HS2Enquiries, High Speed Two (HS2) Limited

Thank you for your email to High Speed Two Ltd.

 

Your email has been forwarded to the Public Enquiries team and will be
dealt with within 20 working days.

 

If you haven't already done so, you may wish to view information regarding
HS2 Ltd on our website at [1]www.hs2.org.uk

 

Documents underlining the HS2 proposals can be found on the Department for
Transport's website at

[2]www.dft.gov.uk/topics/high-speed-rail

HS2

This email is scanned and cleared by Websense. HS2 Ltd is registered in
England and Wales. Registration Number 06791686, Registered office High
Speed Two (HS2) Ltd, 2nd Floor, Eland House, Bressenden Place, London SW1E
5DU England.
This email is sent subject to our disclaimer which can be accessed via our
website at [3]http://www.hs2.org.uk/policies

References

Visible links
1. http://www.hs2.org.uk/
2. http://www.dft.gov.uk/topics/high-speed-...
3. http://www.hs2.org.uk/policies

Humphrey Systems Ltd

Dear High Speed Two (HS2) Limited,

Dear HS2, I have had no reply, so I am referring for internal review.

It is clear HS2 are avoiding FOI when they have the information, so I have selected a task which is easy to achieve. A dump of directories, and database table structure, so other FOI can be evaluated for truthfulness.

eg. We can't see what the average compensation is in XYZ Area.

Yours faithfully,

Humphrey Systems Ltd

Humphrey Systems Ltd

Dear High Speed Two (HS2) Limited,

Please pass this on to the person who conducts Freedom of Information reviews.

I am writing to request an internal review of High Speed Two (HS2) Limited's handling of my FOI request 'Structure of database / letter storage on HS2'.

Still no internal review.

A full history of my FOI request and all correspondence is available on the Internet at this address: https://www.whatdotheyknow.com/request/s...

Yours faithfully,

Humphrey Systems Ltd

HS2Enquiries, High Speed Two (HS2) Limited

Thank you for your email to HS2 Ltd.

 

Your email has been forwarded to the Public Enquiries team. We aim to
respond to all enquiries within 20 working days.

 

The Government is currently seeking the public's views on the proposed
rail route from the West Midlands to Manchester and Leeds. This
consultation is your chance to have your say on the route, stations and
depots being proposed.

 

You can respond to the consultation in one of the following ways, giving
as much evidence and reasoning as possible to support your comments.

 

·         By completing the online response form at [1]www.hs2.org.uk

 

·         Sending your response by email to [2][email address]

 

·         By freepost to the following address: You do not need a stamp

FREEPOST RTEL-YAZX-HAZT

Phase Two Route Consultation

PO Box 1152

Harrow

HA1 9LH

 

The deadline for responses to this consultation is 5pm on 31^st January
2014.

 

For more information on HS2 please visit our website [3]www.hs2.org.uk.

 

HS2 Ltd.

 

This email is scanned and cleared by Websense. HS2 Ltd is registered in
England and Wales. Registration Number 06791686, Registered office High
Speed Two (HS2) Ltd, 2nd Floor, Eland House, Bressenden Place, London SW1E
5DU England.
This email is sent subject to our disclaimer which can be accessed via our
website at [4]http://www.hs2.org.uk/policies

References

Visible links
1. http://www.hs2.org.uk/
2. mailto:[email address]
3. file:///tmp/www.hs2.org.uk
4. http://www.hs2.org.uk/policies

Humphrey Systems Ltd

Dear High Speed Two (HS2) Limited,

Where is my Internal review or information?

Yours faithfully,

Humphrey Systems Ltd

HS2Enquiries, High Speed Two (HS2) Limited

Dear Sir/Madam,

Thank you for your email. Unfortunately we are unable to find a record of an information request or internal review for 'Humphrey Systems Ltd'. Please could you provide us with either the FOI reference number or a copy of the original request so that we can help you further.

Kind regards,

Karen MacKnight
Freedom of Information Manager | HS2 Ltd

dangos adrannau a ddyfynnir

Humphrey Systems Ltd

Dear HS2Enquiries,

Please find below the original FOI which was never responded to.

Yours sincerely,

Humphrey Systems Ltd

Dear High Speed Two (HS2) Limited,

Background
==========

In FOI12-487, HS2 give "database search" for a single postcode (up
to 16 houses) as likely to cost more than £450.

I can see such an argument could apply to manual storage, or
redacting review (depending on what was in a letter, given
data-protection), but the question was how many letters, not what
is in them.

Since inception, decades ago, Unix and Microsoft have provided text
search facility. eg. "UB5 6YW".

Although given 2 streets, and SQL works on databases, I would
imagine criteria like POSTCODE="UB5 6*" AND (ROADNAME="Rabournmead
Drive" OR ROADNAME="Wheatsheaf Close" etc.

As an IT consultant, I find your FOI response indicative of either
a) poorly constructed databases or b) excuse.

For example, POSTCODE, HOUSE_NUMBER and NAME are required fields
for any such "public facing" database.

For example given these, Heathrow Airport could track where your
suitcase went; even though this requires interfacing several
databases, eg. booking, flight, luggage routing through conveyors,
etc.

There is probably already a tool that already exists for normal
administration. Just ask you IT Geeks, this really is easy. (Even
if you had scanned letters, I could do this as an overnight batch
using Text Recognition Reader software, piped into Grep etc. Heck,
even Bookies used to do this with Scanned Receipts, for customer
disputes, See Alphameric in Andover).

FOI Request (1)
===============

List of IT service providers for HS2, if suppliers have a
"SERVICE_TYPE" property (field). Otherwise, simply a list of all
suppliers, and I can do the work, working out what they do. In any
competent company, there will be such a list.

The present government's manifesto included opening up government
contracts to small and medium businesses.

FOI Request (2)
===============

The operating system, application name, and purpose of major
databases involved in dealing with public house-holders.
eg. Redhat, Oracle, Public-Contacts.
eg. Windows, SQL Server 2010, EHS-Compensation.

This information is probably already contained in your IT Emergency
or Backup Plan. Just photocopy the relevant pages.

FOI Request (3)
===============

List of database fields. eg. SELECT * FROM SYSTABLE etc.

The £25 per hour "FOI government level" can probably be met by
whatever IT staff you employ. This equates to £48750 pa.

Alternatively, given FOI 1 and 2, I could probably work out
suitable queries for free. Which you IT can check and use.

Alternatively, I am available for contract at £35ph (given I am not
local and need a hotel etc). Past projects include CocaCola, Quaker
Oats, Highland Spring, RollsRoyce, Thames Water etc. (These have
very large databases).

Regards,

HUMPHREY SYSTEMS LTD
COMMONWEALTH OF ENGLAND 16 CARNFORTH CLOSE
STAPLEFORD
NOTTINGHAM
NOTTS
ENGLAND
NG9 7EZ
Company No. 08106660

Link to this

HS2Enquiries, High Speed Two (HS2) Limited

Dear Sir/Madam,

Thank you for your reply. I apologise that you did not receive a response to this request. I have now logged this as a request to be considered under the Freedom of Information Act 2000 and will attempt to gather this information for you. Your reference number for this request is FOI14-1161.

We will attempt to provide an answer as soon as possible, however the latest we will respond is 13 October 2014.

To ensure that your request complies with the Freedom of Information Act please could you provide a proper-name to which we can respond.

Kind regards,

Karen MacKnight | Freedom of Information Manager | HS2 Ltd
[email address] | Facebook | Twitter | LinkedIn

High Speed Two (HS2) Limited, 19th Floor, One Canada Square, Canary Wharf, London E14 5AB | www.hs2.org.uk

dangos adrannau a ddyfynnir

HS2Enquiries, High Speed Two (HS2) Limited

2 Atodiad

Dear Sir,

Please find our response to your enquiry attached.

Kind regards,

Karen MacKnight | Freedom of Information Team | HS2 Ltd
[email address] | Facebook | Twitter | LinkedIn

High Speed Two (HS2) Limited, 19th Floor, One Canada Square, Canary Wharf, London E14 5AB | www.hs2.org.uk

dangos adrannau a ddyfynnir