This dataset has the following 85 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| 2011 Annual Average Traffic Volume(aadt11) | aadt11 | number | 2011 Annual Average Traffic Volume | 10000 20000 3900 2600 0 view top 100 |
| 2012 Year the AADT/Value was collected | aadt11yr | text | 2012 Year the AADT/Value was collected | 2010 2009 2011 2008 2006 view top 100 |
| 2012 Average Annual Daily Traffic Volume (aadt12) | aadt12 | number | Average Annual Daily Traffic Volume | 3700 2500 1100 10000 600 view top 100 |
| 2012 Year the AADT value was collected | aadt12yr | text | 2012 Year the AADT value was collected | 2012 2010 2011 2006 2008 view top 100 |
| Agency Type | agency_typ | text | Type of Agency | MPO MDOT CRC MODEL model view top 100 |
| Agency Oracle Code | agncy_orcl | text | DTMB created a global agency look up file in Oracle . Each agency has been assigned a unique ID. Agency defined as city, village, county, MPO, RPA, MDOT Region etc. | 129 574 596 615 201 view top 100 |
| arrow | arrow | text | B E S N view top 100 | |
| bmp | bmp | text | 0 0.5 0.999 1.004 0.25 view top 100 | |
| bmp13 | bmp13 | text | 0 0.5 1.003 0.995 1.001 view top 100 | |
| cnt_based | cnt_based | text | TRUE view top 100 | |
| cntdesc | cntdesc | text | NHS- national highway system, SAMPLE- HPMS sample segment, NONSAMPLE- full extent segment, PA- principal arterial, anything other than these four is a typo | NONSAMPLE sample PA NHS SAMPLE view top 100 |
| co | co | text | 82 41 25 63 81 view top 100 | |
| collect | collect | text | Agency responcible for collecting traffic data | Mdot_collects Agency_collects Mpo_collects per_mpo_call_LA Mdot_collects ` view top 100 |
| comments | comments | text | CHANGED FRM VOL TO CLASS. TRCK TRFFC M-99 AND M-60 NEW SAMP 2014 view top 100 | |
| counted | counted | text | 1 0 view top 100 | |
| county | county | text | Wayne Kent Genesee Oakland Washtenaw view top 100 | |
| countype | countype | text | 4 1 3 2 0 view top 100 | |
| countyr | countyr | text | 2012 2016 2014 2017 2015 view top 100 | |
| couplet | couplet | text | LOCAL rndabt divded 256685 256877 view top 100 | |
| dir | dir | text | 0 1 3 2 4 view top 100 | |
| dur | dur | number | 24 48 0 49 43 view top 100 | |
| emp | emp | number | 0.499 0.504 0.502 0.497 0.501 view top 100 | |
| emp13 | emp13 | text | 0 0.5 1.003 0.504 1.001 view top 100 | |
| f_sched | f_sched | text | 2015 2016 2018 2017 2019 view top 100 | |
| from_ | from_ | text | empty JURISDICTIONAL BOUNDARY Main St Michigan Ave Grand River Ave view top 100 | |
| gravel | gravel | text | y N NO view top 100 | |
| AADT - Annual Average Daily Traffic (i21) | i21 | number | AADT ( Annual Average Daily Traffic) | 3700 2500 600 10000 3800 view top 100 |
| i21d | i21d | number | AADT Year Year traffic count was collected | 2012 2011 2010 2013 2009 view top 100 |
| Single Unit AADT (i22) | i22 | number | Single Unit AADT | 0 2 6 30 19 view top 100 |
| Percent Peak Single Unit Traffic (i23) | i23 | number | Percent Peak Single Unit traffic | 0 1 0.2 0.89999998 3 view top 100 |
| Combination Unit (i24) | i24 | number | Combination Unit AADT | 0 1 3 9 2 view top 100 |
| i25 | i25 | number | Percent Peak Combination Unit traffic | 0 0.89999998 0.5 1 0.1 view top 100 |
| i26 | i26 | number | K Factor | 0 9 10 8 11 view top 100 |
| i27 | i27 | number | Directional Factor | 0 60 55 100 52 view top 100 |
| i28 | i28 | number | i21 (aadt) X expansion factor + aadt | 0 621 8063 664 3466 view top 100 |
| i28d | i28d | number | 0 2034 2035 2029 2030 view top 100 | |
| last_edi_1 | last_edi_1 | calendar_date | date record was edited | 2014-11-06T00:00:00.000 view top 100 |
| last_edite | last_edite | text | who last edited the record | CARSWELLM view top 100 |
| len | len | text | 0.499 0.501 0.502 0.504 0.503 view top 100 | |
| len1 | len1 | text | 0.499 0.501 0.502 0.504 0.503 view top 100 | |
| loc_error | loc_error | text | NO ERROR PARTIAL MATCH FOR THE TO-MEASURE view top 100 | |
| ls | ls | text | 2 4 3 5 7 view top 100 | |
| mdot_col | mdot_col | text | FALSE TRUE view top 100 | |
| mdot_reg | mdot_reg | text | 7 3 6 4 5 view top 100 | |
| mdot_samp | mdot_samp | text | MDOT view top 100 | |
| minprior | minprior | text | 4 1 3 2 0 view top 100 | |
| nfc | nfc | text | 5 4 3 6 0 view top 100 | |
| nfc_text | nfc_text | text | MAJOR_COLL MINOR_ART PA MIN_COLL LOCAL view top 100 | |
| nhs | nhs | text | 0 1 3 5 2 view top 100 | |
| ni_tag | ni_tag | text | 512208D 180489U 0 180494R 000513Y view top 100 | |
| num_hr | num_hr | number | 24 0 48 49 43 view top 100 | |
| objectid | objectid | text | 0 13801 17390 12480 16385 view top 100 | |
| place | place | text | 1808 41 63 82 2784 view top 100 | |
| place_name | place_name | text | DETROIT KENT OAKLAND WAYNE GRAND RAPIDS view top 100 | |
| plan_reg | plan_reg | text | 1 10 3 20 16 view top 100 | |
| pr | pr | text | 1497102 3416247 3251558 405602 442605 view top 100 | |
| pr13 | pr13 | text | 1497102 3416247 3251558 405602 442605 view top 100 | |
| pry2 | pry2 | text | 4 1 3 2 0 view top 100 | |
| relid | relid | text | 0 870 13359 7914 872 view top 100 | |
| ru_l | ru_l | text | 4 1 2 3 0 view top 100 | |
| ru_r | ru_r | text | 4 1 2 3 0 view top 100 | |
| ru_text | ru_text | text | URBAN RURAL view top 100 | |
| sample_id | sample_id | text | 0 4.2784E+11 4.2388E+11 2.73001E+11 4.0516E+11 view top 100 | |
| sched1 | sched1 | text | 2012 2010 2011 2013 2014 view top 100 | |
| sched2 | sched2 | text | 2015 2016 2018 2017 2019 view top 100 | |
| sched3 | sched3 | text | view top 100 | |
| sched_2012 | sched_2012 | text | 0 2013 view top 100 | |
| seg_descri | seg_descri | text | Long Lake Rd, 9 Mile Rd, Seaman Rd, Brooks Rd, Johnson Rd, Andersonville Rd, Bass Lake Rd, Bass Lake Rd, Bass Lake Rd, Bass Lake Rd, Bass Lake Rd, Benston Rd, Benston Rd, view top 100 | |
| segcolor | segcolor | text | 2 3 7 1 5 view top 100 | |
| shape_stle | shape_stle | text | 0 6862.342401 14388.34228 1241.411483 31638.07467 view top 100 | |
| source | source | text | MDOT SEMCOG GVMC GLS TRICO view top 100 | |
| study | study | text | wave hose mio MIO MPO view top 100 | |
| study_type | study_type | text | volume class calss classs volume ` view top 100 | |
| studyear | studyear | text | 2012 2016 2014 2017 2013 view top 100 | |
| studytype2 | studytype2 | text | VOLUME CLASS volume view top 100 | |
| stwd_area | stwd_area | text | 9 3 6 2 5 view top 100 | |
| three | three | text | 0 3 view top 100 | |
| to_ | to_ | text | empty JURISDICTIONAL BOUNDARY Main St Michigan Ave Grand River Ave view top 100 | |
| traff_alig | traff_alig | text | * - view top 100 | |
| traff_id | traff_id | text | 256752 575004 255595 215066 85103 view top 100 | |
| twp | twp | text | Detroit Grand Rapids Flint Saginaw Lansing view top 100 | |
| twp_fips | twp_fips | text | 22000 34000 0 29000 70520 view top 100 | |
| version | version | text | 13 0 view top 100 | |
| name | name | text | Wayne Kent Genesee Oakland Washtenaw view top 100 | |
| Location 1 | location_1 | location | view top 100 |