r6 - 03 Sep 2009 - 14:33:00 - NattaponKlakhaengYou are here: NTL >  Project Web  > RoadTrafficEstimate > TrafficInformationCenter > WsManual > LocationTable

˹ѧÊ×ÍàªÔ­

8.1 ¤ÇÒÁËÁÒÂáÅзÕèÁÒ

¡ÒÃÍéÒ§ÍÔ§·ÕèµÑé§ (location referencing) à»ç¹¡ÒþÂÒÂÒÁÃкصÓá˹觷Õèʹ㨠â´Â¡ÒÃÍéÒ§ÍÔ§¨Ò¡·ÕèµÑé§«Öè§¡Ó˹´äÇéÅèǧ˹éÒ â´ÂÁըش»ÃÐʧ¤ìà¾×èÍãËéÊÒÁÒöÊ×èÍÊÒáѹãËé¤ÍÁ¾ÔÇàµÍÃìÊÒÁÒöà¢éÒã¨ä´é â´ÂäÁèµéͧ¼èÒ¹¡ÒõդÇÒÁâ´ÂÁ¹ØÉÂì àªè¹ µéͧ¡ÒÃÃкض֧ªèǧ¶¹¹ÅÒ´¾ÃéÒǵÑé§áµè«Í 68 ¶Ö§ «Í 72 á·¹·Õè¨ÐãªéÇÔ¸Õ¡ÒÃà¢Õ¹¤ÓºÃÃÂÒ´ѧ¡ÅèÒÇ áÅéÇÊè§ä»Âѧ¼ÙéÃѺ¢éÍÁÙÅ»ÅÒ·ҧ ¡çãªéÇÔ¸ÕÍéÒ§ÍÔ§¨Ò¡·ÕèµÑé§ÍéÒ§ÍÔ§´éÇÂÃËÑÊ»ÃШӷÕèµÑé§¾ÃéÍÁ·Ñé§ÃкطÔÈ·Ò§à»ç¹ÃËÑÊ à¾×èÍãËéÊÑé¹áÅЪѴਹ㹡ÒõդÇÒÁ´éǤÍÁ¾ÔÇàµÍÃì

ã¹Ê¶Ò¹¡Òóì·ÕèÊͧ½èÒ«Öè§µÔ´µèÍáÅ¡à»ÅÕè¹¢éÍÁÙšѹÁÕá¼¹·Õ褹ÅЪش à»ç¹ä»ä´éÇèÒ¾Ô¡Ñ´¢Í§ÊÔè§à´ÕÂǡѹÍÒ¨äÁèµÃ§¡Ñ¹ à¹×èͧ¨Ò¡¼ÅÔµâ´ÂµèÒ§ºÃÔÉÑ· ËÃ×͵èҧ˹èǧҹ ËÃ×Í Ë¹èǧҹà´ÕÂǡѹáµèà»ç¹¡ÒÃÍÍ¡ÊÓÃǨµèÒ§ÇÒÃÐ µèҧʶҹ¡Òóì¡Ñ¹

¨Ò¡¡Ò÷Õè¾Ô¡Ñ´¢Í§ÊÔè§à´ÕÂǡѹÍÒ¨ÁÕ¤èÒäÁèà·èҡѹ¹Õé¨Ö§·ÓãËéäÁèÊÒÁÒöÍéÒ§ÍÔ§â´Âãªé¤èÒ¾Ô¡Ñ´áµèà¾Õ§ÍÂèÒ§à´ÕÂÇä´éà¹×èͧ¨Ò¡ÂѧÁÕ¤ÇÒÁ¡Ó¡ÇÁ ¡ÒÃÍéÒ§ÍÔ§·ÕèµÑé§¹Ñé¹à¹é¹·Õè¡ÒÃÊè§à©¾ÒТéÍÁÙÅÃËÑÊ»ÃШӵÑǢͧ·ÕèµÑé§«Öè§ÁÕ¡Òõ¡Å§¡Ñ¹äÇéÅèǧ˹éÒáÅéÇ ÃÇÁ仾ÃéÍÁ¡Ñº¢éÍÁÙÅ»ÃСͺ «Ö觪èÇÂãËé¼ÙéÃѺÊÒÁÒö¶Í´¡ÅѺÍÍ¡ÁÒà»ç¹¢éÍÁÙÅ·ÕèµÑé§ËÃ×͵Óá˹觷Õè¼ÙéÊè§µéͧ¡ÒÃÃÐºØ ·Ñé§¹ÕéµÓá˹觢ͧÊÔè§·Õèʹ㨹Ñé¹ÍÒ¨à»ç¹ä´é·Ñ駨ش ËÃ×Í ªèǧº¹¶¹¹

»ÃÐ⪹ì¤×ÍãªéÊÓËÃѺ¡ÒÃÊ×èÍÊÒÃÃÒ§ҹ ËÃ×ÍãËé¢éÍÁÙÅã´ æ ·ÕèµéͧÁÕ¡ÒÃÃкØÇèÒà˵ءÒóìËÃ×ÍÊÔè§·Õèµéͧ¡ÒÃÃÒ§ҹ¹Ñé¹ à¡Ô´¢Öé¹·Õèã´ â´Â·Õè¼ÙéÃѺ¢éÍÁÙÅáÅмÙéãËé¢éÍÁÙÅäÁè¨Óà»ç¹µéͧÁÕá¼¹·ÕèªØ´à´ÕÂǡѹ áÅÐÍÒ¨¨Ðà»ç¹á¼¹·Õè«Öè§«×éÍËÃ×Íä´éÁÒ¨Ò¡¤¹ÅÐáËÅè§¡çä´é à¾Õ§áµè¨Ðµéͧ·Ó¡ÒÃÈÖ¡ÉÒáÅÐÍéÒ§ÍÔ§¨Ò¡·ÕèµÑé§ÍéÒ§ÍÔ§ªØ´à´ÕÂǡѹÃèÇÁ¡Ñ¹

8.2 â¤Ã§ÊÃéÒ§µÒÃÒ§

ÊÓËÃѺ Location Table ·Õè¨Ðᨡ¨èÒ¹Ñ鹨ÐÍÂÙèã¹ÃٻẺ·ÕèᵡµèÒ§¡Ñº TMC Exchange Format â´Â¨Ð»ÃСͺ仴éÇ 3 µÒÃÒ§ËÅÑ¡Íѹä´éá¡è Point, Line, Area â´Ââ¤Ã§ÊÃéÒ§µÒÃÒ§¨ÐÍÂÙèã¹ÅѡɳдѧÀÒ¾

µÒÃÒ§

Location

à»ç¹µÒÃÒ§·ÕèäÇéà¡çºÃǺÃÇÁ¢éÍÁÙÅã¹ Location table ·Ñé§ËÁ´â´Â¨Ðà¡çºäÇé੾ÒÐ Location id áÅÐ Table id Location id: ÃËÑʢͧ LocationÁÕ¤èÒÍÂÙè㹪èǧ 1 - 65536; Table id: ÃËÑʢͧ Table â´ÂäÇéà¡çº¤èҢͧ Table äÇé

Point

