IKINOKTA NAVIGATION DATA STANDARTS

IKINOKTA NAVIGATION
DATA STANDARTS
V004-0908
INTRODUCTION
4
I. LAYERS OF TURKEY NAVIGATION DATA SET
5
A.ROAD DESCRIPTION
A.1. ROAD TABLE
A.1.1 DIR_TRAVEL
A.1.2 FUN_CLASS
A.1.3 STR_TYPE
A.1.4 Z_LEVEL
A.1.5 URBAN_LINK
A.1.6 PRIVATE
A.1.7 ROUTE_TYP
A.1.8 UNPAVED
A.1.9 RAMP
A.1.10 THROUGH
A.1.11 FOW
A.1.12 PAVEMENT
A.1.13 TOLL
A.1.14 INTERSECT
A.2. JUNCTION TABLE
A.2.1 TYPE
A.3. USAGE FEE REQUIRED TABLE
A.4. DRIVING RESTRICTION
A.5. FERRY LINES
A.5.1 FERRY_FOR
A.6. RAILWAY
A.6.1 IN_PROCESS
A.6.2 CATEGORY
B.AREA OF INTEREST (AOI) DESCRIPTION
B.1. ADMINISTRATIVE AREAS
B.1.1 RANG_ID
B.1.2 ADM_LEVEL
B.1.3 A_CLASS
B.2. BUILTUP AREA
B.3. GREEN PLACES
B.3.1 CATEGORY
B.4. LAND USE
B.4.1 CATEGORY
B.5. ZIP CODE AREAS
C.POINT OF INTEREST (POI) DESCRIPTION
C.1. POI
C.1.1 CATEGORY
D.TOPOGRAPHY DESCRIPTION
D.1. RIVER (WIDE)
D.2. RIVER
D.2.1 TYPE
D.3. LAKE
5
5
7
7
8
8
8
9
9
9
9
10
10
10
10
11
11
11
11
12
12
12
13
13
13
14
14
14
14
15
15
15
16
16
16
16
17
17
18
23
23
23
23
23
2
DOCUMENT VERSION CONTROL
The information below describes the changes made to this document for each version.
Release Date
15.07.2008
31.07.2008
04.08.2008
18.08.2008
Version
V001-0708
V002-0708
V003-0708
V004-0808
Description
Initial Release
See Version History V002-0708
See Version History V003-0708
See Version History V004-0808
3
INTRODUCTION
This document represents navigation dataset of Ikinokta. This dataset involves the required
structure for navigation as well as some special information like POI, AOI and additional road
tables. Navigational data structures are acquired from IKINOKTA database.
The spatial database consists of organized set of layers in ESRI shapefile format.
SHAPE
Shapefile stores non-topological geometry and attribute information for the spatial features in
a data set. The geometry for a feature is stored as a shape comprising a set of vectors
coordinates. A full specification of shapefiles can be downloaded at the following site:
http://www.esri.com/library/whitepapers/pdfs/shapefile.pdf
• Shapefiles have to be digitized according to WGS 84 DD xx.xxxxxxx. (decimal degrees)
4
I. LAYERS OF TURKEY NAVIGATION DATASET
Name
Name of ESRI/Shape Table Name
1
Road
road_polyline.shp
road
polyline
2
Junction
junction.shp
road
point
3
Usage Fee Required
usage_fee_required.shp
road
polyline
4
Driving Restriction
Drv_rest_none.dbf
road
text
5
Ferry Lines
Ferry_lines.shp
road
polyline
6
Railway
railway.shp
road
polyline
aoi
polygon
7
Administrative Areas Area_polygon.shp
Category
Format
8
Builtup Area
builtup.shp
aoi
polygon
9
Green Places
Green_places_polygon.shp
aoi
polygon
10
Land Use
Land_use_polygon.shp
aoi
polygon
11
Zip Code Areas
zip_code_areas.shp
aoi
polygon
12
POI
poi_point.shp
poi
point
13
River (wide)
River_polygon.shp
topography
polygon
14
River
Rivers_polyline.shp
topography
polyline
15
Lake
Lake_region.shp
topography
polygon
Table 1: Navigation Layers
A. ROAD DESCRIPTION
This set includes routing requirements which are rudimentary for navigation.
A.1.
ROAD TABLE
Layer Names
road_polyline.shp
ID Field Name
2 LINK_ID
3 USERID
Contents
all road types
Data Type
NUMBER (38,8)
NUMBER (38,8)
4
FROM_NODE
NUMBER (38,8)
5
TO_NODE
NUMBER (38,8)
6
7
8
DIR_TRAVEL
FUN_CLASS
LANE_CAT
NVARCHAR2 (1)
NUMBER (38,8)
NUMBER (38,8)
9
DIVIDER
NVARCHAR2 (1)
Object Types
Line
Description
Unique link ID
Unused (can be used for some inner purposes)
Node ID of first point of the link. This ID refers to field
NODE in table JUNCTIONS
Node ID of last point of the link. This ID refers to field
NODE in table JUNCTIONS
Direction of travel through this link. Possible values: T, F,
B, N.
Functional class of this link
Not used
Physical (barrier) or legal (white firm line) divider splitting
opposite sides of road….Has only default value “N” means
that non-divider
5
10 L_AREA
NUMBER (38,8)
11
12
13
14
R_AREA
L_ZIP
R_ZIP
STREET1
NUMBER (38,8)
NUMBER (38,8)
NUMBER (38,8)
NUMBER (38,8)
15
16
17
18
19
20
21
22
STREET2
STREET3
ADDR
LENGTH0
SECONDS
ACCESS_
DISPLAY
MI_PRINX
NUMBER (38,8)
NUMBER (38,8)
NVARCHAR2 (1)
NUMBER (38,8)
NUMBER (38,8)
NVARCHAR2 (1)
NVARCHAR2 (1)
NUMBER (38,8)
23 DIRECTION
24
25
26
27
ROAD_NAME
STR_TYPE
Z_LEVEL
URBAN_LINK
28 PRIVATE
29 ROUTE_INT
30 ROUTE_TYP
31 ROUTE_NAME
32 ROUTE_SUB
33 UNPAVED
34
35
36
37
38
39
EXIT_NO
RAMP
THROUGH
FOW
PAVEMENT
TOLL
40 INTERSECT_
41 L_FMT
42
43
44
45
L_SCHEME
R_SCHEME
R_FMT
FRIGHT
NUMBER (5)
NVARCHAR2
(75)
NUMBER (5)
NUMBER (38,8)
NUMBER (5)
NUMBER (5)
NVARCHAR2
(40)
NUMBER (5)
NVARCHAR2
(254)
NVARCHAR2
(254)
NUMBER (5)
NVARCHAR2
(30)
NUMBER (5)
NUMBER (5)
NUMBER (5)
NUMBER (5)
NUMBER (5)
NUMBER (5)
NVARCHAR2
(50)
NVARCHAR2
(50)
NVARCHAR2 (4)
NVARCHAR2 (1)
INTEGER
Left city ID (reference to field AREA_ID in table
AREA_POLYGON)
Right city ID (reference to field AREA_ID in table
AREA_POLYGON)
Left ZIP code
Right ZIP code
ID of 1st street (reference to field USERID) in table streets
ID of 2nd street (reference to field USERID) in table
streets.
ID of 3th street (reference to field USERID) in table streets.
Reserved for inner use.
Length of link in meters
Travel time in units of 0.1 seconds for this link
Set of other link attributes
Set of other link attributes
Unique ID (Same with LINK ID)
Direction of travel through this link.(same as dir_travel, not
important)
Road (street) name
Road classification
Z-level of road
Urban link means the roads in builtup areas (urban or rural).
Private means if the roads are in private areas (military,
campus, gated community ...etc) or not
International route names. (E70, E5……etc)
Category of route types.
Name of route (motorway like "032" etc; highway Like
"D100" etc and province road like "32-24" etc….)
Name of sub-route (lots roads have sub name like "D10012" or "O32 -18" etc…)
Indicates that the road is of good quality or not.
These exit numbers are used for motorways
Indicates that the road is ramp or not
Recommended ways when passing through cities
Form of way
Indicates that road has pavement or not
Indicates that road is toll way or not
Indicates the intersect type of road if the road has
intersection
Left houses number format. N (numeric) only.
Left houses numbers scheme (ODD OR EVEN)
The same as L_SCHEME
The same as L_FMT
The same as FLEFT
6
46 TRIGHT
47 FLEFT
48 TLEFT
INTEGER
INTEGER
INTEGER
49 BUILTUP ID
NUMBER (38,8)
The same as TLEFT
Number of first left house on this link in direction of link.
Number of last left house on this link in direction of link.
Road that belongs to relevant Builtup area (reference to
field BUILTUP_ID in table BUILTUP)
Table 2: Road table
A.1.1 ID:6 DIR_TRAVEL
Direction of travel through a link.
DIR TRAVEL ON ROAD TABLE
Code
Data Description
Travel direction coincides with order of points in
F
the link
B
Link is bidirectional
N
Link is not road for cars
Table 2.1. Structure of Field DIR_TRAVEL
A.1.2 ID:7 FUN_CLASS
Functional class of a link.
FUN CLASS ON ROAD TABLE
Code Data Description
1
Motorway
2
Highway
3
Avenue/main street
4
Street
Village road, touristic road (village roads are only in Istanbul and
5
some other cities.)
Table 2.2. Structure of Field FUN_CLASS
7
A.1.3 ID:25 STR_TYPE
Road classification.
STR_TYPE
Code
Data Description TR
1
Otoyol
2
Devlet Yolu
3
İl Yolu
4
Köy Yolu
5
Orman Yolu
6
Bulvar
7
Cadde
8
Sokak
9
Çıkmaz Sokak
10
Siteiçi Yol
11
Kavsak(Otoyol)
12
Kavsak(Devlet Yolu)
13
Kavsak(İl Yolu)
16
Kavsak(Bulvar)
17
Kavsak(Cadde)
18
Kavsak(Sokak)
Data Description ENG
Motorway
State Road
Province Road
Village Road
Forest Road
Boulevard
Avenue
Street
Dead End Street
Site Road
Junction (Motorway)
Junction (State Road)
Junction (Province Road)
Junction (Boulevard)
Junction (Avenue)
Junction (Street)
Table 2.3. Structure of Field STR_TYPE
A.1.4 ID: 26 Z_LEVEL
Z-level of road.
Z_LEVEL ON ROAD TABLE
Code
Data Description
-2
Two level below another road
-1
One level below another road
0
Default value
1
One level above another road
2
Two level above another road
Table 2.4. Structure of Field Z_LEVEL
A.1.5 ID: 27 URBAN_LINK
Urban link means the roads in builtup areas (urban or rural).
URBAN_LINK ON ROAD TABLE
Code
Data Description
1
Road is in urban area
0
Road is not in urban area
Table 2.5. Structure of Field URBAN_LINK
8
A.1.6 ID: 28 PRIVATE
Private means if the roads are in private areas (military, campus, gated community ...etc) or
not.
PRIVATE ON ROAD TABLE
Code
Data Description
1
Road is in private area
0
Road is not in private area
Table 2.6. Structure of Field PRIVATE
A.1.7 ID: 30 ROUTE_TYP
Category of route types.
ROUTE_TYP ON ROAD TABLE
Code Data Description
1
All motorways
Primary roads - international route number (like E-70) and some major
2
highways
3
Secondary roads - route number (like D020)
4
Tertiary roads- route number (like 32-21 etc)
NOTE: if a road has Int. Route and motorway name..it is in route type 1
Table 2.7. Structure of Field ROUTE_TYP
A.1.8 ID: 33 UNPAVED
Indicates that the road is of good quality or not.
UNPAVED ON ROAD TABLE
Code
Data Description
1
Unpaved road
0
Paved road ( quality road- asphalt)
Table 2.8. Structure of Field UNPAVED
A.1.9 ID: 35 RAMP
Indicates that the road is ramp or not.
RAMP ON ROAD TABLE
Code
Data Description
1
Ramp
0
Not ramp
Table 2.9. Structure of Field RAMP
9
A.1.10 ID: 36 THROUGH
Recommended ways when passing through cities.
THROUGH ON ROAD TABLE
Code
Data Description
1
Road passing through cities
0
Roads not passing through cities
Table 2.10. Structure of Field THROUGH
A.1.11 ID: 37 FOW
The form of way.
FOW ON ROAD TABLE
Code
Data Description
0
Single Carriageway
1
Motorway
Multiple carriageway (except
motorway)
2
3
Roundabout
4
Slip Road
5
Service Road
6
Entrance to or exit to service area
Table 2.11. Structure of Field FOW
A.1.12 ID: 38 PAVEMENT
Indicates that road has pavement or not.
PAVEMENT ON ROAD TABLE
Code
Data Description
1
Road has pavement
0
Road doesn’t have pavement
Table 2.12. Structure of Field PAVEMENT
A.1.13 ID: 39 TOLL
Indicates that road is toll way or not.
TOLL ON ROAD TABLE
Code
Data Description
1
Toll road
0
Untoll road (default value)
Table 2.13. Structure of Field TOLL
10
A.1.14 ID: 40 INTERSECT
Indicates the intersect type of road if the road has intersection.
INTERSECT ON ROAD TABLE
Code
Data Description
0
No crossing or unknown (all other roads)
1
Freeway intersection
2
Roundabout (Same as "3" on FOW)
3
Crossing
Table 2.14. Structure of Field INTERSECT
A.2. JUNCTION TABLE
Layer Names
junction .shp
ID Field Name
2 NODE
3
4
5
Z
ALIGN
TYPE
Contents
all junctions
Data Type
NUMBER (14)
Object Types
point
Description
Unique JUNCTION/NODE ID
Junction above another junction
NVARCHAR2 (23) has a z- level of 1
NVARCHAR2 (1) Unused
NUMBER (4)
Junction Type
Table 3: Junction table
A.2.1 ID: 5 TYPE
Junction types.
TYPE ON JUNCTION TABLE
Code
Data Description
0
Other junctions
1
Mini-roundabout
2
Bifurcation
3
Railway crossing
Table 3.1. Structure of Field TYPE
A.3. USAGE FEE REQUIRED TABLE
This table has the same table structure with road table. In Turkey, usage fee required roads are
two Bosphorus bridges.
Layer Names
Contents
usage_fee_required.shp Usage fee req.
Object Types
Polyline
Table 4: Usage Fee Required Table
11
A.4. DRIVING RESTRICTION
Layer Names
Drv_rest_none.dbf
ID Field Name
2
JUNCTION
3
F_EDGE
4
T_EDGE
Contents
Driving
restriction
Data Type
Object Types
text
Description
a restriction belongs to which
NODE/JUNCTION. (reference to field
NUMBER (14) NODE_ID in table JUNCTION)
NUMBER
starting edge for restriction (reference to field
(38,8)
LINK_ID in table ROAD)
NUMBER
finish edge for restriction (reference to field
(38,8)
LINK_ID in table ROAD)
Table 5: Driving Restriction table
A.5. FERRY LINES
ID
Layer Names
Ferry_lines.shp
Field Name
1
MI_PRINX
2
3
LINE_NAME
FERRY_FOR
4
FROM_AREA
5
TO_AREA
Contents
Ferry lines
Data Type
NUMBER
(38,8)
NVARCHAR2
(75)
INTEGER
Object Types
line
Description
unused id
name of a line
which car carrying
Area id of departing area (reference to field
NUMBER (18) AREA_ID in table AREA_POLYGON)
Area id of arriving area (reference to field
NUMBER (18) AREA_ID in table AREA_POLYGON)
Table 6: Ferry Lines table
A.5.1 ID: 3 FERRY_FOR
Indicates that the ferry is carrying vehicle or train.
FERRY_FOR ON FERRY LINE TABLE
Code
Data Description
0
Carrying Vehicle
1
Carrying Train
Table6 .1.: Structure of Field FERRY_FOR
12
A.6. RAILWAY
Layer Names
railway.shp
ID Field Name
1
2
3
MI_PRINX
IN_PROCESS
STATE_ID
4
AREA_ID
5
6
ROAD_NAME
CATEGORY
Contents
railways
Data Type
NUMBER
(38,8)
NUMBER (4)
NUMBER (4)
Object Types
line
Description
unused Unique id
construction or not
province traffic licence plate code
railway in where area (reference to field
NUMBER (18) AREA_ID in table AREA_POLYGON)
NVARCHAR2
(75)
railway line name
INTEGER
railway category
Table 7: Railway table
A.6.1 ID:2 IN_PROCESS
Indicates that the railway is under construction or not.
IN_PROCESS ON RAILWAY TABLE
Code
Data Description
0
using line
1
under construction line
Table 7.1. Structure of Field IN_PROCESS
A.6.2 ID:6 CATEGORY
Railway category.
CATEGORY ON RAILWAY TABLE
Code
Data Description
1
Aerial tramway
2
Funicular
3
Light rail
4
Railway
5
Subway
6
Tramway
Table 7.2. Structure of Field CATEGORY
13
B. AREA OF INTEREST (AOI) DESCRIPTION
This set includes administrative boundaries as well as urban land use and green places.
B.1. ADMINISTRATIVE AREAS
Administrative areas (area_polygon table) have all the following layers in the same table.
Layer Names
Contents
Object Types
administrative
Area_polygon.shp areas
area
ID Field Name
Data Type
Description
1 AREA_ID
NUMBER (18)
Unique ID for city (Area)
2 RANG_ID
NUMBER (13)
Rang of the area
NVARCHAR2
3 CITYNAME
(254)
name of administrative area
4 COUNTRY_ID
NUMBER (18)
country code Turkey : "90" (default value)
5 STATE_ID
NUMBER (18)
province traffic licence plate code
6 PARENT
NUMBER (18)
Reference to Area_ID of parent area.
7 ADM_LEVEL
NUMBER (9)
Level of area
8 LANG_CODE
NVARCHAR2 (3) Language code for CITYNAME "TR" is default value
9 COUNTY_ID
NUMBER (30,15) unused - county id
10 ZIP_CODE
NUMBER (18)
zip code of a administrative areas
11 A_CLASS
NUMBER (5)
classification of base admin. Area
NVARCHAR2
Turkish official code for base admin area.
12 OFF_CODE
(254)
http://www.tuik.gov.tr
Table 8: Administrative areas (area_polygon table)
B.1.1 ID:2 RANG_ID
Indicates that the boundaries of 14 major cities of Turkey.
RANG_ID ON AREA_POLYGON TABLE
Code
Data Description
0
All other cities
1
Major provinces in Turkey (14 province)
2
Ankara (province capital city of Turkey)
Table 8.1. Structure of Field RANG_ID
B.1.2 ID:7 ADM_LEVEL
Indicates the administrative levels.
ADM_LEVEL ON AREA_POLYGON TABLE
Code
Data Description
1
Country (all TURKEY)
3
Province (# 81) in turkish called as "il"
4
County in Turkish called as "ilçe"
8
Others (village, sub-district, neighborhood)
Table 8.2. Structure of Field ADM_LEVEL
14
B.1.3 ID:11 A_CLASS
Indicates the classification of base administrative areas.
A_CLASS ON AREA_POLYGON TABLE
Code Data Description
0
Country, provinces and counties
1
Neighborhood in turkish called as "mahalle"
2
Sub-district in turkish called as "belde"
3
Sub-district in turkish called as "bucak"
4
Village in turkish called as "köy"
5
Other base administrative areas
Table 8.3. Structure of Field A_CLASS
B.2. BUILTUP AREA
This table designates builtup area. All urban areas and village centers are builtup areas.
Layer Names
builtup.shp
ID Field Name
1 NOKTA_ID
Contents
builtup areas
Data Type
NUMBER (38,8)
Object Types
area
Description
Unused unique id
Reference to Builtup area of parent area.(reference to field
2 PARENT
NUMBER (38,8) AREA_ID in table AREA_POLYGON)
3 STATE_ID
NUMBER (4)
Province traffic licence plate code
For parent area. Same with Table 8.2. Structure of Field
ADM_LEVEL
4 ADM_LEVEL NUMBER (4)
For parent area. same with Table 8.3. Structure of Field
A_CLASS
5 A_CLASS
NUMBER (4)
NVARCHAR2
6 NAME
(50)
Builtup area name
7 BUILTUP_ID NUMBER (38,8) Unique builtup area ID
Table 9: Builtup Area
B.3. GREEN PLACES
This table designates urban green areas.
Layer Names
Contents
Green_places_polygon.shp Green places
ID Field Name
Data Type
1
2
3
4
PARENT
STATE_ID
NAME
CATEGORY
Table 10: Green Places
Object Types
area
Description
The AREA_ID where the green place is located in
(reference to field AREA_ID in table
NUMBER (9)
AREA_POLYGON)
NUMBER (38,8) Province traffic licence plate code
NVARCHAR2
(150)
Name of green places.
INTEGER
Category of green places.
15
B.3.1 ID:4 CATEGORY
This table designates categories of green places.
CATEGORY ON GREEN PLACES POLYGON TABLE
Code
Data Description
CATEGORY ENGLISH
1
Park (city&county)
2
Park (state)
3
Woodland
CATEGORY TR
Park
Milli Park
Ağaçlık
Table 10.1. Structure of Field CATEGORY
B.4. LAND USE
Layer Names Contents
Land_use.shp land uses
ID Field Name
Data Type
1
2
3
4
PARENT
STATE_ID
NAME
CATEGORY
Table 11: Land Use
Object Types
area
Description
The AREA_ID where the land use is located in (reference to field
AREA_ID in table AREA_POLYGON)
NUMBER (9)
NUMBER (38,8) province traffic licence plate code
NVARCHAR2
(150)
Name of land use
INTEGER
Category of land use
B.4.1 ID:4 CATEGORY
This table designates categories of land uses.
CATEGORY ON LAND USE TABLE
Code
Data Description
CATEGORY ENGLISH
1
Airport
2
Cemetery
3
Harbour
4
Industrial complex
5
Market place (bazaar)
6
Military airport
7
Military base
8
Shipyard
9
Shopping center
10
University & College
CATEGORY TR
Havaalanı
Mezarlık
Liman
Sanayi Sitesi
Pazar
Askeri Havaalanı
Askeriye
Tersane
Alışveriş Merkezi
Üniversite
Table 11.1. Structure of Field CATEGORY
16
B.5. ZIP CODE AREAS
Layer Names
Contents
zipcode_areas.shp zip code areas
ID Field Name
Data Type
1 TRAF_CODE
NUMBER (38,8)
2 PROVINCE
NVARCHAR2 (50)
3 COUNTY
NVARCHAR2 (50)
4 ZIP_CODE
INTEGER
Table 12: Zip Code Areas
Object Types
area
Description
Province traffic licence plate code
Belongs to which province
Belongs to which county
Zip code
C. POINT OF INTEREST (POI) DESCRIPTION
This set includes the required points for navigation and more contents.
C.1. POI
Layer Names Contents
poi_point.shp point of interest
ID Field Name
Data Type
1
2
AREA_ID
NUMBER (38,8)
CATEGORY INTEGER
3
LINK_ID
5
6
7
INTEGER
NVARCHAR2
(100)
NAME
NVARCHAR2
ADDRESS
(150)
POI_PHONE NVARCHAR2 (23)
IKINKTA_ID NUMBER (38,8)
8
CHAIN
4
NUMBER (38,8)
9
BUILTUP_ID NUMBER (38,8)
NVARCHAR2
10 NAME_ENG (100)
11 STATE_ID
NUMBER (38,8)
Object Types
point
Description
POI that belongs to relevant administrative area.
(reference to field AREA_ID in table AREA_POLYGON)
POI category
The link which the POI is located on
(reference to field LINK_ID in table ROAD_POLYLINE)
Name of POI
Address of POI
Phone of POI
Unused unique ID
Information about POI whether it is franchising/chain
or not (burger king..etc)
“1” is chain, “0” is not chain
POI that belongs to relevant builtup area
(reference to field BUILTUP_ID in table BUILTUP)
Name of poi english ( Kadıköy primary school..etc)
Province traffic licence plate code
Table 13: Point of Interest (POI)
17
C.1.1 ID:2 CATEGORY
CATEGORY ON POI_POINT TABLE
Code
Data Description
CATEGORIES
NAME TR
NAME ENGLISH
MAIN CODE
2001
2003
2004
2005
2006
2007
2008
2009
2010
2011
3001
3002
3003
3005
3006
3007
3008
3009
3010
3012
3014
3015
3016
3017
3018
3019
5040
5041
5042
6032
6033
6034
6035
6036
6037
7020
7021
7022
7023
11040
11044
11045
Vergi Dairesi
Muhtarlık
Belediye
Konsolosluk
Diğer Resmi Kurum
Polis
Postane
İtfaiye
Kütüphane
Adliye
Sinema
Tiyatro Ve Gösteri Merkezi
Müze
Anıt
Tarihi Mekan
Kültür Ve Eğlence Merkezi
Milli Park
Mağara
Şelale
Göl
Park
Plaj
Piknik Alanı
Spor
Sıcak Su Dinlenme
Diğer Eğlence
Yahudi Mezarlığı
Müslüman Mezarlığı
Hrıstiyan Mezarlığı
5 Yıldızlı Otel
4 Yıldızlı Otel
3 Yıldız Ve Altı Otel
Tatil Köyü
Pansiyon
Konaklama Tesisi
Sinagog
Kilise
Cami
Diğer Dini Mekan
Otobüs Terminali
Liman
Vapur İskelesi
Tax Administration
Mukhtar's Office
Municipality
Consulate
Other Official Institution
The Police Department
Post Office
Fire Department
Library
Courthouse
Cinema
Theatre
Museum
Monument
Historical Place
Entertainment And Cultural
National Park
Cave
Waterfall
Lake
Park
Beach
Picnic Area
Sport
Thermal Water
Other Entertainment
Jewish Cemetery
Muslim Cemetery
Christian Cemetery
5 Star Hotel
4 Star Hotel
3 Star And Below Stars Hotels
Holiday Village
Pension
Resting
Synagogue
Church
Mosque
Other Religious Place
Bus Terminal
Harbour / Marina
Ferry Pier
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
5
5
5
6
6
6
6
6
6
7
7
7
7
11
11
11
18
11046
11047
11050
11051
11054
11055
11056
11057
17001
17002
17003
17004
17005
17006
17007
21001
21002
21003
21004
21005
21006
21009
21010
21011
21012
21013
21014
21015
21016
21017
21018
21019
21020
21021
21022
21023
21024
21025
23027
23028
23029
23030
23031
26156
26157
26158
26159
26160
Deniz Otobüsü İskelesi
Motor İskelesi
Tren İstasyonu
Havaalanı
Köprü
Tünel
Geçit
Otopark
Hastane
Poliklinik
Dispanser
Sağlık Ocağı
Diş Hekimi
Doktor
Eczane
PO
BP
Opet
Unıted
Shell
Akpet
Alpet
Moıl
Petlıne
Total
Erk
Sunpet
Lukoıl
Turkuaz
Soıl
Starpet
Tabaş
Tuta
Yuropet
Mobıl
Elf
Habaş
Diğer Akaryakıt
Alışveriş Merkezi
Market
İş Merkezi
Han
Çarşı
Anaokulu
İlköğretım
Lise
Üniversite
Diğer Okul
Seabus Terminal
Boat Pier
Train Station
Airport
Bridge
Tunnel
Gate
Parking
Hospital
Policlinic
Dispensary
Medical Service
Dentist
Doctor
Pharmacy
PO
BP
Opet
United
Shell
Akpet
Alpet
Moil
Petline
Total
Erk
Sunpet
Lukoil
Turkuaz
Soil
Starpet
Tabas
Tuta
Yuropet
Mobil
Elf
Habas
Other Gas Station
Mall
Market
Business Center
Commercial Building
Bazaar
Nursery
Primary
High school
University
Other School
11
11
11
11
11
11
11
11
17
17
17
17
17
17
17
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
21
23
23
23
23
23
26
26
26
26
26
19
28153
28154
28156
28157
28162
28163
28164
28165
28167
28168
28169
28170
28171
28172
28173
28174
28175
28176
28177
30001
30002
31001
31002
31003
31004
31005
31006
31007
31008
31009
31010
31011
31012
31013
31014
31015
32001
33001
40003
50001
50002
50003
50004
50005
50006
50007
50008
50009
İş Bankası
Garanti Bankası
Hsbc
Yapı Ve Kredi Bankası
Ziraat Bankası
Halk Bankası
Akbank
Ing Bank
Fınansbank
Fortis
Teb
Anadolubank
Cıtıbank
Denızbank
Mılenıum Bank
Tekfen Bank
Vakıfbank
Şekerbank
Diğer Banka
Lokanta
Lüks Lokanta
Pızza Hut
Kfc
Fastfood
Burger Kıng
Mc Donalds
Donut
Dunkın Donuts
Domınos Pızza
Pizza
Pızza Day's
Pızza Max
Sıcıly's
Arby's
Lıttle Ceasars
Pastane / Cafe
Bar
Büfe
Sanayi Sitesi
İdaş
İpek
İstikbal
Kelebek
Kilim
Mobilya
Çilek
Alfemo
Bellona
Is Bank
Garanti Bank
Hsbc
Yapi Ve Kredi Bank
Ziraat Bank
Halk Bank
Akbank
Ing Bank
Finansbank
Fortis
Teb
Anadolubank
Citibank
Denizbank
Milenium Bank
Tekfen Bank
Vakifbank
Sekerbank
Other Bank
Restaurant
Luxus Restaurant
Pizza Hut
Kfc
Fastfood
Burger King
Mc Donalds
Donut
Dunkin Donuts
Dominos Pizza
Pizza
Pizza Day's
Pizza Max
Sicily's
Arby's
Little Ceasars
Bakery / Cafe
Bar
Buffet
Industry Site
Idas
Ipek
Istikbal
Kelebek
Kilim
Furniture
Cilek
Alfemo
Bellona
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
28
30
30
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
32
33
40
50
50
50
50
50
50
50
50
50
20
50010
50011
60001
60002
60003
60004
70001
70002
70003
70004
80001
80002
80003
80004
80005
80006
80007
80008
80009
80010
80011
80012
80013
80014
80015
80016
80017
80018
80019
80020
80021
80022
80023
80024
80025
80026
80027
80028
80029
80030
80031
80032
80033
80034
80035
80036
80037
80038
Tepe Mobilya
Yataş
Avea
Vodafone
Turkcell
Cep Shop
Avukatlık Bürosu
Noter
Mimarlık
Emlak
Alfa Romeo
Askam
Audı
Bisan
Bmc
Bmw
Chevrolet
Chrysler
Cıtroen
Dacıa
Daewoo
Daf
Daıhatsu
Fıat
Ford
Honda
Hyundaı
Isuzu
Iveco
Jeep
Karsan
Kıa
Lada
Land Rover
Man
Mazda
Mercedes
Mını Cooper
Mıtsubıshı
Nıssan
Otokar
Peugeot
Saab
Scanıa
Seat
Skoda
Subaru
Suzukı
Tepe Mobilya
Yatas
Avea
Vodafone
Turkcell
Gsm Mobile Shop
Lawyer Service
Notary
Architecture
Real Estate
Alfa Romeo
Askam
Audi
Bisan
Bmc
Bmw
Chevrolet
Chrysler
Citroen
Dacia
Daewoo
Daf
Daihatsu
Fiat
Ford
Honda
Hyundai
Isuzu
Iveco
Jeep
Karsan
Kia
Lada
Land Rover
Man
Mazda
Mercedes
Mini Cooper
Mitsubishi
Nissan
Otokar
Peugeot
Saab
Scania
Seat
Skoda
Subaru
Suzuki
50
50
60
60
60
60
70
70
70
70
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
21
80039
80040
80041
80042
80043
80044
80045
80046
80047
80048
90001
100001
100002
100003
100004
100005
100006
100007
Tata
Toyota
Volkswagen
Volvo
Dodge
Bırmot
Opel
Araç Kiralama
Lastikçi
Renault
Elektronik
Çiçekçi
Hediyelik Eşya
İç Dekorasyon
Fıtness Merkezi
Tenis Klubü
Yüzme Havuzu
Yarış Pisti
Tata
Toyota
Volkswagen
Volvo
Dodge
Birmot
Opel
Rent A Car
Tyres Shop
Renault
Electronic
Florist
Gift Shop
Inner Decoration
Fitness Center
Tennis Club
Swimming Pool
Race Track
80
80
80
80
80
80
80
80
80
80
90
100
100
100
100
100
100
100
Table 13.1. Structure of Field CATEGORY
MAIN CODE ON CATEGORIES TABLE ON POI_POINT TABLE
Code
Data Description
MAIN
CODE
MAIN CATEGORIES TR
MAIN CATEGORIES ENGLISH
2
Resmi Kurum
Official Institution
3
Eğlence Ve Kültür
Entertainment And Cultural
5
Mezarlık
Cemetery
6
Otel
Hotel
7
Dini Kurum
Religious
11
Ulaşım
Transportation
17
Sağlık Hizmeti
Health Service
21
Akaryakıt
Gas Station
23
Alışveriş
Shopping
26
Okul
School
28
Banka
Bank
30
Yeme İçme Hizmeti
Restaurant
31
Fastfood
Fast food
32
Bar
Bar
33
Büfe
Buffet
40
Yerleşim Yeri
Settlement
50
Mobilya
Furniture
60
Gsm Hizmeti
Gsm Mobile Shop
70
Danışmanlık Proje Hizmeti
Consultancy Project Service
80
Otomotiv
Automotive
90
Elektronik
Electronic
100
İlgi Alanları
Interests
Table 13.1.a Structure of Field MAIN CODE
22
D. TOPOGRAPHY DESCRIPTION
This set includes topographical requirements.
D.1. RIVER (WIDE)
This layer designates wide river beds. This table doesn’t include any content for navigation
set. All river contents are kept in the other River table (polyline)
ID
1
Layer Names
River_polygon.shp
Field Name
RIVER_ID
Contents
wide river beds
Data Type
NUMBER (17)
Object Types
area
Description
Unused unique id for navigation
Table 14: River polygon table
D.2. RIVER
ID
1
2
3
4
Layer Names
Rivers_polyline.shp
Field Name
NAME
TYPE
NAME0
MI_PRINX
Contents
river lines
Data Type
NVARCHAR2 (80)
NUMBER (18,15)
NVARCHAR2 (50)
NVARCHAR2 (254)
Object Types
line
Description
Name of rivers (TR)
Categories of rivers
Name of rivers (ENG)
unused unique id for nav
Table 15: River polyline table
D.2.1 ID:2 TYPE
CATEGORY ON LAND USE TABLE
Code
Data Description
TYPE TR
TYPE ENG
1
Nehir
River
2
Çay
Brook creek
3
Dere
Creek
4
Kanal
Canal
5
Baraj yatağı
Dam Course
Table 15.1.: Structure of Field TYPE
D.3. LAKE
ID
1
Layer Names
Lake_region.shp
Field Name
NAME
Contents
lakes
Data Type
NVARCHAR2 (80)
2
MI_PRINX
NUMBER (13)
Object Types
area
Description
Name of a lake
Unused unique id for
navigation
Table 16:. Lake table
23
APPENDIX 1: TABLE RELATIONSHIPS
junction.shp
NODE
Drv_rest_none.dbf
JUNCTION
F_EDGE
T_EDGE
road_polyline.shp
LINK_ID
L_AREA
R_AREA
BUILTUP_ID
FROM_NODE
TO_NODE
Area_polygon.shp
AREA_ID
PARENT
poi_point.shp
LINK_ID
AREA_ID
BUILTUP_ID
Green_places_polygon.shp
PARENT
Land_use.shp
PARENT
builtup.shp
BUILTUP_ID
Railway.shp
AREA_ID
Ferry_lines.shp
FROM_AREA
TO_AREA
24
APPENDIX 2: VERSION HISTORY
Version
V002-0708
V002-0708
V003-0708
V003-0708
V004-0808
Date
31.07.2008
31.07.2008
04.08.2008
04.08.2008
18.08.2008
Page # Description
Update Index
19 Poi category "28165" changed
17 Poi category "2007" added
17 Poi category "11044" changed
7-5 STR_TYPE field structure was changed
25