Maryland/Functional Class Archived Project

From OpenStreetMap Wiki
Jump to navigation Jump to search

Draft effort to standardize OSM roadway classification based on government functional classification (F.C.) .


Planning with Functional Class, Access Control

Planning notes from 2016 effort between Elliott and Mike.

Tables to involve

Table Role Why
SHACenterline83ft Master The centerline file
AccessType Child Tells the access control for a segment
FunctionalClass Child Gives the functional class

These should do. The other tables (NHS, Gov Control, Fed Aid, Admin Class) could come in handy for putting in attributes but KISS for the join

Joining

Keep only matching, since we wouldn't want any extra orphan joined data to deal with.

Results

Now that the data is joined, let's summarize the results

Query: SHA_LINE_FUNCCLASS_MD_2015.FUNC_CL = X AND SHA_LINE_ACCESSTYPE_MD_2015.ACCESS_TYPE= X

FUNC_CL ACCESS_TYPE Description Count OSM Issue
= = Total (items with both values) 276882 =
1 1 Rural Interstate w/ full access control 470 motorway
2 1 Rural Principal Arterial (Other) w/ full access control 58 trunk Not really full ac
2 2 Rural Principal Arterial (Other) w/ partial access control 235 trunk
2 3 Rural Principal Arterial (Other) w/ no access control 1162 primary
6 2 Rural Minor Arterial w/ partial access control 248 primary
6 3 Rural Minor Arterial w/ no access control 2869 secondary
7 2 Rural Major Collector w/ partial access control 63 tertiary
7 3 Rural Major Collector w/ no access control 5245 tertiary
8 3 Rural Minor Collector w/ no access control 4958 unclassified
9 3 Rural Local w/ no access control 35763 residential
11 1 Urban Interstate w/ full access control 1567 motorway
12 1 Urban Principal Arterial (Other Freeways and Expressways) w/ full access control 513 motorway
12 2 Urban Principal Arterial (Other Freeways and Expressways) w/ partial access control 770 trunk
12 3 Urban Principal Arterial (Other Freeways and Expressways) w/ no access control 175 primary
14 1 Urban Principal Arterial (Other) w/ full access control 31 trunk
14 2 Urban Principal Arterial (Other) w/ partial access control 656 primary
14 3 Urban Principal Arterial (Other) w/ no access control 10001 primary
16 2 Urban Minor Arterial w/ partial access control 124 primary assumed
16 3 Urban Minor Arterial w/ no access control 17181 secondary
17 1 Urban Major Collector w/ full access control 3 secondary
17 3 Urban Major Collector w/ no access control 19209 tertiary
18 3 Urban Minor Collector w/ no access control 662 unclassified
19 1 Urban Local w/ full access control 5 residential
19 2 Urban Local w/ partial access control 21 residential
19 3 Urban Local w/ no access control 174893 residential


Here are some examples to go with the findings

Rural Principal Arterial (Other) w/ full access control

  • US 50 in Dorchester County Only

Rural Principal Arterial (Other) w/ partial access control

  • US 301 in QA Co
  • MD 4 in AA Co
  • US 13 somerset county south to MD line
  • Md 404 Caroline and east
  • US 340 in Washington Co

Rural Principal Arterial (Other) w/ no access control - primary

  • MD 140 and US 1 in BaCo
  • All of US 1 except from middle of Susquhanna river north
  • US 222 Cecil
  • MD 231
  • 40 past the split with 68
  • MD / US 219
  • US 522 (keep trunk)
  • US 50 in Talbot and QA (trunk)
  • 404 in QA (keep)
  • 228 (trunk)
    • Make 5 Business primary

Rural Minor Arterial w/ partial access control

  • US 220 (primary)
  • MD 194 fred co (primary)
  • MD 165 in Harford
  • MD 715

Rural Minor Arterial w/ no access control

