[Home] [Help] [Dependency Information]
Object Name: | CSF_LF_POIS_EU |
---|---|
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000493176C00018$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000493176C00019$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
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. | ||
POI_POINT | SDO_GEOMETRY | (1) |
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
, POI_POINT
FROM CSF.CSF_LF_POIS_EU;
|
|
|