Baselight

2013 Real Property Asset Data

State of Oklahoma

@usgov.state_of_oklahoma_2013_real_property_asset_data

Loading...
Loading...

About this Dataset

2013 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:59:52.138160
Tags: 2013, asset, buildings, oklahoma-real-property-asset-report, oklahoma-state-government-asset-reduction-and-cost-savings-program, real-property, underutilized-property

Tables

Data - 2013 OMES Mineral Interest Inventory List

@usgov.state_of_oklahoma_2013_real_property_asset_data.data_2013_omes_mineral_interest_inventory_list
  • 43.57 KB
  • 445 rows
  • 24 columns
Loading...

CREATE TABLE data_2013_omes_mineral_interest_inventory_list (
  "file" VARCHAR,
  "pooled_or_unitized" VARCHAR,
  "owner_agency" VARCHAR,
  "active_expired" VARCHAR,
  "county" VARCHAR,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "tract" DOUBLE,
  "legal_description" VARCHAR,
  "net_acres" DOUBLE,
  "gross_acres" DOUBLE,
  "original_lessee" VARCHAR,
  "current_lessee" VARCHAR,
  "lease" VARCHAR,
  "royalty_interest" DOUBLE,
  "well_name" VARCHAR,
  "well_operator" VARCHAR,
  "production_zone" VARCHAR,
  "sale_or_approved_date" TIMESTAMP,
  "end_or_expiration_date" TIMESTAMP,
  "royalty_bonus" VARCHAR,
  "location_1" VARCHAR,
  "state" VARCHAR
);

Data - 2013 Real Property Inventory List

@usgov.state_of_oklahoma_2013_real_property_asset_data.data_2013_real_property_inventory_list
  • 611.7 KB
  • 12806 rows
  • 34 columns
Loading...

CREATE TABLE data_2013_real_property_inventory_list (
  "agency_code" 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_township_range" VARCHAR,
  "size_of_structure_and_or_acres" DOUBLE,
  "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_building_fte" 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,
  "n__acres_used_by_state" DOUBLE,
  "additional_description_of_size_space" 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,
  "state" VARCHAR,
  "location_1" VARCHAR
);

Data - 2013 Report Of 5 % Most Underutilized Properties- Tier 3

@usgov.state_of_oklahoma_2013_real_property_asset_data.data_2013_report_of_5_most_underutilized_properties_tier_3
  • 26.38 KB
  • 8 rows
  • 32 columns
Loading...

CREATE TABLE data_2013_report_of_5_most_underutilized_properties_tier_3 (
  "agency_code" 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" DOUBLE,
  "purpose" VARCHAR,
  "section_township_range" VARCHAR,
  "size_of_structure_and_or_acres" VARCHAR,
  "list_value" VARCHAR,
  "n__of_property_being_utilized" BIGINT,
  "year_built" DOUBLE,
  "occupancy_rate_of_the_building" DOUBLE,
  "state_employees_at_this_building" VARCHAR,
  "n__occupied_by_the_state" DOUBLE,
  "additional_description_of_occupied_by_the_state" VARCHAR,
  "n__of_the_building_being_leased_or_subleased" VARCHAR,
  "additional_description_building_leased_or_subleased" VARCHAR,
  "usage_by_state_daily_weekly_monthly" VARCHAR,
  "acres" DOUBLE,
  "acres_used_by_state" VARCHAR,
  "additional_description_of_acres" VARCHAR,
  "purpose_land" VARCHAR,
  "usage_by_state_daily_weekly_monthly_land" VARCHAR,
  "n__of_acres_of_the_land_being_leased_or_subleased" VARCHAR,
  "estimated_value" VARCHAR,
  "taxes" VARCHAR,
  "state" VARCHAR,
  "location_1" VARCHAR
);

Data - 2013 Report Of Underutilized Properties-Tier 1

@usgov.state_of_oklahoma_2013_real_property_asset_data.data_2013_report_of_underutilized_properties_tier_1
  • 39.24 KB
  • 166 rows
  • 30 columns
Loading...

CREATE TABLE data_2013_report_of_underutilized_properties_tier_1 (
  "agency_code" 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" VARCHAR,
  "sectiontownshiprange" VARCHAR,
  "size_of_structure_and_or_acres" VARCHAR,
  "list_value" VARCHAR,
  "n__of_property_being_utilized" BIGINT,
  "year_built" VARCHAR,
  "occupancy_rate_of_the_building" DOUBLE,
  "state_employees_at_this_building" VARCHAR,
  "n__occupied_by_the_state" DOUBLE,
  "additional_description_of_occupied_by_the_state" VARCHAR,
  "n__of_the_building_being_leased_or_subleased" DOUBLE,
  "additional_description_building_leased_or_subleased" VARCHAR,
  "usage_by_state_daily_weekly_monthly" VARCHAR,
  "acres" DOUBLE,
  "acres_used_by_state" DOUBLE,
  "additional_description_of_acres" VARCHAR,
  "purpose_land" VARCHAR,
  "usage_by_state_daily_weekly_monthly_land" VARCHAR,
  "n__of_acres_of_the_land_being_leased_or_subleased" DOUBLE,
  "state" VARCHAR,
  "location_1" VARCHAR
);

Data - 2013 Report Of Underutilized Properties-Tier 2

@usgov.state_of_oklahoma_2013_real_property_asset_data.data_2013_report_of_underutilized_properties_tier_2
  • 32.46 KB
  • 57 rows
  • 32 columns
Loading...

CREATE TABLE data_2013_report_of_underutilized_properties_tier_2 (
  "agency_code" 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" VARCHAR,
  "section_township_range" VARCHAR,
  "size_of_structure_and_or_acres" VARCHAR,
  "list_value" VARCHAR,
  "n__of_property_being_utilized" BIGINT,
  "year_built" VARCHAR,
  "occupancy_rate_of_the_building" DOUBLE,
  "state_employees_at_this_building" VARCHAR,
  "n__occupied_by_the_state" DOUBLE,
  "additional_description_of_occupied_by_the_state" VARCHAR,
  "n__of_the_building_being_leased_or_subleased" DOUBLE,
  "additional_description_building_leased_or_subleased" VARCHAR,
  "usage_by_state_daily_weekly_monthly" VARCHAR,
  "acres" DOUBLE,
  "acres_used_by_state" DOUBLE,
  "additional_description_of_acres" VARCHAR,
  "purpose_land" VARCHAR,
  "usage_by_state_daily_weekly_monthly_land" VARCHAR,
  "n__of_acres_of_the_land_being_leased_or_subleased" DOUBLE,
  "estimated_value" VARCHAR,
  "taxes" VARCHAR,
  "state" VARCHAR,
  "location_1" VARCHAR
);

Data - 2013 State Of Oklahoma Personal Property Inventory List

@usgov.state_of_oklahoma_2013_real_property_asset_data.data_2013_state_of_oklahoma_personal_property_inventory_list
  • 1.97 MB
  • 180658 rows
  • 7 columns
Loading...

CREATE TABLE data_2013_state_of_oklahoma_personal_property_inventory_list (
  "agency_code" DOUBLE,
  "state_agency" VARCHAR,
  "property_type" VARCHAR,
  "property_classification" VARCHAR,
  "property_description" VARCHAR,
  "date_property_acquired_install_date" VARCHAR,
  "list_value_acquisition_cost" VARCHAR
);

Data - 2013 Turnpike Authority Rights Of Way Inventory List

@usgov.state_of_oklahoma_2013_real_property_asset_data.data_2013_turnpike_authority_rights_of_way_inventory_list
  • 44.82 KB
  • 3071 rows
  • 13 columns
Loading...

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

Data - 2013 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2013_real_property_asset_data.n__2013_transportation_department_rights_of_way_inventory_list
  • 623.6 KB
  • 9818 rows
  • 16 columns
Loading...

CREATE TABLE n__2013_transportation_department_rights_of_way_inventory_list (
  "state_agency" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "county" VARCHAR,
  "subsection_id" VARCHAR,
  "purpose" VARCHAR,
  "section_township_range" VARCHAR,
  "list_value" VARCHAR,
  "n__of_property_being_utilized" BIGINT,
  "acres_of_undeveloped_land" DOUBLE,
  "acres_of_land_used_by_state" DOUBLE,
  "usage_by_state" VARCHAR,
  "n__of_acres_being_leased" BIGINT,
  "beginning_point_latitude" DOUBLE,
  "beginning_point_longitude" DOUBLE,
  "location" VARCHAR
);

Share link

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