Name: CoC Crashes

Display Field: INTERSECTION_RELATED

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8424751.00528885
YMin: 7.5060238247104E-08
XMax: 2186588.85611337
YMax: 9296239.23099235
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[68,163,219,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}}},"scaleSymbols":true,"transparency":30,"labelingInfo":null}

HasZ: false

HasM: false

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)
• CRN (type: esriFieldTypeInteger, alias: CRN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ARRIVAL_TM (type: esriFieldTypeDouble, alias: ARRIVAL_TM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AUTOMOBILE_COUNT (type: esriFieldTypeInteger, alias: AUTOMOBILE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BELTED_DEATH_COUNT (type: esriFieldTypeInteger, alias: BELTED_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BELTED_SUSP_SERIOUS_INJ_COUNT (type: esriFieldTypeInteger, alias: BELTED_SUSP_SERIOUS_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BICYCLE_COUNT (type: esriFieldTypeInteger, alias: BICYCLE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BICYCLE_DEATH_COUNT (type: esriFieldTypeInteger, alias: BICYCLE_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BICYCLE_SUSP_SERIOUS_INJ_COUNT (type: esriFieldTypeInteger, alias: BICYCLE_SUSP_SERIOUS_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUS_COUNT (type: esriFieldTypeInteger, alias: BUS_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHLDPAS_DEATH_COUNT (type: esriFieldTypeInteger, alias: CHLDPAS_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHLDPAS_SUSP_SERIOUS_INJ_COUNT (type: esriFieldTypeInteger, alias: CHLDPAS_SUSP_SERIOUS_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COLLISION_TYPE (type: esriFieldTypeInteger, alias: COLLISION_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMM_VEH_COUNT (type: esriFieldTypeInteger, alias: COMM_VEH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONS_ZONE_SPD_LIM (type: esriFieldTypeDouble, alias: CONS_ZONE_SPD_LIM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeInteger, alias: COUNTY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_MONTH (type: esriFieldTypeInteger, alias: CRASH_MONTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_YEAR (type: esriFieldTypeInteger, alias: CRASH_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DAY_OF_WEEK (type: esriFieldTypeInteger, alias: DAY_OF_WEEK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEC_LAT (type: esriFieldTypeDouble, alias: DEC_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEC_LONG (type: esriFieldTypeDouble, alias: DEC_LONG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPATCH_TM (type: esriFieldTypeDouble, alias: DISPATCH_TM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeInteger, alias: DISTRICT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_COUNT_16YR (type: esriFieldTypeInteger, alias: DRIVER_COUNT_16YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_COUNT_17YR (type: esriFieldTypeInteger, alias: DRIVER_COUNT_17YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_COUNT_18YR (type: esriFieldTypeInteger, alias: DRIVER_COUNT_18YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_COUNT_19YR (type: esriFieldTypeInteger, alias: DRIVER_COUNT_19YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_COUNT_20YR (type: esriFieldTypeInteger, alias: DRIVER_COUNT_20YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_COUNT_50_64YR (type: esriFieldTypeInteger, alias: DRIVER_COUNT_50_64YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_COUNT_65_74YR (type: esriFieldTypeInteger, alias: DRIVER_COUNT_65_74YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_COUNT_75PLUS (type: esriFieldTypeInteger, alias: DRIVER_COUNT_75PLUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EST_HRS_CLOSED (type: esriFieldTypeDouble, alias: EST_HRS_CLOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FATAL_COUNT (type: esriFieldTypeInteger, alias: FATAL_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEAVY_TRUCK_COUNT (type: esriFieldTypeInteger, alias: HEAVY_TRUCK_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HORSE_BUGGY_COUNT (type: esriFieldTypeInteger, alias: HORSE_BUGGY_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HOUR_OF_DAY (type: esriFieldTypeInteger, alias: HOUR_OF_DAY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ILLUMINATION (type: esriFieldTypeInteger, alias: ILLUMINATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INJURY_COUNT (type: esriFieldTypeInteger, alias: INJURY_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERSECT_TYPE (type: esriFieldTypeInteger, alias: INTERSECT_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERSECTION_RELATED (type: esriFieldTypeString, alias: INTERSECTION_RELATED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LANE_CLOSED (type: esriFieldTypeInteger, alias: LANE_CLOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeString, alias: LATITUDE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LN_CLOSE_DIR (type: esriFieldTypeDouble, alias: LN_CLOSE_DIR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCATION_TYPE (type: esriFieldTypeInteger, alias: LOCATION_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeString, alias: LONGITUDE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MAX_SEVERITY_LEVEL (type: esriFieldTypeInteger, alias: MAX_SEVERITY_LEVEL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MCYCLE_DEATH_COUNT (type: esriFieldTypeInteger, alias: MCYCLE_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MCYCLE_SUSP_SERIOUS_INJ_COUNT (type: esriFieldTypeInteger, alias: MCYCLE_SUSP_SERIOUS_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MOTORCYCLE_COUNT (type: esriFieldTypeInteger, alias: MOTORCYCLE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MUNICIPALITY (type: esriFieldTypeInteger, alias: MUNICIPALITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NONMOTR_COUNT (type: esriFieldTypeInteger, alias: NONMOTR_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NONMOTR_DEATH_COUNT (type: esriFieldTypeInteger, alias: NONMOTR_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NONMOTR_SUSP_SERIOUS_INJ_COUNT (type: esriFieldTypeInteger, alias: NONMOTR_SUSP_SERIOUS_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NTFY_HIWY_MAINT (type: esriFieldTypeString, alias: NTFY_HIWY_MAINT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PED_COUNT (type: esriFieldTypeInteger, alias: PED_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PED_DEATH_COUNT (type: esriFieldTypeInteger, alias: PED_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PED_SUSP_SERIOUS_INJ_COUNT (type: esriFieldTypeInteger, alias: PED_SUSP_SERIOUS_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSON_COUNT (type: esriFieldTypeInteger, alias: PERSON_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POLICE_AGCY (type: esriFieldTypeString, alias: POLICE_AGCY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• POSSIBLE_INJ_COUNT (type: esriFieldTypeInteger, alias: POSSIBLE_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RDWY_SURF_TYPE_CD (type: esriFieldTypeDouble, alias: RDWY_SURF_TYPE_CD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RELATION_TO_ROAD (type: esriFieldTypeInteger, alias: RELATION_TO_ROAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROAD_CONDITION (type: esriFieldTypeInteger, alias: ROAD_CONDITION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROADWAY_CLEARED (type: esriFieldTypeString, alias: ROADWAY_CLEARED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SCH_BUS_IND (type: esriFieldTypeString, alias: SCH_BUS_IND, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SCH_ZONE_IND (type: esriFieldTypeString, alias: SCH_ZONE_IND, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SECONDARY_CRASH (type: esriFieldTypeString, alias: SECONDARY_CRASH, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SMALL_TRUCK_COUNT (type: esriFieldTypeInteger, alias: SMALL_TRUCK_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPEC_JURIS_CD (type: esriFieldTypeDouble, alias: SPEC_JURIS_CD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUSP_MINOR_INJ_COUNT (type: esriFieldTypeInteger, alias: SUSP_MINOR_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUSP_SERIOUS_INJ_COUNT (type: esriFieldTypeInteger, alias: SUSP_SERIOUS_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUV_COUNT (type: esriFieldTypeInteger, alias: SUV_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TCD_FUNC_CD (type: esriFieldTypeDouble, alias: TCD_FUNC_CD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TCD_TYPE (type: esriFieldTypeInteger, alias: TCD_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TFC_DETOUR_IND (type: esriFieldTypeString, alias: TFC_DETOUR_IND, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TIME_OF_DAY (type: esriFieldTypeInteger, alias: TIME_OF_DAY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_INJ_COUNT (type: esriFieldTypeInteger, alias: TOT_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_UNITS (type: esriFieldTypeInteger, alias: TOTAL_UNITS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNB_DEATH_COUNT (type: esriFieldTypeInteger, alias: UNB_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNB_SUSP_SERIOUS_INJ_COUNT (type: esriFieldTypeInteger, alias: UNB_SUSP_SERIOUS_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNBELTED_OCC_COUNT (type: esriFieldTypeInteger, alias: UNBELTED_OCC_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNK_INJ_DEG_COUNT (type: esriFieldTypeInteger, alias: UNK_INJ_DEG_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNK_INJ_PER_COUNT (type: esriFieldTypeInteger, alias: UNK_INJ_PER_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• URBAN_AREA (type: esriFieldTypeInteger, alias: URBAN_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• URBAN_RURAL (type: esriFieldTypeInteger, alias: URBAN_RURAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VAN_COUNT (type: esriFieldTypeInteger, alias: VAN_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHICLE_COUNT (type: esriFieldTypeInteger, alias: VEHICLE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WEATHER1 (type: esriFieldTypeInteger, alias: WEATHER1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WEATHER2 (type: esriFieldTypeString, alias: WEATHER2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WORK_ZONE_IND (type: esriFieldTypeString, alias: WORK_ZONE_IND, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WORK_ZONE_LOC (type: esriFieldTypeDouble, alias: WORK_ZONE_LOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORK_ZONE_TYPE (type: esriFieldTypeDouble, alias: WORK_ZONE_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORKERS_PRES (type: esriFieldTypeString, alias: WORKERS_PRES, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WZ_CLOSE_DETOUR (type: esriFieldTypeString, alias: WZ_CLOSE_DETOUR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WZ_FLAGGER (type: esriFieldTypeString, alias: WZ_FLAGGER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WZ_LAW_OFFCR_IND (type: esriFieldTypeString, alias: WZ_LAW_OFFCR_IND, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WZ_LN_CLOSURE (type: esriFieldTypeString, alias: WZ_LN_CLOSURE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WZ_MOVING (type: esriFieldTypeString, alias: WZ_MOVING, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WZ_OTHER (type: esriFieldTypeString, alias: WZ_OTHER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WZ_SHLDER_MDN (type: esriFieldTypeString, alias: WZ_SHLDER_MDN, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WZ_WORKERS_INJ_KILLED (type: esriFieldTypeString, alias: WZ_WORKERS_INJ_KILLED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MAX_Youth (type: esriFieldTypeDouble, alias: MAX_Youth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashWeight (type: esriFieldTypeDouble, alias: CrashWeight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• crash_count (type: esriFieldTypeString, alias: crash_count, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• crash_count_num (type: esriFieldTypeDouble, alias: crash_count_num, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Youth_Score (type: esriFieldTypeInteger, alias: Youth_Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BikePed_Count (type: esriFieldTypeInteger, alias: BikePed_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BikePed_Score (type: esriFieldTypeInteger, alias: BikePed_Score, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: CoC Crashes
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/17/2023 2:20:42 PM

Schema Last Edit Date: 10/17/2023 2:20:42 PM

Data Last Edit Date: 10/17/2023 2:20:42 PM

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