Name: Final MSA Scoring

Display Field: MnDOT_Roadway_Routes_in_Minnesota_ROUTE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 513825.657692572
YMin: 136235.477797101
XMax: 547193.642398325
YMax: 194980.569194089
Spatial Reference: 103734 (103734)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,163,118,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

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)
• MnDOT_Roadway_Routes_in_Minnesota_ROUTE_ID (type: esriFieldTypeString, alias: ROUTE_ID, SQL Type: sqlTypeOther, length: 26, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_ROUTE_NAME (type: esriFieldTypeString, alias: ROUTE_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_ROUTE_LABE (type: esriFieldTypeString, alias: ROUTE_LABE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_ROUTE_SIGN (type: esriFieldTypeString, alias: ROUTE_SIGN, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_ROUTE_SYST (type: esriFieldTypeString, alias: ROUTE_SYST, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_OWNERSHIP (type: esriFieldTypeString, alias: OWNERSHIP, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_ALT_S (type: esriFieldTypeString, alias: ALT_STREET_NAME2, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_ALT_1 (type: esriFieldTypeString, alias: ALT_STREET_NAME1, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_MSA_M (type: esriFieldTypeSingle, alias: MSA_MILEAGE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_STREE (type: esriFieldTypeDate, alias: STREET_CLINE_REVD, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_STR_1 (type: esriFieldTypeDate, alias: STREET_CLINE_CREATED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_GBSID (type: esriFieldTypeInteger, alias: GBSID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_COMME (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_SOURC (type: esriFieldTypeDate, alias: SOURCE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_DIGIT (type: esriFieldTypeString, alias: DIGITIZING_SOURCE, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_SPEED (type: esriFieldTypeInteger, alias: SPEED_LIM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_FUNC_ (type: esriFieldTypeString, alias: FUNC_CLASS, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_TRUCK (type: esriFieldTypeString, alias: TRUCK_ROUTE_TYPE, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_BUS_R (type: esriFieldTypeString, alias: BUS_ROUTE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_SNOW_ (type: esriFieldTypeString, alias: SNOW_EMERGENCY_ROUTE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_POTHO (type: esriFieldTypeString, alias: POTHOLE_MAINTENANCE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_STR_2 (type: esriFieldTypeString, alias: STREET_MAINT_DIST, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_BRIDG (type: esriFieldTypeString, alias: BRIDGE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_TURNB (type: esriFieldTypeString, alias: TURNBACK, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_SYSTE (type: esriFieldTypeString, alias: SYSTEM_MILEAGE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_SEGME (type: esriFieldTypeDouble, alias: SEGMENT_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_JURIS (type: esriFieldTypeString, alias: JURISDICTION, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_US_RO (type: esriFieldTypeString, alias: US_ROUTE_NO2, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_US__1 (type: esriFieldTypeString, alias: US_ROUTE_NO1, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_ROUTE (type: esriFieldTypeString, alias: ROUTE_TYPE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_ROU_1 (type: esriFieldTypeString, alias: ROUTE_NO, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_STR_3 (type: esriFieldTypeString, alias: STREET_T_NAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_STR_4 (type: esriFieldTypeString, alias: STREET_F_NAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_STR_5 (type: esriFieldTypeString, alias: STREET_O_NAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_OFT (type: esriFieldTypeString, alias: OFT, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_SYMBO (type: esriFieldTypeString, alias: SYMBOL_NAME, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_R_ZIP (type: esriFieldTypeString, alias: R_ZIPCODE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_L_ZIP (type: esriFieldTypeString, alias: L_ZIPCODE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_R_CIT (type: esriFieldTypeString, alias: R_CITY_CODE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_STR_6 (type: esriFieldTypeString, alias: STREET_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MnDOT_Roadway_Routes_in_Minnesota_selection_AddSpatialJoin_AADT_ (type: esriFieldTypeInteger, alias: AADT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HighCrashScore (type: esriFieldTypeInteger, alias: High Crash Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TEPScore (type: esriFieldTypeInteger, alias: Tep Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SchoolLibraryScore (type: esriFieldTypeInteger, alias: School and Library Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransitScore (type: esriFieldTypeInteger, alias: Transit Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NearPark (type: esriFieldTypeInteger, alias: Near Park, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WRFYScore (type: esriFieldTypeInteger, alias: WRFY Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AAAScore (type: esriFieldTypeInteger, alias: AAAScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PPNScore (type: esriFieldTypeInteger, alias: PPNScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MSAScore (type: esriFieldTypeInteger, alias: MSA Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OverallCrashWeight (type: esriFieldTypeDouble, alias: Overall Injury Crash Concentration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OverallCrashCount (type: esriFieldTypeInteger, alias: Overall Crash Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIS (type: esriFieldTypeInteger, alias: High Injury Street, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length_1 (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length_12 (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Join_Count (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Final_MSA_Traffic_Volumes_and_Speed_Data_AddSpatialJoin_CURRENT_ (type: esriFieldTypeSmallInteger, alias: MNDOT_CURRENT_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Final_MSA_Traffic_Volumes_and_Speed_Data_AddSpatialJoin_CURRENT1 (type: esriFieldTypeDouble, alias: MNDOT_CURRENT_VOLUME, SQL Type: sqlTypeOther, nullable: true, editable: true)
• c2079120_MSA_Street_Tr_Merge2_Average_Daily_Segment_Traffic__ (type: esriFieldTypeDouble, alias: Average Daily Segment Traffic (StL Volume), SQL Type: sqlTypeOther, nullable: true, editable: true)
• c2079120_MSA_Street_Tr_Merge2_VolumeDiff (type: esriFieldTypeInteger, alias: Volume Difference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Final_MSA_Traffic_Volumes_and_Speed_Data_AddSpatialJoin_5_SpeedL (type: esriFieldTypeInteger, alias: SpeedLimit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• c2079120_MSA_Street_Tr_Merge2_Avg_Segment_Speed__mph_ (type: esriFieldTypeDouble, alias: Avg Segment Speed (mph), SQL Type: sqlTypeOther, nullable: true, editable: true)
• c2079120_MSA_Street_Tr_Merge2_DiffinSpeed (type: esriFieldTypeInteger, alias: Difference in Speed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Final_MSA_Traffic_Volumes_and_Speed_Data_AddSpatialJoin_7_OFT (type: esriFieldTypeString, alias: OFT, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• Shape__Length_12_13 (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID_12 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Join_Count_1 (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID_1 (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalMSATraffi_SplitLineAtPo3_Final_MSA_Traffic_Volumes_and_Sp_3 (type: esriFieldTypeSmallInteger, alias: MNDOT_CURRENT_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalMSATraffi_SplitLineAtPo3_Final_MSA_Traffic_Volumes_and_Sp_4 (type: esriFieldTypeDouble, alias: MNDOT_CURRENT_VOLUME, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalMSATraffi_SplitLineAtPo3_c2079120_MSA_Street_Tr_Merge2_Aver (type: esriFieldTypeDouble, alias: Average Daily Segment Traffic (StL Volume), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalMSATraffi_SplitLineAtPo3_c2079120_MSA_Street_Tr_Merge2_Volu (type: esriFieldTypeInteger, alias: Volume Difference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalMSATraffi_SplitLineAtPo3_Final_MSA_Traffic_Volumes_and_Sp_8 (type: esriFieldTypeInteger, alias: SpeedLimit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalMSATraffi_SplitLineAtPo3_c2079120_MSA_Street_Tr_Merge2_Avg_ (type: esriFieldTypeDouble, alias: Avg Segment Speed (mph), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalMSATraffi_SplitLineAtPo3_c2079120_MSA_Street_Tr_Merge2_Diff (type: esriFieldTypeInteger, alias: Difference in Average Speed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalMSATraffi_SplitLineAtPo3_AddSpatialJoin_PreliminaryMSAScori (type: esriFieldTypeString, alias: OFT, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• Shape__Length_12_13_14 (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VolumeScore (type: esriFieldTypeInteger, alias: Traffic Volume Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SpeedScore (type: esriFieldTypeInteger, alias: Speed Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PeopleGenScore (type: esriFieldTypeInteger, alias: People Generator Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CityPriScore (type: esriFieldTypeInteger, alias: City Priority Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID_12_13 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Join_Count_12 (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID_12 (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PlannedImprovements (type: esriFieldTypeInteger, alias: Planned Improvements, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length_12_13_14_15 (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Eligibility (type: esriFieldTypeInteger, alias: Eligibility, SQL Type: sqlTypeOther, nullable: true, editable: true)
• speeddifferencenotaverage (type: esriFieldTypeInteger, alias: 85th Percentile Speed Difference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID_12_13_14 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Join_Count_12_13 (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID_12_13 (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FinalMSATraffi_SplitLineAtPo3_c2079120_MSA_Street_Tr_Merge2_F85t (type: esriFieldTypeDouble, alias: 85th Speed Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length_12_13_14_15_16 (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Final MSA Scoring
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/14/2026 9:13:18 PM

Schema Last Edit Date: 9/14/2026 9:13:18 PM

Data Last Edit Date: 9/14/2026 9:13:18 PM

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