About this Dataset

2023 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: 2023-12-29T13:58:15.262468
Tags: real-property-assets, real-property-inventory

Tables

2023 Mineral Interest List

@usgov.state_of_oklahoma_2023_real_property_asset_data.n_2023_mineral_interest_list

52.38 kB
491 rows
26 columns

CREATE TABLE n_2023_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
);

2023 Personal Property

@usgov.state_of_oklahoma_2023_real_property_asset_data.n_2023_personal_property

2 MB
166,758 rows
8 columns

CREATE TABLE n_2023_personal_property (
  "agency_code" DOUBLE,
  "state_agency" VARCHAR,
  "property_type" VARCHAR,
  "property_classification" VARCHAR,
  "property_name" VARCHAR,
  "date_acquired_or_installed" VARCHAR,
  "value_or_cost" VARCHAR,
  "it_non_it" VARCHAR
);

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

@usgov.state_of_oklahoma_2023_real_property_asset_data.n_2023_real_property_inventory_list_abc_s_with_no_real_property

5.35 kB
51 rows
3 columns

CREATE TABLE n_2023_real_property_inventory_list_abc_s_with_no_real_property (
  "agency_number" VARCHAR,
  "state_agency" VARCHAR,
  "property_classification" VARCHAR
);

2023 Real Property Inventory List-Leased

@usgov.state_of_oklahoma_2023_real_property_asset_data.n_2023_real_property_inventory_list_leased

100.42 kB
1,013 rows
33 columns

CREATE TABLE n_2023_real_property_inventory_list_leased (
  "predominant_use" VARCHAR,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "location_type" VARCHAR,
  "state_owned" VARCHAR  -- STATE OWNED?,
  "lease_class" VARCHAR,
  "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" TIMESTAMP,
  "year_property_acquired_4_digit_year" TIMESTAMP  -- YEAR PROPERTY ACQUIRED (4 DIGIT YEAR),
  "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
);

2023 Real Property Inventory List-Owned

@usgov.state_of_oklahoma_2023_real_property_asset_data.n_2023_real_property_inventory_list_owned

745.88 kB
16,971 rows
47 columns

CREATE TABLE n_2023_real_property_inventory_list_owned (
  "predominant_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "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" VARCHAR,
  "estimated_value" VARCHAR  -- ESTIMATED VALUE ($),
  "appraised_value" DOUBLE  -- APPRAISED VALUE ($),
  "replacement_value" DOUBLE  -- REPLACEMENT VALUE ($),
  "annual_utility_costs_electric" VARCHAR  -- ANNUAL UTILITY COSTS-ELECTRIC ($),
  "annual_utility_costs_gas" VARCHAR  -- 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" VARCHAR,
  "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" VARCHAR
);

2023 Report Of 5 Percent Most Underutilized Properties

@usgov.state_of_oklahoma_2023_real_property_asset_data.n_2023_report_of_5_percent_most_underutilized_properties

38.88 kB
10 rows
49 columns

CREATE TABLE n_2023_report_of_5_percent_most_underutilized_properties (
  "predominant_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "location_type" VARCHAR,
  "ownership_status" VARCHAR,
  "area_of_government" VARCHAR,
  "property_type" VARCHAR,
  "campus_code" VARCHAR,
  "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" BIGINT  -- ANNUAL UTILITY COSTS-ELECTRIC ($),
  "annual_utility_costs_gas" BIGINT  -- ANNUAL UTILITY COSTS-GAS ($),
  "annual_utility_costs_water_sewage" BIGINT  -- 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" BIGINT,
  "square_feet_occupied_by_your_agency" BIGINT,
  "square_feet_of_the_building_being_outleased" BIGINT,
  "acres_of_land_being_outleased" BIGINT,
  "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
);

2023 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2023_real_property_asset_data.n_2023_transportation_department_rights_of_way_inventory_list

174.45 kB
3,999 rows
20 columns

CREATE TABLE n_2023_transportation_department_rights_of_way_inventory_list (
  "agency" 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
);

2023 Turnpike Authority Rights Of Way Inventory LIst

@usgov.state_of_oklahoma_2023_real_property_asset_data.n_2023_turnpike_authority_rights_of_way_inventory_list

94.34 kB
3,330 rows
20 columns

CREATE TABLE n_2023_turnpike_authority_rights_of_way_inventory_list (
  "property_no" VARCHAR  -- PROPERTY NO.,
  "agency_name" 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" DOUBLE,
  "acres_of_undeveloped_land" DOUBLE,
  "acres_of_land_used_by_state" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);