Changes between Version 13 and Version 14 of PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/document
- Timestamp:
- Jul 12, 2012, 10:55:13 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/document
v13 v14 37 37 38 38 {{{ 39 #! sql39 #!c 40 40 raster ST_Union(raster ST_AsRaster(source_geom, list of parameters for raster specifications)) 41 41 }}} … … 43 43 The Euclidean distance from each pixel to its nearest source pixel can then be computed using ST_MapAlgebra. 44 44 45 CREATE FUNCTION euclidean_fct(pos1 integer[], pos2 integer[]) 45 {{{ 46 #! 47 sql 48 CREATE FUNCTION euclidean_fct(pos1 integer[], pos2 integer[]) 46 49 RETURNS float 47 50 AS $$ … … 56 59 SELECT rid, ST_MapAlgebraFct(rast, 'euclidean_fct(position of computed pixel, position of source point pixel)'::regprocedure) rast 57 60 FROM myexistingcoveragetable 61 }}} 58 62 59 63 Remarks:
