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 (Seattle Police Department)

TimClemans filed this request with the Seattle Police Department of Seattle, WA.
Tracking #

P049438-102119

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
Due Oct. 25, 2019
Est. Completion None
Status
Awaiting Response

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

Dear Tim Clemans:

Thank you for using the Seattle Police Public Records Request Center.
Your request was received on October 21, 2019 and the reference number is P049438-102119.


Request Summary

Incident Information (if provided):

* Incident Number:
* Incident Date:
* Incident Time:
* Incident Location:
* Investigating Officers: Request Description and Details (as provided):

Overall Description: 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/ PARDON OUR PROGRESS SPD is implementing a new Records Management Sy stem (RMS) to replace the RMS in use for more than a decade. Some request responses may take longer to process while we implement the new system. Thank you for your understanding.

From: Seattle Police Department

10/22/2019

Tim Clemans
requests@muckrock.com

RE:  Public Disclosure Request#: P049438-102119

Dear Tim Clemans,

This communication is in response to your public disclosure request.


The purpose of this correspondence is to provide you a status update.  Your request status is:  Assigned.

If you have any questions, you may send messages using the Police Records Request Center or call the Public Disclosure Desk at 206-684-5481.


Please add seattle@mycusthelp.net to your E-mail contacts/address book to ensure delivery of the record center E-mails to your Inbox.

This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

SPD receives between 6000 and 7000 public records requests annually and is processing between 900 to 1000 open requests at a time. This may result in a slower than anticipated response to your request. Thank you for your patience.

From: Seattle Police Department

10/24/2019

Tim Clemans
requests@muckrock.com

RE:  Public Disclosure Request#: P049438-102119

Dear Tim Clemans,

This communication is in response to your public disclosure request.


The purpose of this correspondence is to provide you a status update.  Your request status is:  Being Researched/Reviewed.

If you have any questions, you may send messages using the Police Records Request Center or call the Public Disclosure Desk at 206-684-5481.


Please add seattle@mycusthelp.net to your E-mail contacts/address book to ensure delivery of the record center E-mails to your Inbox.

This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

SPD receives between 6000 and 7000 public records requests annually and is processing between 900 to 1000 open requests at a time. This may result in a slower than anticipated response to your request. Thank you for your patience.

From: Seattle Police Department

--- Please respond above this line ---

10/24/2019

Tim Clemans
requests@muckrock.com

RE:  Public Disclosure Request#: P049438-102119

Dear Tim Clemans,

This is to update you regarding SPD’s response to your multiple public records requests. You currently have 10 open requests for records, reference numbers: P046786-082719, P046787-082719, P047006-083019, P047071-090319, P047071-090319, P047261-090519, P047262-090519, P049438-102119, P049633-102319, and P049045-101119.

The Washington Public Records Act (PRA) states that agencies shall adopt and enforce reasonable rules and regulations to provide full public access to public records, to protect public records from damage or disorganization, and to prevent excessive interference with other essential functions of the agency, the office of the secretary of the senate, or the office of the chief clerk of the house of representatives. Such rules and regulations shall provide for the fullest assistance to inquirers and the most timely possible action on requests for information. RCW 42.56.100. Consistent with the PRA, the City of Seattle has adopted Multi-Departmental Administrative Rule MDAR 17-0002, Citywide Policy on Processing Public Disclosure Requests: http://clerk.seattle.gov/~scripts/nph-brs.exe?s1=mdar&s3=&s2=&s4=&Sect4=AND&l=200&Sect2=THESON&Sect3=PLURON&Sect5=CFCF1&Sect6=HITOFF&d=CFCF&p=1&u=%2F~public%2Fcfcf1.htm&r=1&f=G

In order to provide fullest assistance to all requesters, to prevent damage to or disorganization of City records or excessive interference with other essential City functions, or to assure that the appropriate amount of City time and resources will be fairly allocated among all requests and requesters, City rules give a Public Disclosure Officer (PDO) the discretion to group multiple requests received from the same requester or similar requests from multiple requesters and to process the requests together as a group. In addition City rules allow a PDO to allocate specific amounts of time and resources to responding to a request, whether individual or grouped, and/or to a particular requester. This may include, but is not limited to allocating a specific number of hours per week or month to be spent by PDO staff and/or employees for whom responding to records requests is not among their primary assigned duties.

SPD will group and process your requests as follows:

1. P047107-090319
2. P046786-082719
3. P046787-082719
4. P047006-083019
5. P047071-090319
6. P047261-090519
7. P047262-090519
8. P049438-102119
9. P049633-102319
10. P049045-101119

If you submit additional requests, we will group them with any remaining open requests and handle them as a single request as well.

At this time, we estimate that we will provide the first installment of records to P047107-090319 on or about 11/22/19. All other grouped PDRs will be pushed out until 12/31/19. We will update each grouped PDR due date as we begin processing it. The City may revise its estimate upon further review or changed circumstances.

Please note if an installment is not picked up within 30 days, the Department will consider all of the requests in the group abandoned and will close the request.

If you have any questions, you may send a message using the Police Records Request Center or call the Public Disclosure Desk at 206-684-5481.

Sincerely,
Tara Collings
Seattle Police Department
Public Disclosure Unit



SPD receives between 6000 and 7000 public records requests annually and is processing between 900 to 1000 open requests at a time. This may result in a slower than anticipated response to your request. Thank you for your patience.

As a reminder you can login at the Police Records Request Center where you can access Police online information, manage your profile, submit record requests, track your request status, receive and send messages, make payments, view frequently asked questions, and download your records. (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FNzSBb89hrFa60YkSOiGQewSoZPqs51S1ZOJR6HvtJY31HMPbZATRtDiaIWA9s7uBp12hY87-2FeDD2Qt7d9tLwRrU-3D_TO1Q8Wnf-2FSd3Ay3PHR-2BBX9Wg78-2F0f71jqxSGNS-2BqNiwZQuNN99KdnBoHPNd-2BtrVEJQZ-2BSIdf6WPKjXLiEivYxl8dhztuafVa7inm-2FRPHf-2FIbSkGMNWYOUBh7vT2AyMfU5HsmFE4QYdinQ30FiYtIBdWS-2BF0fYQD6WOZm5JlCNrPB-2F25-2FqJKQsBqCKO8vOBnBiHa8j2DgupLrcvt7bKkLuaBWFB3TGOo0OGpWPNZPCTWHyxyDOkV7q7cdXTL4aMuVnGF47Xnkh9Nae-2FRLzyC4g7sncfzeZxzPtISp6mKQzIctmjNN-2BnTmPGorNP-2BFfQG-2B1WyZdSYnmqHR4E1yMCG6R7Xs4CFujqpusgNVQZf48HcOp74kE935IQ5t7BzjdZxZQe6qGM8w9dJmYulxR5ka7A-3D-3D) Please add seattle@mycusthelp.net to your E-mail contacts/address book to ensure delivery of the record center E-mails to your Inbox.

Files

There are no files associated with this request.