About this Dataset

2024 Real Property Asset Report 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: 2024-12-27T21:07:32.251091

Tables

2024 Mineral Interest List

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_mineral_interest_list

52.8 kB
490 rows
26 columns

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

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

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_real_property_inventory_list_abc_s_with_no_real_property

5.35 kB
51 rows
3 columns

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

2024 Real Property Inventory List - Leased

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_real_property_inventory_list_leased

132.89 kB
1,586 rows
34 columns

CREATE TABLE n_2024_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" 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,
  "total_leased_space" DOUBLE,
  "unit_of_measure" VARCHAR,
  "annual_cost" DOUBLE,
  "percent_of_property_being_utilized" DOUBLE,
  "agency_staff_assigned_to_location" DOUBLE,
  "risk_management_number" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2024 Real Property Inventory List - Owned

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_real_property_inventory_list_owned

809.71 kB
18,699 rows
47 columns

CREATE TABLE n_2024_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" VARCHAR  -- 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" 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" VARCHAR
);

2024 Report Of Five (5) Percent Most Underutilized Properties

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_report_of_five_5_percent_most_underutilized_properties

38.86 kB
10 rows
49 columns

CREATE TABLE n_2024_report_of_five_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" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE  -- ESTIMATED VALUE ($),
  "appraised_value" BIGINT  -- 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" BIGINT,
  "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
);

2024 Report Of Underutilized Properties

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_report_of_underutilized_properties

52.09 kB
203 rows
48 columns

CREATE TABLE n_2024_report_of_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" 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" VARCHAR  -- Year Property Acquired (4 Digit Year),
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" VARCHAR  -- 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" DOUBLE  -- Annual Utility Costs-Water/Sewage ($),
  "property_condition" VARCHAR,
  "percent_of_property_being_utilized" BIGINT,
  "year_built_4_digit_year" DOUBLE  -- Year Built (4 Digit Year),
  "agency_employees_at_this_location" BIGINT,
  "square_feet_occupied_by_your_agency" DOUBLE,
  "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
);

2024 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_transportation_department_rights_of_way_inventory_list

174.45 kB
3,999 rows
20 columns

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

2024 Turnpike Authority Rights Of Way Inventory List

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_turnpike_authority_rights_of_way_inventory_list

94.34 kB
3,330 rows
20 columns

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