All Layers and Tables (SWCS_GF_0120

Layers:

Layer: SWCS_GF_0120_0725_upd (29)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[132,43,100,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:

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)
INCIDENT_ID (type: esriFieldTypeInteger, alias: Incident ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
INCIDENT_TYPE (type: esriFieldTypeString, alias: Event Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CRASH_INVOLVED (type: esriFieldTypeString, alias: Is Crash Involved?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ROUTE (type: esriFieldTypeString, alias: Interstate Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ROUTE_NAME (type: esriFieldTypeString, alias: SWCS Route Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
INCIDENT_MILE_MARKER (type: esriFieldTypeString, alias: SWCS Event Mile Marker, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
DIRECTION (type: esriFieldTypeString, alias: Travel Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
COUNTY (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TDOT_REGION (type: esriFieldTypeSmallInteger, alias: TDOT Region, SQL Type: sqlTypeOther, nullable: true, editable: true)
LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
INCIDENT_START_DATE_AND_TIME (type: esriFieldTypeDate, alias: SWCS Event Start Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
INCIDENT_END_DATE_AND_TIME (type: esriFieldTypeDate, alias: SWCS Event End Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
START_TIME (type: esriFieldTypeTimeOnly, alias: SWCS Event Start Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
DURATION (type: esriFieldTypeString, alias: SWCS Event Time Duration. Values are: hh:mm:ss, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
BLOCKAGE_DESCRIPTION (type: esriFieldTypeString, alias: Blocked Lane Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
EVENT_STATUS (type: esriFieldTypeString, alias: Event Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CREATED_BY (type: esriFieldTypeString, alias: SWCS HELP Operator Name or ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HELP_DATE (type: esriFieldTypeDate, alias: HELP On Scene Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LAW_ENFORCEMENT_DATE (type: esriFieldTypeDate, alias: Law Enforcement On Scene Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
FIRE_DATE (type: esriFieldTypeDate, alias: Fire On Scene Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
EMS_DATE (type: esriFieldTypeDate, alias: Emergency Medical Services On Scene Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TOW_INVOLVED (type: esriFieldTypeString, alias: Is Tow Involved?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TOW_DATE (type: esriFieldTypeDate, alias: Tow Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
RECEIVED_BY (type: esriFieldTypeString, alias: SWCS HELP Operator who Received Event, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CONFIRMED_BY (type: esriFieldTypeString, alias: SWCS HELP Operator who Confimed Event, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TOTAL_LANES (type: esriFieldTypeSmallInteger, alias: Total Roadway Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
LEFT_SHOULDER_CLOSED (type: esriFieldTypeString, alias: Is Left Shoulder Closed?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
RIGHT_SHOULDER_CLOSED (type: esriFieldTypeString, alias: Is Right Shoulder Closed?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
GORE_CLOSED (type: esriFieldTypeDate, alias: Gore Closed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
GORE_OPEN (type: esriFieldTypeDate, alias: Gore Opened Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TOTAL_DMS (type: esriFieldTypeInteger, alias: Total Dynamic Messaging Signs, SQL Type: sqlTypeOther, nullable: true, editable: true)
HAR (type: esriFieldTypeString, alias: Highway Advisory Radio, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
URBAN_RURAL (type: esriFieldTypeString, alias: Area Type, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LANE_BLOCKING_INCIDENT (type: esriFieldTypeString, alias: Is Lane Blocked?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CODE_3_RESPONSE (type: esriFieldTypeString, alias: Is Code 3 Response?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SECONDARY_CRASH_OCCURRED (type: esriFieldTypeString, alias: Is Secondary Crash Present?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LANES_REOPENED_MNT (type: esriFieldTypeSingle, alias: Lanes Reopened Minutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROADWAY_CLEARANCE_MNT_OLD (type: esriFieldTypeInteger, alias: Old Roadway Clearance Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROADWAY_CLEARANCE_MNT (type: esriFieldTypeInteger, alias: Roadway Clearance Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
TRAVEL_LANE_BLOCKING_INCIDENT (type: esriFieldTypeString, alias: Is Travel Lane Blocked?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TRAVEL_LANES_MAX_BLOCKED_COUNT (type: esriFieldTypeSmallInteger, alias: Blocked Travel Lanes Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
VEHICLE_TYPE_LIST (type: esriFieldTypeString, alias: Involved Vehicle(s) Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
INCIDENT_CLEARANCE_TIME (type: esriFieldTypeSingle, alias: Incident Clearance Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROADWAY_CLEARANCE_TIME (type: esriFieldTypeSingle, alias: Roadway Clearance Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
FULL_CLOSURE_MINUTES (type: esriFieldTypeSingle, alias: Full Roadway Closure Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
EVENT_CONFIRMATION_DATE (type: esriFieldTypeDate, alias: SWCS Event Confirmed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
THP_INDCIDENTNO (type: esriFieldTypeString, alias: THP Incident Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
INVOLVED_VEHICLE_DETAILS (type: esriFieldTypeString, alias: Involved Vehicle(s) Details, SQL Type: sqlTypeOther, length: 999, nullable: true, editable: true)
NOTIFYING_CONTACT_NAME (type: esriFieldTypeString, alias: Notifying Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NOTIFYING_CONTACT_ORGANIZATION (type: esriFieldTypeString, alias: Notifying Contact Organization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WEATHER_CONDITIONS (type: esriFieldTypeString, alias: Weather Conditions at Time of Event, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
IS_ROLLOVER (type: esriFieldTypeString, alias: Is Vehicle(s) Rollover?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
IS_HAZMAT (type: esriFieldTypeString, alias: Is Hazmat Present?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
HAS_DMS (type: esriFieldTypeString, alias: Has Dynamic Message Sign?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
NUM_OF_DMS_MESSAGES (type: esriFieldTypeInteger, alias: DMS Messages Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
DMS_DURATION_MINUTES (type: esriFieldTypeSingle, alias: DMS Messages Duration in Minutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
EVENT_DURATION_MINUTES (type: esriFieldTypeSingle, alias: Event Duration in Minutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
FIRST_LANE_BLOCKED_DATE (type: esriFieldTypeDate, alias: First Lane Blocked Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
County2 (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Total_Minutes (type: esriFieldTypeDouble, alias: Total Event Minutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
Start_of_Month (type: esriFieldTypeDate, alias: SWCS Event Start Month, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Start_of_Quarter (type: esriFieldTypeDate, alias: SWCS Event Start Quarter, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Year (type: esriFieldTypeInteger, alias: SWCS Event Year , SQL Type: sqlTypeOther, nullable: true, editable: true)
TOW_ARRIVAL_TIME (type: esriFieldTypeString, alias: Tow Vehicle Arrival Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Total_Minutes_Tow_Arrival (type: esriFieldTypeDouble, alias: Tow Vehicle Arrival Minutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOW_ON_SCENE_TOTAL (type: esriFieldTypeString, alias: Tow On Scene Total Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Total_Minutes_Tow_on_scene (type: esriFieldTypeSingle, alias: Tow On Scene Total Minutes , SQL Type: sqlTypeOther, nullable: true, editable: true)
HELP_ON_SCENE (type: esriFieldTypeString, alias: SWCS HELP Operator On Scene, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CRASH_INVOLVED2 (type: esriFieldTypeString, alias: Is Crash Involved?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
HELP_ON_SCENE2 (type: esriFieldTypeString, alias: SWCS HELP Operator On Scene?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
StartofWeek (type: esriFieldTypeDateOnly, alias: Start of Week Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
StartofDay (type: esriFieldTypeDateOnly, alias: Start of Day Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
HELP_ON_SCENE3 (type: esriFieldTypeString, alias: Recoding of HELP On Scene 2, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
INCIDENT_ID2 (type: esriFieldTypeInteger, alias: Incident ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
SECONDARY_CRASH_OCCURRED2 (type: esriFieldTypeString, alias: Secondary Crash Occurred?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TEMP___HELP_Time (type: esriFieldTypeDouble, alias: Temporary HELP Minutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
Roadway_Type (type: esriFieldTypeString, alias: Roadway Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_Type (type: esriFieldTypeString, alias: Report Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Traffic_Event_ (type: esriFieldTypeString, alias: Is Traffic Event?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Relationship_Column (type: esriFieldTypeString, alias: Regional Relationship, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Fire_TF (type: esriFieldTypeString, alias: Is Fire Involved?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Hazmat_TF (type: esriFieldTypeString, alias: Is Hazmat Involved?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Rollover_TF (type: esriFieldTypeString, alias: Is Vehicle Rolled Over?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
StatewideID (type: esriFieldTypeString, alias: Statewide ID Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Join_Count (type: esriFieldTypeSmallInteger, alias: HELP Routes that Match Each SWCS HELP Point Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
TARGET_FID (type: esriFieldTypeInteger, alias: SWCS HELP Incident ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
region (type: esriFieldTypeSmallInteger, alias: Region Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
route_1 (type: esriFieldTypeSmallInteger, alias: Route Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
miles (type: esriFieldTypeDouble, alias: Length of HELP Route in Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
regionn (type: esriFieldTypeString, alias: Region Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mondayoperatinghours (type: esriFieldTypeString, alias: Monday Operating Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
tuesdayoperatinghours (type: esriFieldTypeString, alias: Tuesday Operating Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
wednesdayoperatinghours (type: esriFieldTypeString, alias: Wednesday Operating Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
thursdayoperatinghours (type: esriFieldTypeString, alias: Thursday Operating Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
fridayoperatinghours (type: esriFieldTypeString, alias: Friday Operating Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
saturdayoperatinghours (type: esriFieldTypeString, alias: Sunday Operating Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sundayoperatinghours (type: esriFieldTypeString, alias: Saturday Operating Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mondaytotalshifthours (type: esriFieldTypeString, alias: Monday Total Shift Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
tuesdaytotalshifthours (type: esriFieldTypeString, alias: Tuesday Total Shift Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
wednesdaytotalshifthours (type: esriFieldTypeString, alias: Wednesday Total Shift Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
thursdaytotalshifthours (type: esriFieldTypeString, alias: Thursday Total Shift Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
fridaytotalshifthours (type: esriFieldTypeString, alias: Friday Total Shift Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
saturdaytotalshifthours (type: esriFieldTypeString, alias: Saturday Total Shift Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sundaytotalshifthours (type: esriFieldTypeString, alias: Sunday Total Shift Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
numberofoperators (type: esriFieldTypeSmallInteger, alias: Number of HELP Operators, SQL Type: sqlTypeOther, nullable: true, editable: true)
routedescription (type: esriFieldTypeString, alias: HELP Route Description, SQL Type: sqlTypeOther, length: 999, nullable: true, editable: true)
statewiderouteid (type: esriFieldTypeString, alias: Statewide Route ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AreaName (type: esriFieldTypeString, alias: HELP Coverage Area Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
IncidentClearanceTime (type: esriFieldTypeDouble, alias: Incident Clearance Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
RoadwayClearanceDuration (type: esriFieldTypeDouble, alias: Roadway Clearance Duration, SQL Type: sqlTypeOther, nullable: true, editable: true)
LaneReopenedDuration (type: esriFieldTypeDouble, alias: Lane Reopened Duration, SQL Type: sqlTypeOther, nullable: true, editable: true)
RoadwayClearanceTime (type: esriFieldTypeDouble, alias: Roadway Clearance Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
HELPCoverageAreaYN (type: esriFieldTypeSmallInteger, alias: HELP Coverage Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
INCIDENT_DATE (type: esriFieldTypeDateOnly, alias: Incident Date Only, SQL Type: sqlTypeOther, nullable: true, editable: true)
INCIDENT_DATE_ONLY (type: esriFieldTypeDate, alias: Incident Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

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 (SWCS_GF_0120_0725)

Layers:

Layer: SWCS_GF_0120_0725_upd (29)