Information wrt DBMSs (Bureau Of Technology Services)

Matt Chapman filed this request with the Bureau of Technology Services of Portland, OR.
Tracking #

C075204-080118

Multi Request Information wrt DBMSs
Est. Completion None
Status
Fix Required

Communications

From: Matt Chapman

To Whom It May Concern:

Pursuant to the Oregon Public 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.

With gratitude,
Matt Chapman,
Free Our Info, NFP

From: Bureau of Technology Services

RE: City Public Records Request of August 01, 2018 Reference # C075201-080118

Dear Matt,

The City received a Public Records Request from you on August 01, 2018 for the following:
"Information regarding DBMSs -- see attached."

You have requested a fee waiver from the City of Portland for the fees associated with your public records request.  Your request is complicated enough to require me to complete a cost estimate according to statute.  I want to give you an opportunity to provide more information related to your waiver request while I prepare my estimate.  Please provide the following information to help me evaluate your fee waiver request:

1) How do you or your organization intend to use the information?  (Please answer regarding the specific information requested as opposed to speaking generally regarding information on the general topic requested);

2) How will the information benefit the wider public?  (Please explain how this specific information assists the public given the information already provided to the public on this topic);

3) How do you or your organization intend to disseminate the information to the wider public?
Without responses to all 3 of these questions it may be difficult, or even impossible, to assess whether the requested disclosure is in the public interest because it will primarily benefit the public.
Please also bear in mind that the Bureau providing the records must weigh the public's interest in disclosure against the cost to the public of fulfilling the request without reimbursement.  As part of that balancing of interests, the City may consider the volume of the records requested.  Please discuss whether a more narrowly tailored, and thus less expensive, request could equally meet the public interest.
Sincerely,

JEN CLODIUS
Senior Management Analyst

From: Bureau of Technology Services

Dear Matt Chapman,

