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


TABLE: CSF.CSF_LF_POIS_NA

Object Details
Object Name: CSF_LF_POIS_NA
Object Type: TABLE
Owner: CSF
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_TX_DATA
PCT Free: 10
PCT Used:
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
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
,      SECURITY_GROUP_ID
FROM CSF.CSF_LF_POIS_NA;

Dependencies

[top of page]

CSF.CSF_LF_POIS_NA does not reference any database object

CSF.CSF_LF_POIS_NA is referenced by following:

SchemaAPPS
SynonymCSF_LF_POIS_NA