Note: The Sex Abuse category represents a subset of the most serious sexual abuse cases reported to MPD.
The advanced features on MPD’s crime mapping application can provide a substantial amount of information on incidents that have been reported in the District of Columbia, including:
- Advisory Neighborhood Commissions
- Block (specific addresses are not available)
- Census Block Group
- Census Tract
- Criminal Complaint Number
- Neighborhood Cluster
- Report Date
- Voting Precinct
- Map Coordinates
In an effort to show you what you can get from the crime mapping application, let’s go through a step-by-step process of running a basic query and downloading the more detailed information.
Step 1: Run a Query
You can search for information on crimes by address, by police district or PSA, or by many other geographic areas (including schools, places of worship, libraries, and other DC landmarks). As an example, let’s go to crimemap.dc.gov and run a report. Select the location you want to search by using the radio button. An address field or a drop down menu will appear depending on what tab you select. We chose to search crimes in PSA 403 for the past 30 days:
Step 2: Download More Information
The basic query (see above) will return a table with the total number of crimes in the designated area for the timeframe indicated. Select the “Download Crime Data” link at the top of the table. This will let you select what information you want to download.
To see a map of the offenses, just click on the “view map” link, which will return a graphic representation of the crime locations. You’ll need to download data to get details on specific incidents.
Step 3: Download Crime Data
Click on the "Download Crime Data" link just above the table of data. A page will come up that lets you select the types of information you want. You can get the data in two formats: Microsoft Excel or Text. Check the boxes of the information fields you would like to download and then click “Get Data.”
Step 4: Sort Your Data for Analysis
Your Excel file is now available. You'll need Excel in order to manipulate the file.
Step 5: Evaluate Data Using Excel
After you download the file, you can review the data using Excel. A very useful tool in Excel will let you sort the data by any category (the title field). Simply place your cursor in the column that contains the information you want to sort by and then click on the "Sort Ascending" button in the tool bar (if the icon is not on your table, go to Data>Sort). The information will then be organized by that field. Do not highlight a column to sort the data; just place your cursor in one of the boxes.
In the snapshot below, we put the cursor in cell 2B and then clicked on the highlighted icon. The data was then sorted by offense.
We hope these instructions will make the MPD's crime mapping application a helpful tool that is easy to use. If you have any additional questions, please contact the Office of Research and Analytical Services at (202) 727-4174.