About this Dataset

2022 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-12-30T10:30:19.282067
Tags: real-property-assets, real-property-inventory

Tables

2022 Mineral Interest List

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_mineral_interest_list

52.39 kB
491 rows
26 columns

CREATE TABLE n_2022_mineral_interest_list (
  "file_number" VARCHAR,
  "pooled_or_unitized" VARCHAR,
  "owner_agency" VARCHAR,
  "lessor" VARCHAR,
  "active_or_expired" VARCHAR,
  "county" VARCHAR,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "tract_number" DOUBLE,
  "legal_description" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "net_acres" VARCHAR,
  "gross_acres" DOUBLE,
  "original_lessee" VARCHAR,
  "current_lessee" VARCHAR,
  "lease_number" VARCHAR,
  "royalty_interest" DOUBLE,
  "well_name" VARCHAR,
  "well_operator" VARCHAR,
  "production_zone" VARCHAR,
  "sale_or_approved_date" VARCHAR,
  "end_or_expiration_date" VARCHAR,
  "bonus" VARCHAR
);

2022 Personal Property

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_personal_property

2.69 MB
232,713 rows
8 columns

CREATE TABLE n_2022_personal_property (
  "agency_code" BIGINT,
  "state_agency" VARCHAR,
  "property_type" VARCHAR,
  "property_classification" VARCHAR,
  "property_name" VARCHAR,
  "date_acquired_or_installed" VARCHAR,
  "n__value_or_cost" VARCHAR  -- VALUE OR COST,
  "it_non_it" VARCHAR
);

2022 Real Property Inventory List-ABC's With No Real Property

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_real_property_inventory_list_abc_s_with_no_real_property

21.97 kB
51 rows
34 columns

CREATE TABLE n_2022_real_property_inventory_list_abc_s_with_no_real_property (
  "agency_number" VARCHAR,
  "state_agency" VARCHAR,
  "property_classification" VARCHAR,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "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,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33
);

2022 Real Property Inventory List-Leased

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_real_property_inventory_list_leased

111.91 kB
1,178 rows
32 columns

