Name: VA Crash Data 15 to 23
Display Field: County_Name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -83.5950214699999
YMin: 36.5391983600001
XMax: -75.36874944
YMax: 39.42286434
Spatial Reference: 4326 (4326)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[120,71,173,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Crash_ID (type: esriFieldTypeInteger, alias: Crash ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Crash_Year (type: esriFieldTypeInteger, alias: Crash Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Quarter_CY (type: esriFieldTypeString, alias: Quarter-CY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Report_State (type: esriFieldTypeString, alias: Report State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Crash_Date (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Truck_Bus_Indicator (type: esriFieldTypeString, alias: Truck Bus Indicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Fatal_Count (type: esriFieldTypeInteger, alias: Fatal Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Non_Fatal_Count (type: esriFieldTypeInteger, alias: Non Fatal Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Fatalities (type: esriFieldTypeInteger, alias: Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Injuries (type: esriFieldTypeInteger, alias: Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Injury_Count (type: esriFieldTypeInteger, alias: Injury Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Tow_Away (type: esriFieldTypeString, alias: Tow Away, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Federal_Recordable (type: esriFieldTypeString, alias: Federal Recordable, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- State_Recordable (type: esriFieldTypeString, alias: State Recordable, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Vehicles_In_Accident (type: esriFieldTypeInteger, alias: Vehicles In Accident, SQL Type: sqlTypeOther, nullable: true, editable: true)
- City_Code (type: esriFieldTypeString, alias: City Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- County_Code (type: esriFieldTypeInteger, alias: County Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
- County_Name (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Trafficway_Desc (type: esriFieldTypeString, alias: Trafficway Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Road_Surface_Condition_Desc (type: esriFieldTypeString, alias: Road Surface Condition Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Weather_Condition_Desc (type: esriFieldTypeString, alias: Weather Condition Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Light_Condition_Desc (type: esriFieldTypeString, alias: Light Condition Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- First_Harmful_Event (type: esriFieldTypeString, alias: First Harmful Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- USDOT_Number (type: esriFieldTypeInteger, alias: USDOT Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Carrier_Name (type: esriFieldTypeString, alias: Carrier Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Carrier_Street (type: esriFieldTypeString, alias: Carrier Street, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Carrier_City (type: esriFieldTypeString, alias: Carrier City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Carrier_State (type: esriFieldTypeString, alias: Carrier State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Carrier_Zip_Code (type: esriFieldTypeString, alias: Carrier Zip Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Carrier_Domicile (type: esriFieldTypeString, alias: Carrier Domicile, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- New_Entrant (type: esriFieldTypeString, alias: New Entrant, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Interstate_Carrier (type: esriFieldTypeString, alias: Interstate Carrier, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Driver_Age_Category (type: esriFieldTypeString, alias: Driver Age Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Driver_License_State (type: esriFieldTypeString, alias: Driver License State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Valid_Driver_License (type: esriFieldTypeString, alias: Valid Driver License, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Driver_License_Class_Desc (type: esriFieldTypeString, alias: Driver License Class Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Citation_Issued_Code_Desc (type: esriFieldTypeString, alias: Citation Issued Code Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Vehicle_Configuration_Desc (type: esriFieldTypeString, alias: Vehicle Configuration Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Cargo_Body_Type_Desc (type: esriFieldTypeString, alias: Cargo Body Type Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- GVW_Rating_Desc (type: esriFieldTypeString, alias: GVW Rating Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Vehicle_License_Number (type: esriFieldTypeString, alias: Vehicle License Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Vehicle_License_State (type: esriFieldTypeString, alias: Vehicle License State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Hazmat_Placard (type: esriFieldTypeString, alias: Hazmat Placard, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Hazmat_Number (type: esriFieldTypeInteger, alias: Hazmat Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Hazmat_Material (type: esriFieldTypeString, alias: Hazmat Material, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Hazmat_Class_ID (type: esriFieldTypeInteger, alias: Hazmat Class ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Hazmat_Released (type: esriFieldTypeString, alias: Hazmat Released, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Crash_Number (type: esriFieldTypeInteger, alias: Crash Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Crash_Date_1 (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Day_of_Week_Category (type: esriFieldTypeString, alias: Day of Week Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Crash_Time (type: esriFieldTypeInteger, alias: Crash Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Time_of_Day_Category (type: esriFieldTypeString, alias: Time of Day Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CRASH_SEVERITY (type: esriFieldTypeString, alias: CRASH SEVERITY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- K_PEOPLE (type: esriFieldTypeInteger, alias: K PEOPLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- A_PEOPLE (type: esriFieldTypeInteger, alias: A PEOPLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- B_PEOPLE (type: esriFieldTypeInteger, alias: B PEOPLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- C_PEOPLE (type: esriFieldTypeInteger, alias: C PEOPLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PEDESTRIANS_KILLED (type: esriFieldTypeInteger, alias: PEDESTRIANS KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PEDESTRIANS_INJURED (type: esriFieldTypeInteger, alias: PEDESTRIANS INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Collision_Type (type: esriFieldTypeString, alias: Collision Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Crash_in_relation_to_roadway (type: esriFieldTypeString, alias: Crash in relation to roadway, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Roadway_Alingment (type: esriFieldTypeString, alias: Roadway Alingment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Roadway_Surface_Type (type: esriFieldTypeString, alias: Roadway Surface Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Type_of_Intersection (type: esriFieldTypeString, alias: Type of Intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Type_of_Traffic_Control_Device (type: esriFieldTypeString, alias: Type of Traffic Control Device, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Traffic_Control_Device_Status (type: esriFieldTypeString, alias: Traffic Control Device Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Work_Zone_Crash (type: esriFieldTypeString, alias: Work Zone Crash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- WorkZone_Crash_Location (type: esriFieldTypeString, alias: WorkZone Crash Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Work_Zone_Type (type: esriFieldTypeString, alias: Work Zone Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- First_Harmful_Event_Location (type: esriFieldTypeString, alias: First Harmful Event Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- ALCOHOL_Involved (type: esriFieldTypeString, alias: ALCOHOL Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Animal_Strike (type: esriFieldTypeString, alias: Animal Strike, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Seatbelt_Used (type: esriFieldTypeString, alias: Seatbelt Used, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- DISTRACTED_Driver (type: esriFieldTypeString, alias: DISTRACTED Driver, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- DROWSY_Driver (type: esriFieldTypeString, alias: DROWSY Driver, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- DRUG_Related (type: esriFieldTypeString, alias: DRUG Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Hit_and_Run (type: esriFieldTypeString, alias: Hit and Run, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Large_Truck_Involved (type: esriFieldTypeString, alias: Large Truck Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Pedestrian_Involved (type: esriFieldTypeString, alias: Pedestrian Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Speeding_Involved (type: esriFieldTypeString, alias: Speeding Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Speeding_Over_Limit (type: esriFieldTypeInteger, alias: Speeding Over Limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Road_Functionality (type: esriFieldTypeString, alias: Road Functionality, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Crash_Area_Type (type: esriFieldTypeString, alias: Crash Area Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Templates:
Name: VA Crash Data 15 to 23
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 11/7/2023 7:07:54 PM
Schema Last Edit Date: 11/7/2023 7:07:54 PM
Data Last Edit Date: 11/7/2023 7:07:54 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat