Name: CrashTrendsTable

Display Field: road_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 8ccfacc4e7c044b8958301289f2d5e4b

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: false
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
Supports Time Relation: false
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:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• year ( modelName: year, nullable: true, editable: true, defaultValue: null, alias: Year, type: esriFieldTypeDouble )
• fatalities ( modelName: fatalities, nullable: true, editable: true, defaultValue: null, alias: Fatalities, type: esriFieldTypeDouble )
• serious_injuries ( modelName: serious_injuries, nullable: true, editable: true, defaultValue: null, alias: Serious_Injuries, type: esriFieldTypeDouble )
• serious_crash_total ( modelName: serious_crash_total, nullable: true, editable: true, defaultValue: null, alias: Serious_Crash_Total, type: esriFieldTypeDouble )
• bloomington ( modelName: bloomington, nullable: true, editable: true, defaultValue: null, alias: Bloomington, type: esriFieldTypeDouble )
• ellettsville ( modelName: ellettsville, nullable: true, editable: true, defaultValue: null, alias: Ellettsville, type: esriFieldTypeDouble )
• stinesville ( modelName: stinesville, nullable: true, editable: true, defaultValue: null, alias: Stinesville, type: esriFieldTypeDouble )
• unincorporated_area ( modelName: unincorporated_area, nullable: true, editable: true, defaultValue: null, alias: Unincorporated Area, type: esriFieldTypeDouble )
• f1spring ( modelName: f1spring, nullable: true, editable: true, defaultValue: null, alias: 1Spring, type: esriFieldTypeDouble )
• f2summer ( modelName: f2summer, nullable: true, editable: true, defaultValue: null, alias: 2Summer, type: esriFieldTypeDouble )
• f3fall ( modelName: f3fall, nullable: true, editable: true, defaultValue: null, alias: 3Fall, type: esriFieldTypeDouble )
• f4winter ( modelName: f4winter, nullable: true, editable: true, defaultValue: null, alias: 4Winter, type: esriFieldTypeDouble )
• bicycle ( modelName: bicycle, nullable: true, editable: true, defaultValue: null, alias: Bicycle, type: esriFieldTypeDouble )
• car ( modelName: car, nullable: true, editable: true, defaultValue: null, alias: Car, type: esriFieldTypeDouble )
• pedestrian ( modelName: pedestrian, nullable: true, editable: true, defaultValue: null, alias: Pedestrian, type: esriFieldTypeDouble )
• crash_total ( modelName: crash_total, nullable: true, editable: true, defaultValue: null, alias: Crash_Total, type: esriFieldTypeDouble )
• gis_surface_conditions ( modelName: gis_surface_conditions, nullable: true, editable: true, defaultValue: null, length: 8000, alias: gis_surface_conditions, type: esriFieldTypeString )
• backing_crash ( modelName: backing_crash, nullable: true, editable: true, defaultValue: null, alias: Backing Crash, type: esriFieldTypeDouble )
• collision_with_deer ( modelName: collision_with_deer, nullable: true, editable: true, defaultValue: null, alias: Collision With Deer, type: esriFieldTypeDouble )
• head_on_between_two_motor_vehic ( modelName: head_on_between_two_motor_vehic, nullable: true, editable: true, defaultValue: null, alias: Head On Between Two Motor Vehicles, type: esriFieldTypeDouble )
• opposite_direction_sideswipe ( modelName: opposite_direction_sideswipe, nullable: true, editable: true, defaultValue: null, alias: Opposite Direction Sideswipe, type: esriFieldTypeDouble )
• other_gis_manner_of_collision ( modelName: other_gis_manner_of_collision, nullable: true, editable: true, defaultValue: null, alias: Other_gis_manner_of_collision, type: esriFieldTypeDouble )
• ran_off_road ( modelName: ran_off_road, nullable: true, editable: true, defaultValue: null, alias: Ran Off Road, type: esriFieldTypeDouble )
• rear_end ( modelName: rear_end, nullable: true, editable: true, defaultValue: null, alias: Rear End, type: esriFieldTypeDouble )
• right_angle ( modelName: right_angle, nullable: true, editable: true, defaultValue: null, alias: Right Angle, type: esriFieldTypeDouble )
• same_direction_sideswipe ( modelName: same_direction_sideswipe, nullable: true, editable: true, defaultValue: null, alias: Same Direction Sideswipe, type: esriFieldTypeDouble )
• gis_locality ( modelName: gis_locality, nullable: true, editable: true, defaultValue: null, length: 8000, alias: gis_locality, type: esriFieldTypeString )
• gis_time_of_day ( modelName: gis_time_of_day, nullable: true, editable: true, defaultValue: null, length: 8000, alias: gis_time_of_day, type: esriFieldTypeString )
• road_name ( modelName: road_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Road Name, type: esriFieldTypeString )
• miles ( modelName: miles, nullable: true, editable: true, defaultValue: null, alias: Miles, type: esriFieldTypeDouble )
• average_crashes_per_year ( modelName: average_crashes_per_year, nullable: true, editable: true, defaultValue: null, alias: Average Crashes Per Year, type: esriFieldTypeDouble )
• crash_rate_by_length ( modelName: crash_rate_by_length, nullable: true, editable: true, defaultValue: null, alias: Crash Rate By Length, type: esriFieldTypeDouble )

Templates:

• Name: CrashTrendsTable
  Description:
  Prototype:
  average_crashes_per_year: null
  ran_off_road: null
  right_angle: null
  f3fall: null
  bicycle: null
  year: null
  stinesville: null
  serious_injuries: null
  ellettsville: null
  gis_surface_conditions: null
  miles: null
  rear_end: null
  car: null
  backing_crash: null
  same_direction_sideswipe: null
  crash_total: null
  f4winter: null
  collision_with_deer: null
  unincorporated_area: null
  serious_crash_total: null
  gis_time_of_day: null
  road_name: null
  gis_locality: null
  other_gis_manner_of_collision: null
  f2summer: null
  fatalities: null
  pedestrian: null
  opposite_direction_sideswipe: null
  crash_rate_by_length: null
  bloomington: null
  f1spring: null
  head_on_between_two_motor_vehic: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata