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 (Port of Seattle Police Department) • MuckRock

12 Communications
1 File

Communications

From: TimClemans

10/20/2019

Subject: Washington Public Records Act 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 (Port of Seattle Police D

Portal

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: Port of Seattle Police Department

10/21/2019

Subject: Your first record request #19-217 has been opened.

Portal

Port of Seattle Police

************************************************************************

Hi there

Your first Port of Seattle Police record request (request number #19-217) has been submitted.
It is currently unpublished and is not available for the general public to view.

The Port of Seattle has received your request. You will receive a further response within 5 business days. Thank you.

************************************************************************
Questions about your request? Reply to this email or sign in to contact staff at Port of Seattle Police. Technical support: See our <a href='https://www.nextrequest.com/support'>help page</a>

From: Port of Seattle Police Department

10/24/2019

Subject: [External Message Added] Port of Seattle Police public records request #19-217

Portal

Port of Seattle Police

************************************************************************

Hi there

A message was sent to you regarding record request #19-217:

We are in receipt of your request. We will update you on or before November 25, 2019.

From: Port of Seattle Police Department

11/25/2019

Subject: [Document Released to Requester] Port of Seattle Police public records request #19-217

Portal

Port of Seattle Police

************************************************************************

Hi there

Documents have been released for record request #19-217 along with the following message:

Mr. Clemans:

Uploaded you will find the following:

Jaywalking infraction

List of parking tickets

List of traffic infractions

Because you did not clarify what years you have requested for parking tickets and traffic infractions we are providing you a list of 2017, 2018, and 2019 for each (uploaded).

If you can please identify what years you are interested in and/or identify which parking tickets and traffic infractions you are seeking, we can have copies available to you for inspection and copying.

The Port of Seattle wants to ensure we are providing the exact records you want, thus we are attempting to clarify your request in order to meet this objective. With clarification we can focus our search efforts more efficiently.

If you are interested in viewing, inspecting and identifying which records you want, we can propose dates and times for you to do an in-person inspection at our Port of Seattle Police office.

Please note that as per the Port’s fee schedule, the charge for standard black-and-white photocopies is fifteen ($.15) cents per page.

Please note, in order to view uploaded records, you will need to use your NextRequest login ID and password.

Please expect another update and further communication regarding this request on or before January 10, 2020.

Please be advised that the Port’s estimate for a response to your request is based upon the number of requests and volume of records sought in requests that the Port is already processing.

This information is responsive to your request. These documents and/or information are provided to you in accordance with the Public Records Act (Chapter 42.56 RCW). By making Port of Seattle documents available to you, the Port is not responsible for your use of the information nor for any claims or liabilities that may result from your use or further dissemination.

* Jaywalking-REDACTED.pdf

* Parking.pdf

* Traffic Infractions.pdf

From: Port of Seattle Police Department

11/27/2019

Subject: [Document Released to Requester] Port of Seattle Police public records request #19-217

Portal

Port of Seattle Police

************************************************************************

Hi there

A document has been released to you for record request #19-217:

* PDRequestFromPortOfSeattleFor191126.xlsx

PDRequestFromPortOfSeattleFor191126.xlsx
- Download

From: Port of Seattle Police Department

11/27/2019

Subject: [External Message Added] Port of Seattle Police public records request #19-217

Portal

Port of Seattle Police

************************************************************************

Hi there

A message was sent to you regarding record request #19-217:

Because you did not clarify what years you have requested for electronic infraction tickets and traffic infractions we are providing you a list of 2017, 2018, and 2019 for each (uploaded).

If you are interested in viewing, inspecting and identifying which records you want, we can propose dates and times for you to do an in-person inspection at our Port of Seattle Police office.

Please note that as per the Port’s fee schedule, the charge to scan a paper-copy is ten ($.10) cents per page.

Please note, in order to view uploaded records, you will need to use your NextRequest login ID and password.

Please expect another update and further communication regarding this request on or before January 10, 2020.

Please be advised that the Port’s estimate for a response to your request is based upon the number of requests and volume of records sought in requests that the Port is already processing.

From: TimClemans

11/29/2019

Subject: RE: Washington Public Records Act Request #19-217

Portal

I only requested SQL data if you don't have SQL data for a category then just say no responsive records for that category.

From: Port of Seattle Police Department

12/11/2019

Subject: [External Message Added] Port of Seattle Police public records request #19-217

Portal

Port of Seattle Police

************************************************************************

Hi there

A message was sent to you regarding record request #19-217:

Mr. Clemans:

Thank you for your most recent message. Please expect a further response/update on or before January 10, 2020.

Thank you.

From: Port of Seattle Police Department

01/10/2020

Subject: [External Message Added] Port of Seattle Police public records request #19-217

Portal

Port of Seattle Police

************************************************************************

Hi there

A message was sent to you regarding record request #19-217:

Mr. Clemans:

You have requested “all HR, CAD, RMS, IAPro or similar software.” However, software programs leased or owned by the Port of Seattle are not “writings” under the RCW 42.56.010(4), do not “relate to the conduct of government or the performance of any governmental or proprietary function.” RCW 42.56.010(3). As a result, such software programs, if they exist, would not qualify as “public records” under the Act. We therefore consider this portion of your request closed.

You have also requested “Forensics software including tables creating [sic] by the SQL software automatically like table of names and columns.” It is unclear from this description what specific type of record you seek. As indicated above, if you are requesting proprietary software owned, used, or licensed by the Port, such software is not subject to disclosure under the Act.

You have also requested “DEMS, 911 Call/radio recorder, [and] Internet logs.” It is unclear what you intend to identify by these descriptions. For example, the Port does not know what you mean by “DEMS” or “Internet logs.” We invite you to clarify the specific records you seek with these descriptions. Regarding 911 calls and recordings of law enforcement transmissions, if you seek recordings related to specific incidents or call, please identify those incidents so we may review our files to locate any potentially responsive recordings. The proprietary software through which such calls are recorded and stored is not itself a “public record.”

In general, you “demand that data be copied to the CSV format” and identify the specific method and format in which redactions be made. Under the applicable case law, the Port of Seattle is not required to provide response to records requests in a specific format demanded by the requestor. Benton County v. Zink, 191 Wn. App. 269, 281, 361 P.3d 801 (2015) (quoting Mitchell v. Dep’t of Corr., 164 Wn. App. 597, 606, 277 P.3d 670 (2011)), review denied, 185 Wn.2d 1021 (2016); see also Mechling v. City of Monroe, 152 Wash. App. 830, 849, 222 P.3d 808, 817 (2009). Any records will be provided in the format that is reasonable and feasible to do so. See WAC 44-14-05001.

We previously provided records responsive to your request for “Parking Tickets, Driving citations, J-walking or similar citations,” and invited you to clarify whether you were seeking additional records in those categories. You responded to our invitation as follows: “I only requested SQL data if you don’t have SQL data for a category then just say no responsive records for that category.” If you are only seeking SQL data for each of the requests you have made, please consider this our final response: We have no SQL data responsive to any requests you have made.

From: Port of Seattle Police Department

02/11/2020

Subject: [External Message Added] Port of Seattle Police public records request #19-217

Portal

Port of Seattle Police

************************************************************************

Hi there

A message was sent to you regarding record request #19-217:

Hello. We have not received a response from you and we will be closing your request at this time. Thank you.

From: Port of Seattle Police Department

02/11/2020

Subject: Your Port of Seattle Police public records request #19-217 has been closed.

Portal

Port of Seattle Police

************************************************************************

Hi there

Record request #19-217 has been closed.

Files

11/28/2019

PDRequestFromPortOfSeattleFor191126.xlsx
- Download

Tracking #	19-217
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