View In:   ArcGIS Online Map Viewer

Name: Crashes.DBO.CrashesLocation

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1823303.1972000003
YMin: 3847308
XMax: 2157674
YMax: 4498473.7223000005
Spatial Reference: 3460  (3460)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Severity_of_Accident
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Fatal
  Label: Fatal
  Description:
  Symbol:
  
• Value: Hospitalized
  Label: Hospitalized
  Description:
  Symbol:
  
• Value: Not Hospitalized
  Label: Not Hospitalized
  Description:
  Symbol:
  
• Value: Damage Only
  Label: Damage only
  Description:
  Symbol:
  
• Value:
  Label: Unknown
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Severity_of_Accident

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Accident_Key ( type: esriFieldTypeInteger, alias: Accident_Key, editable: true, nullable: true, defaultValue: null, modelName: Accident_Key )
• Number_of_Vehicles ( type: esriFieldTypeInteger, alias: Number_of_Vehicles, editable: true, nullable: true, defaultValue: null, modelName: Number_of_Vehicles )
• Number_of_Casualties ( type: esriFieldTypeInteger, alias: Number_of_Casualties, editable: true, nullable: true, defaultValue: null, modelName: Number_of_Casualties )
• Report_No ( type: esriFieldTypeString, alias: Report_No, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Report_No )
• Date ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• Division ( type: esriFieldTypeString, alias: Division, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Division )
• Police_Station ( type: esriFieldTypeString, alias: Police_Station, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Police_Station )
• No_Vehicles_Damaged ( type: esriFieldTypeInteger, alias: No_Vehicles_Damaged, editable: true, nullable: true, defaultValue: null, modelName: No_Vehicles_Damaged )
• Day ( type: esriFieldTypeString, alias: Day, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Day )
• Time ( type: esriFieldTypeString, alias: Time, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Time )
• Severity_of_Accident ( type: esriFieldTypeString, alias: Severity_of_Accident, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Severity_of_Accident )
• Severity_Z_Score ( type: esriFieldTypeInteger, alias: Severity_Z_Score, editable: true, nullable: true, defaultValue: null, modelName: Severity_Z_Score )
• Weather ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Weather )
• Light_Conditions ( type: esriFieldTypeString, alias: Light_Conditions, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Light_Conditions )
• Road_Description ( type: esriFieldTypeString, alias: Road_Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Road_Description )
• Traffic_Movement ( type: esriFieldTypeString, alias: Traffic_Movement, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Traffic_Movement )
• Road_Separation ( type: esriFieldTypeString, alias: Road_Separation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Road_Separation )
• Road_Surface_Type ( type: esriFieldTypeString, alias: Road_Surface_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Road_Surface_Type )
• Road_Width ( type: esriFieldTypeDouble, alias: Road_Width, editable: true, nullable: true, defaultValue: null, modelName: Road_Width )
• Shoulder_Width ( type: esriFieldTypeDouble, alias: Shoulder_Width, editable: true, nullable: true, defaultValue: null, modelName: Shoulder_Width )
• Shoulder_Type ( type: esriFieldTypeString, alias: Shoulder_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Shoulder_Type )
• Surface_Condition ( type: esriFieldTypeString, alias: Surface_Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Surface_Condition )
• Bad_Road_Edge ( type: esriFieldTypeString, alias: Bad_Road_Edge, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Bad_Road_Edge )
• Location_Type ( type: esriFieldTypeString, alias: Location_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location_Type )
• Traffic_Control ( type: esriFieldTypeString, alias: Traffic_Control, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Traffic_Control )
• Hit___Run ( type: esriFieldTypeString, alias: Hit___Run, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hit___Run )
• Collision_Type ( type: esriFieldTypeString, alias: Collision_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Collision_Type )
• Roadworks ( type: esriFieldTypeString, alias: Roadworks, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Roadworks )
• Accident_Attended ( type: esriFieldTypeString, alias: Accident_Attended, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Accident_Attended )
• Major_Offender ( type: esriFieldTypeInteger, alias: Major_Offender, editable: true, nullable: true, defaultValue: null, modelName: Major_Offender )
• Record_Complete ( type: esriFieldTypeString, alias: Record_Complete, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Record_Complete )
• Research_Field_1 ( type: esriFieldTypeString, alias: Research_Field_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Research_Field_1 )
• Research_Field_2 ( type: esriFieldTypeString, alias: Research_Field_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Research_Field_2 )
• Urban_Rural ( type: esriFieldTypeString, alias: Urban_Rural, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Urban_Rural )
• Route_No ( type: esriFieldTypeString, alias: Route_No, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Route_No )
• Kilometre ( type: esriFieldTypeDouble, alias: Kilometre, editable: true, nullable: true, defaultValue: null, modelName: Kilometre )
• Metre ( type: esriFieldTypeDouble, alias: m, editable: true, nullable: true, defaultValue: null, modelName: m )
• Map_Code ( type: esriFieldTypeString, alias: Map_Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Map_Code )
• X_coordinate ( type: esriFieldTypeDouble, alias: X_coordinate, editable: true, nullable: true, defaultValue: null, modelName: X_coordinate )
• Y_coordinate ( type: esriFieldTypeDouble, alias: Y_coordinate, editable: true, nullable: true, defaultValue: null, modelName: Y_coordinate )
• Street_Map_Code ( type: esriFieldTypeDouble, alias: Street_Map_Code, editable: true, nullable: true, defaultValue: null, modelName: Street_Map_Code )
• Node_1 ( type: esriFieldTypeDouble, alias: Node_1, editable: true, nullable: true, defaultValue: null, modelName: Node_1 )
• Node_2 ( type: esriFieldTypeDouble, alias: Node_2, editable: true, nullable: true, defaultValue: null, modelName: Node_2 )
• Accident_Description ( type: esriFieldTypeString, alias: Accident_Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Accident_Description )
• Location_Description ( type: esriFieldTypeString, alias: Location_Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location_Description )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status )
• RoadID ( type: esriFieldTypeString, alias: RoadID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RoadID )
• RoadName ( type: esriFieldTypeString, alias: RoadName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RoadName )
• Oid_1 ( type: esriFieldTypeInteger, alias: Oid_1, editable: true, nullable: true, defaultValue: null, modelName: Oid_1 )
• Month ( type: esriFieldTypeString, alias: Month, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Month , Coded Values: [1: January] , [2: February] , [3: March] , ...9 more... )
• Year ( type: esriFieldTypeSmallInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )

Types:

ID: Fatal
Name: Fatal
Domains:
• Month:
  Inherited
Templates:
• Name: Fatal
  Description:
  Prototype:
  Month: null
  Year: null
  Accident_Key: null
  Number_of_Vehicles: null
  Number_of_Casualties: null
  Report_No: null
  Date: null
  Division: null
  Police_Station: null
  No_Vehicles_Damaged: null
  Day: null
  Time: null
  Severity_of_Accident: Fatal
  Severity_Z_Score: null
  Weather: null
  Light_Conditions: null
  Road_Description: null
  Traffic_Movement: null
  Road_Separation: null
  Road_Surface_Type: null
  Road_Width: null
  Shoulder_Width: null
  Shoulder_Type: null
  Surface_Condition: null
  Bad_Road_Edge: null
  Location_Type: null
  Traffic_Control: null
  Hit___Run: null
  Collision_Type: null
  Roadworks: null
  Accident_Attended: null
  Major_Offender: null
  Record_Complete: null
  Research_Field_1: null
  Research_Field_2: null
  Urban_Rural: null
  Route_No: null
  Kilometre: null
  Metre: null
  Map_Code: null
  X_coordinate: null
  Y_coordinate: null
  Street_Map_Code: null
  Node_1: null
  Node_2: null
  Accident_Description: null
  Location_Description: null
  Status: null
  RoadID: null
  RoadName: null
  Oid_1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Hospitalized
Name: Hospitalized
Domains:
• Month:
  Inherited
Templates:
• Name: Hospitalized
  Description:
  Prototype:
  Month: null
  Year: null
  Accident_Key: null
  Number_of_Vehicles: null
  Number_of_Casualties: null
  Report_No: null
  Date: null
  Division: null
  Police_Station: null
  No_Vehicles_Damaged: null
  Day: null
  Time: null
  Severity_of_Accident: Hospitalized
  Severity_Z_Score: null
  Weather: null
  Light_Conditions: null
  Road_Description: null
  Traffic_Movement: null
  Road_Separation: null
  Road_Surface_Type: null
  Road_Width: null
  Shoulder_Width: null
  Shoulder_Type: null
  Surface_Condition: null
  Bad_Road_Edge: null
  Location_Type: null
  Traffic_Control: null
  Hit___Run: null
  Collision_Type: null
  Roadworks: null
  Accident_Attended: null
  Major_Offender: null
  Record_Complete: null
  Research_Field_1: null
  Research_Field_2: null
  Urban_Rural: null
  Route_No: null
  Kilometre: null
  Metre: null
  Map_Code: null
  X_coordinate: null
  Y_coordinate: null
  Street_Map_Code: null
  Node_1: null
  Node_2: null
  Accident_Description: null
  Location_Description: null
  Status: null
  RoadID: null
  RoadName: null
  Oid_1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Not Hospitalized
