Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Square type buffer

sujnanSep 30 2009 — edited Oct 6 2009
Hi
How can I generate square or rectangular type buffer for linestring geometry (SDO_TYPE =2002) in Oracle Spatial? The SDO_GEOM.SDO_BUFFER function generates circular type buffer for input geometry.

For example

select SDO_GEOM.SDO_BUFFER(
SDO_GEOMETRY(2002, 32643, NULL,
SDO_ELEM_INFO_ARRAY(1,2,1),
SDO_ORDINATE_ARRAY(0,0, 14,0)), 5, 0.05) geom from dual

This query returns

SDO_GEOMETRY(2003, 32643, NULL, SDO_ELEM_INFO_ARRAY(1, 1005, 4, 1, 2, 2, 5, 2, 1, 7, 2, 2, 11, 2, 1), SDO_ORDINATE_ARRAY(0, 5, -5, 6.1230E-16, 0, -5, 14, -5, 19, -1.225E-15, 14, 5, 0, 5))

But I am expecting following geometry

SDO_GEOMETRY(2003, 32643, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(0, -5, 14, -5, 14, 5, 0, 5, 0, -5))



Please give me a suggestion.


Thanks,
Sujnan

Edited by: sujnan on Oct 1, 2009 5:24 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 3 2009
Added on Sep 30 2009
#database-key-features, #spatial
10 comments
2,434 views