How do I Check to See if a column is within latitiude/longitude coordinates?

Question

I have two columns latitude and longitude. I am trying to create boundaries such that only points within the boundary is returned. For example i have this static lat/long (40.6681, -73.9806).

There are latitude/longitude coordinates in my database which are not within that static coordinate, how do I only select those coordinates within 40.6681, -73.9806? Here is my query:

select houses from housing where borough = 'BROOKLYN' and latitude + longitude = st_within(40.6681, -73.9806);

The error message I see is:

Hint: No function matches the given name and argument types. You might need to add explicit type casts. Can someone guide me in the right direction?

Answer 1

You are not using the function properly. ST_WITHIN() takes two arguments both type geom.

For example:

ST_Within(geometry A, geometry B);

will return true if geometry A is completely inside geometry B.

You are going to want to try something like this:

select houses from housing where borough = 'BROOKLYN'
AND ST_WITHIN(ST_MakePoint(longitude, latitude), YOUR_BOUNDARY_GEOM);

see postgis docs