{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

scan0094 - Geometry Examples The third triplet indicates...

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

View Full Document Right Arrow Icon
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Geometry Examples The third triplet indicates that the second subelement line string is made up of a circular arc with ordinates starting at offset 5. The end point of this line string is determined by the starting offset of the next element or the current length of the SD070RDINATES array, if this is the last element. I SDO_ORDINATES = (6,10, 10,1, 14,10, 10,14, 6,10). Example 2—7 shows a SQL statement that inserts the geometry illustrated in Figure 2—5 into the database. Example 2—7 SOL Statement to Insert 8 Compound Polygon INSERT INTO cola_marke:s VALUES( 12, 'compound_polygon’ , SDO_GEOMETRY [ 2003, —» two—dimensional polygon NULL, NULL, SDO_ELEM_1NFO_ARRAY[1,1005,2, 1,2,1, 5,2,2), —— compound polygon SDO_ORDINATE_ARRAY(6,l0, 10,1, 14,10, 10,14, 6.10) 2.5.5 Point Figure 2—6 illustrates a point-only geometry at coordinates (12,14). Figure 2—6 Point-Only Geometry dddddd HNOtLOIOQO. 581800 '8 5 In the SDO_GEOMETRY definition of the geometry illustrated in Figure 2—6: I SDO_GTYI’E = 2001. The 2 indicates two-dimensional, and the 1 indicates a single point. - SDO_SRID : NULL. 2-20 Oracle Spatial User's Guide and Reference ...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online