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 (Washington State Patrol)

Dear Tim Clemans,
Thank you for registering with the Washington State Patrol (WSP) Public Records Center. If you have never used this system, your account has been created by a staff person at WSP.
Thank you,
Washington State Patrol
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY

Dear Tim Clemans:
Thank you for your interest in public records of the Washington State Patrol. Your request has been received and is being processed in accordance with the Revised Code of Washington, RCW 42.56. Your request was received in this office on 10/21/2019 and given the reference number R012845-102119 for tracking purposes.
Records 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://accounts.muckrock.com/accounts/login/?url_auth_token=AAAawHapt0XKE6ZBQMyv_eeI3Ek%3A1iMZlC%3AVCaeOQvJIfTQkyRhWNUGjkKEa9U&next=https%3A%2F%2Fwww.muckrock.com%2Faccounts%2Flogin%2F%3Fnext%3D%252Faccounts%252Fagency_login%252Fwashington-state-patrol-211%252Fcopy-of-hr-cad-rms-iapro-or-similar-software-parking-tickets-driving-citations-j-walking-or-similar-citations-dems-911-callradio-recorder-internet-logs-forensics-software-sql-data-washington-state-patrol-81919%252F%253Femail%253Dpubrecs%252540wsp.wa.gov

Your request will be forwarded to the relevant Washington State Patrol department(s) to locate the information you seek and to determine the volume and any costs associated with satisfying your request. You will be contacted about the availability and/or provided with copies of the records in question. PLEASE NOTE: The Washington Public Records Act does not require a governmental body to create new information, to do legal research, or to answer questions.

--- Please respond above this line ---

RE: Public Records Request of October 21, 2019, Reference # R012845-102119
Dear Tim Clemans,
Thank you for your inquiry to the Washington State Patrol. Pursuant to RCW 42.56.520, this is notification that we have received your public disclosure request below.
“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://accounts.muckrock.com/accounts/login/?url_auth_token=AAAawHapt0XKE6ZBQMyv_eeI3Ek%3A1iMZlC%3AVCaeOQvJIfTQkyRhWNUGjkKEa9U&next=https%3A%2F%2Fwww.muckrock.com%2Faccounts%2Flogin%2F%3Fnext%3D%252Faccounts%252Fagency_login%252Fwashington-state-patrol-211%252Fcopy-of-hr-cad-rms-iapro-or-similar-software-parking-tickets-driving-citations-j-walking-or-similar-citations-dems-911-callradio-recorder-internet-logs-forensics-software-sql-data-washington-state-patrol-81919%252F%253Femail%253Dpubrecs%252540wsp.wa.gov”
We anticipate it may take up to 30 days from the date of this notification to provide our response. Additional time is required due to the current volume of pending records requests, and to research this request, search for and collect existing responsive records, notify involved parties, and/or prepare records for dissemination.
Should you have any questions, please respond to this email.
Sincerely,
Elizabeth Hoffman
Video Unit Supervisor