CREATE TABLE n_2022_real_property_inventory_list_leased (
  "predominant_use" VARCHAR,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "location_type" VARCHAR,
  "ownership_status" VARCHAR,
  "state_owned" VARCHAR  -- STATE OWNED?,
  "primary_or_sub_lease" VARCHAR  -- PRIMARY OR SUB-LEASE?,
  "primary_lease_no" VARCHAR  -- PRIMARY LEASE NO.,
  "sub_lease_no" VARCHAR  -- SUB-LEASE NO.,
  "area_of_government" VARCHAR,
  "property_type" VARCHAR,
  "property_no" VARCHAR  -- PROPERTY NO.,
  "property_name" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county_name" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "initial_occupancy" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "total_leased_space" VARCHAR,
  "unit_of_measure" VARCHAR,
  "percent_of_property_being_utilized" BIGINT,
  "agency_staff_assigned_to_location" DOUBLE,
  "risk_management_number" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2022 Real Property Inventory List-Owned

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_real_property_inventory_list_owned

764.81 kB
17,053 rows
47 columns

CREATE TABLE n_2022_real_property_inventory_list_owned (
  "predominant_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_number" BIGINT,
  "agency_shell_pk_agency_name" VARCHAR  -- AGENCY SHELL PK / AGENCY NAME,
  "location_type" VARCHAR,
  "ownership_status" VARCHAR,
  "area_of_government" VARCHAR,
  "property_type" VARCHAR,
  "campus_code" DOUBLE,
  "property_no" VARCHAR  -- PROPERTY NO.,
  "property_name" VARCHAR,
  "bonding_financing_agency" VARCHAR  -- BONDING / FINANCING AGENCY,
  "bonded_financed" VARCHAR  -- BONDED / FINANCED?,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county_name" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired_4_digit_year" DOUBLE  -- YEAR PROPERTY ACQUIRED (4 DIGIT YEAR),
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE  -- ESTIMATED VALUE ($),
  "appraised_value" DOUBLE  -- APPRAISED VALUE ($),
  "replacement_value" VARCHAR  -- REPLACEMENT VALUE ($),
  "annual_utility_costs_electric" VARCHAR  -- ANNUAL UTILITY COSTS-ELECTRIC ($),
  "annual_utility_costs_gas" DOUBLE  -- ANNUAL UTILITY COSTS-GAS ($),
  "annual_utility_costs_water_sewage" DOUBLE  -- ANNUAL UTILITY COSTS-WATER/SEWAGE ($),
  "property_condition" VARCHAR,
  "percent_of_property_being_utilized" DOUBLE,
  "year_built_4_digit_year" DOUBLE  -- YEAR BUILT (4 DIGIT YEAR),
  "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_management_number" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "latitude" VARCHAR,
  "longitude" DOUBLE
);

2022 Report Of 5 Percent Most Underutilized Properties

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_report_of_5_percent_most_underutilized_properties

39.34 kB
11 rows
49 columns

CREATE TABLE n_2022_report_of_5_percent_most_underutilized_properties (
  "predominant_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_number" BIGINT,
  "agency_shell_pk_agency_name" VARCHAR  -- AGENCY SHELL PK / AGENCY NAME,
  "location_type" VARCHAR,
  "ownership_status" VARCHAR,
  "area_of_government" VARCHAR,
  "property_type" VARCHAR,
  "campus_code" DOUBLE,
  "property_no" VARCHAR  -- PROPERTY NO.,
  "property_name" VARCHAR,
  "bonding_financing_agency" VARCHAR  -- BONDING / FINANCING AGENCY,
  "bonded_financed" VARCHAR  -- BONDED / FINANCED?,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county_name" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired_4_digit_year" DOUBLE  -- YEAR PROPERTY ACQUIRED (4 DIGIT YEAR),
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE  -- ESTIMATED VALUE ($),
  "appraised_value" DOUBLE  -- APPRAISED VALUE ($),
  "replacement_value" DOUBLE  -- REPLACEMENT VALUE ($),
  "annual_utility_costs_electric" DOUBLE  -- ANNUAL UTILITY COSTS-ELECTRIC ($),
  "annual_utility_costs_gas" DOUBLE  -- ANNUAL UTILITY COSTS-GAS ($),
  "annual_utility_costs_water_sewage" VARCHAR  -- ANNUAL UTILITY COSTS-WATER/SEWAGE ($),
  "property_condition" VARCHAR,
  "percent_of_property_being_utilized" DOUBLE,
  "year_built_4_digit_year" DOUBLE  -- YEAR BUILT (4 DIGIT YEAR),
  "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_management_number" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "omes_estimated_value" VARCHAR,
  "taxes" VARCHAR
);

2022 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_transportation_department_rights_of_way_inventory_list

174.53 kB
3,999 rows
20 columns

CREATE TABLE n_2022_transportation_department_rights_of_way_inventory_list (
  "agency_shell_pk" VARCHAR,
  "location_type" VARCHAR,
  "ownership_status" VARCHAR,
  "property_type" VARCHAR,
  "county_name" VARCHAR,
  "parcel" VARCHAR  -- PARCEL #,
  "subsection_id" VARCHAR,
  "row_purpose" VARCHAR,
  "row_project" VARCHAR  -- ROW PROJECT #,
  "row_id" VARCHAR  -- ROW ID #,
  "route_turnpike" VARCHAR  -- ROUTE / TURNPIKE,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "list_value" DOUBLE  -- LIST VALUE ($),
  "percent_of_property_being_utilized" BIGINT,
  "acres_of_undeveloped_land" DOUBLE,
  "acres_of_land_used_by_state" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2022 Turnpike Authority Rights Of Way Inventory List

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_turnpike_authority_rights_of_way_inventory_list

69.89 kB
3,238 rows
20 columns

CREATE TABLE n_2022_turnpike_authority_rights_of_way_inventory_list (
  "agency_shell_pk" VARCHAR,
  "location_type" VARCHAR,
  "ownership_status" VARCHAR,
  "property_type" VARCHAR,
  "county_name" VARCHAR,
  "parcel" VARCHAR  -- PARCEL #,
  "subsection_id" VARCHAR,
  "row_purpose" VARCHAR,
  "row_project" VARCHAR  -- ROW PROJECT #,
  "row_id" VARCHAR  -- ROW ID #,
  "route_turnpike" VARCHAR  -- ROUTE / TURNPIKE,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "list_value" BIGINT  -- LIST VALUE ($),
  "percent_of_property_being_utilized" BIGINT,
  "acres_of_undeveloped_land" BIGINT,
  "acres_of_land_used_by_state" DOUBLE,
  "latitude" BIGINT,
  "longitude" BIGINT
);