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

RE: PUBLIC RECORDS REQUEST of 10/21/2019, Reference # P015639-102119

Dear Tim Clemans,

The City of Auburn received your public records request on 10/21/2019, regarding “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/
Your request will be forwarded to the applicable department(s) for response.
You will be notified regarding the status of your request in 5 business days per RCW 42.56.

Thank you for your submission,
City of Auburn
City Clerk’s Office

Re:  Public Records Request concerning PRR P015639-102119

10/25/2019

Tim Clemans

MuckRock News DEPT MR 81928 411A Highland Ave

Somerville MA 02144

RE: PUBLIC RECORDS REQUEST of October 21, 2019, Reference # P015639-102119

Dear Tim:

Pursuant to RCW 42.56.520 and Doe I v. Washington State Patrol, 80 Wn. App. 296 (1996), this letter acknowledges receipt of your public record request addressed to the City of Auburn received by this office on  October 21, 2019.

Please be advised that the City responds to numerous public records requests and estimates the time of response to your specific request to be approximately ten to fifteen business days from the date of this letter. If additional installments are required a time estimate for your whole request will be provided with the City’s next response.

Please note the City of Auburn fee’s for public records below:

Type Fees
Fees for public records – collection

Non-certified photocopies of public records, printed copies of electronic public records when requested by the person requesting records $0.15 per page plus postage

Certified copies of public records $5.00 per document plus copying fees

Scanned public records into an electronic format $0.10 per page

Electronic files or attachments uploaded to email, cloud-based storage service or other means of electronic delivery $0.05 per each 4 electronic files

Transmission of public records in an electronic format $0.10 per gigabyte

Digital Storage Media or Device; Container or Envelope Used to Mail Copies to Requestor, and Postage Actual Cost

City of Auburn Clerk’s OfficeTo view the full details of  this request please log into the
Public Records Center. (https://u4037834.ct.sendgrid.net/wf/click?upn=L5asTq9oAWi6tKrRmhm-2FjWCdZg7I8mHY15IWFaZjK8jKAVgJMGCTKGkOr46jeB5gm6S6wzP3OcOl4F1KYGbvNkyiDd3ZVZSMH46UAQc53do-3D_431l8OAq3CYJAnGLlnECItNQsv8L4PYblLi7Yifh5T-2FRzrcuC4ieULq1M6iGBjqxiYprTPvPQaVzykBAaxnpAOT6ZPr5S4yQZO-2Fq2Xe7Zjx2bKzw1-2BewAnfsz0uCvVWMqjc1h6bN94YscqLLZ7Mxa5f9CS5dY0Eeirgr77wG0vHoSCyvijlP7mO3nLQE9WszOHCW88I2Hv7Z7fT6KXj83zHswnXHIs9H370QHvM6qUYXmq63xOqARaRfQwN-2BRbPm)

--- Please respond above this line ---
RE: PUBLIC RECORDS REQUEST of 10/21/2019, Reference #P015639-102119
Dear Tim,
The City of Auburn received a public records request from you on 10/21/2019. You requested the following:
"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/

This letter is to clarify what information that you are seeking from the City of Auburn. In your request you are seeking "a copy of all" items which are listed below and require clarification.

* HR: What does "HR" mean and what records are you seeking?
* CAD: Are you requesting all CAD documents held by the City?
* RMA: What does "RMS mean? What records are you seeking?
* IAPro: Are you requesting all documents held in IAPro?
* or similar software: Please clarify what documents you are requesting.
* Parking Tickets: Would you like to clarify a date range or location?
* Driving Citations: Would you like to clarify a date range or location?
* J-Walking: J-Walking is not a defined term in City Code. Are you seeking citations under ACC 10.12.290 or a different code provision? Is there a date range you would like records for? or similar citations: Please clarify what documents you are requesting. DEMS: I am not aware of this acronym. Please clarify what DEMS means and what documents your are requesting. Internet Logs: Are you requesting all internet logs for all City Employees, a specific department or division or employee? Would you like to clarify a date range. Forensics Software including table creating by SQL software automatically like table of table name and columns. What document or records are you requesting? Contracts and data dictionaries for each effected vendor. Please clarify what records you are requesting and what affected vendor means. You have not provided a date range for your request. Is there a date range for the records you are seeking? If I do not receive clarification within 15 days (November 20, 2019) I will start on the first installment of your request. The City will require a 10% deposit prior to starting this installment. I anticipate the first installment being parking citations from 2015. These records are in paper format only. There is approximately 4,000 paper citations with 3-5 electronic photos per citation. the fee to scan the parking citations is $0.10 per page and the fee to provide electronic documents is $0.05 per every four attachments. The total cost for the first installment will be $600.00 (4,000 pages at $0.10 per page -  $400.00, 3 photos per citation and the citation is approximately 16,000 documents (16,000 /4 *$.05) -  $200.00) The deposit to start the installment is 10% for a deposit of $60.00. If I do not receive your deposit by November 20, 2019 we will consider your request abandoned and closed. You can pay your deposit at: City of Auburn City Clerk's Office 25 West Main Street Auburn WA, 98001 or by phone at 253-931-3039.
Sincerely,
Shawn Campbell City Clerk City Clerk's Office 253-931-3055
To monitor the progress or update this request please log into the Public Records Center. (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVut1e-2BCDvn2qjt1ziCv4GSJxpjhKJ-2BY1CR44MTCH2ihtlUhvLgNcVS8sSl4L5dD5X8w3KTyOCEKF3Y8kuOutzl84-3D_431l8OAq3CYJAnGLlnECItNQsv8L4PYblLi7Yifh5T-2FRzrcuC4ieULq1M6iGBjqxt21yLmAODtN07BshZPY8Z-2BkcB2mK5zbhfK9IVUsXFX-2FAoWmJTT-2FTmH-2FVTcU544KVccwZucDokjkRhFTnV2q7GhjApwCGAvH1vRES-2FmEPRg-2FL3rc3OCbvx6Pp709uBwKSGpsoQLEkkiGhpJoRwuCAOs09hOoRzoCvH29YWtxrjw5lMnvYvzr8d-2Fw3G3VWT5I5M2YQqgdxzFga0P4xqI-2BHmIBdBXX4U-2FwwWfg8n-2BqhLDmuPigbUezCC4Qo3eOkmpkHNri-2BK-2Bz3RD8bKvQKVAdLVOf4y8j0EPue9MyI0llHTR2OqweNeJReNrxfzgvWBRZUuT5bPq5vYpyS8-2BO4lrnWqA-3D-3D)