[R-sig-Geo] Handling 3D geospatial (building) data in R

[André Müller]

Dear all,

recently, I finished a study on clustering building blocks and combining blocks to city districts of similar urban morphology.
The basis was 3D CityGML building data and additional 2d cadastral data from Germany and the application of unsupervised (and supervised) machine learning algorithms to this GIS data.
After importing a CityGML data set to a PostgreSQL/PostGIS database via 3DCity-Importer-Exporter (https://github.com/3dcitydb) and pre-processing it, the dataset consisted of 2D building footprint polygons and additional variables, e.g. the building height and the type a the roof. Some data processing was done directly in PostGIS, but the major part using R/PostGIS database connections (packages DBI, RPostgres and RPostgreSQL) and r packages for spatial analysis (packages sf, sp, foot, lwgeom) and non-spatial data analysis (stats, cluster, fcp, klaR)


However, at the moment I am looking for a possibility to derive some additional information from the 3D representations of the buildings by analyzing the surfaces (polygons or multipolygons) and solids.
PostGIS itself has at least a basic function for 3d area calculation: https://postgis.net/docs/ST_3DArea.html. Commercial software like FME from SAFE is allowing for CityGML reading, writing and analysis. ESRI delivers (commercial) possibilities for 3D data analyses as well.
Do you know packages which can handle 3D geospatial data in R or do you have any other suggestions on free / open source solutions which easily can be integrated into an R based data analysis?


Any feedback is appreciated.
Many thanks in advance an best regards
André

***********************************************
André Müller

IWU - Institut Wohnen und Umwelt GmbH
Rheinstraße 65
64295 Darmstadt

Institute for Housing and Environment -
Research institution of the State of Hesse and the City of Darmstadt

Telefon: +49 6151 2904-18
E-Mail: a.mueller using iwu.de<mailto:a.mueller using iwu.de>
Internet: www.iwu.de<http://www.iwu.de/>

Registergericht Darmstadt HRB 1649
Geschäftsführerin: Dr. Monika Meyer
***********************************************
EG2050:E4Q<https://www.iwu.de/forschung/energie/e4q/> - Einbindung erneuerbarer Energieträger in
die Energieversorgung vernetzter Quartiere (Projektseite)
Ergebnisbroschüre E4Q<https://www.iwu.de/fileadmin/publikationen/energie/2022_IWU-TUD_MuellerEtKoert_E4Q-Ergebnisbroschuere.pdf>

Mein Profil auf researchgate.net<https://www.researchgate.net/profile/Andre-Mueller-4>

IWU-Newsletter Energie<https://www.iwu.de/aktuell/newsletter/>
***********************************************
[cid:image001.png using 01D91392.362026D0]


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://stat.ethz.ch/pipermail/r-sig-geo/attachments/20230517/d90138b0/attachment.html>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 6124 bytes
Desc: image001.png
URL: <https://stat.ethz.ch/pipermail/r-sig-geo/attachments/20230517/d90138b0/attachment.png>