[Mobilitydb-users] CREATING AIRCRAFT TRAJECTORIES

[FAQIR HUSSAIN]

Dear Recipient!

I hope that you will be fine and doing your life well.

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.

The dataset contains the following fields:
date_time_stamp, latitude, longitude, altitude, speed, direction

I have generated Geom field from latitude and longitude using the following query:
select ST_SetSRID(ST_MakePoint(long,lat), 4326) geom FROM flight_details
WHERE flight_date='2022-03-07' AND call_sign='PIA300'
order by call_sign, date_time_stamp asc;

The Geom field is generated successfully, and we can see it on Geometry map (This is shown in the screenshot attached).


I am, unable to use altitude, speed and direction fields available in the dataset. I want to use them to generate the same view as is presented on Google Earth.



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.


With regards,
Faqir Hussain
MS (RS & GIS)
IGIS-SCEE-NUST
Islamabad, Pakistan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20220409/1aafba72/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot.png
Type: image/png
Size: 132302 bytes
Desc: Screenshot.png
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20220409/1aafba72/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Flight Details - MobilityDB.csv
Type: text/csv
Size: 19261 bytes
Desc: Flight Details - MobilityDB.csv
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20220409/1aafba72/attachment-0001.csv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PK300-2b393616.kml
Type: application/vnd.google-earth.kml+xml
Size: 501960 bytes
Desc: PK300-2b393616.kml
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20220409/1aafba72/attachment-0001.kml>