Thank you for registering with the City of Portland Public Records Request Center.  Below is your login information: (https://www.portlandoregon.gov/66961)

Login: requests@muckrock.com Password:  38dfe69c7a

Visit this link to log in and to access and manage your public records requests. (https://www.portlandoregon.gov/66961)

This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

From: Bureau of Technology Services

Dear Matt:

The City of Portland acknowledges receipt of your Public Records Request.  Your request was received in this office on August 01, 2018 and given the reference number C075201-080118 for tracking purposes.

Record Requested:  Information regarding DBMSs -- see attached.

At this time, the City is uncertain whether it is the custodian of the requested record.  The City will review your request to determine if it has responsive records.  The City will then gather an estimate of the costs to provide copies of requested public records for which the City does not claim an exemption from disclosure.  The City is permitted to charge its actual costs to provide records.  Fees include research time to locate and analyze the requested records, even if no records are located or if the requested records are determined to be exempt from disclosure.

You can monitor the progress of your request at the link below.  Thank you for using the Portland Public Records Request Center.
To monitor the progress or update your request click here:
Portland Public Records Request Center (https://PORTLANDOR.mycusthelp.com/WEBAPP/_rs/RequestEdit.aspx?rid=75201&coid=)

From: Bureau of Technology Services

Dear Matt Chapman,

Thank you for registering with the City of Portland Public Records Request Center.  Below is your login information: (https://www.portlandoregon.gov/66961)

Login: requests@muckrock.com Password:  cc860340b8

Visit this link to log in and to access and manage your public records requests. (https://www.portlandoregon.gov/66961)

This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

From: Bureau of Technology Services

Dear Matt:

The City of Portland acknowledges receipt of your Public Records Request.  Your request was received in this office on August 01, 2018 and given the reference number C075204-080118 for tracking purposes.

Record Requested:  DBMS information -- see attached.

At this time, the City is uncertain whether it is the custodian of the requested record.  The City will review your request to determine if it has responsive records.  The City will then gather an estimate of the costs to provide copies of requested public records for which the City does not claim an exemption from disclosure.  The City is permitted to charge its actual costs to provide records.  Fees include research time to locate and analyze the requested records, even if no records are located or if the requested records are determined to be exempt from disclosure.

You can monitor the progress of your request at the link below.  Thank you for using the Portland Public Records Request Center.
To monitor the progress or update your request click here:
Portland Public Records Request Center (https://PORTLANDOR.mycusthelp.com/WEBAPP/_rs/RequestEdit.aspx?rid=75204&coid=)

From: Bureau of Technology Services

RE: City Public Records Request of August 01, 2018 Reference # C075204-080118

Dear Matt,

The City received a Public Records Request from you on August 01, 2018 for the following:
"DBMS information -- see attached."

You have requested a fee waiver from the City of Portland for the fees associated with your public records request.  Your request is complicated enough to require me to complete a cost estimate according to statute.  I want to give you an opportunity to provide more information related to your waiver request while I prepare my estimate.  Please provide the following information to help me evaluate your fee waiver request:

1) How do you or your organization intend to use the information?  (Please answer regarding the specific information requested as opposed to speaking generally regarding information on the general topic requested);

2) How will the information benefit the wider public?  (Please explain how this specific information assists the public given the information already provided to the public on this topic);

3) How do you or your organization intend to disseminate the information to the wider public?
Without responses to all 3 of these questions it may be difficult, or even impossible, to assess whether the requested disclosure is in the public interest because it will primarily benefit the public.
Please also bear in mind that the Bureau providing the records must weigh the public's interest in disclosure against the cost to the public of fulfilling the request without reimbursement.  As part of that balancing of interests, the City may consider the volume of the records requested.  Please discuss whether a more narrowly tailored, and thus less expensive, request could equally meet the public interest.
Sincerely,

JEN CLODIUS
Senior Management Analyst

From: Bureau of Technology Services

--- Please respond above this line ---

RE: City Public Records Request of August 01, 2018 Reference # C075204-080118

Dear Matt,
The City received a Public Records Request from you on August 01, 2018 for the following: "DBMS information -- see attached." The City does not produce reports containing the information you requested. The public records law only provides a process for the public to request existing records of the City. The Oregon Attorney General's Public Records and Meetings Manual explains:  "The Public Records Law does not impose on public bodies the duty to create public records.  Public bodies are not required to create a record to disclose the "reasoning" behind their actions, or other "knowledge" their staff might have.  Nor does the Public Records Law require public bodies to explain or to answer questions or provide legal research or analysis about their public records." The City now considers your request fulfilled and it will be closed.  Please note, messages on closed requests are not monitored.
Sincerely,
JEN CLODIUS
Senior Management Analyst If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov
To monitor the progress or update your request click here:
Portland Public Records Request Center (https://www.portlandoregon.gov/66961?qaframe=CustomerIssues.aspx)

From: Bureau of Technology Services

Attachments:
Application_Inventory.xlsx (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR-2Bn1naaGYgrmVbrDV5q-2BlgbY0v92DAMNqKsgBatci3J8G4-2FinjTFu-2Bw9WBQQKNdu1-2BEigdITH2d7thZt1-2BuWZIMlKrGoYidTYS2aitHgC3VDWmVVrH02E2s3a9nFHma90ghFQ-2BgvzJokNQSLBVdgQpcG2YIopQaiR6KSNar7t3lRg-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfOL649bX-2BQ-2F6Q7N-2BsKMc5ah0vcsFWAsU-2FyF-2BIswQOou-2BAOpSkTrFpuC1PuTL-2FBex-2B4xBdlg-2FMV8jj-2BinzdVJndGBjTrTk2hMKu8APTy-2FuI1-2BuMIby1Jh1AdPB-2BSTNsJlg-2BIbh-2FKnmmPK8zQXvWe3k788n-2FMDZHWr5NR4tHlZLX4pom6XEweAwa1L038u7QUDnIU7nI6encF6WV8FjW-2FMmAUpTNXzoRjbDBp1CVC8ZoBdlTVTAKaMpyv6cziMDt4xbeLv8pF3X-2BX7CDXTElYeCbTjpNipxe8kTzAMy6tc0hXiKMw-2F9h8TIIkprW7dnOephQ-3D-3D)
Database_Standards.pdf (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR-2Bn1naaGYgrmVbrDV5q-2BlgbY0v92DAMNqKsgBatci3J8G4-2FinjTFu-2Bw9WBQQKNdu1-2BEigdITH2d7thZt1-2BuWZIMlKrGoYidTYS2aitHgC3VDTwKmIaziTPBdgFvA3tL-2FywhCwLxWv-2Brt5jONcTtW545osA-2BJ7l8vLTqWI1gZApTAA-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfOL649bX-2BQ-2F6Q7N-2BsKMc5ah0vcsFWAsU-2FyF-2BIswQOou-2BAOpSkTrFpuC1PuTL-2FBex-2B4xBdlg-2FMV8jj-2BinzdVJndGBjTrTk2hMKu8APTy-2FuI1-2BuMIby1Jh1AdPB-2BSTNsJlg-2BIbh-2FKnmmPK8zQXvWe3k788n-2FMDZHWr5NR4tHlZLX4pstIyIVN3CrNrV9eSPBf6AtECzsZjHgUnRF5w0fyNqjgTLYlZSX0a3agGBLk9hDJsrDT3IsplsBy5sNms0StFnUDK8C7bCm96y9y2RC26Wq6lreo2AcJbeJBVSiPBK6Dte6jmnH4-2BE-2Fiq4wBcBgVyKw-3D-3D)

--- Please respond above this line ---

RE: City Public Records Request of August 01, 2018 Reference # C075204-080118

Dear Matt,
The City received a Public Records Request from you on August 01, 2018 for the following: "DBMS information -- see attached." 1. Underlying engine (eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc)
A listing of enterprise database standard products is being provided online at the Portland Public Records Request Center. 2. Names of software that connect to each DBMS 3. Names of departments that use information within the DBMS
For sub-requests 2 and 3, The City does not have a list of just DBMS by Bureau.  Therefore, the City is providing a list of all applications and the Bureaus that use them.  We have excluded version information because showing the version of the software can expose known vulnerabilities which could be used against the City. 4. Schema of database (preferably, with granularity down to column names)
The schema contain proprietary trade secret information.  Additionally, providing the schema poses a security concern by identifying the location of sensitive, secure and proprietary information.  This information is exempt. 5. Contract identifier for each database, if relevant
Not relevant.
The requested records are available online at the Portland Public Records Request Center by going to "My Public Records Center" and viewing this request.  To view this request, choose the "View My Requests" button and select the "Details" button for this request.  Then scroll down past the details of your request to where "Attachments" are located (right before "Message History").  Some of the public records requested are exempt from disclosure and will be redacted or not provided.  The City asserts the following exemptions to disclosure:
ORS 192.345(15) computer programs purchased by public body
ORS 192.345(2) trade secrets
ORS 192.355(9) disclosure prohibited by Oregon law, incorporating ORS 646.461(4) trade secrets.
ORS 192.345(22) interference with property or services
ORS 192.345(23) security measures

The fees for this request were $46 which the City is waiving in this instance.
Please note, if you have been provided with emails or text messages as a part of your request, they may have been converted to Greenwich Mean Time (GMT).
The City now considers your request fulfilled and it will be closed.  Please note, messages on closed requests will not be monitored.
If you have questions or concerns, please call me at the number listed below.
Ability to Appeal:
If you were denied the right to inspect or to receive a copy of any public record of the City of Portland you may seek review of the public body's determination pursuant to ORS 192.411, 192.415, 192.418, 192.422, 192.427 and 192.431.

Sincerely,
Jenifer JohnstonSenior Deputy City Attorney 503-823-4047 If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov

To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfOL649bX-2BQ-2F6Q7N-2BsKMc5ah0vcsFWAsU-2FyF-2BIswQOou-2BAOpSkTrFpuC1PuTL-2FBex-2B4xBdlg-2FMV8jj-2BinzdVJndGBjTrTk2hMKu8APTy-2FuI1-2BuMIby1Jh1AdPB-2BSTNsJlg-2BIbh-2FKnmmPK8zQXvWe3k788n-2FMDZHWr5NR4tHlZLX4pZuZVJwvFtm5Luto1KqtX8HsjGEHt4g7RFSkZe70IGxGQavZdcMzrtsxvWmcwQHEq3KQNT8oTDwayJObN5xTzGSrSdT3fANdAf70rK3CAmF78gTXdBLr8tXiLQLr-2BBSEig-2F2oF9IMjsCkYbZvXigbMQ-3D-3D)

From: Bureau of Technology Services

Attachments:
Application_Inventory.xlsx (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR-2Bn1naaGYgrmVbrDV5q-2BlgbY0v92DAMNqKsgBatci3J8G4-2FinjTFu-2Bw9WBQQKNdu1-2BEigdITH2d7thZt1-2BuWZIMlKrGoYidTYS2aitHgC3VDWmVVrH02E2s3a9nFHma90ghFQ-2BgvzJokNQSLBVdgQpcG2YIopQaiR6KSNar7t3lRg-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfOL649bX-2BQ-2F6Q7N-2BsKMc5ah0vcsFWAsU-2FyF-2BIswQOou-2BAOpSkTrFpuC1PuTL-2FBex-2B4xBdlg-2FMV8jj-2BinzdVJndGBjTrTk2hMKu8APTy-2FuI1-2BuMIby1Jh1AdPB-2BSTNsJlg-2BIbh-2FKnmmPK8zQXvWe3k788n-2FMDZHWr5NR4tHlZLX4pom6XEweAwa1L038u7QUDnIU7nI6encF6WV8FjW-2FMmAUpTNXzoRjbDBp1CVC8ZoBdlTVTAKaMpyv6cziMDt4xbeLv8pF3X-2BX7CDXTElYeCbTjpNipxe8kTzAMy6tc0hXiKMw-2F9h8TIIkprW7dnOephQ-3D-3D)
Database_Standards.pdf (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR-2Bn1naaGYgrmVbrDV5q-2BlgbY0v92DAMNqKsgBatci3J8G4-2FinjTFu-2Bw9WBQQKNdu1-2BEigdITH2d7thZt1-2BuWZIMlKrGoYidTYS2aitHgC3VDTwKmIaziTPBdgFvA3tL-2FywhCwLxWv-2Brt5jONcTtW545osA-2BJ7l8vLTqWI1gZApTAA-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfOL649bX-2BQ-2F6Q7N-2BsKMc5ah0vcsFWAsU-2FyF-2BIswQOou-2BAOpSkTrFpuC1PuTL-2FBex-2B4xBdlg-2FMV8jj-2BinzdVJndGBjTrTk2hMKu8APTy-2FuI1-2BuMIby1Jh1AdPB-2BSTNsJlg-2BIbh-2FKnmmPK8zQXvWe3k788n-2FMDZHWr5NR4tHlZLX4pstIyIVN3CrNrV9eSPBf6AtECzsZjHgUnRF5w0fyNqjgTLYlZSX0a3agGBLk9hDJsrDT3IsplsBy5sNms0StFnUDK8C7bCm96y9y2RC26Wq6lreo2AcJbeJBVSiPBK6Dte6jmnH4-2BE-2Fiq4wBcBgVyKw-3D-3D)

--- Please respond above this line ---

RE: City Public Records Request of August 01, 2018 Reference # C075204-080118

Dear Matt,
The City received a Public Records Request from you on August 01, 2018 for the following: "DBMS information -- see attached." 1. Underlying engine (eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc)
A listing of enterprise database standard products is being provided online at the Portland Public Records Request Center. 2. Names of software that connect to each DBMS 3. Names of departments that use information within the DBMS
For sub-requests 2 and 3, The City does not have a list of just DBMS by Bureau.  Therefore, the City is providing a list of all applications and the Bureaus that use them.  We have excluded version information because showing the version of the software can expose known vulnerabilities which could be used against the City. 4. Schema of database (preferably, with granularity down to column names)
The schema contain proprietary trade secret information.  Additionally, providing the schema poses a security concern by identifying the location of sensitive, secure and proprietary information.  This information is exempt. 5. Contract identifier for each database, if relevant
Not relevant.
The requested records are available online at the Portland Public Records Request Center by going to "My Public Records Center" and viewing this request.  To view this request, choose the "View My Requests" button and select the "Details" button for this request.  Then scroll down past the details of your request to where "Attachments" are located (right before "Message History").  Some of the public records requested are exempt from disclosure and will be redacted or not provided.  The City asserts the following exemptions to disclosure:
ORS 192.345(15) computer programs purchased by public body
ORS 192.345(2) trade secrets
ORS 192.355(9) disclosure prohibited by Oregon law, incorporating ORS 646.461(4) trade secrets.
ORS 192.345(22) interference with property or services
ORS 192.345(23) security measures

The fees for this request were $46 which the City is waiving in this instance.
Please note, if you have been provided with emails or text messages as a part of your request, they may have been converted to Greenwich Mean Time (GMT).
The City now considers your request fulfilled and it will be closed.  Please note, messages on closed requests will not be monitored.
If you have questions or concerns, please call me at the number listed below.
Ability to Appeal:
If you were denied the right to inspect or to receive a copy of any public record of the City of Portland you may seek review of the public body's determination pursuant to ORS 192.411, 192.415, 192.418, 192.422, 192.427 and 192.431.

Sincerely,
Jenifer JohnstonSenior Deputy City Attorney 503-823-4047 If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov

To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfOL649bX-2BQ-2F6Q7N-2BsKMc5ah0vcsFWAsU-2FyF-2BIswQOou-2BAOpSkTrFpuC1PuTL-2FBex-2B4xBdlg-2FMV8jj-2BinzdVJndGBjTrTk2hMKu8APTy-2FuI1-2BuMIby1Jh1AdPB-2BSTNsJlg-2BIbh-2FKnmmPK8zQXvWe3k788n-2FMDZHWr5NR4tHlZLX4pZuZVJwvFtm5Luto1KqtX8HsjGEHt4g7RFSkZe70IGxGQavZdcMzrtsxvWmcwQHEq3KQNT8oTDwayJObN5xTzGSrSdT3fANdAf70rK3CAmF78gTXdBLr8tXiLQLr-2BBSEig-2F2oF9IMjsCkYbZvXigbMQ-3D-3D)

From: Bureau of Technology Services

--- Please respond above this line ---
RE:  City Public Records Request of August 01, 2018 Reference #C075204-080118

Dear Matt,

The City received a Public Records Request from you on August 01, 2018 for the following: "DBMS information -- see attached."
Based on our conversation last Friday, I am providing an estimate to provide public records in response to part 4 of you request, as explained below.  I appreciate the conversation to attempt to clarify and narrow your request. I am providing an estimate to provide a single schema from a data base that you identify. The City will then use that work to further refine the estimate for the remaining schema. The City may be the custodian of at least some of the requested public records and the estimated fees for the specific sub-request is listed below.  Records will not be provided until the final amount is paid.  If the final amount incurred is less than the estimate, you will only be charged actual costs.  If the work significantly exceeds the estimate, the City will contact you with a new estimate. 1. Underlying engine (eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc) Records provided, this portion closed. 2. Names of software that connect to each DBMS Records provided.  You raised additional concerns about not being provided with version information, that issue is discussed further below.  However, this request states a request for names of software, not versions. 3. Names of departments that use information within the DBMS Records provided, this portion closed. 4. Schema of database (preferably, with granularity down to column names) See below for estimate. 5. Contract identifier for each database, if relevant Not relevant. 4. Schema of database (preferably, with granularity down to column names) The City proposes to pull one schema from a database you select.  This would allow the City to refine its estimate before providing and estimate for all it for the different database schema.  It would also allow you to see the records provided before deciding on which databases you would additional information.  You also indicated that you are more interested in some databases.  After we use this single schema as a test case, you could provide the City with a prioritized list so we can do the work in order of importance. The City estimates that it will take 2 hours at a rate of $78.15 per hour to pull schema, evaluate whether information is exempt and redact that information, review the security profile to determine whether major version information can be released. If there is a known vulnerability in the version, then publicly identifying that version is the version the City uses could identify a security gap. Additionally, it is possible requested information related to schema may be exempt from disclosure as noted in our earlier response. The City could gather records and determine that information is exempt. Oregon public records law allows the City to charge for its time to gather and redact records, even if no records or highly redacted records are provided. Finally, not all databases may have existing reports to produce the schema. The City is not required to create records or program new reports, only to use existing ones. If you request schema for databases which do not have existing methods to provide schema the City will have to notify you that for that database, no records exist. The City may be the custodian of at least some of the requested public records and the estimated fees are $ 156.30.  Ten business days after the deposit is paid and you have identified the database from which a schema should be pulled, the records will be ready. However, they will not be provided until the final amount is paid.  If the final amount incurred is less than the estimate, you will only be charged actual costs.  If the work significantly exceeds the estimate, the City will contact you with a new estimate. If you disagree with this approach and would like to pay a deposit for all the applications at once, please let me know and I will create a different payment. By paying the 50% deposit, you are confirming this estimate and agreeing to pay the cost of fulfilling this public records request according to the conditions set forth by the City.  The costs may include the cost of locating records, reviewing records to redact exempt material, supervising the inspection of records, copying records, certifying records and mailing records, including the cost of searching for records.  We will not be working on your request until we receive the 50% deposit. Please reply to this message or log in to the Portland Public Records Request Center and indicate that you agree to pay the estimate.  You may pay by electronic check or credit card by going to "My Public Records Request Center" and select "View My Payments".  Then scroll to find an invoice in the status of "payment pending" and select "Make Payment".  Follow the screen prompts to make a payment.  Alternatively, you may mail a check made payable to "The City of Portland".  Please be sure and provide the Record Request Reference number (C075204-080118) on your check and mail it to:

Jenifer Johnston
1221 SW 4th Ave Suite 430
Portland OR 97204
Please give me a call if you have any questions or need to further clarify the request.
Jenifer Johnston Senior Deputy City Attorney 503-823-4047
If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov

To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfOL649bX-2BQ-2F6Q7N-2BsKMc5ah0vcsFWAsU-2FyF-2BIswQOou-2BN5pmsfuy83Yqzk3R7HnrIKAlGlbKzjy20-2FboE6hFn8jcd5DCCLeKEMhl0NpYm45FXBesDcrjp41kFT39PUROrz2JjUvb5GEQGrVNzqOj5pkRNs-2FAYpTJD97hmr6YsPuyZBR6mv-2F2d-2F1YWuPwneFXQIc1nhOQR-2FAwY-2BrJMUd8fMuqJGC5mD6M-2FAT-2FyGS5pR0HVY6jNsskwEGiUVwv7AWGLcXoH3zewy1E9us16rLkX-2FxG3uOGZfd7hSK-2BadFcTr4YkUGNyZqdPk2oF07ecISEOw-3D-3D)

From: Bureau of Technology Services

--- Please respond above this line ---
RE:  City Public Records Request of August 01, 2018 Reference #C075204-080118

Dear Matt,

The City received a Public Records Request from you on August 01, 2018 for the following: "DBMS information -- see attached."
Based on our conversation last Friday, I am providing an estimate to provide public records in response to part 4 of you request, as explained below.  I appreciate the conversation to attempt to clarify and narrow your request. I am providing an estimate to provide a single schema from a data base that you identify. The City will then use that work to further refine the estimate for the remaining schema. The City may be the custodian of at least some of the requested public records and the estimated fees for the specific sub-request is listed below.  Records will not be provided until the final amount is paid.  If the final amount incurred is less than the estimate, you will only be charged actual costs.  If the work significantly exceeds the estimate, the City will contact you with a new estimate. 1. Underlying engine (eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc) Records provided, this portion closed. 2. Names of software that connect to each DBMS Records provided.  You raised additional concerns about not being provided with version information, that issue is discussed further below.  However, this request states a request for names of software, not versions. 3. Names of departments that use information within the DBMS Records provided, this portion closed. 4. Schema of database (preferably, with granularity down to column names) See below for estimate. 5. Contract identifier for each database, if relevant Not relevant. 4. Schema of database (preferably, with granularity down to column names) The City proposes to pull one schema from a database you select.  This would allow the City to refine its estimate before providing and estimate for all it for the different database schema.  It would also allow you to see the records provided before deciding on which databases you would additional information.  You also indicated that you are more interested in some databases.  After we use this single schema as a test case, you could provide the City with a prioritized list so we can do the work in order of importance. The City estimates that it will take 2 hours at a rate of $78.15 per hour to pull schema, evaluate whether information is exempt and redact that information, review the security profile to determine whether major version information can be released. If there is a known vulnerability in the version, then publicly identifying that version is the version the City uses could identify a security gap. Additionally, it is possible requested information related to schema may be exempt from disclosure as noted in our earlier response. The City could gather records and determine that information is exempt. Oregon public records law allows the City to charge for its time to gather and redact records, even if no records or highly redacted records are provided. Finally, not all databases may have existing reports to produce the schema. The City is not required to create records or program new reports, only to use existing ones. If you request schema for databases which do not have existing methods to provide schema the City will have to notify you that for that database, no records exist. The City may be the custodian of at least some of the requested public records and the estimated fees are $ 156.30.  Ten business days after the deposit is paid and you have identified the database from which a schema should be pulled, the records will be ready. However, they will not be provided until the final amount is paid.  If the final amount incurred is less than the estimate, you will only be charged actual costs.  If the work significantly exceeds the estimate, the City will contact you with a new estimate. If you disagree with this approach and would like to pay a deposit for all the applications at once, please let me know and I will create a different payment. By paying the 50% deposit, you are confirming this estimate and agreeing to pay the cost of fulfilling this public records request according to the conditions set forth by the City.  The costs may include the cost of locating records, reviewing records to redact exempt material, supervising the inspection of records, copying records, certifying records and mailing records, including the cost of searching for records.  We will not be working on your request until we receive the 50% deposit. Please reply to this message or log in to the Portland Public Records Request Center and indicate that you agree to pay the estimate.  You may pay by electronic check or credit card by going to "My Public Records Request Center" and select "View My Payments".  Then scroll to find an invoice in the status of "payment pending" and select "Make Payment".  Follow the screen prompts to make a payment.  Alternatively, you may mail a check made payable to "The City of Portland".  Please be sure and provide the Record Request Reference number (C075204-080118) on your check and mail it to:

Jenifer Johnston
1221 SW 4th Ave Suite 430
Portland OR 97204
Please give me a call if you have any questions or need to further clarify the request.
Jenifer Johnston Senior Deputy City Attorney 503-823-4047
If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov

To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfOL649bX-2BQ-2F6Q7N-2BsKMc5ah0vcsFWAsU-2FyF-2BIswQOou-2BN5pmsfuy83Yqzk3R7HnrIKAlGlbKzjy20-2FboE6hFn8jcd5DCCLeKEMhl0NpYm45FXBesDcrjp41kFT39PUROrz2JjUvb5GEQGrVNzqOj5pkRNs-2FAYpTJD97hmr6YsPuyZBR6mv-2F2d-2F1YWuPwneFXQIc1nhOQR-2FAwY-2BrJMUd8fMuqJGC5mD6M-2FAT-2FyGS5pR0HVY6jNsskwEGiUVwv7AWGLcXoH3zewy1E9us16rLkX-2FxG3uOGZfd7hSK-2BadFcTr4YkUGNyZqdPk2oF07ecISEOw-3D-3D)

From: Matt Chapman

To Whom It May Concern:

Please find enclosed a check for $156.30 to satisfy the fee associated with the attached public records request.

Thank you.

From: Bureau of Technology Services

--- Please respond above this line ---

RE: City Public Records Request of August 01, 2018 Reference # C075204-080118

Dear Matt,
The City received a Public Records Request from you on August 01, 2018 for the following:
"DBMS information -- see attached."
We are in receipt of your payment of the estimated fees associated with fulfilling your public records request. I asked you to identify a database so that we could gather that schema information and use that as a sample to estimate a total cost.  I do not see where you indicated which database you wanted to start with? I need that information so I can begin to fill the request.
Once you have identified an initial schema,  will begin working on gathering documents responsive to your request.  Once we have gathered the documents, a final statement of the remaining balance owed will be sent to you.  This amount may change from the estimate depending on how much time and labor is actually spent on your request.  Full payment is required before we release the records to you.
Sincerely,
Jenifer Johnston
Senior Deputy City Attorney 503-823-4047 If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov
To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfIWDvgK8fM3bEnM-2F7q40CDYZFL9rl8tePXs4JWgK9j7tCchEO8ltgbiqPbF3OErR3W7c4aQIkjmK67CHV1GaooVABCa3ZB6LS0b7YwEykt9lhRdJWpR0JCv6Cj-2FOM-2BwpeMQPfrogrejyeI3d4Wv0W04SDLeeKllIb3ZF9Ib517BpTlOzzfu9-2BrnqM-2FrviAiMjfVKpnZ7RaPcJFR9MvA8ezMr9hvAaDCRX6qd-2FP9rojE7aqaC0A41-2BcgyA-2F-2F9CiMJ0KsiicgSDiFIAAoZHs2cfRcFVtLONU5FYqIc72c1ehuvlXWTQeuhCo9wBaye4hVXig-3D-3D)

From: Matt Chapman

Apologies! I would like to start with the RegJIN's Informix backend.

This query should do trick:

SELECT TRIM(t.tabname) AS table_name, TRIM(c.colname) AS column_name
FROM "informix".systables AS t, "informix".syscolumns AS c
WHERE t.tabid = c.tabid
AND t.tabtype = 'T'
AND t.tabid >= 100
ORDER BY t.tabname, c.colno;

(modified only slightly from: https://stackoverflow.com/questions/1380782/informix-sql-list-all-fields-tables -- it's an old thread, but I compared the query against IBM's current documentation of the two tables, and I don't see any glaring reasons why it wouldn't still work).

From: Bureau of Technology Services

Hello,
Unfortunately your email was not recognized and been routed accordingly.  Please be advised that if you wish to submit a new request or check on the status of an already submitted request, you should visit the has not City of Portland Public Records Requests Center. (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR-2F1TbOpgSBtnm17Qmzcu5tuiNnpYPRjH4812CWBpaEkskahz6PSqTQnNJ2-2FTjd9Q0A-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfB-2Fau6Cd2-2Fjcn30vV2d6whlohvf6JzXq1DjbU1HHx3msAtz2kL0xxkNP2hCvilqVRTJaYiYekuQWf2petRWBJZIBNG6L1hsX69bNyMn-2B1Gn-2BsyzRPcZ-2FHpyJSOhLcAmqn4yx77dMdxanUOfa9UlSzKEUSSbn0lZKY26yrY3GwY2vcbK6eiQxhbMvIpggrOfbmimvbjoyhMA572W6aH4WPqE6pRgFOk272s0rVOCdUooIxBWix3M5VDGTRN6MKXBM5hiXvaGyDg6qdNd1BEYojR7xXOS352F9KECa0ka-2BdK9gRZsVGi1fZP91SdtWou3lkg-3D-3D)
If you need further assistance, you can call the PRR Help Line at (503) 823-6040 or email prrhelp@portlandoregon.gov Email Subject: RE: Oregon Public Records Law Request #C075204-080118 Email Body: TO: "Portland Public Records Request Center"[portlandor@mycusthelp.net]Bureau of Technology ServicesJenifer JohnstonSuite 4301221 SW 4th AvePortland, OR 97204May 29, 2019This is a follow up to request number C075204-080118:Apologies! I would like to start with the RegJIN's Informix backend.This query should do trick:SELECT TRIM(t.tabname) AS table_name, TRIM(c.colname) AS column_name FROM "informix".systables AS t, "informix".syscolumns AS c WHERE t.tabid = c.tabid AND t.tabtype = 'T' AND t.tabid >= 100 ORDER BY t.tabname, c.colno;(modified only slightly from: https://stackoverflow.com/questions/1380782/informix-sql-list-all-fields-tables -- it's an old thread, but I compared the query against IBM's current documentation of the two tables, and I don't see any glaring reasons why it wouldn't still work).Filed via MuckRock.comE-mail (Preferred): 58498-21092443@requests.muckrock.comUpload documents directly: https://accounts.muckrock.com/accounts/login/?url_auth_token=AABCRUtJFmQxHL6SfX-gH7zjMMs%3A1hVptw%3Ag_zeNUrJ1hXsHC9_Ly4vTHRzABY&next=https%3A%2F%2Fwww.muckrock.com%2Faccounts%2Flogin%2F%3Fnext%3D%252Faccounts%252Fagency_login%252Finformation-technology-maine-14829%252Finformation-wrt-dbmss-bureau-of-technology-services-58498%252F%253Femail%253Dportlandor%252540mycusthelp.netIs this email coming to the wrong contact? Something else wrong? Use the above link to let us know.For mailed responses, please address (see note):MuckRock NewsDEPT MR 58498411A Highland AveSomerville, MA 02144-2516PLEASE NOTE: This request is not filed by a MuckRock staff member, but is being sent through MuckRock by the above in order to better track, share, and manage public records requests. Also note that improperly addressed (i.e., with the requester's name rather than "MuckRock News" and the department number) requests might be returned as undeliverable.---On May 21, 2019:
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

From: Bureau of Technology Services

--- Please respond above this line ---
RE:  City Public Records Request of August 01, 2018 Reference #C075204-080118

Dear Matt,

The City received a Public Records Request from you on August 01, 2018 for the following: "DBMS information -- see attached."

We discussed beginning filling this request with a single database as a sample to get an idea of the costs involved.  You told me verbally that you would like to begin with database information related to Portland Police.  I have attached to this matter a letter provided to a previous requester which explains the trade secret protections that are applicable to the software that the Portland Police uses.  I understand you to be requesting the same information so the same exemptions would apply.
I would like to discuss selecting another database from the list provided to use as a sample to continue trying to fill this request.
Please reply to this message or give me a call.
Jenifer Johnston Senior Deputy City Attorney 503-823-3077
If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov

To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfB7IkjkCgnGF-2FkfXzCUOROtDeVwuWaXU0QZMtodukVo1wIbzUApU-2Bti6b-2FTLJyjYhMPjMYxVmy0Ay27D0V-2Fy3g6a2cU2Om7aOD1OptasUoaU6XcfaGVwcoLJOFRF-2FY8iiL5RmravAzpkqY2u-2BxMg60FSdoC3JcQkqcpMRJpoK4iGYNTkNDo5-2BEl3qhLVcv3rE7d0qVN9OjzcD1U7sztBNcIvhScgtXZKlpE-2F-2BVd25HkZNuItCOkhCYlwLWwWbaaqndfXV11EL4kW8zERI6FiFYxzVamZWVkBbteZZ2m7YNSEtii1fHddaBKARLc32w-2BzNQ-3D-3D)

From: Bureau of Technology Services

--- Please respond above this line ---

RE: City Public Records Request of August 01, 2018 Reference # C075204-080118

Dear Matt,
The City received a Public Records Request from you on August 01, 2018 for the following: "DBMS information -- see attached." Please be advised that your public records request is closed, due to lack of communication from you.  The City requested a clarification on this request in order to proceed and has not received communication from you in over 60 days.  This request is now closed.  Please be advised that the City of Portland does not monitor requests that have been closed.  If you are still in need of these records, please log on to the City of Portland Public Records Request Center and re-submit your request.
You did pay a deposit on this request.  Normally that deposit would be refunded to you.  However, you owe an outstanding balance on another request.  Therefore, that money will be credit to that request unless you call me and indicate you wish a refund.
Sincerely,
Jenifer Johnston
Senior Deputy City Attorney 503-823-3077 If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov

To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfM5PnRdtIKNEDBBz5Er5dmiefSuOJervZ1g4liIgKQKC01-2FTiKVsuzS37n7R9QX9ugnwjwO8q9rrCwtYZYWbfG5nLdIWDfC4j7BFhGbzDGPqkCIC-2BvE3zeq92FI-2BHQCBXswqbYzCcU09tdCGoFBbStd8Awlr6ERNNPKSXCLL8RRImfarspARzH1BN1NwKhYlAITXTAkujXVMsUrD4hW95fh-2BzY5VroIWOqlCT9FfSxF9L1bVylu7X9smIIsmKPsfKlviWaCnr7DDdXitk2WEVEl8EH0Qn5VdDCe-2BdrAmyoe3SSQ12nOtXtL9U9ELGecI0Q-3D-3D)

From: Bureau of Technology Services

--- Please respond above this line ---
RE:  City Public Records Request of August 01, 2018 Reference #C075204-080118

Dear Matt,

The City received a Public Records Request from you on August 01, 2018 for the following: "DBMS information -- see attached."

Please ignore my prior note.  I will be asking the City to refund the fees in the request.
Jenifer Johnston Senior Deputy City Attorney 503-823-3077
If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov


To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfO4tmNZbTb3Jlz6SWYz4goLBgo3Ge8M1M0mTNM4QFg1rkvkc5jK0TFwJCTlE1vpvofIyAfpzYD7-2F-2BOrigXkG7TySZwftxSWSOEfyvYQc8vjfhLDOFMXC6Df8suTTmiQW0tDYYQMQ63w5aW-2B7VQmg2XeQUqfk-2BSeXPVFxR2zE1d9HzDpcf-2Fgts3cyw9MafyAaLLzVqxwqS2uJ0ilV12p1wvyq0ytkA1e2CMI-2B6FK7wzSGwkCefwh86NEjPdnd0RzdUexQuAu4gfTP9k5qIsZKa0DgZOTyBgX7BtFJT1-2Fd2OynPA7HUGtaXnGUn93Ta-2FYOmw-3D-3D)

From: Bureau of Technology Services

Hello,
Unfortunately your email was not recognized and been routed accordingly.  Please be advised that if you wish to submit a new request or check on the status of an already submitted request, you should visit the has not City of Portland Public Records Requests Center. (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR-2F1TbOpgSBtnm17Qmzcu5tuiNnpYPRjH4812CWBpaEkskahz6PSqTQnNJ2-2FTjd9Q0A-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfDDRQlWcVQzLgaSc7quTYqvt5fXO3ONSc86kA-2FtFwoD1YqlZBWmhgoqEp38OsQ8GkT0vE4fpXnsdAE7hixpFTdPPfSjg-2F-2B-2FLKlNkzoHtB3j1bjFwYzgNHv2a7UunSYNxqEAH-2Bmdrt1G4mBQyuRlkpGOvHRH2nN8175tqCT7mCijKMicv4mMWRmgUCNvo-2B6cDSM3hT7ZFSb9WcPb59zsn4u-2BtestuCwmmbMwjCs7RX3OsXQs9fA1wJUh9edXpYeg-2BI1Pj63irbgu1V5IVv0zu4mnR3VONTC-2FSs-2FC1MpKYUTixk7asDtsKYrFmTiX2AqYmBw-3D-3D)
If you need further assistance, you can call the PRR Help Line at (503) 823-6040 or email prrhelp@portlandoregon.gov Email Subject: RE: Oregon Public Records Law Request #C075204-080118 Email Body: TO: "Portland Public Records Request Center"[portlandor@mycusthelp.net]

Bureau of Technology Services
Jenifer Johnston
Suite 430
1221 SW 4th Ave
Portland, OR 97204
October 22, 2019
This is a follow up to request number C075204-080118:
To Whom It May Concern:
I wanted to follow up on the following Oregon Public Records Law request, copied below, and originally submitted on July 18, 2018. Please let me know when I can expect to receive a response. You had assigned it reference number #C075204-080118.
Thanks for your help, and let me know if further clarification is needed.
Filed via MuckRock.com
E-mail (Preferred): requests@muckrock.com
Upload documents directly: https://accounts.muckrock.com/accounts/login/?next=https%3A%2F%2Fwww.muckrock.com%2Faccounts%2Flogin%2F%3Fnext%3D%252Faccounts%252Fagency_login%252Finformation-technology-maine-14829%252Finformation-wrt-dbmss-bureau-of-technology-services-58498%252F%253Femail%253Dportlandor%252540mycusthelp.net&url_auth_token=AABCRUtJFmQxHL6SfX-gH7zjMMs%3A1iMq27%3AUY2Tt3bA9Q6-8egN7Glt07mfISw
Is this email coming to the wrong contact? Something else wrong? Use the above link to let us know.
For mailed responses, please address (see note):
MuckRock News
DEPT MR 58498
411A Highland Ave
Somerville, MA 02144-2516
PLEASE NOTE: This request is not filed by a MuckRock staff member, but is being sent through MuckRock by the above in order to better track, share, and manage public records requests. Also note that improperly addressed (i.e., with the requester's name rather than "MuckRock News" and the department number) requests might be returned as undeliverable.
---
On Oct. 7, 2019:
Subject: City Public Records Request :: C075204-080118

This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

From: Bureau of Technology Services

--- Please respond above this line ---

Matt-
The City needs an address for this refund.  Can you please send me an address as to where to send the check?
Jenifer Johnston
503-823-3077

To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfAlXFR6bPdQrDjEvo05o8DMu-2Fy2np2o80WuHXGw38PqJg1JDk06bLOVcUfv-2F5WDZDinftbX-2BDrozvlvrpamXYNlUBvSK8dJq8Iqy-2BWbdmGdY0aNPSrPTDgkHtlnMzPXgq5PrPzJpEkwLa1uV30UddbBLdmmjAqNY9Fsr5GgmM4KhkhvKfaHoGclIWENqd1N-2B8RoPrMKgaBi4VxdPSjYDtQJRmmcDY7Sh79XTnx03KjdJClN5bSizA8YYt35ZxGSyOyU9nyhoUJMjwvhiHGD55WqIrAtb2e6AYV8DVXXT5Euj-2FB0Cng2Lmao2LVtKQnT-2Fsw-3D-3D)

From: Bureau of Technology Services

--- Please respond above this line ---
RE:  City Public Records Request of August 01, 2018 Reference #C075204-080118

Dear Matt,

The City received a Public Records Request from you on August 01, 2018 for the following: "DBMS information -- see attached."

On October 16, 2019 a check was cut for $156.30 made payable to:MuckRock Foundation
411A Highland Ave
Somerville MA  02144-2516
This is a refund for a public records deposit.
Please call me if you need additional details. Jenifer Johnston Senior Deputy City Attorney 503-823-3077
If you are having technical difficulties with the website, please contact the website administrator by phone or email.  (503) 823-6040 or prrhelp@portlandoregon.gov


To monitor the progress or update your request click here: Portland Public Records Request Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuknxe4OeTWYiUjehFS-2F2CR8O9GlTjqgerFqDrB7VqrKSaft6uYxiuPUwcJElriKwLQ-3D-3D_we4hEOpoIo9bUdPMmX5q0-2FkAYYaylA3wZGoV2iYraARvN-2F14yzaeYGi-2F4KRJDvAALj-2FQeOgpzzHmGoPLpK6VfDkTB79kjlG9fifNU4M6pghHvobUsNlLZh4QbxBO3Zzhvxl4h-2BbyIzF9eEY-2FEVS8Q6lFSn632UXfFm2pxOcLByKGtVc4RFmklO6IWzfPTHb7myJ3LOR3imTw0d7958Z3dhF3O5k3buGRhGSB4tefY6OeCKSL9Omx1yuhZ07gu2cLCl9eWbpeSWgA5Z5LBxbPhuHDE7KGCNkggeFMX21Te-2B0kVSN4ZGzZD0SYdvZ2tUwfHz96hO6aBDoyfMY1fKTbhmfz126wIYHyEfRsfmVM-2BHRxxeiKayneDjpVE0LVThVGD88B3ZtxIESj9ryL33-2Bt6g-3D-3D)

Files

pages

Close