I am just taking the first steps in using POSTGIS, but having trouble finding a simple example.
I have a database with a Key field, lat and lon fields and a GEOGRAPHY field.
I just want to have a query that gives me all of the Key fields with 100 miles of the following Lat/Lon 52.474702, -132.373041.
A pseudo query would be something like
select Key from GIS where GEOM is within 100 miles of 52.474702, -132.373041