Integrated modeling of utility networks in the urban environment

In recent years, there has been an exponential growth in the need for 3D spatial information, particularly 3D models representing the geographic information of the urban environment. The existence of a comprehensive integrated 3D model representing the condition of the underground utility networks in accordance with the above-ground city objects...

CityJSON in combination with MongoDB, PostgreSQL and GraphQL

CityJSON is a JSON-based encoding for a subset of the CityGML data model and an alternative to the CityGML exchange-format. This new encoding reduces the data size and simplifies the usage. These files can be stored in relational and NoSQL databases. Relational and NoSQL databases have integrated JSON. CityJSON has therefore the potential to be...

Using Foreign Data Wrapper in PostgreSQL to Expose Point Clouds on File System

This research is aimed to answer the main research question: to what extent we can use LiDAR point clouds directly in the PostgreSQL by means of FDW, and thus a FDW supporting the Point Cloud Data Management System is implemented. Then, the range and performance of its functionality are evaluated. The results shows this FDW solution is feasible...

A 3D data modeling approach for integrated management of below and above ground utility network features

Precise and comprehensive knowledge about 3D urban space, critical infrastructures, and below ground features is required for simulation and analysis in the fields of urban and environmental planning, city administration and disaster management. In order to facilitate these applications, geo-information about functional, semantic, and...

Storing Massive TINs in a DBMS: A comparison and a prototype implementation of the multistar approach

Solutions have been introduced to handle massive point clouds in Database Management Systems (DBMS), namely by Oracle in 2011 and postgreSQL in 2013. Many common operations on these massive point clouds require knowledge about the original surface in order to analyse them. A possible method to recreate a representation of the original surface is...

Zoekfunctionaliteit StamboomNederland

In opdracht van het bedrijf 42 is er een nieuwe zoekfunctionaliteit ontwikkelt voor het systeem StamboomNederland, dit systeem is in opdracht van het Centraal Bureau voor Genealogie (CBG) ontwikkelt door 42. Het systeem bevat genealogische data voor het bijhouden van stambomen. De huidige zoekfunctionaliteit werkt echter niet naar behoren...

NoSQL spatial: Neo4j versus PostGIS

The relational data model is now more than 40 years old. It's good for very diferent scenarios and can handle certain types of data very well. But it isn't perfect. An increasing number of non-relational systems are being worked on, collectively called the 'NoSQL movement'. NoSQL is an umbrella term for a loosely defined class of non-relational...