The County interface provides options to import, recalculate, edit, export, and generate county summary data.

Location

The County interface () can be located by selecting the Submittals tab and navigating to the second section-- Summary Files. The County interface is the first icon in this section and the fourth on the Submittals menu. 

Populate

The user can populate the County Summaries table by using one of these methods: importing a file or recalculating the data.

Import a File

To import a county summary file, follow these steps:

1. Click the “Choose File” button at the bottom left of the interface.
2. Select a file to import.
   • To import a file, it must have the following header columns: BeginDate, StateID, CountyID, FSystem, UrbanID, Ownership, SystemLength, and Comments.
3. After selecting the desired file, click the “Open” button.

Recalculate Data

To recalculate the data, follow these steps:

1. Select a data table in the "Data Table" picklist.
   • The recalculate process uses the data table to retrieve routes that classify as rural minor collectors and local roads for each urbanized area and rural areas.
2. Click the “Recalculate” button.
3. If the new values are sufficient, click the “Save Changes” button to save the new values.

Edit

The first column in the interface table-- Override-- is available to initiate the editing process for the desired record. To fully edit a record, follow these steps:

1. Select the checkbox in the "Override" column for the desired record or click on a record that has been previously overridden.
2. Once selected, a textbox will appear in the System_Length and Comments columns to allow edits.
3. After entering the desired changes, click the “Save Changes” button.

Overridden records will not be recalculated or be overwritten by the import process.

Export

To export the county summary table, the user can click the “Export to Pipe Delimited File” link located at the bottom right of the interface. The file will be in a text file in pipe delimited format and will contain the following header columns: BeginDate, StateID, CountyID, FSystem, UrbanID, Ownership, SystemLength, and Comments.