Unformatted text preview: Geometry Examples Figure 2—4 Compound Line String (10.10) In the SDO_GEOMETRY definition of the geometry illustrated in Figure 2—4: I SDO_GTYPE = 2002. The first 2 indicates two—dimensional, and the second 2
indicates one or more line segments. I SDO_SRID : NULL.
I SDO_POINT = NULL. I SD07ELEM_INFO = (1,4,2, 1,2,1, 3,2,2). There are three triplet elements: 1,4,2,
1,2,1, and 3,2,2. The first triplet indicates that this element is a compound line string made up of
two subelement line strings, which are described with the next two triplets. The second triplet indicates that the line string is made up of straight line
segments and that the ordinates for this line string start at offset 1. The end point of this line string is determined by the starting offset of the second line string, 3 in
this instance. The third triplet indicates that the second line string is made up of circular arcs
with ordinates starting at offset 3. The end point of this line string is determined
by the starting offset of the next element or the current length of the SDO_
ORDINATES array, if this is the last element. I SDO_ORDINATES = (10,10, 10,14, 6,10, 14,10). Example 2—6 shows a SQL statement that inserts the geometry illustrated in Figure 2—4
into the database. Example 2—6 SQL Statement to Insert 5 Compound Llne String INSERT INTO cola_market s VALUES (
'compound_l ine_s tring' ,
2 0 0 2 .
NULL , 2-18 Oracle Spatial User’s Guide and Reference ...
View Full Document
- Spring '09