F
F
furyon2016-04-06 18:48:53
PostgreSQL
furyon, 2016-04-06 18:48:53

How to implement circle occurrence check in PostgreSQL?

Hello!
There is PostgreSQL 9.4, there is a table with a Circle type column. It has circles where xy is geographic coordinates.
It is necessary to find all lines where the point will be included in this Circle.
Everything is extremely simple, but I can’t figure out how to set the radius for Circle if I initially have it in meters.
Googled, everywhere there are examples on Postgis with powerful solutions that take into account the curvature of the earth, etc. My radii will be within a few kilometers, so I don’t need such power, I’d like to solve everything with out-of-the-box tools without installing plugins.
Please let me know,
thanks in advance!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Stanislav Makarov, 2016-04-06
@furyon

www.postgresql.org/docs/9.1/static/functions-geome...
Operator: @>
Description: Contains?
Example: circle '((0,0),2)' @> point '(1,1)'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question