maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_geofence_set_zoom()
Parameters
Name
Type
Mode
Definition
DECLARE _area float; _zoom_factor int; BEGIN _area := st_area(NEW.geom::geography); IF _area > 10000000 THEN _zoom_factor := 9; ELSIF _area BETWEEN 33000 AND 10000000 THEN _zoom_factor := 10; ELSIF _area BETWEEN 32700 AND 33000 THEN _zoom_factor := 11; ELSIF _area BETWEEN 32000 AND 32700 THEN _zoom_factor := 12; ELSIF _area < 32000 THEN _zoom_factor := 13; END IF; NEW.zoom_factor := _zoom_factor; NEW.area := _area; RETURN NEW; END;