Error while importing geofence data from WKT file

Vajihks Morotell3 years ago

Hi Anton,

I hope you are doing good !!
I am importing data using WKT file of my city but, it is giving this error.

Data truncation: Data too long for column 'area' at row 1 - MysqlDataTruncation (... < QueryBuilder: 446 < DataManager: 425 < BaseObjectManager: 123 < ...)

Can I change the data type of area column directly into the database to resolve this issue?
Will it cause any issue whenever we upgrade the server to the latest version?

Anton Tananaev3 years ago

You can change the column and it shouldn't cause any issues, other than performance issues related to handling large geofences.

Vajihks Morotell3 years ago

Thanks Anton,

My objective is to create city and state geofence for the entire globe. This will enable to filter devices by geofence

Klaas Strikwerda3 years ago

Not sure if this is the right direction of you problem, but when i tried to add Geofences manually, i experienced that the number of points (coördinates) for one geofence is limited in lenght, for example 256 characters, not sure about the actual number.
May be try first a simple one for test.