search

MobilityDB / MobilityDB-python

Python driver for MobilityDB
11 stars 7 forks source link

to_sql? #9

Closed apiszcz closed 1 year ago

apiszcz commented 2 years ago

The Pandas GeoDataframe supports to_sql. Is there an equivalent capability to insert tgeompoint trajectories with the time stamp? My first review of mobilitydb-python and movingpandas did not locate a capabilty. movingpandas to_traj_gdf creates a standard geometry for the line string and not a tgeompoint Point(x,y)@timestamp element. The mobilitydb-python capability does not appear to offer a pandas like capability. Current though I'll need to create the tgeompoint string EWKT and insert each row into the postgres/mobilitydb table. Thank you for any advice.

Diviloper commented 1 year ago

I'm closing this issue due to the deprecation of the package in favor of the new PyMEOS package, which provides a similar collection of classes, but using the MEOS library under the hood. Although I'm not sure what was the issue here, the new package provides a to_dataframe method for temporal points, which may be what you were looking for.