[postgis-users] distance() Unit's

Adam adam at spatialsystems.org
Sun Jan 8 22:44:53 PST 2006


I'm finding all the cities within a certian distance using the DISTANCE 
function.

What is the unit of measurement for the distance?
Can it be set to miles or feet?

I checked the documentation but didn't find anything.

geo=# SELECT name FROM city_locations WHERE distance (the_geom, 
'POINT( -88.0501 41.8616 )' ) < 0.1;
       name
------------------ 
 Addison
 Glendale Heights
 Carol Stream
 Villa Park
 North Glen Ellyn
 Lombard
 Glen Ellyn
 York Center
 Wheaton
 Oakbrook Terrace
 Highland Hills
 Valley View
 Downers Grove
 Westmont
 Lisle
(15 rows)

geo=#




More information about the postgis-users mailing list