Name: CrashData_Basic_Updated

Display Field: mpo_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 2311163

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8889567.8724
YMin: 4441123.3074
XMax: -8750949.5739
YMax: 4547260.6176
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"symbol":{"outline":{"color":[0,0,0,255],"width":1},"color":[0,38,176,255],"size":4,"yoffset":0,"xoffset":0,"angle":0,"style":"esriSMSCircle","type":"esriSMS"},"type":"simple"},"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:

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)
• document_n (type: esriFieldTypeInteger, alias: DOCUMENT_N, SQL Type: sqlTypeOther, nullable: true, editable: true)
• crash_year (type: esriFieldTypeString, alias: CRASH_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• crash_dt (type: esriFieldTypeDate, alias: CRASH_DT, SQL Type: sqlTypeOther, length: 29, nullable: true, editable: true)
• crash_mili (type: esriFieldTypeString, alias: CRASH_MILI, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• crash_seve (type: esriFieldTypeString, alias: CRASH_SEVE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• k_people (type: esriFieldTypeInteger, alias: K_PEOPLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• a_people (type: esriFieldTypeInteger, alias: A_PEOPLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• b_people (type: esriFieldTypeInteger, alias: B_PEOPLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• c_people (type: esriFieldTypeInteger, alias: C_PEOPLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• persons_in (type: esriFieldTypeInteger, alias: PERSONS_IN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pedestrian (type: esriFieldTypeInteger, alias: PEDESTRIAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pedestri_1 (type: esriFieldTypeInteger, alias: PEDESTRI_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• veh_count (type: esriFieldTypeInteger, alias: VEH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• collision_ (type: esriFieldTypeString, alias: COLLISION_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• weather_co (type: esriFieldTypeString, alias: WEATHER_CO, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• light_cond (type: esriFieldTypeString, alias: LIGHT_COND, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• roadway_su (type: esriFieldTypeString, alias: ROADWAY_SU, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• relation_t (type: esriFieldTypeString, alias: RELATION_T, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• roadway_al (type: esriFieldTypeString, alias: ROADWAY_AL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• roadway__1 (type: esriFieldTypeString, alias: ROADWAY__1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• roadway_de (type: esriFieldTypeString, alias: ROADWAY_DE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• roadway__2 (type: esriFieldTypeString, alias: ROADWAY__2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• intersecti (type: esriFieldTypeString, alias: INTERSECTI, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• traffic_co (type: esriFieldTypeString, alias: TRAFFIC_CO, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• trfc_ctrl_ (type: esriFieldTypeString, alias: TRFC_CTRL_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• work_zone_ (type: esriFieldTypeString, alias: WORK_ZONE_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• work_zone1 (type: esriFieldTypeString, alias: WORK_ZONE1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• work_zon_1 (type: esriFieldTypeString, alias: WORK_ZON_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• school_zon (type: esriFieldTypeString, alias: SCHOOL_ZON, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• first_harm (type: esriFieldTypeString, alias: FIRST_HARM, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• first_ha_1 (type: esriFieldTypeString, alias: FIRST_HA_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• alcohol_no (type: esriFieldTypeString, alias: ALCOHOL_NO, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• animal (type: esriFieldTypeString, alias: ANIMAL, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• belted_unb (type: esriFieldTypeString, alias: BELTED_UNB, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• bike_nonbi (type: esriFieldTypeString, alias: BIKE_NONBI, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• distracted (type: esriFieldTypeString, alias: DISTRACTED, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• drowsy_not (type: esriFieldTypeString, alias: DROWSY_NOT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• drug_nodru (type: esriFieldTypeString, alias: DRUG_NODRU, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• gr_nogr (type: esriFieldTypeString, alias: GR_NOGR, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• hitrun_not (type: esriFieldTypeString, alias: HITRUN_NOT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• lgtruck_no (type: esriFieldTypeString, alias: LGTRUCK_NO, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• motor_nonm (type: esriFieldTypeString, alias: MOTOR_NONM, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• ped_nonped (type: esriFieldTypeString, alias: PED_NONPED, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• speed_nots (type: esriFieldTypeString, alias: SPEED_NOTS, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• speed_diff (type: esriFieldTypeInteger, alias: SPEED_DIFF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rd_type (type: esriFieldTypeString, alias: RD_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• intersec_1 (type: esriFieldTypeString, alias: INTERSEC_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• senior_not (type: esriFieldTypeString, alias: SENIOR_NOT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• young_noty (type: esriFieldTypeString, alias: YOUNG_NOTY, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• mainline_y (type: esriFieldTypeString, alias: MAINLINE_Y, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• night (type: esriFieldTypeString, alias: NIGHT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• vdot_distr (type: esriFieldTypeString, alias: VDOT_DISTR, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• juris_code (type: esriFieldTypeString, alias: JURIS_CODE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• physical_j (type: esriFieldTypeString, alias: PHYSICAL_J, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• fun (type: esriFieldTypeString, alias: FUN, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• fac (type: esriFieldTypeString, alias: FAC, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• area_type (type: esriFieldTypeString, alias: AREA_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• system (type: esriFieldTypeString, alias: SYSTEM, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• vsp (type: esriFieldTypeString, alias: VSP, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ownership (type: esriFieldTypeString, alias: OWNERSHIP, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• plan_distr (type: esriFieldTypeString, alias: PLAN_DISTR, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• mpo_name (type: esriFieldTypeString, alias: MPO_NAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• rte_nm (type: esriFieldTypeString, alias: RTE_NM, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• rns_mp (type: esriFieldTypeDouble, alias: RNS_MP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• node (type: esriFieldTypeString, alias: NODE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• offset_ (type: esriFieldTypeDouble, alias: OFFSET, SQL Type: sqlTypeOther, nullable: true, editable: true)
• document_nbr (type: esriFieldTypeInteger, alias: DOCUMENT_NBR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• jurisdiction_revised (type: esriFieldTypeString, alias: Jurisdiction_Revised, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ped_a (type: esriFieldTypeInteger, alias: PED_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ped_k (type: esriFieldTypeInteger, alias: PED_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ped_b (type: esriFieldTypeInteger, alias: PED_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ped_c (type: esriFieldTypeInteger, alias: PED_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mcyc_a (type: esriFieldTypeInteger, alias: MCYC_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mcyc_k (type: esriFieldTypeInteger, alias: MCYC_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mcyc_b (type: esriFieldTypeInteger, alias: MCYC_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mcyc_c (type: esriFieldTypeInteger, alias: MCYC_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bike_a (type: esriFieldTypeInteger, alias: BIKE_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bike_k (type: esriFieldTypeInteger, alias: BIKE_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bike_b (type: esriFieldTypeInteger, alias: BIKE_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bike_c (type: esriFieldTypeInteger, alias: BIKE_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• young_a (type: esriFieldTypeInteger, alias: YOUNG_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• young_k (type: esriFieldTypeInteger, alias: YOUNG_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• young_b (type: esriFieldTypeInteger, alias: YOUNG_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• young_c (type: esriFieldTypeInteger, alias: YOUNG_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• old_a (type: esriFieldTypeInteger, alias: OLD_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• old_k (type: esriFieldTypeInteger, alias: OLD_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• old_b (type: esriFieldTypeInteger, alias: OLD_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• old_c (type: esriFieldTypeInteger, alias: OLD_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oldped_a (type: esriFieldTypeInteger, alias: OLDPED_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oldped_k (type: esriFieldTypeInteger, alias: OLDPED_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oldped_b (type: esriFieldTypeInteger, alias: OLDPED_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oldped_c (type: esriFieldTypeInteger, alias: OLDPED_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oldtot_a (type: esriFieldTypeInteger, alias: OLDTOT_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oldtot_k (type: esriFieldTypeInteger, alias: OLDTOT_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oldtot_b (type: esriFieldTypeInteger, alias: OLDTOT_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oldtot_c (type: esriFieldTypeInteger, alias: OLDTOT_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• op_a (type: esriFieldTypeInteger, alias: OP_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• op_k (type: esriFieldTypeInteger, alias: OP_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• op_b (type: esriFieldTypeInteger, alias: OP_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• op_c (type: esriFieldTypeInteger, alias: OP_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drink_a (type: esriFieldTypeInteger, alias: DRINK_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drink_k (type: esriFieldTypeInteger, alias: DRINK_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drink_b (type: esriFieldTypeInteger, alias: DRINK_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drink_c (type: esriFieldTypeInteger, alias: DRINK_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drug_a (type: esriFieldTypeInteger, alias: DRUG_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drug_k (type: esriFieldTypeInteger, alias: DRUG_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drug_b (type: esriFieldTypeInteger, alias: DRUG_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drug_c (type: esriFieldTypeInteger, alias: DRUG_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dist_a (type: esriFieldTypeInteger, alias: DIST_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dist_k (type: esriFieldTypeInteger, alias: DIST_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dist_b (type: esriFieldTypeInteger, alias: DIST_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dist_c (type: esriFieldTypeInteger, alias: DIST_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drwsy_a (type: esriFieldTypeInteger, alias: DRWSY_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drwsy_k (type: esriFieldTypeInteger, alias: DRWSY_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drwsy_b (type: esriFieldTypeInteger, alias: DRWSY_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drwsy_c (type: esriFieldTypeInteger, alias: DRWSY_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• imptot_a (type: esriFieldTypeInteger, alias: IMPTOT_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• imptot_k (type: esriFieldTypeInteger, alias: IMPTOT_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• imptot_b (type: esriFieldTypeInteger, alias: IMPTOT_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• imptot_c (type: esriFieldTypeInteger, alias: IMPTOT_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spd_a (type: esriFieldTypeInteger, alias: SPD_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spd_k (type: esriFieldTypeInteger, alias: SPD_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spd_b (type: esriFieldTypeInteger, alias: SPD_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spd_c (type: esriFieldTypeInteger, alias: SPD_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hvyveh_a (type: esriFieldTypeInteger, alias: HVYVEH_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hvyveh_k (type: esriFieldTypeInteger, alias: HVYVEH_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hvyveh_b (type: esriFieldTypeInteger, alias: HVYVEH_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hvyveh_c (type: esriFieldTypeInteger, alias: HVYVEH_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• int_a (type: esriFieldTypeInteger, alias: INT_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• int_k (type: esriFieldTypeInteger, alias: INT_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• int_b (type: esriFieldTypeInteger, alias: INT_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• int_c (type: esriFieldTypeInteger, alias: INT_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rd_a (type: esriFieldTypeInteger, alias: RD_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rd_k (type: esriFieldTypeInteger, alias: RD_K, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rd_b (type: esriFieldTypeInteger, alias: RD_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rd_c (type: esriFieldTypeInteger, alias: RD_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• imp_drive (type: esriFieldTypeString, alias: IMP_DRIVE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: CrashData_Basic_Updated
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/15/2024 8:04:51 PM

Schema Last Edit Date: 8/1/2024 10:39:20 PM

Data Last Edit Date: 8/1/2024 10:49:32 PM

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