search

amillb / pgMapMatch

map-matching of GPS traces
MIT License
77 stars 20 forks source link

geom column of postgresql gps trace table #13

Closed AngeloValenzuela closed 4 years ago

AngeloValenzuela commented 4 years ago

when i try to use the pgMapMatch in pg mode, the geom of the route is a linestring, and it raises the exception:

Raise Exception('GPS trace geometry column %s must be LineString with M coordinate' % geomName) Exception: GPS trace geometry column geom must be LineString with M coordinate

how can i convert the geom to linestringM and what is the M coordinate.

AngeloValenzuela commented 4 years ago

i succesfully created a linestringM with the gps points and M as the timestamp. but now the code raises the following exception: psycopg2.errors.UndefinedColumn: column does not exist «none» LINE 3: ... FROM sf_streets, (SELECT ST_DumpPoints(None) AS d...

amillb commented 4 years ago

The M coordinate is the timestamp, which is essential for the matching to work. Most GPS exporters will create this automatically.

amillb commented 4 years ago

I can try and help but would need more information about the column names in your trace table and how you are calling pgmapmatch.

amillb commented 4 years ago

Feel free to reopen this issue if you still need help.