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 (Valley Communications Center)
| Submitted | Oct. 20, 2019 |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
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: Valley Communications Center
--- Please respond above this line ---
Dear Tim Clemans,
Thank you for your interest in public records of Valley Communications Center. Â Your request has been received and is being processed. Â Your request was received in this office on October 21, 2019Â and given the reference number V016553-102119Â for tracking purposes. See Attached Email Your request will be forwarded to the relevant Valley Communications Center 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.
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 Public Records Center.
To monitor the progress or update this request please log into the Public Records Center. (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN4KAST8ESiRJTswcAuDcm7RRRzVbmkopVnMc2k8K2-2FnhpFky10jviRW-2FZwjc7y-2Bi9qCWNRa19GeCSmvkfGp38TUHb3-2FOS7cCMTTAOZREe-2FJe_wR3j6vFOHPjXR7dao08kLjuB48xpIRRyTdZLgzfmq3m-2BPuexmo-2BwU1gittd-2FRMhKWxUY9V0RP0CJLj95L8-2B-2FLzRHQu5xDfPBH2U83vklRl-2BeTOgDliej6xYf3-2F30IhTSxHh3QxW80df6DZr8v39h-2BigEPnqKrCR4jp7sYQ2slCDkE-2FLZKF5-2F1T-2Fa6oPtj-2FrR2BRtND0YnWb4axJeczGeEDCUYVAfa-2BJfmXk3hXWp6SQKOijmpRDeVkmQ742tjKRZjtBqtPYDwGhjAsVuJrhQsR9wN6Jgw36n-2Fqo-2Fw9cUnkcYaN9XeLkOGLvH1sjDPgRAN0M1ofuDplbU0bVgJccISP7rrEwOaKG8UsxmId4AVXJMU4FHX7EJ53xlBMetgEDrQOKfjQYl-2BY7KeqZPA6ZcUg-3D-3D)
From: Valley Communications Center
--- Please respond above this line ---
RE: PUBLIC RECORDS REQUEST of October 21, 2019., Reference # V016553-102119.
Dear Tim Clemans,
Valley Communications Center received a public information request from you on October 21, 2019. You requested the following:
"See Attached Email"
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 within thirty (30) days, or by December 10th about the availability and/or provided with copies 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. To monitor the progress or update this request please log into Valley Communications Public Record Center. (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN4KAST8ESiRJTswcAuDcm7RRRzVbmkopVnMc2k8K2-2FnhFBu5H-2FzaajROMGo4spZQXArIgHQsTLnyFtRY1sluVmY-3D_wR3j6vFOHPjXR7dao08kLjuB48xpIRRyTdZLgzfmq3m-2BPuexmo-2BwU1gittd-2FRMhKWxUY9V0RP0CJLj95L8-2B-2FL-2Fyx1AK0zN88cGO2mCweHWslRIWCc6PftEC63AGZ0WZhrwUyARVimg-2BVOJyXIyClU-2FP-2BueTwCYwh4-2FX4YhpJg6g7vkKQXaYPY5oTiyeU9Hiqc-2F9uB31ERiQxB8MefaO02nXRNGFo-2BCYz2vtBKwXeUBKqaaFWqKm2a5THUcQtiWUNA60ygAv1zsllFs1nuLijbSfneB5lTj7KYtqPCHJFIVLP4WoO-2Fl70yG5qk3bB1x1iSlcmA2TuWhCJ83nV6BFK9EwBgaIxVjksAZpnv-2BwPX1azjB5dasLmm-2Fmvt-2FLwry6WK7vZv0LYBMSTtLZMfPA3eg-3D-3D)
Thank you for your patience in awaiting this information. If you have any questions please feel free to contact me at 253.372.1553.
Sincerely,
Cassie Gilman Public Records Specialist Valley Communications Center
To monitor the progress or update this request please log into the Public Records Center. (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN4KAST8ESiRJTswcAuDcm7RRRzVbmkopVnMc2k8K2-2FnhpFky10jviRW-2FZwjc7y-2Bi9qCWNRa19GeCSmvkfGp38TUHb3-2FOS7cCMTTAOZREe-2FJe_wR3j6vFOHPjXR7dao08kLjuB48xpIRRyTdZLgzfmq3m-2BPuexmo-2BwU1gittd-2FRMhKWxUY9V0RP0CJLj95L8-2B-2FL-2Fyx1AK0zN88cGO2mCweHWslRIWCc6PftEC63AGZ0WZhrwUyARVimg-2BVOJyXIyClU-2FP-2BueTwCYwh4-2FX4YhpJg6g7vkKQXaYPY5oTiyeU9Hiqc-2F9uB31ERiQxB8MefaO02nXRNGFo-2BCYz2vtBKwXeUBKqaaFWqKm2a5THUcQtiWUNKbhd7IAltRQ4AyViqhf-2FZiBcIlbAKAb0HKzPuw7DpwHesVxLbYZmxlXXU1UWYxuxInR6JNCiwNp-2F2T0uTmTAFJVOnGRJpu0iDtnydFwVlF9-2FdxBMyt1c2yaWuji2BFwksSLevl8-2BfVHdDvQrP2cNvA-3D-3D)
From: Valley Communications Center
--- Please respond above this line ---
RE: PUBLIC RECORDS REQUEST of 10/21/2019, Reference #V016553-102119
Dear Tim Clemans,
Valley Communications Center received a public records request from you on 10/21/2019. You requested the following:
Other
See Attached Email
This correspondence is to clarify what information that you are seeking from Valley Communications Center.
Copy of HR – Please describe what specific records you are requesting Please describe what specific records you are requesting
CAD – Valley Communications Center does not have nor do we maintain
RMS – Valley Communications Center does not have nor do we maintain
IAPro or Similar – Valley Communications Center does not have nor do we maintain
Parking Tickets – Valley Communications Center does not have nor do we maintain
Driving Citations – Valley Communications Center does not have nor do we maintain
J-walking or Similar Citations – Valley Communications Center does not have nor do we maintain
DEMS – Please describe what specific records you are requesting
911 Call/Radio Recorder – Please describe what specific records you are requesting
Internet Logs – Valley Communications Center does not have nor do we maintain
Forensic Software – Please describe what specific records you are requesting
Contracts & Data Dictionaries For Each Effected Vendor – Please describe what specific records you are requesting
Written name of each SQL server – Please describe what specific records you are requesting
Name of each SQL access tool owned by the agency or the agency’s IT provider – Please describe what specific records you are requesting
Custom data invoice – In addition a time frame is needed for the request. If Valley Communications Center does not receive a response within 10 days or by November 15 th, 2019 we will consider this request abandoned and closed. You may provide a response to Valley Communications Center by any of the following methods: You may provide a response to Valley Communications Center by any of the following methods:
1. by replying to this electronic mail 2. by replying via Valley Communications Public Record Center 3. by facsimile to 253-372-1305 4. by regular mail to Valley Communications Center, 27519 108th Avenue SE
Kent, WA 98030; or 5. in person at the Valley Communications Center, 27519 108th Avenue SE
Kent, WA 98030.
Please keep in mind Dispatch center communications are subject to judicial process and may be considered admissible evidence. All phone, radio and Computer Aided Dispatch (CAD) entries are recorded. The Revised Code of Washington (RCW) requires that Valley Communications keep recordings for a period of 90 days.
The disclosure of Valley Communications records are governed by appropriate state and local regulations. Public records subject to disclosure may have identifiable details deleted to the extent necessary to prevent an unreasonable invasion of privacy. Any deletions made shall be explained in writing.
If you have any questions, please contact me at 253.372.1553.
Thank you for your attention.
Sincerely,
Cassie Gilman Public Records Specialist Valley Communications Center
To monitor the progress or update this request please log into the Public Records Center. (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN4KAST8ESiRJTswcAuDcm7RRRzVbmkopVnMc2k8K2-2FnhpFky10jviRW-2FZwjc7y-2Bi9qCWNRa19GeCSmvkfGp38TUHb3-2FOS7cCMTTAOZREe-2FJe_wR3j6vFOHPjXR7dao08kLjuB48xpIRRyTdZLgzfmq3m-2BPuexmo-2BwU1gittd-2FRMhKWxUY9V0RP0CJLj95L8-2B-2FL2enM3X7at5RAoGvOE9v2skjgQmsshnS9PUQEhDgQSRO3T3OcGJYQoUbvy7vqd1PXYu1-2BbUiJczYGUFzAxdRDLKiDRX1tClkE4-2FEdQ3PtfEOgXgJCUUcpkItsxWq4G-2BjIcg-2FDYGiLOpoEt-2BoK0e2K34n7uNnr-2B-2BVgljHtKzthU2UEnC8ZOZpkxNrzBlgEYRCubB1LdKT0bjLKoeGPXrhL6SGwVV3GSQ3PwiTxZB2doptvcGMWViAeHFs131wAFWTh8O30X-2FKM468uFXRU0iHBia4vVv34PcjKp0VeES3DqXO4-2F2lPvQGg9U5aqHoRrb-2FDQ-3D-3D)
From: TimClemans
I'm confused about no CAD SQL data. Then where is your structured CAD data stored? I'm too tired to respond to the rest. Let's discuss CAD first.
From: Valley Communications Center
Hello,
Unfortunately your email was not recognized and has not been routed accordingly. Â Please be advised that if you wish to submit a new request or check on the status of an already submitted request, you should visit the Valley Communications Public Disclosure Request Center.
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.
From: Valley Communications Center
--- Please respond above this line ---
Dear Tim Clemans,
A request for clarification was sent via email on October 31st, 2019. I located a misdirected response within GovQA from October 31st, 2019 as well. Unfortunately, the response which was misdirected did not provide any clarification.
If Valley Communications Center does not receive clarification to the message sent on October 31st, 2019 by Wednesday, November 27th, 2019 this request will be considered abandoned and closed.
If you have any questions please reply via GovQA.
Thank You,
Cassie B. Gilman, CPRO
To monitor the progress or update this request please log into the Public Records Center. (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN4KAST8ESiRJTswcAuDcm7RRRzVbmkopVnMc2k8K2-2FnhpFky10jviRW-2FZwjc7y-2Bi9qCWNRa19GeCSmvkfGp38TUHb3-2FOS7cCMTTAOZREe-2FJe_wR3j6vFOHPjXR7dao08kLjuB48xpIRRyTdZLgzfmq3m-2BPuexmo-2BwU1gittd-2FRMhKWxUY9V0RP0CJLj95L8-2B-2FL1QfEg6eqYUIyxL6DdWIwIT2qwb5-2BHtxrU9txveWfM-2BESh40EBhSQLKBZ4BaUwqbD5E4j8YqZpvQLwb3zuOaYe1cvsUU5CaQOKTmOcdSTHoob-2FtKP-2BsjBhv-2F4Vv-2BRKW7Y-2BOKXK8VFpi5aD5Xp8arNqQzn75mk3YdpHoFNsP23DTMPmAXJAiUITSG1Wt6v5hRL8dxD1CBxNTVsj8XfSbIGlyrf4rzKOiClRErv-2FpuW7PmTXCGEe2xG7PLygngWIA7dnZ0DbmYEWMcikLuxhT6RvQA7ucRNapuK7gRUOBUSEvoTkqa-2BaM4nwZtXVEUm5FLTA-3D-3D)
From: Valley Communications Center
--- Please respond above this line ---
Good Morning Mr. Clemans,
As of today Valley Communications Center has not received clarification from you regarding this request. Per my email on November 20th, 2019, Valley Communications Center now considers this request abandoned and closed.
If you have any additional questions please feel free to contact me at 253.372.1553.
Thank You,
Cassie B. Gilman, CPRO
To monitor the progress or update this request please log into the Public Records Center. (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN4KAST8ESiRJTswcAuDcm7RRRzVbmkopVnMc2k8K2-2FnhpFky10jviRW-2FZwjc7y-2Bi9qCWNRa19GeCSmvkfGp38TUHb3-2FOS7cCMTTAOZREe-2FJe_wR3j6vFOHPjXR7dao08kLjuB48xpIRRyTdZLgzfmq3m-2BPuexmo-2BwU1gittd-2FRMhKWxUY9V0RP0CJLj95L8-2B-2FLxNJpxR3gInG-2BDXiTSsUVb5QYURFUe39VCgo6YzbqVCyUj1Eja0Ai-2FRk9TRPGNvXVwSlnUav3zyBPIzp7AhuD2NdseR40YYdbeYciyEmwHWztZUVG9ocqK2zc4JUA0C7NT3EHs6bikjjGO5AqylE1T5e7S-2BIhD-2FWr82UOIUGepi4KBvH3wjR4YB7dHG5spLh9q4Xm-2F7HTByaQzJbHO4hqLjmwj-2B99T23yWEDzcA2v8wWrkrSo8A5FhDJriMW-2Bnn1s6Yky7dEwrW-2FFJ-2Bjlk62WA-2F2xe2Dh6qAAmb7pNHxBWTXrhJP3K7f6F0V7mWfysFfqg-3D-3D)
Files
There are no files associated with this request.