[Home] [Help] [Dependency Information]
Object Name: | CSF_MD_RD_SEGS# |
---|---|
Object Type: | VIEW |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROAD_SEGMENT_ID | NUMBER | (30) | Yes | |
FUNCTIONAL_CLASS | NUMBER | Yes | ||
CONSTRUCTION_STATUS | NUMBER | |||
FORM_OF_WAY | NUMBER | |||
SPEED_CATEGORY | NUMBER | |||
LANE_CATEGORY | NUMBER | |||
ONEWAY_DIRECTION | NUMBER | Yes | ||
TOLL_ROAD | VARCHAR2 | (3) | Yes | |
PAVED | VARCHAR2 | (3) | ||
FEATURE_CODE | NUMBER | Yes | ||
FERRY_TYPE | VARCHAR2 | (240) | ||
ACCESS_CAR | VARCHAR2 | (3) | Yes | |
ACCESS_CARPOOL | VARCHAR2 | (3) | Yes | |
ACCESS_DELIVERY | VARCHAR2 | (3) | Yes | |
ACCESS_TAXI | VARCHAR2 | (3) | Yes | |
ACCESS_PEDESTRIAN | VARCHAR2 | (3) | Yes | |
ACCESS_BUS | VARCHAR2 | (3) | Yes | |
ACCESS_BICYCLE | VARCHAR2 | (3) | Yes | |
ACCESS_EMERGENCY | VARCHAR2 | (3) | Yes | |
ACCESS_TRUCK | VARCHAR2 | (3) | Yes | |
INST_STYLE_ID | NUMBER | (30) | Yes | |
GEOMETRY | SDO_GEOMETRY | (64) | ||
SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROAD_SEGMENT_ID
, FUNCTIONAL_CLASS
, CONSTRUCTION_STATUS
, FORM_OF_WAY
, SPEED_CATEGORY
, LANE_CATEGORY
, ONEWAY_DIRECTION
, TOLL_ROAD
, PAVED
, FEATURE_CODE
, FERRY_TYPE
, ACCESS_CAR
, ACCESS_CARPOOL
, ACCESS_DELIVERY
, ACCESS_TAXI
, ACCESS_PEDESTRIAN
, ACCESS_BUS
, ACCESS_BICYCLE
, ACCESS_EMERGENCY
, ACCESS_TRUCK
, INST_STYLE_ID
, GEOMETRY
, SECURITY_GROUP_ID
FROM CSF.CSF_MD_RD_SEGS#;
|
|
|