About this Dataset

State Owned Buildings

This dataset contains information on structures that are owned by the State of Connecticut.

This inventory is currently maintained by the Office of Policy and Management (OPM) and information is self-reported by those State agencies that have custody and control over State owned buildings.

For additional information about this data, please contact the agency which is listed as owning the property. This data is updated each March.
Organization: State of Connecticut
Last updated: 2020-11-12T14:54:21.847836
Tags: buildings, opm, state-owned

Tables

Table 1

@usgov.state_of_connecticut_state_owned_buildings.table_1

278.42 kB
3,814 rows
35 columns

CREATE TABLE table_1 (
  "reference_number" VARCHAR,
  "structure_name" VARCHAR,
  "address" VARCHAR,
  "town" VARCHAR,
  "condition" VARCHAR,
  "gross_square_feet" DOUBLE,
  "net_usable_square_feet" DOUBLE,
  "occupancy_status" VARCHAR,
  "percent_occupied" VARCHAR,
  "structure_classification" VARCHAR,
  "construction_type" VARCHAR,
  "year_of_construction" VARCHAR,
  "year_of_last_major_renovation" VARCHAR,
  "n_2_year_use_plans" VARCHAR  -- 2 Year Use Plans,
  "n_5_year_use_plans" VARCHAR  -- 5 Year Use Plans,
  "number_of_clients_housed" VARCHAR,
  "number_of_employees_housed" VARCHAR,
  "on_or_eligible_for_historic_register" VARCHAR,
  "number_of_owned_parking_spaces" VARCHAR,
  "facility_name" VARCHAR,
  "known_deed_restrictions" VARCHAR,
  "annual_walk_in_traffic" VARCHAR,
  "used_to_house_non_state_entities" VARCHAR,
  "percent_heated" VARCHAR,
  "percent_cooled" VARCHAR,
  "number_of_floors" VARCHAR,
  "agency_name" VARCHAR,
  "agency_contact_name" VARCHAR,
  "agency_contact_phone" VARCHAR,
  "agency_contact_email" VARCHAR,
  "emergency_contact_name" VARCHAR,
  "emergency_contact_phone" VARCHAR,
  "emergency_contact_email" VARCHAR,
  "general_memo_field" VARCHAR,
  "location" VARCHAR
);