State Owned Buildings

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.ct.gov
Id r8ci-yhcn
Name State Owned Buildings
Attribution Office of Policy and Management
Category Government
Tags opm, state, buildings, property, usodcensus
Created 2014-03-21T20:05:42Z
Publication Date 2015-11-23T15:25:56Z

Description

Contains information on structures that are owned by the State of Connecticut. This inventory is currently maintained by the 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 annually (October).

Columns

| Included | Schema Type    | Field Name                               | Name                                     | Data Type | Render Type |
| ======== | ============== | ======================================== | ======================================== | ========= | =========== |
| No       | time           | :updated_at                              | updated_at                               | meta_data | meta_data   |
| Yes      | series tag     | agency_name                              | Agency Name                              | text      | text        |
| Yes      | series tag     | reference_number                         | Reference Number                         | text      | text        |
| Yes      | series tag     | agency_number                            | Agency Number                            | text      | number      |
| Yes      | series tag     | structure_name                           | Structure Name                           | text      | text        |
| No       |                | address                                  | Address                                  | text      | text        |
| Yes      | series tag     | town                                     | Town                                     | text      | text        |
| Yes      | series tag     | zip_code                                 | Zip Code                                 | text      | text        |
| Yes      | series tag     | nearest_crossroads                       | Nearest Crossroads                       | text      | text        |
| Yes      | series tag     | condition                                | Condition                                | text      | text        |
| Yes      | series tag     | construction_type                        | Construction Type                        | text      | text        |
| Yes      | numeric metric | year_of_construction                     | Year of Construction                     | number    | number      |
| Yes      | numeric metric | year_of_last_major_renovation            | Year of Last Major Renovation            | number    | number      |
| Yes      | numeric metric | gross_square_feet                        | Gross Square Feet                        | number    | number      |
| Yes      | numeric metric | net_usable_square_feet                   | Net Usable Square Feet                   | number    | number      |
| Yes      | numeric metric | square_feet_currently_utilized           | Square Feet Currently Utilized           | number    | number      |
| Yes      | numeric metric | square_feet_not_utilized                 | Square Feet Not Utilized                 | number    | number      |
| Yes      | numeric metric | utilization_rate                         | Utilization Rate                         | percent   | percent     |
| Yes      | numeric metric | number_of_floors                         | Number of Floors                         | number    | number      |
| Yes      | series tag     | 2_year_use_recommendation                | 2 Year Use Recommendation                | text      | text        |
| Yes      | series tag     | 5_year_use_recommendation                | 5 Year Use Recommendation                | text      | text        |
| Yes      | series tag     | memo_field                               | Memo Field                               | text      | text        |
| Yes      | series tag     | used_to_house_clients                    | Used To House Clients                    | text      | text        |
| Yes      | numeric metric | number_of_clients_currently_housed       | Number of Clients Currently Housed       | number    | number      |
| Yes      | series tag     | occupancy_status                         | Occupancy Status                         | text      | text        |
| Yes      | series tag     | on_or_eligible_for_historic_register     | On or Eligible For Historic Register     | text      | text        |
| Yes      | series tag     | cooling_fuel                             | Cooling Fuel                             | text      | text        |
| Yes      | series tag     | heating_fuel                             | Heating Fuel                             | text      | text        |
| Yes      | series tag     | hot_water_fuel                           | Hot Water Fuel                           | text      | text        |
| Yes      | series tag     | preventative_maintenance_plan_available  | Preventative Maintenance Plan Available  | text      | text        |
| Yes      | numeric metric | owned_parking_spaces_for_this_structure  | Owned Parking Spaces For This Structure  | number    | number      |
| Yes      | numeric metric | leased_parking_spaces_for_this_structure | Leased Parking Spaces For This Structure | number    | number      |
| Yes      | series tag     | part_of_which_facility                   | Part of Which Facility                   | text      | text        |
| No       |                | date_acquired                            | Date Acquired                            | text      | text        |
| Yes      | numeric metric | initial_acquisition_cost                 | Initial Acquisition Cost                 | money     | money       |
| Yes      | series tag     | acquisition_method                       | Acquisition Method                       | text      | text        |
| Yes      | numeric metric | building_value                           | Building Value                           | money     | money       |
| Yes      | numeric metric | content_value                            | Content Value                            | money     | money       |
| Yes      | series tag     | deed_restrictions                        | Deed Restrictions                        | text      | text        |
| Yes      | series tag     | deed_restriction_description             | Deed Restriction Description             | text      | text        |
| Yes      | series tag     | opm_building_number                      | OPM Building Number                      | text      | text        |
| Yes      | series tag     | dpw_building_number                      | DPW Building Number                      | text      | text        |
| Yes      | series tag     | comptroller_building_number              | Comptroller Building Number              | text      | number      |
| Yes      | series tag     | fire_marshall_building_number            | Fire Marshall Building Number            | text      | number      |
| Yes      | numeric metric | total_acres                              | Total Acres                              | number    | number      |
| Yes      | numeric metric | undeveloped_acres                        | Undeveloped Acres                        | number    | number      |
| Yes      | series tag     | structure_classification                 | Structure Classification                 | text      | text        |

Time Field

Value = updated_at
Format & Zone = seconds

Series Fields

Excluded Fields = address,date_acquired

Data Commands

series e:r8ci-yhcn d:2015-11-05T06:32:27.000Z t:part_of_which_facility="Capitol Community Technical College" t:zip_code=06106 t:preventative_maintenance_plan_available=Yes t:condition=Excellent t:construction_type="Type 3" t:5_year_use_recommendation="educational institution" t:agency_number=7701 t:agency_name="Board of Trustees Of Community Technical Colleges" t:structure_classification=Education t:acquisition_method=Purchased t:nearest_crossroads="Interstate 91 and 84" t:reference_number=7701-7107 t:on_or_eligible_for_historic_register=Yes t:structure_name="Capital Community College" t:occupancy_status="Currently being utilized" t:deed_restrictions=No t:memo_field="40,000 of additional space leased, funding for tenant fit out bonded 1/08" t:town=Hartford t:2_year_use_recommendation="educationall institution" m:year_of_construction=2000 m:building_value=0 m:number_of_floors=11 m:owned_parking_spaces_for_this_structure=0 m:square_feet_currently_utilized=171257 m:utilization_rate=100 m:square_feet_not_utilized=0 m:net_usable_square_feet=171257 m:year_of_last_major_renovation=2002 m:leased_parking_spaces_for_this_structure=500 m:gross_square_feet=304000

series e:r8ci-yhcn d:2015-11-05T06:32:29.000Z t:reference_number=3100-2456 t:occupancy_status="Vacant - not surplus to agency needs" t:structure_name=House t:part_of_which_facility="Not Part Of A Facility" t:zip_code=06756 t:town=Goshen t:agency_number=3100 t:agency_name="Department of Environmental Protection" m:building_value=89580.6 m:square_feet_currently_utilized=0 m:utilization_rate=0 m:square_feet_not_utilized=0 m:net_usable_square_feet=1 m:gross_square_feet=1

series e:r8ci-yhcn d:2015-11-05T06:32:27.000Z t:part_of_which_facility="Three Rivers Community Technical College" t:zip_code=06360 t:preventative_maintenance_plan_available=Yes t:opm_building_number=7709-35 t:condition=Good t:comptroller_building_number=4 t:cooling_fuel="Not Cooled" t:construction_type="Type 5" t:dpw_building_number=48389 t:5_year_use_recommendation="Norwich technical high school" t:agency_number=7701 t:agency_name="Board of Trustees Of Community Technical Colleges" t:structure_classification=Education t:nearest_crossroads="Ox Hill Road & Mahan Drive" t:reference_number=7701-35 t:used_to_house_clients=No t:on_or_eligible_for_historic_register=No t:structure_name="Mohegan Campus" t:occupancy_status="Currently being utilized" t:memo_field="Konvoer on construction on site for Votech project, active construction site for project. Should be complete during fall 2008." t:town=Norwich t:2_year_use_recommendation="care and custody will be turned over to technical high school within 1 year.  Three Rives still using campus for temporary space until Thames new construction complete." t:heating_fuel="Not Heated" m:year_of_construction=1966 m:building_value=9696410.33 m:number_of_floors=3 m:owned_parking_spaces_for_this_structure=461 m:square_feet_currently_utilized=65600 m:utilization_rate=100 m:content_value=2115739 m:total_acres=40.7 m:square_feet_not_utilized=0 m:net_usable_square_feet=65600 m:leased_parking_spaces_for_this_structure=0 m:gross_square_feet=102000 m:initial_acquisition_cost=3185090

