Name: MenloPark_Collisions
Display Field: CASE_ID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
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: 6062315.14055863
YMin: 1979850.02126014
XMax: 6085908.82598272
YMax: 2003953.15973356
Spatial Reference: 102643 (2227)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[67,58,140,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)
- CASE_ID (type: esriFieldTypeDouble, alias: CASE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ACCIDENT_YEAR (type: esriFieldTypeDouble, alias: ACCIDENT_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PROC_DATE (type: esriFieldTypeDate, alias: PROC_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- JURIS (type: esriFieldTypeDouble, alias: JURIS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COLLISION_DATE (type: esriFieldTypeDate, alias: COLLISION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- COLLISION_TIME (type: esriFieldTypeDouble, alias: COLLISION_TIME, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OFFICER_ID (type: esriFieldTypeDouble, alias: OFFICER_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- REPORTING_DISTRICT (type: esriFieldTypeString, alias: REPORTING_DISTRICT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DAY_OF_WEEK (type: esriFieldTypeString, alias: DAY_OF_WEEK, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CHP_SHIFT (type: esriFieldTypeString, alias: CHP_SHIFT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- POPULATION (type: esriFieldTypeString, alias: POPULATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CNTY_CITY_LOC (type: esriFieldTypeDouble, alias: CNTY_CITY_LOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SPECIAL_COND (type: esriFieldTypeString, alias: SPECIAL_COND, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- BEAT_TYPE (type: esriFieldTypeString, alias: BEAT_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CHP_BEAT_TYPE (type: esriFieldTypeString, alias: CHP_BEAT_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CITY_DIVISION_LAPD (type: esriFieldTypeString, alias: CITY_DIVISION_LAPD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CHP_BEAT_CLASS (type: esriFieldTypeString, alias: CHP_BEAT_CLASS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- BEAT_NUMBER (type: esriFieldTypeDouble, alias: BEAT_NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
- street_name (type: esriFieldTypeString, alias: street_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SECONDARY_RD (type: esriFieldTypeString, alias: SECONDARY_RD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DISTANCE (type: esriFieldTypeDouble, alias: DISTANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DIRECTION (type: esriFieldTypeString, alias: DIRECTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- INTERSECTION (type: esriFieldTypeString, alias: INTERSECTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- WEATHER_1 (type: esriFieldTypeString, alias: WEATHER_1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- WEATHER_2 (type: esriFieldTypeString, alias: WEATHER_2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- STATE_HWY_IND (type: esriFieldTypeString, alias: STATE_HWY_IND, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CALTRANS_COUNTY (type: esriFieldTypeString, alias: CALTRANS_COUNTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CALTRANS_DISTRICT (type: esriFieldTypeDouble, alias: CALTRANS_DISTRICT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STATE_ROUTE (type: esriFieldTypeDouble, alias: STATE_ROUTE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ROUTE_SUFFIX (type: esriFieldTypeString, alias: ROUTE_SUFFIX, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- POSTMILE_PREFIX (type: esriFieldTypeString, alias: POSTMILE_PREFIX, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- POSTMILE (type: esriFieldTypeDouble, alias: POSTMILE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LOCATION_TYPE (type: esriFieldTypeString, alias: LOCATION_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- RAMP_INTERSECTION (type: esriFieldTypeString, alias: RAMP_INTERSECTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SIDE_OF_HWY (type: esriFieldTypeString, alias: SIDE_OF_HWY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- TOW_AWAY (type: esriFieldTypeString, alias: TOW_AWAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- severity (type: esriFieldTypeString, alias: COLLISION_SEVERITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- NUMBER_KILLED (type: esriFieldTypeDouble, alias: NUMBER_KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_INJURED (type: esriFieldTypeDouble, alias: NUMBER_INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PARTY_COUNT (type: esriFieldTypeDouble, alias: PARTY_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PRIMARY_COLL_FACTOR (type: esriFieldTypeString, alias: PRIMARY_COLL_FACTOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PCF_CODE_OF_VIOL (type: esriFieldTypeString, alias: PCF_CODE_OF_VIOL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PCF_VIOL_CATEGORY (type: esriFieldTypeString, alias: PCF_VIOL_CATEGORY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PCF_VIOLATION (type: esriFieldTypeDouble, alias: PCF_VIOLATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PCF_VIOL_SUBSECTION (type: esriFieldTypeString, alias: PCF_VIOL_SUBSECTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- HIT_AND_RUN (type: esriFieldTypeString, alias: HIT_AND_RUN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- TYPE_OF_COLLISION (type: esriFieldTypeString, alias: TYPE_OF_COLLISION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MVIW (type: esriFieldTypeString, alias: MVIW, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PED_ACTION (type: esriFieldTypeString, alias: PED_ACTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ROAD_SURFACE (type: esriFieldTypeString, alias: ROAD_SURFACE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ROAD_COND_1 (type: esriFieldTypeString, alias: ROAD_COND_1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ROAD_COND_2 (type: esriFieldTypeString, alias: ROAD_COND_2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- LIGHTING (type: esriFieldTypeString, alias: LIGHTING, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CONTROL_DEVICE (type: esriFieldTypeString, alias: CONTROL_DEVICE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CHP_ROAD_TYPE (type: esriFieldTypeDouble, alias: CHP_ROAD_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PEDESTRIAN_ACCIDENT (type: esriFieldTypeString, alias: PEDESTRIAN_ACCIDENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- BICYCLE_ACCIDENT (type: esriFieldTypeString, alias: BICYCLE_ACCIDENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MOTORCYCLE_ACCIDENT (type: esriFieldTypeString, alias: MOTORCYCLE_ACCIDENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- TRUCK_ACCIDENT (type: esriFieldTypeString, alias: TRUCK_ACCIDENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- NOT_PRIVATE_PROPERTY (type: esriFieldTypeString, alias: NOT_PRIVATE_PROPERTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ALCOHOL_INVOLVED (type: esriFieldTypeString, alias: ALCOHOL_INVOLVED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- STWD_VEHTYPE_AT_FAULT (type: esriFieldTypeString, alias: STWD_VEHTYPE_AT_FAULT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CHP_VEHTYPE_AT_FAULT (type: esriFieldTypeString, alias: CHP_VEHTYPE_AT_FAULT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- COUNT_SEVERE_INJ (type: esriFieldTypeDouble, alias: COUNT_SEVERE_INJ, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNT_VISIBLE_INJ (type: esriFieldTypeDouble, alias: COUNT_VISIBLE_INJ, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNT_COMPLAINT_PAIN (type: esriFieldTypeDouble, alias: COUNT_COMPLAINT_PAIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNT_PED_KILLED (type: esriFieldTypeDouble, alias: COUNT_PED_KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNT_PED_INJURED (type: esriFieldTypeDouble, alias: COUNT_PED_INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNT_BICYCLIST_KILLED (type: esriFieldTypeDouble, alias: COUNT_BICYCLIST_KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNT_BICYCLIST_INJURED (type: esriFieldTypeDouble, alias: COUNT_BICYCLIST_INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNT_MC_KILLED (type: esriFieldTypeDouble, alias: COUNT_MC_KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNT_MC_INJURED (type: esriFieldTypeDouble, alias: COUNT_MC_INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PRIMARY_RAMP (type: esriFieldTypeString, alias: PRIMARY_RAMP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SECONDARY_RAMP (type: esriFieldTypeString, alias: SECONDARY_RAMP, SQL Type: sqlTypeOther, length: 255, 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)
- COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
- POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Intersection_ID (type: esriFieldTypeString, alias: Intersection ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Segment_ID (type: esriFieldTypeString, alias: Segment ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Location_Criteria_Inclusion (type: esriFieldTypeString, alias: Location Criteria Inclusion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Time_of_Day (type: esriFieldTypeString, alias: Time of Day, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Day_of_Week_1 (type: esriFieldTypeString, alias: Day of Week, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Month (type: esriFieldTypeString, alias: Month, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- KSI_ (type: esriFieldTypeString, alias: KSI?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- KSI_Victims (type: esriFieldTypeDouble, alias: KSI Victims, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Intersection_ (type: esriFieldTypeString, alias: Intersection?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Collision_Severity_1 (type: esriFieldTypeString, alias: Collision Severity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PCF_Violation_Category (type: esriFieldTypeString, alias: PCF Violation Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PCF_Violation_Detail (type: esriFieldTypeString, alias: PCF Violation Detail, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Turn_Involved (type: esriFieldTypeDouble, alias: Turn Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Left_Turn (type: esriFieldTypeDouble, alias: Left Turn, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Right_Turn (type: esriFieldTypeDouble, alias: Right Turn, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Other_Turn (type: esriFieldTypeDouble, alias: Other Turn, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Victim_15_and_under (type: esriFieldTypeDouble, alias: Victim_15_and_under, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Victim_65_and_over (type: esriFieldTypeDouble, alias: Victim_65_and_over, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BelleHaven (type: esriFieldTypeDouble, alias: BelleHaven, SQL Type: sqlTypeOther, nullable: true, editable: true)
- StateOwned (type: esriFieldTypeDouble, alias: StateOwned, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Downtown (type: esriFieldTypeDouble, alias: Downtown, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mixed_use_zoning (type: esriFieldTypeDouble, alias: mixed_use_zoning, SQL Type: sqlTypeOther, nullable: true, editable: true)
- residential_zoning (type: esriFieldTypeDouble, alias: residential_zoning, SQL Type: sqlTypeOther, nullable: true, editable: true)
- commercial_zoning (type: esriFieldTypeDouble, alias: commercial_zoning, SQL Type: sqlTypeOther, nullable: true, editable: true)
- industrial_zoning (type: esriFieldTypeDouble, alias: industrial_zoning, SQL Type: sqlTypeOther, nullable: true, editable: true)
- other_zoning (type: esriFieldTypeDouble, alias: other_zoning, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Transit_Buffer (type: esriFieldTypeString, alias: Transit_Buffer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- School_Buffer (type: esriFieldTypeString, alias: School_Buffer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Rail_Xing_Buffer (type: esriFieldTypeString, alias: Rail_Xing_Buffer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- StopSignCount (type: esriFieldTypeDouble, alias: StopSignCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Control_Type (type: esriFieldTypeString, alias: Control_Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- LegsCount (type: esriFieldTypeDouble, alias: LegsCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Bike_Lanes (type: esriFieldTypeString, alias: Bike_Lanes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Crosswalk (type: esriFieldTypeString, alias: Crosswalk, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Vehicle_fail_to_yield (type: esriFieldTypeDouble, alias: Vehicle_fail_to_yield, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EA1StateOwned (type: esriFieldTypeDouble, alias: EA1StateOwned, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EA2Arterial (type: esriFieldTypeDouble, alias: EA2Arterial, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EA3Local (type: esriFieldTypeDouble, alias: EA3Local, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EA4Intersection (type: esriFieldTypeDouble, alias: EA4Intersection, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EA5School (type: esriFieldTypeDouble, alias: EA5School, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BelleHaven1 (type: esriFieldTypeDouble, alias: BelleHaven1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Downtown1 (type: esriFieldTypeDouble, alias: Downtown1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Willows (type: esriFieldTypeDouble, alias: Willows, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Templates:
Name: MenloPark_Collisions
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/15/2024 10:38:09 PM
Schema Last Edit Date: 8/15/2024 10:38:09 PM
Data Last Edit Date: 8/15/2024 10:38:09 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat