Search by GPS coordinates, java?

Question

Java

Good afternoon. There is a database with GPS coordinates. How to do in JAVA search for suitable GPS coordinates included in the designated circle? I can not figure out how to implement this search. I would be grateful if you could point me to the right solution, preferably a small example. I need a search and output algorithm, without SQL queries

Answer 1

This is for postgria
https://stackoverflow.com/questions/29744816/postg...
For MSSQL, there is most likely an analogue for your database.
https://docs.microsoft.com/en-us/sql/t-sql/spatial...

DECLARE @ggeography;
DECLARE @h geography;
SET @g = geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326);
SET @h = geography::STGeomFromText('POINT(-122.34900 47.65100)', 4326);
SELECT @g.STDistance(@h);