|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|
|Submitted||Oct. 20, 2019|
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
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.
To Whom It May Concern:
I wanted to follow up on the following Washington Public Records Act request, copied below, and originally submitted on Oct. 20, 2019. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
Dear Tim Clemans,
Thank you for registering with the Spokane County Public Records Center!
Your Login ID is: firstname.lastname@example.org
If you did not submit your request through the public portal but are receiving this e-mail, an account has been created for you where you can track and monitor the status of your request, and receive any documents in response to your request.
If you have never used this system or cannot remember your password you may request a temporary password here: Request Temporary Password (https://u4037834.ct.sendgrid.net/wf/click?upn=L5asTq9oAWi6tKrRmhm-2FjT2sx38I6vCLDvwFieei90f2Kp4QVbeFk-2F8XzA8UHDtB4QS8NyU68nCfOu-2FJdnh7YVyNR7d3924o2Q8RqGzPUjQ-3D_3cDIljmeGwPYqtzVZfOwcdQWq5jsa8q9zuKReLMOk4SdWGTT43RjMKv48z7Y5Dl117Ve4j4-2BVxiDgvv2v-2FjjACu-2FPw1EOrMQL-2BzHvdxzH-2BKT-2BDQmqFbhWdzDOEfGKF1cGNQJxabfK77-2B3nSOqidK9ZqHE9HW-2FSsqx-2BIMl-2F-2BEnh-2BRa10LwBQBdRZFnedT73WVdiMy-2Bq98bl-2FfPwWj6d8rwvPwG9plfXVuzuSIQd-2BR6Myf0MDZc46uobv7epp7qIBw)
Please login to "My Request Center" to update your account information, track the status of your request and receive requested records when they become available. This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY
Dear Tim Clemans:
Thank you for your interest in public records of Spokane County. Your request has been received and is being processed in accordance with the State of Washington Public Records Act, Chapter 42.56 RCW. Your request was received in this office on 10/25/2019 and given the reference number S001752-102519 for tracking purposes. Records Requested: 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, forensic 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*.
Not all public documents are available in electronic format. If the document(s) requested are not available electronically, we will make them available for inspection or by paper copy in accordance with the Public Records Act, Chapter 42.56 RCW.
Your request will be forwarded to the relevant department(s) to locate the information you seek and to determine the volume and any costs associated with satisfying your request. You will be contacted about the availability and/or provided with copies of the records in question. PLEASE NOTE: The State of Washington Public Records Act, Chapter 42.56 RCW, does not require a governmental body to create new information, to do legal research, or to answer questions.
You can monitor the progress of your request at the link below and you'll receive an email when your request has been completed.
To monitor the progress or update this request please log into the Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukwyHCAc6isYoiayeM9PBgT1i9qggkszLEyGuSe1SVFbraMFP-2FauNG4MAA-2BIbK422vp7ZnBO-2B2pYefQGejq7dx8-3D_3cDIljmeGwPYqtzVZfOwcdQWq5jsa8q9zuKReLMOk4SdWGTT43RjMKv48z7Y5Dl1VkMbyM4gGCQOF-2FPxFY-2FCx4GxZuJTed-2F4jEuQQ9x01JZ2sCC-2BDgEHAM3UD6QkNGSiuZ-2BSYloxabfesxWMVbcrjlyP3xViu-2BvbTArP-2B8PT13CmFhNvLfQUyW3yRHXcp1IOeR21mxMwcUBPkVqqnCI0mul8AGYGrTZ4NrBOjOgjmFw1Q1VV3RZW3J-2Bd8o551VDzEsHhVG4-2BHKFnU-2F45s-2FEGGIZ-2FvJjkfqy64sw1JCxZWy0mHpbTAx6PlzK9ros-2BO9g2RJe9IwLE-2Br1ATKW44kDAXMwLy9Keej2UmdmQDiYzL0YH8UQcffDD1Ejlnj-2Bu5InAoF-2FirC9gF29urOm79633tg-3D-3D)
--- Please respond above this line ---
In accordance with the Public Records Act, RCW 42.56.520, this message acknowledges receipt of your attached public records request, received by the Spokane County Sheriff's Office ("SCSO") on October 21, 2019. This request has been assigned reference No. S001752-102519. Please include this code in any communications concerning this request.
Specifically, you requested:
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, forensic software including tables creating by the SQL software automatically like table of table names and columns.”
Certain portions of your request are not sufficiently clear as to identify specific records. Before staff can reasonably conduct an adequate search for responsive records, we are requesting that you clarify the following eight portions of your request:
1. " A copy of all HR..." is not a specific identifiable record. Please clarify what you mean by "a copy of all HR."
2. Please clarify what you mean by " RMS." I have been advised by the Information Technology (“IT”) department that RMS typically refers to an electronic "records management system." Are you attempting to request a copy of every document in SCSO's electronic Law Enforcement Records Management System (“LERMS”)? Please clarify.
3. Similarly, please clarify your request for " a copy of all ... IAPro or similar software." Are you attempting to request a copy of every document in SCSO's IAPro electronic records management system?
4. With respect to your request for " a copy of all “parking tickets, driving citations, J-walking or similar citations,” please specify a date range under which to search for responsive citations.
5. Additionally, regarding this portion of your request, “ similar citations” is not an identifiable record. Please clarify what you mean by “ similar citations.”
6. Please clarify your request for " a copy of all ... DEMS." Sheriff’s Office staff have advised that DEM typically refers to the “Department of Emergency Management,” which is a division of the Sheriff’s Office. Please confirm if your reference to “DEMS” is meant to refer to “Department of Emergency Management.” If so, “ a copy of all … Department of Emergency Management” is not a request for an identifiable record. Please clarify this portion of your request.
7. With respect to your request for “ a copy of all … internet logs,” please clarify what you mean by “ internet logs.” Are you referring to internet browser history? If so, please specify a date range under which to search for records responsive to this portion of your request.
8. With respect to your reference to “ forensic software including tables creating by the SQL software automatically like table of table names and columns” this portion of your request is not clear to staff. Please clarify the specific identifiable records or document type you are attempting to seek under this portion of your request. Please also provide a date range under which to search for records responsive to this portion of your request.
Please provide the above requested clarifications within 30 days of today’s date, or by November 27, 2019. If no such clarification is received from you by that date, only then will staff move forward with processing your request based upon our current understanding of the records you are attempting to seek.
Additionally, with respect to the portion of your request wherein you reference “911 call/radio recorder,” are you attempting to request copies of 911 calls for service? If so, please be advised that Spokane Regional Emergency Communications (“SREC”) is the custodian of 911 call records in Spokane County. To obtain these records you would need to make a separate request to SREC via the contact information below:
Spokane Regional Emergency Communications
Our procedure is to locate records, review them for exemptions, and then prepare them for your inspection and/or copying. Due to the large volume of records you are seeking, we anticipate needing to process this request in installments.
Based on the current number of open public records requests, as well as staff absences associated with the upcoming holiday season, we reasonably anticipate requiring approximately 60 days from the date clarification is received in order to provide a first installment of responsive records. If no clarification is received by November 27, 2019, then we anticipate providing a first installment, based on our best understanding of your request, on or about January 27, 2020.
If we do not hear from you before that date, then we will follow up with you on or about January 27, 2020, regarding the status of your request. If public records become available in advance of this estimate, we will endeavor to produce them as they become available. Conversely, if staff encounters a need to extend our estimate, we will advise accordingly.
Finally, please be advised that there may be fees associated with the copying of public records. Please take a moment to familiarize yourself with the attached Fee Schedule. If your request requires payment, you will receive an invoice in your email before the records are released.
Public Records Officer
Please do not update subject line above when replying. To monitor the progress or update this request please log into the Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukwyHCAc6isYoiayeM9PBgT1i9qggkszLEyGuSe1SVFbvJYUGpe9dCF7Djl2qv7sE2lp5HZXA2XC0RSAFgS2GPAO8c3eZ6w3Pn8MHRtIzwP9_3cDIljmeGwPYqtzVZfOwcdQWq5jsa8q9zuKReLMOk4SdWGTT43RjMKv48z7Y5Dl1VkMbyM4gGCQOF-2FPxFY-2FCxyrOVlD9rSAGAgXtkNUmC2H0AhPecY4gsk7IFyQZv1PmQEWskzIm0p-2BxnGnXvwTmBwp705UTuYInP-2BJg5feRhgi9Z4YqxYOmLq8NUyibXtqF5mcZXy-2F33OJhQgp9Yd6hDiGzhFlPTQMQyDwhPI8qfqboXSv-2FKApDtW47ZyGC0wJD8OMbD-2F9s3ETOFgAdqfZyMastV5YKJBBxmqSeR-2FpbQJmlu7azlcN6NxrP6CW6glVIemUm1y3awRmBzuaPeOPi6EO0PbbO2nOTIbvcQxSr-2F3YVd2q26JWYW6Lvyc7734MvvE1q1qWcwqpGUJ1WdSKhsQ-3D-3D)
1. All human resource software system's SQL data
2. All data in the LEMS SQL database which contains far more than what gets exported in a PDF
3. All data in the IAPro SQL database which contains far more than what gets exported in a PDF
4. We don't want all date range but all data in the SQL database
6. DEMS is Digital Evidence Management System
7. We have found that agencies have a centralized internet browsing monitoring system
8. We think agencies use forensics software that maintains a SQL database
Hello Tim Clemans,
You have responded to an unresponsive email.
Please be advised that if you wish to submit a public records request, update an existing request, or check the status of an already submitted request, you should visit the Public Records Center.
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.
--- Please respond above this line ---
I’m writing to update you on your public records request assigned reference code S001752-102519. After reviewing the clarifications you provided, my current understanding of your request is that you are attempting to seek all Structured Query Language ("SQL") data from the Spokane County Sheriff's Office's electronic records management system. Based on my current understanding of your request, I conducted a search for responsive records. I have been advised by IT staff that there is no existing record or report that contains all the SQL information you are requesting in the specific manner in which you are asking to have it produced. However, in searching for records responsive to your request, I learned of an existing report that was created as part of the County's Open Data Initiative. This report contains information generated using some of the SQL data from the Sheriff's Office's records management system, and would therefore be partially responsive to this portion of your request. I am producing this in hopes that the information is of use to you. Please find the report attached. Please note that this file contains information from 10/5/2016 (the "go live" date of the RMS) to 11/30/2019.
I also want to make you aware of the Community Crime Map, which is generated using SQL, and therefore may be partially responsive to your request. This is a publicly available resource you can access online via the following link:
With respect to the portion of your request wherein you seek all "SQL" data from Human Resources software, no single report or document currently exists that aggregates this information in that way. Many of the functions of the Human Resources Department occur using paper records, and electronic functions are spread across a number of discrete systems, none of which include a mechanism for generating a single report that would respond to "all SQL data." Accordingly, this portion of your request does not identify a specific existing record.
With respect to the portion of your request wherein you seek all internet browser history data, staff are still in the process of retrieving these records and reviewing them for any exempt information. Based on current workload, i anticipate requiring approximately 30 days, or until January 31, 2020, to provide a next installment containing these records. If records become available in advance of this estimate, I will let you know.
Public Records Officer
Please do not update subject line above when replying. To monitor the progress or update this request please log into the Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukwyHCAc6isYoiayeM9PBgT1i9qggkszLEyGuSe1SVFbvJYUGpe9dCF7Djl2qv7sE2lp5HZXA2XC0RSAFgS2GPAO8c3eZ6w3Pn8MHRtIzwP9_3cDIljmeGwPYqtzVZfOwcdQWq5jsa8q9zuKReLMOk4SdWGTT43RjMKv48z7Y5Dl1VkMbyM4gGCQOF-2FPxFY-2FCx5wIm5ejqZV91cfPnABbiLeUTO6Eciv1szFtWsf92zLzy1oalZNIzlaaO1C4te7v8WepIf5JHj0Drt8uoINpxtTeM2V2kZaZaO2-2BWO35AmpykUKJYLbKek5jNe3G20mH0dtjvwmZAoOuNrPcaEjXJal3po89H0Z75OdKKJGKYE09RiuT4lzbHj-2BEWRraYQCQE0hnaSUDfxPhVs39hTpfxMsQTiSt2C8PxZVswvcbxOQGQ67RzCUXNTex0m9forr2K-2BqrMxci4P2FJ7BfvYFA1fnfNCEjSMKAmuzqGe0-2FieBr9QhHLimqRvZ33a4M7aVZ9NX2Dzj2yg0cKSoMh-2FmdkjE-3D)
--- Please respond above this line ---
I’m writing to update you on your public records request assigned reference code S001752-102519. The next installment of responsive records is now available.
The responsive records are now available for download in the "My Request Center" of the public records portal. Instructions for downloading the files follows:
1. Navigate to the Spokane County Public Records Center by following the blue "Public Records Center" hyperlink contained in the footer of this email.
2. Log in with your user name and password. You will be taken directly into this request.
3. Click on the "Download All" button directly above the blue "Files" box.
*If you have a pop-up blocker, you will need to allow pop-ups for this site in order for the files to download. After they have downloaded, if the files do not open automatically, they will appear in your computer's "Downloads" folder.
We reasonably believe the next installment of records responsive to this request will be available on or about February 7, 2020. If records become available in advance of this estimate, we will let you know. Conversely, if we encounter a need to extend our estimate, we will contact you promptly with a revised estimated completion date.
Public Records Officer
Please do not update subject line above when replying. To monitor the progress or update this request please log into the Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukwyHCAc6isYoiayeM9PBgT1i9qggkszLEyGuSe1SVFbvJYUGpe9dCF7Djl2qv7sE2lp5HZXA2XC0RSAFgS2GPAO8c3eZ6w3Pn8MHRtIzwP9_3cDIljmeGwPYqtzVZfOwcdQWq5jsa8q9zuKReLMOk4SdWGTT43RjMKv48z7Y5Dl1VkMbyM4gGCQOF-2FPxFY-2FCx-2BKoqZeeyafoY1HL88TXl-2F9-2BAw8cxCep0oDlpJUJzJNYMKVILYqN2FOp4433YDSvMWQgfNZ6ZGDjLSljz4yyBHXMMyEwQapf4oHbqpH3T6wCdNBLhHEtO0FDxyGWYJ1odr0PyKYSUOvrkLY4qdBTsWpJzr5phiOZSPGU-2BsNpwfjKl9kMA8gKm5kMoRzRzj7QblLEOJ1PYosJ5Dx1ZQeP1IOZN-2BlkGC37M9kIXwkOnkUuSXigffVo-2FRMrapjQaFr6WiyLhwH02VZkmDzNNGoEXU2i2-2FmgqYRh8d14GUFt9W1iYZK2GwR8NRwBxHXD6BzrQY9hr-2FrJBXvTHGKaOmRoGAs-3D)
--- Please respond above this line ---
I’m writing to update you on your public records request assigned reference code S001752-102519. The final installment of responsive records is now available.
Please find the responsive records attached to this email. The attached report contains statistical analysis of Spokane County Sheriff's Office data that we believe to be responsive to the intent or your request, as we understand it.
Staff have made a diligent effort to locate and produce existing records that we believe to be at least partially responsive to the portions of your request which sought identifiable records. This request is now concluded and closed. If you have questions, please feel free to contact me.
Public Records Officer
Please do not update subject line above when replying. To monitor the progress or update this request please log into the Public Records Center (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVukwyHCAc6isYoiayeM9PBgT1i9qggkszLEyGuSe1SVFbvJYUGpe9dCF7Djl2qv7sE2lp5HZXA2XC0RSAFgS2GPAO8c3eZ6w3Pn8MHRtIzwP9_3cDIljmeGwPYqtzVZfOwcdQWq5jsa8q9zuKReLMOk4SdWGTT43RjMKv48z7Y5Dl1VkMbyM4gGCQOF-2FPxFY-2FCx3JKJUdRn28nLCULfitkmi7abLkjVz9dQjk7CZLQiztDy4Cign1bhfIPcnYNHyx0oXX-2F1RlQ-2B5iAE4tm08KJHGpTGVhB585uKwkqjSJE-2Bh97fRDsv4O22Uf5y9E2zKf6xxg01cMxIKBumKkQe08fvAYIGrCUSEz-2Bi00kTRi5ZQ-2FNsTdzZeNVDaTzkpvGARn2cBiBVcokMctgacbQvnUdZF-2B8xgBZoavtsjARjYQ4-2F4ZL2Bn-2Bo1GEgc9XzM8eHfqY4Z7cOdMLutPwGO7osrS399g9IE58JZI15Wc0q35TokU-2Fl74BaqJSWEfzydOmD8wJiFau-2FksPFyMB6QPF6ulx7Yo-3D)