School districts
The following layers are used in extracting state-level information about school districts:
- School District Objects
- School District Primary Attributes
- School Point Primary Attributes
- School Points Census table
- Join school district objects to school district primary attributes using the object ID (OBJ_ID).
- Join the results from Step 1 to the point primary attributes using the NCES district ID (NCES_DISID).
- Join the results from Step 2 to the point census table using OBJ_ID.
- Complete the selection of districts with the state attribute from the census table.
Shortcut: The first two characters of the NCES_DISID value are the state FIPS code. Using a substring of this ID should allow one to pull out the school district features for a given state.
School attendance zones
The following layers are used to extract state-level information about school attendance zones:
- School Attendance Zone Objects
- School Attendance Zone Primary Attributes
- School Point Primary Attributes
- School Point Census Table
- Join school attendance zone objects to school attendance zone primary attributes using the object ID (OBJ_ID).
- Join the results from Step 1 to the school point primary attributes table using the NCES school ID (NCES_SCHID).
- Join the results from Step 2 to the point census table using the object ID (OBJ_ID).
- Complete the selection of attendance zones with the state attribute from the census table.
Shortcut: The first two characters of the NCES_DISID value are the state FIPS code. Using a substring of this ID should allow one to pull out the school attendance zone features for a given state.
The following layers are used to extract state-level information about school points:
- School Point Objects
- School Point Census Table
- Join the school point objects to the school points census table using the object ID (OBJ_ID).
- Complete the selection of attendance zones with the state attribute from the census table.
Note: Attribute fields for each layer may be joined as needed
or desired.