Travel Sensors
City of Austin
@usgov.city_of_austin_travel_sensors
City of Austin
@usgov.city_of_austin_travel_sensors
CREATE TABLE table_1 (
"reader_id" VARCHAR,
"atd_sensor_id" BIGINT,
"kits_id" DOUBLE,
"atd_location_id" VARCHAR,
"modified_date" VARCHAR,
"sensor_status" VARCHAR,
"turn_on_date" VARCHAR,
"sensor_type" VARCHAR,
"sensor_mfg" VARCHAR,
"coa_intersection_id" DOUBLE,
"primary_st_segment_id" VARCHAR,
"cross_st_segment_id" VARCHAR,
"landmark" VARCHAR,
"primary_st_aka" VARCHAR,
"cross_st_aka" VARCHAR,
"signal_eng_area" VARCHAR,
"council_district" VARCHAR,
"jurisdiction" VARCHAR,
"location_type" VARCHAR,
"location_name" VARCHAR,
"primary_st" VARCHAR,
"cross_st" VARCHAR,
"primary_st_block" DOUBLE,
"county" VARCHAR,
"cross_st_block" DOUBLE,
"ip_comm_status" VARCHAR,
"comm_status_datetime_utc" VARCHAR,
"location_latitude" VARCHAR,
"location_longitude" VARCHAR,
"source_db_id" VARCHAR,
"location" VARCHAR,
"primary_st_segment_display_name" VARCHAR,
"cross_st_segment_display_name" VARCHAR,
"jurisdiction_label" VARCHAR,
"corridor_name" VARCHAR
);
Anyone who has the link will be able to view this.