About this Dataset

Access Explorer All Areas Open Access Enriched

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:39:21.212054
Tags: access, ca-nature, california-natural-resources-agency, caopendata

Tables

Table 1

@usgov.ca_gov_access_explorer_all_areas_open_access_enriched_5f8ee.table_1

506.75 kB
2,319 rows
73 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fid_openacess_singlefeature" BIGINT,
  "orig_fid" BIGINT,
  "fid_citycounties_20211123_canad" 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,
  "age20_29" BIGINT,
  "age10_19" 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, Area,
  "shape_length" DOUBLE  -- Shape, Length
);