Opened 10 years ago

Last modified 7 years ago

#2894 new patch

Kernel density estimation with PostGIS raster

Reported by: jpk Owned by: dustymugs
Priority: medium Milestone: PostGIS Fund Me
Component: raster Version: 2.1.x
Keywords: kernel density estimation, heat map, raster Cc:

Description

Hi everyone,

I was looking for a PostGIS function to create a raster resulting from a kernel density estimation (or heat map). I did not find it so I created it myself in plpgsql. For the moment, it uses a quartic function (same than ArcGIS spatial analyst) but it is possible to implement the other ones (triangular, gaussian, etc). Here is the function and a example of execution. Feel free to use it and improve it.

Attachments (2)

create_kde_function.sql​ (2.1 KB ) - added by jpk 10 years ago.
kde_function
execute_kde_fucntion_final.sql​ (1.5 KB ) - added by jpk 10 years ago.
How to execute the KDE function

Download all attachments as: .zip

Change History (6)

by jpk, 10 years ago

Attachment: create_kde_function.sql​ added

kde_function

by jpk, 10 years ago

Attachment: execute_kde_fucntion_final.sql​ added

How to execute the KDE function

comment:1 by robe, 10 years ago

Component: postgis → raster
Owner: changed from pramsey to dustymugs

comment:2 by robe, 10 years ago

Milestone: → PostGIS Future

comment:3 by robe, 10 years ago

Type: task → patch

comment:4 by robe, 7 years ago

Milestone: PostGIS Future → PostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.