Changes between Version 32 and Version 33 of PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/document


Ignore:
Timestamp:
Jul 15, 2012, 8:19:46 PM (12 years ago)
Author:
qliu
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/document

    v32 v33  
    9191{{{
    9292Comments 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.
     93Not really. If the raster HAS to be in the extent of the point coverage, as stated in the cons, it means
     94it could not correspond to the arbitrary alignment/extent of an existing coverage. This is probably
     95the main reason the third approach is preferable to the TIN one.
    9496}}}
    9597
     
    116118AS $$
    117119BEGIN
    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)),
     121ST_Transform(sourcegeom, Find_SRID(dbschema,sourcetable,sourcegeomcolumn), ST_SRID(rast)) as eucliean_dist
    119122      FROM sourcetable
    120123      ORDER BY $1 <-> $2
     
    168171{{{
    169172#!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)
     173ST_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)
    171177}}}
    172178