Name: ped_crash

Display Field: MPO_NAME

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_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• DOCUMENT_NBR (type: esriFieldTypeInteger, alias: Document Nbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_YEAR (type: esriFieldTypeString, alias: Crash Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CRASH_DT (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CRASH_MILITARY_TM (type: esriFieldTypeSmallInteger, alias: Crash Military Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_SEVERITY (type: esriFieldTypeString, alias: Crash Severity, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: A. Severe Injury], [B: B. Visible Injury], [C: C. Nonvisible Injury], ... 2 more ...)
• K_PEOPLE (type: esriFieldTypeSmallInteger, alias: K_People, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_PEOPLE (type: esriFieldTypeSmallInteger, alias: A_People, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_PEOPLE (type: esriFieldTypeSmallInteger, alias: B_People, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_PEOPLE (type: esriFieldTypeSmallInteger, alias: C_People, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONS_INJURED (type: esriFieldTypeSmallInteger, alias: Persons Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEDESTRIANS_KILLED (type: esriFieldTypeSmallInteger, alias: Pedestrians Killed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEDESTRIANS_INJURED (type: esriFieldTypeSmallInteger, alias: Pedestrians Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEH_COUNT (type: esriFieldTypeSmallInteger, alias: Vehicle Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COLLISION_TYPE (type: esriFieldTypeString, alias: Collision Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Rear End], ... 16 more ...)
• WEATHER_CONDITION (type: esriFieldTypeString, alias: Weather Condition, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. No Adverse Condition (Clear/Cloudy)], ... 10 more ...)
• LIGHT_CONDITION (type: esriFieldTypeString, alias: Light Condition, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Dawn], ... 7 more ...)
• RD_TYPE (type: esriFieldTypeString, alias: RoadDeparture Type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [-: -], [0: NOT_RD], [1: RD_LEFT], ... 2 more ...)
• ROADWAY_SURFACE_COND (type: esriFieldTypeString, alias: Roadway Surface Condition, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Dry], ... 11 more ...)
• RELATION_TO_ROADWAY (type: esriFieldTypeString, alias: Relation To Roadway, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Main-Line Roadway], ... 15 more ...)
• ROADWAY_ALIGNMENT (type: esriFieldTypeString, alias: Roadway Alignment, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Straight - Level], ... 10 more ...)
• ROADWAY_SURFACE_TYPE (type: esriFieldTypeString, alias: Roadway Surface Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Concrete], ... 6 more ...)
• ROADWAY_DEFECT (type: esriFieldTypeString, alias: Roadway Defect, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. No Defects], ... 10 more ...)
• ROADWAY_DESCRIPTION (type: esriFieldTypeString, alias: Roadway Description, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Two-Way, Not Divided], ... 5 more ...)
• INTERSECTION_TYPE (type: esriFieldTypeString, alias: Intersection Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Not at Intersection], ... 6 more ...)
• TRAFFIC_CONTROL_TYPE (type: esriFieldTypeString, alias: Traffic Control Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. No Traffic Control], ... 17 more ...)
• TRFC_CTRL_STATUS_TYPE (type: esriFieldTypeString, alias: Traffic Control Status, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Yes - Working], ... 6 more ...)
• WORK_ZONE_RELATED (type: esriFieldTypeString, alias: Work Zone Related, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Yes], ... 2 more ...)
• WORK_ZONE_LOCATION (type: esriFieldTypeString, alias: Work Zone Location, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Advance Warning Area], ... 4 more ...)
• WORK_ZONE_TYPE (type: esriFieldTypeString, alias: Work Zone Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Lane Closure], ... 5 more ...)
• FIRST_HARMFUL_EVENT (type: esriFieldTypeString, alias: First Harmful Event, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Bank Or Ledge], ... 41 more ...)
• FIRST_HARMFUL_EVENT_LOC (type: esriFieldTypeString, alias: First Harmful Event Loc, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. On Roadway], ... 9 more ...)
• ALCOHOL_NOTALCOHOL (type: esriFieldTypeString, alias: Alcohol?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• BELTED_UNBELTED (type: esriFieldTypeString, alias: UnBelted?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• BIKE_NONBIKE (type: esriFieldTypeString, alias: Bike?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• DISTRACTED_NOTDISTRACTED (type: esriFieldTypeString, alias: Distracted?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• ANIMAL (type: esriFieldTypeString, alias: Animal Related?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• DROWSY_NOTDROWSY (type: esriFieldTypeString, alias: Drowsy?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• DRUG_NODRUG (type: esriFieldTypeString, alias: Drug Related?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• GR_NOGR (type: esriFieldTypeString, alias: Guardrail Related?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• HITRUN_NOT_HITRUN (type: esriFieldTypeString, alias: Hit & Run?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• LGTRUCK_NONLGTRUCK (type: esriFieldTypeString, alias: Large Vehicle?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• MOTOR_NONMOTOR (type: esriFieldTypeString, alias: Motorcycle?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• PED_NONPED (type: esriFieldTypeString, alias: Pedestrian?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• SPEED_DIFF_MAX (type: esriFieldTypeSmallInteger, alias: Max Speed Diff, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPEED_NOTSPEED (type: esriFieldTypeString, alias: Speed?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• SCHOOL_ZONE (type: esriFieldTypeString, alias: School Zone, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [-: -], [0: Not Provided], [1: 1. Yes], ... 3 more ...)
• SENIOR_NOTSENIOR (type: esriFieldTypeString, alias: Senior Driver?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• YOUNG_NOTYOUNG (type: esriFieldTypeString, alias: Young Driver?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• MAINLINE_YN (type: esriFieldTypeString, alias: Mainline?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• NIGHT (type: esriFieldTypeString, alias: Night?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [-: -])
• VDOT_DISTRICT (type: esriFieldTypeString, alias: VDOT District, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: 1. Bristol], [2: 2. Salem], [3: 3. Lynchburg], ... 6 more ...)
• JURIS_CODE (type: esriFieldTypeString, alias: Juris Code, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• PHYSICAL_JURIS (type: esriFieldTypeString, alias: Physical Juris Name, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [-: -], [0: 000. Arlington County], [1: 001. Accomack County], ... 332 more ...)
• LOCAL_CASE_CD (type: esriFieldTypeString, alias: Local Case CD, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FUN (type: esriFieldTypeString, alias: Functional Class, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [INT: 1-Interstate (A,1)], [OFE: 2-Principal Arterial - Other Freeways and Expressways (B)], [OPA: 3-Principal Arterial - Other (E,2)], ... 4 more ...)
• FAC (type: esriFieldTypeString, alias: Facility Type, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [OUD: 1-One-Way Undivided], [OWD: 2-One-Way Divided], [TUD: 3-Two-Way Undivided], ... 2 more ...)
• AREA_TYPE (type: esriFieldTypeString, alias: Area Type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: Rural], [1: Urban])
• SYSTEM (type: esriFieldTypeString, alias: SYSTEM, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: VDOT Interstate], [2: VDOT Primary], [3: VDOT Secondary], ... 2 more ...)
• VSP (type: esriFieldTypeString, alias: VSP, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 5 more ...)
• OWNERSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: 1. State Hwy Agency], [2: 2. County Hwy Agency], [3: 3. City or Town Hwy Agency], ... 3 more ...)
• INTERSECTION_ANALYSIS (type: esriFieldTypeString, alias: Intersection Analysis, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [-: -], [0: NOT_INTERSECTION], [1: VDOT_INTERSECTION], ... 1 more ...)
• PLAN_DISTRICT (type: esriFieldTypeString, alias: Planning District, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [1: Lenowisco], [2: Cumberland Plateau], [3: Mount Rogers], ... 22 more ...)
• MPO_NAME (type: esriFieldTypeString, alias: MPO Name, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [-: -], [BRIS: Bristol Metropolitan Planning Organization], [CVIL: Charlottesville-Albemarle Metropolitan Planning Organization], ... 13 more ...)
• ROUTE_OR_STREET_NM (type: esriFieldTypeString, alias: Route or Street Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• RTE_NM (type: esriFieldTypeString, alias: RTE Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RNS_MP (type: esriFieldTypeDouble, alias: RNS MP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NODE (type: esriFieldTypeString, alias: Node, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OFFSET (type: esriFieldTypeDouble, alias: Node Offset (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAT (type: esriFieldTypeDouble, alias: LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LON (type: esriFieldTypeDouble, alias: LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOCUMENT_NBR_1 (type: esriFieldTypeInteger, alias: Document_Nbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_YEAR_1 (type: esriFieldTypeString, alias: Crash_Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CRASH_SEVERITY_1 (type: esriFieldTypeString, alias: Crash_Severity, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: A. Severe Injury], [B: B. Visible Injury], [C: C. Nonvisible Injury], ... 2 more ...)
• DRIVER_VEHICLENUMBER (type: esriFieldTypeString, alias: Driver_VehicleNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_INJURYTYPE (type: esriFieldTypeString, alias: Driver_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_AGE (type: esriFieldTypeString, alias: Driver_Age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DRIVER_GENDER (type: esriFieldTypeString, alias: Driver_Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_ACTION_TYPE_CD (type: esriFieldTypeString, alias: Driver_Action_Type_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_AIRBAG_DEPLOYMENT (type: esriFieldTypeString, alias: Driver_Airbag_Deployment, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_ALCOHOL_TEST_TYPE_CD (type: esriFieldTypeString, alias: Driver_Alcohol_Test_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_CONDITION_TYPE_CD (type: esriFieldTypeString, alias: Driver_Condition_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_DISTRACTION_TYPE_CD (type: esriFieldTypeString, alias: Driver_Distraction_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_DRINKING_TYPE_CD (type: esriFieldTypeString, alias: Driver_Drinking_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_DRUG_USE_CD (type: esriFieldTypeString, alias: Driver_Drug_Use_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_EJECTED_FROM_VEHICLE (type: esriFieldTypeString, alias: Driver_Ejected_From_Vehicle, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_EMS_TRANSPORT_IND (type: esriFieldTypeString, alias: Driver_Ems_Transport_Ind, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_FLED_SCENE_IND (type: esriFieldTypeString, alias: Driver_Fled_Scene_Ind, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_SAFETY_EQUIP_USED (type: esriFieldTypeString, alias: Driver_Safety_Equip_Used, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_VIS_OBSCURED_TYPE_CD (type: esriFieldTypeString, alias: Driver_Vis_Obscured_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SUMMONS_ISSUED_CD (type: esriFieldTypeString, alias: Summons_Issued_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• VEHICLENUMBER (type: esriFieldTypeString, alias: Vehiclenumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_BODY_TYPE_CD (type: esriFieldTypeString, alias: Vehicle_Body_Type_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_MAKE_NM (type: esriFieldTypeString, alias: Vehicle_Make_Nm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_MANEUVER_TYPE_CD (type: esriFieldTypeString, alias: Vehicle_Maneuver_Type_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_MODEL_NM (type: esriFieldTypeString, alias: Vehicle_Model_Nm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_YEAR_NBR (type: esriFieldTypeString, alias: Vehicle_Year_Nbr, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COMM_CARGO_BODY_TYPE_CD (type: esriFieldTypeString, alias: Comm_Cargo_Body_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• COMM_VEHICLE_BODY_TYPE_CD (type: esriFieldTypeString, alias: Comm_Vehicle_Body_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SPEED_BEFORE (type: esriFieldTypeString, alias: Speed_Before, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPEED_POSTED (type: esriFieldTypeString, alias: Speed_Posted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPEED_MAX_SAFE (type: esriFieldTypeString, alias: Speed_Max_Safe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FIRST_CRASH_EVENT_CD (type: esriFieldTypeString, alias: First_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SECOND_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Second_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• THIRD_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Third_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• FOURTH_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Fourth_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MOST_HARMFUL_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Most_Harmful_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• INITIAL_VEH_IMPACT_AREA_CD (type: esriFieldTypeString, alias: Initial_Veh_Impact_Area_Cd, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DIRECTION_OF_TRAVEL_CD (type: esriFieldTypeString, alias: Direction_Of_Travel_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PASS_VEHICLENUMBER (type: esriFieldTypeString, alias: Pass_vehiclenumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PASS_INJURYTYPE (type: esriFieldTypeString, alias: Pass_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PASS_AGE (type: esriFieldTypeString, alias: Pass_age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PASS_GENDER (type: esriFieldTypeString, alias: Pass_gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PASS_SAFETY_EQUIP_USED (type: esriFieldTypeString, alias: Pass_Safety_Equip_Used, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PASS_AIRBAG_DEPLOYMENT (type: esriFieldTypeString, alias: Pass_Airbag_Deployment, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PASS_EJECTED_FROM_VEHICLE (type: esriFieldTypeString, alias: Pass_Ejected_From_Vehicle, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PASS_EMS_TRANSPORT_IND (type: esriFieldTypeString, alias: Pass_Ems_Transport_Ind, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• BIKE_VEHICLENUMBER (type: esriFieldTypeString, alias: Bike_VehicleNumber, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BIKE_INJURYTYPE (type: esriFieldTypeString, alias: Bike_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BIKE_AGE (type: esriFieldTypeString, alias: Bike_Age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BIKE_GENDER (type: esriFieldTypeString, alias: Bike_Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_NUMBER (type: esriFieldTypeString, alias: Ped_Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PED_INJURYTYPE (type: esriFieldTypeString, alias: Ped_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_AGE (type: esriFieldTypeString, alias: PED_Age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PED_GENDER (type: esriFieldTypeString, alias: Ped_Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_ACTION (type: esriFieldTypeString, alias: Ped_Action, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_DRINK (type: esriFieldTypeString, alias: Ped_Drink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_COND (type: esriFieldTypeString, alias: Ped_Cond, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_AL_TEST (type: esriFieldTypeString, alias: Ped_Al_Test, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_DRUG (type: esriFieldTypeString, alias: Ped_Drug, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_RFLCT (type: esriFieldTypeString, alias: Ped_Rflct, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NODE_TOTAADT (type: esriFieldTypeInteger, alias: Node AADT of Crash Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEG_TOTAADT (type: esriFieldTypeInteger, alias: Segment AADT of Crash Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BASETYPEDESC (type: esriFieldTypeString, alias: Basetypedesc, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [0: N/A, Unknown, or Unstabilized], [1: Bituminous Concrete (Black Base)], [2: Stabilized with Selected Material (Soil,Gravel,Stone,etc.)], ... 7 more ...)
• CURBGUTTERDESC (type: esriFieldTypeSmallInteger, alias: Curbgutterdesc, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Right side], [3: Left side], ... 5 more ...)
• RURALURBANDESC (type: esriFieldTypeSmallInteger, alias: Ruralurbandesc, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Rural], [2: Small Urban (Population 5,000 - 49,999)], [3: Urbanized (Population 50,000 - 199,999)], ... 1 more ...)
• ACCESS_CONTROL (type: esriFieldTypeSmallInteger, alias: Access_Control, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Full Access Control], [2: Partial Access Control], [1: No Access Control])
• SURFACEDESC (type: esriFieldTypeSmallInteger, alias: Surfacedesc, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Paved (unofficial definition)], [2: Good Base Gravel (unofficial definition)], [3: Gravel (unofficial definition)], ... 1 more ...)
• GOVCONDESC (type: esriFieldTypeString, alias: Govcondesc, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [-: -], [1: State Primary and Interstate], [2: State Secondary], ... 12 more ...)
• SIDEWALKDESC (type: esriFieldTypeString, alias: Sidewalkdesc, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [-: -], [1: None], [2: Right side], ... 6 more ...)
• TRUCKCOMMR (type: esriFieldTypeString, alias: Truckcommr, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [-: -], [1: Not a Parkway - Trucks and Commercial Vehicles Allowed], [2: Parkway - Trucks and Commercial Vehicles Prohibited], ... 5 more ...)
• NUMBEROFLANE (type: esriFieldTypeSmallInteger, alias: Numberoflane, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CARSPEEDLIMIT (type: esriFieldTypeSmallInteger, alias: Carspeedlimit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PAVEMENT_CONDITIONVALUE (type: esriFieldTypeDouble, alias: Pavement_Conditionvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PAVEMENT_ROUGHNESSVALUE (type: esriFieldTypeInteger, alias: Pavement_Roughnessvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PAVEMENT_WIDTH (type: esriFieldTypeInteger, alias: Pavement_Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RIGHTSHOULDERWIDTH (type: esriFieldTypeDouble, alias: Rightshoulderwidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEFTSHOULDERWIDTH (type: esriFieldTypeDouble, alias: Leftshoulderwidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_TYPE (type: esriFieldTypeSmallInteger, alias: Median_Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Divided Roadway], [2: Undivided Roadway])
• MEDIAN_TYPEDESC (type: esriFieldTypeSmallInteger, alias: MedianTypeDesc, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Grass/Unprotected], [4: Curbed Grass], [5: Flush (Painted/Other)], ... 2 more ...)
• MEDIAN_LEFTSHOULDERWIDTH (type: esriFieldTypeDouble, alias: Median_LeftShoulderWidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_RIGHTSHOULDERWIDTH (type: esriFieldTypeDouble, alias: Median_RightShoulderWidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_WIDTHMAX (type: esriFieldTypeInteger, alias: Median_WidthMax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_WIDTHMIN (type: esriFieldTypeInteger, alias: Median_WidthMin, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: ped_crash
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/14/2023 10:03:25 PM

Schema Last Edit Date: 2/14/2023 10:03:25 PM

Data Last Edit Date: 2/14/2023 10:03:25 PM

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