Saltar al contenido
← Todos los conjuntos de datos

School Attendance Zone Tracts

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

Cobertura de años
2027–2027
Actualización
as zones change
Versión
1.0.0
Hash del esquema
122ef0833a4d

Niveles de detalle disponibles

Escuela · predeterminado

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.

Métrica clave

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.

ColumnaTipoUnidadRango¿Nulo?Descripción
yearYearinteger——noSchool 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_codeDistrict Codestring——noGOSA 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_codeSchool Codestring——no4-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_levelZone Levelstring——noElementary, 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
  • elementary
  • high
  • middle
grade_levelGrade Levelstring——noGrade (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
  • 01
  • 02
  • 03
  • 04
  • 05
  • 06
  • 07
  • 08
  • 09
  • 10
  • 11
  • 12
  • k
tract_geoidTract GEOIDstring——no11-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.

Se une a tracts; agrega sus columnas de etiqueta.

num_populationNumber Populationintegercount—yes2020 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_populationNumber Tract Populationintegercount—yesThe 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_populationPercent of Tract Populationnumberproportion—yesShare 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_areaPercent of Tract Areanumberproportion—yesShare 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_populationPercent of Zone Populationnumberproportion—yesShare 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_tractIs Largest Zone for Tractboolean——yesTrue 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ámetroTipoValores permitidosNotas
yearyear_exactcualquier valor—
year_minyear_rangecualquier valor—
year_maxyear_rangecualquier valor—
detaildetailschoolsenum validado, predeterminado: schools
district_codeforeign_keycualquier valorvalores múltiples
school_codeforeign_keycualquier valorvalores múltiples
tract_geoidforeign_keycualquier valorvalores múltiples
zone_levelcategoricalelementaryhighmiddlevalores múltiples, enum validado
grade_levelcategorical
13 valores permitidos
  • 01
  • 02
  • 03
  • 04
  • 05
  • 06
  • 07
  • 08
  • 09
  • 10
  • 11
  • 12
  • k
valores múltiples, enum validado, elige uno
is_largest_zone_for_tractcategoricalcualquier valorvalores múltiples
district_typedimension_attribute
7 valores permitidos
  • commission_charter
  • resa
  • standard
  • state_agency
  • state_charter
  • state_school
  • state_special
valores múltiples, enum validado
school_leveldimension_attributeelementarymiddlehighk12othervalores múltiples, enum validado
localedimension_attributecitysuburbtownruralvalores 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.