[Home] [Help] [Dependency Information]
Object Name: | CSF_TDS_CONDITIONS_AU |
---|---|
Object Type: | TABLE |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
DEFINITION
A Condition defines a specific restriction that applies to a road segment or to a combination of road segments. It can include Vehicles type for which the condition applies and time contraints for a condition.
EXAMPLE
Turn Restriction, access limited by a Gate, temporary change in Oneway information, Construction on a road during certain period of time.
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONDITION_ID | NUMBER | (30) | Yes | Unique identifier for Condition Table |
ACCESS_BUS | VARCHAR2 | (3) | Yes | does condition apply to public buses? |
ACCESS_BICYCLE | VARCHAR2 | (3) | Yes | does condition apply to bicycles? |
ACCESS_CARS | VARCHAR2 | (3) | Yes | does condition apply to passenger cars? |
ACCESS_TAXI | VARCHAR2 | (3) | Yes | does condition apply to taxis? |
ACCESS_CARPOOL | VARCHAR2 | (3) | Yes | does condition apply to carpool cars? |
ACCESS_DELIVERY | VARCHAR2 | (3) | Yes | does condition apply to delivery trucks? |
ACCESS_TRUCK | VARCHAR2 | (3) | Yes | does condition apply to trucks? |
ACCESS_EMERGENCY | VARCHAR2 | (3) | Yes | does condition apply to emergency vehicles? |
ACCESS_PEDESTRIAN | VARCHAR2 | (3) | Yes | does condition apply to pedestrians? |
ACCESS_THROUGH_TRAFFIC | VARCHAR2 | (3) | Yes | can segment be used for through traffic? |
BIN_INDEX | NUMBER | used to generate segment index for binary TDS file | ||
CONDITION_TYPE | NUMBER | (1) | Yes | Defines the type of Conditions |
NR_SEGMENT_INVOLVED | NUMBER | (2) | Yes | specifies how many roadsegment are involved in the condition |
CONSTRUCTION_STATUS | NUMBER | (1) | specifies the type of construction (open or closed) | |
DIRECTION_OF_TRAFFIC | NUMBER | (1) | specifies the oneway information for a segment | |
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 CONDITION_ID
, ACCESS_BUS
, ACCESS_BICYCLE
, ACCESS_CARS
, ACCESS_TAXI
, ACCESS_CARPOOL
, ACCESS_DELIVERY
, ACCESS_TRUCK
, ACCESS_EMERGENCY
, ACCESS_PEDESTRIAN
, ACCESS_THROUGH_TRAFFIC
, BIN_INDEX
, CONDITION_TYPE
, NR_SEGMENT_INVOLVED
, CONSTRUCTION_STATUS
, DIRECTION_OF_TRAFFIC
, INTERVAL_ID
, SECURITY_GROUP_ID
FROM CSF.CSF_TDS_CONDITIONS_AU;
CSF.CSF_TDS_CONDITIONS_AU does not reference any database object
CSF.CSF_TDS_CONDITIONS_AU is referenced by following:
|
|
|