{"id":50700,"date":"2020-04-06T00:00:00","date_gmt":"2020-04-06T07:00:00","guid":{"rendered":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/"},"modified":"2025-11-14T07:54:02","modified_gmt":"2025-11-14T15:54:02","slug":"nyc-taxi-open-data-node-js","status":"publish","type":"post","link":"https:\/\/www.griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/","title":{"rendered":"GridDB\u3068NodeJS\u3092\u4f7f\u7528\u3057\u305f\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u30bf\u30af\u30b7\u30fc\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306e\u5206\u6790"},"content":{"rendered":"

\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u3001NYC\uff08\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\uff09\u30bf\u30af\u30b7\u30fc\u30b3\u30df\u30c3\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u63d0\u4f9b\u3055\u308c\u305f\u3044\u304f\u3064\u304b\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066\u5206\u6790\u3059\u308b\u305f\u3081\u306e\u7c21\u5358\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3053\u3053\u306b\u793a\u3059\u6307\u91dd\u306f\u3001\u3055\u307e\u3056\u307e\u306a\u30bf\u30a4\u30d7\u306e\u554f\u984c\u306b\u9069\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3067\u3057\u3087\u3046\u3002<\/p>\n

GridDB\u30b5\u30fc\u30d0\u30fc\u3092\u307e\u3060\u8a2d\u5b9a\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001\u30af\u30a4\u30c3\u30af\u30b9\u30bf\u30fc\u30c8<\/a>\u306b\u5f93\u3063\u3066\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002Node.js\u7528\u306bGridDB\u3092\u8a2d\u5b9a\u3059\u308b\u5834\u5408\u306f\u3001\u3053\u3061\u3089\u306e\u30d6\u30ed\u30b0<\/a>\u3092\u4f7f\u7528\u3057\u3066\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002NYC Open Data\u306e\u30a6\u30a7\u30d6\u30b5\u30a4\u30c8<\/a>\u3067\u3001NYC\u30bf\u30af\u30b7\u30fc\u306e\u30c7\u30fc\u30bf\u306e\u8a73\u7d30\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u898b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb<\/h2>\n
\nVendorID,tpep_pickup_datetime,tpep_dropoff_datetime,passenger_count,trip_distance,RatecodeID,store_and_fwd_flag,PULocationID,DOLocationID,payment_type,fare_amount,extra,mta_tax,tip_amount,tolls_amount,improvement_surcharge,total_amount\n2,03\/13\/2018 02:58:38 PM,03\/13\/2018 03:00:22 PM,1,0.31,1,N,132,132,2,3.5,0,0.5,0,0,0.3,4.3\n1,03\/13\/2018 02:34:11 PM,03\/13\/2018 02:40:35 PM,1,2.3,1,N,132,132,1,9,0,0.5,1.95,0,0.3,11.75\n1,03\/13\/2018 02:42:12 PM,03\/13\/2018 03:21:44 PM,1,17.5,2,N,132,230,1,52,0,0.5,5,5.76,0.3,63.56\n1,03\/13\/2018 02:36:05 PM,03\/13\/2018 03:04:08 PM,1,10.5,1,N,230,138,1,32.5,0,0.5,7.8,5.76,0.3,46.86\n1,03\/13\/2018 02:41:52 PM,03\/13\/2018 02:45:41 PM,1,0.7,1,N,264,264,2,5,0,0.5,0,0,0.3,5.8\n1,03\/13\/2018 02:47:40 PM,03\/13\/2018 02:55:06 PM,1,1.3,1,N,264,264,1,7,0,0.5,2,0,0.3,9.8\n1,03\/13\/2018 02:27:57 PM,03\/13\/2018 02:48:45 PM,1,4.8,1,N,142,13,1,18.5,0,0.5,3.85,0,0.3,23.15\n1,03\/13\/2018 02:03:27 PM,03\/13\/2018 02:10:51 PM,1,0.6,1,N,164,100,1,6,0,0.5,1.36,0,0.3,8.16\n1,03\/13\/2018 02:12:58 PM,03\/13\/2018 02:25:04 PM,1,1,1,N,100,230,2,8.5,0,0.5,0,0,0.3,9.3\n<\/pre>\n
\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306b\u306f17\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u3042\u308b\u305f\u3081\u3001\u307e\u305a\u306f\u30c7\u30fc\u30bf\u3092\u8907\u6570\u306e\u30b3\u30f3\u30c6\u30ca\u30fc\u306b\u5206\u5272\u3059\u308b\u65b9\u6cd5\u3092\u6c7a\u5b9a\u3057\u307e\u3059\u3002\u6700\u3082\u7406\u60f3\u7684\u306a\u306e\u306f\u3001\u500b\u3005\u306e\u30bf\u30af\u30b7\u30fc\u304b\u3089\u306e\u30c7\u30fc\u30bf\u3092\u500b\u3005\u306e\u30b3\u30f3\u30c6\u30ca\u30fc\u306b\u5165\u308c\u308b\u65b9\u6cd5\u3067\u3059\u304c\u3001\u3053\u306e\u65b9\u6cd5\u3067\u306f\u30c7\u30fc\u30bf\u304c\u533f\u540d\u5316\u3055\u308c\u308b\u305f\u3081\u5404\u30bf\u30af\u30b7\u30fc\u306e\u4e00\u610f\u306e\u8b58\u5225\u5b50\u306f\u63d0\u4f9b\u3055\u308c\u307e\u305b\u3093\u3002\u6b21\u306b\u671b\u307e\u3057\u3044\u30d5\u30a3\u30fc\u30eb\u30c9\u306f\u3001PULocationID<\/code>\u3067\u3059\u3002\u3053\u308c\u306f\u3001\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u3068\u305d\u306e\u8fd1\u96a3\u306e\u5834\u6240\u305d\u308c\u305e\u308c\u306e\u4e00\u610f\u306e\u8b58\u5225\u5b50\u3092\u8868\u30591\u301c265\u306e\u6574\u6570\u3067\u3059\u3002<\/p>\n
\u7570\u306a\u308b\u30bf\u30af\u30b7\u30fc\u304c\u307e\u3063\u305f\u304f\u540c\u3058\u8fd1\u6240\u3067\u540c\u3058\u30bf\u30a4\u30df\u30f3\u30b0\u3067\u5225\u306e\u4e57\u5ba2\u3092\u4e57\u305b\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u305f\u3081\u3001tpep_pickup_datetime<\/code>\u3092\u4e3b\u30ad\u30fc\u3068\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002\u4ee3\u308f\u308a\u306b\u3001\u884c\u304c\u8ffd\u52a0\u3055\u308c\u308b\u305f\u3073\u306b\u5897\u5206\u3055\u308c\u308b\u4e00\u610f\u306e\u6574\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n
\u307e\u305f\u3001hour_of_day<\/code>\u3068day_of_week<\/code>\u306e\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u3044\u304f\u3064\u304b\u8ffd\u52a0\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u30bf\u30af\u30b7\u30fc\u30c7\u30fc\u30bf\u306e\u5206\u6790\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n
\n
var colInfo = new griddb.ContainerInfo({\n    'name': \"col\"+data['PULocationID'],\n    'columnInfoList': [\n        [\"id\" , griddb.Type.LONG],\n        [\"duration\" , griddb.Type.INTEGER],\n        [\"VendorID\", griddb.Type.INTEGER ],\n        [\"tpep_pickup_datetime\", griddb.Type.TIMESTAMP ],\n        [\"tpep_dropoff_datetime\", griddb.Type.TIMESTAMP ],\n        [\"passenger_count\", griddb.Type.LONG],\n        [\"store_and_fwd_flag\" , griddb.Type.BOOL],\n        [\"PULocationID\", griddb.Type.INTEGER],\n        [\"DOLocationID\", griddb.Type.INTEGER],\n        [\"payment_type\", griddb.Type.INTEGER],\n        [\"fare_amount\", griddb.Type.FLOAT],\n        [\"extra\", griddb.Type.FLOAT],\n        [\"mta_tax\", griddb.Type.FLOAT],\n        [\"tip_amount\", griddb.Type.FLOAT],\n        [\"tolls_aount\", griddb.Type.FLOAT],\n        [\"improvement_surcharge\", griddb.Type.FLOAT],\n        [\"total_amount\", griddb.Type.FLOAT], \n        [\"hour_of_day\", griddb.Type.INTEGER], \n        [\"day_of_week\", griddb.Type.INTEGER]],\n   'type': griddb.ContainerType.COLLECTION, 'rowKey': true\n});\n<\/pre>\n<\/td>\n
\"NYC<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u30c7\u30fc\u30bf\u53d6\u308a\u8fbc\u307f<\/h2>\n
\u5b9f\u969b\u306b\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3080\u969b\u306f\u3001csv-parser npm module<\/a>\u3092\u4f7f\u7528\u3059\u308b\u3068\u975e\u5e38\u306b\u7c21\u5358\u3067\u3059\u3002\u30c7\u30fc\u30bf\u306fCSV\u30d1\u30fc\u30b5\u30fc\u304b\u3089\u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u3055\u308c\u3001\u51e6\u7406\u3055\u308c\u305f\u5f8c\u3001\u5358\u7d14\u306a\u914d\u5217\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u3053\u306e\u914d\u5217\u304c\u9069\u5207\u306aGridDB\u30b3\u30f3\u30c6\u30ca\u30fc\u306b\u53d6\u308a\u8fbc\u307e\u308c\u307e\u3059\u3002<\/p>\n
\nvar griddb = require('griddb_node');\nvar fs = require('fs');\nvar csv = require('csv-parser')\n\nlet factory = griddb.StoreFactory.getInstance();\nlet store = factory.getStore({\n    \"host\": '239.0.0.1',\n    \"port\": 31999,\n    \"clusterName\": \"defaultCluster\",\n    \"username\": \"admin\",\n    \"password\": \"admin\"\n});\n\nlet cols = {}\nlet count=0\n\nfs.createReadStream('data.csv')\n  .pipe(csv())\n  .on('data', (data) => {\n    let row = []\n    row[0] = count++;\n    row[1] = parseInt(Date.parse(data['tpep_dropoff_datetime'])-Date.parse(data['tpep_pickup_datetime']))\/1000)\n    row[2] = parseInt(data['VendorID'], 10);\n    row[3] = Date.parse(data['tpep_pickup_datetime'])\n    row[4] = Date.parse(data['tpep_dropoff_datetime'])\n    row[5] = parseInt(data['passenger_count'], 10)\n    if(data['store_and_fwd_flag'] == 'Y')\n        row[6] = true\n    else\n        row[6] = false\n    row[7] = parseInt(data['PULocationID'])\n    row[8] = parseInt(data['DOLocationID'])\n    row[9] = parseInt(data['payment_type'])\n    row[10] = Number(data['fare_amount'])\n    row[11] = Number(data['extra'])\n    row[12] = Number(data['mta_tax'])\n    row[13] = Number(data['tip_amount'])\n    row[14] = Number(data['tolls_amount'])\n    row[15] = Number(data['improvement_surcharge'])\n    row[16] = Number(data['total_amount'])\n    let date = new Date(row[3])\n    row[17] = date.getHours()\n    row[18] = date.getDay()\n\n    var colInfo = . . . snipped above . . .\n    store.putContainer(colInfo, false)\n        .then(cont => {\n            cont.put(row)\n            console.log(row[0])\n        })\n    .catch(err => {\n        if (err.constructor.name == \"GSException\") {\n            for (var i = 0; i < err.getErrorStackSize(); i++) {\n                console.log(\"[\", i, \"]\");\n                console.log(err.getErrorCode(i));\n                console.log(err.getMessage(i));\n            }\n        } else {\n            console.log(err);\n        }\n    });\n});\n<\/pre>\n
\u5206\u6790<\/h2>\n
\u8208\u5473\u6df1\u3044\u7d50\u679c\u304c\u5f97\u3089\u308c\u308b\u30af\u30a8\u30ea\u306f\u305f\u304f\u3055\u3093\u3042\u308a\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u3001\u6700\u3082\u9577\u8ddd\u96e2\u306e\u4e57\u8eca\u306f\u3069\u308c\u3067\u3059\u304b\uff1f\u6700\u3082\u6599\u91d1\u304c\u9ad8\u984d\u3068\u306a\u3063\u305f\u30c9\u30e9\u30a4\u30d6\u306f\u3044\u3064\u3067\u3059\u304b\uff1f\u6700\u3082\u5fd9\u3057\u304b\u3063\u305f\u4e57\u8eca\u306f\u3069\u308c\u3067\u3059\u304b\uff1f<\/p>\n
\n\/\/ standard boilerplate\nvar griddb = require('griddb_node');\nvar fs = require('fs');\nvar csv = require('csv-parser')\n\n\/\/ our Cluster's credentials\nlet factory = griddb.StoreFactory.getInstance();\nlet store = factory.getStore({\n    \"host\": '239.0.0.1',\n    \"port\": 31999,\n    \"clusterName\": \"defaultCluster\",\n    \"username\": \"admin\",\n    \"password\": \"admin\"\n});\n\nlet promises = []\nlet results = {}\n\nvar iterate = function(locID) {\n    return function(rowset) {\n        if(rowset != null) {\n            if (rowset.hasNext()) {\n                row = rowset.next();\n                results[locID] = row;\n                \/\/ if result is an aggregation use this instead\n                \/\/ results[locID] = row..get(griddb.GS_TYPE_LONG);\n            }\n        }\n    }\n}\n\nvar query = function (locID) {\n    return function(cont) {\n        if(cont != null) {\n            q = cont.query(\"SELECT * ORDER BY fare_amount DESC LIMIT 1 \");\n            return q.fetch()\n        }\n    }\n}\n\nfor (let i=0; i < 100; i++) {\n    var locID = i\n    promise = store.getContainer(\"col\"+i)\n    .then(query(i))\n    .then(iterate(i))\n    .catch(err => {\n        if (err.constructor.name == \"GSException\") {\n            for (var i = 0; i < err.getErrorStackSize(); i++) {\n                console.log(\"[\", i, \"]\");\n                console.log(err.getErrorCode(i));\n                console.log(err.getMessage(i));\n            }\n        } else {\n            console.log(err);\n        }\n    })\n    promises.push(promise)\n}\n\nPromise.all(promises).then(values => {\n    var retval=null;\n    console.log(\"sorting...\")\n    for (var k in results) {\n        if (retval == null || results[k][10] > retval[10])\n            retval=results[k]\n    }\n    console.log(retval)\n})\n<\/pre>\n
\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u3067\u8abf\u3079\u305f\u7d50\u679c\u30013\u670822\u65e5\u306b3\u6642\u9593\u3092\u8d85\u3048\u5229\u7528\u6599\u91d1\u304c\u8a08$475\u3068\u6700\u3082\u9ad8\u984d\u306a\u4e57\u8eca\u304c\u898b\u3064\u304b\u308a\u307e\u3057\u305f\u3002<\/p>\n
\n[ 1725438,\n  true,\n  2,\n  2018-03-22T06:43:13.000Z,\n  2018-03-22T09:59:34.000Z,\n  1,\n  false,\n  93,\n  265,\n  1,\n  450,\n  0,\n  0,\n  0,\n  24.760000228881836,\n  0.30000001192092896,\n  475.05999755859375,\n  6,\n  4 ]\n<\/pre>\n
\u975e\u540c\u671f\u306e\u6027\u8cea\u304c\u3042\u308bNode.js\u3067\u306f\u30012\u3064\u306e\u624b\u9806\u304c\u5fc5\u8981\u3067\u3059\u3002\u6700\u521d\u306b\u3001\u30af\u30a8\u30ea\u30d1\u30e9\u30e1\u30fc\u30bf(locationID)\u3092\u6c7a\u5b9a\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u5c11\u3057\u8907\u96d1\u3067\u3001\u30d7\u30ed\u30df\u30b9\u30c1\u30a7\u30fc\u30f3\u5185\u306b\u914d\u7f6e\u3055\u308c\u3001\u30ab\u30ea\u30fc\u5316<\/a>\u3092\u7528\u3044\u3066\u89e3\u6c7a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bthen() \u547c\u3073\u51fa\u3057\u3067\u95a2\u6570\u304c\u6307\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n
\nfor (let i=0; i < 100; i++) {\n    promise=store.getContainer(\"col\"+i) .then(query(i)) .then(iterate(i))\n    ...\n}\n<\/pre>\n
\u3059\u3079\u3066\u306e\u30af\u30a8\u30ea\u306f\u30d0\u30c3\u30af\u30b0\u30e9\u30a6\u30f3\u30c9\u3067\u540c\u6642\u306b\u5b9f\u884c\u3055\u308c\u308b\u305f\u3081\u3001\u5b8c\u4e86\u3059\u308b\u307e\u3067\u5f85\u3061\u307e\u3059\u3002
\n\u6700\u521d\u306b\u3001\u30af\u30a8\u30eapromise\u3092\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
\n    promises.push(promise)\n<\/pre>\n
\u305d\u3057\u3066\u3001\u3059\u3079\u3066\u306epromise\u304c\u5b8c\u4e86\u3059\u308b\u306e\u3092\u5f85\u3061\u307e\u3059\u3002<\/p>\n
\nPromise.all(promises).then(values => {\n    \/\/ display results\n}\n<\/pre>\n
\u3053\u308c\u3092\u6700\u3082\u9577\u8ddd\u96e2\u306e\u4e57\u8eca\u3092\u691c\u7d22\u3059\u308b\u30af\u30a8\u30ea\u306b\u5909\u66f4\u3059\u308b\u306b\u306f\u3001\u300cfare_amount\u300d\u3092\u300cduration\u300d\u306b\u5909\u66f4\u3057\u3001\u6700\u5f8c\u306e\u6bd4\u8f03\u30ad\u30fc\u3092\u300c10\u300d\u304b\u3089\u300c1\u300d\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n
\n...\n\n            q = cont.query(\"SELECT * ORDER BY duration DESC LIMIT 1 \");\n\n...\n\n        if (retval == null || results[k][1] > retval[1])\n\n...\n<\/pre>\n
\u6700\u3082\u4e57\u8eca\u56de\u6570\u306e\u591a\u3044\u30a8\u30ea\u30a2\u3092\u898b\u305f\u3044\u5834\u5408\u306f\u3001\u96c6\u8a08\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u3042\u308f\u305b\u3066\u7d50\u679c\u306e\u53d6\u5f97\u3068\u6700\u7d42\u7684\u306a\u4e26\u3079\u66ff\u3048\u3082\u5909\u66f4\u3055\u308c\u307e\u3059\u3002<\/p>\n
\n...\n\nvar iterate = function(locID) {\n    return function(rowset) {\n        if(rowset != null) {\n            if (rowset.hasNext()) {\n                row = rowset.next();\n                results[locID] = row.get(griddb.GS_TYPE_LONG);\n            }\n        }\n    }\n}\n\nvar query = function (locID) {\n    return function(cont) {\n        if(cont != null) {\n            q = cont.query(\"SELECT COUNT(*)\");\n            return q.fetch()\n        }\n    }\n}\n\n...\n\nPromise.all(promises).then(values => {\n    var items = Object.keys(results).map(function(key) {\n        return [key, results[key]];\n    });\n\n    items.sort(function(first, second) {\n       return second[1] - first[1];\n    });\n\n    console.log(items.slice(0, 10))\n})\n<\/pre>\n
\u4ee5\u4e0b\u3092\u51fa\u529b\u3059\u308b\u3068\u3001\u30a8\u30ea\u30a2161\uff08\u30de\u30f3\u30cf\u30c3\u30bf\u30f3\u30df\u30c3\u30c9\u30bf\u30a6\u30f3\uff09\u3067156,727\u56de\u306e\u4e57\u8eca\u304c\u3042\u308a\u6700\u3082\u5fd9\u3057\u3044\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n
\n[ [ '161', 156727 ],\n  [ '237', 153388 ],\n  [ '162', 144923 ],\n  [ '230', 143784 ],\n  [ '186', 136234 ],\n  [ '236', 136093 ],\n  [ '170', 134533 ],\n  [ '48', 131547 ],\n  [ '234', 130747 ],\n  [ '79', 115052 ] ]\n<\/pre>\n
\u3088\u308a\u8907\u96d1\u306a\u5206\u6790<\/h2>\n
\u4e0a\u8a18\u306e\u30b7\u30f3\u30d7\u30eb\u306a\u30af\u30a8\u30ea\u306f\u8208\u5473\u6df1\u3044\u50be\u5411\u3092\u77e5\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u304c\u3001\u305f\u3068\u3048\u3070\u300c1\u65e5\u306e\u7279\u5b9a\u306e\u6642\u9593\u306b\u3069\u306e\u30a8\u30ea\u30a2\u304c\u6700\u3082\u5fd9\u3057\u3044\u304b\u300d\u306a\u3069\u306e\u3088\u308a\u8907\u96d1\u306a\u30af\u30a8\u30ea\u3092\u4f7f\u3048\u3070\u3001\u30bf\u30af\u30b7\u30fc\u4f1a\u793e\u306f\u5229\u76ca\u3092\u6700\u5927\u5316\u3059\u308b\u305f\u3081\u306e\u30bf\u30af\u30b7\u30fc\u306e\u914d\u5099\u3092\u8003\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
\u3053\u308c\u306b\u306f\u3001\u8907\u6570\u306e\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u3066\u30011\u65e5\u306e\u7279\u5b9a\u306e\u6642\u9593\u306b\u5404\u8fd1\u96a3\u304b\u3089\u306e\u4e57\u8eca\u56de\u6570\u3092\u77e5\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u5834\u6240\u3054\u3068\u3001\u6642\u9593\u3054\u3068\u306b\u3001\u30b7\u30f3\u30d7\u30eb\u306a\u30ab\u30a6\u30f3\u30c8\u96c6\u8a08\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n
\u7d50\u679c\u306f\u3001\u3055\u3089\u306b\u51e6\u7406\u3092\u884c\u3046\u6642\u306e\u305f\u3081\u306b2\u6b21\u5143\u30c7\u30a3\u30af\u30b7\u30e7\u30ca\u30ea\u306b\u914d\u7f6e\u3055\u308c\u307e\u3059\u3002<\/p>\n
\nvar iterate = function(locID, hour ) {\n    return function(rowset) {\n        if(rowset != null) {\n            while (rowset.hasNext()) {\n                row = rowset.next();\n                results[hour][locID] = row.get(griddb.GS_TYPE_LONG)\n            }\n        }\n    }\n}\n\nvar query = function (locID, hour) {\n    return function(cont) {\n        if(cont != null) {\n            q = cont.query(\"SELECT count(*) where hour_of_day = \"+hour);\n            return q.fetch()\n        }\n    }\n}\n\nfor(let hour=0; hour < 24; hour++) {\n    results[hour] = {};\n    for (loc=0; loc < 265; loc++)\n        results[hour][loc] = 0\n\n    for (let i=0; i < 265; i++) {\n        var locID = i\n        promise = store.getContainer(\"col\"+i)\n        .then(query(i, hour))\n        .then(iterate(i, hour))\n        .catch(err => {\n            if (err.constructor.name == \"GSException\") {\n                for (var i = 0; i < err.getErrorStackSize(); i++) {\n                    console.log(\"[\", i, \"]\");\n                    console.log(err.getErrorCode(i));\n                    console.log(err.getMessage(i));\n                }\n            } else {\n                console.log(err);\n            }\n        })\n        promises.push(promise)\n    }\n}\n<\/pre>\n
\u6b21\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u3001\u3059\u3079\u3066\u306e\u30af\u30a8\u30ea\u30d7\u30ed\u30df\u30b9\u3092\u5f85\u3063\u3066\u304b\u3089\u3001\u6700\u3082\u4e57\u8eca\u56de\u6570\u306e\u591a\u304410\u30ab\u6240\u3092\u51fa\u529b\u3059\u308b\u6700\u7d42\u51e6\u7406\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n
\nPromise.all(promises).then(values => {\n    for (hour=0; hour < 24; hour++) {\n        var items = Object.keys(results[hour]).map(function(key) {\n          return [key, results[hour][key]];\n        });\n\n        items.sort(function(first, second) {\n          return second[1] - first[1];\n        });\n\n        locations = items.map(function(item) {\n            return item[0]\n        })\n\n        console.log(hour+\": \"+locations.slice(0, 10))\n    }\n})\n<\/pre>\n
\n0: 79,230,48,249,148,234,132,161,164,114\n1: 79,148,48,230,249,114,164,132,234,68\n2: 79,148,48,114,249,68,230,164,158,234\n3: 79,148,68,48,230,249,114,164,158,144\n4: 79,48,230,148,68,164,249,186,107,114\n5: 48,100,132,186,79,230,170,236,107,263\n6: 186,48,100,132,236,170,162,68,107,263\n7: 186,236,48,170,100,237,141,162,107,140\n8: 236,237,170,186,48,141,162,107,140,239\n9: 236,237,170,162,186,48,141,239,138,161\n10: 237,236,186,138,162,170,161,48,230,142\n11: 237,236,161,162,186,170,138,230,142,234\n12: 237,236,161,162,186,170,230,234,239,138\n13: 237,161,236,162,170,186,234,239,163,230\n14: 237,161,236,162,234,170,239,163,138,186\n15: 237,161,236,162,234,138,170,186,239,142\n16: 161,237,236,162,138,234,132,170,230,239\n17: 161,237,162,230,236,234,170,138,163,186\n18: 161,162,237,230,234,236,170,163,186,142\n19: 161,162,234,237,170,230,186,163,138,142\n20: 161,162,234,230,170,237,79,186,48,138\n21: 230,161,162,234,48,79,186,138,170,142\n22: 230,161,48,79,234,186,162,142,164,138\n23: 230,79,48,142,234,161,138,249,132,186\n<\/pre>\n
\u7d50\u679c\u3092\u898b\u308b\u3068\u3001\u65e9\u671d\u306f\u30a8\u30ea\u30a279\uff08\u30a4\u30fc\u30b9\u30c8\u30d3\u30ec\u30c3\u30b8\uff09\u304c\u6700\u3082\u5fd9\u3057\u304f\u3001\u663c\u9803\u306b\u306f\u30a8\u30ea\u30a2237\uff08\u30a2\u30c3\u30d1\u30fc\u30a4\u30fc\u30b9\u30c8\u30b5\u30a4\u30c9\uff09\u304c\u6700\u3082\u5fd9\u3057\u304f\u3001\u5915\u65b9\u30fb\u591c\u306f161\uff08\u30de\u30f3\u30cf\u30c3\u30bf\u30f3\u30df\u30c3\u30c9\u30bf\u30a6\u30f3\uff09\u304c\u6700\u3082\u5fd9\u3057\u3044\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3059\u3002<\/p>\n
\u6700\u7d42\u51e6\u7406\u3092\u5909\u66f4\u3057\u3066\u30d1\u30fc\u30bb\u30f3\u30c8\u3067\u4e57\u8eca\u56de\u6570\u3092\u8a08\u7b97\u3057\u305f\u308a\u3001\u4e0a\u8a18\u306e\u30af\u30a8\u30ea\u3092\u5909\u66f4\u3057\u3066\u6f5c\u5728\u7684\u306a\u6700\u5927\u53ce\u76ca\u3092\u898b\u3064\u3051\u308b\u3053\u3068\u3082\u7c21\u5358\u306b\u3067\u304d\u307e\u3059\u3002<\/p>\n
\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u30d5\u30eb\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u3001\u3053\u3061\u3089<\/a>\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u3001NYC\uff08\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\uff09\u30bf\u30af\u30b7\u30fc\u30b3\u30df\u30c3\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u63d0\u4f9b\u3055\u308c\u305f\u3044\u304f\u3064\u304b\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066\u5206\u6790\u3059\u308b\u305f\u3081\u306e\u7c21\u5358\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3053\u3053\u306b\u793a\u3059\u6307\u91dd\u306f\u3001\u3055\u307e\u3056\u307e\u306a\u30bf\u30a4\u30d7\u306e\u554f\u984c\u306b\u9069\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3067\u3057\u3087 […]<\/p>\n","protected":false},"author":71,"featured_media":49093,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1005],"tags":[],"class_list":["post-50700","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1005"],"acf":[],"yoast_head":"\nGridDB\u3068NodeJS\u3092\u4f7f\u7528\u3057\u305f\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u30bf\u30af\u30b7\u30fc\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306e\u5206\u6790 | GridDB: Open Source Time Series Database for IoT<\/title>\n<meta name=\"description\" content=\"\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u3001NYC\uff08\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\uff09\u30bf\u30af\u30b7\u30fc\u30b3\u30df\u30c3\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u63d0\u4f9b\u3055\u308c\u305f\u3044\u304f\u3064\u304b\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066\u5206\u6790\u3059\u308b\u305f\u3081\u306e\u7c21\u5358\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3053\u3053\u306b\u793a\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/griddb.net\/ja\/\u672a\u5206\u985e\/nyc-taxi-open-data-node-js\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GridDB\u3068NodeJS\u3092\u4f7f\u7528\u3057\u305f\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u30bf\u30af\u30b7\u30fc\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306e\u5206\u6790 | GridDB: Open Source Time Series Database for IoT\" \/>\n<meta property=\"og:description\" content=\"\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u3001NYC\uff08\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\uff09\u30bf\u30af\u30b7\u30fc\u30b3\u30df\u30c3\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u63d0\u4f9b\u3055\u308c\u305f\u3044\u304f\u3064\u304b\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066\u5206\u6790\u3059\u308b\u305f\u3081\u306e\u7c21\u5358\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3053\u3053\u306b\u793a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/griddb.net\/ja\/\u672a\u5206\u985e\/nyc-taxi-open-data-node-js\/\" \/>\n<meta property=\"og:site_name\" content=\"GridDB: Open Source Time Series Database for IoT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/griddbcommunity\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-06T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-14T15:54:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.griddb.net\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1276\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Owen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@GridDBCommunity\" \/>\n<meta name=\"twitter:site\" content=\"@GridDBCommunity\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Owen\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/\"},\"author\":{\"name\":\"Owen\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/0f2f6d4b593adde8c43cf3ea5c794c66\"},\"headline\":\"GridDB\u3068NodeJS\u3092\u4f7f\u7528\u3057\u305f\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u30bf\u30af\u30b7\u30fc\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306e\u5206\u6790\",\"datePublished\":\"2020-04-06T07:00:00+00:00\",\"dateModified\":\"2025-11-14T15:54:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/\"},\"wordCount\":25,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/griddb.net\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg\",\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/\",\"url\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/\",\"name\":\"GridDB\u3068NodeJS\u3092\u4f7f\u7528\u3057\u305f\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u30bf\u30af\u30b7\u30fc\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306e\u5206\u6790 | GridDB: Open Source Time Series Database for IoT\",\"isPartOf\":{\"@id\":\"https:\/\/griddb.net\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg\",\"datePublished\":\"2020-04-06T07:00:00+00:00\",\"dateModified\":\"2025-11-14T15:54:02+00:00\",\"description\":\"\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u3001NYC\uff08\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\uff09\u30bf\u30af\u30b7\u30fc\u30b3\u30df\u30c3\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u63d0\u4f9b\u3055\u308c\u305f\u3044\u304f\u3064\u304b\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066\u5206\u6790\u3059\u308b\u305f\u3081\u306e\u7c21\u5358\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3053\u3053\u306b\u793a\",\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#primaryimage\",\"url\":\"\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg\",\"contentUrl\":\"\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg\",\"width\":1920,\"height\":1276},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/griddb.net\/en\/#website\",\"url\":\"https:\/\/griddb.net\/en\/\",\"name\":\"GridDB: Open Source Time Series Database for IoT\",\"description\":\"GridDB is an open source time-series database with the performance of NoSQL and convenience of SQL\",\"publisher\":{\"@id\":\"https:\/\/griddb.net\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/griddb.net\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/griddb.net\/en\/#organization\",\"name\":\"Fixstars\",\"url\":\"https:\/\/griddb.net\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png\",\"contentUrl\":\"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png\",\"width\":200,\"height\":83,\"caption\":\"Fixstars\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/griddbcommunity\/\",\"https:\/\/x.com\/GridDBCommunity\",\"https:\/\/www.linkedin.com\/company\/griddb-by-toshiba\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/0f2f6d4b593adde8c43cf3ea5c794c66\",\"name\":\"Owen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/47438a5c81215c7a9043be1b427e0bbd8dc0f77bd536f147f8495575149e4325?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/47438a5c81215c7a9043be1b427e0bbd8dc0f77bd536f147f8495575149e4325?s=96&d=mm&r=g\",\"caption\":\"Owen\"},\"url\":\"https:\/\/www.griddb.net\/ja\/author\/owen\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GridDB\u3068NodeJS\u3092\u4f7f\u7528\u3057\u305f\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u30bf\u30af\u30b7\u30fc\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306e\u5206\u6790 | GridDB: Open Source Time Series Database for IoT","description":"\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u3001NYC\uff08\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\uff09\u30bf\u30af\u30b7\u30fc\u30b3\u30df\u30c3\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u63d0\u4f9b\u3055\u308c\u305f\u3044\u304f\u3064\u304b\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066\u5206\u6790\u3059\u308b\u305f\u3081\u306e\u7c21\u5358\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3053\u3053\u306b\u793a","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/griddb.net\/ja\/\u672a\u5206\u985e\/nyc-taxi-open-data-node-js\/","og_locale":"ja_JP","og_type":"article","og_title":"GridDB\u3068NodeJS\u3092\u4f7f\u7528\u3057\u305f\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u30bf\u30af\u30b7\u30fc\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306e\u5206\u6790 | GridDB: Open Source Time Series Database for IoT","og_description":"\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u3001NYC\uff08\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\uff09\u30bf\u30af\u30b7\u30fc\u30b3\u30df\u30c3\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u63d0\u4f9b\u3055\u308c\u305f\u3044\u304f\u3064\u304b\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066\u5206\u6790\u3059\u308b\u305f\u3081\u306e\u7c21\u5358\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3053\u3053\u306b\u793a","og_url":"https:\/\/griddb.net\/ja\/\u672a\u5206\u985e\/nyc-taxi-open-data-node-js\/","og_site_name":"GridDB: Open Source Time Series Database for IoT","article_publisher":"https:\/\/www.facebook.com\/griddbcommunity\/","article_published_time":"2020-04-06T07:00:00+00:00","article_modified_time":"2025-11-14T15:54:02+00:00","og_image":[{"width":1920,"height":1276,"url":"https:\/\/www.griddb.net\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg","type":"image\/jpeg"}],"author":"Owen","twitter_card":"summary_large_image","twitter_creator":"@GridDBCommunity","twitter_site":"@GridDBCommunity","twitter_misc":{"\u57f7\u7b46\u8005":"Owen","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"5\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#article","isPartOf":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/"},"author":{"name":"Owen","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/0f2f6d4b593adde8c43cf3ea5c794c66"},"headline":"GridDB\u3068NodeJS\u3092\u4f7f\u7528\u3057\u305f\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u30bf\u30af\u30b7\u30fc\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306e\u5206\u6790","datePublished":"2020-04-06T07:00:00+00:00","dateModified":"2025-11-14T15:54:02+00:00","mainEntityOfPage":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/"},"wordCount":25,"commentCount":0,"publisher":{"@id":"https:\/\/griddb.net\/en\/#organization"},"image":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg","inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/","url":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/","name":"GridDB\u3068NodeJS\u3092\u4f7f\u7528\u3057\u305f\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u30bf\u30af\u30b7\u30fc\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u306e\u5206\u6790 | GridDB: Open Source Time Series Database for IoT","isPartOf":{"@id":"https:\/\/griddb.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#primaryimage"},"image":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg","datePublished":"2020-04-06T07:00:00+00:00","dateModified":"2025-11-14T15:54:02+00:00","description":"\u3053\u306e\u30d6\u30ed\u30b0\u3067\u306f\u3001NYC\uff08\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\uff09\u30bf\u30af\u30b7\u30fc\u30b3\u30df\u30c3\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u63d0\u4f9b\u3055\u308c\u305f\u3044\u304f\u3064\u304b\u306e\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066\u5206\u6790\u3059\u308b\u305f\u3081\u306e\u7c21\u5358\u306a\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u3053\u3053\u306b\u793a","inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/nyc-taxi-open-data-node-js\/#primaryimage","url":"\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg","contentUrl":"\/wp-content\/uploads\/2020\/01\/taxi_1920x1276.jpg","width":1920,"height":1276},{"@type":"WebSite","@id":"https:\/\/griddb.net\/en\/#website","url":"https:\/\/griddb.net\/en\/","name":"GridDB: Open Source Time Series Database for IoT","description":"GridDB is an open source time-series database with the performance of NoSQL and convenience of SQL","publisher":{"@id":"https:\/\/griddb.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/griddb.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Organization","@id":"https:\/\/griddb.net\/en\/#organization","name":"Fixstars","url":"https:\/\/griddb.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png","contentUrl":"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png","width":200,"height":83,"caption":"Fixstars"},"image":{"@id":"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/griddbcommunity\/","https:\/\/x.com\/GridDBCommunity","https:\/\/www.linkedin.com\/company\/griddb-by-toshiba"]},{"@type":"Person","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/0f2f6d4b593adde8c43cf3ea5c794c66","name":"Owen","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/47438a5c81215c7a9043be1b427e0bbd8dc0f77bd536f147f8495575149e4325?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/47438a5c81215c7a9043be1b427e0bbd8dc0f77bd536f147f8495575149e4325?s=96&d=mm&r=g","caption":"Owen"},"url":"https:\/\/www.griddb.net\/ja\/author\/owen\/"}]}},"_links":{"self":[{"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/posts\/50700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/users\/71"}],"replies":[{"embeddable":true,"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/comments?post=50700"}],"version-history":[{"count":1,"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/posts\/50700\/revisions"}],"predecessor-version":[{"id":51543,"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/posts\/50700\/revisions\/51543"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/media\/49093"}],"wp:attachment":[{"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/media?parent=50700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/categories?post=50700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.griddb.net\/ja\/wp-json\/wp\/v2\/tags?post=50700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}