ዻᕈᬌ⚝ߣ⛔⸘ ‫ޝ‬8/1㧘8/2‫ޞ‬ SuperMap ߢߪዻᕈᖱႎ߆ࠄࠝࡉࠫࠚࠢ࠻ߩᬌ⚝߇น⢻ߢ㧘ࡑ࠶ࡊ߿ዻᕈ৻ⷩ⴫ߣߒߡෳᾖߔ
ࠆߎߣ߇ߢ߈߹ߔ‫ߚ߹ޕ‬ᬌ⚝⚿ᨐࠍᣂⷙ࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽߔࠆߎߣ߽น⢻ߢߔ‫ߦࠄߐޕ‬SQL ࠢࠛ࡝ߩ⸳ቯߦࠃࠅ㧘ࡈࠖ࡯࡞࠼ߦ⸘▚⚿ᨐߩㅊട㧘ዻᕈ୯ߩ⛔⸘߿㓸⸘⸘▚߽น⢻ߢߔ‫ޕ‬‫ޣ‬ᵈᗧ‫ޤ‬SQL ࠢࠛ࡝ߢㅊടߒߚࡈࠖ࡯࡞࠼ߪ
㧝㧚㧿㧽㧸ࠢࠛ࡝ࠍ೑↪ߒߚዻᕈᬌ⚝ SuperMap ߢߪዻᕈᬌ⚝ߪ‫ޡ‬SQL ࠢࠛ࡝‫⸳ߩ࠙࠼ࡦࠖ࠙ޢ‬ቯ߆ࠄⴕ޿߹ߔ‫ޕ‬‫ޡ‬SQL ࠢࠛ࡝‫ࠍ࠙࠼ࡦࠖ࠙ޢ‬㐿ߊ߹ߢߩᚻ㗅ߪࡢ࡯ࠢࠬࡍ࡯ࠬ࠙ࠖࡦ࠼࠙ߩኻ⽎࠺࡯࠲࠮࠶࠻
ࠍฝࠢ࡝࠶ࠢࠃࠅ‫ޡ‬SQL ࠢࠛ࡝‫ࠍޢ‬ㆬᛯ㧔࿑㧝㧙㧝㧕޽ࠆ޿ߪࡔ࠾ࡘ࡯߆ࠄ‫ޢ࡝ࠛࠢޡ‬㧛‫ޡ‬SQLࠢࠛ࡝‫ߢޢ‬㧘‫ޡ‬SQL ࠢࠛ࡝‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔߩߢ㧘ᬌ⚝᧦ઙࠍ⸳ቯߒᬌ⚝ߔࠆߎߣߣߥࠅ
߹ߔ‫ޕ‬‫ޣ‬ᵈᗧ‫⁁ߚߒ␜⴫ࠍ࠻࠶࠮࠲࡯࠺ߦࡊ࠶ࡑޤ‬ᘒߢ‫ޡ‬SQL ࠢࠛ࡝‫ߦޢ‬ㅴߺ߹ߔߣᬌ⚝⸳ቯኻ⽎߇ߘߩ࠺࡯࠲࠮࠶࠻ߩߺߦߥߞߡߒ߹޿߹ߔ‫ⶄޕ‬ᢙߩ࠺࡯࠲࠮࠶࠻߿೎ߩ࠺࡯࠲࠮࠶࠻ࠍኻ⽎ߣߒߚ޿႐วߪࡑ࠶ࡊࠍ㐽ߓߡ߆ࠄⴕߞߡߊߛߐ޿‫ޕ‬
SQL ࠢࠛ࡝ߩ౉ജ㗄⋡ߪⶄ㔀ߢ޽ࠅ߹ߔ߇㧘ߘߩ౉ജ㗄⋡ߪ࿑㧝㧙㧞ߦ␜ߔ㧟୘ߩ౉ജ㗄⋡ࠣ࡞࡯ࡊߦ඙ಽߢ߈߹ߔ‫ޕ‬ 㧭㧦౉ജ⵬ഥࠛ࡝ࠕ‫ޕ‬ᬌ⚝᧦ઙ╬ߩ౉ജ㧔㧮ࠛ࡝ࠕ㧕ߩ⵬ഥࠍ⋡⊛ߣߒߡ޿߹ߔ‫ࡈޕ‬ࡈࠖ࡯࡞࠼Ᏹ↪㑐ᢙߦߪ‫ޡ‬㓸ว㑐ᢙ‫ޢ‬㧘‫ޡ‬ᢙᖱႎ㧘Ṷ▚ሶ㧘Ᏹ↪㑐ᢙࠍ㧘৻ⷩ⴫߆ࠄߩㆬᛯ౉ജߢ⵬ഥߒ߹ߔ‫ޕ‬Ᏹቇ㑐ᢙ‫ޢ‬㧘‫ޡ‬ᢥሼ೉㑐ᢙ‫ޢ‬㧘‫ޡ‬ᣣઃ㑐ᢙ‫߇ߔ߹ࠅ޽߇ޢ‬㧘⹦⚦ߪ SuperMap ߩࡑ࠾ࡘࠕ࡞ࠍෳᾖߒߡ
ߊߛߐ޿‫ޕ‬㧮㧦ᬌ⚝᧦ઙ෸߮಴ജࡈࠖ࡯࡞࠼ߩ౉ജࠛ࡝ࠕ‫ࡈޕ‬ࡈࠖ࡯࡞࠼ฬ㧘ࠢࠢࠛ࡝᧦ઙ㧘ࠣࠣ࡞࡯ࡊൻ㧘ਗਗߴᦧ߃ߦᔅⷐߥᢙᑼ෸߮ࡈࠖ࡯࡞࠼ฬࠍ౉ജߒ߹ߔ‫ޕ‬ዻᕈᬌ⚝ߢߪᦨ㊀ⷐߥ౉ജ㗄⋡ߣߥࠅ߹ߔ‫ޕ‬㧯㧦ᬌ⚝⚿ᨐߩ಴ജᒻᑼᜰቯ‫ޕ‬ᬌ⚝⚿ᨐࠍዻᕈ࠹࡯ࡉ࡞߿ࡑ࠶ࡊߣߒߡ⴫␜ߔࠆ߆ࠍㆬᛯߔࠆ
ߎߣ߇ߢ߈߹ߔ‫ߚ߹ޕ‬㧘ᬌ⚝⚿ᨐࠍ࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽߒߚ޿႐ว㧘‫⚿࡝ࠛࠢޡ‬ᨐࠍ଻ሽ‫ߦޢ‬࠴ࠚ࠶ࠢࠍ౉ࠇߡ㧘࠺࡯࠲࠮࠶࠻ฬ⒓ࠍ౉ജߒ߹ߔ‫ߩߎޕ‬ᯏ⢻ࠍ૶޿߹ߔߣ㧘ᄙᢙߩࠝࡉࠫࠚࠢ
࠻ࠍ฽߻࠺࡯࠲࠮࠶࠻߆ࠄᬌ⚝᧦ઙߦวߞߚࠝࡉࠫࠚࠢ࠻ࠍ฽߻࠺࡯࠲࠮࠶࠻ࠍ↢ᚑߔࠆߎߣ߇
ߢ߈߹ߔ‫߇࠭ࠗࠨ࠲࡯࠺ޕ‬ዊߐߊߥࠆߚ߼㧘࿾࿑⴫␜߿ⓨ㑆ಽᨆ߇ⴕ޿߿ߔߊߥࠅ߹ߔ‫ޕ‬㧞㧚ᢙ୯ߦࠃࠆᬌ⚝ ߎߎߢߪ ࠺࡯࠲࠰࡯ࠬ⛔
⛔⸘ౝߩ࠺࡯࠲࠮࠶࠻ okinawa_D ࠍ૶↪ߒߡ㧘ᢙ୯᧦ઙߦࠃࠆዻᕈ
ᬌ⚝ߩᣇᴺࠍ⸃⺑ߒ߹ߔ‫ ߅ߥޕ‬okinawa_D ߪ‫ޟ‬ዻᕈ୯ߩ✬㓸‫ߢޠ‬૞ᚑߒߚ߽ߩߢ㧘ᴒ✽ፉߩᏒ↸᧛࿑ߣ㧘ዻᕈ୯ߣߒߡᏒ↸᧛ฬߣฦᐕߩੱญࠍ᦭ߔࠆ࠺࡯࠲࠮࠶࠻ߢߔ‫ޕ‬ታ㓙ߩ SQL ࠢࠛ࡝⸳ቯߪⶄ㔀ߥߩߢ㧘଀㗴ࠍ૶ߞߡ⺑᣿ߒ߹ߔ‫ޕ‬଀㧝㧚2000 ᐕߩੱญ߇ 10000 ੱએ਄ߩᏒ↸᧛ࠍ৻ⷩ⴫෸߮ࡑ࠶ࡊߦ⴫␜
ࡄ࡜ࡔ࡯࠲⸳ቯ⁁ᴫߪ࿑㧝㧙㧟ߦ␜ߒ߹ߔ‫ߚ߹ޕ‬㧘⹦⚦ߪએਅߩㅢࠅߦߥࠅ߹ߔ‫ޕ‬Ԙࡈࡈࠖ࡯࡞࠼ฬ㧦ᬌ⚝⚿ᨐߣߥࠆ࠺࡯࠲࠮࠶࠻ߢ㧘ᬌ⚝ኻ⽎ߣߥߞߚ࠺࡯࠲࠮࠶࠻ߩዻᕈ᭴ㅧ
㧖㧕‫ߚ߹ޕ‬㧘৻ㇱ㧔ࡈࠖ࡯࡞࠼ߩ᭴ᚑ㧕ࠍߘߩ߹߹೑↪ߔࠆ႐วߪ 㧖 ߣߒ߹ߔ㧔࠺ࡈࠜ࡞࠻ߢ㧖ߩࡈࠖ࡯࡞࠼ߩ೑↪ߦߥࠆ႐วߪ㧭ࠛ࡝ࠕߩ‫࠼࡞࡯ࠖࡈޡ‬ᖱႎ‫ࠍ⴫ⷩ৻ޢ‬೑↪ߒߡ౉ജ㧔ࡑ࠙ࠬߢࠢ࡝࠶ࠢ㧕ߒߡߊߛߐ޿‫ⶄޕ‬ᢙࡈࠖ࡯࡞࠼౉ജߩ႐วߪ ̌㧘̍ߢ඙ಾࠅ߹ߔ‫ߩ࠼࡞࡯ࠖࡈޕ‬ฬ⒓ߪ‫ޟ‬㧔࠺࡯࠲࠮࠶࠻ฬ⒓㧕㧚㧔ࡈࠖ࡯࡞࠼ฬ㧕‫ޕߔ߹޿ߡߞߥߣޠ‬ ԙࠢࠢࠛ࡝᧦ઙ㧦2000 ᐕੱญߪࡈࠖ࡯࡞࠼ okinawa_D㧚pop2000 ߣߥࠅ߹ߔ‫࠼࡞࡯ࠖࡈޡޕ‬ᖱႎ‫౉ࠄ߆ޢ‬ജน⢻ߢߔ‫ޕ‬‫ޟ‬10000 એ਄‫ޡߪޠ‬Ṷ▚ሶ‫౉ࠄ߆࠼࡯ࡏ࡯ࠠߣޢ‬ജߒ߹ߔ‫ޕ‬ࠣ࡞࡯ࡊൻ㧘ਗਗߴᦧ߃㧦㓸⸘⸘▚෸߮಴ജᤨߦᔅⷐߥ⸳ቯߢߔߩߢ㧘ߎߩᬌ⚝ߦߪ೑↪ߒ߹
 Ԛࠣ
ߖࠎ‫ޕ‬
ᬌ⚝⚿ᨐߩ಴ജ⸳ቯ㧦‫ޡ‬ዻᕈ⴫ߦࠢࠛ࡝⚿ᨐࠍ⴫␜‫ޢ‬෸߮‫⚿ߦ࠙࠼ࡦࠖ࠙ࡊ࠶ࡑޡ‬ᨐࠍ⴫␜‫ޢ‬ԛᬌߦ࠴ࠚ࠶ࠢࠍ౉ࠇ߹ߔ㧔Viewer ߢߪዻᕈ࠹࡯ࡉ࡞৻ⷩ⴫⴫␜ߪߢ߈߹ߖࠎ㧕‫ޕ‬‫⚿࡝ࠛࠢޡ‬ᨐࠍ଻ሽ‫ޢ‬ߦ࠴ࠚ࠶ࠢߔࠆߣᬌ⚝⚿ᨐࠍ࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽߔࠆߎߣ߇ߢ߈߹ߔ‫଻ᤨߩߎޕ‬ሽߔࠆ࠺࡯
࠲࠮࠶࠻ߩฬ⒓ࠍ᳿߼ߡਅߐ޿‫ޕ‬ ⸳ቯ⚳ੌᓟ㧔࿑㧝㧙㧟㧕㧘OK ࡏ࠲ࡦࠍ᛼ߒ㧿㧽㧸ࠢࠛ࡝ታⴕᓟ㧘ᬌ⚝⚿ᨐ࠹࡯ࡉ࡞ߣᬌ⚝ߐࠇߚࠝࡉࠫࠚࠢ࠻߇ㆬᛯ⁁ᘒߢ␜ߐࠇߚࡑ࠶ࡊ߇⴫␜ߐࠇ߹ߔ‫ޕ‬㧔࿑㧝㧙㧠㧘㧡㧕 ᬌ⚝⚿ᨐߩ࠺࡯࠲࠮࠶࠻଻ሽߪ㧘࿑㧝㧙㧡ߩࡑ࠶ࡊ࠙ࠖࡦ࠼࠙߆ࠄ߽ฝࠢ࡝࠶ࠢߢน⢻ߢߔ‫ޕ‬଀㧞㧚㧞㧜㧜㧜ᐕߩੱญ߇㧝㧥㧥㧜ᐕߦᲧߴჇടߒߚᏒ↸᧛ࠍࡑ࠶ࡊߦ⴫␜
ࡄ࡜ࡔ࡯࠲⸳ቯ⁁ᴫ෸߮ᬌ⚝⚿ᨐߪ࿑㧝㧙㧢ߦ␜ߒ߹ߔ‫ޕ‬ ࠢࠛ࡝᧦ઙࠍⶄᢙߩࡈࠖ࡯࡞࠼ࠍ૶ߞߚᢙᑼߦߔࠆߎߣ߇น⢻ߢߔ‫࠼࡞࡯ࠖࡈޕ‬ฬ⒓߇㐳ߊߥࠆߚ߼㧘‫࠼࡞࡯ࠖࡈޡ‬ᖱႎ‫ࠍ⴫ⷩ৻ޢ‬೑↪ߒߡ౉ജߔࠆߩ߇޿޿ߢߒࠂ߁‫ޕ‬㧟㧚࠹ࠠࠬ࠻ߦࠃࠆᬌ⚝ ࠹ࠠࠬ࠻ߦࠃࠆዻᕈᬌ⚝ߪ㧘࠹ࠠࠬ࠻ᠲ૞ࠍⴕ߁ᢥሼ೉㑐ᢙࠍ૶޿ߎߥߖࠇ߫㜞ᐲߥᬌ⚝ࠍߔࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬ᢥሼ೉㑐ᢙߩ⹦⚦ߪࡑ࠾ࡘࠕ࡞ࠍෳᾖߒߡߊߛߐ޿‫ߪߢߎߎޕ‬ၮᧄ⊛ߥᢥሼ೉㑐ᢙࠍ೑↪ߒߡዻᕈᬌ⚝ߩ⸃⺑ࠍⴕ޿߹ߔ‫ޕ‬ ߎߎߢߪ ࠺࡯࠲࠰࡯ࠬ map25k_vec ౝߩ࠺࡯࠲࠮࠶࠻౏౒ᣉ⸳ࠍ૶↪ߒߡ㧘࠹ࠠࠬ࠻᧦ઙߦ
ࠃࠆዻᕈᬌ⚝ߩᣇᴺࠍ⸃⺑ߒ߹ߔ‫౒౏߅ߥޕ‬ᣉ⸳ߪᴒ✽ፉౝߩ౏౒ᣉ⸳࿾ὐࡐࠗࡦ࠻㧘ዻᕈ୯ߣ
ߒߡߘߩ⒳㘃㧘ฬ⒓㧘૑ᚲࠍ᦭ߔࠆ࠺࡯࠲࠮࠶࠻ߢߔ‫ޕ‬଀㧟㧚ฬ⒓߆ࠄࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝ ‫⚿ߦ࠙࠼ࡦࠖ࠙ࡊ࠶ࡑޡ‬ᨐࠍ⴫␜‫ࠍޢ‬೑↪ߔࠆߣᬌ⚝ࠝࡉࠫࠚࠢ࠻ࠍࡑ࠶ࡊ਄ߦ⴫␜ߔࠆߎߣ
߇ߢ߈߹ߔ‫ ࠼࡞࡯ࠖࡈߪߢߎߎޕ‬Namae ߆ࠄᴒ✽⋵ᐡࠍࡑ࠶ࡊ⴫␜ߐߖ߹ߔ‫ޕ‬ ࡄ࡜ࡔ࡯࠲⸳ቯߪ࿑㧝㧙22 ߦ␜ߒ߹ߔ‫੹ޕ‬࿁ߪᬌ⚝⚿ᨐࠍࡑ࠶ࡊ⴫␜ߐߖࠆߚ߼‫ࠖ࠙ࡊ࠶ࡑޡ‬ࡦ࠼࠙ߦ⚿ᨐࠍ⴫␜‫ࠇ޿ࠍࠢ࠶ࠚ࠴ߦޢ‬㧘‫ޡ‬ዻᕈ⴫ߦࠢࠛ࡝⚿ᨐࠍ⴫␜‫ࠍࠢ࠶ࠚ࠴ߪޢ‬ᄖߒ߹ߔ‫ޕ‬ࠢࠛ࡝᧦ઙ㧦 ౏౒ᣉ⸳.Namae="ᴒ✽⋵ᐡ" ߣ౉ജߒ߹ߔ‫ޕ‬ᬌ⚝ࠍⴕ޿߹ߔߣࡑ࠶ࡊ⴫␜ߪ࿑㧝㧙23 ߩ⁁ᘒߦᄌൻߒ߹ߔ‫ߪࠇߎޕ‬ᬌ⚝ߒߚࠝࡉࠫࠚࠢ࠻
㧔ᴒ✽⋵ᐡߩࡐࠗࡦ࠻㧕߇ࡑ࠶ࡊਛᄩߦ࠮࠶࠻ߐࠇߚߚ߼ߢߔ‫⁁ߩߎޕ‬ᘒ߆ࠄࡑ࠶ࡊ❗ዤࠍᄢ߈ߊߔࠆߣ㧔ࡑ࠶ࡊ⸳ቯ࠷࡯࡞ࡃ࡯ߩ❗ዤᄌᦝߥߤ㧕ᬌ⚝ࠝࡉࠫࠚࠢ࠻߇್⺒น⢻ߦߥࠅ߹ߔ‫ޕ‬㧔ਛᄩߩ㕍޿ὐ㧕߹ߚ㧘ᬌ⚝ಣℂ೨ߩࡑ࠶ࡊߦᬌ⚝ࠝࡉࠫࠚࠢ࠻߇⴫␜ߐࠇߡ޿ߥ޿႐วߪ㧘ᬌ⚝ᓟ⴫␜૏⟎߇ᬌ⚝ࠝࡉࠫࠚࠢ࠻ࠍਛᔃߣߒߚ↹㕙ߦ⒖േߒ߹ߔ‫ޕ‬㧔࿑㧝㧙24㧕ⶄᢙߩࠝࡉࠫࠚࠢ࠻
߇ᬌ⚝ߐࠇߚ႐วߪߘࠇࠄ߇ోߡ⴫␜ߐࠇࠆ⁁ᘒߦ↹㕙߇ᄌൻߒ߹ߔ‫ޕ‬଀㧠㧚ቇᩞࠍᬌ⚝㧘ᣂⷙ࠺࡯࠲࠰࡯ࠬߦ଻ሽ
ࡄ࡜ࡔ࡯࠲⸳ቯߪ࿑㧝㧙㧣㧘߹ߚᬌ⚝⚿ᨐߪ࿑㧝㧙㧤ߦ␜ߒ߹ߔ‫ޕ‬ ࠺࡯࠲࠮࠶࠻౏౒ᣉ⸳ߩ Shurui ࡈࠖ࡯࡞࠼ߦฦࡐࠗࡦ࠻ߩ⒳೎߇⸥౉ߐࠇߡ޿ࠆߩߢ㧘ߎߎ߇̌ቇᩞ̍ߣߥߞߚࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝ߔࠆߎߣߣߥࠅ߹ߔ‫ޕ‬ࠢࠛ࡝᧦ઙ㧦 ౏౒ᣉ⸳.Shurui="ቇᩞ" ߣ౉ജߒ߹ߔ‫ޕ‬‫⚿࡝ࠛࠢޡ‬ᨐࠍ଻ሽ‫ࠇ޿ࠢ࠶ࠚ࠴ߦޢ‬ᬌ⚝⚿ᨐࠍᣂⷙ࠺࡯࠲࠮࠶࠻ቇ
ቇᩞߣߒߡ଻ሽߒ߹ߔ‫ޕ‬଀㧡㧚ዊቇᩞࠍᬌ⚝ ࠺࡯࠲࠮࠶࠻౏౒ᣉ⸳ߩ Shurui ࡈࠖ࡯࡞࠼߆ࠄᬌ⚝ߔࠆߎߣߪߢ߈߹ߖࠎ‫ޕ‬Nmae ࡈࠖ࡯࡞࠼ߦฦࡐࠗࡦ࠻ߩฬ⒓߇౉ߞߡ޿߹ߔ߇㧘ߎߩฬ⒓ߩᦨᓟ߆ࠄ㧟ᢥሼ߇‫ޟ‬ዊቇᩞ‫ࠆ޿ߡߞߥߣޠ‬߽ߩࠍᬌ⚝ߔࠆᔅⷐ߇޽ࠅ߹ߔ‫ࠍ࠻ࠬࠠ࠹ߦ߁ࠃߩߎޕ‬ᠲ૞ߒߥߌࠇ߫ߥࠄߥ޿႐ว㧘ᢥሼ೉ᠲ૞㑐ᢙ߇᦭ലߦߥࠅ߹ߔ‫ޕ‬ ԘRight 㑐ᢙࠍ૶ߞߚᣇᴺ Right㧔ࡈࠖ࡯࡞࠼ฬ㧘ᢥሼᢙ㧕ߢ㧘ࡈࠖ࡯࡞࠼࠺࡯࠲ࠍฝ߆ࠄᢥ
ሼᢙಽಾࠅ಴ߒ߹ߔ‫ޕ‬ᓥߞߡ㧘ࠢࠛ࡝᧦ઙ㧦 Right㧔౏౒ᣉ⸳.Shurui㧘㧟㧕="ዊቇᩞ" ߣ౉ജߒ߹ߔ‫ޕ‬㧔࿑㧝㧙㧥㧕
ԙInstr 㑐ᢙࠍ૶ߞߚᣇᴺ Instr㧔ࠨ࡯࠴㐿ᆎᢥሼ૏⟎㧘ࡈࠖ࡯࡞࠼ฬ㧘ᬌ⚝࠹ࠠࠬ࠻㧕ߢ㧘ኻ⽎ࡈࠖ࡯࡞࠼ߩ࠺࡯࠲߆ࠄᬌ⚝࠹ࠠࠬ࠻ࠍតߒ߹ߔ‫޿ߥࠄ߆ߟ⷗߇࠻ࠬࠠ࠹ߒ߽ޕ‬႐วߪ㧜ࠍ㧘⷗ߟ߆ߞߚ႐วߪߘߩᢥሼ૏⟎ࠍ㄰ߒ߹ߔ‫ޕ‬ᬌ⚝ߒߚ޿࠹ࠠࠬ࠻ߩ૏⟎߇࿕ቯߐࠇߡ޿ߥ޿႐ว
ߥߤߦ㕖Ᏹߦᓎ┙ߜ߹ߔ‫ޕ‬ࠢࠛ࡝᧦ઙ㧦 instr(1,౏౒ᣉ⸳.Namae,"ዊቇᩞ") > 0 ߣ౉ജߒ߹ߔ‫ޕ‬㧔࿑㧝㧙10㧕 ዻᕈᬌ⚝ߢߪࠢࠛ࡝᧦ઙࠍⶄว᧦ઙߢ⸳ቯߔࠆߎߣ߇ߢ߈߹ߔ‫᧦ޕ‬ઙᑼࠍ AND ߿ OR ߥߤߢㅪ⚿ߔࠆߎߣߣߥࠅ߹ߔ‫ޕ‬ṶṶ▚ሶ৻ⷩ⴫߆ࠄ౉ജߔࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬ṶṶ▚ሶߩ⹦⚦ߪࡑ࠾ࡘࠕ
࡞ߦߡ⏕⹺ߒߡߊߛߐ޿‫ޕ‬㧠㧚ࡈࠖ࡯࡞࠼⸘▚⚿ᨐߩㅊട SQL ࠢࠛ࡝ࠍ૶ߞߡ㧘ⶄᢙࡈࠖ࡯࡞࠼㑆ߢ▚಴ߒߚ⚿ᨐࠍዻᕈᖱႎߦᣂⷙࡈࠖ࡯࡞࠼ߣߒߡㅊ
ടߔࠆߎߣ߇น⢻ߢߔ‫ޕ‬‫ޡ‬SQL ࠢࠛ࡝‫ߡ޿߅ߦ࠙࠼ࡦࠖ࠙ޢ‬㧘ࡈࡈࠖ࡯࡞࠼ฬߦ⸘▚ᑼߣᣂⷙࡈࠖ
࡯࡞࠼ฬ⒓ࠍ⸥ㅀߔࠆߎߣߢ㧘⸘▚⚿ᨐࠍ⸥ߒߚࡈࠖ࡯࡞࠼ࠍㅊടߢ߈߹ߔ‫ߪ࠼࡞࡯ࠖࡈߩߎޕ‬⥄േߢ↢ᚑߐࠇ㧘‫ޡ‬ዻᕈ⴫ߩ᭴ᚑ‫࠼࡞࡯ࠖࡈࠄ߆ޢ‬ㅊടಣℂࠍⴕ߁ᔅⷐߪ޽ࠅ߹ߖࠎ‫ޕ‬ ߎߎߢ㧘࠺࡯࠲࠰࡯ࠬ⛔
⛔⸘ౝߩ࠺࡯࠲࠮࠶࠻ okinawa_D ࠍ૶↪ߒߡੱญኒᐲࠍ▚಴ߒ߹ߔ‫ޕ‬ࡈࠖ࡯࡞࠼ฬߦએਅߩᑼࠍ⸥ㅀߒ߹ߔ‫ޕ‬ *,okinawa_D.pop2000/okinawa_D.SdAreaBL*1000000 as ੱญኒᐲ‫ޡ‬㧘‫ޢ‬એਅࠍㅊടߔࠆߎߣࠍᗧ๧ߒ వ㗡ߩ‫*ޡ‬,‫ ߪޢ‬okinawa_D ߩዻᕈࡈࠖ࡯࡞࠼ࠍోߡ೑↪ߒ㧘߹ߔ‫ޡޕ‬okinawa_D.pop2000/okinawa_D.SdAreaBL*1000000‫▚⸘ߚߞ૶ࠍ࠼࡞࡯ࠖࡈߪޢ‬ᑼߢ‫ޡ‬okinawa_D.pop2000‫ ߪޢ‬2000 ᐕੱญ߇⸥ߐࠇߚࡈࠖ࡯࡞࠼㧘‫ޡ‬okinawa_D.SdAreaBL‫ߪޢ‬㕙
Ⓧ㧔ট㧕ߢන૏឵▚ߩߚ߼ 1000000 ୚ߒߡ޿߹ߔ‫▚⸘ߩߎޕ‬ᑼ߆ࠄߩ▚಴⚿ᨐࠍ෼⚊ߔࠆࡈࠖ࡯
ੱญኒ
࡞࠼ฬ⒓ࠍቯ⟵ߔࠆߚ߼‫ޡ‬as ੱญኒᐲ‫ޕߔ߹ࠅ޽ߡߒߣޢ‬ᓥߞߡ⸘▚⚿ᨐߪࡈࠖ࡯࡞࠼ੱ
ᐲߦ⸥౉ߐࠇ߹ߔ‫ޕ‬‫ޡ‬SQL ࠢࠛ࡝‫⸳ߩޢ‬ቯ⁁ᴫߪ࿑㧝㧙11 ߦ㧘⸘▚ᓟߩዻᕈ࠺࡯࠲৻ⷩ⴫ߪ࿑㧝㧙12 ߦ␜ߒ߹ߔ‫ޕ‬ ▚಴ߒߚࡈࠖ࡯࡞࠼ࠍ฽߻ዻᕈ࠺࡯࠲ߪ㧘ዻᕈ࠺࡯࠲৻ⷩ⴫ߦ৻ᤨ⊛ߦ⴫␜ߐࠇߡ޿ࠆߛߌߢ㧘ߎߩ࠙ࠖࡦ࠼࠙ࠍ㐽ߓߚᲑ㓏ߢߘߩ⚿ᨐߪᄬࠊࠇߡߒ߹߁‫ߩߎޕ‬ዻᕈ࠺࡯࠲㧔ࠝࡉࠫࠚࠢ࠻߽฽
߻㧕ࠍ଻ሽߔࠆ႐วߪ㧘ߎߩዻᕈ⴫߆ࠄ‫଻ߦ࠻࠶࠮࠲࡯࠺ޡ‬ሽ‫ߢޢ‬ᣂⷙ࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽ
ߒ߹ߔ‫ޕ‬㧔‫ޟ‬ዻᕈ৻ⷩ⴫ߩ೑↪‫ޕߔ߹ߒ⺑⸃ߢޠ‬㧕‫ޣ‬ᵈᗧ‫ޡޤ‬SQL ࠢࠛ࡝‫ߢ࠙࠼ࡦࠖ࠙ޢ‬㧘ᬌ⚝⚿ᨐࠍ‫⚿࡝ࠛࠢޡ‬ᨐࠍ଻ሽ‫ࠄ߆ޢ‬ᣂⷙ࠺࡯࠲ߣߒߡ
଻ሽߒߚ႐ว㧘ࡈࠖ࡯࡞࠼ฬߢㅊടߒߚᣂⷙࡈࠖ࡯࡞࠼㧔⸘▚⚿ᨐ㧕ߪ଻ሽߐࠇ߹ߖࠎ‫ޕ‬㧡㧚ዻᕈࡈࠖ࡯࡞࠼ߩ࡝ࡦࠢ㧢㧚SQL ࠢࠛ࡝ߩࠣ࡞࡯ࡊൻ
SQL ࠢࠛ࡝ߩࠣ࡞࡯ࡊൻࠍ೑↪ߔࠆߣዻᕈ୯ߢ૶ࠊࠇߡ޿ࠆᖱႎߩ⒳㘃ࠍ⍮ࠆߎߣ߇ߢ߈߹ߔ‫ ࠬ࡯࠰࠲࡯࠺ޕ‬map25k_vec ౝߩ࠺࡯࠲࠮࠶࠻౏౒ᣉ⸳ߢߪࡈࠖ࡯࡞࠼ Shurui ߦࡐࠗࡦ࠻࠺
࡯࠲ߩ⒳೎߇⸥౉ߐࠇߡ޿߹ߔ߇㧘ߤߩࠃ߁ߥ⒳㘃ߦ඙ಽߐࠇߡ޿ࠆ߆⍮ࠆߦߪ࠺࡯࠲ᢙ߇ᄙߊ
࿎㔍ߢߔ‫ߥ߁ࠃߩߎޕ‬႐ว㧘ࠣ࡞࡯ࡊൻࠍ೑↪ߔࠆߣߘߩ⒳㘃ࠍ⍮ࠆߎߣ߇ኈᤃߦߥࠅ߹ߔ‫ޕ‬ࡈࠖ࡯࡞࠼ฬߦ‫౒౏ޡ‬ᣉ⸳.Shurui‫ޢ‬㧘ࠣࠣߎߩ଀ߢߪࡈࠖ࡯࡞࠼ Shurui ߩߺ૶↪ߒ߹ߔߩߢ㧘ࡈ࡞࡯ࡊൻ㗄⋡ߦ‫౒౏ޡ‬ᣉ⸳.Shurui‫౉ߣޢ‬ജߒ㧔࿑㧝㧙13㧕㧘SQL ᬌ⚝ࠍታⴕߒ߹ߔ‫ޕ‬ᬌ⚝⚿ᨐߪ㧔࿑㧝㧙14㧕ࡈࠖ࡯࡞࠼ Shurui ߦߤߩࠃ߁ߥ୯߇೑↪ߐࠇߡ޿ࠆ߆ࠍ␜ߔ৻ⷩ⴫ߣߥࠅ߹ߔ‫ޕ‬ ߹ߚ㧘ࠣ࡞࡯ࡊൻࠍ೑↪ߔࠆߣ㓸⸘߇ⴕ߃߹ߔ‫ޕ‬㓸⸘ߥߤߩ⛔⸘ಣℂߪ‫ޡ‬㓸ว㑐ᢙ‫ࠅࠃޢ‬ㆬᛯ౉ജน⢻ߢ㧘଀߃߫⒳㘃ߏߣߩࠝࡉࠫࠚࠢ࠻୘ᢙࠍ⸘᷹ߒߚ޿႐วߪ㧘⸳ቯ࠙ࠖࡦ࠼࠙ߩࡈࠖ࡯
ࠣ࡞࡞࠼ฬߦ count()㑐ᢙࠍㅊടߒ‫౒౏ޟ‬ᣉ⸳.Shurui,Count(*) As ୘ᢙ‫౉ߣޠ‬ജߒ߹ߔ‫ߚ߹ޕ‬㧘ࠣ࡯ࡊൻ㗄⋡ߪ‫౒౏ޡ‬ᣉ⸳.Shurui‫ޕߔ߹ߒߣޢ‬㧔࿑㧝㧙25㧕 ᬌ⚝ታⴕᓟ㧘⚿ᨐ৻ⷩ⴫߇⴫␜ߐࠇ߹ߔ‫ޕ‬㧔࿑㧝㧙26㧕
㧣㧚㧿㧽㧸ࠢࠛ࡝ࠍ೑↪ߒߚ⛔⸘⸘▚ SQL ࠢࠛ࡝ߩ㓸ว㑐ᢙࠍ೑↪ߔࠆߣ㧘㓸⸘ߥߤߩ⛔⸘⸘▚ࠍⴕ߁ߎߣ߇ߢ߈߹ߔ‫ߪߢߎߎޕ‬㧘࠺࡯࠲࠰࡯ࠬ⛔
⛔⸘ౝߩ࠺࡯࠲࠮࠶࠻ okinawa_D ࠍ૶↪ߒߚ଀ࠍ૶ߞߡ⸃⺑ߒ߹ߔ‫ޕ‬଀㧢㧚㧞㧜㧜㧜ᐕߩੱญ࠺࡯࠲ࠃࠅ㧘࠺࡯࠲୘ᢙ㧘ᦨᄢ୯㧘ᦨዊ୯㧘ว⸘ࠍ▚಴‫ޕ‬ࡈࠖ࡯࡞࠼ฬߦᔅⷐߥᢙᑼࠍ⸥౉ߔࠆߎߣߣߥࠅ߹ߔ‫ޕ‬ ⛔⸘⸘▚╬ࠍⴕ߁႐ว㧘㧮ࠛ࡝ࠕߩࡈ Ԙ୘ᢙߩࠞ࠙ࡦ࠻㧦㓸ว㑐ᢙ৻ⷩ㧔ٕࠃࠅ㧕߆ࠄ Count ࠍㆬᛯߒ߹ߔ‫ޕ‬ ԙࡈࡈࠖ࡯࡞࠼ฬߦ Count㧔㧕߇౉ജߐࠇ߹ߔ‫ޕ‬㧔㧕ౝߦ⒖േߒ㧘ࡈࠖ࡯࡞࠼ᖱႎ߆ࠄ okinawa_D.Name ㆬᛯߒ߹ߔ‫ߩߎޕ‬ᠲ૞ Ԛࠞ࡯࠰࡞ࠍ㧔ߢ Count(okinawa_D.Name)ߣߥࠅ߹ߔ‫ޕ‬ ԛ୘ᢙ⸘▚⚿ᨐߩࡈࠖ࡯࡞࠼ฬࠍ̌୘ᢙ̍ߣߔࠆߚ߼㧘⛯ߌߡ‫ ޡ‬as ୘ᢙ‫౉ߣޢ‬ജߒ߹ߔ‫ޕ‬ࡈࠖ࡯࡞࠼ฬߦ౉ജߐࠇߚᢥ Ԝห᭽ߦ Max㧘Min㧘Sum 㑐ᢙߣࡈࠖ࡯࡞࠼ฬࠍ⸳ቯߒ߹ߔ‫ࡈޕ‬ሼ೉ߪએਅߩㅢࠅߦߥࠅ߹ߔ‫ޡޕ‬㧘‫ߢޢ‬඙ಾߞߡㅪ⛯ߒߡ⸥౉ߒߡߊߛߐ޿‫ޕ‬Count(okinawa_D.Name) as ୘ᢙ,
Max (okinawa_D.pop2000) as ᦨᄢ,Min(okinawa_D.pop2000) as ᦨዊ,Sum(okinawa_D.pop2000) as ว⸘ ‫ޡ‬SQL ࠢࠛ࡝‫⸳ޢ‬ቯߪ࿑㧝㧙15 ߦ␜ߔㅢࠅߢߔ‫ޕ‬ಣℂᓟ㧘▚಴⚿ᨐ߇৻ⷩ⴫ߣߒߡ⴫␜ߐࠇ
߹ߔ‫ޕ‬㧔࿑㧝㧙16㧕 ‫ޡ‬SQL ࠢࠛ࡝‫ߢޢ‬೑↪น⢻ߥ㓸⸘㑐ᢙ㧔⛔⸘㧕ߪ࿑㧝㧙17 ߩߣ߅ࠅߢߔ‫ޕ‬ਥߥ㑐ᢙߪ㧘
 Avg㧦ᐔဋ㧘Count㧦୘ᢙ㧘Max㧦ᦨᄢ୯㧘Min㧦ᦨዊ୯㧘Sum㧦㓸⸘ߣߥߞߡ޿߹ߔ‫ޕ‬଀㧣㧚㧝㧥㧣㧜߆ࠄ㧞㧜㧜㧜ᐕߩੱญჇട₸ࠍᏒ↸᧛ߏߣߦ▚಴‫ޕ‬ ࡈࠖ࡯࡞࠼ฬ߳ߩ▚ⴚᑼߩ౉ജߦࠃࠅ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧝㧙18㧕 ԘᏒ↸᧛ߏߣߩ⸘▚⚿ᨐߢ޽ࠆߚ߼㧘╙㧝ࡈࠖ࡯࡞࠼ߦᏒ↸᧛ฬ⴫␜ߩ߼ߦ okinawa_D.Nameࠍ౉ജߒ߹ߔ‫ޡߢߩߔ߹߈⛯߇࠼࡞࡯ࠖࡈߦࠄߐޕ‬㧘‫ޕߔ߹ࠇ౉ࠍޢ‬ ԙࡈࡈࠖ࡯࡞ᖱႎߣṶṶ▚ሶࠍ೑↪ߒߡ▚ⴚᑼࠍ౉ജߒ߹ߔ‫ޕ‬  (okinawa_D.P2000 - okinawa_D.P1970)/ okinawa_D.P1970 Ԛ⸘▚⚿ᨐߩࡈࠖ࡯࡞࠼ฬࠍჇട₸ߣߔࠆߚ߼㧘ᒁ߈⛯߈‫ޡ‬as Ⴧട₸‫౉ޢ‬ജߒ߹ߔ‫ޕ‬ ԛჇട₸ߩᄢ߈޿㗅ߦਗߴᦧ߃ࠆߚ߼㧘ਗਗߴᦧ߃ߦԙߢ૞ᚑߒߚᢙᑼࠍ౉ജߒ߹ߔ‫ޕ‬㧔ࠦࡇ࡯㧒ࡍ࡯ࠬ࠻น⢻㧕ߐࠄߦ㒠㗅࡜ࠫࠝࡏ࠲ࡦࠍ࠮࠶࠻ߒ߹ߔ‫ޕ‬ ‫ޡ‬SQL ࠢࠛ࡝‫ޢ‬ಣℂᓟ㧘▚಴⚿ᨐ߇৻ⷩ⴫ߣߒߡ⴫␜ߐࠇ߹ߔ‫ޕ‬㧔࿑㧝㧙19㧕
 SQL ࠢࠛ࡝ߩ㓸ว㑐ᢙߣࠣ࡞࡯ࡊൻࠍ⚵ߺวࠊߖࠆߎߣߦࠃߞߡ㧘㗄⋡ߏߣߦ㓸⸘ߥߤߩ⛔⸘⸘▚ࠍⴕ߁ߎߣ߇ߢ߈߹ߔ‫ޕ‬଀㧤㧚㧝㧥㧣㧜ᐕߣ㧞㧜㧜㧜ᐕੱญࠍᏒㇱ㧘↸ㇱ㧘᧛ㇱߏߣߦ㓸⸘‫ޕ‬ ࡈࠖ࡯࡞࠼ฬ߳ߩ▚ⴚᑼߩ౉ജߦࠃࠅ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧝㧙20㧕 ԘᏒㇱ㧘↸ㇱ㧘᧛ㇱߏߣߩ㓸⸘ߢ޽ࠆߚ߼㧘Ꮢ↸᧛ฬ㧔Name ࡈࠖ࡯࡞࠼㧕ߩᧃየߩᢥሼ㧔Ꮢ࡮↸࡮᧛㧕ࠍಾࠅ಴ߔಣℂࠍᢥሼ೉㑐ᢙߢⴕ޿߹ߔ‫ޕ‬ᢥሼ೉㑐ᢙ Right ࠍㆬᛯߒ߹ߔ‫ޕ‬ࡈࠖ࡯࡞࠼ฬߦ Right㧔㧕߇౉ജߐࠇ߹ߔ‫ޕ‬ ԙࡈ
㧔㧕ౝߦ⒖േߒ㧘ࡈࡈࠖ࡯࡞࠼ᖱႎ߆ࠄ okinawa_D.Name ㆬᛯߒ߹ߔ‫ޕ‬ Ԛࠞ࡯࠰࡞ࠍ㧔  Right (okinawa_D.Name)ߣߥࠅ߹ߔ‫ޕ‬ ԛ⸘▚⚿ᨐߩࡈࠖ࡯࡞࠼ฬࠍ඙ಽߣߔࠆߚ߼㧘ᒁ߈⛯߈‫ ޡ‬as ඙ಽ‫౉ޢ‬ജߒ߹ߔ‫ޕ‬ࡈࠖ࡯࡞࠼ᖱႎࠍ૶ߞߡ㧘 Ԝ㧝㧥㧣㧜ᐕߣ㧞㧜㧜㧜ᐕߩੱญ㓸⸘ࠍⴕ߁ߚ߼ Sum 㑐ᢙߣࡈ  Sum㧔okinawa_D.p1970㧕ߣ Sum㧔okinawa_D.p2000㧕ࡈࠖ࡯࡞࠼ࠍㅊടߒ߹ߔ‫ޕ‬ ԝᏒㇱ㧘↸ㇱ㧘᧛ㇱߏߣߩ㓸⸘ߩߚ߼㧘ࠣࠣ࡞࡯ࡊൻ߳Ԛߢ૞ᚑߒߚᢙᑼࠍ౉ജߒ߹ߔ‫ޕ‬㧔ࠦࡇ࡯㧒ࡍ࡯ࠬ࠻น⢻㧕 ‫ޡ‬SQL ࠢࠛ࡝‫ޢ‬ಣℂᓟ㧘▚಴⚿ᨐ߇৻ⷩ⴫ߣߒߡ⴫␜ߐࠇ߹ߔ‫ޕ‬㧔࿑㧝㧙21㧕ዻᕈ৻ⷩ⴫ߩ೑↪
 ࡌࠢ࠻࡞࠺࡯࠲࠮࠶࠻ߪ࿑ᒻᖱႎߣዻᕈᖱႎࠍ᦭ߒߡ޿߹ߔ‫ߚ߹ޕ‬㧘SuperMap ߢߪ࿑ᒻᖱႎ
ࠍ઻ࠊߥ޿ዻᕈᖱႎ߆ࠄߥࠆዻᕈ࠺࡯࠲࠮࠶࠻߽޽ࠅ߹ߔ‫ߩࠄࠇߎޕ‬ዻᕈᖱႎ࡮࠺࡯࠲࠮࠶࠻ߪ
ߪ৻ⷩ⴫ߣߒߡ⴫␜ߢ߈ࠆ߶߆㧘ࡈࠖ࡯࡞࠼ࠍ૶ߞߚ⸘▚߿㑐ᢙࠍ૶ߞߚ⸘▚ࠍⴕ߁ߎߣ߇ߢ߈
߹ߔ‫ߚ߹ޕ‬㧘࠺࡯࠲ࡌ࡯ࠬᒻᑼߩ࠺࡯࠲ߣߒߡࠛࠢࠬࡐ࡯࠻߽น⢻ߢߔߩߢ㧘ઁߩ࠰ࡈ࠻ߦⓨ㑆ಽᨆߒߚ࠺࡯࠲ࠍᷰߔߎߣ߇น⢻ߢߔ‫ޕ‬ ዻᕈ৻ⷩ⴫ࠍ૶ߞߚᠲ૞ߪ‫ޡ‬SQL ࠢࠛ࡝‫ߚߞ૶ࠍޢ‬ዻᕈಣℂߦᲧߴ◲නߢߔߩߢ㧘ߗ߭ߘߩᠲ
૞ߦᘠࠇߡߊߛߐ޿‫ޕ‬એਅ㧘࠺࡯࠲࠰࡯ࠬ map25k_vec ࠍኻ⽎ߦታ㓙ߩ೑↪଀ࠍㅢߓߡ⸃⺑ߒ߹ߔ‫ޕ‬‫ޣ‬ᵈᗧ‫ޤ‬ዻᕈ৻ⷩ⴫ߩᠲ૞ߪ Viewer ߢߪⴕ߃߹ߖࠎ߇㧘SuperMap ߩዻᕈ࠺࡯࠲ߪ࠺࡯࠲ࡌ࡯
ࠬ♽࠰ࡈ࠻ߢ⋥ធ೑↪ߔࠆߎߣ߇น⢻ߢߔ‫ޕ‬㧝㧚ዻᕈ৻ⷩ⴫ߩ⴫␜ߣ⺞ᢛ ࠺࡯࠲࠰࡯ࠬࠍ㐿߈㧘ࡢ࡯ࠢࠬࡍ࡯ࠬ࠙ࠖࡦ࠼࠙ߩኻ⽎࠺࡯࠲࠮࠶࠻ࠍฝࠢ࡝࠶ࠢߢ㧘‫ޡ‬ዻᕈ࠺
࡯࠲ߩ⴫␜‫ߢޢ‬㧘ዻᕈ৻ⷩ⴫߇㐿߈߹ߔ‫ޕ‬ዻᕈ⴫ߩ SmID㧘࡜ࠗࡦ࠺࡯࠲࠮࠶࠻ߩ SmLength㧘ࡐ࡝ࠧࡦ࠺࡯࠲࠮࠶࠻ SmArea ߣ SmPerimeter ߪ㧘ౝㇱዻᕈ୯ߢ SuperMap ߇⥄േ⊛ߦઃടߔࠆዻᕈߢߔ‫ޕ‬SmID ߪࠝࡉࠫࠚࠢ࠻ߩ࡙࠾࡯ࠢࠦ࡯࠼㧘SmLength ߪ࡜ࠗࡦࠝࡉࠫࠚࠢ࠻㐳㧘
SmArea ߣ SmPerimeter ߪࡐ࡝ࠧࡦࠝࡉࠫࠚࠢ࠻㕙Ⓧߣ๟࿐㐳ߣߥߞߡ޿߹ߔ‫ޕ‬㧔㧝㧕⴫␜ߩ⺞ᢛ ዻᕈ৻ⷩ⴫⴫␜࠙ࠖࡦ࠼࠙਄ᚗ޿ߪࡈࠖ࡯࡞࠼ฬ⴫␜ㇱಽߢߩฝࠢ࡝࠶ࠢߢ㐿ߊࠨࡉࡔ࠾ࡘ࠙
߆ࠄ⴫␜೉᏷⺞ᢛ߇น⢻ߢߔ‫ߚ߹ޕ‬㧘ࡈࠖ࡯࡞࠼ฬ⴫␜ㇱಽߩႺ⇇✢ߩ࠼࡜࠶ࠣേ૞ߦࠃࠅࡈࠖ
࡯࡞࠼᏷߇ᄌᦝߢ߈߹ߔ‫ޕ‬㧔㧞㧕࡟ࠦ࡯࠼㧘ࡈࠖ࡯࡞࠼ߩㆬᛯ ዻᕈ৻ⷩ⴫߆ࠄ࡟ࠦ࡯࠼ࠍㆬᛯ㧔ⶄᢙ߽น㧕ߔࠆ੐߇น⢻ߢߔ‫ߩߎޕ‬ᠲ૞ߢㆬᛯߐࠇߚ࡟ࠦ࡯
࠼߇ᄌᦝ㧘଻ሽ㧘⛔⸘⸘▚ߩኻ⽎ߦߥࠅ߹ߔ‫ޕ‬ㆬᛯߐࠇߡ޿ߥ޿႐วߪో૕߇ኻ⽎ߦߥࠅ߹ߔ‫ޕ‬߹ߚ㧘ฦ࠮࡞ߩㆬᛯߪዻᕈ୯ߩ✬㓸ߢ૶ߞߡ޿߹ߔߩߢߎߎߢߪขࠅ޽ߍ߹ߖࠎ‫ޕ‬ ࡟ࠦ࡯࠼ㆬᛯߩᣇᴺߪએਅߩㅢࠅߢߔ‫ޕ‬ Ԙන⁛࡟ࠦ࡯࠼ㆬᛯ㧦࡟ࠦ࡯࠼⇟ภࠍࠢ࡝࠶ࠢߒ߹ߔ‫ޕ‬㧔࿑㧞㧙㧟㧕 ԙㅪ⛯࡟ࠦ࡯࠼ㆬᛯ㧦ㆬᛯ㐿ᆎߔࠆ࡟ࠦ࡯࠼ࠍㆬᛯᓟ㧘ㅪ⛯⚳ὐߩ࡟ࠦ࡯࠼ࠍ㧘Shift ࠠ࡯ࠍ᛼ߒߥ߇ࠄࠢ࡝࠶ࠢߒ߹ߔ‫ߪߚ߹ޕ‬㧘ㅪ⛯ᜰቯߒߚ޿࡟ࠦ࡯࠼▸࿐㧔࡟ࠦ࡯࠼⇟ภ㧕ࠍ࠼࡜࠶ࠣ
ߒ߹ߔ‫ޕ‬㧔࿑㧞㧙㧠㧕 Ԛⶄᢙ࡟ࠦ࡯࠼ㆬᛯ㧦࡟ࠦ࡯࠼ࠍ㧘Cerl ࠠ࡯ࠍ᛼ߒߥ߇ࠄࠢ࡝࠶ࠢߒ߹ߔ‫ޕ‬㧔࿑㧞㧙㧡㧕߹ߚ㧘ߎߩ⁁ᘒߢㆬᛯߒߚ࡟ࠦ࡯࠼ࠍࠢ࡝࠶ࠢߔࠆߣㆬᛯ⸃㒰ߢ߈߹ߔ‫ޕ‬ ࡈࠖ࡯࡞࠼ߩㆬᛯߪ㧘ࡈࠖ࡯࡞࠼ో૕ࠍㆬᛯߔࠆ႐วߪࡈࠖ࡯࡞࠼ฬ⒓ࠍ㧘ㇱಽ⊛ߦㆬᛯߔࠆ
႐วߪ࡟ࠦ࡯࠼ㆬᛯߣห᭽ߦᔅⷐߥ࠮࡞ࠍㆬᛯߒߡߊߛߐ޿‫ޕ‬㧔࿑㧞㧙㧢㧕㧔㧟㧕࡟ࠦ࡯࠼ߩਗߴᦧ߃ ዻᕈ৻ⷩ⴫ߪᜰቯߐࠇߚࡈࠖ࡯࡞࠼ࠍࠠ࡯ߦ㧘᣹㗅࡮㒠㗅ߦਗߴᦧ߃ߡ⴫␜ߔࠆߎߣ߇น⢻ߢߔ‫ޕ‬ᠲ૞ᣇᴺߪዻᕈ৻ⷩ⴫ᦨ਄Ბߩࡈࠖ࡯࡞࠼ࠍㆬᛯߒ㧘ฝࠢ࡝࠶ࠢ߆ࠄ‫ޡ‬᣹㗅࠰࡯࠻‫ޢ‬ᚗ޿ߪ‫ޡ‬㒠㗅࠰࡯࠻‫ޕߔ߹ߒࠢ࠶࡝ࠢࠍޢ‬㧔࿑㧞㧙㧣㧘㧤㧕

㧞㧚ࡈࠖ࡯࡞࠼ߩᦝᣂ ዻᕈ৻ⷩ⴫ࠍ೑↪ߒߡ㧘ࡈࠖ࡯࡞࠼ߩᦝᣂ߇น⢻ߢߔ‫ߩ࠼࡯ࠦ࡟ޕ‬ㆬᛯߣ૬↪ߔࠆߣᜰቯߐࠇ
ߚ࡟ࠦ࡯࠼ߛߌࠍᄌᦝߔࠆߎߣ߽น⢻ߢߔ‫ߚ߹ޕ‬㧘ᣂⷙߦ࡟ࠦ࡯࠼ㅊടࠍⴕߞߡ߅ߌ߫㧘ઁߩࡈࠖ࡯࡞࠼߆ࠄߩ⸘▚୯߿㑐ᢙߦࠃࠆ୯╬ࠍㅊടߔࠆߎߣ߇น⢻ߢߔ‫ޕ‬ એਅ㧘଀ࠍ૶ߞߡࡈࠖ࡯࡞࠼ᦝᣂࠍ⸃⺑ߒ߹ߔ‫ޕ‬㧔㧝㧕㕙Ⓧߩౣ⸘▚ SmArea㧔SdAreaBL㧕ߪㅢᏱটන૏ߢᏒ↸᧛㕙Ⓧ╬ߢߪᢙ୯߇ᄢ߈ߔ߉߹ߔ‫ߢߎߘޕ‬㨗㨙㧞න૏ߦౣ⸘▚ߒ㧘ᣂߒ޿ࡈࠖ࡯࡞࠼ߦ଻ሽߒ߹ߔ‫ޕ‬⛔⸘ౝߩ࠺࡯࠲࠮࠶࠻ okinawa_D ߦࡈࠖ࡯࡞࠼㕙Ⓧ km ࠍㅊടߒ߹ߔ‫ࠖࡈޕ‬ Ԙ࠺࡯࠲࠰࡯ࠬ⛔
࡯࡞࠼ဳߪ‫ޡ‬୚♖ᐲဳ‫⸳ߦޢ‬ቯߒ߹ߔ‫ޕ‬ ԙࡈࠖ࡯࡞࠼㕙Ⓧ km ࠍㆬᛯߒ㧘ฝࠢ࡝࠶ࠢ߆ࠄ‫ᦝߩ࠼࡞࡯ࠖࡈޡ‬ᣂ‫߳ޢ‬ㅴߺ߹ߔ‫ޕ‬ Ԛ‫ᦝߩ࠼࡞࡯ࠖࡈޡ‬ᣂ‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔߩߢ㧘ࡄ࡜ࡔ࡯࠲ࠍ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧞㧙10㧕ԛᦝᣂ▸࿐㧦‫࠼࡞࡯ࠖࡈޡ‬ฬߢᜰቯ‫ޡߪߚ߹ޢ‬ㆬᛯߐࠇߚ࡟ࠦ࡯࠼‫ࠍޢ‬ㆬ߮߹ߔ‫ޕ‬‫࡞࡯ࠖࡈޡ‬࠼ฬߢᜰቯ‫ో࠼࡞࡯ࠖࡈߪߢޢ‬૕߇ኻ⽎ߣߥࠅ߹ߔ߇㧘‫ޡ‬ㆬᛯߐࠇߚ࡟ࠦ࡯࠼‫ߪߢޢ‬ㆬᛯߒߚ࡟ࠦ࡯࠼ߩߺ߇ᦝᣂኻ⽎ߣߥࠅ߹ߔ‫ޕ‬Ԝࡈࠖ࡯࡞࠼ฬ㧦ᦝᣂኻ⽎ߣߥࠆࡈࠖ࡯࡞࠼ࠍㆬᛯߒ߹ߔ‫ޕ‬
ԝᦝᣂᣇᴺ㧦
‫ޡ‬ቯᢙ‫ޢ‬㧘‫ޡ‬㧝ߟߩࡈࠖ࡯࡞࠼ߢ⸘▚‫ޢ‬㧘‫ޡ‬㧞ߩࡈࠖ࡯࡞࠼ߢ⸘▚‫ޢ‬㧘‫ޡ‬㑐ᢙ‫ޢ‬ㆬᛯน⢻ߢߔ‫੹ޕ‬࿁ߪ‫ޡ‬㧝ߟߩࡈࠖ࡯࡞࠼ߢ⸘▚‫ޕߔ߹ߒߣޢ‬Ԟ⸘▚㧦⸘▚ኻ⽎ࡈࠖ࡯࡞࠼ࠍㆬᛯߒ߹ߔ‫ޕ‬SmArea㧔SdAreaBL㧕ࠍᜰቯߒ߹ߔ‫ޕ‬ԟ⸘▚ᣇᴺ㧦྾ೣṶ▚ߩ޿ߕࠇ߆ߩㆬᛯߣߥࠅ߹ߔ‫ޕ‬Ԡ⸘▚࿃ሶ㧦਄⸥Ṷ▚ሶࠍ૶ߞߡṶ▚ߔࠆቯᢙ߿ଥᢙࠍਈ߃߹ߔ‫੹ޕ‬࿁ߪන૏឵▚ߩߚ߼ߦ
1000000 ࠍ౉ജߒ㧘‫ޡ‬SmArea㧔SdAreaBL㧕/1000000‫ޕߔ߹޿ⴕࠍ▚⸘߁޿ߣޢ‬ ԡㆡ↪ࡏ࠲ࡦࠍ᛼ߔߣࡈࠖ࡯࡞࠼୯߇ᦝᣂߐࠇ߹ߔ‫ޕ‬㧔࿑㧞㧙11㧕‫ޣ‬ᵈᗧ‫✲ޤ‬ᐲ⚻ᐲᐳᮡߢ૞ᚑߐࠇߚࡐ࡝ࠧࡦ࠺࡯࠲࠮࠶࠻ߩฦࠝࡉࠫࠚࠢ࠻㕙Ⓧࠍᩰ⚊ߔࠆ
SmArea ߩන૏ߪᐲ㧞ߣߥߞߡ޿ࠆ႐ว߇޽ࠅ߹ߔ‫ߩߎޕ‬႐วߪࡔ࠾ࡘ࡯ߩ‫ޢ࠻࠶࠮࠲࡯࠺ޡ‬㧛‫✲ޡ‬ᐲ⚻ᐲ㕙Ⓧ⸘▚‫ߦޢ‬ㅴߺ㧘㕙Ⓧࠍটන૏ߦౣ⸘▚ߔࠆᔅⷐ߇޽ࠅ߹ߔ‫ߪߢ଀ߩߎޕ‬㧘SmArea
ߪᐲ㧞න૏ߣߥߞߡ޿ࠆߚ߼㧘ߎߩಣℂߦࠃࠅটන૏ߩ࠺࡯࠲ࠍࡈࠖ࡯࡞࠼ SdAreaBL ߦ಴ജߒ೑↪ߒ߹ߒߚ‫ޕ‬㧔㧞㧕ࡐࠗࡦ࠻ࠝࡉࠫࠚࠢ࠻૏⟎ᐳᮡߩㅊട ࠺࡯࠲࠮࠶࠻ߩࡐࠗࡦ࠻ࠝࡉࠫࠚࠢ࠻૏⟎ᐳᮡࠍ৻ⷩ⴫ߦ಴ജߒ߹ߔ‫ᦝߩ࠼࡞࡯ࠖࡈޕ‬ᣂಣℂߪ㧝ߟߩࡈࠖ࡯࡞࠼ኻ⽎ߣߥࠅ߹ߔߩߢ㧘㨤࡮㨥ᐳᮡࠍ಴ജߔࠆ႐วߪ㧞࿁ߩಣℂ߇ᔅⷐߦߥࠅ߹ߔ‫ޕ‬ Ԙ౏౒ᣉ⸳ߦࡈࠖ࡯࡞࠼㨤ߣ㨥ࠍㅊടߒ߹ߔ‫ޡߪဳ࠼࡞࡯ࠖࡈޕ‬୚♖ᐲဳ‫⸳ߦޢ‬ቯߒ߹ߔ‫ޕ‬ ԙ‫ᦝߩ࠼࡞࡯ࠖࡈޡ‬ᣂ‫ߦޢ‬ㅴߺ㧘࠙ࠖࡦ࠼࠙ߦߡࡄ࡜ࡔ࡯࠲ࠍ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧞㧙1㧞㧕⸳ቯ
ᣇᴺߪ‫ޡ‬㧔㧝㧕㕙Ⓧߩౣ⸘▚‫ߣޢ‬ห᭽ߢߔ߇㧘‫ᦝޡ‬ᣂᣇᴺ‫⸳ߩޢ‬ቯᣇᴺߦ㆑޿߇޽ࠅ߹ߔ‫ޕ‬
Ԛᦝᣂᣇᴺ㧦‫ޡ‬㑐ᢙ‫ޢ‬ㆬᛯߒ߹ߔ‫ޕ‬ԛ㑐ᢙߣߒߡࡐࠗࡦ࠻ࠝࡉࠫࠚࠢ࠻૏⟎ᐳᮡࠍਈ߃ࠆ ObjCenterX ߣ ObjCenterY ࠍ૶↪ߒ߹ߔ‫ࠇߙࠇߘޕ‬㨤ᐳᮡ㧘㨥ᐳᮡࠍਈ߃ࠆ㑐ᢙߢߔ‫ޕ‬ Ԝㆡ↪ࡏ࠲ࡦࠍ᛼ߔߣࡈࠖ࡯࡞࠼୯߇ᦝᣂߐࠇ߹ߔ‫ޕ‬ ԝ߽߁৻ᣇߩᐳᮡߦߟ޿ߡ߽ห᭽ߩಣℂࠍ➅ࠅ㄰ߒ߹ߔ‫ޕ‬㧔࿑㧞㧙13㧕㧔㧟㧕ࡈࠖ࡯࡞࠼୯ߩᄌᦝ ਄⸥ߩࡈࠖ࡯࡞࠼ᦝᣂߩࠃ߁ߦ㧘ኻ⽎ࠍࡈࠖ࡯࡞࠼ߣߒߚ႐วߪࡈࠖ࡯࡞࠼ౝߩోߡߩ࠺࡯࠲
ࠍᄌᦝߒ߹ߔ߇㧘ㆬᛯߒߚ࡟ࠦ࡯࠼ߛߌࠍࡈࠖ࡯࡞࠼ᦝᣂߔࠆߎߣ߽น⢻ߢߔ‫߫߃଀ޕ‬㧘࠺࡯࠲ቇᩞߦ߅޿ߡ㧘ዊቇᩞߩࡈࠖ࡯࡞࠼ Shurui ߩዻᕈ୯ࠍ‫ޡ‬ዊቇᩞ‫ߦޢ‬ᄌᦝߒ߹ߔ‫ޕ‬࠮࠶࠻ቇ Ԙ‫࠼࡯ࠦ࡟ޡ‬ㆬᛯ‫ޢ‬ᣇᴺߢ㧘ቇᩞฬ㧔Namae㧕߇‫ޟ‬ዊቇᩞ‫ ࠼࡞࡯ࠖࡈࠍߩ߽ࠆ޽ߢޠ‬Shuruiߢᜰቯߒ߹ߔ‫ޕ‬㧔࿑㧞㧙14㧕 ԙ‫ᦝߩ࠼࡞࡯ࠖࡈޡ‬ᣂ‫ߦޢ‬ㅴߺ㧘࠙ࠖࡦ࠼࠙ߦߡࡄ࡜ࡔ࡯࠲ࠍ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧞㧙15㧕Ԛᦝᣂ▸࿐㧦‫ޡ‬ㆬᛯߐࠇߚ࡟ࠦ࡯࠼‫ࠍޢ‬ㆬᛯߒ߹ߔ‫ޕ‬
ԛᦝᣂᣇᴺ㧦‫ޡ‬ቯᢙ‫ޢ‬ㆬᛯߒ߹ߔ‫ޕ‬Ԝቯᢙߣߒߡ‫ޡ‬ዊቇᩞ‫౉ߣޢ‬ജߒ߹ߔ‫ޕ‬ Ԝㆡ↪ࡏ࠲ࡦࠍ᛼ߔߣࡈࠖ࡯࡞࠼୯߇ᦝᣂߐࠇ߹ߔ߇㧘ㆬᛯߐࠇߚㇱಽߛߌߩᦝᣂߦߥߞߡ޿
߹ߔ‫ޕ‬㧔㧠㧕ᬌ⚝ߣ⚵ߺวࠊߖߚࡈࠖ࡯࡞࠼୯ߩᄌᦝ
 SQL ᬌ⚝⚿ᨐࠍ೑↪ߒߡࡈࠖ࡯࡞࠼୯ࠍᦝᣂߔࠆߎߣ߇ߢ߈߹ߔ‫࠻࠶࠮࠲࡯࠺ߡߒߣ଀ޕ‬ቇቇᩞߦ߅޿ߡ㧘ਛቇᩞߩ Shurui ߩዻᕈ୯ࠍ‫ޡ‬ਛቇᩞ‫ߦޢ‬ᄌᦝߒ߹ߔ‫ޕ‬ቇᩞ߆ࠄᬌ⚝ߒ߹ߔ‫ᤨߩߎޕ‬㧘‫ޡ‬ዻᕈ⴫ ԘSQL ࠢࠛ࡝ࠍ૶ߞߡ㧘ਛቇᩞ࠺࡯࠲ࠍ࠺࡯࠲࠮࠶࠻ቇ
