Open gregmalcolm opened 8 years ago
This one will be a little trickier than the other search requests. It would use the coordinate data in the Systems model. Not entirely sure how to do that in an sql friendly kind of way. John Rutherford left us some notes on sphere searches:
https://github.com/gregmalcolm/ed-materializer/wiki/Notes:--Distance-Calculations-(via-John-Rutherford)
... but we could probably get away with doing something as simple as checking if the X/Z coordinates are in a certain freshhold for the first pass.
I'm thinking the basis for the search would be along the lines of "Give me systems X ly from System Y".
So the search string would probably be:
"from:Beagle Point dist:500"
This one will be a little trickier than the other search requests. It would use the coordinate data in the Systems model. Not entirely sure how to do that in an sql friendly kind of way. John Rutherford left us some notes on sphere searches:
https://github.com/gregmalcolm/ed-materializer/wiki/Notes:--Distance-Calculations-(via-John-Rutherford)
... but we could probably get away with doing something as simple as checking if the X/Z coordinates are in a certain freshhold for the first pass.
I'm thinking the basis for the search would be along the lines of "Give me systems X ly from System Y".
So the search string would probably be:
"from:Beagle Point dist:500"