simple latitude/longitude conversion to text file format for geofencing
Budget: $10 – $30 USD
Looking for someone to write a simple script to so a excell file list of lat/long coordinates can be converted into a simple text file with the following format.
The TT geofence file is a simple text file that has following structure.
Example
{"groups":[],"geofences":[{"id":1125,"group_id":0,"name":"Murphy Base Scarborough","coordinates":"[{\"lat\":54.268206589114,\"lng\":-0.42293071746826},{\"lat\":54.266646437214,\"lng\":-0.42325258255005},{\"lat\":54.266602576669,\"lng\":-0.41687965393066},{\"lat\":54.268288041206,\"lng\":-0.41655778884888},{\"lat\":54.268707830203,\"lng\":-0.41895031929016},{\"lat\":54.26869529925,\"lng\":-0.42150378227234}]","polygon_color":"#955a99","type":"polygon","radius":null,"center":null,"device_id":null}]}Format:
"groups" - name of the geofence group. Emtpy [ ] means ungrouped.
"geofences" - list of geofences. Inside it requires "id", "group_id", "name" and "coordinates" to be contained within the geofence. "Coordinates" requires a list of "lat" and "lng" of coordinates of the geofence area.
"polygon_color" - color in html hex code.
The TT geofence file is a simple text file that has following structure.
Example
{"groups":[],"geofences":[{"id":1125,"group_id":0,"name":"Murphy Base Scarborough","coordinates":"[{\"lat\":54.268206589114,\"lng\":-0.42293071746826},{\"lat\":54.266646437214,\"lng\":-0.42325258255005},{\"lat\":54.266602576669,\"lng\":-0.41687965393066},{\"lat\":54.268288041206,\"lng\":-0.41655778884888},{\"lat\":54.268707830203,\"lng\":-0.41895031929016},{\"lat\":54.26869529925,\"lng\":-0.42150378227234}]","polygon_color":"#955a99","type":"polygon","radius":null,"center":null,"device_id":null}]}Format:
"groups" - name of the geofence group. Emtpy [ ] means ungrouped.
"geofences" - list of geofences. Inside it requires "id", "group_id", "name" and "coordinates" to be contained within the geofence. "Coordinates" requires a list of "lat" and "lng" of coordinates of the geofence area.
"polygon_color" - color in html hex code.