Name: traffic_accidents_after_2005_new_addresses_1

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Time_Notified (type: esriFieldTypeInteger, alias: Time Notified, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Accident_Rec__ (type: esriFieldTypeInteger, alias: Accident Rec #, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Local_Case__ (type: esriFieldTypeString, alias: Local Case #, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Time_Occurred (type: esriFieldTypeDate, alias: Time Occurred, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Occurred_Day (type: esriFieldTypeString, alias: Occurred Day, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Notified_Day (type: esriFieldTypeString, alias: Notified Day, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Time_Arrived (type: esriFieldTypeDate, alias: Time Arrived, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Arrived_Day (type: esriFieldTypeString, alias: Arrived Day, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• City (type: esriFieldTypeSingle, alias: City, SQL Type: sqlTypeReal, nullable: true, editable: true)
• City_Text (type: esriFieldTypeString, alias: City Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Street_Prefix (type: esriFieldTypeString, alias: On Street Prefix, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Severity (type: esriFieldTypeSingle, alias: Severity, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Severity_Text (type: esriFieldTypeString, alias: Severity Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Accident_Loc_ (type: esriFieldTypeSingle, alias: Accident Loc., SQL Type: sqlTypeReal, nullable: true, editable: true)
• Accident_Loc__Text (type: esriFieldTypeString, alias: Accident Loc. Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Dist_Units (type: esriFieldTypeSingle, alias: Dist Units, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Hit_and_Run (type: esriFieldTypeString, alias: Hit and Run, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Direction (type: esriFieldTypeSingle, alias: Direction, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Property_Damage (type: esriFieldTypeString, alias: Property Damage, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• From_Street_Prefix (type: esriFieldTypeString, alias: From Street Prefix, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Construct__Zone (type: esriFieldTypeString, alias: Construct. Zone, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Milepost (type: esriFieldTypeSingle, alias: Milepost, SQL Type: sqlTypeReal, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Street (type: esriFieldTypeString, alias: On Street, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Street_Name (type: esriFieldTypeString, alias: On Street Name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Street_Type (type: esriFieldTypeString, alias: On Street Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Street_Sfx_ (type: esriFieldTypeString, alias: On Street Sfx., SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Street_Speed_Lmt_ (type: esriFieldTypeSingle, alias: On Street Speed Lmt., SQL Type: sqlTypeReal, nullable: true, editable: true)
• Photos_By (type: esriFieldTypeInteger, alias: Photos By, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Reviewed_By (type: esriFieldTypeString, alias: Reviewed By, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Distance (type: esriFieldTypeSingle, alias: Distance, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Dist_Units_Text (type: esriFieldTypeString, alias: Dist Units Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Direction_Text (type: esriFieldTypeString, alias: Direction Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• At_Cross_Str (type: esriFieldTypeString, alias: At/Cross Str, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• At_Street_Name (type: esriFieldTypeString, alias: At Street Name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• At_Street_Type (type: esriFieldTypeString, alias: At Street Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• At_Street_Sfx_ (type: esriFieldTypeString, alias: At Street Sfx., SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• At_Street_Speed_Lmt_ (type: esriFieldTypeSingle, alias: At Street Speed Lmt., SQL Type: sqlTypeReal, nullable: true, editable: true)
• Investigating_Dept_ (type: esriFieldTypeString, alias: Investigating Dept., SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Inv__Officer_Badge__ (type: esriFieldTypeString, alias: Inv. Officer/Badge #, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Object_Damaged (type: esriFieldTypeString, alias: Object Damaged, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Object_Owner (type: esriFieldTypeString, alias: Object Owner, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Road_Rec__ (type: esriFieldTypeString, alias: Road Rec #, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Ref_Post (type: esriFieldTypeString, alias: Ref Post, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Org__Station (type: esriFieldTypeString, alias: Org. Station, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Curr_Station (type: esriFieldTypeString, alias: Curr Station, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Light (type: esriFieldTypeSingle, alias: Light, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Light_Text (type: esriFieldTypeString, alias: Light Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Weather (type: esriFieldTypeSingle, alias: Weather, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Weather_Text (type: esriFieldTypeString, alias: Weather Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Surface_Type (type: esriFieldTypeSingle, alias: On Surface Type, SQL Type: sqlTypeReal, nullable: true, editable: true)
• On_Surface_Type_Text (type: esriFieldTypeString, alias: On Surface Type Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• At_Surface_Type (type: esriFieldTypeSingle, alias: At Surface Type, SQL Type: sqlTypeReal, nullable: true, editable: true)
• At_Surface_Type_Text (type: esriFieldTypeString, alias: At Surface Type Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Surface_Cond_ (type: esriFieldTypeSingle, alias: On Surface Cond., SQL Type: sqlTypeReal, nullable: true, editable: true)
• On_Surface_Cond_Text (type: esriFieldTypeString, alias: On Surface Cond Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• At_Surface_Cond_ (type: esriFieldTypeSingle, alias: At Surface Cond., SQL Type: sqlTypeReal, nullable: true, editable: true)
• At_Surface_Cond_Text (type: esriFieldTypeString, alias: At Surface Cond Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Rd__Charact_ (type: esriFieldTypeSingle, alias: On Rd. Charact., SQL Type: sqlTypeReal, nullable: true, editable: true)
• On_Rd__Charact__Text (type: esriFieldTypeString, alias: On Rd. Charact. Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• At_Rd__Charact_ (type: esriFieldTypeSingle, alias: At Rd. Charact., SQL Type: sqlTypeReal, nullable: true, editable: true)
• At_Rd__Charact__Text (type: esriFieldTypeString, alias: At Rd. Charact. Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• On_Const_Maint (type: esriFieldTypeSingle, alias: On Const/Maint, SQL Type: sqlTypeReal, nullable: true, editable: true)
• On_Const_Maint_Text (type: esriFieldTypeString, alias: On Const/Maint Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• At_Const_Maint (type: esriFieldTypeSingle, alias: At Const/Maint, SQL Type: sqlTypeReal, nullable: true, editable: true)
• At_Const_Maint_Text (type: esriFieldTypeString, alias: At Const/Maint Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Accident_Class (type: esriFieldTypeSingle, alias: Accident Class, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Accident_Class_Text (type: esriFieldTypeString, alias: Accident Class Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Collision (type: esriFieldTypeSingle, alias: Collision, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Collision_Text (type: esriFieldTypeString, alias: Collision Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Fixed_Object (type: esriFieldTypeSingle, alias: Fixed Object, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Fixed_Object_Text (type: esriFieldTypeString, alias: Fixed Object Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_1 (type: esriFieldTypeString, alias: Factor 1, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_1_Text (type: esriFieldTypeString, alias: Factor 1 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_2 (type: esriFieldTypeString, alias: Factor 2, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_2_Text (type: esriFieldTypeString, alias: Factor 2 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_3 (type: esriFieldTypeString, alias: Factor 3, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_3_Text (type: esriFieldTypeString, alias: Factor 3 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_4 (type: esriFieldTypeString, alias: Factor 4, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_4_Text (type: esriFieldTypeString, alias: Factor 4 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_5 (type: esriFieldTypeString, alias: Factor 5, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_5_Text (type: esriFieldTypeString, alias: Factor 5 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_6 (type: esriFieldTypeString, alias: Factor 6, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_6_Text (type: esriFieldTypeString, alias: Factor 6 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_7 (type: esriFieldTypeString, alias: Factor 7, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_7_Text (type: esriFieldTypeString, alias: Factor 7 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_8 (type: esriFieldTypeString, alias: Factor 8, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Factor_8_Text (type: esriFieldTypeString, alias: Factor 8 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_On_Street_1 (type: esriFieldTypeString, alias: TC On Street 1, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Traffic_Control_1 (type: esriFieldTypeSingle, alias: Traffic Control 1, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Traffic_Control_1_Text (type: esriFieldTypeString, alias: Traffic Control 1 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_Functional_1 (type: esriFieldTypeString, alias: TC Functional 1, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_On_Street_2 (type: esriFieldTypeString, alias: TC On Street 2, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Traffic_Control_2 (type: esriFieldTypeSingle, alias: Traffic Control 2, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Traffic_Control_2_Text (type: esriFieldTypeString, alias: Traffic Control 2 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_Functional_2 (type: esriFieldTypeString, alias: TC Functional 2, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_On_Street_3 (type: esriFieldTypeString, alias: TC On Street 3, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Traffic_Control_3 (type: esriFieldTypeSingle, alias: Traffic Control 3, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Traffic_Control_3_Text (type: esriFieldTypeString, alias: Traffic Control 3 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_Functional_3 (type: esriFieldTypeString, alias: TC Functional 3, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_On_Street_4 (type: esriFieldTypeString, alias: TC On Street 4, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Traffic_Control_4 (type: esriFieldTypeSingle, alias: Traffic Control 4, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Traffic_Control_4_Text (type: esriFieldTypeString, alias: Traffic Control 4 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_Functional_4 (type: esriFieldTypeString, alias: TC Functional 4, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_On_Street_5 (type: esriFieldTypeString, alias: TC On Street 5, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Traffic_Control_5 (type: esriFieldTypeSingle, alias: Traffic Control 5, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Traffic_Control_5_Text (type: esriFieldTypeString, alias: Traffic Control 5 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TC_Functional_5 (type: esriFieldTypeString, alias: TC Functional 5, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Special_Features_1 (type: esriFieldTypeSingle, alias: Special Features 1, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Special_Features_1_Text (type: esriFieldTypeString, alias: Special Features 1 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Special_Features_2 (type: esriFieldTypeSingle, alias: Special Features 2, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Special_Features_2_Text (type: esriFieldTypeString, alias: Special Features 2 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Special_Features_3 (type: esriFieldTypeSingle, alias: Special Features 3, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Special_Features_3_Text (type: esriFieldTypeString, alias: Special Features 3 Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• F__of_Units (type: esriFieldTypeSingle, alias: # of Units, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Validation (type: esriFieldTypeSingle, alias: Validation, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Validation_Text (type: esriFieldTypeString, alias: Validation Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Forced_V1_Dir_Code (type: esriFieldTypeSingle, alias: Forced V1 Dir Code, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Forced_V1_Direction (type: esriFieldTypeString, alias: Forced V1 Direction, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Forced_V2_Dir_Code (type: esriFieldTypeSingle, alias: Forced V2 Dir Code, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Forced_V2_Direction (type: esriFieldTypeString, alias: Forced V2 Direction, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Coll__Diagram (type: esriFieldTypeSingle, alias: Coll. Diagram, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Coll__Diagram_Text (type: esriFieldTypeString, alias: Coll. Diagram Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Location (type: esriFieldTypeSingle, alias: Location, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Location_Text (type: esriFieldTypeString, alias: Location Text, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Severity_Code (type: esriFieldTypeSingle, alias: Severity Code, SQL Type: sqlTypeReal, nullable: true, editable: true)
• Last_Modified_By (type: esriFieldTypeString, alias: Last Modified By, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Last_Modified_Date (type: esriFieldTypeDate, alias: Last Modified Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Created_By (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Creation_Date_Time (type: esriFieldTypeDate, alias: Creation Date Time, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: address, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/20/2020 1:18:30 PM

Schema Last Edit Date: 5/20/2020 1:18:30 PM

Data Last Edit Date: 5/20/2020 1:18:30 PM

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