APC (RAW) - June 2016 by US Government | Demographics and Population Studies

About this Dataset

APC (RAW) - June 2016

This Capital Metro Automatic Passenger Counter (APC) Ridership data set is unprocessed, pure, raw, flaws and all straight from our Automatic Vehicle Location (AVL) system. Capital Metro, in partnership with a third-party vendor, applies a process that reviews the data to determine the validity and flags various elements to ensure final reported data has any bad elements excluded. Utilizing this data without applying your own methods to remove errors WILL NOT produce results corresponding to the published Ridership Reports.

https://www.capmetro.org/facts/#!

Use of this data is subject to the terms below as well as the Terms of Service location Capital MetroLabs website.

https://www.capmetro.org/metrolabs/

Permission is hereby granted, free of charge, to any person obtaining a copy of this data and associated documentation files (the "Data"), to deal in the Data without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Data, and to permit persons to whom the Data is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Data.
The name of the copyright holder may not be used to endorse or promote products derived from this Data without specific prior written permission.
THE DATA IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE DATA OR THE USE OR OTHER DEALINGS IN THE DATA.
Use of the Capital Metro logo without express written consent is expressly prohibited.
Capital Metro may change Data formats at any time without notice.
Organization: City of Austin
Last updated: 2023-08-25T23:39:25.461785
Tags: apc

Tables

Table 1

@usgov.city_of_austin_apc_raw_june_2016.table_1

256.58 MB
4108680 rows
47 columns


CREATE TABLE table_1 (
  "act_trip_start_time" DOUBLE,
  "actual_sequence" BIGINT,
  "apc_date_time" DOUBLE,
  "block_id" BIGINT,
  "booking_id" VARCHAR,
  "booking_num" BIGINT,
  "booking_start_date" DOUBLE,
  "bs_id" BIGINT,
  "close_date_time" DOUBLE,
  "current_route_id" BIGINT,
  "day_type_vs" BIGINT,
  "direction_code_id" BIGINT,
  "dwell_time" BIGINT,
  "ext_trip_id" BIGINT,
  "garage_id" BIGINT,
  "headsign_route" BIGINT,
  "import_error" BIGINT,
  "import_trip_error" BIGINT,
  "insert_date_time" DOUBLE,
  "max_load" BIGINT,
  "non_rev_distance" DOUBLE,
  "non_rev_seconds" BIGINT,
  "num_sat" BIGINT,
  "offs" BIGINT,
  "ons" BIGINT,
  "open_date_time" DOUBLE,
  "operator_id" BIGINT,
  "position_source" BIGINT,
  "quality_indicator" BIGINT,
  "raw_max_load" BIGINT,
  "raw_off" BIGINT,
  "raw_on" BIGINT,
  "rev_distance" DOUBLE,
  "rev_seconds" BIGINT,
  "route_id" BIGINT,
  "run_id" BIGINT,
  "sched_time" DOUBLE,
  "seg_arr_time" DOUBLE,
  "seg_dep_time" DOUBLE,
  "start_trip_time" DOUBLE,
  "time_id" BIGINT,
  "tp_id" BIGINT,
  "transit_date_time" DOUBLE,
  "variation" VARCHAR,
  "veh_lat" DOUBLE,
  "veh_long" DOUBLE,
  "vehicle_id" BIGINT
);