Name: Crashes Mainline 2016-2021
Display Field: GIS_DERIVED_ROUTE_NAME
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: 1523676.29043341
YMin: 1477648.15323174
XMax: 1525608.9325655
YMax: 1489457.85992724
Spatial Reference: 102713 (2258)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"1d8346d500e65576c43a20af2efccb50","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAu0lEQVQokZWR0QnCMBRFb2zqTzfoGh3Dgls4gkj9qP0RcQPdQmxxCtfoBvlRyJP7MILaEr0/gfBOcnNi8Wfs58aqdUWSoBCP3EzQ329o9/OsHwTWF7cQwUEEgAG42hSoOtdsZ9nmDQjDgz0M6qpzIGRDjdHhEIN6eXJHBbQza0SSTlEqwAeycyzikStAG7/cwChAdbQRixecFaBnquPDxvug2ZXZ9aWVyqhuEBJ8/0OAqI42VMSzBk8OQw9ND1F6kYyU9QAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0}},"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)
- ROAD_CHARACTER (type: esriFieldTypeString, alias: ROAD CHARACTER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CRASH_REPORT_NUMBER (type: esriFieldTypeInteger, alias: CRASH REPORT NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CRASH_DATE (type: esriFieldTypeDate, alias: CRASH DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CRASH_YEAR (type: esriFieldTypeInteger, alias: CRASH YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MONTH (type: esriFieldTypeString, alias: MONTH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- TIME_OF_CRASH (type: esriFieldTypeString, alias: TIME OF CRASH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- HOUR_OF_CRASH (type: esriFieldTypeString, alias: HOUR OF CRASH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DAY_OF_WEEK (type: esriFieldTypeString, alias: DAY OF WEEK, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- LAW_ENFORCEMENT_AGENCY (type: esriFieldTypeString, alias: LAW ENFORCEMENT AGENCY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PRIMARY_STREET (type: esriFieldTypeString, alias: PRIMARY STREET, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SECONDARY_STREET (type: esriFieldTypeString, alias: SECONDARY STREET, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- LANDMARK_LOCATION (type: esriFieldTypeString, alias: LANDMARK/LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- GIS_DERIVED_ROUTE_NAME (type: esriFieldTypeString, alias: GIS-DERIVED ROUTE NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- GIS_DERIVED_MILEPOST (type: esriFieldTypeInteger, alias: GIS-DERIVED MILEPOST, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CRASH_DIRECTION (type: esriFieldTypeString, alias: CRASH DIRECTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DIRECTION_FROM_INTERSECTION_OR_ (type: esriFieldTypeString, alias: DIRECTION FROM INTERSECTION OR LANDMARK, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DISTANCE_FROM_LANDMARK (type: esriFieldTypeDouble, alias: DISTANCE FROM LANDMARK, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DISTANCE_FROM_LANDMARK_MEASUREM (type: esriFieldTypeString, alias: DISTANCE FROM LANDMARK MEASUREMENT UNIT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CRASH_SEVERITY (type: esriFieldTypeString, alias: CRASH SEVERITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- NUMBER_OF_PEOPLE_KILLED_IN_CRAS (type: esriFieldTypeInteger, alias: NUMBER OF PEOPLE KILLED IN CRASH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_OF_PEOPLE_WITH_SUSPECTED (type: esriFieldTypeInteger, alias: NUMBER OF PEOPLE WITH SUSPECTED SERIOUS INJURIES (CLASS A) IN CRASH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_OF_PEOPLE_WITH_SUSPECT_1 (type: esriFieldTypeInteger, alias: NUMBER OF PEOPLE WITH SUSPECTED MINOR INJURIES (CLASS B) IN CRASH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_OF_PEOPLE_WITH_POSSIBLE_ (type: esriFieldTypeInteger, alias: NUMBER OF PEOPLE WITH POSSIBLE INJURIES (CLASS C) IN CRASH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_OF_PEOPLE_INJURED__CLASS (type: esriFieldTypeInteger, alias: NUMBER OF PEOPLE INJURED (CLASS A+B+C) IN CRASH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_OF_PEOPLE_NOT_INJURED__C (type: esriFieldTypeInteger, alias: NUMBER OF PEOPLE NOT INJURED (CLASS O) IN CRASH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOTAL_NUMBER_OF_PEOPLE_IN_CRASH (type: esriFieldTypeInteger, alias: TOTAL NUMBER OF PEOPLE IN CRASH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_OF_VEHICLES__BICYCLES__A (type: esriFieldTypeInteger, alias: NUMBER OF VEHICLES, BICYCLES, AND PEDESTRIANS INVOLVED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_OF_PEOPLE_IN_MOTOR_VEHIC (type: esriFieldTypeInteger, alias: NUMBER OF PEOPLE IN MOTOR VEHICLES, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_OF_PEOPLE_NOT_IN_MOTOR_V (type: esriFieldTypeInteger, alias: NUMBER OF PEOPLE NOT IN MOTOR VEHICLES, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_OF_MOTOR_VEHICLES_INVOLV (type: esriFieldTypeInteger, alias: NUMBER OF MOTOR VEHICLES INVOLVED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FIRST_HARMFUL_EVENT_OCCURRED (type: esriFieldTypeString, alias: FIRST HARMFUL EVENT OCCURRED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CRASH_CLASSIFICATION (type: esriFieldTypeString, alias: CRASH CLASSIFICATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CRASH_ANALYSIS (type: esriFieldTypeString, alias: CRASH ANALYSIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- FIRST_HARMFUL_EVENT (type: esriFieldTypeString, alias: FIRST HARMFUL EVENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- FIRST_HARMFUL_EVENT___ANALYSIS (type: esriFieldTypeString, alias: FIRST HARMFUL EVENT - ANALYSIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- FIRST_HARMFUL_EVENT___LOCATION (type: esriFieldTypeString, alias: FIRST HARMFUL EVENT – LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CRASH_TYPE___COMBINED (type: esriFieldTypeString, alias: CRASH TYPE - COMBINED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- FIRST_HARMFUL_EVENT___MANNER_OF (type: esriFieldTypeString, alias: FIRST HARMFUL EVENT – MANNER OF IMPACT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- FIRST_HARMFUL_EVENT___MANNER__1 (type: esriFieldTypeString, alias: FIRST HARMFUL EVENT – MANNER OF CRASH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- WEATHER (type: esriFieldTypeString, alias: WEATHER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ADDITIONAL_WEATHER (type: esriFieldTypeString, alias: ADDITIONAL WEATHER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- LIGHTING (type: esriFieldTypeString, alias: LIGHTING, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- HIT_AND_RUN_CRASH (type: esriFieldTypeString, alias: HIT AND RUN CRASH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ALCOHOL_INVOLVEMENT (type: esriFieldTypeString, alias: ALCOHOL INVOLVEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DRUG_INVOLVEMENT (type: esriFieldTypeString, alias: DRUG INVOLVEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PEDESTRIAN_INVOLVEMENT (type: esriFieldTypeString, alias: PEDESTRIAN INVOLVEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MOTORCYCLE_INVOLVEMENT (type: esriFieldTypeString, alias: MOTORCYCLE INVOLVEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PEDALCYCLE_INVOLVEMENT (type: esriFieldTypeString, alias: PEDALCYCLE INVOLVEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- HEAVY_TRUCK_INVOLVEMENT (type: esriFieldTypeString, alias: HEAVY TRUCK INVOLVEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- COMMERICAL_MOTOR_VEHICLE_INVOLV (type: esriFieldTypeString, alias: COMMERICAL MOTOR VEHICLE INVOLVEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SCHOOL_BUS_DIRECT_INVOLVEMENT (type: esriFieldTypeString, alias: SCHOOL BUS DIRECT INVOLVEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- HAZARDOUS_MATERIAL_INVOLVEMENT (type: esriFieldTypeString, alias: HAZARDOUS MATERIAL INVOLVEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- INVOLVEMENT_OF_NON_LOCAL_DRIVER (type: esriFieldTypeString, alias: INVOLVEMENT OF NON-LOCAL DRIVER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- STATE_HIGHWAY_DEPT__PROPERTY (type: esriFieldTypeString, alias: STATE HIGHWAY DEPT. PROPERTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ROAD_SYSTEM__URBAN__RURAL_OR_RU (type: esriFieldTypeString, alias: ROAD SYSTEM: URBAN, RURAL OR RURAL INTERSTATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MAXIMUM_VEHICLE_DAMAGE (type: esriFieldTypeString, alias: MAXIMUM VEHICLE DAMAGE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- WORK_ZONE (type: esriFieldTypeString, alias: WORK ZONE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- WORK_ZONE___TYPE (type: esriFieldTypeString, alias: WORK ZONE - TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- WORK_ZONE___LOCATION (type: esriFieldTypeString, alias: WORK ZONE – LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ROAD_GRADE (type: esriFieldTypeString, alias: ROAD GRADE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- INTERSECTION_TYPE (type: esriFieldTypeString, alias: INTERSECTION TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- RELATION_TO_JUNCTION (type: esriFieldTypeString, alias: RELATION TO JUNCTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SECONDARY_CRASH (type: esriFieldTypeString, alias: SECONDARY CRASH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- GIS_DERIVED_UTM_X_COORDINATE (type: esriFieldTypeDouble, alias: GIS-DERIVED UTM X COORDINATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GIS_DERIVED_UTM_Y_COORDINATE (type: esriFieldTypeDouble, alias: GIS-DERIVED UTM Y COORDINATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GIS_DERIVED_LATITUDE_COORDINATE (type: esriFieldTypeDouble, alias: GIS-DERIVED LATITUDE COORDINATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GIS_DERIVED_LONGITUDE_COORDINAT (type: esriFieldTypeDouble, alias: GIS-DERIVED LONGITUDE COORDINATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CATEGORY (type: esriFieldTypeString, alias: CATEGORY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Moved (type: esriFieldTypeString, alias: Moved, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Templates:
Name: Crashes Mainline 2016-2021
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/20/2023 6:34:51 PM
Schema Last Edit Date: 10/20/2023 6:34:51 PM
Data Last Edit Date: 10/20/2023 6:34:51 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat