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
  • 21.84 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_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR
);

2018 Real Property Inventory List-Leased

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650.n_2018_real_property_inventory_list_leased
  • 106.91 KB
  • 1160 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,
  "year_built" DOUBLE,
  "agency_employees_at_this_location_fte_number_only" VARCHAR,
  "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,
  "agency_inventory_id" VARCHAR,
  "latitude" VARCHAR,
  "longitude" DOUBLE,
  "unnamed_39" VARCHAR
);

2018 Real Property Inventory List-Owned

@usgov.state_of_oklahoma_2018_real_property_asset_data_06650.n_2018_real_property_inventory_list_owned
  • 629.47 KB
  • 16822 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,
  "year_built" DOUBLE,
  "agency_employees_at_this_location_fte_number_only" DOUBLE,
  "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,
  "agency_inventory_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" VARCHAR,
  "unnamed_39" VARCHAR
);

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.08 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,
  "year_built" DOUBLE,
  "agency_employees_at_this_location_fte_number_only" DOUBLE,
  "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,
  "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
  • 48.06 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,
  "year_built" DOUBLE,
  "agency_employees_at_this_location_fte_number_only" DOUBLE,
  "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,
  "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
  • 349.71 KB
  • 10299 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,
  "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
  • 50.27 KB
  • 3729 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,
  "acres_of_land_used_by_state" DOUBLE,
  "usage_by_state" VARCHAR
);

Share link

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