About this Dataset

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

Tables

Data - 2014 OMES Mineral Interest Inventory List

@usgov.state_of_oklahoma_2014_real_property_asset_data.data_2014_omes_mineral_interest_inventory_list

44.51 kB
449 rows
24 columns

CREATE TABLE data_2014_omes_mineral_interest_inventory_list (
  "file" VARCHAR  -- FILE #,
  "pooled_or_unitized" VARCHAR,
  "owner_agency" VARCHAR,
  "active_expired" VARCHAR  -- ACTIVE/ EXPIRED,
  "county" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "tract" DOUBLE  -- TRACT #,
  "legal_description" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "net_acres" DOUBLE,
  "gross_acres" DOUBLE,
  "original_lessee" VARCHAR,
  "current_lessee" VARCHAR,
  "lease" VARCHAR  -- LEASE #,
  "royalty_interest" DOUBLE,
  "well_name" VARCHAR,
  "well_operator" VARCHAR,
  "production_zone" VARCHAR,
  "sale_or_approved_date" VARCHAR,
  "end_or_expiration_date" VARCHAR,
  "royalty_bonus" VARCHAR
);

Data - 2014 Real Property Inventory List

@usgov.state_of_oklahoma_2014_real_property_asset_data.data_2014_real_property_inventory_list

730.92 kB
13,727 rows
40 columns

CREATE TABLE data_2014_real_property_inventory_list (
  "agency_code" DOUBLE,
  "state_agency" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "physical_address" VARCHAR,
  "county" VARCHAR,
  "year_property_acquired" VARCHAR,
  "purpose_building" VARCHAR  -- PURPOSE - BUILDING,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet_of_structure" DOUBLE,
  "acres_associated_with_a_structure" DOUBLE,
  "additional_description_of_size_or_space" VARCHAR,
  "list_value" DOUBLE,
  "additional_description_of_list_value" VARCHAR,
  "n__of_property_being_utilized" DOUBLE  -- % OF PROPERTY BEING UTILIZED,
  "year_built" VARCHAR,
  "occupancy_rate_of_the_building" DOUBLE,
  "additional_description_of_occupancy_rate" VARCHAR,
  "vacant_square_footage" DOUBLE,
  "state_employees_at_this_building_fte" DOUBLE  -- STATE EMPLOYEES AT THIS BUILDING (FTE),
  "n__occupied_by_the_state" DOUBLE  -- % OCCUPIED BY THE STATE,
  "additional_description_of_occupied_by_state" VARCHAR  -- ADDITIONAL DESCRIPTION OF % OCCUPIED BY STATE,
  "n__of_the_building_being_leased_or_subleased" DOUBLE  -- % OF THE BUILDING BEING LEASED OR SUBLEASED,
  "additional_description_building_leased_or_subleased" VARCHAR  -- ADDITIONAL DESCRIPTION % BUILDING LEASED OR SUBLEASED,
  "usage_by_state_daily_weekly_monthly_building" VARCHAR  -- USAGE BY STATE: DAILY, WEEKLY, MONTHLY - BUILDING,
  "acres" DOUBLE,
  "n__acres_used_by_state" DOUBLE  -- ACRES USED BY STATE,
  "additional_description_of_size_space_text_and_number" VARCHAR  -- ADDITIONAL DESCRIPTION OF SIZE/SPACE (TEXT AND NUMBER),
  "purpose_land" VARCHAR  -- PURPOSE - LAND,
  "usage_by_state_daily_weekly_monthly_land" VARCHAR  -- USAGE BY STATE: DAILY, WEEKLY, MONTHLY - LAND,
  "n__of_acres_of_the_land_being_leased_or_subleased" DOUBLE  -- % OF ACRES OF THE LAND BEING LEASED OR SUBLEASED,
  "additional_description_land_leased_or_subleased" VARCHAR  -- ADDITIONAL DESCRIPTION % LAND LEASED OR SUBLEASED,
  "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,
  "location_1" VARCHAR
);

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

@usgov.state_of_oklahoma_2014_real_property_asset_data.data_2014_report_of_5_most_underutilized_properties_tier_3

30.19 kB
11 rows
34 columns

