About this Dataset

2016 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-07T15:00:06.273043
Tags: 2016, asset, buildings, oklahoma-real-property-asset-report, oklahoma-state-government-asset-reduction-and-cost-savings-program, real-property, underutilized-property

Tables

2016 OMES Mineral Inventory List

@usgov.state_of_oklahoma_2016_real_property_asset_data.n_2016_omes_mineral_inventory_list

45.93 KB
468 rows
24 columns


CREATE TABLE n_2016_omes_mineral_inventory_list (
  "file" VARCHAR,
  "pooled_or_unitized" VARCHAR,
  "owner_agency" VARCHAR,
  "active_expired" VARCHAR,
  "county" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "tract" DOUBLE,
  "legal_description" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "net_acres" VARCHAR,
  "gross_acres" DOUBLE,
  "original_lessee" VARCHAR,
  "current_lessee" VARCHAR,
  "lease" VARCHAR,
  "royalty_interest" VARCHAR,
  "well_name" VARCHAR,
  "well_operator" VARCHAR,
  "production_zone" VARCHAR,
  "sale_or_approved_date" VARCHAR,
  "end_or_expiration_date" VARCHAR,
  "bonus" VARCHAR
);

2016 Real Property Inventory List

@usgov.state_of_oklahoma_2016_real_property_asset_data.n_2016_real_property_inventory_list

893.97 KB
14356 rows
46 columns


CREATE TABLE n_2016_real_property_inventory_list (
  "agency_no" VARCHAR,
  "state_agency" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "year_property_acquired" VARCHAR,
  "purpose_building" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet_of_structure_number_only" DOUBLE,
  "acres_associated_with_a_structure_number_only" DOUBLE,
  "additional_description_of_size_space_text_and_number" VARCHAR,
  "list_value" VARCHAR,
  "additional_description_of_list_value" VARCHAR,
  "n__of_property_being_utilized" DOUBLE,
  "year_built" VARCHAR,
  "occupancy_rate_of_the_building" DOUBLE,
  "additional_description_of_occupancy_rate" VARCHAR,
  "agency_employees_at_this_location_fte_number_only" VARCHAR,
  "additional_description_of_fte" VARCHAR,
  "n__occupied_by_the_state" DOUBLE,
  "additional_description_of_occupied_by_state" VARCHAR,
  "n__of_the_building_being_leased_or_subleased" VARCHAR,
  "additional_description_building_leased_or_subleased" VARCHAR,
  "usage_by_state_daily_weekly_monthly_building" VARCHAR,
  "acres" VARCHAR,
  "acres_used_by_state" VARCHAR,
  "additional_description_of_acres_text_and_number" VARCHAR,
  "purpose_land" VARCHAR,
  "usage_by_state_daily_weekly_monthly_land" VARCHAR,
  "n__of_acres_of_the_land_being_leased_or_subleased" VARCHAR,
  "additional_description_land_leased_or_subleased" VARCHAR,
  "vacant_square_footage" VARCHAR,
  "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" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2016 Report Of 5 Percent Most Underutilized Properties

@usgov.state_of_oklahoma_2016_real_property_asset_data.n_2016_report_of_5_percent_most_underutilized_properties

40.46 KB
13 rows
48 columns


CREATE TABLE n_2016_report_of_5_percent_most_underutilized_properties (
  "agency_no" BIGINT,
  "state_agency" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "year_property_acquired" VARCHAR,
  "purpose_building" VARCHAR,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet_of_structure_number_only" DOUBLE,
  "acres_associated_with_a_structure_number_only" DOUBLE,
  "additional_description_of_size_space_text_and_number" VARCHAR,
  "list_value" VARCHAR,
  "additional_description_of_list_value" VARCHAR,
  "n__of_property_being_utilized" BIGINT,
  "year_built" VARCHAR,
  "occupancy_rate_of_the_building" DOUBLE,
  "additional_description_of_occupancy_rate" VARCHAR,
  "state_employees_at_this_location_fte_number_only" DOUBLE,
  "additional_description_of_fte" VARCHAR,
  "n__occupied_by_the_state" DOUBLE,
  "additional_description_of_occupied_by_state" VARCHAR,
  "n__of_the_building_being_leased_or_subleased" DOUBLE,
  "additional_description_building_leased_or_subleased" VARCHAR,
  "usage_by_state_daily_weekly_monthly_building" VARCHAR,
  "acres" DOUBLE,
  "acres_used_by_state" DOUBLE,
  "additional_description_of_acres_text_and_number" VARCHAR,
  "purpose_land" VARCHAR,
  "usage_by_state_daily_weekly_monthly_land" VARCHAR,
  "n__of_acres_of_the_land_being_leased_or_subleased" VARCHAR,
  "additional_description_land_leased_or_subleased" VARCHAR,
  "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" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "estimated_value" VARCHAR,
  "taxes" VARCHAR,
  "location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2016 Report Of Underutilized Properties

@usgov.state_of_oklahoma_2016_real_property_asset_data.n_2016_report_of_underutilized_properties

61.81 KB
248 rows
47 columns


CREATE TABLE n_2016_report_of_underutilized_properties (
  "agency_no" DOUBLE,
  "state_agency" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "year_property_acquired" VARCHAR,
  "purpose_building" VARCHAR,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet_of_structure_number_only" DOUBLE,
  "acres_associated_with_a_structure_number_only" DOUBLE,
  "additional_description_of_size_space_text_and_number" VARCHAR,
  "list_value" VARCHAR,
  "additional_description_of_list_value" VARCHAR,
  "n__of_property_being_utilized" DOUBLE,
  "year_built" VARCHAR,
  "occupancy_rate_of_the_building" DOUBLE,
  "additional_description_of_occupancy_rate" VARCHAR,
  "state_employees_at_this_location_fte_number_only" DOUBLE,
  "additional_description_of_fte" VARCHAR,
  "n__occupied_by_the_state" DOUBLE,
  "additional_description_of_occupied_by_state" VARCHAR,
  "n__of_the_building_being_leased_or_subleased" DOUBLE,
  "additional_description_building_leased_or_subleased" VARCHAR,
  "usage_by_state_daily_weekly_monthly_building" VARCHAR,
  "acres" DOUBLE,
  "acres_used_by_state" DOUBLE,
  "additional_description_of_acres_text_and_number" VARCHAR,
  "purpose_land" VARCHAR,
  "usage_by_state_daily_weekly_monthly_land" VARCHAR,
  "n__of_acres_of_the_land_being_leased_or_subleased" DOUBLE,
  "additional_description_land_leased_or_subleased" VARCHAR,
  "vacant_square_footage" VARCHAR,
  "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" VARCHAR,
  "agency_inventory_id" VARCHAR,
  "estimated_value" VARCHAR,
  "location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2016 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2016_real_property_asset_data.n_2016_transportation_department_rights_of_way_inventory_list

292.26 KB
9961 rows
14 columns


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

2016 Turnpike Authority Rights Of Way Inventory List

@usgov.state_of_oklahoma_2016_real_property_asset_data.n_2016_turnpike_authority_rights_of_way_inventory_list

45.28 KB
3072 rows
13 columns


CREATE TABLE n_2016_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,
  "acres_of_land_used_by_state" VARCHAR,
  "usage_by_state" VARCHAR
);