Firearm Project, Overland Park, KS

Brian Freskos filed this request with the Overland Park Police Department of Overland Park, KS.
Status
Completed

Communications

From: Ben Hallman

Hi,

Pursuant to the state’s public records law, I am a journalist requesting access to and copies of data and others records from your agency as part of a national reporting project on the use of stolen firearms in crimes. I have broken the request into three parts, each of which details the records that we are seeking. As expressed below, the date range for each part of this request is January 1, 2010 to the present:

1) Detailed information on stolen guns

It is our understanding that law enforcement agencies keep detailed records about firearms that were reported stolen by the citizens they serve. We are therefore requesting the following for each case of reported firearm theft in your jurisdiction:

-- The police report number and/or incident number for the firearm theft
-- The serial number, make, model, caliber, type and any other descriptive information for each firearm that was reported stolen

If possible, I would be grateful if this data was collated into a spreadsheet where each row represents one firearm. Here is an example:

If a spreadsheet is provided, please provide the record layout and/or code sheet. If such a spreadsheet is not available, please provide any other records that contain this information.

2) Detailed information about seized and/or recovered guns, any guns in evidence, and/or any gun of which the department has taken custody

Third, it is our understanding that law enforcement agencies maintain detailed records about firearms that were used in crimes, found at crimes scenes or other incidents, seized during investigations, placed into evidence or otherwise under the custody and control of the department, including the make, model and serial number of each gun. We are therefore requesting the following:

-- The following records regarding firearms used in crimes in your agency’s jurisdiction, found at crime scenes, seized during investigations or otherwise recovered or taken in by your agency: the make, model, and serial number of each gun; the date of the crime and/or incident from which it was recovered or seized; the police report number for the crime and/or incident; the type of crime the firearm was used in; and the address where the crime was committed and/or the incident occurred. Please include firearms for all offense and incident types, including homicide, robbery, assault, traffic stops, etc.

If your agency maintains a spreadsheet or database containing these records, we ask that you please provide that database. I would be grateful if this data was collated into a spreadsheet where each row represents one case, the same as part 1) “Detailed information about stolen guns.” If a spreadsheet is provided, please also provide a record layout and/or code sheet. If a spreadsheet or database is not available, please release any other records containing the information we seek.

The date range for this part is also January 1, 2010 to the present.

3) Detailed information on lost, stolen or unaccounted for law enforcement guns

Finally, it is our understanding that law enforcement agencies maintain detailed records about firearms that, while owned by the department or under the control and/or in the possession of their employees, went missing, were lost or stolen, or are otherwise unaccounted for. Therefore we request the following:

-- Any and all records of department-issued firearms that were lost, stolen, went missing or are otherwise unaccounted for.

-- If your department does not issue firearms, then we ask for any and all records of firearms that were lost, stolen, went missing or otherwise became unaccounted for while under the control and/or in the possession of one of your employees.

The records should include but not be limited to the following:

• The make, model, serial number and caliber of each firearm
• The location and address where the firearm was lost or stolen
• The date of the loss or theft.
• The date the loss or theft was reported
• Whether each lost or stolen firearm was recovered
• If the lost, stolen or missing firearm was recovered, the date and location of the recovery
• A description of how the firearm was lost, stolen or went missing
• Whether negligence on the part of the employee is/was suspected in the loss or theft of the firearm
• Whether the employee in control of the firearm retired, was terminated or otherwise left the department, and if so, the date and circumstances of the employee’s departure and whether his or her gun was retrieved and/or recovered.
• Any other individual reports and findings on the individual lost, stolen or missing firearms

The records should include but not be limited to audits, inventory reports, databases, internal reports, memos, internal affairs investigations, emails or other correspondence, and/or any other records.

The date range for this part is also January 1, 2010 to the present.

Please label each record in a clear manner. As a 501c3 nonprofit news organization, we will be making information obtained from this request available to the general public and are not requesting it for commercial purposes.

In the event that there are fees, I would be grateful if you informed me of the total charges before completing my request. We request that if you send an invoice, you make it out to The Trace.

