<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Dear all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">recently, I finished a study on clustering building blocks and combining blocks to city districts of similar urban morphology.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">After importing a CityGML data set to a PostgreSQL/PostGIS database via 3DCity-Importer-Exporter (<a href="https://github.com/3dcitydb">https://github.com/3dcitydb</a>) 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
<i>DBI</i>, <i>RPostgres</i> and <i>RPostgreSQL</i>) and r packages for spatial analysis (packages
<i>sf</i>, <i>sp</i>, <i>foot</i>, <i>lwgeom) </i>and non-spatial data analysis (<i>stats</i>,
<i>cluster</i>, <i>fcp</i>, <i>klaR</i>)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">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.<br>
PostGIS itself has at least a basic function for 3d area calculation: <a href="https://postgis.net/docs/ST_3DArea.html">
https://postgis.net/docs/ST_3DArea.html</a>. Commercial software like FME from SAFE is allowing for CityGML reading, writing and analysis. ESRI delivers (commercial) possibilities for 3D data analyses as well.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">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?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Any feedback is appreciated. <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Many thanks in advance an best regards<br>
André<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">***********************************************</span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">André Müller</span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE"> </span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">IWU - Institut Wohnen und Umwelt GmbH</span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">Rheinstraße 65</span><span lang="EN-US" style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">64295 Darmstadt</span><span lang="EN-US" style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE"> </span><span lang="EN-US" style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">Institute for Housing and Environment -</span><span lang="EN-US" style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">Research institution of the State of Hesse and the City of Darmstadt</span><span lang="EN-US" style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE"> </span><span lang="EN-US" style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">Telefon: +49 6151 2904-18</span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">E-Mail: </span><span style="color:#212121;mso-fareast-language:DE"><a href="mailto:a.mueller@iwu.de" target="_blank"><span style="font-size:9.0pt;color:blue">a.mueller@iwu.de</span></a></span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">Internet: </span><span style="color:#212121;mso-fareast-language:DE"><a href="http://www.iwu.de/" target="_blank"><span style="font-size:9.0pt;color:blue">www.iwu.de</span></a></span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE"> </span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">Registergericht Darmstadt HRB 1649</span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">Geschäftsführerin: Dr. Monika Meyer</span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">***********************************************</span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE"><a href="https://www.iwu.de/forschung/energie/e4q/"><span lang="DE" style="color:blue">EG2050:E4Q</span></a></span><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">
– Einbindung erneuerbarer Energieträger in <br>
die Energieversorgung vernetzter Quartiere (Projektseite)<br>
</span><i><span style="font-size:9.0pt;color:blue;mso-fareast-language:DE"><a href="https://www.iwu.de/fileadmin/publikationen/energie/2022_IWU-TUD_MuellerEtKoert_E4Q-Ergebnisbroschuere.pdf"><span style="color:blue">Ergebnisbroschüre E<sup>4</sup>Q</span></a></span></i><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:4.0pt;color:#1F497D;mso-fareast-language:DE"><br>
</span><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">Mein Profil auf
</span><span lang="EN-US" style="font-size:9.0pt;color:blue;mso-fareast-language:DE"><a href="https://www.researchgate.net/profile/Andre-Mueller-4"><span lang="DE" style="color:blue">researchgate.net</span></a></span><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:4.0pt;color:#1F497D;mso-fareast-language:DE"><br>
</span><span lang="EN-US" style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE"><a href="https://www.iwu.de/aktuell/newsletter/"><span lang="DE" style="color:blue">IWU-Newsletter Energie</span></a></span><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1F497D;mso-fareast-language:DE">***********************************************</span><span style="font-size:11.5pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE"><img border="0" width="206" height="69" style="width:2.15in;height:.7166in" id="Bild_x0020_1" src="cid:image001.png@01D988DB.683B6A80" alt="cid:image001.png@01D91392.362026D0"></span><span style="mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>