neotoma
.ndb
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sites_update_bbox_fn()
Parameters
Name
Type
Mode
IN
Definition
DECLARE currGeom public.geometry; BEGIN --no need to check for point or polygon currGeom := ST_GeomFromText(ST_AsText(NEW.geog)); NEW.latitudenorth := ST_YMax(currGeom); NEW.latitudesouth := ST_YMin(currGeom); NEW.longitudeeast := ST_XMax(currGeom); NEW.longitudewest := ST_XMin(currGeom); RETURN NEW; END