{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,3]],"date-time":"2026-07-03T00:46:15Z","timestamp":1783039575848,"version":"3.54.6"},"reference-count":44,"publisher":"MDPI AG","issue":"11","license":[{"start":{"date-parts":[[2016,10,29]],"date-time":"2016-10-29T00:00:00Z","timestamp":1477699200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Sensors"],"abstract":"<jats:p>The efficient sharing of spatio-temporal trajectory data is important to understand traffic congestion in mass data. However, the data volumes of bus networks in urban cities are growing rapidly, reaching daily volumes of one hundred million datapoints. Accessing and retrieving mass spatio-temporal trajectory data in any field is hard and inefficient due to limited computational capabilities and incomplete data organization mechanisms. Therefore, we propose an optimized and efficient spatio-temporal trajectory data retrieval method based on the Cloudera Impala query engine, called ESTRI, to enhance the efficiency of mass data sharing. As an excellent query tool for mass data, Impala can be applied for mass spatio-temporal trajectory data sharing. In ESTRI we extend the spatio-temporal trajectory data retrieval function of Impala and design a suitable data partitioning method. In our experiments, the Taiyuan BeiDou (BD) bus network is selected, containing 2300 buses with BD positioning sensors, producing 20 million records every day, resulting in two difficulties as described in the Introduction section. In addition, ESTRI and MongoDB are applied in experiments. The experiments show that ESTRI achieves the most efficient data retrieval compared to retrieval using MongoDB for data volumes of fifty million, one hundred million, one hundred and fifty million, and two hundred million. The performance of ESTRI is approximately seven times higher than that of MongoDB. The experiments show that ESTRI is an effective method for retrieving mass spatio-temporal trajectory data. Finally, bus distribution mapping in Taiyuan city is achieved, describing the buses density in different regions at different times throughout the day, which can be applied in future studies of transport, such as traffic scheduling, traffic planning and traffic behavior management in intelligent public transportation systems.<\/jats:p>","DOI":"10.3390\/s16111813","type":"journal-article","created":{"date-parts":[[2016,10,31]],"date-time":"2016-10-31T11:09:46Z","timestamp":1477912186000},"page":"1813","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":8,"title":["An Efficient Method of Sharing Mass Spatio-Temporal Trajectory Data Based on Cloudera Impala for Traffic Distribution Mapping in an Urban City"],"prefix":"10.3390","volume":"16","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-3424-1729","authenticated-orcid":false,"given":"Lianjie","family":"Zhou","sequence":"first","affiliation":[{"name":"State Key Laboratory for Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, 129 Luoyu Road, Wuhan 430079, China"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3521-9972","authenticated-orcid":false,"given":"Nengcheng","family":"Chen","sequence":"additional","affiliation":[{"name":"State Key Laboratory for Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, 129 Luoyu Road, Wuhan 430079, China"},{"name":"Collaborative Innovation Center of Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Sai","family":"Yuan","sequence":"additional","affiliation":[{"name":"State Key Laboratory for Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, 129 Luoyu Road, Wuhan 430079, China"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Zeqiang","family":"Chen","sequence":"additional","affiliation":[{"name":"State Key Laboratory for Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, 129 Luoyu Road, Wuhan 430079, China"},{"name":"Collaborative Innovation Center of Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"1968","published-online":{"date-parts":[[2016,10,29]]},"reference":[{"key":"ref_1","doi-asserted-by":"crossref","unstructured":"Nellore, K., and Hancke, G.P. (2016). A Survey on Urban Traffic Management System Using Wireless Sensor Networks. Sensors, 16.","DOI":"10.3390\/s16020157"},{"key":"ref_2","doi-asserted-by":"crossref","first-page":"7797","DOI":"10.3390\/s130607797","article-title":"Performance Evaluation of UHF RFID Technologies for Real-Time Bus Recognition in the Taipei Bus Station","volume":"13","author":"Own","year":"2013","journal-title":"Sensors"},{"key":"ref_3","doi-asserted-by":"crossref","first-page":"26143","DOI":"10.3390\/s151026143","article-title":"A Wireless Sensor Network for Urban Traffic Characterization and Trend Monitoring","volume":"15","year":"2015","journal-title":"Sensors"},{"key":"ref_4","doi-asserted-by":"crossref","first-page":"651","DOI":"10.1109\/JSEN.2004.833520","article-title":"Optimal fusion of multiple nonlinear sensor data","volume":"4","author":"Suranthiran","year":"2004","journal-title":"IEEE Sens. J."},{"key":"ref_5","doi-asserted-by":"crossref","first-page":"185","DOI":"10.1016\/j.envsoft.2014.10.007","article-title":"Web technologies for environmental big data","volume":"63","author":"Vitolo","year":"2015","journal-title":"Environ. Model. Softw."},{"key":"ref_6","doi-asserted-by":"crossref","unstructured":"Oliveira, S.F., Furlinger, K., and Kranzlmuller, D. (2012, January 25\u201327). Trends in computation, communication and storage and the consequences for data intensive science. Proceedings of the IEEE 14th International Conference on High Performance Computing and Communications, Liverpool, UK.","DOI":"10.1109\/HPCC.2012.83"},{"key":"ref_7","unstructured":"Laney, D. 3-D Data Management: Controlling Data Volume, Velocity and Variety. Application Delivery Strategies by META Group Inc.. Available online: http:\/\/blogs.gartner.com\/doug-laney\/files\/2012\/01\/ad949-3D-Data-Management-Controlling-Data-Volume-Velocity-and-Variety.pdf."},{"key":"ref_8","doi-asserted-by":"crossref","first-page":"314","DOI":"10.1016\/j.ins.2014.01.015","article-title":"Data-intensive applications, challenges, techniques and technologies: A survey on big data","volume":"275","author":"Chen","year":"2014","journal-title":"Inf. Sci."},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"573","DOI":"10.1080\/13658816.2015.1104534","article-title":"A land use\/land cover change geospatial cyberinfrastructure to integrate big data and temporal topology","volume":"30","author":"Jin","year":"2016","journal-title":"Int. J. Geogr. Inf. Sci."},{"key":"ref_10","doi-asserted-by":"crossref","first-page":"217","DOI":"10.1016\/j.cviu.2015.06.002","article-title":"PSTG-based multi-label optimization for multi-target tracking","volume":"144","author":"Chen","year":"2016","journal-title":"Comput. Vis. Image Underst."},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"269","DOI":"10.1559\/152304005775194728","article-title":"The Roles of Web Feature Service and Web Map Service in Real Time Geospatial Data Sharing for Time-Critical Applications","volume":"32","author":"Zhang","year":"2005","journal-title":"Geogr. Inf. Sci."},{"key":"ref_12","doi-asserted-by":"crossref","first-page":"123","DOI":"10.1016\/S0198-9715(01)00021-7","article-title":"Impediments to using GIS for real-time disaster decision support","volume":"27","author":"Zerger","year":"2003","journal-title":"Comput. Environ. Urban Syst."},{"key":"ref_13","first-page":"409","article-title":"Automatic search of geospatial features for disaster and emergency management","volume":"6","author":"Zhang","year":"2010","journal-title":"Int. J. Appl. Earth Obs."},{"key":"ref_14","doi-asserted-by":"crossref","first-page":"357","DOI":"10.1007\/BF01231602","article-title":"An introduction to spatial database systems","volume":"3","author":"Ting","year":"1994","journal-title":"VLDB J."},{"key":"ref_15","doi-asserted-by":"crossref","unstructured":"Guttman, A. (1984, January 1\u20134). R-trees: A dynamic index structure for spatial searching. Proceedings of the ACM SIGMOD International Conference on Management of Data, Boston, MA, USA.","DOI":"10.1145\/602264.602266"},{"key":"ref_16","unstructured":"Sellis, T., Roussopoulos, N., and Faloutsos, C. (1987, January 7\u20139). The R+ tree: A dynamic index for multidimensional objects. Proceedings of the 13th International Conference on Very Large Databases, Brighton, UK."},{"key":"ref_17","doi-asserted-by":"crossref","unstructured":"Beckmann, N., Kriegel, H.-P., Schneider, R., and Seeger, B. (1990, January 23\u201325). The R* tree: An efficient and robust access method for points and rectangles. Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data, New York, NY, USA.","DOI":"10.1145\/93597.98741"},{"key":"ref_18","unstructured":"Kamel, I., and Faloutsos, C. (1993, January 12\u201315). Hilbert R-Tree: An improved R-Tree using fractals. Proceedings of the 20th International Conference on Very Large Databases, Santiago de, Chile."},{"key":"ref_19","doi-asserted-by":"crossref","first-page":"1459","DOI":"10.1080\/13658816.2014.894195","article-title":"Optimizing an index with spatiotemporal patterns to support GEOSS Clearinghouse","volume":"28","author":"Xia","year":"2014","journal-title":"Int. J. Geogr. Inf. Sci."},{"key":"ref_20","doi-asserted-by":"crossref","unstructured":"Kothuri, R.K.V., Ravada, S., and Abugov, D. (2002, January 3\u20136). Quad-tree and R-tree indexes in oracle spatial: A comparison using GIS data. Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data, New York, NY, USA.","DOI":"10.1145\/564691.564755"},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"21","DOI":"10.1016\/j.cageo.2012.10.011","article-title":"Development of a web GIS application for emissions inventory spatial allocation based on open source software tools","volume":"52","author":"Gkatzoflias","year":"2013","journal-title":"Comput. Geosci."},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"345","DOI":"10.1016\/j.future.2013.12.036","article-title":"Performance evaluation of NoSQL big-data applications using multi-formalism models","volume":"7","author":"Barbierato","year":"2014","journal-title":"Future Gener. Comput. Syst."},{"key":"ref_23","unstructured":"Vora, M.N. (2011, January 24\u201326). Hadoop-Hbase for large-scale data. Proceedings of the 2011 International Conference on Computer Science and Network Technology (ICCSNT), Harbin, China."},{"key":"ref_24","doi-asserted-by":"crossref","first-page":"35","DOI":"10.1145\/1773912.1773922","article-title":"Cassandra: A decentralized structured storage system","volume":"44","author":"Lakshman","year":"2010","journal-title":"ACM SIGOPS Oper. Syst. Rev."},{"key":"ref_25","doi-asserted-by":"crossref","first-page":"205","DOI":"10.1145\/1365815.1365816","article-title":"Bigtable: A distributed storage system for structured data","volume":"26","author":"Chang","year":"2008","journal-title":"ACM Trans. Comput. Syst."},{"key":"ref_26","doi-asserted-by":"crossref","unstructured":"Calil, A., and Mello, R.D.S. (2012, January 18\u201321). SimpleSQL: A Relational Layer for SimpleDB. Proceedings of the East European Conference on Advances in Databases and Information Systems, Pozna\u0144, Poland.","DOI":"10.1007\/978-3-642-33074-2_8"},{"key":"ref_27","first-page":"2","article-title":"A Distributed Infrastructure for Earth-Science Big Data Retrieval","volume":"2","author":"Liakos","year":"2015","journal-title":"Int. J. Coop. Inf. Syst."},{"key":"ref_28","doi-asserted-by":"crossref","first-page":"563","DOI":"10.1007\/s10586-014-0417-5","article-title":"A spreading activation algorithm of spatial big data retrieval based on the spatial ontology model","volume":"18","author":"Sun","year":"2015","journal-title":"Cluster Comput."},{"key":"ref_29","doi-asserted-by":"crossref","unstructured":"You, S., Zhang, J., and Le, G. (2015, January 13\u201317). Large-scale spatial join query processing in Cloud. Proceedings of the 31st IEEE International Conference on Data Engineering Workshops (ICDEW), Seoul, Korea.","DOI":"10.1109\/ICDEW.2015.7129541"},{"key":"ref_30","unstructured":"Impala Cloudera Impala 2.0.0. Available online: http:\/\/www.cloudera.com\/products\/apache-hadoop\/impala.html."},{"key":"ref_31","unstructured":"Hive Apache Hive 2.0.0. Available online: http:\/\/hive.apache.org\/."},{"key":"ref_32","doi-asserted-by":"crossref","first-page":"118","DOI":"10.1016\/j.cpc.2015.08.019","article-title":"Visualizing long vectors of measurements by use of the Hilbert curve","volume":"197","author":"Estevezrams","year":"2015","journal-title":"Comput. Phys. Commun."},{"key":"ref_33","doi-asserted-by":"crossref","first-page":"1345","DOI":"10.1080\/13658810802634956","article-title":"An overview on current free and open source desktop GIS developments","volume":"23","author":"Steiniger","year":"2009","journal-title":"Int. J. Geogr. Inf. Sci."},{"key":"ref_34","first-page":"57","article-title":"A framework for sharing and integrating remote sensing and GIS models based on Web Service","volume":"1","author":"Chen","year":"2014","journal-title":"Sci. World J."},{"key":"ref_35","doi-asserted-by":"crossref","first-page":"1429","DOI":"10.1109\/JSEN.2010.2095839","article-title":"A flexible data and sensor planning service for virtual sensors based on web service","volume":"6","author":"Chen","year":"2011","journal-title":"IEEE Sens. J."},{"key":"ref_36","unstructured":"Br\u00f6ring, A., Stasch, C., and Echterhoff, J. (2012). OGC Sensor Observation Service Interface Standard (Version 2.0), Open Geospatial Consortium."},{"key":"ref_37","doi-asserted-by":"crossref","first-page":"2652","DOI":"10.3390\/s110302652","article-title":"New Generation Sensor Web Enablement","volume":"11","author":"Echterhoff","year":"2011","journal-title":"Sensors"},{"key":"ref_38","unstructured":"Botts, M. (2007). OpenGIS Sensor Model Language (SensorML) Implementation Specification, Open Geospatial Consortium."},{"key":"ref_39","unstructured":"Cox, S. (2007). OGC Implementation Specification 07-022r1: Observations and Measurements\u2014Part 17 1\u2014Observation Schema, Open Geospatial Consortium."},{"key":"ref_40","unstructured":"Cox, S. (2007). OGC Implementation Specification 07-022r3: Observations and Measurements\u2014Part 19 2\u2014Sampling Features, Open Geospatial Consortium."},{"key":"ref_41","doi-asserted-by":"crossref","first-page":"393","DOI":"10.1007\/s10291-013-0339-3","article-title":"Performance assessment of single- and dual-frequency Beidou\/GPS single-epoch kinematic positioning","volume":"3","author":"He","year":"2014","journal-title":"GPS Solut."},{"key":"ref_42","unstructured":"52 North SOS, 2016. 52 North SOS Prototype 1.0.0. Available online: http:\/\/52north.org\/communities\/sensorweb\/sos\/index.html."},{"key":"ref_43","doi-asserted-by":"crossref","first-page":"7646","DOI":"10.3390\/rs70607646","article-title":"Provenance information representation and tracking for remote sensing observations in a sensor web enabled environment","volume":"6","author":"Chen","year":"2015","journal-title":"Remote Sens."},{"key":"ref_44","doi-asserted-by":"crossref","first-page":"497","DOI":"10.4028\/www.scientific.net\/AMM.571-572.497","article-title":"A real-time log analyzer based on MongoDB","volume":"571\u2013572","author":"Lv","year":"2014","journal-title":"Appl. Mech. Mater."}],"container-title":["Sensors"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/1424-8220\/16\/11\/1813\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T19:34:19Z","timestamp":1760211259000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/1424-8220\/16\/11\/1813"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2016,10,29]]},"references-count":44,"journal-issue":{"issue":"11","published-online":{"date-parts":[[2016,11]]}},"alternative-id":["s16111813"],"URL":"https:\/\/doi.org\/10.3390\/s16111813","relation":{},"ISSN":["1424-8220"],"issn-type":[{"value":"1424-8220","type":"electronic"}],"subject":[],"published":{"date-parts":[[2016,10,29]]}}}