[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