Geo Point Relationship is missing

General
1

Hello

I am not seeing Geo Point relationship with another table.
Geo Point Relationship is missing at my backendless.
I just want to make relationship GPS fields in two different tables.

image
image693×577 26.2 KB

Please help

2

Hello, @FMS_APP.

I didn’t really understand your question. But if you want to create a relation to a table that contains a geolocation, then you need to do the following steps:

  1. Create a new table, for example “Locations”.
  2. Create a column with geodata in this table, I created a column with the POINT data type, which is called ‘whereIs’.
  3. Then you need to create an object in this table.
  4. After that, in my Person table, I added a new column which will be the “relation object”, I called it “locate” (Data Object Relationship data type).
  5. Then in this column, I clicked on this column and selected the object to which this relay will refer.

Below are screenshots of how to do this:

image
image1186×922 45 KB

image
image860×380 22.9 KB

image
image1772×1042 42.4 KB

Best Regards, Nikita.

3

Hi Nikita

My project has requirement to visualize both CSGPS and SNGPS on same map.
SNGPS is in another table, so I have made relation to that table with LinktoSN field. When I add relation to data, it only return object id, actually I want to get SNGPS field value. How can I get SNGPS value from relation? I also try to relate one to one with SNGPS field ,but no POINT type data fields are not appear in identification column.

Let me share some screenshot for your understanding.

image
image675×828 36.3 KB

image
image1011×727 35.5 KB

image
image1821×637 90.5 KB

4

I talked to my colleagues, and here is what we can advise you.
Spatial Data type columns cannot be identifiers in data relational columns. Therefore, I can advise you to create an App View by selecting a table with a relation as a parent table. So you will be able to add all the necessary columns from the child table to the App View. In the same place you can add a column of type Point. Here you can read more about APP Views - Introducing Backendless Database View Designer | Backendless.

Best Regards, Nikita.

5

Hi Nikita

I created view. Still Point Column is shown in Jason format only, not WKT or Visualize map in there.

image
image1794×571 39.7 KB

Client App View also cannot display Geo Point data.

image
image1909×413 9.48 KB

Best regards,
Nyi Nyi Lin

6

We are aware of this issue(BKNDLSS-24583).
Unfortunately, this is not the top priority. So we can not give a clear timeline for its decision.

To get around this problem, you can draw on your own instead of using a table.

Best Regards, Nikita.