Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

CrimeReports.com

No recent searches

    Popular Articles

            Sorry! nothing found for

            CrimeReports.com

            Created by Russ Hartle, Modified on Tue, 15 Apr, 2025 at 10:08 AM by Russ Hartle

            Overview

            The data on CrimeReports is sent on an hourly, daily, or weekly basis from more than 1000 participating agencies to the CrimeReports map. Each agency controls their data flow to CrimeReports, including how often they send data and which incidents are included. More information on CrimeReports can be found here: Crime Reports Website

            Setup and Configuration

            The setup and configuration consists of a database view and database user account that can access the system views.

            Database View
            The view used for CrimeReports.com is called Crime_Reports_Export. The SQL used to create the view can be found below:

            The following is a breakdown of the fields found in the view and what corresponding tables/fields they come from.

            Tables can't be imported directly. Please insert an image of your table which can be found here.

            !The Crime_Reports_Export view has a default city and default state as part of the SQL. When using this view at an agency, these fields must be manually set.
            They can be found here in the SQL: ….iif(a.city <> ‘’, a.city, ‘Glen Dale’) as city, iif(a.state <> ‘’, a.state, ‘WV’) as state,….

            Other filters in the view consist of:

            • The case must have a crime
            • The incident type must be “CASE”
            • Confidential Case must be “FALSE”
            • The date reported must be greater than or equal to the current date/time minus 180 days
            • The date reported must be less than the current date/time
            • Must be a case with a deleted_ts of null

            Database User Account

            The read-only view user ISSVIEW must be added to the security2.fdb using the GSEC command. Learn more about GSEC here: Add/View/Delete Firebird Users

            CrimeReports Upload

            The ISSVIEW credentials and database path are provided to CrimeReports, so that they can access the CRIME_REPORTS_EXPORT view to upload the data. The SQL statement used to access the view is:

            Was this article helpful?

            That’s Great!

            Thank you for your feedback

            Sorry! We couldn't be helpful

            Thank you for your feedback

            Let us know how can we improve this article!

            Feedback sent

            We appreciate your effort and will try to fix the article

            X