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 (Yakima Police Department)
| Submitted | Oct. 20, 2019 |
| Est. Completion | Dec. 28, 2020 |
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: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Muckrock Staff
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.
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following record was added to the request:
You can find the requested record at the following link: City of Yakima Policy:Public Records Disclosure - please download prior to 10/11/2020 (https://yakimawa.box.com/s/oekmovk3ocf7rstiqilz4g57sfycu42l) The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated. The due date for this request has been extended:
Pursuant to RCW 42.56.520, additional time is necessary to clarify the intent of the request and/or gather and review records, to determine whether any of the information requested is exempt from disclosure, and to provide third parties with notice and the opportunity to seek a court order to prevent the release of record(s) in response to your request. 10/09/2020 We anticipate providing you with records or an update regarding the status of your request on or near 10/09/2020. The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request
Thank you for submitting a public records request to the City of Yakima. Pursuant to RCW 38.52.070 and YMC Chapter 6.06, the City of Yakima proclaimed a state of emergency on March 12, 2020, due to the novel coronavirus (COVID-19) in the City of Yakima in Yakima, County, Washington, and established orders and measures to protect public health and safety. Due to increasing staff shortages, workload, and potential facility closures, and pursuant to RCW 42.56.520, additional time is necessary to clarify the intent of the request and/or gather and review records, to determine whether any of the information requested is exempt from disclosure, and to provide third parties with notice and the opportunity to seek a court order to prevent the release of record(s) in response to your request. At this time we anticipate 30 days to respond or provide an update to this request. A response can be the following:
* a question about your request
* an estimate on when your records will be delivered
* a note explaining why the records cannot be released
* the documents you requested
If you have an urgent matter, please phone our office at 509-575-6037. Thank you for your patience and understanding during this difficult time.
The details of your request are as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following note has been added to the request:
Greetings,
We are contacting you to seek clarification on your request. First, we would like to address the following part of your request "Parking Tickets, Driving citations, J-walking or similar citations". If you are seeking parking tickets, driving citation, or j-walking -- since these would be infractions we could forward your request to the Yakima Municipal Court once you've specified further what it is you are looking for. For example are you seeking infractions for a specific incident or incidents, individual(s), or a time frame.
If you are looking for citations other than infractions that would have resulted in a misdemeanor charge in the City of Yakima then again please specify an incident, individual, or time frame you would like records from. We also ask you specify what other records you are requesting when you say "or similar citations".
If you have any questions you can reach us at 509-575-6220. We look forward to hearing from you. The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated. The due date for this request has been extended:
We recevied no reply the the request for clarification sent September 14, and have provided the request as is to our IT Division. Pursuant to RCW 42.56.520, additional time is necessary to clrify the request and to gather and review records. We anticipate providing you with records or an update regarding the status of your request on or near November 9, but please watch for requests for information / clarification between now and then. Please reply to this email with any questions or clarifications. Thank you. We anticipate providing you with records or an update regarding the status of your request on or near 11/09/2020. The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following note has been added to the request:
Good afternoon: IT has some questions and solutions - can you provide a phone number so the supervisor can talk through this with you? Thank you. The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following note has been added to the request:
D. EMS is unfamiliar to us - can you elaborate or clarify? Thank you. The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following record was added to the request:
You can find the requested record at the following link: PDR 14376 This is a link to the HR_schema.csv. The link is active for 30 days to allow time for you to review and download the record. (https://yakimawa.box.com/s/8ifgdamn2j6tlg84bzgonypmmfuyhhj4) The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
-
HR_schema.csv
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated. The due date for this request has been extended:
There is a link to records in my email sent immediately prior to this email. Due to workload and staff availability, and pursuant to RCW 42.56.520, additional time is necessary to clarify the intent of the request and/or gather and review records, to determine whether any of the information requested is exempt from disclosure, and to provide third parties with notice and the opportunity to seek a court order to prevent the release of record(s) in response to your request. We contact us with the previously requested clarifying information and with a contact phone number. We anticipate providing you with records or an update regarding the status of your request on or near 12/15/2020. The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following note has been added to the request:
Please clarify what you are specifically requesting from these two 911 vendors: SunComm has two 9-1-1 and radio logging recorders. One is located at the primary location and the other is used at the backup center.
Primary: Maker: Higherground; Vendor: Commercial Electronics, 1318 N. Brazos, San Antonio, TX 78207 (800) 933-4077; Purchased through HGACBuy
Backup: Maker: Equature; Vendor: DSS/Equature 18311 W. Ten Mile Rd, Southfield, MI 48075 (888) 305-3428 Purchased 2012 The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following note has been added to the request:
Please clarify what you are specifically requesting from PassportParking, Inc., 1300 S. Mint Street Suite 200, Charlotte, NC 28203 The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following note has been added to the request:
Please clarify what you are specifically requesting from vendors IA Pro, Cellebrite and Graykey. The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following note has been added to the request:
Please clarify what you are specifically requesting from vendor Spillman. The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated.
The following record was added to the request:
You can find the requested record at the following link: PDR 14376 This is a link to the WSP SECTOR Schema. The link is active for 30 days to allow time for you to review and download the records. (https://yakimawa.box.com/s/5pk7tlakrm3cszmxq1izcuu9uteg8xdu) The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
-
SECTOR_Schema_12-15-2020
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Updated
A public records request from the City of Yakima that you are subscribed to has been updated. The due date for this request has been extended:
Dear Mr. Clemens: There is a link to the WSP Sector Schema in my email sent immediately prior to this email. We are in the process of working with vendors to gather records. Pursuant to RCW 42.56.520, additional time is necessary to clarify the intent of the request and/or gather and review records, to determine whether any of the information requested is exempt from disclosure, and to provide third parties with notice and the opportunity to seek a court order to prevent the release of record(s) in response to your request. We anticipate providing you with records or an update regarding the status of your request on or near December 28, 2020. Please be aware that we may also send emails earlier with links or asking for clarification. Please contact me with any questions. Thank you, Tammy (509-575-6270)
122820 We anticipate providing you with records or an update regarding the status of your request on or near 12/28/2020. The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
From: Yakima Police Department
Emails/html RecordTrac Email
City of Yakima RecordTrac
Public Records Request Closed
A public records request from the City of Yakima that you are subscribed to has been closed.
The following note has been added to the request:
Certain copies / web links of records have been provided. However, most of the request is not clear and the requested clarfications have not been answered.
Based on our interpretation of the request, which is what we've had to rely on, we have interpreted the requests for vendor information, as written, as not a public record, pursuant to " A "public record" is a record "prepared, owned, used, or retained" by an agency. RCW 42.56.010(3).
Because we have received no communication from you as we have made our attempts to clarify (so that we might be better able to comply), we are now closing the request. Please do not hesitate to contact me with any questions or concerns that you may have, or if you require additional information. Thank you, Tammy (509-575-6270) The original request is as follows:
On Oct. 20, 2019:
Subject: Washington Public Records Act Request: Copy of HR, CAD, R MS, IA Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D EMS, 911 Call/radio recorder, Internet logs, Forensics software SQL data (Yakima Police Department
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 Investigate Safety L.L.C. will not use the data to solicit business transactions nor will it knowingy 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 "R.C.W... 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 R.C.W. 42.56.070(8)." modified to say supplying agency's name. https: //www. s!
os. 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 haven't 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, R.M.S., I.A..Pro or similar software, Parking Tickets, Driving citations, J-walking or similar citations, D.EMS, 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 C.S.V format and redaction.s 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 D.BA_TAB_COLS M.ysql: information_schema.columns P.ostgres: 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.
City of Yakima
If you do not want to receive these updates, please unsubscribe (https://records.yakimawa.gov/requests/unsubscribe/14708)
Files
pages