Dear Tim Clemans:
Thank you for your interest in public records of the Washington State Patrol. Your request has been received and is being processed in accordance with the Revised Code of Washington, RCW 42.56. Your request was received in this office on 10/29/2019 and given the reference number R013287-102919 for tracking purposes.
Records Requested: Hi WSP I just found out you have a state wide arrest database. I need a copy of it urgently. I request the arrest database. I need the tables and field names immediately and will write Excel code to auto redact it. No exemption log wanted.
Your request will be forwarded to the relevant Washington State Patrol department(s) to locate the information you seek and to determine the volume and any costs associated with satisfying your request. You will be contacted about the availability and/or provided with copies of the records in question. PLEASE NOTE: The Washington Public Records Act does not require a governmental body to create new information, to do legal research, or to answer questions.

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 Public Records Center.
Washington State Patrol
To monitor the progress or update this request please log into the Public Records Center. (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuuOprP9-2B-2B5OQXEzIkVzeJHAh3x4k-2B5Bl5tjZsF9HzR3PAbP-2FsDYaYIPzQI-2BP0Pg0UUnTt4Sv5GsqVxE6-2Bc1d9cA-3D_EWaXiZRz3d0pbRPznRyBafd7OXHGlu9iBDi8EaF3V5KUU6TsRxo8XXIDp0Epog-2FxKxKAug22-2BWbDuxMliJOZm4DtTwvS-2BD-2FEywR83UVR6kXAleMNsKwHo6dEaucPXMs6ZTfCq-2FCxcQy55PBLRdpFnvwhvBq1m0lPKWpwb251MfcodroDBq-2BSNqYHQzIcMZf-2BGDSeGLZgkOk50vrFQa27-2FMyCne75xEjIWYGoNlxOo1-2BmJSlJeXq8T-2BmCXxlpnZGxPYVTA8KPYDcOjtqAcfjC4reK1fgmzIG-2BXcv0lTAXsblbPDhQJxz6BSZCg3DU4s5s85-2BvXL6fziZO8DCRxTbeCZXf-2FQxszWHdt-2BrNg9KuBuXvpF7jLYnoNLCYymdZOrA7mtFCapAhmqpNvS4e91m7gg-3D-3D)

--- Please respond above this line ---

RE: Public Records Request of October 29, 2019, Reference # R013287-102919
Dear Tim Clemans,
Thank you for your inquiry to the Washington State Patrol. Pursuant to RCW 42.56.520, this is notification that we have received your public disclosure request below.
“Hi WSP I just found out you have a state wide arrest database. I need a copy of it urgently. I request the arrest database. I need the tables and field names immediately and will write Excel code to auto redact it. No exemption log wanted.”
We anticipate it may take up to 30 days from the date of this notification to provide our response. Additional time is required due to the current volume of pending records requests, and to research this request, search for and collect existing responsive records, notify involved parties, and/or prepare records for dissemination.
Should you have any questions, please respond to this email.
Sincerely,
Gretchen Dolan
Public Records Officer

To monitor the progress or update this request please log into the Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuuOprP9-2B-2B5OQXEzIkVzeJHAh3x4k-2B5Bl5tjZsF9HzR3PAbP-2FsDYaYIPzQI-2BP0Pg0UUnTt4Sv5GsqVxE6-2Bc1d9cA-3D_EWaXiZRz3d0pbRPznRyBafd7OXHGlu9iBDi8EaF3V5KUU6TsRxo8XXIDp0Epog-2FxKxKAug22-2BWbDuxMliJOZm-2B2bUstWirxAMkv4C6uFJ2Y0hQK8D3-2B1KU9NXgo2THZzwzkVHZJChl-2F2NvtScuX0RTAIWYSUlC7FrjNCCSF2GlPgTmTWvqiMA7BdGrJgOr-2Fv6dJmNdWLXCnW9I6H8i1CRZ-2FOSu3yHmbHl321xFHYSpbKIIWudn0DeGtaEmfSmdGmDI1-2FZGaAvASM34PAedzU7tbHa-2Fdmn0BEEFY8RBE1DMawbhwWrbgWTCuM1LttuxSHyq4Fu8WE1byFfgISKz3kaTXKXM8vtlfqtcyY1E-2FPToEq61Kc2WzB2N450GeqDIqER30UQvRwBxUwaYY5Y2UjgA-3D-3D)

--- Please respond above this line ---

