Opened 8 years ago

Last modified 5 years ago

#2894 new patch

Kernel density estimation with PostGIS raster

Reported by: jpk Owned by: Bborie Park
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 8 years ago.
kde_function
execute_kde_fucntion_final.sql (1.5 KB ) - added by jpk 8 years ago.
How to execute the KDE function

Download all attachments as: .zip

Change History (6)

by jpk, 8 years ago

Attachment: create_kde_function.sql added

kde_function

by jpk, 8 years ago

How to execute the KDE function

comment:1 by robe, 8 years ago

Component: postgisraster
Owner: changed from pramsey to Bborie Park

comment:2 by robe, 8 years ago

Milestone: PostGIS Future

comment:3 by robe, 8 years ago

Type: taskpatch

comment:4 by robe, 5 years ago

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.