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 tab is used to enter data for items required for all Data tables. These 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. Both of these items have their own internal tabs on the interface.
Statuses
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. The available statuses-- Success, Warning, and Fatal Error-- are described here.
Routes 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. When a data source type is selected, the controls will update to reflect the associated fields for this choice; the table below outlines the controls provided for each data source selection.
| Control | Data Source Type | Used To... |
| "Is R&H" Checkbox | R&H and Non-R&H | 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. |
| Version Dropdown | R&H | Select the Geodatabase version. |
| 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. |
| 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 when applying temporal data filters (if the selected data table contains temporal data). |
| To Date Dropdown | Non-R&H | Specify the To Date when applying temporal data filters (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. When a data source type is selected, the controls will update to reflect the associated fields for this choice; the table below outlines the controls provided for each data source selection.
| Control | Data Source Type | Used To... |
| "Is R&H" Checkbox | R&H and Non-R&H | 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 data is located in. |
| 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 when applying temporal data filters (if the selected data table contains temporal data). |
| To Date Dropdown | Non-R&H | Specify To Date when applying temporal data filters (if the selected data table contains temporal data). |
| 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. |
Comments
0 comments
Please sign in to leave a comment.