Jasen Betts wrote:
> On 2010-05-22, Mike Ellsworth <younicycle(at)gmail(dot)com> wrote:
>> If you don't want to work with postgis, I think you could just use a bit of sqrt
>> using double precision - for a circle anyway.
>> I did something similar for a simple target archery scoring example I
>> set up awhile ago.
>> Many of the other links off this page require login/privileges - but I
>> believe this specific page works.
>> round(GREATEST(10.5 - sqrt((("xyarchery"."xx" - 200) ^ 2) +
>> (("xyarchery"."yy" - 200) ^ 2)) / 20, 0))
>> where pixels are being recorded & scored.
> you can't apply pythagoras's theorem to latt0tude,longitude
> coordinates and get a useful result unless the points are near the
> By far the easiest solution is to us a package, like postgis, that was
> prepared by persons who know what they are doing.
> the same goes time arithmetic, where leap-years are just one of the
Thanks Sean Mike & Jasen.
Installing PostGIS is not possible at this time.
I just found this page:
which mentions Pythagorean formula has an error of at least 30m for
distance of 20km in my area; this is close enough for my purposes.
If/when more accuracy is needed, I'll look into PostGIS.
In response to
pgsql-novice by date
|Next:||From: Nathaniel Trellice||Date: 2010-05-22 11:45:31|
|Subject: Re: GPS positions|
|Previous:||From: Jasen Betts||Date: 2010-05-22 10:00:52|
|Subject: Re: Transferring Data between databases|