Copy of HR, CAD, RMS, IAPro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, DEMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (King County Sheriff's Office)

Thank you for your interest in obtaining public records held by the King County Sheriff’s Office. Your request has been received and is being processed. Your request was received in this office on October 21, 2019 and given the reference number P040968-102119 for tracking purposes.

Within five business days (excluding holidays) after receiving your request, we will:


* Provide the record(s);
* Or Acknowledge your request and give you a reasonable estimate of how long it will take to respond;
* Or Deny the request in writing, stating the reasons for the denial (this could also include a denial of part of your request and a granting of the remainder).
Record(s) Requested: To Whom It May Concern:

Pursuant to the Washington Public Records Act, I hereby request the following records:

First off phone communications or in person communications with me must be recorded. My phone number is 206-905-6583 and is automatically record inbound and outbound and with auto recording legal warning on inbound and outbound. Some of you have other numbers for me. I won't accept calls from those numbers. Any meetings or phone conferences should include a PRA attorney and the IT person with most knowledge of SQL.

The purpose of the request to address the commercial use prohibition on list of persons is to conduct very complex analysis that goes far beyond what the agency has ever done and to importantly put all of the data in a data warehouse to do cross database analysis. Tim Clemans or InvestigateSafety LLC will not use the data to solicit business transactions nor will it knowly share the data with others that state they want to do so. The data will be published to the internet with the statement taken from Washington State SOS "RCW 42.56.070(8) prohibits the Office of the Secretary of State from providing access to lists of individuals requested for commercial purposes. The company or person using this data agrees that lists of individuals derived by the company or person from the information obtained from this site will not be provided to any customer for commercial purposes in violation of RCW 42.56.070(8)." modified to say supplying agency's name. https://www.sos.wa.gov/corps/alldata.aspx Toby Nixon of WashingtonCOG said to "Does the non commercial use prohibitions for list of persons and dashcam prohibit requester from publishing those records online i filled out a bunch of forms stating purpose of data including to put online and havent heard back" that "I do not believe posting online falls under the definition of "commercial use", even if you have ads on the site. But I'm not your attorney. 🙂"

The request is for a copy of all HR, CAD, RMS, IAPro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, DEMS, 911 Call/radio recorder, Internet logs, Forensics software including tables creating by the SQL software automatically like table of table names and columns. I demand that the data be copied to the CSV format and redactions be done in either Excel or a text editor replacing redacted content with *R*. No exemption log is requested/wanted unless the entire request is denied or for trade secrets/proprietary data/copyright exemptions. I demand to review all third party notifications before notifications are done to add more information to the notification. I records request the contracts and data dictionaries for each effected vendor. Washington State Law doesn't allow this request to be denied because it would take time to review and redact. Nor does it allow the agency to claim that copying the data creates a new record. "If any agency translates a record into an alternative electronic format at the request of a requestor, the copy created does not constitute atab new public record for purposes of this chapter. "

I demand that IT staff only be used to mass copy the data to CSV files using the most efficient software they already have. I request the written name of each sql server used and the name of each sql access tool owned by the agency or the agency's IT provider. I demand the cheapest IT employee or contactor be used that has the ability to press button on SQL access software. I demand that IT not records officer communicate with this email address about the technical aspects of the request and that attorney not records officer communicate with this email about the legal aspects of the request.

I demand a custom data invoice be provided prior to any data copying except to ensure no data covered by the request is deleted. Vendors should be able to freeze deletion for the time it takes to copy the data.

For first installment I demand the table of each table and columns per table: For Microsoft SQL this is the tables sys.objects, sys.columns, sys.types, INFORMATION_SCHEMA.COLUMNS Oracle: ALL_TAB_COLS or DBA_TAB_COLS Mysql: information_schema.columns Postgres: information_schema.columns
For second installment I demand 10 oldest rows of each table except ones released in first installment
Installments are that I request be coordinated with me with an efficient review/redact/release plan. We can work together to remove columns from the request and or rows based on Excel queries.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter.

I look forward to receiving your response to this request within 5 business days, as the statute requires.

Sincerely,

TimClemans

Upload documents directly: https://https://www.muckrock.comhttps://www.muckrock.com/

Once the records have been collected, we will notify you of any copying charges. Any records or portion of records that are exempt from disclosure will be withheld or redacted. We will specify the exemption that applies to any documents withheld or redactions made.

You can monitor the progress of your request at the link below and you'll receive an email when your request has been completed. Again, thank you for using the King County Sheriff’s Office online request system.

King County Sheriff’s Office | Public Disclosure Unit

(206) 263-2103 | www.kingcounty.gov/sheriff (https://u8387795.ct.sendgrid.net/wf/click?upn=S-2BehCBSDSzwVGewhY9FtkeGqwNAWRHbabo7pkfJ0cOUO-2FIJ-2FFWcx5AxWfEVW-2BteS_DasOHqSHhj2mxCXAB3Hxkw2vi1yoYZDRnF1tbrre6pa5iGMWA0edbLMPp4LNIJQv8J06FdbEQegWHfJSlH3Uc3CdiM2oxxIBCIEeN48KPZfYlwdbU4k5U3Is77o0gvyu0XaI6c3k1rHZT60xsI3Pj9l-2FwHxIzzMff4DqC4cLCgseXPcItbTQHJnUM7mi6bRVkkFPNXku5rYUawAgvKWFQt2EHfFy7iIqqZwjx2E6P1VdbY3NZzk-2FHCFn1xrW9k0ZkTsIwfC8gzQ8t4fj7KPN1vOfMpKAH4gtXnzbx37ZZOr8caCwYjyr99PYlxVBHCxBdkl4iPfsFBsNwoz5EB6X-2FYanQ1DJQpqQwlaznz4afnIZNVyUS1eek5stJfpTh82QsQnxdoO2IUIs-2FVpDlHwLaQ-3D-3D)

--- Please respond above this line ---
Subject: Public Disclosure Request Reference# P040968-102119 Thank you for your request made via the King County Sheriff’s Office (KCSO) on October 21, 2019. You requested: (%5bREQUEST_VIEW_HREF%5d) Online Request System “To Whom It May Concern:

Pursuant to the Washington Public Records Act, I hereby request the following records:

First off phone communications or in person communications with me must be recorded. My phone number is 206-905-6583 and is automatically record inbound and outbound and with auto recording legal warning on inbound and outbound. Some of you have other numbers for me. I won't accept calls from those numbers. Any meetings or phone conferences should include a PRA attorney and the IT person with most knowledge of SQL.

The purpose of the request to address the commercial use prohibition on list of persons is to conduct very complex analysis that goes far beyond what the agency has ever done and to importantly put all of the data in a data warehouse to do cross database analysis. Tim Clemans or InvestigateSafety LLC will not use the data to solicit business transactions nor will it knowly share the data with others that state they want to do so. The data will be published to the internet with the statement taken from Washington State SOS "RCW 42.56.070(8) prohibits the Office of the Secretary of State from providing access to lists of individuals requested for commercial purposes. The company or person using this data agrees that lists of individuals derived by the company or person from the information obtained from this site will not be provided to any customer for commercial purposes in violation of RCW 42.56.070(8)." modified to say supplying agency's name. https://www.sos.wa.gov/corps/alldata.aspx Toby Nixon of WashingtonCOG said to "Does the non commercial use prohibitions for list of persons and dashcam prohibit requester from publishing those records online i filled out a bunch of forms stating purpose of data including to put online and havent heard back" that "I do not believe posting online falls under the definition of "commercial use", even if you have ads on the site. But I'm not your attorney. 🙂"

The request is for a copy of all HR, CAD, RMS, IAPro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, DEMS, 911 Call/radio recorder, Internet logs, Forensics software including tables creating by the SQL software automatically like table of table names and columns. I demand that the data be copied to the CSV format and redactions be done in either Excel or a text editor replacing redacted content with *R*. No exemption log is requested/wanted unless the entire request is denied or for trade secrets/proprietary data/copyright exemptions. I demand to review all third party notifications before notifications are done to add more information to the notification. I records request the contracts and data dictionaries for each effected vendor. Washington State Law doesn't allow this request to be denied because it would take time to review and redact. Nor does it allow the agency to claim that copying the data creates a new record. "If any agency translates a record into an alternative electronic format at the request of a requestor, the copy created does not constitute atab new public record for purposes of this chapter. "

I demand that IT staff only be used to mass copy the data to CSV files using the most efficient software they already have. I request the written name of each sql server used and the name of each sql access tool owned by the agency or the agency's IT provider. I demand the cheapest IT employee or contactor be used that has the ability to press button on SQL access software. I demand that IT not records officer communicate with this email address about the technical aspects of the request and that attorney not records officer communicate with this email about the legal aspects of the request.

I demand a custom data invoice be provided prior to any data copying except to ensure no data covered by the request is deleted. Vendors should be able to freeze deletion for the time it takes to copy the data.

For first installment I demand the table of each table and columns per table: For Microsoft SQL this is the tables sys.objects, sys.columns, sys.types, INFORMATION_SCHEMA.COLUMNS Oracle: ALL_TAB_COLS or DBA_TAB_COLS Mysql: information_schema.columns Postgres: information_schema.columns
For second installment I demand 10 oldest rows of each table except ones released in first installment
Installments are that I request be coordinated with me with an efficient review/redact/release plan. We can work together to remove columns from the request and or rows based on Excel queries.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter.

I look forward to receiving your response to this request within 5 business days, as the statute requires.

Sincerely,

TimClemans

Upload documents directly: https://https://www.muckrock.comhttps://www.muckrock.com/ The KCSO is experiencing a high volume of open requests. Your request is one of many (21) that we are processing from you. We will begin processing this request once we have completed all installments for your prior requests. However, keep in mind that this request may require clarification. Depending on the scope and results of our research, we may need to respond to your request through a series of installments with a first installment by May 1, 2020. If we are unable to meet this self-imposed deadline, we will let you know. If we are able to provide a response sooner, we will certainly do so. Your request is subject to fees as allowed under King County Ordinance 18949 and the Public Records Act, RCW 42.56.120 . Please visit our website and select " What is the cost to obtain records " for more information. Once we have determined the scope of your request and responsive records, we may provide an estimate for fees requiring 10% down prior to processing your request. PLEASE NOTE: Per RCW 42.56.120(4), the KCSO reserves the right to close a records request after 30 days if a requester does not inspect, view, download, and/or pick up the records we provide. There is no obligation for us to continue producing records that are not being collected by a requester. RCW 42.56.120(4) states that if an installment of a records request is not claimed or reviewed, the agency is not obligated to fulfill the balance of the request. WAC 44-14-04006(1) states that a records request has been fulfilled and can be closed if an entirely unclear request has not been clarified,a request or installment has not been claimed or reviewed, or the requester cancels the request.
Please reply to this message or log in to the Online Request System if you have any questions or would like to clarify or cancel this request. Sincerely, Kimberly Petty | Public Disclosure Program Manager | Sheriff's Administration - Legal Unit 206.263.2630 | www.kingcounty.gov/sheriff

If you wish to track or respond to this request, please login to the Online Request System. (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN5lE7cMJ1domRh3-2FD3qVNIwW98fjQpt1-2BBEHNHssgEpKuEdDjx0d1fuyz-2B3ammyfTu-2F2vuAY8fuAanN57tldOGE-3D_DasOHqSHhj2mxCXAB3Hxkw2vi1yoYZDRnF1tbrre6pa5iGMWA0edbLMPp4LNIJQv8J06FdbEQegWHfJSlH3UcwoqM7vl5UolB3JyLAD9v-2FTcYen5f0OaFvoWsmuHK5fpX70GJSHt9ja-2F9N0-2BsTrgshfjG79DmsT5oLfKY192f2j4KrVI494n93P7vySV6mxYW3MVK-2Fbuzvp6Un8dSATm9Z5sagrVEmI2V1FqrweZIomkXuv6yLd3NWbq-2BPh4y6vxAmZkWzV4lAFOzWr27oCPg1a6XjxOEip-2BVFO-2BX4YDigCDXmhN2-2FyRxK2hB0QC866zXyh-2FHUHAaZ7Op6gvhhmqgv1JeyJT62NmdezrOT0AXXzL-2FDqGXz3EvWR-2BfN33BTGx)

--- Please respond above this line ---
Subject: Public Disclosure Request Reference# P040968-102119 Thank you, again, for your request made via the King County Sheriff’s Office (KCSO) on October 21, 2019. You requested: (%5bREQUEST_VIEW_HREF%5d) Online Request System “To Whom It May Concern:

Pursuant to the Washington Public Records Act, I hereby request the following records:

First off phone communications or in person communications with me must be recorded. My phone number is 206-905-6583 and is automatically record inbound and outbound and with auto recording legal warning on inbound and outbound. Some of you have other numbers for me. I won't accept calls from those numbers. Any meetings or phone conferences should include a PRA attorney and the IT person with most knowledge of SQL.

The purpose of the request to address the commercial use prohibition on list of persons is to conduct very complex analysis that goes far beyond what the agency has ever done and to importantly put all of the data in a data warehouse to do cross database analysis. Tim Clemans or InvestigateSafety LLC will not use the data to solicit business transactions nor will it knowly share the data with others that state they want to do so. The data will be published to the internet with the statement taken from Washington State SOS "RCW 42.56.070(8) prohibits the Office of the Secretary of State from providing access to lists of individuals requested for commercial purposes. The company or person using this data agrees that lists of individuals derived by the company or person from the information obtained from this site will not be provided to any customer for commercial purposes in violation of RCW 42.56.070(8)." modified to say supplying agency's name. https://www.sos.wa.gov/corps/alldata.aspx Toby Nixon of WashingtonCOG said to "Does the non commercial use prohibitions for list of persons and dashcam prohibit requester from publishing those records online i filled out a bunch of forms stating purpose of data including to put online and havent heard back" that "I do not believe posting online falls under the definition of "commercial use", even if you have ads on the site. But I'm not your attorney. 🙂"

The request is for a copy of all HR, CAD, RMS, IAPro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, DEMS, 911 Call/radio recorder, Internet logs, Forensics software including tables creating by the SQL software automatically like table of table names and columns. I demand that the data be copied to the CSV format and redactions be done in either Excel or a text editor replacing redacted content with *R*. No exemption log is requested/wanted unless the entire request is denied or for trade secrets/proprietary data/copyright exemptions. I demand to review all third party notifications before notifications are done to add more information to the notification. I records request the contracts and data dictionaries for each effected vendor. Washington State Law doesn't allow this request to be denied because it would take time to review and redact. Nor does it allow the agency to claim that copying the data creates a new record. "If any agency translates a record into an alternative electronic format at the request of a requestor, the copy created does not constitute atab new public record for purposes of this chapter. "

I demand that IT staff only be used to mass copy the data to CSV files using the most efficient software they already have. I request the written name of each sql server used and the name of each sql access tool owned by the agency or the agency's IT provider. I demand the cheapest IT employee or contactor be used that has the ability to press button on SQL access software. I demand that IT not records officer communicate with this email address about the technical aspects of the request and that attorney not records officer communicate with this email about the legal aspects of the request.

I demand a custom data invoice be provided prior to any data copying except to ensure no data covered by the request is deleted. Vendors should be able to freeze deletion for the time it takes to copy the data.

For first installment I demand the table of each table and columns per table: For Microsoft SQL this is the tables sys.objects, sys.columns, sys.types, INFORMATION_SCHEMA.COLUMNS Oracle: ALL_TAB_COLS or DBA_TAB_COLS Mysql: information_schema.columns Postgres: information_schema.columns
For second installment I demand 10 oldest rows of each table except ones released in first installment
Installments are that I request be coordinated with me with an efficient review/redact/release plan. We can work together to remove columns from the request and or rows based on Excel queries.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter.

I look forward to receiving your response to this request within 5 business days, as the statute requires.

Sincerely,

TimClemans

Upload documents directly: https://https://www.muckrock.comhttps://www.muckrock.com/

The KCSO continues to experience a high volume of open requests. We noticed that you have abandoned most of your other requests due to unresponsiveness and returned/undeliverable emails. This request requires significant resources through research and coordination with technical and subject matter experts in order to determine the scope, search terms and how to identify responsive records. As such, we will not begin researching your request until we are sure you're still interested. Please confirm you are still seeking the information requested. If we don't hear from you by February 28, 2020, we will consider your request abandoned. If you are still interested, then again, we hope to provide an update as to the results of our searches and first installment by May 1, 2020. If we are unable to meet this self-imposed deadline, we will let you know. If we are able to provide a response sooner, we will certainly do so. Your request is subject to fees as allowed under King County Ordinance 18949 and the Public Records Act, RCW 42.56.120. Please visit our and select "What is the cost to obtain records" for more information. Once we have determined the scope of your request and responsive records, we will require full payment prior to release of responsive records. website (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN4U-2BzByHJzYh0XeTVNqriImX0r1F7GrrhQl4qqt-2F4Is-2BZDks4H0rS-2B48oW-2F1eOY-2BXllhMGUiZGlJVNmUUXgGu4iK7okn3ramOlCy0CqJ2vMtCWdePBecrkPJusCJ29qmcg-3D-3D_DasOHqSHhj2mxCXAB3Hxkw2vi1yoYZDRnF1tbrre6pa5iGMWA0edbLMPp4LNIJQv8J06FdbEQegWHfJSlH3UcxgP8zb7KKo3-2BxRB5RuTX7GolCZmm3IdCPw3Jr9FRVBcNdQgMzkKrSigscue6RMHzMDeGEmSPMpaZ7ZZskdXu008pz5QrE9RqxcYyi5IWM8yiLdVPjCNRvB8ALyUnPtmM56DVJj-2BMulRIgSmmGoOFkBzNtVR-2FeZkPsp9MoNOSavfJ3tc9G-2F6G87Qq-2FCRgcWAk7R1kW-2BsXAEuNVTLciWcJjtCiWtWXpadw97gNR5aAR99dDpbe5nf5m-2BEVwkDZnBmCiRae4dhcswdxCQDMDmwhABN0SfwsqxlyevT5I1rPom-2FUjw3-2BIkV3rEGfbuB1PEifAXLd5mmPO7Mn4nNKi5Rfd0-3D) PLEASE NOTE: Per RCW 42.56.120(4), the KCSO reserves the right to close a records request after 30 days if a requester does not inspect, view, download, and/or pick up the records we provide. There is no obligation for us to continue producing records that are not being collected by a requester. RCW 42.56.120(4) states that if an installment of a records request is not claimed or reviewed, the agency is not obligated to fulfill the balance of the request. WAC 44-14-04006(1) states that a records request has been fulfilled and can be closed if an entirely unclear request has not been clarified,a request or installment has not been claimed or reviewed, or the requester cancels the request.
Please reply to this message or log in to the Online Request System if you have any questions or would like to clarify or cancel this request. Sincerely, Kimberly Petty | Public Disclosure Program Manager | Sheriff's Administration - Legal Unit 206.263.2630 | www.kingcounty.gov/sheriff

If you wish to track or respond to this request, please login to the Online Request System. (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN5lE7cMJ1domRh3-2FD3qVNIwW98fjQpt1-2BBEHNHssgEpKuEdDjx0d1fuyz-2B3ammyfTu-2F2vuAY8fuAanN57tldOGE-3D_DasOHqSHhj2mxCXAB3Hxkw2vi1yoYZDRnF1tbrre6pa5iGMWA0edbLMPp4LNIJQv8J06FdbEQegWHfJSlH3UcxgP8zb7KKo3-2BxRB5RuTX7GolCZmm3IdCPw3Jr9FRVBcNdQgMzkKrSigscue6RMHzMDeGEmSPMpaZ7ZZskdXu008pz5QrE9RqxcYyi5IWM8yiLdVPjCNRvB8ALyUnPtmM56DVJj-2BMulRIgSmmGoOFkBkvwb5-2BjkXjI6tjYv6sPyNbmxLVwx6DaTSzEh-2Fnzn-2BCKL3X5vgBumxXP4MnL9BWKsnAXzNwKizONSn4eS5H0nM0g-2Fe3XHTs9MliUi6xt9qPR26TdIHA8K85zYQRmfPUZ-2FuU4WbKVHGXPpC0QqKmgKmNP3mxqYpBRkVBuMO-2B37vH0d2ohwRpGhe8b-2FHMMV5GOM-3D)