Name: Field Listings
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Field Listings

Listing of all baseball fields within the City of Pittsburgh.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:12:49.041520
Tags: ballfield, baseball, diamond, field, recreation, sports

Tables

Field Listing 2015

@usgov.allegheny_county_city_of_pitts_field_listings.field_listing_2015

23.77 kB
122 rows
26 columns

CREATE TABLE field_listing_2015 (
  "field_name" VARCHAR,
  "dedicated_division" VARCHAR,
  "facility" VARCHAR,
  "neighborhood" VARCHAR,
  "battting_cage" DOUBLE,
  "concession_stand" DOUBLE,
  "back_stop" DOUBLE,
  "infield" DOUBLE,
  "goal_post" DOUBLE,
  "lights" DOUBLE,
  "left" VARCHAR,
  "center" VARCHAR,
  "right" VARCHAR,
  "permit" VARCHAR,
  "drag" VARCHAR,
  "pashek_map_number" DOUBLE,
  "field_renovated" VARCHAR,
  "cd" VARCHAR,
  "lights_renovated" VARCHAR,
  "control_link" VARCHAR,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25
);