[Mobilitydb-users] Loading Moving Feature JSON to Mobility DB?

[Esteban Zimanyi]

Dear Andrew

As part of our CI tests we do the following kind of queries to ensure that
the input/output for MFJSON works correctly.

--------------------------------------------------------------
test=# SELECT COUNT(*) FROM tbl_tgeompoint WHERE asEWKT(temp) !=
asEWKT(tgeompointFromMFJSON(asMFJSON(temp)));
 count
-------
     0
(1 row)


test=# SELECT COUNT(*) FROM tbl_tgeompoint3D WHERE asEWKT(temp) !=
asEWKT(tgeompointFromMFJSON(asMFJSON(temp)));
 count
-------
     0
(1 row)

test=# SELECT COUNT(*) FROM tbl_tgeogpoint WHERE asEWKT(temp) !=
asEWKT(tgeompointFromMFJSON(asMFJSON(temp)));
 count
-------
     0
(1 row)

test=# SELECT COUNT(*) FROM tbl_tgeogpoint3D WHERE asEWKT(temp) !=
asEWKT(tgeompointFromMFJSON(asMFJSON(temp)));
 count
-------
     0
(1 row)
--------------------------------------------------------------

Therefore you should be able to able to input and output in MFJSON format.

Please let us know if you find any issues on this.

Esteban

On Fri, Apr 11, 2025 at 6:12 PM Andrew Koure via Mobilitydb-users <
mobilitydb-users at lists.osgeo.org> wrote:
>
> Hello All,
> I have a program that is generating moving feature JSON, and I am looking
to load the JSON into MobilityDB.
>
> Does anyone have guidance on how best to do this? I've tried looking
through the documentation for MovingPandas, MobilityDB, and MEOS. Most of
what I have found so far is for writing out to MFJSON.
>
> Thanks in Advance,
> Andrew
> _______________________________________________
> Mobilitydb-users mailing list
> Mobilitydb-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mobilitydb-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20250411/dcd54074/attachment.htm>