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:

Name : OBJECTID

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:

Attributes:

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