Bulk police reports dataset (2017-01-01 through 2018-09-30)

--- Please respond above this line ---

01/07/2019

Andrew Sullivan
requests@muckrock.com

RE:  Public Disclosure Request#: P035305-112018

Dear Andrew Sullivan,
Thiscommunication is in response to your public disclosure request received onNovember 26, 2018. Youhave asked for A dataset of police reports fromJanuary 1, 2017 through September 30, 2018 with the following fields: - CDWOffense ID - CDW Incident ID - Offense Code - Offense Code Extension - CrimeType - Summary Offense Code - Summary Crime Type - Offense Occurred Date -Offense Reported Date - Address (partially anonymized is fine, e.g. "24XXBLOCK OF BOYLSTON AV E") - Offense latitude and longitude Essentially, I'mlooking for the data contained in PLUS dates and locations, for the dates mentioned above. The requesteddocuments will be made available to the general public, and this request is notbeing made for commercial purposes. In the event that there are fees, I wouldbe grateful if you would inform me of the total charges in advance offulfilling my request. I would prefer the request filled electronically, bye-mail attachment if available or CD-ROM if not. Thank you in advance for youranticipated cooperation in this matter. I look forward to receiving yourresponse to this request within 5 business days, as the statute requires.Sincerely, Andrew Sullivan

You then amended your request to seek the same data for the period from January 1,2017 to December 16, 2018. We have reviewed your request and have determined that providing the dataset inthe manner you have requested would require the use of information technology expertise to prepare data compilations andprovide customized electronic access services in a manner not used by SPD forother agency purposes in the normal course of business. This exceedsSPD’s obligation under the PRA; however, for an estimated customized servicecharge of $1260.00, we may be able to provide a dataset specific to what youare looking for. We estimate that it will take at least 21 hours for a GISanalyst to perform the work at an hourly rate of $60 per hour. Thisis just an estimate. SPD may impose a customized service charge up to the actual cost of providing theservices. RCW 42.56.120(3). We may also require a deposit in an amount not toexceed ten percent of the estimated cost of providing copies for a request,including a customized service charge. RCW 42.56.120(4). We ask that yousubmit a deposit of $120.60 before we initiate the customized service If the Department does not hear from you orreceive the deposit within 30 days or by February 7, 2019, the Department willconsider your request abandoned and will close the request.
If you have any questions, you may send a message using the Police Records Request Center or call the Public Disclosure Desk at 206-684-5481.

Sincerely,
Sheila Friend-Gray
Seattle Police Department
Public Disclosure Unit

SPD receives between 6000 and 7000 public records requests annually and is processing between 900 to 1000 open requests at a time. This may result in a slower than anticipated response to your request. Thank you for your patience.

--- Please respond above this line ---

02/11/2019

Andrew Sullivan

RE:  Public Disclosure Request#: P035305-112018

Dear Andrew Sullivan,

Thank you for getting back to me.  I will need to talk to our content experts and get back with you.  At this time, I anticipate getting back to you on or about February 25, 2019.
If you have any questions, call the Public Disclosure Desk at 206-684-5481.

Sincerely,
Sheila Friend-Gray
Seattle Police Department
Public Disclosure Unit



SPD receives between 6000 and 7000 public records requests annually and is processing between 900 to 1000 open requests at a time. This may result in a slower than anticipated response to your request. Thank you for your patience.

--- Please respond above this line ---

02/14/2019

Andrew Sullivan

RE:  Public Disclosure Request#: P035305-112018

