Name: VW_TRAFFIC_CRASHES

Display Field: road_name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 62ce090d13a24012a9887e5555671813

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• crsh_id ( type: esriFieldTypeOID, alias: crsh_id )
• road_name ( type: esriFieldTypeString, alias: road_name, length: 41 )
• DATE_VAL_MONTH_STRING ( type: esriFieldTypeString, alias: DATE_VAL_MONTH_STRING, length: 50 )
• date_val_month ( type: esriFieldTypeDouble, alias: date_val_month )
• date_val_day ( type: esriFieldTypeDouble, alias: date_val_day )
• date_val_year ( type: esriFieldTypeDouble, alias: date_val_year )
• DAY_OF_WEEK_STRING ( type: esriFieldTypeString, alias: DAY_OF_WEEK_STRING, length: 50 )
• day_of_week ( type: esriFieldTypeSmallInteger, alias: day_of_week )
• pr ( type: esriFieldTypeInteger, alias: pr )
• mp ( type: esriFieldTypeSingle, alias: mp )
• HOUR_OF_CRASH_STRING ( type: esriFieldTypeString, alias: HOUR_OF_CRASH_STRING, length: 10 )
• hour_of_crash ( type: esriFieldTypeString, alias: hour_of_crash, length: 2 )
• CRASH_SEVERITY_STRING ( type: esriFieldTypeString, alias: CRASH_SEVERITY_STRING, length: 50 )
• crash_severity ( type: esriFieldTypeSmallInteger, alias: crash_severity )
• CRASH_TYPE_STRING ( type: esriFieldTypeString, alias: CRASH_TYPE_STRING, length: 50 )
• crash_type ( type: esriFieldTypeSmallInteger, alias: crash_type )
• WEATHER_CONDITIONS_STRING ( type: esriFieldTypeString, alias: WEATHER_CONDITIONS_STRING, length: 50 )
• weather_conditions ( type: esriFieldTypeSmallInteger, alias: weather_conditions )
• LIGHT_CONDITIONS_STRING ( type: esriFieldTypeString, alias: LIGHT_CONDITIONS_STRING, length: 50 )
• light_conditions ( type: esriFieldTypeSmallInteger, alias: light_conditions )
• ROAD_CONDITIONS_STRING ( type: esriFieldTypeString, alias: ROAD_CONDITIONS_STRING, length: 50 )
• road_conditions ( type: esriFieldTypeSmallInteger, alias: road_conditions )
• distance ( type: esriFieldTypeInteger, alias: distance )
• num_units ( type: esriFieldTypeSmallInteger, alias: num_units )
• number_killed ( type: esriFieldTypeSmallInteger, alias: number_killed )
• number_injured_a ( type: esriFieldTypeSmallInteger, alias: number_injured_a )
• number_injured_b ( type: esriFieldTypeSmallInteger, alias: number_injured_b )
• number_injured_c ( type: esriFieldTypeSmallInteger, alias: number_injured_c )
• mdot_crash_type ( type: esriFieldTypeSmallInteger, alias: mdot_crash_type )
• CRASH_FACTOR_CODE ( type: esriFieldTypeString, alias: CRASH_FACTOR_CODE, length: 42 )
• alcohol_crash ( type: esriFieldTypeSmallInteger, alias: alcohol_crash )
• bicycle_crash ( type: esriFieldTypeSmallInteger, alias: bicycle_crash )
• truckbus_crash ( type: esriFieldTypeSmallInteger, alias: truckbus_crash )
• deer_crash ( type: esriFieldTypeSmallInteger, alias: deer_crash )
• ems_crash ( type: esriFieldTypeSmallInteger, alias: ems_crash )
• elderly_crash ( type: esriFieldTypeSmallInteger, alias: elderly_crash )
• drug_crash ( type: esriFieldTypeSmallInteger, alias: drug_crash )
• intersection_crash ( type: esriFieldTypeSmallInteger, alias: intersection_crash )
• lanedepart_crash ( type: esriFieldTypeSmallInteger, alias: lanedepart_crash )
• motorcycle_crash ( type: esriFieldTypeSmallInteger, alias: motorcycle_crash )
• pedestrian_crash ( type: esriFieldTypeSmallInteger, alias: pedestrian_crash )
• redlight_crash ( type: esriFieldTypeSmallInteger, alias: redlight_crash )
• schoolbus_crash ( type: esriFieldTypeSmallInteger, alias: schoolbus_crash )
• train_crash ( type: esriFieldTypeSmallInteger, alias: train_crash )
• workzone_crash ( type: esriFieldTypeSmallInteger, alias: workzone_crash )
• young_crash ( type: esriFieldTypeSmallInteger, alias: young_crash )
• secondary_crash ( type: esriFieldTypeSmallInteger, alias: secondary_crash )
• distracted_driver ( type: esriFieldTypeSmallInteger, alias: distracted_driver )
• driveway_crash ( type: esriFieldTypeSmallInteger, alias: driveway_crash )
• speeding_crash ( type: esriFieldTypeSmallInteger, alias: speeding_crash )
• unbelted_crash ( type: esriFieldTypeSmallInteger, alias: unbelted_crash )
• link_id ( type: esriFieldTypeDouble, alias: link_id )
• falink_id ( type: esriFieldTypeDouble, alias: falink_id )
• point_id ( type: esriFieldTypeInteger, alias: point_id )
• fainterx ( type: esriFieldTypeDouble, alias: fainterx )
• mgf_mcd ( type: esriFieldTypeInteger, alias: mgf_mcd )
• semmcd ( type: esriFieldTypeSmallInteger, alias: semmcd )
• greatest_severity ( type: esriFieldTypeSmallInteger, alias: greatest_severity )
• jurisdiction ( type: esriFieldTypeString, alias: jurisdiction, length: 25 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata