2013 Real Property Asset Data
State of Oklahoma
@usgov.state_of_oklahoma_2013_real_property_asset_data
State of Oklahoma
@usgov.state_of_oklahoma_2013_real_property_asset_data
CREATE TABLE data_2013_omes_mineral_interest_inventory_list (
"file" VARCHAR,
"pooled_or_unitized" VARCHAR,
"owner_agency" VARCHAR,
"active_expired" VARCHAR,
"county" VARCHAR,
"section" DOUBLE,
"township" VARCHAR,
"range" VARCHAR,
"tract" DOUBLE,
"legal_description" VARCHAR,
"net_acres" DOUBLE,
"gross_acres" DOUBLE,
"original_lessee" VARCHAR,
"current_lessee" VARCHAR,
"lease" VARCHAR,
"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
);
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,
"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,
"year_built" VARCHAR,
"occupancy_rate_of_the_building" DOUBLE,
"additional_description_of_occupancy_rate" VARCHAR,
"state_employees_at_this_building_fte" 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,
"n__acres_used_by_state" DOUBLE,
"additional_description_of_size_space" 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,
"state" VARCHAR,
"location_1" VARCHAR
);
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,
"year_built" DOUBLE,
"occupancy_rate_of_the_building" DOUBLE,
"state_employees_at_this_building" VARCHAR,
"n__occupied_by_the_state" DOUBLE,
"additional_description_of_occupied_by_the_state" VARCHAR,
"n__of_the_building_being_leased_or_subleased" VARCHAR,
"additional_description_building_leased_or_subleased" VARCHAR,
"usage_by_state_daily_weekly_monthly" VARCHAR,
"acres" DOUBLE,
"acres_used_by_state" VARCHAR,
"additional_description_of_acres" VARCHAR,
"purpose_land" VARCHAR,
"usage_by_state_daily_weekly_monthly_land" VARCHAR,
"n__of_acres_of_the_land_being_leased_or_subleased" VARCHAR,
"estimated_value" VARCHAR,
"taxes" VARCHAR,
"state" VARCHAR,
"location_1" VARCHAR
);
CREATE TABLE data_2013_report_of_underutilized_properties_tier_1 (
"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" VARCHAR,
"sectiontownshiprange" VARCHAR,
"size_of_structure_and_or_acres" VARCHAR,
"list_value" VARCHAR,
"n__of_property_being_utilized" BIGINT,
"year_built" VARCHAR,
"occupancy_rate_of_the_building" DOUBLE,
"state_employees_at_this_building" VARCHAR,
"n__occupied_by_the_state" DOUBLE,
"additional_description_of_occupied_by_the_state" VARCHAR,
"n__of_the_building_being_leased_or_subleased" DOUBLE,
"additional_description_building_leased_or_subleased" VARCHAR,
"usage_by_state_daily_weekly_monthly" VARCHAR,
"acres" DOUBLE,
"acres_used_by_state" DOUBLE,
"additional_description_of_acres" VARCHAR,
"purpose_land" VARCHAR,
"usage_by_state_daily_weekly_monthly_land" VARCHAR,
"n__of_acres_of_the_land_being_leased_or_subleased" DOUBLE,
"state" VARCHAR,
"location_1" VARCHAR
);
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,
"year_built" VARCHAR,
"occupancy_rate_of_the_building" DOUBLE,
"state_employees_at_this_building" VARCHAR,
"n__occupied_by_the_state" DOUBLE,
"additional_description_of_occupied_by_the_state" VARCHAR,
"n__of_the_building_being_leased_or_subleased" DOUBLE,
"additional_description_building_leased_or_subleased" VARCHAR,
"usage_by_state_daily_weekly_monthly" VARCHAR,
"acres" DOUBLE,
"acres_used_by_state" DOUBLE,
"additional_description_of_acres" VARCHAR,
"purpose_land" VARCHAR,
"usage_by_state_daily_weekly_monthly_land" VARCHAR,
"n__of_acres_of_the_land_being_leased_or_subleased" DOUBLE,
"estimated_value" VARCHAR,
"taxes" VARCHAR,
"state" VARCHAR,
"location_1" VARCHAR
);
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,
"list_value_acquisition_cost" VARCHAR
);
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,
"acres_of_land_used_by_state" VARCHAR,
"usage_by_state" VARCHAR
);
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,
"acres_of_undeveloped_land" DOUBLE,
"acres_of_land_used_by_state" DOUBLE,
"usage_by_state" VARCHAR,
"n__of_acres_being_leased" BIGINT,
"beginning_point_latitude" DOUBLE,
"beginning_point_longitude" DOUBLE,
"location" VARCHAR
);
Anyone who has the link will be able to view this.