IKINOKTA NAVIGATION DATA STANDARTS
Transkript
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