Name: Metered Streets Pittsburgh Parking Authority
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Metered Streets Pittsburgh Parking Authority

Pittsburgh Parking Metered Streets
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:03:37.635766
Tags: _etl, harvested, pittsburgh, pittsburgh-parking-metered-streets, transportation

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_metered_streets_pittsbu_1bfbc5ae.table_1

126.84 KB
595 rows
77 columns


CREATE TABLE table_1 (
  "n__id" BIGINT,
  "objectid_12" BIGINT,
  "objectid_1" BIGINT,
  "objectid_2" BIGINT,
  "objectid" BIGINT,
  "fnode_no" BIGINT,
  "tnode_no" BIGINT,
  "lpoly_no" BIGINT,
  "rpoly_no" BIGINT,
  "length" DOUBLE,
  "streetcl_n" BIGINT,
  "streetcl_i" BIGINT,
  "prefix" VARCHAR,
  "name" VARCHAR,
  "type" VARCHAR,
  "suffix" VARCHAR,
  "dir" VARCHAR,
  "streetname" VARCHAR,
  "alternaten" VARCHAR,
  "lleft" BIGINT,
  "hleft" BIGINT,
  "lrgt" BIGINT,
  "hrgt" BIGINT,
  "fromstreet" VARCHAR,
  "tostreet" VARCHAR,
  "zipl" BIGINT,
  "zipr" BIGINT,
  "mcdl" VARCHAR,
  "mcdr" VARCHAR,
  "owner" VARCHAR,
  "beltway" VARCHAR,
  "majorrd" VARCHAR,
  "no_lanes" BIGINT,
  "cfcc" VARCHAR,
  "gdtlink" VARCHAR,
  "oneway" VARCHAR,
  "stcl_code" BIGINT,
  "unique_id" BIGINT,
  "route_no" VARCHAR,
  "std_rng" VARCHAR,
  "checked" TIMESTAMP,
  "changed" VARCHAR,
  "stadded" VARCHAR,
  "cltype" VARCHAR,
  "halfvac" VARCHAR,
  "cen20lt" BIGINT,
  "cen20rg" BIGINT,
  "zone_left" BIGINT,
  "zone_right" BIGINT,
  "hood_left" VARCHAR,
  "hood_right" VARCHAR,
  "dpw_zon_lt" BIGINT,
  "dpw_zon_rt" BIGINT,
  "fire_zn_lt" VARCHAR,
  "fire_zn_rt" VARCHAR,
  "ward_lt" BIGINT,
  "ward_rg" BIGINT,
  "nh_l" BIGINT,
  "nh_r" BIGINT,
  "council_lt" BIGINT,
  "council_rt" BIGINT,
  "vote_dt_lt" BIGINT,
  "vote_dt_rt" BIGINT,
  "class" VARCHAR,
  "paveddate" TIMESTAMP,
  "truckroute" VARCHAR,
  "symbology" BIGINT,
  "cartegraph" BIGINT,
  "streetfrom" VARCHAR,
  "oldfireznl" VARCHAR,
  "oldfireznr" VARCHAR,
  "cen2010lt" BIGINT,
  "cen2010rg" BIGINT,
  "council_1" VARCHAR,
  "council_2" VARCHAR,
  "shape_leng" DOUBLE,
  "ppa_zones" VARCHAR
);