Information wrt DBMSs (Information Technology, Iowa)

Matt Chapman - Free Our Info, NFP filed this request with the Information Technology of Des Moines, IA.
Status
Completed

Communications

From: Matt Chapman - Free Our Info, NFP

To Whom It May Concern:

Pursuant to the Iowa Open Records Law, 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 10 business days, as the statute requires.

With gratitude,
Matt Chapman,
Free Our Info, NFP

From: Des Moines City Clerk

Dear Mr. Chapman,

This will confirm receipt of your most recent open records request to the City of Des Moines, Iowa on behalf of MuckRock News, dated July 20, 2018. Your request has been forwarded to me for response. I will begin working with our Information Technology Department to prepare a response to your request.

In the meantime, if you have any questions, please feel free to contact me.

Sincerely,

Lisa Mickey
Open Records Coordinator
Phone: 515-283-4566
Email: lmmickey@dmgov.org<mailto:lmmickey@dmgov.org>

[LEGLogo]

From: Information Technology

To Whom it May Concern,

This email will provide the responses to MuckRock's Open Records Request to the City of Des Moines dated July 20, 2018, wherein MuckRock requested the following:

"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"

Attached to this email, please see a list of software names the City uses which would connect to the DBMS. The names of departments that use information within the DBMS can be found by going to the City's website at www.dmgov.org<http://www.dmgov.org>.

The City of Des Moines considers all other information requested in your Open Records Request of July 20, 2018 to be confidential pursuant to Iowa Code Chapter 22.7(50) (please see a copy of this code section attached), and therefore, this information will not be provided in response to your request.

Please let me know if you have any questions.

Sincerely,

Lisa Mickey
Open Records Coordinator
Phone: 515-283-4566
Email: lmmickey@dmgov.org<mailto:lmmickey@dmgov.org>

[LEGLogo]

Files

pages

Close