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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CSF.CSF_MD_RD_SEGS_WM

Object Details

Object Name:	CSF_MD_RD_SEGS_WM
Object Type:	TABLE
Owner:	CSF
Subobject Name:
Status:	VALID

DEFINITION
A MD ROAD SEGMENT defines a navigable feature. Elements in the MD ROAD SEGMENT a part of the navigable road network.
EXAMPLE
Some examples of navigable features are: Roads, Ferries, Walkway
MISCELLANEOUS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000493358C00029$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000493358C00030$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
ROAD_SEGMENT_ID	NUMBER	(30)	Yes	The ROAD SEGMENT ID defines the unique identifier for a road segment.
FUNCTIONAL_CLASS	NUMBER		Yes	The FUNCTIONAL CLASS defines the level of importance of the road.
CONSTRUCTION_STATUS	NUMBER			The CONSTRUCTION STATUS determines if a road segment is currently under contruction .
FORM_OF_WAY	NUMBER			The FORM OF WAY determines the physical characteristics of the road segment.
SPEED_CATEGORY	NUMBER			The SPEED CATEGORY defines the legal speed that applies to the road segment.
LANE_CATEGORY	NUMBER			The LANE CATEGORY defines the number of lanes of the road segment.
ONEWAY_DIRECTION	NUMBER		Yes	The ONEWAY DIRECTORY determines in which end the road can be enterred. The direction is specified using the start and end node.
TOLL_ROAD	VARCHAR2	(3)	Yes	The TOLL ROAD defines if toll fee needs to be paid for using the road.
PAVED	VARCHAR2	(3)		The PAVED attribute defines if a road is paved or unpaved.
FEATURE_CODE	NUMBER		Yes	The FEATURE CODE determines the type of road segment. Currently only one type is in use. In a later release this column will determine the aggregation state of a road segment.
FERRY_TYPE	VARCHAR2	(240)		Date and time this occurrence ceases being active for user access
ACCESS_CAR	VARCHAR2	(3)	Yes	The ACCESS CAR determines if the road segment is accessible for cars.
ACCESS_CARPOOL	VARCHAR2	(3)	Yes	The ACCESS CARPOOL determines if the road segment is accessible for carpool vehicles.
ACCESS_DELIVERY	VARCHAR2	(3)	Yes	The ACCESS DELIVERY determines if the road segment is accessible for delivery vehicles.
ACCESS_TAXI	VARCHAR2	(3)	Yes	The ACCESS TAXI determines if the road segment is accessible for taxies.
ACCESS_PEDESTRIAN	VARCHAR2	(3)	Yes	The ACCESS PEDESTRIAN determines if the road segment is accessible for pedestrians.
ACCESS_BUS	VARCHAR2	(3)	Yes	The ACCESS BUS determines if the road segment is accessible for busses.
ACCESS_BICYCLE	VARCHAR2	(3)	Yes	The ACCESS BICYCLE determines if the road segment is accessible for bicycles.
ACCESS_EMERGENCY	VARCHAR2	(3)	Yes	The ACCESS EMERGENCY determines if the road segment is accessible for emergency vehicles.
ACCESS_TRUCK	VARCHAR2	(3)	Yes	The ACCESS TRUCK determines if the road segment is accessible for trucks.
INST_STYLE_ID	NUMBER	(30)	Yes	Generic unique identifier for an entity
SECURITY_GROUP_ID	NUMBER			Identifier used for running in hosted mode.
GEOMETRY	SDO_GEOMETRY	(1)

Query Text

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
,      SECURITY_GROUP_ID
,      GEOMETRY
FROM CSF.CSF_MD_RD_SEGS_WM;

Dependencies

[top of page]

CSF.CSF_MD_RD_SEGS_WM references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY
SYS: STANDARD - show dependent code

CSF.CSF_MD_RD_SEGS_WM is referenced by following:

CSF: CSF_MD_RD_SEGS_WM#