Recreation And Park Department's Facility Conditions Assessment by US Government | Finance and Economics

About this Dataset

Recreation And Park Department's Facility Conditions Assessment

A 2007 conditions assessment of the Recreation & Parks Department's capital assets. This data is collected and published from COMET.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:27.870068
Tags: capital-assets, capital-program, comet

Tables

Table 1

@usgov.city_of_san_francisco_recreation_and_park_departments__6f8d9b11.table_1

377.46 KB
12023 rows
29 columns


CREATE TABLE table_1 (
  "tma_supervisoral_district" DOUBLE,
  "psa_id" DOUBLE,
  "psa_title" VARCHAR,
  "psa_fci" DOUBLE,
  "site_id" DOUBLE,
  "site_name" VARCHAR,
  "site_sq_ft" DOUBLE,
  "site_fci" DOUBLE,
  "tma_facility_type" VARCHAR,
  "path_name" VARCHAR,
  "fci" DOUBLE,
  "path_type" VARCHAR,
  "assembly" VARCHAR,
  "assembly_id" BIGINT,
  "assm_desc" VARCHAR,
  "uom" VARCHAR,
  "qty" BIGINT,
  "unit_price" DOUBLE,
  "ext_unit_price" DOUBLE,
  "replacement_amt" DOUBLE,
  "renewal_pct" DOUBLE,
  "renewal_amt" DOUBLE,
  "life" BIGINT,
  "year_installed" DOUBLE,
  "priority" DOUBLE,
  "priority_description" VARCHAR,
  "category" VARCHAR,
  "distress" VARCHAR,
  "material" VARCHAR
);