Dear Andrew Sullivan,
Mr. Sullivan: We cannot provide the latitude/longitude and unblurred address for every incident because it would not protect the privacy of victims or witnesses who asked for nondisclosure or other sensitive locations. You have rejected the custom programming proposal. Therefore, SPD will process this by providing records and applying manual redactions to those records. SPD can generate a report (list) containing the following information “CDW Offense ID -CDW Incident ID - Offense Code - Offense Code Extension - Crime Type - Summary Offense Code - Summary Crime Type - Offense Occurred Date - Offense Reported Date – Address.” We understand that you have modified your request to exclude lat/long, so lat/long will not be provided. Please let us know within 30 days if this modification is incorrect and we will provide updated estimates of anticipated response times. SPD generated approximately 230.000 GOs during the requested period. SPD must review and manually redact the addresses from the list that are exempt from disclosure. We can accomplish this in one of three ways: 1. Targeted redaction: This will require a PDO to open the GO in the RMS and to review the report to determine whether the address is exempt. The PDO would redact those addresses from the list that are exempt and provide you the remaining addresses. This is an extremely labor-intensive and slow process. This process will take a minimum of one-minute per report. We estimate that it would take 3833 hours to process the entire list of 230,000 reports. SPD receives approximately 7000 requests each year. With current staffing, we could devote one hour per month to this task. We, therefore, estimate that it would take 26.6 years to process your request, 2. Provide you the initial reports and the list without addresses: This will require a PDO to open the GOin the RMS, download a copy of the initial report, apply any redactions needed prior to disclosure of the report, and then provide the report to you. You may then compile a new report by incorporating the information in the GO with the corresponding entry in the list. This is the most labor-intensive approach.Based on prior analysis, it typically takes an experienced PDO four minutes to process a GO in this manner. It would take four times as long to process in this manner as it would for targeted redactions indicated above or approximately 106 years to process the request. 3. Manually redact all addresses on the list to the 100 block. The will require the PDO to manually redact the list by redacting to the 100 block where possible. We can also provide examples in the first installment of how we would process those addresses that are not amenable to this approach. We estimate that we could process 1000 addresses on the list each month, and could complete the response in 23 months. If we do not hear from you within 30 days or by March 18, 2019, we will go forward with processing the response by applying the manual redactions to the list at the 100 block level as indicated in option 3. Please let us know whether you would prefer option 1 or 2 or you wish to modify your request in any way.
If you have any questions, you may call the Public Disclosure Desk at 206-684-5481.

Sincerely,
Sheila Friend-Gray
Seattle Police Department
Public Disclosure Unit



SPD receives between 6000 and 7000 public records requests annually and is processing between 900 to 1000 open requests at a time. This may result in a slower than anticipated response to your request. Thank you for your patience.

--- Please respond above this line ---

03/14/2019

Andrew Sullivan
requests@muckrock.com

RE:  Public Disclosure Request#: P035305-112018

Dear Andrew Sullivan,

Mr. Sullivan, SPD does not  have the internal capability to auto-redact address to 100 Block. In order to respond to your request, SPD would have to do one of two things:
* Engage a GIS analyst to blur the data— this would require you to pay a custom processing charge, which we understand that you have rejected; or Process as a standard pdr using one of the three approaches previously described:
* Targeted redaction: This will require a PDO to open the GO in the RMS and to review the report to determine whether the address is exempt. The PDO would redact those addresses from the list that are exempt and provide you the remaining addresses. This is an extremely labor-intensive and slow process. This process will take a minimum of one-minute per report. We estimate that it would take 3833 hours to process the entire list of 230,000 reports. SPD receives approximately 7000 requests each year. With current staffing, we could devote one hour per month to this task. We, therefore, estimate that it would take 26.6 years to process your request,
* Provide you the initial reports and the list without addresses: This will require a PDO to open the GO in the RMS, download a copy of the initial report, apply any redactions needed prior to disclosure of the report, and then provide the report to you. You may then compile a new report by incorporating the information in the GO with the corresponding entry in the list. This is the most labor-intensive approach. Based on prior analysis, it typically takes an experienced PDO four minutes to process a GO in this manner. It would take four times as long to process in this manner as it would for targeted redactions indicated above or approximately 106 years to process the request.
* Manually redact all addresses on the list to the 100 block. The will require the PDO to manually redact the list by redacting to the 100 block where possible. We can also provide examples in the first installment of how we would process those addresses that are not amenable to this approach. We estimate that we could process 1000 addresses on the list each month, and could complete the response in 23 months. Please clarify whether you have changed your mind and want to pursue custom programming or if you wish to pursue one of the options listed in 2(a)-(c). If SPD does not hear from you within 30 days or by April 15, 2019, we will consider your request closed. While SPD does not have the ability to provide the records in the form you requested, you may wish to direct a request to the Seattle IT Department to determine whether it can provide the record as you requested. https://city-seattle.mycusthelp.com/webapp/_rs/(S(iuolafqly4forbqmaa4p3mov))/supporthome.aspx?sSessionID=156742509ZEURQRNRMEELVCGDJTNNIRWOZTUHXKI (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN6aJurjb97okwL9xhZ5GuVgbGkRgWS9L-2BSLyaJWBlQgCktCQbmcz-2Bgd-2FbtTsxx8YzQDL0Z3t1ekY3HbctSuTn8Qd8fqa0h48KNCUAB-2FOU5hc7puMXRxBr-2FXPJQQOGm2zFdidgZOxDcgwC572nsJy9VnBsupxjsjGG4Yj3uvVI-2F2SE3s8SFxm-2F0SMNYgVjw8Meg-3D-3D_sifIWu6ikk7GgGQtps8zHKWhWRHij-2BeBVcSABKfIcRd3SmGZYU3WNMIkNGCEi402FEwAbp6k5sd6gFIOc84Qo2n1h2r0uIAR-2FvpQPhjl4k68WNfVKaz5UoIwmMswRj4TQy2tafHwOUTEDD1khOSpbAaGcM-2F-2F-2B9qXyDQV2S6CIDK8w0YLqLWjWcgd7sY3TonmIUUKsyDcO8Zy5AFbVVAc09xrXkLwkoabt8dF1oBBG-2Bu-2BW5dMQcqOVGyVGTDkbUSn-2FQnBg2zpbrxXG6kGeaHmkZHuor3IcDWwviwZpEP2xxQvYG7HJw4KZI3CeVEC4zWcEdvou0CQlkkoArPvvgj-2FqmgVBFVkdIZK76fSXJiBdGU6T-2BTwCB2M24zYRx7-2B57kL-2FRSOOhWfDxjGWFHfxAZHfw-3D-3D) Thank you
If you have any questions, you may send a message using the Police Records Request Center or call the Public Disclosure Desk at 206-684-5481.

