Name: 20240529_kabc_crash_psrc_append_20162023.csv

Display Field: collision_report

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)
• x (type: esriFieldTypeDouble, alias: x, SQL Type: sqlTypeOther, nullable: true, editable: true)
• y (type: esriFieldTypeDouble, alias: y, 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)
• collision_report (type: esriFieldTypeString, alias: collision_report, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• intentional (type: esriFieldTypeString, alias: intentional, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• collision_report_type (type: esriFieldTypeString, alias: collision_report_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date (type: esriFieldTypeDate, alias: date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• year (type: esriFieldTypeInteger, alias: year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• time (type: esriFieldTypeString, alias: time, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• total_k (type: esriFieldTypeInteger, alias: total_k, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_a (type: esriFieldTypeInteger, alias: total_a, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_b (type: esriFieldTypeInteger, alias: total_b, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_c (type: esriFieldTypeInteger, alias: total_c, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_abc (type: esriFieldTypeInteger, alias: total_abc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_bike (type: esriFieldTypeInteger, alias: total_bike, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_pedestrian (type: esriFieldTypeInteger, alias: total_pedestrian, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_vehicle (type: esriFieldTypeInteger, alias: total_vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• primary_trafficway (type: esriFieldTypeString, alias: primary_trafficway, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• city_primary_trafficway (type: esriFieldTypeString, alias: city_primary_trafficway, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• city_intersecting_trafficway (type: esriFieldTypeString, alias: city_intersecting_trafficway, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute (type: esriFieldTypeString, alias: stateroute, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_milepost (type: esriFieldTypeString, alias: stateroute_milepost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_accummulated_milepos (type: esriFieldTypeString, alias: stateroute_accummulated_milepost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_num (type: esriFieldTypeString, alias: stateroute_num, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_related_roadway_type (type: esriFieldTypeString, alias: stateroute_related_roadway_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_urban_rural (type: esriFieldTypeString, alias: stateroute_urban_rural, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_functional_class (type: esriFieldTypeString, alias: stateroute_functional_class, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_intersect_node_descr (type: esriFieldTypeString, alias: stateroute_intersect_node_descr, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_veh1_movement (type: esriFieldTypeString, alias: stateroute_veh1_movement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_collision_type (type: esriFieldTypeString, alias: stateroute_collision_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_veh2_movement (type: esriFieldTypeString, alias: stateroute_veh2_movement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateroute_direction (type: esriFieldTypeString, alias: stateroute_direction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• first_impact_location (type: esriFieldTypeString, alias: first_impact_location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• second_impact_location (type: esriFieldTypeString, alias: second_impact_location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• county_road_num (type: esriFieldTypeDouble, alias: county_road_num, SQL Type: sqlTypeOther, nullable: true, editable: true)
• county_road_milepost (type: esriFieldTypeDouble, alias: county_road_milepost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• county_intersect_milepost (type: esriFieldTypeDouble, alias: county_intersect_milepost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• county_functional_class (type: esriFieldTypeString, alias: county_functional_class, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• misc_trafficway_type (type: esriFieldTypeString, alias: misc_trafficway_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• misc_primary_trafficway (type: esriFieldTypeString, alias: misc_primary_trafficway, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• misc_intersect_trafficway (type: esriFieldTypeString, alias: misc_intersect_trafficway, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• most_severe_injury_type (type: esriFieldTypeString, alias: most_severe_injury_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• collision_severity (type: esriFieldTypeString, alias: collision_severity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• most_severe_sobriety_type (type: esriFieldTypeString, alias: most_severe_sobriety_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• first_collision_type (type: esriFieldTypeString, alias: first_collision_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• second_collision_type (type: esriFieldTypeString, alias: second_collision_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• junction_relationship (type: esriFieldTypeString, alias: junction_relationship, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• weather (type: esriFieldTypeString, alias: weather, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• roadway_surface (type: esriFieldTypeString, alias: roadway_surface, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• lighting_condition (type: esriFieldTypeString, alias: lighting_condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• location_characteristics (type: esriFieldTypeString, alias: location_characteristics, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• roadway_characteristic (type: esriFieldTypeString, alias: roadway_characteristic, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• hit_run (type: esriFieldTypeString, alias: hit_run, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• off_road (type: esriFieldTypeString, alias: off_road, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• off_travel_way (type: esriFieldTypeString, alias: off_travel_way, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• intersection_related_collision (type: esriFieldTypeInteger, alias: intersection_related_collision, SQL Type: sqlTypeOther, nullable: true, editable: true)
• wrong_way_vehicle_count (type: esriFieldTypeInteger, alias: wrong_way_vehicle_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alcohol_impaired_person_count (type: esriFieldTypeInteger, alias: alcohol_impaired_person_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drug_impaired_person_count (type: esriFieldTypeInteger, alias: drug_impaired_person_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• impaired_person_count (type: esriFieldTypeInteger, alias: impaired_person_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drinking_person_count (type: esriFieldTypeInteger, alias: drinking_person_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• speeding_driver_count (type: esriFieldTypeInteger, alias: speeding_driver_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• distracted_person_count (type: esriFieldTypeInteger, alias: distracted_person_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unrestrained_occupant_count (type: esriFieldTypeInteger, alias: unrestrained_occupant_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drowsy_driver_count (type: esriFieldTypeInteger, alias: drowsy_driver_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• non_junc_opposite_direction_cra (type: esriFieldTypeInteger, alias: non_junc_opposite_direction_crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_16_25_count (type: esriFieldTypeInteger, alias: driver_16_25_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_65_count (type: esriFieldTypeInteger, alias: driver_65_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_70_count (type: esriFieldTypeInteger, alias: driver_70_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• rgeo (type: esriFieldTypeString, alias: rgeo, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• rgc (type: esriFieldTypeString, alias: rgc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• mic (type: esriFieldTypeString, alias: mic, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• tract10 (type: esriFieldTypeDouble, alias: tract10, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tract20 (type: esriFieldTypeDouble, alias: tract20, SQL Type: sqlTypeOther, nullable: true, editable: true)
• risk_score (type: esriFieldTypeDouble, alias: risk_score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hdc (type: esriFieldTypeString, alias: hdc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• psrc_urban_rural (type: esriFieldTypeString, alias: psrc_urban_rural, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• crash_injury_level (type: esriFieldTypeString, alias: crash_injury_level, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• total_kabc (type: esriFieldTypeInteger, alias: total_kabc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bike_kabc (type: esriFieldTypeInteger, alias: bike_kabc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ped_kabc (type: esriFieldTypeInteger, alias: ped_kabc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_ksi (type: esriFieldTypeInteger, alias: total_ksi, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bike_ksi (type: esriFieldTypeInteger, alias: bike_ksi, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ped_ksi (type: esriFieldTypeInteger, alias: ped_ksi, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bike_k (type: esriFieldTypeInteger, alias: bike_k, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ped_k (type: esriFieldTypeInteger, alias: ped_k, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_heavy_vehicle (type: esriFieldTypeInteger, alias: total_heavy_vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_light_duty_truck (type: esriFieldTypeInteger, alias: total_light_duty_truck, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_car (type: esriFieldTypeInteger, alias: total_car, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_misc_vehicle (type: esriFieldTypeInteger, alias: total_misc_vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_small_vehicle (type: esriFieldTypeInteger, alias: total_small_vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• small_vehicle_kabc (type: esriFieldTypeInteger, alias: small_vehicle_kabc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• small_vehicle_ksi (type: esriFieldTypeInteger, alias: small_vehicle_ksi, SQL Type: sqlTypeOther, nullable: true, editable: true)
• small_vehicle_k (type: esriFieldTypeInteger, alias: small_vehicle_k, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: 20240529_kabc_crash_psrc_append_20162023.csv
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/14/2024 8:55:57 PM

Schema Last Edit Date: 6/14/2024 8:55:57 PM

Data Last Edit Date: 6/14/2024 8:55:57 PM

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