Information wrt DBMSs (Information Technology)

Matt Chapman - Free Our Info, NFP filed this request with the Information Technology of Charleston, WV.
Est. Completion Aug. 24, 2018
Status
Fix Required

Communications

From: Matt Chapman - Free Our Info, NFP

To Whom It May Concern:

Pursuant to the West Virginia Freedom of Information Act, I hereby request the following records:

For all DBMSs owned, maintained, operated, contracted with/through, or supported by the Information Technology - or similar - department(s) within your city, please provide me with the following information:

-Underlying engine (eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc)
-Names of software that connect to each DBMS
-Names of departments that use information within the DBMS
-Schema of database (preferably, with granularity down to column names)
-Contract identifier for each database, if relevant

I understand that the information respondent to this request may require the creation of new documents - if that will be the case, then please provide me with documents that may contain the information (eg, documentation, contracts, etc). I am also happy to narrow the scope of my request if necessary.

Please also let me know if any help is needed with discovering any DBMS services. My background is in distributed systems systems administration and I can offer technical tips or advice if it would be helpful in any way.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes. As I believe the information respondent to this request outweighs the costs and burden, I would like to kindly request a fee waiver.

I look forward to receiving your response to this request within 5 business days, as the statute requires.

With gratitude,
Matt Chapman,
Free Our Info, NFP

From:

This email is to confirm that we have received your July 26, 2018, FOIA request for records related to City of Charleston, West Virginia, database management systems. The City does not have a record of having received your July 18, 2018, request. The specifics of your request have been forwarded to the City's IT Department who will compile non-exempt public information responsive to your request. We will provide a response to your request on or before August 24, 2018. If you have any questions in the meantime, please contact me.

Susan Economou
Senior Staff Associate
City Attorney of Charleston
P.O. Box 2749
Charleston WV 25330
304-348-8031

CONFIDENTIALITY NOTICE:
This e-mail and any attachments are confidential and may be protected by legal privilege. If you are not the intended recipient, be aware that any disclosure, copying, distribution, or use of this e-mail or any attachments is prohibited. If you have received this e-mail in error, please notify us immediately by returning it to the sender and delete this copy from your system. Thank you for your cooperation.

CONFIDENTIALITY NOTE:

This e-mail and any attachments are confidential and may be

protected by legal privilege. If you are not the recipient, be aware

that any disclosure, copying, distribution or use of this e-mail or

any attachment is prohibited. If you have received this e-mail in

error, please notify us immediately by returning it to the sender

and delete this copy from your system. Thank you for your

cooperation.

From:

This email is in response to your request under the West Virginia Freedom of Information Act for records related to the City of Charleston, West Virginia's DMBS. In your request, you indicated that the requested documents will be made available to the general public. W. Va. Code § 29B-1-4(a)(1) provides an exemption under FOIA for "trade secrets. . . having commercial value, and which gives its users an opportunity to obtain business advantage over competitors;". Additionally, W. Va. Code § 29B-1-4(a)(13) provides an exemption under FOIA for "Computing, telecommunications, and network security records, passwords, security codes, or programs used to respond to or plan against acts of terrorism which may be the subject of a terrorist act;". The definition of a "terrorist act" provided under West Virginia law includes acts that are likely to result in damage to property intended to affect the conduct of a branch or level of government by intimidation or coercion.

The information you have requested includes information that private companies providing services/software to the City consider proprietary. Additionally, it is the opinion of the Director of the City's IT Department that providing the information you have requested may expose the City's IT systems to a security breach. In consideration of proprietary content and due to the reasonable concerns for the security of the City's IT systems, the City is denying your request under the W. Va. Code exemptions cited above. If you are seeking specific, public, nonexempt information that will not compromise the security of the City's IT systems, please resubmit a more detailed request.

With the submission of this email, we consider the response of the City of Charleston, West Virginia, to your request complete. If we have misunderstood your request or you would like to discuss your request in greater detail, please call City Attorney, Paul Ellis, at 304-348-8031. Thank you.

Susan Economou
Senior Staff Associate
City Attorney of Charleston
P.O. Box 2749
Charleston WV 25330
304-348-8031

CONFIDENTIALITY NOTICE:
This e-mail and any attachments are confidential and may be protected by legal privilege. If you are not the intended recipient, be aware that any disclosure, copying, distribution, or use of this e-mail or any attachments is prohibited. If you have received this e-mail in error, please notify us immediately by returning it to the sender and delete this copy from your system. Thank you for your cooperation.

CONFIDENTIALITY NOTE:

This e-mail and any attachments are confidential and may be

protected by legal privilege. If you are not the recipient, be aware

that any disclosure, copying, distribution or use of this e-mail or

any attachment is prohibited. If you have received this e-mail in

error, please notify us immediately by returning it to the sender

and delete this copy from your system. Thank you for your

cooperation.

From: Information Technology

________________________________
Please see the attached which was sent in response to your FOIA request on August 16, 2018.

Files

There are no files associated with this request.