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 (University of Washington Police)

TimClemans filed this request with the University of Washington Police of Washington.
Tracking #

PR_2022_000100

PR-2019-00813

Multi Request 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
Est. Completion Dec. 16, 2021
Status
Payment Required

Communications

From: TimClemans

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

From: University of Washington Police

October 28, 2019

Mr. Tim Clemans
MuckRock News
DEPT MR 81929
411A Highland Ave
Somerville, MA 02144-2516

Re: Public Records Request PR-2019-00813

Dear Mr. Clemans:

I am writing to acknowledge receipt of your public records request on October 21, 2019. We estimate we will respond to your request by December 5, 2019. As allowed by RCW 42.56.520, if additional time is needed to locate, review or assemble documents or to notify third parties affected by your request, we will contact you.

If you need to contact us about your request, please have the request number noted above available. If you have any questions, please feel free to contact this office.

Sincerely,

Andrea Tutmarc
Compliance Analyst
UNIVERSITY OF WASHINGTON
Office of Public Records and Open Public Meetings
Mail: Roosevelt Commons-Box 354997, Seattle, WA 98195
Street: 4311 11th Ave NE, #360

From: University of Washington Police

December 5, 2019

Mr. Tim Clemans
MuckRock News
DEPT MR 81929
411A Highland Ave
Somerville, MA 02144-2516

Re: Public Records Request PR-2019-00813

Dear Mr. Clemans:

The Office of Public Records and Open Public Meetings finds it necessary to extend the response date to your public records request to May 7, 2021. This extension is allowed by RCW 42.56.520 of the Public Records Act of Washington State. The extension is needed to locate, review or assemble documents or to notify third parties affected by your request.

However, this office is pleased to inform you that we will make some records available to you on a rolling production basis to avoid unnecessary delay.

Please let us know if you have any questions.

Sincerely,

Andrea Tutmarc
Compliance Analyst
UNIVERSITY OF WASHINGTON
Office of Public Records and Open Public Meetings
Mail: Roosevelt Commons-Box 354997, Seattle, WA 98195
Street: 4311 11th Ave NE, #360

From: University of Washington Police

May 7, 2021

Mr. Tim Clemans
MuckRock News
DEPT MR 81929
411A Highland Ave
Somerville, MA 02144-2516

Re: Public Records Request PR-2019-00813

Dear Mr. Clemans:

The Office of Public Records and Open Public Meetings finds it necessary to extend the response date to your public records request to December 16, 2021. This extension is allowed by RCW 42.56.520 of the Public Records Act of Washington State. The extension is needed to locate, review or assemble documents or to notify third parties affected by your request.

Please let us know if you have any questions.

Sincerely,

Andrea Tutmarc
Compliance Analyst
UNIVERSITY OF WASHINGTON
Office of Public Records and Open Public Meetings
Mail: Roosevelt Commons-Box 354997, Seattle, WA 98195
Street: 4311 11th Ave NE, #360

From: University of Washington Police

Dear Requester:

We are writing to inform you that the Office of Public Records and Open Public Meetings has implemented a new system. We are in the process of moving your public records request into this new system. As such, you should soon receive an email with instructions on registering your account on our new online portal.

If you have any questions, please contact our office.

Sincerely,

Office of Public Records and Open Public Meetings
Roosevelt Commons Box 354997
4311 11th Ave NE, Suite 360 Seattle, WA 98105

From:

From: University of Washington Police

December 16, 2021

Mr. Tim Clemans
MuckRock News
DEPT MR 81929
411A Highland Ave
Somerville, MA 02144-2516

Re: Public Records Request PR-2019-00813

Dear Mr. Clemans:

The Office of Public Records and Open Public Meetings finds it necessary to extend the response date to your public records request to March 16, 2022. This extension is allowed by RCW 42.56.520 of the Public Records Act of Washington State. The extension is needed to locate, review or assemble documents or to notify third parties affected by your request.

However, we will make some records available to you on a rolling production basis to avoid unnecessary delay.

Please let us know if you have any questions.

Sincerely,

Perry Tapper
Compliance Officer
UNIVERSITY OF WASHINGTON
Office of Public Records and Open Public Meetings
Mail: Roosevelt Commons-Box 354997, Seattle, WA 98195
Street: 4311 11th Ave NE, #360

From: University of Washington

Release Sought_3.2020










01/28/2022

Clemans Tim
MuckRock

Re: Public Records Request PR_2022_000100

Dear Requestor:

This email is to inform you that your public records number PR-2019-00813 has been changed to PR_2022_000100. Please use this new request number on all future correspondence with our office.

The University is piloting an online portal through which requestors can receive digital records. If you would like to opt in to this pilot project, please contact our office. The costs are as follows:

$0.05 for every 4 files, and $0.10 per GB

If you choose not to opt-in to the pilot program, our standard charges apply. See below:

Discs (CD) $0.69 per CD
Envelope $0.29 per envelope
Photocopy (Black & White copy) $0.15 per page
First Class US Postage

Requestors will be notified in advance of any non-standard charges.

Please feel free to contact this office if you have any questions or concerns.

Sincerely,

Perry Tapper

UNIVERSITY OF WASHINGTON
Office of Public Records and Open Public Meetings
Mail: Roosevelt Commons-Box 354997, Seattle, WA 98195
Street: 4311 11th Ave NE, #360

From: University of Washington

Invoice Sent_3.2020










02/10/2022

Tim Clemans
MuckRock

Re: Public Records Request PR_2022_000100 (Stage 01)

Dear Requester:

Attached is an invoice for costs associated with providing a portion of the documents responsive to your public records request for PR-2019-00813. These costs are allowed by RCW 42.56.070(7)(a).

Please remit payment by check or money order, or call to make an appointment to view these records, by 03/04/2022.  Please also provide a mailing address to which the disk containing the records will be mailed.  There is no cost to view the records in the office. If we do not receive payment or a call for an appointment by 03/04/2022, we will close your request.

You may reach us by email at pubrec@uw.edu or you may call us at 206.543.9180.

Sincerely,

Perry Tapper

UNIVERSITY OF WASHINGTON
Office of Public Records and Open Public Meetings
Mail: Roosevelt Commons-Box 354997, Seattle, WA 98195
Street: 4311 11th Ave NE, #360

From:

Portal Complete With Link










Your FOIA request is closed. Please refer to the determination letter for detailed information on the results of your FOIA Request:
490-2022-000009

"Test"


Open Request (https://test.eeoc.arkcase.com/foia/portal/request-status?requestNumber=490-2022-000009)

Notice of Confidentiality: The information contained in this transmission may contain privileged and confidential information, including information protected by federal and state privacy laws. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution, or duplication of this communication is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact us at ecso@eeoc.gov and destroy all copies of the original message and attachments.





Request Details








Title
490-2022-000009 - Test Description
Type
New Request Queue
Release
Created

Files

pages

Close