Traffic Cameras

City of Austin

@usgov.city_of_austin_traffic_cameras_39eee

Table List

1 table(110.21 KB)

Table 1

@usgov.city_of_austin_traffic_cameras_39eee.table_1

110.21 KB
947 rows
26 columns

camera_id Camera ID	location_name Location Name	camera_status Camera Status	turn_on_date Turn On Date	camera_manufacturer Camera Manufacturer	atd_location_id ATD Location ID	landmark Landmark	signal_engineer_area Signal Engineer Area	council_district Council District	jurisdiction Jurisdiction	location_type Location Type	primary_street_block Primary Street Block	primary_street Primary Street	cross_street_block Cross Street Block	cross_street Cross Street	coa_intersection_id COA Intersection ID	modified_date Modified Date	screenshot_address Screenshot Address	funding Funding	id ID	location Location
282	SLAUGHTER LN / FRANCIA TRL	TURNED_ON		Wisenet	LOC16-004525		SOUTH	5, 2	AUSTIN FULL PURPOSE	ROADWAY	400	SLAUGHTER LN	9101	FRANCIA TRL	5150904	08/01/2023 07:25:00 PM	https://cctv.austinmobility.io/image/282.jpg	None Identified	582a419a5e304c982be5c3ba	POINT (-97.79583 30.169279)
1426	200 BLK TRINITY ST	TURNED_ON	Wed Mar 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Wisenet	LOC24-023025		CENTRAL	9	AUSTIN FULL PURPOSE	ROADWAY	200	TRINITY ST				03/07/2024 09:14:00 PM	https://cctv.austinmobility.io/image/1426.jpg	None Identified	65e8d35ea4ee1900290bc463	POINT (-97.740502 30.263874)
458	KOENIG LN / GUADALUPE ST	TURNED_ON	Sat Mar 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Advidia	LOC16-000045		NORTHWEST	4	AUSTIN FULL PURPOSE	ROADWAY	600	KOENIG LN	5510	GUADALUPE ST	5159393	10/18/2024 06:26:00 PM	https://cctv.austinmobility.io/image/458.jpg	1/4 Cent	591a10a320eacf2d16669c45	POINT (-97.723831 30.323502)
459	KOENIG LN / WOODROW AVE	TURNED_ON	Wed Jun 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Advidia	LOC16-000060		NORTHWEST	7	AUSTIN FULL PURPOSE	ROADWAY	1400	KOENIG LN	5900	WOODROW AVE	5158454	10/21/2024 03:13:00 PM	https://cctv.austinmobility.io/image/459.jpg	1/4 Cent	591a10a320eacf2d16669c47	POINT (-97.73159 30.330872)
463	MOPAC EXPY / NORTHLAND DR (East)	TURNED_ON	Wed Feb 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Advidia	LOC16-002170	East	NORTHWEST	7	AUSTIN FULL PURPOSE	ROADWAY	5300	MOPAC EXPY	3000	NORTHLAND DR	5155147	12/05/2023 07:03:00 PM	https://cctv.austinmobility.io/image/463.jpg	1/4 Cent	591a10a420eacf2d16669c4f	POINT (-97.753723 30.335529)
464	BURNET RD / WHITE HORSE TRL	TURNED_ON	Wed Jul 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Advidia	LOC16-000405		NORTHWEST	7	AUSTIN FULL PURPOSE	ROADWAY	6314	BURNET RD	2101	WHITE HORSE TRL	5157237	10/10/2022 05:11:00 PM	https://cctv.austinmobility.io/image/464.jpg	2016 Bond	591a10a420eacf2d16669c51	POINT (-97.73925 30.33848)
465	BURNET RD / ADAMS AVE	TURNED_ON	Tue Jul 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Advidia	LOC16-004710		NORTHWEST	7	AUSTIN FULL PURPOSE	ROADWAY	5500	BURNET RD	5600	ADAMS AVE	5157168	10/10/2022 05:11:00 PM	https://cctv.austinmobility.io/image/465.jpg	None Identified	591a10a420eacf2d16669c53	POINT (-97.739891 30.330071)
466	BURNET RD / 49TH ST	TURNED_ON	Wed Mar 14 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Advidia	LOC16-000440		NORTHWEST	7	AUSTIN FULL PURPOSE	ROADWAY	4900	BURNET RD	2101	49TH ST	5157310	12/05/2023 08:02:00 PM	https://cctv.austinmobility.io/image/466.jpg	1/4 Cent	591a10a420eacf2d16669c55	POINT (-97.739227 30.319857)
467	BURNET RD / NORTHCROSS DR	TURNED_ON	Tue Jul 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Advidia	LOC16-000450		NORTHWEST	7	AUSTIN FULL PURPOSE	ROADWAY	7600	BURNET RD	7601	NORTHCROSS DR	5158100	10/10/2022 05:11:00 PM	https://cctv.austinmobility.io/image/467.jpg	None Identified	591a10a420eacf2d16669c57	POINT (-97.733246 30.352217)
468	BURNET RD / STECK AVE	TURNED_ON	Tue Jul 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Advidia	LOC16-000380		NORTHWEST	4, 7	AUSTIN FULL PURPOSE	ROADWAY	8224	BURNET RD	2501	STECK AVE	5158619	10/10/2022 05:11:00 PM	https://cctv.austinmobility.io/image/468.jpg	None Identified	591a10a420eacf2d16669c59	POINT (-97.72934 30.361847)


CREATE TABLE table_1 (
  "camera_id" BIGINT,
  "location_name" VARCHAR,
  "camera_status" VARCHAR,
  "turn_on_date" TIMESTAMP,
  "camera_manufacturer" VARCHAR,
  "atd_location_id" VARCHAR,
  "landmark" VARCHAR,
  "signal_engineer_area" VARCHAR,
  "council_district" VARCHAR,
  "jurisdiction" VARCHAR,
  "location_type" VARCHAR,
  "primary_st_segment_id" VARCHAR,
  "cross_st_segment_id" VARCHAR,
  "primary_street_block" DOUBLE,
  "primary_street" VARCHAR,
  "primary_st_aka" VARCHAR,
  "cross_street_block" DOUBLE,
  "cross_street" VARCHAR,
  "cross_st_aka" VARCHAR,
  "coa_intersection_id" DOUBLE,
  "modified_date" VARCHAR,
  "published_screenshots" VARCHAR,
  "screenshot_address" VARCHAR,
  "funding" VARCHAR,
  "id" VARCHAR,
  "location" VARCHAR
);