GitLab

2.3.16

Лев Лимин

@lev_limin

e180eec1 · Merge branch 'develop' · Dec 17, 2024

Добавлено условие для пересечений геометрий

$payload = ["where" => ["spec" => "ST_Intersects", "geo" => ["POLYGON((42.22158105429307 55.257661403182276, 42.22185541410531 55.257488235540436, 42.22138926927481 55.257247009690005, 42.221114751818426 55.25742017715623, 42.22158105429307 55.257661403182276))", 4326]]];

или

$payload = ["where" => ["spec" => "ST_Intersects", ["geo" => ["POLYGON((42.22158105429307 55.257661403182276, 42.22185541410531 55.257488235540436, 42.22138926927481 55.257247009690005, 42.221114751818426 55.25742017715623, 42.22158105429307 55.257661403182276))", 4326]]]];

результат

SELECT * WHERE ST_Intersects(geo, ST_GeomFromText('POLYGON((42.22158105429307 55.257661403182276, 42.22185541410531 55.257488235540436, 42.22138926927481 55.257247009690005, 42.221114751818426 55.25742017715623, 42.22158105429307 55.257661403182276))', 4326)) = 1