Name: City Of Pittsburgh Bridges
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

City Of Pittsburgh Bridges

Bridges in the city of Pittsburgh.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:54.849426
Tags: _etl, bridge, city-of-bridges, road, transportation

Tables

City Bridges

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_bridges.city_bridges

25.69 KB
153 rows
18 columns


CREATE TABLE city_bridges (
  "n__id" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "start_neighborhood" VARCHAR,
  "end_neighborhood" VARCHAR,
  "year_built" DOUBLE,
  "year_rehab" DOUBLE,
  "image" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" BIGINT,
  "ward" DOUBLE,
  "tract" BIGINT,
  "public_works_division" DOUBLE,
  "pli_division" DOUBLE,
  "police_zone" DOUBLE,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

City Bridges Data Dictionary

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_bridges.city_bridges_data_dictionary

3.04 KB
17 rows
3 columns


CREATE TABLE city_bridges_data_dictionary (
  "n__id" BIGINT,
  "id" VARCHAR,
  "type" VARCHAR
);