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

8 rows where state = "MI" and vendor = "DJI" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

vendor 1

state 1

ledger 1

Link rowid vendor city state spend_date product amount ▲ quote source_document mytown_record ledger amount_type dup_rank geo_suspect anomaly state_norm
3046 3046 DJI Macomb County MI 2024-11-21 DJI Matrice 350 RTK Drone (purchase) 51870.0 Purchase: NOAR Technologies - (1) DJI Matrice 350 RTK Drone with Thermal and LiDAR Cameras for Public Works ($51,870) https://macombcomi.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=20604,plainText=false) https://mytown.theboringparts.com/city/macombcomi/2024/#m740264 sv:drone:dji stated 1 0 0 MI
3048 3048 DJI Macomb County MI 2024-11-19 DJI Matrice 350 RTK (purchase) 51870.0 approve the purchase with NOAR Technologies to provide one (1) DJI Matrice 350 RTK Drone with Thermal and LiDAR Cameras in the amount of $51,870 for Public Works. https://macombcomi.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=20571,plainText=false) https://mytown.theboringparts.com/city/macombcomi/2024/#m740260 sv:drone:dji stated 1 0 0 MI
3003 3003 DJI Fraser MI 2025-07-10 two drones (approve purchase) 18117.0 Motion by Schornak, supported by Baranski to approve the purchase of two DJI drones with equipment and software as outlined in the quote from NOAR Technologies for a total purchase cost of $18,117.00, with $5,000 being reimbursed to the City of Fraser by 14 House Firefighters Association on the condition that the money comes from the Gambling Forfeiture Fund. https://frasermi.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=3777,plainText=false) https://mytown.theboringparts.com/city/frasermi/2025/#m760322 sv:drone:dji stated 1 0 0 MI
3004 3004 DJI Fraser MI 2025-07-10 two drones (approve purchase) 18117.0 Motion by Schornak, supported by Baranski to approve the purchase of two DJI drones with equipment and software as outlined in the quote from NOAR Technologies for a total purchase cost of $18,117.00, with $5,000 being reimbursed to the City of Fraser by 14 House Firefighters Association on the condition that the money comes from the Gambling Forfeiture Fund. https://frasermi.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=3610,plainText=false) https://mytown.theboringparts.com/city/frasermi/2025/#m760321 sv:drone:dji stated 2 0 0 MI
3005 3005 DJI Fraser MI 2025-06-12 drones with equipment and software (approve purchase) 18117.0 Motion by Schornak, supported by Baranski to approve the purchase of two DJI drones with equipment and software as outlined in the quote from NOAR Technologies, at a purchase price of $18,117.00. https://frasermi.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=3772,plainText=false) https://mytown.theboringparts.com/city/frasermi/2025/#m760316 sv:drone:dji stated 1 0 0 MI
3006 3006 DJI Fraser MI 2025-06-12 drones with equipment and software (approve purchase) 18117.0 Motion by Schornak, supported by Baranski to approve the purchase of two DJI drones with equipment and software as outlined in the quote from NOAR Technologies, at a purchase price of $18,117.00. https://frasermi.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=3770,plainText=false) https://mytown.theboringparts.com/city/frasermi/2025/#m760315 sv:drone:dji stated 2 0 0 MI
3007 3007 DJI Fraser MI 2025-06-12 drones with equipment and software (approve purchase) 18117.0 Motion by Schornak, supported by Baranski to approve the purchase of two DJI drones with equipment and software as outlined in the quote from NOAR Technologies, at a purchase price of $18,117.00. https://frasermi.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=3600,plainText=false) https://mytown.theboringparts.com/city/frasermi/2025/#m760314 sv:drone:dji stated 3 0 0 MI
3008 3008 DJI Fraser MI 2025-06-12 drones with equipment (approve purchase) 18117.0 Motion by Schornak, supported by Baranski to approve the purchase of two DJI drones with equipment and software as outlined in the quote from NOAR Technologies, at a purchase price of $18,117.00. https://frasermi.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=3596,plainText=false) https://mytown.theboringparts.com/city/frasermi/2025/#m760313 sv:drone:dji stated 4 0 0 MI

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