cell_id | id | Stable number of the hexagon area |
area_name | name | Area name: nearest mapped place, or the cross streets inside or nearest the area where the build names areas by street |
nearest_major_intersection | near | Nearest intersection of two through streets, with direction and distance from the area center; empty where the name is that intersection or the build does not name areas by street |
area_type | place | res = residents ranked; activity = developed, no residents; empty = undeveloped |
city_or_community | city | City or census-designated community containing the area's center (Census TIGERweb places) |
rank | rank | Rank under the priorities in this file (1 = most need) |
priority_score_0_100 | score | Priority score under these priorities, relative within the study area |
rank_recommended_mix | rank_default | Rank under the recommended mix shipped with the data |
score_recommended_mix | score_default | Score under the recommended mix |
rank_recommended_mix_p05 | rank_lo | Recommended-mix rank, 5th percentile across re-draws of census margins and ±10-point weight jitter |
rank_recommended_mix_p95 | rank_hi | Recommended-mix rank, 95th percentile across the same re-draws |
top_tier_share | rank_top_share | Share of re-draws in which the area ranks in the best 10% under the recommended mix |
surface_heat_c | lst_c | Summer land-surface temperature, °C (satellite) |
tree_cover_pct | canopy_pct | Tree cover, % of assessed land; empty where only satellite greenness is available |
greenness_index_0_100 | greenness_index | Satellite greenness index, 0–100; filled only where tree_cover_source_type = ndvi |
tree_cover_source_type | green_src | canopy = tree-cover map (aerial classification or a model of it, calibrated height model or lidar; see tree_cover_dataset); ndvi = satellite greenness stand-in |
tree_cover_dataset | canopy_source | usfs-2022 aerial classification, naip-model (modelled from the 2022 aerial survey outside the USFS map), usfs+naip-model (USFS map for the assessed part, the same model for the rest, where most homes lie outside the assessed part), chm-legacy height model, lidar-2020 county lidar map, or none (no tree-cover assessment; greenness stand-in) |
tree_cover_year | canopy_year | Year of the tree-cover dataset |
tree_cover_assessed_fraction | coverage_frac | Share of the area the aerial assessment covers (0–1) |
tree_cover_quality | canopy_quality | full, partial, modelled (see naip-model), completed (see usfs+naip-model), calibrated (height model rescaled to the aerial line), lidar, coverage-unknown, below-threshold (assessed on under 10% of the area) or unassessed |
tree_cover_m2 | canopy_m2 | Assessed tree crown area, m² |
assessed_area_m2 | assessed_m2 | Land the assessment covers, m² |
residents | pop | Estimated residents (ACS, allocated into the area) |
residents_65_plus_pct | pct65 | Estimated share of residents aged 65+, % |
homes_with_ac_pct | ac_pct | Estimated share of homes with air conditioning, % |
ac_source | ac_src | lace = Census LACE; lace-pop = population-weighted LACE; income-model = fallback estimate |
ac_coverage_fraction | ac_coverage | Share of homes with a LACE estimate (0–1) |
census_acs_year | acs_year | ACS five-year vintage |
walk_to_cooling_min | access_min | Estimated walking minutes to the nearest mapped cool place |
walk_to_cooling_km | access_km | Estimated walking distance, km |
walk_quality_flag | access_quality | network-estimate, approach-review (>100 m off-network approach) or detour-review (route far longer than the straight line) |
walk_method | access_src | routed = walked on the OpenStreetMap pedestrian network; straightline = straight-line distance times a detour factor because the area could not be connected to the network |
share_inside_study_area | inside_frac | Share of the hexagon inside the study boundary (1 = wholly inside); residents, street capacity and the city label describe that part only |
walk_network_connection_m | access_snap_m | Straight-line meters from the area center to the walking network |
area_m2 | area_m2 | Area of the hexagon, m² |
mapped_street_m | street_m | Mapped street centerline in the area, m: theoretical capacity from OpenStreetMap, not surveyed plantable space |
street_room_tree_spots | street_room_positions | Tree spots the mapped street could hold on both sides at the spacing in tree_spacing_m (10 m unless changed in the app): an upper bound, not a site survey |
street_room_band | street_room_band | no mapped street, little room, some room or plenty of room: city-relative thirds of the areas with any mapped street |
planting_scenario_available | scenario_ok | true when mapped street capacity exists |
tree_cover_baseline_complete | canopy_baseline_ok | true when the aerial assessment covers ≥99% of the area |
land_cover | land | Dominant land cover (ESA WorldCover) for undeveloped areas |
redlining_grade | holc | 1930s HOLC grade A–D where a map exists |
ward_id | ward_id | Council ward or district number, where the city publishes boundaries |
ward_name | ward_name | Council ward or district name; blank = outside every ward |
sb535_dac_share_pct | dac | Share of the area inside an SB 535 disadvantaged community (CalEPA, September 2026), % |
sb535_dac_criterion | dac_type | Designation criterion of the tract covering most of the area |
sb535_dac_tract | dac_tract | Census tract GEOID of that designated tract |
priority_population_share_pct | pp | Share of the area inside a California Climate Investments priority population area (CARB Priority Populations 5.0: SB 535 disadvantaged or AB 1550 low-income community), %; empty where the build does not carry the layer |
priority_population_designation | pp_type | Designation covering most of the area: disadvantaged, disadvantaged and low-income, low-income, or low-income within half a mile of a disadvantaged community |
schools_in_area | schools | Open schools in the area (city school layer); empty where the build does not count places |
school_names | school_names | Names of up to three of those schools |
bus_stops_in_area | bus_stops | Transit stops in the area |
park_share_pct | park | Share of the area inside a public park, % |
park_name | park_name | Name of the park covering most of that share |
park_city_owned | park_city | true where that park belongs to the city itself |
fire_perimeter_share_pct | fire | Share of the area inside the perimeter of a wildfire newer than the tree-cover and census inputs, %; empty or 0 where none |
fire_name | fire_name | Name of that fire (CAL FIRE perimeter) |
fire_year | fire_year | Year of that fire |
planting_share_pct | planting_share | Share of street capacity planted in this scenario, % |
scenario_trees_planted | trees | Trees planted in this scenario |
scenario_trees_surviving | trees_surviving | Trees assumed to reach maturity (survival_share_pct in planting_assumptions) |
scenario_tree_cover_gain_points | canopy_gain_points | Added tree cover at maturity from surviving trees, percentage points |
scenario_cost_usd | cost_usd | Indicative cost for all planted trees at cost_per_tree_usd; cost_scope says what that figure is taken to cover |
field_check_status | field_status | Field-check status entered in the app (To visit / Checked · feasible / partly / not feasible / Planted) |
field_check_note | field_note | Field-check note entered in the app |
field_check_updated | field_note_updated | When the field check was last edited (ISO time) |
scenario_air_cooling_c | cooling_c | Illustrative summer air cooling at maturity, °C |
scenario_future_tree_cover_pct | future_canopy_pct | Tree cover at maturity, % (only when the baseline is complete) |
study_area_slug | study_area_slug | Build (study area) this row was exported from |
exported_at | exported_at | Export time (ISO 8601) |
dataset_sha256 | dataset_sha256 | Fingerprint of the data file |
dataset_version | dataset_version | Data version tag |
dataset_acs_year | dataset_acs_year | ACS vintage of the data file |
preset | preset | Preset in force, or custom |
population_weight | population_weight | How strongly population counts (0–1) |
cost_per_tree_usd | cost_per_tree_usd | Per-tree figure behind scenario_cost_usd |
cost_scope | cost_scope | What the per-tree figure is taken to cover |
survival_share_pct | survival_share_pct | Share of planted trees assumed to reach maturity, % |
tree_spacing_m | tree_spacing_m | Spacing that turns mapped street length into tree positions, m |
crown_m2_per_tree | crown_m2_per_tree | Mature crown area credited per surviving tree, m² |
cooling_c_per_10_canopy_points | cooling_c_per_10_canopy_points | Illustrative summer air cooling per 10 canopy points, °C |
weight_hotter_ground | w_heat | Share of the ranking given to hotter ground |
weight_fewer_trees | w_green | Share given to fewer trees |
weight_homes_without_ac | w_ac | Share given to homes without A/C |
weight_older_residents | w_age65 | Share given to older residents |
weight_far_from_cooling | w_access | Share given to distance from cooling |
weight_sb535_community | w_dac | Share given to SB 535 disadvantaged-community designation |