I would prefer the requested information be sent via an e-mail attachment if available, or a mailed CD-ROM if not. If standard mail must be used, we ask that you send the request to the following address:

The Trace (at WeWork)
Attn: Brian Freskos
428 Broadway
New York, NY 10013

Thank you in advance for your help with this request. I look forward to receiving your response. If you have any questions or concerns, do not hesitate to contact me on my cell phone: (919) 522-6354

Sincerely,

Brian Freskos

From: Knoll, John

This will acknowledge receipt of your open records request copied below.

I will determine what records the city has that are responsive to your
request and what exceptions, if any, to the open records act apply, and get
back to you with my findings. This process is expected to take no longer
than two weeks. You should hear back from me no later than March 15, 2017.
Please advise if you have any questions.

--

*John J. Knoll*
Assistant City Attorney, Sr
Law Department

City of Overland Park
8500 Santa Fe Dr
Overland Park, KS 66212

(w1) 913-327-6941 <(913)%20327-6941> (M, T, Th)
(w2) 913-895-6086 <(913)%20895-6086> (W, F)
(c) 785-231-9595 <(785)%20231-9595>
john.knoll@opkansas.org | www.opkansas.org

[image: http://apps.opkansas.org/images/email-logo-sm.gif]®

---------- Forwarded message ----------
From: <requests@muckrock.com>
Date: Tue, Feb 28, 2017 at 10:43 AM
Subject: Kansas Open Records Act Request: Firearm Project, Overland Park, KS
To: oppdpio@opkansas.org

February 28, 2017
Overland Park Police Department
Overland Park Police Department
ATTN: Public Information Officer
12400 Foster Street
Overland Park, KS 66213

Hi,

Pursuant to the state’s public records law, I am a journalist requesting
access to and copies of data and others records from your agency as part of
a national reporting project on the use of stolen firearms in crimes. I
have broken the request into three parts, each of which details the records
that we are seeking. As expressed below, the date range for each part of
this request is January 1, 2010 to the present:

1) Detailed information on stolen guns

It is our understanding that law enforcement agencies keep detailed records
about firearms that were reported stolen by the citizens they serve. We are
therefore requesting the following for each case of reported firearm theft
in your jurisdiction:

-- The police report number and/or incident number for the firearm theft
-- The serial number, make, model, caliber, type and any other descriptive
information for each firearm that was reported stolen

If possible, I would be grateful if this data was collated into a
spreadsheet where each row represents one firearm. Here is an example:

If a spreadsheet is provided, please provide the record layout and/or code
sheet. If such a spreadsheet is not available, please provide any other
records that contain this information.

2) Detailed information about seized and/or recovered guns, any guns in
evidence, and/or any gun of which the department has taken custody

Third, it is our understanding that law enforcement agencies maintain
detailed records about firearms that were used in crimes, found at crimes
scenes or other incidents, seized during investigations, placed into
evidence or otherwise under the custody and control of the department,
including the make, model and serial number of each gun. We are therefore
requesting the following:

-- The following records regarding firearms used in crimes in your agency’s
jurisdiction, found at crime scenes, seized during investigations or
otherwise recovered or taken in by your agency: the make, model, and serial
number of each gun; the date of the crime and/or incident from which it was
recovered or seized; the police report number for the crime and/or
incident; the type of crime the firearm was used in; and the address where
the crime was committed and/or the incident occurred. Please include
firearms for all offense and incident types, including homicide, robbery,
assault, traffic stops, etc.

If your agency maintains a spreadsheet or database containing these
records, we ask that you please provide that database. I would be grateful
if this data was collated into a spreadsheet where each row represents one
case, the same as part 1) “Detailed information about stolen guns.” If a
spreadsheet is provided, please also provide a record layout and/or code
sheet. If a spreadsheet or database is not available, please release any
other records containing the information we seek.

The date range for this part is also January 1, 2010 to the present.

3) Detailed information on lost, stolen or unaccounted for law enforcement
guns

