The Data Table Definition functionality is concentrated in the Required Items and Attributes tabs in the Data Tables interface. This article focuses on the first tab, Required Items.
Required Items Tab
The Required Items must be defined before an overlay can be populated or refreshed. There are two mandatory items required by HPMS Manager: Routes and Sample Section Locations. Each of these items have their own internal tabs on the interface. Once an overlay is populated, an icon will appear next to the title of the tab, indicating the status of the imported data. Each time the overlay is populated or refreshed, this icon will be updated to reflect the import status. Click here to learn more about the status types.
Route Tab
This interface is used to specify the route network to use when retrieving route data. There are two data source types in this tab: R&H or Non-R&H. The table below outlines the controls provided for each data source option.
| Control | Data Source Type | Used To... |
| "Is R&H" Checkbox | N/A | Specify whether the Route data is a Roads and Highways (R&H) data source. |
| Map Service Dropdown | R&H | Select the map service that the route network data is located in. |
| Network Name Dropdown | R&H | Select the route network; auto-filled after selecting a Map Service. |
| Version Dropdown | R&H | Select the Geodatabase version; auto-filled after selecting a Map Service. |
| Filters Textbox | R&H | Enter a valid SQL filter the Populate process uses to filter a subset of data from the selected route network. |
| Data Source Dropdown | Non-R&H | Select the data source for route network data; required. |
| Table Name Dropdown | Non-R&H | Select the table where the route data is located; auto-filled once a data source is selected. |
| Route ID Dropdown | Non-R&H | Specify the Route ID field for the route data. |
| From Measure Dropdown | Non-R&H | Specify the From Measure field for the route data. |
| To Measure Dropdown | Non-R&H | Specify the To Measure field for the route data. |
| From Date Dropdown | Non-R&H | Specify the From Date field when applying temporal data filters. This field is only required if the selected data table contains temporal data. |
| To Date Dropdown | Non-R&H | Specify the To Date field when applying temporal data filters. This field is only required if the selected data table contains temporal data. |
| Filters Textbox | Non-R&H | Enter a valid SQL filter the Populate process uses to filter a subset of data from the selected table. |
Sample Section Locations Tab
This interface is used to enter the data source for sample data. Both data source types (R&H or Non-R&H) are on this interface as well. The table below outlines the controls provided for each data source option.
| Control | Data Source Type | Used To... |
| "Is R&H" Checkbox | N/A | Specify whether the Route data is a Roads and Highways (R&H) data source. |
| Version Dropdown | R&H | Specify which Geodatabase version to use for the sample data; required. |
| Event Name Dropdown | R&H | Specify which event contains the sample data information; required. |
| Source Column Dropdown | R&H | Specify which column to use for the Sample ID field in the HPMS Data table; required.* |
| Filters Textbox | R&H | Enter a SQL filter that can be used to filter a subset of data from the selected event table. |
| Data Source Dropdown | Non-R&H | Select the data source for the sample data; required. |
| Table Name Dropdown | Non-R&H | Specify the table that contains sample data; required.* |
| Column Dropdown | Non-R&H | Specify the Sample ID field in the HPMS Data table; required.* |
| Route ID Dropdown | Non-R&H | Specify the Route ID field for the sample data; required.* |
| From Measure Dropdown | Non-R&H | Specify the From Measure field for the sample data; required.* |
| To Measure Dropdown | Non-R&H | Specify the To Measure field for the sample data; required.* |
| From Date Dropdown | Non-R&H | Specify the From Date field when applying temporal data filters.* |
| To Date Dropdown | Non-R&H | Specify To Date field when applying temporal data filters.* |
| Filters Textbox | Non-R&H | Enter a valid SQL filter that can be used to retrieve a subset of data from the selected table. |
| Allow Save to Source Checkbox | Non-R&H | Permit the update of sample section source data for database source types. |
*Once a table is selected, the dropdown will be filled with a list of columns found in the selected table.
Comments
0 comments
Please sign in to leave a comment.