There is no direct correspondence between OBJ_ID in the School Points table and OBJ_ID in the School Attendance Zone table. To join points and attendance zones, OBJ_ID field from the School Points table (school_point_usa_objects) needs to be joined to OBJ_ID_PNT field from the SAZ tertiary attribute table (school_attendance_zone_usa_tertiary_attributes) using the following procedure:
- Join point objects to point primary attributes using OBJ_ID to get the full set of point attribution.
- Join attendance zone objects to attendance zone tertiary attributes.
- Using the results of Steps 1 and 2, join point information to attendance zones –
school_point_usa_objects.OBJ_ID = school_attendance_zone_usa_tertiary_attributes.OBJ_ID_PNT
Not all points have an attendance zone, so not all points will join for one of the following reasons:
- Some school types do not have attendance zones. The most common school types without
an attendance zone are –
- Alternative
- Charter
- Choice
- Indian
- Magnet
- Military
- Vocational
- Precisely is unable to locate an official resource for school boundary information from either the district, the school, or local or state governments
- There is a legitimate school with an attendance zone on the district website, but it has not been updated in our records due to resource constraints