CREATE TABLE data_2014_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,
  "county" VARCHAR,
  "year_property_acquired" DOUBLE,
  "purpose_building" VARCHAR  -- PURPOSE- BUILDING,
  "sectiontownshiprange" VARCHAR,
  "size_of_structure_and_or_acres" VARCHAR,
  "list_value" VARCHAR,
  "n__of_property_being_utilized" BIGINT  -- % OF PROPERTY BEING UTILIZED,
  "year_built" DOUBLE,
  "occupancy_rate_of_the_building" DOUBLE,
  "vacant_square_footage" DOUBLE,
  "state_employees_at_this_building" VARCHAR,
  "n__occupied_by_the_state" DOUBLE  -- % OCCUPIED BY THE STATE,
  "additional_description_of_occupied_by_the_state" VARCHAR  -- ADDITIONAL DESCRIPTION OF % OCCUPIED BY THE STATE,
  "n__of_the_building_being_leased_or_subleased" DOUBLE  -- % OF THE BUILDING BEING LEASED OR SUBLEASED,
  "additional_description_building_leased_or_subleased" VARCHAR  -- ADDITIONAL DESCRIPTION % BUILDING LEASED OR SUBLEASED,
  "usage_by_state_daily_weekly_monthly_building" VARCHAR  -- USAGE BY STATE: DAILY, WEEKLY, MONTHLY- BUILDING,
  "acres" DOUBLE,
  "acres_used_by_state" VARCHAR,
  "additional_description_of_acres" VARCHAR,
  "purpose_land" VARCHAR,
  "usage_by_state_daily_weekly_monthly_land" VARCHAR  -- USAGE BY STATE: DAILY, WEEKLY, MONTHLY- LAND,
  "n__of_acres_of_the_land_being_leased_or_subleased" VARCHAR  -- % OF ACRES OF THE LAND BEING LEASED OR SUBLEASED,
  "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,
  "estimated_value" VARCHAR,
  "taxes" VARCHAR,
  "location_1" VARCHAR
);

Data - 2014 Report Of Underutilized Properties- Tier 2

@usgov.state_of_oklahoma_2014_real_property_asset_data.data_2014_report_of_underutilized_properties_tier_2

37.39 kB
76 rows
34 columns

CREATE TABLE data_2014_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,
  "county" VARCHAR,
  "year_property_acquired" DOUBLE,
  "purpose_building" VARCHAR  -- PURPOSE- BUILDING,
  "sectiontownshiprange" VARCHAR,
  "size_of_structure_and_or_acres" VARCHAR,
  "list_value" VARCHAR,
  "n__of_property_being_utilized" BIGINT  -- % OF PROPERTY BEING UTILIZED,
  "year_built" DOUBLE,
  "occupancy_rate_of_the_building" DOUBLE,
  "vacant_square_footage" VARCHAR,
  "state_employees_at_this_building" VARCHAR,
  "n__occupied_by_the_state" DOUBLE  -- % OCCUPIED BY THE STATE,
  "additional_description_of_occupied_by_the_state" VARCHAR  -- ADDITIONAL DESCRIPTION OF % OCCUPIED BY THE STATE,
  "n__of_the_building_being_leased_or_subleased" DOUBLE  -- % OF THE BUILDING BEING LEASED OR SUBLEASED,
  "additional_description_building_leased_or_subleased" VARCHAR  -- ADDITIONAL DESCRIPTION % BUILDING LEASED OR SUBLEASED,
  "usage_by_state_daily_weekly_monthly_building" VARCHAR  -- USAGE BY STATE: DAILY, WEEKLY, MONTHLY- BUILDING,
  "acres" DOUBLE,
  "acres_used_by_state" DOUBLE,
  "additional_description_of_acres" VARCHAR,
  "purpose_land" VARCHAR  -- PURPOSE- LAND,
  "usage_by_state_daily_weekly_monthly_land" VARCHAR  -- USAGE BY STATE: DAILY, WEEKLY, MONTHLY-LAND,
  "n__of_acres_of_the_land_being_leased_or_subleased" DOUBLE  -- % OF ACRES OF THE LAND BEING LEASED OR SUBLEASED,
  "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,
  "estimated_value" VARCHAR,
  "taxes" VARCHAR,
  "location_1" VARCHAR
);

Data - 2014 Turnpike Authority Rights Of Way Inventory List

@usgov.state_of_oklahoma_2014_real_property_asset_data.data_2014_turnpike_authority_rights_of_way_inventory_list

45.9 kB
3,071 rows
13 columns

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

Data - 2014 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2014_real_property_asset_data.n__2014_transportation_department_rights_of_way_inventory_list

632.04 kB
9,818 rows
16 columns

CREATE TABLE n__2014_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" 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,
  "n__of_acres_being_leased" BIGINT  -- % OF ACRES BEING LEASED,
  "beginning_point_of_latitude" DOUBLE,
  "beginning_point_of_longitutde" DOUBLE,
  "location_1" VARCHAR
);