Public safety

City incidents, patrol beats and street lighting

Chicago, Illinois, United Statessynthetic data, real placeMaps, charts and report
The question

Where and when do incidents cluster, which beats are getting worse, and where should patrols go?

A police department uploads a year of incident reports, its patrol beats, stations, CCTV cameras, transit stops, licensed premises and street light outages, monthly calls for service and beat staffing, and its briefings. It wants to know where and when incidents cluster, which beats are getting worse and where to send patrols.

41.8790, -87.6440data covers about 6 by 5 km
12datasets uploaded
27output layers
24maps made
41charts made
104findings
786 sStart run time

Every map and chart this run made is here. 24 map images, 41 charts and the cited report (PDF, Word, Markdown), as exported on 2026-10-22.

Findings (first few)

  • Evidenced: The timeline counts 2,484 dated events in Incidents, Street light outages, Calls for service by beat and month per month, from October 2024 to September 2026 1234.
  • Evidenced: By dataset: Incidents 1,680; Street light outages 420; Calls for service by beat and month 384 15.
  • Evidenced: The trend is +11.8 events per month; the second half of the months has 2,292 against 192 in the first (+1093.8%) 1.
  • Evidenced: Month over month, the largest rise was from September 2025 to October 2025 (16 to 163, +147) and the largest fall was from January 2026 to February 2026 (177 to 150, -27) 16.
  • Evidenced: The count rose from 33 in week of 2026-06-22 to 72 in week of 2026-06-29 (+118.2%), beyond what chance would give (p = 0.000178) 78.

What Start ran

Describe mode, the local model only (no paid model); run status succeeded, 16 analyst agents.

gp_calculate_densitygp_find_nearestgp_find_point_clustersgp_hot_spotsgp_near_repeatgp_period_changegp_pipeline (1 failed)gp_space_time_hot_spotsgp_spatial_joingp_summarize_within

Maps

Every map image this run exported, with legend, north arrow and scale bar. Select one to view it full size.

Overview: the top 3 results
Overview: the top 3 resultsFig. 4
Hot spots: CCTV cameras
Hot spots: CCTV camerasFig. 5
Hot spots: licensed premises
Hot spots: licensed premisesFig. 6
Emerging hot spots: incidents
Emerging hot spots: incidentsFig. 7
Emerging hot spots: street light outages
Emerging hot spots: street light outagesFig. 8
Clusters: licensed premises
Clusters: licensed premisesFig. 9
Clusters: incidents
Clusters: incidentsFig. 10
Clusters: street light outages
Clusters: street light outagesFig. 11
Counts: CCTV cameras, by patrol beat
Counts: CCTV cameras, by patrol beatFig. 12
Counts: licensed premises, by patrol beat
Counts: licensed premises, by patrol beatFig. 13
Counts: incidents, by patrol beat
Counts: incidents, by patrol beatFig. 14
Period change: incidents, by patrol beat
Period change: incidents, by patrol beatFig. 15
Period change: street light outages, by patrol beat
Period change: street light outages, by patrol beatFig. 19
Density: licensed premises
Density: licensed premisesFig. 23
Density: incidents
Density: incidentsFig. 24
Density: street light outages
Density: street light outagesFig. 25
Hot spots: incidents
Hot spots: incidentsFig. 26
Near repeat: incidents
Near repeat: incidentsFig. 27
Hot cells inside each cluster of licensed premises
Hot cells inside each cluster of licensed premisesFig. 28
Change beside the counts per patrol beat
Change beside the counts per patrol beatFig. 30
Change of incidents where density is high
Change of incidents where density is highFig. 32
Hot cells of CCTV cameras per patrol beat
Hot cells of CCTV cameras per patrol beatFig. 34
Nearest police station to each cluster of licensed premises
Nearest police station to each cluster of licensed premisesFig. 36
Change of street light outages per patrol beat
Change of street light outages per patrol beatFig. 39

Charts

Every chart image this run exported.

Incidents: count per week
Incidents: count per weekFig. 16
Incidents: week of 2026-06-22 to week of 2026-06-29 by place
Incidents: week of 2026-06-22 to week of 2026-06-29 by placeFig. 17
Street light outages: count per week
Street light outages: count per weekFig. 20
Street light outages: week of 2026-02-02 to week of 2026-02-09 by place
Street light outages: week of 2026-02-02 to week of 2026-02-09 by placeFig. 21
Incidents over time (reported_at)
Incidents over time (reported_at)Fig. 41
Street light outages over time (reported_at)
Street light outages over time (reported_at)Fig. 42
CCTV cameras over time (installed_year)
CCTV cameras over time (installed_year)Fig. 43
Calls for service by beat and month over time (month)
Calls for service by beat and month over time (month)Fig. 44
Hot spot analysis: CCTV cameras
Hot spot analysis: CCTV camerasFig. 45
Hot spot analysis: Licensed premises
Hot spot analysis: Licensed premisesFig. 46
Emerging hot spots: Incidents
Emerging hot spots: IncidentsFig. 47
Emerging hot spots: Street light outages
Emerging hot spots: Street light outagesFig. 48
Find point clusters: Licensed premises
Find point clusters: Licensed premisesFig. 49
Find point clusters: cluster hulls
Find point clusters: cluster hullsFig. 50
Find point clusters: Incidents
Find point clusters: IncidentsFig. 51
Find point clusters: cluster hulls
Find point clusters: cluster hullsFig. 52
Find point clusters: Street light outages
Find point clusters: Street light outagesFig. 53
Find point clusters: cluster hulls
Find point clusters: cluster hullsFig. 54
Summarize within: Patrol beats
Summarize within: Patrol beatsFig. 55
Summarize within: Patrol beats
Summarize within: Patrol beatsFig. 56
Summarize within: Patrol beats
Summarize within: Patrol beatsFig. 57
Period change: Incidents (week of 2026-06-22 to week of 2026-06-29)
Period change: Incidents (week of 2026-06-22 to week of 2026-06-29)Fig. 18
Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09)
Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09)Fig. 22
Calculate density: Licensed premises
Calculate density: Licensed premisesFig. 58
Calculate density: Incidents
Calculate density: IncidentsFig. 59
Calculate density: Street light outages
Calculate density: Street light outagesFig. 60
Hot spot analysis: Incidents
Hot spot analysis: IncidentsFig. 61
Repeat and near repeat classification: Incidents
Repeat and near repeat classification: IncidentsFig. 62
Hot cells inside each cluster of licensed premises
Hot cells inside each cluster of licensed premisesFig. 29
Change beside the counts per patrol beat
Change beside the counts per patrol beatFig. 31
Change of incidents where density is high
Change of incidents where density is highFig. 33
Hot cells of CCTV cameras per patrol beat
Hot cells of CCTV cameras per patrol beatFig. 35
Nearest police station to each cluster of licensed premises
Nearest police station to each cluster of licensed premisesFig. 37
Dense areas of street light outages
Dense areas of street light outagesFig. 38
Change of street light outages per patrol beat
Change of street light outages per patrol beatFig. 40
Repeat and near repeat classification: Incidents over time
Repeat and near repeat classification: Incidents over timeFig. 63
Find point clusters: Street light outages over time
Find point clusters: Street light outages over timeFig. 64
Find point clusters: Incidents over time
Find point clusters: Incidents over timeFig. 65
Timeline: events per month by dataset
Timeline: events per month by datasetFig. 1
Timeline lanes: events per month by dataset
Timeline lanes: events per month by datasetFig. 2
Timeline: change from one month to the next
Timeline: change from one month to the nextFig. 3

The cited report

Sample: Public safety, Chicago: report

Project: Sample: Public safety, Chicago
Goal: Describe the project Sample: Public safety, Chicago: run the analyses that tell the most about its data, draw every result, and write a cited report.
Run: 2e6054ca-62f3-479f-b398-915fe26200ce (running, 19 agent run(s))
Generated: 2026-10-19T04:36:58Z, version 1
Model cost: USD 0.0000 over 0 model call(s)

Data used

DataKindRowsTime spanSummarySource
Incidentsvector, Point1,6802025-10-01 to 2026-09-301,680 point features; dated by 'reported_at' from 2025-10-01 to 2026-09-30; 'category' has 7 values (top: theft 539, battery 286, criminal damage 207); 'location_type' has 6 values (top: street 626, residence 351, business 274); 'severity' 1 to 5 (mean 2.587); extent -87.6800,41.8566 to -87.6078,41.9016. Dated point events by category: where and when Incidents happen.2
Street light outagesvector, Point4202025-10-01 to 2026-09-30420 point features; dated by 'reported_at' from 2025-10-01 to 2026-09-30; 'cause' has 4 values (top: lamp failure 209, cable fault 100, vandalism 64); 'days_out' 1 to 60 (mean 6.95); extent -87.6803,41.8565 to -87.6125,41.9013. Dated point events by cause: where and when Street light outages happen.3
Patrol beatsvector, Polygon1616 polygon (area) features; 'district' has 1 values (top: District 12 16); 'population' 11,440 to 33,436 (mean 2.514e+04); 'officers_assigned' 6 to 12 (mean 9.75); named by 'name' (e.g. North River Beat, Market West Beat, Station Quarter Beat); total area 30.02 km2; extent -87.6804,41.8563 to -87.6076,41.9017. Areas (Patrol beats) with population to compare and map.145
Police stationsvector, Point33 point features; 'open_24h' has 2 values (top: False 2, True 1); 'officers' 97 to 139 (mean 124.7); named by 'name' (e.g. Central District Station, Westside Station, Riverside Station); extent -87.6671,41.8744 to -87.6210,41.8881. Point locations of Police stations by open_24h.146
CCTV camerasvector, Point6060 point features; 'ptz' has 2 values (top: False 41, True 19); 'status' has 2 values (top: live 45, fault 15); 'installed_year' 2,012 to 2,025 (mean 2018); extent -87.6796,41.8566 to -87.6139,41.9010. Point locations of CCTV cameras by ptz.147
Transit stopsvector, Point8080 point features; 'mode' has 2 values (top: bus 74, rail 6); 'daily_boardings' 48 to 4,542 (mean 311.9); named by 'name' (e.g. Central Transit Center, Stop 002, Stop 003); extent -87.6794,41.8569 to -87.6138,41.9013. Point locations of Transit stops by mode.148
Licensed premisesvector, Point120120 point features; 'type' has 4 values (top: restaurant 57, bar 38, liquor store 13); 'closing_hour' 0 to 23 (mean 5.775); 'capacity' 32 to 350 (mean 124.8); extent -87.6794,41.8569 to -87.6140,41.9008. Point locations of Licensed premises by type.149
Roadsvector, LineString1,0331,033 line features; 'class' has 4 values (top: local 814, other 181, motorway 25); 'speed_limit_mph' 25 to 35 (mean 25.37); 'lanes' 2 to 4 (mean 2.074); named by 'name' (e.g. Randolph St, W Arcade Pl, Harrison St); total length 509.7 km; extent -87.6804,41.8563 to -87.6077,41.9016. Lines (Roads) such as routes or networks.150
Calls for service by beat and monthtable3842024-10-01 to 2026-09-01Table of 384 rows and 6 columns without geometry; dated by 'month' from 2024-10-01 to 2026-09-01; 'calls' 61 to 814 (mean 226.5); 'priority_1_calls' 9 to 139 (mean 35.84); 'median_response_min' 5.7 to 13.9 (mean 9.779). A table of Calls for service by beat and month without locations.4
Beat staffing by shifttable48Table of 48 rows and 5 columns without geometry; 'shift' has 3 values (top: day 16, evening 16, night 16); 'officers' 2 to 6 (mean 3.75); 'vehicles' 1 to 3 (mean 1.979); 'overtime_hours' 0 to 59 (mean 28.85). A table of Beat staffing by shift without locations.151
Quarterly crime and safety briefingdocument1-page md document 'Quarterly crime and safety briefing, third quarter 2026'; language en; mentions 7 place(s): Central Transit Center (2), Market West Beat (2), N Elizabeth St (2), Kingsway Beat (2), 41.87815, -87.63532 (1). A document about Central Transit Center, Market West Beat, N Elizabeth St; it names event terms Thefts, Transit, street.152
Hot spot patrol plandocument1-page pdf document 'Hot spot patrol plan'; language en; mentions 6 place(s): Central District Station (1), Westside Station (1), Riverside Station (1), Central Transit Center (1), Market West Beat (1). A document about Central District Station, Westside Station, Riverside Station; it names organizations Focus; event terms theft, Patrols, Transit.153
Sample: Public safety, Chicagorecord154
Hot spot analysis: CCTV cameraslayer, Polygon3698
Hot spot analysis: Licensed premiseslayer, Polygon112155
Emerging hot spots: Incidentslayer, Polygon270156
Emerging hot spots: Street light outageslayer, Polygon47157
Find point clusters: Licensed premiseslayer, Point120158
Find point clusters: cluster hullslayer, Polygon381
Find point clusters: Incidentslayer, Point1,680159
Find point clusters: cluster hullslayer, Polygon3160
Find point clusters: Street light outageslayer, Point420161
Find point clusters: cluster hullslayer, Polygon1162
Summarize within: Patrol beatslayer, Polygon16163
Summarize within: Patrol beatslayer, Polygon16164
Summarize within: Patrol beatslayer, Polygon1688
Period change: Incidents (week of 2026-06-22 to week of 2026-06-29)layer, Polygon168
Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09)layer, Polygon710
Calculate density: Licensed premiseslayer, Polygon164165
Calculate density: Incidentslayer, Polygon2,874166
Calculate density: Street light outageslayer, Polygon84893
Hot spot analysis: Incidentslayer, Polygon2,91280
Repeat and near repeat classification: Incidentslayer, Point1,680167
Dense areas of street light outageslayer, MultiPolygon5110
Hot cells inside each cluster of licensed premiseslayer, Polygon382
Change beside the counts per patrol beatlayer, Polygon1689
Change of incidents where density is highlayer, Polygon1694
Hot cells of CCTV cameras per patrol beatlayer, Polygon1699
Nearest police station to each cluster of licensed premiseslayer, Polygon3104
Change of street light outages per patrol beatlayer, Polygon16113

Timeline

Timeline: events per month by dataset
Figure 1. Timeline: events per month by dataset 1. Per month, 2024-10-01 to 2026-09-01. Source: Incidents, Street light outages, Calls for service by beat and month (2,484 features). The data is in the appendix.
Timeline lanes: events per month by dataset
Figure 2. Timeline lanes: events per month by dataset 5. Per month, 2024-10-01 to 2026-09-01. Source: Incidents, Street light outages, Calls for service by beat and month (2,484 features). The data is in the appendix.
Timeline: change from one month to the next
Figure 3. Timeline: change from one month to the next 6. Per month, 2024-11-01 to 2026-09-01. Source: Incidents, Street light outages, Calls for service by beat and month (2,484 features). The data is in the appendix.

The timeline counts 2,484 dated events in Incidents, Street light outages, Calls for service by beat and month per month, from October 2024 to September 2026 1234. By dataset: Incidents 1,680; Street light outages 420; Calls for service by beat and month 384 15. The trend is +11.8 events per month; the second half of the months has 2,292 against 192 in the first (+1093.8%) 1. Month over month, the largest rise was from September 2025 to October 2025 (16 to 163, +147) and the largest fall was from January 2026 to February 2026 (177 to 150, -27) 16. The count rose from 33 in week of 2026-06-22 to 72 in week of 2026-06-29 (+118.2%), beyond what chance would give (p = 0.000178) 78. Between the two, the largest rise was in Market West Beat (7 to 16, +9) and the largest fall in Granary Beat (2 to 0, -2) 78. The count fell from 17 in week of 2026-02-02 to 4 in week of 2026-02-09 (-76.5%), beyond what chance would give (p = 0.0072) 910. Between the two, the largest rise was in Parkview Beat (0 to 2, +2) and the largest fall in Market West Beat (9 to 2, -7) 910.

Busiest months

  • July 2026: 235 events 1
  • September 2026: 234 events 1
  • August 2026: 228 events 1

Quietest months

  • October 2024: 16 events 1
  • November 2024: 16 events 1
  • December 2024: 16 events 1

Overview

Overview: the top 3 results in the report's order, each in one distinct color, over Patrol beats as context 11.

Overview: the top 3 results
Figure 4. Overview: the top 3 results 11

Spatial structure

Incidents are clustered (nearest-neighbor ratio 0.73, z = -21.0; features lie 48.8 m apart on average against 66.5 m if random) 12. Incidents are dated by 'reported_at' from 2025-10-01 to 2026-09-30 at a week grain 12. Over time the pattern changes: the earlier half is clustered (ratio 0.7893) and the later half clustered (ratio 0.7746); the center moved 132 m 12. Street light outages are clustered (nearest-neighbor ratio 0.88, z = -4.9; features lie 113 m apart on average against 129 m if random) 13. Street light outages are dated by 'reported_at' from 2025-10-01 to 2026-09-30 at a week grain 13. Over time the pattern changes: the earlier half is clustered (ratio 0.8542) and the later half clustered (ratio 0.8877); the center moved 263 m 13. Patrol beats are 16 areas of 1.876 km2 on average, covering 99 percent of their extent, with no overlap 14. CCTV cameras are spread at random (nearest-neighbor ratio 0.93, z = -1.0; features lie 311 m apart on average against 334 m if random) 15. Transit stops are spread at random (nearest-neighbor ratio 0.93, z = -1.2; features lie 268 m apart on average against 289 m if random) 16. Licensed premises are clustered (nearest-neighbor ratio 0.85, z = -3.2; features lie 199 m apart on average against 234 m if random) 17. Roads form a connected network: 1033 lines with 120 junctions and 2864 crossings in 98 connected parts, 509.7 km in all 18. 100 percent of CCTV cameras lie inside Patrol beats (60 of 60) 1415. 100 percent of Incidents lie inside Patrol beats (1680 of 1680) 1214. 100 percent of Licensed premises lie inside Patrol beats (120 of 120) 1417. 100 percent of Police stations lie inside Patrol beats (3 of 3) 1419. 100 percent of Street light outages lie inside Patrol beats (420 of 420) 1314. 100 percent of Transit stops lie inside Patrol beats (80 of 80) 1416. 99 percent of Roads lie inside Patrol beats (1019 of 1033) 1418. CCTV cameras lie 2.33 m from the nearest of Roads (median); 100 percent lie within 100 m 1518. Street light outages lie 3.89 m from the nearest of Roads (median); 96 percent lie within 100 m 1318. Transit stops lie 4.41 m from the nearest of Roads (median); 100 percent lie within 100 m 1618.

ResultValue
layers profiled8
clustered point layers3
random point layers2

Findings

  • Evidenced: Incidents are clustered (nearest-neighbor ratio 0.73, z = -21.0; features lie 48.8 m apart on average against 66.5 m if random) 12.
  • Evidenced: Incidents are dated by 'reported_at' from 2025-10-01 to 2026-09-30 at a week grain 12.
  • Evidenced: Over time the pattern changes: the earlier half is clustered (ratio 0.7893) and the later half clustered (ratio 0.7746); the center moved 132 m 12.
  • Evidenced: Street light outages are clustered (nearest-neighbor ratio 0.88, z = -4.9; features lie 113 m apart on average against 129 m if random) 13.
  • Evidenced: Street light outages are dated by 'reported_at' from 2025-10-01 to 2026-09-30 at a week grain 13.
  • Evidenced: Over time the pattern changes: the earlier half is clustered (ratio 0.8542) and the later half clustered (ratio 0.8877); the center moved 263 m 13.
  • Evidenced: Patrol beats are 16 areas of 1.876 km2 on average, covering 99 percent of their extent, with no overlap 14.
  • Evidenced: CCTV cameras are spread at random (nearest-neighbor ratio 0.93, z = -1.0; features lie 311 m apart on average against 334 m if random) 15.
  • Evidenced: Transit stops are spread at random (nearest-neighbor ratio 0.93, z = -1.2; features lie 268 m apart on average against 289 m if random) 16.
  • Evidenced: Licensed premises are clustered (nearest-neighbor ratio 0.85, z = -3.2; features lie 199 m apart on average against 234 m if random) 17.
  • Evidenced: Roads form a connected network: 1033 lines with 120 junctions and 2864 crossings in 98 connected parts, 509.7 km in all 18.
  • Evidenced: 100 percent of CCTV cameras lie inside Patrol beats (60 of 60) 1415.
  • Evidenced: 100 percent of Incidents lie inside Patrol beats (1680 of 1680) 1214.
  • Evidenced: 100 percent of Licensed premises lie inside Patrol beats (120 of 120) 1417.
  • Evidenced: 100 percent of Police stations lie inside Patrol beats (3 of 3) 1419.
  • Evidenced: 100 percent of Street light outages lie inside Patrol beats (420 of 420) 1314.
  • Evidenced: 100 percent of Transit stops lie inside Patrol beats (80 of 80) 1416.
  • Evidenced: 99 percent of Roads lie inside Patrol beats (1019 of 1033) 1418.
  • Evidenced: CCTV cameras lie 2.33 m from the nearest of Roads (median); 100 percent lie within 100 m 1518.
  • Evidenced: Street light outages lie 3.89 m from the nearest of Roads (median); 96 percent lie within 100 m 1318.
  • Evidenced: Transit stops lie 4.41 m from the nearest of Roads (median); 100 percent lie within 100 m 1618.

Hot spots

What this analysis is. Hot spot analysis: Getis-Ord Gi* hot and cold spots with z-scores, p-values and confidence bins 20. In ArcGIS it is Find Hot Spots or Hot Spot Analysis (Getis-Ord Gi*); in QGIS, qgis:hotspot (plugin) 20.

