Backendless Support
 

Importing geolocation data

Besides the Backendless feature to import data table schemas, relations and data objects to Backendless with CSV files it is also possible to accomplish import process with the geolocation storage. 

The process is extremely simple.

A developer should browse to a CSV file with the geolocation data and let Backendless process it. An imported file may include as many geopoints as you need. For each geopoint a developer can provide the latitude and longitude coordinates, the categories the data point should belong to and the geopoint metadata. 

Consider the following example of a geolocation CSV file:

Sample Geodata 

LATITUDELONGITUDECATEGORY NAME                                                         METADATA
29.76328-95.36327personalscity=Houston|burgers=true|hiking=false|chinese=true|gender=male
33.15067-96.82361personalscity=Frisco|burgers=false|hiking=false|chinese=true|gender=female
32.73569-97.10807personalscity=Arlington|burgers=false|hiking=false|chinese=false|gender=female
33.01984-96.69889personalscity=Plano|burgers=false|hiking=true|chinese=false|gender=male
32.78306-96.80667personalscity=Dallas|burgers=true|hiking=true|chinese=false|gender=female

Geolocation CSV files must follow the following structure:

  • latitude column
  • longitude column
  • category names. The entire string must enclosed into double quotes. Category names must separated by commas.
  • metadata in the key=value format. Multiple key/value pairs must be separated with the pipe character - |

To import geolocation data a developer has to follow the next steps:

  1. Login to Backendless console, select an app and click the Manage icon.
  2. Click the Import menu.
  3. Click the add file button for the Geo Service section.
  4. Browse and open a CSV file with the geolocation data

Once Backendless completes the import of the data, it sends an email to the application developer email address with a status report about the import procedure. If all the data is successfully processed, you can see it in the Geolocation screen of Backendless console. 

For example, the data from the table shown above is rendered as: 

Review related topis:

Is article helpful?