à»ç¹µÒÃÒ§·Õèà¡çºÃǺÃÇÁ¢éÍÁÙÅ·Õèà»ç¹Êèǹ¢Í§¨Ø´ (Point) ·ÕèãªéÊÓËÃѺÍéÒ§ÍÔ§ã¹ Location Table ·Ñé§ËÁ´â´ÂáµèÅШش¹Ñ鹨ÐÊÒÁÒöÍéÒ§ÍÔ§ä´é¡Ñº Line ä´éà¾Õ§á¤è Line à´ÕÂÇà·èÒ¹Ñé¹»ÃСͺ´éÇÂ
  • location id: ÃËÑÊ location code ¢Í§¨Ø´
  • table id: ÃËÑʢͧµÒÃÒ§·Õè¨Ø´¹Ñ鹿Êѧ¡Ñ´ÍÂÙè
  • locType: »ÃÐàÀ·¢Í§¢éÍÁÙÅ (ã¹µÒÃÒ§¹Õé¨Ð¢Ö鹵鹴éÇ P)
  • version: version ¢Í§ location code
  • latitude: ÅеԨٵÔ
  • longitude: ÅͧµÔ¨ÙµÔ
  • positive_point_id: location id ¢Í§¨Ø´ÍéÒ§ÍÔ§¶Ñ´ä»·ÕèÍÂÙèã¹·ÔÈ·Ò§ºÇ¡
  • positive_point_table_id
  • negative_point_id: location id ¢Í§¨Ø´ÍéÒ§·Õè¶Ñ´ä»·ÕèÍÂÙèã¹·Ôȷҧź
  • negative_point_table_id
  • line_id: location id ¢Í§àÊé¹·Õè¨Ø´ location code ¹ÕéÍéÒ§ÍÔ§ÍÂÙè
  • line_table_id
  • area_id: location id ¢Í§¾×é¹·Õè·Õè location code ¹ÕéÍéÒ§ÍÔ§ÍÂÙè
  • area_table_id
  • Roadname: ª×èͧ͢¶¹¹·Õè¨Ø´¹ÕéÍéÒ§ÍÔ§ÍÂÙè
  • formalname: ª×èÍËÅÑ¡¢Í§¨Ø´ÍéÒ§ÍÔ§
  • alias_name: ª×èÍÃͧ¢Í§¨Ø´ÍéÒ§ÍÔ§
  • alias_name2: ª×èÍÃͧ¢Í§¨Ø´ÍéÒ§ÍÔ§

Segment Line

à»ç¹µÒÃÒ§·Õèà¡çº¢éÍÁÙŢͧ¶¹¹â´Â¨ÐÁÕ¡ÒÃà¡çº¶¹¹à»ç¹ÊèǹæËÃ×Í Segment «Öè§¶¹¹¹Ñé¹ÍÒ¨¨Ð¶Ù¡áºè§à»ç¹ËÅÒ Segment ËÃ×Ͷ¹¹ËÅÒÂæ¶¹¹ÍÒ¨¨ÐÃÇÁà»ç¹ Segment à´ÕÂǡѹ¡çä´éáÅéÇáµè¤ÇÒÁàËÁÒÐÊÁ ·Ñé§¹Õéà¾×èÍãËéÊдǡµèÍ¡ÒÃÃÒ§ҹáÅСÒùÓä»ãªé
  • location_id: locatio code
  • table_id: ÃËÑʢͧµÒÃÒ§
  • locType: »ÃÐàÀ·¢Í§¢éÍÁÙÅ (ã¹µÒÃÒ§¹Õé¨Ð¢Ö鹵鹴éÇ L)
  • version: version ¢Í§¢éÍÁÙÅ
  • negative_point_id: ÃËÑʢͧ¨Ø´»ÅÒ¢ͧ segment ã¹´éҹź
  • negative_point_table_id
  • positive_point_id: ÃËÑʢͧ¨Ø´»ÅÒ¢ͧ segment
  • positive_point_table_id
  • parent_line_id: location id ¢Í§ segment_line ËÃ×Í nonsegment_line ·ÕèÍéÒ§Í×§¡Ñº¶¹¹àÊé¹ÍÂÙè (segment line ¨Ðà»ç¹àÊé¹·ÕèÁÕ¢¹Ò´ãË­è¡ÇèÒ)
  • parent_line_table_id:
  • parent_area_id: location id ¢Í§¾×é¹·Õè·Õè location id ¹ÕéÍéÒ§ÍÔ§ÍÂÙè (à»ç¹¡ÒÃÃкØÇèÒ segment line ¹ÕéÍÂÙèã¹¾×é¹·ÕèºÃÔàdzã´)
  • parent_area_table_id
  • formalname: ª×èÍËÅÑ¡¢Í§¢éÍÁÙÅ
  • alias_name: ª×èÍÃͧ¢Í§¢éÍÁÙÅ
  • alias_name2: ª×èÍÃͧ¢Í§¢éÍÁÙÅ