ߦࠢࠛ࡝⚿ᨐࠍ⴫␜‫ޕߔ߹ࠇ౉ࠍࠢ࠶ࠚ࠴ߦޢ‬㧔ࠢࠛ࡝⚿ᨐ଻ሽߦߪ࠴ࠚ࠶ࠢࠍ౉ࠇࠆᔅⷐߪ޽ࠅ
߹ߖࠎ‫ޕ‬㧕㧔࿑㧞㧙16㧕ቇᩞߩዻᕈߩ৻ㇱ㧔ᬌ⚝⚿ᨐ㧕 ԙᬌ⚝⚿ᨐ߇ዻᕈ৻ⷩ⴫ߦ⴫␜ߐࠇ߹ߔ߇㧘ߎࠇߪ࠺࡯࠲࠮࠶࠻ቇ
㧔࿑㧞㧙17㧕
ߩ⴫␜ߣߥߞߡ޿߹ߔ‫ޕ‬SmID ࠍ⏕⹺ߔࠆߣ⇟ภ߇ㅪ⛯ߒߡ޿ߥ޿ߩ߇ࠊ߆ࠅ߹ߔ‫ޕ‬ Ԛߎߩዻᕈ৻ⷩ⴫ߦ߅޿ߡࡈࠖ࡯࡞࠼ᦝᣂࠍⴕ޿߹ߔ‫ߦ࠼࡞࡯ࠖࡈޕ‬ኻߔࠆᦝᣂࠍⴕߞߡ߽ᦝ
ቇᩞߩዻᕈߩ৻ㇱߦߥࠅ߹ߔ‫ޕ‬Shurui ߩዻᕈ୯ࠍ‫ޡ‬ਛቇᩞ‫ߦޢ‬ᄌᦝߒᣂߐࠇࠆߩߪ࠺࡯࠲࠮࠶࠻ቇ
߹ߔ‫ޕ‬㧔࿑㧞㧙18㧕 ԛߎߩዻᕈ৻ⷩ⴫ߢߪ Shurui ߩోߡߩዻᕈ୯߇‫ޡ‬ਛቇᩞ‫߇ߔ߹޿ߡߞߥߣޢ‬㧘࠺࡯࠲࠮࠶࠻
ቇᩞߩዻᕈ৻ⷩߢߪ৻ㇱಽߩߺ߇ᄌᦝߐࠇߡ޿߹ߔ‫ޕ‬㧔࿑㧞㧙19㧕ᬌ⚝ߣ⚵ߺวࠊߖߚࡈࠖ࡯࡞࠼୯ߩᄌᦝߪ SQL ࠢࠛ࡝એᄖߩⓨ㑆ᬌ⚝ߣ૬↪ߔࠆߎߣ߽ߢ߈
߹ߔ‫ޕ‬㧟㧚ࡈࠖ࡯࡞࠼ߩ⛔⸘ ዻᕈ৻ⷩ⴫ߩฦࡈࠖ࡯࡞࠼ߦߟ޿ߡ⛔⸘ಣℂ߇ⴕ߃߹ߔ‫ߡߒߣ଀ޕ‬㧘࠺࡯࠲࠰࡯ࠬ⛔
⛔⸘ౝߩ࠺࡯࠲࠮࠶࠻ okinawa_D ߦߟ޿ߡ⛔⸘ಣℂࠍⴕ޿߹ߔ‫ޕ‬ Ԙokinawa_D ߩዻᕈ৻ⷩ⴫ࠍ㐿߈㧘ฝࠢ࡝࠶ࠢ߆ࠄ‫ࠍޢ⸘⛔ߩ࠼࡞࡯ࠖࡈޡ‬ㆬᛯߒ߹ߔ‫ޕ‬ ԙ‫߇࠙࠼ࡦࠖ࠙ޢ⸘⛔ߩ࠼࡞࡯ࠖࡈޡ‬㐿߈߹ߔ‫ޕ‬㧔࿑㧞㧙20㧕
Ԛ⛔⸘ಣℂࠍⴕ޿ߚ޿ࡈࠖ࡯࡞࠼ࠍ‫⸘⛔ޡ‬రߩࡈࠖ࡯࡞࠼‫ࠅࠃⷩ৻ޢ‬㧪ࡏ࠲ࡦࠍ૶ߞߡ‫⛔ޡ‬⸘⚿ᨐߩࡈࠖ࡯࡞࠼‫ߦޢ‬⒖േߒ߹ߔ‫ޕ‬ԛ⛔⸘ࡏ࠲ࡦࠍ᛼ߔߣ‫⚿⸘⛔ޡ‬ᨐ‫ߦࠕ࡝ࠛ␜⴫ޢ‬ಣℂ⚿ᨐࠍ⴫␜ߒ߹ߔ‫ޕ‬㧔࿑㧞㧙21㧕 ߥ߅㧘ߎߩ⛔⸘ಣℂߪ㧘࡟ࠦ࡯࠼ࠍⶄᢙㆬᛯᓟⴕ߁ߣ㧘ㆬᛯߐࠇߚ࠺࡯࠲ߦߟ޿ߡߩߺ⛔⸘ಣ
ℂࠍⴕ޿㧘⚿ᨐࠍ⴫␜ߒ߹ߔ‫ޕ‬㧠㧚ዻᕈ৻ⷩࠍ૶ߞߚ࡟ࠦ࡯࠼ㆬᛯ଻ሽ ዻᕈ৻ⷩ⴫ࠃࠅ㧘ฝࠢ࡝࠶ࠢߢ‫଻ߦ࠻࠶࠮࠲࡯࠺ޡ‬ሽ‫ޡߪ޿ࠆ޽ޢ‬ዻᕈ࠹࡯ࡉ࡞ߦ଻ሽ‫࠺ߢޢ‬࡯࠲ࠍ଻ሽߔࠆߎߣ߇ߢ߈߹ߔ‫଻ޕ‬ሽಣℂࠍⴕ߁೨ߦ㧘࡟ࠦ࡯࠼ࠍⶄᢙㆬᛯߔࠆߣ㧘ㆬᛯߐࠇߚ

࡟ࠦ࡯࠼ߦߟ޿ߡߩߺ଻ሽߒ߹ߔ‫ࠄ߆࠻࠶࠮࠲࡯࠺ޕ‬ዻᕈ୯ߩ୯ߢ৻ㇱ࠺࡯࠲ࠍಽ㔌ߒ⸃ᨆߔࠆ
႐วߦଢ೑ߢߔ‫ޕ‬‫଻ߦ࠻࠶࠮࠲࡯࠺ޡ‬ሽ‫ߪޢ‬࿑ᒻᖱႎࠍ฽߼ߚ࠺࡯࠲ࠍ೎࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽߒ߹ߔ‫ޕ‬‫ޡ‬ዻᕈ࠹࡯ࡉ࡞ߦ଻ሽ‫ߪޢ‬ዻᕈᖱႎߛߌࠍዻᕈ࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽߒ߹ߔ‫ޕ‬ዻᕈ࠺࡯࠲࠮࠶࠻ߪ࠺
࡯࠲ࡌ࡯ࠬ࠰ࡈ࠻ᒻᑼߩࡈࠔࠗ࡞ߣߒߡࠛࠢࠬࡐ࡯࠻ߔࠆߎߣ߇ߢ߈㧘ઁߩ࠰ࡈ࠻ߢߩಽᨆߦ࠺
࡯࠲ࠍ೑↪ߢ߈߹ߔ‫ޕ‬ⓨ㑆ᬌ⚝㧝㧚ㆬᛯࠕࠗࠦࡦࠍ૶ߞߚⓨ㑆ᬌ⚝ ࡑ࠶ࡊߦ⴫␜ߐࠇߚ࠺࡯࠲࠮࠶࠻ߪ㧘ㆬᛯ࠷࡯࡞ࠍ૶ߞߡࠝࡉࠫࠚࠢ࠻ࠍㆬᛯߔࠆߎߣ߇ߢ߈
߹ߔ‫ߦࠄߐޕ‬㧘ߘߩ⚿ᨐߩ৻ⷩ⴫␜߿㧘ᣂߒ޿࠺࡯࠲࠮࠶࠻ߣߒߡ೑↪ߔࠆߎߣ߇น⢻ߢߔ‫ߎޕ‬ߎߢߪⓨ㑆ᬌ⚝ߩၮ␆ߢ޽ࠆࡑ࠶ࡊࠍ૶ߞߚᬌ⚝ࠍ⸃⺑ߒ߹ߔ‫ޕ‬SuperMap ߦߪ㧟⒳㘃ߩㆬᛯ࠷࡯࡞ࠕࠗࠦࡦ߇޽ࠅ߹ߔ‫ޕ‬㧝ߟߪ⋥ធࠝࡉࠫࠚࠢ࠻ࠍㆬᛯߔࠆ
࠷࡯࡞㧘ᱷࠅߪ▸࿐ࠍᜰቯߒߡߘߩਛߦ฽߹ࠇࠆࠝࡉࠫࠚࠢ࠻ࠍⶄᢙㆬᛯߢ߈ࠆ࠷࡯࡞ߢ㧘ߘࠇߙࠇ౞ᒻߣᄙⷺᒻߢ▸࿐ࠍᜰቯߒ߹ߔ‫ޕ‬㧔㧝㧕ࠝࡉࠫࠚࠢ࠻ߩㆬᛯ ࠝࡉࠫࠚࠢ࠻ㆬᛯ࠷࡯࡞ࠕࠗࠦࡦߦࠃࠅࡑ࠶ࡊ਄ߩࠝࡉࠫࠚࠢ࠻ࠍㆬᛯߢ
߈߹ߔ‫ᤨߩߎޕ‬㧘ㆬᛯߐࠇߚࠝࡉࠫࠚࠢ࠻ߪ㕖ㆬᛯࠝࡉࠫࠚࠢ࠻ߣߪ⇣ߥࠆࠬ࠲ࠗ࡞㧔⦡ᓀ㧕ߢ⴫⃻ߐࠇ߹ߔ‫ߚ߹ޕ‬㧘ߎߩࠝࡉࠫࠚࠢ࠻ࠍ࠳ࡉ࡞ࠢ࡝࠶ࠢߔࠆߎߣߢ㧘ዻᕈᖱႎࠍ㑛ⷩߢ߈߹ߔ‫ޕ‬㧔࿑㧟㧙㧝㧕
 SHIFT ࠠ࡯ࠍ᛼ߒߥ߇ࠄㆬᛯ࠷࡯࡞ࠍ೑↪ߔࠆߣⶄᢙߩࠝࡉࠫࠚࠢ࠻ࠍㆬᛯߔࠆ੐߇น⢻ߢߔ‫ޕ‬㧔࿑㧟㧙㧞㧕ⶄᢙࠝࡉࠫࠚࠢ࠻ㆬᛯᓟฝࠢ࡝࠶ࠢ߆ࠄ‫ޡ‬ዻᕈ‫ޢ‬ㆬᛯߢ㧘ㆬᛯⶄᢙࠝࡉࠫࠚࠢ࠻
ߩዻᕈ৻ⷩࠍ⴫␜ߐߖࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬㧔࿑㧟㧙㧟㧕㧔㧞㧕ㆬᛯࠝࡉࠫࠚࠢ࠻ߩ଻ሽ ࡑ࠶ࡊ਄ߢㆬᛯߒߚࠝࡉࠫࠚࠢ࠻ࠍᣂⷙߩ࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽߔࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬Ԙⶄᢙࠝࡉࠫࠚࠢ࠻ㆬᛯᓟ㧘ฝࠢ࡝࠶ࠢ߆ࠄ‫଻ߦ࠻࠶࠮࠲࡯࠺ޡ‬ሽ‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬ԙ‫଻ߦ࠻࠶࠮࠲࡯࠺ޡ‬ሽ‫ߩ࠙࠼ࡦࠖ࠙ޢ‬ฦ㗄⋡ࠍ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧟㧙㧠㧕Ԛᣂⷙߩ࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽߔࠆ႐วߪ㧘‫ޡ‬ᣂⷙ࠺࡯࠲࠮࠶࠻‫ߒࠢ࠶ࠚ࠴ߦޢ‬㧘࠺࡯࠲࠮࠶
࠻ฬࠍ౉ജߒ߹ߔ‫ⶄޕ‬ᢙߩ࠺࡯࠲࠰࡯ࠬࠍ㐿޿ߡ޿ࠆ႐ว㧘೎ߩ࠺࡯࠲࠰࡯ࠬౝߦ଻ሽߔࠆߎߣ
߽ߢ߈߹ߔ‫ޕ‬ԛOK ࡏ࠲ࡦࠍ᛼ߒ߹ߔ‫ޕ‬ ಣℂ⚳ੌᓟ㧘ࡢ࡯ࠢࠬࡍ࡯ࠬ࠙ࠖࡦ࠼࠙ߩ࠺࡯࠲࠰࡯ࠬ⛔
⛔⸘ౝߦ࠺࡯࠲࠮࠶࠻ query1 ߇↢ᚑߐࠇ߹ߔ‫ߦࠄߐޕ‬㧘ߘߩ࠺࡯࠲࠮࠶࠻ࠍࡑ࠶ࡊߢ⏕⹺ߔࠆߣ㧘ㆬᛯߒߚࠝࡉࠫࠚࠢ࠻ߩߺߢ޽ࠆ
ߎߣ߇ࠊ߆ࠅ߹ߔ‫ޕ‬㧔࿑㧟㧙㧡㧕 ߹ߚ㧘ⶄᢙࠝࡉࠫࠚࠢ࠻ㆬᛯᓟ㧘ዻᕈ࠹࡯ࡉ࡞৻ⷩ⴫ࠍ⴫␜ߐߖ㧘ฝࠢ࡝࠶ࠢ߆ࠄ‫ޡ‬ዻᕈ࠹࡯ࡉ࡞ߦ଻ሽ‫ߦޢ‬ㅴ߻ߣ㧘ㆬᛯߒߚࠝࡉࠫࠚࠢ࠻ߩዻᕈ࠹࡯ࡉ࡞ࠍዻᕈ࠺࡯࠲࠮࠶࠻ߣߒߡ↢ᚑߔࠆߎߣ߇น⢻ߢߔ‫଻ޕ‬ሽߩᲑ㓏ߢ଻ሽߔࠆࡈࠖ࡯࡞࠼ᜰቯ෸߮࠺࡯࠲࠮࠶࠻ฬ⒓ߩ⸳ቯࠍⴕߞߡ
ߊߛߐ޿‫ޕ‬㧔࿑㧟㧙㧢㧕㧔㧟㧕౞ᒻㆬᛯ࡮ࡐ࡝ࠧࡦㆬᛯ ౞ᒻㆬᛯ࠷࡯࡞ߦࠃࠅࡑ࠶ࡊ਄ߦ౞ᒻߩㆬᛯ㗔ၞࠍ⸳ቯߒ㧘ߘߩ㗔ၞౝߦ฽߹ࠇࠆⶄᢙߩࠝࡉࠫࠚࠢ࠻ࠍㆬᛯߔࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬౞ᒻㆬᛯ࠷࡯
࡞ߩ૶↪ᴺߪએਅߩߣ߅ࠅߢߔ‫ޕ‬㧔࿑㧟㧙㧣㧕Ԙ౞ᒻㆬᛯ࠷࡯࡞ㆬᛯߒ߹ߔ‫ޕ‬ԙࠞ࡯࠰࡞ࠍㆬᛯߒߚ޿㗔ၞߩਛᔃߦ⒖േߒ㧘ࠢ࡝࠶ࠢߒ߹ߔ‫ߚߒࠢ࠶࡝ࠢޕ‬࿾ὐ߇౞ߩਛᔃ
ߣߥࠅ߹ߔ‫ޕ‬Ԛࠞ࡯࠰࡞ࠍ⒖േߒ߹ߔߣ㧘ߎߎ߹ߢࠍඨᓘߣߒߚ౞㧔ὐ✢㧕߇⴫␜ߐࠇ߹ߔ‫ޕ‬ᔅⷐߥ▸࿐ߣߥࠆࠃ߁ߦඨᓘࠍ⺞ᢛߒ߹ߔ‫ޕ‬ԛ▸࿐⏕ቯߔࠆߚ߼ߦࠢ࡝࠶ࠢߒ߹ߔߣᬌ⚝߇ታⴕߐࠇ㧘⹥ᒰߔࠆࠝࡉࠫࠚࠢ࠻߇ㆬᛯߐࠇ߹
ߔ‫ޕ‬ㆬᛯߐࠇߚࠝࡉࠫࠚࠢ࠻ߪ⦡ߩ㆑޿ߢ್೎ߔࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬ ౞ᒻㆬᛯߣห᭽ߦ㧘ࡐ࡝ࠧࡦㆬᛯ࠷࡯࡞ߦࠃࠅࡑ࠶ࡊ਄ߢછᗧߩᄙⷺ
ᒻౝߦ฽߹ࠇࠆࠝࡉࠫࠚࠢ࠻ࠍⶄᢙㆬᛯߢ߈߹ߔ‫ࡦࠧ࡝ࡐޕ‬ㆬᛯ࠷࡯࡞
ߩ૶↪ᴺߪએਅߩߣ߅ࠅߢߔ‫ޕ‬㧔࿑㧟㧙㧤㧕Ԙࡐ࡝ࠧࡦㆬᛯ࠷࡯࡞ㆬᛯߒ߹ߔ‫ޕ‬ԙᗐቯߔࠆ㗔ၞࠍ࿐߻ࠃ߁ߦ㧘ࠞ࡯࠰࡞⒖േߣࠢ࡝࠶ࠢࠍ➅ࠅ㄰ߒ㧘ࡐ࡝ࠧࡦㆬᛯ▸࿐ࠍᜰቯߒ߹ߔ‫ޕ‬
Ԛ㗔ၞᜰቯᓟ㧘ฝࠢ࡝࠶ࠢࠃࠅ㗔ၞ߇⏕ቯߒᬌ⚝߇ታⴕߐࠇ߹ߔ‫ޕ‬ㆬᛯߐࠇߚࠝࡉࠫࠚࠢ࠻ߪ
⦡ߩ㆑޿ߢ್೎ߢ߈߹ߔ‫ޕ‬ ㆬᛯߒߚࠝࡉࠫࠚࠢ࠻ߪ‫ޡ‬㧞㧚ㆬᛯࠝࡉࠫࠚࠢ࠻ߩ଻ሽ‫ߣޢ‬ห᭽ߩᣇᴺߢ೑↪ߔࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬㧞㧚᳢↪ࠢࠛ࡝ߦࠃࠆⓨ㑆ᬌ⚝ ‫ޡ‬౞ᒻㆬᛯ࡮ࡐ࡝ࠧࡦㆬᛯ‫ࠆࠃߦޢ‬ⓨ㑆ᬌ⚝ߢߪࠝࡉࠫࠚࠢ࠻ࠍ౉ജߔࠆᔅⷐ߇޽ࠅ߹ߒߚ߇㧘ࡑ࠶ࡊ਄ߦ㊀ߨวߖߚ࠺࡯࠲࠮࠶࠻ࠍ೑↪ߒߡࠝࡉࠫࠚࠢ࠻ߩㆬᛯ߇น⢻ߢߔ‫ߪߦ⥸৻ޕ‬ᜰቯߒߚࡐ࡝ࠧࡦౝߦ฽߹ࠇࠆ೎࡟ࠗࡗ࡯ߩࡐࠗࡦ࠻㧘࡜ࠗࡦ㧘ࡐ࡝ࠧࡦߥߤࠍㆬᛯߔࠆⓨ㑆ᬌ⚝ߢ㧘SuperMap ߢߪ‫ޡ‬᳢↪ࠢࠛ࡝‫ࠍޢ‬೑↪ߒ߹ߔ‫ޕ‬ ߹ߚ㧘‫ޡ‬᳢↪ࠢࠛ࡝‫ߪߢޢ‬ⓨ㑆ᬌ⚝ߩ᧦ઙࠍ⸳ቯߔࠆߎߣ߇ߢ߈߹ߔ‫ޡޕ‬౞ᒻㆬᛯ࡮ࡐ࡝ࠧࡦㆬ
ᛯ‫ࠆࠃߦޢ‬ᬌ⚝ߢߪ㧘ࠝࡉࠫࠚࠢ࠻߇ㆬᛯߐࠇࠆ᧦ઙߪ‫࠻ࡦࠗࡐޡ‬ᚗ޿ߪࡐ࡝ࠧࡦ߿࡜ࠗࡦߩ㊀ᔃ߇฽߹ࠇࠆ‫߇ߔߢߺߩޢ‬㧘‫ޡ‬᳢↪ࠢࠛ࡝‫ߪߢޢ‬ㆬᛯ᧦ઙࠍ⒳‫ޘ‬ㆬ߱ߎߣ߇น⢻ߢߔ‫ޕ‬㧔㧝㧕න⁛ߩ࡟ࠗࡗ࡯߆ࠄߩⓨ㑆ᬌ⚝ᴒ✽㧾ਛߩฬ⼔㗔ၞߦ㓞ធߒߚࡐ࡝ࠧࡦࠍᬌ⚝ߒ߹ߔ‫ޕ‬଀ߣߒߡ㧘࠺࡯࠲࠮࠶࠻ᴒ
ᴒ✽㧾ࠍࡑ࠶ࡊߦ⴫␜ߒ㧘ฬ⼔ࠍㆬᛯߒ߹ߔ‫ޕ‬ Ԙⓨ㑆ᬌ⚝ࠍⴕ޿ߚ޿࠺࡯࠲࠮࠶࠻ᴒ ԙࡔ࠾ࡘ࡯߆ࠄ‫ޢ࡝ࠛࠢޡ‬㧛‫ޡ‬᳢↪ࠢࠛ࡝‫ࠍޢ‬ㆬᛯߒ߹ߔ‫ޕ‬㧔࿑㧟㧙㧥㧕 Ԛ‫ޡ‬᳢↪ࠢࠛ࡝‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔ‫ޕ‬㧔࿑㧟㧙10㧕ԛᬌ⚝ኻ⽎ߣߥࠆ࡟ࠗࡗ࡯ߦ࠴ࠚ࠶ࠢߒ߹ߔ‫ޕ‬੹࿁ߪ㧝୘ߩߢߔߩߢ㧘ߎࠇࠍ࠴ࠚ࠶ࠢߒ߹ߔ‫ޕ‬㧔࿑㧟㧙11㧕 Ԝⓨ㑆ᬌ⚝᧦ઙࠍㆬᛯߒ߹ߔ‫ޕ‬ⓨ㑆ᬌ⚝᧦ઙࡈࠖ࡯࡞࠼ࠍࠢ࡝࠶ࠢߒߡ᧦ઙ৻ⷩ߆ࠄㆬ߮߹ߔ‫ޕ‬੹࿁ߪ㓞ធࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝ߔࠆߚ߼ CommonLine ᧦ઙࠍ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧟㧙12㧕߹ߚ㧘೑↪น⢻ߥᬌ⚝᧦ઙߪ࿑㧟㧙12 ߦ␜ߔߣ߅ࠅߢ㧘ਥߥᬌ⚝᧦ઙߩ᭎ⷐߪએਅߩㅢࠅߢߔ‫ޕ‬⹦⚦߿ઁߩ᧦ઙߦߟ޿ߡߪࡑ࠾ࡘࠕ࡞ࠍෳᾖߒߡߊߛߐ޿‫ޕ‬
xCommonPoint㧦ᬌ⚝ࠝࡉࠫࠚࠢ࠻ߣ౒ㅢߔࠆࡁ࡯࠼ࠍ᦭ߔࠆࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝‫ޕ‬
xLineCross㧦ᬌ⚝ࠝࡉࠫࠚࠢ࠻ߩㄝ߿࡜ࠗࡦߣ੤Ꮕߒߡ޿ࠆࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝‫ޕ‬
xCommonLine㧦ᬌ⚝ࠝࡉࠫࠚࠢ࠻ߣߩ㑆ߦ౒ㅢߩㄝࠍ᦭ߔࠆࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝‫ޕ‬
xAreaIntersect㧦ᬌ⚝ࠝࡉࠫࠚࠢ࠻߇ోߡ߹ߚߪ৻ㇱ߇฽߹ࠇࠆࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝‫ޕ‬
xContaining㧦ᬌ⚝ࠝࡉࠫࠚࠢ࠻߇ቢోߦ฽ࠎߢ޿ࠆࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝‫ޕ‬
xCentroidInPolygon㧦ࠝࡉࠫࠚࠢ࠻ߩ㊀ᔃ㧔ਛᔃὐ㧦Centroid Point㧕߇ᬌ⚝ࠝࡉࠫࠚࠢ࠻
ߩౝㇱߦ૏⟎ߔࠆࡐ࡝ࠧࡦࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝‫ޕ‬
xIndentical 㧦ᬌ⚝ࠝࡉࠫࠚࠢ࠻ߣቢోߦหߓࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝‫ޕ‬ ਄⸥ᬌ⚝᧦ઙએᄖߦਅ⸥ߩ߽ߩ߇⸳ቯน⢻ߢߔ߇㧘⹦⚦ߪ࠰ࡈ࠻ߩࡋ࡞ࡊᯏ⢻߆ࠄ⏕⹺ߒߡߊߛߐ޿‫ޕ‬
CommonPointOrLineCross㧘EdgeTouchOrAreaIntersect㧘AreaIntersectNoEdgeTouch㧘ContainedBy㧘ContainedByNoEdgeTouch㧘ContainingNoEdgeTouch㧘PointInPolygon ԝOK ࠍ᛼ߔߣᬌ⚝㐿ᆎߒ߹ߔ‫ޕ‬ㆬᛯߐࠇߚࠝࡉࠫࠚࠢ࠻ߩዻᕈ৻ⷩ⴫߇⴫␜ߐࠇ߹ߔ‫ߚ߹ޕ‬㧘ࡑ࠶ࡊࠍ⴫␜ߔࠆߎߣߦࠃߞߡᬌ⚝ࠝࡉࠫࠚࠢ࠻ࠍ⏕⹺ߢ߈߹ߔ‫ޕ‬㧔࿑㧟㧙13㧕 ㆬᛯߒߚࠝࡉࠫࠚࠢ࠻ߪ‫ޡ‬㧝㧚ㆬᛯࠕࠗࠦࡦࠍ૶ߞߚⓨ㑆ᬌ⚝‫ߣޢ‬ห᭽ߩᣇᴺߢ೑↪น⢻ߢߔ‫ޕ‬㧔㧞㧕ⶄᢙ࡟ࠗࡗ࡯߆ࠄߩⓨ㑆ᬌ⚝ ㊀ߥࠅวߞߚⶄᢙ࡟ࠗࡗ࡯㑆ߢߩⓨ㑆ᬌ⚝߽‫ޡ‬᳢↪ࠢࠛ࡝‫ࠍޢ‬೑↪ߒߡⴕ߃߹ߔ‫࠺ߡߒߣ଀ޕ‬࡯࠲࠮࠶࠻ᴒᴒ ✽㧾ߣ౏౒ᣉ⸳߆ࠄߥࠆࡑ࠶ࡊࠃࠅ㧘ฬ⼔ᏒౝߦಽᏓߔࠆ౏౒ᣉ⸳ࠝࡉࠫࠚࠢ࠻
㧔ࡐࠗࡦ࠻㧕ࠍᬌ⚝ߒ߹ߔ‫ޕ‬ᴒ✽㧾ߣ౏౒ᣉ⸳ࠍ㊀ߨวࠊߡࡑ࠶ࡊ⴫␜ߒ߹ߔ‫ޕ‬ Ԙᴒᴒ✽㧾ࠃࠅࡐ࡝ࠧࡦࠝࡉࠫࠚࠢ࠻ฬ⼔㗔ၞࠍㆬᛯᓟ㧘ࡔ࠾ࡘ࡯߆ࠄ‫ޢ࡝ࠛࠢޡ‬㧛‫ޡ‬᳢↪ࠢࠛ ԙᴒ࡝‫ࠍޢ‬ㆬᛯߒ߹ߔ‫ޕ‬Ԛ‫ޡ‬᳢↪ࠢࠛ࡝‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔ‫ޕ‬ ԛ࡟ࠗࡗ࡯৻ⷩ߇⴫␜ߐࠇ߹ߔߩߢ㧘ⓨ㑆ᬌ⚝ኻ⽎ߣߥࠆ౏౒ᣉ⸳࡟ࠗࡗ࡯ߦ࠴ࠚ࠶ࠢߒ߹ߔ‫ޕ‬㧔࿑㧟㧙14㧕Ԝⓨ㑆ᬌ⚝᧦ઙߦ Containing ࠍ⸳ቯߒ߹ߔ‫ޕ‬
ԝOK ࠃࠅᬌ⚝㐿ᆎߒ߹ߔ‫ޕ‬ಣℂᓟ㧘ㆬᛯߐࠇߚࠝࡉࠫࠚࠢ࠻ߩዻᕈ৻ⷩ⴫߇⴫␜ߐࠇ㧘ߐࠄߦࡑ࠶ࡊ⴫␜ߔࠆߣᬌ⚝ࠝࡉࠫࠚࠢ࠻ࠍ⏕⹺น⢻ߢߔ㧔࿑㧟㧙15㧕‫ޕ‬㧔ㆬᛯࠝࡉࠫࠚࠢ࠻߇೎ߩ⦡
ߢ⴫␜㧘ࡂࠗ࡜ࠗ࠻⴫␜㧕‫ޡ‬᳢↪ࠢࠛ࡝‫ޡߪߦ࠙࠼ࡦࠖ࠙ޢ‬ዻᕈᬌ⚝᧦ઙ‫౉ޢ‬ജⷩ߇߽߁ߌࠄࠇߡ޿߹ߔ‫ߪࠇߎޕ‬หᤨߦዻᕈᬌ⚝ࠍⴕ߁ߎߣ߇น⢻ߢ޽ࠆߎߣࠍ⴫ߒߡ޿߹ߔ‫ޕ‬ዻᕈᬌ⚝ߪ⸳ቯ࠙ࠖࡦ࠼࠙ౝߩዻᕈᬌ⚝᧦ઙࠍࠢ࡝࠶ࠢߒ㧘SQL ᧦ઙᑼࠍ౉ജߔࠆߎߣߢน⢻ߦߥࠅ߹ߔ‫ߩߎޕ‬ᯏ⢻ࠍ೑↪ߔࠆߣ‫ޟ‬ฬ⼔Ꮢౝߦ޽ࠆቇᩞ‫ߩޠ‬᭽ߥⓨ㑆ᬌ⚝ߣዻᕈᬌ⚝ࠍ૬↪ߒߚᬌ⚝ࠍⴕ߁ߎߣ߇ߢ߈߹ߔ‫ޕ‬ዻᕈᬌ⚝ߦߟ޿ߡߪ‫ޡ‬ዻᕈᬌ⚝‫ޕ޿ߐߛߊߡߒ⹺⏕ߢޢ‬ࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆ ‫ޝ‬8/1‫ޞ‬ ‫ޡ‬ⓨ㑆ᬌ⚝‫ߪޢ‬㧘㗔ၞߦ฽߹ࠇࠆࠝࡉࠫࠚࠢ࠻ࠍᬌ⚝ߔࠆᯏ⢻ߢ޽ࠅ㧘ߐࠄߦ‫ޡ‬฽߹ࠇࠆ‫ߣޢ‬್ᢿߔࠆ᧦ઙ߽⸳ቯน⢻ߢߒߚ‫߼ߚߩߘޕ‬㧘଀߃߫‫ߩࡦࠗ࡜߿ࡦࠧ࡝ࡐޟ‬㊀ᔃ߇฽߹ࠇࠆ‫⸳ߣޠ‬ቯߔࠆߣ㧘ᬌ⚝㗔ၞ߆ࠄߪߺ಴ߒߚㇱಽ߽฽߼ߡࠝࡉࠫࠚࠢ࠻߇ㆬᛯߐࠇࠆ႐ว߽↢ߓ߹ߔ‫޽ޕ‬ࠆ޿ߪ‫ࠍ࠻ࠢࠚࠫࡉࠝޟ‬ቢోߦ฽߻‫ߚߒߣޠ‬႐วߪ㧘ࠝࡉࠫࠚࠢ࠻ߩᄢㇱಽ߇㗔ၞߦ฽߹ࠇߡ޿
ߡ߽ᬌ⚝߆ࠄ⪭ߜߡߒ߹߁ߎߣ߽⊒↢ߒ߹ߔ‫ޕ‬ GIS ࠺࡯࠲ߦኻߒߡ㧘޽ࠆ㗔ၞߦ฽߹ࠇࠆㇱಽࠍဳᛮ߈ߩࠃ߁ߦಾࠅ಴ߔಣℂ㧔ᬌ⚝㧕ࠍⴕ޿ߚ޿႐วߦߪ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫߇ޢ‬ଢ೑ߢߔ‫ޕ‬‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ߪߦޢ‬Ԙ⍱ᒻ㧘౞ᒻ㧘ࡐ࡝ࠧࡦߥߤߩ㗔ၞࠍ౉ജߒߡࡑ࠶ࡊࠢ࡝࠶ࡊߔࠆᣇᴺ
ԙࠝ࡯ࡃ࡯࡟ࠗߒߚ࠺࡯࠲࠮࠶࠻ߢࠝࡉࠫࠚࠢ࠻ࠍㆬᛯߒ㧘ߎࠇࠍ㗔ၞߣߒߡࡑ࠶ࡊࠢ࡝࠶ࡊ
ߔࠆᣇᴺ
Ԛ㗔ၞߣߔࠆ࠺࡯࠲࠮࠶࠻ߣᬌ⚝ኻ⽎ߣߥࠆ࠺࡯࠲࠮࠶࠻ࠍᜰቯߒ㧘ㅪ⛯⊛ߦಣℂࠍⴕ߁ᣇᴺ
߇޽ࠅ߹ߔ‫ޕ‬ એਅ㧘ⓨ㑆ၮ⋚࠺࡯࠲ࠃࠅ૞ᚑߒߚ࠺࡯࠲࠰࡯ࠬ map25k2_vec ࠍ೑↪ߒߡߘߩ૶↪ᴺࠍ⸃⺑ߒ߹ߔ‫ޕ‬
㧝㧚⍱ᒻ㧘౞ᒻ㧘ࡐ࡝ࠧࡦ㗔ၞߩࡑ࠶ࡊࠢ࡝࠶ࡊ
ᴒ✽㧾ߣ౏౒ᣉ⸳ࠍࡑ࠶ࡊ⴫␜ߒ㧘ࡔ࠾ࡘ࡯߆ࠄ‫ޢࡊ࠶ࡑޡ‬㧛‫࠶ࡑޡ‬ ኻ⽎ߣߥࠆ࠺࡯࠲࠮࠶࠻ᴒ
ࡊࠢ࡝࠶ࡊ‫ߣޢ‬ㅴߺ㧘㗔ၞ⸳ቯߩᣇᴺ㧔⍱ᒻ㧘౞ᒻ㧘ࡐ࡝ࠧࡦ㧕ࠍㆬᛯߒ߹ߔ‫ޕ‬㧔㧝㧕౏౒ᣉ⸳ࠍኻ⽎ߦ⍱ᒻㆬᛯ ⍱ᒻ౉ജࠕࠗࠦࡦߦᄌൻߒ߹ߔ‫౉ޕ‬ജߪ⍱ᒻኻⷺߩ㗂ὐߢ㧘㧞ὐ౉ജ߇ᔅⷐߦߥࠅ߹ߔ‫ޕ‬ Ԙ㗂ὐ㧝୘ࠍࠢ࡝࠶ࠢߢ᳿ቯߒ߹ߔ‫ޕ‬ ԙኻⷺߩ㗂ὐࠍࠢ࡝࠶ࠢߢ᳿ቯߒ߹ߔ‫ޕ‬ Ԛ‫߇࠙࠼ࡦࠖ࠙ޢࠣࡦࡇ࠶࡝ࠢࡊ࠶ࡑޡ‬㐿߈߹ߔߩߢ㧘ࡄ࡜ࡔ࡯࠲ࠍ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧠㧙㧞㧕ᴒ✽㧾ߣ౏౒ᣉ⸳ࠍ㐿޿ߡ޿߹ߔߩߢ㧘ಣℂኻ  ԛኻ⽎࡟ࠗࡗ࡯ߩ⸳ቯ㧦ߎߩ଀ߢߪࡑ࠶ࡊߦᴒ
⽎ߣߥࠆ࡟ࠗࡗ࡯ࠍ࠴ࠚ࠶ࠢߒ߹ߔ‫ޕ‬㧔ࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ߩ౏౒ᣉ⸳ࠍኻ⽎ߣߒ߹ߔ‫ޕ‬㧕Ԝࠢ࡝࠶ࡇࡦࠣ㗔ၞߩᜰቯ㧦౉ജߒߚ⍱ᒻ㗔ၞߩౝ஥ᚗ޿ߪᄖ஥߳ߣኻ⽎ࠍಾࠅ឵߃ࠆߎߣ
߇ߢ߈߹ߔ‫ޕ‬ԝࠢ࡝࠶ࡇࡦࠣ㗔ၞ೥㒰㧦ࠢ࡝࠶ࡇࡦࠣ㗔ၞࠍ೥㒰ߣ޿߁⸳ቯߦಾࠅ឵߃ࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬ Ԟࠢ࡝࠶ࡇࡦࠣಣℂ⚿ᨐߪ࠺࡯࠲࠮࠶࠻ߦ଻ሽߐࠇ߹ߔ‫࠻࠶࠮࠲࡯࠺ޕ‬ฬߪ⥄േ⊛ߦ↢ᚑߐࠇ߹ߔ߇㧘ਇㇺว߇޽ࠆ႐วߪୃᱜߒߡߊߛߐ޿‫ߚ߹ޕ‬㧘ⶄᢙߩ࠺࡯࠲࠰࡯ࠬࠍ㐿޿ߡ޿ࠆ႐วߦ
ߪ㧘଻ሽవߩ࠺࡯࠲࠰࡯ࠬߩᄌᦝ߽น⢻ߢߔ‫ޕ‬ ԟOK ࡏ࠲ࡦߢಣℂࠍ㐿ᆎߒ߹ߔ‫ޕ‬ ಣℂ⚳ੌᓟ㧘ࠢ࡝࠶ࡇࡦࠣ⚿ᨐߪԞߩ⸳ቯߦᓥߞߡ࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽߐࠇ߹ߔ߇㧘ࡑ࠶ࡊ਄ߦߪ⴫␜ߐࠇ߹ߖࠎ‫ߩ߼ߚߩ␜⴫ࡊ࠶ࡑޕ‬ᠲ૞ࠍⴕ߁ᔅⷐ߇޽ࠅ߹ߔ‫ޕ‬ ࠢ࡝࠶ࡇࡦࠣ㗔ၞߩ⸳ቯߪ㧘૏⟎ᐳᮡߩᢙ୯౉ജߦࠃࠅⴕ߁ߎߣ߇ߢ߈߹ߔ‫ޕ‬਄⸥ԟߩ೨ߦ㧘‫ࠣࡦࡇ࠶࡝ࠢޡߩ࠙࠼ࡦࠖ࠙ޢࠣࡦࡇ࠶࡝ࠢࡊ࠶ࡑޡ‬㗔ၞߩ⸳ቯ‫ࠅࠃࡉ࠲ޢ‬㧘ᢙ୯౉ജ↹㕙߇⴫␜ߐࠇ߹ߔߩߢ㧘ߎߎߢ୯ࠍ౉ജߒߡߊߛߐ޿‫ޕ‬㧔࿑㧠㧙㧟㧕ᴒ✽㧾ࠍኻ⽎ߦ౞ᒻㆬᛯ㧔㧞㧕ᴒ ౞ᒻ౉ജࠕࠗࠦࡦߦᄌൻߒ߹ߔ‫౉ޕ‬ജߪਛᔃὐߣ౞๟਄ߩὐߩ㧞ὐ౉ജ߇ᔅⷐߦߥࠅ߹ߔ‫ޕ‬ Ԙ౞ਛᔃ㧝୘ࠍࠢ࡝࠶ࠢߢ᳿ቯߒ߹ߔ‫ޕ‬ ԙࠞ࡯࠰࡞ࠍ⒖േߔࠆߣ㧘ਛᔃὐ߆ࠄࠞ࡯࠰࡞૏⟎ࠍඨᓘߣߔࠆ౞ࠍឬ޿ߡ߈߹ߔ‫ޕ‬ᔅⷐߥ౞ߣߥߞߚ૏⟎ߢࠢ࡝࠶ࠢߒ㧘᳿ቯߒ߹ߔ‫ࠣࡦࡇ࠶࡝ࠢޕ‬㗔ၞߩ⸳ቯߪ㧘૏⟎ᐳᮡߩᢙ୯౉ജߦࠃ

ࠅⴕ߁ߎߣ߇ߢ߈߹ߔ‫ޕ‬‫ࠣࡦࡇ࠶࡝ࠢޡ‬㗔ၞߩ⸳ቯ‫ࠅࠃࡉ࠲ޢ‬㧘ਛᔃ૏⟎ߣඨᓘߩᜰቯ߇น⢻ߢߔ‫ޕ‬ Ԛ‫߇࠙࠼ࡦࠖ࠙ޢࠣࡦࡇ࠶࡝ࠢࡊ࠶ࡑޡ‬㐿߈߹ߔߩߢ㧘ࡄ࡜ࡔ࡯࠲ࠍ⸳ቯߒ߹ߔ‫⸳ߩߎޕ‬ቯߪᴒ✽㧾ߣߒ߹ߔ‫ޕ‬⍱ᒻߩ႐วߣหߓߢߔ‫ߪߢߎߎޕ‬㧘ኻ⽎࡟ࠗࡗ࡯ࠍࡐ࡝ࠧࡦ࠺࡯࠲࠮࠶࠻ߩᴒ
 ԛOK ࡏ࠲ࡦߢಣℂࠍ㐿ᆎߒ߹ߔ‫ޕ‬ ಣℂ⚳ੌᓟ㧘ࠢ࡝࠶ࡇࡦࠣ⚿ᨐߪ⸳ቯߦᓥߞߡ࠺࡯࠲࠮࠶࠻ߣߒߡ଻ሽߐࠇ߹ߔ߇㧘⏕⹺ߩߚᴒ✽㧾ߩࠢ࡝࠶ࡇࡦࠣߦࠃ
߼ߦߪࡑ࠶ࡊ⴫␜ᠲ૞ࠍⴕ߁ᔅⷐ߇޽ࠅ߹ߔ‫࠻࠶࠮࠲࡯࠺ࡦࠧ࡝ࡐޕ‬ᴒࠅ㧘౞ᒻߦဳᛮ߈ߐࠇߚࠝࡉࠫࠚࠢ࠻߇↢ᚑߐࠇߡ޿߹ߔ‫ޕ‬㧔࿑㧠㧙㧠㧕 ࡐ࡝ࠧࡦࠝࡉࠫࠚࠢ࠻߿࡜ࠗࡦࠝࡉࠫࠚࠢ࠻ߪ㧘⸳ቯߐࠇߚࠢ࡝࠶ࡇࡦࠣ㗔ၞߦࠃࠅဳᛮ߈ߐ
ࠇߚᣂߒ޿ࠝࡉࠫࠚࠢ࠻ߣߥࠅ߹ߔ‫ߚ߹ޕ‬㧘㗔ၞᜰቯߩ࠺࡯࠲ߪࡐ࡝ࠧࡦࠝࡉࠫࠚࠢ࠻ߢߔ߇㧘ࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆኻ⽎ߣߥࠆ࠺࡯࠲ߪ㧘ࡌࠢ࠻࡞࠺࡯࠲࠮࠶࠻ߛߌߢߪߥߊ㧘࡜ࠬ࠲࡯࠺࡯࠲࠮
࠶࠻߽ኻ⽎ߣߥࠅ߹ߔ‫࡯࠲ࠬ࡜ޕ‬࿾ᒻ࿑߿ⓨਛ౮⌀ߩࡕࠩࠗࠢಣℂߢ૶↪ߒߚ‫ޢࡊ࠶࡝ࠢࡊ࠶ࡑޡ‬߽◲නߥ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ޕߔߢޢ‬㧞㧚ࡐ࡝ࠧࡦࠝࡉࠫࠚࠢ࠻ࠍ૶ߞߚࠢ࡝࠶ࡇࡦࠣ ࠝ࡯ࡃ࡯࡟ࠗߒߚ࠺࡯࠲࠮࠶࠻ࠍ೑↪ߒߡࠝࡉࠫࠚࠢ࠻ߩㆬᛯ߇น⢻ߢߔ‫ߪߦ⥸৻ޕ‬ᜰቯߒߚࡐ࡝ࠧࡦౝߦ฽߹ࠇࠆ೎࡟ࠗࡗ࡯ߩࡐࠗࡦ࠻㧘࡜ࠗࡦ㧘ࡐ࡝ࠧࡦߥߤࠍࠢ࡝࠶ࡇࡦࠣߔࠆᣇᴺߢ
ߔ‫ࠆߔ↪૶ߦࠣࡦࡇ࠶࡝ࠢޕ‬㗔ၞࠍ࠺࡯࠲࠮࠶࠻ߣߒߡ↪ᗧߢ߈ࠆߩߢ㧘ⶄ㔀ߥᒻ⁁ߩࡐ࡝ࠧࡦ
ࠍ૶ߞߚࠢ࡝࠶ࡇࡦࠣ╬ߦะ޿ߡ޿߹ߔ‫ޕ‬㧔㧝㧕ࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ߩࠢ࡝࠶ࡇࡦࠣ
࿾ฬ࠺࡯࠲࠮࠶࠻߆ࠄฬ⼔Ꮢ▸࿐ߩࡐࠗࡦ࠻ࠝࡉࠫ
଀ߣߒߡ࠺࡯࠲࠰࡯ࠬ map25k2_vec ਛߩ࿾ࠚࠢ࠻ࠍࠢ࡝࠶ࡇࡦࠣߒ߹ߔ‫ޕ‬ map25k2_vec ਛߩ࠺࡯࠲࠮࠶࠻࿾
࿾ฬ㧘ᴒᴒ✽ R ࠍࡑ࠶ࡊߦ⴫␜ߒ߹ߔ‫ޕ‬Ԙԙ ㆬᛯ࠷࡯࡞ߢฬ⼔Ꮢࠛ࡝ࠕ㧔ࡐ࡝ࠧࡦ㧕ࠍㆬᛯߒ㧘ࡑ࠙ࠬฝࠢ࡝࠶ࠢࠃࠅ‫ޡ‬ㆬᛯࠝࡉࠫࠚ
ࠢ࠻ߢࡑ࠶ࡊࠢ࡝࠶ࡊ‫ࠍޢ‬ㆬᛯߒ߹ߔ‫ޕ‬Ԛ ‫߇࠙࠼ࡦࠖ࠙ޢࠣࡦࡇ࠶࡝ࠢࡊ࠶ࡑޡ‬㐿߈߹ߔ‫⸳ߩߎޕ‬ቯߪ‫ޡ‬㧝㧚⍱ᒻ㧘౞ᒻ㧘ࡐ࡝ࠧࡦ㗔ၞߩࡑ࠶ࡊࠢ࡝࠶ࡊ‫ߊోߣޢ‬หߓ⸳ቯ↹㕙ߢߔ‫ޕ‬࿾ฬ㧬map25k2_vec ‫ޕ‬ԛࡑ࠶ࡊࠢ࡝࠶ࡊኻ⽎࡟ࠗࡗ࡯ࠍ࠴ࠚ࠶ࠢߒ߹ߔ‫੹ޕ‬࿁ߪ࿾Ԝ଻ሽߔࠆ࠺࡯࠲࠮࠶࠻ฬࠍ⸳ቯߒ߹ߔ‫੹ޕ‬࿁ߪ ฬ⼔࿾ฬ ߣߒ߹ߒߚ‫ޕ‬ ԝOK ࡏ࠲ࡦߢಣℂࠍ㐿ᆎߒ߹ߔ‫ޕ‬
ಣℂ⚳ੌᓟ㧘ࠢ࡝࠶ࡇࡦࠣ⚿ᨐߪ⸳ቯߦᓥߞߡ࠺࡯࠲࠮࠶࠻ฬ
ฬ⼔࿾ฬߣߒߡ଻ሽߐࠇ߹ߔ߇㧘⏕⹺ߩߚ߼ߦߪࡑ࠶ࡊ⴫␜ᠲ૞ࠍⴕ߁ᔅⷐ߇޽ࠅ߹ߔ‫ޕ‬㧔㧞㧕࡜ࠗࡦ࠺࡯࠲࠮࠶࠻ߩࠢ࡝࠶ࡇࡦࠣห᭽ߩಣℂࠍ࡜ࠗࡦ࠺࡯࠲࠮࠶࠻㆏〝ߦኻߒߡⴕ߁႐ว㧘ߘߩᚻᴺߪ਄⸥ߣ߶߷ห᭽ߦߥࠅ߹
ߔ߇㧘ࡑ࠶ࡊߦ㆏〝ࠍㅊടߔࠆߎߣ㧘‫ߩߢ࠙࠼ࡦࠖ࠙ޢࠣࡦࡇ࠶࡝ࠢࡊ࠶ࡑޡ‬ኻ⽎࡟ࠗࡗ࡯⸳ቯ
ߢ㆏〝㧬map25k2_vec ߦ࠴ࠚ࠶ࠢߔࠆߎߣ߇⇣ߥࠆㇱಽߢߔ‫ߦ࠻ࠢࠚࠫࡉࠝ࠻ࡦࠗࡐޕ‬Ყߴⶄ㔀ߥߚ߼㧘ಣℂߦᤨ㑆ࠍⷐߒ߹ߔ߇㧘㗔ၞߢဳᛮ߈ߐࠇߚ࡜ࠗࡦࠝࡉࠫࠚࠢ࠻߇↢ᚑߐࠇ߹ߔ‫ޕ‬㧔࿑㧠㧙㧡㧕
㧟㧚࠺࡯࠲࠮࠶࠻೑↪ߦࠃࠆࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆ
ࠢ࡝࠶ࡇࡦࠣ㗔ၞߣߔࠆ࠺࡯࠲࠮࠶࠻ߣኻ⽎ߣߥࠆ࠺࡯࠲࠮࠶࠻ࠍᜰቯߒ㧘ㅪ⛯⊛ߦࠢ࡝࠶ࡇ
ࡦࠣಣℂࠍⴕ߁ᣇᴺߢߔ‫ޕ‬㧔㧝㧕㧞ᰴࡔ࠶ࠪࡘߦࠃࠆࠢ࡝࠶ࡇࡦࠣ
ᴒ✽㧾ࠍ඙ಽߒߡߺ߹ߔ‫ޕ‬వߕᴒ✽㧾ߣᴒ✽ፉ ଀ߣߒߡ㧞ᰴࡔ࠶ࠪࡘࠍ૶↪ߒߡ࠺࡯࠲࠮࠶࠻ᴒ

๟ㄝߩ㧞ᰴࡔ࠶ࠪࡘ࠺࡯࠲ߢ޽ࠆ okin_mesh2R ࠍࠝ࡯ࡃ࡯࡟ࠗߐߖ߹ߔ‫ޕ‬ Ԙࡔ࠾ࡘ࡯߆ࠄ‫⸃ޡ‬ᨆ‫ޢ‬㧛‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬㧔࿑㧠㧙㧢㧕 ԙ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔߩߢ㧘ࡄ࡜ࡔ࡯࠲ࠍ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧠㧙㧣㧕Ԛ࠺࡯࠲࠮࠶࠻㧝㧦⸃ᨆኻ⽎ߩ࠺࡯࠲࠮࠶࠻ࠍᜰቯߒ߹ߔ‫੹ޕ‬࿁ߪᴒᴒ✽㧾ߢߔ‫ޕ‬ԛ࠺࡯࠲࠮࠶࠻㧞㧦ࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆࠍⴕ߁㗔ၞߩ࠺࡯࠲࠮࠶࠻ࠍᜰቯߒ߹ߔ‫੹ޕ‬࿁ߪ
okin_mesh2R ߣߥࠅ߹ߔ‫ޕ‬Ԝ଻ሽవߩ࠺࡯࠲࠮࠶࠻㧦⸃ᨆ⚿ᨐࠍ଻ሽߔࠆ࠺࡯࠲࠮࠶࠻ฬ⒓ߢߔ‫ߩ࠻࡞ࠜࡈ࠺ޕ‬ฬ⒓߇
⸳ቯߐࠇ߹ߔ߇㧘ਇㇺว߇޽ࠆ႐วߪᄌᦝน⢻ߢߔ‫ߚ߹ޕ‬㧘Ԛ㨪Ԝߪⶄᢙߩ࠺࡯࠲࠰࡯ࠬࠍ
㐿޿ߚ⁁ᘒߢߔߣ࠺࡯࠲࡯࠰࡯ࠬߩᜰቯ߽น⢻ߢߔ‫ޕ‬ԝࠝ࡯ࡃ࡯࡟ࠗᣇᑼ㧦ฦ⒳ࠝ࡯ࡃ࡯࡟ࠗᣇᴺࠍㆬᛯߢ߈߹ߔ‫ࠍࠣࡦࡇ࠶࡝ࠢߪߢߎߎޕ‬ᜰቯߒ߹ߔ‫ޕ‬
 ԞOK ࡏ࠲ࡦߢಣℂࠍ㐿ᆎߒ߹ߔ‫ޕ‬