Why it was run on this data. 60 points: Getis-Ord Gi* tests whether the concentrations in CCTV cameras are statistically significant 21.

What it found. The hot spot analysis tool, gp_hot_spots, utilized the CCTV cameras layer 15 and returned a result containing 36 features 22.

ResultValue
result, bins36
result, count36
result, elapsed ms3
result, cell size m1,000
result, incidents used60
result, distance band m2,000
billing, cost0.0512
billing, list price0.0512
billing, upstream cost0
Hot spots: CCTV cameras
Figure 5. Hot spots: CCTV cameras 23

What the map shows. The map draws Hot spot analysis: CCTV cameras by gi_bin in 7 classes: Hot spot - 99% confidence, Hot spot - 95% confidence, Hot spot - 90% confidence, Not significant, Cold spot - 90% confidence, Cold spot - 95% confidence and 1 more 23. The map draws Patrol beats with one symbol 23. It draws 52 features 23. It covers longitude -87.715 to -87.578 and latitude 41.838 to 41.917, at about 1:47,468 23.

Findings

  • Evidenced: Hot spots on CCTV cameras: Hot spot analysis: 1 layer saved: Hot spot analysis: CCTV cameras (36 features) 1522.
  • Evidenced: It reported result, bins 36; result, count 36; result, elapsed ms 3; result, cell size m 1,000; result, incidents used 60; result, distance band m 2,000 22.

Tool gp_hot_spots; parameters {"project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "CCTV cameras (ad88aaeb)"}, "aggregation": "hexagon", "cell_size_m": 1000.0, "distance_band_m": 2000.0}

Hot spots

What this analysis is. Hot spot analysis: Getis-Ord Gi* hot and cold spots with z-scores, p-values and confidence bins 20. In ArcGIS it is Find Hot Spots or Hot Spot Analysis (Getis-Ord Gi*); in QGIS, qgis:hotspot (plugin) 20.

Why it was run on this data. 120 points: Getis-Ord Gi* tests whether the concentrations in Licensed premises are statistically significant 24. Measured: Licensed premises are clustered (nearest-neighbor ratio 0.85, z = -3.2), median spacing 121 m 24. Cells of 500 m and a band of 1000 m from the measured spacing 24.

What it found. Hot spots on Licensed premises: Hot spot analysis: 1 layer saved: Hot spot analysis: Licensed premises (112 features) 1725. It reported result, bins 112; result, count 112; result, elapsed ms 5; result, cell size m 500; result, incidents used 120; result, distance band m 1,000 25.

ResultValue
result, bins112
result, count112
result, elapsed ms5
result, cell size m500
result, incidents used120
result, distance band m1,000
billing, cost0.0524
billing, list price0.0524
billing, upstream cost0
Hot spots: licensed premises
Figure 6. Hot spots: licensed premises 26

What the map shows. The map draws Hot spot analysis: Licensed premises by gi_bin in 7 classes: Hot spot - 99% confidence, Hot spot - 95% confidence, Hot spot - 90% confidence, Not significant, Cold spot - 90% confidence, Cold spot - 95% confidence and 1 more 26. The map draws Patrol beats with one symbol 26. It draws 128 features 26. It covers longitude -87.705 to -87.593 and latitude 41.847 to 41.911, at about 1:38,555 26.

Findings

  • Evidenced: Hot spots on Licensed premises: Hot spot analysis: 1 layer saved: Hot spot analysis: Licensed premises (112 features) 1725.
  • Evidenced: It reported result, bins 112; result, count 112; result, elapsed ms 5; result, cell size m 500; result, incidents used 120; result, distance band m 1,000 25.

A model draft was discarded because a sentence did not cite a source of this section.

Tool gp_hot_spots; parameters {"project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Licensed premises (055b5c2c)"}, "aggregation": "hexagon", "cell_size_m": 500.0, "distance_band_m": 1000.0}

Space time hot spots

What this analysis is. Emerging hot spots: Where hot spots are new, consecutive, intensifying, persistent, diminishing, sporadic, oscillating or historical over time 27. In ArcGIS it is Emerging Hot Spot Analysis or Create Space Time Cube 27.

Why it was run on this data. Incidents carry dates in 'reported_at': emerging hot spot analysis finds new, intensifying and fading hot spots per week 28. Measured: the pattern of Incidents changes over time (earlier half clustered, later half clustered; the center moved 132 m) 28.

What it found. The space time hot spots analysis was executed using the Incidents layer 12 and resulted in 270 features saved as "Emerging hot spots: Incidents" 29. The process was efficient, concluding in an elapsed time of 46 milliseconds 29. Furthermore, the analysis utilized 1,680 features and incurred a total cost of 0.184 29.

ResultValue
result, count270
result, elapsed ms46
result, resolution9
result, features used1,680
result, time neighbors0
billing, cost0.184
billing, list price0.184
billing, upstream cost0
Emerging hot spots: incidents
Figure 7. Emerging hot spots: incidents 30

What the map shows. The map draws Emerging hot spots: Incidents by category in 2 classes: Sporadic hot spot, No pattern detected 30. The map draws Patrol beats with one symbol 30. It draws 286 features 30. It covers longitude -87.702 to -87.587 and latitude 41.846 to 41.91, at about 1:39,916 30.

Findings

  • Evidenced: Space time hot spots on Incidents: Emerging hot spots: 1 layer saved: Emerging hot spots: Incidents (270 features) 1229.
  • Evidenced: It reported result, count 270; result, elapsed ms 46; result, resolution 9; result, features used 1,680; result, time neighbors 0; billing, cost 0.184 29.

Tool gp_space_time_hot_spots; parameters {"project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Incidents (36ad5f7c)"}, "interval": "week", "bin_shape": "h3", "resolution": 9, "time_field": "reported_at"}

Space time hot spots

What this analysis is. Emerging hot spots: Where hot spots are new, consecutive, intensifying, persistent, diminishing, sporadic, oscillating or historical over time 27. In ArcGIS it is Emerging Hot Spot Analysis or Create Space Time Cube 27.

Why it was run on this data. Street light outages carry dates in 'reported_at': emerging hot spot analysis finds new, intensifying and fading hot spots per week 31. Measured: the pattern of Street light outages changes over time (earlier half clustered, later half clustered; the center moved 263 m) 31.

What it found. Space time hot spots on Street light outages: Emerging hot spots: 1 layer saved: Emerging hot spots: Street light outages (47 features) 1332. It reported result, count 47; result, elapsed ms 10; result, resolution 8; result, features used 420; result, time neighbors 0; billing, cost 0.121 32.

ResultValue
result, count47
result, elapsed ms10
result, resolution8
result, features used420
result, time neighbors0
billing, cost0.121
billing, list price0.121
billing, upstream cost0
Emerging hot spots: street light outages
Figure 8. Emerging hot spots: street light outages 33

What the map shows. The map draws Emerging hot spots: Street light outages by category in 2 classes: Sporadic hot spot, No pattern detected 33. The map draws Patrol beats with one symbol 33. It draws 63 features 33. It covers longitude -87.716 to -87.578 and latitude 41.839 to 41.916, at about 1:47,799 33.

Findings

  • Evidenced: Space time hot spots on Street light outages: Emerging hot spots: 1 layer saved: Emerging hot spots: Street light outages (47 features) 1332.
  • Evidenced: It reported result, count 47; result, elapsed ms 10; result, resolution 8; result, features used 420; result, time neighbors 0; billing, cost 0.121 32.

Tool gp_space_time_hot_spots; parameters {"project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Street light outages (a7218535)"}, "interval": "week", "bin_shape": "h3", "resolution": 8, "time_field": "reported_at"}

Find point clusters

What this analysis is. Find point clusters: Density-based clusters (DBSCAN, HDBSCAN or OPTICS, optionally space-time) with hulls and noise 34. In ArcGIS it is Find Point Clusters or Density-based Clustering; in QGIS, native:dbscanclustering or native:stdbscanclustering 34.

Why it was run on this data. DBSCAN finds dense groups of Licensed premises and separates noise 35. Measured: Licensed premises are clustered (nearest-neighbor ratio 0.85, z = -3.2), median spacing 121 m 35. DBSCAN at 200 m (twice the measured spacing) 35.

What it found. Find point clusters on Licensed premises: Find point clusters: 2 layers saved: Find point clusters: Licensed premises (120 features); Find point clusters: cluster hulls (3 features) 1736. It reported result, count 120; result, noise 61; result, distance m 200; result, elapsed ms 499; result, min points 3; billing, cost 0.0524 36.

ResultValue
result, count120
result, noise61
result, distance m200
result, elapsed ms499
result, min points3
billing, cost0.0524
billing, list price0.0524
billing, upstream cost0
Clusters: licensed premises
Figure 9. Clusters: licensed premises 37

What the map shows. The map draws Patrol beats with one symbol 37. The map draws Find point clusters: cluster hulls with one symbol 37. The map draws Find point clusters: Licensed premises by cluster_id in 4 classes: Cluster 0, Cluster 1, Cluster 2, Noise 37. It draws 139 features 37. It covers longitude -87.695 to -87.598 and latitude 41.851 to 41.906, at about 1:33,333 37.

Findings

  • Evidenced: Find point clusters on Licensed premises: Find point clusters: 2 layers saved: Find point clusters: Licensed premises (120 features); Find point clusters: cluster hulls (3 features) 1736.
  • Evidenced: It reported result, count 120; result, noise 61; result, distance m 200; result, elapsed ms 499; result, min points 3; billing, cost 0.0524 36.

Tool gp_find_point_clusters; parameters {"method": "dbscan", "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Licensed premises (055b5c2c)"}, "distance_m": 200.0, "min_points": 3}

Find point clusters

What this analysis is. Find point clusters: Density-based clusters (DBSCAN, HDBSCAN or OPTICS, optionally space-time) with hulls and noise 34. In ArcGIS it is Find Point Clusters or Density-based Clustering; in QGIS, native:dbscanclustering or native:stdbscanclustering 34.

Why it was run on this data. DBSCAN finds dense groups of Incidents and separates noise 38. Measured: Incidents are clustered (nearest-neighbor ratio 0.73, z = -21.0), median spacing 34.3 m 38. DBSCAN at 50 m (twice the measured spacing) 38.

What it found. Find point clusters on Incidents: Find point clusters: 2 layers saved: Find point clusters: Incidents (1680 features); Find point clusters: cluster hulls (3 features) 1239. It reported result, count 1,680; result, noise 1,609; result, distance m 50; result, elapsed ms 19; result, min points 20; billing, cost 0.0836 39.

ResultValue
result, count1,680
result, noise1,609
result, distance m50
result, elapsed ms19
result, min points20
billing, cost0.0836
billing, list price0.0836
billing, upstream cost0
Clusters: incidents
Figure 10. Clusters: incidents 40

What the map shows. The map draws Find point clusters: cluster hulls with one symbol 40. The map draws Find point clusters: Incidents by cluster_id in 4 classes: Cluster 0, Cluster 1, Cluster 2, Noise 40. It draws 1,683 features 40. It covers longitude -87.693 to -87.595 and latitude 41.85 to 41.907, at about 1:34,033 40.

Findings

  • Evidenced: Find point clusters on Incidents: Find point clusters: 2 layers saved: Find point clusters: Incidents (1680 features); Find point clusters: cluster hulls (3 features) 1239.
  • Evidenced: It reported result, count 1,680; result, noise 1,609; result, distance m 50; result, elapsed ms 19; result, min points 20; billing, cost 0.0836 39.

Tool gp_find_point_clusters; parameters {"method": "dbscan", "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Incidents (36ad5f7c)"}, "distance_m": 50.0, "min_points": 20}

Find point clusters

What this analysis is. Find point clusters: Density-based clusters (DBSCAN, HDBSCAN or OPTICS, optionally space-time) with hulls and noise 34. In ArcGIS it is Find Point Clusters or Density-based Clustering; in QGIS, native:dbscanclustering or native:stdbscanclustering 34.

Why it was run on this data. DBSCAN finds dense groups of Street light outages and separates noise 41. Measured: Street light outages are clustered (nearest-neighbor ratio 0.88, z = -4.9), median spacing 74.9 m 41. DBSCAN at 100 m (twice the measured spacing) 41.

What it found. The gp_find_point_clusters tool was utilized against the Street light outages layer 13. This analysis successfully identified 420 features 42, classifying 410 of the input data as noise 42. The cluster process was configured with a distance threshold of 100 meters and required a minimum of 10 points 42.

ResultValue
result, count420
result, noise410
result, distance m100
result, elapsed ms5
result, min points10
billing, cost0.0584
billing, list price0.0584
billing, upstream cost0
Clusters: street light outages
Figure 11. Clusters: street light outages 43

What the map shows. The map draws Patrol beats with one symbol 43. The map draws Find point clusters: cluster hulls with one symbol 43. The map draws Find point clusters: Street light outages by cluster_id in 2 classes: Cluster 0, Noise 43. It draws 437 features 43. It covers longitude -87.695 to -87.597 and latitude 41.85 to 41.906, at about 1:33,798 43.

Findings

  • Evidenced: Find point clusters on Street light outages: Find point clusters: 2 layers saved: Find point clusters: Street light outages (420 features); Find point clusters: cluster hulls (1 feature) 1342.
  • Evidenced: It reported result, count 420; result, noise 410; result, distance m 100; result, elapsed ms 5; result, min points 10; billing, cost 0.0584 42.

Tool gp_find_point_clusters; parameters {"method": "dbscan", "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Street light outages (a7218535)"}, "distance_m": 100.0, "min_points": 10}

Summarize within

What this analysis is. Summarize within: Count and aggregate the features inside each polygon (or bin), proportionally for lines and polygons 44. In ArcGIS it is Summarize Within or Aggregate Points; in QGIS, native:countpointsinpolygon or native:sumlinelengths 44.

Why it was run on this data. Count CCTV cameras inside each feature of Patrol beats by ptz; the counts map as a choropleth (natural breaks, sequential colors) 45.

What it found. Summarize within on CCTV cameras, Patrol beats: Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features) 141546. It reported result, count 16; result, elapsed ms 0; billing, cost 0.01154; billing, list price 0.01154; billing, upstream cost 0 46.

ResultValue
result, count16
result, elapsed ms0
billing, cost0.01154
billing, list price0.01154
billing, upstream cost0
Counts: CCTV cameras, by patrol beat
Figure 12. Counts: CCTV cameras, by patrol beat 47

What the map shows. The map draws Summarize within: Patrol beats by count in 5 classes: 1 to 3, 3 to 4, 4 to 5, 5 to 9.5, 9.5 to 13 47. It draws 16 features 47. It covers longitude -87.694 to -87.594 and latitude 41.85 to 41.907, at about 1:34,270 47.

Findings

  • Evidenced: Summarize within on CCTV cameras, Patrol beats: Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features) 141546.
  • Evidenced: It reported result, count 16; result, elapsed ms 0; billing, cost 0.01154; billing, list price 0.01154; billing, upstream cost 0 46.

Tool gp_summarize_within; parameters {"stats": [{"stat": "sum", "field": "installed_year"}], "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "CCTV cameras (ad88aaeb)"}, "group_by": "ptz", "polygons": {"layer": "Patrol beats (8c67e28f)"}}

Summarize within

What this analysis is. Summarize within: Count and aggregate the features inside each polygon (or bin), proportionally for lines and polygons 44. In ArcGIS it is Summarize Within or Aggregate Points; in QGIS, native:countpointsinpolygon or native:sumlinelengths 44.

Why it was run on this data. Count CCTV cameras inside each feature of Patrol beats by ptz; the counts map as a choropleth (natural breaks, sequential colors) 45.

What it found. The analysis used the "Summarize within: Patrol beats" function, which processed 16 features 48.

ResultValue
result, count16
result, elapsed ms0
billing, cost0.01274
billing, list price0.01274
billing, upstream cost0
Counts: licensed premises, by patrol beat
Figure 13. Counts: licensed premises, by patrol beat 49

What the map shows. The map draws Summarize within: Patrol beats by count in 5 classes: 1 to 4, 4 to 7, 7 to 23, 23 to 27, 27 to 31 49. It draws 16 features 49. It covers longitude -87.694 to -87.594 and latitude 41.85 to 41.907, at about 1:34,270 49.

Findings

  • Evidenced: Summarize within on Licensed premises, Patrol beats: Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features) 141748.
  • Evidenced: It reported result, count 16; result, elapsed ms 0; billing, cost 0.01274; billing, list price 0.01274; billing, upstream cost 0 48.

Tool gp_summarize_within; parameters {"stats": [{"stat": "sum", "field": "closing_hour"}], "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Licensed premises (055b5c2c)"}, "group_by": "type", "polygons": {"layer": "Patrol beats (8c67e28f)"}}

Summarize within

What this analysis is. Summarize within: Count and aggregate the features inside each polygon (or bin), proportionally for lines and polygons 44. In ArcGIS it is Summarize Within or Aggregate Points; in QGIS, native:countpointsinpolygon or native:sumlinelengths 44.

Why it was run on this data. Count CCTV cameras inside each feature of Patrol beats by ptz; the counts map as a choropleth (natural breaks, sequential colors) 45.

What it found. Summarize within on Incidents, Patrol beats: Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features) 121450. It reported result, count 16; result, elapsed ms 2; billing, cost 0.04394; billing, list price 0.04394; billing, upstream cost 0 50.

ResultValue
result, count16
result, elapsed ms2
billing, cost0.04394
billing, list price0.04394
billing, upstream cost0
Counts: incidents, by patrol beat
Figure 14. Counts: incidents, by patrol beat 51

What the map shows. The map draws Summarize within: Patrol beats by count in 5 classes: 18 to 53, 53 to 117, 117 to 154, 154 to 304, 304 to 332 51. It draws 16 features 51. It covers longitude -87.694 to -87.594 and latitude 41.85 to 41.907, at about 1:34,270 51.

Findings

  • Evidenced: Summarize within on Incidents, Patrol beats: Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features) 121450.
  • Evidenced: It reported result, count 16; result, elapsed ms 2; billing, cost 0.04394; billing, list price 0.04394; billing, upstream cost 0 50.

Tool gp_summarize_within; parameters {"stats": [{"stat": "sum", "field": "severity"}], "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Incidents (36ad5f7c)"}, "group_by": "category", "polygons": {"layer": "Patrol beats (8c67e28f)"}}

Period change

What this analysis is. Period change: Counts or sums per period (week over week, month over month, any two periods, or before and after a date), per area, per H3 cell or in total, with the places of largest rise and fall and a significance note 52. In ArcGIS it is Summarize Percent Change (Crime Analysis) or Change Point Detection 52.

Why it was run on this data. Incidents carry dates in 'reported_at' over 52 weeks: the count per week, week over week, with the places of largest rise and fall per feature of Patrol beats and whether the change is beyond chance 53.

What it found. Period change on Patrol beats, Incidents produced Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) (16 features) 781214. Incidents: count per week shows a trend of +0.36 per week; the second half of its weeks has 979 against 676 in the first (+44.8%) 55. The chart Incidents: week of 2026-06-22 to week of 2026-06-29 by place is drawn from 30 rows 56. The chart Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) is drawn from 5 rows 57.

Period change: incidents, by patrol beat
Figure 15. Period change: incidents, by patrol beat 54

What the map shows. The map draws Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) by change in 4 classes: < -0.5 Std; Dev, -0.5 to 0.5 Std; Dev, 0.5 to 1.5 Std; Dev, > 1.5 Std; Dev 54. It draws 16 features 54. It covers longitude -87.696 to -87.592 and latitude 41.85 to 41.907, at about 1:35,725 54.

Incidents: count per week
Figure 16. Incidents: count per week 55. Per week, 2025-09-29 to 2026-09-28. Source: Incidents (1,680 features). The data is in the appendix.
Incidents: week of 2026-06-22 to week of 2026-06-29 by place
Figure 17. Incidents: week of 2026-06-22 to week of 2026-06-29 by place 56. Source: Incidents (1,680 features). The data is in the appendix.
Period change: Incidents (week of 2026-06-22 to week of 2026-06-29)
Figure 18. Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) 57. Source: Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) (16 features). The data is in the appendix.

Findings

  • Evidenced: Period change on Patrol beats, Incidents produced Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) (16 features) 781214.
  • Evidenced: Incidents: count per week shows a trend of +0.36 per week; the second half of its weeks has 979 against 676 in the first (+44.8%) 55.
  • Evidenced: The chart Incidents: week of 2026-06-22 to week of 2026-06-29 by place is drawn from 30 rows 56.
  • Evidenced: The chart Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) is drawn from 5 rows 57.

Tool gp_period_change; parameters {"by": "area", "areas": {"layer": "Patrol beats (8c67e28f)"}, "period": "week", "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Incidents (36ad5f7c)"}, "area_field": "name", "time_field": "reported_at"}

Period change

What this analysis is. Period change: Counts or sums per period (week over week, month over month, any two periods, or before and after a date), per area, per H3 cell or in total, with the places of largest rise and fall and a significance note 52. In ArcGIS it is Summarize Percent Change (Crime Analysis) or Change Point Detection 52.

Why it was run on this data. Incidents carry dates in 'reported_at' over 52 weeks: the count per week, week over week, with the places of largest rise and fall per feature of Patrol beats and whether the change is beyond chance 53.

What it found. Period change on Patrol beats, Street light outages produced Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) (7 features) 9101314. Street light outages: count per week shows a trend of -0.0337 per week; the second half of its weeks has 183 against 224 in the first (-18.3%) 59. The chart Street light outages: week of 2026-02-02 to week of 2026-02-09 by place is drawn from 14 rows 60. The chart Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) is drawn from 5 rows 61.

