caltrans_17 NREL Changelog 
Version date: 2021-05-12 
 
Table name changes: 
 
    person_CA.xlsx renamed to survey_person. 
    Trip_CA.xlsx renamed to survey_trip. 
    household_weights_5day.xlsx renamed to survey_household_weights_5day. 
    household_weights_7day.xlsx renamed to survey_household_weights_7day. 
    person_weights_5day.xlsx renamed to survey_person_weights_5day. 
    person_weights_7day.xlsx renamed to survey_person_weights_7day. 

Column name changes: 
 
    houseid renamed to sampno. 
    personid renamed to perno. 
    vehid renamed to vehno. 
    tdtrpnum renamed to tripno. 
    vehyear renamed to veh_year. 
    make renamed to veh_make. 
    model renamed to veh_model. 
    timezone renamed to time_local. 
    latitude renamed to latitude. 
    longitude renamed to longitude. 
    trpmiles17 renamed to distance_mi. 
    zip renamed to zipcode. 

Column redactions: 
 
    r_age
    longitude
    veh_model
    tractfips
    blockfips
    latitude
    r_age_imp
    geom_nrel
    locname
    fullfips

Column additions: 
 
    r_age_imp_nrel_agebin
    geom_nrel
    r_age_nrel_agebin
