This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[Stop by user] | |
Result is stored into C:\Users\Foo\Flickr-Tag-Crawler\test/result/car_train_NyHZ6SNw.txt |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
node execute.js car train -122.28,33.27,-113.43,42.26 -6.52,49.81,2.32,58.79 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
cd c:\sobig\ | |
npm install flickr-tag-crawler |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#phpをインストール | |
sudo dnf install php | |
#Apache(Webサーバ)を再起動 | |
sudo systemctl restart httpd |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--試行課題3 | |
---以下の2つの問い合わせの意味の違いを考えよ | |
--一番安いワインを得る問い合わせ その1 | |
SELECT * FROM wine ORDER BY price LIMIT 1; | |
--一番安いワインを得る問い合わせ その2 | |
SELECT * FROM wine | |
WHERE price= ( | |
SELECT min(price) FROM wine); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--試行課題2 | |
---以下の三つのSQLを試してみて、結果からそれぞれの問い合わせの意味・違いを考えよう。 | |
--右結合 | |
SELECT wid, name, district, price | |
FROM wine LEFT JOIN vineyard | |
ON wine.did = vineyard.did; | |
--左結合 | |
SELECT wid, name, district, price |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sudo vim /root/credentials_nas.txt | |
#書き込む内容は下のcredentials_nas.txtを参照せよ | |
#作成終わったらパーミッションをrootのみに限定する | |
sudo chown root:toot /root/credentials_nas.txt | |
sudo chmod 600 /root/credentials_nas.txt |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
find /drobo/yokolab/dataset/flickr_yokoyama/NewYork/ -name "*.geojson" -type f -print0 | xargs -0 -i% cp % ./NewYork |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"dateupload":1364826240, /*当該ユーザのdateupload最大値*/ | |
"type":"LineString", /*geojson形式準拠の為*/ | |
"coordinates":[ /*[経度,緯度]の配列*/ | |
[-67.55418,46.976475], | |
[-76.798982,18.000203], | |
....以後続く | |
], | |
"photos":[ | |
[ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--p.14 | |
CREATE TABLE users ( | |
user_id integer, | |
namn varchar(30) NOT NULL, | |
PRIMARY KEY (user_id) | |
); | |
CREATE TABLE birthday ( | |
user_id integer, | |
barthday date NOT NULL, | |
FOREIGN KEY (user_id) |