[Home] [Help] [Dependency Information]
Object Name: | CSF_MD_RD_SEGS |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_MD_RD_SEGS |
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
Tablespace: | APPS_TS_MEDIA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000083040C00028$$ | LOB | UNIQUE | APPS_TS_MEDIA | |
SYS_IL0000083040C00029$$ | LOB | UNIQUE | APPS_TS_MEDIA |
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 |
GEOMETRY | SDO_GEOMETRY | (1) | ||
SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode. |
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;
|
|
|