Convert › F009
Burglary by Beat
CJIWave 2| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Burglary by Beat - Agency A (2025) | RSSSRS | Incidents | 373 | 9/30/2026 6:10 AM | Mapped |
| Burglary by Beat - Agency L (2026 YTD) | RSSSRS | Incidents | 15 | 9/24/2026 4:15 AM | Mapped |
| Burglary by Beat - Agency G (2025) | RSSSRS | Incidents | 10 | 8/30/2026 9:36 PM | Mapped |
| Burglary by Beat | RSSSRS | Incidents | 10 | 7/10/2026 1:14 PM | Mapped |
| Burglary by Beat - Agency I (2026 YTD) | RSSSRS | Incidents | 9 | 9/7/2026 7:33 PM | Mapped |
| Burglary by Beat - Agency K (2025) | RSSSRS | Incidents | 8 | 9/7/2026 5:29 AM | Mapped |
| Burglary by Beat - Agency E (2025) | RSSSRS | Incidents | 6 | 5/15/2026 2:50 AM | Mapped |
| Burglary by Beat - Agency H (2025) | RSSSRS | Incidents | 0 | Never | Mapped |
| Burglary by Beat - Agency F (2026 YTD) | RSSSRS | Incidents | 0 | Never | Mapped |
9 of 9
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 9 reports
- Layout
- Standard
SELECT i.beat, CONVERT(char(7), i.occurred_date, 126) AS month, COUNT(*) AS incidents FROM incident i WHERE i.offense_code = '220' AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY i.beat, CONVERT(char(7), i.occurred_date, 126)