ಣℂ⚳ੌᓟ㧘ࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆ⚿ᨐߪ⸳ቯߦᓥߞߡ࠺࡯࠲࠮࠶࠻ߦ଻ሽߐࠇ߹ߔ߇㧘⏕⹺ߩߚ߼ߦߪࡑ࠶ࡊ⴫␜ᠲ૞ࠍⴕ߁ᔅⷐ߇޽ࠅ߹ߔ‫੹ޕ‬࿁ߩࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆ⚿ᨐߪ࿑㧠㧙㧤ߦ␜ߔࠃᴒ✽㧾ౝߩࠝࡉࠫࠚࠢ࠻ߪ okin_mesh2R ߩࠝࡉࠫࠚࠢ࠻ߦಽഀߐࠇߚ⁁ᘒߦߥ߁ߦߥࠅ߹ߔ‫ޕ‬ᴒᴒ✽㧾ߩ߽ߩࠍᒁ߈⛮߉߹ߔ‫ޕ‬ࠅ㧘ዻᕈᖱႎߪ㧘㕙Ⓧ߿๟࿐㐳એᄖߪᴒ㧔㧞㧕㧞ᰴࡔ࠶ࠪࡘߦࠃࠆࠗࡦ࠲࡯࠮࡚ࠢࠪࡦ ࠗࡦ࠲࡯࠮࡚ࠢࠪࡦߪࠢ࡝࠶ࡇࡦࠣߣห᭽ߥ࿑ᒻࠍ↢ᚑߔࠆಣℂߢߔ߇㧘↢ᚑߐࠇࠆࠝࡉࠫࠚ
ࠢ࠻ߩዻᕈ୯ࠍ✬㓸ߒߡ㧘ࠝ࡯ࡃ࡯࡟ࠗߦ૶↪ߒߚࡐ࡝ࠧࡦߩዻᕈᖱႎ߽ઃടߢ߈ࠆಣℂᣇᑼߢߔ‫ޡޕ‬㧔㧝㧕㧞ᰴࡔ࠶ࠪࡘߦࠃࠆࠢ࡝࠶ࡇࡦࠣ‫ߊోߣޢ‬ᚻ㗅ߪหߓߢߔ߇㧘ࠝ࡯ࡃ࡯࡟ࠗᣇᑼㆬᛯ
ߢ㧘ࠗࡦ࠲࡯࠮࡚ࠢࠪࡦࠍᜰቯߒ߹ߔߣ㧘଻ሽవ࠺࡯࠲࠮࠶࠻ߩⷩߦࡈࠖ࡯࡞࠼⸳ቯࡏ࠲ࡦ߇⃻ࠇ߹ߔ‫ޕ‬㧔࿑㧠㧙㧥㧕ߐࠄߦߎߩࡏ࠲ࡦࠍ᛼ߔߣ‫⸳࠼࡞࡯ࠖࡈޡ‬ቯ‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔ‫ޕ‬ ߎߎߢ㧘ࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆߦࠃߞߡ↢ᚑߔࠆ࠺࡯࠲࠮࠶࠻ߦ↪޿ࠆዻᕈࡈࠖ࡯࡞࠼ࠍᜰቯߔࠆ
ߎߣ߇ߢ߈߹ߔ‫⸃ߪߢߎߎޕ‬ᨆኻ⽎ߩ࠺࡯࠲࠮࠶࠻㧝㧔ᴒᴒ✽㧾㧕ߣࠝ࡯ࡃ࡯࡟ࠗ㗔ၞߣߥࠆ࠺࡯
࠲࠮࠶࠻㧞㧔okin_mesh2R㧕߆ࠄᔅⷐߥዻᕈࡈࠖ࡯࡞࠼ࠍㆬᛯߒ߹ߔ‫ޕ‬㧔࿑㧠㧙10㧕ಣℂ⚿ᨐߪ࿑㧠㧙11 ߦ␜ߔߣ߅ࠅߦߥࠅ㧘ዻᕈᖱႎߣߒߡ okin_mesh2R ߩᖱႎ߽ઃടߐࠇߡ޿ࠆߎߣ߇ࠊ
߆ࠅ߹ߔ‫ޕ‬ࠝ࡯ࡃ࡯࡟ࠗᣇᑼ㧔ԝ㧕ߩ⸳ቯߢߪ㧘ࠢ࡝࠶ࡇࡦࠣߣࠗࡦ࠲࡯࠮࡚ࠢࠪࡦએᄖߦ࡙࠾ࠝࡦ㧘ࠗ࡟࡯ࠬ㧘ࠕࠗ࠺ࡦ࠹ࠖ࠹ࠖ㧘ࠪࡦࡔ࠻࡝࠶ࠢ߇น⢻ߢߔ߇㧘ߘࠇߙࠇߩ⹦⚦ߪࡑ࠾ࡘࠕ࡞ࠍෳᾖ
ߒߡߊߛߐ޿‫ޕ‬㧔㧟㧕ࠗࡦ࠲࡯࠮࡚ࠢࠪࡦࠍ೑↪ߒߚࠝࡉࠫࠚࠢ࠻ߩಽ㘃 ࠺࡯࠲࠮࠶࠻ᴒ
ᴒ✽㧾ߣ౏౒ᣉ⸳߿㆏〝ߦኻߒ㧘㧘ࠗࡦ࠲࡯࠮࡚ࠢࠪࡦࡕ࡯࠼ߩࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆ
ࠍⴕ߃߫Ꮢ↸᧛ߏߣߩ౏౒ᣉ⸳߿㆏〝ߩ඙ಽࠍ◲නߦⴕ߁ߎߣ߇ߢ߈߹ߔ‫ޕ‬ቇᩞౝߩࠝࡉࠫࠚࠢ࠻ߦᏒ↸᧛ฬࠍઃടߒߡߺ߹ߔ‫ޕ‬㧔࿑㧠㧙12㧕 ଀ߣߒߡ࠺࡯࠲࠮࠶࠻ቇ  Ԙࡔ࠾ࡘ࡯߆ࠄ‫⸃ޡ‬ᨆ‫ޢ‬㧛‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬  ԙ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔߩߢ㧘ࡄ࡜ࡔ࡯࠲ࠍ⸳ቯߒ߹ߔ‫ޕ‬㧔࿑㧠㧙13㧕ቇᩞߢߔ‫ޕ‬Ԛ࠺࡯࠲࠮࠶࠻㧝㧦⸃ᨆኻ⽎ߩ࠺࡯࠲࠮࠶࠻ࠍᜰቯߒ߹ߔ‫੹ޕ‬࿁ߪቇᴒԛ࠺࡯࠲࠮࠶࠻㧞㧦ࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆࠍⴕ߁㗔ၞߩ࠺࡯࠲࠮࠶࠻ࠍᜰቯߒ߹ߔ‫੹ޕ‬࿁ߪᴒ✽㧾ߣߥࠅ߹ߔ‫ޕ‬Ԝ଻ሽవߩ࠺࡯࠲࠮࠶࠻㧦⸃ᨆ⚿ᨐࠍ଻ሽߔࠆ࠺࡯࠲࠮࠶࠻ฬ⒓ߢߔ‫ߩ࠻࡞ࠜࡈ࠺ޕ‬ฬ⒓߇
⸳ቯߐࠇ߹ߔ߇㧘ਇㇺว߇޽ࠆ႐วߪᄌᦝน⢻ߢߔ‫ޕ‬ԝࠝ࡯ࡃ࡯࡟ࠗᣇᑼ㧦ฦ⒳ࠝ࡯ࡃ࡯࡟ࠗᣇᴺࠍㆬᛯߢ߈߹ߔ‫ࡦ࡚ࠪࠢ࠮࡯࠲ࡦࠗߪߢߎߎޕ‬ࠍᜰቯߒ߹ߔ‫ޕ‬Ԟ଻ሽవ࠺࡯࠲࠮࠶࠻ߩⷩߦ޽ࠆࡈࠖ࡯࡞࠼⸳ቯࡏ࠲ࡦࠍ᛼ߒ߹ߔ‫ޕ‬‫⸳࠼࡞࡯ࠖࡈޡ‬ቯ‫࠙ޢ‬ࠖࡦ࠼࠙߇㐿߈߹ߔ‫ޕ‬ԟ࠺࡯࠲࠮࠶࠻ߦ↢ᚑߔࠆࡈࠖ࡯࡞࠼ࠍᜰቯߒ߹ߔ‫߈ߣߩߎޕ‬ቇቇᩞߣᴒᴒ✽㧾ߩਔᣇߩࡈ
ቇᩞߩࡈࠖ࡯࡞
ࠖ࡯࡞࠼ࠍ೑↪ߢ߈߹ߔ‫ߢࠢ࡯ࡑࠢ࠶ࠚ࠴ޕ‬ㆬᛯߒߡߊߛߐ޿‫੹ޕ‬࿁ߪቇᴒ✽㧾ߩ Name ࡈࠖ࡯࡞࠼㧔Ꮢ↸᧛ฬ㧕ࠍ೑↪ߒ߹ߔ‫ޕ‬㧔࿑㧠㧙14㧕⸳ቯ߇࠼ࠍਥ૕ߦᴒ
⚳ੌߒߚࠄ OK ࡏ࠲ࡦࠍ᛼ߒߡߊߛߐ޿‫ޕ‬ Ԟ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ߦ࠙࠼ࡦࠖ࠙ޢ‬ᚯࠅ߹ߒߚࠄ OK ࡏ࠲ࡦߢಣℂࠍ㐿ᆎߒ߹ߔ‫ޕ‬ ↢ᚑߒߚ࠺࡯࠲࠮࠶࠻ NewDT ߩዻᕈ࠹࡯ࡉ࡞ࠍ⴫␜ߐߖ㧘ಣℂౝኈࠍ⏕⹺ߒߡߊߛߐ޿‫ޕ‬ᣂⷙߦ Name ࡈࠖ࡯࡞࠼߇ㅊടߐࠇ㧘ߘߎߦᏒ↸᧛ฬ߇࠮࠶࠻ߐࠇߡ޿ࠆߩߪ⏕⹺ߢ߈߹ߔ‫ޕ‬㧔࿑㧠㧙15㧕೎ߩᔕ↪଀ߣߒߡ㧘޽ࠆ࿾ၞߩ࿾⾰࠺࡯࠲ߣᬀ↢࠺࡯࠲ߦㆡᔕߔࠇ߫㧘࿾⾰᧦ઙߣᬀ↢᧦ઙࠍⲢวߐߖߚᣂߒ޿඙ಽ࿑ࠍ૞ᚑߔࠆߎߣ߇น⢻ߦߥࠅ߹ߔ‫ࡃ࡯ࠝߩ࠼࡯ࡕࡦ࡚ࠪࠢ࠮࡯࠲ࡦࠗޕ‬࡯࡟ࠗ⸃ᨆߪ㜞ᐲߥⓨ㑆⸃ᨆࠍⴕ߃ࠆಣℂᣇᴺߛߣ⠨߃ߡ޿߹ߔ‫ޕ‬ⓨ㑆ᠲ૞ ࡃࡈࠔ߿ࡏࡠࡁࠗ࿑૞ᚑࠍⴕ߁ⓨ㑆ᠲ૞ߦࠃࠅ㧘࠺࡯࠲࠮࠶࠻෸߮ߘߩࠝࡉࠫࠚࠢ࠻߆ࠄᣂߒ
޿㗔ၞࠍ⴫ߔࡐ࡝ࠧࡦ࠺࡯࠲࠮࠶࠻ࠍ↢ᚑߒ߹ߔ‫↢ޕ‬ᚑߐࠇߚ࠺࡯࠲࠮࠶࠻ߣࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆ
ࠍ૬↪ߒ߹ߔߣ㜞ᐲߥⓨ㑆ಽᨆ߇น⢻ߦߥࠅ߹ߔ‫ޕ‬㧝㧚ࡐࠗࡦ࠻߆ࠄߩࡃࡈࠔ૞ᚑ
࠺࡯࠲࠮࠶࠻ߩᜰቯߒߚࠝࡉࠫࠚࠢ࠻ߦኻߒ㧘৻ቯ〒㔌ߩ▸࿐ࠍ␜ߔࡃࡈࠔࠍ૞ᚑߔࠆߎߣ߇
ߢ߈߹ߔ‫ޕ‬૞ᚑߐࠇߚࡃࡈࠔߣ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ࠍޢ‬૬↪ߔࠆߣฦ⒳ࠝࡉࠫࠚࠢ࠻ߩ㜞ᐲߥⓨ㑆ಽᨆ߇น⢻ߦߥࠅ߹ߔ‫ࠍࠔࡈࡃޕ‬૞ᚑߔࠆ႐ว㧘⻉ࡄ࡜ࡔ࡯࠲ࠍ㨙න૏ߢ⸳ቯߔࠆߚ߼࠺࡯࠲
࠮࠶࠻ߪᐔ㕙⋥ⷺᐳᮡ♽ߦ⸳ቯߔࠆߎߣࠍ߅൘߼ߒ߹ߔ‫✲ޕ‬ᐲ࡮⚻ᐲᐳᮡ♽ߩ႐วߪᢙ୯߇ᐲන૏ߣߥࠅℂ⸃ߒߦߊߊߥߞߡߒ߹޿߹ߔ‫ޕ‬㧔㧝㧕ࡐࠗࡦ࠻߆ࠄߩࡃࡈࠔ૞ᚑ
ၮᧄ⊛ߥࡃࡈࠔ૞ᚑᴺࠍࡐࠗࡦ࠻ࠝࡉࠫࠚࠢ࠻ߦኻߔࠆࡃࡈࠔ૞ᚑߢ⸃⺑ߒ߹ߔ‫࠺ߡߒߣ଀ޕ‬࿾ฬ߆ࠄ㧘છᗧߩࡐࠗࡦ࠻ߦኻߒࡃࡈࠔࠍ૞ᚑߒ߹
࡯࠲࠰࡯ࠬ map25k2_vec ਛߩ࠺࡯࠲࠮࠶࠻࿾
ߔ‫ޕ‬Ԙછᗧߩ㧝ὐࠍㆬᛯߒ㧘ฝࠢ࡝࠶ࠢ߆ࠄ‫↢ࠍࠔࡈࡃޡ‬ᚑ‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬㧔࿑㧡㧙㧝㧕ԙ‫↢ࠔࡈࡃޡ‬ᚑ‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔ‫⸳ࠍ࠲࡯ࡔ࡜ࡄޕ‬ቯߒ߹ߔ‫ޕ‬㧔࿑㧡㧙㧞㧕
Ԛࡃࡈࠔඨᓘ㧦ࡃࡈࠔඨᓘߣߘߩන૏ࠍ⸳ቯߒ߹ߔ‫ޕ‬ԛ౞ߩࠬࡓ࡯ࠬࡀࠬ㧦౞ࠍᱜᄙⷺᒻߢㄭૃߒߡࡃࡈࠔࠍ▚಴ߔࠆߚ߼㧘ߘߩᄙⷺᒻߩ㗂ὐᢙࠍ౉ജߒ߹ߔ‫ޕ‬ᢙ୯߇ᄢ߈޿߶ߤ౞ߦㄭߠ߈߹ߔ‫ޕ‬
Ԝಣℂ⚿ᨐࠍ଻ሽߔࠆ࠺࡯࠲࠮࠶࠻ฬ⒓ࠍ᳿ቯߒ߹ߔ‫ޕ‬ ԝOK ࠃࠅ㧘࠺࡯࠲࠮࠶࠻ Buffer ߇૞ᚑߐࠇ߹ߔ‫ޕ‬㧔࿑㧡㧙㧟㧕㧔㧞㧕ࡑ࡞࠴ࡃࡈࠔ ㆬᛯߒߚࠝࡉࠫࠚࠢ࠻߆ࠄ޽ࠆ㑆㓒ߢᜰቯߒߚඨᓘߩㅪ⛯ߒߚࡃࡈࠔࠍ૞ᚑߔࠆߎߣ߇น⢻ߢߔ‫ޕ‬‫ޟ‬ᜰቯߒߚࠝࡉࠫࠚࠢ࠻߆ࠄߤࠇߋࠄ޿ߩ〒㔌ߦߤߩࠃ߁ߥࠝࡉࠫࠚࠢ࠻߇ሽ࿷ߔࠆ߆‫ߤߥޠ‬࿾ฬߩછᗧࡐࠗࡦ࠻ߦኻߒࡑ࡞࠴ࡃࡈࠔࠍ૞ߩⓨ㑆ಽᨆߦ೑↪ߢ߈߹ߔ‫࠻࠶࠮࠲࡯࠺ߡߒߣ଀ޕ‬࿾ᚑߒ߹ߔ‫ޕ‬Ԙછᗧߩ㧝ὐࠍㆬᛯߒ㧘ฝࠢ࡝࠶ࠢ߆ࠄ‫↢ࠍࠔࡈࡃޡ‬ᚑ‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬ԙ‫↢ࠔࡈࡃޡ‬ᚑ‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔ‫⸳ࠍ࠲࡯ࡔ࡜ࡄޕ‬ቯߒ߹ߔ‫ޕ‬㧔࿑㧡㧙㧠㧕
Ԛ౞ߩࠬࡓ࡯ࠬࡀࠬ㧦౞ࠍᱜᄙⷺᒻߢㄭૃߒߡࡃࡈࠔࠍ▚಴ߔࠆߚ߼㧘ߘߩᄙⷺᒻߩ㗂ὐᢙࠍ౉ജߒ߹ߔ‫ޕ‬ᢙ୯߇ᄢ߈޿߶ߤ౞ߦㄭߠ߈߹ߔ‫ޕ‬㧔ᵈᗧ㧦ࡑ࡞࠴ࡃࡈࠔߢߪߎߩ⸳ቯ߇ᄖ஥
ߩࡃࡈࠔ౞๟ߦ෻ᤋߐࠇ߹ߖࠎ‫ޕ‬㧕ԛಣℂ⚿ᨐࠍ଻ሽߔࠆ࠺࡯࠲࠮࠶࠻ฬ⒓ࠍ᳿ቯߒ߹ߔ‫ޕ‬Ԝࡑ࡞࠴ࡃࡈࠔࡏ࠲ࡦࠍ᛼ߔߣ‫߇࠙࠼ࡦࠖ࠙ޢࠔࡈࡃ࠴࡞ࡑޡ‬㐿߈߹ߔ‫ޕ‬㧔࿑㧡㧙㧡㧕ԝᏀฝⷩߦᢙ୯ࠍᦠ߈ㄟߺ߹ߔ‫੹ޕ‬࿁ߪ 1000㨙㑆㓒ߢࡃࡈࠔࠍ૞ᚑߒ߹ߔ‫ޕ‬Ԟㅊടࡏ࠲ࡦࠍ૶ߞߡ⸥౉ᰣࠍㅊടߒ߹ߔ‫ޕ‬ԟ‫ޟ‬ԝߣԞ‫ࠍޠ‬ᔅⷐߥ࿁ᢙ➅ࠅ㄰ߒ߹ߔ‫ޕ‬Ԡ⸳ቯ⚳ੌᓟ OK ࡏ࠲ࡦࠍ᛼ߒ߹ߔ‫ޕ‬ ԝOK ࠃࠅ㧘࠺࡯࠲࠮࠶࠻ Buffer ߇૞ᚑߐࠇ߹ߔ‫ޕ‬㧔࿑㧡㧙㧢㧕 ૞ᚑߐࠇߚࠝࡉࠫࠚࠢ࠻ߪਛᔃߦ౞ᒻ㧘๟ㄝߦ࠼࡯࠽࠷⁁ߩࡐ࡝ࠧࡦ߇↢ᚑߐࠇ㧘ߘࠇࠄߩႺ
⇇✢ߪਛᔃ߆ࠄ 1000,2000,3000,4000m ߣߥߞߡ޿߹ߔ‫ޕ‬ዻᕈᖱႎߦߘࠇߙࠇߩࡃࡈࠔඨᓘࠍ⴫
ߔ୯ࠍㅊടߔࠇ߫ࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆߢ㊀ߥࠅว߁࠺࡯࠲ߩಽᨆ߇น⢻ߢߔ‫ޕ‬㧔㧟㧕ⶄᢙࠝࡉࠫࠚࠢ࠻߆ࠄߩࡃࡈࠔ ⶄᢙࠝࡉࠫࠚࠢ࠻ࠍㆬᛯߒߚ႐วߢ߽ࡃࡈࠔࠍ⸳ቯߔࠆߎߣ߇น⢻ߢߔ‫ߩߎޕ‬႐ว㧘‫ⶄޡ‬ᢙߩࠝ
ࡉࠫࠚࠢ࠻ߢ୘೎ߦࡃࡈࠔࠍ↢ᚑߔࠆ‫Ⲣࠍࠔࡈࡃߩ࠻ࠢࠚࠫࡉࠝޡߣ࠼࡯ࡕޢ‬วߒߡ㧝୘ߩࡃࡈࠔߣߒߡ↢ᚑߔࠆ‫⸳ࠍ࠼࡯ࡕޢ‬ቯߔࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬㧔࿑㧡㧙㧣㧕ߘࠇߙࠇߩࡕ࡯࠼ߢ૞ᚑߒߚ
ࡃࡈࠔࠍ࿑㧡㧙㧤ߣ࿑㧡㧙㧥ߦ␜ߒ߹ߔ‫ޕ‬ ߹ߚ㧘ߘࠇߙࠇߩࠝࡉࠫࠚࠢ࠻ߢ⇣ߥࠆࡃࡈࠔඨᓘࠍណ↪ߔࠆߎߣ߇น⢻ߢߔ‫ߩߎޕ‬႐วߪࠝࡉࠫࠚࠢ࠻ߩዻᕈߦࡃࡈࠔඨᓘࠍᩰ⚊ߒߚዻᕈࡈࠖ࡯࡞࠼ࠍḰ஻ߔࠆᔅⷐ߇޽ࠅ߹ߔ‫ࠔࡈࡃޕ‬ඨᓘࠍ⸳ቯߒߚࡈࠖ࡯࡞࠼ߩᜰቯߪࡃࡈࠔඨᓘ⸳ቯߩࡈࠖ࡯࡞࠼߆ࠄࡏ࠲ࡦࠍ᛼ߒߡ‫࠼࡞࡯ࠖࡈޡ‬ㆬᛯ‫ࠔࡈࡃߪߢߎߎޕߔ߹ߒࠍޢ‬ඨᓘࡈࠖ࡯࡞࠼ߦᜰቯߒ߹ߔ‫ޕ‬㧔࿑㧡㧙12㧕㧞㧚࡜ࠗࡦ࡮ࡐ࡝ࠧࡦ߆ࠄߩࡃࡈࠔ૞ᚑ ࡜ࠗࡦ࡮ࡐ࡝ࠧࡦࠝࡉࠫࠚࠢ࠻߆ࠄߩࡃࡈࠔ૞ᚑߪ㧘ࡐࠗࡦ࠻ࠝࡉࠫࠚࠢ࠻߆ࠄߩࡃࡈࠔߣห
᭽ߥᚻᴺࠍ೑↪ߢ߈߹ߔ‫ߪߢߎߎޕ‬ၮᧄ⊛ߥ࡜ࠗࡦ࡮ࡐ࡝ࠧࡦ߆ࠄߩࡃࡈࠔ૞ᚑᴺࠍ⸃⺑ߒ߹ߔ‫ޕ‬㧔㧝㧕࡜ࠗࡦ߆ࠄߩࡃࡈࠔ૞ᚑ ࡜ࠗࡦ࠺࡯࠲࠮࠶࠻࿖㆏߆ࠄࠝࡉࠫࠚࠢ࠻ࠍㆬᛯߒ㧘ฝࠢ࡝࠶ࠢ߆ࠄ‫↢ࠍࠔࡈࡃޡ‬ᚑ‫ࠍޢ‬ㆬᛯߒ߹ߔ‫ࠔࡈࡃޕ‬ඨᓘ〒㔌╬ߩࡄ࡜ࡔ࡯࠲ࠍ⸳ቯᓟ㧘OK ࡏ࠲ࡦࠃࠅ࠺࡯࠲࠮࠶࠻ Buffer ߇૞ᚑߐࠇ߹ߔ‫ޕ‬㧔࿑㧡㧙13㧕࡜ࠗࡦࠝࡉࠫࠚࠢ࠻߆ࠄߩࡃࡈࠔ૞ᚑߢߪ‫↢ࠔࡈࡃࡦࠗ࡜ޡ‬ᚑߩࠝࡊࠪ
࡚ࡦ‫ࠍޢ‬ㆬᛯߔࠆߎߣ߇น⢻ߢ㧘ߎࠇߪ✢ߩᆎὐ࡮⚳ὐㇱಽߩࡃࡈࠔࠍ౞ᒻߦߔࠆ߆⍱ᒻߢ⚳ੌߐߖࠆ߆ࠍ⸳ቯߢ߈߹ߔ‫ޕ‬㧔࿑㧡㧙14㧕㧔㧞㧕ࡐ࡝ࠧࡦ߆ࠄߩࡃࡈࠔ૞ᚑ ࡐ࡝ࠧࡦ࠺࡯࠲࠮࠶࠻ౝ
ౝ᳓㕙߆ࠄࠝࡉࠫࠚࠢ࠻ࠍㆬᛯߒ㧘ฝࠢ࡝࠶ࠢ߆ࠄ‫↢ࠍࠔࡈࡃޡ‬ᚑ‫ࠍޢ‬ㆬᛯߒ߹ߔ‫ࠔࡈࡃޕ‬ඨᓘ╬ߩࡄ࡜ࡔ࡯࠲ࠍ⸳ቯᓟ㧘OK ࠃࠅ࠺࡯࠲࠮࠶࠻ Buffer ߇૞ᚑߐࠇ߹
ߔ‫ޕ‬㧔࿑㧡㧙15㧕㧟㧚ࡏࡠࡁࠗ࿑
ⶄᢙߩࡐࠗࡦ࠻߇ಽᏓߔࠆⓨ㑆ߦ߅޿ߡ㧘޽ࠆࡐࠗࡦ࠻߆ࠄߩ〒㔌߇ઁߩ޿߆ߥࠆࡐࠗࡦ࠻߆
ࠄߩ〒㔌ࠃࠅዊߐ޿ⓨ㑆ࠍ㧘ߘߩࡐࠗࡦ࠻ߣኻᔕߐߖߚ㗔ၞߣߒߡ඙ಽߒ૞ᚑߒߚⓨ㑆඙ಽ࿑ࠍࡏࡠࡁࠗ࿑ߣ๭߮߹ߔ‫ࠗࡁࡠࡏޕ‬࿑ߪേ‛ߩߥࠊ߫ࠅ߿ࠦࡦࡆ࠾ߥߤߩ໡࿤ࠍផቯߔࠆ㗔ၞ↢ᚑߦ೑↪ߐࠇߡ޿߹ߔ‫ޕ‬SuperMap ߢߪࡏࡠࡁࠗ࿑૞ᚑ࠷࡯࡞߇ឭଏߐࠇߡ޿ࠆߩߢ◲නߦ૞ᚑߔ
ቇᩞࠍ૶ߞߡࡐࡠࡁࠗ࿑ࠍ
ࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬એਅ㧘map25k2_vec ਛߩࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ቇ
૞ᚑߒ߹ߔ‫ޕ‬ቇᩞࠍ⴫␜ߒ߹ߔ‫ޕ‬ Ԙࡑ࠶ࡊߦ࠺࡯࠲࠮࠶࠻ቇ ԙࡔ࠾ࡘ࡯ࠃࠅ‫⸃ޡ‬ᨆ‫ޢ‬㧛‫ࠗࡁࡠࡏޡ‬࿑ߩ↢ᚑ‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬ Ԛ‫ࠗࡁࡠࡏޡ‬࿑ߩ↢ᚑ‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔ‫ޕ‬㧔࿑㧡㧙16㧕ԛ‫↢ޡ‬ᚑర࠺࡯࠲‫ޢ‬㧔ࡏࡠࡁࠗ࿑૞ᚑಣℂࠍᣉߔࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻㧕ࠍㆬᛯߒ߹ߔ‫ޕ‬㧔࠺ቇᩞ㧕࡯࠲࠮࠶࠻ቇ
Ԝ‫↢ޡ‬ᚑవ࠺࡯࠲‫ޢ‬㧔↢ᚑߒߚࡏࡠࡁࠗࡐ࡝ࠧࡦࠝࡉࠫࠚࠢ࠻ࠍ଻ሽߔࠆ࠺࡯࠲࠮࠶࠻ฬ⒓㧕
ࠍ౉ജߒ߹ߔ‫ޕ‬ ԝOK ࡏ࠲ࡦࠃࠅಣℂ㐿ᆎߒ߹ߔ‫↢ޕ‬ᚑߒߚࡏࡠࡁࠗ࿑ߪᣂⷙ࠺࡯࠲࠮࠶࠻ RgnDT ߣߒߡ଻ሽߐࠇ߹ߔ‫ࠆߔ␜⴫ࡊ࠶ࡑߪߦ߼ߚߩ⹺⏕ޕ‬ᔅⷐ߇޽ࠅ߹ߔ‫ޕ‬㧔࿑㧡㧙17㧕 ↢ᚑߒߚࡏࡠࡁࠗ࿑ߢߪᄖ✼ㇱಽߦಽᏓߔࠆࡐࠗࡦ࠻ߩಣℂ߇‫▸࠻࠶࠮࠲࡯࠺ޡ‬࿐‫ࠊⴕߢ߹ޢ‬ࠇߡ޿߹ߔ‫ޕ‬㧔‫▸࠻࠶࠮࠲࡯࠺ޡ‬࿐‫࠻࠶࠮࠲࡯࠺ߪޢ‬ቇቇᩞฝࠢ࡝࠶ࠢ߆ࠄ‫ޡ‬ዻᕈ‫ߣߎࠆߔ⹺⏕ߢޢ‬߇น⢻ߢߔ㧕ታ㓙ߦࡏࡠࡁࠗ࿑ࠍ೑↪ߔࠆ㓙ߪ㧘ᄖ✼ߩࡐࠗࡦ࠻ࠍ⚿ࠎߛ▸࿐ߢࡑ࠶ࡊࠢ࡝࠶ࡊ
ಣℂࠍߔࠆ߆㧘࠺࡯࠲▸࿐ࠍ⸳ቯߒߚ࠺࡯࠲࠮࠶࠻㧔ߎߩ଀ߢߪᴒ
ᴒ✽ፉ㧾㧕ߢ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ޢ‬ᚻᴺߢਇⷐㇱಽࠍ೥㒰ߒߡ೑↪ߒ߹ߔ‫ޕ‬ࡔ࠶ࠪࡘࡐ࡝ࠧࡦߩ૞ᚑ ࡔ࠶ࠪࡘࡐ࡝ࠧࡦ㧔࠲ࠗ࡞ࡐ࡝ࠧࡦ㧕ߪ╬㑆㓒ߩࠣ࡝࠶࠼✢ߦ඙ಾࠄࠇߚ⍱ᒻࡐ࡝ࠧࡦߩ㓸ว૕ߢߔ‫⥄ޕ‬ὼ⑼ቇ߿␠ળ⑼ቇߥߤߢߪ㧘⎇ⓥኻ⽎㗔ၞࠍࡔ࠶ࠪࡘࡐ࡝ࠧࡦߢⷒ޿㧘ฦࡔ࠶ࠪࡘߩ
ዻᕈ୯ౝߦⅣႺ᧦ઙ߿⛔⸘㊂ࠍ᦭ߒߚ࠺࡯࠲ࠍ૞ᚑߒ㧘ⓨ㑆᧦ઙࠍන⚐ൻߒಽᨆߔࠆߣߣ߽ߦ㧘ࠪࡒࡘ࡟࡯࡚ࠪࡦ⸃ᨆߥߤߦ߽೑↪ߒߡ޿߹ߔ‫ޕ‬ ߎߎߢߪ㧘਻Ꮊ࿾⾰࠺࡯࠲ߩࡔ࠶ࠪࡘࡐ࡝ࠧࡦࠍ૞ᚑߔࠆᣇᴺࠍ⸃⺑ߒ߹ߔ‫ޕ‬㧝㧚ࡔ࠶ࠪࡘࡐ࡝ࠧࡦߩ૞ᚑ છᗧߩ࠮࡞ࠨࠗ࠭ߩࡔ࠶ࠪࡘࡐ࡝ࠧࡦߪ㧘‫ߩ✢࠼࠶࡝ࠣޟ‬૞ᚑ‫࡯ࠫࡠࡐ࠻ޟߣޠ‬ಣℂ‫ࠍޠ‬૬↪ߒߡ⥄↱ߥࠨࠗ࠭ߢ૞ᚑߔࠆߎߣ߇ߢ߈߹ߔ‫ޕ‬ ਻Ꮊ࿾⾰࠺࡯࠲㧘࠺࡯࠲࠰࡯ࠬ grid_ll ౝߩࡐ࡝ࠧࡦ࠺࡯࠲࠮࠶࠻ geomap ߦኻߒࡔ࠶ࠪࡘࡐ
࡝ࠧࡦࠍḰ஻ߒ߹ߔ‫ޕ‬ Ԙࠣ࡝࠶࠼✢ࠍ૞ᚑߒ߹ߔ‫ࠍޠ␜⴫ߩ✢࠼࠶࡝ࠣޟߪ⚦⹦ޕ‬ෳᾖߒߡߊߛߐ޿‫ߚ߹ޕ‬㧘ࡄ࡜ࡔ࡯࠲ߩ⸳ቯߪ࿑㧢㧙㧝ߦ␜ߒߚߣ߅ࠅߣߥࠅ߹ߔ‫↢ޕ‬ᚑߐࠇߚࠣ࡝࠶࠼ߪ MapDivision ߣߥߞߡ޿߹ߔ‫ޕ‬㧔࿑㧢㧙㧞㧕 ԙ࠻ࡐࡠࠫ࡯ಣℂߦࠃࠅ࡜ࠗࡦ࠺࡯࠲࠮࠶࠻ MapDivision ߆ࠄࡔ࠶ࠪࡘࡐ࡝ࠧࡦࠍ↢ᚑߒ߹ߔ‫ߩ࠻࠶࠮࠲࡯࠺ࡦࠧ࡝ࡐޟߪ⚦⹦ޕ‬૞ᚑ㧞‫ࠍޠ‬ෳᾖߒߡߊߛߐ޿‫ߚ߹ޕ‬㧘ࡄ࡜ࡔ࡯࠲ߩ⸳ቯߪ
࿑㧢㧙㧟ߦ␜ߒߚߣ߅ࠅߣߥࠅ߹ߔ‫↢ޕ‬ᚑߐࠇߚࠣ࡝࠶࠼ߪ grid_2min ߣߥߞߡ޿߹ߔ‫ޕ‬㧔࿑㧢㧙㧠㧕 એ਄ߩᣇᴺߢ࠮࡞ࠨࠗ࠭⥄↱ߦࡔ࠶ࠪࡘࡐ࡝ࠧࡦࠍ૞ᚑߔࠆߎߣ߇ߢ߈߹ߔ‫⸳ߩ࠭ࠗࠨ࡞࠮ޕ‬ቯන૏ߪ✲ᐲ⚻ᐲ♽࠺࡯࠲࠰࡯ࠬߢߪᐲಽ⑽න૏㧘ᐔ㕙⋥ⷺᐳᮡ♽ߢߪ㨙න૏ߣߔࠆߎߣࠍ߅൘
߼ߒ߹ߔ‫ޕ‬㧞㧚ࡔ࠶ࠪࡘࡐ࡝ࠧࡦ߳ߩዻᕈขࠅㄟߺ ㅢᏱ㧘ࡔ࠶ࠪࡘࡐ࡝ࠧࡦߩዻᕈ୯ߪ㧘ฦ࠮࡞ਛᔃὐࠍ฽߻ࠝࡉࠫࠚࠢ࠻ߩዻᕈ୯ߣߥࠅ߹ߔ‫ޕ‬SuperMap ߢߪ⋥ធߎߩಣℂ߇ߢ߈ߥ޿ߩߢ㧘ࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ࠍ੺ߒߡߩಣℂߦߥࠅ߹ߔ‫ޕ‬ߘߩߚ߼㧘ዻᕈ୯ขࠅㄟߺᚻ㗅ߪᄙዋⶄ㔀ߢߔ‫ޕ‬ߘࠇߢߪߘߩ࿾⾰࠺࡯࠲ geomap ߆ࠄࡔ࠶ࠪࡘ grid_2min ߳ߩዻᕈ୯ขࠅㄟߺᚻ㗅ࠍ⺑᣿޿ߚߒ߹ߔ‫ޕ‬
㧔㧝㧕ࡔ࠶ࠪࡘࡐ࡝ࠧࡦ߆ࠄࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻߳ ዻᕈ୯ߩขࠅㄟߺߪࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ࠍ೑↪ߔࠆᔅⷐ߇޽ࠅ߹ߔߩߢ㧘ࡔ࠶ࠪࡘࡐ࡝ࠧࡦ
ߩਛᔃὐࠍࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ߦᄌ឵ߒ߹ߔ‫ޕ‬ Ԙࡔ࠾ࡘ࡯ࠃࠅ‫ޢ࠻࠶࠮࠲࡯࠺ޡ‬㧛‫ߩࡊࠗ࠲࠲࡯࠺ޡ‬ᄌ឵‫ޢ‬㧛‫ߩࡦࠧ࡝ࡐޡ‬ਛᔃὐࠍࡐࠗࡦ࠻
࠺࡯࠲࠮࠶࠻ߦᄌ឵‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬ ԙ‫࠻ࡦࠗࡐޡ‬ਛᔃὐ㧪ࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻‫߇࠙࠼ࡦࠖ࠙ޢ‬㐿߈߹ߔ‫ޕ‬ᄌ឵ߔࠆࡐ࡝ࠧࡦ࠺࡯
࠲࠮࠶࠻㧔grid_2min㧕ߣ↢ᚑߔࠆࡐࠗࡦ࠻࠮࠶࠻ߩฬ⒓ࠍ᳿ቯߒ߹ߔ‫ ߢ࠻࡞ࠜࡈ࠺ޕ‬NewDTߣߥߞߡ޿߹ߔ߇㧘ᄌᦝ߽น⢻ߢߔ‫ޕ‬㧔࿑㧢㧙㧢㧕㧔࿑㧢㧙㧣㧕
 ԚOK ࡏ࠲ࡦߢಣℂ㐿ᆎߢߔ‫ ࠻࠶࠮࠲࡯࠺࠻ࡦࠗࡐޕ‬NewDT ߣߒߡ଻ሽߐࠇ߹ߔ‫ޕ‬㧔㧞㧕ࡐࠗࡦ࠻ࠝࡉࠫࠚࠢ࠻ߦ࿾⾰ዻᕈࠍขࠅㄟ߻ ࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆࠍ૶ߞߡࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ NewDT ߦ࿾⾰࠺࡯࠲ geomap ߩዻᕈࠍขࠅ

ㄟߺ߹ߔ‫ޕ‬㧔࿑㧢㧙㧤㧕⹦⚦ߪ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޟ‬ᨆ‫ࠍޠ‬ෳᾖߒߡߊߛߐ޿‫ޕ‬ Ԙࡔ࠾ࡘ࡯߆ࠄ‫⸃ޡ‬ᨆ‫ޢ‬㧛‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬ ԙ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ߢ࠙࠼ࡦࠖ࠙ޢ‬࿑㧢㧙㧥ߩࠃ߁ߦ⸳ቯߒ߹ߔ‫ޕ‬ Ԛࡈࠖ࡯࡞࠼⸳ቯࡏ࠲ࡦࠍ᛼ߒ㧘‫⸳࠼࡞࡯ࠖࡈޡ‬ቯ‫ࠍ࠙࠼ࡦࠖ࠙ޢ‬࿑㧢㧙10 ߩࠃ߁ߦ⸳ቯߒ߹
ߔ NewDT ߩ SmID ߪࡔ࠶ࠪࡘࡐ࡝ࠧࡦ࠮࡞ߩ ID ߣหߓ߽ߩߢ޽ࠅ㧘࠺࡯࠲ߩࡑ࠶࠴ࡦࠣߢᔅ
ⷐߥᖱႎߢߔ‫ߚ߹ޕ‬㧘geomap ߩ࿾⾰⸥ภߪࡐࠗࡦ࠻ࠝࡉࠫࠚࠢ࠻㧔࠮࡞ߩਛᔃὐ㧕ߩ࿾⾰ᖱႎߣߥࠅ߹ߔ‫ޕ‬ ԛ‫⸃ࠗ࡟࡯ࡃ࡯ࠝޡ‬ᨆ‫ ߩ࠙࠼ࡦࠖ࠙ޢ‬OK ࡏ࠲ࡦࠃࠅ㧘ಣℂ߇㐿ᆎߐࠇᣂⷙ࠺࡯࠲࠮࠶࠻
NewDT_1 ߇↢ᚑߐࠇ߹ߔ‫ޕ‬
NewDT_1 ߪ geomap ߣ NewDT ߇㊀ߥࠅวߞߚㇱಽߢ᭴ᚑߐࠇߚࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ߣߥ
ߞߡ޿߹ߔ‫ޕ‬㧔࿑㧢㧙11㧕㧔㧟㧕ࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ዻᕈࠍࡔ࠶ࠪࡘࡐ࡝ࠧࡦ߳㧙㧝 SuperMap ߦߪ㧘ࡐ࡝ࠧࡦࠝࡉࠫࠚࠢ࠻ౝߦ㧝୘ߩࡐࠗࡦ࠻ࠝࡉࠫࠚࠢ࠻߇฽߹ࠇࠆ႐ว㧘ߘߩዻᕈᖱႎࠍࡐ࡝ࠧࡦ߳ࠦࡇ࡯ߔࠆᯏ⢻߇޽ࠅ߹ߔ‫ޕ‬ Ԙࡔ࠾ࡘ࡯߆ࠄ‫ޢ࠻࠶࠮࠲࡯࠺ޡ‬㧛‫ߩࡊࠗ࠲࠲࡯࠺ޡ‬ᄌ឵‫ޢ‬㧛‫࠻࠶࠮࠲࡯࠺࠻ࡦࠗࡐޡ‬ዻᕈ߆ࠄࡐ࡝ࠧࡦ࠺࡯࠲࠮࠶࠻ߩዻᕈߦᄌ឵‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬ ԙ‫࠻ࡦࠗࡐ࠼ࠗࡠ࠻ࡦ࠮ޡ‬ዻᕈ߆ࠄࡐ࡝ࠧࡦዻᕈ‫ߢ࠙࠼ࡦࠖ࠙ޢ‬㧘࿑㧢㧙13 ߩࠃ߁ߦ⸳ቯߒ߹ߔ‫ޕ‬ ԚOK ࡏ࠲ࡦࠃࠅಣℂ߇㐿ᆎߐࠇ grid_2min ߦዻᕈ୯߇ࠦࡇ࡯ߐࠇ߹ߔ‫ޕ‬ ቢᚑߒߚࡔ࠶ࠪࡘࡐ࡝ࠧࡦ࠺࡯࠲ grid_2min ߩࡈࠖ࡯࡞࠼࿾⾰⸥ภߦߟ޿ߡ૞ᚑߒߚ୘೎ਥ㗴࿑ࠍ࿑㧢㧙14 ߦ␜ߒ߹ߔ‫ޕ‬㧔㧠㧕ࡐࠗࡦ࠻࠺࡯࠲࠮࠶࠻ዻᕈࠍࡔ࠶ࠪࡘࡐ࡝ࠧࡦ߳㧙㧞 NewDT_1 ߩዻᕈࡈࠖ࡯࡞࠼ NewDT_SmID ߣ grid_2min ߩ SmID ߪࠠ࡯ߣߒߡኻᔕߒߡ޿
߹ߔ‫ޡߢߎߘޕ‬ዻᕈ࠹࡯ࡉ࡞ߩ⚿ว‫࠻࠶࠮࠲࡯࠺࠻ࡦࠗࡐߡߞ૶ࠍޢ‬ዻᕈࠍࡔ࠶ࠪࡘࡐ࡝ࠧࡦ߳
⚿วߔࠆߎߣ߇ߢ߈߹ߔ‫ߩߎޕ‬႐ว㧘ࠠ࡯ߣߔࠆዻᕈࡈࠖ࡯࡞࠼ߪฬ⒓߇หߓߢ޽ࠆᔅⷐ߇޽ࠆ
ߚ߼㧘grid_2min ߩ SmID ࠍ NewDT_SmID ࡈࠖ࡯࡞࠼ߦࠦࡇ࡯ߔࠆᔅⷐ߇޽ࠅ߹ߔ㧔SQL ࠢࠛ࡝ߢⴕ޿߹ߔ㧕‫ߚ߹ޕ‬㧘‫ޡ‬ዻᕈ࠹࡯ࡉ࡞ߩ⚿ว‫⸳ߩߢ࠙࠼ࡦࠖ࠙ޢ‬ቯߪ࿑㧢㧙15 ߦߥࠅ߹ߔ‫ޕ‬ฦ࠮࡞ౝߢᦨᄢ㕙Ⓧࠍ␜ߔዻᕈࠍࡔ࠶ࠪࡘࡐ࡝ࠧࡦዻᕈ୯ߣߔࠆᚻᴺߪ㧘࿾⾰࠺࡯࠲ geomapߣࡔ࠶ࠪࡘ grid_2min ߩࠝ࡯ࡃ࡯࡟ࠗ⸃ᨆߣ SQL ࠢࠛ࡝ࠍ⚵ߺวࠊߖࠆߎߣߢน⢻ߢߔ߇㧘ߘߩᚻ㗅ߪⶄ㔀ߢߔ‫ޕ‬ዻᕈ୯ࠍࠛࠢࠬࡐ࡯࠻ߒ㧘ઁߩ࠰ࡈ࠻ߢಣℂᓟ SuperMap ߦࠗࡦࡐ࡯࠻ߘߒ
ߡࡑ࡯ࠫߔࠆᣇᴺࠍ߅൘߼ߒ߹ߔ‫ޕ‬㧟㧚ࡔ࠶ࠪࡘࡐ࡝ࠧࡦዻᕈ୯ߩࠗࡦࡐ࡯࠻ࠛࠢࠬࡐ࡯࠻ ࡔ࠶ࠪࡘࡐ࡝ࠧࡦߩ࠮࡞ⴕ೉૏⟎߆ࠄ▚಴ߒߚ ID ࠍ೑↪ߔࠆߣ㧘ዻᕈᖱႎࠍࠛࠢࠬࡐ࡯࠻ߒ
ߡ೑↪ߔࠆ႐ว߿㧘ઁߩ࠰ࡈ࠻ߢ▚಴ߒߚ⚿ᨐࠍࠗࡦࡐ࡯࠻ߒߡ೑↪ߔࠆ႐วߥߤߦଢ೑ߢߔ‫ޕ‬㧔㧝㧕ࡔ࠶ࠪࡘࡐ࡝ࠧࡦ࠮࡞ਛᔃᐳᮡࠍዻᕈߦขࠅㄟ߻
‫ޡ‬ዻᕈ‫ޡߩ࠙࠼ࡦࠖ࠙ޢ‬ዻᕈ⴫ߩ᭴ᚑ‫ࠄ߆ޢ‬ᣂⷙ Ԙgrid_2min ฝࠢ࡝࠶ࠢࠃࠅ‫ޡ‬ዻᕈ‫ߦޢ‬ㅴߺ㧘ࡈࠖ࡯࡞࠼ࠍ૞ᚑߒ߹ߔ‫ޕ‬ ԙ࠮࡞ਛᔃᐳᮡࠍ⸥౉ߔࠆߚ߼㧘ࡈࠖ࡯࡞࠼ฬ㧦㨤㧘ࡈࠖ࡯࡞࠼ဳ㧦୚♖ᐲဳ෸߮ࡈࠖ࡯࡞࠼
ฬ㧦㨥㧘ࡈࠖ࡯࡞࠼ဳ㧦୚♖ᐲဳߩࡈࠖ࡯࡞࠼㧞୘ࠍㅊടߒ߹ߔ‫ޕ‬㧔࿑㧢㧙16㧕 Ԛgrid_2min ฝࠢ࡝࠶ࠢࠃࠅ‫ޡ‬ዻᕈ࠺࡯࠲ߩ⴫␜‫ߦޢ‬ㅴߺ㧘ዻᕈ࠹࡯ࡉ࡞ࠍ⴫␜ߐߖ߹ߔ‫ޕ‬ ԛዻᕈ࠹࡯ࡉ࡞ฝࠢ࡝࠶ࠢࠃࠅ‫ᦝߩ࠼࡞࡯ࠖࡈޡ‬ᣂ‫ߦޢ‬ㅴߺ߹ߔ‫ޕ‬Ԝ‫ᦝߩ࠼࡞࡯ࠖࡈޡ‬ᣂ‫࠼࡞࡯ࠖࡈߢ࠙࠼ࡦࠖ࠙ޢ‬㨤ߦ࠮࡞ਛᔃ㨤ᐳᮡ୯㧔㑐ᢙ ObjCenterX㧕ࠍ⸳ቯߒ㧘ㆡ↪߹ߚߪ OK ࡏ࠲ࡦߢಣℂ㐿ᆎߢߔ‫ޕ‬㧔࿑㧢㧙17㧕ԝห᭽ߩಣℂࠍࡈࠖ࡯࡞࠼㨥ߦኻߒߡⴕ޿߹ߔ‫ࠆߔ↪૶ߢࠄߜߎޕ‬㑐ᢙߪ ObjCenterY ߣߥࠅ߹ߔ‫ޕ‬ એ਄ߢ࠮࡞ਛᔃᐳᮡߩขࠅㄟߺߪ⚳ੌߢߔ߇㧔࿑㧢㧙18㧕㧘࠮࡞ⴕ೉૏⟎ࠍ⸘▚ߔࠆߚ߼ߦ㨤࡮㨥ᐳᮡߩᦨዊ୯ࠍ⺞ߴߡ߅߈߹ߔ‫ߪࠇߎޕ‬ዻᕈ࠹࡯ࡉ࡞ฝࠢ࡝࠶ࠢࠃࠅ‫ߦޢ⸘⛔ߩ࠼࡞࡯ࠖࡈޡ‬ㅴߺ㧘㐿޿ߚ‫࠼࡞࡯ࠖࡈߢ࠙࠼ࡦࠖ࠙ޢ⸘⛔ߩ࠼࡞࡯ࠖࡈޡ‬㨤㧘㨥ߩ⸳ቯᓟ㧘⛔⸘ࡏ࠲ࡦࠃࠅ⸘
▚⚿ᨐࠍ⴫␜ߒ߹ߔ‫ޕ‬㧔࿑㧢㧙19㧕㧔㧞㧕࠮࡞ⴕ೉૏⟎㧵㧰ߩ૞ᚑ ࡈࠖ࡯࡞࠼㨤㧘㨥෸߮ߘࠇߙࠇߩᦨዊ୯ࠍ૶ߞߡ࠮࡞૏⟎ࠍ⴫ߔ ID ࠍ૞ᚑߒ߹ߔ‫ߢߎߎޕ‬૞ᚑߔࠆ ID ߪ࠹ࠠࠬ࠻ᒻᑼߢ‫⇟ⴕ࡞࠮ޟ‬ภ‫ޠ‬㧗‫࡞࠮ޟ‬೉⇟ภ‫ޡޕߔ߹ࠅߥߣޠ‬SQL ࠢࠛ࡝‫૶ࠍޢ‬ߞߡ૞ᚑߒ߹ߔ‫ޕ‬࠮࡞ⴕ⇟ภ i ߪ 㨕㧩int㧖㧝㧔㧔㨥㧙㨇ࡈࠖ࡯࡞࠼㨥ᦨዊ୯㨉㧕㧛㧔㧞㧛㧢㧜㧖㧞㧕㧗㧜㧚㧡㧖㧟㧕   㧖㧝㧦ᢛᢙൻ㑐ᢙ㧘㧖㧞㧦grid_2min ߪ㧞ಽࠣ࡝࠶࠼ߢᐲߦᄌ឵㧘㧖㧟㧦ᩴ⪭ߜ੍㒐࠮࡞೉⇟ภ㨖ߪ 㨖㧩int㧔㧔㨤㧙㨇ࡈࠖ࡯࡞࠼㨤ᦨዊ୯㨉㧕㧛㧔㧞㧛㧢㧜㧕㧗㧜㧚㧡㧕ߢ▚಴ߐࠇ߹ߔ‫ߩࡦࠧ࡝ࡐࡘࠪ࠶ࡔ߅ߥޕ‬Ꮐਅⷺߩ࠮࡞ࠍⴕ⇟ภ㧜㧘೉⇟ภ㧜ߣߒߡ޿߹ߔ‫ޕ‬ ਄⸥࠮࡞ⴕ⇟ภߣ೉⇟ภ߆ࠄ࠹ࠠࠬ࠻ဳߩ ID ࠍ▚಴ߒ߹ߔ‫▚ޕ‬಴ߦߪᢙ୯ᢥሼ೉ᄌ឵㑐ᢙ
STR ࠍ૶޿߹ߔ‫ ޕ‬ID㧩 str㧔㨕㧕㧗str㧔㨖㧕ታ㓙ߦߪ‫ޡ‬SQL ࠢࠛ࡝࠙ࠖࡦ࠼࠙‫࠼࡞࡯ࠖࡈߩޢ‬ฬߦᰴߩ࠹ࠠࠬ࠻ࠍᦠ߈ㄟߺ߹ߔ‫ޕ‬㧔࿑㧢㧙
20㧕
 grid_2min.*,str(int(y-30.9833)*30+0.5))+ str(int(x-129.3167)*30+0.5)) as ID ↢ᚑߐࠇߚ ID ߪ㧘ᢙ୯߆ࠄᢥሼ೉ᄌ឵ߩㆊ⒟ߢవ㗡ߦඨⷺⓨ⊕㧝ᢥሼ߇౉ߞߡߒ߹߁ߚ߼㧘̌㨇ඨⷺⓨ⊕㨉ⴕ⇟ภ㨇ඨⷺⓨ⊕㨉೉⇟ภ̍ߣߥߞߡ޿߹ߔ‫ޕ‬㧔࿑㧢㧙21㧕ID ࠍ૶ߞߡᄖㇱ࠺࡯࠲ߩࠗࡦࡐ࡯࠻╬ࠍⴕ߁႐วߪᵈᗧ߇ᔅⷐߢߔ‫ޕ‬

࿑㧝㧙㧝

࿑㧝㧙㧟

㧭

㧮

࿑㧝㧙㧠
㧯

࿑㧝㧙㧞

࿑㧝㧙㧡

࿑㧝㧙㧢

࿑㧝㧙㧤

࿑㧝㧙㧣
࿑㧝㧙㧥

࿑㧝㧙10

࿑㧝㧙12

࿑㧝㧙11

࿑㧝㧙13

࿑㧝㧙14

࿑㧝㧙18

࿑㧝㧙15

࿑㧝㧙16

࿑㧝㧙17

࿑㧝㧙19

࿑㧞㧙㧝
࿑㧝㧙20

࿑㧝㧙2㧝

࿑㧞㧙㧞

࿑㧞㧙㧡

࿑㧞㧙㧟

࿑㧞㧙㧢

࿑㧞㧙㧠

࿑㧞㧙㧣

࿑㧞㧙㧤

࿑㧞㧙11

࿑㧞㧙12

࿑㧞㧙㧥

࿑㧞㧙13
࿑㧞㧙10

࿑㧞㧙14

࿑㧞㧙17

࿑㧞㧙18

࿑㧞㧙15

࿑㧞㧙16
࿑㧞㧙19

࿑㧞㧙20

࿑㧟㧙㧝

࿑㧞㧙21

࿑㧟㧙㧞

࿑㧟㧙㧟

࿑㧟㧙㧠

࿑㧟㧙㧤

࿑㧟㧙㧡

࿑㧟㧙㧥

࿑㧟㧙10
࿑㧟㧙㧢

࿑㧟㧙㧣

࿑㧟㧙11

࿑㧟㧙12

࿑㧟㧙15

࿑㧟㧙13

࿑㧟㧙14

࿑㧠㧙㧟

࿑㧠㧙㧝

࿑㧠㧙㧠
࿑㧠㧙㧞

࿑㧠㧙㧣

࿑㧠㧙㧡

࿑㧠㧙㧢

࿑㧠㧙㧤

࿑㧠㧙㧥

࿑㧠㧙11

࿑㧠㧙10

࿑㧡㧙㧟
࿑㧡㧙㧝

࿑㧡㧙㧠

࿑㧡㧙㧞

࿑㧡㧙㧡

࿑㧡㧙㧢

࿑㧡㧙㧤

࿑㧡㧙㧣

࿑㧡㧙㧥

࿑㧡㧙10

࿑㧡㧙11

࿑㧡㧙13

࿑㧡㧙14

࿑㧡㧙1㧞

࿑㧡㧙15

࿑㧡㧙17

࿑㧡㧙16

࿑㧢㧙㧝

࿑㧢㧙㧟

࿑㧢㧙㧠
࿑㧢㧙㧞

࿑㧢㧙㧣
࿑㧢㧙㧡

࿑㧢㧙㧢

࿑㧢㧙㧤

࿑㧢㧙㧥

࿑㧢㧙11

࿑㧢㧙10

࿑㧢㧙12

࿑㧢㧙13
࿑㧢㧙15

࿑㧢㧙16

࿑㧢㧙14

࿑㧢㧙17

࿑㧢㧙20
࿑㧢㧙18

࿑㧢㧙21
࿑㧢㧙19

࿑㧝㧙22

࿑㧝㧙24

࿑㧝㧙25
࿑㧝㧙23

࿑㧝㧙26

࿑㧠㧙13

࿑㧠㧙14

࿑㧠㧙12

࿑㧠㧙17
࿑㧠㧙15

࿑㧠㧙18

࿑㧠㧙16

࿑㧠㧙21
࿑㧠㧙19

࿑㧠㧙22
࿑㧠㧙20