RE: PUBLIC RECORDS REQUEST of October 29, 2019, Reference # R013287-102919.
Dear Tim Clemans,
The Washington State Patrol (WSP) received a public records request from you on October 29, 2019. You requested:
“Hi WSP I just found out you have a state wide arrest database. I need a copy of it urgently. I request the arrest database. I need the tables and field names immediately and will write Excel code to auto redact it. No exemption log wanted.”
WSP has reviewed your request and has determined that the records requested are exempt from disclosure for the following reasons:
The Washington State Patrol Identification and Criminal History Section is the repository for criminal history record information (CHRI) for the state of Washington pursuant to Chapter 10.97 RCW. The dissemination of CHRI is exclusively governed by RCW 10.97.050, RCW 43.43.710, 28 USC § 534 and 28 CFR Part 20, and is not subject to the Public Records Act (Chapter 42.56 RCW).
Non-conviction criminal history information is for law enforcement use only, and restricted from dissemination under the above provisions. To obtain a copy of conviction CHRI you may conduct a search using the Internet website, Washington Access to Criminal History (WATCH), at http://watch.wsp.wa.gov. There is a $10 fee, payable by major credit card, and the response is returned immediately online. This fee is required per search.

Additionally, it is likely we do not have complete records related to arrests in the CHRI database. All records contained in the Washington State Identification System (WASIS) criminal history database are fingerprint based. If we do not have a fingerprint based record on an individual, we would not have any subsequent arrest information. If an individual is not fingerprinted at the time of the arrest event, or if those prints are not submitted to us, we would not have those records in our system.
This response completes your request. Should you have any questions, please respond to this email.
Sincerely,
Gretchen Dolan, Public Records Officer

To monitor the progress or update this request please log into the Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuuOprP9-2B-2B5OQXEzIkVzeJHAh3x4k-2B5Bl5tjZsF9HzR3PAbP-2FsDYaYIPzQI-2BP0Pg0UUnTt4Sv5GsqVxE6-2Bc1d9cA-3D_EWaXiZRz3d0pbRPznRyBafd7OXHGlu9iBDi8EaF3V5KUU6TsRxo8XXIDp0Epog-2FxKxKAug22-2BWbDuxMliJOZm-2FSiplDLMuRV7Hud4haNwgQ5fKxUw0sB-2B2If0LJcsPefKuOu4PaNIuPf62L6qhmK3Hy-2FmyacfH-2BLYOF5-2FiM021jdAg5HFB6z3lai-2BH7X3wj-2BwLdYKwvJSynG9ytd8vX6OLs2q6PeMXKaKAU5RTNMFGiKDqwNxYTeuQ-2FZNGFlGKqZ9M1c6cFR6lsoEt-2B-2B8n6vanv7ZAM-2F5rlTD0wDnY0Q3MO1RwP9r1VYP-2BfEWGGvynNEc9J7fpQQun0D5ImLlA8YTIhHuxqkVveoi3ag-2B0RB2V-2Bf7lsasO0abfELR0-2FtnL2z9fpOz6O0pecDeYB84liehQ-3D-3D)

--- Please respond above this line ---

RE: Public Records Request of October 21, 2019, Reference # R012845-102119
Dear Tim Clemans,
Thank you for your inquiry to the Washington State Patrol.  Pursuant to RCW 42.56.520, this is notification that we have received your public disclosure request for:
“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."
Your request does not provide “a reasonable description enabling the government employee to locate the requested records” and was not for clearly identifiable WSP public records, as required by RCW 42.56.080 (see also O’Neill v. City of Shoreline, 145 Wn. App. 913, 926 (2008)).
Please provide us with the following clarification(s):
Are you seeking data exports from these systems or some other type of record?  Please also clarify the terms "IAPro", "DEMS", and "Forensics software".
Once we have received clarification, we will be able to process your request. Pursuant to RCW 42.56.520, if clarification is not received within 30 calendar days, we will consider this request abandoned and cancel it. In that event, please feel free to resubmit your request at any time with the clarified elements included.
We anticipate it may take up to 30 days from the date of this notification to provide our response. Additional time is required to receive clarification and process your request.
You can send your clarification by logging into our online Public Records Center and sending a message.
Should you have any additional questions or concerns, please respond to this email.
Sincerely,
Gretchen Dolan, Public Records Officer

