View In:   ArcGIS Online Map Viewer

Parent Layer: Crashes

Name: Crashes (2015)

Display Field: XID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 414f3a886c574487b60bc93d2de5216e

Copyright Text:

Default Visibility: false

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3500000

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 , Coded Values: [3: 3 CITY POLICE DEPARTMENT] , [2: 2 COUNTY SHERIFF'S OFFICE] , [1: 1 FLORIDA HIGHWAY PATROL] , ...2 more... )
• 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 , Coded Values: [01: 01 FIRST] , [02: 02 SECOND] , [03: 03 THIRD] , ...5 more... )
• DOT_CNTY_CD ( type: esriFieldTypeString, alias: FDOT County Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: DOT_CNTY_CD , Coded Values: [26: 26 ALACHUA] , [27: 27 BAKER] , [46: 46 BAY] , ...66 more... )
• 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 , Coded Values: [01: 01 MONDAY] , [02: 02 TUESDAY] , [03: 03 WEDNESDAY] , ...4 more... )
• WEEKDAY_TXT ( type: esriFieldTypeString, alias: Day, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WEEKDAY_TXT )
• DHSMV_CTY_CD ( type: esriFieldTypeString, alias: DHSMV City, editable: true, nullable: true, length: 4, defaultValue: null, modelName: DHSMV_CTY_CD , Coded Values: [2630: 2630 ALACHUA] , [5328: 5328 ALFORD] , [7730: 7730 ALTAMONTE SPRINGS] , ...689 more... )
• 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 , Coded Values: [E: E END OF ST RD] , [I: I INTERSECTION] , [L: L LEFT] , ...6 more... )
• ACCLANE ( type: esriFieldTypeString, alias: Accident Lane Number, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ACCLANE , Coded Values: [A: A ACCEL/MERGE] , [V: V BIKE LANE] , [T: T CONTIN. TURN] , ...23 more... )
• TRAVDIR ( type: esriFieldTypeString, alias: Travel Direction Vehicle 1, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TRAVDIR , Coded Values: [E: E EAST] , [N: N NORTH] , [O: O OFF-ROAD] , ...3 more... )
• CRRATECD ( type: esriFieldTypeString, alias: FDOT Road Category, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CRRATECD , Coded Values: [02: 02 INTERSTATE RURAL] , [01: 01 INTERSTATE URBAN] , [08: 08 RAMP RURAL] , ...36 more... )
• DHSRDSYS ( type: esriFieldTypeString, alias: DHSMV Road System Id, editable: true, nullable: true, length: 2, defaultValue: null, modelName: DHSRDSYS , Coded Values: [77: 77 ALL OTHER] , [04: 04 COUNTY] , [07: 07 FOREST ROAD] , ...8 more... )
• JCT_CD ( type: esriFieldTypeString, alias: Relation to Junction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: JCT_CD , Coded Values: [17: 17 ACCELERATION/DECELERATION LANE] , [15: 15 CROSSOVER-RELATED] , [04: 04 DRIVEWAY/ALLEY ACCESS RELATED] , ...10 more... )
• FRST_HARM_LOC_CD ( type: esriFieldTypeString, alias: Crash Harmful Event Location, editable: true, nullable: true, length: 2, defaultValue: null, modelName: FRST_HARM_LOC_CD , Coded Values: [06: 06 GORE] , [08: 08 IN PARKING LANE OR ZONE] , [04: 04 MEDIAN] , ...8 more... )
• INTCT_TYP_CD ( type: esriFieldTypeString, alias: Intersection Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: INTCT_TYP_CD , Coded Values: [07: 07 FIVE-POINT, OR MORE] , [02: 02 FOUR-WAY INTERSECTION] , [01: 01 NOT AT INTERSECTION] , ...6 more... )
• TYPESHLD ( type: esriFieldTypeString, alias: Shoulder Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: TYPESHLD , Coded Values: [03: 03 CURB] , [00: 00 N/A] , [01: 01 PAVED] , ...2 more... )
• 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 , Coded Values: [09: 09 RURAL LOCAL] , [07: 07 RURAL MAJOR COLLECTOR] , [06: 06 RURAL MINOR ART] , ...11 more... )
• 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 , Coded Values: [08: 08 CURB W RESF] , [06: 06 CURB&GUTTER] , [04: 04 GRAVEL/MARL] , ...7 more... )
• 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 , Coded Values: [08: 08 CURB W RESF] , [06: 06 CURB&GUTTER] , [04: 04 GRAVEL/MARL] , ...7 more... )
• 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 , Coded Values: [08: 08 CURB W RESF] , [06: 06 CURB&GUTTER] , [04: 04 GRAVEL/MARL] , ...7 more... )
• 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: esriFieldTypeDouble, 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 , Coded Values: [5: 5 FATAL(WITHIN 30 DAYS) INJURY] , [4: 4 INCAPACITATING INJURY] , [1: 1 NO INJURY] , ...4 more... )
• CARSTACD ( type: esriFieldTypeString, alias: CAR Status Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CARSTACD , Coded Values: [12: 12 BATCH - ON SR BUT NOT LOCATED] , [16: 16 BATCH DET OFF-SYS - SITE LOC] , [17: 17 BATCH DET OFF-SYS -ALIAS MATCH] , ...23 more... )
• ALCINVCD ( type: esriFieldTypeString, alias: Alcohols/Drug Involved, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ALCINVCD , Coded Values: [3: 3 A/D] , [1: 1 ALC] , [2: 2 DRG] , ...2 more... )
• SITELOCA ( type: esriFieldTypeString, alias: Site Location, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SITELOCA , Coded Values: [77: 77 ALL OTHER] , [02: 02 AT INTERSECTION] , [06: 06 BRIDGE] , ...11 more... )
• LGHT_COND_CD ( type: esriFieldTypeString, alias: Lighting, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LGHT_COND_CD , Coded Values: [04: 04 DARK-LIGHTED] , [05: 05 DARK-NOT LIGHTED] , [06: 06 DARK-UNKNOWN LIGHTING] , ...6 more... )
• EVNT_WTHR_COND_CD ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 2, defaultValue: null, modelName: EVNT_WTHR_COND_CD , Coded Values: [06: 06 BLOWING SAND, SOIL, DIRT] , [01: 01 CLEAR] , [02: 02 CLOUDY] , ...6 more... )
• RD_SRFC_COND_CD ( type: esriFieldTypeString, alias: Road Surface, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RD_SRFC_COND_CD , Coded Values: [01: 01 DRY] , [04: 04 ICE/FROST] , [06: 06 MUD, DIRT, GRAVEL] , ...7 more... )
• RDWY_GRDE_CD ( type: esriFieldTypeString, alias: Roadway Grade, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RDWY_GRDE_CD , Coded Values: [04: 04 DOWNHILL] , [02: 02 HILLCREST] , [01: 01 LEVEL] , ...3 more... )
• RDWY_ALIGN_CD ( type: esriFieldTypeString, alias: Roadway Alignment, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RDWY_ALIGN_CD , Coded Values: [3: 3 CURVE LEFT] , [2: 2 CURVE RIGHT] , [0: 0 NOT CODED] , ...1 more... )
• TRAF_WAY_CD ( type: esriFieldTypeString, alias: Traffic Way, editable: true, nullable: true, length: 2, defaultValue: null, modelName: TRAF_WAY_CD , Coded Values: [00: 00 NOT CODED] , [05: 05 ONE-WAY TRAFFICWAY] , [04: 04 TWO-WAY, DIVIDED, POSITIVE MED] , ...4 more... )
• 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 , Coded Values: [00: 00 NOT CODED] , [05: 05 ONE-WAY TRAFFICWAY] , [04: 04 TWO-WAY, DIVIDED, POSITIVE MED] , ...4 more... )
• 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 , Coded Values: [00: 00 NOT CODED] , [05: 05 ONE-WAY TRAFFICWAY] , [04: 04 TWO-WAY, DIVIDED, POSITIVE MED] , ...4 more... )
• 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 , Coded Values: [08: 08 FLASHING SIGNAL] , [01: 01 NO CONTROLS] , [00: 00 NOT CODED] , ...9 more... )
• 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 , Coded Values: [08: 08 FLASHING SIGNAL] , [01: 01 NO CONTROLS] , [00: 00 NOT CODED] , ...9 more... )
• 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 , Coded Values: [12: 12 DEBRIS] , [14: 14 NON-HIGHWAY WORK] , [01: 01 NONE] , ...10 more... )
• 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 , Coded Values: [12: 12 DEBRIS] , [14: 14 NON-HIGHWAY WORK] , [01: 01 NONE] , ...10 more... )
• 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 , Coded Values: [12: 12 DEBRIS] , [14: 14 NON-HIGHWAY WORK] , [01: 01 NONE] , ...10 more... )
• 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 , Coded Values: [77: 77 ALL OTHER (SEE NARRTIVE)] , [05: 05 ANIMAL(S) IN ROADWAY] , [04: 04 GLARE] , ...5 more... )
• 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 , Coded Values: [77: 77 ALL OTHER (SEE NARRTIVE)] , [05: 05 ANIMAL(S) IN ROADWAY] , [04: 04 GLARE] , ...5 more... )
• 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 , Coded Values: [77: 77 ALL OTHER (SEE NARRTIVE)] , [05: 05 ANIMAL(S) IN ROADWAY] , [04: 04 GLARE] , ...5 more... )
• 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 , Coded Values: [13: 13 ANIMAL] , [20: 20 BRIDGE OVERHEAD STRUCTURE] , [21: 21 BRIDGE PIER OR SUPPORT] , ...37 more... )
• IMPCT_TYP_CD ( type: esriFieldTypeString, alias: Manner of Collision, editable: true, nullable: true, length: 2, defaultValue: null, modelName: IMPCT_TYP_CD , Coded Values: [03: 03 ANGLE] , [02: 02 FRONT TO FRONT] , [01: 01 FRONT TO REAR] , ...7 more... )
• VHCL_MOVE_CD ( type: esriFieldTypeString, alias: Vehicle Movement, editable: true, nullable: true, length: 2, defaultValue: null, modelName: VHCL_MOVE_CD , Coded Values: [04: 04 BACKING] , [06: 06 CHANGING LANES] , [17: 17 ENTERING TRAFFIC LANE] , ...13 more... )
• 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 , Coded Values: [28: 28 DISREGARDED OTHER ROAD MARKING] , [27: 27 DISREGARDED OTHER TRAFFIC SIGN] , [12: 12 DROVE TOO FAST FOR CONDITIONS] , ...18 more... )
• 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 , Coded Values: [28: 28 DISREGARDED OTHER ROAD MARKING] , [27: 27 DISREGARDED OTHER TRAFFIC SIGN] , [12: 12 DROVE TOO FAST FOR CONDITIONS] , ...18 more... )
• 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 , Coded Values: [04: 04 ACTIVITY AREA] , [02: 02 ADVANCE WARNING AREA] , [01: 01 BEFORE THE FIRST WARNING SIGN] , ...3 more... )
• WRK_ZONE_TYP_CD ( type: esriFieldTypeString, alias: Type of Workzone, editable: true, nullable: true, length: 2, defaultValue: null, modelName: WRK_ZONE_TYP_CD , Coded Values: [04: 04 INTERMITTENT OR MOVING WORK] , [01: 01 LANE CLOSURE] , [02: 02 LANE SHIFT/CROSSOVER] , ...3 more... )
• WRK_PRSNT_CD ( type: esriFieldTypeString, alias: Workers Present in Workzone, editable: true, nullable: true, length: 2, defaultValue: null, modelName: WRK_PRSNT_CD , Coded Values: [01: 01 NO] , [00: 00 NOT CODED] , [88: 88 UNKNOWN] , ...1 more... )
• 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 , Coded Values: [03: 03 LAW ENFORCEMENT VEHICLE ONLY] , [01: 01 NO] , [00: 00 NOT CODED] , ...1 more... )
• SCHL_BUS_REL_CD ( type: esriFieldTypeString, alias: School Bus Related, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SCHL_BUS_REL_CD , Coded Values: [01: 01 NO] , [00: 00 NOT CODED] , [02: 02 YES, SCHOOL BUS DIRECTLY INVOL] , ...1 more... )
• 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: esriFieldTypeDouble, 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: esriFieldTypeDouble, alias: Navteq Link Id, editable: true, nullable: true, defaultValue: null, modelName: LINK_ID )
• CRSH_REF_NODE_ID ( type: esriFieldTypeDouble, alias: Crash Reference Node Id, editable: true, nullable: true, defaultValue: null, modelName: CRSH_REF_NODE_ID )
• CRSH_XTMREF_NOD_ID ( type: esriFieldTypeDouble, 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: esriFieldTypeDouble, 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: Crashes (2015)
  Description:
  Prototype:
  EXTRACT_DATE: 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
  ARBM_ROAD_STATUS: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

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