School Attendance Zone Tracts
Which 2020 census tracts each Georgia school attendance zone covers at each grade, with population and land-area shares.
- 2027–2027
- as zones change
- 1.0.0
- 122ef0833a4d
Resumen
A crosswalk between Georgia public school attendance zones (the school_attendance_zones geometry topic: the area whose residents a school serves for a run of grades) and 2020 census tracts. One row per school, grade and tract its zone covers at that grade. Population weights are 2020 Census P.L. 94-171 block populations: each 2020 block counts toward the zone holding its interior point; a block that a zone line crosses (two or more schools' zones, or a zone and an unzoned gap, each covering over 1% of it) is split by area, in whole persons; a block whose interior point lies just outside today's district line goes to the zone covering most of it; any other block outside every zone is a gap. Use pct_of_tract_population to answer 'which zones cover this tract at this grade, and how much of it', and pct_of_zone_population to roll tract data (the census topics) up to a zone. year is the school year the zones are in effect for (2027 = 2026-27); the population is the 2020 census. Zones are not official enrollment determinations; each zone's source, method, vintage and accuracy are on the zones topic.
Granularidad de fila: Una fila por year, district_code, school_code, grade_level, tract_geoid.
pct_of_tract_population — Percent of Tract Population (proportion)
El valor principal que la mayoría de las consultas busca.
Variables
Todas las columnas de la tabla de hechos. El código es el nombre exacto del campo que devuelve la API.
| Columna | Tipo | Unidad | Rango | ¿Nulo? | Descripción |
|---|---|---|---|---|---|
year | integer | — | — | no | School year the zones are in effect for, as its ending calendar year (2027 = 2026-27). The weights are 2020 census counts.Descripción completa▾School year the zones are in effect for, as its ending calendar year (2027 = 2026-27). The weights are 2020 census counts. |
district_code | string | — | — | no | GOSA district code (FK to the districts dimension).Descripción completa▾GOSA district code (FK to the districts dimension). |
school_code | string | — | — | no | 4-digit GOSA school code (composite FK to the schools dimension with district_code): the zone's school.Descripción completa▾4-digit GOSA school code (composite FK to the schools dimension with district_code): the zone's school. |
zone_level | string | — | — | no | Elementary, middle or high zone.Descripción completa▾The level of the school's zone at this grade on the zones topic: elementary, middle or high. It follows from the grade and the school (a 6-8 middle school's grade 6, a K-6 school's grade 6 at elementary), so pin grade_level first. 3 valores permitidos▾
|
grade_level | string | — | — | no | Grade (k, 01-12).Descripción completa▾The grade the row's shares hold for (k, 01-12; pre-K is not zoned). A school's zone usually covers the same tracts at every grade it assigns; it differs where the zone differs by grade (a phased-in rezoning) or a neighbour exists at only some grades. 13 valores permitidos▾
|
tract_geoid | string | — | — | no | 11-digit 2020 census tract GEOID (FK to the tracts dimension), as used by the census topics.Descripción completa▾11-digit 2020 census tract GEOID (FK to the tracts dimension), as used by the census topics. |
num_population | integer | — | yes | 2020 census population of the tract living in the zone: whole blocks by interior point, plus the zone's area-weighted part of blocks a zone line crosses (in whole persons).Descripción completa▾2020 census population of the tract living in the zone: whole blocks by interior point, plus the zone's area-weighted part of blocks a zone line crosses (in whole persons). | |
num_tract_population | integer | — | yes | The tract's 2020 census population (all of its blocks), repeated on each of its rows: never add it across rows.Descripción completa▾The tract's 2020 census population (all of its blocks), repeated on each of its rows: never add it across rows. | |
pct_of_tract_population | number | — | yes | Share of the tract's 2020 population living in this zone.Descripción completa▾Share of the tract's 2020 population living in this zone at this grade (num_population / num_tract_population). Across a tract's zones at one grade it adds to 1 when the tract is fully zoned. | |
pct_of_tract_area | number | — | yes | Share of the tract's 2020 land area in this zone, from the same block weights as the population.Descripción completa▾Share of the tract's 2020 land area in this zone, from the same block weights as the population. | |
pct_of_zone_population | number | — | yes | Share of the zone's 2020 population at this grade living in this tract (adds to 1 over the zone's tracts at the grade). Multiply a tract count by pct_of_tract_population, or weight tract rates by this share, to roll tract data up to the zone.Descripción completa▾Share of the zone's 2020 population at this grade living in this tract (adds to 1 over the zone's tracts at the grade). Multiply a tract count by pct_of_tract_population, or weight tract rates by this share, to roll tract data up to the zone. | |
is_largest_zone_for_tract | boolean | — | — | yes | True for the zone holding the most of the tract's 2020 population at this grade (ties go to more land area, then the lower district and school code): exactly one row per tract and grade.Descripción completa▾True for the zone holding the most of the tract's 2020 population at this grade (ties go to more land area, then the lower district and school code): exactly one row per tract and grade. |
Filtros
Parámetros de consulta que acepta el endpoint de hechos. Los valores separados por comas son OR dentro de un parámetro; varios parámetros se combinan con AND.
| Parámetro | Tipo | Valores permitidos | Notas |
|---|---|---|---|
year | year_exact | cualquier valor | — |
year_min | year_range | cualquier valor | — |
year_max | year_range | cualquier valor | — |
detail | detail | schools | enum validado, predeterminado: schools |
district_code | foreign_key | cualquier valor | valores múltiples |
school_code | foreign_key | cualquier valor | valores múltiples |
tract_geoid | foreign_key | cualquier valor | valores múltiples |
zone_level | categorical | elementaryhighmiddle | valores múltiples, enum validado |
grade_level | categorical | 13 valores permitidos▾
| valores múltiples, enum validado, elige uno |
is_largest_zone_for_tract | categorical | cualquier valor | valores múltiples |
district_type | dimension_attribute | 7 valores permitidos▾
| valores múltiples, enum validado |
school_level | dimension_attribute | elementarymiddlehighk12other | valores múltiples, enum validado |
locale | dimension_attribute | citysuburbtownrural | valores múltiples, enum validado |
Ejemplos de solicitudes
Ejecútalos contra la URL base: devuelven datos en vivo.
All rows (first page), schools level
curl "https://georgiacivicdata.org/api/v1/education/school_attendance_zone_tracts"schools data for 2027
curl "https://georgiacivicdata.org/api/v1/education/school_attendance_zone_tracts?year=2027"Filtered to zone_level = elementary for 2027
curl "https://georgiacivicdata.org/api/v1/education/school_attendance_zone_tracts?year=2027&zone_level=elementary"Download 2027 as CSV
curl "https://georgiacivicdata.org/api/v1/education/school_attendance_zone_tracts?year=2027&format=csv"Notas y limitaciones
Manejo de NULL
- El cero es un valor real y reportado.
Limitaciones
Covers the districts whose zones were collected: a tract in a district without zones at a grade, or in a gap, has no rows there or rows whose population shares add to less than 1. Gaps include areas the zones topic leaves unassigned on purpose: new schools not yet in the schools dimension (their zones are withheld), placement areas whose students are placed among several schools, and closed schools' former areas that no published map reassigns; see the zones topic's coverage table. Some zones are known to predate an adopted boundary change (currency_status stale_known_changes on the zones topic) and carry that error here. Weights are the 2020 census: the share of a tract in each zone is frozen at April 2020, so it misses growth since then, which is largest where new schools and rezonings are. A block that a zone line or a gap's edge crosses is split by area, assuming its people are spread evenly over its land. A block counts toward the district whose current TIGER/Line outline holds its 2020 interior point (the 2020 Block Assignment File where no outline does), as a point lookup answers. Rows are school rows: every row has a district, school and tract.