Dump the full ADOT crash record by IncidentId

php ver: 70215 using sql server: azbikelaw.entrydns.org
dump another incident

incident not found in year 2009
incident not found in year 2010
incident not found in year 2011
incident not found in year 2012
incident not found in year 2013
incident not found in year 2014
incident not found in year 2015
incident not found in year 2016
incident not found in year 2017
3459258 2018-12-06 20:36:00 Broadway Rd / 07  52ND                ST      
number of bicyclists / drivers / pedestrians involved: 1 / 1 / 0
Here is Stderr output (if any):

Query Results download:

*************************** 1. row ***************************
                 sF_Bicycle: 1
              sF_Pedestrian: 0
                sF_Motorist: 1
                sF_OtherUnk: 0
              sF_Motorcycle: 0
                 IncidentID: 3459258
                  Microfilm: 0
           ADOTReceivedDate: 2018-12-31 00:00:00
                     Status: 200
           DataConv2008Flag: -1
               IncidentDate: 2018-12-06
           IncidentDateTime: 2018-12-06 20:36:00
               IncidentYear: 2018
              IncidentMonth: 12
          IncidentDayOfWeek: 5
               IncidentHour: 20
                OfficerNcic: 729
                  OfficerId: 19343
                 FileNumber: 18147383
               ExtendedNcic: 729
        DamageOverLimitFlag: 1
            PhotosTakenFlag: -1
           PhotographerName: 
             PhotographerID: 0
         PhotographerAgency: 
    InvestigatedAtSceneFlag: -1
       DateTimeInvestigated: 1900-01-01 00:00:00
            CollisionManner: ANGLE_FRONT_TO_SIDE
             LightCondition: DARK_LIGHTED
          FirstHarmfulEvent: PEDALCYCLE
       FirstHarmfulLocation: NOT_REPORTED_255
                 TotalUnits: 2
             TotalMotorists: 1
          TotalNonMotorists: 1
              TotalInjuries: 0
            TotalFatalities: 1
     TotalMotoristsInjuries: 0
  TotalNonMotoristsInjuries: 0
   TotalMotoristsFatalities: 0
TotalNonMotoristsFatalities: 1
             InjurySeverity: 5
       MedicalTransportFlag: 0
          FatalAccidentFlag: 1
                TowAwayFlag: 1
              NscReportable: FATALS_INJURIES_OR_PROPERTY_DAMAGE_OVER_1000
       SchoolBusRelatedFlag: 0
        WorkZoneRelatedFlag: 0
         WorkersPresentFlag: -1
     AlcoholInvolvementFlag: Not Available
        DrugInvolvementFlag: Not Available
              HazardousFlag: 0
              HitAndRunFlag: 0
                     OnRoad: Broadway Rd
            CrossingFeature: 07  52ND                ST      
                     Offset: 0
         OffsetMeasuredFlag: 0
                 OffsetUnit: 1
                      MPNum: 0
                   MPOffset: 0
                     CityId: 295
                   CountyId: 13
                    StateId: 3
                  StateCode: AZ
                CountryCode: US
                   Latitude: 33.4092408400076
                  Longitude: -111.969523889616
          ValidLocationFlag: 1
        LocationToolVersion: NOV2018
        HESIntersectionFlag: 1
           IntersectionFlag: 0
        IntersectionRouteID: 11883
       IntersectionATISCode: 07  52ND                ST      
             TrafficWayType: TWO_WAY_DIVIDED_UNPROTECTED_PAINTED_4_FEET_MEDIAN
           IntersectionType: NOT_REPORTED_255
           JunctionRelation: INTERSECTION_4_WAY
                    Weather: CLOUDY
    PropertyDamageOwnerCode: NOT_APPLICABLE_MINUS_1
     PropertyDamageDescCode: -1
            OffsetDirection: 0
         SecondaryCrashFlag: 0
*************************** 1. row ***************************
         IncidentID: 3459258
             UnitID: 1718032148
         UnitNumber: 1
           PersonID: 1726567343
       PersonNumber: 1
         PersonType: PEDALCYCLIST
            ZipCode: 0
                Age: 59
                Sex: M
       SeatPosition: 255
       SafetyDevice: NONE_USED
             Airbag: UNKNOWN_99
       InjuryStatus: FATAL
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: AT_INTERSECTION_NOT_IN_CROSSWALK
     AlcoholUseFlag: -1
          BACResult: -1
          TestTypeA: MINUS_1
        DrugUseFlag: -1
           DrugType: MINUS_1
          TestTypeD: -1
    TransportSource: MINUS_1
      TransportedTo: No Data
         InjuryArea: -1
         InjuryDesc: -1
         Violation1: DISREGARDED_TRAFFIC_SIGNAL
         Violation2: NOT_APPLICABLE_0
*************************** 2. row ***************************
         IncidentID: 3459258
             UnitID: 1718031471
         UnitNumber: 2
           PersonID: 1726567440
       PersonNumber: 1
         PersonType: DRIVER
            ZipCode: 0
                Age: 29
                Sex: M
       SeatPosition: 11
       SafetyDevice: SHOULDER_AND_LAP_BELT
             Airbag: NOT_DEPLOYED
       InjuryStatus: NO_INJURY
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: NOT_REPORTED_255
     AlcoholUseFlag: -1
          BACResult: -1
          TestTypeA: MINUS_1
        DrugUseFlag: -1
           DrugType: MINUS_1
          TestTypeD: -1
    TransportSource: MINUS_1
      TransportedTo: No Data
         InjuryArea: -1
         InjuryDesc: -1
         Violation1: NO_IMPROPER_ACTION
         Violation2: NOT_APPLICABLE_0
*************************** 1. row ***************************
        IncidentID: 3459258
            UnitID: 1718032148
        UnitNumber: 1
          UnitType: PEDALCYCLIST
   TravelDirection: SOUTH
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: UNKNOWN_99
        UnitAction: GOING_STRAIGHT_AHEAD
  MostHarmfulEvent: NOT_REPORTED_255
     HitAndRunFlag: 0
    RoadCondition1: NO_CONTRIBUTING_CIRCUMSTANCES
    RoadCondition2: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc2: 
  VehicleStateCode: --
           RegYear: 1900
     BodyStyleDesc: No Data
          MakeDesc: No Data
         ColorDesc: No Data
           BusFlag: -1
          GVWRFlag: -1
        HazmatFlag: -1
       PostedSpeed: 0
    EstimatedSpeed: 0
      DisabledFlag: -1
        DamageArea: UNDEFINED_MINUS_1
       DefectDesc1: No Data
       DefectDesc2: 
    EventSequence1: MOTOR_VEHICLE_IN_TRANSPORT
    EventSequence2: BLANK_0
    EventSequence3: BLANK_0
    EventSequence4: BLANK_0
       ControlType: SIGNAL
 SurfaceCondition1: DRY
 DistractedDriving: 99
eDistractedDriving: UNKNOWN_DISTRACTION_99
*************************** 2. row ***************************
        IncidentID: 3459258
            UnitID: 1718031471
        UnitNumber: 2
          UnitType: DRIVER
   TravelDirection: WEST
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: LANE_1
        UnitAction: GOING_STRAIGHT_AHEAD
  MostHarmfulEvent: NOT_REPORTED_255
     HitAndRunFlag: 0
    RoadCondition1: NO_CONTRIBUTING_CIRCUMSTANCES
    RoadCondition2: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc2: 
  VehicleStateCode: AZ
           RegYear: 1900
     BodyStyleDesc: PASSENGER_4DSD_SEDAN_4_DR
          MakeDesc: LEXS_LEXUS
         ColorDesc: WHI_WHITE
           BusFlag: 0
          GVWRFlag: 0
        HazmatFlag: 0
       PostedSpeed: 45
    EstimatedSpeed: 49
      DisabledFlag: 0
        DamageArea: UNDEFINED_MINUS_1
       DefectDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
       DefectDesc2: 
    EventSequence1: PEDALCYCLE
    EventSequence2: BLANK_0
    EventSequence3: BLANK_0
    EventSequence4: BLANK_0
       ControlType: SIGNAL
 SurfaceCondition1: DRY
 DistractedDriving: 0
eDistractedDriving: NOT_DISTRACTED_0