|
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....
|
|
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.
|
|
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.
|
Ask your Facebook Friends
|
Long distance relationships - yes or no? So, do you think long distance relationships work?
I am currently in one, so I say yes.
Started by Outcast on
, 15 posts
by 15 people.
Answer Snippets (Read the full thread at bulbagarden):
Re: Long....
No longer around.
Too bad there isn't a choice for that =/ Re: Long distance relationships - yes.
Re: Long distance relationships - yes or no? I didn't vote because it really depends how much you love the person.
|
|
I'm just curious if there are any long distance relationships that actually work out and if not for how long did it last for?
Started by b>stingerxx on
, 88 posts
by 76 people.
Answer Snippets (Read the full thread at angelsword):
About two months ago, my crazy long distance, i dont think i really....
My only long distance relationship lasted only 5 months because the person ended up moving here later he's here and now we're happily married <3 Pheww..
|
|
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".
|
|
My 91 year old mother received a third party letter from the above beginning "This letter is being sent to inform you of charges that were sent back to U.S. Telecom Long Distance Inc., by your local carrier. These are charges that you contacted your local...
Started by kimberbl on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at complaintsboard):
Usa phone before the letter....
Beware who you are dealing with.
Geared towards the elderly Telecom in scams involving false bills for long distance service...
Telecom Long Distance, Inc.
In doing research on a scam involving U.S.
|
|
Pros & cons of long distance relationship??
Started by mexistaniX on
, 20 posts
by 15 people.
Answer Snippets (Read the full thread at sythe):
The relationship, but after going through it I honestly believe that long distance relationships can, but after going through it I honestly believe that long distance relationships can never truly as long-distance....
|
|
What is your favorite?
Long-distance trails in the United States
Started by ocguy77 on
, 15 posts
by 13 people.
Answer Snippets (Read the full thread at backpacker):
Many beautiful things, but....
H ! H along its long course.
(Lamebeaver @ Dec.
I kinda like hiking your mom....she knows how to go the distance.
|
|
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 ....
|
