Ad Hoc Queries: Difference between revisions

From TraCS Florida Wiki
No edit summary
No edit summary
Line 1: Line 1:
[[Image:Wiki_Under_Construction.jpg]]
===Overview===
===Overview===


Line 36: Line 38:


====FIBRS Incident Count - Location & Zone====
====FIBRS Incident Count - Location & Zone====
====FIR With Race and Gender - ''Coming in a future release''====


====Parking Citations and Warnings====
====Parking Citations and Warnings====
Line 41: Line 45:
====Speeding Citations With Posted Speed & Violator Speed====
====Speeding Citations With Posted Speed & Violator Speed====


====Boating Citations and Warnings====
====Traffic Warning Search with DOB====


====Boating Citations and Warnings====
====Trespass Warnings Name and Address Search====


====Boating Citations and Warnings====
====UAA Search With Age====


====Boating Citations and Warnings====
====UTC by Location====


====Boating Citations and Warnings====
====UTC Crashes & Aggressive Driving====


====Boating Citations and Warnings====
====UTC Search with DOB====


====Boating Citations and Warnings====
====UTC Seatbelt Violations Written for Crash Reports====
 
====Boating Citations and Warnings====


====Boating Citations and Warnings====
====UTC Speeding in School Zone====


====Boating Citations and Warnings====
====UTC Top Violations====


====Boating Citations and Warnings====
====UTC's Written for Crashes====


====Boating Citations and Warnings====
====Voided & Deleted Citations With Officer Name & Violator Name====


====Warnings With Race, Gender, and Officer Name====


[[Image:Wiki_Under_Construction.jpg]]
====Warnings by Location====

Revision as of 13:12, 8 May 2024

Overview

There are several pre-built Ad Hoc queries available within TraCS.

All TraCS users may access them by going to the Advanced tab and then choosing AdHoc Queries.

Right click in the white space and click Import.
Select the ad hoc query that you wish to import and then press Open.
The query will open to the search criteria screen.
Press Finish and the query will appear on your list.
Repeat for any additional queries that you wish to use.

If you would like to create your own ad hoc query, see the How to Create an Ad Hoc Query page.

Available Ad Hoc Queries

Boating Citations and Warnings

CFS Location by Date

Crashes by Location

Crashes With Approving Supervisor

Crashes With Bicyclists and Pedestrians

Crashes With Motorcycles

Crashes With Citations Issued

Crashes With Motorcycles

Crashes With Suspected Alcohol or Drug Use

FIBRS Crime Stats

FIBRS Incident Count - Location & Zone

FIR With Race and Gender - Coming in a future release

Parking Citations and Warnings

Speeding Citations With Posted Speed & Violator Speed

Traffic Warning Search with DOB

Trespass Warnings Name and Address Search

UAA Search With Age

UTC by Location

UTC Crashes & Aggressive Driving

UTC Search with DOB

UTC Seatbelt Violations Written for Crash Reports

UTC Speeding in School Zone

UTC Top Violations

UTC's Written for Crashes

Voided & Deleted Citations With Officer Name & Violator Name

Warnings With Race, Gender, and Officer Name

Warnings by Location