20250116 07254900 1.0 FALSE McKinneyCrashes 2498157.017820 2565628.178843 7096859.669476 7156636.663771 1 002 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.8'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,1968500.0],PARAMETER[&quot;False_Northing&quot;,6561666.666666666],PARAMETER[&quot;Central_Meridian&quot;,-98.5],PARAMETER[&quot;Standard_Parallel_1&quot;,32.13333333333333],PARAMETER[&quot;Standard_Parallel_2&quot;,33.96666666666667],PARAMETER[&quot;Latitude_Of_Origin&quot;,31.66666666666667],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2276]]</WKT><XOrigin>-123407699.99991921</XOrigin><YOrigin>-86123499.999934509</YOrigin><XYScale>15624.999985448077</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0005120000004768374</XYTolerance><ZTolerance>2.0000000000000002e-05</ZTolerance><MTolerance>2.0000000000000002e-05</MTolerance><HighPrecision>true</HighPrecision><WKID>102738</WKID><LatestWKID>2276</LatestWKID></ProjectedCoordinateSystem> 20250811 11432300 20250811 11432300 ItemDescription 150000000 5000 McKinneyCrashes 2020-2024 Crash data for McKinney CSAP. <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This is the final (merged) data set for crashes within McKinney and those in Prosper/Frisco that share a jurisdictional boundary for 2020-2024. Includes systemic variables.</SPAN></P></DIV></DIV></DIV> Crash Data McKinney CSAP CRIS Data provided by Fehr & Peers. Stephen Spana, PhD, EIT Transportation Planner S.Spana@fehrandpeers.com (689) 206-0081 Version 6.2 (Build 9200) ; Esri ArcGIS 10.9.1.28388 1 -96.769752 -96.545757 33.290030 33.122503 McKinneyCrashes Feature Class 7778 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 4 0 0 Feature geometry. Esri Coordinates defining the features. Field1 Field1 Integer 4 10 0 CRASH_ID CRASH_ID Integer 4 10 0 CRASH_FATAL_FL CRASH_FATAL_FL String 1073741822 0 0 CMV_INVOLV_FL CMV_INVOLV_FL String 1073741822 0 0 SCHL_BUS_FL SCHL_BUS_FL String 1073741822 0 0 RR_RELAT_FL RR_RELAT_FL String 1073741822 0 0 MEDICAL_ADVISORY_FL MEDICAL_ADVISORY_FL String 1073741822 0 0 AMEND_SUPP_FL AMEND_SUPP_FL String 1073741822 0 0 ACTIVE_SCHOOL_ZONE_FL ACTIVE_SCHOOL_ZONE_FL String 1073741822 0 0 CRASH_DATE CRASH_DATE Date 8 0 0 CRASH_TIME CRASH_TIME String 1073741822 0 0 CASE_ID CASE_ID String 1073741822 0 0 LOCAL_USE LOCAL_USE String 1073741822 0 0 RPT_CRIS_CNTY_ID RPT_CRIS_CNTY_ID Integer 4 10 0 RPT_CITY_ID RPT_CITY_ID Integer 4 10 0 RPT_OUTSIDE_CITY_LIMIT_FL RPT_OUTSIDE_CITY_LIMIT_FL String 1073741822 0 0 THOUSAND_DAMAGE_FL THOUSAND_DAMAGE_FL String 1073741822 0 0 RPT_LATITUDE RPT_LATITUDE Double 8 38 8 RPT_LONGITUDE RPT_LONGITUDE Double 8 38 8 RPT_RDWY_SYS_ID RPT_RDWY_SYS_ID String 1073741822 0 0 RPT_HWY_NUM RPT_HWY_NUM Integer 4 10 0 RPT_HWY_SFX RPT_HWY_SFX String 1073741822 0 0 RPT_ROAD_PART_ID RPT_ROAD_PART_ID String 1073741822 0 0 RPT_BLOCK_NUM RPT_BLOCK_NUM Integer 4 10 0 RPT_STREET_PFX RPT_STREET_PFX String 1073741822 0 0 RPT_STREET_NAME RPT_STREET_NAME String 1073741822 0 0 RPT_STREET_SFX RPT_STREET_SFX String 1073741822 0 0 PRIVATE_DR_FL PRIVATE_DR_FL String 1073741822 0 0 TOLL_ROAD_FL TOLL_ROAD_FL String 1073741822 0 0 CRASH_SPEED_LIMIT CRASH_SPEED_LIMIT Integer 4 10 0 ROAD_CONSTR_ZONE_FL ROAD_CONSTR_ZONE_FL String 1073741822 0 0 ROAD_CONSTR_ZONE_WRKR_FL ROAD_CONSTR_ZONE_WRKR_FL String 1073741822 0 0 RPT_STREET_DESC RPT_STREET_DESC String 1073741822 0 0 AT_INTRSCT_FL AT_INTRSCT_FL String 1073741822 0 0 RPT_SEC_RDWY_SYS_ID RPT_SEC_RDWY_SYS_ID String 1073741822 0 0 RPT_SEC_HWY_NUM RPT_SEC_HWY_NUM Integer 4 10 0 RPT_SEC_HWY_SFX RPT_SEC_HWY_SFX String 1073741822 0 0 RPT_SEC_ROAD_PART_ID RPT_SEC_ROAD_PART_ID String 1073741822 0 0 RPT_SEC_BLOCK_NUM RPT_SEC_BLOCK_NUM Integer 4 10 0 RPT_SEC_STREET_PFX RPT_SEC_STREET_PFX String 1073741822 0 0 RPT_SEC_STREET_NAME RPT_SEC_STREET_NAME String 1073741822 0 0 RPT_SEC_STREET_SFX RPT_SEC_STREET_SFX String 1073741822 0 0 RPT_REF_MARK_OFFSET_AMT RPT_REF_MARK_OFFSET_AMT Integer 4 10 0 RPT_REF_MARK_DIST_UOM RPT_REF_MARK_DIST_UOM String 1073741822 0 0 RPT_REF_MARK_DIR RPT_REF_MARK_DIR String 1073741822 0 0 RPT_REF_MARK_NBR RPT_REF_MARK_NBR Integer 4 10 0 RPT_SEC_STREET_DESC RPT_SEC_STREET_DESC String 1073741822 0 0 RPT_CROSSINGNUMBER RPT_CROSSINGNUMBER String 1073741822 0 0 WTHR_COND_ID WTHR_COND_ID String 1073741822 0 0 LIGHT_COND_ID LIGHT_COND_ID String 1073741822 0 0 ENTR_ROAD_ID ENTR_ROAD_ID Integer 4 10 0 ROAD_TYPE_ID ROAD_TYPE_ID String 1073741822 0 0 ROAD_ALGN_ID ROAD_ALGN_ID String 1073741822 0 0 SURF_COND_ID SURF_COND_ID String 1073741822 0 0 TRAFFIC_CNTL_ID TRAFFIC_CNTL_ID String 1073741822 0 0 INVESTIGAT_NOTIFY_TIME INVESTIGAT_NOTIFY_TIME String 1073741822 0 0 INVESTIGAT_NOTIFY_METH INVESTIGAT_NOTIFY_METH String 1073741822 0 0 INVESTIGAT_ARRV_TIME INVESTIGAT_ARRV_TIME String 1073741822 0 0 REPORT_DATE REPORT_DATE Date 8 0 0 INVESTIGAT_COMP_FL INVESTIGAT_COMP_FL String 1073741822 0 0 ORI_NUMBER ORI_NUMBER String 1073741822 0 0 INVESTIGAT_AGENCY_ID INVESTIGAT_AGENCY_ID Integer 4 10 0 INVESTIGAT_AREA_ID INVESTIGAT_AREA_ID Integer 4 10 0 INVESTIGAT_DISTRICT_ID INVESTIGAT_DISTRICT_ID Integer 4 10 0 INVESTIGAT_REGION_ID INVESTIGAT_REGION_ID Integer 4 10 0 BRIDGE_DETAIL_ID BRIDGE_DETAIL_ID String 1073741822 0 0 HARM_EVNT_ID HARM_EVNT_ID String 1073741822 0 0 INTRSCT_RELAT_ID INTRSCT_RELAT_ID String 1073741822 0 0 FHE_COLLSN_ID FHE_COLLSN_ID String 1073741822 0 0 OBJ_STRUCK_ID OBJ_STRUCK_ID String 1073741822 0 0 OTHR_FACTR_ID OTHR_FACTR_ID String 1073741822 0 0 ROAD_PART_ADJ_ID ROAD_PART_ADJ_ID String 1073741822 0 0 ROAD_CLS_ID ROAD_CLS_ID String 1073741822 0 0 ROAD_RELAT_ID ROAD_RELAT_ID String 1073741822 0 0 PHYS_FEATR_1_ID PHYS_FEATR_1_ID String 1073741822 0 0 PHYS_FEATR_2_ID PHYS_FEATR_2_ID String 1073741822 0 0 CNTY_ID CNTY_ID String 1073741822 0 0 CITY_ID CITY_ID String 1073741822 0 0 LATITUDE LATITUDE Double 8 38 8 LONGITUDE LONGITUDE Double 8 38 8 HWY_SYS HWY_SYS String 1073741822 0 0 HWY_NBR HWY_NBR Integer 4 10 0 HWY_SFX HWY_SFX String 1073741822 0 0 DFO DFO Double 8 38 8 STREET_NAME STREET_NAME String 1073741822 0 0 STREET_NBR STREET_NBR Integer 4 10 0 CONTROL CONTROL Integer 4 10 0 SECTION SECTION Integer 4 10 0 MILEPOINT MILEPOINT Double 8 38 8 REF_MARK_NBR REF_MARK_NBR Integer 4 10 0 REF_MARK_DISPL REF_MARK_DISPL Double 8 38 8 HWY_SYS_2 HWY_SYS_2 String 1073741822 0 0 HWY_NBR_2 HWY_NBR_2 Integer 4 10 0 HWY_SFX_2 HWY_SFX_2 String 1073741822 0 0 STREET_NAME_2 STREET_NAME_2 String 1073741822 0 0 STREET_NBR_2 STREET_NBR_2 String 1073741822 0 0 CONTROL_2 CONTROL_2 Integer 4 10 0 SECTION_2 SECTION_2 Integer 4 10 0 MILEPOINT_2 MILEPOINT_2 Double 8 38 8 TXDOT_RPTABLE_FL TXDOT_RPTABLE_FL String 1073741822 0 0 ONSYS_FL ONSYS_FL String 1073741822 0 0 RURAL_FL RURAL_FL String 1073741822 0 0 CRASH_SEV_ID CRASH_SEV_ID String 1073741822 0 0 POP_GROUP_ID POP_GROUP_ID String 1073741822 0 0 LOCATED_FL LOCATED_FL String 1073741822 0 0 DAY_OF_WEEK DAY_OF_WEEK String 1073741822 0 0 HWY_DSGN_LANE_ID HWY_DSGN_LANE_ID String 1073741822 0 0 HWY_DSGN_HRT_ID HWY_DSGN_HRT_ID String 1073741822 0 0 HP_SHLDR_LEFT HP_SHLDR_LEFT Integer 4 10 0 HP_SHLDR_RIGHT HP_SHLDR_RIGHT Integer 4 10 0 HP_MEDIAN_WIDTH HP_MEDIAN_WIDTH Integer 4 10 0 BASE_TYPE_ID BASE_TYPE_ID Integer 4 10 0 NBR_OF_LANE NBR_OF_LANE Integer 4 10 0 ROW_WIDTH_USUAL ROW_WIDTH_USUAL String 1073741822 0 0 ROADBED_WIDTH ROADBED_WIDTH Integer 4 10 0 SURF_WIDTH SURF_WIDTH Integer 4 10 0 SURF_TYPE_ID SURF_TYPE_ID String 1073741822 0 0 CURB_TYPE_LEFT_ID CURB_TYPE_LEFT_ID String 1073741822 0 0 CURB_TYPE_RIGHT_ID CURB_TYPE_RIGHT_ID String 1073741822 0 0 SHLDR_TYPE_LEFT_ID SHLDR_TYPE_LEFT_ID String 1073741822 0 0 SHLDR_WIDTH_LEFT SHLDR_WIDTH_LEFT Integer 4 10 0 SHLDR_USE_LEFT_ID SHLDR_USE_LEFT_ID String 1073741822 0 0 SHLDR_TYPE_RIGHT_ID SHLDR_TYPE_RIGHT_ID String 1073741822 0 0 SHLDR_WIDTH_RIGHT SHLDR_WIDTH_RIGHT Integer 4 10 0 SHLDR_USE_RIGHT_ID SHLDR_USE_RIGHT_ID String 1073741822 0 0 MEDIAN_TYPE_ID MEDIAN_TYPE_ID String 1073741822 0 0 MEDIAN_WIDTH MEDIAN_WIDTH Integer 4 10 0 RURAL_URBAN_TYPE_ID RURAL_URBAN_TYPE_ID Integer 4 10 0 FUNC_SYS_ID FUNC_SYS_ID String 1073741822 0 0 ADT_CURNT_AMT ADT_CURNT_AMT Integer 4 10 0 ADT_CURNT_YEAR ADT_CURNT_YEAR Integer 4 10 0 ADT_ADJ_CURNT_AMT ADT_ADJ_CURNT_AMT Integer 4 10 0 PCT_SINGLE_TRK_ADT PCT_SINGLE_TRK_ADT Double 8 38 8 PCT_COMBO_TRK_ADT PCT_COMBO_TRK_ADT Double 8 38 8 TRK_AADT_PCT TRK_AADT_PCT Double 8 38 8 CURVE_TYPE_ID CURVE_TYPE_ID String 1073741822 0 0 CURVE_LNGTH CURVE_LNGTH String 1073741822 0 0 CD_DEGR CD_DEGR String 1073741822 0 0 DELTA_LEFT_RIGHT_ID DELTA_LEFT_RIGHT_ID String 1073741822 0 0 DD_DEGR DD_DEGR String 1073741822 0 0 FEATURE_CROSSED FEATURE_CROSSED String 1073741822 0 0 STRUCTURE_NUMBER STRUCTURE_NUMBER String 1073741822 0 0 I_R_MIN_VERT_CLEAR I_R_MIN_VERT_CLEAR String 1073741822 0 0 APPROACH_WIDTH APPROACH_WIDTH String 1073741822 0 0 BRIDGE_MEDIAN_ID BRIDGE_MEDIAN_ID String 1073741822 0 0 BRIDGE_LOADING_TYPE_ID BRIDGE_LOADING_TYPE_ID String 1073741822 0 0 BRIDGE_LOADING_IN_1000_LBS BRIDGE_LOADING_IN_1000_LBS String 1073741822 0 0 BRIDGE_SRVC_TYPE_ON_ID BRIDGE_SRVC_TYPE_ON_ID String 1073741822 0 0 BRIDGE_SRVC_TYPE_UNDER_ID BRIDGE_SRVC_TYPE_UNDER_ID String 1073741822 0 0 CULVERT_TYPE_ID CULVERT_TYPE_ID String 1073741822 0 0 ROADWAY_WIDTH ROADWAY_WIDTH String 1073741822 0 0 DECK_WIDTH DECK_WIDTH String 1073741822 0 0 BRIDGE_DIR_OF_TRAFFIC_ID BRIDGE_DIR_OF_TRAFFIC_ID String 1073741822 0 0 BRIDGE_RTE_STRUCT_FUNC_ID BRIDGE_RTE_STRUCT_FUNC_ID String 1073741822 0 0 BRIDGE_IR_STRUCT_FUNC_ID BRIDGE_IR_STRUCT_FUNC_ID String 1073741822 0 0 CROSSINGNUMBER CROSSINGNUMBER String 1073741822 0 0 RRCO RRCO String 1073741822 0 0 POSCROSSING_ID POSCROSSING_ID String 1073741822 0 0 WDCODE_ID WDCODE_ID String 1073741822 0 0 STANDSTOP STANDSTOP String 1073741822 0 0 YIELD YIELD String 1073741822 0 0 SUS_SERIOUS_INJRY_CNT SUS_SERIOUS_INJRY_CNT Integer 4 10 0 NONINCAP_INJRY_CNT NONINCAP_INJRY_CNT Integer 4 10 0 POSS_INJRY_CNT POSS_INJRY_CNT Integer 4 10 0 NON_INJRY_CNT NON_INJRY_CNT Integer 4 10 0 UNKN_INJRY_CNT UNKN_INJRY_CNT Integer 4 10 0 TOT_INJRY_CNT TOT_INJRY_CNT Integer 4 10 0 DEATH_CNT DEATH_CNT Integer 4 10 0 MPO_ID MPO_ID Integer 4 10 0 INVESTIGAT_SERVICE_ID INVESTIGAT_SERVICE_ID String 1073741822 0 0 INVESTIGAT_DA_ID INVESTIGAT_DA_ID String 1073741822 0 0 INVESTIGATOR_NARRATIVE INVESTIGATOR_NARRATIVE String 1073741822 0 0 NEAR_TRAUMA_CENTER_ID NEAR_TRAUMA_CENTER_ID Integer 4 10 0 NEAR_TRAUMA_CENTER_DISTANCE NEAR_TRAUMA_CENTER_DISTANCE Double 8 38 8 TXDOT_DISTRICT_ID TXDOT_DISTRICT_ID Integer 4 10 0 SECONDARY_CRASH_FL SECONDARY_CRASH_FL String 1073741822 0 0 RPT_DIR_TRAFFIC RPT_DIR_TRAFFIC String 1073741822 0 0 RPT_SEC_SPEED_LIMIT RPT_SEC_SPEED_LIMIT String 1073741822 0 0 INVESTIGAT_TIME_RWY_CLRD INVESTIGAT_TIME_RWY_CLRD String 1073741822 0 0 INVESTIGAT_TIME_SCN_CLRD INVESTIGAT_TIME_SCN_CLRD String 1073741822 0 0 INVESTIGAT_NOTIFY_DATE INVESTIGAT_NOTIFY_DATE String 1073741822 0 0 INVESTIGAT_ARRV_DATE INVESTIGAT_ARRV_DATE String 1073741822 0 0 INVESTIGAT_DATE_RWY_CLRD INVESTIGAT_DATE_RWY_CLRD String 1073741822 0 0 INVESTIGAT_DATE_SCN_CLRD INVESTIGAT_DATE_SCN_CLRD String 1073741822 0 0 P_YEAR P_YEAR Integer 4 10 0 P_MONTH P_MONTH Integer 4 10 0 P_DOW_INT P_DOW_INT Integer 4 10 0 P_HOUR P_HOUR Integer 4 10 0 P_HOUR_BIN P_HOUR_BIN Integer 4 10 0 P_HOUR_BIN_DESC P_HOUR_BIN_DESC String 1073741822 0 0 P_NOTIFY_TO_ARRIVE P_NOTIFY_TO_ARRIVE Integer 4 10 0 P_KSI P_KSI Integer 4 10 0 UNIT_DESC_ID UNIT_DESC_ID String 1073741822 0 0 VEH_BODY_STYL_ID VEH_BODY_STYL_ID String 1073741822 0 0 P_CRASH_MODE P_CRASH_MODE String 1073741822 0 0 P_PED_KSI P_PED_KSI Integer 4 10 0 P_BIKE_KSI P_BIKE_KSI Integer 4 10 0 P_MC_KSI P_MC_KSI Integer 4 10 0 P_MV_KSI P_MV_KSI Integer 4 10 0 P_PU_SUV_FLG P_PU_SUV_FLG Integer 4 10 0 P_EMG_VEH_FLG P_EMG_VEH_FLG Integer 4 10 0 P_GC_NEV_FLG P_GC_NEV_FLG Integer 4 10 0 P_CRASH_TYPE P_CRASH_TYPE String 1073741822 0 0 P_LIMITED_ACCESS P_LIMITED_ACCESS SmallInteger 2 5 0 TRVL_DIR_DESC TRVL_DIR_DESC String 1073741822 0 0 CONTRIB_FACTR_1_ID CONTRIB_FACTR_1_ID String 1073741822 0 0 GEOLOCATED GEOLOCATED Integer 4 10 0 SHARED_MCKINNEY SHARED_MCKINNEY Integer 4 10 0 NUM_LN_UPD NUM_LN_UPD SmallInteger 2 5 0 SPD_LM_UPD SPD_LM_UPD SmallInteger 2 5 0 FC_CLASS_INT FC_CLASS_INT SmallInteger 2 5 0 NUM_LN_BIN NUM_LN_BIN SmallInteger 2 5 0 SPEED_BIN SPEED_BIN SmallInteger 2 5 0 Sidewalks Sidewalks SmallInteger 2 5 0 BIKE_BLVD BIKE_BLVD SmallInteger 2 5 0 GUARDRAIL GUARDRAIL SmallInteger 2 5 0 SCHOOL_ZONE SCHOOL_ZONE SmallInteger 2 5 0 School School String 50 0 0 Times Times String 50 0 0 TOP_PAC TOP_PAC SmallInteger 2 5 0 TOP_BAC TOP_BAC SmallInteger 2 5 0 Y2021VolumeTotal Y2021VolumeTotal Integer 4 10 0 VOL_BIN VOL_BIN SmallInteger 2 5 0 SHARED_MCKINNEY_1 SHARED_MCKINNEY Integer 4 10 0 CONTRIB_FACTR_1_ID_AGG CONTRIB_FACTR_1_ID_AGG String 1073741822 0 0 CRASH_DURING_SZ_HOURS CRASH_DURING_SZ_HOURS SmallInteger 2 5 0 P_CRASH_SEV_ID_INT P_CRASH_SEV_ID_INT SmallInteger 2 5 0 P_MODE_INT P_MODE_INT SmallInteger 2 5 0 P_CRASH_TYPE_INT P_CRASH_TYPE_INT SmallInteger 2 5 0 SIG_INT SIG_INT SmallInteger 2 5 0 Feature Class dataset EPSG 5.3(9.0.0) 7778 Simple FALSE 7778 TRUE FALSE 20250811