Can't find geoencoding

[Deepankar01]

I tried searching for geo-location in mongify but it isn't there
i have two different columns as LAT and LONG

table "tbb_buddy_group" do
column "buddyGroupId", :integer
column "userId", :integer
column "LAT", :float
column "LNG", :float
column "groupId", :integer
column "floating_LAT", :float
column "floating_LNG", :float
end
how can i do geo-location using mongify ?

[anlek]

Wow, that's a great point, there isn't any geo-location setup, you might be able to do it via a before_save method.

[Deepankar01]

before_Save do |row|
row.LAT = Array[row.LAT,row.LNG]
end

is this the right way ?
all i want is to merge LAT LNG in a single array

[anlek]

You might want to remove the original values from the record

before_save do |row|
  row.location = Array(row.delete(:LAT), row.delete(:LNG))
end

The value will be stored in your db under location

[Deepankar01]

thanks for the update yesterday i did thanks for the delete row.delete
before_save do |row|
row.loc = Array[row.LAT,row.LNG]
end

[anlek]

Did it work out for you? If so, I can try adding it to the docs.

[Deepankar01]

Yes yes I worked perfectly and please do add it in the docs
As it will be really helpful

Thanks 😊

[IsamAljawarneh]

hi everybody,
i need this also, the information provided here was helpful.
i will test this with my database and provide you with feedback.