[postgis-users] get points from pgis db with "resolution"?

[Johannes Frölich]

Hi,

i am not sure if i am right here, but i have a question:
i have points in a pgis db in a regular grid shape with lets say resolution 1m, 1000m x1000m, so 1.000.000 points. is there any way to recieve query these points in a certain area with a "resolution" - so like only return points within 2m to get a 2m resolution, and return only 500.000 points? i need something like that to then generate Terrain models with different LODs.

Thanks a lot!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230612/68d11211/attachment.htm>