<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
Dear Recipient!<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
I hope that you will be fine and doing your life well.<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
As I mentioned in my previous mail, I am doing my MS thesis on MobilityDB. For this purpose, I am using flight details to show / present it using MobilityDB features. The dataset has been enclosed (.csv file), at the same time we can see the KMZ/KML file on
Google Earth.<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
The dataset contains the following fields:<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
<b><i>date_time_stamp, latitude, longitude, altitude, speed, direction</i> <o:p> </o:p></b></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif">
I have generated Geom field from latitude and longitude using the following query:<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="font-size:10.0pt;font-family:"Source Code Pro"">select ST_SetSRID(ST_MakePoint(long,lat), 4326) geom FROM flight_details
<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="font-size:10.0pt;font-family:"Source Code Pro"">WHERE flight_date='2022-03-07' AND call_sign='PIA300'<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="font-size:10.0pt;font-family:"Source Code Pro"">order by call_sign, date_time_stamp asc;<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="font-size:10.0pt;font-family:"Source Code Pro""><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi">The Geom field is generated successfully, and we can see it on
<i>Geometry map (This is shown in the screenshot attached)</i>.<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi">I am, unable to use
<b><i>altitude</i></b>, <b><i>speed</i></b> and <b><i>direction</i></b> fields available in the dataset. I want to use them to generate the same view as is presented on Google Earth.<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi">What functions / features are to be used to get the required results.
Probably some third-party tool, if required. It is requested to please guide me in this regard.<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi">With regards,<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi">Faqir Hussain<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi">MS (RS & GIS)<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;font-family:Arial, sans-serif;margin-bottom:0in">
<span style="mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-bidi;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-bidi;mso-bidi-font-family:Arial;mso-bidi-theme-font:minor-bidi">IGIS-SCEE-NUST<o:p> </o:p></span></p>
<span style="font-size:12.0pt;line-height:107%;font-family:"Arial",sans-serif;mso-ascii-theme-font:minor-bidi;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-bidi;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA">Islamabad,
Pakistan</span><br>
</div>
</body>
</html>