Urban greennessacross K-12 schools in the United States.

TITLE-----U.S. K-12 Public Schools Environmental and Contextual Dataset (n = 62,055) DESCRIPTION-----------This dataset compiles geospatial, environmental, demographic, educational, and climatic data for 62,055 K-12 public schools across the United States. It integrates data from multiple sources to support analyses related to environmental equity, school performance, and climate adaptation. SOURCES-------- NCES EDGE Geocoded Public School Data (2022–2023) - Stanford Education Data Archive (SEDA) - Meta Canopy Height Map (2018)- CHELSA Bioclimatic Variables v2.1 (1981–2010)- Custom geoprocessing: buffers, block/tract joins, canopy pixel calculations SPATIAL COVERAGE----------------- United States, Hawaii, Alaska and Puerto Rico- Coordinate system: EPSG:4326 (WGS 84) VARIABLE OVERVIEW----------------- Geolocation & Administrative- LAT, LON: Geographic coordinates- STATE, COUNTY, CITY, ZIP- TRACT_FIPS, BLOCK GROUP, GEOID: Census identifiers- CBSA, CSA, NECTA: Metropolitan delineations- LOCALE, ULOCALE: Urbanicity codes Environment & Land Cover- canopy_sch: Tree canopy (%) on school grounds- canopy_blo / canopy_tra: Canopy cover at block/tract scale- total_pixe / canopy_pix: Pixels used and identified as canopy- buffer_wkt: Buffer geometry used for analysis School Attributes- NAME, NCESSCH, LEAID: Identifiers- SCHOOL_LEV, SCHOOL_TYP: Level and type- MAGNET_TEX, VIRTUAL, TITLEI, STATUS- ENROLLMENT: TOTMENROL, TOTFENROL, TOTAL- TEACHERS & Ratios: FTE, STUTERATIO- Grade indicators: PK, KG, G01–G12, UG, AE- Demographics: race/ethnicity (e.g., WH, BL, HI, AS, etc.) Socio-demographics (ACS codes)- B01002_001- B02008–B02013- B11001_002- B25058_001- B19083_001- C17002_*- B25002_002 / B25002_003- B25034_002–011 Academic Performance (Stanford Education Data Archive )- cs_mn_avg_ol: Ordinary Least Squares - cs_mn_avg_eb: Empirical Bayes Climate (CHELSA variables)- CHELSA_bio1 to bio19: Bioclimatic variables (e.g., annual mean temperature, precipitation of driest month, seasonality) TECHNICAL DETAILS------------------ Format: CSV with geometry column or GeoPackage (GPKG)- Geometry type: Points (school location) + polygon buffers- Coordinate system: EPSG:4326- Encoding: UTF-8 MISSING DATA------------Some fields may contain missing values, particularly academic variables in states that do not report publicly. LICENSING & USE---------------Academic research and non-commercial use only. Attribution required for original data providers (NCES, USDA, ACS, CHELSA). CONTACT-------Luisa Velásquez Postdoctoral Researcher University of California, Davis