About this Dataset

Access Explorer City County Reference

Half-mile access sheds to open access open space in the conservation areas dataset built for CA Nature. Each has been intersected to a city and county dataset to allow summarization of demographics. These were then enriched using ESRI's geoenrichment services to provide select demographics. Three layers are included:

1. Half-mile access sheds from open access areas considered 30x30 Conservation Areas (GAP Code 1 and 2)

2. Half-mile access sheds from open access areas in the Conservation Areas dataset (GAP Codes 1, 2, 3, 4)

3. All city and county areas to provide baseline demographics for comparison.

Demographic variables include:

Population
Age Distribution
Educational Attainment
Housing Unit Occupancy
Hispanic or Latino Origin
Race
Household income
Organization: State of California
Last updated: 2024-03-30T02:05:41.831884
Tags: access, ca-nature, california-natural-resources-agency, caopendata

Tables

Table 1

@usgov.ca_gov_access_explorer_city_county_reference_b7e02.table_1

243.06 KB
539 rows
70 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "county_name" VARCHAR,
  "city" VARCHAR,
  "aggregationmethod" VARCHAR,
  "hasdata" BIGINT,
  "original_oid" BIGINT,
  "sourcecountry" VARCHAR,
  "educationalattainment_nohs_cy" BIGINT,
  "educationalattainment_somehs_cy" BIGINT,
  "educationalattainment_hsgrad_cy" BIGINT,
  "educationalattainment_ged_cy" BIGINT,
  "educationalattainment_smcoll_cy" BIGINT,
  "educationalattainment_asscdeg_c" BIGINT,
  "educationalattainment_bachdeg_c" BIGINT,
  "educationalattainment_graddeg_c" BIGINT,
  "educationalattainment_educbasec" BIGINT,
  "populationtotals_totpop_cy" BIGINT,
  "raceandhispanicorigin_pacific_c" BIGINT,
  "raceandhispanicorigin_othrace_c" BIGINT,
  "raceandhispanicorigin_asian_cy" BIGINT,
  "raceandhispanicorigin_amerind_c" BIGINT,
  "raceandhispanicorigin_black_cy" BIGINT,
  "raceandhispanicorigin_white_cy" BIGINT,
  "raceandhispanicorigin_hisppop_c" BIGINT,
  "raceandhispanicorigin_race2up_c" BIGINT,
  "raceandhispanicorigin_nonhisp_c" BIGINT,
  "householdincome_hinc0_cy" BIGINT,
  "householdincome_hinc15_cy" BIGINT,
  "householdincome_hinc25_cy" BIGINT,
  "householdincome_hinc35_cy" BIGINT,
  "householdincome_hinc50_cy" BIGINT,
  "householdincome_hinc75_cy" BIGINT,
  "householdincome_hinc100_cy" BIGINT,
  "householdincome_hinc150_cy" BIGINT,
  "householdincome_hinc200_cy" BIGINT,
  "householdincome_hincbasecy" BIGINT,
  "f5yearincrements_pop0_cy" BIGINT,
  "f5yearincrements_pop5_cy" BIGINT,
  "f5yearincrements_pop10_cy" BIGINT,
  "f5yearincrements_pop15_cy" BIGINT,
  "f5yearincrements_pop20_cy" BIGINT,
  "f5yearincrements_pop25_cy" BIGINT,
  "f5yearincrements_pop30_cy" BIGINT,
  "f5yearincrements_pop35_cy" BIGINT,
  "f5yearincrements_pop40_cy" BIGINT,
  "f5yearincrements_pop45_cy" BIGINT,
  "f5yearincrements_pop50_cy" BIGINT,
  "f5yearincrements_pop55_cy" BIGINT,
  "f5yearincrements_pop60_cy" BIGINT,
  "f5yearincrements_pop65_cy" BIGINT,
  "f5yearincrements_pop70_cy" BIGINT,
  "f5yearincrements_pop75_cy" BIGINT,
  "f5yearincrements_pop80_cy" BIGINT,
  "f5yearincrements_pop85_cy" BIGINT,
  "ownerrenter_owner_cy" BIGINT,
  "ownerrenter_renter_cy" BIGINT,
  "age0_9" BIGINT,
  "age10_19" BIGINT,
  "age20_29" BIGINT,
  "age30_39" BIGINT,
  "age40_49" BIGINT,
  "age50_59" BIGINT,
  "age60_69" BIGINT,
  "age70_79" BIGINT,
  "age80_plus" BIGINT,
  "edu_lesshs" BIGINT,
  "edu_hs_lessba" BIGINT,
  "edu_bachgrad" BIGINT,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);