eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: CSF.CSF_MD_RD_SEGS#

Source

View Text - Preformatted


select ROAD_SEGMENT_ID ROAD_SEGMENT_ID, FUNCTIONAL_CLASS FUNCTIONAL_CLASS, CONSTRUCTION_STATUS CONSTRUCTION_STATUS, FORM_OF_WAY FORM_OF_WAY, SPEED_CATEGORY SPEED_CATEGORY, LANE_CATEGORY LANE_CATEGORY, ONEWAY_DIRECTION ONEWAY_DIRECTION, TOLL_ROAD TOLL_ROAD, PAVED PAVED, FEATURE_CODE FEATURE_CODE, FERRY_TYPE FERRY_TYPE, ACCESS_CAR ACCESS_CAR, ACCESS_CARPOOL ACCESS_CARPOOL, ACCESS_DELIVERY ACCESS_DELIVERY, ACCESS_TAXI ACCESS_TAXI, ACCESS_PEDESTRIAN ACCESS_PEDESTRIAN, ACCESS_BUS ACCESS_BUS, ACCESS_BICYCLE ACCESS_BICYCLE, ACCESS_EMERGENCY ACCESS_EMERGENCY, ACCESS_TRUCK ACCESS_TRUCK, INST_STYLE_ID INST_STYLE_ID, GEOMETRY GEOMETRY, SECURITY_GROUP_ID SECURITY_GROUP_ID from "CSF"."CSF_MD_RD_SEGS"

View Text - HTML Formatted

SELECT ROAD_SEGMENT_ID ROAD_SEGMENT_ID
, FUNCTIONAL_CLASS FUNCTIONAL_CLASS
, CONSTRUCTION_STATUS CONSTRUCTION_STATUS
, FORM_OF_WAY FORM_OF_WAY
, SPEED_CATEGORY SPEED_CATEGORY
, LANE_CATEGORY LANE_CATEGORY
, ONEWAY_DIRECTION ONEWAY_DIRECTION
, TOLL_ROAD TOLL_ROAD
, PAVED PAVED
, FEATURE_CODE FEATURE_CODE
, FERRY_TYPE FERRY_TYPE
, ACCESS_CAR ACCESS_CAR
, ACCESS_CARPOOL ACCESS_CARPOOL
, ACCESS_DELIVERY ACCESS_DELIVERY
, ACCESS_TAXI ACCESS_TAXI
, ACCESS_PEDESTRIAN ACCESS_PEDESTRIAN
, ACCESS_BUS ACCESS_BUS
, ACCESS_BICYCLE ACCESS_BICYCLE
, ACCESS_EMERGENCY ACCESS_EMERGENCY
, ACCESS_TRUCK ACCESS_TRUCK
, INST_STYLE_ID INST_STYLE_ID
, GEOMETRY GEOMETRY
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "CSF"."CSF_MD_RD_SEGS"