wisdot_01 NREL Changelog 
Version date: 2021-06-09 
 
Table name changes: 
 
    hh.csv renamed to survey_household. 
    mrt.csv renamed to survey_most_recent_trip. 
    per.csv renamed to survey_person. 
    day.csv renamed to survey_trip. 
    ldt.csv renamed to survey_long_distance_trip. 

Column name changes: 
 
    houseid renamed to sampno. 
    personid renamed to perno. 
    vehid renamed to vehno. 
    tdcaseid renamed to tripno. 
    vehyear renamed to veh_year. 
    makename renamed to veh_make. 
    modlname renamed to veh_model. 
    worklat renamed to work_latitude. 
    worklong renamed to work_longitude. 
    homelat renamed to home_latitude. 
    homelong renamed to home_longitude. 
    trpstala renamed to trpsta_latitude. 
    trpstalo renamed to trpsta_longitude. 
    trpendla renamed to trpend_latitude. 
    trpendlo renamed to trpend_longitude. 
    fardesla renamed to fardes_latitude. 
    fardeslo renamed to fardes_longitude. 
    trpmiles renamed to distance_mi. 
    plzip renamed to place_zipcode. 
    workzip renamed to work_zipcode. 
    hhzip renamed to household_zip. 

Column redactions: 
 
    age_p7
    age_p11
    trpend_latitude
    home_latitude
    wkldmrk1
    age_p9
    geom_trpend_nrel
    egrname
    eiadmpg
    age_p6
    r_agewgt
    plstname
    wkstnum
    age_p5
    plroad1
    geom_work_nrel
    work_longitude
    modlcodeaccname
    geom_home_nrel
    epatmpg
    pllnmrk2
    veh_model
    wkstname
    age_p1
    age_p10
    age_p4
    r_age
    wheresp
    age_p13
    pllnmrk1
    age_p14work_latitude
    age_p2
    trpend_longitude
    geom_trpsta_nrel
    epatmpgf
    age_p3
    hhr_age
    wkcrost1
    wkldmrk2
    wkldmrk3
    plstnum
    plroad2
    fardes_longitude
    geom_fardes_nrel
    pllnmrk3
    age_p12
    fardes_latitude
    trpsta_longitude
    trpsta_latitude
    employer
    wkcrost2
    home_longitude
    age_p8

Column additions: 
 
    age_p13_nrel_agebin
    age_p1_nrel_agebin
    age_p5_nrel_agebin
    geom_trpend_nrel
    hhr_age_nrel_agebin
    age_p6_nrel_agebin
    geom_work_nrel
    age_p4_nrel_agebin
    age_p10_nrel_agebin
    age_p2_nrel_agebin
    geom_home_nrel
    age_p7_nrel_agebin
    age_p14_nrel_agebin
    r_age_nrel_agebin
    age_p12_nrel_agebin
    age_p8_nrel_agebin
    geom_trpsta_nrel
    r_agewgt_nrel_agebin
    geom_fardes_nrel
    age_p9_nrel_agebin
    age_p3_nrel_agebin
    age_p11_nrel_agebin
