TPL ParkScore Data
City of Austin
@usgov.city_of_austin_tpl_parkscore_data
City of Austin
@usgov.city_of_austin_tpl_parkscore_data
This is a collection of data submitted to Trust for Public Land (TPL) as part of the scoring process for the annual TPL Park Score ranking.
Organization: City of Austin
Last updated: 2023-08-25T22:10:43.182461
Tags: pard, parkscore, survey, tpl
CREATE TABLE table_1 (
"survey_question" BIGINT,
"report_date" VARCHAR,
"tpl_ranking" BIGINT,
"number_of_cities_measured" DOUBLE,
"n_33_how_many_total_paid_and_unpaid_uses_visits_or_use_8197a6e5" DOUBLE -- 33. How Many Total (paid And Unpaid) Uses (visits Or User-days) Do You Estimate Your System Had?,
"n_12_what_is_the_total_number_of_park_units_owned_and__868ad790" DOUBLE -- 12. What Is The Total Number Of Park Units Owned (and/ Or Controlled) By Your Agency Within City Limits?,
"n_13a_of_the_acreage_that_your_agency_owns_and_or_cont_827cf640" DOUBLE -- 13a. Of The Acreage That Your Agency Owns (and/or Controls) Within The City Limits, How Many Acres, Including Water Acres, Are Natural Lands?(What Is This?),
"n_13b_of_the_acreage_that_your_agency_owns_and_or_cont_809c71aa" DOUBLE -- 13b. Of The Acreage That Your Agency Owns (and/or Controls) Within The City Limits, How Many Acres, Including Water Acres, Are Designed Lands?(What Is This?),
"n_13c_of_the_acreage_that_your_agency_owns_and_or_cont_c6cb3b22" DOUBLE -- 13c. Of The Acreage That Your Agency Owns (and/or Controls) Within The City Limits, How Many Acres, Including Water Acres, Are Not Yet Open To The Public?(What Is This?),
"total_acreage_within_city_limits" DOUBLE,
"n_14_if_you_own_land_outside_the_jurisdiction_what_is__30139dbe" DOUBLE -- 14. If You Own Land Outside The Jurisdiction, What Is The Acreage?,
"n_22a_what_is_the_name_of_your_most_visited_park" VARCHAR -- 22a. What Is The Name Of Your Most Visited Park?,
"n_22b_how_many_annual_visitors_does_it_receive" DOUBLE -- 22b. How Many Annual Visitors Does It Receive?,
"n_23a_approximately_how_many_park_trees_are_you_respon_6b103895" DOUBLE -- 23a. Approximately How Many Park Trees Are You Responsible For?,
"n_23b_how_many_park_trees_did_you_plant" DOUBLE -- 23b. How Many Park Trees Did You Plant?,
"n_23c_how_many_park_trees_did_you_remove" DOUBLE -- 23c. How Many Park Trees Did You Remove?,
"n_25a_how_many_full_time_equivalent_regular_non_season_34a8361c" DOUBLE -- 25a. How Many (Full Time Equivalent) Regular, Non-Seasonal Employees Does Your Agency Have?,
"n_25b_how_many_full_time_equivalent_seasonal_employees_551964e2" DOUBLE -- 25b. How Many (Full Time Equivalent) Seasonal Employees Does Your Agency Have?,
"n_26a_approximately_how_many_people_did_volunteer_work_e44a5e41" DOUBLE -- 26a. Approximately How Many People Did Volunteer Work For Your Agency?,
"n_26b_approximately_how_many_total_hours_did_volunteers_work" DOUBLE -- 26b. Approximately How Many (total) Hours Did Volunteers Work?,
"what_is_your_agency_s_total_budget_for_the_above_fiscal_year" VARCHAR -- What Is Your Agency's Total Budget For The Above Fiscal Year?,
"general_appripriations_general_fund" VARCHAR,
"captial_improvments" VARCHAR,
"land_acquisition" VARCHAR,
"year_data_is_from" BIGINT
);Anyone who has the link will be able to view this.