Page History

...

The 'Field Map of Join Features' describes how the features will be summarized as they are joined. The first half of the list of fields displays the attributes of the school buffer layer, ending with the Shape_Area field. The second half of the list of fields, beginning with the Date field, displays the attributes of the crime layer. A count field showing how many crime points intersect with each half-mile buffer will automatically be provided, but, since many crimes will be appended to each school buffer, it does not make sense to generate summary statistics about the rest of the crime fields, since things like offense type, premise code, and address cannot be averaged. By default, the table would actually output only the attributes of the first crime encountered within each buffer, which could be very misleading. Therefore, you will remove the the crime attributes from the output fields.

1. Within 'Output Fields', click the Date field.
2. Hold down Shift and click the last Address field, so that all of the crime fields are selected.
3. Right-click on the Address field and select Remove.
4. Ensure that your Spatial Join tool Parameters tab appears as shown below and click Run.
5. In the Contents pane, right-click the new HISDElemSchools_HalfMileBuffer_WithCrimeStats layer and select Attribute Table.

Notice Notice the newly added Join_Count field.   This field tells you how many crime points are contained within each school buffer.

...

1. In the Contents pane, right-click the HISDElemSchools_HalfMileBuffer layer and select Remove.
2. In the Contents pane, right-click the HPDCrime2010_HISD layer and select Remove.
3. Right-click the HISDElemSchools_HalfMileBuffer_WithCrimeStats layer andand select Symbology.

The Symbology pane...

1. For ‘Primary symbology', use the drop-down menu to click Graduated to select Graduated Colors.
2. For ‘Field:’, use the drop-down menu to select the Join_Count field.
3. In the ‘Color Scheme:’ box, leave the default selection of Graduated colors.
4. Under the Upper Value column, click the first upper value box 27.000000 and type “25”  “25” and press Enter to move to the next range.
5. Type “50” and press Enter.
6. Type 100” and press Enter.
7. Type 150” and press Enter.
8. Type 200” and press Enter.

...