Finally, it is our understanding that law enforcement agencies maintain
detailed records about firearms that, while owned by the department or
under the control and/or in the possession of their employees, went
missing, were lost or stolen, or are otherwise unaccounted for. Therefore
we request the following:

-- Any and all records of department-issued firearms that were lost,
stolen, went missing or are otherwise unaccounted for.

-- If your department does not issue firearms, then we ask for any and all
records of firearms that were lost, stolen, went missing or otherwise
became unaccounted for while under the control and/or in the possession of
one of your employees.

The records should include but not be limited to the following:

• The make, model, serial number and caliber of each firearm
• The location and address where the firearm was lost or stolen
• The date of the loss or theft.
• The date the loss or theft was reported
• Whether each lost or stolen firearm was recovered
• If the lost, stolen or missing firearm was recovered, the date and
location of the recovery
• A description of how the firearm was lost, stolen or went missing
• Whether negligence on the part of the employee is/was suspected in the
loss or theft of the firearm
• Whether the employee in control of the firearm retired, was terminated or
otherwise left the department, and if so, the date and circumstances of the
employee’s departure and whether his or her gun was retrieved and/or
recovered.
• Any other individual reports and findings on the individual lost, stolen
or missing firearms

The records should include but not be limited to audits, inventory reports,
databases, internal reports, memos, internal affairs investigations, emails
or other correspondence, and/or any other records.

The date range for this part is also January 1, 2010 to the present.

Please label each record in a clear manner. As a 501c3 nonprofit news
organization, we will be making information obtained from this request
available to the general public and are not requesting it for commercial
purposes.

In the event that there are fees, I would be grateful if you informed me of
the total charges before completing my request. We request that if you send
an invoice, you make it out to The Trace.

I would prefer the requested information be sent via an e-mail attachment
if available, or a mailed CD-ROM if not. If standard mail must be used, we
ask that you send the request to the following address:

The Trace (at WeWork)
Attn: Brian Freskos
428 Broadway
New York, NY 10013

Thank you in advance for your help with this request. I look forward to
receiving your response. If you have any questions or concerns, do not
hesitate to contact me on my cell phone: (919) 522-6354

Sincerely,

Brian Freskos

------
Filed via MuckRock.com
E-mail (Preferred): requests@muckrock.com

For mailed responses, please address (see note):
MuckRock
DEPT MR 34112
411A Highland Ave
Somerville, MA 02144-2516

PLEASE NOTE: This request is not filed by a MuckRock staff member, but is
being sent through MuckRock by the above in order to better track, share,
and manage public records requests. Also note that improperly addressed
(i.e., with the requester's name rather than "MuckRock News" and the
department number) requests might be returned as undeliverable.
------

--

*John J. Knoll*
Assistant City Attorney, Sr
Law Department

City of Overland Park
8500 Santa Fe Dr
Overland Park, KS 66212

(w1) 913-895-6086 (Mon, Tues)
(w2) 913-327-6941 (Weds - Fri)
(c) 785-231-9595
john.knoll@opkansas.org | www.opkansas.org

