Baselight
Sign In

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.138167
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
  • 44.61 kB
  • 445 rows
  • 24 columns
Loading... 
CREATE TABLE data_2013_omes_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,
  "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" 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
  • 626.38 kB
  • 12,806 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  -- PURPOSE - BUILDING,
  "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  -- % OF PROPERTY BEING UTILIZED,
  "year_built" VARCHAR,
  "occupancy_rate_of_the_building" DOUBLE,
  "additional_description_of_occupancy_rate" VARCHAR,
  "state_employees_at_this_building_fte" DOUBLE  -- STATE EMPLOYEES AT THIS BUILDING (FTE),
  "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,
  "n__acres_used_by_state" DOUBLE  -- ACRES USED BY STATE,
  "additional_description_of_size_space" 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,
  "additional_description_land_leased_or_subleased" VARCHAR  -- ADDITIONAL DESCRIPTION % LAND LEASED OR SUBLEASED,
  "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
  • 27.01 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  -- % OF PROPERTY BEING UTILIZED,
  "year_built" DOUBLE,
  "occupancy_rate_of_the_building" 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" 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" VARCHAR  -- USAGE BY STATE: DAILY, WEEKLY, MONTHLY,
  "acres" DOUBLE,
  "acres_used_by_state" VARCHAR,
  "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" VARCHAR  -- % OF ACRES OF THE LAND BEING LEASED OR SUBLEASED,
  "estimated_value" VARCHAR,
  "taxes" VARCHAR,
  "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
  • 33.24 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  -- % OF PROPERTY BEING UTILIZED,
  "year_built" VARCHAR,
  "occupancy_rate_of_the_building" 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" VARCHAR  -- USAGE BY STATE: DAILY, WEEKLY, MONTHLY,
  "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,
  "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
  • 2.07 MB
  • 180,658 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  -- DATE PROPERTY ACQUIRED/ INSTALL DATE,
  "list_value_acquisition_cost" VARCHAR  -- LIST VALUE/ ACQUISITION COST
);

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
  • 45.9 kB
  • 3,071 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  -- % OF PROPERTY BEING UTILIZED,
  "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
  • 638.57 kB
  • 9,818 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  -- % 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_latitude" DOUBLE,
  "beginning_point_longitude" DOUBLE,
  "location" VARCHAR
);

Share link

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