Hello! Tell me please, where do I make a mistake? There are coordinates enter image description here

And there is a request

SELECT ST_Y(coord_point) as lat, ST_X(coord_point) as lng FROM `customer` WHERE ST_Contains(ST_GEOMFROMTEXT('POLYGON((54.17489482345622 26.503829956054688, 54.375358319198526 26.503829956054688, 54.375358319198526 27.286605834960938, 54.17489482345622 27.286605834960938, 54.17489482345622 26.503829956054688))'), coord_point);

It seems that the polygon is "closed" and all the points are in it, but they are not displayed. I would be grateful if you tell me where to dig ...

  • That's how you imagine that we will find a mistake without your DBMS? Try it. Try to get the dots into a square - and then into a more complex shape. Display your figure there in autocade, maple or Korela. - nick_n_a
  • If it is not difficult to bring a piece of the customer table so that you can reproduce the situation. - cheops
  • image.prntscr.com/image/a538d433b486429bb1e0bcf7ae074f1c.png - RSalnikov

1 answer 1

The issue is decided. It was necessary to change all the coordinates in places. Here I am a muddle ...