surveillance_spending

A DISCOVERY INDEX of surveillance and police-technology dollar figures found in local government meeting records across 130+ named vendors — NOT a table of confirmed spending, and NOT safe to SUM. An audit on 2026-07-29 found aggregate views were adding amounts that must not be added: the same procurement recurs at committee, council, approval, amendment and renewal stages; "not to exceed" figures are authorization ceilings, not payments. Use the canned query "the CONSERVATIVE total" for any number you intend to publish, and "data-quality report" to see what is flagged. Columns added for this: `amount_type` (stated / ceiling / proposed / recommended / estimated), `dup_rank` (>1 = redundant copy), `geo_suspect` (city disagrees with the source link), `anomaly` (implausible figure), `state_norm` (normalized state). Vendors covered include ALPR (Flock, Vigilant, Genetec), body cameras/tasers (Axon, WatchGuard, Utility, Getac), gunshot detection (ShotSpotter/SoundThinking), face recognition (Clearview AI, DataWorks Plus), fingerprint biometrics (Idemia AFIS/Livescan, filed separately under `sv:biometrics`), data fusion and OSINT (Fusus, Peregrine, LexisNexis Accurint, Thomson Reuters CLEAR), phone forensics (Cellebrite, GrayKey, Magnet), drones (Skydio, BRINC, DJI), cameras/VMS (Verkada, Avigilon), cell-site simulators, CAD/RMS records systems, photo enforcement, jail-call and student monitoring. Every row carries a VERBATIM quote from the minutes and a link to the source document, and a row only publishes if that quote was found character-for-character in the source text. READ THE `ledger` COLUMN: `sv:<category>:<vendor>`. `radio_infra` (two-way radios), `rms` (records/CAD software), `biometrics` (fingerprints) and `not_surveillance` are NOT surveillance sensors — exclude them before quoting any surveillance figure.

Data license: CC BY 4.0 · Data source: MyTown

9 rows where ledger = "sv:rms:centralsquare" and state = "IL" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, spend_date, product, amount, quote, amount_type, dup_rank, spend_date (date)

vendor 1

state 1

ledger 1

  • sv:rms:centralsquare · 9 ✖
