# Using Deep Learning for Collecting Data about Museum Visitor Behavior
## Appendix A SQL Queries  
This appendix contains all the queries described in Section 4.3. ``` CREATEVIEWdist_positionsAS SELECTDISTINCTP.TIMESTMP,P.BADGE_ID,c.CT
3/*Changingthereferencesystem*/ P.X+C.XASX, P.Y+C.YASY, P.Z+C.ZASZ FROMpositionsP,cameraC
8 MHEREP.CAMERA_ID=C.CAMERA_ID

## References

* (1)
* (2) [PERSON]; [PERSON]; [PERSON] Listen to What You Look at: Combining an Audio Guide with a Mobile Eye Tracker on the Go. In _Proceedings of the 10 th International Workshop on Artificial Intelligence for Cultural Heritage Co-Located with the 15 th International Conference of the Italian Association for Artificial Intelligence (APIA 2016)_, _CEUR Workshop Proceedings_; [PERSON], [PERSON], [PERSON], Eds. ; CEUR-WS.org: Aachen, Germany, 2016; Volume 1772, pp. 2-9. * (3) [PERSON]; [PERSON]; [PERSON] Personalization in Cultural Heritage: The Road Travelled and the One Ahead. _User Model. User-Adapt. Interact._**2012**, _22_, 73-99. [CrossRef]
* (4) [PERSON]; [PERSON] [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON] Visualizing Museum Visitors' Behavior: Where Do They Go and What Do They Do There? _Pers. Ubiquitous Comput._**2017**, _21_, 313-326. [CrossRef]
* (5) [PERSON] [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON] Deep Artwork Detection and Retrieval for Automatic Context-Aware Audio Guides. _ACM Trans. Multimed. Comput. Commun. Appl._**2017**, _13_, 35:1-35:21. [CrossRef]
* (6) [PERSON]; [PERSON] [PERSON]; [PERSON]; [PERSON] [PERSON]; [PERSON] Visualizing, clustering, and predicting the behavior of museum visitors. _Pervasive Mob. Comput._**2017**, _38_, 430-443. [CrossRef]
* (7) [PERSON] [PERSON]; [PERSON]; [PERSON] [PERSON] Mobile user tracking system with ZigBee. _Microprocess. Microsyst._**2016**, _44_, 47-55. [CrossRef]
* (8) [PERSON]; [PERSON]; [PERSON]; [PERSON] [PERSON]; [PERSON] The museum visit: Generating seamless personalized presentations on multiple devices. In _Proceedings of the 9 th International Conference on Intelligent User Interfaces_; ACM: New York, NY, USA, 2004; pp. 316-318. * (9) [PERSON]; [PERSON] [PERSON] A Nomadic Information System for Adaptive Exhibition Guidance. _Arch. Mus. Inform._**1999**, _13_, 127-138. [CrossRef]
* (10) [PERSON] [PERSON]; [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON] Knowledge-based smart city service system. _Electronics_**2020**, \(9\), 965. [CrossRef]
* (11) [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON]; [PERSON] Enhancing Cultural Recommendations through Social and Linked Open Data. _User Model. User-Adapt. Interact._**2019**, _29_, 121-159. [CrossRef]
* (12) [PERSON]; [PERSON]; [PERSON] [PERSON]; [PERSON] Towards robots reasoning about group behavior of museum visitors: Leader detection and group tracking. _J. Ambient Intell. Smart Environ._**2018**, _10_, 3-19. [CrossRef]
* (13) [PERSON]; [PERSON]; [PERSON]; [PERSON] Measurement and analysis of visitors' trajectories in crowded museums. In Proceedings of the IMEKO TC4 International Conference on Metrology for Archaeology and Cultural Heritage (MetroArchaeo 2019), Florence, Italy, 4-6 December 2019; pp. 423-428. * (14) [PERSON]; [PERSON]; [PERSON] [PERSON]; [PERSON]; [PERSON] [PERSON]; [PERSON] Tracking visitors in a real museum for behavioral analysis. In Proceedings of the 2016 Joint 8 th International Conference on Soft Computing and Intelligent Systems (SCIS) and 17 th International Symposium on Advanced Intelligent Systems (ISIS), Sapporo, Japan, 25-28 August 2016; pp. 80-85. * (15) [PERSON]; [PERSON]; [PERSON]; [PERSON] Survey of Wireless Indoor Positioning Techniques and Systems. _IEEE Trans. Syst. Man Cybern. Part C (Appl. Rev. )_**2007**, _37_, 1067-1080. [CrossRef]* [PERSON] et al. (2019) [PERSON]; [PERSON]; [PERSON] A Survey of Indoor Localization Systems and Technologies. _IEEE Commun. Surv. Tutor._**2019**, _21_, 2568-2599. [CrossRef]
* [PERSON] et al. (2020) [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON]; [PERSON]; [PERSON] [PERSON]; [PERSON] Machine Learning for Cultural Heritage: A Survey.