Spatially Enabling Rectangle Data

Dbms2sde command line:
dbms2sde -o quad -l hur_tbsa -stable hurboxes -coords "minx=min_lon, miny=min_lat, maxx=max_lon, maxy=max_lat" -G 4326 -key id -load -buffer -type B ...

	hur_tbsa
	ID NAME MIN_LAT MAX_LAT MIN_LON MAX_LON SHAPE --- ------ ------- ------- ------- ------- ----- 1 DOREEN 13.9 28.0 -109.3 -104.0 1 2 NAOMI 12.1 28.5 -107.7 -99.0 2 3 PAUL 14.1 26.0 -109.5 -100.5 3 4 LIDIA 12.5 20.4 -118.4 -102.6 4
Figure 3: Bounding Rectangles of Hurricane Tracklines (left) Plotted From Spatially Enabled Table (right)

The dbms2sde -coords parameters minx, miny, maxx, maxy can be any valid SQL (single-row—not group-value, e.g., tan—but not avg) expression, e.g., minx = longitude + ln(my_column). (Also see next example...)