Structured Spatial Three-Dimensional Objects Data Modeling Extension in PostgreSQL

Spatial data plays a crucial role across diverse fields, from construction and game design to geology. To address the challenges of modeling three-dimensional geometric objects within spatial data extensions, we introduce a novel extension for PostgreSQL, referencing the functionalities of PostGIS. PostGIS extension lack the ability to identify and execute object-specific operations on structured three-dimensional shapes, limiting their practicality. In this work, a comprehensive solution that enables the accurate modeling of structured objects by defining unique type identifiers and minimal sets of information is presented. These sets encapsulate essential characteristics such as shape, location, and size. This extension encompasses measurement functions, geometric processing, and affine transformations, enabling a wide array of operations on these objects. The implementation is done using plpgsql language, focusing on the geometric functions, including calculation of vertex coordinates for various shapes, including cubes, blocks, pyramids, and prisms. Rigorous evaluation and testing validate the efficacy of this extension's approach, showcasing the precision and versatility of the extension. Through this research, an innovative solution to the challenges of spatial data modeling, enhancing the capabilities of PostgreSQL's structured geometry objects spatial data management is contributed.