FourSevens Tool
The FourSevens tool makes it much easier for users to compile their Fixed Broadband Deployment data inot a properly formatted, FCC-ready CSV repot. The tool processes input data provided by the user and quickly outputs a csv file that would otherwise have to be manually created by the user.
Once installed, the tool can be accessed by clicking on the Telecom tab in ArcGIS Pro and selecting the FourSevens button in the Reports group as shown below.
Welcome Page
The Welcome Page is the first page that appears when the tool is loaded. This page is used to select the type of report to be run and begin the process of running the tool. Currently, the only report type available in the tool is for Fixed Broadband Deployment. A link is also provided that navigates to the FCC 477 Reporting website where details on each of the report types can be reviewed before starting, as shown below.
Provider Details Page
The Provider Details Page is the first Fixed Broadband Deployment (F.B.D.) page in the wizard. This page simply asks for the 'Doing Business As' (D.B.A.) name for the reporting service provider.
Census Data Page
The Census Data Page is used to gather details about the Census Block layer in the map that contains the census polygon data. That is, the user will select the relevant polygon feature layer from a list of all polygon feature layers that are present in the map. Next, the user will select the field that contains the required Census Block ID from the selected feature layer.
- Select the polygon feature layer that contains the census block information.
- Select the field (from the selected layer) that contain the ID of the census block.
Service Location Data Page 1
The first Service Location Page requires the user to select the point feature layer containing the service location data as well as some field values based on that selection.
- Select the point feature layer that contains the service location information.
- Select the field (from the selected layer) that contains the service location type data.
- Assign the unique values found in the layer data to the values required for the report by selecting an Expected Field Value followed by any Distinct Field Value that is relevant. (i.e. if the report is looking for 'Consumer' and the layer data has 'con', then 'con' will be shown in the Distinct Field Values and should be selected)
Service Location Data Page 2
The second Service Location Data Page requires the user to select the field containing the technology type data.
- Select the field that contains the technology type data.
- Assign each Expected Field Value to it's corresponding Distinct Field Values as was done on the previous step.
Service Location Data Page 3
The third and final Service Location Data Page requires the user to select the fields containing the various bandwidth values that are reported on.
- Select the field that contains the maximum advertised downstream bandwidth data.
- Select the field that contains the maximum advertised upstream bandwidth data.
Output Information Page
The Output Information Page allows the user to specify the file name and folder path location where the output from the tool will be stored.
Output Information Page (Processing)
Once the output file and path have been specified, the 'Run' button is enabled and the tool is ready to go. When 'Run' is clicked, a progress window will appear to show the progress of the tool. Once completed, a prompt will appear indicating the tool has finished with a reminder of the chosen file path and name for the output. From here, the user may go back to any page to adjust values to run the tool again, or go to reset the tool by clicking 'Start Over'.
Note: While running, the process can be cancelled at any time, but the output file will contain any data processed prior to cancellation.