Information wrt DBMSs (Los Angeles Information Technology Agency)

Matt Chapman filed this request with the Los Angeles Information Technology Agency of Los Angeles, CA.
Multi Request Information wrt DBMSs
Submitted July 18, 2018
Status
Completed

Communications

From: Matt Chapman

Subject: California Public Records Act Request: Information wrt DBMSs (Los Angeles Information Technology Agency)

Email

To Whom It May Concern:

Pursuant to the California Public Records 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 10 calendar days, as the statute requires.

With gratitude,
Matt Chapman,
Free Our Info, NFP

From:

Subject: Automatic E-Mail Reply RE: California Public Records Act Request: Information wrt DBMSs (Los Angeles Information Technology Agency)

Email

I am out of the office (RDO) on Monday 8/6/18 returning on Tuesday, August 7th, 2018.

For CPRA requests, please contact Solie Nosrat at 213-978-2874 or email at Solie.Nosrat@lacity.org. (mailto:Solie.Nosrat@lacity.org)
For IT Professional Contract or any other inquiries, please contact Maryam Abbassi at 213-473-9797 or email at Maryam.Abbassi@lacity.org. (mailto:Maryam.Abbassi@lacity.org)

Otherwise, please leave me a message, and I will return your call upon my return,

Please note that every other Monday is my Regular Day Off (RDO).

Thank you.
--

Kuljeet Arora
Sr. Systems Analyst II
Information Technology Agency* 200 N. Main St, CHE, 14th floor (14-171)
Los Angeles, CA 90012
213.922-8307 (tel:213.808-8403) | Kuljeet.Arora@ lacity.org (mailto:greg.kung@lacity.org) * a department of 'City of Los Angeles'
'Please note that every other Monday is my Regular Day Off'
"Great minds discuss ideas; Average minds discuss events; Small minds discuss people." ~ Author Unknown Please consider the environment before printing this email

From: Los Angeles Information Technology Agency

Subject: Re: California Public Records Act Request: Information wrt DBMSs (Los Angeles Information Technology Agency)

Email

Hello Mr. Chapman,
Thank you for following up with your CPRA request related to the
information wrt DBMSs (Los Angeles Information Technology Agency).

Please be advised that the Information Technology Agency (ITA) is still
reviewing your request and will get back to you soon.

Thank you for your patience.

Regards

--
Kuljeet Arora
Sr. Systems Analyst II
*Information Technology Agency**
200 N. Main St, CHE, 14th floor (14-171)
Los Angeles, CA 90012

*(:213.922-8307 <javascript:void(0);> | *: Kuljeet.Arora@lacity.org
<greg.kung@lacity.org>*
** a department of 'City of Los Angeles'*

*'Please note that every other Monday is my Regular Day Off'*

"Great minds discuss ideas; Average minds discuss events; Small minds
discuss people."
~ Author Unknown

-

* P Please consider the environment before printing this email *

From: Los Angeles Information Technology Agency

Subject: Re: California Public Records Act Request: Information wrt DBMSs (Los Angeles Information Technology Agency)

Email

Hello Mr. Chapman,
As per your CPRA request about all DBMSs owned, maintained operated,
contracted with/through, or supported or by the Information Technology - or
similar - department (s) within the City, *please see the City's Open Data
Portal, and Application Portfolio dataset *-
https://data.lacity.org/A-Well-Run-City/Application-Portfolio/qzxk-wqtd

This dataset has the info that you are requesting that has been approved
for release, without compromising the cybersecurity of the City systems
involved.

ITA has no other responsive records.

Thank you

Regards

--
Kuljeet Arora
Sr. Systems Analyst II
*Information Technology Agency**
200 N. Main St, CHE, 14th floor (14-171)
Los Angeles, CA 90012

*(:213.922-8307 <javascript:void(0);> | *: Kuljeet.Arora@lacity.org
<greg.kung@lacity.org>*
** a department of 'City of Los Angeles'*

*'Please note that every other Monday is my Regular Day Off'*

"Great minds discuss ideas; Average minds discuss events; Small minds
discuss people."
~ Author Unknown

-

* P Please consider the environment before printing this email *

Files

There are no files associated with this request.