[image: http://apps.opkansas.org/images/email-logo-sm.gif]®

From: Ben Hallman

Thank you so much. Please let me know if you have any questions. Brian

From: Knoll, John

Mr. Freskos, I have now heard from our records and IT staff on your request
set out below.

Our records management system does not easily lend itself to generating the
spreadsheets you request. I have been advsied that quite a bit of manual
manipulation of data queries and reports would be required to generate the
data in the format that you seek.

I have been advised that an estimate to perform such queries and generate
the requested reports would require
112 hours of work and would cost $3,360.00. Please advise if you wish to
proceed with your request or to modify or withdraw it.

--

*John J. Knoll*
Assistant City Attorney, Sr
Law Department

City of Overland Park
8500 Santa Fe Dr
Overland Park, KS 66212

(w1) 913-895-6086 (Mon, Tues)
(w2) 913-327-6941 (Weds - Fri)
(c) 785-231-9595
john.knoll@opkansas.org | www.opkansas.org

[image: http://apps.opkansas.org/images/email-logo-sm.gif]®

From: Brian Freskos

Hi John,

Would we be able to do some of that data manipulation? If your folks were able to provide a spreadsheet, my research assistant and I would be able to go through and parse out the information we need.

From: Knoll, John

Unfortunately, no.

The Property module in our records management software (I/Leads) where gun
information is stored is not tied to the Incident module in such a way as
to produce a report that lists both the weapon, charge/nature of
investigation & location of recovery.

I am told that records staff will have to pull a report from the property
module that lists all the cases with guns, then look up each case by hand
and enter the charge/nature of investigation and location into the property
data sheet.

You also asked for a "key" to the spreadsheet headers which I/Leads uses
table codes to identify - without this work, any spreadsheet we would send
you would be unclear.

--

*John J. Knoll*
Assistant City Attorney, Sr
Law Department

City of Overland Park
8500 Santa Fe Dr
Overland Park, KS 66212

(w1) 913-895-6086 (Mon, Tues)
(w2) 913-327-6941 (Weds - Fri)
(c) 785-231-9595
john.knoll@opkansas.org | www.opkansas.org

[image: http://apps.opkansas.org/images/email-logo-sm.gif]®

From: Brian Freskos

Thank you. What would the estimated charges be if we requested only Part 2 and eliminated Parts 1 and 3?

From: Knoll, John

Here is the response from our property unit Captain:

Their Part 2 question was only:

"2) Detailed information about seized and/or recovered guns, any guns in
evidence, and/or any gun of which the department has taken custody"

If "detailed information" was just the data dump from the Property Module
in I/Leads and did not include any location information about each item,
and did not include a detailed key to the data headers, that would be free
of charge and would be available within a couple of hours.

If the "detailed information" did not include any location information but
did include a detailed key, that would be 8 hours of research and a $240.00
fee.

If the "detailed information" included both the location information and a
detailed key then we are back up to 48 hours of research and a fee of
$1,440.00.

Please advise how you wish to proceed.

--

*John J. Knoll*
Assistant City Attorney, Sr
Law Department

City of Overland Park
8500 Santa Fe Dr
Overland Park, KS 66212

(w1) 913-895-6086 (Mon, Tues)
(w2) 913-327-6941 (Weds - Fri)
(c) 785-231-9595
john.knoll@opkansas.org | www.opkansas.org

[image: http://apps.opkansas.org/images/email-logo-sm.gif]®

From: Brian Freskos

Thanks! Let's just do the free data dump.

From: Knoll, John

I have attached the data file you requested.

---------- Forwarded message ----------
From: <requests@muckrock.com>
Date: Tue, Mar 21, 2017 at 4:42 PM
Subject: RE: Kansas Open Records Act Request: Firearm Project, Overland
Park, KS
To: john.knoll@opkansas.org

March 21, 2017
Overland Park Police Department
Overland Park Police Department
ATTN: Public Information Officer
12400 Foster Street
Overland Park, KS 66213

This is a follow up to a previous request:

Thanks! Let's just do the free data dump.
---

--

*John J. Knoll*
Assistant City Attorney, Sr
Law Department

City of Overland Park
8500 Santa Fe Dr
Overland Park, KS 66212

(w1) 913-895-6086 (Mon, Tues)
(w2) 913-327-6941 (Weds - Fri)
(c) 785-231-9595
john.knoll@opkansas.org | www.opkansas.org

[image: http://apps.opkansas.org/images/email-logo-sm.gif]®

From: Brian Freskos

Thank you so much John. And please pass along my thanks to anyone who also assisted. One question: Column BM is titled, "pecateg," and contains several acronyms that appear to the be the status of the gun. What does it mean, though, when a cell in that column is blank?

I assume the acronyms mean the following, but can you confirm?
EVID: Evidence
SAFE: Safekeeping
STO: Stolen
RECV: Received
SEIZ: Seized
FND: Found
LOST: Lost
INVL: I'm not sure what this one is but assume it's a gun that the department has taken custody of in some fashion.

From: Knoll, John

Sorry for the delayed response. I was out of the office for a few days.

"Pecateg" stands for Property-Evidence Catalog, and defines the National
Incident Based Reporting Syste (NIBRS) status of the item. Those rows
without an entry on this line currently have no NIBRS status with our
Department because we have released or disposed of this item.

Your assumptions on the abbreviations below is correct, except for the last
one, which stands for "involved."

--

*John J. Knoll*
Assistant City Attorney, Sr
Law Department

City of Overland Park
8500 Santa Fe Dr
Overland Park, KS 66212

(w1) 913-895-6086 (Mon, Tues)
(w2) 913-327-6941 (Weds - Fri)
(c) 785-231-9595
john.knoll@opkansas.org | www.opkansas.org

[image: http://apps.opkansas.org/images/email-logo-sm.gif]®

From: Brian Freskos

Thanks!

From: Brian Freskos

Hi John,

We have more column in this datasheet that we had questions about. It is labeled, "prstatus." What does this column mean? There are several codes in that column as well that I was curious about. I might have figured a few out, but was hoping you could confirm and help me fill in the other ones:

1 - ?
4 - ?
6 - ?
7 - ?
8 - ?
E - EVIDENCE?
F - FOUND?
L - LOST?
S - STOLEN?

From: Brian Freskos

My apologies, I left out the 5. So the codes contained in the prstatus column are:

1 - ?
4 - ?
5 - ?
6 - ?
7 - ?
8 - ?
E - EVIDENCE?
F - FOUND?
L - LOST?
S - STOLEN?

From: Brian Freskos

Hi John,

I just wanted to follow up on my last. I left you a voicemail yesterday seeking contact information for the captain of the property unit. I wanted to inquire with him or her about the codes in my last email. It's important I have the meaning those codes so I can format the data correctly. Do you have a phone/email for the captain?

Thank you,
Brian Freskos

From: Knoll, John

Captain Melanie Pierce, 913-327-6947.

--

*John J. Knoll*
Assistant City Attorney, Sr
Law Department

City of Overland Park
8500 Santa Fe Dr
Overland Park, KS 66212

(w1) 913-895-6086 (Mon, Tues)
(w2) 913-327-6941 (Weds - Fri)
(c) 785-231-9595
john.knoll@opkansas.org | www.opkansas.org

[image: http://apps.opkansas.org/images/email-logo-sm.gif]®

From: Brian Freskos

Thanks!

From: Knoll, John

FYI.

---------- Forwarded message ----------
From: Pierce, Melanie <melanie.pierce@opkansas.org>
Date: Tue, Sep 5, 2017 at 10:56 AM
Subject: Fwd: Kansas Open Records Act Request: Firearm Project, Overland
Park, KS
To: John Knoll <john.knoll@opkansas.org>

As previously mentioned, the column is the incident based reporting status
for the piece of property reported to us. Numbers 1 through 7 are based
out of the Property Section in the Sixth Edition of the Kansas Incident
Based Reporting System (KIBRS) Handbook. The KIBRS Handbook can be located
online. I have explained the codes for Unknown, Evidence, Found, Lost and
Safe Keeping below:

1 None
2 Burned
3 Counterfeited/Forged
4 Destroyed/Damaged/Vandalized
5 Recovered
6 Seized
7 Stolen
8 Unknown - unable to determine the status of the property at the time of
the report.
E Evidence - item was deemed to be evidence as it relates to the report at
the time of the report.
F Found - item found does not fit into one of the other categories.
L Lost - lost or misplaced item not related to a criminal report.
S Safe Keeping - an item not relative to a criminal case is placed in
police care until a disposition is determined.

*John J. Knoll*
Assistant City Attorney, Sr
Law Department

City of Overland Park
8500 Santa Fe Dr
Overland Park, KS 66212

(w1) 913-895-6086 (Mon, Tues)
(w2) 913-327-6941 (Weds - Fri)
(c) 785-231-9595
john.knoll@opkansas.org | www.opkansas.org

[image: http://apps.opkansas.org/images/email-logo-sm.gif]®

Files