Period change: street light outages, by patrol beat
Figure 19. Period change: street light outages, by patrol beat 58

What the map shows. The map draws Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) by change in 4 classes: < -1.5 Std; Dev, -1.5 to -0.5 Std; Dev, -0.5 to 0.5 Std; Dev, > 0.5 Std; Dev 58. It draws 7 features 58. It covers longitude -87.7 to -87.597 and latitude 41.85 to 41.907, at about 1:35,479 58.

Street light outages: count per week
Figure 20. Street light outages: count per week 59. Per week, 2025-09-29 to 2026-09-28. Source: Street light outages (420 features). The data is in the appendix.
Street light outages: week of 2026-02-02 to week of 2026-02-09 by place
Figure 21. Street light outages: week of 2026-02-02 to week of 2026-02-09 by place 60. Source: Street light outages (420 features). The data is in the appendix.
Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09)
Figure 22. Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) 61. Source: Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) (7 features). The data is in the appendix.

Findings

  • Evidenced: Period change on Patrol beats, Street light outages produced Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) (7 features) 9101314.
  • Evidenced: Street light outages: count per week shows a trend of -0.0337 per week; the second half of its weeks has 183 against 224 in the first (-18.3%) 59.
  • Evidenced: The chart Street light outages: week of 2026-02-02 to week of 2026-02-09 by place is drawn from 14 rows 60.
  • Evidenced: The chart Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) is drawn from 5 rows 61.

Tool gp_period_change; parameters {"by": "area", "areas": {"layer": "Patrol beats (8c67e28f)"}, "period": "week", "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Street light outages (a7218535)"}, "area_field": "name", "time_field": "reported_at"}

Calculate density

What this analysis is. Calculate density: Kernel density per square kilometer on a grid 62. In ArcGIS it is Calculate Density or Kernel Density; in QGIS, native:heatmapkerneldensityestimation 62.

Why it was run on this data. 120 points in Licensed premises: a density surface shows where they concentrate 63. Measured: Licensed premises are clustered (nearest-neighbor ratio 0.85, z = -3.2), median spacing 121 m 63.

What it found. Calculate density on Licensed premises: Calculate density: 1 layer saved: Calculate density: Licensed premises (164 features) 1764. It reported result, count 164; result, elapsed ms 4; result, bandwidth m 1,000; result, cell size m 500; result, excluded null 0; result, max density per km2 42.62 64.

ResultValue
result, count164
result, elapsed ms4
result, bandwidth m1,000
result, cell size m500
result, excluded null0
result, max density per km242.62
billing, cost0.0524
billing, list price0.0524
billing, upstream cost0
Density: licensed premises
Figure 23. Density: licensed premises 65

What the map shows. The map draws Calculate density: Licensed premises by density_per_km2 in 6 classes: 1.26 to 2.87, 2.87 to 5.35, 5.35 to 15.5, 15.5 to 25.5, 25.5 to 35.5, 35.5 to 42.6 65. The map draws Patrol beats with one symbol 65. It draws 180 features 65. It covers longitude -87.716 to -87.577 and latitude 41.839 to 41.918, at about 1:47,798 65.

Findings

  • Evidenced: Calculate density on Licensed premises: Calculate density: 1 layer saved: Calculate density: Licensed premises (164 features) 1764.
  • Evidenced: It reported result, count 164; result, elapsed ms 4; result, bandwidth m 1,000; result, cell size m 500; result, excluded null 0; result, max density per km2 42.62 64.

Tool gp_calculate_density; parameters {"kernel": "quartic", "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Licensed premises (055b5c2c)"}, "bandwidth_m": 1000.0, "cell_size_m": 500.0}

Calculate density

What this analysis is. Calculate density: Kernel density per square kilometer on a grid 62. In ArcGIS it is Calculate Density or Kernel Density; in QGIS, native:heatmapkerneldensityestimation 62.

Why it was run on this data. 1680 points in Incidents: a density surface shows where they concentrate 66. Measured: Incidents are clustered (nearest-neighbor ratio 0.73, z = -21.0), median spacing 34.3 m 66.

What it found. Calculate density on Incidents: Calculate density: 1 layer saved: Calculate density: Incidents (2874 features) 1267. It reported result, count 2,874; result, elapsed ms 50; result, bandwidth m 200; result, cell size m 100; result, excluded null 0; result, max density per km2 1,347 67.

ResultValue
result, count2,874
result, elapsed ms50
result, bandwidth m200
result, cell size m100
result, excluded null0
result, max density per km21,347
billing, cost0.0836
billing, list price0.0836
billing, upstream cost0
Density: incidents
Figure 24. Density: incidents 68

What the map shows. The map draws Calculate density: Incidents by density_per_km2 in 6 classes: 38.9 to 95.2, 95.2 to 203, 203 to 404, 404 to 714, 714 to 1,139, 1,139 to 1,347 68. The map draws Patrol beats with one symbol 68. It draws 2,890 features 68. It covers longitude -87.697 to -87.591 and latitude 41.848 to 41.909, at about 1:36,730 68.

Findings

  • Evidenced: Calculate density on Incidents: Calculate density: 1 layer saved: Calculate density: Incidents (2874 features) 1267.
  • Evidenced: It reported result, count 2,874; result, elapsed ms 50; result, bandwidth m 200; result, cell size m 100; result, excluded null 0; result, max density per km2 1,347 67.

Tool gp_calculate_density; parameters {"kernel": "quartic", "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Incidents (36ad5f7c)"}, "bandwidth_m": 200.0, "cell_size_m": 100.0}

Calculate density

What this analysis is. Calculate density: Kernel density per square kilometer on a grid 62. In ArcGIS it is Calculate Density or Kernel Density; in QGIS, native:heatmapkerneldensityestimation 62.

Why it was run on this data. 420 points in Street light outages: a density surface shows where they concentrate 69. Measured: Street light outages are clustered (nearest-neighbor ratio 0.88, z = -4.9), median spacing 74.9 m 69.

What it found. Calculate density on Street light outages: Calculate density: 1 layer saved: Calculate density: Street light outages (848 features) 1370. It reported result, count 848; result, elapsed ms 15; result, bandwidth m 500; result, cell size m 200; result, excluded null 0; result, max density per km2 107.5 70.

ResultValue
result, count848
result, elapsed ms15
result, bandwidth m500
result, cell size m200
result, excluded null0
result, max density per km2107.5
billing, cost0.0584
billing, list price0.0584
billing, upstream cost0
Density: street light outages
Figure 25. Density: street light outages 71

What the map shows. The map draws Calculate density: Street light outages by density_per_km2 in 6 classes: 4.4 to 10, 10 to 20.1, 20.1 to 37.8, 37.8 to 56.8, 56.8 to 80.7, 80.7 to 108 71. The map draws Patrol beats with one symbol 71. The map draws Dense areas of street light outages with one symbol 71. It draws 869 features 71. It covers longitude -87.706 to -87.588 and latitude 41.845 to 41.912, at about 1:40,754 71.

Findings

  • Evidenced: Calculate density on Street light outages: Calculate density: 1 layer saved: Calculate density: Street light outages (848 features) 1370.
  • Evidenced: It reported result, count 848; result, elapsed ms 15; result, bandwidth m 500; result, cell size m 200; result, excluded null 0; result, max density per km2 107.5 70.

Tool gp_calculate_density; parameters {"kernel": "quartic", "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Street light outages (a7218535)"}, "bandwidth_m": 500.0, "cell_size_m": 200.0}

Hot spots

What this analysis is. Hot spot analysis: Getis-Ord Gi* hot and cold spots with z-scores, p-values and confidence bins 20. In ArcGIS it is Find Hot Spots or Hot Spot Analysis (Getis-Ord Gi*); in QGIS, qgis:hotspot (plugin) 20.

Why it was run on this data. 1680 points: Getis-Ord Gi* tests whether the concentrations in Incidents are statistically significant 72. Measured: Incidents are clustered (nearest-neighbor ratio 0.73, z = -21.0), median spacing 34.3 m 72. Cells of 100 m and a band of 200 m from the measured spacing 72.

What it found. Hot spots on Incidents: Hot spot analysis: 1 layer saved: Hot spot analysis: Incidents (2912 features) 1273. It reported result, bins 2,912; result, count 2,912; result, elapsed ms 100; result, cell size m 100; result, incidents used 1,680; result, distance band m 200 73.

ResultValue
result, bins2,912
result, count2,912
result, elapsed ms100
result, cell size m100
result, incidents used1,680
result, distance band m200
billing, cost0.0836
billing, list price0.0836
billing, upstream cost0
Hot spots: incidents
Figure 26. Hot spots: incidents 74

What the map shows. The map draws Hot spot analysis: Incidents by gi_bin in 7 classes: Hot spot - 99% confidence, Hot spot - 95% confidence, Hot spot - 90% confidence, Not significant, Cold spot - 90% confidence, Cold spot - 95% confidence and 1 more 74. The map draws Patrol beats with one symbol 74. It draws 2,928 features 74. It covers longitude -87.695 to -87.593 and latitude 41.849 to 41.907, at about 1:35,233 74.

Findings

  • Evidenced: Hot spots on Incidents: Hot spot analysis: 1 layer saved: Hot spot analysis: Incidents (2912 features) 1273.
  • Evidenced: It reported result, bins 2,912; result, count 2,912; result, elapsed ms 100; result, cell size m 100; result, incidents used 1,680; result, distance band m 200 73.

Tool gp_hot_spots; parameters {"project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Incidents (36ad5f7c)"}, "aggregation": "hexagon", "cell_size_m": 100.0, "distance_band_m": 200.0}

Near repeat

What this analysis is. Repeat and near repeat classification: Classify incidents as originators, repeats (same place) or near repeats within a distance and time window, with a Knox test table 75. In ArcGIS it is Repeat and Near Repeat Classification or Near Repeat Calculator 75.

Why it was run on this data. Near repeat analysis tests whether Incidents close in space also follow each other within 30 days 76.

What it found. The gp\_near\_repeat tool processed the Incidents data 12 and generated results covering 30 days 77. The tool identified 1,680 results 77, involving 152 chains 77. This analysis calculated pairs linked involving 1,357 pairs 77 over a distance of 100 m 77. The total cost for this process was 0.1004 77.

ResultValue
result, days30
result, count1,680
result, chains152
result, distance m100
result, elapsed ms39
result, pairs linked1,357
billing, cost0.1004
billing, list price0.1004
billing, upstream cost0
Near repeat: incidents
Figure 27. Near repeat: incidents 78

What the map shows. The map draws Repeat and near repeat classification: Incidents by nr_class in 4 classes: Originator, Repeat, Near repeat, Isolated 78. It draws 1,680 features 78. It covers longitude -87.695 to -87.593 and latitude 41.85 to 41.907, at about 1:35,233 78.

Findings

  • Evidenced: Near repeat on Incidents: Repeat and near repeat classification: 1 layer saved: Repeat and near repeat classification: Incidents (1680 features) 1277.
  • Evidenced: It reported result, days 30; result, count 1,680; result, chains 152; result, distance m 100; result, elapsed ms 39; result, pairs linked 1,357 77.

Tool gp_near_repeat; parameters {"days": 30, "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Incidents (36ad5f7c)"}, "distance_m": 100.0, "time_field": "reported_at"}

What follows from the results

Hot cells inside each cluster of licensed premises, from Hot spot analysis: Incidents and Find point clusters: cluster hulls: 1 of 3 clusters hold hot spot cells; cluster 0 holds the most (53) 797336. Change beside the counts per patrol beat, from Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) and Summarize within: Patrol beats: the busiest area, Market West Beat (332 in all), changed by +9 87750. Change of incidents where density is high, from Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) and Calculate density: Street light outages: the largest rise (+9, Market West Beat) is where density averages 58.82 per square kilometer 92770. Hot cells of CCTV cameras per patrol beat, from Hot spot analysis: CCTV cameras: 9 of 16 areas hold hot spot cells; Southgate Beat holds the most (5) 9722. Nearest police station to each cluster of licensed premises, from Find point clusters: cluster hulls: the 3 clusters lie 836 to 972 m from the nearest facility (Central District Station and others) 10336. Dense areas of street light outages, from Calculate density: Street light outages: the densest of five classes joins 170 cells into one area 10970. Change of street light outages per patrol beat, from Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09): Parkview Beat rose the most (+2) and Market West Beat fell the most (-7) 1129.

Findings

  • Evidenced: Hot cells inside each cluster of licensed premises, from Hot spot analysis: Incidents and Find point clusters: cluster hulls: 1 of 3 clusters hold hot spot cells; cluster 0 holds the most (53) 797336.
  • Evidenced: Change beside the counts per patrol beat, from Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) and Summarize within: Patrol beats: the busiest area, Market West Beat (332 in all), changed by +9 87750.
  • Evidenced: Change of incidents where density is high, from Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) and Calculate density: Street light outages: the largest rise (+9, Market West Beat) is where density averages 58.82 per square kilometer 92770.
  • Evidenced: Hot cells of CCTV cameras per patrol beat, from Hot spot analysis: CCTV cameras: 9 of 16 areas hold hot spot cells; Southgate Beat holds the most (5) 9722.
  • Evidenced: Nearest police station to each cluster of licensed premises, from Find point clusters: cluster hulls: the 3 clusters lie 836 to 972 m from the nearest facility (Central District Station and others) 10336.
  • Evidenced: Dense areas of street light outages, from Calculate density: Street light outages: the densest of five classes joins 170 cells into one area 10970.
  • Evidenced: Change of street light outages per patrol beat, from Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09): Parkview Beat rose the most (+2) and Market West Beat fell the most (-7) 1129.

Hot cells inside each cluster of licensed premises

What this analysis is. Summarize within: Count and aggregate the features inside each polygon (or bin), proportionally for lines and polygons 44. In ArcGIS it is Summarize Within or Aggregate Points; in QGIS, native:countpointsinpolygon or native:sumlinelengths 44.

Why it was run on this data. Count CCTV cameras inside each feature of Patrol beats by ptz; the counts map as a choropleth (natural breaks, sequential colors) 45.

What it found. The gp_summarize_within analysis saved one layer called Hot cells inside each cluster of licensed premises with 3 features 79.

ResultValue
result, count3
result, elapsed ms6
billing, cost0.0683
billing, list price0.0683
billing, upstream cost0
Hot cells inside each cluster of licensed premises
Figure 28. Hot cells inside each cluster of licensed premises 83

What the map shows. The map draws Hot cells inside each cluster of licensed premises by count in 2 classes: 2 to 5, 5 to 86 83. The map draws Patrol beats with one symbol 83. It draws 19 features 83. It covers longitude -87.667 to -87.631 and latitude 41.875 to 41.896, at about 1:12,455 83.

Hot cells inside each cluster of licensed premises
Figure 29. Hot cells inside each cluster of licensed premises 84. Source: Hot cells inside each cluster of licensed premises (3 features). The data is in the appendix.

Findings

  • Evidenced: Summarize within on Hot spot analysis: Incidents, Find point clusters: cluster hulls produced Hot cells inside each cluster of licensed premises (3 features) 79808182.
  • Evidenced: It reported result, count 3; result, elapsed ms 6; billing, cost 0.0683; billing, list price 0.0683; billing, upstream cost 0 79.
  • Evidenced: The chart Hot cells inside each cluster of licensed premises is drawn from 3 rows 84.

Tool gp_summarize_within; parameters {"project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Hot spot analysis: Incidents (8382f930)"}, "group_by": "gi_bin", "polygons": {"layer": "Find point clusters: cluster hulls (4dfef6fb)"}, "output_name": "Hot cells inside each cluster of licensed premises"}

Change beside the counts per patrol beat

What this analysis is. Spatial join: Attach attributes (or aggregates) of matching features from another layer, by location, distance, time and attributes 85. In ArcGIS it is Join Features or Spatial Join; in QGIS, native:joinattributesbylocation or native:joinbylocationsummary 85.

Why it was run on this data. It was run toward the goal "Describe the project Sample: Public safety, Chicago: run the analyses that tell the most about its data, draw every result, and write a cited report" 86.

What it found. Spatial join on Summarize within: Patrol beats, Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) produced Change beside the counts per patrol beat (16 features) 8878889. It reported result, count 16; result, elapsed ms 1; billing, cost 0.01066; billing, list price 0.01066; billing, upstream cost 0 87. The chart Change beside the counts per patrol beat is drawn from 5 rows 91.

ResultValue
result, count16
result, elapsed ms1
billing, cost0.01066
billing, list price0.01066
billing, upstream cost0
Change beside the counts per patrol beat
Figure 30. Change beside the counts per patrol beat 90

What the map shows. The map draws Change beside the counts per patrol beat by count in 5 classes: 18 to 53, 53 to 117, 117 to 154, 154 to 304, 304 to 332 90. It draws 16 features 90. It covers longitude -87.694 to -87.594 and latitude 41.85 to 41.907, at about 1:34,270 90.

Change beside the counts per patrol beat
Figure 31. Change beside the counts per patrol beat 91. Source: Change beside the counts per patrol beat (16 features). The data is in the appendix.

Findings

  • Evidenced: Spatial join on Summarize within: Patrol beats, Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) produced Change beside the counts per patrol beat (16 features) 8878889.
  • Evidenced: It reported result, count 16; result, elapsed ms 1; billing, cost 0.01066; billing, list price 0.01066; billing, upstream cost 0 87.
  • Evidenced: The chart Change beside the counts per patrol beat is drawn from 5 rows 91.

Tool gp_spatial_join; parameters {"join": {"layer": "Summarize within: Patrol beats (31bedf68)"}, "fields": ["count"], "target": {"layer": "Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) (1e0726ac)"}, "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "predicate": "largest_overlap", "output_name": "Change beside the counts per patrol beat"}

Change of incidents where density is high

What this analysis is. Spatial join: Attach attributes (or aggregates) of matching features from another layer, by location, distance, time and attributes 85. In ArcGIS it is Join Features or Spatial Join; in QGIS, native:joinattributesbylocation or native:joinbylocationsummary 85.

Why it was run on this data. It was run toward the goal "Describe the project Sample: Public safety, Chicago: run the analyses that tell the most about its data, draw every result, and write a cited report" 86.

What it found. The spatial join utilized the Period change: Incidents data 8 and calculated density data from Street light outages 93.

ResultValue
result, count16
result, elapsed ms1
billing, cost0.0273
billing, list price0.0273
billing, upstream cost0
Change of incidents where density is high
Figure 32. Change of incidents where density is high 95

What the map shows. The map draws Change of incidents where density is high by join_count in 5 classes: 38 to 46, 46 to 57, 57 to 75, 75 to 90, 90 to 94 95. It draws 16 features 95. It covers longitude -87.694 to -87.594 and latitude 41.85 to 41.907, at about 1:34,270 95.

Change of incidents where density is high
Figure 33. Change of incidents where density is high 96. Source: Change of incidents where density is high (16 features). The data is in the appendix.

Findings

  • Evidenced: Spatial join on Calculate density: Street light outages, Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) produced Change of incidents where density is high (16 features) 8929394.
  • Evidenced: It reported result, count 16; result, elapsed ms 1; billing, cost 0.0273; billing, list price 0.0273; billing, upstream cost 0 92.
  • Evidenced: The chart Change of incidents where density is high is drawn from 5 rows 96.

Tool gp_spatial_join; parameters {"join": {"layer": "Calculate density: Street light outages (22316e02)"}, "stats": [{"agg": "mean", "field": "density_per_km2"}], "target": {"layer": "Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) (1e0726ac)"}, "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "predicate": "intersects", "output_name": "Change of incidents where density is high"}

Hot cells of CCTV cameras per patrol beat

What this analysis is. Summarize within: Count and aggregate the features inside each polygon (or bin), proportionally for lines and polygons 44. In ArcGIS it is Summarize Within or Aggregate Points; in QGIS, native:countpointsinpolygon or native:sumlinelengths 44.

Why it was run on this data. Count CCTV cameras inside each feature of Patrol beats by ptz; the counts map as a choropleth (natural breaks, sequential colors) 45.

What it found. Summarize within on Hot spot analysis: CCTV cameras, Patrol beats produced Hot cells of CCTV cameras per patrol beat (16 features) 14979899. It reported result, count 16; result, elapsed ms 2; billing, cost 0.01104; billing, list price 0.01104; billing, upstream cost 0 97. The chart Hot cells of CCTV cameras per patrol beat is drawn from 5 rows 101.

ResultValue
result, count16
result, elapsed ms2
billing, cost0.01104
billing, list price0.01104
billing, upstream cost0
Hot cells of CCTV cameras per patrol beat
Figure 34. Hot cells of CCTV cameras per patrol beat 100

What the map shows. The map draws Hot cells of CCTV cameras per patrol beat by count in 4 classes: 2 to 4, 4 to 5, 5 to 6, 6 to 7 100. It draws 16 features 100. It covers longitude -87.694 to -87.594 and latitude 41.85 to 41.907, at about 1:34,270 100.

Hot cells of CCTV cameras per patrol beat
Figure 35. Hot cells of CCTV cameras per patrol beat 101. Source: Hot cells of CCTV cameras per patrol beat (16 features). The data is in the appendix.

Findings

  • Evidenced: Summarize within on Hot spot analysis: CCTV cameras, Patrol beats produced Hot cells of CCTV cameras per patrol beat (16 features) 14979899.
  • Evidenced: It reported result, count 16; result, elapsed ms 2; billing, cost 0.01104; billing, list price 0.01104; billing, upstream cost 0 97.
  • Evidenced: The chart Hot cells of CCTV cameras per patrol beat is drawn from 5 rows 101.

Tool gp_summarize_within; parameters {"project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Hot spot analysis: CCTV cameras (2cc32b98)"}, "group_by": "gi_bin", "polygons": {"layer": "Patrol beats (8c67e28f)"}, "output_name": "Hot cells of CCTV cameras per patrol beat"}

Nearest police station to each cluster of licensed premises

What this analysis is. Find nearest: The k nearest features for each input, with geodesic distance and bearing 102. In ArcGIS it is Find Nearest or Near; in QGIS, native:joinbynearest or native:nearestneighbouranalysis 102.

Why it was run on this data. It was run toward the goal "Describe the project Sample: Public safety, Chicago: run the analyses that tell the most about its data, draw every result, and write a cited report" 86.

What it found. Find nearest on Police stations, Find point clusters: cluster hulls produced Nearest police station to each cluster of licensed premises (3 features) 1981103104. It reported result, count 3; result, elapsed ms 3; billing, cost 0.01012; billing, list price 0.01012; billing, upstream cost 0 103. The chart Nearest police station to each cluster of licensed premises is drawn from 3 rows 106.

ResultValue
result, count3
result, elapsed ms3
billing, cost0.01012
billing, list price0.01012
billing, upstream cost0
Nearest police station to each cluster of licensed premises
Figure 36. Nearest police station to each cluster of licensed premises 105

What the map shows. The map draws Nearest police station to each cluster of licensed premises by distance_m in 2 classes: 836 to 881, 881 to 972 105. The map draws Patrol beats with one symbol 105. It draws 19 features 105. It covers longitude -87.667 to -87.631 and latitude 41.875 to 41.896, at about 1:12,455 105.

Nearest police station to each cluster of licensed premises
Figure 37. Nearest police station to each cluster of licensed premises 106. Source: Nearest police station to each cluster of licensed premises (3 features). The data is in the appendix.

Findings

  • Evidenced: Find nearest on Police stations, Find point clusters: cluster hulls produced Nearest police station to each cluster of licensed premises (3 features) 1981103104.
  • Evidenced: It reported result, count 3; result, elapsed ms 3; billing, cost 0.01012; billing, list price 0.01012; billing, upstream cost 0 103.
  • Evidenced: The chart Nearest police station to each cluster of licensed premises is drawn from 3 rows 106.

Tool gp_find_nearest; parameters {"k": 1, "to": {"layer": "Police stations (6b7fdf5e)"}, "from": {"layer": "Find point clusters: cluster hulls (4dfef6fb)"}, "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "output_name": "Nearest police station to each cluster of licensed premises"}

Dense areas of street light outages

What this analysis is. Pipeline: Run up to 20 GIS operations in one engine call; a step's params may use "$id" (an earlier step's result) or "$id.key", and layer references 107. Every step's map outputs are saved as styled layers 107.

Why it was run on this data. Patrol beats holds population in 'population': CCTV cameras per 10,000 people in each feature compares features of different size; mapped as a choropleth (natural breaks, sequential colors) 108.

What it found. Pipeline on Calculate density: Street light outages produced Dense areas of street light outages (5 features) 93109110. It reported result, count 5; result, elapsed ms 13; billing, cost 0.03697; billing, list price 0.03697; billing, upstream cost 0; list price 0.03697 109. The chart Dense areas of street light outages is drawn from 5 rows 111.

ResultValue
result, count5
result, elapsed ms13
billing, cost0.03697
billing, list price0.03697
billing, upstream cost0
list price0.03697

What the map shows. Drawn with calculate density on the map Density: street light outages 71.

Dense areas of street light outages
Figure 38. Dense areas of street light outages 111. Source: Dense areas of street light outages (5 features). The data is in the appendix.

Findings

  • Evidenced: Pipeline on Calculate density: Street light outages produced Dense areas of street light outages (5 features) 93109110.
  • Evidenced: It reported result, count 5; result, elapsed ms 13; billing, cost 0.03697; billing, list price 0.03697; billing, upstream cost 0; list price 0.03697 109.
  • Evidenced: The chart Dense areas of street light outages is drawn from 5 rows 111.

*Tool gp_pipeline; parameters {"save": "final", "steps": [{"id": "classes", "params": {"field": "density_per_km2", "method": "quantile", "classes": 5, "features": {"layer": "Calculate density: Street light outages (22316e02)"}}, "operation": "classify_field"}, {"id": "areas", "params": {"by": ["class"], "features": "$classes"}, "operation": "dissolve"}], "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "output_name": "Dense *

Change of street light outages per patrol beat

What this analysis is. Summarize within: Count and aggregate the features inside each polygon (or bin), proportionally for lines and polygons 44. In ArcGIS it is Summarize Within or Aggregate Points; in QGIS, native:countpointsinpolygon or native:sumlinelengths 44.

Why it was run on this data. Count CCTV cameras inside each feature of Patrol beats by ptz; the counts map as a choropleth (natural breaks, sequential colors) 45.

What it found. Summarize within on Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09), Patrol beats produced Change of street light outages per patrol beat (16 features) 1014112113. It reported result, count 16; result, elapsed ms 1; billing, cost 0.01048; billing, list price 0.01048; billing, upstream cost 0 112. The chart Change of street light outages per patrol beat is drawn from 5 rows 115.

ResultValue
result, count16
result, elapsed ms1
billing, cost0.01048
billing, list price0.01048
billing, upstream cost0
Change of street light outages per patrol beat
Figure 39. Change of street light outages per patrol beat 114

What the map shows. The map draws Change of street light outages per patrol beat by sum_change in 4 classes: -7 to -3, -3 to -2, -2 to -1, -1 to 2 114. It draws 16 features 114. It covers longitude -87.694 to -87.594 and latitude 41.85 to 41.907, at about 1:34,270 114.

Change of street light outages per patrol beat
Figure 40. Change of street light outages per patrol beat 115. Source: Change of street light outages per patrol beat (16 features). The data is in the appendix.

Findings

  • Evidenced: Summarize within on Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09), Patrol beats produced Change of street light outages per patrol beat (16 features) 1014112113.
  • Evidenced: It reported result, count 16; result, elapsed ms 1; billing, cost 0.01048; billing, list price 0.01048; billing, upstream cost 0 112.
  • Evidenced: The chart Change of street light outages per patrol beat is drawn from 5 rows 115.

Tool gp_summarize_within; parameters {"stats": [{"agg": "sum", "field": "change"}], "project": "fe9df6b9-8a15-4264-946b-4b37b8dbb89d", "features": {"layer": "Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) (b942fd09)"}, "polygons": {"layer": "Patrol beats (8c67e28f)"}, "output_name": "Change of street light outages per patrol beat"}

Maps and charts

The run also made 25 chart(s) 116117118119120121122123124125126127128129130131132133134135136137138139140.

Incidents over time (reported_at)
Figure 41. Incidents over time (reported_at) 116. Per week, 2025-09-29 to 2026-09-28. Source: Incidents (1,680 features). The data is in the appendix.
Street light outages over time (reported_at)
Figure 42. Street light outages over time (reported_at) 117. Per week, 2025-09-29 to 2026-09-28. Source: Street light outages (420 features). The data is in the appendix.
CCTV cameras over time (installed_year)
Figure 43. CCTV cameras over time (installed_year) 118. Source: CCTV cameras (60 features). The data is in the appendix.
Calls for service by beat and month over time (month)
Figure 44. Calls for service by beat and month over time (month) 119. Per month, 2024-10-01 to 2026-09-01. Source: Calls for service by beat and month (384 features). The data is in the appendix.
Hot spot analysis: CCTV cameras
Figure 45. Hot spot analysis: CCTV cameras 120. Source: Hot spot analysis: CCTV cameras (36 features). The data is in the appendix.
Hot spot analysis: Licensed premises
Figure 46. Hot spot analysis: Licensed premises 121. Source: Hot spot analysis: Licensed premises (112 features). The data is in the appendix.
Emerging hot spots: Incidents
Figure 47. Emerging hot spots: Incidents 122. Source: Emerging hot spots: Incidents (270 features). The data is in the appendix.
Emerging hot spots: Street light outages
Figure 48. Emerging hot spots: Street light outages 123. Source: Emerging hot spots: Street light outages (47 features). The data is in the appendix.
Find point clusters: Licensed premises
Figure 49. Find point clusters: Licensed premises 124. Source: Find point clusters: Licensed premises (120 features). The data is in the appendix.
Find point clusters: cluster hulls
Figure 50. Find point clusters: cluster hulls 125. Source: Find point clusters: cluster hulls (3 features). The data is in the appendix.
Find point clusters: Incidents
Figure 51. Find point clusters: Incidents 126. Period: 2025-10-01 to 2026-09-30 (reported_at). Source: Find point clusters: Incidents (1,680 features). The data is in the appendix.
Find point clusters: cluster hulls
Figure 52. Find point clusters: cluster hulls 127. Source: Find point clusters: cluster hulls (3 features). The data is in the appendix.
Find point clusters: Street light outages
Figure 53. Find point clusters: Street light outages 128. Period: 2025-10-06 to 2026-10-20 (repaired_on). Source: Find point clusters: Street light outages (420 features). The data is in the appendix.
Find point clusters: cluster hulls
Figure 54. Find point clusters: cluster hulls 129. Source: Find point clusters: cluster hulls (1 features). The data is in the appendix.
Summarize within: Patrol beats
Figure 55. Summarize within: Patrol beats 130. Source: Summarize within: Patrol beats (16 features). The data is in the appendix.
Summarize within: Patrol beats
Figure 56. Summarize within: Patrol beats 131. Source: Summarize within: Patrol beats (16 features). The data is in the appendix.
Summarize within: Patrol beats
Figure 57. Summarize within: Patrol beats 132. Source: Summarize within: Patrol beats (16 features). The data is in the appendix.
Calculate density: Licensed premises
Figure 58. Calculate density: Licensed premises 133. Source: Calculate density: Licensed premises (164 features). The data is in the appendix.
Calculate density: Incidents
Figure 59. Calculate density: Incidents 134. Source: Calculate density: Incidents (2,874 features). The data is in the appendix.
Calculate density: Street light outages
Figure 60. Calculate density: Street light outages 135. Source: Calculate density: Street light outages (848 features). The data is in the appendix.
Hot spot analysis: Incidents
Figure 61. Hot spot analysis: Incidents 136. Source: Hot spot analysis: Incidents (2,912 features). The data is in the appendix.
Repeat and near repeat classification: Incidents
Figure 62. Repeat and near repeat classification: Incidents 137. Per week, 2025-09-29 to 2026-09-28. Source: Repeat and near repeat classification: Incidents (1,680 features). The data is in the appendix.
Repeat and near repeat classification: Incidents over time
Figure 63. Repeat and near repeat classification: Incidents over time 138. Per week, 2025-09-29 to 2026-09-28. Source: Repeat and near repeat classification: Incidents (1,680 features). The data is in the appendix.
Find point clusters: Street light outages over time
Figure 64. Find point clusters: Street light outages over time 139. Per month, 2025-10-01 to 2026-10-01. Source: Find point clusters: Street light outages (420 features). The data is in the appendix.
Find point clusters: Incidents over time
Figure 65. Find point clusters: Incidents over time 140. Per week, 2025-09-29 to 2026-09-28. Source: Find point clusters: Incidents (1,680 features). The data is in the appendix.

Documents

What the documents name. Quarterly crime and safety briefing, third quarter 2026 (1 page, 1 page(s) from the text layer) names 12 event terms and 11 places 141. Event terms in Quarterly crime and safety briefing, third quarter 2026: Thefts (page 1, line 7, 2 mentions), Transit (page 1, line 7, 2 mentions), street (page 1, line 9, 2 mentions), demonstration (page 1, line 3) 142. Places named in Quarterly crime and safety briefing, third quarter 2026: Central Transit Center (page 1, line 7, 2 mentions), Market West Beat (page 1, line 9, 2 mentions), N Elizabeth St (page 1, line 11, 2 mentions), Kingsway Beat (page 1, line 11, 2 mentions) 142. Hot spot patrol plan (1 page, 1 page(s) from the text layer) names 1 organization, 8 event terms and 6 places 143. Organizations named in Hot spot patrol plan: Focus (page 1, line 7) 144. Event terms in Hot spot patrol plan: theft (page 1, line 11, 2 mentions), patrol (page 1, line 1), Patrols (page 1, line 3), Transit (page 1, line 8) 144. Places named in Hot spot patrol plan: Central District Station (page 1, line 3), Westside Station (page 1, line 3), Riverside Station (page 1, line 3), Central Transit Center (page 1, line 8) 144.

ResultValue
Documents2
Entities38
Organizations1
Event terms20
Places17

Findings

  • Evidenced: Quarterly crime and safety briefing, third quarter 2026 (1 page, 1 page(s) from the text layer) names 12 event terms and 11 places.
  • Evidenced: Event terms in Quarterly crime and safety briefing, third quarter 2026: Thefts (page 1, line 7, 2 mentions), Transit (page 1, line 7, 2 mentions), street (page 1, line 9, 2 mentions), demonstration (page 1, line 3).
  • Evidenced: Places named in Quarterly crime and safety briefing, third quarter 2026: Central Transit Center (page 1, line 7, 2 mentions), Market West Beat (page 1, line 9, 2 mentions), N Elizabeth St (page 1, line 11, 2 mentions), Kingsway Beat (page 1, line 11, 2 mentions).
  • Evidenced: Hot spot patrol plan (1 page, 1 page(s) from the text layer) names 1 organization, 8 event terms and 6 places.
  • Evidenced: Organizations named in Hot spot patrol plan: Focus (page 1, line 7).
  • Evidenced: Event terms in Hot spot patrol plan: theft (page 1, line 11, 2 mentions), patrol (page 1, line 1), Patrols (page 1, line 3), Transit (page 1, line 8).
  • Evidenced: Places named in Hot spot patrol plan: Central District Station (page 1, line 3), Westside Station (page 1, line 3), Riverside Station (page 1, line 3), Central Transit Center (page 1, line 8).

Changes since the last run

94 number(s) changed since the report of 2026-10-19T04:03:32Z.

AnalysisMeasureBeforeAfterChange
Hot spotsresult, bins35361
Hot spotsresult, count35361
Hot spotsresult, elapsed ms231
Hot spotsresult, incidents used8060-20
Hot spotsresult, distance band m1,0002,0001,000
Hot spotsbilling, cost0.05160.0512-0.0004
Hot spotsbilling, list price0.05160.0512-0.0004
Hot spotsresult, bins3511277
Hot spotsresult, count3511277
Hot spotsresult, elapsed ms253
Hot spotsresult, cell size m1,000500-500
Hot spotsresult, incidents used8012040
Hot spotsbilling, cost0.05160.05240.0008
Hot spotsbilling, list price0.05160.05240.0008
Space time hot spotsresult, elapsed ms44462
Space time hot spotsresult, count27047-223
Space time hot spotsresult, elapsed ms4410-34
Space time hot spotsresult, resolution98-1
Space time hot spotsresult, features used1,680420-1,260
Space time hot spotsbilling, cost0.1840.121-0.063
Space time hot spotsbilling, list price0.1840.121-0.063
Find point clustersresult, count1,680120-1,560
Find point clustersresult, noise1,60961-1,548
Find point clustersresult, distance m50200150
Find point clustersresult, elapsed ms118499381
Find point clustersresult, min points203-17
Find point clustersbilling, cost0.08360.0524-0.0312
Find point clustersbilling, list price0.08360.0524-0.0312
Find point clustersresult, elapsed ms11819-99
Find point clustersresult, count1,680420-1,260
Find point clustersresult, noise1,609410-1,199
Find point clustersresult, distance m5010050
Find point clustersresult, elapsed ms1185-113
Find point clustersresult, min points2010-10
Find point clustersbilling, cost0.08360.0584-0.0252
Find point clustersbilling, list price0.08360.0584-0.0252
Summarize withinresult, elapsed ms10-1
Summarize withinbilling, cost0.010480.011540.00106
Summarize withinbilling, list price0.010480.011540.00106
Summarize withinresult, elapsed ms10-1
Summarize withinbilling, cost0.010480.012740.00226
Summarize withinbilling, list price0.010480.012740.00226
Summarize withinresult, elapsed ms121
Summarize withinbilling, cost0.010480.043940.03346
Summarize withinbilling, list price0.010480.043940.03346
Calculate densityresult, count2,874164-2,710
Calculate densityresult, elapsed ms1624-158
Calculate densityresult, bandwidth m2001,000800
Calculate densityresult, cell size m100500400
Calculate densityresult, max density per km21,34742.62-1,305
Calculate densitybilling, cost0.08360.0524-0.0312
Calculate densitybilling, list price0.08360.0524-0.0312
Calculate densityresult, elapsed ms16250-112
Calculate densityresult, count2,874848-2,026
Calculate densityresult, elapsed ms16215-147
Calculate densityresult, bandwidth m200500300
Calculate densityresult, cell size m100200100
Calculate densityresult, max density per km21,347107.5-1,240
Calculate densitybilling, cost0.08360.0584-0.0252
Calculate densitybilling, list price0.08360.0584-0.0252
Hot spotsresult, bins352,9122,877
Hot spotsresult, count352,9122,877
Hot spotsresult, elapsed ms210098
Hot spotsresult, cell size m1,000100-900
Hot spotsresult, incidents used801,6801,600
Hot spotsresult, distance band m1,000200-800
Hot spotsbilling, cost0.05160.08360.032
Hot spotsbilling, list price0.05160.08360.032
Near repeatresult, count4201,6801,260
Near repeatresult, chains5315299
Near repeatresult, distance m200100-100
Near repeatresult, elapsed ms103929
Near repeatresult, pairs linked1851,3571,172
Near repeatbilling, cost0.06260.10040.0378
Near repeatbilling, list price0.06260.10040.0378
Hot cells inside each cluster of licensed premisesresult, count163-13
Hot cells inside each cluster of licensed premisesresult, elapsed ms165
Hot cells inside each cluster of licensed premisesbilling, cost0.010480.06830.05782
Hot cells inside each cluster of licensed premisesbilling, list price0.010480.06830.05782
Change beside the counts per patrol beatbilling, cost0.02730.01066-0.01664
Change beside the counts per patrol beatbilling, list price0.02730.01066-0.01664
Hot cells of CCTV cameras per patrol beatresult, elapsed ms121
Hot cells of CCTV cameras per patrol beatbilling, cost0.010480.011040.00056
Hot cells of CCTV cameras per patrol beatbilling, list price0.010480.011040.00056
Nearest police station to each cluster of licensed premisesresult, elapsed ms231
Dense areas of street light outagesresult, count9365-931
Dense areas of street light outagesresult, elapsed ms2213-9
Dense areas of street light outagesbilling, cost0.1020.03697-0.06503
Dense areas of street light outagesbilling, list price0.1020.03697-0.06503
Dense areas of street light outageslist price0.1020.03697-0.06503
DocumentsDocuments172-15
DocumentsEntities173821
DocumentsOrganizations171-16
DocumentsEvent terms17203

New findings:

  • Change beside the counts per patrol beat, from Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) and Summarize within: Patrol beats: the busiest area, Market West Beat (332 in all), changed by +9 87750.
  • Change of incidents where density is high, from Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) and Calculate density: Street light outages: the largest rise (+9, Market West Beat) is where density averages 58.82 per square kilometer 92770.
  • Change of street light outages per patrol beat, from Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09): Parkview Beat rose the most (+2) and Market West Beat fell the most (-7) 1129.
  • Dense areas of street light outages, from Calculate density: Street light outages: the densest of five classes joins 170 cells into one area 10970.
  • Find nearest on Police stations, Find point clusters: cluster hulls produced Nearest police station to each cluster of licensed premises (3 features).
  • Hot cells inside each cluster of licensed premises, from Hot spot analysis: Incidents and Find point clusters: cluster hulls: 1 of 3 clusters hold hot spot cells; cluster 0 holds the most (53) 797336.
  • Hot cells of CCTV cameras per patrol beat, from Hot spot analysis: CCTV cameras: 9 of 16 areas hold hot spot cells; Southgate Beat holds the most (5) 9722.
  • Hot spots on Incidents: Hot spot analysis: 1 layer saved: Hot spot analysis: Incidents (2912 features).
  • Hot spots on Licensed premises: Hot spot analysis: 1 layer saved: Hot spot analysis: Licensed premises (112 features).
  • It reported result, bins 112; result, count 112; result, elapsed ms 5; result, cell size m 500; result, incidents used 120; result, distance band m 1,000.
  • It reported result, bins 2,912; result, count 2,912; result, elapsed ms 100; result, cell size m 100; result, incidents used 1,680; result, distance band m 200.
  • It reported result, bins 36; result, count 36; result, elapsed ms 3; result, cell size m 1,000; result, incidents used 60; result, distance band m 2,000.
  • It reported result, count 1,680; result, noise 1,609; result, distance m 50; result, elapsed ms 19; result, min points 20; billing, cost 0.0836.
  • It reported result, count 120; result, noise 61; result, distance m 200; result, elapsed ms 499; result, min points 3; billing, cost 0.0524.
  • It reported result, count 164; result, elapsed ms 4; result, bandwidth m 1,000; result, cell size m 500; result, excluded null 0; result, max density per km2 42.62.
  • It reported result, count 16; result, elapsed ms 0; billing, cost 0.01274; billing, list price 0.01274; billing, upstream cost 0.
  • It reported result, count 16; result, elapsed ms 2; billing, cost 0.04394; billing, list price 0.04394; billing, upstream cost 0.
  • It reported result, count 2,874; result, elapsed ms 50; result, bandwidth m 200; result, cell size m 100; result, excluded null 0; result, max density per km2 1,347.
  • It reported result, count 270; result, elapsed ms 46; result, resolution 9; result, features used 1,680; result, time neighbors 0; billing, cost 0.184.
  • It reported result, count 3; result, elapsed ms 3; billing, cost 0.01012; billing, list price 0.01012; billing, upstream cost 0.
  • It reported result, count 3; result, elapsed ms 6; billing, cost 0.0683; billing, list price 0.0683; billing, upstream cost 0.
  • It reported result, count 420; result, noise 410; result, distance m 100; result, elapsed ms 5; result, min points 10; billing, cost 0.0584.
  • It reported result, count 5; result, elapsed ms 13; billing, cost 0.03697; billing, list price 0.03697; billing, upstream cost 0; list price 0.03697.
  • It reported result, count 848; result, elapsed ms 15; result, bandwidth m 500; result, cell size m 200; result, excluded null 0; result, max density per km2 107.5.
  • It reported result, days 30; result, count 1,680; result, chains 152; result, distance m 100; result, elapsed ms 39; result, pairs linked 1,357.
  • Near repeat on Incidents: Repeat and near repeat classification: 1 layer saved: Repeat and near repeat classification: Incidents (1680 features).
  • Nearest police station to each cluster of licensed premises, from Find point clusters: cluster hulls: the 3 clusters lie 836 to 972 m from the nearest facility (Central District Station and others) 10336.
  • Summarize within on Hot spot analysis: Incidents, Find point clusters: cluster hulls produced Hot cells inside each cluster of licensed premises (3 features).
  • Summarize within on Incidents, Patrol beats: Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features).
  • Summarize within on Licensed premises, Patrol beats: Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features).
  • The chart Hot cells inside each cluster of licensed premises is drawn from 3 rows.
  • The chart Nearest police station to each cluster of licensed premises is drawn from 3 rows.

