Timeline for Fetch rows which belongs to a certain geo location
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Aug 21, 2017 at 15:34 | history | suggested | Jefferson | CC BY-SA 3.0 |
improved formatting
|
| Aug 21, 2017 at 15:10 | review | Suggested edits | |||
| S Aug 21, 2017 at 15:34 | |||||
| Aug 20, 2017 at 20:37 | comment | added | Evan Carroll |
@TheAlpha both, however if you take it one step further and (1) store them as a point, (2) store the ST_Buffer(pt, radius) as a geom, and index the geom then the operation on MBRContains will use the index, potentially saving costly calculations with ST_Contains
|
|
| Aug 20, 2017 at 19:03 | comment | added | The Alpha | Thanks for your answer but I'm still confused. If I change the lat, lng to point and instead of storing radius as km, if I store the distance in degrees then which query should I use? | |
| Aug 20, 2017 at 18:54 | history | answered | Evan Carroll | CC BY-SA 3.0 |