Name: POC Crash Master

Display Field: STATE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: POC_Crash_Master_XYTableToPoint

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: -79.6760116999999
YMin: 37.9858206000001
XMax: -74.9999999999999
YMax: 39.7209197830001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,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: false

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• STATE_CODE (type: esriFieldTypeString, alias: State Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• STATE_NAME (type: esriFieldTypeString, alias: State Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• REPORT_NO (type: esriFieldTypeString, alias: Report Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• REPORT_TYPE (type: esriFieldTypeString, alias: Crash Severity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ACCIDENT_DATE (type: esriFieldTypeString, alias: Accident Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ACCIDENT_TIME (type: esriFieldTypeInteger, alias: Accident Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TIME_CATEGORY (type: esriFieldTypeString, alias: Time Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VEHICLES_IN_ACCIDENT (type: esriFieldTypeInteger, alias: # Vehicles involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CMV_IN_ACCIDENT (type: esriFieldTypeInteger, alias: # CMVs involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FATALITIES (type: esriFieldTypeInteger, alias: # Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INJURIES (type: esriFieldTypeInteger, alias: # Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_CATEGORY (type: esriFieldTypeString, alias: Crash Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WEATHER_DESC (type: esriFieldTypeString, alias: Weather Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LIGHT_DESC (type: esriFieldTypeString, alias: Light Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• JUNCTION_DESC (type: esriFieldTypeString, alias: Road Junction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• COLLISION_TYPE_DESC (type: esriFieldTypeString, alias: Collision Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SURFACE_COND_DESC (type: esriFieldTypeString, alias: Surface Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LANE_DESC (type: esriFieldTypeString, alias: Lane Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROAD_DESC (type: esriFieldTypeString, alias: Road Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WORKZONE_FLAG (type: esriFieldTypeString, alias: Workzone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FIRST_HARMFUL_EVENT (type: esriFieldTypeString, alias: First Harmful Event, SQL Type: sqlTypeOther, length: 8000, 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)
• LIGHT_TRUCK (type: esriFieldTypeInteger, alias: # Light Trucks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIUM_TRUCK (type: esriFieldTypeInteger, alias: # Medium Trucks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEAVY_TRUCK (type: esriFieldTypeInteger, alias: # Heavy Trucks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT (type: esriFieldTypeInteger, alias: AADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT_COMBINATION (type: esriFieldTypeInteger, alias: AADT Combination, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT_SINGLE_UNIT (type: esriFieldTypeInteger, alias: AADT Single Unit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_SYSTEM (type: esriFieldTypeInteger, alias: F System, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUNCTIONAL_SYSTEM (type: esriFieldTypeString, alias: Functional System, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CRACKING_PERCENT (type: esriFieldTypeInteger, alias: Cracking Percent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• URBAN_CODE (type: esriFieldTypeInteger, alias: Urban Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• URBAN_RURAL (type: esriFieldTypeString, alias: Urban/Rural, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MediumTruckFlag (type: esriFieldTypeString, alias: Medium Truck Flag, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: POC Crash Master
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/27/2021 7:40:48 PM

Schema Last Edit Date: 5/27/2021 7:40:48 PM

Data Last Edit Date: 5/27/2021 7:40:48 PM

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