Name: truck_crashes_2020_2024

Display Field: StreetName

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)
• OID_ (type: esriFieldTypeDouble, alias: OID_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StateCaseNumber (type: esriFieldTypeDouble, alias: StateCaseNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocalCaseNumber (type: esriFieldTypeString, alias: LocalCaseNumber, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• CrashDate (type: esriFieldTypeString, alias: CrashDate, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• County (type: esriFieldTypeDouble, alias: County, SQL Type: sqlTypeOther, nullable: true, editable: true)
• City (type: esriFieldTypeDouble, alias: City, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StreetName (type: esriFieldTypeString, alias: StreetName, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• StreetRoute (type: esriFieldTypeString, alias: StreetRoute, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• StreetSection (type: esriFieldTypeString, alias: StreetSection, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• RoadID (type: esriFieldTypeString, alias: RoadID, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• Logmile (type: esriFieldTypeDouble, alias: Logmile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crashseverity (type: esriFieldTypeDouble, alias: Crashseverity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashManner (type: esriFieldTypeDouble, alias: CrashManner, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FirstHarmfulEvent (type: esriFieldTypeDouble, alias: FirstHarmfulEvent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocFirstHarmfulEventRelToRoad (type: esriFieldTypeDouble, alias: LocFirstHarmfulEventRelToRoad, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LightCondition (type: esriFieldTypeDouble, alias: LightCondition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RoadwaySurfaceCondition (type: esriFieldTypeDouble, alias: RoadwaySurfaceCondition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PropertyClassification (type: esriFieldTypeDouble, alias: PropertyClassification, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrafficwayClassification (type: esriFieldTypeDouble, alias: TrafficwayClassification, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RoadSystem (type: esriFieldTypeDouble, alias: RoadSystem, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsIntersection (type: esriFieldTypeDouble, alias: IsIntersection, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IntersectingStreetName (type: esriFieldTypeString, alias: IntersectingStreetName, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• IntersectingStreetRoute (type: esriFieldTypeInteger, alias: IntersectingStreetRoute, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NonTrafficwayLocationDesc (type: esriFieldTypeString, alias: NonTrafficwayLocationDesc, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• JunctionRelation (type: esriFieldTypeDouble, alias: JunctionRelation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IntersectionType (type: esriFieldTypeDouble, alias: IntersectionType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SchoolBusRelation (type: esriFieldTypeDouble, alias: SchoolBusRelation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkZoneRelation (type: esriFieldTypeDouble, alias: WorkZoneRelation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocationRelativeToWorkZone (type: esriFieldTypeDouble, alias: LocationRelativeToWorkZone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkZoneType (type: esriFieldTypeDouble, alias: WorkZoneType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkerPresence (type: esriFieldTypeDouble, alias: WorkerPresence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PoliceNotificationDate (type: esriFieldTypeString, alias: PoliceNotificationDate, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• PoliceArrivalDate (type: esriFieldTypeString, alias: PoliceArrivalDate, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• LawEnforcementPresence (type: esriFieldTypeDouble, alias: LawEnforcementPresence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AgencyName (type: esriFieldTypeString, alias: AgencyName, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• AH_Route (type: esriFieldTypeString, alias: AH_Route, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• AH_Section (type: esriFieldTypeString, alias: AH_Section, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• AH_Logmile (type: esriFieldTypeDouble, alias: AH_Logmile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Log_Direct (type: esriFieldTypeString, alias: Log_Direct, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• AH_RoadID (type: esriFieldTypeString, alias: AH_RoadID, SQL Type: sqlTypeOther, length: 65536, nullable: true, editable: true)
• RuralUrbanArea (type: esriFieldTypeDouble, alias: RuralUrbanArea, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumSerInj (type: esriFieldTypeDouble, alias: NumSerInj, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumFatalities (type: esriFieldTypeDouble, alias: NumFatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NonMotorist_Rel (type: esriFieldTypeDouble, alias: NonMotorist_Rel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeInteger, alias: last_edited_date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeInteger, alias: GlobalID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year (type: esriFieldTypeDouble, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Parked_Truck_Flag (type: esriFieldTypeDouble, alias: Parked_Truck_Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fat_and_SI (type: esriFieldTypeSmallInteger, alias: Fat_and_SI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• County_Name (type: esriFieldTypeString, alias: County_Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Severity_Label (type: esriFieldTypeString, alias: Severity_Label, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• RoadSystem_Label (type: esriFieldTypeString, alias: RoadSystem_Label, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)

Templates:

Name: truck_crashes_2020_2024
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/4/2026 2:21:14 PM

Schema Last Edit Date: 8/4/2026 2:21:14 PM

Data Last Edit Date: 8/4/2026 2:21:14 PM

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