Name: Crash
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:
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_DAY (type: esriFieldTypeString, alias: Accident Day, 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)
- TIME_BREAKDOWN (type: esriFieldTypeString, alias: Time Breakdown, 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)
- CRASH_TYPE (type: esriFieldTypeString, alias: Crash Type, 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: Road 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: Work Zone, 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 Truck, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MEDIUM_TRUCK (type: esriFieldTypeInteger, alias: # Medium Truck, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HEAVY_TRUCK (type: esriFieldTypeInteger, alias: # Heavy Truck, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MEDIUM_TRUCK_FLAG (type: esriFieldTypeString, alias: Medium Truck Flag?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- DRIVER_LICENSE_CATEGORY (type: esriFieldTypeString, alias: Driver License Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- DRIVER_LICENSE_CLASS (type: esriFieldTypeString, alias: Driver License Class, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- DRIVER_DOB (type: esriFieldTypeString, alias: Driver DOB, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- DRIVER_AGE (type: esriFieldTypeInteger, alias: Driver Age, 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)
- SEQ_ID (type: esriFieldTypeInteger, alias: Vehicle Sequence ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- aadt_scaled (type: esriFieldTypeDouble, alias: aadt_scaled, SQL Type: sqlTypeOther, nullable: true, editable: true)
- crash_rate (type: esriFieldTypeDouble, alias: crash_rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DOW_ORDER (type: esriFieldTypeInteger, alias: DOW_ORDER, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOD_ORDER (type: esriFieldTypeInteger, alias: TOD_ORDER, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Error_Type_ID (type: esriFieldTypeInteger, alias: Error Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AADT_GRP_NAME (type: esriFieldTypeString, alias: AADT_GRP_NAME, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- AADT_GRP_ORDER (type: esriFieldTypeInteger, alias: AADT_GRP_ORDER, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CRASH_CATEGORY_ORDER (type: esriFieldTypeInteger, alias: CRASH_CATEGORY_ORDER, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Crash
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/8/2021 4:37:16 PM
Schema Last Edit Date: 10/8/2021 4:37:16 PM
Data Last Edit Date: 10/8/2021 4:37:16 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat