About this Dataset

2021 Real Property Asset Data

The Oklahoma Real Property Asset Report is published annually in compliance with the Oklahoma State Government Asset Reduction and Cost Savings Program found in Title 62 O.S. §908. The act requires the Office of Management and Enterprise Services (OMES) to compile and maintain a comprehensive inventory of all real property owned and leased by the state. All data contained in this report was self-reported by each state agency, board, commission, or public trust having the State of Oklahoma as a beneficiary.
Organization: State of Oklahoma
Last updated: 2022-01-25T01:44:52.427274
Tags: real-property-assets, real-property-inventory

Tables

2021 Real Property Inventory List-Owned

@usgov.state_of_oklahoma_2021_real_property_asset_data.n_2021_real_property_inventory_list_owned

704.19 kB
16,984 rows
46 columns

CREATE TABLE n_2021_real_property_inventory_list_owned (
  "predominant_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_number" DOUBLE,
  "state_agency" VARCHAR,
  "location_type" VARCHAR,
  "ownership_status" VARCHAR,
  "area_of_government" VARCHAR,
  "type_of_property" VARCHAR,
  "campus_code" VARCHAR,
  "property_name" VARCHAR,
  "bonding_financing_agency" VARCHAR  -- BONDING/ FINANCING AGENCY,
  "bonded_financed" VARCHAR  -- BONDED/ FINANCED?,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" VARCHAR,
  "estimated_value" VARCHAR,
  "appraised_value" DOUBLE,
  "replacement_value" DOUBLE,
  "annual_utility_costs_electric" VARCHAR,
  "annual_utility_costs_gas" VARCHAR,
  "annual_utility_costs_water_sewage" VARCHAR  -- ANNUAL UTILITY COSTS-WATER/ SEWAGE,
  "property_condition" VARCHAR,
  "percent_of_property_being_utilized" DOUBLE,
  "year_built" VARCHAR,
  "agency_employees_at_this_location" DOUBLE,
  "square_feet_occupied_by_your_agency" DOUBLE,
  "square_feet_of_the_building_being_outleased" DOUBLE,
  "acres_of_land_being_outleased" DOUBLE,
  "vacant_square_footage" DOUBLE,
  "listed_on_the_national_register_of_historic_places" VARCHAR,
  "listed_with_the_national_trust_for_historic_preservation" VARCHAR,
  "property_is_of_potential_historic_significance" VARCHAR,
  "risk_mgmt_number" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);