Baselight
Sign In

2020 Real Property Asset Data

State of Oklahoma

@usgov.state_of_oklahoma_2020_real_property_asset_data_30ceb

Loading...
Loading...

About this Dataset

2020 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: 2021-08-07T14:56:03.443437
Tags: real-property-assets

Tables

2020 OMES Mineral Interest List

@usgov.state_of_oklahoma_2020_real_property_asset_data_30ceb.n_2020_omes_mineral_interest_list
  • 52.77 kB
  • 489 rows
  • 26 columns
Loading... 
CREATE TABLE n_2020_omes_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
);

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

@usgov.state_of_oklahoma_2020_real_property_asset_data_30ceb.n_2020_real_property_inventory_list_abc_s_with_no_real_property
  • 21.95 kB
  • 50 rows
  • 34 columns
Loading... 
CREATE TABLE n_2020_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
);

2020 Real Property Inventory List-Leased

@usgov.state_of_oklahoma_2020_real_property_asset_data_30ceb.n_2020_real_property_inventory_list_leased
  • 105.18 kB
  • 1,201 rows
  • 33 columns
Loading... 
CREATE TABLE n_2020_real_property_inventory_list_leased (
  "predominant_use" VARCHAR,
  "agency_number" DOUBLE,
  "state_agency" VARCHAR,
  "location_type" VARCHAR,
  "property_classification" VARCHAR,
  "area_of_government" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "state_owned_location" VARCHAR,
  "year_property_acquired" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" VARCHAR,
  "acres" DOUBLE,
  "percent_of_property_utilizied" BIGINT,
  "agency_employees_at_this_location" VARCHAR,
  "square_feet_occupied_by_your_agency" VARCHAR,
  "square_feet_of_the_building_being_subleased_to_other_entities" DOUBLE,
  "acres_of_land_being_subleased_to_other_entities" DOUBLE,
  "vacant_square_footage" DOUBLE,
  "risk_mgmt_number" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "unnamed_32" VARCHAR  -- Unnamed: 32
);

2020 Real Property Inventory List-Owned

@usgov.state_of_oklahoma_2020_real_property_asset_data_30ceb.n_2020_real_property_inventory_list_owned
  • 659.31 kB
  • 16,998 rows
  • 41 columns
Loading... 
CREATE TABLE n_2020_real_property_inventory_list_owned (
  "predominant_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_number" DOUBLE,
  "state_agency" VARCHAR,
  "location_type" VARCHAR,
  "property_classification" VARCHAR,
  "area_of_government" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "ocia_bonded" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired" DOUBLE,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" VARCHAR,
  "estimated_value" VARCHAR,
  "appraised_value" VARCHAR,
  "replacement_value" DOUBLE,
  "property_condition" VARCHAR,
  "percent_of_property_being_utilized" DOUBLE,
  "year_built" 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_mgmt_number" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2020 Report Of 5 Percent Most Underutilized Properties

@usgov.state_of_oklahoma_2020_real_property_asset_data_30ceb.n_2020_report_of_5_percent_most_underutilized_properties
  • 34.47 kB
  • 14 rows
  • 43 columns
Loading... 
CREATE TABLE n_2020_report_of_5_percent_most_underutilized_properties (
  "predominant_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_number" BIGINT,
  "state_agency" VARCHAR,
  "location_type" VARCHAR,
  "property_classification" VARCHAR,
  "area_of_government" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "ocia_bonded" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired" DOUBLE,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE,
  "appraised_value" VARCHAR,
  "replacement_value" DOUBLE,
  "property_condition" VARCHAR,
  "percent_of_property_being_utilized" BIGINT,
  "year_built" DOUBLE,
  "agency_employees_at_this_location" DOUBLE,
  "square_feet_occupied_by_your_agency" DOUBLE,
  "square_feet_of_the_building_being_leased" DOUBLE,
  "acres_of_land_being_leased" 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_mgmt_number" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "omes_estimated_value" VARCHAR,
  "taxes" VARCHAR
);

2020 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2020_real_property_asset_data_30ceb.n_2020_transportation_department_rights_of_way_inventory_list
  • 212.22 kB
  • 3,910 rows
  • 14 columns
Loading... 
CREATE TABLE n_2020_transportation_department_rights_of_way_inventory_list (
  "state_agency" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "county" VARCHAR,
  "subsection_id" VARCHAR,
  "purpose" VARCHAR,
  "route" VARCHAR,
  "list_value" DOUBLE,
  "n__of_property_being_utilized" BIGINT  -- % OF PROPERTY BEING UTILIZED,
  "acres_of_undeveloped_land" DOUBLE,
  "acres_of_land_used_by_state" DOUBLE,
  "usage_by_state" VARCHAR,
  "beginning_point_of_latitude" DOUBLE,
  "beginning_point_of_longitutde" DOUBLE
);

2020 Turnpike Authority Rights Of Way Inventory List

@usgov.state_of_oklahoma_2020_real_property_asset_data_30ceb.n_2020_turnpike_authority_rights_of_way_inventory_list
  • 47.77 kB
  • 3,274 rows
  • 13 columns
Loading... 
CREATE TABLE n_2020_turnpike_authority_rights_of_way_inventory_list (
  "state_agency" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "turnpike" VARCHAR,
  "county" VARCHAR,
  "parcel_number" VARCHAR,
  "purpose" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "n__of_property_being_utilized" BIGINT  -- % OF PROPERTY BEING UTILIZED,
  "acres_of_land_used_by_state" VARCHAR,
  "usage_by_state" VARCHAR
);

Share link

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