Name: Crash_EA

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: -12140244.3575133
YMin: 3684146.46334155
XMax: -11466166.5882661
YMax: 4439121.14371385
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[47,132,135,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: 34, nullable: true, editable: true)
• Date (type: esriFieldTypeString, alias: Date of Crash, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• Year (type: esriFieldTypeInteger, alias: Crash Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Month (type: esriFieldTypeString, alias: Month of Crash, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• Day (type: esriFieldTypeString, alias: Day of Crash, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• DayOfWeek (type: esriFieldTypeString, alias: Day of Week, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• Hour (type: esriFieldTypeString, alias: Hour of Crash, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• KABCO (type: esriFieldTypeString, alias: KABCO Classification, 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 Serious Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B (type: esriFieldTypeInteger, alias: Number of Minor Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C (type: esriFieldTypeInteger, alias: Number of Compliant of Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• O (type: esriFieldTypeInteger, alias: Number of No Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumVeh (type: esriFieldTypeInteger, alias: Number of Motor Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashClass (type: esriFieldTypeString, alias: Crash Classification, SQL Type: sqlTypeOther, length: 42, nullable: true, editable: true)
• CraAnalys (type: esriFieldTypeString, alias: Crash Analysis, SQL Type: sqlTypeOther, length: 168, nullable: true, editable: true)
• Severity (type: esriFieldTypeString, alias: Crash Severity, SQL Type: sqlTypeOther, length: 52, nullable: true, editable: true)
• FstHarmEve (type: esriFieldTypeString, alias: First Harmful Event, SQL Type: sqlTypeOther, length: 74, nullable: true, editable: true)
• FstHEvent_Occ (type: esriFieldTypeString, alias: First Harmful Event Occ., SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
• FstHarmLoc (type: esriFieldTypeString, alias: First Harmful Event - Location, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• FstHarmImp (type: esriFieldTypeString, alias: First Harmful Event - Impact, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
• FstHarmCra (type: esriFieldTypeString, alias: First Harmful Event - Crash, SQL Type: sqlTypeOther, length: 52, nullable: true, editable: true)
• FstHarmAna (type: esriFieldTypeString, alias: First Harmful Event - Analysis, SQL Type: sqlTypeOther, length: 130, nullable: true, editable: true)
• Weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 66, nullable: true, editable: true)
• AddWea (type: esriFieldTypeString, alias: Additional Weather, SQL Type: sqlTypeOther, length: 66, nullable: true, editable: true)
• Light (type: esriFieldTypeString, alias: Lighting, SQL Type: sqlTypeOther, length: 46, nullable: true, editable: true)
• RdChrc (type: esriFieldTypeString, alias: Road Character, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• RdGrade (type: esriFieldTypeString, alias: Road Grade, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• IntType (type: esriFieldTypeString, alias: Intersection Type, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• RelToJun (type: esriFieldTypeString, alias: Relation to Junction, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• StHwyProp (type: esriFieldTypeString, alias: State Highway Dept. Property, SQL Type: sqlTypeOther, length: 82, nullable: true, editable: true)
• MaxVehDam (type: esriFieldTypeString, alias: Maximum Vehicle Damage, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
• EnfAgency (type: esriFieldTypeString, alias: Law Enforcement Agency, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 52, nullable: true, editable: true)
• Rdsys (type: esriFieldTypeString, alias: Road System, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• GISRes (type: esriFieldTypeString, alias: GIS Derived Reservation, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• GISTrDist (type: esriFieldTypeInteger, alias: GIS Derived Transp. District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GISPolDist (type: esriFieldTypeInteger, alias: GIS Derived Police District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GISMainDis (type: esriFieldTypeInteger, alias: GIS Derived Hwy Maint. District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PriStreet (type: esriFieldTypeString, alias: Primary Street, SQL Type: sqlTypeOther, length: 130, nullable: true, editable: true)
• SecStreet (type: esriFieldTypeString, alias: Secondary Street, SQL Type: sqlTypeOther, length: 118, nullable: true, editable: true)
• Landmark (type: esriFieldTypeString, alias: Landmark/Location, SQL Type: sqlTypeOther, length: 180, nullable: true, editable: true)
• Landmark_Dir (type: esriFieldTypeString, alias: Direction from Landmark, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• Landmark_Dist (type: esriFieldTypeString, alias: Distance from Landmark, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Landmark_Unit (type: esriFieldTypeString, alias: Distance from Landmark Unit, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• GISRoute (type: esriFieldTypeString, alias: GIS Derived Route Name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• GISMilepst (type: esriFieldTypeDouble, alias: GIS Derived Milepost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Direction (type: esriFieldTypeString, alias: Crash Direction, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• WrkZone (type: esriFieldTypeString, alias: Work Zone, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• WrkType (type: esriFieldTypeString, alias: Work Zone - Type, SQL Type: sqlTypeOther, length: 54, nullable: true, editable: true)
• WrkLoc (type: esriFieldTypeString, alias: Work Zone - Location, SQL Type: sqlTypeOther, length: 58, nullable: true, editable: true)
• HandR (type: esriFieldTypeInteger, alias: Hit and Run Crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ComVehInv (type: esriFieldTypeInteger, alias: Comm. Motor Vehicle Inv., SQL Type: sqlTypeOther, nullable: true, editable: true)
• SchBusDInv (type: esriFieldTypeInteger, alias: School Bus direct Inv., SQL Type: sqlTypeOther, nullable: true, editable: true)
• HazMedInv (type: esriFieldTypeInteger, alias: Hazardous Material Inv., SQL Type: sqlTypeOther, nullable: true, editable: true)
• NonLocDrv (type: esriFieldTypeString, alias: Inv. of Non-Local Driver, SQL Type: sqlTypeOther, length: 54, nullable: true, editable: true)
• SecCrash (type: esriFieldTypeInteger, alias: Secondary Crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TriJur (type: esriFieldTypeInteger, alias: Tribal Jurisdiction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StatRep (type: esriFieldTypeInteger, alias: Station Report, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TracsData (type: esriFieldTypeInteger, alias: Tracs Data, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_PedInv (type: esriFieldTypeInteger, alias: Pedestrian Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_YngDrv (type: esriFieldTypeInteger, alias: Young Driver Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_OldDrv (type: esriFieldTypeInteger, alias: Older Driver Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_IntRel (type: esriFieldTypeInteger, alias: Intersection Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_BikInv (type: esriFieldTypeInteger, alias: Bicycles Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_HwyTrk (type: esriFieldTypeInteger, alias: Heavy Trucks Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Light (type: esriFieldTypeInteger, alias: Lighting Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_IncWea (type: esriFieldTypeInteger, alias: Inclement Weather, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_TriLnd (type: esriFieldTypeInteger, alias: Tribal Lands, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_AlcInv (type: esriFieldTypeInteger, alias: Alcohol Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_DrgInv (type: esriFieldTypeInteger, alias: Drug Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_ImpDrv (type: esriFieldTypeInteger, alias: Impaired Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_SpdDrv (type: esriFieldTypeInteger, alias: Speed Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_AggDrv (type: esriFieldTypeInteger, alias: Aggressive Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_SpdAgg (type: esriFieldTypeInteger, alias: Speed/Aggressive Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Unres (type: esriFieldTypeInteger, alias: Unrestrained Occupant, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_MotInv (type: esriFieldTypeInteger, alias: Motorcycle Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_MotAtvMopInv (type: esriFieldTypeInteger, alias: Motorcycle/ATVs/Moped Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_SlpDrv (type: esriFieldTypeInteger, alias: Sleepy/Fatigued Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_WrkZon (type: esriFieldTypeInteger, alias: Work Zone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Rail (type: esriFieldTypeInteger, alias: Rail Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Bus (type: esriFieldTypeInteger, alias: Bus Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Animal (type: esriFieldTypeInteger, alias: Animal Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_Distrc (type: esriFieldTypeInteger, alias: Distracted Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_RdwDep (type: esriFieldTypeInteger, alias: Roadway Departure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ea_SchBusInv (type: esriFieldTypeInteger, alias: School Bus Involvement, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Crash_EA
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• Person_EA (0) -- Related To: Person_EA (2)
• Vehicle_EA (1) -- Related To: Vehicle_EA (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/26/2023 11:32:44 PM

Schema Last Edit Date: 8/26/2023 8:49:50 PM

Data Last Edit Date: 8/26/2023 11:32:44 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat