Spatially Enabling Line Data

Dbms2sde command line:
dbms2sde -o line -l hur_tbsl -stable hurtracka -ftable hurtrackb -fkey a_id -oflds id -G 4326 -key id -load -buffer -type B ...

 hur_tbsl
 ID NAME   SHAPE
--- ------ -----
  1 DOREEN     1
  2 NAOMI      2
  3 PAUL       3
  4 LIDIA      4
hurtrackb
 ID A_ID LATITUDE LONGITUDE
--- ---- -------- ---------
  1    1     13.9    -104.0
  2    1     14.0    -104.6
  3    1     14.3    -105.2
  4    1     14.7    -105.7
  5    1     15.1    -106.1
  6    1     15.6    -106.5
  7    1     16.1    -106.8
...    .      ...       ...
 21    2     12.1     -99.0
 22    2     12.5    -100.5
 23    2     13.0    -101.6
 24    2     13.5    -102.5
 25    2     14.0    -103.4
 26    2     14.5    -104.3
 27    2     15.1    -105.2
...    .      ...       ...
Figure 2: Hurricane Tracklines (left) Plotted From Spatially Enabled Table—and Joined Table (right)

Unlike the previous (and following) example, the vertices that will define the shape feature are in a second business table (e.g., hurtrackb) that is related to the table being spatially enabled (e.g., hurtracka). It is necessary to have a join column between these two tables (e.g., hurtracka.id and hurtrackb.a_id), as well as an “order by” column in the second table (e.g., hurtrackb.id) so that dbms2sde can create each line feature from the appropriate points in the proper order.

<-- PreviousNext -->
dbms2sde.sourceforge.net2002-10-17