Link rowid vendor city state spend_date product amount ▲ quote source_document mytown_record ledger amount_type dup_rank geo_suspect anomaly state_norm
3633 3633 CentralSquare Naperville IL 2023-09-05 CAD/RMS software maintenance (award) 423407.0 Approve the award of Sole Source Procurement 23-190, Naviline Public Administration and Public Safety CAD/RMS Software Maintenance and Support, to Central Square Technologies for an amount not to exceed $423,407.41 and for a one-year term https://naperville.legistar1.com/naperville/meetings/2023/9/3041_M_City_Council_23-09-05_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/naperville/2023/#m325311 sv:rms:centralsquare ceiling 1 0 0 IL
3634 3634 CentralSquare Naperville IL 2022-09-20 CAD/RMS software maintenance (award) 414875.0 Approve the award of Sole Source Procurement 22-257, Naviline Public Administration and Public Safety CAD/RMS Software Maintenance and Support, to CentralSquare Technologies for an amount not to exceed $414,875.31 and for a one-year term https://naperville.legistar1.com/naperville/meetings/2022/9/2770_M_City_Council_22-09-20_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/naperville/2022/#m325170 sv:rms:centralsquare ceiling 1 0 0 IL
3635 3635 CentralSquare Naperville IL 2021-10-05 CAD/RMS maintenance (award sole source procurement) 399461.0 Approve the award of Sole Source Procurement 21-335, Naviline Public Administration and Public Safety CAD/RMS Software Maintenance and Support, to CentralSquare Technologies for an amount not to exceed $399,461 and for a one-year term https://naperville.legistar1.com/naperville/meetings/2021/10/2532_M_City_Council_21-10-05_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/naperville/2021/#m325012 sv:rms:centralsquare ceiling 1 0 0 IL
3630 3630 CentralSquare Naperville IL 2024-07-16 Naviline CAD/RMS maintenance (award sole source procurement) 321155.0 Approve the award of Sole Source Procurement 24-184, Naviline Public Administration and Public Safety CAD/RMS Software Maintenance and Support, to CentralSquare Technologies, for an amount not to exceed $321,155.44 and for a one-year term https://naperville.legistar1.com/naperville/meetings/2024/7/3125_M_City_Council_24-07-16_Meeting_Minutes.pdf https://mytown.theboringparts.com/city/naperville/2024/#m325443 sv:rms:centralsquare ceiling 1 0 0 IL
3277 3277 CentralSquare Quincy IL 2025-05-28 cloud hosting services (approve contract) 28220.0 with the option for automatic one (1) year renewal with CentralSquare Technologies, LLC of Lake Mary, FL and an additional payment of $28,220.44 to CentralSquare Technologies for year one (1) fees per the agreement terms. https://quincyil.granicus.com/AgendaViewer.php?view_id=3&clip_id=26 https://mytown.theboringparts.com/city/gr-quincyil/2025/#m582100 sv:rms:centralsquare stated 1 0 0 IL
3278 3278 CentralSquare Quincy IL 2025-05-28 cloud hosting services (approve contract) 28220.0 with the option for automatic one (1) year renewal with CentralSquare Technologies, LLC of Lake Mary, FL and an additional payment of $28,220.44 to CentralSquare Technologies for year one (1) fees per the agreement terms. https://quincyil.granicus.com/AgendaViewer.php?view_id=3&clip_id=25 https://mytown.theboringparts.com/city/gr-quincyil/2025/#m582099 sv:rms:centralsquare stated 2 0 0 IL
3279 3279 CentralSquare Quincy IL 2025-05-28 cloud hosting services (approve contract) 28220.0 Resolution for NaviLine Cloud Solutions software and cloud-based hosting services for a term beginning on June 1, 2025, and ending on May 31, 2030, with the option for automatic one (1) year renewal with CentralSquare Technologies, LLC of Lake Mary, FL and an additional payment of $28,220.44 to CentralSquare Technologies for year one (1) fees per the agreement terms. https://quincyil.granicus.com/AgendaViewer.php?view_id=3&clip_id=24 https://mytown.theboringparts.com/city/gr-quincyil/2025/#m582098 sv:rms:centralsquare stated 2 0 0 IL
3280 3280 CentralSquare Quincy IL 2025-05-28 cloud hosting services (approve contract) 28220.0 with the option for automatic one (1) year renewal with CentralSquare Technologies, LLC of Lake Mary, FL and an additional payment of $28,220.44 to CentralSquare Technologies for year one (1) fees per the agreement terms. https://quincyil.granicus.com/AgendaViewer.php?view_id=3&clip_id=23 https://mytown.theboringparts.com/city/gr-quincyil/2025/#m582097 sv:rms:centralsquare stated 3 0 0 IL
3282 3282 CentralSquare Quincy IL 2026-05-11 Cognos upgrade/support (approve quote) 15840.0 Information Technology Director and City Comptroller recommending approval of the quote from CentralSquare Technologies, Inc. in the amount of $15,840.00 for the upgrade, support, and training of Cognos. https://quincyil.granicus.com/AgendaViewer.php?view_id=3&clip_id=125 https://mytown.theboringparts.com/city/gr-quincyil/#m582059 sv:rms:centralsquare recommended 1 0 0 IL

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE surveillance_spending (
  vendor TEXT, city TEXT, state TEXT, spend_date TEXT, product TEXT,
  amount REAL, quote TEXT, source_document TEXT, mytown_record TEXT, ledger TEXT, amount_type TEXT, dup_rank INTEGER, geo_suspect INTEGER, anomaly INTEGER, state_norm TEXT);
CREATE INDEX ix_surv_vendor ON surveillance_spending(vendor);
CREATE INDEX ix_surv_state ON surveillance_spending(state);
CREATE INDEX ix_surv_amount ON surveillance_spending(amount);
CREATE INDEX ix_surv_ledger ON surveillance_spending(ledger);