Name: Not Hospitalized
Domains:
• Month:
  Inherited
Templates:
• Name: Not Hospitalized
  Description:
  Prototype:
  Month: null
  Year: null
  Accident_Key: null
  Number_of_Vehicles: null
  Number_of_Casualties: null
  Report_No: null
  Date: null
  Division: null
  Police_Station: null
  No_Vehicles_Damaged: null
  Day: null
  Time: null
  Severity_of_Accident: Not Hospitalized
  Severity_Z_Score: null
  Weather: null
  Light_Conditions: null
  Road_Description: null
  Traffic_Movement: null
  Road_Separation: null
  Road_Surface_Type: null
  Road_Width: null
  Shoulder_Width: null
  Shoulder_Type: null
  Surface_Condition: null
  Bad_Road_Edge: null
  Location_Type: null
  Traffic_Control: null
  Hit___Run: null
  Collision_Type: null
  Roadworks: null
  Accident_Attended: null
  Major_Offender: null
  Record_Complete: null
  Research_Field_1: null
  Research_Field_2: null
  Urban_Rural: null
  Route_No: null
  Kilometre: null
  Metre: null
  Map_Code: null
  X_coordinate: null
  Y_coordinate: null
  Street_Map_Code: null
  Node_1: null
  Node_2: null
  Accident_Description: null
  Location_Description: null
  Status: null
  RoadID: null
  RoadName: null
  Oid_1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Damage Only
Name: Damage Only
Domains:
• Month:
  Inherited
Templates:
• Name: Damage Only
  Description:
  Prototype:
  Month: null
  Year: null
  Accident_Key: null
  Number_of_Vehicles: null
  Number_of_Casualties: null
  Report_No: null
  Date: null
  Division: null
  Police_Station: null
  No_Vehicles_Damaged: null
  Day: null
  Time: null
  Severity_of_Accident: Damage Only
  Severity_Z_Score: null
  Weather: null
  Light_Conditions: null
  Road_Description: null
  Traffic_Movement: null
  Road_Separation: null
  Road_Surface_Type: null
  Road_Width: null
  Shoulder_Width: null
  Shoulder_Type: null
  Surface_Condition: null
  Bad_Road_Edge: null
  Location_Type: null
  Traffic_Control: null
  Hit___Run: null
  Collision_Type: null
  Roadworks: null
  Accident_Attended: null
  Major_Offender: null
  Record_Complete: null
  Research_Field_1: null
  Research_Field_2: null
  Urban_Rural: null
  Route_No: null
  Kilometre: null
  Metre: null
  Map_Code: null
  X_coordinate: null
  Y_coordinate: null
  Street_Map_Code: null
  Node_1: null
  Node_2: null
  Accident_Description: null
  Location_Description: null
  Status: null
  RoadID: null
  RoadName: null
  Oid_1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: null
Name:
Domains:
• Month:
  Inherited
Templates:
• Name:
  Description:
  Prototype:
  Month: null
  Year: null
  Accident_Key: null
  Number_of_Vehicles: null
  Number_of_Casualties: null
  Report_No: null
  Date: null
  Division: null
  Police_Station: null
  No_Vehicles_Damaged: null
  Day: null
  Time: null
  Severity_of_Accident: null
  Severity_Z_Score: null
  Weather: null
  Light_Conditions: null
  Road_Description: null
  Traffic_Movement: null
  Road_Separation: null
  Road_Surface_Type: null
  Road_Width: null
  Shoulder_Width: null
  Shoulder_Type: null
  Surface_Condition: null
  Bad_Road_Edge: null
  Location_Type: null
  Traffic_Control: null
  Hit___Run: null
  Collision_Type: null
  Roadworks: null
  Accident_Attended: null
  Major_Offender: null
  Record_Complete: null
  Research_Field_1: null
  Research_Field_2: null
  Urban_Rural: null
  Route_No: null
  Kilometre: null
  Metre: null
  Map_Code: null
  X_coordinate: null
  Y_coordinate: null
  Street_Map_Code: null
  Node_1: null
  Node_2: null
  Accident_Description: null
  Location_Description: null
  Status: null
  RoadID: null
  RoadName: null
  Oid_1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata