Hi Max, 
 
Please see attached videos that we tried running through speed processing and it didnt quite work. Also can the result be a spreadsheet instead of the text file?
 
https://drive.google.com/file/d/1aQCTHhHosMGflQurmjVAfdx3bdALHe00/view?usp=sharing
 
https://drive.google.com/file/d/18_-htgqTZYwhikaORGZBoB7CqSehmRIG/view?usp=sharing

https://manage.netc.ourdevapps.com/admin/main

 
*Intersection:* 35. South Leonard St @ Porter St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Z4n-beUbVLWq9Mxzy44gDVMBVQjemo6qjw6O8c-rpxM/edit?usp=sharing
*Video:* https://drive.google.com/file/d/10lI6C2c5ONeJnIfhUhjtohcAPnlbSmzJ/view?usp=sharing
*Intersection:* 68. Route 69/Washington St @ Union St/Hamilton Ave
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Ayux_GBB9fFjrRj59oGoFzQdWpZOlvmQUVWRbQ7HNM0/edit?usp=sharing
*Video:* https://drive.google.com/file/d/176m3gerERP19oBVifsAxwNmUxCt2TL48/view?usp=sharing
 
*Intersection:* 1. Chase Parkway @ Rt 64
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1CyrXmipnJvaFwFhh8m-iDJtWRD6SZigej0_8YfVCwzg/edit?usp=sharing
*Video:* https://drive.google.com/file/d/15_HxT2CvFz1RVika5c337quap97NsnKI/view?usp=sharing
*Intersection:* 2. Chase Parkway @ Ruth Parsons Dr
*Spreadsheet:* https://docs.google.com/spreadsheets/d/15TGktVHeLbgPZxr5jkW5djqQXmW0zNT9huBSM4BuWPs/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1_0wfxuYAVyj9H_Bikib6WkKDPptd2ctZ/view?usp=sharing
 
*Intersection:* 3. Chase Parkway @ I-84 WB On Ramp (Interchange 17)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1G5x5cfW3pQJcYdkhaVPPqKlwScuDkvedP46PFL1BdIg/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1NaZTpXGD0GC5oy3iVbOKswCjbqMxIoo2/view?usp=sharing
*Intersection:* 6. West Main St @ Park Road/I-84 WB Off Ramp (Interchange 18)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1qgnrCMJMQkFN5S0LqdgC2B_hTaw3ck_tIdd4rRONIOc/edit?usp=sharing
*Video:* https://drive.google.com/file/d/17MHgis8Wb6hefsLom2LqgI2KhpMnkde1/view?usp=sharing
 
*Intersection:* 12. Highland Ave @ EB On Ramp (Interchange 18)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1LIrcl15L-R3YRC2OjOxRJeiE7IzfZulZHClsY9WD8Yw/edit?usp=sharing
*Video:* https://drive.google.com/file/d/19eniRmyoX1w1xCrJoEcDKpNRSi9fr7y4/view?usp=sharing
*Intersection:* 32. Washington Ave @ Riverside St/Route 8 SB Off Ramp (Interchange 30)/Charles St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1AeHFLuw8sVFr54eJkMaaWeKxW8zqMdPwkxWmitUwFPY/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1FgBufqxnHuFAhlsY3BVnX6eHTFaw829N/view?usp=sharing
 
*Intersection:* 33. NB Riverside St/S Leonard St @ Washington St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1A2ZqSQ8fMYNip017lWjSrStZZtobEhuEmWk_A0442xw/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1SSqN6V4acbCdUHqf2KwW-Y00-iXGLPwA/view?usp=sharing
*Intersection:* 34. Charles St @ Porter St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1YrbNeRWSqDgqLx3efzbTflx9v_JGj6t_HiPApqWCHUw/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1W4ZVQL_4Ff1TpKKuOCTJQVn0ZeijZ7-p/view?usp=sharing
 
*Intersection:* 36. Charles St @ Fifth St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1xhrSAcWJrPcCvD9McgbVk0e5sOPqPC-ioH6ehm81ry0/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1hWYMNcisr8ZNeVKI0CildChkEYZGJuno/view?usp=sharing
*Intersection:* 37. South Leonard St @ Fifth St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1KWPlhP6yFlksz7oJ2s9J1OrVxVoNzDjLjLCHm07tcCk/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1ER63VVRjcIoB_Tz6v67JCilqTraODSvX/view?usp=sharing
 
*Intersection:* 67. Union St @ I-84 WB On Ramp (Interchange 22)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Ep0f4encZUirFY09hDk8hC-uaR4WndvfSFDbacpkWCM/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1vcTKPtdzHGEzo13QIrUG_GHwjrr3dsAf/view?usp=sharing
*Intersection:* 66. Union St @ Brass Mill Center Dr
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1U5---WFVwF5_oJbGcNZQLfZyzfZQLXaM4XzgZcZ6L_k/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1Kb9WLP00Fsjhzk9O_YltLWLxl5TyMrSp/view?usp=sharing
 
*Intersection:* 75. West Main St @ Riverside St/ Watertown Ave
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Fg_28lDiXSSDgrM970jtGCUuMA6OPZFRBri94WbLOSs/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1yDAA0ngEJYg5EWmXNGt9IoN7WVQESoNz/view?usp=sharing
*Intersection:* 78. Watertown Ave @ Robbins St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Rz96eKnFYyblAu5kTIfpz3OHpgpNCXrQRr3XaVafBC8/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1b94lL2IpCq0ofQissseDgmHMQ98r0pKG/view?usp=sharing
 
*Intersection:* 82. Route 73 @ East Aurora St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1dSqqzpbxg2ZP2QHdfpWfL8nsTktWXMSyR14SgcIOm3g/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1fISYcTSP96m66F9b0d--Ge8ArV2ktp0i/view?usp=sharing
*Intersection:* 81. Route 73 @ Watertown Ave (SR 846)/Huntingdon Ave
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1fmL5Yg3fpr0hQV8kwu2_YlCvmFTZxNJs2CkHzWOZrUE/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1F4JIXvHiYF3sBOAWqe6LzQhD9l2XFvnb/view?usp=sharing
 
*Intersection:* 72. West Main St @ Grandview Ave/Kalamazoo Ave
*Spreadsheet:* https://docs.google.com/spreadsheets/d/18qX3BaXqsYSFliQj7TxSATnOfyv7a5eYwES3k14D7Do/edit?usp=sharing
*Video:* https://drive.google.com/file/d/19KpQI2kpVaq9vDKKW9S6xABQ-8TvECG8/view?usp=sharing
*Intersection:* 69. East Main St @ Brass Mill Center Dr
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1GhjJv02ENRdRYZCPKXkvOWYKstRm4o7YTgmzOQGObPM/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1ZZgAu9e-D4vjMX2GyKK9mSFFQRCPoAi4/view?usp=sharing
 
*Intersection:* 30. Riverside St @ Bank St/N Leonard St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1NzD677PrzRr5hUtI9g9g6Lzc4luAzo3Nt_tLAmN_HH8/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1eY_U6JSTH7gA45nJNRgWTQelo3HPZjjF/view?usp=sharing
*Intersection:* 29. Bank St @ NB Riverside St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1eDWa3B4uTV7vQEP391WUCIGwneBNeM3_9LhYpQ5r7ig/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1FEutx7C9j4D6B05MkabexwQSOMgQzPQm/view?usp=sharing
 
*Intersection:* 16. Jackson St @ Freight St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1ejmR0zAcXkODZrfK8TJ6dD4OUDRgyT01nGBT6N-R0oc/edit?usp=sharing
*Video:* https://drive.google.com/file/d/172Wn0k2ekdQwDimDilNWN4aR00wOkqTP/view?usp=sharing
*Intersection:* 17. Sunnyside Ave @ I-84 EB Off Ramp (Interchange 19)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1JtdwKdcMAhKUVNt5MLWcZhbD9smNKA_ycUyFiYKTW0Q/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1cq6xoYpc59hPK-NqaP0Nt7VIC9CHGMXK/view?usp=sharing
 
*Intersection:* 9. Chase Parkway @ EB Off Ramp (Interchange 18)/Chase Collegiate School Dr
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Uep4YsxPIXuhT2zZgrND0AxiygPjQ5AZtDln_sXM83I/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1Frj1AqO4u3dPi1qAs2dL_ed7aiYk6oMW/view?usp=sharing
*Intersection:* 10. Chase Parkway @ EB On Ramp (Interchange 18)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/17Duov-siEsjNxgnn3GaHdnb1hSWS4UmNZvbBPVH8J3Q/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1xJkGxpiKwtWfQDW2tv2gprZ5ytQ79uW6/view?usp=sharing
 
*Intersection:* 14. Riverside St SB @ Freight St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1uVZs5R5PHo7tLekPjnT3Q-k9_gldJvrKkSE79WiBj1A/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1A-Qh2R74fQwy2zliiJQVdTpKxAAjWmrb/view?usp=sharing
*Intersection:* 4. Chase Parkway @ Naugatuck Community College Entrance
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Gvv_UuSwpPklY43o5NALstxJ1d8Az3Md4LGUBhI3gdQ/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1XUCr50w6Hj5N1gxT4xmGMbN700ZWoDRE/view?usp=sharing
 
*Intersection:* 15. Riverside St NB @ Freight St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1NEji_zZ-IMJbgf5VRLOfwkd-lKLL5i8sWlZNOV_xcxY/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1o2k0ZsAQ08zKRQ6-eyMe2R-bb1ejbYYU/view?usp=sharing
*Intersection:* 76. West Main St @ Jackson St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1ZSLqXff0OZOPMxhOA7vyo_i6IOoSRgqpkJ-z05TLZWw/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1AfcsA62nv5R16HYAwxGTXxTlqPAxk76Q/view?usp=sharing
 
*Intersection:* 5. Chase Parkway @ West Main St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1p3KJWJEu0diN_DIn6GsJz0xca45IEFhw9m6R2s3YXNw/edit?usp=sharing
*Video:* https://drive.google.com/file/d/109Mb2OL_4yApb4DMqbAcsopxKIY3jYe0/view?usp=sharing
*Intersection:* 83. Huntingdon Ave @ Rt 8 SB On-Ramp
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1_KoPfxV1-484VtABXJkoMuKoN-7-EJs7Y8G1T7-ZJGs/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1TGNpMmwvJHcEgD8KdBh7b3rXsrh2r-Az/view?usp=sharing
 
*Intersection:* 85. Huntingdon Ave @ Rt 8 Ramps
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1c5Zm6LeEbXfkdS6QGt8lqwZtp9WfSbHwk0sKLX5eMNc/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1n2Nml2S9oRn07IHxQEFis-IAspvT_gph/view?usp=sharing

*Intersection:* 56. Union St @ S Elm St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1X6lFcxA2t9GatUsodUI9v_9neQQ9otjWjWiu_jNs8VA/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1233etirKZtbaI1Lzra5Y_Hdk2kwZoax_/view?usp=sharing
 
*Intersection:* 43. Grand St @ Leavenworth St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1siJp-xHmBK7d4uZZc15cAjYEFFMCz9fdRRjoWzQAYmY/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1Wrk5gXz7AXKocVYAKjwhjKBFOLNxd780/view?usp=sharing
 
*Intersection:* 26. Meadow St @ Bank St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1jhnLnq-U-avQT2DgXK8SIN2P524pjCSBbOaPKwJwjoY/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1G8TNausVOOSziGiMsIV98iBC9ecPAa9A/view?usp=sharing
 
*Intersection:* 45. W Main St/E Main St @ N Main St/S Main St & Bank St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1yt8_daGD89DN5-e47BCcQSwKsgbG-QZt51d0ZG2Ttnk/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1S99iZCNRHGkk5Xce6MihLwEnHqopHlAk/view?usp=sharing
 
*Intersection:* 18. Sunnyside Ave @ Riverside St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Kuz8qba3uEhWsvB0KdzCmKsMTh2BjFyrAc5Pc84AVJI/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1iH0e91xGewgM3KwXatdjKszF8SDRKstk/view?usp=sharing
 
*Intersection:* 13. Highland Ave @ Sunnyside Ave/Chase Parkway
*Spreadsheet:* https://docs.google.com/spreadsheets/d/14jvVyCDynnHMGujzP8fl2HVHlBeM8U2e2s9lqcHOqKI/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1neQZkqhBeaHtDoXXx-BYOLrcrU4fnWW9/view?usp=sharing
 
*Intersection:* 11. Highland Ave @ I-84 WB Off Ramp (Interchange 18)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Eto8b7Xdf_JsLHJTqId_8Tkea84yKo5fEpCP6m7ALY4/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1SFpj6v2BuudlwFjod7wnZXPdEiZ5ahvY/view?usp=sharing
 
*Intersection:* 7. West Main St @ Robbins St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1F63H--kYvzHMFgsmh7UDz3xD-bqUAi-YNCFt4h4P918/edit?usp=sharing
*Video:*https://drive.google.com/file/d/14csymuFLyAsbGFwMqJaCaT4BLyVeoRow/view?usp=sharing
 

https://app.roboflow.com/

More intersections for this project. 
*Intersection:* 70. Route 69 @ Brass Mill Center Dr
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1e8_qWdn0xfxaNUXiMABFVNhQpaO1FgQ-0Yh4YDo-9lY/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1zI2BU0XwqzYV1MzmdoJFYSGsxXwIust1/view?usp=sharing
 
*Intersection:* 61. Washington St @ Sylvan Ave
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1kSF0O_YNiV8sVvoNqsGjzDlR2Hm9DeGo0q8S5gXlekE/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1DCnpnxWajsQs7azN2N4-WavxJbLrtXyK/view?usp=sharing
 
*Intersection:* 58. Baldwin St @ Mill St/Scovill St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1iSBIKka4xdDNByncyhDM4sNvRYLHrZxEmvIn4F59pgA/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1XggD-Uw3z1o6-P0BA0st-sFGtLWWRipl/view?usp=sharing
 
*Intersection:* 49. Market Square @ I-84 EB Off Ramp (Interchange 22)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1eabqh1S6H6vLIHzEqTvfCZEIG0HMgFeA-SsQ1BXeKQU/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1EdAMwgDHJXbELkSqL7EKOVJvVUyTKOPl/view?usp=sharing
 
*Intersection:* 48. South Main St @ Union St/Grand St (SR 847)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1rGzPM4Itx1oNkCbsMtY5ihqg_68yv7aQ8p1_YA0snlA/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1Lr-s5OssL5lblh1lvF6UmB700KSl_htM/view?usp=sharing
 
*Intersection:* 27. Bank St @ Jackson St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1cwbFlmpVwQD63z5zthu8a0xgjAIto-59Tb2S5ujmO-w/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1kKoHCMf2Pbs91rN_J2yXvLd3eugRVSE0/view?usp=sharing
 
*Intersection:* 19. West Main St @ Meadow St/Willow St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1RxPCD3goaect1JS-dIavKRm3-hes9ArOz22gzWj1tes/edit?usp=sharing
*Video:* https://drive.google.com/file/d/12NTE55rstrO9GEmsKPjdnQ0PflnaGP11/view?usp=sharing
 
*Intersection:* 39. W Main St @ Central Ave
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1kjNrD2OPfGMKMnqJp5FEp7RQq5gfd6_G6QnFHMEiJ70/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1F9mHkkcBCzXB1cd9TU-9Gn-G3At-f9Yn/view?usp=sharing
 
*Intersection:* 51a. South Main St @ E Clay St/W Clay St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1WqvS-eF5Nun6Bb1FhQ86o3hcBrpN82yprscOsAde9qA/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1JdhVUQAbtaQjrsCnVIGLsesBOe4kK49p/view?usp=sharing
 
*Intersection:* 51b. E Clay St and S Elm St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1-gBfIBpg4fYOK7X-lKvFeJD3izcRbCqMgtLne0fZLQI/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1JdhVUQAbtaQjrsCnVIGLsesBOe4kK49p/view?usp=sharing
 
*Intersection:* 54. E Main St @ N Elm St/S Elm St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1_rYCnoXBxoATDqrHrliClSB9ntG8IXbWJcJcttYnQ1A/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1xnj4gQbqptDV4vILnRIoJLXMZTTcyUfB/view?usp=sharing
 
*Intersection:* 60. Baldwin St @ I-84 EB On Ramp (Interchange 23)/McMahon St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1PYNiCt4D8S3miD2R4B6RFqKCWcHA1p4aO1VvPIMpsLE/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1OuOB-s0RO8wYsfwtsxUTV43oa6JCCHuX/view?usp=sharing
 
*Intersection:* 57. Baldwin St/Cherry Street @ East Main St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1WJpBHFfB_i1-PV9wvH8oav-_BKwjevV2puhZIeVoILk/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1NTw-0j-tp2auyfxBWHU15QXocq6TrV2T/view?usp=sharing
 
*Intersection:* 44. W Main St @ N Main St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1yRHEctEe_tLcZ3J50roq8xchzIk1_4iN66bPyIWDxig/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1TJtVVpapXVfHWgUkRVxNJ6EKLzfUwNx8/view?usp=sharing
 
*Intersection:* 41. W Main St @ Church St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1L1nostXOKioTK5GfmtJbKppOd307eIEVvA4_TefBe5M/edit?usp=sharing
*Video:* https://drive.google.com/file/d/12RWvI_BrJJhErntn1PkyxuqxSLYzltq-/view?usp=sharing

More intersections for this project. 
 
*Intersection:* 71. Route 69 @ East Main St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/17zECgzKDu3AavfLMLtYxbuFV4E3Ioab_CM9ahbqVkwg/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1bKuFCGXGvKFf8jbNNO94HCVyL_9Qomr5/view?usp=sharing
 
*Intersection:* 52. South Main St @ E Liberty St/W Liberty St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1uVpk0I-YYj7L527hKwvyshBTNsBq1c0EZIjeN2RRM6Q/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1QbUVA21XJX72wB0nvjArTN6oyM9MCyWy/view?usp=sharing
 
*Intersection:* 42. W Main St @ Leavenworth St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1gcXF2QytXCXyO3IpXeFFI--UyiHT90jxjRQL1yucM2Y/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1S_is5B3cJNqSJ2NQhAfjKX9Xvktttjcb/view?usp=sharing
 
*Intersection:* 22. Meadow St @ Field St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1JIBo4sy2FZXH9Ev5ZtLrdXZ7aRfFqLYYwZHkCGeaiWQ/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1xHwxRTfImAcebrrGNEAclwdOuqPbFSrd/view?usp=sharing
 
*Intersection:* 62. Washington St @ I-84 EB Off Ramp (Interchange 23)
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1mGnXgdCDIBooxQwybMVMXaOERp_VL-24TIdqCsXR7pI/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1_VITf3q3vJU_ZD-JjMVnZMS-_swEiKgj/view?usp=sharing

Here is part one for this project. 
 
All the pictures with directions are in the spreadsheet. 
 
 
*Intersection:* 20. Meadow St @ Freight St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1ZQHUUpas8vJG5RKsqlLdPBPOqpYEjzM5QSj4EpMERKc/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1mtXWGyeFFeCClPwrCPRlI285Pt1VMA_1/view?usp=sharing
 
*Intersection:* 21. Meadow St @ Grand St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1mOTk66BSPW4bgxry44IQkrYD5wtNkJxwRjilqYbBr18/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1kWDzezOWR7_3MgX9hB77fSYb9sFzL176/view?usp=sharing
 
*Intersection:* 23. I-84 WB Off-Ramp @ Field St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1W9OLKna44-sdr0KPvFGn9eakvBbnpX3Tnh41hzn61Os/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1W_s6ftA0YsVaCI-DfIG3dcEwsOMSw4eQ/view?usp=sharing
 
*Intersection:* 24. Meadow St @ I-84 EB On-Ramp
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1UOe-mFru8u9IBqtiPVI-B_c8U068E3hT1QdvEKPg2Nw/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1YO6NkqNEAAZhIexWHDB1BoVheBZB-v80/view?usp=sharing
 
*Intersection:* 28. Bank St @ W Liberty St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1tzzaUikUe1mpI52dhyVi706ccrH-KswS550PIekM4TQ/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1cbAZWOVpOBN6cq2ZNJSUYOF_G64vXWdI/view?usp=sharing
 
*Intersection:* 40. W Main St North @ W Main St & Park Place
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1MtdM8tqsqwZtRzEohsj9J08lOGAWuXa9St-gmntDn7w/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1V-F8fbE97pn8ivUI975jqaBJUzS6FjUD/view?usp=sharing
 
*Intersection:* 50. Market Square @ South Main St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1zIxT3uMYNJ_XwFfgNQ0ZTI_2268YDVZ3jNeoyQE2aDc/edit?usp=sharing
*Video:* https://drive.google.com/file/d/13bOAoVkvv5fyANp66scJlM6Rw1afMr6x/view?usp=sharing
 
*Intersection:* 53a. South Main St @ Washington St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1c-qMR-wL8fXhm1TZrFzvzucoxN5ecFqC11ySSkX_fOw/edit?usp=sharing
*Video:* https://drive.google.com/file/d/16EqaPel_RRl0SnTNqmuryqkL93J85xxB/view?usp=sharing
 
*Intersection:* 53b. South Main St @ Washington St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/10Ws939r5Pb5EqaVRhucLUfFIIp6R0PwjVeUnAav-_W0/edit?usp=sharing
*Video:* https://drive.google.com/file/d/16EqaPel_RRl0SnTNqmuryqkL93J85xxB/view?usp=sharing
 
*Intersection:* 59. Union St @ Mill St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1KuUTHaMoUleKrZ6jINE1-aQXC8dM9rmI8fsssWig8tI/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1OMi3mpGnomYz9eDnPNj1YcL4sU8w_l_q/view?usp=sharing
 
*Intersection:* 63. Brass Mill Dr @ Welton St and East Main St
*Spreadsheet:* https://docs.google.com/spreadsheets/d/1Y0fvLzLqNYkLOZSPbV-TrCB-evmj-JDEebPQw_KIG9I/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1gmIJ4wXXBEmoGokeIx1UmyG0hy4NjykN/view?usp=sharing
 
*Intersection:* 64. Brass Mill Dr @ Driveways To Brass Mill Commons
*Spreadsheet:* https://docs.google.com/spreadsheets/d/12BeqhFauifj7BYtSxu0uZuQ4-uZUHSWHhObw4y6_Des/edit?usp=sharing
*Video:* https://drive.google.com/file/d/1hMu90EJnlCOuTEWyOKUqe-F2mG9jRt6A/view?usp=sharing
 

After processing the video, all objects are recognized as "vehicle_type" => "Vehicle", including pedestrians and trucks.

After placing the coordinates on the image and clicking the Save Coordinates, the coordinates revert to their initial position.

This video did not produce any rsults. please review and update.

As we discussed on the phone earlier today, here are some videos that would have trucks and pedestrians. Pedestrians are counted when they cross the approach and bicycles are counted along with traffic movement. Trucks are everything bigger than a pickup truck
 
*Pedestrians/Bikes:* 
https://drive.google.com/file/d/1TjLYALENYD4crNm_hb6yrYGR_yG_BhfL/view?usp=sharing
 
https://drive.google.com/file/d/1WMLH2ptOrYSEnSvODSDhhXT5YqN8NEd-/view?usp=sharing
 
https://drive.google.com/file/d/18tZnA8ebr2sD3EXDuoc78WsatZAcl_Al/view?usp=sharing
 
https://drive.google.com/file/d/1NC_ukfRWOGCKNG7Zeq5p7P4i-b0VKuhO/view?usp=sharing
 
https://drive.google.com/file/d/1kyw6yV0D3PIatUn6GMrmYgeDcZZcpkZn/view?usp=sharing
 
*Trucks*
https://drive.google.com/file/d/1Qq54fyWppGI5Xse54LC9ohjDeZcBqeRU/view?usp=drive_link
 
https://drive.google.com/file/d/1dINusjFhjdJuxu72SxDrXEUOtXpfPZC8/view?usp=sharing
 
https://drive.google.com/file/d/1b5V5hgbJuh9g6re8piK7EFwH7lHLPAyk/view?usp=sharing
 
https://drive.google.com/file/d/1b38vCylF8TSNfOk4CX0suuK3omtemZwU/view?usp=sharing

After specifying the coordinates, when clicking the 'Save Coordinates' button, the coordinates are not saved, and they need to be set again.
 After manually entering the coordinates in editing, they started to be saved.
Video ID 70
https://manage.netc.ourdevapps.com/admin/videos?page=4
https://manage.netc.ourdevapps.com/admin/videos/70/edit

For some videos, for unclear reasons, the processing process stops at 90% completion.
There are no data in the Excel file.

https://docs.google.com/document/d/1T6WLfq6YqF2IfXoMEBZhGQOdWRzEjveEAP-ljNtDIAM/edit?usp=sharing вот в этот документ добавляйте скрины и как пользоватся

When processing video from the Python script, it's necessary to send endpoint to the backend  every 5% of the video processed.
(To display the video processing progress to the user.)

After processing the video, there is data in the CSV file, but the Excel file is not being generated

When processing the video, the process does not complete and constantly stays in the 'processing' status. We need to check the server to see what's preventing it from completing.
Pid
454076
454313
|454536|
email: max@verixity.com password: verixity
 
видео на последних страницах нажимаешь "..." - Process As New Job
 
потом идешь в https://manage.netc.ourdevapps.com/admin/jobs
Там видео появляется (через минуту)то для которого ты запустил процесс
Link Preview__
Sign in to your account - Laravel
 
получает статус processing потом должен быть статус completed
 
когда статус completed нажимаешь на "..." и CSV (файле должна быть информация) но ее нет и показывается - [] // app/Http/Controllers/ExportDataFromJobController.php:17
__
когда процесс прошел успешно как в ID157 видео name - TestOneCarTestTest
получаем информацию
array:1 911
"video_id" => 39
"job_id" => 157
"timestamp" => 4
"zone_from" => "Northbound"
"zone_to" => "Southbound"
"additional_data" => null
"vehicle_id" => 1
"vehicle_type" => "Vehicle"
">▼ // app/Http/Controllers/ExportDataFromJobController.php:17
0 => array:9 ▼
"id" => 911
"video_id" => 39
"job_id" => 157
"timestamp" => 4
"zone_from" => "Northbound"
"zone_to" => "Southbound"
"additional_data" => null
"vehicle_id" => 1
"vehicle_type" => "Vehicle"

From client: 
I uploaded different videos with spreadsheets and here are screenshots for directions below. Let me know if this is what you were looking for.
 
1. Chestnut Street and Liberty Street
3. Bridge St at Prospect Hill Rd
5) Route 12 (Norwich Road) at Academy Hill Road (Route 14A)_Cemetery Road (1)
7. Huntington Avenue at South Huntington Avenue
Int 1_ Tolland Turnpike at Route 30 (Deming St)
Intersection 6_ Route 372 at Route 10
Location 6_Groton
Union Street at Maple Street

FTP
projects.verixity.com
login - netc
pass - iDrzrx3w9WDx2hTgZL
---------
Please upload 3 or 5 videos and test.
# follow steps to hook up the video 
# create jobs
# verify that jobs ran and successfully finished
# generate reports (EXCEL file)

Добавить модель с пешеходами, чтоб считать пешеходов также

Videos:
# add the ability to create a new job "Process as New Job."
# Rename to "Update Coordinates on Preview"
Jobs:
1. Add statuses: "Canceled" and "Completed"
2. Add "Cancel Job" in Actions column.
3. only show "generate xls" when job = completed.

Создание функционала для анализа видео с автомобилями, включая рисование линий на кадрах и запись данных о пересечении этих линий машинами в базу данных.
# *Создание скриншотов с видео*:
** Автоматически делать скриншоты первых кадров из видео, прикрепленного к проекту.
** Сохранять эти кадры для дальнейшей обработки.
# *Выбор кадра администратором*:
** Отображать сохраненные кадры в административном интерфейсе.
** Позволить администратору выбрать один кадр для дальнейшего редактирования.
# *Рисование линий на выбранном кадре*:
** В новом окне предоставить администратору возможность рисования линий на выбранном кадре.
** Сохранить обработанный кадр с нарисованными линиями как новое изображение.
( https://www.youtube.com/watch?v=JgLpmqsHf8k ) 
https://github.com/another-coder4life/drawing-on-image 
https://github.com/another-coder4life  посмотри это видео и файлы у этого человека
# *Сохранение координат линий*:
** Сохранить координаты нарисованных линий в отдельный текстовый файл.
** Этот файл должен содержать метаданные линий для дальнейшего анализа в Python-скрипте.
# *Анализ пересечений с линиями*:
** Разработать Python-код, который анализирует, когда автомобили пересекают нарисованные линии.
** Пример: если машина пересекает отмеченную красную линию, двигаясь с севера на юг, это фиксируется как проезд с севера на юг.
# *Запись результатов в базу данных*:
** Записывать данные о пересечениях машинами нарисованных линий в базу данных для дальнейшего анализа
--------------
*перевод ниже* 
-------
Create functionality for analyzing videos with vehicles, including drawing lines on frames and recording data about the crossing of these lines by vehicles into a database.
# *Creating Screenshots from Video*:
** Automatically take screenshots of the first frames from the video attached to the project.
** Save these frames for further processing.
# *Frame Selection by Administrator*:
** Display the saved frames in the administrative interface.
** Allow the administrator to select one frame for further editing.
# *Drawing Lines on the Selected Frame*:
** In a new window, provide the administrator the ability to draw lines on the selected frame.
** Save the edited frame with the drawn lines as a new image.
# *Saving Coordinates of the Lines*:
** Save the coordinates of the drawn lines in a separate text file.
** This file should contain metadata of the lines for further analysis in the Python script.
# *Analyzing Intersections with Lines*:
** Develop Python code that analyzes when vehicles cross the drawn lines.
** Example: if a vehicle crosses a marked red line moving from north to south, this is recorded as a passage from north to south.
# *Recording Results in the Database*:
** Record the data about the vehicles crossing the drawn lines in the database for further analysis.

https://manage.netc.ourdevapps.com/admin/videos/create
when a admin creates a new video mapping, the admin should be able to select a video (from the drop-down of videos, that are new videos)
Admin can name the video and select the start time and date and and time and date. 
admin should be able to select the customer and the project for that customer.
After submission, the video should be added to the JOBs to start analyzing. 
-------------
Make sure that when a new video a user will be selecting, he can not select the video, that is already was used / mapped prevusly. 

# create a username and pssword that client will be using to upload videos.
# Folder should be sitting on the server that currently on a local folder (for testing purposes); the folder should possible to be executed and read by the python script  https://manage.netc.ourdevapps.com/admin/videos/create 
in this admin section.

Anna, please organize the project in the client portal, invite a client into the portal, and show him on how to use it. 
Please, create any necessary tasks after an initial planning session with team.

h4. Python Coding and Model Training:
# *Model Training for Enhanced Detection*:
** Address the issue of training the machine learning model to detect vehicles under challenging conditions, such as at night or from different angles.
# *Model Selection Functionality*:
** Implement a feature allowing the administrator to select the appropriate model for vehicle detection when processing a video.
# *Model List Display*:
** Display a list of available models on the form used by the administrator for processing videos.
h4. Video Masking and Area Identification:
# *Development of HTML-Based Tool*:
** The Python developer will create an HTML-based tool enabling the administrator to identify areas in the video where vehicles enter and exit.
# *Interactive Video Masking*:
** Allow the administrator to delineate zones directly on the video using a WYSIWYG (What You See Is What You Get) or GUI (Graphical User Interface) editor.
** Ensure the functionality is intuitive, enabling the administrator to use a mouse to draw on the video and save the mask for each specific video.
# *Masking Data Storage*:
** Save the masks identified by the administrator in the database as presets or masking areas for each video.
# *Color-Coded Masking*:
** Enable the administrator to use different colors for masking and link these colors to corresponding columns in the report.
h4. Report Generation:
# *Excel Report Structure*:
** Create Excel reports with three tabs, each tab dedicated to a specific type of vehicle.
** Ensure the information in each tab is clearly delineated and corresponds accurately to the vehicle types.
# *Consultation and Collaboration*:
** Conduct regular consultations between the Python developer and the project manager to align on the implementation strategy.
** Review the attached Google Sheets document for further guidance and specifics.
h4. Project Manager's Role:
# *Detail Execution and Coordination*:
** Ensure all aspects of the Python development are executed precisely, adhering to the project specifications.
** Facilitate communication between the Python developer and other team members to ensure clarity and alignment on project goals.
# *Quality Assurance and Testing*:
** Oversee the testing of the new functionalities, particularly the model selection and video masking tools, to ensure they meet the project requirements.
-----------
h3. Детальные Спецификации для Разработки на Python и Управления Проектом
h4. Кодирование на Python и Обучение Моделей:
# *Обучение Моделей для Улучшенного Обнаружения*:
** Решить проблему обучения машинного обучения для обнаружения автомобилей в сложных условиях, таких как ночью или под разными углами.
# *Функциональность Выбора Модели*:
** Реализовать функцию, позволяющую администратору выбирать подходящую модель для обнаружения автомобилей при обработке видео.
# *Отображение Списка Моделей*:
** Отобразить список доступных моделей на форме, используемой администратором для обработки видео.
h4. Маскировка Видео и Определение Областей:
# *Разработка Инструмента на Основе HTML*:
** Разработчик на Python создаст инструмент на основе HTML, который позволит администратору определять области на видео, где въезжают и выезжают автомобили.
# *Интерактивная Маскировка Видео*:
** Позволить администратору обозначать зоны непосредственно на видео с помощью редактора WYSIWYG или GUI.
** Обеспечить интуитивно понятный функционал, позволяющий администратору рисовать на видео мышью и сохранять маску для каждого конкретного видео.
# *Хранение Данных Маскировки*:
** Сохранять маски, определенные администратором, в базе данных как пресеты или области маскирования для каждого видео.
# *Цветовая Кодировка Маскировки*:
** Включить возможность использования администратором различных цветов для маскировки и связать эти цвета с соответствующими столбцами в отчете.
h4. Генерация Отчетов:
# *Структура Отчета Excel*:
** Создать отчеты Excel с тремя вкладками, каждая из которых посвящена определенному типу автомобилей.
** Убедиться, что информация в каждой вкладке четко разделена и соответствует типам транспортных средств.
# *Консультации и Сотрудничество*:
** Проводить регулярные консультации между разработчиком на Python и управляющим проектом для согласования стратегии реализации.
** Ознакомиться с приложенным документом Google Sheets для дополнительных рекомендаций и конкретики.
h4. Роль Управляющего Проектом:
# *Точное Исполнение и Координация*:
** Обеспечить точное выполнение всех аспектов разработки на Python, соблюдая спецификации проекта.
** Облегчить коммуникацию между разработчиком на Python и другими членами команды для обеспечения ясности и согласованности целей проекта.
# *Контроль Качества и Тестирование*:
** Контролировать тестирование новых функций, особенно выбор модели и инструментов маскировки видео,
 

This project will have a robust system based on Orchid software  https://orchid.software/ ] that will be customized and integrated with Python. (Laravel Orchid is a powerful open-source package that simplifies the development and creation of administration-style applications. With its elegant and intuitive interface, developers can quickly implement beautiful and functional interfaces with minimal effort. )
h4.
Administrator Workflow:
# *Video Upload via FTP*:
** Administrator uploads videos through an FTP server, provided by the System Administrator.
# *Video Management in Administration Section*:
** Uploaded videos become visible in the administration section of the application.
** Administrator links videos to specific projects, setting start and end times for each video within a project.
# *Job Creation and Execution*:
** Administrator initiates a job by clicking on 'create a job'.
** The server schedules and executes the job as a cron job within a 5 or 10-minute interval, processing the videos.
# *Log Generation for Debugging*:
** As the server processes each video, it generates logs and activity records for debugging and quality testing.
# *Report Review and Organization*:
** Upon job completion, the system generates Excel and PDF reports as deliverables.
** Administrator reviews these reports, organized by execution date, video usage, and time frames.
# *Communication with Clients*:
** Administrator selects an email template to communicate results to the client.
# *Administration Section Overview*:
** The administration section includes lists of customers, projects, videos, jobs, logs, users, email templates, and sent emails.
h4. QA Team Workflow:
# *Pre-Delivery Testing*:
** QA team tests the system thoroughly before handing it over to the customer.
# *Functionality Testing*:
** Ensure the smooth functioning of video uploads, linking, job creation, and execution.
# *Log and Report Verification*:
** Verify the accuracy and completeness of logs and reports generated by the system.
# *User Interface Testing*:
** Test the user interface for ease of navigation and functionality in the administration section.
# *Email Communication Testing*:
** Ensure the email templates and sending functionality work correctly.
# *Performance Testing*:
** Test the system's performance, especially the processing speed and efficiency of the cron jobs.
# *Final Approval for Customer Use*:
** Once all tests are successfully passed, approve the system for customer use.

h4. Project Summary:
Development of a web application for traffic video analysis, including the setup of development, staging, and production environments, with emphasis on GPU utilization for video processing. The project involves system administration, testing, project management, and graphic design tasks.
h4. Task List and Description
*For System Administrator:*
# *Environment Setup*:
*
** Description: Set up development and staging environments on internal servers. Ensure the implementation of Docker and proper linkage of pipelines between environments.
# *Production Environment Preparation*:
*
** Description: Collaborate with the customer to set up the production environment on their server, ensuring the inclusion of GPU for optimal video processing.
# *Temporary Cloud Service Setup*:
*
** Description: Arrange a temporary GPU-enabled cloud service account for development and testing purposes.
# *Credentials and Database Access Provision*:
*
** Description: Create and distribute access credentials to developers and provide web interface access to the MySQL database for testers, project managers, and developers.
*For Testers:*
# *Testing Environment Access*:
*
** Description: Utilize provided web interface access to perform database testing in development and staging environments.
# *Functionality and User Experience Testing*:
*
** Description: Test the application for functionality, performance, and user experience, particularly focusing on the administration section and project creation process.
*For Project Managers:*
# *Project Coordination and Documentation*:
*
** Description: Oversee project development, ensuring adherence to scope and timelines. Initiate and maintain comprehensive project documentation.
# *Client Communication and Feedback Integration*:
*
** Description: Facilitate communication with the client, gather feedback, and ensure its integration into the project development process.
*For Graphic Designer:*
# *Design Creation*:
*
** Description: Develop and complete the design elements of the project, including the user interface of the web application, within the next five business days.
# *Collaboration with Development Team*:
*
** Description: Work closely with the development team to ensure design elements are seamlessly integrated into the application.
-------------
h3. Перевод организации проекта на русский язык
h4. Общее описание проекта:
Разработка веб-приложения для анализа видео дорожного движения, включая настройку сред разработки, тестирования и производства, с акцентом на использование GPU для обработки видео. В проект вовлечены задачи системного администратора, тестировщиков, управляющих проектами и графических дизайнеров.
h4. Список задач и описание
*Для системного администратора:*
# *Настройка сред*:
** Описание: Настройка сред разработки и тестирования на внутренних серверах. Обеспечение реализации Docker и правильного соединения конвейеров между средами.
# *Подготовка производственной среды*:
** Описание: Совместная работа с клиентом по настройке производственной среды на их сервере, обеспечивая включение GPU для оптимальной обработки видео.
# *Настройка временного облачного сервиса*:
** Описание: Организация временного аккаунта в облачном сервисе с поддержкой GPU для целей разработки и тестирования.
# *Предоставление учетных данных и доступа к базе данных*:
** Описание: Создание и распределение учетных данных доступа для разработчиков и предоставление доступа к интерфейсу MySQL для тестировщиков, управляющих проектами и разработчиков.
*Для тестировщиков:*
# *Доступ к тестовой среде*:
** Описание: Использование предоставленного доступа к интерфейсу для тестирования базы данных в средах разработки и тестирования.
# *Тестирование функциональности и пользовательского опыта*:
** Описание: Тестирование приложения на функциональность, производительность и удобство использования, особенно сосредоточившись на разделе администрирования и процессе создания проекта.
*Для управляющих проектами:*
# *Координация проекта и документация*:
** Описание: Общее руководство проектом, обеспечение соответствия задач и временных рамок. Инициирование и ведение полной проектной документации.
# *Коммуникация с клиентом и интеграция обратной связи*:
** Описание: Обеспечение связи с клиентом, сбор обратной связи и обеспечение ее интеграции в процесс разработки проекта.
*Для графического дизайнера:*
# *Создание дизайна*:
** Описание: Разработка и завершение дизайнерских элементов проекта, включая пользовательский интерфейс веб-приложения, в течение следующих пяти рабочих дней.
# *Сотрудничество с командой разработчиков*:
## Описание: Тесное сотрудничество с командой разработчиков для обеспечения беспрепятственной интеграции дизайнерских элементов в приложение.
##
-------------------

h4. *Project Overview*
Verixity will develop a web-based application for ENTC to manage traffic video analysis projects. The application will allow administrators to create projects, link video files to these projects, and view the results of traffic analysis in the form of database entries and Excel reports.
h3. *Key Features and Functionalities*
* *User Management and Project Administration*
* *User Authentication and Authorization:* Secure login for administrators, with role-based access controls for administrators and staff.
* *Project Creation and Management:* Facilities to create new projects, including fields for client information, location details, and date, as well as capabilities to view, edit, and delete existing projects.
* *Video Processing and Analysis*
* *Video File Management:* An interface to view and manage a list of uploaded videos via FTP and link them to specific projects.
* *Video Analysis Job Submission and Processing:* A feature to submit video analysis jobs with backend scheduling for processing within 5 minutes, using a Python script (employing libraries like OpenCV and Yolo v8) for analyzing traffic data and identifying various vehicle movements, with various triggering positions and zones.
* *Data Management and Reporting*
* *Data Storage:* Utilizing a MySQL database to store detailed traffic data, including vehicle movements (U-Turn, Left, Thru, Right), timestamps, and project identifiers.
* *Excel Report Generation:* PHP Laravel functionality to generate Excel reports summarizing traffic data in 15-minute intervals, formatted as per the provided example.
* *Data Review and Export:* Interface options for administrators to review raw data, generated reports, and download options for Excel files and video links.
* *Communication and Client Interface*
* *Notification System:* Automated email notifications to administrators upon job completion, including job status and links for data and report review.
* *Client Data Transmission:* A system for administrators to easily send Excel reports and video links to clients.
h4. *Technical Specifications*
* *Frontend:* HTML, CSS, JavaScript (with frameworks like Vue.js or React).
* *Backend:* PHP with Laravel framework.
* *Database:* MySQL.
* *Video Processing:* Python with libraries suitable for video analysis (OpenCV and Yolo v8).
* *Hosting:* dedicated hosting (Digital Ocean & s3 cloud storage by Digital Ocean)
* *Security:* SSL for secure data transmission, data encryption, and secure storage practices.
h4. *Capabilities and Specifications:*
* *Pedestrian and Bicycle Movement Counting:*
* Capability: Yes
* Details: Usage of data models for counting pedestrians at crosswalks and bicycles along roads.
* *Vehicle Classification:*
* Capability: Partial
* Details: Limited ability to differentiate all 13 vehicle classes initially. May need further data model training. Implementation of a "multi-model interface pipeline."
* *Modes for Intersections and Road Segments:*
* Capability: Yes
* Details: Two distinct modes available. Flexibility in model selection or auto-detection during video upload.
* *Video Frame Rate Compatibility:*
* Capability: Yes
* Details: Minimum of 30 fps; higher frame rates preferred. Higher resolution enhances detection quality.
* *Video Analysis for Various Conditions:*
* High Angle Camera: Supported.
* Dark Lighting Conditions: Use of a model trained for night lighting. Ability to transition to evening/night mode for data collection during darker hours.
* Multi-Lane Intersections: Challenging but doable.
* *Video Data Processing:*
* Data Volume: Around 200 GB/month.
* Server Requirements: Recommendation for a GPU-equipped server.
* Cost Implications: To be provided by Verixity dev team
* *Model Training and Adaptability:*
* Potential need for additional training of models, especially for night mode.
* Possibility to edit/adjust models in the future for different data types like speed.
h4. *Server Development and Hosting:*
# *Development Server Usage:* The Verixity Development team will utilize their own server for the development of the project for New England Traffic Counts. This service will be provided at no additional cost to New England Traffic Counts.
# *Production Server Recommendations:* It is recommended that the production server for New England Traffic Counts be acquired through Digital Ocean, a platform previously suggested by the Verixity team. This server will be used primarily for storing videos in an S3 storage bucket.
# *Project Delivery and Code Upload:* Upon completion of the project, the Verixity team will be responsible for uploading the final code to the production server provided by New England Traffic Counts.
# *Server Configuration:* The server provided by New England Traffic Counts will be configured to mirror the setup of the development server, ensuring consistency and reliability in the project's deployment.
# *Cost Estimation and Server Specifications:* An estimation of the monthly cost for the server will be provided to New England Traffic Counts. Currently, the project requires a GPU-based server for efficient video processing. Although Digital Ocean does not directly offer GPU-based servers, they have a referral to a company that does provide such services. This information will be shared with New England Traffic Counts for appropriate decision-making.
h4. *Development Phases*
* Requirements Gathering and Planning
* Finalize detailed requirements with the client.
* Plan project milestones and timelines.
* Design
* Create wireframes and design user interfaces.
* Design database schema and system architecture.
* Development
* Frontend and backend development.
* Integration of video analysis script and database.
* Implementation of Excel report generation.
* Testing
* Functional testing of each feature.
* Performance testing, especially for video processing and report generation.
* Security testing to ensure data protection.
* Deployment
* Initial deployment on a staging server (Verixity server) for client review.
* Final deployment to the production server (client’s server).
* Training and Documentation
* Provide training to administrators on how to use the application.
* Prepare comprehensive documentation.
* Maintenance and Support
* Weekly database backups
* Monthly web server maintenance
h4. *Reporting and Communication*
* Regular progress updates via email or project management tools (Client Portal).
* Scheduled meetings for milestone reviews and feedback.
 
-----------
initial request from the customer:
https://docs.google.com/document/d/1qDlNRM73d2ILB7tMKDMg5zlJDb63VrniT7bY8TD2LaE/edit 

Development of a comprehensive web application for New England Traffic Counts (ENTC) to facilitate efficient management and analysis of traffic video data, including user management, project administration, video processing, data reporting, and client communication.
The Epic encompasses the development of a web-based application for ENTC, focusing on the end-to-end management of traffic video analysis projects. Key functionalities include:
# *User Management and Project Administration*: This includes secure login for administrators, role-based access controls, and facilities to create, view, edit, and delete projects, along with managing client information and project details.
# *Video Processing and Analysis*: Implementation of an interface for managing uploaded videos, linking them to projects, and processing video analysis jobs using Python scripts with OpenCV and Yolo v8 libraries. This feature will support various vehicle movements and positions.
# *Data Management and Reporting*: Utilizing a MySQL database to store traffic data (vehicle movements, timestamps), and generating Excel reports to summarize the data. This also includes reviewing and exporting raw data and reports.
# *Communication and Client Interface*: Establishing an automated notification system for job completion and a system for administrators to send reports and video links to clients.
# *Technical Specifications*: The frontend will use HTML, CSS, JavaScript with frameworks like Vue.js or React. The backend will be powered by PHP with Laravel or Orchad framework, and video processing will utilize Python with libraries suitable for video analysis. Hosting will be done on Digital Ocean with s3 cloud storage, and security will be ensured via SSL, data encryption, and secure storage practices.
# *Capabilities and Specifications*: The app will have capabilities for pedestrian and bicycle movement counting, vehicle classification, modes for intersections and road segments, video frame rate compatibility, and adaptability to various video analysis conditions.