[postgis-users] Spheroid Question
woodbri at swoodbridge.com
Tue Jun 28 06:51:15 PDT 2005
Markus Schaber wrote:
> Hi, Stephen,
> Stephen Woodbridge wrote:
>>>>the_geom && expand(setSRID(makepoint(-72.607912,
>>>[Meters per degree]
>>You are correct that degrees per meter increases, but we are concerned
>>with meters per degree in this example and being the inverse they
>>decrease. So by using the value at the equator, we over sample as we
>>move toward the poles which is ok, unless it creates a performance
>>problem in which case you will have to expand the bbox x and y as you
> AFAICS, you give an degree value 0.179664 to expand in your example, and
> this makes the bbox too narrow when going to the poles.
Oops, Right you are! This gets very confusing without a picture and
numbers to validate the model. So somewhere very near the pole 1 degree
of longitude == 1 meter and closer to the pole you need multiple degrees
of longitude and at the pole it is a divide by zero and at the equator
you need some fraction of a degree (0.179664) to equal a meter.
So like I said, user be aware of the limitations.
It might be nice to have a function or three that deals with these issues.
More information about the postgis-users