2015 Future University Hakodate 2015 System Information Science Practice Group Report Twitter Project Name Twitter Localization Group Name Search Group /Project No. 19 /Project Leader 1013039 Hirohito Maruyama /Group Leader 1013091 Tasuku Kumamoto /Group Member 1013039 Hirohito Maruyama 1013091 Tasuku Kumamoto 1013108 Naoto Endo 1013210 Junya Inagaki Advisor Kengo Terasawa Takashi Takenouchi Kiyohito Nagano Yasuhiro Katagiri 2016 1 20 Date of Submission January 20, 2016
(SNS). Twitter 2014 12, LINE Facebook, SNS 1., Twitter 80%, Twitter.,,., Twitter,,.,,,, Twitter., Twitter,., Twitter,.,. - i -
Abstract The number of SNS users is increasing.twitter is the most popular service after the LINE and Facebook at December, 2014 and achieves real-time exchange of tweet. 80% of users possessing mobile devices use Twitter and can easily exchange or search information through Twitter, anytime and anywhere. But when we cannot get complete information from Twitter, we need some additional processes with other search engines. For example when we want to search information about restaurants through Twitter, we firstly have to access other search engines to look up names of restaurants if we are not familiar with what kind of restaurants there are in the neighborhood. We propose a new service which makes it possible to get complete and real-time information from Twitter. - ii -
1 1 2 3 3 4 3.1.......................................... 4 3.2.......................................... 4 4 5 4.1................................ 5 4.2....................... 5 4.3............................ 7 4.4............................ 9 4.4.1.................................... 9 4.4.2 API.................................. 9 4.4.3 Git................................... 10 4.4.4........................... 10 4.5.................... 10 4.5.1................................. 10 4.5.2................................. 11 4.6.................................. 11 4.7.................................... 12 4.8.......................... 12 4.8.1 Ajax.................................. 12 4.8.2............................. 13 4.8.3................................ 14 4.8.4................................ 15 4.8.5................................. 16 4.8.6........................... 17 4.9................... 17 4.9.1............................... 17 4.9.2..................................... 18 4.9.3................................... 18 4.9.4................................. 19 4.9.5................................. 20 4.10................................ 21 4.10.1................................... 21 4.10.2............................. 21 - iii -
5 22 5.1......................... 22 5.2.......................... 23 5.3......................... 24 5.4......................... 26 6 27 6.1.......................... 27 6.2..................................... 29 7 30 8 31 32 - iv -
1, Web, (BBS) (Weblog), (SNS) [1]. SNS,, Web [2]., SNS,, 2006 Twitter, 2008 4 23 Twitter Japan [3], 2014 12, LINE Facebook 3 [4]., Twitter 2 8400, 2000 [5]. 140. Twitter 80%[5], Twitter. Twitter,. Twitter Facebook SNS, 2. 1,., 1 5700, [6]. 2, 10 20., Twitter,, Twitter. 2. 1,, Twitter., 2 2., Web Web,, Web Group Report of 2015 SISP - 1 - Group Number 19
, Web.,,. Group Report of 2015 SISP - 2 - Group Number 19
2 10 30 500,, 4 [8].,,.,,.,, Twitter.,, Twitter Twitter., Twitter.,,, Web,, Twitter., 1. Twitter Web,,, Web. Group Report of 2015 SISP - 3 - Group Number 19
3 3.1, Web. Web,,, Twitter Web.,, Twitter, Twitter. Web,,, 1 Web. 3.2 Web,. 1. Web,,,.,,,. 2.,,,,. 3.,,.,,.,,,. Group Report of 2015 SISP - 4 - Group Number 19
4 4.1,,,,., Twitter, Twitter.,, Web 1,. Twitter. Twitter,,., Twitter,,.,,., KJ 2...,. 4.2 4, 4.,.,.,., 4., Group Report of 2015 SISP - 5 - Group Number 19
,,, 4,,. 4, 7W2H. 7W2H When Where Who What Why Whom Which How Howmuch 9,. 7W2H,,., Twitter, Twitter.,,.,, Twitter, Twitter.,,,,., 4., 4, 4 7, 4,, 3 14, 4..,, Group Report of 2015 SISP - 6 - Group Number 19
.,.,,.,,, 2,.,.,,.,,.,, Twitter.,. : 4.3,.,,,,.,,.,,,, Web. Twitter API, PHP., HTML., WBS. WBS Work Breakdown Structure,,. WBS, 4.1..,. API,., 4.2.,,,, Group Report of 2015 SISP - 7 - Group Number 19
.,. 4.1 WBS 4.2 Group Report of 2015 SISP - 8 - Group Number 19
4.3, 4.3.,,,. WBS 3., 3. : 4.4 4.4.1, Web, PC XAMPP.,, MySQL, Apache XAMPP., Localhost,,.. 4.4.2 API API, PHP file get contents() API JSON, PHP JSON, Group Report of 2015 SISP - 9 - Group Number 19
. 4.4.3 Git, Git., Git, Git., GitGUI, Git. 4.4.4,,,.,,.. 4.5.,.,.,. 4.5.1,, 3. Twitter.,,. Twitter, 2., Web., TwitterAPI API..,,. API Web,.,., Web..,,, Group Report of 2015 SISP - 10 - Group Number 19
. 4.5.2,.,.,,.,,,., 1,.,.,.,,,.,. : / 4.6,,.,,,.,,,,.,,., 2. 1,,,. 2,,,., 1.,.,,.,,.,.,.,,.,,.,,,,..,. Group Report of 2015 SISP - 11 - Group Number 19
,.,,. 4.7,.,,.,,,.,. 4.8,, 6. 4.8.1 Ajax, API,, Ajax., [9]. Ajax API,. GeocodingAPI,,,.,,.,,,,, GeocodingAPI.,,, API. API, API. API,,,.,,,,, API,,.,,, Group Report of 2015 SISP - 12 - Group Number 19
,,.,, API,. PHP, JSON Ajax JSON. TwitterAPI, TwitterOAuth TwitterAPI.,., Twitter,.,. TwitterAPI, Twitter,, 1,.,, API.,, 1,.,. Twitter, API,, PHP., API,, 2,, JSON,.,., Twitter. 4.8.2,..,,.,,. Group Report of 2015 SISP - 13 - Group Number 19
, 4.4,,.,. 4.4,,.,. 4.. 4.8.3, OpenStreetMap, OpenLayers. OpenLayers,, OpenLayers Leaflet. Leaflet,,,. Leaflet,. Group Report of 2015 SISP - 14 - Group Number 19
: 4.8.4,. GPS,., GPS,,.,,.,,., 4.5., HTML.,.,.., Twitter, 10. 4.5 Group Report of 2015 SISP - 15 - Group Number 19
: 4.8.5,,.,,.,,.,,, (, ) AND.,,.,,,,., 1,, 1. NTT, 8, 4 [10]..,.,, AND.,,. 3, positive array 3, negative array, PHP., AND (positive array) AND (negative array), AND.,,.,,., PHP strpos, 1,.,., 1. TwitterAPI, 100, 1,, strpos.,, 100,. PHP strpos,, strpos strstr, 1 0.03 [11].,, 200 100 0.03 600, Web.,,,,. SQL LIKE, 1 0.006, 12. SQL, SQL., JavaScript. JavaScript SQL LIKE Group Report of 2015 SISP - 16 - Group Number 19
,,.,,., Web 4.1, 100.,,,, 3.,,,,. 4.1,,,,,,,,, 4.8.6,.,,.,.,.,.,,., PHP,,. : 4.9 4.9.1,,,., 1.,, Group Report of 2015 SISP - 17 - Group Number 19
,.,. 1,.,,.,,.,,.,.,,.,,. 4.9.2,,,,.,,,,.,.,. 4.9.3, 1.,.,,.,. Group Report of 2015 SISP - 18 - Group Number 19
4.9.4,, 1.,,,.,,.,.,.,.,,,,..,,.,,.,,.,,, Web QR.,.,.,,.,,,, ( 4.6).,,,,. Group Report of 2015 SISP - 19 - Group Number 19
Twitter Localization 図 4.6 最終発表時のポスター 文責: 遠藤直人 4.9.5 スライド作成 最終成果発表でのスライドは, 構成とレイアウトに関しては中間発表時のスライドを継続して使 用することとなった. これは, 中間発表時と同じスライドデザインを用いることによって中間発表 時の来場者が同じプロジェクトであることがすぐわかるのではないかという意見によって採用さ れた. スライドは事前に内容を決定済みであったポスターの内容に準ずる形で作成を行った. 中間 発表時ではパソコン版のサービスしか構想していなかったため, 使用した図もパソコン版のもので あったが, 最終成果発表では新たに作成したスマートフォン版のウェブアプリケーションをもとに して説明を行う形を採用した. これは, 実際に飲食店を検索する場合は外出先でスマートフォンを 用いることが多いことが理由になっている. スライドはプロジェクト全体部分と, 分析班と検索班の部分をそれぞれ個別に作成し, 最終的に それらを 1 つのデザインに統合する形をとった. これにより, 各グループが同時に作成作業を行う ことができ効率的にスライド作成を行うことができた. スライドを作成後, 各グループにおいて原 稿の作成作業を行った. 本プロジェクトのスライドは成果物や動作について図解することを目的に Group Report of 2015 SISP - 20 - Group Number 19
,.,.,.,.,.,,. 4,. : 4.10 4.10.1, 120 3, 3 6, 3,.,,. 4.10.2, 2.,.,.,,,.,,.,,,. Group Report of 2015 SISP - 21 - Group Number 19
5 5.1,. 1 2, 3..,.,..,, Web,.,,..,. Twitter,,.,,,.,..,.,,,., Google Drive Group Report of 2015 SISP - 22 - Group Number 19
WBS 7W2H.,.,,., Web,. UI, HTML, CSS, JavaScript, jquery..,,.,,,,.,. 5.2, Twitter, Twitter., Twitter.,.,,,., WBS.,., PHP, HTML CSS, JavaScript..,, GitHub,., GitHub.,,..,,.,. DOM.. GitHub, Group Report of 2015 SISP - 23 - Group Number 19
1.,.,.,...,,., 1..,.,,.,. : 5.3, Twitter., Twitter., Twitter.,,., 1,.,.,,.,,,.,.,., NTT docomo, [12].,,.,,.,,.,.,,., Twitter,.,.,, Group Report of 2015 SISP - 24 - Group Number 19
.,., PHP,,.,,., PHP, Web.,,.,.,.,. Web,,.,. 2., Object,., Array,.,,.,,.,,.,, 100., AND,., PHP, PHP,, Javascript SQL.,,.,,,.,.,.,, Twitter.,,.,.,.,.,.,,,.,,.,,.,. Twitter,,,.,,,.,, Group Report of 2015 SISP - 25 - Group Number 19
.,.,.,. 5.4, Twitter,. Twitter 4, Twitter 7, 4. 4,,,,,., Web,.,,.,, PHP API,.,.,,,, 3., 3., PHP, OpenWeatherMap API TwitterAPI, Twitter BOT,., API, TwitterAPI, GeocodingAPI.,,, Ajax,. Ajax, API,. PHP, JavaScript.,.., 3., 2. Group Report of 2015 SISP - 26 - Group Number 19
6 6.1, Web.,. 6.1, 6.2,.,,,. 6.1, 6.2.,.,, 6.3. 6.4 16. 6.5,,.,,.., 6.6.,.,. Group Report of 2015 SISP - 27 - Group Number 19
Twitter Localization よってユーザーは店舗検索をやり直す必要なく, 複数の店舗に関するツイートを連続して検索する ことができるようになっている. 本ウェブアプリケーションではこれらの 飲食店検索 地図上で表示 ツイートの検索 とい う工程を 1 つのウェブサイト上で表示可能にすることを目的として作られており, 現段階でこの目 的は達成されている. 図 6.2 現在地を中心とした地図 図 6.3 図 6.4 カテゴリを表示した状態 Group Report of 2015 SISP 任意の場所を中心とした地図 図 6.5-28 - 飲食店検索後の表示 Group Number 19
6.6 6.2, Git, GitHub. PHP, JavaScript, CSS.,,., GitHub GitHub Education,.,,. : Group Report of 2015 SISP - 29 - Group Number 19
7, Web, Web 2.,.,,. OS,,.,,,.,, API, API,.,, Web.,. 1,, 1,. 1,,.,,,.,.,,.,,,,.,.,,.,, 200, 300 1. 2014, [13]. Web,. Web, Web.,,. Group Report of 2015 SISP - 30 - Group Number 19
8,. Twitter, Twitter Twitter,.,.,,.,,.,,.,,, 4. : Group Report of 2015 SISP - 31 - Group Number 19
[1],, vol.47, no.8, pp.993-1000, September. 2006. [2] IT, SNS Social Networking Service, http://e-words.jp/w/sns.html [Accessed: Dec. 18, 2015]. [3] SNS LINE Twitter,, 2014. [4] nielsen, 92% SNS, SNS, http://www.netratings.co.jp/news_release/2015/01/ Newsrelease20150127.html. [Accessed: Jul. 24, 2015]. [5] Twitter, Inc., Twitter Reports Third Quarter 2014 Results, https://investor. twitterinc.com/releasedetail.cfm?releaseid=878170. [Accessed: Jul. 24, 2015]. [6] Twitter Development of Speech Function for Communication Robot using Twitter,,, 2014. [7] Twitter, Twitter, http: //www.greenspace.info/twitter/step4.html#services. [Accessed: Dec. 18, 2015]. [8] Smart Survey, -, https://www.smartsurvey.jp/board/press_ view/129. [Accessed: Jul. 24, 2015]. [9],,, (2008),, JSAI08(0), 9-9. [10] NTT, NTT,, http://research.nttcoms.com/database/data/001436/. [Accessed: Dec. 19, 2015]. [11] Hatena::Diary, strpos strstr, http://d.hatena.ne.jp/oishiy/ 20080515/1210836445. [Accessed: Dec. 19, 2015]. [12] Technology Reports,,,,,, 2014. [13] IEICE,,,,, 2014. Group Report of 2015 SISP - 32 - Group Number 19