Traffic Data Export Help File

******* NOTE ********

  NEW FILE LAYOUT - see below

******* NOTE ********

Two options are available:

        History, contains all traffic data end of last month back 7 years
        Weekly, contains traffic data from Sunday back to last Sunday.
                this one will also contain November of 2012 through current week for 2
                months

File Layout - traffic export

pipe (|) delimited - can load into excel, access or other database


violation date    yyyymmdd
citation number   7 characters  ******* CHANGED FIELD ******
check digit               1 character   ******* NEW FIELD *******
last name         up to 20 characters
first name        up to 20 characters
middle name       up to 20 characters
address           up to 50 characters
city              up to 30 characters
state             2 characters
zip               5 characters
fine amount       $$$
dl state          2 characters
dl number         up to 20 characters
dob               yyyymmdd
sex               M or F
charge description up to 40 characters
case number       16 characters
disposition date  yyyymmdd       ******* NEW FIELD *******
Uniform Case Num  20 (ALPHA)     ******* NEW FIELD *******

Traffic Data Sample

20200715|ACBHU8E||CASADO|JOSE|LUIS|120 BUCKLES DR|INTERLACHEN|FL|32148||FL|C230432650560|19650216|M|DRIVING WHILE LICENSE SUSPENDED OR REVOKED|2020001378CTAXMX||542020CT001378CTAXMX
20200720|AD2GLRE||PLATT|LOUIS|E|8228 CACTUS HILL DR|MELROSE|FL|32666||FL|P430525884200|19881120|M|NO MOTOR VEHICLE REGISTRATION|2020001391CTAXMX||542020CT001391CTAXMX
20200720|AD2GLSE||PLATT|LOUIS|E|8228 CACTUS HILL DR|MELROSE|FL|32666||FL|P430525884200|19881120|M|DRIVING WHILE LICENSE CANCELED, SUSPENDED OR REVOKED|2020001390CTAXMX||542020CT001390CTAXMX
20200722|AD2GA4E||HENDERSON|KIEVON|ISIAH|304 OCEAN ST|PALATKA|FL|32177||FL|H536509034010|20031101|M|DL NOT CARRIED/EXHIBIT ON DEMAND|2020001838TRAXMX|20200729|542020TR001838TRAXMX
20200722|AD2GCKE||BRINSON|DEZARAE|MONIQUE|141 FIRST WAY|INTERLACHEN|FL|32148||FL|B652173979480|19971208|F|UNLAWFUL SPEED-CONSTRUCTION ZONE|2020001876TRAXMX||542020TR001876TRAXMX
20200722|AD2GCLE||BRINSON|DEZARAE|MONIQUE|141 FIRST WAY|INTERLACHEN|FL|32148||FL|B652173979480|19971208|F|POSSESSION OF OPEN CONTAINER IN MOTOR VEHICLE (PASSANGER SITED)|2020001874TRAXMX||542020TR001874TRAXMX
20200722|AD2GCME||BOSTIC|DOMINIQUE|ADONNIS|306 NE BAY AVE|MICANOPY|FL|32667||FL|B232161953460|19950926|M|POSSESSION OF OPEN CONTAINER IN MOTOR VEHICLE (PASSANGER SITED)|2020001875TRAXMX||542020TR001875TRAXMX
20200723|AD2GITE||MAGEE|BYRON|ANTUAN|14788 FERN HAMMOCK DR|JACKSONVILLE|FL|32258||FL|M200061740630|19740223|M|UNLAWFUL SPEED|2020001877TRAXMX||542020TR001877TRAXMX
20200724|ACBZWSE||HERNANDEZ-PEREZ|JOSE|ROBERTO|131 DOGWOOD AVE|GEORGETOWN|FL|32139||FL|H655436814410|19811201|M|EXPIRED DRIVERS LICENSE - MORE THAN 6 MONTHS|2020001380CTAXMX||542020CT001380CTAXMX
