[postgis-users] Get the bounding box?

Michael A. Peters mpeters at shastaherps.org
Tue Jul 20 20:46:38 PDT 2010


Yes, for plotting the maps in cartesian SVG I already do some of what it
looks like that does via php. I assume the earth is a perfect sphere and
calculate arc lengths where I need distance etc. - it looks like the
geography type may let me simplify my code even moreso.

> You might want to look into the GEOGRAPHY type
> http://postgis.refractions.net/docs/ch04.html#PostGIS_Geography to do
> this nicely.
>
> -Francis
>
> On 21 July 2010 12:57, Michael A. Peters <mpeters at shastaherps.org> wrote:
>> Thank you. It did work with one caveat, I assume because all my shape
>> data
>> is in WGS84 it added an equal number of specified decimal degrees to
>> each
>> side but that was cake to adjust post ST_Expand and it now does exactly
>> what I want it to do.
>>
>>> Hallo
>>> ST_Expand should do the trick.
>>> http://postgis.org/documentation/manual-1.5/ST_Expand.html
>>> /Nicklas
>>> 2010-07-20 Michael A. Peters  wrote:
>>>
>> *snip*
>>>>
>>>>I can't figure out how to get the bounding box for the intersection. It
>>>>would be nice to be able to simply ask for the bounding box + X
>>>> kilometers
>>>>in each direction if PostGIS can do that (I'm running 1.3.2 on CentOS -
>>>>that's stock EPEL build) but I can do the math outside of PostGIS if
>>>>necessary. I just can't figure out how to get the bounding box
>>>> returned.
>>
>> -----
>> Michael A. Peters
>>
>> http://www.shastaherps.org/
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-----
Michael A. Peters

http://www.shastaherps.org/



More information about the postgis-users mailing list