School Attendance Zone Block Groups

Which 2020 census block groups each Georgia school attendance zone covers at each grade, with population, household and land-area shares.

Fuente: School attendance zones (this platform's school_attendance_zones topic); U.S. Census Bureau 2020 Census P.L. 94-171 block populations and occupied housing units, TIGER/Line 2020 blocks, and TIGER/Line school district outlines.
Cobertura de años: 2027–2027
Actualización: as zones change
Versión: 1.0.0
Hash del esquema: 58174ac48ecb

Niveles de detalle disponibles

Escuela · predeterminado

Resumen

A crosswalk between Georgia public school attendance zones (the school_attendance_zones geometry topic) and 2020 census block groups. One row per school, grade and block group its zone covers at that grade. Weights are 2020 Census P.L. 94-171 block populations and households (occupied housing units), assigned to zones block by block exactly as in the tract crosswalk (school_attendance_zone_tracts): a block goes to the zone holding its interior point, or is split by area where a zone line or an unzoned gap crosses it. Use pct_of_block_group_households to roll block-group household data (ACS household tables) up to a zone, pct_of_block_group_population for person data. year is the school year the zones are in effect for (2027 = 2026-27). Zones are not official enrollment determinations; each zone's source and accuracy are on the zones topic.

Granularidad de fila: Una fila por year, district_code, school_code, grade_level, block_group_geoid.

Métrica clave

pct_of_block_group_population — Percent of Block Group Population (proportion)

El valor principal que la mayoría de las consultas busca.

Esquema JSON →Contrato de datos (YAML) →

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`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`District Code	string	—	—	no	GOSA district code (FK to the districts dimension). Descripción completa▾ GOSA district code (FK to the districts dimension). Se une a districts; agrega sus columnas de etiqueta.
`school_code`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. Se une a schools; agrega sus columnas de etiqueta.
`zone_level`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, so pin grade_level first. 3 valores permitidos▾ `elementary` `middle` `high`
`grade_level`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). 13 valores permitidos▾ `k` `01` `02` `03` `04` `05` `06` `07` `08` `09` `10` `11` `12`
`block_group_geoid`Block Group GEOID	string	—	—	no	12-digit 2020 census block group GEOID (FK to the block_groups dimension), as ACS 5-year tables publish. Descripción completa▾ 12-digit 2020 census block group GEOID (FK to the block_groups dimension), as ACS 5-year tables publish. Se une a block_groups; agrega sus columnas de etiqueta.
`num_population`Number Population	integer	count	—	yes	2020 census population of the block group living in the zone (whole persons). Descripción completa▾ 2020 census population of the block group living in the zone (whole persons).
`num_block_group_population`Number Block Group Population	integer	count	—	yes	The block group's 2020 census population (all of its blocks), repeated on each of its rows: never add it across rows. Descripción completa▾ The block group's 2020 census population (all of its blocks), repeated on each of its rows: never add it across rows.
`pct_of_block_group_population`Percent of Block Group Population	number	proportion	—	yes	Share of the block group's 2020 population living in this zone. Descripción completa▾ Share of the block group's 2020 population living in this zone at this grade (num_population / num_block_group_population).
`pct_of_block_group_area`Percent of Block Group Area	number	proportion	—	yes	Share of the block group's 2020 land area in this zone. Descripción completa▾ Share of the block group's 2020 land area in this zone.
`pct_of_zone_population`Percent of Zone Population	number	proportion	—	yes	Share of the zone's 2020 population at this grade living in this block group (adds to 1 over the zone's block groups). Descripción completa▾ Share of the zone's 2020 population at this grade living in this block group (adds to 1 over the zone's block groups).
`num_households`Number Households	integer	count	—	yes	2020 census households (occupied housing units, P.L. 94-171 H1_002N) of the block group in the zone, apportioned with the same block weights as the population (whole households). Descripción completa▾ 2020 census households (occupied housing units, P.L. 94-171 H1_002N) of the block group in the zone, apportioned with the same block weights as the population (whole households).
`num_block_group_households`Number Block Group Households	integer	count	—	yes	The block group's 2020 households (all of its blocks; equals the block_groups dimension's households_2020), repeated on each of its rows: never add it across rows. Descripción completa▾ The block group's 2020 households (all of its blocks; equals the block_groups dimension's households_2020), repeated on each of its rows: never add it across rows.
`pct_of_block_group_households`Percent of Block Group Households	number	proportion	—	yes	Share of the block group's 2020 households in this zone at this grade (num_households / num_block_group_households): the weight for household data. Descripción completa▾ Share of the block group's 2020 households in this zone at this grade (num_households / num_block_group_households): the weight for household data.
`is_largest_zone_for_block_group`Is Largest Zone for Block Group	boolean	—	—	yes	True for the zone holding the most of the block group's 2020 population at this grade (ties: more land, then the lower district and school code): one row per block group and grade. Descripción completa▾ True for the zone holding the most of the block group's 2020 population at this grade (ties: more land, then the lower district and school code): one row per block group 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
`block_group_geoid`	foreign_key	cualquier valor	valores múltiples
`zone_level`	categorical	`elementarymiddlehigh`	valores múltiples, enum validado
`grade_level`	categorical	13 valores permitidos▾ `k` `01` `02` `03` `04` `05` `06` `07` `08` `09` `10` `11` `12`	valores múltiples, enum validado, elige uno
`is_largest_zone_for_block_group`	categorical	cualquier valor	valores múltiples
`district_type`	dimension_attribute	7 valores permitidos▾ `commission_charter` `resa` `standard` `state_agency` `state_charter` `state_school` `state_special`	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_block_groups"

schools data for 2027

curl "https://georgiacivicdata.org/api/v1/education/school_attendance_zone_block_groups?year=2027"

Filtered to zone_level = elementary for 2027

curl "https://georgiacivicdata.org/api/v1/education/school_attendance_zone_block_groups?year=2027&zone_level=elementary"

Download 2027 as CSV

curl "https://georgiacivicdata.org/api/v1/education/school_attendance_zone_block_groups?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 block group in a district without zones at a grade, or in a gap, has no rows there or rows whose shares add to less than 1 (gaps include withheld new schools' areas, placement areas and closed schools' former areas; see the zones topic's coverage table). Some zones 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 block group in each zone is frozen at April 2020, so it misses growth and new housing since. A block that a zone line or a gap's edge crosses is split by area, assuming its people and households are spread evenly over its land. Household counts carry the Census's disclosure-avoidance noise (a block can show households and no people), which shrinks as blocks are summed. A block counts toward the district whose current TIGER/Line outline holds its interior point. The same blocks and rules as the tract crosswalk (school_attendance_zone_tracts): summed to tracts, the people match it exactly. Rows are school rows.