{'fraction_non_alphanumeric': 0.02541544477028348, 'fraction_numerical': 0.0, 'mean_word_length': 5.4, '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}}
Modeling and Querying Spatial Networks in Databases

Infrastructures like transportation, power, and pipeline networks which are characterized by a spatial embedding are known as spatial networks. Spatial networks are ubiquitous in our everyday life and used in transport, navigation, and city planning as well as in Geographical Information Systems (GIS) and other geo-spatial applications. The largely increasing amount of generated data about spatial networks can only be efficiently stored and analyzed in a database system. However database support for large spatial networks in order to represent, store, query, and manipulate them is rare. This article aims to provide a conceptual, abstract, and formal model of spatial networks, called Spatial Network Algebra (SNA). It includes data types, operations, and predicates and serves as a specification for their later implementation in spatial database systems and GIS. Finally, we show how our spatial network concepts can be embedded into an SQL-like query language.