Baselight
Sign In

2018 Real Property Asset Data

State of Oklahoma

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650

Loading...
Loading...

About this Dataset

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

Tables

2018 Real Property Inventory List-ABC's With No Real Property

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650.n_2018_real_property_inventory_list_abc_s_with_no_real_property
  • 22.37 kB
  • 44 rows
  • 34 columns
Loading... 
CREATE TABLE n_2018_real_property_inventory_list_abc_s_with_no_real_property (
  "agency_no" VARCHAR,
  "state_agency" VARCHAR,
  "property_classification" VARCHAR,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33
);

2018 Real Property Inventory List-Leased

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650.n_2018_real_property_inventory_list_leased
  • 109.47 kB
  • 1,160 rows
  • 40 columns
Loading... 
CREATE TABLE n_2018_real_property_inventory_list_leased (
  "predominate_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_no" DOUBLE,
  "state_agency" VARCHAR,
  "location_type" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired" DOUBLE,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE,
  "appraised_value" DOUBLE,
  "replacement_value" DOUBLE,
  "property_condition" VARCHAR,
  "n__of_property_being_utilized" BIGINT  -- % OF PROPERTY BEING UTILIZED,
  "year_built" DOUBLE,
  "agency_employees_at_this_location_fte_number_only" VARCHAR  -- AGENCY EMPLOYEES AT THIS LOCATION (FTE) NUMBER ONLY,
  "square_feet_occupied_by_the_state" DOUBLE,
  "square_feet_of_the_building_being_leased" DOUBLE,
  "acres_of_land_being_leased" DOUBLE,
  "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,
  "latitude" VARCHAR,
  "longitude" DOUBLE,
  "unnamed_39" VARCHAR  -- Unnamed: 39
);

2018 Real Property Inventory List-Owned

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650.n_2018_real_property_inventory_list_owned
  • 644.58 kB
  • 16,822 rows
  • 40 columns
Loading... 
CREATE TABLE n_2018_real_property_inventory_list_owned (
  "predominate_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_no" DOUBLE,
  "state_agency" VARCHAR,
  "location_type" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired" DOUBLE,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" VARCHAR,
  "appraised_value" DOUBLE,
  "replacement_value" VARCHAR,
  "property_condition" VARCHAR,
  "n__of_property_being_utilized" DOUBLE  -- % OF PROPERTY BEING UTILIZED,
  "year_built" DOUBLE,
  "agency_employees_at_this_location_fte_number_only" DOUBLE  -- AGENCY EMPLOYEES AT THIS LOCATION (FTE) NUMBER ONLY,
  "square_feet_occupied_by_the_state" DOUBLE,
  "square_feet_of_the_building_being_leased" DOUBLE,
  "acres_of_land_being_leased" DOUBLE,
  "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,
  "latitude" DOUBLE,
  "longitude" VARCHAR,
  "unnamed_39" VARCHAR  -- Unnamed: 39
);

2018 Report Of 5 Percent Most Underutilized Properties

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650.n_2018_report_of_5_percent_most_underutilized_properties
  • 32.85 kB
  • 14 rows
  • 41 columns
Loading... 
CREATE TABLE n_2018_report_of_5_percent_most_underutilized_properties (
  "predominate_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_no" BIGINT,
  "state_agency" VARCHAR,
  "location_type" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired" DOUBLE,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" DOUBLE,
  "appraised_value" DOUBLE,
  "replacement_value" DOUBLE,
  "property_condition" VARCHAR,
  "n__of_property_being_utilized" BIGINT  -- % OF PROPERTY BEING UTILIZED,
  "year_built" DOUBLE,
  "agency_employees_at_this_location_fte_number_only" DOUBLE  -- AGENCY EMPLOYEES AT THIS LOCATION (FTE) NUMBER ONLY,
  "square_feet_occupied_by_the_state" DOUBLE,
  "square_feet_of_the_building_being_leased" DOUBLE,
  "acres_of_land_being_leased" DOUBLE,
  "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,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "estimated_value_1" VARCHAR,
  "taxes" VARCHAR
);

2018 Report Of Underutilized Properties

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650.n_2018_report_of_underutilized_properties
  • 49.21 kB
  • 285 rows
  • 40 columns
Loading... 
CREATE TABLE n_2018_report_of_underutilized_properties (
  "predominate_use" VARCHAR,
  "county_assessor_account_number" VARCHAR,
  "agency_no" DOUBLE,
  "state_agency" VARCHAR,
  "location_type" VARCHAR,
  "property_classification" VARCHAR,
  "type_of_property" VARCHAR,
  "name_of_building" VARCHAR,
  "physical_address" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "year_property_acquired" DOUBLE,
  "section" DOUBLE,
  "township" VARCHAR,
  "range" VARCHAR,
  "meridian" VARCHAR,
  "legal_description" VARCHAR,
  "square_feet" DOUBLE,
  "acres" DOUBLE,
  "estimated_value" VARCHAR,
  "appraised_value" DOUBLE,
  "replacement_value" DOUBLE,
  "property_condition" VARCHAR,
  "n__of_property_being_utilized" BIGINT  -- % OF PROPERTY BEING UTILIZED,
  "year_built" DOUBLE,
  "agency_employees_at_this_location_fte_number_only" DOUBLE  -- AGENCY EMPLOYEES AT THIS LOCATION (FTE) NUMBER ONLY,
  "square_feet_occupied_by_the_state" DOUBLE,
  "square_feet_of_the_building_being_leased" DOUBLE,
  "acres_of_land_being_leased" DOUBLE,
  "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,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "estimated_value_1" VARCHAR
);

2018 Transportation Department Rights Of Way Inventory List

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650.n_2018_transportation_department_rights_of_way_inventory_list
  • 358.1 kB
  • 10,299 rows
  • 14 columns
Loading... 
CREATE TABLE n_2018_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  -- % OF PROPERTY BEING UTILIZED,
  "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
);

2018 Turnpike Authority Rights Of Way Inventory List

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650.n_2018_turnpike_authority_rights_of_way_inventory_list
  • 51.48 kB
  • 3,729 rows
  • 13 columns
Loading... 
CREATE TABLE n_2018_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" DOUBLE  -- % OF PROPERTY BEING UTILIZED,
  "acres_of_land_used_by_state" DOUBLE,
  "usage_by_state" VARCHAR
);

Share link

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