really it is a great article, i was looking for like.
But i have one problem with my table and i was stuck in spatial query for it.
description of my table is like this
field – type
—————-
id – int (10)
property – geometry
in property field we stored latitude and longitudes as POINT type. (select astext(property) from mytable; will return POINT(12.000 77.0000))
how to apply haversine formula as you mentioned on mytable?
do i need to extract lat lon values first and apply your query after? (i tried select X(coordinates),Y(coordinates) from mytable; but ended up with unknown column coordinates error) or is there any direct way to apply haversine formula on mytable?
thank you
Hey, did you found any answers about this? I have a similar problem http://laravel.io/forum/09-16-2015-select-raw-inside-eager-load-constraints-relationship-problem
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community