Name: CARS_With_SPFID_3857

Display Field: ON_ROADWAY_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: -161064.597366411
YMin: 2715218.68046087
XMax: 597821.298247341
YMax: 3447708.07861459
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[150,73,122,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: true

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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• XID (type: esriFieldTypeString, alias: Crash Id, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• CALENDAR_YEAR (type: esriFieldTypeSmallInteger, alias: Calendar Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_NUMBER (type: esriFieldTypeString, alias: FDOT Crash Number, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• CASE_NUMBER (type: esriFieldTypeString, alias: Reporting Agency Case Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INVSTGT_AGCY_CD (type: esriFieldTypeString, alias: Reporting Agency Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• DOT_GEOG_DIST_CD (type: esriFieldTypeString, alias: FDOT Managing District, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [01: 01 FIRST], [02: 02 SECOND], [03: 03 THIRD], ... 5 more ...)
• DOT_CNTY_CD (type: esriFieldTypeString, alias: FDOT County Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [26: 26 ALACHUA], [27: 27 BAKER], [46: 46 BAY], ... 66 more ...)
• COUNTY_TXT (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CRASH_DATE (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CRASH_TIME (type: esriFieldTypeString, alias: Crash Time, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• DAYOWEEK (type: esriFieldTypeString, alias: Week Day Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [01: 01 MONDAY], [02: 02 TUESDAY], [03: 03 WEDNESDAY], ... 4 more ...)
• WEEKDAY_TXT (type: esriFieldTypeString, alias: Day, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DHSMV_CTY_CD (type: esriFieldTypeString, alias: DHSMV City, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [2630: 2630 ALACHUA], [5328: 5328 ALFORD], [7730: 7730 ALTAMONTE SPRINGS], ... 689 more ...)
• DHSCNTYCTY (type: esriFieldTypeString, alias: Crash Report City Code, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• IN_TOWN_FLAG (type: esriFieldTypeString, alias: In Town, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ON_ROADWAY_NAME (type: esriFieldTypeString, alias: On Roadway Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INT_ROADWAY_NAME (type: esriFieldTypeString, alias: Int Roadway Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• REFDISTANCE_MI (type: esriFieldTypeDouble, alias: Reference Distance (Miles), SQL Type: sqlTypeOther, nullable: true, editable: true)
• REFDIRECT (type: esriFieldTypeString, alias: Reference Direction, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• OFFICER_LATITUDE (type: esriFieldTypeDouble, alias: Officer Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OFFICER_LONGITUDE (type: esriFieldTypeDouble, alias: Officer Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAFETYLAT (type: esriFieldTypeDouble, alias: FDOT Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAFETYLON (type: esriFieldTypeDouble, alias: FDOT Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROADWAYID (type: esriFieldTypeString, alias: FDOT Roadway, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LOCMP (type: esriFieldTypeDouble, alias: Nearest Inventory MP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NEAREST_NODE_FROM_CRASH (type: esriFieldTypeString, alias: Nearest Node From Crash, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STATE_ROAD_NUMBER (type: esriFieldTypeString, alias: State Road #, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• US_ROAD_NUMBER (type: esriFieldTypeString, alias: US Highway, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ACCSIDRD (type: esriFieldTypeString, alias: Crash Side of Road, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [E: E END OF ST RD], [I: I INTERSECTION], [L: L LEFT], ... 6 more ...)
• ACCLANE (type: esriFieldTypeString, alias: Accident Lane Number, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: A ACCEL/MERGE], [V: V BIKE LANE], [T: T CONTIN. TURN], ... 23 more ...)
• TRAVDIR (type: esriFieldTypeString, alias: Travel Direction Vehicle 1, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [E: E EAST], [N: N NORTH], [O: O OFF-ROAD], ... 3 more ...)
• CRRATECD (type: esriFieldTypeString, alias: FDOT Road Category, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [02: 02 INTERSTATE RURAL], [01: 01 INTERSTATE URBAN], [08: 08 RAMP RURAL], ... 36 more ...)
• DHSRDSYS (type: esriFieldTypeString, alias: DHSMV Road System Id, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [77: 77 ALL OTHER], [04: 04 COUNTY], [07: 07 FOREST ROAD], ... 8 more ...)
• JCT_CD (type: esriFieldTypeString, alias: Relation to Junction, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [03: 03 CURB], [00: 00 N/A], [01: 01 PAVED], ... 2 more ...)
• SKID_NUMBER (type: esriFieldTypeSmallInteger, alias: FDOT Roadway SKID Test Result, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SKID_TEST_DATE (type: esriFieldTypeDate, alias: FDOT Roadway SKID Test Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FUNCLASS (type: esriFieldTypeString, alias: Functional Class, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RCI_SHOULDER_TYPE_1 (type: esriFieldTypeString, alias: RCI Shoulder Type First Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• RCI_SHOULDER_WIDTH_1_FT (type: esriFieldTypeDouble, alias: RCI Shoulder Width First, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RCI_SHOULDER_TYPE_2 (type: esriFieldTypeString, alias: RCI Shoulder Type Second Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• RCI_SHOULDER_WIDTH_2_FT (type: esriFieldTypeDouble, alias: RCI Shoulder Width Second, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RCI_SHOULDER_TYPE_3 (type: esriFieldTypeString, alias: RCI Shoulder Type Third Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• RCI_SHOULDER_WIDTH_3_FT (type: esriFieldTypeDouble, alias: RCI Shoulder Width Third, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RCI_MEDIAN_WIDTH_FT (type: esriFieldTypeDouble, alias: RCI Median Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVERAGE_DAILY_TRAFFIC (type: esriFieldTypeDouble, alias: Avg Daily Traffic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT_SOURCE (type: esriFieldTypeString, alias: AADT Source, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• RCI_AVG_PERC_TRUCK_TRAFF (type: esriFieldTypeDouble, alias: RCI Avg Per Truck Traffic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RCI_HORIZ_CURVE_CD (type: esriFieldTypeString, alias: RCI Horiz Curve Condition, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• SPEED_LIMIT (type: esriFieldTypeSmallInteger, alias: Posted Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INJSEVER (type: esriFieldTypeString, alias: Highest Injury in Crash, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [3: 3 A/D], [1: 1 ALC], [2: 2 DRG], ... 2 more ...)
• SITELOCA (type: esriFieldTypeString, alias: Site Location, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [77: 77 ALL OTHER], [02: 02 AT INTERSECTION], [06: 06 BRIDGE], ... 11 more ...)
• LGHT_COND_CD (type: esriFieldTypeString, alias: Lighting, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [01: 01 DRY], [04: 04 ICE/FROST], [06: 06 MUD, DIRT, GRAVEL], ... 7 more ...)
• RDWY_GRDE_CD (type: esriFieldTypeString, alias: Roadway Grade, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [04: 04 DOWNHILL], [02: 02 HILLCREST], [01: 01 LEVEL], ... 3 more ...)
• RDWY_ALIGN_CD (type: esriFieldTypeString, alias: Roadway Alignment, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [3: 3 CURVE LEFT], [2: 2 CURVE RIGHT], [0: 0 NOT CODED], ... 1 more ...)
• TRAF_WAY_CD (type: esriFieldTypeString, alias: Traffic Way, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• V2_TRAF_WAY_CD (type: esriFieldTypeString, alias: Traffic Way Vehicle 2 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• V1TRAFCTL (type: esriFieldTypeString, alias: Traffic Control Vehicle 1 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• V2TRAFCTL (type: esriFieldTypeString, alias: Traffic Control Vehicle 2 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• TRAFFIC_CONTROL_MC (type: esriFieldTypeString, alias: Traffic Control, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• CNTOFLANES (type: esriFieldTypeSmallInteger, alias: Count of Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROADCOND1 (type: esriFieldTypeString, alias: Road Condition 1 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [12: 12 DEBRIS], [14: 14 NON-HIGHWAY WORK], [01: 01 NONE], ... 10 more ...)
• ROADCOND1_TXT (type: esriFieldTypeString, alias: Road Condition 1, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ROADCOND2 (type: esriFieldTypeString, alias: Road Condition 2 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [12: 12 DEBRIS], [14: 14 NON-HIGHWAY WORK], [01: 01 NONE], ... 10 more ...)
• ROADCOND2_TXT (type: esriFieldTypeString, alias: Road Condition 2, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ROADCOND3 (type: esriFieldTypeString, alias: Road Condition 3 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [12: 12 DEBRIS], [14: 14 NON-HIGHWAY WORK], [01: 01 NONE], ... 10 more ...)
• ROADCOND3_TXT (type: esriFieldTypeString, alias: Road Condition 3, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ROAD_CONDITION_MC (type: esriFieldTypeString, alias: Road Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ENVIRNMT1 (type: esriFieldTypeString, alias: Environment Condition 1 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ENVIRNMT2 (type: esriFieldTypeString, alias: Environment Condition 2 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ENVIRNMT3 (type: esriFieldTypeString, alias: Environment Condition 3 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ENVIRONMENT_CONDITION_MC (type: esriFieldTypeString, alias: Environment Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MOST_HARM_EVNT_CD (type: esriFieldTypeString, alias: Crash Harmful Event, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• D2_FRST_DR_ACTN_CD (type: esriFieldTypeString, alias: Driver Action Vehicle 2 Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• DRIVER_ACTION_MC (type: esriFieldTypeString, alias: Driver Action, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• LOC_WTHN_ZONE_CD (type: esriFieldTypeString, alias: Location Within Workzone, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMBER_OF_KILLED (type: esriFieldTypeSmallInteger, alias: Count of Traffic Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMBER_OF_SERIOUS_INJURIES (type: esriFieldTypeSmallInteger, alias: Count of Serious Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMBER_OF_PEDESTRIANS (type: esriFieldTypeSmallInteger, alias: Count of Pedestrians, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_DRIVERS (type: esriFieldTypeSmallInteger, alias: Count of Drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMBER_OF_BICYCLISTS (type: esriFieldTypeSmallInteger, alias: Count of Bicyclists, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMBER_OF_VEHICLES (type: esriFieldTypeSmallInteger, alias: Count of Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_PERSONS (type: esriFieldTypeDouble, alias: Count of Persons, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WRONGWAY_IND (type: esriFieldTypeString, alias: Wrong Way, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• WORKZONE_IND (type: esriFieldTypeString, alias: Workzone Inv, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• COMMERCIAL_VEHICLE_IND (type: esriFieldTypeString, alias: Commercial Vehicle Inv, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• INTERSECTION_IND (type: esriFieldTypeString, alias: Intersection Inv, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DEPARTURE_IND (type: esriFieldTypeString, alias: Lane Departure, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CRASH_CLASS_IND_MC (type: esriFieldTypeString, alias: Crash Category, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SPEEDING_IND (type: esriFieldTypeString, alias: Speeding, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AGGRESSIVE_DRIVING_IND (type: esriFieldTypeString, alias: Agressive Driving, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• IMPAIRED_DRIVER_IND (type: esriFieldTypeString, alias: Impaired Driver, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• IMPAIRED_PEDESTRIAN_IND (type: esriFieldTypeString, alias: Impaired Pedestrian, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• IMPAIRED_BICYCLIST_IND (type: esriFieldTypeString, alias: Impaired Bicyclist, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DISTRACTED_DRIVER_IND (type: esriFieldTypeString, alias: Distracted Driver, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DRIVER_PEDEST_CONDIT_IND_MC (type: esriFieldTypeString, alias: Driver Behavior, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SPEEDING_AGGRESSIVE_IND (type: esriFieldTypeString, alias: Speeding or Aggressive Driving, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PEDESTRIAN_RELATED_IND (type: esriFieldTypeString, alias: Pedestrian Related, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• BICYCLIST_RELATED_IND (type: esriFieldTypeString, alias: Bicyclist Related, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PEDESTRIAN_BICYCLIST_IND (type: esriFieldTypeString, alias: Pedestrian or Bicyclist Related, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MOTORCYCLE_INVOLVED_IND (type: esriFieldTypeString, alias: Motorcycle Inv, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• NO_BELT_IND (type: esriFieldTypeString, alias: No Belt, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• NO_BELT_AGE_1_4_IND (type: esriFieldTypeString, alias: No Belt - Ages 1-4, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• NO_BELT_AGE_5_12_IND (type: esriFieldTypeString, alias: No Belt - Ages 5-12, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• NO_BELT_AGE_13_17_IND (type: esriFieldTypeString, alias: No Belt - Ages 13-17, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AGE_TEEN_IND (type: esriFieldTypeString, alias: Driver - Ages Teen, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AGE_65_PLUS_IND (type: esriFieldTypeString, alias: Driver - Ages 65 plus, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AGE_65_69_IND (type: esriFieldTypeString, alias: Driver - Ages 65-69, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AGE_70_74_IND (type: esriFieldTypeString, alias: Driver - Ages 70-74, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AGE_75_79_IND (type: esriFieldTypeString, alias: Driver - Ages 75-79, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AGE_80_PLUS_IND (type: esriFieldTypeString, alias: Driver - Ages 80 plus, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LINK_ID (type: esriFieldTypeDouble, alias: Navteq Link Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRSH_REF_NODE_ID (type: esriFieldTypeDouble, alias: Crash Reference Node Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRSH_XTMREF_NOD_ID (type: esriFieldTypeDouble, alias: Crash Begin Node Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DSTNC_TOXTRNOD_NUM (type: esriFieldTypeDouble, alias: Distance to Begin Node, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRSH_XTRREFNODB_ID (type: esriFieldTypeDouble, alias: Crash End Node Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DST_TOXTRMNODB_NUM (type: esriFieldTypeDouble, alias: Distance to End Node, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: ARBM Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: ARBM Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X_COORDINATE (type: esriFieldTypeDouble, alias: UTM Zone 17N X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORDINATE (type: esriFieldTypeDouble, alias: UTM Zone 17N Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ARBM_ROADSIDE (type: esriFieldTypeString, alias: ARBM Side of Road, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• GEO_URBAN_RURAL_IND (type: esriFieldTypeString, alias: Urban Rural Indicator, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MAP_SOURCE (type: esriFieldTypeString, alias: GIS Street Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• EXTRACT_DATE (type: esriFieldTypeDate, alias: Extract Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ARBM_ROAD_STATUS (type: esriFieldTypeString, alias: ARBM Road Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SPFID (type: esriFieldTypeInteger, alias: SPFID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: CARS_With_SPFID_3857
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• CARS_to_SPF (0) -- Related To: SPF_Network_v6 (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/14/2023 9:19:02 AM

Schema Last Edit Date: 2/14/2023 9:19:02 AM

Data Last Edit Date: 11/30/2021 6:22:05 PM

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