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

TimClemans filed this request with the Spokane Police Department of Spokane, 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
Status
Completed

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

Tim Clemans

Thank you for your interest in public records of the City of Spokane.  Your request has been received and is being processed.  Your request was received in this office on October 31, 2019 and given the reference number P004475-103119 for tracking purposes.
Date/Date Range Start:
Date Range End:
Description of 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

Your request will be forwarded to the relevant City department(s) to locate the records you seek and to determine the volume and any costs associated with satisfying your request.  You will be contacted about the availability of the records in question.
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 Spokane Records Center.
City of Spokane

From: Spokane Police Department

Please DO NOT REPLY to this email . This is an auto-generated email and has originated from an unmonitored email account. You have a new message available through the Spokane Public Records Center. This is a system-generated email notification. Please log in to the Spokane Public Records Center to view and reply to this message. Please DO NOT REPLY to this email.
Mr. Clemans:

This is to acknowledge receipt of your October 31, 2019, Public Records Request which has been assigned PRR Tracking No. P004475-103119.

Your request states the following:

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.Upon initial review, included as part of your request for records, you make a number of directives and statements.   In the beginning portion of your request, you state:

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.
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.

We are unclear as to the tone, intent, and/or purpose of the above statement.  We, therefore, request that any communications concerning your public records requests be in writing via your “My Records Center Account” on the City’s online public records request portal (GovQA) or send to clerks@spokanecity.org or mailed to the Office of the City Clerk, 808 W. Spokane Falls Blvd, Spokane, WA 99201-3342.

City staff are still in the process of reviewing your request and determining what records, if any, may be located in response to your request.  We anticipate requiring approximately 30 days, or until on or about December 10, 2019, to follow up with you as to the status of your request.  If records, if any, become available sooner, we will let you know. Likewise, if additional time is needed to provide a further response to your request, we will advise accordingly.  We anticipate making records available, if any, in installments.  If clarification of your request is needed as we proceed, we will let you know.

Sincerely,

Terri Pfister
City Clerk

To monitor the progress or update this request please log into the Spokane Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukLZ3O7-2FSQtDe1w-2F-2FCaYfD2kzOW4Yk4nqEXhNkmDfH-2FfKGCKBMjgP8O1Y3EoAtrr-2FHwCzIqofI57wsjoSFdavVLU-2FQXB1-2FVIT2m2byUG4lUIUqmDbIkGcFAitVcZpz4EW-2BbdRoVAW7jWRVioavCI5WA-3D_ZWMigRLu8-2F2EdbbA94uYA1MUEuxeW0UdhoF4YcGx67ZyfwT0rc9-2BI1gmfbr92u3T0-2FESa7gnftBbMfLuKDiNWQgVCUZZ2h9GTG7oJiLRR-2FAqnp7cEFaPmeHlud-2F1KhnMqQ-2FhWHUkq-2FGmX7BYm-2FRw4Q-2FSAShFfzaAdaEUKZBtMkq20hUzIhn9zdx2pJL6OfUZq0PsDFu55EQiukVRJhLgMvLc1lsZNdr8luVj7XPIKpS48XWB1LHiaOln4NL-2FsryEB9yE7L9XeokvhaR2uuIyfwrOj111Gtl4lvypqayuJUsYTU0we152VkgnJxYvct0KakVtb4mlmBWomZtuKWpLtYDzrXLf-2BAXSAZUuuovGCRlB7iu7Hwh02aPrMN96YCJRcL1XvjYRXd3G1gY5ZLQhqw-3D-3D)

From: Spokane Police Department

--- Please respond above this line ---

