Baselight
Sign In

2022 Real Property Asset Data

State of Oklahoma

@usgov.state_of_oklahoma_2022_real_property_asset_data

Loading...
Loading...

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.282062
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
  • 51.16 KB
  • 491 rows
  • 26 columns
Loading... 

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.56 MB
  • 232713 rows
  • 8 columns
Loading... 

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,
  "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.46 KB
  • 51 rows
  • 34 columns
Loading... 

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_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR
);

2022 Real Property Inventory List-Leased

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_real_property_inventory_list_leased
  • 109.29 KB
  • 1178 rows
  • 32 columns
Loading... 

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,
  "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,
  "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
  • 746.89 KB
  • 17053 rows
  • 47 columns
Loading... 

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,
  "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" DOUBLE,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE,
  "appraised_value" DOUBLE,
  "replacement_value" VARCHAR,
  "annual_utility_costs_electric" VARCHAR,
  "annual_utility_costs_gas" DOUBLE,
  "annual_utility_costs_water_sewage" DOUBLE,
  "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" 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
  • 38.42 KB
  • 11 rows
  • 49 columns
Loading... 

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,
  "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" DOUBLE,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE,
  "appraised_value" DOUBLE,
  "replacement_value" DOUBLE,
  "annual_utility_costs_electric" DOUBLE,
  "annual_utility_costs_gas" DOUBLE,
  "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" DOUBLE,
  "longitude" DOUBLE,
  "omes_estimated_value" VARCHAR,
  "taxes" VARCHAR
);

2022 Report Of Underutilized Properties

@usgov.state_of_oklahoma_2022_real_property_asset_data.n_2022_report_of_underutilized_properties
  • 52.92 KB
  • 216 rows
  • 48 columns
Loading... 

CREATE TABLE n_2022_report_of_underutilized_properties (
  "predominant_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_number" BIGINT,
  "agency_shell_pk_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" DOUBLE,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE,
  "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" 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" DOUBLE,
  "longitude" DOUBLE,
  "omes_estimated_value" 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
  • 170.43 KB
  • 3999 rows
  • 20 columns
Loading... 

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,
  "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
);

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
  • 68.26 KB
  • 3238 rows
  • 20 columns
Loading... 

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,
  "subsection_id" VARCHAR,
  "row_purpose" VARCHAR,
  "row_project" VARCHAR,
  "row_id" VARCHAR,
  "route_turnpike" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "list_value" BIGINT,
  "percent_of_property_being_utilized" BIGINT,
  "acres_of_undeveloped_land" BIGINT,
  "acres_of_land_used_by_state" DOUBLE,
  "latitude" BIGINT,
  "longitude" BIGINT
);

Share link

Anyone who has the link will be able to view this.