openpath_uprm_civic_24 NREL Changelog 
Version date: 2024-03-14 
 
Table name changes: 
 
    analysis_cleaned_place.csv renamed to analysis_cleaned_place. 
    analysis_cleaned_section.csv renamed to analysis_cleaned_section. 
    analysis_cleaned_stop.csv renamed to analysis_cleaned_stop. 
    analysis_cleaned_trip.csv renamed to analysis_cleaned_trip. 
    analysis_confirmed_trip.csv renamed to analysis_confirmed_trip. 
    manual_demographic_survey.csv renamed to manual_demographic_survey. 

Column name changes: 
 
    user_id renamed to perno. 
    data_trip_id renamed to tripno. 

Column redactions: 
 
    data_exit_loc_coordinates
    data_enter_local_dt_minute
    exit_loc_geom_nrel
    location_loc_geom_nrel
    data_enter_fmt_time
    metadata_write_ts
    metadata_write_local_dt_minute
    metadata_write_fmt_time
    data_exit_fmt_time
    data_latitude
    data_start_fmt_time
    data_exit_local_dt_minute
    data_location_coordinates
    data_start_loc_latitude
    data_enter_local_dt_hour
    data_start_local_dt_hour
    data_location_longitude
    data_start_local_dt_minute
    data_enter_local_dt_second
    data_end
    metadata_write_local_dt_second
    data_start
    data_end_fmt_time
    end_loc_geom_nrel
    data_exit_ts
    data_end_loc_latitude
    data_enter_loc_latitude
    data_end_loc_longitude
    data_end_local_dt_minute
    data_start_ts
    metadata_write_local_dt_hour
    data_enter_ts
    data_end_loc_coordinates
    data_start_loc_longitude
    data_start_loc_coordinates
    data_start_local_dt_second
    data_loc_latitude
    location_geom_nrel
    data_end_ts
    data_exit_loc_longitude
    data_longitude
    data_exit_local_dt_second
    data_location_latitude
    data_enter_loc_longitude
    data_loc_longitude
    data_end_local_dt_hour
    data_exit_local_dt_hour
    enter_loc_geom_nrel
    data_end_local_dt_second
    data_loc_coordinates
    data_exit_loc_latitude
    start_loc_geom_nrel
    data_enter_loc_coordinates

Column additions: 
 
    exit_loc_geom_nrel
    enter_loc_geom_nrel
    enter_loc_geom_nrel_zipcode
    location_geom_nrel_zipcode
    exit_loc_geom_nrel_zipcode
    end_loc_geom_nrel_zipcode
    end_loc_geom_nrel
    start_loc_geom_nrel
    location_geom_nrel
    start_loc_geom_nrel_zipcode
