The columns which are used in network screening (i.e., crash filters, network scope etc.) need to be configured in Setup SMS Column window (Safety > Network Screening > Setup > SMS Columns). The following attributes are specified for each listed SMS column:
Column | Description | |
Is Crash Scope Var? | | It determines whether the column will be listed as a crash scope variable |
| When this feature is checked in the crash filter window (Safety > Network Screening > Setup > Crash Filter) will have this column available for filter. | |
Column | Description | |
Is Network Scope Variable? | • It determines whether the SQL main profile also needs additional attribute for further filter. • The column ‘Update SQL Network Scope’ must be filled with update SQL so that the field (i.e. network scope variables) values are calculated for SQL Main Profile. Later these fields will be used in screening to filter the scope | |
Use Crash Filter? | It determines if the performance measure needs to use Crash Filter or Not. Note: Do not select ‘USE CRASH FILTER’ for Crash rate (by VMT) and crash rate (by length) | |
Update SQL Network Scope | The SQL query to update Network Scope variables in Main Profile Window. | |
Update SQL Black-Spot | The SQL query to update hotspot variables Hotspot window. | |
Update SQL Main profile | The SQL query to update variables in Main Results Window. | |
Update SQL Secondary profile | The SQL query to update variables in Secondary Results Window. | |
Examples:
SQL for Main Profile:
select route_id, 0 as lane_dir, 0 as lane_id, offset_from, offset_to from setup_network_lines
Update SQL for Highway Class:
SELECT c.SMS_HWYCLASS_ID from SETUP_SMS_HWYCLASS c where C.LRS_COMP_ID= (SELECT (MAX(b.SIGN_SYSTEM)) from WV_CO_ROUTE_VW b, SETUP_LOC_IDENT la where b.ROUTE_ID= la.ROUTE_ID and a.LOC_IDENT=la.LOC_IDENT)
Update SQL for County
SELECT c.COUNTY_ID from SETUP_COUNTY c where C.EXTERNAL_ID= (SELECT
TO_NUMBER(MAX(b.COUNTY_CODE)) from WV_CO_ROUTE_VW b, SETUP_LOC_IDENT la where b.ROUTE_ID= la.ROUTE_ID and a.LOC_IDENT=la.LOC_IDENT)
