Spatially Enabling Quadrilateral Data
Dbms2sde command line:
dbms2sde -o quad -l hur_tbsa -stable hurtrackb -coords "ll_x=longitude, ll_y=latitude-0.3, ul_x=longitude-0.3, ul_y=latitude, ur_x=longitude+0.3, ur_y=latitude+0.6, lr_x=longitude+0.3, lr_y=latitude" ...
| | hur_tbsa |
|---|
| ID LATITUDE LONGITUDE SHAPE
--- -------- --------- -----
1 13.9 -104.0 1
2 14.0 -104.6 2
3 14.3 -105.2 3
4 14.7 -105.7 4
5 15.1 -106.1 5
6 15.6 -106.5 6
7 16.1 -106.8 7
8 16.8 -106.9 8
9 17.5 -107.0 9
10 18.4 -107.1 10
11 19.2 -107.3 11
12 20.2 -108.0 12
13 21.1 -109.0 13
14 22.8 -109.3 14
15 24.6 -108.8 15
16 26.5 -107.6 16
17 28.0 -106.0 17
21 12.1 -99.0 18
22 12.5 -100.5 19
23 13.0 -101.6 20
24 13.5 -102.5 21
25 14.0 -103.4 22
26 14.5 -104.3 23
27 15.1 -105.2 24
... ... ... |
| Figure 1: Quadrilaterals of Hurricane Observations (left) Plotted From Spatially Enabled Table (right) |
As with the dbms2sde rectangle -coords parameters, ll_x, ll_y, ul_x, ... can be any valid
SQL (single-row—not group-value) expression.