Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table places(lat_lng point, place_name varchar(50));
- insert into places values (POINT(-126.4, 45.32), 'Food Bar');
- select *
- from places
- where lat_lng <-> POINT(-125.4, 46.32) < 1
- order by lat_lng <-> POINT(-125.4, 46.32)
- create table places(
- lat_lng geography(Point,4326),
- place_name varchar(50)
- );
- -- Two ways to make a geography point
- insert into places values (ST_MakePoint(-126.4, 45.32), 'Food Bar1');
- insert into places values ('POINT(-126.4 45.32)', 'Food Bar2');
- -- Spatial index
- create index places_lat_lng_idx on places using gist(lat_lng);
- select *, ST_Distance(lat_lng, ST_MakePoint(-126.4, 45.32)::geography)
- from places
- where ST_DWithin(lat_lng, ST_MakePoint(-126.4, 45.32)::geography, 1000)
- order by ST_Distance(lat_lng, ST_MakePoint(-126.4, 45.32)::geography);
Add Comment
Please, Sign In to add comment