Sincerely,
Sheila Friend-Gray
Seattle Police Department
Public Disclosure Unit



SPD receives between 6000 and 7000 public records requests annually and is processing between 900 to 1000 open requests at a time. This may result in a slower than anticipated response to your request. Thank you for your patience.

As a reminder you can login at the Police Records Request Center where you can access Police online information, manage your profile, submit record requests, track your request status, receive and send messages, make payments, view frequently asked questions, and download your records. (https://u8387795.ct.sendgrid.net/wf/click?upn=S-2BehCBSDSzwVGewhY9Ftkex1NnfCMS7NsuXpbCcEGAH-2FYU41snC8emZsrnfZ4oCeHaK3yIWuMAD3mDpxGYIOdxRo9xcLTKbUiKTVrm7wvSo-3D_sifIWu6ikk7GgGQtps8zHKWhWRHij-2BeBVcSABKfIcRd3SmGZYU3WNMIkNGCEi402FEwAbp6k5sd6gFIOc84Qo2n1h2r0uIAR-2FvpQPhjl4k68WNfVKaz5UoIwmMswRj4TQy2tafHwOUTEDD1khOSpbAaGcM-2F-2F-2B9qXyDQV2S6CIDK8w0YLqLWjWcgd7sY3TonmIUUKsyDcO8Zy5AFbVVAc09xrXkLwkoabt8dF1oBBG-2Bu-2BW5dMQcqOVGyVGTDkbUSnzr4uhsllz6irprB3I7RPOW7vRqwkQU300ZxnzORX685oL2DaYhfmUU4QREneXpFYkGKwtX7EUq7bO8br4Yfya7oRtWmXceDuaMN-2BG90KOQZxPATvwH8wZ37E26a2juhbgpI2x1kEsaXNTZxw0ND1hQ-3D-3D) Please add seattle@mycusthelp.net to your E-mail contacts/address book to ensure delivery of the record center E-mails to your Inbox.

--- Please respond above this line ---

03/14/2019

Andrew Sullivan
requests@muckrock.com

RE:  Public Disclosure Request#: P035305-112018

Dear Andrew Sullivan,

Mr. Sullivan, SPD does not  have the internal capability to auto-redact address to 100 Block. In order to respond to your request, SPD would have to do one of two things:
* Engage a GIS analyst to blur the data— this would require you to pay a custom processing charge, which we understand that you have rejected; or Process as a standard pdr using one of the three approaches previously described:
* Targeted redaction: This will require a PDO to open the GO in the RMS and to review the report to determine whether the address is exempt. The PDO would redact those addresses from the list that are exempt and provide you the remaining addresses. This is an extremely labor-intensive and slow process. This process will take a minimum of one-minute per report. We estimate that it would take 3833 hours to process the entire list of 230,000 reports. SPD receives approximately 7000 requests each year. With current staffing, we could devote one hour per month to this task. We, therefore, estimate that it would take 26.6 years to process your request,
* Provide you the initial reports and the list without addresses: This will require a PDO to open the GO in the RMS, download a copy of the initial report, apply any redactions needed prior to disclosure of the report, and then provide the report to you. You may then compile a new report by incorporating the information in the GO with the corresponding entry in the list. This is the most labor-intensive approach. Based on prior analysis, it typically takes an experienced PDO four minutes to process a GO in this manner. It would take four times as long to process in this manner as it would for targeted redactions indicated above or approximately 106 years to process the request.
* Manually redact all addresses on the list to the 100 block. The will require the PDO to manually redact the list by redacting to the 100 block where possible. We can also provide examples in the first installment of how we would process those addresses that are not amenable to this approach. We estimate that we could process 1000 addresses on the list each month, and could complete the response in 23 months. Please clarify whether you have changed your mind and want to pursue custom programming or if you wish to pursue one of the options listed in 2(a)-(c). If SPD does not hear from you within 30 days or by April 15, 2019, we will consider your request closed. While SPD does not have the ability to provide the records in the form you requested, you may wish to direct a request to the Seattle IT Department to determine whether it can provide the record as you requested. https://city-seattle.mycusthelp.com/webapp/_rs/(S(iuolafqly4forbqmaa4p3mov))/supporthome.aspx?sSessionID=156742509ZEURQRNRMEELVCGDJTNNIRWOZTUHXKI (https://u8387795.ct.sendgrid.net/wf/click?upn=Ow1KccipsoIsnXbuEgm-2FN6aJurjb97okwL9xhZ5GuVgbGkRgWS9L-2BSLyaJWBlQgCktCQbmcz-2Bgd-2FbtTsxx8YzQDL0Z3t1ekY3HbctSuTn8Qd8fqa0h48KNCUAB-2FOU5hc7puMXRxBr-2FXPJQQOGm2zFdidgZOxDcgwC572nsJy9VnBsupxjsjGG4Yj3uvVI-2F2SE3s8SFxm-2F0SMNYgVjw8Meg-3D-3D_sifIWu6ikk7GgGQtps8zHKWhWRHij-2BeBVcSABKfIcRd3SmGZYU3WNMIkNGCEi402FEwAbp6k5sd6gFIOc84Qo2n1h2r0uIAR-2FvpQPhjl4k68WNfVKaz5UoIwmMswRj4TQy2tafHwOUTEDD1khOSpbAaGcM-2F-2F-2B9qXyDQV2S6CIDK8w0YLqLWjWcgd7sY3TonmIUUKsyDcO8Zy5AFbVVAc09xrXkLwkoabt8dF1oBBG-2Bu-2BW5dMQcqOVGyVGTDkbUSn-2FQnBg2zpbrxXG6kGeaHmkZHuor3IcDWwviwZpEP2xxQvYG7HJw4KZI3CeVEC4zWcEdvou0CQlkkoArPvvgj-2FqmgVBFVkdIZK76fSXJiBdGU6T-2BTwCB2M24zYRx7-2B57kL-2FRSOOhWfDxjGWFHfxAZHfw-3D-3D) Thank you
If you have any questions, you may send a message using the Police Records Request Center or call the Public Disclosure Desk at 206-684-5481.

Sincerely,
Sheila Friend-Gray
Seattle Police Department
Public Disclosure Unit



SPD receives between 6000 and 7000 public records requests annually and is processing between 900 to 1000 open requests at a time. This may result in a slower than anticipated response to your request. Thank you for your patience.

As a reminder you can login at the Police Records Request Center where you can access Police online information, manage your profile, submit record requests, track your request status, receive and send messages, make payments, view frequently asked questions, and download your records. (https://u8387795.ct.sendgrid.net/wf/click?upn=S-2BehCBSDSzwVGewhY9Ftkex1NnfCMS7NsuXpbCcEGAH-2FYU41snC8emZsrnfZ4oCeHaK3yIWuMAD3mDpxGYIOdxRo9xcLTKbUiKTVrm7wvSo-3D_sifIWu6ikk7GgGQtps8zHKWhWRHij-2BeBVcSABKfIcRd3SmGZYU3WNMIkNGCEi402FEwAbp6k5sd6gFIOc84Qo2n1h2r0uIAR-2FvpQPhjl4k68WNfVKaz5UoIwmMswRj4TQy2tafHwOUTEDD1khOSpbAaGcM-2F-2F-2B9qXyDQV2S6CIDK8w0YLqLWjWcgd7sY3TonmIUUKsyDcO8Zy5AFbVVAc09xrXkLwkoabt8dF1oBBG-2Bu-2BW5dMQcqOVGyVGTDkbUSnzr4uhsllz6irprB3I7RPOW7vRqwkQU300ZxnzORX685oL2DaYhfmUU4QREneXpFYkGKwtX7EUq7bO8br4Yfya7oRtWmXceDuaMN-2BG90KOQZxPATvwH8wZ37E26a2juhbgpI2x1kEsaXNTZxw0ND1hQ-3D-3D) Please add seattle@mycusthelp.net to your E-mail contacts/address book to ensure delivery of the record center E-mails to your Inbox.