Name: Crash
Display Field: CID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -10191732.2964938
YMin: 4432826.46205333
XMax: -9725516.00748166
YMax: 5238722.12414221
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[145,39,145,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- CID (type: esriFieldTypeString, alias: Crash ID, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- NO_VEH (type: esriFieldTypeInteger, alias: Number Of Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
- YEAR (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DAYOFWEEK (type: esriFieldTypeString, alias: Day Of Week, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- KABCO (type: esriFieldTypeString, alias: KABCO, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- K (type: esriFieldTypeInteger, alias: Number Of Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
- A (type: esriFieldTypeInteger, alias: Number of A Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
- B (type: esriFieldTypeInteger, alias: Number of B Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
- C (type: esriFieldTypeInteger, alias: Number of C Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
- O (type: esriFieldTypeInteger, alias: Number of Persons with No Injury, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RT_NBR (type: esriFieldTypeString, alias: Route Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- INT_REL (type: esriFieldTypeInteger, alias: Intersection Related, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
- FUNC_CLASS (type: esriFieldTypeInteger, alias: Functional Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Interstate], [2: Freeway and Expressway], [3: Other Principal Arterial], ... 15 more ...)
- TWAY_CLASS (type: esriFieldTypeInteger, alias: Traffic Way Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unmarked Highway rural], [1: Controlled rural], [2: State numbered rural], ... 7 more ...)
- TWAY_DESC (type: esriFieldTypeInteger, alias: Traffic Way Description, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Two Way: Not divided], [2: Two Way: Divided, with median barrier (not raised)], [3: Two Way: Divided, with median barrier], ... 20 more ...)
- TCONT_DEV (type: esriFieldTypeInteger, alias: Traffic Control Device, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No controls], [2: Stop sign], [3: Traffic signal], ... 17 more ...)
- TCONT_CON (type: esriFieldTypeInteger, alias: Traffic Control Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No controls], [2: Not functioning], [3: Functioning improperly], ... 6 more ...)
- ALIGN (type: esriFieldTypeInteger, alias: Alignment Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Straight and level], [2: Straight on grade], [3: Straight on hillcrest], ... 5 more ...)
- SURF_CON (type: esriFieldTypeInteger, alias: Surface Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dry], [2: Wet], [3: Snow or slush], ... 5 more ...)
- DEFECT (type: esriFieldTypeInteger, alias: Road Defects, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No defects], [2: Construction zone], [3: Maintenance zone], ... 9 more ...)
- LIGHT (type: esriFieldTypeInteger, alias: Light Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Daylight], [2: Dawn], [3: Dusk], ... 4 more ...)
- WEATHER (type: esriFieldTypeInteger, alias: Weather Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Clear], [2: Rain], [3: Snow], ... 8 more ...)
- COL_TYPE (type: esriFieldTypeInteger, alias: Collision Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pedestrian], [2: Pedalcyclist], [3: Railway Train], ... 16 more ...)
- CAUSE_1 (type: esriFieldTypeInteger, alias: Primary Cause, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Exceeding authorized speed limit], [2: Failing to yield right-of way], [3: Following too closely], ... 38 more ...)
- CAUSE_2 (type: esriFieldTypeInteger, alias: Secondary Cause, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Exceeding authorized speed limit], [2: Failing to yield right-of way], [3: Following too closely], ... 38 more ...)
- HIT_RUN (type: esriFieldTypeInteger, alias: Is Hit and Run, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
- PROP_DESC1 (type: esriFieldTypeString, alias: Property Description 1, SQL Type: sqlTypeOther, length: 102, nullable: true, editable: true)
- PROP_DESC2 (type: esriFieldTypeString, alias: Property Description 2, SQL Type: sqlTypeOther, length: 102, nullable: true, editable: true)
- WZ_TYPE (type: esriFieldTypeInteger, alias: Work Zone Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Blank (Crash in Designated Work Zone was "No")], [2: Construction], [3: Maintenance], ... 3 more ...)
- WZ_WORKER (type: esriFieldTypeInteger, alias: Workers Present, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
- WZ_RELATED (type: esriFieldTypeInteger, alias: Work Zone Related, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
- Pedestrian (type: esriFieldTypeInteger, alias: Pedestrian, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Pedalcyclist (type: esriFieldTypeInteger, alias: Pedalcyclist, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Younger_Driver__16_20_ (type: esriFieldTypeInteger, alias: Younger_Driver__16_20_, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Older_Driver__65__ (type: esriFieldTypeInteger, alias: Older_Driver__65__, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Unrestrained_Occupants (type: esriFieldTypeInteger, alias: Unrestrained_Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Impaired_Driver (type: esriFieldTypeInteger, alias: Impaired_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Distracted_Fatigued_Drowsy_Driv (type: esriFieldTypeInteger, alias: Distracted_Fatigued_Drowsy_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Speeding_Aggressive_Driver (type: esriFieldTypeInteger, alias: Speeding_Aggressive_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Wrong_Way_Driving (type: esriFieldTypeInteger, alias: Wrong_Way_Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Roadway_Departure (type: esriFieldTypeInteger, alias: Roadway_Departure, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Highway_Railroad_Grade_Crossing (type: esriFieldTypeInteger, alias: Highway_Railroad_Grade_Crossings, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Work_Zone (type: esriFieldTypeInteger, alias: Work_Zone, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Animal (type: esriFieldTypeInteger, alias: Animal, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Heavy_Vehicle (type: esriFieldTypeInteger, alias: Heavy_Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Motorcycle (type: esriFieldTypeInteger, alias: Motorcycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Intersection_Related (type: esriFieldTypeInteger, alias: Intersection_Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EA_List (type: esriFieldTypeString, alias: EA_List, SQL Type: sqlTypeOther, length: 292, nullable: true, editable: true)
- DATE (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Templates:
Name: Crash
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Relationships:
- Vehicle (0) -- Related To: Vehicle (5)
- Person (1) -- Related To: Person (4)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/18/2023 6:16:15 PM
Schema Last Edit Date: 1/18/2023 6:16:15 PM
Data Last Edit Date: 1/18/2023 6:16:15 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat