A smart phone-based system for post-earthquake investigations of building damage Zhen Xu a, Xinzheng Lu b,*, Qingle Cheng b, Hong Guan c, Li Deng b, Zongcai Zhang a a Beijing Key Laboratory of Urban Underground Space Engineering, School of Civil and Resource Engineering, University of Science and Technology Beijing, Beijing, China. b Key Laboratory of Civil Engineering Safety and Durability of China Education Ministry, Department of Civil Engineering, Tsinghua University, Beijing, China. c Griffith School of Engineering, Griffith University Gold Coast Campus, Queensland 4222, Australia Abstract: Current post-earthquake investigations of building damage are mainly conducted manually, making the collection and management of the investigation data inefficient. To overcome this shortcoming, a professional system for post-earthquake investigations of building damage is proposed herein using smart phones. This system adopts a framework which uses smart phones for distributed data collection and a web browser for centralized data management. A building-oriented database is designed to satisfy the requirements of data organization in the investigations. In addition, a data exchange mechanism between smart phones and the web server is created, demonstrating a satisfactory level of fault-tolerance for various use cases of the system. Further, an algorithm of reverse address retrieval of photos based on multi-threads is designed to conveniently index photos by their addresses. The proposed system is used in a virtual investigation of Tsinghua University campus and a practical investigation of the Tibet area during the 2015 Nepal earthquake. These case studies demonstrate that the proposed system offers an intelligentized, efficient and networked tool for post-earthquake investigations of building damage. Keywords: Post-earthquake investigation; building damage; smart phones; building-oriented database; data exchange; reverse address retrieval of photos. |
1. Introduction Professional teams (e.g., academics and engineers specialized in building structures) are always sent to the earthquake-hit areas to investigate the seismic damage of buildings after an earthquake[1每2], such as the Wenchuan, Ya*an and Ludian earthquakes in China [3每5], the Canterbury earthquake in New Zealand [6], and the Tohoku earthquake in Japan [7]. Such post-earthquake investigations of building damage can collect disaster information and assess the damage of building structures timely, which is very important for earthquake engineering research and post-disaster recovery and reconstruction activities. Current post-earthquake investigations of building damage are conducted manually involving a combined effort of completing required forms and taking relevant photos [1每7]. For example, the United States published the ATC-20 placard system which provides the investigation forms for assessing post-earthquake safety of buildings [8]. Similar investigation forms and working procedure have also been adopted in Greece [9]. In addition, plenty of photos are required to be taken for each building to record the details of seismic damage. In view of the current practices [1每8], Xu et al. [10] has summarized their drawbacks as follows: (1) the investigation forms have no direct link to the damage photos. Details of building damage are recorded in a large number of photos, which requires extensive additional work to be matched with the investigation forms. It is usual that many photos cannot be identified and are therefore wasted. (2) It is inconvenient to search a photo that is taken at a specific place or on a specific target due to the lack of addresses in the collected photos. (3) The investigation data cannot be timely shared. Effective planning of post-disaster recovery activities reply heavily on the investigation results; however paper-based forms are difficult to be shared as fast as the digital forms, which may delay the decision-making process. As described above, an intelligentized, efficient and networked investigation method is urgently needed. Smart phones can be a great alternative to solve the abovementioned problems for post-earthquake investigations of building damage. Firstly, smart phones can be used to complete the investigation forms and collect multi-media data of seismic damage of buildings (e.g., photos, audios and videos). In addition, these forms and the collected multi-media data can be easily linked by using smart phones, thereby reducing the time-consuming matching work. Secondly, the collected photos can be indexed by their locations because the global positioning system (GPS) coordinates of the photos can be stored by smart phones [11]. According to the latest analysis report of GPS performance which is published by the University of Texas at Austin in 2017 [12], the position service of GPS is available in more than 99% of the earth*s surface. Therefore, the seismic zones can be mostly covered by GPS. Finally, post-earthquake investigation data can be quickly uploaded to the servers through the network of smart phones, so that seismic damage data can be timely shared to support decision making for post-disaster recovery. It is worth noting that post-earthquake investigations of building damage are normally performed after the completions of emergency rescues, so the mobile networks of the disaster area can generally be recovered during the investigations. For instance, in the Wenchuan earthquake with a magnitude of M8.0, it only took four days to recover the mobile network [13]. In the recent Jiuzhaigou earthquake (M7.0) occurring on Aug 8th, 2017, the mobile network was recovered within 24 hours [14]. Therefore, post-earthquake investigations of building damage for the abovementioned earthquakes can be performed using mobile networks. In addition, the mobile network to date is fast enough to meet the transfer requirements of multi-media data in the investigation. For instance, the theoretical downlink and uplink rates of TD-LTE (Time Division-Long Term Evolution), a widely-used 4G network for smart phones, can be up to 100 Mbps and 50 Mbps [15], respectively. The applications of smart phones for collecting disaster data in earthquakes have been reported in the literatures [16每26]. For example, in the United States, Federal Emergency Management Agency (FEMA) also released an application (i.e., FEMA App) with a function of ※submit disaster photos§ [27], through which the post-earthquake photos can be collected from different app users. The UC Berkeley iShake project designed a mobile client-backend server architecture that uses sensor-equipped mobile devices to measure earthquake ground shaking [28]. In Japan, Lwin and Murayama developed a smart phone application based on web geographic information systems (GIS) [29], which can timely display photos from the disaster area. In China, Peng et al. [30] developed a smart phone software called "E-Explorer" to discover the positions of survivors for rescue workers. More recently, Zhao et al. [31] developed a mobile application for earthquake intensity survey, through which the form of intensity survey can be filled in online. However, the abovementioned researches [16每31] do not provide necessary connections between the collected data and the corresponding buildings, which will makes post-earthquake investigations very inefficient. Moreover, the existing researches only focused on collecting the disaster data, with seldom consideration of the subsequent management of the collected data (e.g., the indexing and visualization), making it difficult for the collected data to be used directly for post-earthquake decision-making. In summary, the issues with data collection and management in post-earthquake investigations have not been fully addressed yet. In this study, a professional system for post-earthquake investigations of building damage is proposed using smart phones. This system adopts a framework which uses smart phones for distributed data collection and a web browser for centralized data management. A building-oriented database is designed in this system to establish the link between the collected data and the corresponding buildings, thereby avoiding the time-consuming data identification work. A data exchange mechanism between smart phones and the web server is also created, with a satisfactory level of fault-tolerance for various use cases of the system. Furthermore, an algorithm of reverse address retrieval of photos based on multi-threads is designed to conveniently index photos by their addresses. This system is used in a virtual investigation of Tsinghua University campus and a practical investigation of the Tibet area in the 2015 Nepal earthquake. These case studies demonstrate that the proposed system offers an intelligentized, efficient and networked tool for the post-earthquake investigations of building damage. |
2. Framework The framework of the proposed system includes five components: smart phones, a web browser, a web server, a database, and cloud services, as shown in Fig. 1. Among them, smart phones and the database are used to collect and store the seismic damage data of buildings in post-earthquake investigations, respectively; the web browser is used to manage and display these collected data, while the web server is used for data exchange and processing; the cloud services will provide the map platform and address data for this system.
Fig. 1. The framework of the proposed post-earthquake investigation system The distributed data collection and centralized data management can be easily achieved in this framework. Specifically, users can use many smart phones to perform parallel data collecting tasks for a high efficient investigation; since all of the collected data are transferred to the server, the integrated investigation results can be timely provided to the earthquake emergency command center by using a web browser. In view of the above, this framework is very suitable for post-earthquake investigations of building damage. To implement the above framework, three critical data related challenges need to be addressed: (1) Data organization Post-earthquake investigations involve multi-source data of various types. For example, there may be a large number of users and each of whom may collect different types of data (e.g., building information, positions, photos, videos and audios). How to organize these complicated data is a rather challenging task. As buildings are the basic elements for data collection during the investigation, a building-oriented database is necessary to be established to address the data organization problem. (2) Data exchange Post-earthquake investigations may involve many users and each user may have different working scenarios of data exchanges between smart phones and the web server. Such complicated data exchanges can potentially cause data conflicts or repetitions. For example, two users may submit different names for the same building to the web server, or a user uploads the same photo twice. Therefore, a data exchange mechanism between smart phones and the web server with a satisfactory level of fault-tolerance need to be established. (3) Data indexing Photos are the most important data for recording building damage in a post-earthquake investigation. It is a challenging task to conveniently index photos by their addresses, because the GPS coordinates included in the photos are difficult to be used as search words for users. Generally, people are familiar with addresses rather than the GPS coordinates, hence a reverse address retrieval of photos is necessary to convert the GPS coordinates into addresses. In addition, since a large number of photos are taken in a post-earthquake investigation, the process of the reverse address retrieval of photos must be efficient so that the investigation results can be shared timely with the earthquake emergency command center. |
3 Key Techniques 3.1 A building-oriented database (1) Database design The types of data that will be stored in the database are determined first. There are six types of data in the proposed system: building, user, location, photo, audio and video. Specifically, the building data includes the information of the investigation forms, while the user data includes the name, ID, account, passwords and so on. In this system, smart phones will send the GPS coordinates to the database when a building is investigated. Thus, the location data in the database includes the GPS coordinates and recording time, which are only used to record the locations of buildings. In addition, substantial amount of multi-media data of buildings (i.e., photos, audios and videos) are also generated during an investigation. These data includes files and their associated basic information (e.g., name, ID, stored path of files). The architecture of the database is determined according to the relationship of the aforementioned six types of data. If the number of the multi-media data related to a building is N, the relations between the multi-media data and the building are N : 1. A building has only one location, so the relation of the location and the building is 1 : 1. Since a user can investigate many buildings and a building can also be investigated by many users, so the relation between buildings and users is L : M, where L and M are the numbers of the buildings and users, respectively. Given that the network database [32] is mainly suitable for a corresponding relationship of 1 : N, such a network database cannot be adopted in the proposed system. Also, hierarchical database [33] is not suitable for this system either because the investigation data have no top-down hierarchical relationship. As such, a relational database [34, 35] is chosen for this system. In the relational database, each type of data is created as an entity and each entity has its own storage scheme. Using the relational database, complex relationships of all data can be described by several two-entity corresponding relationships, which is quite efficient for data indexing. (2) Implementation Being one of the most widely-used relational databases, MySQL [36] is adopted in the proposed system. The designed data structure of database is shown in Fig. 2. Entity building is the center of all entities. The relationships between entities building and video, photo and audio are all 1 : N. The relationships between entities building and user is L : M.
Fig. 2. The designed building-oriented database In MySQL, an entity building is established to store the data from the forms of post-earthquake investigations. It should be noted that each building has a unique ID. The entities photo, audio and video are established to store the collected photos, audios and videos in an investigation. These entities include three common items of key information: file ID, file path and building ID. Every file is named with a unique ID. The files are stored in a certain path in the computer in which the database is located. Thus, through the file ID and file path, the database can access any collected files. In order to establish the corresponding relation to buildings, the entities (i.e. photo, audio and video) must have a building ID. It should be noted that if a building*s ID changes, all entities with this building ID should be changed accordingly. An entity user is created with a unique user ID for each user. To establish the L : M corresponding relationship between user and building, the entity building needs to include a group of user IDs and the entity user also needs to have a group of building IDs. In addition, the entity location with a unique ID is also created to store the GPS coordinates of buildings. It should be noted that photos also have their GPS coordinates, but these coordinates of photos are stored in the entity photo rather than the entity location. An entity building has a unique location ID, because a building corresponds to a specific location. According to the building IDs, The designed database can link all the collected data with buildings to form a structuralized dataset. 3.2 Data exchange mechanism The proposed system involves data exchange between smart phones, a web server, a web browser, a database, and cloud services, as shown in Fig. 1. The cloud service providers (e.g., Baidu map [37] and Amap [38]) have the fixed interface for data exchange with the web server. In addition, a widely-used third-party framework Primefaces of JavaServer Faces (JSF) [39] is used for communication between the web server and browsers. Therefore, the present work focuses on the data exchange mechanism between smart phones, the web server and a database. In this system, the web server is used as a data exchange hub between smart phones and database for fault-tolerant processing. Specifically, only the web server can access the database, while smart phones are not allowed to access the database directly to avoid incorrect data operation. In general, smart phones firstly upload the collected data to the web server, and then the web server will process the uploaded data (e.g., the fault-tolerance judgment and reverse address retrieval of photos). Finally, the web server will write the processed data to the database. The above process is implemented by a data exchange mechanism considering fault-tolerance, as follows: (1) A data exchange mechanism considering fault-tolerance In the designed data exchange mechanism, the fault-tolerant algorithm is only executed in the web server but do not affect the data collection work in smart phones. A pending list including the events to be confirmed is built in the web server. All of the events that involve potential conflicts due to the uploaded data of smart phones will be added to this list. Before the events are confirmed in the pending list, the corresponding data will not be written to the database, but data collection of smart phones can continue without any influence. In addition, if the networks are unavailable for smart phones, the tasks of collecting data can still be performed, but the process of uploading data will be paused. As soon as the networks are recovered, the collected data in smart phones can then be uploaded to the web server with the fault-tolerant processing. After the conflict events are confirmed in the web server, smart phones and the database will be synchronized to update the confirmed data. There are four use cases for data exchange between smart phones and a web server: creating a new building object (Case A), modifying the building data (Case B), uploading the collected files (Case C) and deleting a building object (Case D), as shown in Fig. 3.
Fig. 3. The data exchange mechanism with fault-tolerance When a new building object is established (Case A), a check is required as whether the same building object has already existed. In this system, the accuracy of distinguishing between different building locations is 5 m considering the positioning accuracy of GPS in a smart phone [40]. If the distance between the two buildings is smaller than 5 m, the buildings can be distinguished by their names in the investigation. Therefore, a double-check method using the names and locations of buildings is proposed to identify the repeated buildings. Firstly, the name of the new building is indexed to check whether there is a same name in the database. If yes, the event will be sent to the pending list for manual check. Otherwise, the locations of all the buildings are checked to identify repeated buildings. Specially, if the distances between the new building and the existed buildings are smaller than 5 m, this new building is considered to be potentially repetitive. Subsequently, this event will also be sent to the pending list in the web server and await a manual check. Finally, if a building is confirmed to be repeated by the web server, this new building object thus adopts the existed building ID. Any building data conflicts (Case B) and any repetitions of the collected files (Case C) also need to be checked, as shown in Fig. 3. If the new building is confirmed not to be repeating through the web server, the new building will be assigned to a new building ID and the related data will be written to the database. If the data of a building need to be modified (Case B), it is necessary to check data conflicts. Firstly, the building object data should be traversed to identify conflicts; secondly, the conflict events will be added to the pending list in the web server; finally, after the manual judgment through the web server, the confirmed data will be written to the database, as shown in Fig. 3. When a new file is uploaded to the web server (Case C), it is necessary to check whether the uploaded file is repeated. The message-digest algorithm 5 (MD5), a widely-used method to verify data uniqueness [41], is used to uncover the repeated files. If the uploaded file is repeated, the file will be rejected to be stored in the database and a reminder message will be sent to the smart phone, as shown in Fig. 3. When a building object needs to be removed (Case D), the deleting event will be sent to the pending list and the web server will decide whether the building should be deleted. Through this mechanism, the uncertain events will be confirmed manually in the web server, while the certain events (such as file duplication) will be processed automatically. Therefore, this mechanism can balance the caution and efficiency in the process of data exchange. (2) Implementation A method suitable for transferring large files is adopted in the proposed system to guarantee highly-efficient transfer of photos, videos and audios from smart phones to the web server. Generally, the socket mechanism [42] is a widely-used method for the communications between smart phones and a web server. Due to the weakness in transferring large files, the socket mechanism is thus not suitable for the proposed system. As an alternative, an open-source framework AsyncHttpClient [43] is used to transfer data between smart phones and the web server. In smart phones, the hypertext transfer protocol (HTTP) requests of data transfer are sent to the web server using the Get and Post method in the AsyncHttpClient [43]; in the web server, many kinds of Servlet programs for various HTTP requests are developed to accept the uploaded data from smart phones. The Servlet programs of the AsyncHttpClient are suitable for large files and easy for multi-thread transfer [43], so they can meet the requirements of uploading large files by multiple users. In addition, a widely-used Java database connectivity (JDBC) standard [44] is adopted as the communication method between the web and the database in this system. 3.3 Reverse address retrieval of photos To obtain the addresses from the collected photos, an algorithm for reverse address retrieval of photos is proposed and the corresponding computer code is also implemented, as follows: (1) The algorithm for reverse address retrieval of photos Generally, there are three steps to obtain the addresses of photos: (1) obtain the longitude and latitude coordinates of the photos; (2) send these coordinates to the interface of map servers (e.g., Baidu map [37] and Amap [38]) for requesting the addresses of photos; (3) write the returned addresses to the photo entity in the database. Although the map servers can directly provide the addresses according to the GPS coordinates, it still remains a challenging task to match the returned addresses with the photos. Note that the returning time of addresses is uncertain as it is determined by the status of the network and the map servers, so the sequencing of the returned addresses is not consistent with that of the requests, leading to potentially wrong matches between the addresses and the photos. To achieve an accurate match, a two-step strategy of retrieving the addresses of the photos is designed. The first step is to obtain the IDs of the photos from the database and send the GPS coordinates as well as the photo IDs to the map servers. The second step is to accept the returned addresses and IDs from the map servers, and write the addresses to the corresponding photo entities in the database according to their IDs. Employing the photo IDs can minimize the possibility of wrong matching caused by the uncertainties in the returning time of addresses. In addition, the reverse address retrieval of photos can be parallelized by multi-threads. Specifically, each retrieving task of a photo will be sent to the web server by a uniform resource locator (URL) request. In the web server, each request will be assigned to a thread to obtain the addresses of the photos from the map servers. Such multi-thread method can process excessive number of photos to be uploaded by many users at the same time in post-earthquake investigations. The detailed algorithm of the reverse address retrieving of photos is shown in Fig. 4. In the web server, each HTTP request will be assigned to a thread which will perform the task of uploading the photo from the smart phone. The photo will be analyzed to have its basic data (i.e. GPS coordinates, user and shoot time) extracted from the exchangeable image file (EXIF) format which is used to store the basic attributes of the photos [45]. Then the thread will check if the uploaded photo is the same as the one already existed. If so, a reminder message will be sent to the user to terminate the thread. If not, the photo will be stored by the database with a unique Photo_ID. Finally, the GPS coordinates as well as the Photo_ID will be sent to the map server to obtain the required address. According to the Photo_ID, the returned address will be added to the corresponding photo entity in the database.
Fig. 4. The algorithm of reverse address retrieval of photos (2) Implementation In the proposed system, the photos and other files are uploaded using the component FileUpload of Primefaces [39]. The class ImageMetadataReader in Java [46] is used to analyze the EXIF format of photos. In addition, the proposed algorithm of reverse address retrieval of photos involves multi-threads, the function synchronized() in Java [46] is applied before writing the database, to avoid the conflicts of threads. |
5. Conclusions A new smart phone-based system for post-earthquake investigations of building damage is proposed in this study. A virtual case study of Tsinghua campus and a practical investigation of the Tibet area are performed, leading to the following conclusions: (1) A framework consisting of smart phones, a web server, a web browser, a database and cloud services is proposed, which is highly suited for distributed collection and centralized management in post-earthquake investigations. (2) A building-oriented database is specially designed to provide a rational organization approach for the collection and storage of the investigation data. (3) A data exchange mechanism between the smart phones and the web server is established, which offers a satisfactory level of fault-tolerance for multiple use cases in an investigation. (4) An algorithm of reverse address retrieval of photos based on multi-threads is also developed to conveniently index photos by their addresses, thereby improving the practicability and efficiency of the proposed system. (5) The proposed system provides an intelligentized, efficient and networked tool for seismic damage investigation of buildings, which can assist decision-making of post-disaster recovery and reconstruction activities. Acknowledgments The authors are grateful for the financial support received from the Beijing Natural Science Foundation (No. 8173057), the National Key Technology R&D Program (No. 2015BAK14B02), and Beijing Municipal Science and Technology Project (No. Z161100001116104). References [1] S. Anagnostopoulos, M. Moretti, Post-earthquake emergency assessment of building damage, safety and usability〞Part 2: Organisation, Soil Dyn. Earthq. Eng. 28 (3) (2008) 233每244. [2] S. Platt, B.D. Drinkwater, Post-earthquake decision making in Turkey: studies of Van and İzmir, Int. J. Disast. Risk Re. 17 (2016) 220每237. [3] X.Z. Lu, L.P. Ye, Y.H. Ma, D.Y. Tang, Lessons from the collapse of typical RC frames in Xuankou School during the great Wenchuan Earthquake, Adv. Struct. Eng. 15 (1) (2012) 139每153. [4] Q.X. Meng, W.Y. Xu, Ya*an earthquake of 20 April 2013: introduction and reflections, Nat. Hazards 70 (1) (2014) 941每949. [6] K. Elwood, F. Marquis, J. Kim, Post-earthquake assessment and repairability of RC buildings: lessons from Canterbury and emerging challenges. In: Proceedings of the Tenth Pacific Conference on Earthquake Engineering Building an Earthquake-Resilient Pacific, 2015. [7] Y. Tsukimata, T. Mukai, H. Kinugasa, Damage evaluation for SRC apartment building suffered from earthquake and investigation on post earthquake functional use, Aij Journal of Technology & Design 22 (50) (2016) 105每108. [8] Applied Technology Council (ATC), ATC-20 Building Safety Evaluation Forms and Placards. 2005, USA. [9] S. Anagnostopoulos, M. Moretti, Post-earthquake emergency assessment of building damage, safety and usability〞Part 1: Technical issues, Soil Dyn. Earthq. Eng. 28 (3) (2008) 223每232. [10] Z. Xu, X.Z. Lu, L. Deng, A.Z. Ren, M.W. Xie, A system for post-earthquake investigation of building damage based on smart phones. In: The 16th International Conference on Computing in Civil and Building Engineering, 2016. [11] R.M. Stokoe, Putting people at the centre of tornado warnings: how perception analysis can cut fatalities, Int. J. Disast. Risk Re. 17 (2016) 137每153. [12] B.A. Renfro, A. Terry, N. Boeker, An Analysis of Global Positioning System (GPS) Standard Positioning System (SPS) Performance for 2016, 2017, USA. [13] NetEase, China Mobile has recovered the mobile network of earthquake disaster in Sichuan province. http://tech.163.com/08/0516/11/4C2FEBIQ00092MTQ.html, (Accessed Sep 20, 2017). (in Chinese) [14] Tecent, China Mobile guarantees the mobile network for Jiuzhaigou earthquake. http://tech.qq.com/a/20170809/023907.htm, (Accessed Sep 20, 2017). (in Chinese) [15] Wikipedia, LTE. https://en.wikipedia.org/wiki/LTE_(telecommunication)/, (Accessed Apr 13, 2016) [16] K. Yamazaki, A. Kawaguchi, R. Era, Information collecting measures during the earthquake disaster using smartphone and other Tools. In: 20th ITS World Congress, 2013. [17] H.M. Bland, J.D. Frost, Opportunities and considerations for smartphone applications and mobile social media in post extreme event reconnaissance data collection. In: Sixth Congress on Forensic Engineering, 2012. [18] F. Finazzi, A. Fasso', Earthquake monitoring using volunteer smartphone-based sensor networks. In: Joint Meeting of METMAVII and GRASPA14, 2014. [19] H. Yuze, Y. Qian, N. Suzuki, Development of smartphone application for off-line use in case of disaster. In: 27th International Conference on Advanced Information Networking and Applications Workshops. IEEE, 2013. [20] M.H. Cheng, S. Wu, T.H. Heaton, J.L. Beck, Earthquake early warning application to buildings, Eng. Struct. 60 (2) (2014) 155每164. [21] Q. Kong, Smartphone-based networks for earthquake detection. In: International Conference on Supercomputing, 2015. [22] M. Kaigo, Social media usage during disasters and social capital: Twitter and the Great East Japan earthquake, Keio Communication Review 2012 No. 34. [23] Z. Zhu, S. German, I. Brilakis, Visual retrieval of concrete crack properties for automated post-earthquake structural safety evaluation, Automat Constr. 20 (7) (2011) 874每883. [24] Q. Kong, R.M. Allen, L. Schreier, Y.W. Kwon, MyShake: a smartphone seismic network for earthquake early warning and beyond, Science Advances 2 (2) (2016) e1501055. [25] W. Shan, J. Feng, J. Chang, F. Yang, Z. Li, Collecting earthquake disaster area information using smart phone. In: International Conference on System Science and Engineering, 2012. [26] Y.R. He, D.J. Zhang, Y.H. Fang, Development of a mobile post-disaster management system using free and open source technologies. Int. J. Disast. Risk Re., (2017). DOI: 10.1016/j.ijdrr.2017.08.007. [27] Federal Emergency Management Agency (FEMA), FEMA App. https://www.fema.gov/mobile-app/, (Accessed May 5, 2015). [28] J. Reilly, S. Dashti, M. Ervasti, J. D. Bray, S.D. Glaser, A. M. Bayen, Mobile phones as seismologic sensors: Automating data extraction for the iShake system. IEEE Transactions on Automation Science and Engineering, 10 (2) (2013) 242每251. [29] K.K. Lwin, Y. Murayama, Web-based GIS system for real-time field data collection using personal mobile phone, Journal of Geographic Information System 3 (4) (2011) 382每389. [30] D. Peng, X. Zhao, Q. Zhao, Y. Yu, Smartphone based public participant emergency rescue information platform for earthquake zone - "E-Explorer", In: Proceedings of the International Conference on Vibroengineering, 2015. [31] X. Zhao, Y. Yu, Research on quick seismic damage investigation using smartphone. In: Proceedings of SPIE, 2016. [32] D. Papadias, J. Zhang, N. Mamoulis, Y. Tao, Query processing in spatial network databases. In: International Conference on Very Large Data Bases, 2003. [33] J. Black T. Ellis, D. Makris, A hierarchical database for visual surveillance applications. In: International Conference on Multimedia and Expo. IEEE, 2004. [34] C. Vicknair, M. Macias, Z. Zhao, X. Nan, Y. Chen, D. Wilkins, A comparison of a graph database and a relational database: a data provenance perspective. In: Southeast Regional Conference. ACM, 2010. [35] C. Tisell, K. Orsborn, A system for multibody analysis based on object-relational database technology, Adv. Eng. Softw. 31 (12) (2000) 971每984. [36] Oracle, MySQL. https://www.mysql.com/, (Accessed Jan 6, 2015). [37] Baidu, Develop platform of Baidu map. http://lbsyun.baidu.com/, (Accessed Feb 6, 2015). (in Chinese) [38] Amap, Develop platform of Amap. http://lbs.amap.com/, (Accessed Feb 6, 2015). (in Chinese) [39] Primefaces, PrimeFaces: ultimate UI framework for Java EE. http://primefaces.org/, (Accessed Feb 23, 2015). [38] National Coordination Office for Space-Based Positioning, Navigation, and Timing, GPS accuracy. http://www.gps.gov/systems/gps/performance/accuracy/, (Accessed Feb 23, 2016). [41] Wikipedia, MD5. https://en.wikipedia.org/wiki/MD5/, (Accessed Jan 11, 2015). [42] Javaworld, Sockets programming in Java: A tutorial. http://www.javaworld.com/article/2077322/core-java/core-java-sockets-programming-in-java-a-tutorial.html, (Accessed Jan 10, 2015). [43] Github, AsyncHttpClient. https://github.com/AsyncHttpClient/async-http-client/, (Accessed Jan 10, 2015). [44] Oracle. The Java Database Connectivity (JDBC). http://www.oracle.com/technetwork/java/javase/tech/index-jsp-136101.html, (Accessed Jan 12, 2015). [45] Wikipedia, EXIF. https://en.wikipedia.org/wiki/Exif/, (Accessed Jan 4, 2015). [46] Oracle, Java SE documentation. http://www.oracle.com/technetwork/java/javase/documentation/index.html, (Accessed Dec 12, 2014). * Corresponding author. Tel.: 86-10-62795364; E-mail address: luxz@tsinghua.edu.cn |