View In:   ArcGIS Online Map Viewer

Name: Off System Commercial Vehicle Crashes

Display Field: ON_ROADWAY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 68cc4c1b4235467481bdf7e2a0df6045

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 300000

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: -128529.39297058772
YMin: 2714955.7068008846
XMax: 596172.4452234483
YMax: 3447858.940457178
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• XID ( type: esriFieldTypeString, alias: Crash Id, editable: true, nullable: false, length: 13, defaultValue: null, modelName: XID )
• CALENDAR_YEAR ( type: esriFieldTypeSmallInteger, alias: Calendar Year, editable: true, nullable: false, defaultValue: null, modelName: CALENDAR_YEAR )
• CRASH_NUMBER ( type: esriFieldTypeString, alias: FDOT Crash Number, editable: true, nullable: true, length: 9, defaultValue: null, modelName: CRASH_NUMBER )
• CASE_NUMBER ( type: esriFieldTypeString, alias: Reporting Agency Case Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CASE_NUMBER )
• INVSTGT_AGCY_CD ( type: esriFieldTypeString, alias: Reporting Agency Code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: INVSTGT_AGCY_CD )
• AGENCY_TYPE_TXT ( type: esriFieldTypeString, alias: Reporting Agency Type, editable: true, nullable: true, length: 35, defaultValue: null, modelName: AGENCY_TYPE_TXT )
• DOT_GEOG_DIST_CD ( type: esriFieldTypeString, alias: FDOT Managing District, editable: true, nullable: true, length: 2, defaultValue: null, modelName: DOT_GEOG_DIST_CD )
• DOT_CNTY_CD ( type: esriFieldTypeString, alias: FDOT County Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: DOT_CNTY_CD )
• COUNTY_TXT ( type: esriFieldTypeString, alias: County Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COUNTY_TXT )
• CRASH_DATE ( type: esriFieldTypeDate, alias: Crash Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CRASH_DATE )
• CRASH_TIME ( type: esriFieldTypeString, alias: Crash Time, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CRASH_TIME )
• DAYOWEEK ( type: esriFieldTypeString, alias: Week Day Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: DAYOWEEK )
• WEEKDAY_TXT ( type: esriFieldTypeString, alias: Day, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WEEKDAY_TXT )
• DHSMV_CTY_CD ( type: esriFieldTypeString, alias: DHSHMV City, editable: true, nullable: true, length: 4, defaultValue: null, modelName: DHSMV_CTY_CD )
• DHSCNTYCTY ( type: esriFieldTypeString, alias: Crash Report City Code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: DHSCNTYCTY )
• IN_TOWN_FLAG ( type: esriFieldTypeString, alias: In Town, editable: true, nullable: true, length: 1, defaultValue: null, modelName: IN_TOWN_FLAG )
• ON_ROADWAY_NAME ( type: esriFieldTypeString, alias: On Roadway Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ON_ROADWAY_NAME )
• INT_ROADWAY_NAME ( type: esriFieldTypeString, alias: Int Roadway Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INT_ROADWAY_NAME )
• REFDISTANCE_MI ( type: esriFieldTypeDouble, alias: Reference Distance (Miles), editable: true, nullable: true, defaultValue: null, modelName: REFDISTANCE_MI )
• REFDIRECT ( type: esriFieldTypeString, alias: Reference Direction, editable: true, nullable: true, length: 1, defaultValue: null, modelName: REFDIRECT )
• OFFICER_LATITUDE ( type: esriFieldTypeDouble, alias: Officer Latitude, editable: true, nullable: true, defaultValue: null, modelName: OFFICER_LATITUDE )
• OFFICER_LONGITUDE ( type: esriFieldTypeDouble, alias: Officer Longitude, editable: true, nullable: true, defaultValue: null, modelName: OFFICER_LONGITUDE )
• SAFETYLAT ( type: esriFieldTypeDouble, alias: FDOT Latitude, editable: true, nullable: true, defaultValue: null, modelName: SAFETYLAT )
• SAFETYLON ( type: esriFieldTypeDouble, alias: FDOT Longitude, editable: true, nullable: true, defaultValue: null, modelName: SAFETYLON )
• ROADWAYID ( type: esriFieldTypeString, alias: FDOT Roadway, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ROADWAYID )
• LOCMP ( type: esriFieldTypeDouble, alias: Nearest Inventory MP, editable: true, nullable: true, defaultValue: null, modelName: LOCMP )
• NEAREST_NODE_FROM_CRASH ( type: esriFieldTypeString, alias: Nearest Node From Crash, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEAREST_NODE_FROM_CRASH )
• STATE_ROAD_NUMBER ( type: esriFieldTypeString, alias: State Road #, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STATE_ROAD_NUMBER )
• US_ROAD_NUMBER ( type: esriFieldTypeString, alias: US Highway, editable: true, nullable: true, length: 8, defaultValue: null, modelName: US_ROAD_NUMBER )
• ACCSIDRD ( type: esriFieldTypeString, alias: Crash Side of Road, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ACCSIDRD )
• ACCLANE ( type: esriFieldTypeString, alias: Accident Lane Number, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ACCLANE )
• TRAVDIR ( type: esriFieldTypeString, alias: Travel Direction Vehicle 1, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TRAVDIR )
• CRRATECD ( type: esriFieldTypeString, alias: FDOT Road Category, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CRRATECD )
• DHSRDSYS ( type: esriFieldTypeString, alias: DHSMV Road System Id, editable: true, nullable: true, length: 2, defaultValue: null, modelName: DHSRDSYS )
• JCT_CD ( type: esriFieldTypeString, alias: Relation to Junction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: JCT_CD )
• FRST_HARM_LOC_CD ( type: esriFieldTypeString, alias: Crash Harmful Event Location, editable: true, nullable: true, length: 2, defaultValue: null, modelName: FRST_HARM_LOC_CD )
• INTCT_TYP_CD ( type: esriFieldTypeString, alias: Intersection Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: INTCT_TYP_CD )
• TYPESHLD ( type: esriFieldTypeString, alias: Shoulder Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: TYPESHLD )
• SKID_NUMBER ( type: esriFieldTypeSmallInteger, alias: FDOT Roadway SKID Test Result, editable: true, nullable: true, defaultValue: null, modelName: SKID_NUMBER )
• SKID_TEST_DATE ( type: esriFieldTypeDate, alias: FDOT Roadway SKID Test Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SKID_TEST_DATE )
• FUNCLASS ( type: esriFieldTypeString, alias: Functional Class, editable: true, nullable: true, length: 2, defaultValue: null, modelName: FUNCLASS )
• RCI_SURFACE_WIDTH_FT ( type: esriFieldTypeDouble, alias: RCI Surface Width, editable: true, nullable: true, defaultValue: null, modelName: RCI_SURFACE_WIDTH_FT )
• RCI_SHOULDER_TYPE_1 ( type: esriFieldTypeString, alias: RCI Shoulder Type First Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RCI_SHOULDER_TYPE_1 )
• RCI_SHOULDER_TYPE_1_TXT ( type: esriFieldTypeString, alias: RCI Shoulder Type First, editable: true, nullable: true, length: 35, defaultValue: null, modelName: RCI_SHOULDER_TYPE_1_TXT )
• RCI_SHOULDER_WIDTH_1_FT ( type: esriFieldTypeDouble, alias: RCI Shoulder Width First, editable: true, nullable: true, defaultValue: null, modelName: RCI_SHOULDER_WIDTH_1_FT )
• RCI_SHOULDER_TYPE_2 ( type: esriFieldTypeString, alias: RCI Shoulder Type Second Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RCI_SHOULDER_TYPE_2 )
• RCI_SHOULDER_TYPE_2_TXT ( type: esriFieldTypeString, alias: RCI Shoulder Type Second, editable: true, nullable: true, length: 35, defaultValue: null, modelName: RCI_SHOULDER_TYPE_2_TXT )
• RCI_SHOULDER_WIDTH_2_FT ( type: esriFieldTypeDouble, alias: RCI Shoulder Width Second, editable: true, nullable: true, defaultValue: null, modelName: RCI_SHOULDER_WIDTH_2_FT )
• RCI_SHOULDER_TYPE_3 ( type: esriFieldTypeString, alias: RCI Shoulder Type Third Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RCI_SHOULDER_TYPE_3 )
• RCI_SHOULDER_TYPE_3_TXT ( type: esriFieldTypeString, alias: RCI Shoulder Type Third, editable: true, nullable: true, length: 35, defaultValue: null, modelName: RCI_SHOULDER_TYPE_3_TXT )
• RCI_SHOULDER_WIDTH_3_FT ( type: esriFieldTypeDouble, alias: RCI Shoulder Width Third, editable: true, nullable: true, defaultValue: null, modelName: RCI_SHOULDER_WIDTH_3_FT )
• RCI_MEDIAN_WIDTH_FT ( type: esriFieldTypeDouble, alias: RCI Median Width, editable: true, nullable: true, defaultValue: null, modelName: RCI_MEDIAN_WIDTH_FT )
• AVERAGE_DAILY_TRAFFIC ( type: esriFieldTypeInteger, alias: Avg Daily Traffic, editable: true, nullable: true, defaultValue: null, modelName: AVERAGE_DAILY_TRAFFIC )
• AADT_SOURCE ( type: esriFieldTypeString, alias: AADT Source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AADT_SOURCE )
• RCI_AVG_PERC_TRUCK_TRAFF ( type: esriFieldTypeDouble, alias: RCI Avg Per Truck Traffic, editable: true, nullable: true, defaultValue: null, modelName: RCI_AVG_PERC_TRUCK_TRAFF )
• RCI_HORIZ_CURVE_CD ( type: esriFieldTypeString, alias: RCI Horiz Curve Condition, editable: true, nullable: true, length: 6, defaultValue: null, modelName: RCI_HORIZ_CURVE_CD )
• SPEED_LIMIT ( type: esriFieldTypeSmallInteger, alias: Posted Speed Limit, editable: true, nullable: true, defaultValue: null, modelName: SPEED_LIMIT )
• INJSEVER ( type: esriFieldTypeString, alias: Highest Injury in Crash, editable: true, nullable: true, length: 1, defaultValue: null, modelName: INJSEVER )
• CARSTACD ( type: esriFieldTypeString, alias: CAR Status Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CARSTACD )
• ALCINVCD ( type: esriFieldTypeString, alias: Alcohols/Drug Involved, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ALCINVCD )
• SITELOCA ( type: esriFieldTypeString, alias: Site Location, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SITELOCA )
• LGHT_COND_CD ( type: esriFieldTypeString, alias: Lighting, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LGHT_COND_CD )
• EVNT_WTHR_COND_CD ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 2, defaultValue: null, modelName: EVNT_WTHR_COND_CD )
• RD_SRFC_COND_CD ( type: esriFieldTypeString, alias: Road Surface, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RD_SRFC_COND_CD )
• RDWY_GRDE_CD ( type: esriFieldTypeString, alias: Roadway Grade, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RDWY_GRDE_CD )
• RDWY_ALIGN_CD ( type: esriFieldTypeString, alias: Roadway Alignment, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RDWY_ALIGN_CD )
• TRAF_WAY_CD ( type: esriFieldTypeString, alias: Traffic Way, editable: true, nullable: true, length: 2, defaultValue: null, modelName: TRAF_WAY_CD )
• V1_TRAF_WAY_CD ( type: esriFieldTypeString, alias: Traffic Way Vehicle 1 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: V1_TRAF_WAY_CD )
• V1_TRAF_WAY_CD_TXT ( type: esriFieldTypeString, alias: Traffic Way Vehicle 1, editable: true, nullable: true, length: 35, defaultValue: null, modelName: V1_TRAF_WAY_CD_TXT )
• V2_TRAF_WAY_CD ( type: esriFieldTypeString, alias: Traffic Way Vehicle 2 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: V2_TRAF_WAY_CD )
• V2_TRAF_WAY_CD_TXT ( type: esriFieldTypeString, alias: Traffic Way Vehicle 2, editable: true, nullable: true, length: 35, defaultValue: null, modelName: V2_TRAF_WAY_CD_TXT )
• V1TRAFCTL ( type: esriFieldTypeString, alias: Traffic Control Vehicle 1 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: V1TRAFCTL )
• V1TRAFCTL_TXT ( type: esriFieldTypeString, alias: Traffic Control Vehicle 1, editable: true, nullable: true, length: 35, defaultValue: null, modelName: V1TRAFCTL_TXT )
• V2TRAFCTL ( type: esriFieldTypeString, alias: Traffic Control Vehicle 2 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: V2TRAFCTL )
• V2TRAFCTL_TXT ( type: esriFieldTypeString, alias: Traffic Control Vehicle 2, editable: true, nullable: true, length: 35, defaultValue: null, modelName: V2TRAFCTL_TXT )
• TRAFFIC_CONTROL_MC ( type: esriFieldTypeString, alias: TRAFFIC_CONTROL_MC, editable: true, nullable: true, length: 6, defaultValue: null, modelName: TRAFFIC_CONTROL_MC )
• CNTOFLANES ( type: esriFieldTypeSmallInteger, alias: Count of Lanes, editable: true, nullable: true, defaultValue: null, modelName: CNTOFLANES )
• ROADCOND1 ( type: esriFieldTypeString, alias: Road Condition 1 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROADCOND1 )
• ROADCOND1_TXT ( type: esriFieldTypeString, alias: Road Condition 1, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ROADCOND1_TXT )
• ROADCOND2 ( type: esriFieldTypeString, alias: Road Condition 2 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROADCOND2 )
• ROADCOND2_TXT ( type: esriFieldTypeString, alias: Road Condition 2, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ROADCOND2_TXT )
• ROADCOND3 ( type: esriFieldTypeString, alias: Road Condition 3 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROADCOND3 )
• ROADCOND3_TXT ( type: esriFieldTypeString, alias: Road Condition 3, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ROADCOND3_TXT )
• ROAD_CONDITION_MC ( type: esriFieldTypeString, alias: ROAD_CONDITION_MC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ROAD_CONDITION_MC )
• ENVIRNMT1 ( type: esriFieldTypeString, alias: Environment Condition 1 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ENVIRNMT1 )
• ENVIRNMT1_TXT ( type: esriFieldTypeString, alias: Environment Condition 1, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ENVIRNMT1_TXT )
• ENVIRNMT2 ( type: esriFieldTypeString, alias: Environment Condition 2 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ENVIRNMT2 )
• ENVIRNMT2_TXT ( type: esriFieldTypeString, alias: Environment Condition 2, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ENVIRNMT2_TXT )
• ENVIRNMT3 ( type: esriFieldTypeString, alias: Environment Condition 3 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ENVIRNMT3 )
• ENVIRNMT3_TXT ( type: esriFieldTypeString, alias: Environment Condition 3, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ENVIRNMT3_TXT )
• ENVIRONMENT_CONDITION_MC ( type: esriFieldTypeString, alias: ENVIRONMENT_CONDITION_MC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ENVIRONMENT_CONDITION_MC )
• MOST_HARM_EVNT_CD ( type: esriFieldTypeString, alias: Crash Harmful Event, editable: true, nullable: true, length: 2, defaultValue: null, modelName: MOST_HARM_EVNT_CD )
• IMPCT_TYP_CD ( type: esriFieldTypeString, alias: Manner of Collision, editable: true, nullable: true, length: 2, defaultValue: null, modelName: IMPCT_TYP_CD )
• VHCL_MOVE_CD ( type: esriFieldTypeString, alias: Vehicle Movement, editable: true, nullable: true, length: 2, defaultValue: null, modelName: VHCL_MOVE_CD )
• D1_FRST_DR_ACTN_CD ( type: esriFieldTypeString, alias: Driver Action Vehicle 1 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: D1_FRST_DR_ACTN_CD )
• D1_FRST_DR_ACTN_CD_TXT ( type: esriFieldTypeString, alias: Driver Action Vehicle 1, editable: true, nullable: true, length: 35, defaultValue: null, modelName: D1_FRST_DR_ACTN_CD_TXT )
• D2_FRST_DR_ACTN_CD ( type: esriFieldTypeString, alias: Driver Action Vehicle 2 Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: D2_FRST_DR_ACTN_CD )
• D2_FRST_DR_ACTN_CD_TXT ( type: esriFieldTypeString, alias: Driver Action Vehicle 2, editable: true, nullable: true, length: 35, defaultValue: null, modelName: D2_FRST_DR_ACTN_CD_TXT )
• DRIVER_ACTION_MC ( type: esriFieldTypeString, alias: DRIVER_ACTION_MC, editable: true, nullable: true, length: 6, defaultValue: null, modelName: DRIVER_ACTION_MC )
• LOC_WTHN_ZONE_CD ( type: esriFieldTypeString, alias: Location Within Workzone, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LOC_WTHN_ZONE_CD )
• WRK_ZONE_TYP_CD ( type: esriFieldTypeString, alias: Type of Workzone, editable: true, nullable: true, length: 2, defaultValue: null, modelName: WRK_ZONE_TYP_CD )
• WRK_PRSNT_CD ( type: esriFieldTypeString, alias: Workers Present in Workzone, editable: true, nullable: true, length: 2, defaultValue: null, modelName: WRK_PRSNT_CD )
• LAW_ENFRC_PRSNT_CD ( type: esriFieldTypeString, alias: Law Enforcement Present in Workzone, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LAW_ENFRC_PRSNT_CD )
• SCHL_BUS_REL_CD ( type: esriFieldTypeString, alias: School Bus Related, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SCHL_BUS_REL_CD )
• NUMBER_OF_INJURED ( type: esriFieldTypeSmallInteger, alias: Count of Nonfatal Injuries, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_INJURED )
• NUMBER_OF_KILLED ( type: esriFieldTypeSmallInteger, alias: Count of Traffic Fatalities, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_KILLED )
• NUMBER_OF_SERIOUS_INJURIES ( type: esriFieldTypeSmallInteger, alias: Count of Serious Injuries, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_SERIOUS_INJURIES )
• NUMBER_OF_PEDESTRIANS ( type: esriFieldTypeSmallInteger, alias: Count of Pedestrians, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_PEDESTRIANS )
• TOTAL_DRIVERS ( type: esriFieldTypeSmallInteger, alias: Count of Drivers, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_DRIVERS )
• NUMBER_OF_BICYCLISTS ( type: esriFieldTypeSmallInteger, alias: Count of Bicyclists, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_BICYCLISTS )
• NUMBER_OF_VEHICLES ( type: esriFieldTypeSmallInteger, alias: Count of Vehicles, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_VEHICLES )
• TOTAL_PERSONS ( type: esriFieldTypeInteger, alias: Count of Persons, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_PERSONS )
• WRONGWAY_IND ( type: esriFieldTypeString, alias: Wrong Way, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WRONGWAY_IND )
• WORKZONE_IND ( type: esriFieldTypeString, alias: Workzone Inv, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WORKZONE_IND )
• COMMERCIAL_VEHICLE_IND ( type: esriFieldTypeString, alias: Commercial Vehicle Inv, editable: true, nullable: true, length: 1, defaultValue: null, modelName: COMMERCIAL_VEHICLE_IND )
• INTERSECTION_IND ( type: esriFieldTypeString, alias: Intersection Inv, editable: true, nullable: true, length: 1, defaultValue: null, modelName: INTERSECTION_IND )
• LANE_DEPARTURE_IND ( type: esriFieldTypeString, alias: Lane Departure, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LANE_DEPARTURE_IND )
• CRASH_CLASS_IND_MC ( type: esriFieldTypeString, alias: CRASH_CLASS_IND_MC, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CRASH_CLASS_IND_MC )
• SPEEDING_IND ( type: esriFieldTypeString, alias: Speeding, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SPEEDING_IND )
• AGGRESSIVE_DRIVING_IND ( type: esriFieldTypeString, alias: Agressive Driving, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AGGRESSIVE_DRIVING_IND )
• IMPAIRED_DRIVER_IND ( type: esriFieldTypeString, alias: Impaired Driver, editable: true, nullable: true, length: 1, defaultValue: null, modelName: IMPAIRED_DRIVER_IND )
• IMPAIRED_PEDESTRIAN_IND ( type: esriFieldTypeString, alias: Impaired Pedestrian, editable: true, nullable: true, length: 1, defaultValue: null, modelName: IMPAIRED_PEDESTRIAN_IND )
• IMPAIRED_BICYCLIST_IND ( type: esriFieldTypeString, alias: Impaired Bicyclist, editable: true, nullable: true, length: 1, defaultValue: null, modelName: IMPAIRED_BICYCLIST_IND )
• DISTRACTED_DRIVER_IND ( type: esriFieldTypeString, alias: Distracted Driver, editable: true, nullable: true, length: 1, defaultValue: null, modelName: DISTRACTED_DRIVER_IND )
• DRIVER_PEDEST_CONDIT_IND_MC ( type: esriFieldTypeString, alias: DRIVER_PEDEST_CONDIT_IND_MC, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DRIVER_PEDEST_CONDIT_IND_MC )
• SPEEDING_AGGRESSIVE_IND ( type: esriFieldTypeString, alias: Speeding or Aggressive Driving, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SPEEDING_AGGRESSIVE_IND )
• PEDESTRIAN_RELATED_IND ( type: esriFieldTypeString, alias: Pedestrian Related, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PEDESTRIAN_RELATED_IND )
• BICYCLIST_RELATED_IND ( type: esriFieldTypeString, alias: Bicyclist Related, editable: true, nullable: true, length: 1, defaultValue: null, modelName: BICYCLIST_RELATED_IND )
• PEDESTRIAN_BICYCLIST_IND ( type: esriFieldTypeString, alias: Pedestrian or Bicyclist Related, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PEDESTRIAN_BICYCLIST_IND )
• MOTORCYCLE_INVOLVED_IND ( type: esriFieldTypeString, alias: Motorcycle Inv, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MOTORCYCLE_INVOLVED_IND )
• NO_BELT_IND ( type: esriFieldTypeString, alias: No Belt, editable: true, nullable: true, length: 2, defaultValue: null, modelName: NO_BELT_IND )
• NO_BELT_AGE_1_4_IND ( type: esriFieldTypeString, alias: No Belt - Ages 1-4, editable: true, nullable: true, length: 1, defaultValue: null, modelName: NO_BELT_AGE_1_4_IND )
• NO_BELT_AGE_5_12_IND ( type: esriFieldTypeString, alias: No Belt - Ages 5-12, editable: true, nullable: true, length: 1, defaultValue: null, modelName: NO_BELT_AGE_5_12_IND )
• NO_BELT_AGE_13_17_IND ( type: esriFieldTypeString, alias: No Belt - Ages 13-17, editable: true, nullable: true, length: 1, defaultValue: null, modelName: NO_BELT_AGE_13_17_IND )
• AGE_TEEN_IND ( type: esriFieldTypeString, alias: Driver - Ages Teen, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AGE_TEEN_IND )
• AGE_65_PLUS_IND ( type: esriFieldTypeString, alias: Driver - Ages 65 plus, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AGE_65_PLUS_IND )
• AGE_65_69_IND ( type: esriFieldTypeString, alias: Driver - Ages 65-69, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AGE_65_69_IND )
• AGE_70_74_IND ( type: esriFieldTypeString, alias: Driver - Ages 70-74, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AGE_70_74_IND )
• AGE_75_79_IND ( type: esriFieldTypeString, alias: Driver - Ages 75-79, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AGE_75_79_IND )
• AGE_80_PLUS_IND ( type: esriFieldTypeString, alias: Driver - Ages 80 plus, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AGE_80_PLUS_IND )
• LINK_ID ( type: esriFieldTypeInteger, alias: Navteq Link Id, editable: true, nullable: true, defaultValue: null, modelName: LINK_ID )
• CRSH_REF_NODE_ID ( type: esriFieldTypeInteger, alias: Crash Reference Node Id, editable: true, nullable: true, defaultValue: null, modelName: CRSH_REF_NODE_ID )
• CRSH_XTMREF_NOD_ID ( type: esriFieldTypeInteger, alias: Crash Begin Node Id, editable: true, nullable: true, defaultValue: null, modelName: CRSH_XTMREF_NOD_ID )
• DSTNC_TOXTRNOD_NUM ( type: esriFieldTypeDouble, alias: Distance to Begin Node, editable: true, nullable: true, defaultValue: null, modelName: DSTNC_TOXTRNOD_NUM )
• CRSH_XTRREFNODB_ID ( type: esriFieldTypeInteger, alias: Crash End Node Id, editable: true, nullable: true, defaultValue: null, modelName: CRSH_XTRREFNODB_ID )
• DST_TOXTRMNODB_NUM ( type: esriFieldTypeDouble, alias: Distance to End Node, editable: true, nullable: true, defaultValue: null, modelName: DST_TOXTRMNODB_NUM )
• LATITUDE ( type: esriFieldTypeDouble, alias: ARBM Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: ARBM Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• X_COORDINATE ( type: esriFieldTypeDouble, alias: UTM Zone 17N X, editable: true, nullable: true, defaultValue: null, modelName: X_COORDINATE )
• Y_COORDINATE ( type: esriFieldTypeDouble, alias: UTM Zone 17N Y, editable: true, nullable: true, defaultValue: null, modelName: Y_COORDINATE )
• ARBM_ROADSIDE ( type: esriFieldTypeString, alias: ARBM Side of Road, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ARBM_ROADSIDE )
• GEO_URBAN_RURAL_IND ( type: esriFieldTypeString, alias: Urban Rural Indicator, editable: true, nullable: true, length: 1, defaultValue: null, modelName: GEO_URBAN_RURAL_IND )
• MAP_SOURCE ( type: esriFieldTypeString, alias: GIS Street Source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAP_SOURCE )
• EXTRACT_DATE ( type: esriFieldTypeDate, alias: Extract Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EXTRACT_DATE )
• ARBM_ROAD_STATUS ( type: esriFieldTypeString, alias: ARBM Road Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ARBM_ROAD_STATUS )

Templates:

• Name: Off System Commercial Vehicle Crashes
  Description:
  Prototype:
  EXTRACT_DATE: null
  ARBM_ROAD_STATUS: null
  XID:
  CALENDAR_YEAR: 0
  CRASH_NUMBER: null
  CASE_NUMBER: null
  INVSTGT_AGCY_CD: null
  AGENCY_TYPE_TXT: null
  DOT_GEOG_DIST_CD: null
  DOT_CNTY_CD: null
  COUNTY_TXT: null
  CRASH_DATE: null
  CRASH_TIME: null
  DAYOWEEK: null
  WEEKDAY_TXT: null
  DHSMV_CTY_CD: null
  DHSCNTYCTY: null
  IN_TOWN_FLAG: null
  ON_ROADWAY_NAME: null
  INT_ROADWAY_NAME: null
  REFDISTANCE_MI: null
  REFDIRECT: null
  OFFICER_LATITUDE: null
  OFFICER_LONGITUDE: null
  SAFETYLAT: null
  SAFETYLON: null
  ROADWAYID: null
  LOCMP: null
  NEAREST_NODE_FROM_CRASH: null
  STATE_ROAD_NUMBER: null
  US_ROAD_NUMBER: null
  ACCSIDRD: null
  ACCLANE: null
  TRAVDIR: null
  CRRATECD: null
  DHSRDSYS: null
  JCT_CD: null
  FRST_HARM_LOC_CD: null
  INTCT_TYP_CD: null
  TYPESHLD: null
  SKID_NUMBER: null
  SKID_TEST_DATE: null
  FUNCLASS: null
  RCI_SURFACE_WIDTH_FT: null
  RCI_SHOULDER_TYPE_1: null
  RCI_SHOULDER_TYPE_1_TXT: null
  RCI_SHOULDER_WIDTH_1_FT: null
  RCI_SHOULDER_TYPE_2: null
  RCI_SHOULDER_TYPE_2_TXT: null
  RCI_SHOULDER_WIDTH_2_FT: null
  RCI_SHOULDER_TYPE_3: null
  RCI_SHOULDER_TYPE_3_TXT: null
  RCI_SHOULDER_WIDTH_3_FT: null
  RCI_MEDIAN_WIDTH_FT: null
  AVERAGE_DAILY_TRAFFIC: null
  AADT_SOURCE: null
  RCI_AVG_PERC_TRUCK_TRAFF: null
  RCI_HORIZ_CURVE_CD: null
  SPEED_LIMIT: null
  INJSEVER: null
  CARSTACD: null
  ALCINVCD: null
  SITELOCA: null
  LGHT_COND_CD: null
  EVNT_WTHR_COND_CD: null
  RD_SRFC_COND_CD: null
  RDWY_GRDE_CD: null
  RDWY_ALIGN_CD: null
  TRAF_WAY_CD: null
  V1_TRAF_WAY_CD: null
  V1_TRAF_WAY_CD_TXT: null
  V2_TRAF_WAY_CD: null
  V2_TRAF_WAY_CD_TXT: null
  V1TRAFCTL: null
  V1TRAFCTL_TXT: null
  V2TRAFCTL: null
  V2TRAFCTL_TXT: null
  TRAFFIC_CONTROL_MC: null
  CNTOFLANES: null
  ROADCOND1: null
  ROADCOND1_TXT: null
  ROADCOND2: null
  ROADCOND2_TXT: null
  ROADCOND3: null
  ROADCOND3_TXT: null
  ROAD_CONDITION_MC: null
  ENVIRNMT1: null
  ENVIRNMT1_TXT: null
  ENVIRNMT2: null
  ENVIRNMT2_TXT: null
  ENVIRNMT3: null
  ENVIRNMT3_TXT: null
  ENVIRONMENT_CONDITION_MC: null
  MOST_HARM_EVNT_CD: null
  IMPCT_TYP_CD: null
  VHCL_MOVE_CD: null
  D1_FRST_DR_ACTN_CD: null
  D1_FRST_DR_ACTN_CD_TXT: null
  D2_FRST_DR_ACTN_CD: null
  D2_FRST_DR_ACTN_CD_TXT: null
  DRIVER_ACTION_MC: null
  LOC_WTHN_ZONE_CD: null
  WRK_ZONE_TYP_CD: null
  WRK_PRSNT_CD: null
  LAW_ENFRC_PRSNT_CD: null
  SCHL_BUS_REL_CD: null
  NUMBER_OF_INJURED: null
  NUMBER_OF_KILLED: null
  NUMBER_OF_SERIOUS_INJURIES: null
  NUMBER_OF_PEDESTRIANS: null
  TOTAL_DRIVERS: null
  NUMBER_OF_BICYCLISTS: null
  NUMBER_OF_VEHICLES: null
  TOTAL_PERSONS: null
  WRONGWAY_IND: null
  WORKZONE_IND: null
  COMMERCIAL_VEHICLE_IND: null
  INTERSECTION_IND: null
  LANE_DEPARTURE_IND: null
  CRASH_CLASS_IND_MC: null
  SPEEDING_IND: null
  AGGRESSIVE_DRIVING_IND: null
  IMPAIRED_DRIVER_IND: null
  IMPAIRED_PEDESTRIAN_IND: null
  IMPAIRED_BICYCLIST_IND: null
  DISTRACTED_DRIVER_IND: null
  DRIVER_PEDEST_CONDIT_IND_MC: null
  SPEEDING_AGGRESSIVE_IND: null
  PEDESTRIAN_RELATED_IND: null
  BICYCLIST_RELATED_IND: null
  PEDESTRIAN_BICYCLIST_IND: null
  MOTORCYCLE_INVOLVED_IND: null
  NO_BELT_IND: null
  NO_BELT_AGE_1_4_IND: null
  NO_BELT_AGE_5_12_IND: null
  NO_BELT_AGE_13_17_IND: null
  AGE_TEEN_IND: null
  AGE_65_PLUS_IND: null
  AGE_65_69_IND: null
  AGE_70_74_IND: null
  AGE_75_79_IND: null
  AGE_80_PLUS_IND: null
  LINK_ID: null
  CRSH_REF_NODE_ID: null
  CRSH_XTMREF_NOD_ID: null
  DSTNC_TOXTRNOD_NUM: null
  CRSH_XTRREFNODB_ID: null
  DST_TOXTRMNODB_NUM: null
  LATITUDE: null
  LONGITUDE: null
  X_COORDINATE: null
  Y_COORDINATE: null
  ARBM_ROADSIDE: null
  GEO_URBAN_RURAL_IND: null
  MAP_SOURCE: null
  
  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 Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata