View In:   ArcGIS Online Map Viewer

Name: AllCrashes18to20_Merge

Display Field: roadway_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 076c247ffb55458abe186c86a96af377

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -9560245.8867
YMin: 4847140.048500001
XMax: -9519859.1298
YMax: 4921244.496699996
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid_1 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID_1, alias: OBJECTID_1 )
• master_record_number ( modelName: Master_Record_Number, nullable: true, editable: true, defaultValue: null, alias: Master_Record_Number, type: esriFieldTypeDouble )
• agency ( modelName: Agency, nullable: true, editable: true, defaultValue: null, length: 255, alias: Agency, type: esriFieldTypeString )
• local_code ( modelName: Local_Code, nullable: true, editable: true, defaultValue: null, length: 255, alias: Local_Code, type: esriFieldTypeString )
• county ( modelName: County, nullable: true, editable: true, defaultValue: null, length: 255, alias: County, type: esriFieldTypeString )
• township ( modelName: Township, nullable: true, editable: true, defaultValue: null, length: 255, alias: Township, type: esriFieldTypeString )
• city ( modelName: City, nullable: true, editable: true, defaultValue: null, length: 255, alias: City, type: esriFieldTypeString )
• collision_date ( modelName: Collision_Date, nullable: true, editable: true, defaultValue: null, length: 29, alias: Collision_Date, type: esriFieldTypeDate )
• collision_time ( modelName: Collision_Time, nullable: true, editable: true, defaultValue: null, length: 255, alias: Collision_Time, type: esriFieldTypeString )
• vehicles_involved ( modelName: Vehicles_Involved, nullable: true, editable: true, defaultValue: null, alias: Vehicles_Involved, type: esriFieldTypeDouble )
• trailers_involved ( modelName: Trailers_Involved, nullable: true, editable: true, defaultValue: null, alias: Trailers_Involved, type: esriFieldTypeDouble )
• number_injured ( modelName: Number_Injured, nullable: true, editable: true, defaultValue: null, alias: Number_Injured, type: esriFieldTypeDouble )
• number_dead ( modelName: Number_Dead, nullable: true, editable: true, defaultValue: null, alias: Number_Dead, type: esriFieldTypeDouble )
• number_deer ( modelName: Number_Deer, nullable: true, editable: true, defaultValue: null, alias: Number_Deer, type: esriFieldTypeDouble )
• house_number ( modelName: House_Number, nullable: true, editable: true, defaultValue: null, length: 255, alias: House_Number, type: esriFieldTypeString )
• roadway_name ( modelName: Roadway_Name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Roadway_Name, type: esriFieldTypeString )
• roadway_suffix ( modelName: Roadway_Suffix, nullable: true, editable: true, defaultValue: null, length: 255, alias: Roadway_Suffix, type: esriFieldTypeString )
• roadway_number ( modelName: Roadway_Number, nullable: true, editable: true, defaultValue: null, length: 255, alias: Roadway_Number, type: esriFieldTypeString )
• roadway_interchange ( modelName: Roadway_Interchange, nullable: true, editable: true, defaultValue: null, length: 255, alias: Roadway_Interchange, type: esriFieldTypeString )
• roadway_ramp ( modelName: Roadway_Ramp, nullable: true, editable: true, defaultValue: null, length: 255, alias: Roadway_Ramp, type: esriFieldTypeString )
• roadway_id ( modelName: Roadway_Id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Roadway_Id, type: esriFieldTypeString )
• intersecting_road ( modelName: Intersecting_Road, nullable: true, editable: true, defaultValue: null, length: 255, alias: Intersecting_Road, type: esriFieldTypeString )
• intersecting_road_number ( modelName: Intersecting_Road_Number, nullable: true, editable: true, defaultValue: null, length: 255, alias: Intersecting_Road_Number, type: esriFieldTypeString )
• mile_marker ( modelName: Mile_Marker, nullable: true, editable: true, defaultValue: null, length: 255, alias: Mile_Marker, type: esriFieldTypeString )
• interchange ( modelName: Interchange, nullable: true, editable: true, defaultValue: null, length: 255, alias: Interchange, type: esriFieldTypeString )
• corporate_limits ( modelName: Corporate_Limits, nullable: true, editable: true, defaultValue: null, length: 255, alias: Corporate_Limits, type: esriFieldTypeString )
• property_type ( modelName: Property_Type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property_Type, type: esriFieldTypeString )
• feet_from ( modelName: Feet_From, nullable: true, editable: true, defaultValue: null, alias: Feet_From, type: esriFieldTypeDouble )
• direction ( modelName: Direction, nullable: true, editable: true, defaultValue: null, length: 255, alias: Direction, type: esriFieldTypeString )
• lat_orig ( modelName: LAT_orig, nullable: true, editable: true, defaultValue: null, alias: LAT_orig, type: esriFieldTypeDouble )
• long_orig ( modelName: LONG_orig, nullable: true, editable: true, defaultValue: null, alias: LONG_orig, type: esriFieldTypeDouble )
• roadway_class ( modelName: Roadway_Class, nullable: true, editable: true, defaultValue: null, length: 255, alias: Roadway_Class, type: esriFieldTypeString )
• traffic_control_devices ( modelName: Traffic_Control_Devices, nullable: true, editable: true, defaultValue: null, length: 255, alias: Traffic_Control_Devices, type: esriFieldTypeString )
• aggressive_driving ( modelName: Aggressive_Driving, nullable: true, editable: true, defaultValue: null, length: 255, alias: Aggressive_Driving, type: esriFieldTypeString )
• hit_and_run ( modelName: Hit_and_Run, nullable: true, editable: true, defaultValue: null, length: 255, alias: Hit_and_Run, type: esriFieldTypeString )
• locality ( modelName: Locality, nullable: true, editable: true, defaultValue: null, length: 255, alias: Locality, type: esriFieldTypeString )
• school_zone ( modelName: School_Zone, nullable: true, editable: true, defaultValue: null, length: 255, alias: School_Zone, type: esriFieldTypeString )
• rumble_strips ( modelName: Rumble_Strips, nullable: true, editable: true, defaultValue: null, length: 255, alias: Rumble_Strips, type: esriFieldTypeString )
• construction ( modelName: Construction, nullable: true, editable: true, defaultValue: null, length: 255, alias: Construction, type: esriFieldTypeString )
• construction_type ( modelName: Construction_Type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Construction_Type, type: esriFieldTypeString )
• light_condition ( modelName: Light_Condition, nullable: true, editable: true, defaultValue: null, length: 255, alias: Light_Condition, type: esriFieldTypeString )
• weather_conditions ( modelName: Weather_Conditions, nullable: true, editable: true, defaultValue: null, length: 255, alias: Weather_Conditions, type: esriFieldTypeString )
• surface_condition ( modelName: Surface_Condition, nullable: true, editable: true, defaultValue: null, length: 255, alias: Surface_Condition, type: esriFieldTypeString )
• type_of_median ( modelName: Type_of_Median, nullable: true, editable: true, defaultValue: null, length: 255, alias: Type_of_Median, type: esriFieldTypeString )
• roadway_junction_type ( modelName: Roadway_Junction_Type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Roadway_Junction_Type, type: esriFieldTypeString )
• road_character ( modelName: Road_Character, nullable: true, editable: true, defaultValue: null, length: 255, alias: Road_Character, type: esriFieldTypeString )
• roadway_surface ( modelName: Roadway_Surface, nullable: true, editable: true, defaultValue: null, length: 255, alias: Roadway_Surface, type: esriFieldTypeString )
• primary_factor ( modelName: Primary_Factor, nullable: true, editable: true, defaultValue: null, length: 255, alias: Primary_Factor, type: esriFieldTypeString )
• damage_estimate ( modelName: Damage_Estimate, nullable: true, editable: true, defaultValue: null, length: 255, alias: Damage_Estimate, type: esriFieldTypeString )
• manner_of_collision ( modelName: Manner_of_Collision, nullable: true, editable: true, defaultValue: null, length: 255, alias: Manner_of_Collision, type: esriFieldTypeString )
• time_notified ( modelName: Time_Notified, nullable: true, editable: true, defaultValue: null, alias: Time_Notified, type: esriFieldTypeDouble )
• time_arrived ( modelName: Time_Arrived, nullable: true, editable: true, defaultValue: null, alias: Time_Arrived, type: esriFieldTypeDouble )
• investigation_complete ( modelName: Investigation_Complete, nullable: true, editable: true, defaultValue: null, length: 255, alias: Investigation_Complete, type: esriFieldTypeString )
• photos_taken ( modelName: Photos_Taken, nullable: true, editable: true, defaultValue: null, length: 255, alias: Photos_Taken, type: esriFieldTypeString )
• officer_last_name ( modelName: Officer_Last_Name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Officer_Last_Name, type: esriFieldTypeString )
• officer_first_name ( modelName: Officer_First_Name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Officer_First_Name, type: esriFieldTypeString )
• officer_id ( modelName: Officer_Id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Officer_Id, type: esriFieldTypeString )
• unique_location_id ( modelName: Unique_Location_Id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Unique_Location_Id, type: esriFieldTypeString )
• state_property_damage ( modelName: State_Property_Damage, nullable: true, editable: true, defaultValue: null, alias: State_Property_Damage, type: esriFieldTypeDouble )
• traffic_control ( modelName: Traffic_Control, nullable: true, editable: true, defaultValue: null, length: 255, alias: Traffic_Control, type: esriFieldTypeString )
• narrative ( modelName: NARRATIVE, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: NARRATIVE, type: esriFieldTypeString )
• kabco_num ( modelName: KABCO_Num, nullable: true, editable: true, defaultValue: null, alias: KABCO_Num, type: esriFieldTypeDouble )
• kabco ( modelName: KABCO, nullable: true, editable: true, defaultValue: null, length: 255, alias: KABCO, type: esriFieldTypeString )
• motorcycle ( modelName: Motorcycle, nullable: true, editable: true, defaultValue: null, alias: Motorcycle, type: esriFieldTypeDouble )
• bikeped ( modelName: BikePed, nullable: true, editable: true, defaultValue: null, alias: BikePed, type: esriFieldTypeDouble )
• bus ( modelName: Bus, nullable: true, editable: true, defaultValue: null, alias: Bus, type: esriFieldTypeDouble )
• lat_new ( modelName: LAT_new, nullable: true, editable: true, defaultValue: null, alias: LAT_new, type: esriFieldTypeDouble )
• long_new ( modelName: LONG_new, nullable: true, editable: true, defaultValue: null, alias: LONG_new, type: esriFieldTypeDouble )
• check_complete ( modelName: Check_complete, nullable: true, editable: true, defaultValue: null, alias: Check_complete, type: esriFieldTypeDouble )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• cleandist_ft ( modelName: CleanDist_ft, nullable: true, editable: true, defaultValue: null, alias: CleanDist_ft, type: esriFieldTypeDouble )
• monthnum ( modelName: monthNum, nullable: true, editable: true, defaultValue: null, alias: monthNum, type: esriFieldTypeDouble )
• crashhour ( modelName: CrashHour, nullable: true, editable: true, defaultValue: null, alias: CrashHour, type: esriFieldTypeDouble )
• year ( modelName: Year, nullable: true, editable: true, defaultValue: null, alias: Year, type: esriFieldTypeDouble )
• vulnerable_user ( modelName: Vulnerable_User, nullable: true, editable: true, defaultValue: null, alias: Vulnerable_User, type: esriFieldTypeSmallInteger )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• check_2 ( modelName: Check_2, nullable: true, editable: true, defaultValue: null, alias: Check_2, type: esriFieldTypeSmallInteger )
• nearseg_oid ( modelName: NEARSEG_OID, nullable: true, editable: true, defaultValue: null, alias: NEARSEG_OID, type: esriFieldTypeInteger )
• nearseg_dist_m ( modelName: NEARSEG_DIST_M, nullable: true, editable: true, defaultValue: null, alias: NEARSEG_DIST_M, type: esriFieldTypeDouble )
• nearseg_segmentid ( modelName: NEARSEG_SegmentID, nullable: true, editable: true, defaultValue: null, alias: NEARSEG_SegmentID, type: esriFieldTypeInteger )
• postedspeed ( modelName: PostedSpeed, nullable: true, editable: true, defaultValue: null, alias: PostedSpeed, type: esriFieldTypeSmallInteger )
• int_zone_dist ( modelName: Int_Zone_Dist, nullable: true, editable: true, defaultValue: null, alias: Int_Zone_Dist, type: esriFieldTypeInteger )
• segment_flag ( modelName: Segment_Flag, nullable: true, editable: true, defaultValue: null, alias: Segment_Flag, type: esriFieldTypeSmallInteger )
• intersection_flag ( modelName: Intersection_Flag, nullable: true, editable: true, defaultValue: null, alias: Intersection_Flag, type: esriFieldTypeSmallInteger )
• intinfzone_flag ( modelName: IntInfZone_Flag, nullable: true, editable: true, defaultValue: null, alias: IntInfZone_Flag, type: esriFieldTypeSmallInteger )
• rrx_flag ( modelName: RRX_Flag, nullable: true, editable: true, defaultValue: null, alias: RRX_Flag, type: esriFieldTypeSmallInteger )
• rrx_infzone_flag ( modelName: RRX_InfZone_Flag, nullable: true, editable: true, defaultValue: null, alias: RRX_InfZone_Flag, type: esriFieldTypeSmallInteger )
• uncontrolled_flag ( modelName: Uncontrolled_Flag, nullable: true, editable: true, defaultValue: null, alias: Uncontrolled_Flag, type: esriFieldTypeSmallInteger )
• objectid ( modelName: OBJECTID, nullable: true, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger )
• a1_segmentid ( modelName: A1_SegmentID, nullable: true, editable: true, defaultValue: null, alias: A1_SegmentID, type: esriFieldTypeInteger )
• a1_segmentlength ( modelName: A1_SegmentLength, nullable: true, editable: true, defaultValue: null, alias: A1_SegmentLength, type: esriFieldTypeDouble )
• b1_functionalclass ( modelName: B1_FunctionalClass, nullable: true, editable: true, defaultValue: null, alias: B1_FunctionalClass, type: esriFieldTypeSmallInteger )
• b1_urbanrural ( modelName: B1_UrbanRural, nullable: true, editable: true, defaultValue: null, alias: B1_UrbanRural, type: esriFieldTypeSmallInteger )
• b1_accesscontrol ( modelName: B1_AccessControl, nullable: true, editable: true, defaultValue: null, alias: B1_AccessControl, type: esriFieldTypeSmallInteger )
• c1_throughlanes ( modelName: C1_ThroughLanes, nullable: true, editable: true, defaultValue: null, alias: C1_ThroughLanes, type: esriFieldTypeSmallInteger )
• e1_mediantype ( modelName: E1_MedianType, nullable: true, editable: true, defaultValue: null, alias: E1_MedianType, type: esriFieldTypeSmallInteger )
• e1_medianwidth ( modelName: E1_MedianWidth, nullable: true, editable: true, defaultValue: null, alias: E1_MedianWidth, type: esriFieldTypeSmallInteger )
• h1_operations ( modelName: H1_Operations, nullable: true, editable: true, defaultValue: null, alias: H1_Operations, type: esriFieldTypeSmallInteger )
• h1_speedlimit ( modelName: H1_Speedlimit, nullable: true, editable: true, defaultValue: null, alias: H1_Speedlimit, type: esriFieldTypeSmallInteger )
• e1_mediancrossovertype ( modelName: E1_MedianCrossoverType, nullable: true, editable: true, defaultValue: null, alias: E1_MedianCrossoverType, type: esriFieldTypeSmallInteger )
• globalid_1 ( modelName: GlobalID_1, nullable: true, editable: true, defaultValue: null, length: 38, alias: GlobalID_1, type: esriFieldTypeGUID )
• review_flag ( modelName: Review_Flag, nullable: true, editable: true, defaultValue: null, alias: Rewiew_Flag, type: esriFieldTypeSmallInteger )
• notes ( modelName: Notes, nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
• b1_areatype ( modelName: B1_AreaType, nullable: true, editable: true, defaultValue: null, alias: B1_AreaType, type: esriFieldTypeSmallInteger )
• creationdate ( modelName: CreationDate, nullable: true, editable: true, defaultValue: null, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: Creator, nullable: true, editable: true, defaultValue: null, length: 128, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: EditDate, nullable: true, editable: true, defaultValue: null, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: Editor, nullable: true, editable: true, defaultValue: null, length: 128, alias: Editor, type: esriFieldTypeString )
• maintenance_lpa ( modelName: Maintenance_LPA, nullable: true, editable: true, defaultValue: null, length: 255, alias: Maintenance_LPA, type: esriFieldTypeString )
• junctionid ( modelName: JunctionID, nullable: true, editable: true, defaultValue: null, alias: JunctionID, type: esriFieldTypeInteger )
• motorcycle_md ( nullable: true, editable: true, defaultValue: null, alias: Motorcycle_MD, type: esriFieldTypeDouble )
• urbanrural_md ( nullable: true, editable: true, defaultValue: null, length: 255, alias: UrbanRural_MD, type: esriFieldTypeString )
• responsetime_md ( nullable: true, editable: true, defaultValue: null, alias: ResponseTime_MD, type: esriFieldTypeDouble )
• impairany_md ( nullable: true, editable: true, defaultValue: null, alias: ImpairAny_MD, type: esriFieldTypeDouble )
• age65plus_md ( nullable: true, editable: true, defaultValue: null, alias: Age65plus_MD, type: esriFieldTypeDouble )
• scatterfield ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Scatterfield, type: esriFieldTypeString )

Templates:

• Name: AllCrashes18to20_Merge
  Description:
  Prototype:
  year: null
  county: null
  junctionid: null
  e1_medianwidth: null
  house_number: null
  c1_throughlanes: null
  manner_of_collision: null
  interchange: null
  segment_flag: null
  e1_mediancrossovertype: null
  roadway_ramp: null
  a1_segmentlength: null
  narrative: null
  locality: null
  kabco: null
  crashhour: null
  weather_conditions: null
  officer_id: null
  intinfzone_flag: null
  lat_new: null
  roadway_number: null
  intersection_flag: null
  editdate: null
  long_new: null
  roadway_surface: null
  city: null
  maintenance_lpa: null
  state_property_damage: null
  unique_location_id: null
  hit_and_run: null
  intersecting_road_number: null
  traffic_control_devices: null
  roadway_junction_type: null
  uncontrolled_flag: null
  aggressive_driving: null
  property_type: null
  last_edited_date: null
  nearseg_segmentid: null
  roadway_name: null
  editor: null
  creator: null
  agency: null
  roadway_class: null
  number_dead: null
  construction_type: null
  primary_factor: null
  last_edited_user: null
  check_complete: null
  h1_speedlimit: null
  vulnerable_user: null
  h1_operations: null
  lat_orig: null
  road_character: null
  investigation_complete: null
  bus: null
  traffic_control: null
  creationdate: null
  surface_condition: null
  notes: null
  long_orig: null
  b1_functionalclass: null
  check_2: null
  officer_first_name: null
  collision_time: null
  motorcycle: null
  rrx_infzone_flag: null
  damage_estimate: null
  trailers_involved: null
  mile_marker: null
  vehicles_involved: null
  type_of_median: null
  master_record_number: null
  created_user: null
  time_arrived: null
  nearseg_oid: null
  nearseg_dist_m: null
  b1_urbanrural: null
  a1_segmentid: null
  school_zone: null
  time_notified: null
  collision_date: null
  kabco_num: null
  photos_taken: null
  light_condition: null
  roadway_suffix: null
  postedspeed: null
  rumble_strips: null
  b1_areatype: null
  roadway_id: null
  officer_last_name: null
  b1_accesscontrol: null
  corporate_limits: null
  feet_from: null
  number_deer: null
  construction: null
  direction: null
  cleandist_ft: null
  globalid_1: null
  local_code: null
  bikeped: null
  int_zone_dist: null
  rrx_flag: null
  roadway_interchange: null
  intersecting_road: null
  e1_mediantype: null
  number_injured: null
  monthnum: null
  created_date: null
  review_flag: null
  township: null
  objectid: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata