{'fraction_non_alphanumeric': 0.025870646766169153, 'fraction_numerical': 0.0, 'mean_word_length': 5.367088607594937, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Real-time and Secure Geospatial Data Warehouse for Intelligent Transportation Systems

Location data is crucial in intelligent transportation systems (ITS) as evidenced in Transport for London, Belgium’s STIB, and NEXTBUS in the United States. In order to provide real-time information on public buses, trams, and trains to citizens, databases and data warehouses were adapted to source and deliver traffic data in many end-to-end systems. In contrast, open systems were rarely studied and implemented for their security risks and proprietary dependencies. In this paper, we propose a real-time, secure data warehouse paired with specific application programming interfaces (APIs) to facilitate movement of data and demonstrate an open ecosystem for third-party developers to produce intelligent mobility solutions such as a public vehicle tracker and a time-of-arrival estimator. The resulting design and implementation show how simple APIs can be the foundation for an open ecosystem in ITS development.