Sources

  1. 1Rendering: Chart: Timeline: events per month by dataset. 72 rows id d013059e-6933-47a5-bb09-9a0dc42d4902
  2. 2Dataset: Incidents. vector, 1680 rows id 8e5ad24c-d6a6-4a58-8281-8b363a095f60
  3. 3Dataset: Street light outages. vector, 420 rows id abe096b9-4f2d-4a2c-8093-abb51b141f33
  4. 4Dataset: Calls for service by beat and month. table, 384 rows id 924696a2-7623-45fc-aa81-6181d9eba827
  5. 5Rendering: Chart: Timeline lanes: events per month by dataset. 72 rows id fb1cdee2-f533-45f4-983f-0cd951892613
  6. 6Rendering: Chart: Timeline: change from one month to the next. 23 rows id 2d043b97-3b7e-4081-a3cc-a2d4f2bb2246
  7. 7Tool result: gp_period_change, step 0. The count rose from 33 in week of 2026-06-22 to 72 in week of 2026-06-29 (+118.2%); a change this large is unlikely to be chance (p = 0.000178). id 2042e52a-03d6-42f1-8365-22ab6777dc1e:0
  8. 8Layer: Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) id 1e0726ac-a223-423b-b680-55434fcfa5e6
  9. 9Tool result: gp_period_change, step 1. The count fell from 17 in week of 2026-02-02 to 4 in week of 2026-02-09 (-76.5%); a change this large is unlikely to be chance (p = 0.0072). id 2042e52a-03d6-42f1-8365-22ab6777dc1e:1
  10. 10Layer: Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) id b942fd09-4b01-4ffe-a2ab-c88503e90ef1
  11. 11Rendering: Map: Overview: the top 3 results. view longitude -87.71811 to -87.57468, latitude 41.83798 to 41.91748 id 79e66837-1f85-4f45-956b-0a34bfd5fe00
  12. 12Layer: Incidents. spatial profile id 36ad5f7c-eab7-4ac7-8256-9737c4a1b044
  13. 13Layer: Street light outages. spatial profile id a7218535-327c-4a76-b5d4-8caa09f44155
  14. 14Layer: Patrol beats. spatial profile id 8c67e28f-6678-462f-a450-e83d278138e8
  15. 15Layer: CCTV cameras. spatial profile id ad88aaeb-e7ac-4b9c-aa1c-c4626ae498b8
  16. 16Layer: Transit stops. spatial profile id 313ae694-78aa-4830-955c-22be11a8a8a3
  17. 17Layer: Licensed premises. spatial profile id 055b5c2c-2a86-4379-95be-6f38f708b65b
  18. 18Layer: Roads. spatial profile id f63e5a45-031b-44a5-bf1e-7b9d17cb2378
  19. 19Layer: Police stations. spatial profile id 6b7fdf5e-7de9-4f14-995d-0c918b2e91ec
  20. 20Catalog: Hot spot analysis (operation catalog, gp_hot_spots). Getis-Ord Gi* hot and cold spots with z-scores, p-values and confidence bins. ArcGIS: Find Hot Spots, Hot Spot Analysis (Getis-Ord Gi*). QGIS: qgis:hotspot (plugin). id gp_hot_spots
  21. 21Plan: Hot spots of CCTV cameras (the Start plan's candidate c_f0a51c3ce192). 60 points: Getis-Ord Gi* tests whether the concentrations in CCTV cameras are statistically significant. id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_f0a51c3ce192
  22. 22Tool result: gp_hot_spots, step 0. Hot spot analysis: 1 layer saved: Hot spot analysis: CCTV cameras (36 features). id 321ba186-8b6e-4c4b-bb58-94f915d8b6aa:0
  23. 23Rendering: Map: Hot spots: CCTV cameras. view longitude -87.7152 to -87.57762, latitude 41.83848 to 41.91701 id a5a339e4-5577-4333-9b86-911f2f84f49a
  24. 24Plan: Hot spots of Licensed premises (the Start plan's candidate c_91bb663e526f). 120 points: Getis-Ord Gi* tests whether the concentrations in Licensed premises are statistically significant. Measured: Licensed premises are clustered (nearest-neighbor ratio 0.85, z = -3.2), median spacing 121 m. Cells of 500 m and a band of 1000 m from the measured spacing. id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_91bb663e526f
  25. 25Tool result: gp_hot_spots, step 1. Hot spot analysis: 1 layer saved: Hot spot analysis: Licensed premises (112 features). id 321ba186-8b6e-4c4b-bb58-94f915d8b6aa:1
  26. 26Rendering: Map: Hot spots: licensed premises. view longitude -87.70465 to -87.5929, latitude 41.84743 to 41.91121 id 2145f368-15a9-49e0-ad22-77165edbf2be
  27. 27Catalog: Emerging hot spots (operation catalog, gp_space_time_hot_spots). Where hot spots are new, consecutive, intensifying, persistent, diminishing, sporadic, oscillating or historical over time. ArcGIS: Emerging Hot Spot Analysis, Create Space Time Cube. id gp_space_time_hot_spots
  28. 28Plan: Space time hot spots of Incidents (the Start plan's candidate c_1c60b58dbb29). Incidents carry dates in 'reported_at': emerging hot spot analysis finds new, intensifying and fading hot spots per week. Measured: the pattern of Incidents changes over time (earlier half clustered, later half clustered; the center moved 132 m). id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_1c60b58dbb29
  29. 29Tool result: gp_space_time_hot_spots, step 0. Emerging hot spots: 1 layer saved: Emerging hot spots: Incidents (270 features). id 961133c9-b424-4eba-880c-76b21b589fcb:0
  30. 30Rendering: Map: Emerging hot spots: incidents. view longitude -87.70246 to -87.58676, latitude 41.84569 to 41.90983 id 6f2b1b3c-6588-4aa1-b6cf-4e9a3a111f44
  31. 31Plan: Space time hot spots of Street light outages (the Start plan's candidate c_2469aa67bba0). Street light outages carry dates in 'reported_at': emerging hot spot analysis finds new, intensifying and fading hot spots per week. Measured: the pattern of Street light outages changes over time (earlier half clustered, later half clustered; the center moved 263 m). id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_2469aa67bba0
  32. 32Tool result: gp_space_time_hot_spots, step 1. Emerging hot spots: 1 layer saved: Emerging hot spots: Street light outages (47 features). id 961133c9-b424-4eba-880c-76b21b589fcb:1
  33. 33Rendering: Map: Emerging hot spots: street light outages. view longitude -87.71613 to -87.57759, latitude 41.83894 to 41.91574 id 91191d14-e6a0-40e1-a6fa-dd44826aaf6e
  34. 34Catalog: Find point clusters (operation catalog, gp_find_point_clusters). Density-based clusters (DBSCAN, HDBSCAN or OPTICS, optionally space-time) with hulls and noise. ArcGIS: Find Point Clusters, Density-based Clustering. QGIS: native:dbscanclustering, native:stdbscanclustering. id gp_find_point_clusters
  35. 35Plan: Cluster points of Licensed premises (the Start plan's candidate c_bca1140666e1). DBSCAN finds dense groups of Licensed premises and separates noise. Measured: Licensed premises are clustered (nearest-neighbor ratio 0.85, z = -3.2), median spacing 121 m. DBSCAN at 200 m (twice the measured spacing). id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_bca1140666e1
  36. 36Tool result: gp_find_point_clusters, step 0. Find point clusters: 2 layers saved: Find point clusters: Licensed premises (120 features); Find point clusters: cluster hulls (3 features). id 215b8c93-8d01-4390-b188-f5c767207b46:0
  37. 37Rendering: Map: Clusters: licensed premises. view longitude -87.69497 to -87.59835, latitude 41.85068 to 41.90582 id 2605dc65-0adc-4643-9694-8530ea34521a
  38. 38Plan: Cluster points of Incidents (the Start plan's candidate c_0aed3f12db5c). DBSCAN finds dense groups of Incidents and separates noise. Measured: Incidents are clustered (nearest-neighbor ratio 0.73, z = -21.0), median spacing 34.3 m. DBSCAN at 50 m (twice the measured spacing). id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_0aed3f12db5c
  39. 39Tool result: gp_find_point_clusters, step 1. Find point clusters: 2 layers saved: Find point clusters: Incidents (1680 features); Find point clusters: cluster hulls (3 features). id 215b8c93-8d01-4390-b188-f5c767207b46:1
  40. 40Rendering: Map: Clusters: incidents. view longitude -87.69327 to -87.59462, latitude 41.8503 to 41.9066 id d9cb38e3-2bbf-4bd6-8736-3a3f54e2766c
  41. 41Plan: Cluster points of Street light outages (the Start plan's candidate c_eac5e908317b). DBSCAN finds dense groups of Street light outages and separates noise. Measured: Street light outages are clustered (nearest-neighbor ratio 0.88, z = -4.9), median spacing 74.9 m. DBSCAN at 100 m (twice the measured spacing). id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_eac5e908317b
  42. 42Tool result: gp_find_point_clusters, step 2. Find point clusters: 2 layers saved: Find point clusters: Street light outages (420 features); Find point clusters: cluster hulls (1 feature). id 215b8c93-8d01-4390-b188-f5c767207b46:2
  43. 43Rendering: Map: Clusters: street light outages. view longitude -87.6954 to -87.59744, latitude 41.85029 to 41.9062 id e91b963b-96c8-45a2-9a13-6a160f41445f
  44. 44Catalog: Summarize within (operation catalog, gp_summarize_within). Count and aggregate the features inside each polygon (or bin), proportionally for lines and polygons. ArcGIS: Summarize Within, Aggregate Points. QGIS: native:countpointsinpolygon, native:sumlinelengths. id gp_summarize_within
  45. 45Plan: CCTV cameras per feature of Patrol beats (the Start plan's candidate c_c58f45b29b6e). Count CCTV cameras inside each feature of Patrol beats by ptz; the counts map as a choropleth (natural breaks, sequential colors). id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_c58f45b29b6e
  46. 46Tool result: gp_summarize_within, step 0. Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features). id 5e359a15-f5e2-429c-a252-d2486c76e559:0
  47. 47Rendering: Map: Counts: CCTV cameras, by patrol beat. view longitude -87.69371 to -87.59438, latitude 41.85001 to 41.9067 id 1d6099da-be90-4b9c-9991-ddaea0c2a814
  48. 48Tool result: gp_summarize_within, step 1. Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features). id 5e359a15-f5e2-429c-a252-d2486c76e559:1
  49. 49Rendering: Map: Counts: licensed premises, by patrol beat. view longitude -87.69371 to -87.59438, latitude 41.85001 to 41.9067 id f3ebc560-673b-4e0e-bfeb-f244b6e425c8
  50. 50Tool result: gp_summarize_within, step 2. Summarize within: 1 layer saved: Summarize within: Patrol beats (16 features). id 5e359a15-f5e2-429c-a252-d2486c76e559:2
  51. 51Rendering: Map: Counts: incidents, by patrol beat. view longitude -87.69371 to -87.59438, latitude 41.85001 to 41.9067 id f6217787-f7ba-4030-aa6d-63161fb23a9e
  52. 52Catalog: Period change (analysis catalog, gp_period_change). Counts or sums per period (week over week, month over month, any two periods, or before and after a date), per area, per H3 cell or in total, with the places of largest rise and fall and a significance note. ArcGIS: Summarize Percent Change (Crime Analysis), Change Point Detection. id gp_period_change
  53. 53Plan: Incidents: change per week per feature of Patrol beats (the Start plan's candidate c_55dcc49526ff). Incidents carry dates in 'reported_at' over 52 weeks: the count per week, week over week, with the places of largest rise and fall per feature of Patrol beats and whether the change is beyond chance. id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_55dcc49526ff
  54. 54Rendering: Map: Period change: incidents, by patrol beat. view longitude -87.69576 to -87.59221, latitude 41.8496 to 41.907 id f8fa38e0-6b2b-4027-9d48-4238d9d56b8b
  55. 55Rendering: Chart: Incidents: count per week. 53 rows id 669d11fe-6a6b-4977-827a-e6583fbb9ec8
  56. 56Rendering: Chart: Incidents: week of 2026-06-22 to week of 2026-06-29 by place. 30 rows id d57784f7-9e7d-4cb3-a1b4-5c224a8d2ffd
  57. 57Rendering: Chart: Period change: Incidents (week of 2026-06-22 to week of 2026-06-29). 5 rows id 8f97238b-666e-416b-87f0-c34f89646566
  58. 58Rendering: Map: Period change: street light outages, by patrol beat. view longitude -87.69969 to -87.59686, latitude 41.84969 to 41.90669 id 064b0349-aa03-4072-ac98-9eb86c884bd9
  59. 59Rendering: Chart: Street light outages: count per week. 53 rows id 73202d54-d8bb-4119-8b31-815538262a83
  60. 60Rendering: Chart: Street light outages: week of 2026-02-02 to week of 2026-02-09 by place. 14 rows id 56c46fab-d5ad-44bb-b563-5bba1cc24883
  61. 61Rendering: Chart: Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09). 5 rows id d58ef4fc-c705-4cc6-bbc5-aca3bf3f48b6
  62. 62Catalog: Calculate density (operation catalog, gp_calculate_density). Kernel density per square kilometer on a grid. ArcGIS: Calculate Density, Kernel Density. QGIS: native:heatmapkerneldensityestimation. id gp_calculate_density
  63. 63Plan: Kernel density of Licensed premises (the Start plan's candidate c_2b247b24a505). 120 points in Licensed premises: a density surface shows where they concentrate. Measured: Licensed premises are clustered (nearest-neighbor ratio 0.85, z = -3.2), median spacing 121 m. id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_2b247b24a505
  64. 64Tool result: gp_calculate_density, step 0. Calculate density: 1 layer saved: Calculate density: Licensed premises (164 features). id 8475a7ee-691d-4552-8a24-41bb69bf46a4:0
  65. 65Rendering: Map: Density: licensed premises. view longitude -87.71552 to -87.57698, latitude 41.83894 to 41.91801 id 2d0ffd6b-492c-46b6-9708-edf0e8f348fa
  66. 66Plan: Kernel density of Incidents (the Start plan's candidate c_9007d02c4a41). 1680 points in Incidents: a density surface shows where they concentrate. Measured: Incidents are clustered (nearest-neighbor ratio 0.73, z = -21.0), median spacing 34.3 m. id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_9007d02c4a41
  67. 67Tool result: gp_calculate_density, step 1. Calculate density: 1 layer saved: Calculate density: Incidents (2874 features). id 8475a7ee-691d-4552-8a24-41bb69bf46a4:1
  68. 68Rendering: Map: Density: incidents. view longitude -87.69708 to -87.59062, latitude 41.848 to 41.90876 id 0aa6b6e6-e52d-4399-b08c-8e798eb73c93
  69. 69Plan: Kernel density of Street light outages (the Start plan's candidate c_bd626b9123bb). 420 points in Street light outages: a density surface shows where they concentrate. Measured: Street light outages are clustered (nearest-neighbor ratio 0.88, z = -4.9), median spacing 74.9 m. id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_bd626b9123bb
  70. 70Tool result: gp_calculate_density, step 2. Calculate density: 1 layer saved: Calculate density: Street light outages (848 features). id 8475a7ee-691d-4552-8a24-41bb69bf46a4:2
  71. 71Rendering: Map: Density: street light outages. view longitude -87.70567 to -87.58754, latitude 41.84454 to 41.91196 id 27e532e4-8298-4330-ad1a-0d9375f48b07
  72. 72Plan: Hot spots of Incidents (the Start plan's candidate c_c312b5d076a7). 1680 points: Getis-Ord Gi* tests whether the concentrations in Incidents are statistically significant. Measured: Incidents are clustered (nearest-neighbor ratio 0.73, z = -21.0), median spacing 34.3 m. Cells of 100 m and a band of 200 m from the measured spacing. id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_c312b5d076a7
  73. 73Tool result: gp_hot_spots, step 0. Hot spot analysis: 1 layer saved: Hot spot analysis: Incidents (2912 features). id bc2d155b-8245-44bd-bc02-ae3dd8ce99bd:0
  74. 74Rendering: Map: Hot spots: incidents. view longitude -87.69527 to -87.59314, latitude 41.84909 to 41.90737 id 207cb3df-c55c-401c-8124-cbf80367ad53
  75. 75Catalog: Repeat and near repeat classification (operation catalog, gp_near_repeat). Classify incidents as originators, repeats (same place) or near repeats within a distance and time window, with a Knox test table. ArcGIS: Repeat and Near Repeat Classification, Near Repeat Calculator. id gp_near_repeat
  76. 76Plan: Near repeat of Incidents (the Start plan's candidate c_cabb2c797127). Near repeat analysis tests whether Incidents close in space also follow each other within 30 days. id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_cabb2c797127
  77. 77Tool result: gp_near_repeat, step 0. Repeat and near repeat classification: 1 layer saved: Repeat and near repeat classification: Incidents (1680 features). id e703fd06-1a0c-47e1-8d41-9a7f7ca7a096:0
  78. 78Rendering: Map: Near repeat: incidents. view longitude -87.69493 to -87.59281, latitude 41.85009 to 41.9067 id 28e59ede-c587-4b24-bb28-3230a99a4d59
  79. 79Tool result: gp_summarize_within, step 0. Summarize within: 1 layer saved: Hot cells inside each cluster of licensed premises (3 features). id 47c5f0de-dfdf-494b-911d-90b10a714d4d:0
  80. 80Layer: Hot spot analysis: Incidents. 2,912 features id 8382f930-c9d0-432b-82b7-fabc618137e9
  81. 81Layer: Find point clusters: cluster hulls. 3 features id 4dfef6fb-4663-43a7-86b3-cb7ca742b344
  82. 82Layer: Hot cells inside each cluster of licensed premises. 3 features id ca4b4f64-91e3-4c8b-b95e-1027e417c18a
  83. 83Rendering: Map: Hot cells inside each cluster of licensed premises. view longitude -87.66722 to -87.63111, latitude 41.87536 to 41.89597 id 1f5b237f-456e-4271-ac5a-8b7c49ea1203
  84. 84Rendering: Chart: Hot cells inside each cluster of licensed premises. 3 rows id dc8f6491-2889-4c96-8892-a5a92ddccff9
  85. 85Catalog: Spatial join (operation catalog, gp_spatial_join). Attach attributes (or aggregates) of matching features from another layer, by location, distance, time and attributes. ArcGIS: Join Features, Spatial Join. QGIS: native:joinattributesbylocation, native:joinbylocationsummary, native:joinbynearest. id gp_spatial_join
  86. 86Plan: The run's goal. Describe the project Sample: Public safety, Chicago: run the analyses that tell the most about its data, draw every result, and write a cited report. id 2e6054ca-62f3-479f-b398-915fe26200ce:goal
  87. 87Tool result: gp_spatial_join, step 0. Spatial join: 1 layer saved: Change beside the counts per patrol beat (16 features). id b47bd286-7bf7-47ee-8462-aba2f7f03009:0
  88. 88Layer: Summarize within: Patrol beats. 16 features id 31bedf68-b7b3-41b2-abda-6a464b2f0776
  89. 89Layer: Change beside the counts per patrol beat. 16 features id a982a2d6-956f-4dfe-b821-16eefe49fc59
  90. 90Rendering: Map: Change beside the counts per patrol beat. view longitude -87.69371 to -87.59438, latitude 41.85001 to 41.9067 id 72abfc34-1aa3-41c0-918f-e1038e14d6e4
  91. 91Rendering: Chart: Change beside the counts per patrol beat. 5 rows id 0db6652b-8019-4841-a5c5-bb77cb37c605
  92. 92Tool result: gp_spatial_join, step 0. Spatial join: 1 layer saved: Change of incidents where density is high (16 features). id a507fc16-21fd-45b9-aeb6-d8c679c59bfa:0
  93. 93Layer: Calculate density: Street light outages. 848 features id 22316e02-9759-4f61-b1eb-206b935b14bb
  94. 94Layer: Change of incidents where density is high. 16 features id b18abe82-9e7c-4939-aba0-31147b337e8d
  95. 95Rendering: Map: Change of incidents where density is high. view longitude -87.69371 to -87.59438, latitude 41.85001 to 41.9067 id 4c6d9fb2-ffd0-4f64-8535-c3988767f184
  96. 96Rendering: Chart: Change of incidents where density is high. 5 rows id 92ea2477-a522-47ee-89b1-746ee6856ca5
  97. 97Tool result: gp_summarize_within, step 0. Summarize within: 1 layer saved: Hot cells of CCTV cameras per patrol beat (16 features). id 614dc9e6-1702-4222-aaee-d9710ae1d2fa:0
  98. 98Layer: Hot spot analysis: CCTV cameras. 36 features id 2cc32b98-9097-49ba-8818-944110cdf58f
  99. 99Layer: Hot cells of CCTV cameras per patrol beat. 16 features id d17a96b4-151e-4595-be18-86aaab10e46f
  100. 100Rendering: Map: Hot cells of CCTV cameras per patrol beat. view longitude -87.69371 to -87.59438, latitude 41.85001 to 41.9067 id b8be83a4-10bf-4533-a453-099468da0894
  101. 101Rendering: Chart: Hot cells of CCTV cameras per patrol beat. 5 rows id 35fadd76-8342-4832-bb6b-54b406cc2355
  102. 102Catalog: Find nearest (operation catalog, gp_find_nearest). The k nearest features for each input, with geodesic distance and bearing. ArcGIS: Find Nearest, Near, Generate Near Table. QGIS: native:joinbynearest, native:nearestneighbouranalysis. id gp_find_nearest
  103. 103Tool result: gp_find_nearest, step 0. Find nearest: 1 layer saved: Nearest police station to each cluster of licensed premises (3 features). id c991d762-1f84-44c6-96ae-3710f29ec64c:0
  104. 104Layer: Nearest police station to each cluster of licensed premises. 3 features id e1507503-e9d4-495b-92ae-125ebdaa2cf0
  105. 105Rendering: Map: Nearest police station to each cluster of licensed premises. view longitude -87.66722 to -87.63111, latitude 41.87536 to 41.89597 id 85be50e0-3982-4731-8c0e-823fa9294a88
  106. 106Rendering: Chart: Nearest police station to each cluster of licensed premises. 3 rows id 2dec7314-090d-4c50-abac-7f19aa87b8c3
  107. 107Catalog: Pipeline (tool description, gp_pipeline). Run up to 20 GIS operations in one engine call; a step's params may use "$id" (an earlier step's result) or "$id.key", and layer references. Every step's map outputs are saved as styled layers. Never calls Mapbox. id gp_pipeline
  108. 108Plan: CCTV cameras per 10,000 people per feature of Patrol beats (the Start plan's candidate c_c2ae8a2714b2). Patrol beats holds population in 'population': CCTV cameras per 10,000 people in each feature compares features of different size; mapped as a choropleth (natural breaks, sequential colors). id f922208b-bbd9-4f8c-a605-3fb31853d7fd:c_c2ae8a2714b2
  109. 109Tool result: gp_pipeline, step 0. Pipeline of 2 steps (classify_field > dissolve): 1 layer saved. id 6ca7bfd5-79a6-41c1-bf7d-8e6d94107d57:0
  110. 110Layer: Dense areas of street light outages. 5 features id ac9b6845-0f71-4373-bd6d-610425383c47
  111. 111Rendering: Chart: Dense areas of street light outages. 5 rows id eb14b23d-e657-47db-bbb9-6dc855c8b8cc
  112. 112Tool result: gp_summarize_within, step 0. Summarize within: 1 layer saved: Change of street light outages per patrol beat (16 features). id cc3dd633-eef0-4eb3-8158-2f9fd13fb200:0
  113. 113Layer: Change of street light outages per patrol beat. 16 features id 3aa058c3-6af3-4495-9b14-12531d1ab9a2
  114. 114Rendering: Map: Change of street light outages per patrol beat. view longitude -87.69371 to -87.59438, latitude 41.85001 to 41.9067 id 8c09d493-6848-4496-8154-9e4918bed43f
  115. 115Rendering: Chart: Change of street light outages per patrol beat. 5 rows id f5280b27-6c71-4ddf-ba62-2c3527a68ab7
  116. 116Rendering: Chart: Incidents over time (reported_at). 318 rows id 77127ac6-8e99-4791-97cd-fae719d89262
  117. 117Rendering: Chart: Street light outages over time (reported_at). 212 rows id f9621103-3d0a-49ab-b90b-f7b40f93745b
  118. 118Rendering: Chart: CCTV cameras over time (installed_year). 7 rows id d430a879-effd-4bd0-81f7-baa28a4e5360
  119. 119Rendering: Chart: Calls for service by beat and month over time (month). 24 rows id 7c56f65f-9b6b-4cdd-a312-17f1982d8de0
  120. 120Rendering: Chart: Hot spot analysis: CCTV cameras. 12 rows id 64aa9539-922f-4609-8b9a-6ef06a308a05
  121. 121Rendering: Chart: Hot spot analysis: Licensed premises. 15 rows id 4a5bc439-21a2-432b-9b8c-8615b719b8f0
  122. 122Rendering: Chart: Emerging hot spots: Incidents. 10 rows id 07721714-421e-4a56-9250-c62be37e8e3e
  123. 123Rendering: Chart: Emerging hot spots: Street light outages. 7 rows id 890e75d2-c676-4d56-aa47-5dc8fc6b1f37
  124. 124Rendering: Chart: Find point clusters: Licensed premises. 4 rows id eab8321b-459d-4b21-8ac3-03b4c9716a0b
  125. 125Rendering: Chart: Find point clusters: cluster hulls. 3 rows id 597c1cc7-6d4d-45ea-805f-e76406a7301d
  126. 126Rendering: Chart: Find point clusters: Incidents. 4 rows id 834a7e88-1f92-40c3-876e-07b230849ef1
  127. 127Rendering: Chart: Find point clusters: cluster hulls. 3 rows id b1d73a1a-bd54-4f9a-829e-a64da853e8b8
  128. 128Rendering: Chart: Find point clusters: Street light outages. 2 rows id da93f938-3c5c-4e4b-a1e9-332a9c4d97c4
  129. 129Rendering: Chart: Find point clusters: cluster hulls. 1 rows id d0a69a7c-4f2e-46e8-8fbb-3db7d1804d97
  130. 130Rendering: Chart: Summarize within: Patrol beats. 5 rows id cf0bb795-0579-4a40-a979-e2f725bdfd8a
  131. 131Rendering: Chart: Summarize within: Patrol beats. 5 rows id cf1142c2-7076-48aa-b438-d97d2f7f83d6
  132. 132Rendering: Chart: Summarize within: Patrol beats. 5 rows id 85f26d21-089a-4d33-bb0c-b985b8e6ddae
  133. 133Rendering: Chart: Calculate density: Licensed premises. 9 rows id 3365b9ed-e2bc-4612-b00e-b147032aaa0b
  134. 134Rendering: Chart: Calculate density: Incidents. 13 rows id 130ec3b4-ddc0-4f62-8c53-493253574a12
  135. 135Rendering: Chart: Calculate density: Street light outages. 11 rows id 5d19b0ed-c618-4e8e-9536-3f3a0821dcd8
  136. 136Rendering: Chart: Hot spot analysis: Incidents. 48 rows id dc40d842-a071-4cf4-87b5-9dbd4aff8223
  137. 137Rendering: Chart: Repeat and near repeat classification: Incidents. 106 rows id 2774b60c-5a11-46d6-a8e1-f56f2a252051
  138. 138Rendering: Chart: Repeat and near repeat classification: Incidents over time. 106 rows id d3456b40-f8d2-4674-9fe4-b420ca81087b
  139. 139Rendering: Chart: Find point clusters: Street light outages over time. 52 rows id b7008422-a117-4748-8bb2-7dd55cd29bdd
  140. 140Rendering: Chart: Find point clusters: Incidents over time. 106 rows id fcaf3d1b-6848-404c-9e97-b57b023c1cbd
  141. 141Document: Quarterly crime and safety briefing, third quarter 2026. 1 page(s), 1 page(s) from the text layer id 7f7de84b-c518-4d25-b279-e98be530690e
  142. 142Document page: Quarterly crime and safety briefing, third quarter 2026, page 1. Thefts and robberies remain concentrated around the Central Transit Center at 41.87815, -87.63532, mostly on weekday commuting hours. id 7f7de84b-c518-4d25-b279-e98be530690e:1
  143. 143Document: Hot spot patrol plan. 1 page(s), 1 page(s) from the text layer id 0bf0414d-d633-4517-a876-66ca320180f3
  144. 144Document page: Hot spot patrol plan, page 1. Focus id 0bf0414d-d633-4517-a876-66ca320180f3:1
  145. 145Dataset: Patrol beats. vector, 16 rows id ba848777-0930-4af3-b069-03edd17a2c3a
  146. 146Dataset: Police stations. vector, 3 rows id d3ceed49-4119-4de8-9218-65b32992e120
  147. 147Dataset: CCTV cameras. vector, 60 rows id 13e9e089-c520-4be6-9034-c0ecaf7790ab
  148. 148Dataset: Transit stops. vector, 80 rows id cc2e635f-1052-402a-82aa-95b2db052e76
  149. 149Dataset: Licensed premises. vector, 120 rows id 1a088947-ca4e-4632-b13d-975d48c05e97
  150. 150Dataset: Roads. vector, 1033 rows id e72c7c55-1cdd-49b2-b75d-3d2ec18b9c1e
  151. 151Dataset: Beat staffing by shift. table, 48 rows id 6abb3c2e-68b3-4a9c-b2a7-ce316203ebe8
  152. 152Dataset: Quarterly crime and safety briefing. document, ? rows id 535a8782-a933-42ff-af25-92ec818afdd6
  153. 153Dataset: Hot spot patrol plan. document, ? rows id 70e64e98-d266-4079-a9a1-7d54ac2c3e96
  154. 154Record: Sample: Public safety, Chicago id fe9df6b9-8a15-4264-946b-4b37b8dbb89d
  155. 155Layer: Hot spot analysis: Licensed premises. 112 features id 90322b1c-a218-4ac5-8478-7f0de2a327dd
  156. 156Layer: Emerging hot spots: Incidents. 270 features id ddbdee29-f892-4397-9f92-4fb6062a0a16
  157. 157Layer: Emerging hot spots: Street light outages. 47 features id 377fb9d7-1ae0-4b9d-b202-467adca71899
  158. 158Layer: Find point clusters: Licensed premises. 120 features id 0f39a418-fa9c-4906-bbe4-7afb6c00ba8c
  159. 159Layer: Find point clusters: Incidents. 1,680 features id 75dd415e-0b2c-4a18-b79c-cc2338385dd5
  160. 160Layer: Find point clusters: cluster hulls. 3 features id 99ba9a84-3453-4bca-a43e-5861ef41c540
  161. 161Layer: Find point clusters: Street light outages. 420 features id 4ac9e9ca-a714-4ec7-9df8-4e3869dbcc58
  162. 162Layer: Find point clusters: cluster hulls. 1 features id 6d783f7e-8f24-4458-8abc-6e3126e9630a
  163. 163Layer: Summarize within: Patrol beats. 16 features id 430dcae6-3721-44c7-9264-40595ff75b4e
  164. 164Layer: Summarize within: Patrol beats. 16 features id fabe7842-f3f5-4d5e-a46f-c3232381dc5f
  165. 165Layer: Calculate density: Licensed premises. 164 features id 76319405-6afb-4505-946b-c33b783be8eb
  166. 166Layer: Calculate density: Incidents. 2,874 features id 8d228b68-9a3d-43fd-96a3-e37297b29f9a
  167. 167Layer: Repeat and near repeat classification: Incidents. 1,680 features id aa6cf905-4fec-4559-9917-c9810ef2a94b
Appendix: the data behind the chartsShow

Figure 1. Timeline: events per month by dataset 1

periodseriesvalue
2024-10-01Incidents0
2024-10-01Street light outages0
2024-10-01Calls for service by beat and month16
2024-11-01Incidents0
2024-11-01Street light outages0
2024-11-01Calls for service by beat and month16
2024-12-01Incidents0
2024-12-01Street light outages0
2024-12-01Calls for service by beat and month16
2025-01-01Incidents0
2025-01-01Street light outages0
2025-01-01Calls for service by beat and month16
2025-02-01Incidents0
2025-02-01Street light outages0
2025-02-01Calls for service by beat and month16
2025-03-01Incidents0
2025-03-01Street light outages0
2025-03-01Calls for service by beat and month16
2025-04-01Incidents0
2025-04-01Street light outages0
2025-04-01Calls for service by beat and month16
2025-05-01Incidents0
2025-05-01Street light outages0
2025-05-01Calls for service by beat and month16
2025-06-01Incidents0
2025-06-01Street light outages0
2025-06-01Calls for service by beat and month16
2025-07-01Incidents0
2025-07-01Street light outages0
2025-07-01Calls for service by beat and month16
2025-08-01Incidents0
2025-08-01Street light outages0
2025-08-01Calls for service by beat and month16
2025-09-01Incidents0
2025-09-01Street light outages0
2025-09-01Calls for service by beat and month16
2025-10-01Incidents114
2025-10-01Street light outages33
2025-10-01Calls for service by beat and month16
2025-11-01Incidents125
2025-11-01Street light outages26
2025-11-01Calls for service by beat and month16
2025-12-01Incidents119
2025-12-01Street light outages40
2025-12-01Calls for service by beat and month16
2026-01-01Incidents112
2026-01-01Street light outages49
2026-01-01Calls for service by beat and month16
2026-02-01Incidents90
2026-02-01Street light outages44
2026-02-01Calls for service by beat and month16
2026-03-01Incidents126
2026-03-01Street light outages37
2026-03-01Calls for service by beat and month16
2026-04-01Incidents133
2026-04-01Street light outages37
2026-04-01Calls for service by beat and month16
2026-05-01Incidents162
2026-05-01Street light outages28
2026-05-01Calls for service by beat and month16
2026-06-01Incidents143
2026-06-01Street light outages33
2026-06-01Calls for service by beat and month16
2026-07-01Incidents195
2026-07-01Street light outages24
2026-07-01Calls for service by beat and month16
2026-08-01Incidents179
2026-08-01Street light outages33
2026-08-01Calls for service by beat and month16
2026-09-01Incidents182
2026-09-01Street light outages36
2026-09-01Calls for service by beat and month16

Figure 2. Timeline lanes: events per month by dataset 5

laneperiodperiod_endvalue
Incidents2024-10-012024-11-010
Incidents2024-11-012024-12-010
Incidents2024-12-012025-01-010
Incidents2025-01-012025-02-010
Incidents2025-02-012025-03-010
Incidents2025-03-012025-04-010
Incidents2025-04-012025-05-010
Incidents2025-05-012025-06-010
Incidents2025-06-012025-07-010
Incidents2025-07-012025-08-010
Incidents2025-08-012025-09-010
Incidents2025-09-012025-10-010
Incidents2025-10-012025-11-01114
Incidents2025-11-012025-12-01125
Incidents2025-12-012026-01-01119
Incidents2026-01-012026-02-01112
Incidents2026-02-012026-03-0190
Incidents2026-03-012026-04-01126
Incidents2026-04-012026-05-01133
Incidents2026-05-012026-06-01162
Incidents2026-06-012026-07-01143
Incidents2026-07-012026-08-01195
Incidents2026-08-012026-09-01179
Incidents2026-09-012026-10-01182
Street light outages2024-10-012024-11-010
Street light outages2024-11-012024-12-010
Street light outages2024-12-012025-01-010
Street light outages2025-01-012025-02-010
Street light outages2025-02-012025-03-010
Street light outages2025-03-012025-04-010
Street light outages2025-04-012025-05-010
Street light outages2025-05-012025-06-010
Street light outages2025-06-012025-07-010
Street light outages2025-07-012025-08-010
Street light outages2025-08-012025-09-010
Street light outages2025-09-012025-10-010
Street light outages2025-10-012025-11-0133
Street light outages2025-11-012025-12-0126
Street light outages2025-12-012026-01-0140
Street light outages2026-01-012026-02-0149
Street light outages2026-02-012026-03-0144
Street light outages2026-03-012026-04-0137
Street light outages2026-04-012026-05-0137
Street light outages2026-05-012026-06-0128
Street light outages2026-06-012026-07-0133
Street light outages2026-07-012026-08-0124
Street light outages2026-08-012026-09-0133
Street light outages2026-09-012026-10-0136
Calls for service by beat and month2024-10-012024-11-0116
Calls for service by beat and month2024-11-012024-12-0116
Calls for service by beat and month2024-12-012025-01-0116
Calls for service by beat and month2025-01-012025-02-0116
Calls for service by beat and month2025-02-012025-03-0116
Calls for service by beat and month2025-03-012025-04-0116
Calls for service by beat and month2025-04-012025-05-0116
Calls for service by beat and month2025-05-012025-06-0116
Calls for service by beat and month2025-06-012025-07-0116
Calls for service by beat and month2025-07-012025-08-0116
Calls for service by beat and month2025-08-012025-09-0116
Calls for service by beat and month2025-09-012025-10-0116
Calls for service by beat and month2025-10-012025-11-0116
Calls for service by beat and month2025-11-012025-12-0116
Calls for service by beat and month2025-12-012026-01-0116
Calls for service by beat and month2026-01-012026-02-0116
Calls for service by beat and month2026-02-012026-03-0116
Calls for service by beat and month2026-03-012026-04-0116
Calls for service by beat and month2026-04-012026-05-0116
Calls for service by beat and month2026-05-012026-06-0116
Calls for service by beat and month2026-06-012026-07-0116
Calls for service by beat and month2026-07-012026-08-0116
Calls for service by beat and month2026-08-012026-09-0116
Calls for service by beat and month2026-09-012026-10-0116

Figure 3. Timeline: change from one month to the next 6

periodperiod_endvaluepreviouschange
2024-11-012024-12-0116160
2024-12-012025-01-0116160
2025-01-012025-02-0116160
2025-02-012025-03-0116160
2025-03-012025-04-0116160
2025-04-012025-05-0116160
2025-05-012025-06-0116160
2025-06-012025-07-0116160
2025-07-012025-08-0116160
2025-08-012025-09-0116160
2025-09-012025-10-0116160
2025-10-012025-11-0116316147
2025-11-012025-12-011671634
2025-12-012026-01-011751678
2026-01-012026-02-011771752
2026-02-012026-03-01150177-27
2026-03-012026-04-0117915029
2026-04-012026-05-011861797
2026-05-012026-06-0120618620
2026-06-012026-07-01192206-14
2026-07-012026-08-0123519243
2026-08-012026-09-01228235-7
2026-09-012026-10-012342286

Figure 16. Incidents: count per week 55

periodvalue
2025-09-2916
2025-10-0625
2025-10-1329
2025-10-2019
2025-10-2731
2025-11-0337
2025-11-1031
2025-11-1731
2025-11-2420
2025-12-0122
2025-12-0832
2025-12-1528
2025-12-2224
2025-12-2932
2026-01-0522
2026-01-1224
2026-01-1926
2026-01-2624
2026-02-0218
2026-02-0918
2026-02-1626
2026-02-2329
2026-03-0216
2026-03-0923
2026-03-1634
2026-03-2339
2026-03-3025
2026-04-0641
2026-04-1322
2026-04-2036
2026-04-2736
2026-05-0436
2026-05-1132
2026-05-1840
2026-05-2537
2026-06-0122
2026-06-0837
2026-06-1542
2026-06-2233
2026-06-2972
2026-07-0634
2026-07-1336
2026-07-2036
2026-07-2740
2026-08-0331
2026-08-1024
2026-08-1746
2026-08-2455
2026-08-3141
2026-09-0741
2026-09-1449
2026-09-2147
2026-09-2813

Figure 17. Incidents: week of 2026-06-22 to week of 2026-06-29 by place 56

groupperiodvalue
Market West Beatweek of 2026-06-227
Market West Beatweek of 2026-06-2916
Kingsway Beatweek of 2026-06-226
Kingsway Beatweek of 2026-06-2913
Southgate Beatweek of 2026-06-222
Southgate Beatweek of 2026-06-299
Elm Park Beatweek of 2026-06-225
Elm Park Beatweek of 2026-06-299
North River Beatweek of 2026-06-225
North River Beatweek of 2026-06-299
Granary Beatweek of 2026-06-222
Granary Beatweek of 2026-06-290
Midtown Beatweek of 2026-06-221
Midtown Beatweek of 2026-06-293
Old Mill Beatweek of 2026-06-221
Old Mill Beatweek of 2026-06-293
Westbrook Beatweek of 2026-06-220
Westbrook Beatweek of 2026-06-292
Brickworks Beatweek of 2026-06-220
Brickworks Beatweek of 2026-06-291
Cedar Heights Beatweek of 2026-06-220
Cedar Heights Beatweek of 2026-06-291
Foundry Beatweek of 2026-06-220
Foundry Beatweek of 2026-06-291
Parkview Beatweek of 2026-06-222
Parkview Beatweek of 2026-06-291
Station Quarter Beatweek of 2026-06-221
Station Quarter Beatweek of 2026-06-292
Union Yards Beatweek of 2026-06-220
Union Yards Beatweek of 2026-06-291

Figure 18. Period change: Incidents (week of 2026-06-22 to week of 2026-06-29) 57

bin_startbin_endcount
-1.414-0.70921
-0.7092-0.004281
-0.004280.70072
0.70071.4068
1.4062.1114

Figure 20. Street light outages: count per week 59

periodvalue
2025-09-294
2025-10-066
2025-10-136
2025-10-2010
2025-10-2710
2025-11-037
2025-11-107
2025-11-174
2025-11-245
2025-12-0114
2025-12-0811
2025-12-157
2025-12-227
2025-12-2911
2026-01-059
2026-01-129
2026-01-1916
2026-01-266
2026-02-0217
2026-02-094
2026-02-1612
2026-02-2311
2026-03-024
2026-03-099
2026-03-166
2026-03-2312
2026-03-3013
2026-04-069
2026-04-139
2026-04-207
2026-04-277
2026-05-043
2026-05-118
2026-05-188
2026-05-256
2026-06-0112
2026-06-087
2026-06-153
2026-06-2210
2026-06-295
2026-07-066
2026-07-136
2026-07-207
2026-07-276
2026-08-037
2026-08-109
2026-08-176
2026-08-245
2026-08-3110
2026-09-078
2026-09-148
2026-09-219
2026-09-282

Figure 21. Street light outages: week of 2026-02-02 to week of 2026-02-09 by place 60

groupperiodvalue
Market West Beatweek of 2026-02-029
Market West Beatweek of 2026-02-092
North River Beatweek of 2026-02-023
North River Beatweek of 2026-02-090
Parkview Beatweek of 2026-02-020
Parkview Beatweek of 2026-02-092
Southgate Beatweek of 2026-02-022
Southgate Beatweek of 2026-02-090
Canal Row Beatweek of 2026-02-021
Canal Row Beatweek of 2026-02-090
Cedar Heights Beatweek of 2026-02-021
Cedar Heights Beatweek of 2026-02-090
Westbrook Beatweek of 2026-02-021
Westbrook Beatweek of 2026-02-090

Figure 22. Period change: Street light outages (week of 2026-02-02 to week of 2026-02-09) 61

bin_startbin_endcount
-2.111-1.4063
-1.406-0.70073
-0.70070.004280
0.004280.70920
0.70921.4141

Figure 29. Hot cells inside each cluster of licensed premises 84

clusterfeaturesfractionshare
010.333333.3%
110.333333.3%
210.333333.3%

Figure 31. Change beside the counts per patrol beat 91

bin_startbin_endcount
-1.414-0.70921
-0.7092-0.004281
-0.004280.70072
0.70071.4068
1.4062.1114

Figure 33. Change of incidents where density is high 96

bin_startbin_endcount
-1.414-0.70921
-0.7092-0.004281
-0.004280.70072
0.70071.4068
1.4062.1114

Figure 35. Hot cells of CCTV cameras per patrol beat 101

bin_startbin_endcount
231
340
452
564
679

Figure 37. Nearest police station to each cluster of licensed premises 106

rankname
1Central District Station
1Central District Station
1Central District Station

Figure 38. Dense areas of street light outages 111

bin_startbin_endcount
00.81
0.81.61
1.62.41
2.43.21
3.241

Figure 40. Change of street light outages per patrol beat 115

bin_startbin_endcount
00.29
0.20.40
0.40.60
0.60.80
0.817

Figure 41. Incidents over time (reported_at) 116

periodseriesvalue
2025-09-29theft8
2025-09-29battery4
2025-09-29criminal damage0
2025-09-29burglary1
2025-09-29motor vehicle theft0
2025-09-29Other3
2025-10-06theft8
2025-10-06battery1
2025-10-06criminal damage3
2025-10-06burglary9
2025-10-06motor vehicle theft0
2025-10-06Other4
2025-10-13theft10
2025-10-13battery5
2025-10-13criminal damage6
2025-10-13burglary1
2025-10-13motor vehicle theft3
2025-10-13Other4
2025-10-20theft8
2025-10-20battery2
2025-10-20criminal damage3
2025-10-20burglary2
2025-10-20motor vehicle theft2
2025-10-20Other2
2025-10-27theft11
2025-10-27battery5
2025-10-27criminal damage3
2025-10-27burglary5
2025-10-27motor vehicle theft1
2025-10-27Other6
2025-11-03theft12
2025-11-03battery7
2025-11-03criminal damage1
2025-11-03burglary7
2025-11-03motor vehicle theft1
2025-11-03Other9
2025-11-10theft7
2025-11-10battery8
2025-11-10criminal damage5
2025-11-10burglary2
2025-11-10motor vehicle theft4
2025-11-10Other5
2025-11-17theft9
2025-11-17battery4
2025-11-17criminal damage5
2025-11-17burglary3
2025-11-17motor vehicle theft4
2025-11-17Other6
2025-11-24theft5
2025-11-24battery3
2025-11-24criminal damage2
2025-11-24burglary2
2025-11-24motor vehicle theft4
2025-11-24Other4
2025-12-01theft6
2025-12-01battery4
2025-12-01criminal damage4
2025-12-01burglary3
2025-12-01motor vehicle theft0
2025-12-01Other5
2025-12-08theft8
2025-12-08battery3
2025-12-08criminal damage8
2025-12-08burglary4
2025-12-08motor vehicle theft2
2025-12-08Other7
2025-12-15theft8
2025-12-15battery5
2025-12-15criminal damage6
2025-12-15burglary2
2025-12-15motor vehicle theft2
2025-12-15Other5
2025-12-22theft8
2025-12-22battery2
2025-12-22criminal damage3
2025-12-22burglary5
2025-12-22motor vehicle theft2
2025-12-22Other4
2025-12-29theft11
2025-12-29battery2
2025-12-29criminal damage6
2025-12-29burglary4
2025-12-29motor vehicle theft1
2025-12-29Other8
2026-01-05theft7
2026-01-05battery5
2026-01-05criminal damage3
2026-01-05burglary0
2026-01-05motor vehicle theft4
2026-01-05Other3
2026-01-12theft10
2026-01-12battery3
2026-01-12criminal damage0
2026-01-12burglary5
2026-01-12motor vehicle theft3
2026-01-12Other3
2026-01-19theft10
2026-01-19battery1
2026-01-19criminal damage1
2026-01-19burglary4
2026-01-19motor vehicle theft2
2026-01-19Other8
2026-01-26theft12
2026-01-26battery1
2026-01-26criminal damage3
2026-01-26burglary3
2026-01-26motor vehicle theft0
2026-01-26Other5
2026-02-02theft9
2026-02-02battery1
2026-02-02criminal damage1
2026-02-02burglary1
2026-02-02motor vehicle theft4
2026-02-02Other2
2026-02-09theft6
2026-02-09battery2
2026-02-09criminal damage2
2026-02-09burglary3
2026-02-09motor vehicle theft3
2026-02-09Other2
2026-02-16theft9
2026-02-16battery3
2026-02-16criminal damage2
2026-02-16burglary7
2026-02-16motor vehicle theft3
2026-02-16Other2
2026-02-23theft13
2026-02-23battery4
2026-02-23criminal damage1
2026-02-23burglary0
2026-02-23motor vehicle theft6
2026-02-23Other5
2026-03-02theft5
2026-03-02battery1
2026-03-02criminal damage1
2026-03-02burglary4
2026-03-02motor vehicle theft3
2026-03-02Other2
2026-03-09theft7
2026-03-09battery4
2026-03-09criminal damage2
2026-03-09burglary1
2026-03-09motor vehicle theft6
2026-03-09Other3
2026-03-16theft7
2026-03-16battery8
2026-03-16criminal damage6
2026-03-16burglary7
2026-03-16motor vehicle theft1
2026-03-16Other5
2026-03-23theft9
2026-03-23battery4
2026-03-23criminal damage5
2026-03-23burglary5
2026-03-23motor vehicle theft7
2026-03-23Other9
2026-03-30theft6
2026-03-30battery8
2026-03-30criminal damage2
2026-03-30burglary2
2026-03-30motor vehicle theft3
2026-03-30Other4
2026-04-06theft11
2026-04-06battery7
2026-04-06criminal damage5
2026-04-06burglary8
2026-04-06motor vehicle theft5
2026-04-06Other5
2026-04-13theft8
2026-04-13battery7
2026-04-13criminal damage1
2026-04-13burglary2
2026-04-13motor vehicle theft2
2026-04-13Other2
2026-04-20theft9
2026-04-20battery9
2026-04-20criminal damage5
2026-04-20burglary5
2026-04-20motor vehicle theft3
2026-04-20Other5
2026-04-27theft9
2026-04-27battery10
2026-04-27criminal damage6
2026-04-27burglary4
2026-04-27motor vehicle theft2
2026-04-27Other5
2026-05-04theft14
2026-05-04battery2
2026-05-04criminal damage7
2026-05-04burglary4
2026-05-04motor vehicle theft4
2026-05-04Other5
2026-05-11theft11
2026-05-11battery4
2026-05-11criminal damage2
2026-05-11burglary7
2026-05-11motor vehicle theft5
2026-05-11Other3
2026-05-18theft14
2026-05-18battery7
2026-05-18criminal damage7
2026-05-18burglary3
2026-05-18motor vehicle theft3
2026-05-18Other6
2026-05-25theft14
2026-05-25battery5
2026-05-25criminal damage7
2026-05-25burglary3
2026-05-25motor vehicle theft3
2026-05-25Other5
2026-06-01theft6
2026-06-01battery3
2026-06-01criminal damage6
2026-06-01burglary2
2026-06-01motor vehicle theft3
2026-06-01Other2
2026-06-08theft6
2026-06-08battery7
2026-06-08criminal damage7
2026-06-08burglary7
2026-06-08motor vehicle theft5
2026-06-08Other5
2026-06-15theft8
2026-06-15battery14
2026-06-15criminal damage4
2026-06-15burglary4
2026-06-15motor vehicle theft6
2026-06-15Other6
2026-06-22theft12
2026-06-22battery6
2026-06-22criminal damage10
2026-06-22burglary1
2026-06-22motor vehicle theft2
2026-06-22Other2
2026-06-29theft20
2026-06-29battery21
2026-06-29criminal damage9
2026-06-29burglary6
2026-06-29motor vehicle theft7
2026-06-29Other9
2026-07-06theft12
2026-07-06battery7
2026-07-06criminal damage1
2026-07-06burglary7
2026-07-06motor vehicle theft3
2026-07-06Other4
2026-07-13theft9
2026-07-13battery4
2026-07-13criminal damage4
2026-07-13burglary4
2026-07-13motor vehicle theft7
2026-07-13Other8
2026-07-20theft7
2026-07-20battery9
2026-07-20criminal damage6
2026-07-20burglary2
2026-07-20motor vehicle theft3
2026-07-20Other9
2026-07-27theft15
2026-07-27battery5
2026-07-27criminal damage6
2026-07-27burglary3
2026-07-27motor vehicle theft7
2026-07-27Other4
2026-08-03theft11
2026-08-03battery7
2026-08-03criminal damage4
2026-08-03burglary1
2026-08-03motor vehicle theft4
2026-08-03Other4
2026-08-10theft11
2026-08-10battery2
2026-08-10criminal damage3
2026-08-10burglary1
2026-08-10motor vehicle theft4
2026-08-10Other3
2026-08-17theft18
2026-08-17battery6
2026-08-17criminal damage7
2026-08-17burglary5
2026-08-17motor vehicle theft6
2026-08-17Other4
2026-08-24theft18
2026-08-24battery7
2026-08-24criminal damage5
2026-08-24burglary5
2026-08-24motor vehicle theft8
2026-08-24Other12
2026-08-31theft15
2026-08-31battery8
2026-08-31criminal damage2
2026-08-31burglary3
2026-08-31motor vehicle theft6
2026-08-31Other7
2026-09-07theft19
2026-09-07battery3
2026-09-07criminal damage3
2026-09-07burglary5
2026-09-07motor vehicle theft2
2026-09-07Other9
2026-09-14theft15
2026-09-14battery12
2026-09-14criminal damage4
2026-09-14burglary7
2026-09-14motor vehicle theft4
2026-09-14Other7
2026-09-21theft17
2026-09-21battery9
2026-09-21criminal damage1
2026-09-21burglary5
2026-09-21motor vehicle theft7
2026-09-21Other8
2026-09-28theft1
2026-09-28battery5
2026-09-28criminal damage1
2026-09-28burglary0
2026-09-28motor vehicle theft1
2026-09-28Other5

Figure 42. Street light outages over time (reported_at) 117

periodseriesvalue
2025-09-29lamp failure2
2025-09-29cable fault1
2025-09-29vandalism1
2025-09-29collision0
2025-10-06lamp failure4
2025-10-06cable fault0
2025-10-06vandalism2
2025-10-06collision0
2025-10-13lamp failure4
2025-10-13cable fault0
2025-10-13vandalism2
2025-10-13collision0
2025-10-20lamp failure6
2025-10-20cable fault3
2025-10-20vandalism0
2025-10-20collision1
2025-10-27lamp failure3
2025-10-27cable fault3
2025-10-27vandalism3
2025-10-27collision1
2025-11-03lamp failure4
2025-11-03cable fault2
2025-11-03vandalism1
2025-11-03collision0
2025-11-10lamp failure5
2025-11-10cable fault1
2025-11-10vandalism1
2025-11-10collision0
2025-11-17lamp failure2
2025-11-17cable fault1
2025-11-17vandalism1
2025-11-17collision0
2025-11-24lamp failure2
2025-11-24cable fault0
2025-11-24vandalism2
2025-11-24collision1
2025-12-01lamp failure6
2025-12-01cable fault4
2025-12-01vandalism2
2025-12-01collision2
2025-12-08lamp failure6
2025-12-08cable fault1
2025-12-08vandalism2
2025-12-08collision2
2025-12-15lamp failure2
2025-12-15cable fault2
2025-12-15vandalism2
2025-12-15collision1
2025-12-22lamp failure2
2025-12-22cable fault4
2025-12-22vandalism0
2025-12-22collision1
2025-12-29lamp failure7
2025-12-29cable fault3
2025-12-29vandalism0
2025-12-29collision1
2026-01-05lamp failure5
2026-01-05cable fault3
2026-01-05vandalism1
2026-01-05collision0
2026-01-12lamp failure5
2026-01-12cable fault1
2026-01-12vandalism1
2026-01-12collision2
2026-01-19lamp failure6
2026-01-19cable fault6
2026-01-19vandalism3
2026-01-19collision1
2026-01-26lamp failure1
2026-01-26cable fault2
2026-01-26vandalism1
2026-01-26collision2
2026-02-02lamp failure8
2026-02-02cable fault1
2026-02-02vandalism5
2026-02-02collision3
2026-02-09lamp failure2
2026-02-09cable fault1
2026-02-09vandalism0
2026-02-09collision1
2026-02-16lamp failure4
2026-02-16cable fault1
2026-02-16vandalism4
2026-02-16collision3
2026-02-23lamp failure6
2026-02-23cable fault2
2026-02-23vandalism1
2026-02-23collision2
2026-03-02lamp failure1
2026-03-02cable fault3
2026-03-02vandalism0
2026-03-02collision0
2026-03-09lamp failure4
2026-03-09cable fault4
2026-03-09vandalism0
2026-03-09collision1
2026-03-16lamp failure3
2026-03-16cable fault2
2026-03-16vandalism1
2026-03-16collision0
2026-03-23lamp failure8
2026-03-23cable fault1
2026-03-23vandalism3
2026-03-23collision0
2026-03-30lamp failure10
2026-03-30cable fault1
2026-03-30vandalism1
2026-03-30collision1
2026-04-06lamp failure3
2026-04-06cable fault3
2026-04-06vandalism2
2026-04-06collision1
2026-04-13lamp failure6
2026-04-13cable fault2
2026-04-13vandalism1
2026-04-13collision0
2026-04-20lamp failure4
2026-04-20cable fault1
2026-04-20vandalism2
2026-04-20collision0
2026-04-27lamp failure3
2026-04-27cable fault3
2026-04-27vandalism1
2026-04-27collision0
2026-05-04lamp failure0
2026-05-04cable fault1
2026-05-04vandalism0
2026-05-04collision2
2026-05-11lamp failure5
2026-05-11cable fault1
2026-05-11vandalism2
2026-05-11collision0
2026-05-18lamp failure5
2026-05-18cable fault2
2026-05-18vandalism0
2026-05-18collision1
2026-05-25lamp failure5
2026-05-25cable fault1
2026-05-25vandalism0
2026-05-25collision0
2026-06-01lamp failure9
2026-06-01cable fault1
2026-06-01vandalism1
2026-06-01collision1
2026-06-08lamp failure4
2026-06-08cable fault0
2026-06-08vandalism3
2026-06-08collision0
2026-06-15lamp failure0
2026-06-15cable fault1
2026-06-15vandalism1
2026-06-15collision1
2026-06-22lamp failure4
2026-06-22cable fault3
2026-06-22vandalism1
2026-06-22collision2
2026-06-29lamp failure2
2026-06-29cable fault1
2026-06-29vandalism1
2026-06-29collision1
2026-07-06lamp failure4
2026-07-06cable fault1
2026-07-06vandalism0
2026-07-06collision1
2026-07-13lamp failure4
2026-07-13cable fault1
2026-07-13vandalism1
2026-07-13collision0
2026-07-20lamp failure1
2026-07-20cable fault4
2026-07-20vandalism0
2026-07-20collision2
2026-07-27lamp failure4
2026-07-27cable fault0
2026-07-27vandalism1
2026-07-27collision1
2026-08-03lamp failure5
2026-08-03cable fault1
2026-08-03vandalism0
2026-08-03collision1
2026-08-10lamp failure3
2026-08-10cable fault6
2026-08-10vandalism0
2026-08-10collision0
2026-08-17lamp failure2
2026-08-17cable fault2
2026-08-17vandalism1
2026-08-17collision1
2026-08-24lamp failure3
2026-08-24cable fault0
2026-08-24vandalism1
2026-08-24collision1
2026-08-31lamp failure4
2026-08-31cable fault5
2026-08-31vandalism0
2026-08-31collision1
2026-09-07lamp failure2
2026-09-07cable fault3
2026-09-07vandalism2
2026-09-07collision1
2026-09-14lamp failure4
2026-09-14cable fault1
2026-09-14vandalism2
2026-09-14collision1
2026-09-21lamp failure4
2026-09-21cable fault3
2026-09-21vandalism1
2026-09-21collision1
2026-09-28lamp failure1
2026-09-28cable fault0
2026-09-28vandalism0
2026-09-28collision1

Figure 43. CCTV cameras over time (installed_year) 118

bin_startbin_endcount
2,0122,0149
2,0142,0167
2,0162,0188
2,0182,01911
2,0192,02111
2,0212,0238
2,0232,0256

Figure 44. Calls for service by beat and month over time (month) 119

periodvalue
2024-10-013,466
2024-11-013,080
2024-12-012,721
2025-01-012,613
2025-02-012,623
2025-03-012,843
2025-04-013,288
2025-05-013,726
2025-06-014,161
2025-07-014,458
2025-08-014,448
2025-09-014,171
2025-10-013,824
2025-11-013,418
2025-12-012,939
2026-01-012,808
2026-02-012,892
2026-03-013,079
2026-04-013,632
2026-05-014,128
2026-06-014,507
2026-07-014,792
2026-08-014,812
2026-09-014,551

Figure 45. Hot spot analysis: CCTV cameras 120

bin_startbin_endbandband_labelcount
-2-1.5cold_90Cold spot, 90% confidence1
-2-1.5not_significantNot significant1
-1.5-1not_significantNot significant1
-1-0.5not_significantNot significant10
-0.50not_significantNot significant4
00.5not_significantNot significant5
0.51not_significantNot significant2
11.5not_significantNot significant4
1.52hot_90Hot spot, 90% confidence1
1.52hot_95Hot spot, 95% confidence1
22.5hot_95Hot spot, 95% confidence5
2.53hot_99Hot spot, 99% confidence1

Figure 46. Hot spot analysis: Licensed premises 121

bin_startbin_endbandband_labelcount
-1.5-1not_significantNot significant12
-1-0.5not_significantNot significant49
-0.50not_significantNot significant28
00.5not_significantNot significant2
0.51not_significantNot significant2
11.5not_significantNot significant2
1.52hot_90Hot spot, 90% confidence2
1.52not_significantNot significant1
22.5hot_95Hot spot, 95% confidence2
33.5hot_99Hot spot, 99% confidence3
3.54hot_99Hot spot, 99% confidence1
44.5hot_99Hot spot, 99% confidence2
4.55hot_99Hot spot, 99% confidence2
55.5hot_99Hot spot, 99% confidence1
5.56hot_99Hot spot, 99% confidence3

Figure 47. Emerging hot spots: Incidents 122

bin_startbin_endcount
-0.659-0.1378163
-0.13780.383472
0.38340.90462
0.90461.4260
1.4261.94719
1.9472.4686
2.4682.9890
2.9893.5110
3.5114.0326
4.0324.5532

Figure 48. Emerging hot spots: Street light outages 123

bin_startbin_endcount
-0.707-0.291928
-0.29190.12330
0.12330.538414
0.53840.95360
0.95361.3694
1.3691.7840
1.7842.1991

Figure 49. Find point clusters: Licensed premises 124

clusterfeaturesfractionshare
Noise610.508350.8%
0530.441744.2%
130.0252.5%
230.0252.5%

Figure 50. Find point clusters: cluster hulls 125

clusterfeaturesfractionshare
010.333333.3%
110.333333.3%
210.333333.3%

Figure 51. Find point clusters: Incidents 126

clusterfeaturesfractionshare
Noise1,6090.957795.8%
0300.017861.8%
1210.01251.2%
2200.011911.2%

Figure 52. Find point clusters: cluster hulls 127

clusterfeaturesfractionshare
010.333333.3%
110.333333.3%
210.333333.3%

Figure 53. Find point clusters: Street light outages 128

clusterfeaturesfractionshare
Noise4100.976297.6%
0100.023812.4%

Figure 54. Find point clusters: cluster hulls 129

clusterfeaturesfractionshare
011100.0%

Figure 55. Summarize within: Patrol beats 130

bin_startbin_endcount
13.411
3.45.83
5.88.21
8.210.60
10.6131

Figure 56. Summarize within: Patrol beats 131

bin_startbin_endcount
1710
7134
13190
19251
25311

Figure 57. Summarize within: Patrol beats 132

bin_startbin_endcount
1880.810
80.8143.62
143.6206.42
206.4269.20
269.23322

Figure 58. Calculate density: Licensed premises 133

bin_startbin_endcount
01.55615
1.5563.11122
3.1114.66713
4.6676.22226
6.2227.77814
7.7789.33326
9.33310.8910
10.8912.4423
12.441415

Figure 59. Calculate density: Incidents 134

bin_startbin_endcount
04.846172
4.8469.692242
9.69214.54246
14.5419.38260
19.3824.23260
24.2329.08240
29.0833.92204
33.9238.77261
38.7743.62264
43.6248.46266
48.4653.31262
53.3158.15153
58.156344

Figure 60. Calculate density: Street light outages 135

bin_startbin_endcount
02.90959
2.9095.81884
5.8188.72782
8.72711.6485
11.6414.5579
14.5517.4585
17.4520.3686
20.3623.2787
23.2726.1887
26.1829.0980
29.093234

Figure 61. Hot spot analysis: Incidents 136

bin_startbin_endbandband_labelcount
-1.5-1not_significantNot significant685
-1-0.5not_significantNot significant757
-0.50not_significantNot significant714
00.5not_significantNot significant318
0.51not_significantNot significant104
11.5not_significantNot significant125
1.52hot_90Hot spot, 90% confidence13
1.52not_significantNot significant27
22.5hot_95Hot spot, 95% confidence35
2.53hot_99Hot spot, 99% confidence26
33.5hot_99Hot spot, 99% confidence8
3.54hot_99Hot spot, 99% confidence8
44.5hot_99Hot spot, 99% confidence5
4.55hot_99Hot spot, 99% confidence7
55.5hot_99Hot spot, 99% confidence2
5.56hot_99Hot spot, 99% confidence4
66.5hot_99Hot spot, 99% confidence3
6.57hot_99Hot spot, 99% confidence5
77.5hot_99Hot spot, 99% confidence5
7.58hot_99Hot spot, 99% confidence3
88.5hot_99Hot spot, 99% confidence2
8.59hot_99Hot spot, 99% confidence4
99.5hot_99Hot spot, 99% confidence2
9.510hot_99Hot spot, 99% confidence2
10.511hot_99Hot spot, 99% confidence1
1111.5hot_99Hot spot, 99% confidence3
11.512hot_99Hot spot, 99% confidence3
1212.5hot_99Hot spot, 99% confidence4
12.513hot_99Hot spot, 99% confidence4
1313.5hot_99Hot spot, 99% confidence3
13.514hot_99Hot spot, 99% confidence2
14.515hot_99Hot spot, 99% confidence3
1515.5hot_99Hot spot, 99% confidence2
15.516hot_99Hot spot, 99% confidence1
1616.5hot_99Hot spot, 99% confidence1
16.517hot_99Hot spot, 99% confidence2
1717.5hot_99Hot spot, 99% confidence1
1818.5hot_99Hot spot, 99% confidence1
1919.5hot_99Hot spot, 99% confidence1
20.521hot_99Hot spot, 99% confidence5
2121.5hot_99Hot spot, 99% confidence2
21.522hot_99Hot spot, 99% confidence2
2222.5hot_99Hot spot, 99% confidence2
22.523hot_99Hot spot, 99% confidence1
23.524hot_99Hot spot, 99% confidence1
2424.5hot_99Hot spot, 99% confidence1
24.525hot_99Hot spot, 99% confidence1
2626.5hot_99Hot spot, 99% confidence1

Figure 62. Repeat and near repeat classification: Incidents 137

periodseriesvalue
2025-09-29no arrest13
2025-09-29arrest3
2025-10-06no arrest20
2025-10-06arrest5
2025-10-13no arrest24
2025-10-13arrest5
2025-10-20no arrest19
2025-10-20arrest0
2025-10-27no arrest25
2025-10-27arrest6
2025-11-03no arrest31
2025-11-03arrest6
2025-11-10no arrest28
2025-11-10arrest3
2025-11-17no arrest24
2025-11-17arrest7
2025-11-24no arrest16
2025-11-24arrest4
2025-12-01no arrest21
2025-12-01arrest1
2025-12-08no arrest29
2025-12-08arrest3
2025-12-15no arrest26
2025-12-15arrest2
2025-12-22no arrest23
2025-12-22arrest1
2025-12-29no arrest27
2025-12-29arrest5
2026-01-05no arrest19
2026-01-05arrest3
2026-01-12no arrest17
2026-01-12arrest7
2026-01-19no arrest22
2026-01-19arrest4
2026-01-26no arrest22
2026-01-26arrest2
2026-02-02no arrest17
2026-02-02arrest1
2026-02-09no arrest16
2026-02-09arrest2
2026-02-16no arrest25
2026-02-16arrest1
2026-02-23no arrest29
2026-02-23arrest0
2026-03-02no arrest13
2026-03-02arrest3
2026-03-09no arrest22
2026-03-09arrest1
2026-03-16no arrest31
2026-03-16arrest3
2026-03-23no arrest32
2026-03-23arrest7
2026-03-30no arrest20
2026-03-30arrest5
2026-04-06no arrest37
2026-04-06arrest4
2026-04-13no arrest19
2026-04-13arrest3
2026-04-20no arrest34
2026-04-20arrest2
2026-04-27no arrest33
2026-04-27arrest3
2026-05-04no arrest31
2026-05-04arrest5
2026-05-11no arrest25
2026-05-11arrest7
2026-05-18no arrest39
2026-05-18arrest1
2026-05-25no arrest34
2026-05-25arrest3
2026-06-01no arrest21
2026-06-01arrest1
2026-06-08no arrest33
2026-06-08arrest4
2026-06-15no arrest34
2026-06-15arrest8
2026-06-22no arrest28
2026-06-22arrest5
2026-06-29no arrest58
2026-06-29arrest14
2026-07-06no arrest29
2026-07-06arrest5
2026-07-13no arrest36
2026-07-13arrest0
2026-07-20no arrest27
2026-07-20arrest9
2026-07-27no arrest36
2026-07-27arrest4
2026-08-03no arrest27
2026-08-03arrest4
2026-08-10no arrest21
2026-08-10arrest3
2026-08-17no arrest43
2026-08-17arrest3
2026-08-24no arrest48
2026-08-24arrest7
2026-08-31no arrest38
2026-08-31arrest3
2026-09-07no arrest35
2026-09-07arrest6
2026-09-14no arrest43
2026-09-14arrest6
2026-09-21no arrest38
2026-09-21arrest9
2026-09-28no arrest11
2026-09-28arrest2

Figure 63. Repeat and near repeat classification: Incidents over time 138

periodseriesvalue
2025-09-29no arrest13
2025-09-29arrest3
2025-10-06no arrest20
2025-10-06arrest5
2025-10-13no arrest24
2025-10-13arrest5
2025-10-20no arrest19
2025-10-20arrest0
2025-10-27no arrest25
2025-10-27arrest6
2025-11-03no arrest31
2025-11-03arrest6
2025-11-10no arrest28
2025-11-10arrest3
2025-11-17no arrest24
2025-11-17arrest7
2025-11-24no arrest16
2025-11-24arrest4
2025-12-01no arrest21
2025-12-01arrest1
2025-12-08no arrest29
2025-12-08arrest3
2025-12-15no arrest26
2025-12-15arrest2
2025-12-22no arrest23
2025-12-22arrest1
2025-12-29no arrest27
2025-12-29arrest5
2026-01-05no arrest19
2026-01-05arrest3
2026-01-12no arrest17
2026-01-12arrest7
2026-01-19no arrest22
2026-01-19arrest4
2026-01-26no arrest22
2026-01-26arrest2
2026-02-02no arrest17
2026-02-02arrest1
2026-02-09no arrest16
2026-02-09arrest2
2026-02-16no arrest25
2026-02-16arrest1
2026-02-23no arrest29
2026-02-23arrest0
2026-03-02no arrest13
2026-03-02arrest3
2026-03-09no arrest22
2026-03-09arrest1
2026-03-16no arrest31
2026-03-16arrest3
2026-03-23no arrest32
2026-03-23arrest7
2026-03-30no arrest20
2026-03-30arrest5
2026-04-06no arrest37
2026-04-06arrest4
2026-04-13no arrest19
2026-04-13arrest3
2026-04-20no arrest34
2026-04-20arrest2
2026-04-27no arrest33
2026-04-27arrest3
2026-05-04no arrest31
2026-05-04arrest5
2026-05-11no arrest25
2026-05-11arrest7
2026-05-18no arrest39
2026-05-18arrest1
2026-05-25no arrest34
2026-05-25arrest3
2026-06-01no arrest21
2026-06-01arrest1
2026-06-08no arrest33
2026-06-08arrest4
2026-06-15no arrest34
2026-06-15arrest8
2026-06-22no arrest28
2026-06-22arrest5
2026-06-29no arrest58
2026-06-29arrest14
2026-07-06no arrest29
2026-07-06arrest5
2026-07-13no arrest36
2026-07-13arrest0
2026-07-20no arrest27
2026-07-20arrest9
2026-07-27no arrest36
2026-07-27arrest4
2026-08-03no arrest27
2026-08-03arrest4
2026-08-10no arrest21
2026-08-10arrest3
2026-08-17no arrest43
2026-08-17arrest3
2026-08-24no arrest48
2026-08-24arrest7
2026-08-31no arrest38
2026-08-31arrest3
2026-09-07no arrest35
2026-09-07arrest6
2026-09-14no arrest43
2026-09-14arrest6
2026-09-21no arrest38
2026-09-21arrest9
2026-09-28no arrest11
2026-09-28arrest2

Figure 64. Find point clusters: Street light outages over time 139

periodseriesvalue
2025-10-01lamp failure15
2025-10-01cable fault3
2025-10-01vandalism6
2025-10-01collision1
2025-11-01lamp failure16
2025-11-01cable fault8
2025-11-01vandalism5
2025-11-01collision1
2025-12-01lamp failure17
2025-12-01cable fault11
2025-12-01vandalism8
2025-12-01collision7
2026-01-01lamp failure22
2026-01-01cable fault13
2026-01-01vandalism6
2026-01-01collision4
2026-02-01lamp failure19
2026-02-01cable fault6
2026-02-01vandalism9
2026-02-01collision9
2026-03-01lamp failure15
2026-03-01cable fault11
2026-03-01vandalism2
2026-03-01collision3
2026-04-01lamp failure23
2026-04-01cable fault6
2026-04-01vandalism8
2026-04-01collision2
2026-05-01lamp failure17
2026-05-01cable fault8
2026-05-01vandalism3
2026-05-01collision3
2026-06-01lamp failure20
2026-06-01cable fault4
2026-06-01vandalism5
2026-06-01collision3
2026-07-01lamp failure13
2026-07-01cable fault8
2026-07-01vandalism3
2026-07-01collision4
2026-08-01lamp failure13
2026-08-01cable fault8
2026-08-01vandalism3
2026-08-01collision4
2026-09-01lamp failure15
2026-09-01cable fault11
2026-09-01vandalism5
2026-09-01collision4
2026-10-01lamp failure4
2026-10-01cable fault3
2026-10-01vandalism1
2026-10-01collision2

Figure 65. Find point clusters: Incidents over time 140

periodseriesvalue
2025-09-29no arrest13
2025-09-29arrest3
2025-10-06no arrest20
2025-10-06arrest5
2025-10-13no arrest24
2025-10-13arrest5
2025-10-20no arrest19
2025-10-20arrest0
2025-10-27no arrest25
2025-10-27arrest6
2025-11-03no arrest31
2025-11-03arrest6
2025-11-10no arrest28
2025-11-10arrest3
2025-11-17no arrest24
2025-11-17arrest7
2025-11-24no arrest16
2025-11-24arrest4
2025-12-01no arrest21
2025-12-01arrest1
2025-12-08no arrest29
2025-12-08arrest3
2025-12-15no arrest26
2025-12-15arrest2
2025-12-22no arrest23
2025-12-22arrest1
2025-12-29no arrest27
2025-12-29arrest5
2026-01-05no arrest19
2026-01-05arrest3
2026-01-12no arrest17
2026-01-12arrest7
2026-01-19no arrest22
2026-01-19arrest4
2026-01-26no arrest22
2026-01-26arrest2
2026-02-02no arrest17
2026-02-02arrest1
2026-02-09no arrest16
2026-02-09arrest2
2026-02-16no arrest25
2026-02-16arrest1
2026-02-23no arrest29
2026-02-23arrest0
2026-03-02no arrest13
2026-03-02arrest3
2026-03-09no arrest22
2026-03-09arrest1
2026-03-16no arrest31
2026-03-16arrest3
2026-03-23no arrest32
2026-03-23arrest7
2026-03-30no arrest20
2026-03-30arrest5
2026-04-06no arrest37
2026-04-06arrest4
2026-04-13no arrest19
2026-04-13arrest3
2026-04-20no arrest34
2026-04-20arrest2
2026-04-27no arrest33
2026-04-27arrest3
2026-05-04no arrest31
2026-05-04arrest5
2026-05-11no arrest25
2026-05-11arrest7
2026-05-18no arrest39
2026-05-18arrest1
2026-05-25no arrest34
2026-05-25arrest3
2026-06-01no arrest21
2026-06-01arrest1
2026-06-08no arrest33
2026-06-08arrest4
2026-06-15no arrest34
2026-06-15arrest8
2026-06-22no arrest28
2026-06-22arrest5
2026-06-29no arrest58
2026-06-29arrest14
2026-07-06no arrest29
2026-07-06arrest5
2026-07-13no arrest36
2026-07-13arrest0
2026-07-20no arrest27
2026-07-20arrest9
2026-07-27no arrest36
2026-07-27arrest4
2026-08-03no arrest27
2026-08-03arrest4
2026-08-10no arrest21
2026-08-10arrest3
2026-08-17no arrest43
2026-08-17arrest3
2026-08-24no arrest48
2026-08-24arrest7
2026-08-31no arrest38
2026-08-31arrest3
2026-09-07no arrest35
2026-09-07arrest6
2026-09-14no arrest43
2026-09-14arrest6
2026-09-21no arrest38
2026-09-21arrest9
2026-09-28no arrest11
2026-09-28arrest2

GeoBit Large Spatial Model. Findings are labeled Evidenced (computed by a tool), Inferred (a reading or reasoning) or Unverified (no evidence yet).

The data

The files this sample uploads: synthetic data generated at a real place, except the real data listed below. Download any of them and add them to a project of your own.

DatasetKindRowsTime spanFile
Incidents
Reported incidents over twelve months, one point each, with category, severity and beat. Dated by reported_at (minute).
vector, Point1,6802025-10-01
to 2026-09-30
incidents.geojson
Street light outages
Street light outage reports by day, with repair dates and cause. Dated by reported_at (day).
vector, Point4202025-10-01
to 2026-09-30
streetlight_outages.geojson
Patrol beats
Patrol beat boundaries with population.
vector, Polygon16patrol_beats.geojson
Police stations
Police stations.
vector, Point3police_stations.geojson
CCTV cameras
City CCTV cameras.
vector, Point60cctv_cameras.geojson
Transit stops
Bus and rail stops with daily boardings.
vector, Point80transit_stops.geojson
Licensed premises
Bars, restaurants and liquor licenses.
vector, Point120licensed_premises.geojson
Roads
The real streets of the place from a public source, clipped to the sample, with class, speed limit and lanes. Real data: Roads: U.S. Census Bureau, 2024 TIGER/Line Shapefiles, All Roads, Cook County, Illinois (public domain), clipped to the sample and simplified.
vector, LineString1,033roads.geojson
Calls for service by beat and month
Monthly calls for service per beat (joins to Patrol beats on beat_id). Dated by month (month).
table3842024-10-01
to 2026-09-01
calls_for_service_monthly.csv
Beat staffing by shift
Officers and vehicles per beat and shift (joins to Patrol beats on beat_id).
table48beat_staffing.csv
Quarterly crime and safety briefing
A one-page briefing that names beats, stations and the transit center.
documentsafety_briefing_q3.md, safety_briefing_q3.pdf
Hot spot patrol plan
A patrol plan with a table of areas, shifts and units.
documentpatrol_plan_autumn.pdf, patrol_plan_autumn.md

What the data was built to show

  • A theft and robbery cluster around the Central Transit Center (41.87815, -87.63532).
  • A nightlife strip on N Elizabeth St that heats up on Friday and Saturday nights in summer.
  • A festival spike in the week of 2026-07-03.
  • Market West Beat (B02) gets worse month after month, and most street light outages sit there.

Expected analysis families: hot_spots, space_time, density, aggregation, clusters.

How the product read each dataset

The profile written when the data was added, before Start; no model call is needed for it.

  • Incidents: 1,680 point features; dated by 'reported_at' from 2025-10-01 to 2026-09-30; 'category' has 7 values (top: theft 539, battery 286, criminal damage 207); 'location_type' has 6 values (top: street 626, residence 351, business 274); 'severity' 1 to 5 (mean 2.587); extent -87.6800,41.8566 to -87.6078,41.9016.
  • Street light outages: 420 point features; dated by 'reported_at' from 2025-10-01 to 2026-09-30; 'cause' has 4 values (top: lamp failure 209, cable fault 100, vandalism 64); 'days_out' 1 to 60 (mean 6.95); extent -87.6803,41.8565 to -87.6125,41.9013.
  • Patrol beats: 16 polygon (area) features; 'district' has 1 values (top: District 12 16); 'population' 11,440 to 33,436 (mean 2.514e+04); 'officers_assigned' 6 to 12 (mean 9.75); named by 'name' (e.g. North River Beat, Market West Beat, Station Quarter Beat); total area 30.02 km2; extent -87.6804,41.8563 to -87.6076,41.9017.
  • Police stations: 3 point features; 'open_24h' has 2 values (top: False 2, True 1); 'officers' 97 to 139 (mean 124.7); named by 'name' (e.g. Central District Station, Westside Station, Riverside Station); extent -87.6671,41.8744 to -87.6210,41.8881.
  • CCTV cameras: 60 point features; 'ptz' has 2 values (top: False 41, True 19); 'status' has 2 values (top: live 45, fault 15); 'installed_year' 2,012 to 2,025 (mean 2018); extent -87.6796,41.8566 to -87.6139,41.9010.
  • Transit stops: 80 point features; 'mode' has 2 values (top: bus 74, rail 6); 'daily_boardings' 48 to 4,542 (mean 311.9); named by 'name' (e.g. Central Transit Center, Stop 002, Stop 003); extent -87.6794,41.8569 to -87.6138,41.9013.
  • Licensed premises: 120 point features; 'type' has 4 values (top: restaurant 57, bar 38, liquor store 13); 'closing_hour' 0 to 23 (mean 5.775); 'capacity' 32 to 350 (mean 124.8); extent -87.6794,41.8569 to -87.6140,41.9008.
  • Roads: 1,033 line features; 'class' has 4 values (top: local 814, other 181, motorway 25); 'speed_limit_mph' 25 to 35 (mean 25.37); 'lanes' 2 to 4 (mean 2.074); named by 'name' (e.g. Randolph St, W Arcade Pl, Harrison St); total length 509.7 km; extent -87.6804,41.8563 to -87.6077,41.9016.
  • Calls for service by beat and month: Table of 384 rows and 6 columns without geometry; dated by 'month' from 2024-10-01 to 2026-09-01; 'calls' 61 to 814 (mean 226.5); 'priority_1_calls' 9 to 139 (mean 35.84); 'median_response_min' 5.7 to 13.9 (mean 9.779).
  • Beat staffing by shift: Table of 48 rows and 5 columns without geometry; 'shift' has 3 values (top: day 16, evening 16, night 16); 'officers' 2 to 6 (mean 3.75); 'vehicles' 1 to 3 (mean 1.979); 'overtime_hours' 0 to 59 (mean 28.85).
  • Quarterly crime and safety briefing: 1-page md document 'Quarterly crime and safety briefing, third quarter 2026'; language en; mentions 7 place(s): Central Transit Center (2), Market West Beat (2), N Elizabeth St (2), Kingsway Beat (2), 41.87815, -87.63532 (1).
  • Hot spot patrol plan: 1-page pdf document 'Hot spot patrol plan'; language en; mentions 6 place(s): Central District Station (1), Westside Station (1), Riverside Station (1), Central Transit Center (1), Market West Beat (1).

Real data in this sample

  • Roads: U.S. Census Bureau, 2024 TIGER/Line Shapefiles, All Roads, Cook County, Illinois (public domain), clipped to the sample and simplified. Used for hot spots along streets, incidents near licensed premises and patrol routing.

Run this on your own data.

Sign up at lsm.geobit.ai, add your files, services and documents to a project, and get your own maps, charts and cited report.