About this Dataset

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

Tables

2015 Mineral Interest Inventory List

@usgov.state_of_oklahoma_2015_real_property_asset_data.n_2015_mineral_interest_inventory_list

45.95 kB
471 rows
24 columns

CREATE TABLE n_2015_mineral_interest_inventory_list (
  "file" VARCHAR  -- File #,
  "pooled_or_unitized" VARCHAR,
  "owner_agency" VARCHAR,
  "active_expired" VARCHAR  -- Active/ Expired,
  "county" VARCHAR,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "tract" DOUBLE  -- Tract #,
  "legal_description" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "net_acres" VARCHAR,
  "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,
  "bonus" DOUBLE
);

2015 Real Property Inventory List

@usgov.state_of_oklahoma_2015_real_property_asset_data.n_2015_real_property_inventory_list

907.63 kB
13,766 rows
46 columns

CREATE TABLE n_2015_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  -- PURPOSE - BUILDING,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet_of_structure_number_only" VARCHAR  -- SQUARE FEET OF STRUCTURE (NUMBER ONLY),
  "acres_associated_with_a_structure_number_only" DOUBLE  -- ACRES ASSOCIATED WITH A STRUCTURE (NUMBER ONLY),
  "additional_description_of_size_space_text_and_number" VARCHAR  -- ADDITIONAL DESCRIPTION OF SIZE/SPACE (TEXT AND NUMBER),
  "list_value" VARCHAR,
  "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,
  "agency_employees_at_this_location_fte_number_only" VARCHAR  -- AGENCY EMPLOYEES AT THIS LOCATION (FTE) NUMBER ONLY,
  "additional_description_of_fte" VARCHAR,
  "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" VARCHAR  -- % 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" VARCHAR,
  "acres_used_by_state" VARCHAR,
  "additional_description_of_acres_text_and_number" VARCHAR  -- ADDITIONAL DESCRIPTION OF ACRES (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" VARCHAR  -- % OF ACRES OF THE LAND BEING LEASED OR SUBLEASED,
  "additional_description_land_leased_or_subleased" VARCHAR  -- ADDITIONAL DESCRIPTION % LAND LEASED OR SUBLEASED,
  "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  -- RISK MGMT #,
  "agency_inventory_id" VARCHAR,
  "location" VARCHAR,
  "latitude" VARCHAR,
  "longitude" DOUBLE
);

2015 State Of Oklahoma Personal Property List

@usgov.state_of_oklahoma_2015_real_property_asset_data.n_2015_state_of_oklahoma_personal_property_list

2.68 MB
237,861 rows
8 columns

CREATE TABLE n_2015_state_of_oklahoma_personal_property_list (
  "agency_code" DOUBLE,
  "state_agency" VARCHAR,
  "property_type" VARCHAR,
  "property_classification" VARCHAR,
  "property_name" VARCHAR,
  "property_description" VARCHAR,
  "date_acquired_or_installed" DOUBLE,
  "value_or_cost" DOUBLE
);

2015 Top 5 Percent Most Underutilized Properties

@usgov.state_of_oklahoma_2015_real_property_asset_data.n_2015_top_5_percent_most_underutilized_properties

37.72 kB
11 rows
45 columns

CREATE TABLE n_2015_top_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  -- PURPOSE - BUILDING,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet_of_structure_number_only" DOUBLE  -- SQUARE FEET OF STRUCTURE (NUMBER ONLY),
  "acres_associated_with_a_structure_number_only" DOUBLE  -- ACRES ASSOCIATED WITH A STRUCTURE (NUMBER ONLY),
  "additional_description_of_size_space_text_and_number" VARCHAR  -- ADDITIONAL DESCRIPTION OF SIZE/SPACE (TEXT AND NUMBER),
  "list_value" VARCHAR,
  "additional_description_of_list_value" VARCHAR,
  "n__of_property_being_utilized" BIGINT  -- % OF PROPERTY BEING UTILIZED,
  "year_built" VARCHAR,
  "occupancy_rate_of_the_building" DOUBLE,
  "additional_description_of_occupancy_rate" VARCHAR,
  "state_employees_at_this_location_fte_number_only" DOUBLE  -- STATE EMPLOYEES AT THIS LOCATION (FTE) NUMBER ONLY,
  "additional_description_of_fte" VARCHAR,
  "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,
  "acres_used_by_state" VARCHAR,
  "additional_description_of_acres_text_and_number" VARCHAR  -- ADDITIONAL DESCRIPTION OF ACRES (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" VARCHAR  -- % OF ACRES OF THE LAND BEING LEASED OR SUBLEASED,
  "additional_description_land_leased_or_subleased" VARCHAR  -- ADDITIONAL DESCRIPTION % LAND LEASED OR SUBLEASED,
  "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  -- RISK MGMT #,
  "agency_inventory_id" VARCHAR,
  "estimated_value" VARCHAR,
  "taxes" VARCHAR
);

2015 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2015_real_property_asset_data.n_2015_transportation_department_rights_of_way_inventory_list

342 kB
9,986 rows
15 columns

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

2015 Turnpike Authority Rights Of Way Inventory List

@usgov.state_of_oklahoma_2015_real_property_asset_data.n_2015_turnpike_authority_rights_of_way_inventory_list

46.26 kB
3,067 rows
13 columns

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