Name: Collisions_XYTableToPoint

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: -117.4627151
YMin: 33.03503799
XMax: -117.2071991
YMax: 33.29743195
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[30,145,87,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: true

HasM: false

Time Info:

Start Time Field: COLLISION_DATE
End Time Field: null
Track ID Field: null
Time Extent
[1/1/2018 12:00:00 AM UTC, 12/31/2018 12:00:00 AM UTC]

Time Reference: UTC
Time Interval: 1
Time Interval Units: esriTimeUnitsUnknown
Has Live Data: false
Export Options:

Use Time: true
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

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)
• 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: esriFieldTypeString, alias: OFFICER_ID, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• REPORTING_DISTRICT (type: esriFieldTypeString, alias: REPORTING_DISTRICT, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• DAY_OF_WEEK (type: esriFieldTypeDouble, alias: DAY_OF_WEEK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHP_SHIFT (type: esriFieldTypeDouble, alias: CHP_SHIFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POPULATION (type: esriFieldTypeDouble, alias: POPULATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CNTY_CITY_LOC (type: esriFieldTypeDouble, alias: CNTY_CITY_LOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPECIAL_COND (type: esriFieldTypeDouble, alias: SPECIAL_COND, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BEAT_TYPE (type: esriFieldTypeDouble, alias: BEAT_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHP_BEAT_TYPE (type: esriFieldTypeDouble, alias: CHP_BEAT_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CITY_DIVISION_LAPD (type: esriFieldTypeString, alias: CITY_DIVISION_LAPD, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• CHP_BEAT_CLASS (type: esriFieldTypeDouble, alias: CHP_BEAT_CLASS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BEAT_NUMBER (type: esriFieldTypeDouble, alias: BEAT_NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRIMARY_RD (type: esriFieldTypeString, alias: PRIMARY_RD, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• SECONDARY_RD (type: esriFieldTypeString, alias: SECONDARY_RD, SQL Type: sqlTypeOther, length: 5000, 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: 5000, nullable: true, editable: true)
• INTERSECTION (type: esriFieldTypeString, alias: INTERSECTION, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• WEATHER_1 (type: esriFieldTypeString, alias: WEATHER_1, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• WEATHER_2 (type: esriFieldTypeString, alias: WEATHER_2, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• STATE_HWY_IND (type: esriFieldTypeString, alias: STATE_HWY_IND, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• CALTRANS_COUNTY (type: esriFieldTypeString, alias: CALTRANS_COUNTY, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• CALTRANS_DISTRICT (type: esriFieldTypeString, alias: CALTRANS_DISTRICT, SQL Type: sqlTypeOther, length: 5000, 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: 5000, nullable: true, editable: true)
• POSTMILE_PREFIX (type: esriFieldTypeString, alias: POSTMILE_PREFIX, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• POSTMILE (type: esriFieldTypeString, alias: POSTMILE, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• LOCATION_TYPE (type: esriFieldTypeString, alias: LOCATION_TYPE, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• RAMP_INTERSECTION (type: esriFieldTypeString, alias: RAMP_INTERSECTION, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• SIDE_OF_HWY (type: esriFieldTypeString, alias: SIDE_OF_HWY, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• TOW_AWAY (type: esriFieldTypeString, alias: TOW_AWAY, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• COLLISION_SEVERITY (type: esriFieldTypeDouble, alias: COLLISION_SEVERITY, SQL Type: sqlTypeOther, 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: 5000, nullable: true, editable: true)
• PCF_CODE_OF_VIOL (type: esriFieldTypeString, alias: PCF_CODE_OF_VIOL, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• PCF_VIOL_CATEGORY (type: esriFieldTypeDouble, alias: PCF_VIOL_CATEGORY, SQL Type: sqlTypeOther, 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: 5000, nullable: true, editable: true)
• HIT_AND_RUN (type: esriFieldTypeString, alias: HIT_AND_RUN, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• TYPE_OF_COLLISION (type: esriFieldTypeString, alias: TYPE_OF_COLLISION, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• MVIW (type: esriFieldTypeString, alias: MVIW, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• PED_ACTION (type: esriFieldTypeString, alias: PED_ACTION, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• ROAD_SURFACE (type: esriFieldTypeString, alias: ROAD_SURFACE, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• ROAD_COND_1 (type: esriFieldTypeString, alias: ROAD_COND_1, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• ROAD_COND_2 (type: esriFieldTypeString, alias: ROAD_COND_2, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• LIGHTING (type: esriFieldTypeString, alias: LIGHTING, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• CONTROL_DEVICE (type: esriFieldTypeString, alias: CONTROL_DEVICE, SQL Type: sqlTypeOther, length: 5000, 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: 5000, nullable: true, editable: true)
• BICYCLE_ACCIDENT (type: esriFieldTypeString, alias: BICYCLE_ACCIDENT, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• MOTORCYCLE_ACCIDENT (type: esriFieldTypeString, alias: MOTORCYCLE_ACCIDENT, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• TRUCK_ACCIDENT (type: esriFieldTypeString, alias: TRUCK_ACCIDENT, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• NOT_PRIVATE_PROPERTY (type: esriFieldTypeString, alias: NOT_PRIVATE_PROPERTY, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• ALCOHOL_INVOLVED (type: esriFieldTypeString, alias: ALCOHOL_INVOLVED, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• STWD_VEHTYPE_AT_FAULT (type: esriFieldTypeString, alias: STWD_VEHTYPE_AT_FAULT, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• CHP_VEHTYPE_AT_FAULT (type: esriFieldTypeDouble, alias: CHP_VEHTYPE_AT_FAULT, SQL Type: sqlTypeOther, 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: 5000, nullable: true, editable: true)
• SECONDARY_RAMP (type: esriFieldTypeString, alias: SECONDARY_RAMP, SQL Type: sqlTypeOther, length: 5000, 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: 5000, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 5000, 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)

Templates:

Name: Collisions_XYTableToPoint
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/23/2021 1:12:12 AM

Schema Last Edit Date: 8/23/2021 1:12:12 AM

Data Last Edit Date: 8/23/2021 1:12:12 AM

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