maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
cc_get_current_fence(integer, double precision, double precision)
Parameters
Name
Type
Mode
p_idvehicle
integer
IN
p_longitud
double precision
IN
p_latitud
double precision
IN
Definition
SELECT gr.idgeoreference, gr.idclient, gr.idgeocategory, gr.alias, gr.createbyuser, gr.creationdate, gr.lastmodifiedbyuser, gr.lastmodificationdate,gr.originatingsystem, gr.enabled, gr.aef_id,gr.georeferencetype FROM geofence gf, georeference gr WHERE gf.idgeoreference = gr.idgeoreference and st_intersects(st_setsrid(st_point(p_longitud,p_latitud),4326),gf.geom);