All Layers and Tables (CARS_With_SPFID

Layers:

Tables:

CARS_With_SPFID_Table (0)

Name:

Display Field:

Type:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (CARS_With_SPFID_Table)

Layers:

Tables:

CARS_With_SPFID_Table (0)