Information wrt DBMSs (Department of Information Technology)
| Tracking # |
C030407-072218 |
| Multi Request | Information wrt DBMSs |
| Submitted | July 18, 2018 |
| Due | Sept. 4, 2018 |
| Est. Completion | May 20, 2019 |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
Communications
From: Matt Chapman
To Whom It May Concern:
Pursuant to the Washington 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 5 business days, as the statute requires.
With gratitude,
Matt Chapman,
Free Our Info, NFP
From: Department of Information Technology
--- Please respond above this line ---
07/27/2018
Dear Matt Chapman, This acknowledges receipt of your public disclosure request C030407-072218 received on July 22, 2018 regarding:
Sincerely, *ITD *PDR
To monitor the progress, update this request, make payments and download your responsive records please log into the
Public Records Request Center. (http://www.seattle.gov/public-records/public-records-request-center)
From: Department of Information Technology
--- Please respond above this line ---
07/27/2018
Dear Matt Chapman, This acknowledges receipt of your public disclosure request C030407-072218 received on July 22, 2018 regarding: Sincerely, *ITD *PDR
To monitor the progress, update this request, make payments and download your responsive records please log into the
Public Records Request Center. (http://www.seattle.gov/public-records/public-records-request-center)
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman: Regarding your July 22, 2018request: Forall DBMSs owned, maintained, operated, contracted with/through, or supported bythe Information Technology - or similar - department(s) within your city, pleaseprovide me with the following information: -Underlying engine (eg, postgres,mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQLServer, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc) -Namesof software that connect to each DBMS -Names of departments that useinformation within the DBMS -Schema of database (preferably, with granularitydown to column names) -Contract identifier for each database, if relevant Iunderstand that the information respondent to this request may require thecreation of new documents - if that will be the case, then please provide mewith documents that may contain the information (eg, documentation, contracts,etc). I am also happy to narrow the scope of my request if necessary. As you may have guessed, this is a very large and complexrequest, and will take some time to produce. I met with some departmentmembers, responsible for helping to pull this information together and severalquestions came up. It would be helpful to get further clarificationbefore we proceed. Here are some questions the group had: Are you requestingproduction vs. non-production databases? On premise only? No imbeddedsystems? What do you mean by contract identifier? Once we get yourclarification, we will be better able to give you a time estimate. If we do not hear from you within 30 days, the City will consider your request closed. Thankyou. Sincerely, Kristen Glundberg-Prossor Seattle Information Technology Public Disclosure
To monitor the progress, update this request, make payments and download your responsive records please log into the
Public Records Request Center. (http://www.seattle.gov/public-records/public-records-request-center)
From: Department of Information Technology
--- Please respond above this line ---
10/10/2018
Dear Mr. Chapman,
This email is in response to your public disclosure request C030407-072218 received on July 22, 2018 regarding the following:
It's come to my attention that it's been over 30 days and I hadn't heard back from you. Can you answer any of the clarifying questions in my last message? It would be super helpful so that we can move forward. Conversely is there any way that you could possibly narrow your request? Or, are you even still interested in this request? Let me know and many thanks.
Sincerely,
Kristen Glundberg-Prossor
PDO/Seattle IT
From: Matt Chapman
Thank you for the followup and sorry it took so long to get back! Yes, I'm still interested in the records for this request.
Are you requesting production vs. non-production databases? Production only.
On premise only?
No imbedded systems? No need for imbedded systems.
What do you mean by contract identifier? This info can be dropped from the request.
Please let me know if there are any other questions. I realize that the information from this request might be a bit difficult to compile, but the information is incredibly valuable for understanding what sort of records exist for the use with future requests. For example, by knowing the names of columns exist in a table/database, that allows a requester to request only the information from those columns, where it would likely be a guessing game otherwise.
Thanks -
Matt Chapman
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman:
This is in response to your public records request C030407. Factors influencing the volume and timing of our response include time needed to find, gather, and review the information, and office workload and staffing, among others. While the timing and volume of a production may cause you some displeasure, the PRA does give agencies such as ours latitude to estimate how long it will take to provide the records based on these factors. We make this determination on a case-by-case basis. We anticipate having an installment to you on or around January 20, 2019. Thank you. Sincerely, Seattle IT PDO
To monitor the progress, update this request, make payments and download your responsive records please log into the
Public Records Request Center. (http://www.seattle.gov/public-records/public-records-request-center)
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman: The purpose of this email is to provide an update on your public records request C030407. Factors influencing the volume and timing of our response include time needed to find, gather, and review the information, and office workload and staffing, among others. While the timing and volume of a production may cause you some displeasure, the PRA does give agencies such as ours latitude to estimate how long it will take to provide the records based on these factors. We make this determination on a case-by-case basis. We expect to have more information or an installment to you on or about January 31, 2019. Sincerely, ITD/PDO
To monitor the progress, update this request, make payments and download your responsive records please log into the
Public Records Request Center. (https://u8387795.ct.sendgrid.net/wf/click?upn=S-2BehCBSDSzwVGewhY9FtkXJ91fxIoY-2BgXaEKqJaICVpOYbbwwc9jnXiobb65RLkU0f5Ep56eIF1uwa6shpgedaGKAQaiEf2LeCUyUXHd9fc-3D_vWLpM80-2BdtbVEGePF4yfAO5fIFp0gvV-2FTwhXx3wK9dSjFowFIobXJb7Ujt9Q-2BJabMA8cD2p8MnLRe4Kmo-2BfcGs8ZjIq9ECYDiRLkrEX9iWvQVk5WLWUTYkV7vzgykF-2FkISGeYAge5qdJVuN9TJuwv1-2BWb4sk61KPesPjpaeNtfkr8FKcSr997cs-2BQU7aZ6Yy16R-2Bt7P8RzNK4lJIO5EVrgu8C-2FdDPBZhrWccUf5PD0P7giDm18EAMQtm1KdbnJ7ukcK4c5361y-2F3n-2BR2Mu68ru0u1JEySPBpoMJMlKco-2FnFY6iSPw3eMfWkQAR-2BrYg7Fbjo8EUA-2FijXgv1zwJtYZJnndc-2B0qjiqlI8JAzWSNI5c6e-2FaIWVQZgIoMntASuCTvhcoT9acWZBHGBCM5RL33bg-3D-3D)
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman: The purpose of this email is to provide an update on your public records request C030407. Factors influencing the volume and timing of our response include time needed to find, gather, and review the information, and office workload and staffing, among others. While the timing and volume of a production may cause you some displeasure, the PRA does give agencies such as ours latitude to estimate how long it will take to provide the records based on these factors. We make this determination on a case-by-case basis. We expect to have more information or an installment to you on or about January 31, 2019. Sincerely, ITD/PDO
To monitor the progress, update this request, make payments and download your responsive records please log into the
Public Records Request Center. (https://u8387795.ct.sendgrid.net/wf/click?upn=S-2BehCBSDSzwVGewhY9FtkXJ91fxIoY-2BgXaEKqJaICVpOYbbwwc9jnXiobb65RLkU0f5Ep56eIF1uwa6shpgedaGKAQaiEf2LeCUyUXHd9fc-3D_vWLpM80-2BdtbVEGePF4yfAO5fIFp0gvV-2FTwhXx3wK9dSjFowFIobXJb7Ujt9Q-2BJabMA8cD2p8MnLRe4Kmo-2BfcGs8ZjIq9ECYDiRLkrEX9iWvQVk5WLWUTYkV7vzgykF-2FkISGeYAge5qdJVuN9TJuwv1-2BWb4sk61KPesPjpaeNtfkr8FKcSr997cs-2BQU7aZ6Yy16R-2Bt7P8RzNK4lJIO5EVrgu8C-2FdDPBZhrWccUf5PD0P7giDm18EAMQtm1KdbnJ7ukcK4c5361y-2F3n-2BR2Mu68ru0u1JEySPBpoMJMlKco-2FnFY6iSPw3eMfWkQAR-2BrYg7Fbjo8EUA-2FijXgv1zwJtYZJnndc-2B0qjiqlI8JAzWSNI5c6e-2FaIWVQZgIoMntASuCTvhcoT9acWZBHGBCM5RL33bg-3D-3D)
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Washington Public Records Act 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 #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman: The purpose of this email is to provide a status update regarding your request C030407. The City needs additional time to respond to your request in order to analyze the costs of programming that needs to be done to produce the information you are requesting. At this time, the Department anticipates having a response to you about those costs on or about February 22, 2019. Thank you for your patience. Sincerely, ITD PDO
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman, The purpose of this email is to provide a status update regarding your request C030407. The City needs additional time to respond to your request in order to further analyze security concerns regarding your request. At this time, the Department anticipates having a response to you about the status of your request on or about March 15, 2019. Thank you for your patience. Sincerely, ITD PDO
To monitor the progress, update this request, make payments and download your responsive records please log into the Public Records Request Center. (https://u8387795.ct.sendgrid.net/wf/click?upn=S-2BehCBSDSzwVGewhY9FtkXJ91fxIoY-2BgXaEKqJaICVpOYbbwwc9jnXiobb65RLkU0f5Ep56eIF1uwa6shpgedaGKAQaiEf2LeCUyUXHd9fc-3D_vWLpM80-2BdtbVEGePF4yfAO5fIFp0gvV-2FTwhXx3wK9dSjFowFIobXJb7Ujt9Q-2BJabMA8cD2p8MnLRe4Kmo-2BfcGs8ZjIq9ECYDiRLkrEX9iWvQVk5WLWUTYkV7vzgykF-2FkISGeYAge5qdJVuN9TJuwv1-2BWb4sk61KPesPjpaeNtfmGW-2F3MNuj39F8wtKtHpie24Z2ohYUQkAdWruPLgXZBpgy-2FGIwV3GDeGbiUDEDyAK92B27DOv5m5KhsvrUwiJx8PcX6wWAPieE4k5CWt020pXIx1WfR8n41nFoesK-2BIrtJQ23eMLEOFwD4xTKhdJOPwpbCc99O0NCiD7OE-2FR-2BL18ttyz-2BSOia-2Fb-2FnEkkQzB1Au2EKaM-2FNlQukT4iIfwmeNKRlmMgSxK0wiK3s91Etnjzg-3D-3D)
From: Department of Information Technology
--- Please respond above this line ---
Dear Matt Chapman, This communication is in response to your public disclosure request C030407-072218 received on July 22, 2018. The purpose of this email is to provide a status update regarding your request. Seattle IT needs additional time to respond to your request due to the complexity of the request. At this time, the Department anticipates that it will be able to provide the requested records or a first installment of records on or about April 15, 2019. Sincerely,
*ITD *PDR
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman, This communication is in response to your public disclosure request C030407-072218. The purpose of this email is to provide a status update regarding your request. Seattle Information Technology needs additional time to respond to your request due to a heavy caseload of requests . At this time, the Department anticipates that it will be able to provide the requested records or a first installment of records on or about April 26, 2019. Thank you for your patience. Sincerely,
ITD PDO
PDO/ Seattle InformationTechnology
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman, This communication is in response to your public disclosure request C030407-072218. The purpose of this email is to provide a status update regarding your request. Seattle Information Technology needs additional time to respond to your request due to a heavy caseload of requests . At this time, the Department anticipates that it will be able to provide the requested records or a first installment of records on or about April 26, 2019. Thank you for your patience. Sincerely,
ITD PDO
PDO/ Seattle InformationTechnology
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman, This communication is in response to your public disclosure request C030407-072218. The purpose of this email is to provide a status update regarding your request. Seattle Information Technology needs additional time to respond to your request due to a heavy caseload of requests . At this time, the Department anticipates that it will be able to provide the requested records or a first installment of records on or about May 20, 2019. Thank you for your patience. Sincerely,
ITD PDO
PDO/ Seattle InformationTechnology
From: Department of Information Technology
--- Please respond above this line ---
Dear Mr. Chapman, This communication is in response to your public disclosure request C030407-072218. The purpose of this email is to provide a status update regarding your request. Seattle Information Technology needs additional time to respond to your request due to a heavy caseload of requests . At this time, the Department anticipates that it will be able to provide the requested records or a first installment of records on or about May 20, 2019. Thank you for your patience. Sincerely,
ITD PDO
PDO/ Seattle InformationTechnology
From: Department of Information Technology
Dear Matt Chapman,
Records in response to your public disclosure request C030407-072218 received on July 22, 2018 are now available. The cost for the records is as follows:
Invoice Number: INV19-C030407-1
Total: $1.25
To pay online, please follow these steps: Please note that you will need to disable any pop-up blockers to make a payment using the system.
Once your payment has been approved, we will send you an email with instructions on how to download your records. Note that City staff must manually upload records. Records will be available one to two business days after payment.
Please let your public disclosure officer (PDO) know if you are unable to pay online; your PDO will work with you on alternative ways to make your payment.
You have 30 days from today’s date to pay for your records. If the City does not receive your payment within this time period, your request will be considered abandoned, and you will need to submit a new request.
Please add seattle@mycusthelp.net to your email contacts/address book to ensure delivery of the record center emails to your inbox. (mailto:seattle@mycusthelp.net)
This is an auto-generated email originating from an unmonitored email account. Please DO NOT REPLY.
From: Matt Chapman
To Whom It May Concern:
Please find enclosed a check for $1.25 to satisfy the fee associated with the attached public records request.
Thank you.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 18, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 18, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 18, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 18, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I'm following up on the following Washington Public Records Act request, copied below, and originally submitted on July 23, 2018. You had previously indicated that it would be completed on May 20, 2019. I wanted to check on the status of my request, and to see if there was a new estimated completion date. You had assigned it reference number #C030407-072218.
Thanks for your help, and let me know if further clarification is needed.
Files
There are no files associated with this request.