Mr. Clemans:
This is a follow up to my November 7, 2019, message to you pertaining to your public records request assigned PRR tracking No. P004475-103119.   City staff are still in the process of reviewing your request and preparing a follow up response.  Due to other workload and staff schedules, I was unable to complete a comprehensive response by today's date.  I anticipate providing you an update on your request by on or about this Friday, December 13, 2019.
Sincerely,
Terri Pfister
City Clerk
To monitor the progress or update this request please log into the Spokane Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukLZ3O7-2FSQtDe1w-2F-2FCaYfD2kzOW4Yk4nqEXhNkmDfH-2FfKGCKBMjgP8O1Y3EoAtrr-2FHwCzIqofI57wsjoSFdavVLU-2FQXB1-2FVIT2m2byUG4lUIUqmDbIkGcFAitVcZpz4EW-2BbdRoVAW7jWRVioavCI5WA-3D_ZWMigRLu8-2F2EdbbA94uYA1MUEuxeW0UdhoF4YcGx67ZyfwT0rc9-2BI1gmfbr92u3T0-2FESa7gnftBbMfLuKDiNWQKUZmKu3blKdP7zoUe-2FuRJMorgO7pHCDI42Lcmgn-2Bnk40XPVXTHISTc7Mqn-2F2DXdpxiUngn0OyVF68Da6G-2Bm2GrNTbDCj2-2BfvwzACRFQmaFhioec2Sm1m3l11wr-2BjHu0C7QMvWDx9aOg4mOeUuPhi9EtDvInfoJaeJfnJUMdpiyhbT-2FXSJv1p-2F4I6QH06LUdJlmzdzR4F6603a1ZjtJ140YCgtoq86yWUegOEGApA1-2FVViIL9JE47-2FLiDndbjsAjzmooGGFHUlo8PcVWC6jukApBE7sFgZYZgJ0nVWaO248Ru5CKLAQ0aBYxa0-2FeWTazg-3D-3D)

From: Spokane Police Department

--- Please respond above this line ---
This is an auto-generated email. PLEASE DO NOT REPLY to this email. A new message has been added to a public records request submitted by you. If you wish to submit a response, update the request, check the status, or submit a new public records request, please do so through your "My Request Center" account on the City's public records request center. (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukLZ3O7-2FSQtDe1w-2F-2FCaYfD2kzOW4Yk4nqEXhNkmDfH-2FfG8xvs8dxmUevyfB8cl8GxVizfjAA-2Fl0Dhhj-2FHtrJp-2Fc-3D_ZWMigRLu8-2F2EdbbA94uYA1MUEuxeW0UdhoF4YcGx67ZyfwT0rc9-2BI1gmfbr92u3T0-2FESa7gnftBbMfLuKDiNWZEmwC1FmzvTchQGnCBVstxTaUhqQCZCU-2BazPrO9iZsZoHtg0rwZjtJv5B-2FgS-2BmGDQGjPUM1W-2B17sa1hJg2vUTlHqGdhq-2B0Stp4xNlrHA-2BxP2Bfu71Rj4-2By08ezeP3zmmjv33LKWJ8kPkSJcrwimX3gHSbCpkERvfCwQUO4Fp3Ipcuj2N56mLSrLwuHVhOzdkEWbTXwhgGNje3PRpF-2BeLzHs5Vf9Ur0JV7NRoe1alzz7HYVscw6NlKSMQtcqPy-2BxRatV2LPQeGQFXitlZvvImk9VJHiiUWI7Of1sRmCWfzUbI7mCETHrhYvnaxnvsdE7UQ-3D-3D)
Mr. Clemans:
This is a follow up to my December 10, 2019, email to you pertaining to your public records request assigned PRR tracking No. P004475-103119.  I regret I was unable to complete a response to you today as initially anticipated.  Due to staff schedules and other workload, I anticipate requiring an additional few days, or until on or about December 18, 2019.  If I am able to respond to you sooner, I will let you know.
Sincerely,
Terri Pfister
City Clerk
To monitor the progress or update this request please log into the Spokane Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukLZ3O7-2FSQtDe1w-2F-2FCaYfD2kzOW4Yk4nqEXhNkmDfH-2FfKGCKBMjgP8O1Y3EoAtrr-2FHwCzIqofI57wsjoSFdavVLU-2FQXB1-2FVIT2m2byUG4lUIUqmDbIkGcFAitVcZpz4EW-2BbdRoVAW7jWRVioavCI5WA-3D_ZWMigRLu8-2F2EdbbA94uYA1MUEuxeW0UdhoF4YcGx67ZyfwT0rc9-2BI1gmfbr92u3T0-2FESa7gnftBbMfLuKDiNWZEmwC1FmzvTchQGnCBVstxTaUhqQCZCU-2BazPrO9iZsZoHtg0rwZjtJv5B-2FgS-2BmGDQGjPUM1W-2B17sa1hJg2vUTlHqGdhq-2B0Stp4xNlrHA-2BxP2Bfu71Rj4-2By08ezeP3zmmjv33LKWJ8kPkSJcrwimX3gHSbCpkERvfCwQUO4Fp3IpBadIEQS3p25NhCT3v8rMk8cwGcouf5Z0ANyB8UK-2F50mA1wgj8GtHKV2WPjgSciJfE3yVIGT0h7dYMEqtnTL78d7a9lPDNrrEQci2pGyiJQpiRDng9tUdG1J4ple7rq2nXjYJjCYjkPO77yDNTOyB5w-3D-3D)

From: Spokane Police Department

--- Please respond above this line ---
This is an auto-generated email. PLEASE DO NOT REPLY to this email. A new message has been added to a public records request submitted by you. If you wish to submit a response, update the request, check the status, or submit a new public records request, please do so through your "My Request Center" account on the City's public records request center. (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukLZ3O7-2FSQtDe1w-2F-2FCaYfD2kzOW4Yk4nqEXhNkmDfH-2FfG8xvs8dxmUevyfB8cl8GxVizfjAA-2Fl0Dhhj-2FHtrJp-2Fc-3D_ZWMigRLu8-2F2EdbbA94uYA1MUEuxeW0UdhoF4YcGx67ZyfwT0rc9-2BI1gmfbr92u3T0-2FESa7gnftBbMfLuKDiNWZG35Fug1P4sLu8wR2m02H5zMULe6x-2BbPzpxUyU8-2BXElYKadeu1Tx6xBmA0Le3Wvocqm6iOY0DTjPGLCqej704PNLZ4L5tiYgiGL2ndPxqZUuazL5l2rFq4gSYeFa4q81pRQgj0A-2BFmvfqiaI9i56zKlkDTqeZ-2F2yaTLP0t6xpn7NMiotRnnRpbeLKWSWfMcRG2DFtVcEaz6Tv44W4vNIYk2OqK6U-2BJ5-2B1iY5uaO936pc-2FKTQzb2kHenK8sDvtnYtNbo4dE1UCvbp5V1216tPPgL8PewI44afvVdhyDgGFZHHnSQ7pygDlmEzzxP5K7RGPn-2FLRikIdw-2BHDiITzs8vas-3D)
Mr. Clemans:

This is a follow up on your public records request assigned public records request tracking No. P004244-101619.  Additionally, below is a follow up to my December 10, 2019, response to you regarding your public records request assigned PRR tracking No. P004475-103119.
P004244-101619
This is to advise you that some records responsive to your request are immediately available – specifically the portion of your request for the following:
“..export of data from RMS database: case number, investigation status & another: case numbers not associated with a residence and no mention of residence/home in narrative.”

City police staff have developed datasets for the City’s Open Data initiative that include crime data from police reports and call for service data (911 calls and officer self-initiated calls). The data is generalized to the hundred block for standard police reports (ex: burglary, vehicle theft) and omitted for more sensitive calls (ex: domestic violence) in order to protect victim privacy. This data is freely available for the period of October 5, 2016, through the present. (October 5, 2016, is the date the Police Department went live on a new police records system.)  You may access the data by visiting the following link: http://communitycrimemap.com/?address=Spokane,WA&zoom=11. (https://u8387778.ct.sendgrid.net/wf/click?upn=5gBdU487HLOhhS0-2BT6GwbYPEVeVpvAy5Dy88wdXCwRh3DkyTWwK6S4HwWcXjZLEG2Ta3VFciw2mkahkJ-2FBJ-2FIwP7ZiWf7Yq3P8TAtwrvQMo-3D_ZWMigRLu8-2F2EdbbA94uYA1MUEuxeW0UdhoF4YcGx67ZyfwT0rc9-2BI1gmfbr92u3T0-2FESa7gnftBbMfLuKDiNWZG35Fug1P4sLu8wR2m02H5zMULe6x-2BbPzpxUyU8-2BXElYKadeu1Tx6xBmA0Le3Wvocqm6iOY0DTjPGLCqej704PNLZ4L5tiYgiGL2ndPxqZUuazL5l2rFq4gSYeFa4q81pRQgj0A-2BFmvfqiaI9i56zKlkDTqeZ-2F2yaTLP0t6xpn71Je1IvF6qdRy9wEYFEBaORvjbIVDOqHul6a37GB3Mup-2FD8KJ1ck5-2B9nLceiLDzgFjbz5QXqsnGf2vMc1OSuAnwpBjifm0-2FFAV4E-2FBhdh4zctnOdnarVQDaoY4zoa4zrAj5rI-2BSI12ihHEDc4OxN8C0VhVT-2BdTwxI2PVmcL2NkI4-3D)

Please advise whether the available data on the City’s website sufficiently addresses this portion of your request?  If not, please clarify what identifiable records you are seeking with respect to this portion of your request.

City staff are continuing to work on your request assigned P004244-101619.  An email search and review is underway on this request.  The parameters being utilized for the email search portion of your request (internal emails only; not emails sent to you) are, as follows:

Time frame:  April 1, 2018 to October 16, 2019
Search Term:  “Clemans”

Please advise at your earliest opportunity, but no later than December 27, 2019, if you have any clarifications to provide in the parameters utilized for the email search.

Some clarification for a portion of your request is required in order to enable City staff to proceed with an adequate search for responsive records, if any to your request.  Your request assigned P004244-101619 states, in part, the following: “I records request the complete evidence created log for all time.” What is an “evidence created log for all time”?  Please explain and clarify where you would expect us to find such a log.

We anticipate a next installment of responsive records will be available for release in approximately 30 days, or by on or about January 21, 2020.
P004475-103119
Upon review, your request as phrased is unclear, and we are unable to determine the specific identifiable public records you are attempting to seek, nor are we clear as to the time frame under which you would like City staff to perform a search for such records, if any, to your request (once clarification is received).

Your request states, in part, the following:
“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."

With respect to “…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,” are you attempting to seek copies of the software itself?  In addition, I have the following requests for clarification:
What do you mean be “all”?  Please be advised that, under RCW 42.56.080, “A request for all or substantially all records prepared, owned, used or retained by an agency is not a valid request for identifiable records…”  As noted under WAC 44-14-04002, “It benefits both the requestor and the agency when the request includes terms that that are for identifiable records actually sought by the requestor, and which produce meaningful search results by the agency.” As it pertains to any records you are attempting to seek in reference to “RMS,” does the provided link to crime data above sufficiently address this portion of your request? What do you mean by “similar software” in relation to this portion of your request? What is DEMS or what do you mean by DEMS? City staff are not familiar with this abbreviation and have no knowledge of what it means or what it is referring to. When stating “Parking tickets, Driving citations, J-walking or similar citations,” are you attempting to seek systems software where these records may be maintained or are you attempting to seek actual copies of parking tickets, driving citations, and j-walking citations?  If the latter, for which individual(s) are you attempting to seek such records and under what time frame would you like City staff to perform a search for any such records?  When you state “similar citations,” what do you mean or what are you referring to? When you state “911 Call/radio recorder,” what 911 Call/radio recorder do you mean or are you referring to?  Are you attempting to request copies of 911 calls for service?  If so, the City does not maintain such records, rather Spokane Regional Emergency Communications (SREC) is the custodian of 911 call records in Spokane County.  For information on making a public records request to SREC, visit the following link: https://srec911.org/. (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVus33iMtsaKQLjzxIgL-2Fwybc-3D_ZWMigRLu8-2F2EdbbA94uYA1MUEuxeW0UdhoF4YcGx67ZyfwT0rc9-2BI1gmfbr92u3T0-2FESa7gnftBbMfLuKDiNWZG35Fug1P4sLu8wR2m02H5zMULe6x-2BbPzpxUyU8-2BXElYKadeu1Tx6xBmA0Le3Wvocqm6iOY0DTjPGLCqej704PNLZ4L5tiYgiGL2ndPxqZUuazL5l2rFq4gSYeFa4q81pRQgj0A-2BFmvfqiaI9i56zKlkDTqeZ-2F2yaTLP0t6xpn7NQNX5E-2BGayBOnjwLViotYbPzZZqEyPNDiEVuelEEr1m6r6lPAhD7SJKYCDW624-2BLlMxeC6OTwssXkkwiQw8zWf3O-2FxWaTzgtaMdEpVOLJ2oeamzgzZIUShdUy5UuR7-2Bxz81A0IsQUm0LRL4kQK8y2Zb5aQQOW1VHB6p4C9GoBTs-3D) When you state “Internet logs,” are you attempting to seek internet logs for all employees or employees of a specific department or for a specific individual? What is the time frame under which you would like the City to perform a search? When you state “Forensics software including tables creating by the SQL software automatically like table of table names and columns,” what forensics software do you mean or are you referring to and/or what forensics software records are you specifically attempting to seek and under what time frame?

In another portion of your request, you state the following:
“I records request the contracts and data dictionaries for each affected vendor.”

We are unclear as to what specific contracts and/or what identifiable public records you are attempting to seek under this portion of your request. What contracts are you referring to or do you mean?  By “data dictionaries for each affected vendor,” what affected vendor do you mean or are you referring to and what data dictionaries do you mean and are you referring to?

You further request the following:
“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.”

This portion of your request appears to be phrased in the form of a request for information rather than a request for identifiable public records. Are you requesting the City to create a list of each sql server it uses and the name of each sql access tool owned by the agency or the agency’s IT provider?  Please clarify.  If so, the City is under no obligation to create a document where none currently exists, nor does the City have the resources to perform the research required to create such a list.  Even if the City did possess such a list, certain information regarding digital systems is classified as critical infrastructure and would be exempt from release pursuant to RCW 42.56.420 (Security).

The remainder of your request appears to be a series of statements and/or demands, for which no further response will be forthcoming.  If you feel we have misunderstood and/or overlooked anything in our review of your request at this time, please advise and clarify with as much specificity and clarity as you can as to the specific identifiable public records you are attempting to seek, including the time frame under which you would like City staff to perform a search for such records (if any).  A sufficient description of the identifiable public records you are attempting to seek, including a time frame under which you would like City staff to perform a search for such records, will be required in order to enable City staff to proceed with an adequate search for responsive records, if any, to your request.

Please provide the requested clarifications above within 30 days of today’s date, or by January 21, 2020.  If no such clarifications, as sought above, are received by January 21, we will consider those portions of your request abandoned and closed, and a new request for the records you seek will be required after that date.

Pending any clarifications received from you, our best estimate of when a first installment could be made available is approximately 90 days from the date your clarification is received.  Should additional time be needed, we will advise accordingly.

Sincerely,

Terri Pfister
City Clerk

To monitor the progress or update this request please log into the Spokane Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukLZ3O7-2FSQtDe1w-2F-2FCaYfD2kzOW4Yk4nqEXhNkmDfH-2FfKGCKBMjgP8O1Y3EoAtrr-2FHwCzIqofI57wsjoSFdavVLU-2FQXB1-2FVIT2m2byUG4lUIUqmDbIkGcFAitVcZpz4EW-2BbdRoVAW7jWRVioavCI5WA-3D_ZWMigRLu8-2F2EdbbA94uYA1MUEuxeW0UdhoF4YcGx67ZyfwT0rc9-2BI1gmfbr92u3T0-2FESa7gnftBbMfLuKDiNWZG35Fug1P4sLu8wR2m02H5zMULe6x-2BbPzpxUyU8-2BXElYKadeu1Tx6xBmA0Le3Wvocqm6iOY0DTjPGLCqej704PNLZ4L5tiYgiGL2ndPxqZUuazL5l2rFq4gSYeFa4q81pRQgj0A-2BFmvfqiaI9i56zKlkDTqeZ-2F2yaTLP0t6xpn766nP208RXHRkSkTRqs0W9yzwyGcsdml8u8dUZFbxCh075Q-2Fz5noIhYoaY7DHXi4BkSqvjtwzJhvXoDoZVqBYmFiHFlf5jbROmn0blmBpW5snMk0AAhgGXrLSBnwbrhNTSGAFgJKrY1533k5-2BCU9NFoKeVw-2B-2FVCGgh3bPUT3-2F6EQ-3D)

From: Spokane Police Department

Mr. Clemans:

This is a follow up to my previous correspondence sent to you via the GovQA portal. My last correspondence, dated December 13, 2019 (utilizing the email address in the GovQA portal of tim@investigatesafety.com<mailto:tim@investigatesafety.com>) bounced back and we received an undeliverable message.

Your request states the following:

record showing price paid for Case Guard for use by public records unit to redact video and audio

