City Of Pittsburgh Retaining Walls by US Government | Demographics and Population Studies

About this Dataset

City Of Pittsburgh Retaining Walls

City of Pittsburgh Retaining Walls
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:49.432429
Tags: _etl, infrastructure, retaining, walls

Tables

Retaining Walls

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_reta_3bd63e5d.retaining_walls

55.3 KB
562 rows
21 columns


CREATE TABLE retaining_walls (
  "n__id" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "street" VARCHAR,
  "to_street" VARCHAR,
  "year_constructed" DOUBLE,
  "public_view" VARCHAR,
  "inactive" VARCHAR,
  "height" DOUBLE,
  "length" DOUBLE,
  "image" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" BIGINT,
  "ward" DOUBLE,
  "tract" BIGINT,
  "public_works_division" BIGINT,
  "pli_division" DOUBLE,
  "police_zone" BIGINT,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Retaining Walls Data Dictionary

@usgov.allegheny_county_city_of_pitts_city_of_pittsburgh_reta_3bd63e5d.retaining_walls_data_dictionary

3.1 KB
20 rows
3 columns


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