Opened 3 years ago

Last modified 5 weeks 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 3 years ago.
kde_function
execute_kde_fucntion_final.sql (1.5 KB) - added by jpk 3 years ago.
How to execute the KDE function

Download all attachments as: .zip

Change History (6)

Changed 3 years ago by jpk

Attachment: create_kde_function.sql added

kde_function

Changed 3 years ago by jpk

How to execute the KDE function

comment:1 Changed 3 years ago by robe

Component: postgisraster
Owner: changed from pramsey to dustymugs

comment:2 Changed 3 years ago by robe

Milestone: PostGIS Future

comment:3 Changed 3 years ago by robe

Type: taskpatch

comment:4 Changed 5 weeks ago by robe

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.