Polk Broadband Plan - Page 80

PROJECTION OF FUTURE DEMAND The following steps were taken to produce the final Weighted Broadband Demand Score dataset: 1. In ESRI ArcGIS, perform a spatial join with the parcel layer as the target feature class and TAZs as the join feature class. The join operation is “Join one to one” and the match option is “Closest.” All target features are retained. No search radius is specified. 2. Union the resulting dataset to the Generalized Future Land Use feature class, using an XY tolerance of 10 feet to avoid producing very small features. 3. Union the resulting dataset to a census tract level dataset indicating the number of fixed broadband connections per 1000 households (FCC data available at http://transition.fcc.gov/wcb/iatd/comp.html, listed under “Form 477 Filers by State”). Use an XY tolerance of 10 feet. 4. Clip the dataset to the boundaries of the parcel layer to produce a clean parcel-level dataset. 5. Dissolve the resulting dataset at the level of the Parcel ID field, so that there is one record per parcel. 6. Clean up dataset as necessary (there may be extraneous fields). 7. Add and calculate a new field B = E + P + F + C in the resulting dataset. 8. The percentile ranking can be calculated and displayed in the final map. Most operations were performed in a GIS ModelBuilder model that is shown in Figure 60. Figure 60. ESRI ArcGIS ModelBuilder Data Model 78