Main menu:

Site search

Categories

Tags

intern

Oracle und SQL

Perl

Archive for 'PostgreSQL'

PostGIS: find the regions with the highest density

For my perl Module Geo::Heatmap you need to find a the maximum number of point per tile (or rather per bin). You may achieve this by parsing the the logs, or use the Power of PostGIS: To group geographically close points you may use the ST_GeoHash function: with geohash as ( select ST_GeoHash(geom::geometry, 5) st_geohash, […]