0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

neo4jでsandbox その6

Posted at

概要

neo4jでsandboxやってみた。
鉄道、路線、やってみた。

参考にしたページ

データ投入

CREATE
(I01:Station {name:"目黒駅", no:"I01"}),
(I02:Station {name:"白金台駅", no:"I02"}),
(I03:Station {name:"白金高輪駅", no:"I03"}),
(I04:Station {name:"三田駅   ", no:"I04"}),
(I05:Station {name:"芝公園駅", no:"I05"}),
(I06:Station {name:"御成門駅", no:"I06"}),
(I07:Station {name:"内幸町駅", no:"I07"}),
(I08:Station {name:"日比谷駅", no:"I08"}),
(I09:Station {name:"大手町駅", no:"I09"}),
(I10S06:Station {name:"神保町駅", no:"I10"}),
(I11:Station {name:"水道橋駅", no:"I11"}),
(I12:Station {name:"春日駅", no:"I12"}),
(I13:Station {name:"白山駅", no:"I13"}),
(I14:Station {name:"千石駅", no:"I14"}),
(I15JY11:Station {name:"巣鴨駅", no:"I15JY11"}),
(I16:Station {name:"西巣鴨駅", no:"I16"}),
(I17:Station {name:"新板橋駅", no:"I17"}),
(I18:Station {name:"板橋区役所前駅", no:"I18"}),
(I19:Station {name:"板橋本町駅", no:"I19"}),
(I20:Station {name:"本蓮沼駅", no:"I20"}),
(I21:Station {name:"志村坂上駅", no:"I21"}),
(I22:Station {name:"志村三丁目駅", no:"I22"}),
(I23:Station {name:"蓮根駅", no:"I23"}),
(I24:Station {name:"西台駅", no:"I24"}),
(I25:Station {name:"高島平駅", no:"I25"}),
(I26:Station {name:"新高島平駅", no:"I26"}),
(I27:Station {name:"西高島平駅", no:"I27"}),
(I01)-[:三田線]->(I02), (I02)-[:三田線]->(I01),
(I02)-[:三田線]->(I03), (I03)-[:三田線]->(I02),
(I03)-[:三田線]->(I04), (I04)-[:三田線]->(I03),
(I04)-[:三田線]->(I05), (I05)-[:三田線]->(I04),
(I05)-[:三田線]->(I06), (I06)-[:三田線]->(I05),
(I06)-[:三田線]->(I07), (I07)-[:三田線]->(I06),
(I07)-[:三田線]->(I08), (I08)-[:三田線]->(I07),
(I08)-[:三田線]->(I09), (I09)-[:三田線]->(I08),
(I09)-[:三田線]->(I10S06), (I10S06)-[:三田線]->(I09),
(I10S06)-[:三田線]->(I11), (I11)-[:三田線]->(I10S06),
(I11)-[:三田線]->(I12), (I12)-[:三田線]->(I11),
(I12)-[:三田線]->(I13), (I13)-[:三田線]->(I12),
(I13)-[:三田線]->(I14), (I14)-[:三田線]->(I13),
(I14)-[:三田線]->(I15JY11), (I15JY11)-[:三田線]->(I14),
(I15JY11)-[:三田線]->(I16), (I16)-[:三田線]->(I15JY11),
(I16)-[:三田線]->(I17), (I17)-[:三田線]->(I16),
(I17)-[:三田線]->(I18), (I18)-[:三田線]->(I17),
(I18)-[:三田線]->(I19), (I19)-[:三田線]->(I18),
(I19)-[:三田線]->(I20), (I20)-[:三田線]->(I19),
(I20)-[:三田線]->(I21), (I21)-[:三田線]->(I20),
(I21)-[:三田線]->(I22), (I22)-[:三田線]->(I21),
(I22)-[:三田線]->(I23), (I23)-[:三田線]->(I22),
(I23)-[:三田線]->(I24), (I24)-[:三田線]->(I23),
(I24)-[:三田線]->(I25), (I25)-[:三田線]->(I24),
(I25)-[:三田線]->(I26), (I26)-[:三田線]->(I25),
(I26)-[:三田線]->(I27), (I27)-[:三田線]->(I26),
(S01JY17:Station {name:"新宿駅", no:"S01JY17"}),
(S02:Station {name:"新宿三丁目駅", no:"S02"}),
(S03:Station {name:"曙橋駅", no:"S03"}),
(S04:Station {name:"市ヶ谷駅", no:"S04"}),
(S05:Station {name:"九段下駅", no:"S05"}),
(S07:Station {name:"小川町駅", no:"S07"}),
(S08:Station {name:"岩本町駅", no:"S08"}),
(S09:Station {name:"馬喰横山駅", no:"S09"}),
(S10:Station {name:"浜町駅", no:"S10"}),
(S11:Station {name:"森下駅", no:"S11"}),
(S12:Station {name:"菊川駅", no:"S12"}),
(S13:Station {name:"住吉駅", no:"S13"}),
(S14:Station {name:"西大島駅", no:"S14"}),
(S15:Station {name:"大島駅", no:"S15"}),
(S16:Station {name:"東大島駅", no:"S16"}),
(S17:Station {name:"船堀駅", no:"S17"}),
(S18:Station {name:"一之江駅", no:"S18"}),
(S19:Station {name:"瑞江駅", no:"S19"}),
(S20:Station {name:"篠崎駅", no:"S20"}),
(S21:Station {name:"本八幡駅", no:"S21"}),
(S01JY17)-[:新宿線]->(S02), (S02)-[:新宿線]->(S01JY17),
(S02)-[:新宿線]->(S03), (S03)-[:新宿線]->(S02),
(S03)-[:新宿線]->(S04), (S04)-[:新宿線]->(S03),
(S04)-[:新宿線]->(S05), (S05)-[:新宿線]->(S04),
(S05)-[:新宿線]->(I10S06), (I10S06)-[:新宿線]->(S05),
(I10S06)-[:新宿線]->(S07), (S07)-[:新宿線]->(I10S06),
(S07)-[:新宿線]->(S08), (S08)-[:新宿線]->(S07),
(S08)-[:新宿線]->(S09), (S09)-[:新宿線]->(S08),
(S09)-[:新宿線]->(S10), (S10)-[:新宿線]->(S09),
(S10)-[:新宿線]->(S11), (S11)-[:新宿線]->(S10),
(S11)-[:新宿線]->(S12), (S12)-[:新宿線]->(S11),
(S12)-[:新宿線]->(S13), (S13)-[:新宿線]->(S12),
(S13)-[:新宿線]->(S14), (S14)-[:新宿線]->(S13),
(S14)-[:新宿線]->(S15), (S15)-[:新宿線]->(S14),
(S15)-[:新宿線]->(S16), (S16)-[:新宿線]->(S15),
(S16)-[:新宿線]->(S17), (S17)-[:新宿線]->(S16),
(S17)-[:新宿線]->(S18), (S18)-[:新宿線]->(S17),
(S18)-[:新宿線]->(S19), (S19)-[:新宿線]->(S18),
(S19)-[:新宿線]->(S20), (S20)-[:新宿線]->(S19),
(S20)-[:新宿線]->(S21), (S21)-[:新宿線]->(S20),
(JY25:Station {name:"品川駅", no:"JY25"}),
(JY24:Station {name:"大崎駅", no:"JY24"}),
(JY23:Station {name:"五反田駅", no:"JY23"}),
(JY22:Station {name:"目黒駅", no:"JY22"}),
(JY21:Station {name:"恵比寿駅", no:"JY21"}),
(JY20:Station {name:"渋谷駅", no:"JY20"}),
(JY19:Station {name:"原宿駅", no:"JY19"}),
(JY18:Station {name:"代々木駅", no:"JY18"}),
(JY16:Station {name:"新大久保駅", no:"JY16"}),
(JY15:Station {name:"高田馬場駅", no:"JY15"}),
(JY14:Station {name:"目白駅", no:"JY14"}),
(JY13:Station {name:"池袋駅", no:"JY13"}),
(JY12:Station {name:"大塚駅", no:"JY12"}),
(JY10:Station {name:"駒込駅", no:"JY10"}),
(JY09:Station {name:"田端駅", no:"JY09"}),
(JY08:Station {name:"西日暮里駅", no:"JY08"}),
(JY07:Station {name:"日暮里駅", no:"JY07"}),
(JY06:Station {name:"鶯谷駅", no:"JY06"}),
(JY05:Station {name:"上野駅", no:"JY05"}),
(JY04:Station {name:"御徒町駅", no:"JY04"}),
(JY03:Station {name:"秋葉原駅", no:"JY03"}),
(JY02:Station {name:"神田駅", no:"JY02"}),
(JY01:Station {name:"東京駅", no:"JY01"}),
(JY30:Station {name:"有楽町駅", no:"JY30"}),
(JY29:Station {name:"新橋駅", no:"JY29"}),
(JY28:Station {name:"浜松町駅", no:"JY28"}),
(JY27:Station {name:"田町駅", no:"JY27"}),
(JY25)-[:山手線]->(JY24), (JY24)-[:山手線]->(JY25),
(JY24)-[:山手線]->(JY23), (JY23)-[:山手線]->(JY24),
(JY23)-[:山手線]->(JY22), (JY22)-[:山手線]->(JY23),
(JY22)-[:山手線]->(JY21), (JY21)-[:山手線]->(JY22),
(JY21)-[:山手線]->(JY20), (JY20)-[:山手線]->(JY21),
(JY20)-[:山手線]->(JY19), (JY19)-[:山手線]->(JY20),
(JY19)-[:山手線]->(JY18), (JY18)-[:山手線]->(JY19),
(JY18)-[:山手線]->(S01JY17), (S01JY17)-[:山手線]->(JY18),
(S01JY17)-[:山手線]->(JY16), (JY16)-[:山手線]->(S01JY17),
(JY16)-[:山手線]->(JY15), (JY15)-[:山手線]->(JY16),
(JY15)-[:山手線]->(JY14), (JY14)-[:山手線]->(JY15),
(JY14)-[:山手線]->(JY13), (JY13)-[:山手線]->(JY14),
(JY13)-[:山手線]->(JY12), (JY12)-[:山手線]->(JY13),
(JY12)-[:山手線]->(I15JY11), (I15JY11)-[:山手線]->(JY12),
(I15JY11)-[:山手線]->(JY10), (JY10)-[:山手線]->(I15JY11),
(JY10)-[:山手線]->(JY09), (JY09)-[:山手線]->(JY10),
(JY09)-[:山手線]->(JY08), (JY08)-[:山手線]->(JY09),
(JY08)-[:山手線]->(JY07), (JY07)-[:山手線]->(JY08),
(JY07)-[:山手線]->(JY06), (JY06)-[:山手線]->(JY07),
(JY06)-[:山手線]->(JY05), (JY05)-[:山手線]->(JY06),
(JY05)-[:山手線]->(JY04), (JY04)-[:山手線]->(JY05),
(JY04)-[:山手線]->(JY03), (JY03)-[:山手線]->(JY04),
(JY03)-[:山手線]->(JY02), (JY02)-[:山手線]->(JY03),
(JY02)-[:山手線]->(JY01), (JY01)-[:山手線]->(JY02),
(JY01)-[:山手線]->(JY30), (JY30)-[:山手線]->(JY01),
(JY30)-[:山手線]->(JY29), (JY29)-[:山手線]->(JY30),
(JY29)-[:山手線]->(JY28), (JY28)-[:山手線]->(JY29),
(JY28)-[:山手線]->(JY27), (JY27)-[:山手線]->(JY28),
(JY27)-[:山手線]->(JY25), (JY25)-[:山手線]->(JY27)
RETURN *;

三田線:西台駅から新宿駅へ行くには

match (start:Station {name:"西台駅"}), (end:Station {name:"新宿駅"}), path = allShortestPaths((start)-[*]-(end))
return start, end, path
LIMIT 50

結果

image.png

以上。

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?