View In:   ArcGIS Online Map Viewer

Name: dbo.Crashdata_StoredView

Display Field: City

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 20000

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

Supports Datum Transformation: true

Extent:

XMin: -104.04754008099997
YMin: -9.999951089412207E-9
XMax: 1.0000064776249928E-8
YMax: 49.000425980000045
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Crash_Severity
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value:
  Label:
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [178, 178, 178, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: A-Suspected Serious Injury
  Label: A-Suspected Serious Injury
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: B-Suspected Minor Injury
  Label: B-Suspected Minor Injury
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 197, 255, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: C-Possible Injury
  Label: C-Possible Injury
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 112, 255, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: K-Fatal Injury
  Label: K-Fatal Injury
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: O-No Apparent Injury
  Label: O-No Apparent Injury
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [76, 230, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Crash_Severity

Fields:

• CRSNUM ( type: esriFieldTypeOID, alias: CRSNUM, editable: false, nullable: false, defaultValue: null, modelName: CRSNUM )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: City )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 50, defaultValue: null, modelName: County )
• Crash_Date ( type: esriFieldTypeString, alias: Crash_Date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Crash_Date )
• Crash_Time ( type: esriFieldTypeString, alias: Crash_Time, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Crash_Time )
• First_Harmful_Event ( type: esriFieldTypeString, alias: First_Harmful_Event, editable: true, nullable: true, length: 100, defaultValue: null, modelName: First_Harmful_Event )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Manner_Crash ( type: esriFieldTypeString, alias: Manner_Crash, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manner_Crash )
• Number_MV ( type: esriFieldTypeString, alias: Number_MV, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Number_MV )
• Specific_Location ( type: esriFieldTypeString, alias: Specific_Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Specific_Location )
• Crash_Severity ( type: esriFieldTypeString, alias: Crash_Severity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Crash_Severity )
• Driver_Suspected_Alcohol ( type: esriFieldTypeString, alias: Driver_Suspected_Alcohol, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Driver_Suspected_Alcohol )
• Driver_Suspected_Drug ( type: esriFieldTypeString, alias: Driver_Suspected_Drug, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Driver_Suspected_Drug )
• Day_Week ( type: esriFieldTypeString, alias: Day_Week, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Day_Week )
• Most_Harmful_Event ( type: esriFieldTypeString, alias: Most_Harmful_Event, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Most_Harmful_Event )
• Weather_Conditions ( type: esriFieldTypeString, alias: Weather_Conditions, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Weather_Conditions )
• Workzone_Location_Crash ( type: esriFieldTypeString, alias: Workzone_Location_Crash, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Workzone_Location_Crash )
• Crashyear ( type: esriFieldTypeString, alias: Crashyear, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Crashyear )
• Seatbelt_Use ( type: esriFieldTypeString, alias: Seatbelt_Use, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Seatbelt_Use )
• RurUrb ( type: esriFieldTypeString, alias: RurUrb, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RurUrb )
• Work_Zone ( type: esriFieldTypeString, alias: Work_Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Work_Zone )
• Truck ( type: esriFieldTypeString, alias: Truck, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Truck )
• Speeding_Related ( type: esriFieldTypeString, alias: Speeding_Related, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Speeding_Related )
• Driver_Distracted ( type: esriFieldTypeString, alias: Driver_Distracted, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Driver_Distracted )
• DUI ( type: esriFieldTypeString, alias: DUI, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DUI )
• Surface_Type ( type: esriFieldTypeString, alias: Surface_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Surface_Type )
• Intersection ( type: esriFieldTypeString, alias: Intersection, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Intersection )
• Alignment_Curve ( type: esriFieldTypeString, alias: Alignment_Curve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Alignment_Curve )
• Lane_Departure ( type: esriFieldTypeString, alias: Lane_Departure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Lane_Departure )
• Light_Conditions ( type: esriFieldTypeString, alias: Light_Conditions, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Light_Conditions )
• Driver1Violation ( type: esriFieldTypeString, alias: Driver1Violation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Driver1Violation )
• Driver2Violation ( type: esriFieldTypeString, alias: Driver2Violation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Driver2Violation )
• Temp_Data ( type: esriFieldTypeSmallInteger, alias: Temp_Data, editable: true, nullable: true, defaultValue: null, modelName: Temp_Data )

Types:

ID: null
Name:
Domains:
Templates:
• Name:
  Description:
  Prototype:
  Crash_Severity: <Null>
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: A-Suspected Serious Injury
Name: A-Suspected Serious Injury
Domains:
Templates:
• Name: A-Suspected Serious Injury
  Description:
  Prototype:
  Crash_Severity: A-Suspected Serious Injury
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: B-Suspected Minor Injury
Name: B-Suspected Minor Injury
Domains:
Templates:
• Name: B-Suspected Minor Injury
  Description:
  Prototype:
  Crash_Severity: B-Suspected Minor Injury
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: C-Possible Injury
Name: C-Possible Injury
Domains:
Templates:
• Name: C-Possible Injury
  Description:
  Prototype:
  Crash_Severity: C-Possible Injury
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: K-Fatal Injury
Name: K-Fatal Injury
Domains:
Templates:
• Name: K-Fatal Injury
  Description:
  Prototype:
  Crash_Severity: K-Fatal Injury
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: O-No Apparent Injury
Name: O-No Apparent Injury
Domains:
Templates:
• Name: O-No Apparent Injury
  Description:
  Prototype:
  Crash_Severity: O-No Apparent Injury
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

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 DateBins   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata