Questions tagged [min]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
86 views

Using SELECT with minimal ST_Distance

With this query, I can find the distance. SELECT a.id_one, c.id_two, MIN(ST_Distance(c.the_geom,a.the_geom)) FROM layerone AS a JOIN layer2 c ON ST_Distance(c.the_geom,a.the_geom) < 2 GROUP BY 1,2 ...
-2
votes
1answer
143 views

PostGIS Clustering with MAX and MIN SUM Limit of Attribute

I have point data with number of peoples living in a house. wkt111,members SRID=4326;POINT(8.40771254932301 52.8935196103868),158 SRID=4326;POINT(8.35609033091261 52.8948388844689),122 SRID=4326;POINT(...