To monitor the progress or update this request please log into the Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVuuOprP9-2B-2B5OQXEzIkVzeJHAh3x4k-2B5Bl5tjZsF9HzR3PTu7uAo3e8-2FTVBKDU-2Bz-2FSYRTVruAATGTJ3ZvHs8O4ULY-3D_EWaXiZRz3d0pbRPznRyBafd7OXHGlu9iBDi8EaF3V5KUU6TsRxo8XXIDp0Epog-2FxKxKAug22-2BWbDuxMliJOZmzHWzglnjrIjd0jZZtsC4umaZ7fRFebsFsKnPm5OsMukSLFWAzkm8E02oVzf6TEDjEh55LF0-2FkZ-2FczGEGQRyks-2BClFG6UQxl8xmIP82F7Itn2pezCT2nTN5053oF04MDqk-2F1YOsCHEYx-2FIZL3RBnWmq8Zc8tcx1s9L652h8mNLXH3CIHvZa4xEFqw8vQ7HPTXcNOCm-2BRLO2qjOj2-2FoJvrtQMgfG1axC0oxl9qAYR6UbDqfcMsjXdQp9bPar-2BFxfDfjmIZK6ik-2F9ksJYKWBNIaKuhGfSjXiJ22mqLf73Jv4Tg8Q4IsBEET8L9-2FIXmig8UKA-3D-3D)

--- Please respond above this line ---
Subject: [Records Center] Public Records Request :: R012548-101419
Body:
RE: Public Records Request of October 14, 2019, Reference # R012548-101419
Dear Mr. Tim Clemans,
The Washington State Patrol is continuing to work on your records request for the following:
“All photos and videos taken by drones and all photos and videos of the drones themselves. Topic is drones or drone use for collision investigations”
We anticipate it may take up to 60 days from the date of this notification to provide our response. Additional time is required due to the current amount of records requests, the volume of potentially responsive records, and to prepare records for dissemination without causing disruption to the essential functions of the agency (RCW 42.56.100).
Should you have any questions, please respond to this email.
Sincerely,
Gretchen Dolan
Public Records Officer

To monitor the progress or update this request please log into the Public Records Center (https://u8387778.ct.sendgrid.net/ls/click?upn=6HtRfOYLt5fXvpttM-2FU1HVSq22df7njlUlh-2F4NEGPxXCviGQG-2FN9qAWxxW-2FGGCBYPnVRNtmM7-2FluWkev5fK6oFSCD3XY9WqGPv8K5G4AGlE-3Drz6t_d2T1Wd4zv3sK4M-2FYO56lO7-2FkAr42-2B-2BVIsZFn61b6LlRxekUJdofAHz9Gv5ivkjilboDlC0aeWCsNLgTrEoJ6yPpQWQ4GHeHgfhnvBdSPIJX0Ps6gbzLlHlSPomSZXzMEhTBSp-2BMuYa9FT0Rw0UW669ta-2FQbMnuIeCD9lp-2F-2Fla-2FgC8hXKzkMSqztfN8sDXQ3NzYe2ce9Nu4RZurkiy9CpPAfueMW3OSY0WuYkyVEL44D1qQy7xzNtFMrM1shVPTD8eplkrpONMiByaCuY5JfhpShx33GmshTI-2Bp99Ah-2Fltm-2F5fmXuFbKGQrJG8RmyHq2NZfIsrECX3Q5tkuvXUTT9qIZUS8eMuF-2BLNFlIlHw-2FXhyt5-2B6zJF3p8TO38myVUUzU93qJT6tf8xEd6qypz7zbwQ-3D-3D)

Good Morning - We received a bounce back when we attempted to communicate with the provided email address regarding this records request. The provided address is tim@investigatesafety.com<mailto:tim@investigatesafety.com>. We are reaching out to the other email addresses we have on file for you. Please provide us with a correct email address to use. If we do not receive this clarification within the next 30 days, we will be forced to close your request as abandoned as we will have no way to communicate with you.

Sincerely,
WSP Public Records Section