[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CSF_TDS_SEGMENTS_WM |
|---|---|
| Object Type: | TABLE |
| Owner: | CSF |
| Subobject Name: | |
| Status: | VALID |
DEFINITION
A TDS SEGMENT defines a connection between two nodes.
EXAMPLE
MISCELLANEOUS
A segment is the smallest entity representing a road. A road is made up of several segments.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SEGMENT_ID | NUMBER | (30) | Yes | Generic unique identifier for an entity |
| FUNCTIONAL_CLASS | NUMBER | (1) | Yes | The FUNCTIONAL CLASS defines the importance level of the road for routing. |
| LENGTH | NUMBER | Yes | The LENGTH defines the length of the segment in meters. | |
| LANE_CATEGORY | NUMBER | (1) | The LANE CATEGORY defines the number of lanes available in the segment. | |
| ONEWAY_DIRECTION | NUMBER | (1) | Yes | The ONEWAY DIRECTION defines the allowed direction of the traffic flow. |
| ROAD_CONDITION | NUMBER | (1) | The ROAD CONDITION defines if a road is paved or not. | |
| SPECIAL_RESTRICTIONS | NUMBER | (1) | The SPECIAL RESTRICTIONS defines if a segment is publicly accessible. | |
| TIME_ZONE | NUMBER | The TIME ZONE defines the GMT offset of the segment. | ||
| BRUNNEL_TYPE | NUMBER | (1) | The BRUNNEL TYPE defines if the segment is either a bridge of a tunnel. | |
| AVERAGE_SPEED | NUMBER | (3) | The AVERAGE SPEED defines the legal speed limit for a roadsegment in kilometers per hours. | |
| BIN_INDEX | NUMBER | Used to generate an index for Segments in the Binary file | ||
| TOLL_ROAD | NUMBER | (1) | Yes | The TOLL ROAD defines if the segment is or is part of a toll road. |
| FERRY_TYPE | NUMBER | (1) | The FERRY TYPE defines the type of transport of the ferry. | |
| DIVIDED_ROAD_ELEMENT | NUMBER | (1) | Yes | The DIVIDED ROAD ELEMENT defines if the segment is divided in terms of accessiblity. |
| DIVIDER_TYPE | NUMBER | (1) | The DIVIDER TYPE determines if the segment/road divider is either a legal or hysical barrier. | |
| ACCESS_CARS | VARCHAR2 | (3) | Specifies if a road is accessible by regular passenger cars. | |
| ACCESS_BUS | VARCHAR2 | (3) | Specifies if a roadsegment is accessible by Public Buses. | |
| ACCESS_TAXI | VARCHAR2 | (3) | Specifies if a roadsegment is accessible by Taxis. | |
| ACCESS_DELIVERY | VARCHAR2 | (3) | Specifies if a roadsegment is accessible by (small) Delivery Trucks. | |
| ACCESS_TRUCK | VARCHAR2 | (3) | Specifies if a roadsegment is accessible by larger Trucks. | |
| ACCESS_EMERGENCY | VARCHAR2 | (3) | Specifies is a roadsegment is accessible by Emergency Vehicles. | |
| ACCESS_PEDESTRIAN | VARCHAR2 | (3) | Specifies if the roadsegment is accessible by Pedestrians. | |
| ACCESS_BICYCLE | VARCHAR2 | (3) | Specifies is a roadsemgment is accessible by Bicycles. | |
| ACCESS_CARPOOL | VARCHAR2 | (3) | Specifies if a roadsegment is accessible by High Occupancy Vehicles (i.e. passenger cars where a certain minimum number of passengers is required). | |
| ACCESS_THROUGH_TRAFFIC | VARCHAR2 | (3) | The THROUGH TRAFFIC defines if the segment can be used for ongoing traffic. THROUGH TRAFFIC = N means that the road is only accessible for local resident that live in this area, and can not be used for transit traffic. | |
| TILE_ID | NUMBER | (30) | The TILE ID defines the unique identifier of the entity. | |
| INTERVAL_ID | NUMBER | (30) | Unique identifier for the Interval entity | |
| SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode. |
Cut, paste (and edit) the following text to query this object:
SELECT SEGMENT_ID
, FUNCTIONAL_CLASS
, LENGTH
, LANE_CATEGORY
, ONEWAY_DIRECTION
, ROAD_CONDITION
, SPECIAL_RESTRICTIONS
, TIME_ZONE
, BRUNNEL_TYPE
, AVERAGE_SPEED
, BIN_INDEX
, TOLL_ROAD
, FERRY_TYPE
, DIVIDED_ROAD_ELEMENT
, DIVIDER_TYPE
, ACCESS_CARS
, ACCESS_BUS
, ACCESS_TAXI
, ACCESS_DELIVERY
, ACCESS_TRUCK
, ACCESS_EMERGENCY
, ACCESS_PEDESTRIAN
, ACCESS_BICYCLE
, ACCESS_CARPOOL
, ACCESS_THROUGH_TRAFFIC
, TILE_ID
, INTERVAL_ID
, SECURITY_GROUP_ID
FROM CSF.CSF_TDS_SEGMENTS_WM;
CSF.CSF_TDS_SEGMENTS_WM does not reference any database object
CSF.CSF_TDS_SEGMENTS_WM is referenced by following:
CSF
CSF_TDS_SEGMENTS_WM#
|
|
|
|