Meta Commands

metric m:year_of_construction p:integer l:"Year of Construction" t:dataTypeName=number

metric m:year_of_last_major_renovation p:integer l:"Year of Last Major Renovation" t:dataTypeName=number

metric m:gross_square_feet p:integer l:"Gross Square Feet" t:dataTypeName=number

metric m:net_usable_square_feet p:integer l:"Net Usable Square Feet" t:dataTypeName=number

metric m:square_feet_currently_utilized p:integer l:"Square Feet Currently Utilized" t:dataTypeName=number

metric m:square_feet_not_utilized p:double l:"Square Feet Not Utilized" t:dataTypeName=number

metric m:utilization_rate p:float l:"Utilization Rate" t:dataTypeName=percent

metric m:number_of_floors p:double l:"Number of Floors" t:dataTypeName=number

metric m:number_of_clients_currently_housed p:integer l:"Number of Clients Currently Housed" t:dataTypeName=number

metric m:owned_parking_spaces_for_this_structure p:integer l:"Owned Parking Spaces For This Structure" t:dataTypeName=number

metric m:leased_parking_spaces_for_this_structure p:integer l:"Leased Parking Spaces For This Structure" t:dataTypeName=number

metric m:initial_acquisition_cost p:double l:"Initial Acquisition Cost" t:dataTypeName=money

metric m:building_value p:double l:"Building Value" t:dataTypeName=money

metric m:content_value p:double l:"Content Value" t:dataTypeName=money

metric m:total_acres p:double l:"Total Acres" t:dataTypeName=number

metric m:undeveloped_acres p:double l:"Undeveloped Acres" t:dataTypeName=number

entity e:r8ci-yhcn l:"State Owned Buildings" t:attribution="Office of Policy and Management" t:url=https://data.ct.gov/api/views/r8ci-yhcn

property e:r8ci-yhcn t:meta.view v:id=r8ci-yhcn v:category=Government v:attributionLink=http://www.ct.gov/opm/finance v:averageRating=0 v:name="State Owned Buildings" v:attribution="Office of Policy and Management"

property e:r8ci-yhcn t:meta.view.license v:name="Public Domain"

property e:r8ci-yhcn t:meta.view.owner v:id=cvy9-n6sb v:screenName="Tyler Kleykamp" v:lastNotificationSeenAt=1492608796 v:displayName="Tyler Kleykamp"

property e:r8ci-yhcn t:meta.view.tableauthor v:id=cvy9-n6sb v:screenName="Tyler Kleykamp" v:roleName=administrator v:lastNotificationSeenAt=1492608796 v:displayName="Tyler Kleykamp"

Top Records

