Name: vehicles_data_table

Display Field: VIN111

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)
• CrashID (type: esriFieldTypeInteger, alias: CrashID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashReportUnitNbr (type: esriFieldTypeInteger, alias: CrashReportUnitNbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VIN111 (type: esriFieldTypeString, alias: VIN111, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NbrOccupants (type: esriFieldTypeString, alias: NbrOccupants, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VehTypeCode (type: esriFieldTypeInteger, alias: VehTypeCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VehUseCode (type: esriFieldTypeInteger, alias: VehUseCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VehDefectsCode (type: esriFieldTypeInteger, alias: VehDefectsCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VehManeuverPriorCode (type: esriFieldTypeInteger, alias: VehManeuverPriorCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DirectionPriorTravelCode (type: esriFieldTypeInteger, alias: DirectionPriorTravelCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsTowed (type: esriFieldTypeString, alias: IsTowed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IsFire (type: esriFieldTypeString, alias: IsFire, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IsHazMatSpill (type: esriFieldTypeString, alias: IsHazMatSpill, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IsCommercial (type: esriFieldTypeString, alias: IsCommercial, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EventMostSevereCode (type: esriFieldTypeInteger, alias: EventMostSevereCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EventMostSevereLocCode (type: esriFieldTypeInteger, alias: EventMostSevereLocCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MostHarmfulEventNo (type: esriFieldTypeInteger, alias: MostHarmfulEventNo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashEvent1Code (type: esriFieldTypeInteger, alias: CrashEvent1Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashEvent2Code (type: esriFieldTypeInteger, alias: CrashEvent2Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashEvent3Code (type: esriFieldTypeInteger, alias: CrashEvent3Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Event1LocCode (type: esriFieldTypeInteger, alias: Event1LocCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Event2LocCode (type: esriFieldTypeInteger, alias: Event2LocCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Event3LocCode (type: esriFieldTypeInteger, alias: Event3LocCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VehPointOfFirstContactCode (type: esriFieldTypeInteger, alias: VehPointOfFirstContactCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DirectionPriorTravel (type: esriFieldTypeString, alias: DirectionPriorTravel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VehDefects (type: esriFieldTypeString, alias: VehDefects, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VehManeuverPrior (type: esriFieldTypeString, alias: VehManeuverPrior, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VehType (type: esriFieldTypeString, alias: VehType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VehUse (type: esriFieldTypeString, alias: VehUse, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EventMostSevere (type: esriFieldTypeString, alias: EventMostSevere, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EventMostSevereLoc (type: esriFieldTypeString, alias: EventMostSevereLoc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CrashEvent1 (type: esriFieldTypeString, alias: CrashEvent1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CrashEvent2 (type: esriFieldTypeString, alias: CrashEvent2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CrashEvent3 (type: esriFieldTypeString, alias: CrashEvent3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Event1Loc (type: esriFieldTypeString, alias: Event1Loc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Event2Loc (type: esriFieldTypeString, alias: Event2Loc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Event3Loc (type: esriFieldTypeString, alias: Event3Loc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VehYear (type: esriFieldTypeString, alias: VehYear, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VehMake (type: esriFieldTypeString, alias: VehMake, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VehModel (type: esriFieldTypeString, alias: VehModel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExceedingSpeedLimit (type: esriFieldTypeString, alias: ExceedingSpeedLimit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TowedDueTo (type: esriFieldTypeString, alias: TowedDueTo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DoesVehicleHaveAutomation (type: esriFieldTypeString, alias: DoesVehicleHaveAutomation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LevelOfAutomation (type: esriFieldTypeString, alias: LevelOfAutomation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LevelOfAutomationDuringCrash (type: esriFieldTypeString, alias: LevelOfAutomationDuringCrash, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExtentOfDamage (type: esriFieldTypeString, alias: ExtentOfDamage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Speeding_Related (type: esriFieldTypeString, alias: Speeding Related, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: vehicles_data_table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/25/2024 5:24:01 PM

Schema Last Edit Date: 3/25/2024 5:24:01 PM

Data Last Edit Date: 3/25/2024 5:24:01 PM

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