Changes between Version 32 and Version 33 of PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/document
- Timestamp:
- Jul 15, 2012, 8:19:46 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/document
v32 v33 91 91 {{{ 92 92 Comments from Mentor: 93 Not really. If the raster HAS to be in the extent of the point coverage, as stated in the cons, it means it could not correspond to the arbitrary alignment/extent of an existing coverage. This is probably the main reason the third approach is preferable to the TIN one. 93 Not really. If the raster HAS to be in the extent of the point coverage, as stated in the cons, it means 94 it could not correspond to the arbitrary alignment/extent of an existing coverage. This is probably 95 the main reason the third approach is preferable to the TIN one. 94 96 }}} 95 97 … … 116 118 AS $$ 117 119 BEGIN 118 SELECT ST_Distance (ST_GeomFromText('POINT(columnx rowy)',ST_SRID(rast)), ST_Transform(sourcegeom, Find_SRID(dbschema,sourcetable,sourcegeomcolumn), ST_SRID(rast)) as eucliean_dist 120 SELECT ST_Distance (ST_GeomFromText('POINT(columnx rowy)',ST_SRID(rast)), 121 ST_Transform(sourcegeom, Find_SRID(dbschema,sourcetable,sourcegeomcolumn), ST_SRID(rast)) as eucliean_dist 119 122 FROM sourcetable 120 123 ORDER BY $1 <-> $2 … … 168 171 {{{ 169 172 #!sql 170 ST_EuclideanDistance(text dbschema, text sourcetable, text sourcegeomcolumn, double precision scalex, double precision scaley, double precision gridx, double precision gridy, text pixeltype, double precision nodataval=0, double precision skewx=0, double precision skewy=0) 173 ST_EuclideanDistance(text dbschema, text sourcetable, text sourcegeomcolumn, 174 double precision scalex, double precision scaley, 175 double precision gridx, double precision gridy, text pixeltype, 176 double precision nodataval=0, double precision skewx=0, double precision skewy=0) 171 177 }}} 172 178