[Home] [Help] [Dependency Information]
Object Name: | CSF_LF_ROADSEGM_PLACES_EU |
---|---|
Object Type: | TABLE |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
DEFINITION
Intersection table required since one Segment can be located in multiple places (e.g. road on admin boundary) and one place contains multiple segments.
EXAMPLE
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000493226C00012$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000493226C00013$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROADSEGM_PLACE_ID | NUMBER | (30) | Yes | Surrogate key used for primary unique identifiers |
PLACE_SIDE | VARCHAR2 | (1) | Specifies side of roadsegment to which Place belongs | |
ROADSEGMENT_ID | NUMBER | (30) | Yes | Permanent identifier for RoadSegment (=GDF3.0 Edge ID) |
PLACE_ID | NUMBER | (30) | Yes | Unique key that identifies the place |
SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode. | ||
ROAD_CENTROID | SDO_GEOMETRY | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ROADSEGM_PLACE_ID
, PLACE_SIDE
, ROADSEGMENT_ID
, PLACE_ID
, SECURITY_GROUP_ID
, ROAD_CENTROID
FROM CSF.CSF_LF_ROADSEGM_PLACES_EU;
|
|
|