Name: Crash_Vehicle

Display Field: REPORTNUMBER

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• CRASHSEVERITYDESCRIPTION ( type: esriFieldTypeString, alias: CrashSeverityDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CRASHSEVERITYDESCRIPTION )
• REPORTNUMBER ( type: esriFieldTypeString, alias: Reportnumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REPORTNUMBER )
• BODYTYPEVEH ( type: esriFieldTypeInteger, alias: BodyTypeVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: BODYTYPEVEH )
• LARGEVEHICLEBODYTYPE ( type: esriFieldTypeInteger, alias: LargeVehicleBodyType_2024, editable: true, nullable: true, defaultValue: null, modelName: LARGEVEHICLEBODYTYPE )
• VEHICLEID ( type: esriFieldTypeString, alias: VehicleID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VEHICLEID )
• BARRIERTYPEDESCRIPTIONVEH ( type: esriFieldTypeString, alias: BarrierTypeDescriptionVeh_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BARRIERTYPEDESCRIPTIONVEH )
• BARRIERTYPEVEH ( type: esriFieldTypeInteger, alias: BarrierTypeVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: BARRIERTYPEVEH )
• BODYTYPEVEHDESCRIPTION ( type: esriFieldTypeString, alias: BodyTypeVehDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BODYTYPEVEHDESCRIPTION )
• CARRIERSTATE ( type: esriFieldTypeString, alias: CarrierState_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CARRIERSTATE )
• CARRIERTYPEDESCRIPTION ( type: esriFieldTypeString, alias: CarrierTypeDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CARRIERTYPEDESCRIPTION )
• CARRIERZIPCODE ( type: esriFieldTypeString, alias: CarrierZipCode_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CARRIERZIPCODE )
• CARRIERTYPE ( type: esriFieldTypeInteger, alias: Carriertype_2024, editable: true, nullable: true, defaultValue: null, modelName: CARRIERTYPE )
• DAMAGEDBYFIRE ( type: esriFieldTypeString, alias: DamagedByFire, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DAMAGEDBYFIRE )
• DAMAGEEXTENTVEH ( type: esriFieldTypeInteger, alias: DamageExtentVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: DAMAGEEXTENTVEH )
• DAMAGEEXTENTVEHDESCRIPTION ( type: esriFieldTypeString, alias: DamageExtentVehDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DAMAGEEXTENTVEHDESCRIPTION )
• DIVIDEDROADWAYVEH ( type: esriFieldTypeInteger, alias: DividedRoadwayVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: DIVIDEDROADWAYVEH )
• DIVIDEDROADWAYVEHDESCRIPTION ( type: esriFieldTypeString, alias: DividedRoadwayVehDescription_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DIVIDEDROADWAYVEHDESCRIPTION )
• DRIVERLESSVEH ( type: esriFieldTypeString, alias: DriverlessVeh, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DRIVERLESSVEH )
• EMERGENCYUSEVEH ( type: esriFieldTypeInteger, alias: EmergencyUseVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: EMERGENCYUSEVEH )
• EMERGENCYUSEVEHDESCRIPTION ( type: esriFieldTypeString, alias: EmergencyUseVehDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EMERGENCYUSEVEHDESCRIPTION )
• FIRSTIMPACTDESCRIPTION ( type: esriFieldTypeString, alias: FirstImpactDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FIRSTIMPACTDESCRIPTION )
• FIRSTIMPACTVEH ( type: esriFieldTypeInteger, alias: FirstImpactVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: FIRSTIMPACTVEH )
• HASHAZMATONBOARD ( type: esriFieldTypeString, alias: HashazmatOnboard_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HASHAZMATONBOARD )
• HASTOWEDTRAILERVEH ( type: esriFieldTypeString, alias: HasTowedTrailerVeh_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HASTOWEDTRAILERVEH )
• HAZMATCLASS ( type: esriFieldTypeInteger, alias: HazmatClass, editable: true, nullable: true, defaultValue: null, modelName: HAZMATCLASS )
• HAZMATCLASSDESCRIPTION ( type: esriFieldTypeString, alias: HazmatClassDescription_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HAZMATCLASSDESCRIPTION )
• HAZMATPLACARDDISPLAYED ( type: esriFieldTypeString, alias: HazmatPlacardDisplayed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HAZMATPLACARDDISPLAYED )
• HAZMATSPILL ( type: esriFieldTypeString, alias: HazmatSpill, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HAZMATSPILL )
• HIGHOCCUPANCYLANEVEH ( type: esriFieldTypeInteger, alias: HighOccupancyLaneVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: HIGHOCCUPANCYLANEVEH )
• HIGHOCCUPANYLANEDESCRIPTIONVEH ( type: esriFieldTypeString, alias: HighOccupanyLaneDescriptionVeh_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HIGHOCCUPANYLANEDESCRIPTIONVEH )
• HOVRELATEDVEH ( type: esriFieldTypeString, alias: HOVRelatedVeh_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HOVRELATEDVEH )
• ISINSURED ( type: esriFieldTypeString, alias: IsInsured_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ISINSURED )
• ISPARKED ( type: esriFieldTypeString, alias: IsParked, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ISPARKED )
• LANEDIRECTIONVEH ( type: esriFieldTypeInteger, alias: LaneDirectionVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: LANEDIRECTIONVEH )
• LANEDIRECTIONVEHDESCRIPTION ( type: esriFieldTypeString, alias: LaneDirectionVehDescription_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LANEDIRECTIONVEHDESCRIPTION )
• LANEVEHICLEINVEH ( type: esriFieldTypeString, alias: LaneVehicleInVeh_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LANEVEHICLEINVEH )
• LANEVEHICLEINVEHDESCRIPTION ( type: esriFieldTypeString, alias: LaneVehicleInVehDescription_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LANEVEHICLEINVEHDESCRIPTION )
• LARGEVEHICLEBODYTYPEDESCRIPTIO ( type: esriFieldTypeString, alias: LargeVehicleBodyTypeDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LARGEVEHICLEBODYTYPEDESCRIPTIO )
• LARGEVEHICLECONFIGURATION ( type: esriFieldTypeInteger, alias: LargeVehicleConfiguration_2024, editable: true, nullable: true, defaultValue: null, modelName: LARGEVEHICLECONFIGURATION )
• LARGEVEHICLECONFIGURATIONDESCR ( type: esriFieldTypeString, alias: LargeVehicleConfigurationDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LARGEVEHICLECONFIGURATIONDESCR )
• LARGEVEHICLENUMBEROFAXLES ( type: esriFieldTypeInteger, alias: LargeVehicleNumberOfAxles, editable: true, nullable: true, defaultValue: null, modelName: LARGEVEHICLENUMBEROFAXLES )
• LEFTSCENEVEH ( type: esriFieldTypeString, alias: LeftSceneVeh, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LEFTSCENEVEH )
• MAKEVEH ( type: esriFieldTypeString, alias: MakeVeh, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAKEVEH )
• MODELVEH ( type: esriFieldTypeString, alias: ModelVeh, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODELVEH )
• MOSTHARMFULEVENTVEH ( type: esriFieldTypeInteger, alias: MostHarmfulEventVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: MOSTHARMFULEVENTVEH )
• MOSTHARMFULEVENTVEHDESCRIPTION ( type: esriFieldTypeString, alias: MostHarmfulEventVehDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MOSTHARMFULEVENTVEHDESCRIPTION )
• MOVEMENTVEH ( type: esriFieldTypeInteger, alias: MovementVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: MOVEMENTVEH )
• MOVEMENTVEHDESCRIPTION ( type: esriFieldTypeString, alias: MovementVehDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MOVEMENTVEHDESCRIPTION )
• NUMBEROFAUXILIARYLANESVEH ( type: esriFieldTypeInteger, alias: NumberOfAuxiliaryLanesVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFAUXILIARYLANESVEH )
• NUMBEROFTHROUGHLANESVEH ( type: esriFieldTypeInteger, alias: NumberOfThroughLanesVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFTHROUGHLANESVEH )
• PERMITTEDLOAD ( type: esriFieldTypeString, alias: PermittedLoad_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERMITTEDLOAD )
• REGISTRATIONSTATEVEH ( type: esriFieldTypeString, alias: RegistrationStateVeh_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REGISTRATIONSTATEVEH )
• REPORTNUMBERVEH ( type: esriFieldTypeString, alias: ReportNumberVeh, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REPORTNUMBERVEH )
• ROADALIGNMENTVEH ( type: esriFieldTypeInteger, alias: RoadAlignmentVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: ROADALIGNMENTVEH )
• ROADALIGNMENTVEHDESCRIPTION ( type: esriFieldTypeString, alias: RoadAlignmentVehDescription_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ROADALIGNMENTVEHDESCRIPTION )
• ROADGRADEVEH ( type: esriFieldTypeInteger, alias: RoadGradeVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: ROADGRADEVEH )
• ROADGRADEVEHDESCRIPTION ( type: esriFieldTypeString, alias: RoadGradeVehDescription_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ROADGRADEVEHDESCRIPTION )
• SPECIALFUNCTIONVEH ( type: esriFieldTypeInteger, alias: SpecialFunctionVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: SPECIALFUNCTIONVEH )
• SPECIALFUNCTIONVEHDESCRIPTION ( type: esriFieldTypeString, alias: SpecialFunctionVehDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SPECIALFUNCTIONVEHDESCRIPTION )
• SPEEDLIMITVEH ( type: esriFieldTypeInteger, alias: SpeedLimitVeh, editable: true, nullable: true, defaultValue: null, modelName: SPEEDLIMITVEH )
• TOWEDAWAYVEH ( type: esriFieldTypeString, alias: TowedAwayVeh_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TOWEDAWAYVEH )
• TOWEDTYPEVEH ( type: esriFieldTypeInteger, alias: TowedTypeVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: TOWEDTYPEVEH )
• TOWEDTYPEVEHDESCRIPTION ( type: esriFieldTypeString, alias: TowedTypeVehDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TOWEDTYPEVEHDESCRIPTION )
• TRAVELDIRECTIONVEH ( type: esriFieldTypeInteger, alias: TravelDirectionVeh_2024, editable: true, nullable: true, defaultValue: null, modelName: TRAVELDIRECTIONVEH )
• TRAVELDIRECTIONVEHDESCRIPTION ( type: esriFieldTypeString, alias: TravelDirectionVehDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TRAVELDIRECTIONVEHDESCRIPTION )
• UNITNUMBERVEH ( type: esriFieldTypeInteger, alias: UnitnumberVeh, editable: true, nullable: true, defaultValue: null, modelName: UNITNUMBERVEH )
• UNKNOWNVEHICLEVEH ( type: esriFieldTypeString, alias: UnknownVehicleVeh_2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UNKNOWNVEHICLEVEH )
• VINVEH ( type: esriFieldTypeString, alias: VINVeh, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VINVEH )
• YEARVEH ( type: esriFieldTypeInteger, alias: YearVeh, editable: true, nullable: true, defaultValue: null, modelName: YEARVEH )
• COMMERCIALGVW ( type: esriFieldTypeString, alias: CommercialGVW_2019_2023, editable: true, nullable: true, length: 25, defaultValue: null, modelName: COMMERCIALGVW )
• COMMERCIALHAZMATNUMBER ( type: esriFieldTypeString, alias: CommercialHazmatNumber_2019_2023, editable: true, nullable: true, length: 10, defaultValue: null, modelName: COMMERCIALHAZMATNUMBER )
• CONTINUEDIRECTION ( type: esriFieldTypeString, alias: Continuedirection_2019_2023, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CONTINUEDIRECTION )
• MAINIMPACT ( type: esriFieldTypeString, alias: Mainimpact_2019_2023, editable: true, nullable: true, length: 520, defaultValue: null, modelName: MAINIMPACT )
• VEHICLEBUSUSE ( type: esriFieldTypeString, alias: VehicleBusUse_2019_2023, editable: true, nullable: true, length: 15, defaultValue: null, modelName: VEHICLEBUSUSE )
• MERGE_SRC ( type: esriFieldTypeString, alias: MERGE_SRC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MERGE_SRC )
• EMERGENCYMOTORVEHICLEUSE ( type: esriFieldTypeString, alias: Emergencymotorvehicleuse_2019_2023, editable: true, nullable: true, length: 10, defaultValue: null, modelName: EMERGENCYMOTORVEHICLEUSE )

Templates:

• Name: Crash_Vehicle
  Description:
  Prototype:
  MERGE_SRC: null
  EMERGENCYMOTORVEHICLEUSE: null
  CRASHSEVERITYDESCRIPTION: null
  REPORTNUMBER: null
  BODYTYPEVEH: null
  LARGEVEHICLEBODYTYPE: null
  VEHICLEID: null
  BARRIERTYPEDESCRIPTIONVEH: null
  BARRIERTYPEVEH: null
  BODYTYPEVEHDESCRIPTION: null
  CARRIERSTATE: null
  CARRIERTYPEDESCRIPTION: null
  CARRIERZIPCODE: null
  CARRIERTYPE: null
  DAMAGEDBYFIRE: null
  DAMAGEEXTENTVEH: null
  DAMAGEEXTENTVEHDESCRIPTION: null
  DIVIDEDROADWAYVEH: null
  DIVIDEDROADWAYVEHDESCRIPTION: null
  DRIVERLESSVEH: null
  EMERGENCYUSEVEH: null
  EMERGENCYUSEVEHDESCRIPTION: null
  FIRSTIMPACTDESCRIPTION: null
  FIRSTIMPACTVEH: null
  HASHAZMATONBOARD: null
  HASTOWEDTRAILERVEH: null
  HAZMATCLASS: null
  HAZMATCLASSDESCRIPTION: null
  HAZMATPLACARDDISPLAYED: null
  HAZMATSPILL: null
  HIGHOCCUPANCYLANEVEH: null
  HIGHOCCUPANYLANEDESCRIPTIONVEH: null
  HOVRELATEDVEH: null
  ISINSURED: null
  ISPARKED: null
  LANEDIRECTIONVEH: null
  LANEDIRECTIONVEHDESCRIPTION: null
  LANEVEHICLEINVEH: null
  LANEVEHICLEINVEHDESCRIPTION: null
  LARGEVEHICLEBODYTYPEDESCRIPTIO: null
  LARGEVEHICLECONFIGURATION: null
  LARGEVEHICLECONFIGURATIONDESCR: null
  LARGEVEHICLENUMBEROFAXLES: null
  LEFTSCENEVEH: null
  MAKEVEH: null
  MODELVEH: null
  MOSTHARMFULEVENTVEH: null
  MOSTHARMFULEVENTVEHDESCRIPTION: null
  MOVEMENTVEH: null
  MOVEMENTVEHDESCRIPTION: null
  NUMBEROFAUXILIARYLANESVEH: null
  NUMBEROFTHROUGHLANESVEH: null
  PERMITTEDLOAD: null
  REGISTRATIONSTATEVEH: null
  REPORTNUMBERVEH: null
  ROADALIGNMENTVEH: null
  ROADALIGNMENTVEHDESCRIPTION: null
  ROADGRADEVEH: null
  ROADGRADEVEHDESCRIPTION: null
  SPECIALFUNCTIONVEH: null
  SPECIALFUNCTIONVEHDESCRIPTION: null
  SPEEDLIMITVEH: null
  TOWEDAWAYVEH: null
  TOWEDTYPEVEH: null
  TOWEDTYPEVEHDESCRIPTION: null
  TRAVELDIRECTIONVEH: null
  TRAVELDIRECTIONVEHDESCRIPTION: null
  UNITNUMBERVEH: null
  UNKNOWNVEHICLEVEH: null
  VINVEH: null
  YEARVEH: null
  COMMERCIALGVW: null
  COMMERCIALHAZMATNUMBER: null
  CONTINUEDIRECTION: null
  MAINIMPACT: null
  VEHICLEBUSUSE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Crash_Report (0) -- Related To: Crash Report (0)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Analytic   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata