Dump the full ADOT crash record by IncidentId

using sql server: azbikelaw.entrydns.org
dump another incident

incident not found in year 2009
2472764 2010-10-04 16:35:00 Bell Rd                          / Interstate 17
number of bicyclists / drivers / pedestrians involved: 1 / 1 / 0
Here is Stderr output (if any):

Query Results download:

*************************** 1. row ***************************
                 IncidentID: 2472764
                  Microfilm: 20021870
           ADOTReceivedDate: 2010-11-03 00:00:00
                     Status: 200
           DataConv2008Flag: 1
               IncidentDate: 2010-10-04
           IncidentDateTime: 2010-10-04 16:35:00
               IncidentYear: 2010
              IncidentMonth: 10
          IncidentDayOfWeek: 2
               IncidentHour: 16
                OfficerNcic: 723
                  OfficerId: 8222
                 FileNumber: 16387
               ExtendedNcic: 723
        DamageOverLimitFlag: 1
            PhotosTakenFlag: -1
           PhotographerName: 
             PhotographerID: 0
         PhotographerAgency: 
    InvestigatedAtSceneFlag: -1
       DateTimeInvestigated: 1900-01-01 00:00:00
            CollisionManner: OTHER_97
             LightCondition: DAYLIGHT
          FirstHarmfulEvent: PEDALCYCLE
       FirstHarmfulLocation: ROADSIDE
                 TotalUnits: 2
             TotalMotorists: 1
          TotalNonMotorists: 1
              TotalInjuries: 1
            TotalFatalities: 0
     TotalMotoristsInjuries: 0
  TotalNonMotoristsInjuries: 1
   TotalMotoristsFatalities: 0
TotalNonMotoristsFatalities: 0
             InjurySeverity: 3
       MedicalTransportFlag: -1
          FatalAccidentFlag: 0
                TowAwayFlag: 0
              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: Bell Rd                         
            CrossingFeature: Interstate 17
                     Offset: -0.0625
         OffsetMeasuredFlag: -1
                 OffsetUnit: 1
                      MPNum: 0
                   MPOffset: 0
                     CityId: 214
                   CountyId: 13
                    StateId: 3
                  StateCode: AZ
                CountryCode: US
                   Latitude: 33.6398431477427
                  Longitude: -112.11845436697
          ValidLocationFlag: -1
        LocationToolVersion: 2008 DCU
        HESIntersectionFlag: 1
           IntersectionFlag: 1
        IntersectionRouteID: 948
       IntersectionATISCode:   I 017                       2 
             TrafficWayType: TWO_WAY_DIVIDED_POSITIVE_MEDIAN_BARRIER
           IntersectionType: NOT_AT_INTERSECTION_0
           JunctionRelation: NOT_JUNCTION_RELATED_0
                    Weather: RAIN
    PropertyDamageOwnerCode: UNKNOWN_99
    PropertyDamageDes
cCode: 41
*************************** 1. row ***************************
         IncidentID: 2472764
             UnitID: 4680791
         UnitNumber: 2
           PersonID: 6965722
       PersonNumber: 1
         PersonType: DRIVER
            ZipCode: 0
                Age: 60
                Sex: F
       SeatPosition: 11
       SafetyDevice: SHOULDER_AND_LAP_BELT
             Airbag: UNKNOWN_99
       InjuryStatus: NO_INJURY
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: NON_APPLICABLE_0
     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
*************************** 2. row ***************************
         IncidentID: 2472764
             UnitID: 4679507
         UnitNumber: 1
           PersonID: 6966703
       PersonNumber: 1
         PersonType: PEDALCYCLIST
            ZipCode: 0
                Age: 55
                Sex: F
       SeatPosition: 51
       SafetyDevice: HELMET_USED
             Airbag: NOT_APPLICABLE_0
       InjuryStatus: NON_INCAPACITATING_INJURY
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: UNKNOWN_99
     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: OTHER_97
         Violation2: NOT_APPLICABLE_0
*************************** 1. row ***************************
       IncidentID: 2472764
           UnitID: 4679507
       UnitNumber: 1
         UnitType: PEDALCYCLIST
  TravelDirection: WEST
    RoadAlignment: UNKNOWN_99
        RoadGrade: LEVEL
             Lane: NON_ROADWAY_97
       UnitAction: GOING_STRAIGHT_AHEAD
 MostHarmfulEvent: UNKNOWN_99
    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: NOT_APPLICABLE_MINUS_1
   EventSequence2: BLANK_0
   EventSequence3: BLANK_0
   EventSequence4: BLANK_0
      ControlType: UNDEFINED_MINUS_1
SurfaceCondition1: WET
*************************** 2. row ***************************
       IncidentID: 2472764
           UnitID: 4680791
       UnitNumber: 2
         UnitType: DRIVER
  TravelDirection: NORTH
    RoadAlignment: UNKNOWN_99
        RoadGrade: UNKNOWN_99
             Lane: UNKNOWN_99
       UnitAction: OTHER_97
 MostHarmfulEvent: UNKNOWN_99
    HitAndRunFlag: 0
   RoadCondition1: NO_CONTRIBUTING_CIRCUMSTANCES
   RoadCondition2: NO_CONTRIBUTING_CIRCUMSTANCES
EnvConditionDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
EnvConditionDesc2: 
 VehicleStateCode: AZ
          RegYear: 1900
    BodyStyleDesc: PASSENGER_SD_SEDAN
         MakeDesc: UNKNOWN
        ColorDesc: UNKNOWN
          BusFlag: 0
         GVWRFlag: 0
       HazmatFlag: 0
      PostedSpeed: 45
   EstimatedSpeed: 5
     DisabledFlag: 0
       DamageArea: UNDEFINED_MINUS_1
      DefectDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
      DefectDesc2: 
   EventSequence1: NOT_APPLICABLE_MINUS_1
   EventSequence2: BLANK_0
   EventSequence3: BLANK_0
   EventSequence4: BLANK_0
      ControlType: UNKNOWN_99
SurfaceCondition1: WET