[postgis-users] Selecting geocoded postal codes within a given distance ( miles for example )

[Vinko Vrsalovic]

On Mon, Dec 16, 2002 at 02:06:32PM -0600, Hugh W. O'Brien wrote:
> I probably should have posted that I am a noob to not only using PostGIS 
> but also using a spatial engine in general.  So I am not familiar with 
> the terms UTM, state place. etc...  So, how would one go about 
> projecting their longitude/latitude data into UTM for example. Would 

To project the data you have the transform() PostGIS function.

> doing so convert my degrees long/lat to actual distance units such that 
> the standard bounding box example in the FAQ would be applicable?

Yes.

Remember that your data must have SRID's set to use the transform
function. More info in the archives (the topic was discussed not long
ago) and in the docs.
-- 
Vinko Vrsalovic <el[|- at -|]vinko.cl>
http://www.cprsig.cl