mytown-research: surveillance_spending: 25 rows where ledger = "sv:drone:dji" sorted by amount descending

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

25 rows where ledger = "sv:drone:dji" sorted by amount descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	vendor	city	state	spend_date	product	amount ▲	quote	source_document	mytown_record	ledger	amount_type	dup_rank	geo_suspect	state_norm
3437	3437	DJI	Hingham	MA	2025-07-15	DJI Matrice drones (approve contract)	78353.0	Ms. Strehle made a motion to authorize the Town Administrator to sign the Agreement with Adorama Camera Incorporated for DJI MATRICE Model Drones to be used by the Police Department in an amount not to exceed $78,353.95.	https://www.hingham-ma.gov/AgendaCenter/ViewFile/Minutes/_07152025-10335	https://mytown.theboringparts.com/city/hingham-ma.gov/2025/#m505412	sv:drone:dji	ceiling	1	0	MA
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	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	MI
2531	2531	DJI	Snyder	TX	2024-02-05	DJI Mavic 3 Thermal Drones (approve purchase)	38159.0	Councilmember Jerry Webb made the motion to approve the purchase of 5 DJI Mavic 3 Thermal Drones from RMUS for $38,159.90 for Dept. 16.	https://www.ci.snyder.tx.us/AgendaCenter/ViewFile/Minutes/_02052024-446	https://mytown.theboringparts.com/city/ci.snyder.tx.us/#m1543487	sv:drone:dji	stated	1	0	TX
3650	3650	DJI	Lombard	IL	2021-09-01	Matrice 300 RTK drone (purchase)	29433.0	Staff recommendation to purchase one DJI Matrice 300 RTK sUAS with Zenmuse H20T camera and one DJI Mini 2 sUAS from Aerial Influence LLC in the amount of $29,433.00.	https://legistar1.granicus.com/Lombard/meetings/2021/9/6969_M_Public_Safety___Transportation_Committee__21-09-01_Minutes.pdf	https://mytown.theboringparts.com/city/lombard/2021/#m302033	sv:drone:dji	recommended	1	0	IL
2986	2986	DJI	Pottawatomie County	OK	2026-02-03	Matrice 4TD drone (purchase)	23826.0	A motion was made by Mrs. Dennis to approve emergency management to purchase a DJI Matrice 4TD drone from Unmanned Vehicle Technologies, LLC (state contract SW-10160) for $23,826.07 out of their sales tax account.	https://pottawatomiecook.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=5509,plainText=false)	https://mytown.theboringparts.com/city/pottawatomiecook/#m782595	sv:drone:dji	stated	1	0	OK
2412	2412	DJI	McLeod County	MN	2018-07-17	Matrice 210 drone (purchase)	23641.0	Consider approval of purchase of a DJI (Dà-Jiāng Innovations) Matrice 210 Drone and related equipment through Maverick Drone Systems (Savage, Minnesota) for $23,641.00.*	https://www.mcleodcountymn.gov/Agendas%20&%20Minutes/2016-2020/2018/20180717%20Meeting%20Minutes.pdf	https://mytown.theboringparts.com/city/rz-mcleodcountymn.gov/#m7982941	sv:drone:dji	stated	1	0	MN
2454	2454	DJI	Burnet County	TX	2026-07-14	Matrice 4TD drones (approve purchase)	22962.0	Two (2) DJI Matrice 4TD Drones in an amount not to exceed $22,962.	https://public.destinyhosted.com/agenda_publish.cfm?id=28763&mt=ALL&get_month=7&get_year=2026&dsp=min&seq=4587	https://mytown.theboringparts.com/city/aq-28763/#m6748058	sv:drone:dji	ceiling	1	1	TX
2931	2931	DJI	Pittsburg	CA	2024-03-18	UAV drones (purchase)	20000.0	i. DJI Matrice 210 V2, cost $20,000, quantity: 1.	https://pittsburgca.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1253,plainText=false)	https://mytown.theboringparts.com/city/pittsburgca/2024/#m812378	sv:drone:dji	stated	1	0	CA
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	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	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	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	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	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	MI
2494	2494	DJI	Logan County	KY	2025-08-26	DJI M30T drone (approve grant application)	14319.0	On motion of Chris Wilcutt duly seconded by Anne Crawford to approve the grant application from the Gary Sinise Foundation for a DJI M30T Public Safety Combo Drone with accessories from Fly High USA in the amount of $14,319.00 for the Logan County Sheriff’s Department.	https://www.logancountyky.gov/AgendaCenter/ViewFile/Minutes/_08262025-49	https://mytown.theboringparts.com/city/logancountyky.gov/#m1589883	sv:drone:dji	stated	1	0	KY
2677	2677	DJI	Meredith	NH	2024-08-26	drone (accept donated funds for purchase)	14189.0	The approximate cost is 14,189.99 DJI is the brand and there are no known maintenance costs.	https://www.meredithnh.org/AgendaCenter/ViewFile/Minutes/_08262024-124	https://mytown.theboringparts.com/city/meredithnh.org/2024/#m1365998	sv:drone:dji	estimated	1	0	NH
2508	2508	DJI	Starkville	MS	2024-12-03	Matrice 30T drone (approve grant contribution)	13300.0	Covert Drones: DJI Matrice 30T Thermal FPV Drone Advanced Public Safety Drone Bundle---$13,300.00	https://www.cityofstarkville.org/AgendaCenter/ViewFile/Minutes/_12032024-973	https://mytown.theboringparts.com/city/cityofstarkville.org/2024/#m1574538	sv:drone:dji	stated	1	0	MS
3468	3468	DJI	Waterloo	IA	2025-02-17	Matrice drone (purchase)	12451.0	Police (DJI Matrice Drone) Amount: $12,451.00 Expenditure: Purchase of a new drone for the WPD Drone Unit.	https://waterlooia.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1622,plainText=false)	https://mytown.theboringparts.com/city/waterlooia/2025/#m461499	sv:drone:dji	stated	1	0	IA
3456	3456	DJI	Cottage Grove	MN	2025-09-17	Matrice 4 Series drone (accept donation)	10536.0	Accept the donation of the DJI Matrice 4 Series drone with the value of $10,536.15.	https://cottagegrovemn.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1146,plainText=false)	https://mytown.theboringparts.com/city/cottagegrovemn/2025/#m470529	sv:drone:dji	stated	1	0	MN
2547	2547	DJI	Elizabeth	NJ	2024-11-26	DJI camera (award contract)	10217.0	Letter dated November 14, 2024, from the Business Administrator recommending awarding a contract to SHI International Corp., 290 Davidson Avenue, Somerset, NJ for the purchase of One DJI Zenmuse H30T Five-Module Camera for use with a Paladin Drone for the Elizabeth Police Department at the total cost of $10,217.39.	https://www.elizabethnj.org/AgendaCenter/ViewFile/Minutes/_11262024-398	https://mytown.theboringparts.com/city/elizabethnj.org/2024/#m1523001	sv:drone:dji	recommended	1	0	NJ
2651	2651	DJI	Stow	OH	2024-09-04	Matrice M30T drone (purchase)	8978.0	DJI MATRICE M30T DRONE $8,978.00	https://www.stowohio.gov/AgendaCenter/ViewFile/Minutes/_09042024-662	https://mytown.theboringparts.com/city/stowohio.gov/#m1390829	sv:drone:dji	stated	1	0	OH
2519	2519	DJI	Weirton	WV	2023-07-10	Mavic 3T Combo Drone (purchase)	7740.0	A Resolution to Authorize the City Manager to Enter into a Contract to Purchase One (1) DJI Mavic 3T Combo Drone to be Used for the City of Weirton Police Department ($7,740.00).	https://www.cityofweirton.com/AgendaCenter/ViewFile/Minutes/_07102023-423	https://mytown.theboringparts.com/city/cityofweirton.com/2023/#m1558707	sv:drone:dji	stated	1	0	WV
2627	2627	DJI	Schiller Park	IL	2023-06-15	Mavic 3T drone (purchase)	5498.0	Motion by Trustee Klug, seconded by Trustee Sheridan to purchase a DJI Mavic 3T drone from ABT for $5,498. Drug Asset funds will be used to purchase the drone and authorize the Village Manager to execute the necessary documents and undertake such action to effectuate same.	https://www.villageofschillerpark.com/AgendaCenter/ViewFile/Minutes/_06152023-1717	https://mytown.theboringparts.com/city/villageofschillerpark.com/2023/#m1397915	sv:drone:dji	stated	1	0	IL
3054	3054	DJI	Rock Island County	IL	2024-11-01	drone controller (purchase)	1600.0	DJI RC Plus Drone Controller-$1600.00-APPROVED	https://rockislandil.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=1084,plainText=false)	https://mytown.theboringparts.com/city/rockislandil/2024/#m734334	sv:drone:dji	stated	1	0	IL

Advanced export

JSON shape: default, array, newline-delimited

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