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

TABLE: CSF.CSF_LF_POIS

Object Details
Object Name: CSF_LF_POIS
Object Type: TABLE
Owner: CSF
FND Design Data: TableCSF.CSF_LF_POIS
Subobject Name:
Status: VALID


DEFINITION
Points Of Interest (POI) are single points in the road network database that are typically known by their name, e.g. City Centres, Airports, Hotels.
EXAMPLE
Hotel Mayfair, Luchthaven Schiphol, Tour Eiffel, Buckingham Palace, New Orleans, Tai Chek
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_MEDIA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000082997C00017$$ LOB UNIQUE TablespaceAPPS_TS_MEDIA
SYS_IL0000082997C00018$$ LOB UNIQUE TablespaceAPPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
POI_ID NUMBER (30) Yes Unique identifier for POI Table
FEATURE_CODE NUMBER
Yes Describes type of POI
POI_ADDRESS VARCHAR2 (240)
Full address of the POI (Streetname and HouseNr)
TELEPHONE_NUMBER VARCHAR2 (240)
Phone number of the POI
CHAIN_NAME VARCHAR2 (240)
Chain where the POI is part of
FOOD_TYPE VARCHAR2 (240)
Type of food served in Restau
IMPORTANCE NUMBER
Yes Indication if POI is of National Importance
POPULATION NUMBER

Estimated population for City Centre POI
ROADSEGMENT_ID NUMBER (30) Yes Permanent identifier for RoadSegment (=GDF3.0 Edge ID)
PLACE_ID NUMBER (30) Yes Foreign key to place table
POI_POINT SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT POI_ID
,      FEATURE_CODE
,      POI_ADDRESS
,      TELEPHONE_NUMBER
,      CHAIN_NAME
,      FOOD_TYPE
,      IMPORTANCE
,      POPULATION
,      ROADSEGMENT_ID
,      PLACE_ID
,      POI_POINT
,      SECURITY_GROUP_ID
FROM CSF.CSF_LF_POIS;

Dependencies

[top of page]

CSF.CSF_LF_POIS references the following:

SchemaMDSYS
TYPESDO_GEOMETRY
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
CSF.CSF_LF_POIS is referenced by following:

SchemaCSF
ViewCSF_LF_POIS#