{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

scan0091

# scan0091 - Geometry Examples Figure 2—4 Compound Line...

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

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 ( ll , 'compound_l ine_s tring' , SDO_GECMETRY f 2 0 0 2 . NULL , NULL , 2-18 Oracle Spatial User’s Guide and Reference ...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online