I am advised by SPD staff that Spokane County has the primary contract with Case Guard, with the City of Spokane being a user. If you have already, you may wish to make a separate request of the County to determine what, if any, responsive records that agency may hold. The contact information for making a request of Spokane County is as follows:
Tony Dinaro, Public Records Officer
Spokane County
1116 W. Broadway Avenue
Spokane, WA 99260
(509) 477-2287
spocoprr@spokanecounty.org<mailto:spocoprr@spokanecounty.org>

In addition, information on how to submit a public records request to Spokane County can be located at the following link on the Spokane County website: http://www.spokanecounty.org/2254/Public-Record-Requests.

In case it is of any help or interest to you, attached is an invoice located by SPD which shows payment for services for transcription equipment.

I am in the process of checking with staff from the City's Accounting Department regarding any potential responsive records. I anticipate following up with you in approximately 21 days, on or about February 3, regarding the status of your request. If I am able to follow up with you sooner, I will let you know.

Sincerely,

Laurie Farnsworth
Spokane Deputy City Clerk

[City Logo 2 color.jpg]
Laurie Farnsworth | City of Spokane | Deputy City Clerk

From: Spokane Police Department

--- Please respond above this line ---
This is an auto-generated email. PLEASE DO NOT REPLY to this email. A new message has been added to a public records request submitted by you. If you wish to submit a response, update the request, check the status, or submit a new public records request, please do so through your "My Request Center" account on the City's public records request center. (https://u8387778.ct.sendgrid.net/ls/click?upn=6HtRfOYLt5fXvpttM-2FU1HSVD4CrS9uFW2stupoI-2F3P-2FCR9v4w4dDGSabyWOuZGyK73EIPwhayp6yerTiw-2FMwyAatRlrvnO7ENj4b1rLl3GE-3DN1A2_CQ-2BXuev0gvcjmxr4emnL7l-2F6Hwmhpk3PVtM7pPnHCSSFJKug4qkftA3bfExc1yilZFgO-2FK-2BKuarkrBsviBaN39W3x-2FrKtoFMy3NjelnEwBsTJc8crs4hLZ8iLEWBnI9FXKUzXp1JYoh6WLh7DC1WFt55hehCTDPPcKdTPaMnQqdxHVeJNO4c0zeLdapUBKu59fH5NsBT0uzryAWgBmD2C0tBBcFH9Oc-2F7dR5VgIFUvDd7g-2Bak8KvZDerC-2FIWMfSkqH298c1EVZScnqa4eA24gvg-2FZzzsFfWz-2F5K25VIZ-2FYmEdHfg-2FL4pZPnsQR3wMhIW5iodmVrPUJ-2BijpNXfMmQuQJuxP4qQtJuTZ4D9quEXtY-2FFlke-2FB2eprT-2B6ugQawC4GCIfHx50aKpdao0PF3IQYe6Fxvw7UIw0U70J7Cdt9f4-3D)
Mr. Clemans:

This is a follow up to my December 19, 2019, communication to you pertaining to your two public records requests assigned P004244-101619 and P004475-103119.
P004244-101619
This is to advise that a second (and final) installment of responsive records pertaining to your request assigned P004244-101619 is available for your review by accessing your “My Request Center Account” on the City’s public records request portal (GovQA).  This installment consists of emails located in response to your request.  Under my December 19 communication, I requested that any clarifications to the proposed parameters for the email search, as outlined in my December 19 communication, be provided by December 27, 2019. Deputy City Clerk Laurie Farnsworth, under her October 23, 2019, response to you also requested clarification as to the time frame under which you would like to have an email search and review performed.  No such clarifications were received from you. The parameters utilized for the email search were, as follows:

Time frame: April 1, 2018 to October 16, 2019
Search Term: “Clemans”

As noted above, the emails located in response to your request are available for your review by accessing your GovQA account. We note your email account of tim@investigatesafety.com (Time the PDR Terrorist) bounced and this is the email address utilized for the public records request assigned P004244-101619.  In case it may be helpful or of assistance to you, we are making the emails available for review under both of your requests – P004244-101619 and P004475-103119.  The email address associated with your request assigned P004475-103119 is requests@muckrock.com.  If you have any issues with accessing the emails via your account(s), please advise.

As it pertains to remaining portions of your request assigned P004244-101619, no clarifications from you have been received as requested under my December 19 response to you.  Section 6.1.3 of the City’s Public Record Requests Policy and Procedure states the following:
If the requestor does not provide clarification in response to a request by the Public Records Officer for clarification, within thirty (30) days of the clarification request having been made, the City will consider the request abandoned as to those portions for which clarification was requested but not received, and advise the requestor in writing that the request has been closed as to those portions.  Should the requestor, after such closure, provide clarification, his or her clarified request shall be considered a new request and shall be processed as such, and other public records requests can be processed ahead of such a clarified request.

Therefore, the remaining portions of your request are considered abandoned, and this completes and concludes our response to your public records request assigned P004244-101619 in its entirety.  If you feel we have overlooked anything in responding to your request or if we may be of additional assistance, please advise.
P004475-103119
Under my December 19, 2019, response to you, I made available to you an installment of records by providing a link to crime data available on the City’s website.  Also, under my December 19 response to you, I requested that any clarifications of your request be provided by January 21, 2020.  Section 6.1.3 of the City’s Public Record Requests Policy and Procedure, as also indicated above, states the following:
If the requestor does not provide clarification in response to a request by the Public Records Officer for clarification, within thirty (30) days of the clarification request having been made, the City will consider the request abandoned as to those portions for which clarification was requested but not received, and advise the requestor in writing that the request has been closed as to those portions.  Should the requestor, after such closure, provide clarification, his or her clarified request shall be considered a new request and shall be processed as such, and other public records requests can be processed ahead of such a clarified request.

As no such clarifications as requested have been received from you by the specified date (January 21, 2020), we are considering the remaining portions of your public records request abandoned, and this completes and concludes our response to your public records request assigned P004475-103119 in its entirety.  If you feel we have overlooked anything in responding to your request or if we may be of additional assistance, please advise.

Sincerely,
Terri L. Pfister
City Clerk

To monitor the progress or update this request please log into the Spokane Public Records Center (https://u8387778.ct.sendgrid.net/ls/click?upn=6HtRfOYLt5fXvpttM-2FU1HSVD4CrS9uFW2stupoI-2F3P-2FCR9v4w4dDGSabyWOuZGyKOxaNTcvv-2F4ALTGWf3-2FBgaPBaVltIhzYDixXBSmQVPYTWRSiRzPOiu0McWgcBeQApYBeCBS2GfTD6YowK-2BsZfjBrUon86js-2BmuFgY6bJPu-2FM-3DWC1w_CQ-2BXuev0gvcjmxr4emnL7l-2F6Hwmhpk3PVtM7pPnHCSSFJKug4qkftA3bfExc1yilZFgO-2FK-2BKuarkrBsviBaN39W3x-2FrKtoFMy3NjelnEwBsTJc8crs4hLZ8iLEWBnI9FXKUzXp1JYoh6WLh7DC1WFt55hehCTDPPcKdTPaMnQqdxHVeJNO4c0zeLdapUBKu59fH5NsBT0uzryAWgBmD2C0tBBcFH9Oc-2F7dR5VgIFUvDd7g-2Bak8KvZDerC-2FIWMfSkCey-2Fu37nFJXz5jepeAoIJ4AHa6F3t4sFIBVye-2Fh2rdcCdD2j0xEWDEVnpzR4moAwNlPu7fF8otFTkYLu33sNuaVxcOy2oC04M5BJRUlx9ZWAzgsmnwVsYl9zwTZyGfA6iLNXqK8bq3eVTZnbTkXL7xCahSdAM-2F1DNzwOogYo3vo-3D)

From: Spokane Police Department

Mr. Clemans:

This is a follow up to my below January 13 email to you and is to advise that no additional responsive records for your PRR No. P004224-101519 have been located as staff understands it.

If you feel we have overlooked anything in responding to your request, or, if you have personal knowledge of any responsive records in the City's possession that have not yet been made available to you, please clarify your request by clearly describing what the identifiable public records are, if any, that you may still be attempting to seek, and we will be glad to look into your request further.

Please provide any such clarification within 30 days of today's date, or by March 4. If no clarification is received from you by that date, your request will be considered concluded and closed, and a new request will be required in this matter after March 4.

Sincerely,

Laurie Farnsworth
Spokane Deputy City Clerk

[City Logo 2 color.jpg]
Laurie Farnsworth | City of Spokane | Deputy City Clerk

Files

pages

Close