Baselight
Sign In

2017 Real Property Asset Data

State of Oklahoma

@usgov.state_of_oklahoma_2017_real_property_asset_data

Loading...
Loading...

About this Dataset

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

Tables

2017 OMES Mineral Inventory List

@usgov.state_of_oklahoma_2017_real_property_asset_data.n_2017_omes_mineral_inventory_list
  • 47.39 KB
  • 479 rows
  • 24 columns
Loading... 

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

2017 Personal Property List

@usgov.state_of_oklahoma_2017_real_property_asset_data.n_2017_personal_property_list
  • 3.27 MB
  • 222353 rows
  • 8 columns
Loading... 

CREATE TABLE n_2017_personal_property_list (
  "agency_code" BIGINT,
  "state_agency" VARCHAR,
  "property_type" VARCHAR,
  "property_classification" VARCHAR,
  "property_name" VARCHAR,
  "property_description" VARCHAR,
  "date_acquired_or_installed" VARCHAR,
  "n__value_or_cost" VARCHAR
);

2017 Real Property Inventory List

@usgov.state_of_oklahoma_2017_real_property_asset_data.n_2017_real_property_inventory_list
  • 775.34 KB
  • 18461 rows
  • 45 columns
Loading... 

CREATE TABLE n_2017_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" VARCHAR,
  "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" VARCHAR,
  "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_building" VARCHAR,
  "acres" VARCHAR,
  "acres_used_by_state" VARCHAR,
  "additional_description_of_acres_text_and_number" VARCHAR,
  "purpose_land" VARCHAR,
  "usage_by_state_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,
  "latitude" VARCHAR,
  "longitude" DOUBLE
);

2017 Report Of 5 Percent Most Underutilized Properties

@usgov.state_of_oklahoma_2017_real_property_asset_data.n_2017_report_of_5_percent_most_underutilized_properties
  • 39.93 KB
  • 12 rows
  • 47 columns
Loading... 

CREATE TABLE n_2017_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" 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" 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,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2017 Report Of Underutilized Properties

@usgov.state_of_oklahoma_2017_real_property_asset_data.n_2017_report_of_underutilized_properties
  • 55.3 KB
  • 237 rows
  • 46 columns
Loading... 

CREATE TABLE n_2017_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" 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" 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,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2017 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2017_real_property_asset_data.n_2017_transportation_department_rights_of_way_inventory_list
  • 286.2 KB
  • 10163 rows
  • 14 columns
Loading... 

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

2017 Turnpike Authority Rights Of Way Inventory List

@usgov.state_of_oklahoma_2017_real_property_asset_data.n_2017_turnpike_authority_rights_of_way_inventory_list
  • 46.88 KB
  • 3281 rows
  • 13 columns
Loading... 

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

Share link

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