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.251088

Tables

2024 Mineral Interest List

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_mineral_interest_list

51.56 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 Personal Property Inventory List

@usgov.state_of_oklahoma_2024_real_property_asset_report_data.n_2024_personal_property_inventory_list

2.71 MB
235890 rows
8 columns


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

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.22 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

129.78 KB
1586 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,
  "lease_class" VARCHAR,
  "primary_or_sub_lease" VARCHAR,
  "primary_lease_no" VARCHAR,
  "sub_lease_no" VARCHAR,
  "area_of_government" VARCHAR,
  "property_type" VARCHAR,
  "property_no" VARCHAR,
  "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,
  "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

790.73 KB
18699 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_name" VARCHAR,
  "bonding_financing_agency" VARCHAR,
  "bonded_financed" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county_name" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired_4_digit_year" 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,
  "property_condition" VARCHAR,
  "percent_of_property_being_utilized" DOUBLE,
  "year_built_4_digit_year" DOUBLE,
  "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

37.95 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_name" VARCHAR,
  "bonding_financing_agency" VARCHAR,
  "bonded_financed" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county_name" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired_4_digit_year" DOUBLE,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE,
  "appraised_value" BIGINT,
  "replacement_value" DOUBLE,
  "annual_utility_costs_electric" BIGINT,
  "annual_utility_costs_gas" BIGINT,
  "annual_utility_costs_water_sewage" BIGINT,
  "property_condition" VARCHAR,
  "percent_of_property_being_utilized" BIGINT,
  "year_built_4_digit_year" DOUBLE,
  "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

50.87 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_name" VARCHAR,
  "bonding_financing_agency" VARCHAR,
  "bonded_financed" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county_name" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired_4_digit_year" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" VARCHAR,
  "appraised_value" DOUBLE,
  "replacement_value" DOUBLE,
  "annual_utility_costs_electric" DOUBLE,
  "annual_utility_costs_gas" DOUBLE,
  "annual_utility_costs_water_sewage" DOUBLE,
  "property_condition" VARCHAR,
  "percent_of_property_being_utilized" BIGINT,
  "year_built_4_digit_year" DOUBLE,
  "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

170.36 KB
3999 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,
  "subsection_id" VARCHAR,
  "row_purpose" VARCHAR,
  "row_project" VARCHAR,
  "row_id" VARCHAR,
  "route_turnpike" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "list_value" DOUBLE,
  "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

92.13 KB
3330 rows
20 columns


CREATE TABLE n_2024_turnpike_authority_rights_of_way_inventory_list (
  "property_no" VARCHAR,
  "agency_name" VARCHAR,
  "ownership_status" VARCHAR,
  "property_type" VARCHAR,
  "county_name" VARCHAR,
  "parcel" VARCHAR,
  "subsection_id" VARCHAR,
  "row_purpose" VARCHAR,
  "row_project" VARCHAR,
  "row_id" VARCHAR,
  "route_turnpike" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "list_value" DOUBLE,
  "percent_of_property_being_utilized" DOUBLE,
  "acres_of_undeveloped_land" DOUBLE,
  "acres_of_land_used_by_state" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);