◀ Back to Playground Home
Indicates how many points fit within the polygon
select ST_Within(
toGeometry(bytes_field),
ST_GeomFromText(
'POLYGON((-19.511718750000004 56.9449741808516,-20.917968749999996 41.112468789180895,-10.722656250000007 34.01624188966704,31.113281249999986 34.597041516144174,43.417968749999986 39.77476948529545,39.550781249999986 50.736455137010665,0.1757812499999952 62.02152819100766,-19.511718750000004 56.9449741808516))')) AS withinPolygon,
count(*)
from users
group by withinPolygon
ORDER BY withinPolygon DESC