Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table places(id int generated by default as identity primary key, 
                    geo point);
insert into places(geo) values 
  (point(-84.3871,33.7485)),
  (point(33.7485,-84.3871)),--flipped existing point
  (point(37.64903402157866, -83.84765625000001)),--target coords
  (point(-83.84765625000001, 37.64903402157866))
returning *;

CREATE TABLE




id
geo


1
(-84.3871,33.7485)

2
(33.7485,-84.3871)

3
(37.64903402157866,-83.84765625000001)

4
(-83.84765625000001,37.64903402157866)



INSERT 0 4


create extension postgis;

CREATE EXTENSION


select
  count(*)
from
  places
where
  ST_DWithin(
    ST_GeomFromText(concat('POINT', geo::text), 4326),
    ST_GeomFromText('POINT(37.64903402157866, -83.84765625000001)', 4326),
    66 * 1609.34
  );

ERROR:  parse error - invalid geometry
HINT:  "POINT(37.64903402157866, -" <-- parse error at position 26 within geometry


select geo, geo::text, geo::geometry from places where geo is not null limit 10;


geo
geo
geo


(-84.3871,33.7485)
(-84.3871,33.7485)
01010000000612143FC61855C02B8716D9CEDF4040

(33.7485,-84.3871)
(33.7485,-84.3871)
01010000002B8716D9CEDF40400612143FC61855C0

(37.64903402157866,-83.84765625000001)
(37.64903402157866,-83.84765625000001)
0101000000FA55FC8B13D342400100000040F654C0

(-83.84765625000001,37.64903402157866)
(-83.84765625000001,37.64903402157866)
01010000000100000040F654C0FA55FC8B13D34240



SELECT 4


drop table places;

DROP TABLE


create table places(id int generated by default as identity primary key, 
                    geo point,
                    comment text);
insert into places values 
  (1,point(-84.3871,33.7485),'your existing point'),
  (2,point(33.7485,-84.3871),'flipped lat/lon of existing point'),
  (3,point(37.64903402157866, -83.84765625000001),'target coords'),
  (4,point(-83.84765625000001, 37.64903402157866),'flipped target coords')
returning *;

select
  count(*),array_agg(id::text||':'||comment)
from
  places
where
  ST_DWithin(
    geo::geometry::geography(Point,4326),
    ST_GeogFromText('SRID=4326;POINT(37.64903402157866 -83.84765625000001)'),
    66 * 1609.34, --66 miles
    true --measure over spheroid
  );

CREATE TABLE




id
geo
comment


1
(-84.3871,33.7485)
your existing point

2
(33.7485,-84.3871)
flipped lat/lon of existing point

3
(37.64903402157866,-83.84765625000001)
target coords

4
(-83.84765625000001,37.64903402157866)
flipped target coords



INSERT 0 4




count
array_agg


2
{"2:flipped lat/lon of existing point","3:target coords"}



SELECT 1


select 66 * 1609.34;


?column?


106216.44



SELECT 1

id	geo
1	(-84.3871,33.7485)
2	(33.7485,-84.3871)
3	(37.64903402157866,-83.84765625000001)
4	(-83.84765625000001,37.64903402157866)

geo	geo	geo
(-84.3871,33.7485)	(-84.3871,33.7485)	01010000000612143FC61855C02B8716D9CEDF4040
(33.7485,-84.3871)	(33.7485,-84.3871)	01010000002B8716D9CEDF40400612143FC61855C0
(37.64903402157866,-83.84765625000001)	(37.64903402157866,-83.84765625000001)	0101000000FA55FC8B13D342400100000040F654C0
(-83.84765625000001,37.64903402157866)	(-83.84765625000001,37.64903402157866)	01010000000100000040F654C0FA55FC8B13D34240

id	geo	comment
1	(-84.3871,33.7485)	your existing point
2	(33.7485,-84.3871)	flipped lat/lon of existing point
3	(37.64903402157866,-83.84765625000001)	target coords
4	(-83.84765625000001,37.64903402157866)	flipped target coords