秒間30fps * n台のIOTデータを Express.js MongoDB Metabase + Nuxtでいい感じに可視化する(予定)

Transcript

1. !TVHBOBNJ ඵؒGQT
   
   O୆ͷ*05σʔλΛ
   &YQSFTTKT
   
   .POHP%#
   .FUBCBTF
   
   /VYUͰ͍͍ײ͡ʹՄࢹԽ͢Δ ༧ఆ
2. w ͘͠Έ੡࡞ॴͱ͍͏ϑϧϦϞʔτͷձࣾͰۈ຿͍ͯ͠·͢ɻ ొه্ͷձࣾͷ ॅॴ͸͙ۙ͘͢Ͱ͕͢ɺ୭΋ग़͍ࣾͯ͠·ͤΜɻ
   w ීஈ͸
   όοΫΤϯυΤϯδχΞ 3VCZ
   PO
   3BJMTϝΠϯ ΍ɺ5FSSBGPSN
   $%, ౳Ͱ"84ͷΠϯϑϥߏஙͨ͠Γͯ͠·͢ɻ
   w $IBU(15བྷΈͷҊ݅ʹ৮Γɺ1ZUIPO΍0QFO"*Λຊ֨తσϏϡʔ
   
   w ࡀ̓ϲ݄ͷΘΜͺ͘ͳଉࢠ͕ਓ͍·͢
   w झຯ͸ϩʔυόΠΫɺౙ৔͸࣮૸Ͱ͖ͳ͍ͷͰɺόʔνϟϧϥΠυ͍ͯ͠· ͢ɻ ϩʔυόΠΫ͸ۚ৯͍஬Ͱ͆͢
   w ʰΰδϥʱ͸͍͍͓ͧ ίίϊεεΩϊͷυϧϏʔγωϚͰݟͯ΄͍͠ ࣗݾ঺հ DALL·E3Ͱ࡞ͬͨImageը૾
3. w ෳ਺୆ͷϩϘοτ΍ηϯαʔɺΧϝϥ͕ஔ͔Ε͍ͯΔ෦԰ʹਓ͕ ग़ೖΓ͢ΔͷͰɺͦ͜ͷηϯαʔ͔ΒඈΜͰ͘ΔσʔλΛϦΞϧ λΠϜͰՄࢹԽɺҰݩ؅ཧ͢Δπʔϧ͕΄͍͠
   w ݱঢ়ͦΕͧΕͷηϯαʔ͔Βͷੜσʔλ͸ݟΕΔΑ͏ʹͳ͍ͬͯ Δ΋ͷͷɺ౷߹ͯ͠ݟΕΔΑ͏ͳ͘͠Έ͕੔͍ͬͯͳ͍ɻ·ͨɺ ϑϩϯτΤϯυपΓʹڧ͍ਓࡐ΋͍ͳ͍ͷͰ6*Ϧονʹ͍͍ײ͡ ʹ࡞ͬͯཉ͍͠ɻ
   w ਓͷҠಈ΍ϩϘοτͷಈ͖ΛͰ͖Δ͚ͩγʔϜϨεʹදࣔͨ͠ ͍ɻ ฐࣾ͸ΦϯϥΠϯΠϕϯτπʔϧͰ8FCTPDLFUΛར༻ͨ͠ ։ൃͷ࣮੷͕͋Γɺͦͷ΁Μ͕͍͍ײ͡ʹώοτͨ͠Α͏
   
   w ͍͍ײ͡ͷ؅ཧը໘΋΄͍͠ͳ͊ɻ Ҋ݅ͷલఏ
4. શମతͳΠϝʔδ ෦԰ ෳ਺͋Γ·͢ɻ ฐࣾ࡞੒ྖҬ 1SPUPDPMະఆ XFCTPDLFUʁ 3PPNʹ͖ͭGQTఔ౓ͰKTPO 8FCTPDLFUͰ෦ ԰ͷϦΞϧλΠϜ ͷঢ়گΛ֬ೝ
   +TPOΛ%#ʹอଘ ෼ੳ͠΍͍͢Α ͏ʹ͢Δ
5. શମతͳΠϝʔδ ো֐ൃੜ࣌ 3PPNͷϩϘοτʹෆ۩߹ൃੜ ෆ۩߹ϑϥάΛ෇͚ͯૹ৴༧ఆ μογϡϘʔυͰݪҼௐࠪ ϩϘοτΨν੎͕μογϡ Ͱ௚͢
   
6. w "84ʹ*05ؔ࿈ͷαʔϏε͍ͬͺ͍͋Δ͠ɺαʔόʔϨεΞʔΩ ςΫνϟతͳͷͰ%ZOBNPͱ͔ʹ͍͍ײ͡ͰσʔλಥͬࠐΜͰɺ ؅ཧը໘͸#*πʔϧͱͯ͠ɺ"NB[PO
   2VJDL4JHIU
   8FCTPDLFU ΋"QQ4ZODͷTVCTDSJQUJPOͰ࣮૷͢Ε͹·͍͚͊Δͬ͠ΐʔɻ
   w ࢀߟ63-
   IUUQTBXTBNB[PODPNKQCMPHTNPCJMFJPUXJUIBXTBQQTZOD Ϋϥ΢υ೴ͷΘͨ͠͸࠷ॳ͸͜͏ࢥ͍ͬͯ·ͨ͠
7. w *05ͷ΋Ζ΋Ζͷ੍໿͕͋ΓΦϯϓϨͰɻɻɻ ͔͠͠ɻɻɻ w "84ʹ*05ؔ࿈ͷαʔϏε͍ͬͺ͍͋Δ͠ɺαʔόʔϨεΞʔΩςΫνϟతͳͷͰ %ZOBNPͱ͔ʹ͍͍ײ͡ͰσʔλಥͬࠐΜͰɺ؅ཧը໘͸#*πʔϧͱͯ͠ɺ"NB[PO
   2VJDL4JHIU
   8FCTPDLFU΋"QQ4ZODͷTVCTDSJQUJPOͰ࣮૷͢Ε͹·͍͚͊Δͬ͠ΐʔɻ
   w ࢀߟ63-
   IUUQTBXTBNB[PODPNKQCMPHTNPCJMFJPUXJUIBXTBQQTZOD
8. w ೲظ͕γϏΞͳͷͰɺϛχϚϜͳ΋ͷΛ͓౉ͯ͠͠ɺࡉ͔͍ௐ੔౳ ͸͓ئ͍͢Δܗʹ΍Γͦ͏ɻ
   w %PDLFS$PNQPTFͰ্ཱ͕ͪΔ(JUIVCϦϙδτϦΛ༻ҙ͠ɺΦϯ ϓϨͷαʔόʔͰ্ཱͪ͛ͯ΋Β͏ɻ ,VCFSOFUFTͱ͔͸࣌ؒͳ͞ ͗ͯ͢͞ແཧͩͱࢥ͏ɻ
   w .Z42-ͱ͔ͷ;ͭ͏ͷϦϨʔγϣφϧɾσʔλϕʔεͩͱτϥϯβ ΫγϣϯܥͰGQT٧Έͦ͏ͳؾ͕͢Δɻ
   w ݸਓతʹ΋ձࣾతʹ΋࣮੷͸গͳ͍͚Ͳ
   .POHP%#
   &YQSFTT /PEF
   ͳΒ8FCTPDLFU΋΍Γ΍͍͢͠ɺGQT଱͑ͯ͘ ΕΔͷͰ͸ͳ͍͔ɻ
   w αʔόʔଆ͸ϑϧελοΫͳϑϨʔϜϫʔΫ͸͍Βͳͦ͞͏ͳͷͰ 3BJMT͸·͊ͳͯ͘΋͍͍͔ͳɻɻɻ ΦϯϓϨͷ৔߹ͷ୅Ҋ
9. ΦϯϓϨͷ৔߹ͷ୅Ҋͬ͘͟Γߏ੒ 8FCTPDLFUͰ෦ ԰ͷϦΞϧλΠϜ ͷঢ়گΛ֬ೝ
   +TPOσʔλอଘ
   #*πʔϧ
10. ࠓͷͱ͜Ζ͜͜·ͰͰ͖ͨ ໿೔ؒ ඵؒఔ౓ͷαϯϓϧ +TPOΛ΋ΒͬͨͷͰ౤ೖ
    #*πʔϧ
11. ଟ෼࿩࣌ؒ͢ͳ͍ͩΖ͏͚Ͳ͜Μͳ޻෉Λͨ͠ w .POHPEC༻ͷϥΠϒϥϦͱͯ͠ɺNPOHPPTF
    Λར༻
    w 5ZQFTDSJQU
    FTMJOU
    QSFUUJFSͷઃఆ ࠓͲ͖౰ͨΓલ͔΋Ͱ͕͢
    w ωετͨ͠+TPOͷ4DIFNBఆٛؤுͬͨ ܕ͸࣮෺Ͱ͸ͳͯ͘μϛʔͰ͢
    import mongoose from 'mongoose'; const Schema = mongoose.Schema; const humanSchema = new Schema({ position: { x: Schema.Types.Decimal128, y: Schema.Types.Decimal128, z: Schema.Types.Decimal128, }, }); export const AtrSchema = new Schema({ topic: String, body: { info: { time: { secs: Number, nano: Number, }, robot_id: String, seq: Number, }, humans: [{ type: humanSchema }], }, robot_id: String, timestamp_msec: Schema.Types.Date, humans: [{ type: humanSchema }], }); w 4DIFNF5ZQFT%BUFʹಥͬࠐΉ࣌ʹ
    NTFDͷਫ਼౓·Ͱ͔͠ରԠ͍ͯ͠ͳ͍ͷͰ OBOPTFDΛ*OUʹͯ͠ಥͬࠐΜͩ
    const timestampMsec = parseInt( `${secs}${(nsecs / 1_000_000).toFixed().padStart(3, '0')}`, );
12. w ͦ΋ͦ΋͜ͷߏ੒ͰͪΌΜͱGQTͷෳ਺෦԰Λ͞͹͍ͯ%#อ ଘͰ͖Δͷ͔ʁ ͜͏ͨ͠΄͏͕͑͑ΜͪΌ͏ʁతͳΞυόΠε͋ Ε͹ޙ΄Ͳͦͬͱڭ͍͑ͯͩ͘͞ɻ
    w 8FCTPDLFU
    ਖ਼௚͋Μ·ΓΘ͔ͬͯͳ͍ɻ1+಺ͷڧڧͳϑϩϯτ ΤϯδχΞ͔Βֶͼ͍ͨɻ
    w 8FCTPDLFU͸4PDLFU*0ͱ͍͏ϥΠϒϥϦׂ͕ΓͱϝδϟʔͰ࢖ ͍উख͕Α͍ͷͰɺ8FCTPDLFUͷ࢓༷Λݟͳ͕ΒͲͷΑ͏ʹϥ οϓ͞Ε͍ͯΔͷ͔Λݟ͍͖͍ͯͨɻ
    w ϑϩϯτΤϯυͷ΄͏͕ɺը໘਺ଟ͔ͬͨΓظ଴஋͕ߴ͔ͬͨΓ Ͱɺଟ෼͍Ζ͍Ζ͠ΜͲ͍ͱࢥ͏ͷͰɺ+4ք۾ͭΑͭΑʹͳͬͯ ϔϧϓͰ͖ͨΒ͍͍ͳ͊ɻ ࠓޙͷ՝୊
13. w ࢠҭͯͱϩʔυόΠΫͷτϨʔχϯάͰ͋·Γ͕࣌ؒऔΕͳ͍ͷͰ݄࣌ؒఔ౓ͷ୹͍ۀ຿ͱ͔ɺ εϙοτͰͷܖ໿ͩͱॿ͔Γ·͢ɻ
    w ଈઓྗͱͯ͠׆༂Ͱ͖ͦ͏ͳ͜ͱ
    w 3VCZ
    PO
    3BJMTͷλεΫ ೥͘Β͍΍ͬͯ·͢
    w (JU)VC
    "DUJPOT΍$JSDMF$*
    ʹΑΔ
    $* $%ߏங
    w "84౳ͷ5FSSBGPSNʹΑΔ؀ڥߏங
    w "84ͷίετ࡟ݮܥ ฐࣾͷΠϯϑϥඅ༻Λ΢ϯඦສ୯ҐͰු͔ͤ·ͨ͠ɻ
    w ଟগͷܦݧ͋Γ
    w 7VFKT
    5ZQFTDSJQU ʹΑΔ։ൃ
    w 0QFO"*
    
    3"(Λ࢖ͬͨ$IBU#PU(15։ൃ
    w ڵຯ͸͋Δ͚Ͳগֶ͠शʹ͕͔͔࣌ؒΓͦ͏ͳ͜ͱ
    w /FYUKT౳
    KTք۾ͷϞμϯϑϨʔϜϫʔΫ։ൃ
    w "84
    αʔόʔϨεΞʔΩςΫνϟΛϝΠϯͱ͢Δ৔߹ͷΞϓϦέʔγϣϯߏங ෭ۀืूத ୹Ίͷ
14. ։ൃʹ͋ͨΓࢀߟʹͨ͠ॻ੶ɼهࣄ ͸͡Ίͯͭ͘ΔόοΫΤϯυαʔόʔൃలฤʢ/PEFKT
    
    &YQSFTT
    
    .POHP%#ʣࡾ޷ΞΩ
    8FC
    %FWFMPQNFOU
    XJUI
    /PEF
    BOE
    &YQSFTT
    OE
    &EJUJPO
    
    
    .POHP%#νϡʔτϦΞϧ
    &YQSFTTKT
    νϡʔτϦΞϧ
    *P5σʔλΛ.POHP%#ͱ.FUBCBTFͰՄࢹԽ͢ΔͨΊͷ5JQT NPOHPPTF
    EPDT
15. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