Name: Vehicle_KABCO_12_22

Display Field: CID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CID (type: esriFieldTypeString, alias: Crash Id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CIDUID (type: esriFieldTypeString, alias: Vehicle Id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CrashYear (type: esriFieldTypeInteger, alias: Crash Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DrvAlcInv (type: esriFieldTypeInteger, alias: Driver Alcohol Inv., SQL Type: sqlTypeOther, nullable: true, editable: true)
• DrvDrugInv (type: esriFieldTypeInteger, alias: Driver Drug Inv., SQL Type: sqlTypeOther, nullable: true, editable: true)
• VehDir (type: esriFieldTypeString, alias: Vehicle Direction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehSt (type: esriFieldTypeString, alias: Street Vehicle Traveling On, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PostdSpd (type: esriFieldTypeString, alias: Posted Speed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SafeSpd (type: esriFieldTypeString, alias: Safe Speed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NumKVeh (type: esriFieldTypeInteger, alias: Num. Of. Class K In Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumAVeh (type: esriFieldTypeInteger, alias: Num. Of Class A In Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumBVeh (type: esriFieldTypeInteger, alias: Num. Of Class B In Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumCVeh (type: esriFieldTypeInteger, alias: Num. Of Class C In Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumOVeh (type: esriFieldTypeInteger, alias: Num.Of Class O In Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotPeoVeh (type: esriFieldTypeInteger, alias: Total Num. Of Ppl In Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PsgVeh (type: esriFieldTypeInteger, alias: Passengers In Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DrvSeatPos (type: esriFieldTypeString, alias: Driver Seat Position, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DriverAge (type: esriFieldTypeString, alias: Driver Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DriverSex (type: esriFieldTypeString, alias: Driver Sex, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DriverRes (type: esriFieldTypeString, alias: Driver Residence, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DriverInj (type: esriFieldTypeString, alias: Driver Injury, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvOccPr (type: esriFieldTypeString, alias: Driver Occupant Protection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvPruse (type: esriFieldTypeString, alias: Driver Occ. Protctn. Properly Used, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DriverRace (type: esriFieldTypeString, alias: Driver Race, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HelmetUse (type: esriFieldTypeString, alias: Helmet Use, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvAirDepl (type: esriFieldTypeString, alias: Driver Airbag Deployed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvEjtd (type: esriFieldTypeString, alias: Driver Ejected, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvMedTra (type: esriFieldTypeString, alias: Driver Medical Transportation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvEmsEm (type: esriFieldTypeString, alias: Driver Ems Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvLicSta (type: esriFieldTypeString, alias: Driver License State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvLicTyp (type: esriFieldTypeString, alias: Driver License Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvLiCo (type: esriFieldTypeString, alias: Drivers License Commercial, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvLicRes (type: esriFieldTypeString, alias: Driver License Restrictions, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvLicExp (type: esriFieldTypeString, alias: Driver License Expires, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvLicEnd (type: esriFieldTypeString, alias: Driver License Endorsements, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvLicSts (type: esriFieldTypeString, alias: Driver License Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehTow (type: esriFieldTypeInteger, alias: Vehicle Towed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VehDisDmg (type: esriFieldTypeInteger, alias: Vehicle Towed, Disabling Damage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VehDmgSev (type: esriFieldTypeString, alias: Vehicle Damage Severity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehDmgExt (type: esriFieldTypeString, alias: Vehicle Damage Extent, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehDmgLoc (type: esriFieldTypeString, alias: Vehicle Damage Locations, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehNum (type: esriFieldTypeInteger, alias: Vehicle Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VehYear (type: esriFieldTypeInteger, alias: Vehicle Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VehMake (type: esriFieldTypeString, alias: Vehicle Make, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehModel (type: esriFieldTypeString, alias: Vehicle Model, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehColor (type: esriFieldTypeString, alias: Vehicle Color, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehVIN (type: esriFieldTypeString, alias: Vehicle Vin, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TyeOfVeh (type: esriFieldTypeString, alias: Type Of Vehicle, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehBdySty (type: esriFieldTypeString, alias: Vehicle Body Style, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehCargBdy (type: esriFieldTypeString, alias: Vehicle Cargo Body, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehUse1 (type: esriFieldTypeString, alias: Vehicle Use 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehUse2 (type: esriFieldTypeString, alias: Vehicle Use 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EmgVehUse (type: esriFieldTypeString, alias: Emergency Motor Vehicle Use, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehLicReg (type: esriFieldTypeString, alias: Vehicle License Plate Reg Year, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VehLicPlate (type: esriFieldTypeString, alias: Vehicle License Plate State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USDOTNum (type: esriFieldTypeString, alias: Us Dot Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CMVStNum (type: esriFieldTypeString, alias: Cmv State-Issued Identification Num, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• IccCode (type: esriFieldTypeString, alias: Icc Carrier Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• IntStCarr (type: esriFieldTypeString, alias: Interstate Carrier, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NumOfAxles (type: esriFieldTypeDouble, alias: Number Of Axles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GrVehWgt (type: esriFieldTypeString, alias: Gross Vehicle Weight, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MotVehType (type: esriFieldTypeString, alias: Motor Vehicle Unit Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HazMatNum (type: esriFieldTypeString, alias: Hazardous Material Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HazMatPcd (type: esriFieldTypeString, alias: Hazardous Material Placard, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HazMatId (type: esriFieldTypeString, alias: Hazardous Material Id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HazMatNam (type: esriFieldTypeString, alias: Hazardous Material Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HazMatCls (type: esriFieldTypeString, alias: Hazardous Material Class, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HazMatRlsd (type: esriFieldTypeString, alias: Hazardous Material Released, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RdCondtn (type: esriFieldTypeString, alias: Road Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RdSurface (type: esriFieldTypeString, alias: Road Surface, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TrfCntDev (type: esriFieldTypeString, alias: Traffic Control Device, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RdDgnLan (type: esriFieldTypeString, alias: Road Design Lanes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RdDgnDiv (type: esriFieldTypeString, alias: Road Design Divider, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RdDesign (type: esriFieldTypeString, alias: Road Design, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrvCondnEm (type: esriFieldTypeInteger, alias: Driver Condition - Emotional, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DrvCondnPh (type: esriFieldTypeInteger, alias: Driver Condition - Other Physical Impairement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DrvCondOth (type: esriFieldTypeInteger, alias: Driver Condition - Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Seq1 (type: esriFieldTypeString, alias: Sequence Of Events - Event 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Seq2 (type: esriFieldTypeString, alias: Sequence Of Events - Event 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Seq3 (type: esriFieldTypeString, alias: Sequence Of Events - Event 3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Seq4 (type: esriFieldTypeString, alias: Sequence Of Events - Event 4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SeqMstHrm (type: esriFieldTypeString, alias: Sequence - Most Harmful Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PdpcPedBic (type: esriFieldTypeString, alias: Pdpc at Pedestrian Or Pedalcyclist At Intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DrivingAct (type: esriFieldTypeString, alias: Driving Actions, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Sobriety (type: esriFieldTypeString, alias: Sobriety, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PdpcPrior (type: esriFieldTypeString, alias: Pdpc Action Prior To Crash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PhyCondn (type: esriFieldTypeString, alias: Physical Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PdpcAt (type: esriFieldTypeString, alias: Pdpc Action At Time Of Crash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PdpcLoctn (type: esriFieldTypeString, alias: Pdpc Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PedAtInt (type: esriFieldTypeString, alias: Pedestrian At Intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PedNotInt (type: esriFieldTypeString, alias: Pedestrian Not At Intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ContFact (type: esriFieldTypeString, alias: Contributing Factors, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LeftScene (type: esriFieldTypeString, alias: Left Scene, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LiaIns (type: esriFieldTypeInteger, alias: Liability Insurance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Interlock (type: esriFieldTypeInteger, alias: Interlock, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DrvIncRe (type: esriFieldTypeString, alias: Driver Incident Responder, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ea_PedInv (type: esriFieldTypeInteger, alias: Pedestrian Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_YngDrv (type: esriFieldTypeInteger, alias: Young Driver Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_OldDrv (type: esriFieldTypeInteger, alias: Older Driver Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_IntRel (type: esriFieldTypeInteger, alias: Intersection Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_BikInv (type: esriFieldTypeInteger, alias: Bicycles Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_HwyTrk (type: esriFieldTypeInteger, alias: Heavy Trucks Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Light (type: esriFieldTypeInteger, alias: Lighting Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_IncWea (type: esriFieldTypeInteger, alias: Inclement Weather, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_TriLnd (type: esriFieldTypeInteger, alias: Tribal Lands, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_AlcInv (type: esriFieldTypeInteger, alias: Alcohol Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_DrgInv (type: esriFieldTypeInteger, alias: Drug Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_ImpDrv (type: esriFieldTypeInteger, alias: Impaired Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_SpdDrv (type: esriFieldTypeInteger, alias: Speed Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_AggDrv (type: esriFieldTypeInteger, alias: Aggressive Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_SpdAgg (type: esriFieldTypeInteger, alias: Speed/Aggressive Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Unres (type: esriFieldTypeInteger, alias: Unrestrained Occupant, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_MotInv (type: esriFieldTypeInteger, alias: Motorcycle Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_SlpDrv (type: esriFieldTypeInteger, alias: Sleepy/Fatigued Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_WrkZon (type: esriFieldTypeInteger, alias: Work Zone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Rail (type: esriFieldTypeInteger, alias: Rail Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Bus (type: esriFieldTypeInteger, alias: Bus Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Animal (type: esriFieldTypeInteger, alias: Animal Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Distrc (type: esriFieldTypeInteger, alias: Distracted Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_RdwDep (type: esriFieldTypeInteger, alias: Roadway Departure, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Vehicle_KABCO_12_22
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• Person (0) -- Related To: Person_KABCO_12_22 (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/1/2023 10:31:34 PM

Schema Last Edit Date: 8/1/2023 10:31:34 PM

Data Last Edit Date: 8/1/2023 10:31:34 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat