Readme
Updated over 3 years ago
‧ Indexed 6 hours ago
APC Raw August 25 2016
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| actual_sequence | actual_sequence | actual_sequence | Number | |
| location (city) | location_city | location_city | Text | |
| open_date_time | open_date_time | open_date_time | Number | |
| booking_num | booking_num | booking_num | Number | |
| variation | variation | variation | Text | |
| tp_id | tp_id | tp_id | Number | |
| raw_max_load | raw_max_load | raw_max_load | Number | |
| veh_lat | veh_lat | veh_lat | Number | |
| act_trip_start_time | act_trip_start_time | act_trip_start_time | Number | |
| non_rev_seconds | non_rev_seconds | non_rev_seconds | Number | |
| seg_arr_time | seg_arr_time | seg_arr_time | Number | |
| bs_id | bs_id | bs_id | Number | |
| route_id | route_id | route_id | Number | |
| raw_off | raw_off | raw_off | Number | |
| position_source | position_source | position_source | Number | |
| num_sat | num_sat | num_sat | Number | |
| rev_seconds | rev_seconds | rev_seconds | Number | |
| raw_on | raw_on | raw_on | Number | |
| vehicle_id | vehicle_id | vehicle_id | Number | |
| insert_date_time | insert_date_time | insert_date_time | Number | |
| block_id | block_id | block_id | Number | |
| operator_id | operator_id | operator_id | Text | |
| sched_time | sched_time | sched_time | Number | |
| garage_id | garage_id | garage_id | Number | |
| current_route_id | current_route_id | current_route_id | Number | |
| rev_distance | rev_distance | rev_distance | Number | |
| headsign_route | headsign_route | headsign_route | Number | |
| transit_date_time | transit_date_time | transit_date_time | Number | |
| veh_long | veh_long | veh_long | Number | |
| booking_id | booking_id | booking_id | Text | |
| dwell_time | dwell_time | dwell_time | Number | |
| ext_trip_id | ext_trip_id | ext_trip_id | Number | |
| seg_dep_time | seg_dep_time | seg_dep_time | Number | |
| close_date_time | close_date_time | close_date_time | Number | |
| ons | ons | ons | Number | |
| start_trip_time | start_trip_time | start_trip_time | Number | |
| quality_indicator | quality_indicator | quality_indicator | Number | |
| offs | offs | offs | Number | |
| run_id | run_id | run_id | Number | |
| apc_date_time | apc_date_time | apc_date_time | Number | |
| geo_export_4f4165f3-8c11-4c30-89ae-5142a7696688 | :@computed_region_asjg_v5te | :@computed_region_asjg_v5te | Number | |
| Census Tracts_from_9f6f_erxj | :@computed_region_ht2e_rx86 | :@computed_region_ht2e_rx86 | Number | |
| geo_export_4f4165f3-8c11-4c30-89ae-5142a7696688_from_tph2_wfsj | :@computed_region_38r9_82j6 | :@computed_region_38r9_82j6 | Number | |
| location (zip) | location_zip | location_zip | Text | |
| location (address) | location_address | location_address | Text | |
| location (state) | location_state | location_state | Text | |
| import_error | import_error | import_error | Number | |
| time_id | time_id | time_id | Number | |
| non_rev_distance | non_rev_distance | non_rev_distance | Number | |
| day_type_vs | day_type_vs | day_type_vs | Number | |
| import_trip_error | import_trip_error | import_trip_error | Number | |
| booking_start_date | booking_start_date | booking_start_date | Number | |
| max_load | max_load | max_load | Number | |
| direction_code_id | direction_code_id | direction_code_id | Number | |
| location | location | location | Point |