| :updated_at | agency_name                                       | reference_number | agency_number | structure_name                            | address           | town          | zip_code | nearest_crossroads          | condition | construction_type | year_of_construction | year_of_last_major_renovation | gross_square_feet | net_usable_square_feet | square_feet_currently_utilized | square_feet_not_utilized | utilization_rate | number_of_floors | 2_year_use_recommendation                                                                                                                                               | 5_year_use_recommendation     | memo_field                                                                                                                                                                                                | used_to_house_clients | number_of_clients_currently_housed | occupancy_status                     | on_or_eligible_for_historic_register | cooling_fuel        | heating_fuel        | hot_water_fuel      | preventative_maintenance_plan_available | owned_parking_spaces_for_this_structure | leased_parking_spaces_for_this_structure | part_of_which_facility                     | date_acquired | initial_acquisition_cost | acquisition_method | building_value | content_value | deed_restrictions | deed_restriction_description | opm_building_number | dpw_building_number | comptroller_building_number | fire_marshall_building_number | total_acres        | undeveloped_acres | structure_classification | 
| =========== | ================================================= | ================ | ============= | ========================================= | ================= | ============= | ======== | =========================== | ========= | ================= | ==================== | ============================= | ================= | ====================== | ============================== | ======================== | ================ | ================ | ======================================================================================================================================================================= | ============================= | ========================================================================================================================================================================================================= | ===================== | ================================== | ==================================== | ==================================== | =================== | =================== | =================== | ======================================= | ======================================= | ======================================== | ========================================== | ============= | ======================== | ================== | ============== | ============= | ================= | ============================ | =================== | =================== | =========================== | ============================= | ================== | ================= | ======================== | 
| 1446705147  | Board of Trustees Of Community Technical Colleges | 7701-7107        | 7701          | Capital Community College                 | 950 Main Street   | Hartford      | 06106    | Interstate 91 and 84        | Excellent | Type 3            | 2000                 | 2002                          | 304000            | 171257                 | 171257                         | 0                        | 100.00           | 11               | educationall institution                                                                                                                                                | educational institution       | 40,000 of additional space leased, funding for tenant fit out bonded 1/08                                                                                                                                 |                       |                                    | Currently being utilized             | Yes                                  |                     |                     |                     | Yes                                     | 0                                       | 500                                      | Capitol Community Technical College        | 01-Sep-02     |                          | Purchased          | 0.00           |               | No                |                              |                     |                     |                             |                               |                    |                   | Education                | 
| 1446705149  | Department of Environmental Protection            | 3100-2456        | 3100          | House                                     | Anthena           | Goshen        | 06756    |                             |           |                   |                      |                               | 1                 | 1                      | 0                              | 0                        | 0.00             |                  |                                                                                                                                                                         |                               |                                                                                                                                                                                                           |                       |                                    | Vacant - not surplus to agency needs |                                      |                     |                     |                     |                                         |                                         |                                          | Not Part Of A Facility                     |               |                          |                    | 89580.60       |               |                   |                              |                     |                     |                             |                               |                    |                   |                          | 
| 1446705147  | Board of Trustees Of Community Technical Colleges | 7701-35          | 7701          | Mohegan Campus                            | Mahan Drive       | Norwich       | 06360    | Ox Hill Road & Mahan Drive  | Good      | Type 5            | 1966                 |                               | 102000            | 65600                  | 65600                          | 0                        | 100.00           | 3                | care and custody will be turned over to technical high school within 1 year. Three Rives still using campus for temporary space until Thames new construction complete. | Norwich technical high school | Konvoer on construction on site for Votech project, active construction site for project. Should be complete during fall 2008.                                                                            | No                    |                                    | Currently being utilized             | No                                   | Not Cooled          | Not Heated          |                     | Yes                                     | 461                                     | 0                                        | Three Rivers Community Technical College   |               | 3185090.00               |                    | 9696410.33     | 2115739.00    |                   |                              | 7709-35             | 48389               | 4                           |                               | 40.700000000000003 |                   | Education                | 
| 1446705147  | Board of Trustees Of Community Technical Colleges | 7701-64          | 7701          | Goulet House                              | Park Place        | Winchester    | 06098    | Rt 8 and Rt.44              | Excellent | Type 1            | 1924                 | 2001                          | 5283              | 2300                   | 2300                           | 0                        | 100.00           | 2                | renovation Nov 2001, to be used for student support services                                                                                                            |                               | bid for demo march 2008                                                                                                                                                                                   |                       |                                    | Vacant - not surplus to agency needs |                                      | Electric            | Natural Gas/Propane | Electric            |                                         |                                         |                                          | Northwestern Connecticut Community College |               | 88800.00                 |                    | 94913.58       | 0.00          |                   |                              | 7709-64             |                     | 16                          | 103                           |                    |                   | Education                | 
| 1446705147  | Central Connecticut State University              | 7802-7128        | 7802          | Maintenance, Recycling, De-icing Facility | 1615 Stanley St/  | New Britain   | 06050    | Lester St/Coccomo Circle    | Excellent | Type 4            | 2012                 |                               | 4503              | 4032                   | 4032                           | 0                        | 100.00           | 1                | Maintenance,Recycling, De-icing Facility Maintenance, Recycling, de-icing facility                                                                                      | Same Same                     |                                                                                                                                                                                                           | No                    |                                    | Currently being utilized             | No                                   | Not Cooled          | Natural Gas/Propane | Natural Gas/Propane |                                         | 11                                      |                                          | Central Connecticut State University       |               |                          | Constructed        |                |               |                   |                              |                     |                     |                             |                               |                    |                   | Maintenance/Repair Shop  | 
| 1446705149  | Department of Environmental Protection            | 3100-2388        | 3100          | Radio                                     | Talcott Mountain  | Avon          | 06001    |                             |           |                   |                      |                               | 1                 | 1                      | 0                              | 0                        | 0.00             |                  |                                                                                                                                                                         |                               |                                                                                                                                                                                                           |                       |                                    | Vacant - not surplus to agency needs |                                      |                     |                     |                     |                                         |                                         |                                          | Talcott Mountain State Park                |               |                          |                    | 10211.56       | 0.00          |                   |                              |                     |                     |                             |                               |                    |                   |                          | 
| 1446705147  | Department of Administrative Services             | 1326-527         | 1326          | Residence 2 (DMR)                         | Undercliff Road   | Meriden       | 06451    | Chamberlain Hwy             | Good      | Type 2            | 1931                 |                               | 2880              | 2000                   | 2000                           | 0                        | 100.00           | 2                | Continue current use.                                                                                                                                                   | Continue Current Use          | Used by DMR.                                                                                                                                                                                              | Yes                   |                                    | Currently being utilized             | Yes                                  | Not Cooled          | Not Heated          |                     | No                                      | 4                                       | 0                                        | Altobello Youth Center                     | 01-Jan-31     | 10800.00                 |                    | 79304.15       | 0.00          |                   |                              | 1326-527            | 34656               | 7                           | 136                           |                    |                   |                          | 
| 1446705147  | Commission On Fire Prevention & Control           | 2304-1           | 2304          | Administration Building                   | 34 Perimeter Road | Windsor Locks | 06096    | Rt 75 Ella Grasso Turnpike  | Excellent | Type 5            | 1994                 |                               | 40000             | 40000                  | 40000                          | 0                        | 100.00           | 3                | Building Is Fully Utilized. Plans Are To Continue Using The Space As Is Currently Utilized.                                                                             | Same                          | Lack of storage space, DPW Roofing Warranty issues ongoing, New HVAC Automation System for Energy Management being implimented                                                                            | Yes                   | 0                                  | Currently being utilized             | No                                   | Multiple Fuels Used | Multiple Fuels Used | Natural Gas/Propane | Yes                                     | 185                                     | 0                                        | Connecticut Fire Academy                   | 23-Jan-94     | 7000000.00               | Constructed        | 7574854.56     | 797559.00     | No                |                              | 2304-1              | 71408               | 1                           |                               | 8                  | 0                 | Education                | 
| 1446705147  | Commission On Fire Prevention & Control           | 2304-4           | 2304          | Fire Training Burn Building               | 34 Perimeter Road | Windsor Locks | 06096    | Rt 75 Ella Grasso Turnpike  | Excellent | Type 5            | 1994                 |                               | 4800              | 4500                   | 4500                           | 0                        | 100.00           | 2                | Building Is Fully Utilized. Plans Are To Continue Using Space As Is Currently Utilized.                                                                                 | Same                          | This building is used by Bradley Airport Fire Station 2, Hartford County Emergency Plan and the Commission on Fire Prevention and Control. All town and municipal departments utilize this burn building. | No                    |                                    | Currently being utilized             | No                                   | Not Cooled          | Electric            | No Hot Water        | Yes                                     | 10                                      | 0                                        | Connecticut Fire Academy                   | 23-Jan-94     | 1500000.00               | Constructed        | 1623183.12     | 59938.00      | No                |                              | 2304-4              | 71424               | 2                           |                               | 2                  |                   | Education                | 
| 1446705147  | Commission On Fire Prevention & Control           | 2304-2           | 2304          | Fire Station Maintenance Garage           | 34 Perimeter Road | Windsor Locks | 06096    | Rt. 75 Ella Grasso Turnpike | Excellent | Type 4            | 1994                 |                               | 12264             | 12200                  | 12200                          | 0                        | 100.00           | 1                | Building Is Fully Utilized. Plans Are To Continue Using Space As Is Currently Utilized.                                                                                 | Same                          | This building is shared with Bradley Airport.                                                                                                                                                             | Yes                   | 3                                  | Currently being utilized             | No                                   | Electric            | Natural Gas/Propane | Natural Gas/Propane | Yes                                     | 12                                      | 0                                        | Connecticut Fire Academy                   | 23-Jan-94     | 2000000.00               | Constructed        | 2164244.16     | 972242.00     | No                |                              | 2304-2              | 71416               | 4                           |                               | 3                  |                   | Other                    |