|
I'm using a lat/long SRID in my PostGIS database (-4326). I would like to find the nearest points to a given point in an efficient manner. I tried doing an
ORDER BY ST_Distance(point, ST_GeomFromText(?,-4326))
which gives me ok results in the lower 48...
Started by Paul Tomblin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
This is from SQL Server, and I use Haversine for a ridiculously fast distance that may suffer) ) returns decimal(16,12) as /* fUNCTION: getCoordinateDistance Computes the Great Circle distance in kilometers between two points on the Earth....
|
|
Q: My Long Distance For 252-438-8057 Will Not Work. My Unlimited Long Distance was cancelled but my long distance service wasn't. was it cancelled in error.
Started by cwatkins3280 on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at helpowl):
|
|
Given a coordinate (lat, long), I am trying to calculate a square bounding box that is a given distance (e.g. 50km) away from the coordinate. So as input I have lat, long and distance and as output I would like two coordinates; one being the south-west...
Started by Bryce Thomas on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
It's not actually a "square" (whatever that means on the ... .
Now env contains your envelope.
For distances()); env.expandBy(distance_in_degrees); ...
A square bounding box for a distance from a point? Sounds more like a circle to me.
|
Ask your Facebook Friends
|
I have a database of geocoded entries. I need to determine which two entries are the furthest apart from a subset of the total entries. For example, I select a list of 10 entries then, from that list, determine which two places represent the greatest ...
Started by Don on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Here is....
Now you can tiles.
Store this in the database.
Obvious optimization: break the great circle distance between the centers of of each pairing.
To calculate distance from the center from step (1)
Pick greatest two distances.
|
|
My small business is just about to start a program of work. The 2 of us have been in the same industry for many years and believe we have come up with a simple solution to a VERY common problem. We will know we have succeeded when it becomes a no-brainer...
Started by anthon on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
I end up seeing my clients in person once.
I guess you could call that "short-distance development".
|
|
Am I a sprinter, long distance, or mid distance runner? 100m: 16.0
200m: 36.34
400m: 1:18
1 mile: 9:36
15 year old girl xD
Started by Sun on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at yahoo):
You should try running the 800m Hiya there, it seems like you are more ... .
Long distance runners train I am thinking you might be more of a mid distance runner.
Periods of time and then go sit in the shade and talk to their friends .
|
|
We all know how painful dating long distance can be.
Started by miri on
, 15 posts
by 12 people.
Answer Snippets (Read the full thread at tarflies):
Whatever happened to the "must know each other for at least three years" requirement? Has it turned into "must have been signed with your agent for at least three years"? Well, I think he's hot (aside from having no discernable lips in the official photo... .
|
|
I am writing a program in C. I want to find a solution by minimizing expression
D1+D2+ +Dn
where Di's are distances calculated by distance formula between 2 points. The above expression is in x & y variables
Now I will differentiate this expression and...
Started by nowonder on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
At least one long distance, you've a good chance that the sum of squares has a different minimum that the squares overpenalize long distances; if you construct an example with a minimum containing are unrelated , then for ....
|
|
I've recapped a few devices now, mostly preventative, though now I'm wondering if I can possibly get help with a TV that I have in our holiday apartment that went faulty the last time we were out there.
It exhibits classic bad caps syndrome, a cheap (...
Started by btb88 on
, 16 posts
by 4 people.
Answer Snippets (Read the full thread at badcaps):
I'll have a look and see if I can ... .
I suspect its not a currently for sale model.
Is it this one?
http://skinflint.co.uk/eu/661177
http://skinflint.co.uk/eu/661162 Thanks for your reply, no it isn't that one, and I couldn't find it listed on that site .
|
|
I am looking for a private one-n-one shooting instructor for long distance shooting does anyone know of one in the LA.Calif area.
Started by Bravo25 on
, 14 posts
by 12 people.
Answer Snippets (Read the full thread at calguns):
They and all the good folks it.
|
