Information wrt DBMSs (Information Technology, New Mexico)

Matt Chapman - Free Our Info, NFP filed this request with the Information Technology, New Mexico of Albuquerque, NM.
Tracking #

18-5418

Multi Request Information wrt DBMSs
Est. Completion Oct. 5, 2018
Status
Fix Required

Communications

From: Matt Chapman - Free Our Info, NFP

To Whom It May Concern:

Pursuant to the New Mexico Inspection of 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 15 business days, as the statute requires.

With gratitude,
Matt Chapman,
Free Our Info, NFP

From: Information Technology, New Mexico

City of Albuquerque

************************************************************************

Hi there

Your first City of Albuquerque record request (request number #18-5418) has been submitted.
It is currently unpublished and is not available for the general public to view.

As the requester, you can always see the status of your
request by signing into the City of Albuquerque Public Records
portal here.

If you haven't already activated your account,
click here to get started.
Once your account is activated, your request will be visible at the following link:
Request #18-5418.

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of Albuquerque.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: Information Technology, New Mexico

Hello,
I have put your request into NextRequest.
I do have a few questions can you contact me at 505768-2344.
Than you.

[dti-logo]

SYLVIA MARTINEZ
support staff coordinator
O 505.768.2344
E smartinez@cabq.gov
cabq.gov<https://www.cabq.gov/>

From: Information Technology, New Mexico

City of Albuquerque

************************************************************************

Hi there

Record request #18-5418 has been published and is now available for public view.

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of Albuquerque.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: Information Technology, New Mexico

City of Albuquerque

************************************************************************

Hi there

A message was sent to you regarding record request #18-5418:

Good Morning Mr. Chapman.

Your request has been submitted via NextRequest. 

Sylvia Martinez

Records Custodian.

 

 

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of Albuquerque.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: Information Technology, New Mexico

City of Albuquerque

************************************************************************

Hi there

A document has been released to you for record request #18-5418:

* Information Technology Commodities.pdf

Document links are valid for one month.
After October 21, you will need to sign in to view the document(s).

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of Albuquerque.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: Information Technology, New Mexico

City of Albuquerque

************************************************************************

Hi there

A message was sent to you regarding record request #18-5418:

Hello Matt Chapman, 

On September 20, 2018, we received your request to inspect the following:  

 To Whom It May Concern:

Pursuant to the New Mexico Inspection of 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 15 business days, as the statute requires.

With gratitude,

Matt Chapman,

Although it may be sooner, it will take up to 15 calendar days to respond your request, which will be on October 5, 2018.

 

Sylvia Martinez

DTI Records Custodian

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of Albuquerque.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

From: Matt Chapman - Free Our Info, NFP

Hi - I do not see any records attached to the request. Could you kindly tell me the current status of this request?

From: Information Technology, New Mexico

City of Albuquerque

************************************************************************

Hi there

Record request #18-5418 has been closed. The closure reason supplied was:

Hello Matt Chapman, 

This correspondence regards your Inspection of Public Records Act (“IPRA”) request which was added to the nextrequest.cabq.gov system on or about September 20, 2018 (identified as #18-5418). The request sought the following records:

Pursuant to the New Mexico Inspection of 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.

First off, we appreciate your patience during this process and I apologize for the delays in communicating with you on your original emailed request. Unfortunately, we thought that you would submit your emailed request directly into the nextrequest system, however, since that did not occur we decided to add it to that system for processing and to ensure there are no additional delays. My office has completed our review for any responsive records that existed at the time your request was submitted, and we have only identified one (1) non-exempt responsive record. That record was uploaded into #18-5418 and made available to you in that system. The non-exempt responsive record is called “Information Technology Commodities.pdf”. Please let my office know if you are unable to open that pdf., if you do experience any issues in opening or viewing it then we can try and send it through another method of delivery or you are also welcome to inspect that record at the Office of the City Clerk, located at 600 2nd Street NW, Albuquerque, NM 87102. That office is located on the 7th floor of that building. 

 

Next, there are aspects of your request that we were unable to locate any responsive records for or we are unwilling to create responsive records that did not otherwise exist at the time of your request. As you may be aware the City is not required to create any public records in order to respond to an IPRA request, and we are also not required to provide you “information” if that information was not otherwise located on a public record. See NMSA 1978, § 14-2-8(B). 

 

Lastly, we have determined that certain “information” that you sought is exempt from disclosure, assuming there are records that are responsive and provide the requested information, the City is denying the inspection of those records, because they are exempt from disclosure under IPRA, NMSA 1978, § 14-2-1(A)(7); and NMSA 1978, § 14-2-1(A)(8) (otherwise provided by law), including but not limited to, NMSA 1978, § 53-3-1 et. seq., and Rule 11-508 NMRA, and NMSA 1978, § 14-2-9(A).

 

 

Thank you again for your continued patience regarding this request. My office will now close out this request.

 

Please let me know if you have any questions. 

 

Sincerely,

 

Sylvia Martinez

DTI Records Custodian

 

 

 

************************************************************************
<em>Questions about your request?</em> Reply to this email or sign in to contact staff at City of Albuquerque.<br></br><em>Technical support:</em> See our <a href='https://www.nextrequest.com/support'>help page</a>

Files