wisdot_09 NREL Changelog 
Version date: 2021-05-14 
 
Table name changes: 
 
    locations.xls renamed to survey_location. 
    WI_DTRP.xls renamed to survey_trip. 
    WI_HH.xls renamed to survey_household. 
    WI_PERS.xls renamed to survey_person. 

Column name changes: 
 
    houseid renamed to sampno. 
    personid renamed to perno. 
    vehid renamed to vehno. 
    tdtrpnum 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. 
    trpendla renamed to trpend_latitude. 
    trpendlo renamed to trpend_longitude. 
    trpmiles renamed to distance_mi. 
    plzip renamed to place_zipcode. 
    workzip renamed to work_zipcode. 
    hhzip renamed to household_zip. 

Column redactions: 
 
    veh_make
    pllnmrk2
    pllnmrk3
    whereos
    employer
    pllnmrk1
    plroad2
    geom_work_nrel
    plroad1
    geom_home_nrel
    home_latitude
    plsname
    schname
    home_longitude
    l_model
    r_age
    modlcode
    trpend_latitude
    work_latitude
    veh_model
    imptage
    l_make
    trpend_longitude
    geom_trp_nrel
    age5plus
    makecode
    work_longitude
    plstname
    plstnum
    wheresp

Column additions: 
 
    imptage_nrel_agebin
    geom_trp_nrel
    age5plus_nrel_agebin
    geom_work_nrel
    agerange_nrel_agebin
    geom_home_nrel
    r_age_nrel_agebin
