pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Function: st_dwithin

 

 

Schema

public

 

Owner

postgres

 

Descriptions

args: gg1, gg2, distance_meters, use_spheroid - Returns true if the geometries are within the specified distance of one another. For geometry units are in those of spatial reference and For geography units are in meters and measurement is defaulted to use_spheroid=true (measure around spheroid), for faster check, use_spheroid=false to measure along sphere.

 

Options

Option

Value

Returns

boolean

Language

sql

Parameters

public.geography

public.geography

double precision

boolean

 

Definition

CREATE OR REPLACE FUNCTION public.st_dwithin (
 public.geography,
 public.geography,
 double precision,
 boolean
)
RETURNS boolean AS
$span$
SELECT
$1 && _ST_Expand($2,$3) AND $2 && _ST_Expand($1,$3) AND _ST_DWithin($1, $2, $3, $4)
$span$
LANGUAGE
'sql'
IMMUTABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST
100;

COMMENT ON FUNCTION public.st_dwithin(public.geography, public.geography, double precision, boolean)
IS 'args: gg1, gg2, distance_meters, use_spheroid - Returns true if the geometries are within the specified distance of one another. For geometry units are in those of spatial reference and For geography units are in meters and measurement is defaulted to use_spheroid=true (measure around spheroid), for faster check, use_spheroid=false to measure along sphere.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23
Previous topic Chapter index Next topic