maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_nearest_road(real, real)
Parameters
Name
Type
Mode
longitude
real
IN
latitude
real
IN
distance
real
OUT
descr
character varying
OUT
Definition
SELECT distance::real, street_name as descr FROM (select tipovial||' '||nomvial street_name,st_distance(st_setsrid(st_makepoint($1,$2),4326),st_closestpoint(geom,st_setsrid(st_makepoint( $1, $2),4326))) distance from geo.mexico_ejes_viales order by geom <-> st_setsrid(st_makepoint($1,$2),4326) limit 1) as q ;