austin-metro-demo-socrata/apc-raw-august-25-2016-69xg-kvuh
Icon for Socrata external plugin
 
Readme
Updated over 3 years ago
Indexed 6 hours ago

APC Raw August 25 2016

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
actual_sequenceactual_sequenceactual_sequenceNumber
location (city)location_citylocation_cityText
open_date_timeopen_date_timeopen_date_timeNumber
booking_numbooking_numbooking_numNumber
variationvariationvariationText
tp_idtp_idtp_idNumber
raw_max_loadraw_max_loadraw_max_loadNumber
veh_latveh_latveh_latNumber
act_trip_start_timeact_trip_start_timeact_trip_start_timeNumber
non_rev_secondsnon_rev_secondsnon_rev_secondsNumber
seg_arr_timeseg_arr_timeseg_arr_timeNumber
bs_idbs_idbs_idNumber
route_idroute_idroute_idNumber
raw_offraw_offraw_offNumber
position_sourceposition_sourceposition_sourceNumber
num_satnum_satnum_satNumber
rev_secondsrev_secondsrev_secondsNumber
raw_onraw_onraw_onNumber
vehicle_idvehicle_idvehicle_idNumber
insert_date_timeinsert_date_timeinsert_date_timeNumber
block_idblock_idblock_idNumber
operator_idoperator_idoperator_idText
sched_timesched_timesched_timeNumber
garage_idgarage_idgarage_idNumber
current_route_idcurrent_route_idcurrent_route_idNumber
rev_distancerev_distancerev_distanceNumber
headsign_routeheadsign_routeheadsign_routeNumber
transit_date_timetransit_date_timetransit_date_timeNumber
veh_longveh_longveh_longNumber
booking_idbooking_idbooking_idText
dwell_timedwell_timedwell_timeNumber
ext_trip_idext_trip_idext_trip_idNumber
seg_dep_timeseg_dep_timeseg_dep_timeNumber
close_date_timeclose_date_timeclose_date_timeNumber
onsonsonsNumber
start_trip_timestart_trip_timestart_trip_timeNumber
quality_indicatorquality_indicatorquality_indicatorNumber
offsoffsoffsNumber
run_idrun_idrun_idNumber
apc_date_timeapc_date_timeapc_date_timeNumber
geo_export_4f4165f3-8c11-4c30-89ae-5142a7696688:@computed_region_asjg_v5te:@computed_region_asjg_v5teNumber
Census Tracts_from_9f6f_erxj:@computed_region_ht2e_rx86:@computed_region_ht2e_rx86Number
geo_export_4f4165f3-8c11-4c30-89ae-5142a7696688_from_tph2_wfsj:@computed_region_38r9_82j6:@computed_region_38r9_82j6Number
location (zip)location_ziplocation_zipText
location (address)location_addresslocation_addressText
location (state)location_statelocation_stateText
import_errorimport_errorimport_errorNumber
time_idtime_idtime_idNumber
non_rev_distancenon_rev_distancenon_rev_distanceNumber
day_type_vsday_type_vsday_type_vsNumber
import_trip_errorimport_trip_errorimport_trip_errorNumber
booking_start_datebooking_start_datebooking_start_dateNumber
max_loadmax_loadmax_loadNumber
direction_code_iddirection_code_iddirection_code_idNumber
locationlocationlocationPoint
 
Preview
  • apc_raw_august_25_2016