First_ID_PREFIX ID_RTE_NO First_COUNTY_NAME First_ROADNAMESHA
MD 6 CHARLES CHARLES ST
MD 12 WORCESTER CHURCH ST Change Church Street to secondary in Snow Hill
MD 16 DORCHESTER CAMBRIDGE AVE
CO 24 BALTIMORE MT CARMEL RD
MD 27 CARROLL LIBERTY ST Keep primary
MD 28 FREDERICK CLAY ST Keep primary
MD 31 FREDERICK NEW WINDSOR RD
MD 32 HOWARD PATUXENT PKWY Keep as is
MD 39 GARRETT HUTTON RD Keep primary because of connection
MD 45 BALTIMORE YORK RD
US 50 GARRETT GEORGE WASHINGTON HWY
MD 51 ALLEGANY INDUSTRIAL BLVD
MD 60 WASHINGTON LEITERSBURG PIKE
MD 64 WASHINGTON JEFFERSON BLVD
MD 67 WASHINGTON ROHRERSVILLE RD
MD 97 CARROLL LITTLESTOWN PIKE
US 113 WORCESTER E MARKET ST
MD 135 GARRETT BLOOMINGTON RD
MD 137 BALTIMORE MT CARMEL RD
MD 138 BALTIMORE MONKTON RD
MD 146 BALTIMORE DULANEY VALLEY RD
MD 194 CARROLL FRANCIS SCOTT KEY HWY
MD 213 CECIL AUGUSTINE HERMAN HWY
MD 214 PRINCE GEORGE'S CENTRAL AVE
MD 234 CHARLES BUDDS CREEK RD
MD 236 ST. MARY'S THOMPSON CORNER RD
MD 300 QUEEN ANNE'S E MAIN ST
MD 307 DORCHESTER BROAD ST
MD 311 CAROLINE HALLTOWN RD
MD 313 CAROLINE FEDERALSBURG HWY
MD 318 CAROLINE BRIDGEVILLE RD
MD 328 TALBOT MATTHEWSTOWN RD
MD 331 CAROLINE DOVER BRIDGE RD
MD 343 DORCHESTER HUDSON RD
MD 349 WICOMICO NANTICOKE RD
MD 392 DORCHESTER DELAWARE AVE
CO 441 BALTIMORE TUFTON AVE
MD 454 CAROLINE CROWN STONE RD
MD 577 CAROLINE RELIANCE RD
MD 831 CARROLL MAIN ST

Rural Major Collector w/ partial access control

  • US 222 in cecil

Rural Major Collector w/ no access control

none

12,1 Urban Principal Arterial (Other Freeways and Expressways) w/ full access control - look like motorway

  • Motorway
    • I 895 A B
    • MD 695
    • 295
  • Trunk
    • Sam eig
    • Clara barton

17, 1 Urban Major Collector w/ full access control

  • MD 995

19,1 Urban Local w/ full access control

  • MD 187 B

12, 2 Urban Principal Arterial (Other Freeways and Expressways) w/ partial access control - trunk

  • 32, 43 roads like that

12, 3 Urban Principal Arterial (Other Freeways and Expressways) w/ no access control - primary

  • Md 2 solomons island
  • Moravia rd baltimore

14, 1 Urban Principal Arterial (Other) w/ full access control

  • 200 A (metro access)
  • MD 90 OC Expressway

14, 2 Urban Principal Arterial (Other) w/ partial access control

19, 2

  • MD 15C
  • MD 100 V
  • OP 6144

Codes Reference

References for abbreviations and codes

Functional Class

FUNC_CL Count Desc Rural Urban
1 16 Interstate Rural
2 56 Principal Arterial – Other Rural
6 132 Minor Arterial Rural
7 383 Major Collector Rural
8 739 Minor Collector Rural
9 14897 Local Rural
11 44 Interstate Urban
12 69 Principal Arterial – Other Freeways and Expressways Urban
14 410 Principal Arterial – Other Urban
16 1154 Minor Arterial Urban
17 2251 Major Collector Urban
18 179 Minor Collector Urban
19 65169 Local Urban

Access Control

Access control code Definition
3 NONE
2 PARTIAL
1 FULL