Reporter search: unusual surveillance technology

Search both the extracted product description and vendor name. Useful terms include ALPR, body camera, face recognition, drone, gunshot, CellHawk, cell site simulator, and StingRay. This is intentionally a lead generator. Open the source document before describing the technology: company names such as Motorola and L3Harris also appear on ordinary radios, dispatch systems, and unrelated municipal software.

Custom SQL query returning 1 row (hide) 

SELECT city, state_norm AS state, spend_date, vendor, product,
       amount, amount_type, dup_rank, geo_suspect, anomaly,
       quote, source_document, ledger
FROM surveillance_spending
WHERE (lower(COALESCE(product, '')) LIKE '%' || lower(:term) || '%'
       OR lower(COALESCE(vendor, '')) LIKE '%' || lower(:term) || '%'
       OR lower(COALESCE(quote, '')) LIKE '%' || lower(:term) || '%')
  AND (:state = '' OR state_norm = upper(:state))
ORDER BY state_norm, city, spend_date, vendor

Query parameters

Edit SQL

This data as json, CSV

citystatespend_datevendorproductamountamount_typedup_rankgeo_suspectanomalyquotesource_documentledger
Rialto CA 2024-09-10 Cell-site simulator (StingRay) Radio Frequency Detector/Cell Site Simulator (approve purchase) 930005.0 stated 1 0 0 Approve the Purchase of a Radio Frequency Detector/Cell Site Simulator in the Amount of $ 930,005.16 with Jacobs Technology Inc. ( JTI) https://legistar.granicus.com/Rialto/meetings/2024/9/3137_A_City_Council_24-09-10_Regular_Meeting.pdf sv:intercept:stingray