I'm trying to generate a list of GPS coordinates within 5 meters radius of a location. My latitude and longitude are stored as FLOAT, but after research, I have noticed that I need to work with GEORGRAPHY datatype? So what I'm doing is creating an additional column of that type, and then working with that. I have learned of a few functions (ST_Within, ST_SetSRID, etc). The problem I'm facing is that any function I use returns a 'function not recognized error'. Am I on the right track?
Any help you could provide would be greatly appreciated. My table is called 'gpstemp'. Fields are 'latitude', 'longitude', and gps (my created field of geography datatype).
Thank you so much.