NonSegment? Line

NonSegment? Line ¹Ñ鹨Ðà»ç¹¡ÒÃà¡çº¢éÍÁÙŶ¹¹â´Â¨ÐäÁèÁÕ¡ÒÃÃкØËÃ×Íáºè§à»ç¹Êèǹæ·ÕèªÑ´à¨¹â´Â¨Ðà»ç¹à¾Õ§¢éÍÁÙÅà¡ÕèÂǡѺÃÒÂÅÐàÍÕ´¢Í§¶¹¹àÊé¹¹Ñ鹿à·èÒ¹Ñé¹àªè¹ ¶¹¹¾ËÅâ¸Թ, ¶¹¹ÁÔµÃÀÒ¾ à»ç¹µé¹ (»Ñ¨¨ØºÑ¹µÒÃÒ§¹ÕéÂѧäÁèÁÕ¢éÍÁÙÅ)
  • location_id: location code ¢Í§¢éÍÁÙÅ
  • table_id: ÃËÑʢͧµÒÃÒ§·Õè¢éÍÁÙŹÕéÍÂÙè
  • locType: »ÃÐàÀ·¢Í§¢éÍÁÙÅ (¢éÍÁÙÅã¹µÒÃÒ§¹Õé¢Ö鹵鹴éÇ L)
  • version: version ¢Í§¢éÍÁÙÅ
  • road_num: ÃËÑʢͧ¶¹¹ (¡Ã³Õ·Õè¶¹¹ÁÕÃËÑÊËÃ×Íà»ç¹¶¹¹ËÅǧ)
  • parent_line_id: location_id ¢Í§¶¹¹·Õè¢éÍÁÙŹÕéÍéÒ§ÍÔ§ÍÂÙè
  • parent_line_id
  • parent_area_id: location_id ¢Í§¾×é¹·Õè·ÕèÍéÒ§ÍÔ§ÍÂÙè
  • parent_area_table_id
  • formalname: ª×èÍËÅÑ¡¢Í§¢éÍÁÙÅ
  • alias_name: ª×èÍÃͧ¢Í§¢éÍÁÙÅ
  • alias_name2: ª×èÍÃͧ¢Í§¢éÍÁÙÅ

Area

à»ç¹µÒÃÒ§·Õèà¡çº¢éÍÁÙŢͧ¾×é¹·Õèâ´Â¨ÐäÁèÁÕ¡ÒÃà¡çº¢éÍÁÙÅà¡ÕèÂǡѺ¾Ô¡Ñ´áµè¨ÐÃкØà»ç¹ª×èÍ·ÕèºØ¤¤Å·ÑèÇä»ÃÙé¨Ñ¡¡Ñ¹´ÕáÅÐäÁèÊѺʹàªè¹ ª×è͵ӺÅ, ª×èͨѧËÇÑ´ à»ç¹µé¹
  • location_id: location code ¢Í§¢éÍÁÙÅ
  • table_id: ÃËÑʢͧ µÒÃÒ§ ·Õè location code ¹ÕéÍéÒ§ÍÔ§ÍÂÙè
  • locType: »ÃÐàÀ·¢Í§¢éÍÁÙÅ
  • parent_area_id: location id ·Õè¾×é¹·Õè¹ÕéÍéÒ§ÍÔ§ÍÂÙè (¨ÐÍéÒ§ÍÔ§·ÕèÁÕ¢¹Ò´ãË­è¡ÇèÒµ¹àªè¹ location id ¢Í§µÓºÅ¨ÐÍéÒ§ÍÔ§ä»·Õè location id ¢Í§ ÍÓàÀÍ)
  • parent_area_table_id
  • formalname: ª×èÍËÅÑ¡¢Í§¢éÍÁÙÅ
  • alias_name: ª×èÍÃͧ¢Í§¢éÍÁÙÅ
  • alias_name2: ª×èÍÃͧ¢Í§¢éÍÁÙÅ

Country

à¡çº¢éÍÁÙž×é¹·Õèâ´Â¨Ðà¡çº¢éÍÁÙÅ·Õèà»ç¹¾×é¹·Õè·Õèà»ç¹áºº»ÃÐàÀ· "»ÃÐà·È" à·èÒ¹Ñé¹
  • location_id: location code ¢Í§¢éÍÁÙÅ
  • table_id: ÃËÑʢͧµÒÃÒ§·Õè¢éÍÁÙŹÕé
  • locType: »ÃÐàÀ·¢Í§¢éÍÁÙÅ
  • version: version ¢Í§¢éÍÁÙÅ
  • parent_area_id: location id ¢Í§¾×é¹·Õè·ÕèÍéÒ§ÍÔ§ÍÂÙè (â´ÂÁÒ¡¨Ðà»ç¹ location id ¢Í§·ÇÕ»)
  • parent_area_table_id
  • formalname: ª×èÍËÅÑ¡
  • alias_name: ª×èÍÃͧ
  • alias_name2: ª×èÍÃͧ
  • country_code: country code »ÃШӻÃÐà·È
  • country_id: country id »ÃШӻÃÐà·È

intersection_ref

à»ç¹µÒÃÒ§·Õèà¡çº¢éÍÁÙÅÇèÒ location id ã´ºéÒ§·Õèà»ç¹¨Ø´àª×èÍÁµèÍâ´ÂÁÒ¡¨Ðà»ç¹¨Ø´·Õèà»ç¹¡ÒÃà»ÅÕè¹á»Å§ª×èͶ¹¹ ËÃ×Íà»ç¹¨Ø´µèÍÃÐËÇèÒ§ Segment line 2 àÊé¹ËÃ×Íà»ç¹ºÃÔàdz 4 á¡ (µÒÃÒ§¹ÕéÂѧäÁèÁÕ¢éÍÁÙÅ)
  • location_id: location code ¢Í§¢éÍÁÙÅ
  • table_id: ÃËÑʢͧµÒÃÒ§
  • intersection_id: ÃËÑʢͧá¡

8.3 ¡ÒùÓä»ãªé

ãªéÊÓËÃѺ¡ÒÃÍéÒ§ÍÔ§µÓá˹è§ãËéµÃ§¡Ñº TDC (Traffic Data Center) à¾×èÍ¡ÒÃÃѺ¢éÍÁÙŨÃÒ¨ÃáÅÐá»Å¤ÇÒÁËÁÒµÓá˹è§ä´é¶Ù¡µéͧ â´ÂÁÕ¢Ñ鹵͹¡ÒÃàµÃÕÂÁ¡ÒÃÅèǧ˹éÒ ¤×Í 1. ¹Ó¢éÍÁÙÅ·ÕèµÑé§ÍéÒ§ÍÔ§ä»à»Ô´à»ÃÕºà·Õº¡Ñº·ÕèµÑé§µèÒ§ æ ã¹á¼¹·Õè¢Í§·èÒ¹áÅéÇ·Ó¡ÒèѺ¤Ùèà»ç¹µÒÃÒ§àµÃÕÂÁäÇéã¹ÃٻẺ lookup table àªè¹ ËÒÇèÒÊÕèá¡ ¡. ·Õè»ÃÒ¡¯ã¹¢éÍÁÙÅ·Ñé§ÊͧªØ´ (ªØ´¢éÍÁÙÅ·ÕèµÑé§ÍéÒ§ÍÔ§¡ÑºªØ´¢éÍÁÙÅá¼¹·Õè¢Í§·èÒ¹) áÅéÇ·ÓµÒÃÒ§ (lookup table) ·Õè·ÓºÑ¹·Ö¡¡ÒèѺ¤ÙèÃÐËÇèÒ§ÃËÑÊ»ÃШӷÕèµÑé§ÍéÒ§ÍÔ§¡ÑºÃËÑÊ·ÕèµÑ駢ͧἹ·Õè¢Í§·èÒ¹ 2. ·Óàªè¹¹Õé¡Ñº·ÕèµÑé§ÍéÒ§ÍÔ§·Ñé§ËÁ´¨¹¤Ãº áÅÐä´éµÒÃÒ§¨Ñº¤Ùè·ÕèÊÁºÙóì 3. àÁ×èÍ·Ò§ TDC Êè§¢éÍÁÙÅ«Öè§ÍéÒ§ÍÔ§ÃËÑÊ·ÕèµÑé§ÁÒ ·èÒ¹¡ç¨Ð·ÃÒºÇèÒ TDC ËÁÒ¶֧µÓá˹è§ËÃ×Í·ÕèµÑé§ã´ã¹á¼¹·Õèâ´Â´Ù¨Ò¡µÒÃÒ§¨Ñº¤Ùè´Ñ§¡ÅèÒÇ 4. ËÒ¡·èÒ¹ÊÒÁÒöà¢Õ¹â»Ãá¡ÃÁ¤ÍÁ¾ÔÇàµÍÃìãËéÃѺ¤èÒÃËÑʨҡ TDC áÅéÇä»Ê׺¤é¹µèÍã¹á¼¹·Õè¢Í§·èÒ¹ ·èÒ¹¡ç¨ÐÊÒÁÒö áÊ´§¼Å¢éÍÁÙŨÃҨú¹á¼¹·Õè¢Í§·èÒ¹ä´é

ËÁÒÂà赯 ¡ÒÃãªé·ÕèªØ´µÑé§ÍéÒ§ÍÔ§´Ñ§¡ÅèÒÇà»ç¹µÑÇ¡ÅÒ§¡çà¾×èͨÐËÅÕ¡àÅÕ觻ѭ·Õèà¡Ô´¨Ò¡¤èÒ¾Ô¡Ñ´·ÕèÁÑ¡¨ÐᵡµèÒ§¡Ñ¹áÅЫé͹·Ñº¡Ñ¹äÁèʹԷ

8.4 ¡ÒÃà¢éÒÃËÑÊ·ÕèµÑé§ÍéÒ§ÍÔ§à¾×èÍ¡ÒáÓ˹´µÓá˹è§

´ÙÃÒÂÅÐàÍÕ´ä´éã¹àÍ¡ÊÒÃËÑÇ¢éÍ 8.6.1

8.5 µÔ´µè͢͢éÍÁÙÅ·ÕèµÑé§ÍéÒ§ÍÔ§

µÔ´µèÍä´é·ÕèÍÕàÁÅÅì

8.6 º·¤ÇÒÁÊÓËÃѺÍèÒ¹»ÃСͺ

¡ÒÃÃкصÓá˹觴éÇ¡ÒÃÍéÒ§ÍÔ§·ÕèµÑé§ (àÁÉÒ¹ 2552)

8.7 Êͺ¶ÒÁ¢éÍÁÙÅ·Ò§à·¤¹Ô¤à¾ÔèÁàµÔÁä´é·Õè¤Ø³Á¹µìÈÑ¡´Ôì â«èà¨ÃÔ­¸ÃÃÁ;

toggleopenShow attachmentstogglecloseHide attachments
Topic attachments
I Attachment Action Size Date Who Comment
pngPNG lt4.PNG manage 47.3 K 07 Apr 2009 - 09:33 NattaponKlakhaeng  
pngpng monsak-email.png manage 2.8 K 20 Apr 2009 - 10:03 NattaponKlakhaeng  
pdfpdf Location-Referencing-Design.pdf manage 135.8 K 20 Apr 2009 - 14:09 NattaponKlakhaeng  
Edit | WYSIWYG | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r6 < r5 < r4 < r3 < r2 | More topic actions
 
Powered by NTL
This site is powered by the TWiki collaboration platformCopyright © by National Electronics and Computer Technology Center, NECTEC.
Ideas, requests, problems regarding NTL? Send feedback