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

4 rows where ledger = "sv:rms:centralsquare", state = "AZ" and vendor = "CentralSquare" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, spend_date (date)

vendor 1

  • CentralSquare · 4 ✖

state 1

ledger 1

  • sv:rms:centralsquare · 4 ✖
Link rowid vendor city state spend_date product amount ▲ quote source_document mytown_record ledger amount_type dup_rank geo_suspect anomaly state_norm
3515 3515 CentralSquare Prescott AZ 2023-02-28 PSJ Enterprise Public Safety Software Maintenance and Support (approve contract) 165307.0 Approval of City Contract No. 2023-156 with CentralSquare Technologies for PSJ Enterprise Public Safety Software Maintenance and Support Using TIPS Contract No. 220105 Pricing in an Amount Not to Exceed $165,307.09 to be Equally Divided Between City of Prescott Fire & Police and all Non-City of Prescott Regional Communication Center Partners. https://prescottaz.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1613,plainText=false) https://mytown.theboringparts.com/city/prescottaz/2023/#m433471 sv:rms:centralsquare ceiling 1 0 0 AZ
3517 3517 CentralSquare Prescott AZ 2021-02-23 public safety software maintenance (approve contract) 152082.0 Approval of City Contract No. 2021-113 with CentralSquare Technologies in an Amount not to Exceed $152,082.27 for Inform Public Safety Software Maintenance and Support using Monterrey County, California, Contract No. A-13000 Pricing. https://prescottaz.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1627,plainText=false) https://mytown.theboringparts.com/city/prescottaz/2021/#m433287 sv:rms:centralsquare ceiling 1 0 0 AZ
2442 2442 CentralSquare Chandler AZ 2026-04-20 EAM system support (approve purchase) 120745.0 Move City Council approve the purchase of enterprise asset management (EAM) system annual support and maintenance from CentralSquare Technologies, LLC, in an amount not to exceed $120,745, for the period of one year, July 1, 2026, through June 30, 2027. https://public.destinyhosted.com/chanddocs/2026/CC/20260420_2222/2218_City-of-Chandler-City-Council-study-session-minutes-April-20-2026.pdf https://mytown.theboringparts.com/city/aq-24263/#m6751695 sv:rms:centralsquare ceiling 1 0 0 AZ
3516 3516 CentralSquare Prescott AZ 2021-08-10 asset management software (approve contract) 38441.0 Approval of City Contract No. 2022-038 with CentralSquare Technologies for Enterprise Asset Management Software Annual Technical Support and Maintenance in an Amount Not to Exceed $38,441.75. https://prescottaz.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1402,plainText=false) https://mytown.theboringparts.com/city/prescottaz/2021/#m433335 sv:rms:centralsquare ceiling 1 0 0 AZ

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);