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, […]
Posted: December 8th, 2013 under Database, Perl, PostGIS.
Comments: none