Name: My_Collision_Data_objects

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:

• CASE_ID (type: esriFieldTypeInteger, alias: CASE_ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ACCIDENT_YEAR_x (type: esriFieldTypeSmallInteger, alias: ACCIDENT_YEAR_x, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PROC_DATE (type: esriFieldTypeDate, alias: PROC_DATE, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• JURIS (type: esriFieldTypeSmallInteger, alias: JURIS, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• COLLISION_DATE (type: esriFieldTypeDate, alias: COLLISION_DATE, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• COLLISION_TIME (type: esriFieldTypeSmallInteger, alias: COLLISION_TIME, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• OFFICER_ID (type: esriFieldTypeString, alias: OFFICER_ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• REPORTING_DISTRICT (type: esriFieldTypeString, alias: REPORTING_DISTRICT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DAY_OF_WEEK (type: esriFieldTypeSmallInteger, alias: DAY_OF_WEEK, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• CHP_SHIFT (type: esriFieldTypeSmallInteger, alias: CHP_SHIFT, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• POPULATION (type: esriFieldTypeSmallInteger, alias: POPULATION, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• CNTY_CITY_LOC (type: esriFieldTypeSmallInteger, alias: CNTY_CITY_LOC, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• SPECIAL_COND (type: esriFieldTypeSmallInteger, alias: SPECIAL_COND, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• BEAT_TYPE (type: esriFieldTypeSmallInteger, alias: BEAT_TYPE, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• CHP_BEAT_TYPE (type: esriFieldTypeSmallInteger, alias: CHP_BEAT_TYPE, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• CITY_DIVISION_LAPD (type: esriFieldTypeString, alias: CITY_DIVISION_LAPD, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CHP_BEAT_CLASS (type: esriFieldTypeSmallInteger, alias: CHP_BEAT_CLASS, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• BEAT_NUMBER (type: esriFieldTypeSmallInteger, alias: BEAT_NUMBER, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PRIMARY_RD (type: esriFieldTypeString, alias: PRIMARY_RD, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SECONDARY_RD (type: esriFieldTypeString, alias: SECONDARY_RD, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DISTANCE (type: esriFieldTypeSmallInteger, alias: DISTANCE, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• DIRECTION (type: esriFieldTypeString, alias: DIRECTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• INTERSECTION (type: esriFieldTypeString, alias: INTERSECTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WEATHER_1 (type: esriFieldTypeString, alias: WEATHER_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WEATHER_2 (type: esriFieldTypeString, alias: WEATHER_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STATE_HWY_IND (type: esriFieldTypeString, alias: STATE_HWY_IND, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CALTRANS_COUNTY (type: esriFieldTypeString, alias: CALTRANS_COUNTY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CALTRANS_DISTRICT (type: esriFieldTypeString, alias: CALTRANS_DISTRICT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STATE_ROUTE (type: esriFieldTypeString, alias: STATE_ROUTE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ROUTE_SUFFIX (type: esriFieldTypeString, alias: ROUTE_SUFFIX, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• POSTMILE_PREFIX (type: esriFieldTypeString, alias: POSTMILE_PREFIX, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• POSTMILE (type: esriFieldTypeString, alias: POSTMILE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LOCATION_TYPE (type: esriFieldTypeString, alias: LOCATION_TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• RAMP_INTERSECTION (type: esriFieldTypeString, alias: RAMP_INTERSECTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SIDE_OF_HWY (type: esriFieldTypeString, alias: SIDE_OF_HWY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• TOW_AWAY (type: esriFieldTypeString, alias: TOW_AWAY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• COLLISION_SEVERITY (type: esriFieldTypeSmallInteger, alias: COLLISION_SEVERITY, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• NUMBER_KILLED (type: esriFieldTypeSmallInteger, alias: NUMBER_KILLED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• NUMBER_INJURED (type: esriFieldTypeSmallInteger, alias: NUMBER_INJURED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PARTY_COUNT (type: esriFieldTypeSmallInteger, alias: PARTY_COUNT, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PRIMARY_COLL_FACTOR (type: esriFieldTypeString, alias: PRIMARY_COLL_FACTOR, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PCF_CODE_OF_VIOL (type: esriFieldTypeString, alias: PCF_CODE_OF_VIOL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PCF_VIOL_CATEGORY (type: esriFieldTypeString, alias: PCF_VIOL_CATEGORY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PCF_VIOLATION (type: esriFieldTypeInteger, alias: PCF_VIOLATION, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PCF_VIOL_SUBSECTION (type: esriFieldTypeString, alias: PCF_VIOL_SUBSECTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• HIT_AND_RUN (type: esriFieldTypeString, alias: HIT_AND_RUN, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• TYPE_OF_COLLISION (type: esriFieldTypeString, alias: TYPE_OF_COLLISION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MVIW (type: esriFieldTypeString, alias: MVIW, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PED_ACTION (type: esriFieldTypeString, alias: PED_ACTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ROAD_SURFACE (type: esriFieldTypeString, alias: ROAD_SURFACE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ROAD_COND_1 (type: esriFieldTypeString, alias: ROAD_COND_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ROAD_COND_2 (type: esriFieldTypeString, alias: ROAD_COND_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LIGHTING (type: esriFieldTypeString, alias: LIGHTING, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CONTROL_DEVICE (type: esriFieldTypeString, alias: CONTROL_DEVICE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CHP_ROAD_TYPE (type: esriFieldTypeSmallInteger, alias: CHP_ROAD_TYPE, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PEDESTRIAN_ACCIDENT (type: esriFieldTypeString, alias: PEDESTRIAN_ACCIDENT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• BICYCLE_ACCIDENT (type: esriFieldTypeString, alias: BICYCLE_ACCIDENT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MOTORCYCLE_ACCIDENT (type: esriFieldTypeString, alias: MOTORCYCLE_ACCIDENT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• TRUCK_ACCIDENT (type: esriFieldTypeString, alias: TRUCK_ACCIDENT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• NOT_PRIVATE_PROPERTY (type: esriFieldTypeString, alias: NOT_PRIVATE_PROPERTY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ALCOHOL_INVOLVED (type: esriFieldTypeString, alias: ALCOHOL_INVOLVED, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STWD_VEHTYPE_AT_FAULT (type: esriFieldTypeString, alias: STWD_VEHTYPE_AT_FAULT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CHP_VEHTYPE_AT_FAULT (type: esriFieldTypeString, alias: CHP_VEHTYPE_AT_FAULT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• COUNT_SEVERE_INJ (type: esriFieldTypeSmallInteger, alias: COUNT_SEVERE_INJ, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• COUNT_VISIBLE_INJ (type: esriFieldTypeSmallInteger, alias: COUNT_VISIBLE_INJ, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• COUNT_COMPLAINT_PAIN (type: esriFieldTypeSmallInteger, alias: COUNT_COMPLAINT_PAIN, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• COUNT_PED_KILLED (type: esriFieldTypeSmallInteger, alias: COUNT_PED_KILLED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• COUNT_PED_INJURED (type: esriFieldTypeSmallInteger, alias: COUNT_PED_INJURED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• COUNT_BICYCLIST_KILLED (type: esriFieldTypeSmallInteger, alias: COUNT_BICYCLIST_KILLED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• COUNT_BICYCLIST_INJURED (type: esriFieldTypeSmallInteger, alias: COUNT_BICYCLIST_INJURED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• COUNT_MC_KILLED (type: esriFieldTypeSmallInteger, alias: COUNT_MC_KILLED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• COUNT_MC_INJURED (type: esriFieldTypeSmallInteger, alias: COUNT_MC_INJURED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PRIMARY_RAMP (type: esriFieldTypeString, alias: PRIMARY_RAMP, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SECONDARY_RAMP (type: esriFieldTypeString, alias: SECONDARY_RAMP, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeSingle, alias: LATITUDE, SQL Type: sqlTypeReal, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeSingle, alias: LONGITUDE, SQL Type: sqlTypeReal, nullable: true, editable: true)
• COUNTY_x (type: esriFieldTypeString, alias: COUNTY_x, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CITY_x (type: esriFieldTypeString, alias: CITY_x, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• POINT_X (type: esriFieldTypeString, alias: POINT_X, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• POINT_Y (type: esriFieldTypeString, alias: POINT_Y, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PARTY_NUMBER_x (type: esriFieldTypeSmallInteger, alias: PARTY_NUMBER_x, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PARTY_TYPE (type: esriFieldTypeString, alias: PARTY_TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• AT_FAULT (type: esriFieldTypeString, alias: AT_FAULT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PARTY_SEX (type: esriFieldTypeString, alias: PARTY_SEX, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PARTY_AGE (type: esriFieldTypeSmallInteger, alias: PARTY_AGE, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PARTY_SOBRIETY (type: esriFieldTypeString, alias: PARTY_SOBRIETY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PARTY_DRUG_PHYSICAL (type: esriFieldTypeString, alias: PARTY_DRUG_PHYSICAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DIR_OF_TRAVEL (type: esriFieldTypeString, alias: DIR_OF_TRAVEL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PARTY_SAFETY_EQUIP_1 (type: esriFieldTypeString, alias: PARTY_SAFETY_EQUIP_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PARTY_SAFETY_EQUIP_2 (type: esriFieldTypeString, alias: PARTY_SAFETY_EQUIP_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FINAN_RESPONS (type: esriFieldTypeString, alias: FINAN_RESPONS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SP_INFO_1 (type: esriFieldTypeString, alias: SP_INFO_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SP_INFO_2 (type: esriFieldTypeString, alias: SP_INFO_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SP_INFO_3 (type: esriFieldTypeString, alias: SP_INFO_3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• OAF_VIOLATION_CODE (type: esriFieldTypeString, alias: OAF_VIOLATION_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• OAF_VIOL_CAT (type: esriFieldTypeString, alias: OAF_VIOL_CAT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• OAF_VIOL_SECTION (type: esriFieldTypeInteger, alias: OAF_VIOL_SECTION, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• OAF_VIOLATION_SUFFIX (type: esriFieldTypeString, alias: OAF_VIOLATION_SUFFIX, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• OAF_1 (type: esriFieldTypeString, alias: OAF_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• OAF_2 (type: esriFieldTypeString, alias: OAF_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PARTY_NUMBER_KILLED (type: esriFieldTypeSmallInteger, alias: PARTY_NUMBER_KILLED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PARTY_NUMBER_INJURED (type: esriFieldTypeSmallInteger, alias: PARTY_NUMBER_INJURED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• MOVE_PRE_ACC (type: esriFieldTypeString, alias: MOVE_PRE_ACC, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• VEHICLE_YEAR (type: esriFieldTypeSmallInteger, alias: VEHICLE_YEAR, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• VEHICLE_MAKE (type: esriFieldTypeString, alias: VEHICLE_MAKE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STWD_VEHICLE_TYPE (type: esriFieldTypeString, alias: STWD_VEHICLE_TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CHP_VEH_TYPE_TOWING (type: esriFieldTypeSmallInteger, alias: CHP_VEH_TYPE_TOWING, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• CHP_VEH_TYPE_TOWED (type: esriFieldTypeSmallInteger, alias: CHP_VEH_TYPE_TOWED, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• RACE (type: esriFieldTypeString, alias: RACE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• INATTENTION (type: esriFieldTypeString, alias: INATTENTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SPECIAL_INFO_F (type: esriFieldTypeString, alias: SPECIAL_INFO_F, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SPECIAL_INFO_G (type: esriFieldTypeString, alias: SPECIAL_INFO_G, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ACCIDENT_YEAR_y (type: esriFieldTypeSmallInteger, alias: ACCIDENT_YEAR_y, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• PARTY_NUMBER_y (type: esriFieldTypeSmallInteger, alias: PARTY_NUMBER_y, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• VICTIM_NUMBER (type: esriFieldTypeSmallInteger, alias: VICTIM_NUMBER, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• VICTIM_ROLE (type: esriFieldTypeSmallInteger, alias: VICTIM_ROLE, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• VICTIM_SEX (type: esriFieldTypeString, alias: VICTIM_SEX, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• VICTIM_AGE (type: esriFieldTypeSmallInteger, alias: VICTIM_AGE, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• VICTIM_DEGREE_OF_INJURY (type: esriFieldTypeSmallInteger, alias: VICTIM_DEGREE_OF_INJURY, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• VICTIM_SEATING_POSITION (type: esriFieldTypeString, alias: VICTIM_SEATING_POSITION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• VICTIM_SAFETY_EQUIP_1 (type: esriFieldTypeString, alias: VICTIM_SAFETY_EQUIP_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• VICTIM_SAFETY_EQUIP_2 (type: esriFieldTypeString, alias: VICTIM_SAFETY_EQUIP_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• VICTIM_EJECTED (type: esriFieldTypeString, alias: VICTIM_EJECTED, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• COUNTY_y (type: esriFieldTypeString, alias: COUNTY_y, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CITY_y (type: esriFieldTypeString, alias: CITY_y, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ACCIDENT_YEAR (type: esriFieldTypeSmallInteger, alias: ACCIDENT_YEAR, SQL Type: sqlTypeSmallInt, 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: 2/21/2024 6:32:50 AM

Schema Last Edit Date: 2/21/2024 6:32:50 AM

Data Last Edit Date: 2/21/2024 6:32:50 AM

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