I try to import a route from a gps track using the geofences api, but get this error
Value too long for column "AREA VARCHAR(4096) NOT NULL": "'LINESTRING (56.50431550 8.309912680, 56.50450500 8.317766180, 56.50694430 8.318281170, 56.50798630 8.323087690, 56.50703910 8.3... (5036)"; SQL statement:
INSERT INTO geofences (description, name, calendarId, attributes, area) VALUES (?, ?, ?, ?, ?) [22001-196] - JdbcSQLException (... < QueryBuilder:477 < DataManager:448 < BaseObjectManager:87 < ...)
Could I just increase this field in the database, can I join more areas, or do I need to prune points from the track?
You can increase field size, but if reducing track size would be better in terms of performance, if that's an option.
I put the track into https://www.gpsies.com with high simplification, and set reduction to 150 points. The track looks fine now.
I try to import a route from a gps track using the geofences api, but get this error
Could I just increase this field in the database, can I join more areas, or do I need to prune points from the track?