I am new to PostGIS and GeoData.
I need to find where the lightning has stroke by a period of time and kilometre radius based on a given location.
I have given lon/lat and my table is:
latitude numeric not null, longitude numeric not null, time timestamp(0), geom(point,4326)
I do not know how to use within or radius query. I basically need to find how many points (lightning i have in a radius of a given location(lon/lat).
I am using PostGreSQL 9.2 and PostGIS 2.0.